[Home] [Help]
PACKAGE BODY: APPS.POS_SCO_TOLERANCE_GRP
Source
1 PACKAGE BODY POS_SCO_TOLERANCE_GRP AS
2 /* $Header: POSGTOLB.pls 120.0 2005/06/01 15:45:57 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'POS_SCO_TOLERANCE_GRP';
5 G_FILE_NAME CONSTANT VARCHAR2(30) := 'POSGTOLS.pls';
6 --g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
7
8 -- Read the profile option that enables/dISables the debug log
9 g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10
11
12 PROCEDURE INITIALIZE_TOL_VALUES(itemtype IN VARCHAR2,
13 itemkey IN VARCHAR2,
14 actid IN NUMBER,
15 funcmode IN VARCHAR2,
16 resultout OUT NOCOPY VARCHAR2)
17 IS
18 BEGIN
19
20 POS_SCO_TOLERANCE_PVT.INITIALIZE_TOL_VALUES( itemtype,
21 itemkey,
22 actid,
23 funcmode,
24 resultout);
25
26
27 END INITIALIZE_TOL_VALUES;
28
29 PROCEDURE PROMISE_DATE_WITHIN_TOL( itemtype IN VARCHAR2,
30 itemkey IN VARCHAR2,
31 actid IN NUMBER,
32 funcmode IN VARCHAR2,
33 resultout OUT NOCOPY VARCHAR2)
34 IS
35
36 BEGIN
37
38
39 POS_SCO_TOLERANCE_PVT.PROMISE_DATE_WITHIN_TOL (itemtype,
40 itemkey,
41 actid,
42 funcmode,
43 resultout );
44
45
46
47
48
49 END PROMISE_DATE_WITHIN_TOL;
50
51 PROCEDURE UNIT_PRICE_WITHIN_TOL( itemtype IN VARCHAR2,
52 itemkey IN VARCHAR2,
53 actid IN NUMBER,
54 funcmode IN VARCHAR2,
55 resultout OUT NOCOPY VARCHAR2)
56 IS
57 BEGIN
58
59
60 POS_SCO_TOLERANCE_PVT.UNIT_PRICE_WITHIN_TOL (itemtype,
61 itemkey,
62 actid,
63 funcmode,
64 resultout);
65
66
67
68 END UNIT_PRICE_WITHIN_TOL;
69
70
71 PROCEDURE SHIP_QUANTITY_WITHIN_TOL( itemtype IN VARCHAR2,
72 itemkey IN VARCHAR2,
73 actid IN NUMBER,
74 funcmode IN VARCHAR2,
75 resultout OUT NOCOPY VARCHAR2)
76 IS
77 BEGIN
78
79
80 POS_SCO_TOLERANCE_PVT.SHIP_QUANTITY_WITHIN_TOL (itemtype,
81 itemkey,
82 actid,
83 funcmode,
84 resultout);
85
86
87
88 END SHIP_QUANTITY_WITHIN_TOL ;
89
90
91
92 PROCEDURE DOC_AMOUNT_WITHIN_TOL( itemtype IN VARCHAR2,
93 itemkey IN VARCHAR2,
94 actid IN NUMBER,
95 funcmode IN VARCHAR2,
96 resultout OUT NOCOPY VARCHAR2)
97 IS
98 BEGIN
99
100
101 POS_SCO_TOLERANCE_PVT.DOC_AMOUNT_WITHIN_TOL (itemtype,
102 itemkey,
103 actid,
104 funcmode,
105 resultout);
106
107
108
109 END DOC_AMOUNT_WITHIN_TOL;
110
111 PROCEDURE LINE_AMOUNT_WITHIN_TOL( itemtype IN VARCHAR2,
112 itemkey IN VARCHAR2,
113 actid IN NUMBER,
114 funcmode IN VARCHAR2,
115 resultout OUT NOCOPY VARCHAR2)
116 IS
117 BEGIN
118
119 POS_SCO_TOLERANCE_PVT.LINE_AMOUNT_WITHIN_TOL(itemtype,
120 itemkey,
121 actid,
122 funcmode,
123 resultout);
124
125
126 END LINE_AMOUNT_WITHIN_TOL ;
127
128
129 PROCEDURE SHIP_AMOUNT_WITHIN_TOL( itemtype IN VARCHAR2,
130 itemkey IN VARCHAR2,
131 actid IN NUMBER,
132 funcmode IN VARCHAR2,
133 resultout OUT NOCOPY VARCHAR2)
134 IS
135 BEGIN
136
137
138 POS_SCO_TOLERANCE_PVT.SHIP_AMOUNT_WITHIN_TOL(itemtype,
139 itemkey,
140 actid,
141 funcmode,
142 resultout);
143
144
145
146 END SHIP_AMOUNT_WITHIN_TOl;
147
148
149
150
151 PROCEDURE ROUTE_TO_REQUESTER(itemtype IN VARCHAR2,
152 itemkey IN VARCHAR2,
153 actid IN NUMBER,
154 funcmode IN VARCHAR2,
155 resultout OUT NOCOPY VARCHAR2)
156
157 IS
158 BEGIN
159
160 POS_SCO_TOLERANCE_PVT.ROUTE_TO_REQUESTER( itemtype,
161 itemkey,
162 actid,
163 funcmode,
164 resultout);
165
166
167
168
169
170 END ROUTE_TO_REQUESTER;
171
172 PROCEDURE MARK_SCO_FOR_REQ (itemtype IN VARCHAR2,
173 itemkey IN VARCHAR2,
174 actid IN NUMBER,
175 funcmode IN VARCHAR2,
176 resultout OUT NOCOPY VARCHAR2)
177 IS
178 BEGIN
179
180
181 POS_SCO_TOLERANCE_PVT.MARK_SCO_FOR_REQ( itemtype,
182 itemkey,
183 actid,
184 funcmode,
185 resultout);
186
187
188
189
190
191 END MARK_SCO_FOR_REQ;
192
193
194 PROCEDURE ROUTE_SCO_BIZ_RULES( itemtype IN VARCHAR2,
195 itemkey IN VARCHAR2,
196 actid IN NUMBER,
197 funcmode IN VARCHAR2,
198 resultout OUT NOCOPY VARCHAR2)
199 IS
200 BEGIN
201
202
203 POS_SCO_TOLERANCE_PVT.ROUTE_SCO_BIZ_RULES(itemtype,
204 itemkey,
205 actid,
206 funcmode,
207 resultout);
208
209
210
211 END ROUTE_SCO_BIZ_RULES;
212
213
214
215 PROCEDURE AUTO_APP_BIZ_RULES( itemtype IN VARCHAR2,
216 itemkey IN VARCHAR2,
217 actid IN NUMBER,
218 funcmode IN VARCHAR2,
219 resultout OUT NOCOPY VARCHAR2)
220 IS
221 BEGIN
222
223
224 POS_SCO_TOLERANCE_PVT.AUTO_APP_BIZ_RULES(itemtype,
225 itemkey,
226 actid,
227 funcmode,
228 resultout);
229
230
231
232
233 END AUTO_APP_BIZ_RULES;
234
235
236
237 PROCEDURE PROMISE_DATE_CHANGE(itemtype IN VARCHAR2,
238 itemkey IN VARCHAR2,
239 actid IN NUMBER,
240 funcmode IN VARCHAR2,
241 resultout OUT NOCOPY VARCHAR2)
242 IS
243 BEGIN
244
245 POS_SCO_TOLERANCE_PVT.PROMISE_DATE_CHANGE(itemtype,
246 itemkey,
247 actid,
248 funcmode,
249 resultout);
250
251
252 END PROMISE_DATE_CHANGE;
253
254
255
256 PROCEDURE INITIATE_RCO_FLOW (itemtype IN VARCHAR2,
257 itemkey IN VARCHAR2,
258 actid IN NUMBER,
259 funcmode IN VARCHAR2,
260 resultout OUT NOCOPY VARCHAR2)
261 IS
262 BEGIN
263
264
265 POS_SCO_TOLERANCE_PVT.INITIATE_RCO_FLOW(itemtype,
266 itemkey,
267 actid,
268 funcmode,
269 resultout);
270
271
272
273 END INITIATE_RCO_FLOW;
274
275
276
277
278 PROCEDURE START_RCO_WORKFLOW (itemtype IN VARCHAR2,
279 itemkey IN VARCHAR2,
280 actid IN NUMBER,
281 funcmode IN VARCHAR2,
282 resultout OUT NOCOPY VARCHAR2)
283 IS
284 BEGIN
285
286
287 POS_SCO_TOLERANCE_PVT.START_RCO_WORKFLOW(itemtype,
288 itemkey,
289 actid,
290 funcmode,
291 resultout);
292
293
294 END START_RCO_WORKFLOW;
295
296 END POS_SCO_TOLERANCE_GRP;