[Home] [Help]
PACKAGE: APPS.OE_LINE_SECURITY
Source
1 PACKAGE OE_Line_Security AUTHID CURRENT_USER AS
2 /* $Header: OEXXLINS.pls 120.7.12020000.2 2012/07/20 10:00:54 ckasera ship $ */
3
4
5 -- Package Globals
6 g_check_all_cols_constraint VARCHAR2(1) := 'Y';
7 g_is_caller_defaulting VARCHAR2(1) := 'N';
8 -- Entity global record that is used in APIs for validation templates
9 -- and the generated validation packages to access attribute values
10 -- on the entity record
11 g_record OE_AK_ORDER_LINES_V%ROWTYPE;
12 g_operation_action NUMBER;
13
14 FUNCTION ACCOUNTING_RULE
15 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
16 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
17 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
18 ) RETURN NUMBER;
19
20 FUNCTION ACCOUNTING_RULE_DURATION
21 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
22 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
23 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
24 ) RETURN NUMBER;
25
26 FUNCTION calculate_price_flag(p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
27 ,p_record IN oe_ak_order_lines_v%ROWTYPE
28 ,x_on_operation_action OUT NOCOPY NUMBER)
29 RETURN NUMBER;
30
31 FUNCTION COMMITMENT_ID
32 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
33 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
34 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
35 ) RETURN NUMBER;
36
37 FUNCTION AGREEMENT
38 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
39 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
40 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
41 ) RETURN NUMBER;
42
43 FUNCTION AUTHORIZED_TO_SHIP
44 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
45 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
46 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
47 ) RETURN NUMBER;
48
49 -- Start of fix #1459428
50
51 FUNCTION ATTRIBUTE1
52 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
53 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
54 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
55 ) RETURN NUMBER;
56
57 FUNCTION ATTRIBUTE10
58 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
59 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
60 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
61 ) RETURN NUMBER;
62
63 FUNCTION ATTRIBUTE11
64 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
65 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
66 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
67 ) RETURN NUMBER;
68
69 FUNCTION ATTRIBUTE12
70 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
71 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
72 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
73 ) RETURN NUMBER;
74
75 FUNCTION ATTRIBUTE13
76 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
77 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
78 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
79 ) RETURN NUMBER;
80
81 FUNCTION ATTRIBUTE14
82 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
83 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
84 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
85 ) RETURN NUMBER;
86
87 FUNCTION ATTRIBUTE15
88 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
89 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
90 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
91 ) RETURN NUMBER;
92
93 -- For bug 2184255
94 FUNCTION ATTRIBUTE16
95 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
96 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
97 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
98 ) RETURN NUMBER;
99
100 FUNCTION ATTRIBUTE17
101 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
102 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
103 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
104 ) RETURN NUMBER;
105
106 FUNCTION ATTRIBUTE18
107 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
108 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
109 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
110 ) RETURN NUMBER;
111
112 FUNCTION ATTRIBUTE19
113 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
114 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
115 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
116 ) RETURN NUMBER;
117
118 FUNCTION ATTRIBUTE2
119 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
120 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
121 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
122 ) RETURN NUMBER;
123
124 FUNCTION ATTRIBUTE20
125 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
126 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
127 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
128 ) RETURN NUMBER;
129
130 FUNCTION ATTRIBUTE3
131 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
132 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
133 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
134 ) RETURN NUMBER;
135
136 FUNCTION ATTRIBUTE4
137 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
138 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
139 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
140 ) RETURN NUMBER;
141
142 FUNCTION ATTRIBUTE5
143 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
144 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
145 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
146 ) RETURN NUMBER;
147
148 FUNCTION ATTRIBUTE6
149 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
150 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
151 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
152 ) RETURN NUMBER;
153
154 FUNCTION ATTRIBUTE7
155 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
156 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
157 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
158 ) RETURN NUMBER;
159
160 FUNCTION ATTRIBUTE8
161 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
162 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
163 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
164 ) RETURN NUMBER;
165
166 FUNCTION ATTRIBUTE9
167 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
168 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
169 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
170 ) RETURN NUMBER;
171
172 FUNCTION CONTEXT
173 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
174 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
175 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
176 ) RETURN NUMBER;
177
178 ---START bug 14272033
179 FUNCTION RETURN_CONTEXT
180 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
181 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
182 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
183 ) RETURN NUMBER;
184
185
186 FUNCTION RETURN_ATTRIBUTE1
187 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
188 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
189 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
190 ) RETURN NUMBER;
191
192 FUNCTION RETURN_ATTRIBUTE2
193 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
194 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
195 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
196 ) RETURN NUMBER;
197 ----END bug 14272033
198
199 -- End of fix #1459428
200
201 FUNCTION CREATED_BY
202 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
203 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
204 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
205 ) RETURN NUMBER;
206
207
208 FUNCTION CREDIT_INVOICE_LINE
209 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
213
210 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
211 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
212 ) RETURN NUMBER;
214
215 FUNCTION CUSTOMER_LINE_NUMBER
216 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
217 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
218 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
219 ) RETURN NUMBER;
220
221
222 FUNCTION CUSTOMER_TRX_LINE
223 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
224 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
225 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
226 ) RETURN NUMBER;
227
228
229 FUNCTION CUST_PO_NUMBER
230 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
231 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
232 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
233 ) RETURN NUMBER;
234
235 -- Added for bug #7608170
236 FUNCTION CUSTOMER_JOB
237 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
238 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
239 , x_on_operation_action OUT NOCOPY NUMBER
240 ) RETURN NUMBER;
241
242 FUNCTION DELIVERY_LEAD_TIME
243 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
244 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
245 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
246 ) RETURN NUMBER;
247
248 FUNCTION DELIVER_TO_CONTACT
249 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
250 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
251 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
252 ) RETURN NUMBER;
253
254
255 FUNCTION DELIVER_TO_ORG
256 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
257 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
258 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
259 ) RETURN NUMBER;
260
261
262 FUNCTION DEMAND_CLASS
263 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
264 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
265 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
266 ) RETURN NUMBER;
267
268 FUNCTION DEP_PLAN_REQUIRED
269 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
270 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
271 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
272 ) RETURN NUMBER;
273
274 FUNCTION EARLIEST_ACCEPTABLE_DATE
275 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
276 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
277 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
278 ) RETURN NUMBER;
279
280 FUNCTION END_ITEM_UNIT_NUMBER
281 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
282 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
283 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
284 ) RETURN NUMBER;
285
286
287 FUNCTION FOB_POINT
288 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
289 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
290 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
291 ) RETURN NUMBER;
292
293 FUNCTION FREIGHT_CARRIER
294 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
295 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
296 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
297 ) RETURN NUMBER;
298
299 FUNCTION FREIGHT_TERMS
300 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
301 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
302 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
303 ) RETURN NUMBER;
304
305 FUNCTION FULFILLED_QUANTITY
306 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
307 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
308 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
309 ) RETURN NUMBER;
310
311
312 FUNCTION INVENTORY_ITEM
313 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
314 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
315 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
316 ) RETURN NUMBER;
317
318 FUNCTION INVOICE_TO_CONTACT
319 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
320 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
321 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
322 ) RETURN NUMBER;
323
324 FUNCTION INVOICE_TO_ORG
325 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
326 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
327 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
328 ) RETURN NUMBER;
329
330 FUNCTION INVOICING_RULE
331 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
332 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
333 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
334 ) RETURN NUMBER;
335
336 FUNCTION ITEM_REVISION
340 ) RETURN NUMBER;
337 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
338 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
339 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
341
342 FUNCTION ITEM_TYPE
343 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
344 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
345 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
346 ) RETURN NUMBER;
347
348
349 FUNCTION LATEST_ACCEPTABLE_DATE
350 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
351 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
352 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
353 ) RETURN NUMBER;
354
355 FUNCTION LINE_CATEGORY
356 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
357 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
358 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
359 ) RETURN NUMBER;
360
361 FUNCTION LINE_NUMBER
362 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
363 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
364 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
365 ) RETURN NUMBER;
366
367 FUNCTION LINE_TYPE
368 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
369 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
370 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
371 ) RETURN NUMBER;
372
373
374 FUNCTION ORDERED_QUANTITY
375 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
376 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
377 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
378 ) RETURN NUMBER;
379
380 -- OPM 1857167 start
381
382 FUNCTION ORDERED_QUANTITY2
383 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
384 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
385 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
386 ) RETURN NUMBER;
387
388 -- OPM 1857167 end
389
390 FUNCTION ORDER_QUANTITY_UOM
391 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
392 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
393 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
394 ) RETURN NUMBER;
395
396 FUNCTION ORIG_SYS_DOCUMENT_REF
397 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
398 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
399 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
400 ) RETURN NUMBER;
401
402 FUNCTION ORIG_SYS_LINE_REF
403 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
404 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
405 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
406 ) RETURN NUMBER;
407
408 FUNCTION OVER_SHIP_REASON
409 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
410 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
411 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
412 ) RETURN NUMBER;
413
414 FUNCTION OVER_SHIP_RESOLVED
415 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
416 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
417 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
418 ) RETURN NUMBER;
419
420 FUNCTION PACKING_INSTRUCTIONS
421 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
422 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
423 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
424 ) RETURN NUMBER;
425
426 FUNCTION PAYMENT_TERM
427 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
428 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
429 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
430 ) RETURN NUMBER;
431
432 FUNCTION PLANNING_PRIORITY
433 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
434 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
435 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
436 ) RETURN NUMBER;
437
438 FUNCTION PRICE_LIST
439 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
440 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
441 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
442 ) RETURN NUMBER;
443
444 FUNCTION PRICING_DATE
445 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
446 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
447 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
448 ) RETURN NUMBER;
449
450 FUNCTION PRICING_QUANTITY
451 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
452 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
453 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
454 ) RETURN NUMBER;
455
456 FUNCTION PRICING_QUANTITY_UOM
457 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
458 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
462 FUNCTION PROJECT
459 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
460 ) RETURN NUMBER;
461
463 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
464 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
465 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
466 ) RETURN NUMBER;
467
468 FUNCTION PROMISE_DATE
469 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
470 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
471 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
472 ) RETURN NUMBER;
473
474 FUNCTION REFERENCE_CUST_TRX_LINE
475 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
476 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
477 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
478 ) RETURN NUMBER;
479
480 FUNCTION REFERENCE_TYPE
481 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
482 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
483 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
484 ) RETURN NUMBER;
485
486 FUNCTION REQUEST_DATE
487 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
488 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
489 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
490 ) RETURN NUMBER;
491
492 FUNCTION RETURN_REASON
493 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
494 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
495 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
496 ) RETURN NUMBER;
497
498 FUNCTION SALESREP
499 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
500 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
501 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
502 ) RETURN NUMBER;
503
504 FUNCTION SHIP_SET
505 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
506 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
507 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
508 ) RETURN NUMBER;
509
510 FUNCTION ARRIVAL_SET
511 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
512 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
513 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
514 ) RETURN NUMBER;
515
516
517 FUNCTION SCHEDULE_ARRIVAL_DATE
518 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
519 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
520 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
521 ) RETURN NUMBER;
522
523 FUNCTION SCHEDULE_SHIP_DATE
524 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
525 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
526 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
527 ) RETURN NUMBER;
528
529
530 FUNCTION SHIPMENT_NUMBER
531 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
532 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
533 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
534 ) RETURN NUMBER;
535
536 FUNCTION SHIPMENT_PRIORITY
537 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
538 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
539 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
540 ) RETURN NUMBER;
541
542 FUNCTION SHIPPED_QUANTITY
543 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
544 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
545 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
546 ) RETURN NUMBER;
547
548 FUNCTION SHIPPING_INSTRUCTIONS
549 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
550 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
551 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
552 ) RETURN NUMBER;
553
554 FUNCTION SHIPPING_METHOD
555 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
556 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
557 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
558 ) RETURN NUMBER;
559
560 FUNCTION SHIPPING_QUANTITY
561 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
562 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
563 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
564 ) RETURN NUMBER;
565
566 FUNCTION SHIPPING_QUANTITY_UOM
567 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
568 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
569 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
570 ) RETURN NUMBER;
571
572 FUNCTION SHIPPING_QUANTITY_UOM2 -- INVCONV
573 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
574 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
575 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
576 ) RETURN NUMBER;
580 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
577
578 FUNCTION SHIP_FROM_ORG
579 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
581 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
582 ) RETURN NUMBER;
583
584 FUNCTION SUBINVENTORY
585 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
586 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
587 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
588 ) RETURN NUMBER;
589
590 FUNCTION SHIP_MODEL_COMPLETE
591 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
592 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
593 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
594 ) RETURN NUMBER;
595
596 FUNCTION SHIP_TOLERANCE_ABOVE
597 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
598 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
599 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
600 ) RETURN NUMBER;
601
602 FUNCTION SHIP_TOLERANCE_BELOW
603 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
604 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
605 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
606 ) RETURN NUMBER;
607
608 FUNCTION SHIP_TO_CONTACT
609 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
610 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
611 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
612 ) RETURN NUMBER;
613
614 FUNCTION SHIP_TO_ORG
615 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
616 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
617 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
618 ) RETURN NUMBER;
619
620 FUNCTION SOLD_TO_ORG
621 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
622 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
623 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
624 ) RETURN NUMBER;
625
626 FUNCTION SOURCE_DOCUMENT_TYPE
627 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
628 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
629 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
630 ) RETURN NUMBER;
631
632 FUNCTION SOURCE_TYPE
633 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
634 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
635 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
636 ) RETURN NUMBER;
637
638 FUNCTION TASK
639 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
640 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
641 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
642 ) RETURN NUMBER;
643
644 FUNCTION TAX
645 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
646 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
647 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
648 ) RETURN NUMBER;
649
650 FUNCTION TAX_DATE
651 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
652 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
653 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
654 ) RETURN NUMBER;
655
656 FUNCTION TAX_EXEMPT
657 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
658 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
659 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
660 ) RETURN NUMBER;
661
662 FUNCTION TAX_EXEMPT_NUMBER
663 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
664 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
665 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
666 ) RETURN NUMBER;
667
668 FUNCTION TAX_EXEMPT_REASON
669 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
670 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
671 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
672 ) RETURN NUMBER;
673
674 FUNCTION UNIT_LIST_PRICE
675 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
676 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
677 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
678 ) RETURN NUMBER;
679
680 FUNCTION UNIT_SELLING_PRICE
681 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
682 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
683 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
684 ) RETURN NUMBER;
685
686
687 FUNCTION SERVICE_REFERENCE_TYPE
688 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
689 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
690 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
691 ) RETURN NUMBER;
692
693 FUNCTION SERVICE_REFERENCE_LINE
694 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
695 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
696 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
697 ) RETURN NUMBER;
698
702 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
699 FUNCTION SERVICE_REFERENCE_SYSTEM
700 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
701 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
703 ) RETURN NUMBER;
704
705 /* Fix to bug 2205900: Added constraints functions for
706 some missing SERVICE fields */
707 FUNCTION SERVICE_COTERMINATE
708 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
709 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
710 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
711 ) RETURN NUMBER;
712
713 FUNCTION SERVICE_DURATION
714 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
715 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
716 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
717 ) RETURN NUMBER;
718
719 FUNCTION SERVICE_END_DATE
720 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
721 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
722 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
723 ) RETURN NUMBER;
724
725 FUNCTION SERVICE_PERIOD
726 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
727 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
728 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
729 ) RETURN NUMBER;
730
731 FUNCTION SERVICE_START_DATE
732 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
733 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
734 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
735 ) RETURN NUMBER;
736
737 FUNCTION SERVICE_TXN_COMMENTS
738 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
739 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
740 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
741 ) RETURN NUMBER;
742
743 FUNCTION SERVICE_TXN_REASON
744 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
745 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
746 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
747 ) RETURN NUMBER;
748
749 /*1449220*/
750 FUNCTION ITEM_IDENTIFIER_TYPE
751 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
752 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
753 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
754 ) RETURN NUMBER;
755 /*1449220*/
756
757 FUNCTION USER_ITEM_DESCRIPTION
758 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
759 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
760 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
761 ) RETURN NUMBER;
762
763 FUNCTION BLANKET_NUMBER
764 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
765 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
766 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
767 ) RETURN NUMBER;
768
769 FUNCTION BLANKET_LINE_NUMBER
770 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
771 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
772 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
773 ) RETURN NUMBER;
774
775 FUNCTION IB_OWNER
776 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
777 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
778 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
779 ) RETURN NUMBER;
780
781 FUNCTION IB_INSTALLED_AT_LOCATION
782 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
783 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
784 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
785 ) RETURN NUMBER;
786
787 FUNCTION IB_CURRENT_LOCATION
788 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
789 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
790 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
791 ) RETURN NUMBER;
792
793
794 FUNCTION END_CUSTOMER
795 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
796 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
797 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
798
799 ) RETURN NUMBER;
800
801
802 FUNCTION END_CUSTOMER_CONTACT
803 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
804 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
805 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
806
807 ) RETURN NUMBER;
808
809
810 FUNCTION END_CUSTOMER_SITE_USE
811 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
812 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
813 , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
814
815 ) RETURN NUMBER;
816
817 PROCEDURE ALLOW_TAX_CODE_OVERRIDE
818 ( p_application_id IN NUMBER,
819 p_entity_short_name IN VARCHAR2,
820 p_validation_entity_short_name IN VARCHAR2,
821 p_validation_tmplt_short_name IN VARCHAR2,
822 p_record_set_tmplt_short_name IN VARCHAR2,
823 p_scope IN VARCHAR2,
824 p_result OUT NOCOPY NUMBER /* file.sql.39 change */
825 );
826
827 PROCEDURE ALLOW_TRX_LINE_EXEMPTIONS
828 ( p_application_id IN NUMBER,
829 p_entity_short_name IN VARCHAR2,
830 p_validation_entity_short_name IN VARCHAR2,
831 p_validation_tmplt_short_name IN VARCHAR2,
832 p_record_set_tmplt_short_name IN VARCHAR2,
833 p_scope IN VARCHAR2,
834 p_result OUT NOCOPY NUMBER /* file.sql.39 change */
835 );
836
837 PROCEDURE Entity
838 ( p_LINE_rec IN OE_Order_PUB.LINE_Rec_Type
839 , x_result OUT NOCOPY NUMBER /* file.sql.39 change */
840 , x_return_status OUT NOCOPY VARCHAR2 /* file.sql.39 change */
841 );
842
843 PROCEDURE Attributes
844 ( p_LINE_rec IN OE_Order_PUB.LINE_Rec_Type
845 , p_old_LINE_rec IN OE_Order_PUB.LINE_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
846 , x_result OUT NOCOPY NUMBER /* file.sql.39 change */
847 , x_return_status OUT NOCOPY VARCHAR2 /* file.sql.39 change */
848 );
849
850 FUNCTION CONTINGENCY
851 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
852 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
853 , x_on_operation_action OUT NOCOPY NUMBER
854 ) RETURN NUMBER;
855
856 FUNCTION REVREC_EXPIRATION_DAYS
857 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
858 , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
859 , x_on_operation_action OUT NOCOPY NUMBER
860 ) RETURN NUMBER;
861
862 END OE_Line_Security;