eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.OKC_XPRT_CUSTOM_INV_PACKAGE

Source


1 PACKAGE BODY OKC_XPRT_CUSTOM_INV_PACKAGE AS
2 /* $Header: okcxprtudvtestinvprocb.pls 120.2 2007/12/12 13:43:10 harchand noship $ */
3 
4 
5     G_RET_STS_SUCCESS            CONSTANT   varchar2(1) := FND_API.G_RET_STS_SUCCESS;
6     G_RET_STS_ERROR              CONSTANT   varchar2(1) := FND_API.G_RET_STS_ERROR;
7     G_RET_STS_UNEXP_ERROR        CONSTANT   varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
8 
9 
10 
11     PROCEDURE GET_OE_HEADER_VALUES (
12         P_DOC_TYPE		     IN VARCHAR2,
13         P_DOC_ID		     IN NUMBER,
14 	   P_VARIABLE_CODE		IN VARCHAR2,
15 	   X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
16         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
17         X_MSG_COUNT		     OUT NOCOPY NUMBER,
18         X_MSG_DATA		     OUT NOCOPY VARCHAR2
19 	)
20     IS
21 
22 
23     BEGIN
24 
25 
26 	x_return_status := G_RET_STS_SUCCESS;
27 
28 
29 
30     END GET_OE_HEADER_VALUES;
31 
32 
33     PROCEDURE GET_PRICE_UPDATE_TOLERANCE (
34         P_DOC_TYPE		     IN VARCHAR2,
35         P_DOC_ID		     IN NUMBER,
36 	    P_VARIABLE_CODE			IN VARCHAR2,
37     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
38         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
39         X_MSG_COUNT		     OUT NOCOPY NUMBER,
40         X_MSG_DATA		     OUT NOCOPY VARCHAR2
41 	)
42     IS
43 
44 
45 
46     BEGIN
47 
48 
49 
50 	x_return_status := G_RET_STS_SUCCESS;
51 
52 
53 
54 
55     END GET_PRICE_UPDATE_TOLERANCE;
56 
57     PROCEDURE GET_QUOTE_SALES_SUPPLEMENT (
58         P_DOC_TYPE		     IN VARCHAR2,
59         P_DOC_ID		     IN NUMBER,
60 	    P_VARIABLE_CODE		 IN VARCHAR2,
61     	X_VARIABLE_VALUE_ID	 IN OUT NOCOPY VARCHAR2,
62         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
63         X_MSG_COUNT		     OUT NOCOPY NUMBER,
64         X_MSG_DATA		     OUT NOCOPY VARCHAR2
65 	)
66     IS
67 
68 
69 
70     BEGIN
71 
72 
73 
74 
75 	x_return_status := G_RET_STS_SUCCESS;
76 
77 
78 
79     END GET_QUOTE_SALES_SUPPLEMENT;
80 
81         PROCEDURE GET_SHIP_WAREHOUSE (
82         P_DOC_TYPE		     IN VARCHAR2,
83         P_DOC_ID		     IN NUMBER,
84 	    P_VARIABLE_CODE			IN VARCHAR2,
85     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
86         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
87         X_MSG_COUNT		     OUT NOCOPY NUMBER,
88         X_MSG_DATA		     OUT NOCOPY VARCHAR2
89 	)
90     IS
91     BEGIN
92 	x_return_status := G_RET_STS_SUCCESS;
93     END GET_SHIP_WAREHOUSE;
94 
95     PROCEDURE GET_SOURCING_UOM (
96         P_DOC_TYPE		     IN VARCHAR2,
97         P_DOC_ID		     IN NUMBER,
98 	    P_VARIABLE_CODE			IN VARCHAR2,
99     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
100         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
101         X_MSG_COUNT		     OUT NOCOPY NUMBER,
102         X_MSG_DATA		     OUT NOCOPY VARCHAR2
103 	)
104     IS
105 
106 
107 
108     BEGIN
109 
110 
111 
112 	x_return_status := G_RET_STS_SUCCESS;
113 
114 
115 
116 
117     END GET_SOURCING_UOM;
118 
119        PROCEDURE GET_PO_UOM (
120         P_DOC_TYPE		     IN VARCHAR2,
121         P_DOC_ID		     IN NUMBER,
122 	    P_VARIABLE_CODE			IN VARCHAR2,
123     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
124         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
125         X_MSG_COUNT		     OUT NOCOPY NUMBER,
126         X_MSG_DATA		     OUT NOCOPY VARCHAR2
127 	)
128     IS
129 
130 
131 
132     BEGIN
133 
134 
135 
136 	x_return_status := G_RET_STS_SUCCESS;
137 
138 
139 
140 
141     END GET_PO_UOM;
142 
143        PROCEDURE GET_RELEASE_RATIO (
144         P_DOC_TYPE		     IN VARCHAR2,
145         P_DOC_ID		     IN NUMBER,
146 	    P_VARIABLE_CODE			IN VARCHAR2,
147     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
148         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
149         X_MSG_COUNT		     OUT NOCOPY NUMBER,
150         X_MSG_DATA		     OUT NOCOPY VARCHAR2
151 	)
152     IS
153 
154 
155 
156     BEGIN
157 
158 
159 	x_return_status := G_RET_STS_SUCCESS;
160 
161 
162 
163     END GET_RELEASE_RATIO;
164 
165     PROCEDURE GET_BLANKET_AMOUNT_RANGE (
166         P_DOC_TYPE		     IN VARCHAR2,
167         P_DOC_ID		     IN NUMBER,
168 	    P_VARIABLE_CODE			IN VARCHAR2,
169     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
170         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
171         X_MSG_COUNT		     OUT NOCOPY NUMBER,
172         X_MSG_DATA		     OUT NOCOPY VARCHAR2
173 	)
174     IS
175 
176 
177 
178     BEGIN
179 
180 
181 
182 	x_return_status := G_RET_STS_SUCCESS;
183 
184 
185 
186     END GET_BLANKET_AMOUNT_RANGE;
187 
188     PROCEDURE GET_DFF_PO (
189         P_DOC_TYPE		     IN VARCHAR2,
190         P_DOC_ID		     IN NUMBER,
191 	    P_VARIABLE_CODE			IN VARCHAR2,
192     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
193         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
194         X_MSG_COUNT		     OUT NOCOPY NUMBER,
195         X_MSG_DATA		     OUT NOCOPY VARCHAR2
196 	)
197     IS
198 
199 
200 
201     BEGIN
202 
203 
204 
205 	x_return_status := G_RET_STS_SUCCESS;
206 
207 
208 
209     END GET_DFF_PO;
210 
211     PROCEDURE GET_DFF_SA (
212         P_DOC_TYPE		     IN VARCHAR2,
213         P_DOC_ID		     IN NUMBER,
214 	    P_VARIABLE_CODE			IN VARCHAR2,
215     	X_VARIABLE_VALUE_ID	IN OUT NOCOPY VARCHAR2,
216         X_RETURN_STATUS	     OUT NOCOPY VARCHAR2,
217         X_MSG_COUNT		     OUT NOCOPY NUMBER,
218         X_MSG_DATA		     OUT NOCOPY VARCHAR2
219 	)
220     IS
221 
222 
223 
224 
225     BEGIN
226 
227 
228 
229 	x_return_status := G_RET_STS_SUCCESS;
230 
231 
232 
233     END GET_DFF_SA;
234 
235 END OKC_XPRT_CUSTOM_INV_PACKAGE;
236