1 PACKAGE OKE_DTS_INTEGRATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKEINTGS.pls 120.2 2007/12/21 10:56:58 neerakum ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_DTS_INTEGRATION_PKG';
5 G_WSH_SOURCE_CODE CONSTANT VARCHAR2(30) := 'OKE';
6
7 PROCEDURE Set_WF_Attributes
8 ( ItemType IN VARCHAR2
9 , ItemKey IN VARCHAR2
10 , ActID IN NUMBER
11 , FuncMode IN VARCHAR2
12 , ResultOut OUT NOCOPY VARCHAR2
13 );
14
15
16 PROCEDURE Create_Event
17 ( ItemType IN VARCHAR2
18 , ItemKey IN VARCHAR2
19 , ActID IN NUMBER
20 , FuncMode IN VARCHAR2
21 , ResultOut OUT NOCOPY VARCHAR2
22 );
23
24
25 PROCEDURE Launch_Process
26 ( P_ACTION IN VARCHAR2
27 , P_API_VERSION IN NUMBER
28 , P_COUNTRY_OF_ORIGIN_CODE IN VARCHAR2
29 , P_CURRENCY_CODE IN VARCHAR2
30 , P_DELIVERABLE_ID IN NUMBER
31 , P_DELIVERABLE_NUM IN VARCHAR2
32 , P_INIT_MSG_LIST IN VARCHAR2
33 , P_INSPECTION_REQED IN VARCHAR2
34 , P_ITEM_DESCRIPTION IN VARCHAR2
35 , P_ITEM_ID IN NUMBER
36 , P_ITEM_NUM IN VARCHAR2
37 , P_K_HEADER_ID IN NUMBER
38 , P_K_NUMBER IN VARCHAR2
39 , P_LINE_NUMBER IN VARCHAR2
40 , P_MPS_TRANSACTION_ID IN NUMBER
41 , P_ORGANIZATION IN VARCHAR2
42 , P_ORGANIZATION_ID IN NUMBER
43 , P_PROJECT_ID IN NUMBER
44 , P_PROJECT_NUM IN VARCHAR2
45 , P_QUANTITY IN NUMBER
46 , P_SCHEDULE_DATE IN DATE
47 , P_SCHEDULE_DESIGNATOR IN VARCHAR2
48 , P_SHIP_TO_LOCATION IN VARCHAR2
49 , P_TASK_ID IN NUMBER
50 , P_TASK_NUM IN VARCHAR2
51 , P_UNIT_NUMBER IN VARCHAR2
52 , P_UOM_CODE IN VARCHAR2
53 , P_WORK_DATE IN DATE
54 , P_REQUESTOR IN VARCHAR2 := NULL
55 );
56
57 FUNCTION Charge_Account ( P_Item_ID NUMBER, P_Org_ID NUMBER) RETURN NUMBER;
58
59
60 PROCEDURE Get_Charge_Account
61 ( ItemType IN VARCHAR2
62 , ItemKey IN VARCHAR2
63 , ActID IN NUMBER
64 , FuncMode IN VARCHAR2
65 , ResultOut OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE create_mds_entry(
69 P_DELIVERABLE_ID IN NUMBER,
70 X_OUT_ID OUT NOCOPY NUMBER,
71 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
72
73 FUNCTION Get_WSH_Allowed_Cancel_Qty (
74 P_DELIVERABLE_ID IN NUMBER
75 ) RETURN NUMBER;
76
77 PROCEDURE Cancel_Shipping(
78 P_DELIVERABLE_ID IN NUMBER,
79 X_CANCELLED_QTY OUT NOCOPY NUMBER,
80 X_RETURN_STATUS OUT NOCOPY VARCHAR2
81 );
82
83 END OKE_DTS_INTEGRATION_PKG;