DBA Data[Home] [Help]

PACKAGE: APPS.WSH_TRANSACTIONS_UTIL

Source


1 PACKAGE WSH_TRANSACTIONS_UTIL
2 -- $Header: WSHXUTLS.pls 120.0 2005/05/26 17:57:04 appldev noship $
3 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 PROCEDURE Update_Txn_Hist_Err_WF(	Item_type 	IN	VARCHAR2,
48 					Item_key	IN	VARCHAR2,
49 					Actid		IN	NUMBER,
50 					Funcmode	IN	VARCHAR2,
51 					Resultout	OUT NOCOPY 	VARCHAR2
52                        	 	     );
53 PROCEDURE Update_Txn_Hist_Success_WF(	Item_type 	IN	VARCHAR2,
54 					Item_key	IN	VARCHAR2,
55 					Actid		IN	NUMBER,
56 					Funcmode	IN	VARCHAR2,
57 					Resultout	OUT NOCOPY 	VARCHAR2
58                        	 	     );
59 PROCEDURE Update_Txn_History(		p_item_type 	IN	VARCHAR2,
60 					p_item_key	IN	VARCHAR2,
61 					p_transaction_status IN VARCHAR2,
62 					x_return_status OUT NOCOPY 	VARCHAR2
63                        	 	     );
64 PROCEDURE WSHSUPI_SELECTOR(		Item_type 	IN	VARCHAR2,
65 					Item_key	IN	VARCHAR2,
66 					Actid		IN	NUMBER,
67 					Funcmode	IN	VARCHAR2,
68 					Resultout	IN OUT NOCOPY 	VARCHAR2
69                        	 	     );
70   FUNCTION branch_cms_tpw_flow (p_event_key  IN       VARCHAR2)
71   RETURN BOOLEAN;
72 
73   PROCEDURE Check_cancellation_inprogress (
74                                         p_delivery_name  IN   varchar2,
75                                         x_cancellation_in_progress OUT NOCOPY
76                                                         BOOLEAN ,
77                                         x_return_status OUT NOCOPY VARCHAR2
78                                         );
79   PROCEDURE Check_cancellation_wf (
80                               item_type         IN      VARCHAR2,
81                               item_key          IN      VARCHAR2,
82                               actid             IN      NUMBER,
83                               funcmode          IN      VARCHAR2,
84                               resultout         OUT NOCOPY      VARCHAR2
85                             );
86   PROCEDURE process_cbod_wf (
87                               item_type         IN      VARCHAR2,
88                               item_key          IN      VARCHAR2,
89                               actid             IN      NUMBER,
90                               funcmode          IN      VARCHAR2,
91                               resultout         OUT NOCOPY      VARCHAR2
92                             );
93 
94 END WSH_TRANSACTIONS_UTIL;