PACKAGE: APPS.WSH_ROUTING_RESPONSE_PKG

Source

1 PACKAGE WSH_ROUTING_RESPONSE_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRESPS.pls 115.1 2003/09/04 19:29:10 rlanka noship $ */
3 
4 --
5 G_PKG_NAME	CONSTANT	VARCHAR2(100) := 'WSH_ROUTING_RESPONSE_PKG';
6 g_eventName	CONSTANT	VARCHAR2(50)  := 'oracle.apps.fte.inbound.routresp.send';
7 g_RespIdTab	WSH_UTIL_CORE.id_tab_type;
8 g_RoleExpDate	CONSTANT	DATE := SYSDATE + 15;
9 --
10 PROCEDURE GenerateRoutingResponse(
11 	p_deliveryIdTab 	IN  wsh_util_core.id_tab_type,
12 	x_routingRespIdTab 	OUT NOCOPY wsh_util_core.id_tab_type,
13 	x_RetStatus  		OUT NOCOPY VARCHAR2);
14 
15 
16 PROCEDURE CreateTxnHistory(p_delId IN NUMBER,
17 		           x_TxnId  OUT NOCOPY NUMBER,
18 			   x_RespNum OUT NOCOPY NUMBER,
19 			   x_DelName OUT NOCOPY VARCHAR2,
20 		           x_Status OUT NOCOPY VARCHAR2);
21 
22 PROCEDURE SendNotification(p_delivId    IN NUMBER,
23 			   p_TxnId	IN NUMBER,
24 			   p_DelName	IN VARCHAR2,
25 			   p_RespNum    IN NUMBER,
26                            x_RetSts     OUT NOCOPY VARCHAR2);
27 
28 
29 PROCEDURE PreNotification(itemtype    IN VARCHAR2,
30         		  itemkey     IN VARCHAR2,
31         		  actid       IN NUMBER,
32         		  funcmode    IN VARCHAR2,
33         		  resultout   OUT NOCOPY VARCHAR2);
34 
35 
36 PROCEDURE PostNotification(itemtype    IN VARCHAR2,
37         		   itemkey     IN VARCHAR2,
38         		   actid       IN NUMBER,
39         		   funcmode    IN VARCHAR2,
40         		   resultout   OUT NOCOPY VARCHAR2);
41 
42 
43 PROCEDURE UpdateTxnHistory(p_deliveryId IN NUMBER,
44 			   p_TxnId      IN NUMBER,
45 			   p_RevNum     IN NUMBER,
46 			   x_Status     OUT NOCOPY VARCHAR2);
47 
48 PROCEDURE ValidateDelivery(p_delivery_id   IN NUMBER,
49 			   x_return_status OUT NOCOPY VARCHAR2);
50 
51 
52 FUNCTION GetFromRole(p_UserId IN NUMBER) RETURN VARCHAR2;
53 
54 FUNCTION GetToRole(p_delivId IN NUMBER) RETURN VARCHAR2;
55 
56 FUNCTION LockDelivery(p_deliveryId IN NUMBER) RETURN BOOLEAN;
57 
58 PROCEDURE FTERRESP_SELECTOR(itemType      IN      VARCHAR2,
59                            itemKey        IN      VARCHAR2,
60                            actid          IN      NUMBER,
61                            funcmode       IN      VARCHAR2,
62                            resultout      IN OUT NOCOPY   VARCHAR2);
63 
64 PROCEDURE CheckDeliveryInfo(p_routRespNum	IN	VARCHAR2,
65 			    x_changed		OUT NOCOPY VARCHAR2);
66 
67 
68 PROCEDURE Validate_PO(p_delivery_id       	IN      NUMBER,
69         	      x_return_status         	OUT NOCOPY      VARCHAR2);
70 
71 
72 END WSH_ROUTING_RESPONSE_PKG;