1 PACKAGE "MSC_WS_OTM_BPEL" AUTHID CURRENT_USER AS
2 /* $Header: MSCWOTMS.pls 120.8 2008/02/19 20:14:31 rolar noship $ */
3
4 /*TYPE MsgTokenValuePair IS RECORD
5 (
6 token VARCHAR2(60),
7 value VARCHAR2(60)
8 );
9 TYPE MsgTokenValuePairList IS TABLE OF MsgTokenValuePair;*/
10
11 --================ GET PLANNER =======================
12
13 procedure GetPlanner_1( srInstanceId IN NUMBER,
14 inventoryItemId IN NUMBER,
15 orgId IN NUMBER,
16 planner OUT nocopy varchar2,
17 status OUT nocopy varchar2) ;
18
19 --================ Get Punchout URI ==================
20 function GetPunchoutURI(srInstanceId IN NUMBER,
21 otmReleaseGid IN varchar2) return varchar2;
22
23 --================ ODS =======================
24
25 procedure AddLineId ( poIdString IN varchar2,
26 pnewArrivalDate IN varchar2,
27 ReleaseGid IN varchar2,
28 ReleaseLineGid IN varchar2,
29 tranzId out nocopy NUMBER,
30 status out nocopy varchar2);
31
32 procedure AddLineSO ( pnewArrivalDate IN varchar2,
33 ReleaseGid IN varchar2,
34 ReleaseLineGid IN varchar2,
35 isInternalSO IN varchar2,
36 tranzId out nocopy NUMBER,
37 status out nocopy varchar2);
38 --================ PDS =======================
39
40 procedure UpdatePDS( status OUT nocopy VARCHAR2);
41 procedure UpdatePDS_1( tranzId IN NUMBER,
42 bpelOrderType IN NUMBER,
43 status OUT nocopy VARCHAR2);
44
45 PROCEDURE UpdatePDS_Order( transId IN NUMBER ,
46 order_type IN NUMBER,
47 status OUT nocopy varchar2);
48 PROCEDURE UpdatePDS_PO( planId IN NUMBER,
49 transId IN NUMBER,
50 status OUT nocopy varchar2);
51 PROCEDURE UpdatePDS_SO( planId IN NUMBER,
52 transId IN NUMBER,
53 status OUT nocopy varchar2);
54
55
56 PROCEDURE GenerateException( planId IN NUMBER, transId IN NUMBER, isPoShipment IN NUMBER, status out nocopy varchar2);
57 PROCEDURE GenerateException_SO( planId IN NUMBER, transId IN NUMBER, status out nocopy varchar2);
58
59
60 PROCEDURE UpdateNewColumnAndFirmDate_PO( planId IN NUMBER,
61 transId IN NUMBER,
62 isPoShipment out nocopy NUMBER,
63 status out nocopy varchar2);
64
65 PROCEDURE UpdateNewColumnAndFirmDate_SO( planId IN NUMBER,
66 transId IN NUMBER,
67 status out nocopy varchar2);
68
69 -- ================= NOTIFICATION =============================
70 procedure SendNotification_1 ( tranzId IN NUMBER,
71 status out nocopy varchar2) ;
72
73 procedure GetDataForNotification(lineLocationId IN NUMBER,
74 srInstanceId IN NUMBER,
75 orderNumber OUT nocopy VARCHAR2,
76 inventoryItemId out nocopy NUMBER,
77 orgId out nocopy NUMBER);
78
79 --================ CP ====================================
80
81 procedure UpdateKeyDateInCP ( status OUT NOCOPY VARCHAR2);
82 procedure UpdateCP_1 ( tranzId IN NUMBER,
83 status OUT NOCOPY VARCHAR2);
84
85 procedure Update_CP ( lineLocationId IN NUMBER, arrivalDate IN DATE, status OUT NOCOPY VARCHAR2);
86 function getKeyDate(orderNumber IN VARCHAR2,
87 lineNumber IN VARCHAR2,
88 releaseNumber IN VARCHAR2,
89 lastRefreshNumber IN NUMBER) RETURN DATE;
90
91
92 --================== general ================================
93 procedure AppsInit;
94
95 --================== Purge older than 90 days records ================================
96 procedure PurgeTransportationUpdates;
97
98
99 END;
100
101