1 PACKAGE WSH_TRANSACTIONS_UTIL
2 -- $Header: WSHXUTLS.pls 120.3 2011/12/21 09:51:07 skanduku ship $
3 AUTHID CURRENT_USER AS
4
5 C_SDEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL1;
6 C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
7
8
9 PROCEDURE Send_Document( p_entity_id IN NUMBER,
10 p_entity_type IN VARCHAR2,
11 p_action_type IN VARCHAR2,
12 p_document_type IN VARCHAR2,
13 p_organization_id IN NUMBER,
14 x_return_status OUT NOCOPY VARCHAR2);
15
16
17 PROCEDURE Send_Shipment_Request ( p_entity_id IN NUMBER,
18 p_entity_type IN VARCHAR2,
19 p_action_type IN VARCHAR2,
20 p_document_type IN VARCHAR2,
21 p_organization_id IN NUMBER,
22 x_return_status OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE Get_Event_Key(p_item_type IN VARCHAR2 DEFAULT NULL,
26 p_orig_doc_number IN VARCHAR2 DEFAULT NULL,
27 p_organization_id IN NUMBER,
28 p_event_name IN VARCHAR2,
29 p_delivery_name IN VARCHAR2 DEFAULT NULL,
30 x_event_key OUT NOCOPY VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE Unlock_Delivery_WF( Item_type IN VARCHAR2,
35 Item_key IN VARCHAR2,
36 Actid IN NUMBER,
37 Funcmode IN VARCHAR2,
38 Resultout OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE Process_Inbound_Delivery_WF( Item_type IN VARCHAR2,
42 Item_key IN VARCHAR2,
43 Actid IN NUMBER,
44 Funcmode IN VARCHAR2,
45 Resultout OUT NOCOPY VARCHAR2
46 );
47 -- ---------------------------------------------------------------------
48 -- Procedure: Process_Inbound_SR_WF
49 --
50 -- Parameters: Item_Type IN VARCHAR2
51 -- Item_Key IN VARCHAR2
52 -- Actid IN NUMBER
53 -- Funcmode IN VARCHAR2
54 -- Resultout OUT VARCHAR2
55 --
56 -- Description: This procedure is called from Inbound workflow (WSHSTNDI) to process
57 -- the Inbound Shipment Request information sent by Host ERP system
58 -- Created: Standalone WMS Project
59 -- -----------------------------------------------------------------------
60
61 PROCEDURE Process_Inbound_SR_WF( Item_type IN VARCHAR2 ,
62 Item_key IN VARCHAR2 ,
63 Actid IN NUMBER ,
64 Funcmode IN VARCHAR2 ,
65 Resultout OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE Update_Txn_Hist_Err_WF( Item_type IN VARCHAR2,
69 Item_key IN VARCHAR2,
70 Actid IN NUMBER,
71 Funcmode IN VARCHAR2,
72 Resultout OUT NOCOPY VARCHAR2
73 );
74 PROCEDURE Update_Txn_Hist_Success_WF( Item_type IN VARCHAR2,
75 Item_key IN VARCHAR2,
76 Actid IN NUMBER,
77 Funcmode IN VARCHAR2,
78 Resultout OUT NOCOPY VARCHAR2
79 );
80 -- ---------------------------------------------------------------------
81 -- Procedure: Update_Txn_Hist_Closed_WF
82 --
83 -- Parameters: Item_Type IN VARCHAR2
84 -- Item_Key IN VARCHAR2
85 -- Actid IN NUMBER
86 -- Funcmode IN VARCHAR2
87 -- Resultout OUT VARCHAR2
88 --
89 -- Description: This procedure is called from Inbound Workflow (WSHSTNDI) to Close
90 -- all the previous error out Shipment Request revision of the workflow
91 -- Created: Standalone WMS Project
92 -- -----------------------------------------------------------------------
93
94 PROCEDURE Update_Txn_Hist_Closed_WF( Item_type IN VARCHAR2 ,
95 Item_key IN VARCHAR2 ,
96 Actid IN NUMBER ,
97 Funcmode IN VARCHAR2 ,
98 Resultout OUT NOCOPY VARCHAR2
99 );
100
101 PROCEDURE Update_Txn_History( p_item_type IN VARCHAR2,
102 p_item_key IN VARCHAR2,
103 p_transaction_status IN VARCHAR2,
104 x_return_status OUT NOCOPY VARCHAR2
105 );
106 PROCEDURE WSHSUPI_SELECTOR( Item_type IN VARCHAR2,
107 Item_key IN VARCHAR2,
108 Actid IN NUMBER,
109 Funcmode IN VARCHAR2,
110 Resultout IN OUT NOCOPY VARCHAR2
111 );
112 FUNCTION branch_cms_tpw_flow (p_event_key IN VARCHAR2)
113 RETURN BOOLEAN;
114
115 PROCEDURE Check_cancellation_inprogress (
116 p_delivery_name IN varchar2,
117 x_cancellation_in_progress OUT NOCOPY
118 BOOLEAN ,
119 x_return_status OUT NOCOPY VARCHAR2
120 );
121 PROCEDURE Check_cancellation_wf (
122 item_type IN VARCHAR2,
123 item_key IN VARCHAR2,
124 actid IN NUMBER,
125 funcmode IN VARCHAR2,
126 resultout OUT NOCOPY VARCHAR2
127 );
128 PROCEDURE process_cbod_wf (
129 item_type IN VARCHAR2,
130 item_key IN VARCHAR2,
131 actid IN NUMBER,
132 funcmode IN VARCHAR2,
133 resultout OUT NOCOPY VARCHAR2
134 );
135
136 --Fulfillment Batch XML Project
137 --This procedure sets the name of the event based on the document type and
138 --the value of profile option 'WSH: Distributed Source Entity '
139 --This procedure will be invoked from WSHSSNI.xgm
140 PROCEDURE get_event_name (p_document_type IN VARCHAR2,
141 x_event_name OUT NOCOPY VARCHAR2,
142 x_item_type OUT NOCOPY VARCHAR2);
143
144 --Fulfillment Batch XML Project
145 --This procedure is wrapper for ECX_STANDARD.isDeliveryRequired.
146 --This API raises EXCEPTION when the result out from the ECX API is 'COMPLETE:F'
147 --In this case,it keeps the workflow activity in 'Error' status,so that it may be retried.
148 procedure isDeliveryRequired (itemtype in varchar2,
149 itemkey in varchar2,
150 actid in number,
151 funcmode in varchar2,
152 resultout in out NOCOPY varchar2);
153
154
155 END WSH_TRANSACTIONS_UTIL;