Home » SQL & PL/SQL » SQL & PL/SQL » Package transfer from one to other oracle database (Oracle database 12.2 on Oracle Linux 7)
Package transfer from one to other oracle database [message #676020] |
Tue, 07 May 2019 10:00 |
|
armait
Messages: 14 Registered: April 2019
|
Junior Member |
|
|
Hello, i have oriblem with transfering package from one to other oracle database.Actually, a have to get package from one database and put into my database,compile and validate transfered package.From SQL Developer I use tools-database copy-objects and I check onlz package.In my destination database I have transfered package but i cant compile him.Please help me to tolve this problem.Thank you.
|
|
|
|
|
|
|
|
|
|
|
|
Re: Package transfer from one to other oracle database [message #676038 is a reply to message #676035] |
Wed, 08 May 2019 05:18 |
cookiemonster
Messages: 13943 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Actually looking at the errors sorder is probably a table not a user.
You should know where the table lives, you should be able to check if your schema has access to it.
If it's in a different schema to the one you're putting the package in and the package code doesn't specify the schema name of the tables then you'll need synonyms.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Package transfer from one to other oracle database [message #676055 is a reply to message #676054] |
Wed, 08 May 2019 08:37 |
|
armait
Messages: 14 Registered: April 2019
|
Junior Member |
|
|
Error starting at line : 5 in command -
CREATE OR REPLACE PACKAGE "CUPROD"."UOMORDER"
AS
TYPE sorderrec IS RECORD (
ordnum sorder.ordnum%TYPE,
orderdate sorder.orderdate%TYPE,
ordertype_code sorder.ordertype_code%TYPE,
doctype_code sorder.doctype_code%TYPE,
cacustomer_id sorder.cacustomer_id%TYPE,
bacustomer_id sorder.bacustomer_id%TYPE,
sacustomer_id sorder.sacustomer_id%TYPE,
acontact_id sorder.acontact_id%TYPE,
ocontact1_id sorder.ocontact1_id%TYPE,
ccontact2_id sorder.ccontact2_id%TYPE,
expecteddate sorder.expecteddate%TYPE,
refdate sorder.refdate%TYPE,
refnumber sorder.refnumber%TYPE,
reftype_code sorder.reftype_code%TYPE,
refdate1 sorder.refdate1%TYPE,
refnumber1 sorder.refnumber1%TYPE,
reftype1_code sorder.reftype1_code%TYPE,
orderrank_code sorder.orderrank_code%TYPE,
saleslocation_id sorder.saleslocation_id%TYPE,
salesslocation_id sorder.salesslocation_id%TYPE,
mainlocation_id sorder.mainlocation_id%TYPE,
saleschanneltype_code sorder.saleschanneltype_code%TYPE,
ptechnology_code sorder.ptechnology_code%TYPE,
reason_code sorder.reason_code%TYPE,
headordnum sorder.headordnum%TYPE,
status sorder.status%TYPE,
printlog sorder.printlog%TYPE,
note sorder.note%TYPE,
comments sorder.comments%TYPE,
description sorder.description%TYPE,
created sorder.created%TYPE,
created_by sorder.created_by%TYPE,
modified sorder.modified%TYPE,
modified_by sorder.modified_by%TYPE
);
TYPE productofferrec IS RECORD (
ID productoffer.ID%TYPE,
NAME productoffer.NAME%TYPE,
shortname productoffer.shortname%TYPE,
displayname productoffer.displayname%TYPE,
docname productoffer.docname%TYPE,
pname productoffer.pname%TYPE,
validfrom productoffer.validfrom%TYPE,
validto productoffer.validto%TYPE,
ppspecification_id productoffer.ppspecification_id%TYPE,
package_ind productoffer.package_ind%TYPE,
complex_ind productoffer.complex_ind%TYPE,
bundle_ind productoffer.bundle_ind%TYPE,
pobundlemethod_code productoffer.pobundlemethod_code%TYPE,
crossoffer_ind productoffer.crossoffer_ind%TYPE,
procurable_ind productoffer.procurable_ind%TYPE,
eventsource_ind productoffer.eventsource_ind%TYPE,
cnttype_code productoffer.cnttype_code%TYPE,
lowerlimit productoffer.lowerlimit%TYPE,
upperlimit productoffer.upperlimit%TYPE,
status productoffer.status%TYPE,
description productoffer.description%TYPE,
created productoffer.created%TYPE,
created_by productoffer.created_by%TYPE,
modified productoffer.modified%TYPE,
modified_by productoffer.modified_by%TYPE
);
TYPE sorderitemrec IS RECORD (
orditemnum sorderitem.orditemnum%TYPE,
ordnum sorderitem.ordnum%TYPE,
seqno sorderitem.seqno%TYPE,
orderdate sorderitem.orderdate%TYPE,
ordertype_code sorderitem.ordertype_code%TYPE,
cacustomer_id sorderitem.cacustomer_id%TYPE,
bacustomer_id sorderitem.bacustomer_id%TYPE,
sacustomer_id sorderitem.sacustomer_id%TYPE,
eventsource_id sorderitem.eventsource_id%TYPE,
eventsourcedet_id sorderitem.eventsourcedet_id%TYPE,
cproductoffer_id sorderitem.cproductoffer_id%TYPE,
custexist_ind sorderitem.custexist_ind%TYPE,
saleslocation_id sorderitem.saleslocation_id%TYPE,
salesslocation_id sorderitem.salesslocation_id%TYPE,
mainlocation_id sorderitem.mainlocation_id%TYPE,
servicelocation_id sorderitem.servicelocation_id%TYPE,
pmarketarea_code sorderitem.pmarketarea_code%TYPE,
pfamily_code sorderitem.pfamily_code%TYPE,
ptechnology_code sorderitem.ptechnology_code%TYPE,
pclass_code sorderitem.pclass_code%TYPE,
psalescategory_code sorderitem.psalescategory_code%TYPE,
pproductoffer_id sorderitem.pproductoffer_id%TYPE,
action_code sorderitem.action_code%TYPE,
ad_ind sorderitem.ad_ind%TYPE,
quantity sorderitem.quantity%TYPE,
qtyunit_code sorderitem.qtyunit_code%TYPE,
temporary_ind sorderitem.temporary_ind%TYPE,
tempdatefrom sorderitem.tempdatefrom%TYPE,
tempdateto sorderitem.tempdateto%TYPE,
tempdaysno sorderitem.tempdaysno%TYPE,
billable_ind sorderitem.billable_ind%TYPE,
eventsource_ind sorderitem.eventsource_ind%TYPE,
expecteddate sorderitem.expecteddate%TYPE,
deadlinedate sorderitem.deadlinedate%TYPE,
executiondate sorderitem.executiondate%TYPE,
reason_code sorderitem.reason_code%TYPE,
headorditemnum sorderitem.headorditemnum%TYPE,
status sorderitem.status%TYPE,
note sorderitem.note%TYPE,
comments sorderitem.comments%TYPE,
description sorderitem.description%TYPE,
created sorderitem.created%TYPE,
created_by sorderitem.created_by%TYPE,
modified sorderitem.modified%TYPE,
modified_by sorderitem.modified_by%TYPE
);
TYPE productpricerec IS RECORD (
ID productprice.ID%TYPE,
validfrom productprice.validfrom%TYPE,
validto productprice.validto%TYPE,
product_id productprice.product_id%TYPE,
productprice_id productprice.productprice_id%TYPE,
productpricevalidfrom productprice.productpricevalidfrom%TYPE,
NAME productprice.NAME%TYPE,
shortname productprice.shortname%TYPE,
displayname productprice.displayname%TYPE,
docname productprice.docname%TYPE,
price productprice.price%TYPE,
installmentprice productprice.installmentprice%TYPE,
currency_code productprice.currency_code%TYPE,
qtyunit_code productprice.qtyunit_code%TYPE,
pfrom productprice.pfrom%TYPE,
pto productprice.pto%TYPE,
pqtyunit_code productprice.pqtyunit_code%TYPE,
ptreatment_code productprice.ptreatment_code%TYPE,
pricestype_code productprice.pricestype_code%TYPE,
prorate_ind productprice.prorate_ind%TYPE,
chargeevent_code productprice.chargeevent_code%TYPE,
chargingfrequency_code productprice.chargingfrequency_code%TYPE,
complex_ind productprice.complex_ind%TYPE,
childrelationshiptype_code productprice.childrelationshiptype_code%TYPE,
prpolicy_code productprice.prpolicy_code%TYPE,
treatment_code productprice.treatment_code%TYPE,
dvalue productprice.dvalue%TYPE,
dqtyunit_code productprice.dqtyunit_code%TYPE,
dvaluefrom productprice.dvaluefrom%TYPE,
dvalueto productprice.dvalueto%TYPE,
dvalueqtyunit_code productprice.dvalueqtyunit_code%TYPE,
filter_rule_ind productprice.filter_rule_ind%TYPE,
filter_id productprice.filter_id%TYPE,
priority productprice.priority%TYPE,
tax_ind productprice.tax_ind%TYPE,
taxtype_code productprice.taxtype_code%TYPE,
taxtreatment_code productprice.taxtreatment_code%TYPE,
qtyclass_code productprice.qtyclass_code%TYPE,
revenuecode_id productprice.revenuecode_id%TYPE,
proratercode_id productprice.proratercode_id%TYPE,
terminationcode_id productprice.terminationcode_id%TYPE,
refundrcode_id productprice.refundrcode_id%TYPE,
ronterminate productprice.ronterminate%TYPE,
rondisconn productprice.rondisconn%TYPE,
ronreconn productprice.ronreconn%TYPE,
pltermination_id productprice.pltermination_id%TYPE,
pldisconn_id productprice.pldisconn_id%TYPE,
plreconn_id productprice.plreconn_id%TYPE,
commitment_ind productprice.commitment_ind%TYPE,
commitmentvalue productprice.commitmentvalue%TYPE,
commitmentunit productprice.commitmentunit%TYPE,
installment_ind productprice.installment_ind%TYPE,
installmentvalue productprice.installmentvalue%TYPE,
installmentunit productprice.installmentunit%TYPE,
status productprice.status%TYPE,
description productprice.description%TYPE,
created productprice.created%TYPE,
created_by productprice.created_by%TYPE,
modified productprice.modified%TYPE,
modified_by productprice.modified_by%TYPE
);
TYPE speccharrec IS RECORD (
code ppspeccharacteristic.code%TYPE,
NAME ppspeccharacteristic.NAME%TYPE,
shortname ppspeccharacteristic.shortname%TYPE,
displayname ppspeccharacteristic.displayname%TYPE,
docname ppspeccharacteristic.docname%TYPE,
validfrom ppspeccharacteristic.validfrom%TYPE,
validto ppspeccharacteristic.validto%TYPE,
keyword ppspeccharacteristic.keyword%TYPE,
valuetype_code ppspeccharacteristic.valuetype_code%TYPE,
formula ppspeccharacteristic.formula%TYPE,
entrytype_code ppspeccharacteristic.entrytype_code%TYPE,
configurable_ind ppspeccharacteristic.configurable_ind%TYPE,
presence_ind ppspeccharacteristic.presence_ind%TYPE,
purpose_code ppspeccharacteristic.purpose_code%TYPE,
actiontype_code ppspeccharacteristic.actiontype_code%TYPE,
ddriven_code ppspeccharacteristic.ddriven_code%TYPE,
eventsource_ind ppspeccharacteristic.eventsource_ind%TYPE,
complex_ind ppspeccharacteristic.complex_ind%TYPE,
dbtarget ppspeccharacteristic.dbtarget%TYPE,
dblookup ppspeccharacteristic.dblookup%TYPE,
dbreftype ppspeccharacteristic.dbreftype%TYPE,
status ppspeccharacteristic.status%TYPE,
description ppspeccharacteristic.description%TYPE,
created ppspeccharacteristic.created%TYPE,
created_by ppspeccharacteristic.created_by%TYPE,
modified ppspeccharacteristic.modified%TYPE,
modified_by ppspeccharacteristic.modified_by%TYPE
);
TYPE specchartab IS TABLE OF speccharrec
INDEX BY BINARY_INTEGER;
TYPE cproductofferrec IS RECORD (
ID cproductoffer.ID%TYPE,
ordnum cproductoffer.ordnum%TYPE,
orditemnum cproductoffer.orditemnum%TYPE,
cacustomer_id cproductoffer.cacustomer_id%TYPE,
bacustomer_id cproductoffer.bacustomer_id%TYPE,
sacustomer_id cproductoffer.sacustomer_id%TYPE,
action_code cproductoffer.action_code%TYPE,
billable_ind cproductoffer.billable_ind%TYPE,
pproductoffer_id cproductoffer.pproductoffer_id%TYPE,
pproduct_id cproductoffer.pproduct_id%TYPE,
productname cproductoffer.productname%TYPE,
temporary_ind cproductoffer.temporary_ind%TYPE,
orderdate cproductoffer.orderdate%TYPE,
initialdate cproductoffer.initialdate%TYPE,
enddate cproductoffer.enddate%TYPE,
modifydate cproductoffer.modifydate%TYPE,
suspenddate cproductoffer.suspenddate%TYPE,
expecteddate cproductoffer.expecteddate%TYPE,
resumedate cproductoffer.resumedate%TYPE,
terminationdate cproductoffer.terminationdate%TYPE,
tempdaysno cproductoffer.tempdaysno%TYPE,
quantity cproductoffer.quantity%TYPE,
qtyunit_code cproductoffer.qtyunit_code%TYPE,
itemamount cproductoffer.itemamount%TYPE,
discountamount cproductoffer.discountamount%TYPE,
discountpercent cproductoffer.discountpercent%TYPE,
extendedprice cproductoffer.extendedprice%TYPE,
overrideprice cproductoffer.overrideprice%TYPE,
overridereason cproductoffer.overridereason%TYPE,
installmentamount cproductoffer.installmentamount%TYPE,
netdiscountpercent cproductoffer.netdiscountpercent%TYPE,
nondiscountedlinetotal cproductoffer.nondiscountedlinetotal%TYPE,
cproductoffer_id cproductoffer.cproductoffer_id%TYPE,
eventsource_ind cproductoffer.eventsource_ind%TYPE,
origineventsource_id cproductoffer.origineventsource_id%TYPE,
commitment_ind cproductoffer.commitment_ind%TYPE,
commitmentvalue cproductoffer.commitmentvalue%TYPE,
commitmentunit cproductoffer.commitmentunit%TYPE,
installment_ind cproductoffer.installment_ind%TYPE,
installmentvalue cproductoffer.installmentvalue%TYPE,
installmentunit cproductoffer.installmentunit%TYPE,
status cproductoffer.status%TYPE,
reason_code cproductoffer.reason_code%TYPE,
deactivationreason cproductoffer.deactivationreason%TYPE,
note cproductoffer.note%TYPE,
comments cproductoffer.comments%TYPE,
description cproductoffer.description%TYPE,
created cproductoffer.created%TYPE,
created_by cproductoffer.created_by%TYPE,
modified cproductoffer.modified%TYPE,
modified_by cproductoffer.modified_by%TYPE
);
FUNCTION fget_version
RETURN VARCHAR2;
PROCEDURE psordercreate (
p_orderdate sorder.orderdate%TYPE,
p_ordertype_code sorder.ordertype_code%TYPE,
p_cacustomer_id sorder.cacustomer_id%TYPE,
p_bacustomer_id sorder.bacustomer_id%TYPE,
p_sacustomer_id sorder.sacustomer_id%TYPE,
p_acontact_id sorder.acontact_id%TYPE,
p_ocontact1_id sorder.ocontact1_id%TYPE,
p_ccontact2_id sorder.ccontact2_id%TYPE,
p_expecteddate sorder.expecteddate%TYPE,
p_refdate sorder.refdate%TYPE,
p_refnumber sorder.refnumber%TYPE,
p_refdate1 sorder.refdate1%TYPE,
p_refnumber1 sorder.refnumber1%TYPE,
p_saleslocation_id sorder.saleslocation_id%TYPE,
p_salesslocation_id sorder.salesslocation_id%TYPE,
p_saleschanneltype_code sorder.saleschanneltype_code%TYPE,
p_description sorder.description%TYPE,
p_created sorder.created%TYPE,
p_created_by sorder.created_by%TYPE,
p_reason_code IN sorder.reason_code%TYPE,
p_doctype_code sorder.doctype_code%TYPE,
p_headordnum IN OUT sorder.ordnum%TYPE,
p_ordnum IN OUT sorder.ordnum%TYPE
);
PROCEDURE psorderitemcreate (
p_headordnum IN sorder.headordnum%TYPE,
p_ordnum IN sorderitem.ordnum%TYPE,
p_oldordnum IN sorderitem.ordnum%TYPE,
p_sacustomer_id IN sorderitem.sacustomer_id%TYPE,
p_adress1_id IN caddress.ID%TYPE,
p_adress2_id IN caddress.ID%TYPE,
p_eventsource_id IN sorderitem.eventsource_id%TYPE,
p_eventsourcedet_id IN sorderitem.eventsourcedet_id%TYPE,
p_cproductoffer_id IN sorderitem.cproductoffer_id%TYPE,
p_pclass_code IN sorderitem.pclass_code%TYPE,
p_psalescategory_code IN sorderitem.psalescategory_code%TYPE,
p_pproductoffer_id IN sorderitem.pproductoffer_id%TYPE,
p_action_code IN sorderitem.action_code%TYPE,
p_ad_ind IN sorderitem.ad_ind%TYPE,
p_quantity IN sorderitem.quantity%TYPE,
p_qtyunit_code IN sorderitem.qtyunit_code%TYPE, ---??????
p_temporary_ind IN sorderitem.temporary_ind%TYPE,
p_tempdatefrom IN sorderitem.tempdatefrom%TYPE,
p_tempdateto IN sorderitem.tempdateto%TYPE,
p_tempdaysno IN sorderitem.tempdaysno%TYPE,
p_billable_ind IN sorderitem.billable_ind%TYPE,
p_custexist_ind IN sorderitem.custexist_ind%TYPE,
p_expecteddate IN sorderitem.expecteddate%TYPE,
p_headorditemnum IN sorderitem.headorditemnum%TYPE,
p_description IN sorderitem.description%TYPE,
p_created IN sorderitem.created%TYPE,
p_created_by IN sorderitem.created_by%TYPE,
p_technology_code IN sorderitem.ptechnology_code%TYPE,
p_mainlocation_id IN sorderitem.mainlocation_id%TYPE,
p_orditemnum OUT sorderitem.orditemnum%TYPE
);
PROCEDURE psordercreate (
p_orderdate sorder.orderdate%TYPE,
p_ordertype_code sorder.ordertype_code%TYPE,
p_cacustomer_id sorder.cacustomer_id%TYPE,
p_bacustomer_id sorder.bacustomer_id%TYPE,
p_sacustomer_id sorder.sacustomer_id%TYPE,
p_acontact_id sorder.acontact_id%TYPE,
p_ocontact1_id sorder.ocontact1_id%TYPE,
p_ccontact2_id sorder.ccontact2_id%TYPE,
p_expecteddate sorder.expecteddate%TYPE,
p_refdate sorder.refdate%TYPE,
p_refnumber sorder.refnumber%TYPE,
p_refdate1 sorder.refdate1%TYPE,
p_refnumber1 sorder.refnumber1%TYPE,
p_saleslocation_id sorder.saleslocation_id%TYPE,
p_salesslocation_id sorder.salesslocation_id%TYPE,
p_saleschanneltype_code sorder.saleschanneltype_code%TYPE,
p_description sorder.description%TYPE,
p_created sorder.created%TYPE,
p_created_by sorder.created_by%TYPE,
p_reason_code IN sorder.reason_code%TYPE,
p_headordnum IN OUT sorder.ordnum%TYPE,
p_ordnum IN OUT sorder.ordnum%TYPE
);
PROCEDURE psorderitemcreate (
p_headordnum IN sorder.headordnum%TYPE,
p_ordnum IN sorderitem.ordnum%TYPE,
p_oldordnum IN sorderitem.ordnum%TYPE,
p_sacustomer_id IN sorderitem.sacustomer_id%TYPE,
p_adress1_id IN caddress.ID%TYPE,
p_adress2_id IN caddress.ID%TYPE,
p_eventsource_id IN sorderitem.eventsource_id%TYPE,
p_eventsourcedet_id IN sorderitem.eventsourcedet_id%TYPE,
p_cproductoffer_id IN sorderitem.cproductoffer_id%TYPE,
p_pclass_code IN sorderitem.pclass_code%TYPE,
p_psalescategory_code IN sorderitem.psalescategory_code%TYPE,
p_pproductoffer_id IN sorderitem.pproductoffer_id%TYPE,
p_action_code IN sorderitem.action_code%TYPE,
p_ad_ind IN sorderitem.ad_ind%TYPE,
p_quantity IN sorderitem.quantity%TYPE,
p_qtyunit_code IN sorderitem.qtyunit_code%TYPE, ---??????
p_temporary_ind IN sorderitem.temporary_ind%TYPE,
p_tempdatefrom IN sorderitem.tempdatefrom%TYPE,
p_tempdateto IN sorderitem.tempdateto%TYPE,
p_tempdaysno IN sorderitem.tempdaysno%TYPE,
p_billable_ind IN sorderitem.billable_ind%TYPE,
p_custexist_ind IN sorderitem.custexist_ind%TYPE,
p_expecteddate IN sorderitem.expecteddate%TYPE,
p_headorditemnum IN sorderitem.headorditemnum%TYPE,
p_description IN sorderitem.description%TYPE,
p_created IN sorderitem.created%TYPE,
p_created_by IN sorderitem.created_by%TYPE,
p_orditemnum OUT sorderitem.orditemnum%TYPE
);
PROCEDURE psorderitemproductscreate (
p_orditemnum IN sorderitemproduct.orditemnum%TYPE
);
PROCEDURE psorderitemproductcreate (
p_orditemproductnum OUT sorderitemproduct.orditemproductnum%TYPE,
p_orditemnum IN sorderitemproduct.orditemnum%TYPE,
p_orderdate IN sorderitemproduct.orderdate%TYPE,
p_pproductoffer_id IN sorderitemproduct.pproductoffer_id%TYPE,
p_pproduct_id IN sorderitemproduct.pproduct_id%TYPE,
p_action_code IN sorderitemproduct.action_code%TYPE,
p_quantity IN sorderitemproduct.quantity%TYPE,
p_qtyunit_code IN sorderitemproduct.qtyunit_code%TYPE,
p_billable_ind IN sorderitemproduct.billable_ind%TYPE,
p_commitment_ind IN sorderitemproduct.commitment_ind%TYPE,
p_commitmentvalue IN sorderitemproduct.commitmentvalue%TYPE,
p_commitmentunit IN sorderitemproduct.commitmentunit%TYPE,
p_installment_ind IN sorderitemproduct.installment_ind%TYPE,
p_installmentvalue IN sorderitemproduct.installmentvalue%TYPE,
p_installmentunit IN sorderitemproduct.installmentunit%TYPE,
p_note IN sorderitemproduct.note%TYPE,
p_comments IN sorderitemproduct.comments%TYPE,
p_description IN sorderitemproduct.description%TYPE,
p_created IN sorderitemproduct.created%TYPE,
p_created_by IN sorderitemproduct.created_by%TYPE /*,
p_MODIFIED IN SORDERITEMPRODUCT.MODIFIED%TYPE,
p_MODIFIED_BY IN SORDERITEMPRODUCT.MODIFIED_BY%TYPE*/
);
PROCEDURE psorderitemattcreate (
p_orditemnum IN sorderitemproduct.orditemnum%TYPE,
p_attname sorderitematt.attname%TYPE,
p_attvalue sorderitematt.attvalue%TYPE,
p_attvaluefrom sorderitematt.attvaluefrom%TYPE,
p_attvalueto sorderitematt.attvalueto%TYPE,
p_eventsource_ind sorderitematt.eventsource_ind%TYPE,
p_realization_code sorderitematt.realization_code%TYPE,
p_comments sorderitematt.comments%TYPE,
p_description sorderitematt.description%TYPE,
p_created sorderitematt.created%TYPE,
p_created_by sorderitematt.created_by%TYPE
);
PROCEDURE psorderitemproductpricecreate (
p_orditemproductnum sorderitemproductprice.orditemproductnum%TYPE,
p_productprice_id sorderitemproductprice.productprice_id%TYPE,
-- p_PRICESTYPE_CODE SORDERITEMPRODUCTPRICE.PRICESTYPE_CODE%TYPE,
-- p_ITEMAMOUNT SORDERITEMPRODUCTPRICE.ITEMAMOUNT%TYPE,
-- p_DISCOUNTAMOUNT SORDERITEMPRODUCTPRICE.DISCOUNTAMOUNT%TYPE,
-- p_DISCOUNTPERCENT SORDERITEMPRODUCTPRICE.DISCOUNTPERCENT%TYPE,
-- p_EXTENDEDAMOUNT SORDERITEMPRODUCTPRICE.EXTENDEDAMOUNT%TYPE,
-- p_OVERRIDEAMOUNT SORDERITEMPRODUCTPRICE.OVERRIDEAMOUNT%TYPE,
-- p_OVERRIDEREASON SORDERITEMPRODUCTPRICE.OVERRIDEREASON%TYPE,
-- p_INSTALLMENTAMOUNT SORDERITEMPRODUCTPRICE.INSTALLMENTAMOUNT%TYPE,
p_installmentvalue sorderitemproductprice.installmentvalue%TYPE,
-- p_NETDISCOUNTPERCENT SORDERITEMPRODUCTPRICE.NETDISCOUNTPERCENT%TYPE,
-- p_NONDISCOUNTEDLINETOTAL SORDERITEMPRODUCTPRICE.NONDISCOUNTEDLINETOTAL%TYPE,
p_created sorderitemproductprice.created%TYPE,
p_created_by sorderitemproductprice.created_by%TYPE
);
PROCEDURE psordercomplete (
p_headordnum IN sorder.headordnum%TYPE,
p_destinationfrom_code IN sordtracking.destinationfrom_code%TYPE,
p_description IN sorder.description%TYPE,
p_modified IN sorder.modified%TYPE,
p_modified_by IN sorder.modified_by%TYPE
);
/******************************************************************************************/
PROCEDURE psorderupdate (
p_ordnum IN sorder.ordnum%TYPE,
p_cacustomer_id sorder.cacustomer_id%TYPE,
p_bacustomer_id sorder.bacustomer_id%TYPE,
p_acontact_id sorder.acontact_id%TYPE,
p_ocontact1_id sorder.ocontact1_id%TYPE,
p_refdate sorder.refdate%TYPE,
p_refnumber sorder.refnumber%TYPE,
p_refdate1 sorder.refdate1%TYPE,
p_refnumber1 sorder.refnumber1%TYPE,
p_description sorder.description%TYPE,
p_modified_by sorder.modified_by%TYPE
);
PROCEDURE psgworkordercreate (
p_ordnum IN sorderitem.ordnum%TYPE,
p_saleschanneltype_code sorder.saleschanneltype_code%TYPE,
p_created IN sorderitem.created%TYPE,
p_created_by IN sorderitem.created_by%TYPE
);
PROCEDURE psworkordercreate (
p_ordnum IN sworkorder.ordnum%TYPE,
p_workorderdate IN sworkorder.workorderdate%TYPE,
p_servicelocation_id IN sworkorder.servicelocation_id%TYPE,
p_comments IN sworkorder.comments%TYPE,
p_description IN sworkorder.description%TYPE,
p_created_by IN sworkorder.created_by%TYPE,
p_workordnum OUT sworkorder.workordnum%TYPE
);
PROCEDURE psworkorderitemcreate (
p_workordnum IN sworkorderitem.workordnum%TYPE,
p_orditemnum IN sworkorderitem.orditemnum%TYPE,
p_created IN sworkorderitem.created%TYPE,
p_created_by IN sworkorderitem.created_by%TYPE
);
PROCEDURE peventsourcecreate (
p_orditemnum IN sorderitem.orditemnum%TYPE,
p_cproductoffer_id IN cproductoffer.ID%TYPE
);
PROCEDURE pcproductoffercreate (p_orditemnum IN sorderitem.orditemnum%TYPE);
PROCEDURE pcproductofferattcreate (
p_orditemnum IN sorderitem.orditemnum%TYPE,
p_cproductoffer_id IN cproductoffer.ID%TYPE
);
PROCEDURE pcproductcreate (
p_orditemnum IN sorderitem.orditemnum%TYPE,
p_cproductoffer_id IN cproductoffer.ID%TYPE
);
PROCEDURE pcproductchargescreate (
p_orditemproductnum IN sorderitemproduct.orditemproductnum%TYPE,
p_cproductoffer_id IN cproductoffer.ID%TYPE
);
FUNCTION fsordercreatecheck (
p_orderdate sorder.orderdate%TYPE,
p_cacustomer_id sorder.cacustomer_id%TYPE,
p_bacustomer_id sorder.bacustomer_id%TYPE,
p_sacustomer_id sorder.sacustomer_id%TYPE,
p_acontact_id sorder.acontact_id%TYPE,
p_saleslocation_id sorder.saleslocation_id%TYPE,
p_salesslocation_id sorder.salesslocation_id%TYPE,
p_saleschanneltype_code sorder.saleschanneltype_code%TYPE,
p_headordnum sorder.headordnum%TYPE,
p_created_by sorder.created_by%TYPE,
p_salestype VARCHAR2,
p_doctype_code sorder.doctype_code%TYPE
)
RETURN VARCHAR2;
FUNCTION fget_sorderrec (p_ordnum sorder.ordnum%TYPE)
RETURN sorderrec;
FUNCTION fget_productofferrec (p_id productoffer.ID%TYPE)
RETURN productofferrec;
FUNCTION fget_sorderitemrec (p_orditemnum sorderitem.orditemnum%TYPE)
RETURN sorderitemrec;
FUNCTION fget_productpricerec (p_id productprice.ID%TYPE, p_date DATE)
RETURN productpricerec;
FUNCTION fget_pospecdetcharrec (p_productoffer_id productoffer.ID%TYPE)
RETURN specchartab;
FUNCTION fget_cproductofferrec (p_id cproductoffer.ID%TYPE)
RETURN cproductofferrec;
/***********************************************************************************************************/
PROCEDURE pcreatesquote (
p_ordnum IN squote.ordnum%TYPE,
p_anexnum IN squote.anexnum%TYPE,
p_quotedate IN squote.quotedate%TYPE,
p_saleslocation_id IN squote.saleslocation_id%TYPE,
p_salesslocation_id IN squote.salesslocation_id%TYPE,
p_currency_code IN squote.currency_code%TYPE,
p_pdv_ind IN squote.pdv_ind%TYPE,
p_paymentterms_code IN squote.paymentterms_code%TYPE,
p_created_by IN squote.created_by%TYPE
);
/*********************Procedura za kreiranje stavke predracuna***********************************************************/
PROCEDURE pcreatesquoteitem (
p_quotenum IN squoteitem.quotenum%TYPE,
p_product_id IN squoteitem.product_id%TYPE,
p_productprice_id IN squoteitem.productprice_id%TYPE,
p_quantity IN squoteitem.quantity%TYPE,
p_itemamount IN squoteitem.itemamount%TYPE,
p_discountamount IN squoteitem.discountamount%TYPE,
p_discountpercent IN squoteitem.discountpercent%TYPE,
p_extendedamount IN squoteitem.extendedamount%TYPE,
p_overrideamount IN squoteitem.overrideamount%TYPE,
p_overridereason IN squoteitem.overridereason%TYPE,
p_installmentamount IN squoteitem.installmentamount%TYPE,
p_installmentvalue IN squoteitem.installmentvalue%TYPE,
p_currency_code IN squoteitem.currency_code%TYPE,
p_created_by IN squoteitem.created_by%TYPE
);
/***********************Procedura za update iznosa predracuna nakon dodavanja stavki***********************************************/
PROCEDURE pupdatequoteamnt (
p_quotenum IN squote.quotenum%TYPE,
p_modified_by IN squote.modified_by%TYPE
);
/*********************Procedura za ponistenje stavke predracuna***********************************************************/
PROCEDURE pcanclequoteitem (
p_quotenum IN squoteitem.quotenum%TYPE,
p_seqno IN squoteitem.seqno%TYPE,
p_modified_by IN squoteitem.modified_by%TYPE
);
/***********************Procedura za formiranje otpremnice***********************************************/
PROCEDURE pcreate_sdispatchnote (
p_ordnum IN sdispatchnote.ordnum%TYPE,
p_saleslocation_id IN sdispatchnote.saleslocation_id%TYPE,
p_salesslocation_id IN sdispatchnote.salesslocation_id%TYPE,
p_created_by IN sdispatchnote.created_by%TYPE,
p_approcess_id IN rappworkflow.appprocess_id%TYPE
);
/***********************Procedura za update iznosa otpremnice nakon dodavanja stavki***********************************************/
PROCEDURE pupdate_dispatchnoteamnt (
p_dispatchnotenum IN sdispatchnote.dispatchnotenum%TYPE,
p_modified_by IN sdispatchnote.modified_by%TYPE
);
/*************************************Funkcija za odredjivanje rbr-a stavke predracuna unutar jednog predracuna***********************************************/
FUNCTION fcreate_squoteitem_seqno (p_quotenum IN squoteitem.quotenum%TYPE)
RETURN NUMBER;
/*************************************Funkcija za naziv produkta***********************************************/
FUNCTION fget_productname (p_product_id IN product.ID%TYPE)
RETURN VARCHAR2;
/*************************************Funkcija za odredjivanje rbr-a stavke OTPREMNICE***********************************************/
FUNCTION fcreate_sdispnoteitem_seqno (
p_dispatchnotenum IN sdispatchnote.dispatchnotenum%TYPE
)
RETURN NUMBER;
/****************************Funkcija koja odreduje izlazni status za odredeni activity*************/
FUNCTION fget_statusout (
p_appactivity_id IN rappactivity.ID%TYPE,
p_appprocess_id IN rappworkflow.appprocess_id%TYPE,
p_ordnum IN sorder.ordnum%TYPE
)
RETURN VARCHAR2;
/*****Funkcija koja za poznati status i doctype_in, vraca rezultatni status doctype_out********/
FUNCTION fget_ordstatustrans (
p_status IN rstatus.status%TYPE,
p_doctypecode_in IN rdoctype.code%TYPE,
p_doctypecode_out IN rdoctype.code%TYPE
)
RETURN VARCHAR2;
/*Pocedura koja vrsi update i tracking SORDER tabele zavisno od flag-a**********************************/
PROCEDURE psorderupdate (
p_ordnum IN sorder.ordnum%TYPE,
p_reason_code IN sorder.reason_code%TYPE,
p_status IN sorder.status%TYPE,
p_ordertype_code IN sorder.ordertype_code%TYPE,
p_doctype_code IN sorder.doctype_code%TYPE,
p_destinationfrom_code IN sordtracking.destinationfrom_code%TYPE,
p_description IN sorder.description%TYPE,
p_modified IN sorder.modified%TYPE,
p_modified_by IN sorder.modified_by%TYPE,
p_update_type IN VARCHAR2
);
/****************************Funkcija provjerava da li je predan ORDNUM ili HEADORDNUM u tabeli SORDER******/
FUNCTION fget_ordnumstatus (p_ordnum IN sorder.ordnum%TYPE)
RETURN VARCHAR2;
/****** Krovna procedura koja za predani p_activity i p_reason_code odreduje ili postavlja status na p_status
(ovisno o konkretnom slucaju) **********************************************/
PROCEDURE psordertrans (
p_ordnum IN sorder.ordnum%TYPE,
p_approcess_id IN rappworkflow.appprocess_id%TYPE,
p_activity IN rappactivity.ID%TYPE,
p_reason_code IN sorder.reason_code%TYPE,
p_status_out IN sorder.status%TYPE,
p_destinationfrom_code IN sordtracking.destinationfrom_code%TYPE,
p_description IN sorder.description%TYPE,
p_modified IN sorder.modified%TYPE,
p_modified_by IN sorder.modified_by%TYPE
);
/**************Funkcija provjerava da li su svi zahtjevi ili narudA3be u istom statusu******************/
FUNCTION fcheck_sorderstatus (
p_ordnum IN sorder.ordnum%TYPE,
p_doctype_code sorder.doctype_code%TYPE,
-- Ulazni parametri 'ORDER' ili 'ORDITEM'
p_status_out sorder.status%TYPE
)
RETURN VARCHAR2;
PROCEDURE psorditemupdate (
p_orditemnum IN sgworkorder.orditemnum%TYPE,
p_startdate IN sgworkorder.startdate%TYPE,
p_status IN sgworkorder.status%TYPE,
p_destinationfrom_code IN sordtracking.destinationfrom_code%TYPE,
p_modified IN sgworkorder.modified%TYPE,
p_modified_by IN sgworkorder.modified_by%TYPE,
p_out_stmt OUT VARCHAR2
);
/*******************************************************************************************************************/
FUNCTION fcheck_docvalidate (p_ordnum IN sorderitem.ordnum%TYPE)
RETURN VARCHAR2;
/*************************Funkcija provjerava da li za predani broj zahtjeva moguca izmjena*******************/
FUNCTION fcheck_updateorder (p_ordnum IN sorder.ordnum%TYPE)
RETURN VARCHAR2;
/*********************** Procedura koja za predani broj narudA3be kreira opA!ti ugovor ****************************************/
PROCEDURE pcreate_contracthead (
p_ordnum IN sorder.ordnum%TYPE,
p_saleslocation_id IN scontractannex.saleslocation_id%TYPE,
p_salesslocation_id IN scontractannex.salesslocation_id%TYPE,
p_created_by IN scontractannex.created_by%TYPE
);
/******************Procedura vrA!i insert slogova zahtjeva i/ili viA!e aneksa ugovora ***************************************/
PROCEDURE pinsert_contractorder (
p_contractnum IN scontractannex.contractnum%TYPE,
p_ordnum IN sorder.ordnum%TYPE,
p_created_by IN scontractannex.status%TYPE
);
/******************* Procedura za insert aneksa ugovora *****************************************/
PROCEDURE pinsert_conrtactannex (
p_contractnum IN scontractannex.contractnum%TYPE,
p_contractdate IN scontractannex.contractdate%TYPE,
p_cacustomer_id IN scontractannex.cacustomer_id%TYPE,
p_acontact_id IN scontractannex.acontact_id%TYPE,
p_aaddress_id IN scontractannex.aaddress_id%TYPE,
p_judiciallocation_id IN scontractannex.judiciallocation_id%TYPE,
p_refnumber IN scontractannex.refnumber%TYPE,
p_refdate IN scontractannex.refdate%TYPE,
p_reftype_code IN scontractannex.reftype_code%TYPE,
p_description IN scontractannex.description%TYPE,
p_saleslocation_id IN scontractannex.saleslocation_id%TYPE,
p_salesslocation_id IN scontractannex.salesslocation_id%TYPE,
p_created_by IN scontractannex.created_by%TYPE,
p_scontractnum OUT scontractannex.contractnum%TYPE
);
/******************* Procedura za izmjenu ugovora ********************************************/
PROCEDURE pupdate_contract (
p_contractnum IN scontractannex.contractnum%TYPE,
p_contractdate IN scontractannex.contractnum%TYPE,
p_cacustomer_id IN scontractannex.contractnum%TYPE,
p_acontact_id IN scontractannex.contractnum%TYPE,
p_address_id IN scontractannex.contractnum%TYPE,
p_judiciallocation_id IN scontractannex.judiciallocation_id%TYPE,
p_refnumber IN scontractannex.refnumber%TYPE,
p_refdate IN scontractannex.refdate%TYPE,
p_reftype_code IN scontractannex.reftype_code%TYPE,
p_description IN scontractannex.description%TYPE,
p_modified_by IN scontractannex.modified_by%TYPE,
p_printlog IN scontractannex.printlog%TYPE
);
/*****************************Update Ugovora na POTPISAN ************************/
PROCEDURE pchange_contractstatus (
p_contractnum IN scontractannex.contractnum%TYPE,
p_modified_by IN scontractannex.modified_by%TYPE
);
/*************************************Kreiranje Radnog Naloga ******************************************************/
PROCEDURE psworkordercreate (
p_ordnum IN sworkorder.ordnum%TYPE,
p_created_by IN sworkorder.created_by%TYPE,
p_approcess_id IN rappworkflow.appprocess_id%TYPE,
p_workordnum OUT sworkorder.workordnum%TYPE
);
/********************** Kreiranje stavki radnog naloga **************************************/
PROCEDURE psworkorderitemcreate (
p_workordnum IN sworkorderitem.workordnum%TYPE,
p_ordnum IN sorderitem.ordnum%TYPE,
p_created_by IN sworkorderitem.created_by%TYPE,
p_headorditemnum IN SORDERITEM.HEADORDITEMNUM%TYPE DEFAULT NULL,
p_ptechnology_code IN SORDERITEM.PTECHNOLOGY_CODE%TYPE DEFAULT NULL);
/************************ Tracking za SWOKRORDERTRACKING *************************************/
PROCEDURE psworkordertrackingcreate (
p_workordnum IN sworkordertracking.workordnum%TYPE,
p_status IN sworkordertracking.status%TYPE,
p_trackdate IN sworkordertracking.trackdate%TYPE,
p_destinationto_code IN sworkordertracking.destinationto_code%TYPE,
p_description IN sworkordertracking.description%TYPE,
p_created_by IN sworkordertracking.created_by%TYPE,
p_tracking IN VARCHAR2
);
/************************************* Ponistavanje radnog naloga *******************************/
PROCEDURE psworkordercancel (
p_workordnum IN sworkorder.workordnum%TYPE,
p_modified_by IN sworkorder.modified_by%TYPE
);
/******************************** Ponistavanje stavki radnog naloga ******************************************/
PROCEDURE psworkorderitemcancel (
p_workordnum IN sworkorderitem.workordnum%TYPE,
p_orditemnum IN sworkorderitem.orditemnum%TYPE,
p_modified_by IN sworkorderitem.modified_by%TYPE
);
/*********************************************************************************************/
FUNCTION fcreate_workorderitem_seqno (
p_workordnum IN sworkorder.workordnum%TYPE
)
RETURN NUMBER;
/*********************************************************************************************/
FUNCTION fcreate_tracking_seqno (
p_workordnum IN sworkorder.workordnum%TYPE
)
RETURN NUMBER;
/****************** Procedura za update sworkorder-a **********************/
PROCEDURE pupdate_sworkorder (
p_workordnum IN sworkorder.workordnum%TYPE,
p_workorderdate IN sworkorder.workorderdate%TYPE,
p_comments IN sworkorder.comments%TYPE
);
/*******************************************************************************/
FUNCTION fcheck_responsetm (p_ordnum IN sordtracking.ordnum%TYPE)
RETURN VARCHAR2;
/*******************************************************************************/
PROCEDURE phandlerequesttm (
p_orditemnum IN sorderitem.orditemnum%TYPE,
p_created_by IN sordtracking.created_by%TYPE,
p_destinationfrom_code IN sordtracking.destinationfrom_code%TYPE,
p_destinationto_code IN sordtracking.destinationto_code%TYPE,
p_date IN sordtracking.trackdate%TYPE,
p_description IN sordtracking.description%TYPE,
p_tracking_id OUT sordtracking.ID%TYPE
);
/**************************************************************************************/
PROCEDURE psorderitemcomplete (p_orditemnum IN sorderitem.orditemnum%TYPE);
/***********************Procedura za kreiranje jednokratnih zaduzenja***********************************************/
PROCEDURE pcreatecproductcharge (
p_eventsource_id IN ceventsource.ID%TYPE,
p_pproduct_id IN product.ID%TYPE,
p_productprice_id IN productprice.ID%TYPE,
p_quantity IN cproductoffer.quantity%TYPE,
p_qtyunit_code IN productprice.qtyunit_code%TYPE,
p_price IN productprice.price%TYPE,
p_created_by IN ceventsource.created_by%TYPE,
p_id OUT cproductcharges.ID%TYPE
);
/***********************Procedura za ponistenje predracuna***********************************************/
PROCEDURE pcancleproductcharges (
p_id IN cproductcharges.ID%TYPE,
p_created_by IN ceventsource.created_by%TYPE,
p_out_desc OUT NOCOPY VARCHAR2
);
PROCEDURE pddicorrect (
p_eventsource_id IN ceventsource.ID%TYPE,
p_orditemnum IN cproductoffer.orditemnum%TYPE,
p_cproductoffer_id IN cproductoffer.ID%TYPE,
p_cproductoffer_old_id IN cproductoffer.ID%TYPE,
p_date IN DATE
);
PROCEDURE pcreatedscnt (p_orditemnum IN sorderitem.orditemnum%TYPE);
PROCEDURE ppostattchange (p_orditemnum IN sorderitem.orditemnum%TYPE);
/******************************************************************************/
PROCEDURE pcreatesaaddressnew (
p_address_id IN caddress.ID%TYPE,
p_ba_id IN ccustomer.ID%TYPE,
p_pmarketarea_code IN sorderitem.pmarketarea_code%TYPE,
p_pfamily_code IN sorderitem.pfamily_code%TYPE,
p_ptechnology_code IN sorderitem.ptechnology_code%TYPE,
p_saleslocation_id IN sorderitem.saleslocation_id%TYPE,
p_salesslocation_id IN sorderitem.salesslocation_id%TYPE,
p_created_by IN sorderitem.created_by%TYPE,
p_sa_id OUT NOCOPY ccustomer.ID%TYPE
);
PROCEDURE phandlebhvox (
p_workordnum IN sworkorderitem.workordnum%TYPE,
p_orditemnum IN sworkorderitem.orditemnum%TYPE
);
PROCEDURE psend_email (
od VARCHAR2, --poslijalac
za VARCHAR2, --primatelj
cc VARCHAR2, --primatelj cc
sub VARCHAR2, --subject
tekst VARCHAR2 --tekst poruke
);
PROCEDURE pset_bqtyclass_code (
p_customer_id IN ccustomer.ID%TYPE,
p_date IN DATE
);
/******************************************************************************************/
PROCEDURE pupdateprintlog_ordorder (
p_ordordnum IN sorder.ordnum%TYPE,
p_printlog IN sorder.printlog%TYPE,
p_created_by IN sorder.created_by%TYPE
);
/***** procedura sluA3i za izmjenu instalacijske adrese na nivou stavke zahtjeva *****/
PROCEDURE pupdateorderitem (
p_orditemnum IN sorderitem.orditemnum%TYPE,
p_sacustsomer_id IN sorderitem.sacustomer_id%TYPE,
p_houseno IN caddress.houseno%TYPE,
p_houseletter IN caddress.houseletter%TYPE,
p_entrance IN caddress.entrance%TYPE,
p_apartment IN caddress.apartment%TYPE,
p_floor IN caddress.FLOOR%TYPE,
p_address_id OUT NOCOPY caddress.ID%TYPE
);
PROCEDURE pmanagetakeoverprice (p_orditemnum IN sorderitem.orditemnum%TYPE);
/********** Procedura za update predracuna *******************/
PROCEDURE pupdatequoteitem (
p_quotenum IN squoteitem.quotenum%TYPE,
p_seqno IN squoteitem.seqno%TYPE,
p_unitprice IN squoteitem.unitprice%TYPE,
p_quantity IN squoteitem.quantity%TYPE,
p_itemamount IN squoteitem.itemamount%TYPE,
p_discountamount IN squoteitem.discountamount%TYPE,
p_modified_by IN squoteitem.modified_by%TYPE
);
PROCEDURE pmanagecoffercnt (p_orditemnum IN sorderitem.orditemnum%TYPE);
PROCEDURE phandlecrossupaction (p_orditemnum IN sorderitem.orditemnum%TYPE);
/******************************************PROCEDURA ZA UPDATE PRINTLOG-A**********************************************************************/
PROCEDURE pupdate_printlog (
p_docnum IN scontractannex.contractnum%TYPE,
p_printlog IN scontractannex.printlog%TYPE,
p_doctype IN VARCHAR2
);
/***********************Procedura za update statusa i distribucijskog kanala otpremnice***********************************************/
PROCEDURE pupdate_dispatchnote (
p_dispatchnotenum IN sdispatchnote.dispatchnotenum%TYPE,
p_status IN sdispatchnote.status%TYPE,
p_distributionchannel_code IN sdispatchnote.distributionchannel_code%TYPE,
p_modified_by IN sdispatchnote.modified_by%TYPE
);
/*******************************************************************************************************************/
FUNCTION fcheck_dispatchnotestatus (p_ordnum IN sorderitem.ordnum%TYPE)
RETURN VARCHAR2;
/***************************************************************************************************************/
FUNCTION fget_ordstatus (p_ordnum IN sorder.ordnum%TYPE)
RETURN VARCHAR2;
/************************************************************************************************************************************ /
PROCEDURE porderupdateafterworkorder (
p_ordnum IN sorder.ordnum%TYPE,
p_workordnum IN sworkorderitem.workordnum%TYPE,
p_destinationfrom_code IN sordtracking.destinationfrom_code%TYPE,
p_destinationto_code IN sordtracking.destinationto_code%TYPE,
p_status IN sorder.status%TYPE,
p_description IN sordtracking.description%TYPE,
p_modified IN sorder.modified%TYPE,
p_modified_by IN sorder.modified_by%TYPE
);
/*******************************************************************************/
PROCEDURE pclone_ca (
p_cacustomer_id IN ccustomer.ID%TYPE,
p_ordnum IN sorder.ordnum%TYPE,
p_id OUT NOCOPY ccustomer.ID%TYPE
);
/*********************** Procedura za opti ugovor ****************************************/
PROCEDURE pcreate_tempcontracthead (
p_cacustomer_id IN ccustomer.ID%TYPE,
p_ordnum IN sorder.ordnum%TYPE,
p_contact_id IN ccontact.ID%TYPE,
p_address_id IN caddress.ID%TYPE,
p_saleslocation_id IN scontractannex.saleslocation_id%TYPE,
p_salesslocation_id IN scontractannex.salesslocation_id%TYPE,
p_created_by IN scontractannex.created_by%TYPE,
p_contractnum OUT NOCOPY scontractannex.contractnum%TYPE
);
/******************* Procedura za insert aneksa ugovora *****************************************/
PROCEDURE pinsert_conrtactannex0 (
p_contractnum IN scontractannex.contractnum%TYPE,
p_cacustomer_id IN scontractannex.cacustomer_id%TYPE,
p_acontact_id IN scontractannex.acontact_id%TYPE,
p_aaddress_id IN scontractannex.aaddress_id%TYPE,
p_description IN scontractannex.description%TYPE,
p_saleslocation_id IN scontractannex.saleslocation_id%TYPE,
p_salesslocation_id IN scontractannex.salesslocation_id%TYPE,
p_created_by IN scontractannex.created_by%TYPE,
p_scontractnum OUT scontractannex.contractnum%TYPE
);
/****************** Procedura za update ugovora **********************************/
PROCEDURE pupdate_wtmpcontract (
p_contractnum IN scontractannex.contractnum%TYPE,
p_contractdate IN scontractannex.contractnum%TYPE,
p_cacustomer_id IN scontractannex.contractnum%TYPE,
p_acontact_id IN scontractannex.contractnum%TYPE,
p_address_id IN scontractannex.contractnum%TYPE,
p_judiciallocation_id IN scontractannex.judiciallocation_id%TYPE,
p_refnumber IN scontractannex.refnumber%TYPE,
p_refdate IN scontractannex.refdate%TYPE,
p_reftype_code IN scontractannex.reftype_code%TYPE,
p_description IN scontractannex.description%TYPE,
p_modified_by IN scontractannex.modified_by%TYPE,
p_printlog IN scontractannex.printlog%TYPE
);
/*****************************Update Ugovora na POTPISAN ************************/
PROCEDURE pchange_wtmpcontractstatus (
p_contractnum IN scontractannex.contractnum%TYPE,
p_modified_by IN scontractannex.modified_by%TYPE,
p_ordnum IN sorder.ordnum%TYPE,
p_customer_id IN ccustomer.ID%TYPE
);
/******************************************************************************/
PROCEDURE pupdate_tempatt (
p_cproductoffer_id IN cproductoffer.ID%TYPE,
p_executuondate IN DATE
);
/***********************************************************************************************************************************/
PROCEDURE pstorno_asmb (p_orditemnum IN cproductoffer.orditemnum%TYPE);
/***********************************************************************************************************************************/
-- /* za JRK prepaid pocetak */
PROCEDURE pregister_prepaid (
p_customer_id IN ccustomer.customer_id%TYPE,
p_bacustomer_id IN CCUSTOMER.ID%TYPE, --24.02.2011.
p_saleslocation_id ccustomer.saleslocation_id%TYPE,
p_salesslocation_id ccustomer.salesslocation_id%TYPE,
p_area_code IN ceventsource.area_code%TYPE,
p_msisdn IN ceventsource.msisdn%TYPE,
p_imsi IN CEVENTSOURCE.IMSI%TYPE, --24.02.
p_puk1 IN CEVENTSOURCE.PUK1%TYPE,
p_puk2 IN CEVENTSOURCE.PUK2%TYPE,
p_iccid IN CEVENTSOURCE.ICCID%TYPE,
p_note IN ceventsource.note%TYPE,
p_created IN ceventsource.created%TYPE,
p_created_by IN ccustomer.created_by%TYPE,
p_es_id OUT ceventsource.ID%TYPE,
p_sa_id OUT ccustomer.ID%TYPE
);
-- /* za JRK prepaid kraj */
/***********************************************************************************************************************************/
PROCEDURE pannouncementlink (
p_contact_id IN ccontact_rannouncement.contact_id%TYPE,
p_announcement_code IN ccontact_rannouncement.announcement_code%TYPE,
p_created_by IN rannouncement.code%TYPE
);
/*******************************PROCEDURA ZA ANNOUNCEMENTUNLINK**********************************************************************/
PROCEDURE pannouncementunlink (
p_contact_id IN ccontact_rannouncement.contact_id%TYPE,
p_announcement_code IN ccontact_rannouncement.announcement_code%TYPE,
p_validfrom IN ccontact_rannouncement.validfrom%TYPE,
p_modified_by ccontact_rannouncement.modified_by%TYPE
);
/***********************************************************************************************************************************/
PROCEDURE pupdate_customercontract (p_customer_id IN ccustomer.ID%TYPE);
PROCEDURE pordordersverified (
p_ordnum IN sorder.ordnum%TYPE,
p_destinationfrom_code IN sordtracking.destinationfrom_code%TYPE,
p_destinationto_code IN sordtracking.destinationto_code%TYPE,
p_created_by IN sorder.created_by%TYPE
);
PROCEDURE pordersupdate (
p_ordnum IN sorder.ordnum%TYPE,
p_status IN sorder.status%TYPE,
p_reason_code IN sorder.reason_code%TYPE,
p_destinationfrom_code IN sordtracking.destinationfrom_code%TYPE,
p_description IN VARCHAR2,
p_created_by IN sorder.created_by%TYPE
);
/*******************************************************************************/
PROCEDURE pchange_bhvoxstatus(p_orditemnum IN SORDERITEM.ORDITEMNUM%TYPE,
p_eventsource_id IN CEVENTSOURCE.ID%TYPE,
p_action_code IN SORDERITEM.ACTION_CODE%TYPE);
/**********************************************************************************/
PROCEDURE psorderitemvalidate(p_orderitemnum IN SORDERITEM.ORDITEMNUM%TYPE);
/*******************Procedura koja kreira orditem za bundle pakete**********************/
PROCEDURE pCreateBudleOrditem(p_orditemnum in SORDERITEM.ORDITEMNUM%TYPE);
/*********** API za racunjanje specijalnih popusta ****************************/
PROCEDURE pCreatemanualdscnt(p_orditemnum IN SORDERITEM.ORDITEMNUM%TYPE);
/******************************** Nova pr
|
|
|
Re: Package transfer from one to other oracle database [message #676056 is a reply to message #676054] |
Wed, 08 May 2019 08:39 |
|
armait
Messages: 14 Registered: April 2019
|
Junior Member |
|
|
and this is end of sql developer report for above paclkage code:
/*********** API za racunjanje specijalnih popusta ****************************/
PROCEDURE pCreatemanualdscnt(p_orditemnum IN SORDERITEM.ORDITEMNUM%TYPE);
/******************************** Nova procedura za Sagg cproductcharges******************************************/
PROCEDURE pcreatecproductchargeSAGG (
p_sagg_id IN ccustomer.ID%TYPE,
p_pproduct_id IN product.ID%TYPE,
p_productprice_id IN productprice.ID%TYPE,
p_quantity IN cproductoffer.quantity%TYPE,
p_qtyunit_code IN productprice.qtyunit_code%TYPE,
p_price IN productprice.price%TYPE,
p_created_by IN ceventsource.created_by%TYPE,
p_id OUT cproductcharges.ID%TYPE
);
/*******za NP, upis atributa node i ptechnology_code***********************/
PROCEDURE psorderitemattupdate (
p_orditemnum IN sorderitemproduct.orditemnum%TYPE,
p_attvalue_node IN sorderitematt.attvalue%TYPE,
p_attvalue_acceptor IN sorderitematt.attvalue%TYPE);
PROCEDURE psorderupdatenote (
p_ordnum IN sorder.ordnum%TYPE,
p_note IN sorder.note%TYPE,
p_modified_by IN sorder.modified_by%TYPE);
/******************************Provjera validnosti e-mail adrese***********************************************/
FUNCTION fcheck_email (l_user_name IN VARCHAR2)
RETURN VARCHAR2;
PROCEDURE pcreatechangepackageitem (p_orditemnum IN sorderitem.orditemnum%TYPE);
PROCEDURE psend_email_elrac (
od VARCHAR2, --poslijalac
za VARCHAR2, --primatelj
cc VARCHAR2, --primatelj cc
sub VARCHAR2, --subject
tekst VARCHAR2 --tekst poruke
);
/******************************************PROCEDURA ZA INSERT PRINTLOG-A**********************************************************************/
PROCEDURE pinsert_printlog (
p_docnum IN idispatch_sorder.ordnum%TYPE,
p_printlog IN idispatch_sorder.printlog%TYPE,
p_createdby IN idispatch_sorder.created_by%TYPE
);
--PROCEDURE pcreateEICitem (p_orditemnum IN sorderitem.orditemnum%TYPE);
--22.01.2013. proA!irena procedura sa parametrom p_relationshiptype_code
PROCEDURE pcreateEICitem (p_orditemnum IN sorderitem.orditemnum%TYPE, p_relationshiptype_code IN PORELATIONSHIP.RELATIONSHIPTYPE_CODE%TYPE default null);
/****************************upgrade asemblirana *****************************/
PROCEDURE psorderitemppasmblcreate(p_orditemnum in sorderitem.orditemnum%TYPE);
--Amela 22.07.2013 10088802_ISDN-BRA
PROCEDURE pcreateISDNcontractitem (p_orditemnum IN sorderitem.orditemnum%TYPE);
/*******************Procedura koja kreira orditem za setove kanala kod MojaTV pakete**********************/
PROCEDURE pCreateChannelOrditem(p_orditemnum in SORDERITEM.ORDITEMNUM%TYPE);
--10088819_Uvo?enje novih mobilnih paketa 09.10.2013
PROCEDURE insert_roaming(p_orditemnum in SORDERITEM.ORDITEMNUM%TYPE,p_id CPRODUCTOFFER.id%TYPE);
PROCEDURE pupdatePFitem (p_orditemnum IN sorderitem.orditemnum%TYPE);
-- RO 10090056 - Komision prodaja kroz SRS, popust kroz JRK - emirha
PROCEDURE pupdate_srs_sales (p_orditemnum in SORDERITEM.ORDITEMNUM%TYPE);
----Kanita dodala 25.08.2016. p_action_code za potrebu automatizacije Moj izbor
PROCEDURE pcreateMCitem (p_orditemnum IN sorderitem.orditemnum%TYPE, p_action_code IN sorderitem.action_code%TYPE);
PROCEDURE pcreateMCLeaveitem (p_orditemnum IN sorderitem.orditemnum%TYPE);
/*******************Procedura koja kreira dummy orditem za IPCentrex grupu**********************/
PROCEDURE pCreateCentrexOrditem(p_orditemnum in SORDERITEM.ORDITEMNUM%TYPE);
-- RO10093324 - POCETAK - IP Centrex nove usluge
PROCEDURE p_DeactivateVirtualNumber (p_orditemnum IN cproductoffer.orditemnum%TYPE);
-- RO10093324 - KRAJ- IP Centrex nove usluge
END uomorder;
Error report -
ORA-01435: user does not exist
01435. 00000 - "user does not exist"
*Cause:
*Action:
|
|
|
|
Re: Package transfer from one to other oracle database [message #676058 is a reply to message #676053] |
Wed, 08 May 2019 09:03 |
cookiemonster
Messages: 13943 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
armait wrote on Wed, 08 May 2019 14:28I created that user(sorder) on my database on the advice of colleagues but thats not solved problem.
Judging by the code sorder is a table not a user.
Did you actually ask your colleagues or did you just go off of my earlier comment?
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Sep 27 11:08:30 CDT 2024
|