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 Go to next message
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 #676021 is a reply to message #676020] Tue, 07 May 2019 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
i cant compile him
This does not help us in any way to know why you can't compile.
You have to tell us more.
For instance, copy and paste the result of the compilation.

Before, Please read How to use [code] tags and make your code easier to read.

Re: Package transfer from one to other oracle database [message #676022 is a reply to message #676020] Tue, 07 May 2019 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 26567
Registered: January 2009
Location: SoCal
Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

We can't say what exactly is wrong since you decide to NOT actually show us what you do & how Oracle responded.

use COPY & PASTE so we can see what you do & Oracle's response
Re: Package transfer from one to other oracle database [message #676023 is a reply to message #676022] Tue, 07 May 2019 10:38 Go to previous messageGo to next message
cookiemonster
Messages: 13642
Registered: September 2008
Location: Rainy Manchester
Senior Member
SQL Developer will show the compile errors - you need to look at them.
Re: Package transfer from one to other oracle database [message #676030 is a reply to message #676023] Tue, 07 May 2019 12:44 Go to previous messageGo to next message
Bill B
Messages: 1870
Registered: December 2004
Senior Member
Are all the tables that the procedure uses available in production?
Re: Package transfer from one to other oracle database [message #676031 is a reply to message #676021] Wed, 08 May 2019 01:30 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
Dear Michel, This is procedure which I use to transfer package from one to another oracle database by sql developer.I`m sending you pictures of the procedure and error messages.Thank you.
  • Attachment: SQLD6.png
    (Size: 41.56KB, Downloaded 78 times)
Re: Package transfer from one to other oracle database [message #676032 is a reply to message #676022] Wed, 08 May 2019 01:31 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
This is procedure which I use to transfer package from one to another oracle database by sql developer.I`m sending you pictures of the procedure and error messages.Thank you.
  • Attachment: SQLD6.png
    (Size: 41.56KB, Downloaded 74 times)
Re: Package transfer from one to other oracle database [message #676033 is a reply to message #676031] Wed, 08 May 2019 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So either the SORDER objects mentioned in the error messages don't exist either ARMIN has no access rights to them.

Re: Package transfer from one to other oracle database [message #676034 is a reply to message #676033] Wed, 08 May 2019 02:00 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
So what to do ? How to find objects ?
Re: Package transfer from one to other oracle database [message #676035 is a reply to message #676034] Wed, 08 May 2019 02:57 Go to previous messageGo to next message
cookiemonster
Messages: 13642
Registered: September 2008
Location: Rainy Manchester
Senior Member
Log in as sorder and look.
Re: Package transfer from one to other oracle database [message #676038 is a reply to message #676035] Wed, 08 May 2019 05:18 Go to previous messageGo to next message
cookiemonster
Messages: 13642
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 #676039 is a reply to message #676035] Wed, 08 May 2019 05:40 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
I tried to create sorder user to my database but nothing, error messages is same.
Re: Package transfer from one to other oracle database [message #676040 is a reply to message #676039] Wed, 08 May 2019 05:45 Go to previous messageGo to next message
cookiemonster
Messages: 13642
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you checked in the source db what sorder is?
Or are you just guessing?

It's your DB, with your objects and your users.
If you're not sure what sorder is then you need to find out from your source control/ documentation / colleagues / other DB.
Re: Package transfer from one to other oracle database [message #676041 is a reply to message #676040] Wed, 08 May 2019 06:15 Go to previous messageGo to next message
Bill B
Messages: 1870
Registered: December 2004
Senior Member
Why din't you just copy the source into your clipboard from the first database and paste it into an editor window for the second database. Thats the easiest way to move a package between databases.
Re: Package transfer from one to other oracle database [message #676043 is a reply to message #676032] Wed, 08 May 2019 06:30 Go to previous messageGo to next message
EdStevens
Messages: 1083
Registered: September 2013
Senior Member
there is no reason to post exactly the same content as response to multiple people. Everything is posted to the entire board, and everyone can read everything posted.

Re: Package transfer from one to other oracle database [message #676044 is a reply to message #676043] Wed, 08 May 2019 06:59 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
I did and result is:

  • Attachment: PAKET1.png
    (Size: 36.57KB, Downloaded 43 times)

[Updated on: Wed, 08 May 2019 07:05]

Report message to a moderator

Re: Package transfer from one to other oracle database [message #676045 is a reply to message #676041] Wed, 08 May 2019 07:06 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
Also, I get this
  • Attachment: PAKET2.png
    (Size: 20.50KB, Downloaded 46 times)
Re: Package transfer from one to other oracle database [message #676047 is a reply to message #676045] Wed, 08 May 2019 07:54 Go to previous messageGo to next message
Bill B
Messages: 1870
Registered: December 2004
Senior Member
WIthout the code it's really hard to troubleshoot. But if you run the package create command in sqlplus and then type "show errors" it will display every error in the package by line and the specific error. It will tell you exactly what is wrong
Re: Package transfer from one to other oracle database [message #676049 is a reply to message #676044] Wed, 08 May 2019 08:07 Go to previous messageGo to next message
cookiemonster
Messages: 13642
Registered: September 2008
Location: Rainy Manchester
Senior Member
armait wrote on Wed, 08 May 2019 12:59
I did and result is:

Did what exactly?
Re: Package transfer from one to other oracle database [message #676050 is a reply to message #676049] Wed, 08 May 2019 08:12 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
Why din't you just copy the source into your clipboard from the first database and paste it into an editor window for the second database. Thats the easiest way to move a package between databases.

Did this.
Re: Package transfer from one to other oracle database [message #676051 is a reply to message #676050] Wed, 08 May 2019 08:17 Go to previous messageGo to next message
BlackSwan
Messages: 26567
Registered: January 2009
Location: SoCal
Senior Member
When you observe different results, then you can be 100% certain that something is different.
Only you can compare and contrast between the two databases to discern what is different & make the necessary changes to have them be the same.

What does Oracle report that the USER is missing?
Re: Package transfer from one to other oracle database [message #676052 is a reply to message #676050] Wed, 08 May 2019 08:23 Go to previous messageGo to next message
cookiemonster
Messages: 13642
Registered: September 2008
Location: Rainy Manchester
Senior Member
It's simple but it's wrong.

The code of the packages should be in source control.
Code should be taken from source control and run into the appropriate DB.
Re: Package transfer from one to other oracle database [message #676053 is a reply to message #676051] Wed, 08 May 2019 08:28 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
I created that user(sorder) on my database on the advice of colleagues but thats not solved problem.
Re: Package transfer from one to other oracle database [message #676054 is a reply to message #676053] Wed, 08 May 2019 08:34 Go to previous messageGo to next message
BlackSwan
Messages: 26567
Registered: January 2009
Location: SoCal
Senior Member
armait wrote on Wed, 08 May 2019 06:28
I created that user(sorder) on my database on the advice of colleagues but thats not solved problem.

We can't say what is wrong since you refuse to use COPY & PASTE to show us what you do & how Oracle responds.

Simply tell us "problem exists" is 100% devoid of any actionable detail.

My car won't go.
Tell me how to make my car go.
Re: Package transfer from one to other oracle database [message #676055 is a reply to message #676054] Wed, 08 May 2019 08:37 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #676057 is a reply to message #676055] Wed, 08 May 2019 08:43 Go to previous messageGo to next message
BlackSwan
Messages: 26567
Registered: January 2009
Location: SoCal
Senior Member
You can lead some folks to knowledge, but you can't make them think.

>Error starting at line : 5 in command -
ERROR?
What Error?
I don't see any error.

It appear you are unwilling or incapable to COPY & PASTE your actual session.

You're On Your Own (YOYO)!
Re: Package transfer from one to other oracle database [message #676058 is a reply to message #676053] Wed, 08 May 2019 09:03 Go to previous messageGo to next message
cookiemonster
Messages: 13642
Registered: September 2008
Location: Rainy Manchester
Senior Member
armait wrote on Wed, 08 May 2019 14:28
I 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?
Re: Package transfer from one to other oracle database [message #676059 is a reply to message #676057] Wed, 08 May 2019 09:09 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
This is result which i get in sql developer
Re: Package transfer from one to other oracle database [message #676060 is a reply to message #676058] Wed, 08 May 2019 09:10 Go to previous messageGo to next message
armait
Messages: 14
Registered: April 2019
Junior Member
I asket my older colegue and i make mistake actually
Re: Package transfer from one to other oracle database [message #676062 is a reply to message #676060] Wed, 08 May 2019 09:42 Go to previous message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Which was?

Previous Topic: How to remove line breaks and put it in excel
Next Topic: Why does my SQL not work?
Goto Forum:
  


Current Time: Mon Jul 22 08:49:10 CDT 2019