[Home] [Help]
PACKAGE: APPS.OE_HEADER_SECURITY
Source
1 PACKAGE OE_Header_Security AUTHID CURRENT_USER AS
2 /* $Header: OEXXHDRS.pls 120.0.12010000.2 2009/02/11 08:50:40 haagarwa 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_HEADERS_V%ROWTYPE;
12
13 FUNCTION ACCOUNTING_RULE
14 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
15 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
16 , x_on_operation_action OUT NOCOPY NUMBER
17
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_HEADERS_V%ROWTYPE
23 , x_on_operation_action OUT NOCOPY NUMBER
24
25 ) RETURN NUMBER;
26
27 FUNCTION AGREEMENT
28 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
29 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
30 , x_on_operation_action OUT NOCOPY NUMBER
31
32 ) RETURN NUMBER;
33
34 -- Start of fix #1459428
35
36 FUNCTION ATTRIBUTE1
37 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
38 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
39 , x_on_operation_action OUT NOCOPY NUMBER
40
41 ) RETURN NUMBER;
42
43 FUNCTION ATTRIBUTE10
44 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
45 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
46 , x_on_operation_action OUT NOCOPY NUMBER
47
48 ) RETURN NUMBER;
49
50 FUNCTION ATTRIBUTE11
51 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
52 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
53 , x_on_operation_action OUT NOCOPY NUMBER
54
55 ) RETURN NUMBER;
56
57 FUNCTION ATTRIBUTE12
58 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
59 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
60 , x_on_operation_action OUT NOCOPY NUMBER
61
62 ) RETURN NUMBER;
63
64 FUNCTION ATTRIBUTE13
65 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
66 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
67 , x_on_operation_action OUT NOCOPY NUMBER
68
69 ) RETURN NUMBER;
70
71 FUNCTION ATTRIBUTE14
72 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
73 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
74 , x_on_operation_action OUT NOCOPY NUMBER
75
76 ) RETURN NUMBER;
77
78 FUNCTION ATTRIBUTE15
79 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
80 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
81 , x_on_operation_action OUT NOCOPY NUMBER
82
83 ) RETURN NUMBER;
84
85 -- For bug 2184255
86
87 FUNCTION ATTRIBUTE16
88 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
89 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
90 , x_on_operation_action OUT NOCOPY NUMBER
91
92 ) RETURN NUMBER;
93
94 FUNCTION ATTRIBUTE17
95 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
96 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
97 , x_on_operation_action OUT NOCOPY NUMBER
98
99 ) RETURN NUMBER;
100
101 FUNCTION ATTRIBUTE18
102 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
103 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
104 , x_on_operation_action OUT NOCOPY NUMBER
105
106 ) RETURN NUMBER;
107
108 FUNCTION ATTRIBUTE19
109 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
110 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
111 , x_on_operation_action OUT NOCOPY NUMBER
112
113 ) RETURN NUMBER;
114
115 FUNCTION ATTRIBUTE20
116 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
117 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
118 , x_on_operation_action OUT NOCOPY NUMBER
119
120 ) RETURN NUMBER;
121
122 FUNCTION ATTRIBUTE2
123 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
124 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
125 , x_on_operation_action OUT NOCOPY NUMBER
126
127 ) RETURN NUMBER;
128
129 FUNCTION ATTRIBUTE3
130 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
131 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
132 , x_on_operation_action OUT NOCOPY NUMBER
133
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_HEADERS_V%ROWTYPE
139 , x_on_operation_action OUT NOCOPY NUMBER
140
141 ) RETURN NUMBER;
142
143 FUNCTION ATTRIBUTE5
144 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
145 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
146 , x_on_operation_action OUT NOCOPY NUMBER
147
148 ) RETURN NUMBER;
149
150 FUNCTION ATTRIBUTE6
151 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
152 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
153 , x_on_operation_action OUT NOCOPY NUMBER
154
155 ) RETURN NUMBER;
156
157 FUNCTION ATTRIBUTE7
158 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
159 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
160 , x_on_operation_action OUT NOCOPY NUMBER
161
162 ) RETURN NUMBER;
163
164 FUNCTION ATTRIBUTE8
165 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
166 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
167 , x_on_operation_action OUT NOCOPY NUMBER
168
169 ) RETURN NUMBER;
170
171 FUNCTION ATTRIBUTE9
172 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
173 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
174 , x_on_operation_action OUT NOCOPY NUMBER
175
176 ) RETURN NUMBER;
177
178 FUNCTION CONTEXT
179 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
180 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
181 , x_on_operation_action OUT NOCOPY NUMBER
182
183 ) RETURN NUMBER;
184
185 FUNCTION CONVERSION_RATE
186 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
187 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
188 , x_on_operation_action OUT NOCOPY NUMBER
189
190 ) RETURN NUMBER;
191
192 FUNCTION CONVERSION_RATE_DATE
193 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
194 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
195 , x_on_operation_action OUT NOCOPY NUMBER
196
197 ) RETURN NUMBER;
198
199 FUNCTION CONVERSION_TYPE
200 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
201 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
202 , x_on_operation_action OUT NOCOPY NUMBER
203
204 ) RETURN NUMBER;
205
206 FUNCTION CUSTOMER_PREFERENCE_SET
207 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
208 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
209 , x_on_operation_action OUT NOCOPY NUMBER
210
211 ) RETURN NUMBER;
212
213 FUNCTION CREATED_BY
214 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
215 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
216 , x_on_operation_action OUT NOCOPY NUMBER
217
218 ) RETURN NUMBER;
219
220
221 FUNCTION CUST_PO_NUMBER
222 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
223 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
224 , x_on_operation_action OUT NOCOPY NUMBER
225
226 ) RETURN NUMBER;
227
228 FUNCTION DELIVER_TO_CONTACT
229 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
230 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
231 , x_on_operation_action OUT NOCOPY NUMBER
232
233 ) RETURN NUMBER;
234
235 FUNCTION DELIVER_TO_ORG
236 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
237 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
238 , x_on_operation_action OUT NOCOPY NUMBER
239
240 ) RETURN NUMBER;
241
242 FUNCTION DEMAND_CLASS
243 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
244 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
245 , x_on_operation_action OUT NOCOPY NUMBER
246
247 ) RETURN NUMBER;
248
249
250 FUNCTION EARLIEST_SCHEDULE_LIMIT
251 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
252 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
253 , x_on_operation_action OUT NOCOPY NUMBER
254
255 ) RETURN NUMBER;
256
257 FUNCTION FOB_POINT
258 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
259 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
260 , x_on_operation_action OUT NOCOPY NUMBER
261
262 ) RETURN NUMBER;
263
264 FUNCTION FREIGHT_CARRIER
265 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
266 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
267 , x_on_operation_action OUT NOCOPY NUMBER
268
269 ) RETURN NUMBER;
270
271 FUNCTION FREIGHT_TERMS
272 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
273 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
274 , x_on_operation_action OUT NOCOPY NUMBER
275
276 ) RETURN NUMBER;
277
278 FUNCTION INVOICE_TO_CONTACT
279 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
280 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
281 , x_on_operation_action OUT NOCOPY NUMBER
282
283 ) RETURN NUMBER;
284
285 FUNCTION INVOICE_TO_ORG
286 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
287 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
288 , x_on_operation_action OUT NOCOPY NUMBER
289
290 ) RETURN NUMBER;
291
292 FUNCTION INVOICING_RULE
293 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
294 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
295 , x_on_operation_action OUT NOCOPY NUMBER
296
297 ) RETURN NUMBER;
298
299 FUNCTION LATEST_SCHEDULE_LIMIT
300 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
301 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
302 , x_on_operation_action OUT NOCOPY NUMBER
303
304 ) RETURN NUMBER;
305
306
307 FUNCTION ORDERED_DATE
308 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
309 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
310 , x_on_operation_action OUT NOCOPY NUMBER
311
312 ) RETURN NUMBER;
313
314 FUNCTION ORDER_DATE_TYPE_CODE
315 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
316 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
317 , x_on_operation_action OUT NOCOPY NUMBER
318
319 ) RETURN NUMBER;
320
321 FUNCTION ORDER_NUMBER
322 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
323 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
324 , x_on_operation_action OUT NOCOPY NUMBER
325
326 ) RETURN NUMBER;
327
328 FUNCTION ORDER_SOURCE
329 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
330 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
331 , x_on_operation_action OUT NOCOPY NUMBER
332
333 ) RETURN NUMBER;
334
335 FUNCTION ORDER_TYPE
336 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
337 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
338 , x_on_operation_action OUT NOCOPY NUMBER
339
340 ) RETURN NUMBER;
341
342 FUNCTION ORIG_SYS_DOCUMENT_REF
343 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
344 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
345 , x_on_operation_action OUT NOCOPY NUMBER
346
347 ) RETURN NUMBER;
348
349 FUNCTION PACKING_INSTRUCTIONS
350 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
351 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
352 , x_on_operation_action OUT NOCOPY NUMBER
353
354 ) RETURN NUMBER;
355
356 FUNCTION PAYMENT_TERM
357 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
358 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
359 , x_on_operation_action OUT NOCOPY NUMBER
360
361 ) RETURN NUMBER;
362
363 FUNCTION PRICE_LIST
364 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
365 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
366 , x_on_operation_action OUT NOCOPY NUMBER
367
368 ) RETURN NUMBER;
369
370 FUNCTION PRICING_DATE
371 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
372 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
373 , x_on_operation_action OUT NOCOPY NUMBER
374
375 ) RETURN NUMBER;
376
377 FUNCTION REQUEST_DATE
378 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
379 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
380 , x_on_operation_action OUT NOCOPY NUMBER
381
382 ) RETURN NUMBER;
383
384 FUNCTION RETURN_REASON
385 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
386 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
387 , x_on_operation_action OUT NOCOPY NUMBER
388
389 ) RETURN NUMBER;
390
391 FUNCTION SALESREP
392 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
393 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
394 , x_on_operation_action OUT NOCOPY NUMBER
395
396 ) RETURN NUMBER;
397
398 FUNCTION SHIPMENT_PRIORITY
399 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
400 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
401 , x_on_operation_action OUT NOCOPY NUMBER
402
403 ) RETURN NUMBER;
404
405 FUNCTION SHIPPING_INSTRUCTIONS
406 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
407 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
408 , x_on_operation_action OUT NOCOPY NUMBER
409
410 ) RETURN NUMBER;
411
412 FUNCTION SHIPPING_METHOD
413 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
414 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
415 , x_on_operation_action OUT NOCOPY NUMBER
416
417 ) RETURN NUMBER;
418
419 FUNCTION SHIP_FROM_ORG
420 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
421 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
422 , x_on_operation_action OUT NOCOPY NUMBER
423
424 ) RETURN NUMBER;
425
426 FUNCTION SHIP_TOLERANCE_ABOVE
427 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
428 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
429 , x_on_operation_action OUT NOCOPY NUMBER
430
431 ) RETURN NUMBER;
432
433 FUNCTION SHIP_TOLERANCE_BELOW
434 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
435 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
436 , x_on_operation_action OUT NOCOPY NUMBER
437
438 ) RETURN NUMBER;
439
440 FUNCTION SHIP_TO_CONTACT
441 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
442 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
443 , x_on_operation_action OUT NOCOPY NUMBER
444
445 ) RETURN NUMBER;
446
447 FUNCTION SHIP_TO_ORG
448 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
449 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
450 , x_on_operation_action OUT NOCOPY NUMBER
451
452 ) RETURN NUMBER;
453
454 FUNCTION SOLD_TO_CONTACT
455 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
456 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
457 , x_on_operation_action OUT NOCOPY NUMBER
458
459 ) RETURN NUMBER;
460
461 FUNCTION SOLD_TO_ORG
462 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
463 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
464 , x_on_operation_action OUT NOCOPY NUMBER
465
466 ) RETURN NUMBER;
467
468 FUNCTION SOURCE_DOCUMENT_TYPE
469 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
470 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
471 , x_on_operation_action OUT NOCOPY NUMBER
472
473 ) RETURN NUMBER;
474
475 FUNCTION TAX_EXEMPT
476 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
477 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
478 , x_on_operation_action OUT NOCOPY NUMBER
479
480 ) RETURN NUMBER;
481
482 FUNCTION TAX_EXEMPT_NUMBER
483 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
484 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
485 , x_on_operation_action OUT NOCOPY NUMBER
486
487 ) RETURN NUMBER;
488
489 FUNCTION TAX_EXEMPT_REASON
490 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
491 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
492 , x_on_operation_action OUT NOCOPY NUMBER
493
494 ) RETURN NUMBER;
495
496
497 FUNCTION TRANSACTIONAL_CURR
498 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
499 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
500 , x_on_operation_action OUT NOCOPY NUMBER
501
502 ) RETURN NUMBER;
503
504 FUNCTION CREDIT_CARD_APPROVAL_DATE
505 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
506 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
507 , x_on_operation_action OUT NOCOPY NUMBER
508
509 ) RETURN NUMBER;
510
511
512 PROCEDURE Entity
513 ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type
514 , x_result OUT NOCOPY NUMBER
515
516 , x_return_status OUT NOCOPY VARCHAR2
517
518 );
519
520 PROCEDURE Attributes
521 ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type
522 , p_old_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC
523 , x_result OUT NOCOPY NUMBER
524
525 , x_return_status OUT NOCOPY VARCHAR2
526
527 );
528
529 /* The following Function is added to fix the issue #1651331 to enable
530 the Sales Channel Field be allowed to set the security rules */
531
532 FUNCTION SALES_CHANNEL_CODE
533 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
534 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
535 , x_on_operation_action OUT NOCOPY NUMBER
536
537 ) RETURN NUMBER;
538
539 /* START PREPAYMENT */
540 FUNCTION PAYMENT_TYPE
541 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
542 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
543 , x_on_operation_action OUT NOCOPY NUMBER
544
545 ) RETURN NUMBER;
546
547 FUNCTION CREDIT_CARD_HOLDER_NAME
548 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
549 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
550 , x_on_operation_action OUT NOCOPY NUMBER
551
552 ) RETURN NUMBER;
553
554 FUNCTION CREDIT_CARD
555 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
556 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
557 , x_on_operation_action OUT NOCOPY NUMBER
558
559 ) RETURN NUMBER;
560
561 FUNCTION CREDIT_CARD_NUMBER
562 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
563 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
564 , x_on_operation_action OUT NOCOPY NUMBER
565
566 ) RETURN NUMBER;
567
568 FUNCTION CREDIT_CARD_EXPIRATION_DATE
569 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
570 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
571 , x_on_operation_action OUT NOCOPY NUMBER
572
573 ) RETURN NUMBER;
574 /* END PREPAYMENT */
575
576 /* For bug 2395032 */
577 FUNCTION PAYMENT_AMOUNT
578 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
579 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
580 , x_on_operation_action OUT NOCOPY NUMBER
581
582 ) RETURN NUMBER;
583
584 FUNCTION CHECK_NUMBER
585 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
586 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
587 , x_on_operation_action OUT NOCOPY NUMBER
588
589 ) RETURN NUMBER;
590 /* End bug 2395032 */
591
592 FUNCTION BLANKET_NUMBER
593 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
594 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
595 , x_on_operation_action OUT NOCOPY NUMBER
596
597 ) RETURN NUMBER;
598
599 -- QUOTING changes
600
601 FUNCTION QUOTE_NUMBER
602 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
603 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
604 , x_on_operation_action OUT NOCOPY NUMBER
605
606 ) RETURN NUMBER;
607
608 FUNCTION QUOTE_DATE
609 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
610 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
611 , x_on_operation_action OUT NOCOPY NUMBER
612
613 ) RETURN NUMBER;
614
615 FUNCTION SALES_DOCUMENT_NAME
616 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
617 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
618 , x_on_operation_action OUT NOCOPY NUMBER
619
620 ) RETURN NUMBER;
621
622 FUNCTION TRANSACTION_PHASE
623 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
624 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
625 , x_on_operation_action OUT NOCOPY NUMBER
626
627 ) RETURN NUMBER;
628
629 FUNCTION USER_STATUS
630 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
631 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
632 , x_on_operation_action OUT NOCOPY NUMBER
633
634 ) RETURN NUMBER;
635
636 FUNCTION EXPIRATION_DATE
637 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
638 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
639 , x_on_operation_action OUT NOCOPY NUMBER
640
641 ) RETURN NUMBER;
642
643 FUNCTION VERSION_NUMBER
644 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
645 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
646 , x_on_operation_action OUT NOCOPY NUMBER
647
648 ) RETURN NUMBER;
649
650 FUNCTION SOLD_TO_SITE_USE
651 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
652 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
653 , x_on_operation_action OUT NOCOPY NUMBER
654
655 ) RETURN NUMBER;
656
657 -- QUOTING changes END
658
659 FUNCTION IB_OWNER
660 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
661 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
662 , x_on_operation_action OUT NOCOPY NUMBER
663
664 ) RETURN NUMBER;
665
666 FUNCTION IB_INSTALLED_AT_LOCATION
667 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
668 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
669 , x_on_operation_action OUT NOCOPY NUMBER
670
671 ) RETURN NUMBER;
672
673 FUNCTION IB_CURRENT_LOCATION
674 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
675 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
676 , x_on_operation_action OUT NOCOPY NUMBER
677
678 ) RETURN NUMBER;
679
680
681 FUNCTION END_CUSTOMER
682 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
683 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
684 , x_on_operation_action OUT NOCOPY NUMBER
685
686 ) RETURN NUMBER;
687
688
689 FUNCTION END_CUSTOMER_CONTACT
690 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
691 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
692 , x_on_operation_action OUT NOCOPY NUMBER
693
694 ) RETURN NUMBER;
695
696
697 FUNCTION END_CUSTOMER_SITE_USE
698 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
699 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
700 , x_on_operation_action OUT NOCOPY NUMBER
701
702 ) RETURN NUMBER;
703
704 FUNCTION Is_Op_Constrained
705 ( p_operation IN VARCHAR2
706 , p_column_name IN VARCHAR2 DEFAULT NULL
707 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
708 , x_on_operation_action OUT NOCOPY NUMBER
709
710 ) RETURN NUMBER;
711
712
713 /*---------------------------------------------------------------
714 PROCEDURE Copied_From_Quote
715 -- Used to validate the API based template - Copied From Quote
716 ----------------------------------------------------------------*/
717 PROCEDURE Copied_From_Quote
718 (p_application_id IN NUMBER
719 ,p_entity_short_name IN VARCHAR2
720 ,p_validation_entity_short_name IN VARCHAR2
721 ,p_validation_tmplt_short_name IN VARCHAR2
722 ,p_record_set_short_name IN VARCHAR2
723 ,p_scope IN VARCHAR2
724 ,x_result OUT NOCOPY NUMBER
725 );
726
727 -- Bug 8217769 New Function added for Default Fulfillment Set.
728 FUNCTION DEFAULT_FULFILLMENT_SET
729 ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
730 , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
731 , x_on_operation_action OUT NOCOPY NUMBER
732 ) RETURN NUMBER;
733 -- Bug 8217769 Function ends.
734
735 END OE_Header_Security;