PACKAGE: APPS.OKC_XPRT_CUSTOM_PACKAGE

Source

1 PACKAGE OKC_XPRT_CUSTOM_PACKAGE AS
2 /* $Header: okcxprtudvtestprocs.pls 120.0 2007/03/23 16:17:33 jkodiyan noship $ */
3 
4     PROCEDURE GET_OE_HEADER_VALUES (
5         P_DOC_TYPE		     IN VARCHAR2,
6         P_DOC_ID		     IN NUMBER,
7 	    P_VARIABLE_CODE		IN VARCHAR2,
8 	    X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
9         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
10         X_MSG_COUNT		     OUT NOCOPY NUMBER,
11         X_MSG_DATA		     OUT NOCOPY VARCHAR2
12 	);
13 
14     PROCEDURE GET_PRICE_UPDATE_TOLERANCE (
15         P_DOC_TYPE		     IN VARCHAR2,
16         P_DOC_ID		     IN NUMBER,
17 	    P_VARIABLE_CODE		IN VARCHAR2,
18     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
19         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
20         X_MSG_COUNT		     OUT NOCOPY NUMBER,
21         X_MSG_DATA		     OUT NOCOPY VARCHAR2
22 	);
23 
24 	PROCEDURE GET_QUOTE_SALES_SUPPLEMENT (
25         P_DOC_TYPE		     IN VARCHAR2,
26         P_DOC_ID		     IN NUMBER,
27 	    P_VARIABLE_CODE		IN VARCHAR2,
28     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
29         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
30         X_MSG_COUNT		     OUT NOCOPY NUMBER,
31         X_MSG_DATA		     OUT NOCOPY VARCHAR2
32 	);
33 
34 	        PROCEDURE GET_SHIP_WAREHOUSE (
35         P_DOC_TYPE		     IN VARCHAR2,
36         P_DOC_ID		     IN NUMBER,
37 	    P_VARIABLE_CODE			IN VARCHAR2,
38     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
39         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
40         X_MSG_COUNT		     OUT NOCOPY NUMBER,
41         X_MSG_DATA		     OUT NOCOPY VARCHAR2
42 	);
43 
44         PROCEDURE GET_SOURCING_UOM (
45         P_DOC_TYPE		     IN VARCHAR2,
46         P_DOC_ID		     IN NUMBER,
47 	    P_VARIABLE_CODE			IN VARCHAR2,
48     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
49         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
50         X_MSG_COUNT		     OUT NOCOPY NUMBER,
51         X_MSG_DATA		     OUT NOCOPY VARCHAR2
52 	);
53 
54 	       PROCEDURE GET_PO_UOM (
55         P_DOC_TYPE		     IN VARCHAR2,
56         P_DOC_ID		     IN NUMBER,
57 	    P_VARIABLE_CODE			IN VARCHAR2,
58     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
59         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
60         X_MSG_COUNT		     OUT NOCOPY NUMBER,
61         X_MSG_DATA		     OUT NOCOPY VARCHAR2
62 	);
63 
64        PROCEDURE GET_RELEASE_RATIO (
65         P_DOC_TYPE		     IN VARCHAR2,
66         P_DOC_ID		     IN NUMBER,
67 	    P_VARIABLE_CODE			IN VARCHAR2,
68     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
69         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
70         X_MSG_COUNT		     OUT NOCOPY NUMBER,
71         X_MSG_DATA		     OUT NOCOPY VARCHAR2
72 	);
73 
74 	           PROCEDURE GET_BLANKET_AMOUNT_RANGE (
75         P_DOC_TYPE		     IN VARCHAR2,
76         P_DOC_ID		     IN NUMBER,
77 	    P_VARIABLE_CODE			IN VARCHAR2,
78     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
79         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
80         X_MSG_COUNT		     OUT NOCOPY NUMBER,
81         X_MSG_DATA		     OUT NOCOPY VARCHAR2
82 	);
83 
84            PROCEDURE GET_DFF_PO (
85         P_DOC_TYPE		     IN VARCHAR2,
86         P_DOC_ID		     IN NUMBER,
87 	    P_VARIABLE_CODE			IN VARCHAR2,
88     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
89         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
90         X_MSG_COUNT		     OUT NOCOPY NUMBER,
91         X_MSG_DATA		     OUT NOCOPY VARCHAR2
92 	);
93 
94            PROCEDURE GET_DFF_SA (
95         P_DOC_TYPE		     IN VARCHAR2,
96         P_DOC_ID		     IN NUMBER,
97 	    P_VARIABLE_CODE			IN VARCHAR2,
98     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
99         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
100         X_MSG_COUNT		     OUT NOCOPY NUMBER,
101         X_MSG_DATA		     OUT NOCOPY VARCHAR2
102 	);
103 
104 
105 
106 END OKC_XPRT_CUSTOM_PACKAGE;