1 PACKAGE WSH_TRANSACTIONS_TPW_UTIL AUTHID CURRENT_USER AS
2 /* $Header: WSHTXTPS.pls 120.0.12010000.2 2009/03/23 23:51:21 brana ship $ */
3
4 C_SDEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL1;
5 C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
6
7 PROCEDURE Check_Cancel_Allowed_WF ( P_item_type IN VARCHAR2,
8 P_item_key IN VARCHAR2,
9 P_actid IN NUMBER,
10 P_funcmode IN VARCHAR2,
11 X_resultout OUT NOCOPY VARCHAR2 );
12
13 PROCEDURE Send_Cbod_Success_WF ( P_item_type IN VARCHAR2,
14 P_item_key IN VARCHAR2,
15 P_actid IN NUMBER,
16 P_funcmode IN VARCHAR2,
17 X_resultout OUT NOCOPY VARCHAR2 );
18
19 PROCEDURE Send_Cbod_Failure_WF ( P_item_type IN VARCHAR2,
20 P_item_key IN VARCHAR2,
21 P_actid IN NUMBER,
22 P_funcmode IN VARCHAR2,
23 X_resultout OUT NOCOPY VARCHAR2 );
24
25 PROCEDURE Raise_Cancel_Event_WF ( P_item_type IN VARCHAR2,
26 P_item_key IN VARCHAR2,
27 P_actid IN NUMBER,
28 P_funcmode IN VARCHAR2,
29 X_resultout OUT NOCOPY VARCHAR2 );
30 -- ---------------------------------------------------------------------
31 -- Procedure: Raise_Close_Event_WF
32 --
33 -- Parameters: Item_Type IN VARCHAR2
34 -- Item_Key IN VARCHAR2
35 -- Actid IN NUMBER
36 -- Funcmode IN VARCHAR2
37 -- Resultout OUT VARCHAR2
38 --
39 -- Description: This procedure is called from Inbound workflow (WSHSTNDI) to
40 -- trigger the API Raise_Close_Event that intern calls the business
41 -- event oracle.apps.wsh.standalone.spwf to close all the previous
42 -- error out revision of Shipment Request
43 -- Created: Standalone WMS Project
44 -- -----------------------------------------------------------------------
45 PROCEDURE Raise_Close_Event_WF ( P_item_type IN VARCHAR2 ,
46 P_item_key IN VARCHAR2 ,
47 P_actid IN NUMBER ,
48 P_funcmode IN VARCHAR2 ,
49 X_resultout OUT NOCOPY VARCHAR2 );
50
51 PROCEDURE Send_Cbod_Success ( P_item_type IN VARCHAR2,
52 P_item_key IN VARCHAR2,
53 X_Return_Status OUT NOCOPY VARCHAR2 );
54
55 PROCEDURE Send_Cbod_Failure ( P_item_type IN VARCHAR2,
56 P_item_key IN VARCHAR2,
57 X_Return_Status OUT NOCOPY VARCHAR2 );
58
59 PROCEDURE Check_Cancel_Allowed ( P_item_type IN VARCHAR2,
60 P_item_key IN VARCHAR2,
61 X_return_Status OUT NOCOPY VARCHAR2 );
62
63 PROCEDURE Raise_Cancel_Event ( P_item_type IN VARCHAR2,
64 P_item_key IN VARCHAR2,
65 X_return_Status OUT NOCOPY VARCHAR2 );
66
67 -- ---------------------------------------------------------------------
68 -- Procedure: Raise_Close_Event
69 --
70 -- Parameters: P_Item_Type IN VARCHAR2
71 -- P_Item_Key IN VARCHAR2
72 -- X_return_Status VARCHAR2
73 --
74 -- Description: This procedure is called from Raise_Close_Event_WF API to
75 -- trigger the business event oracle.apps.wsh.standalone.spwf and
76 --- close all the previous error out revision of Shipment Request
77 -- Created: Standalone WMS Project
78 -- -----------------------------------------------------------------------
79 PROCEDURE Raise_Close_Event ( P_item_type IN VARCHAR2 ,
80 P_item_key IN VARCHAR2 ,
81 X_return_Status OUT NOCOPY VARCHAR2 );
82
83 PROCEDURE Send_Shipment_Advice ( P_Entity_ID IN NUMBER,
84 P_Entity_Type IN VARCHAR2,
85 P_Action_Type IN VARCHAR2,
86 P_Document_Type IN VARCHAR2,
87 P_Org_ID IN NUMBER,
88 X_Return_Status OUT NOCOPY VARCHAR2 );
89 END WSH_TRANSACTIONS_TPW_UTIL;