DBA Data[Home] [Help]

APPS.OE_HEADER_PAYMENT_SECURITY dependencies on OE_AK_HEADER_PAYMENTS_V

Line 16: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

12:
13: FUNCTION Is_Op_Constrained
14: ( p_operation IN VARCHAR2
15: , p_column_name IN VARCHAR2 DEFAULT NULL
16: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
17: , x_on_operation_action OUT NOCOPY NUMBER
18:
19: ) RETURN NUMBER IS
20: l_constraint_id NUMBER;

Line 93: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

89: -- Start of fix #1459428 for function definition
90:
91: FUNCTION ATTRIBUTE1
92: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
93: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
94: , x_on_operation_action OUT NOCOPY NUMBER
95:
96: ) RETURN NUMBER
97: IS

Line 118: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

114:
115:
116: FUNCTION ATTRIBUTE10
117: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
118: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
119: , x_on_operation_action OUT NOCOPY NUMBER
120:
121: ) RETURN NUMBER
122: IS

Line 143: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

139:
140:
141: FUNCTION ATTRIBUTE11
142: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
143: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
144: , x_on_operation_action OUT NOCOPY NUMBER
145:
146: ) RETURN NUMBER
147: IS

Line 168: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

164:
165:
166: FUNCTION ATTRIBUTE12
167: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
168: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
169: , x_on_operation_action OUT NOCOPY NUMBER
170:
171: ) RETURN NUMBER
172: IS

Line 193: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

189:
190:
191: FUNCTION ATTRIBUTE13
192: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
193: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
194: , x_on_operation_action OUT NOCOPY NUMBER
195:
196: ) RETURN NUMBER
197: IS

Line 218: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

214:
215:
216: FUNCTION ATTRIBUTE14
217: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
218: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
219: , x_on_operation_action OUT NOCOPY NUMBER
220:
221: ) RETURN NUMBER
222: IS

Line 243: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

239:
240:
241: FUNCTION ATTRIBUTE15
242: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
243: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
244: , x_on_operation_action OUT NOCOPY NUMBER
245:
246: ) RETURN NUMBER
247: IS

Line 268: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

264:
265:
266: FUNCTION ATTRIBUTE2
267: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
268: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
269: , x_on_operation_action OUT NOCOPY NUMBER
270:
271: ) RETURN NUMBER
272: IS

Line 293: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

289:
290:
291: FUNCTION ATTRIBUTE3
292: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
293: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
294: , x_on_operation_action OUT NOCOPY NUMBER
295:
296: ) RETURN NUMBER
297: IS

Line 318: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

314:
315:
316: FUNCTION ATTRIBUTE4
317: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
318: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
319: , x_on_operation_action OUT NOCOPY NUMBER
320:
321: ) RETURN NUMBER
322: IS

Line 343: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

339:
340:
341: FUNCTION ATTRIBUTE5
342: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
343: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
344: , x_on_operation_action OUT NOCOPY NUMBER
345:
346: ) RETURN NUMBER
347: IS

Line 368: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

364:
365:
366: FUNCTION ATTRIBUTE6
367: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
368: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
369: , x_on_operation_action OUT NOCOPY NUMBER
370:
371: ) RETURN NUMBER
372: IS

Line 393: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

389:
390:
391: FUNCTION ATTRIBUTE7
392: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
393: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
394: , x_on_operation_action OUT NOCOPY NUMBER
395:
396: ) RETURN NUMBER
397: IS

Line 418: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

414:
415:
416: FUNCTION ATTRIBUTE8
417: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
418: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
419: , x_on_operation_action OUT NOCOPY NUMBER
420:
421: ) RETURN NUMBER
422: IS

Line 443: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

439:
440:
441: FUNCTION ATTRIBUTE9
442: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
443: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
444: , x_on_operation_action OUT NOCOPY NUMBER
445:
446: ) RETURN NUMBER
447: IS

Line 468: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

464:
465:
466: FUNCTION CONTEXT
467: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
468: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
469: , x_on_operation_action OUT NOCOPY NUMBER
470:
471: ) RETURN NUMBER
472: IS

Line 494: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

490: -- End of fix #1459428 for function definition
491:
492: FUNCTION CREATED_BY
493: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
494: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
495: , x_on_operation_action OUT NOCOPY NUMBER
496:
497: ) RETURN NUMBER
498: IS

Line 519: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

515:
516:
517: FUNCTION PAYMENT_LEVEL_CODE
518: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
519: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
520: , x_on_operation_action OUT NOCOPY NUMBER
521:
522: ) RETURN NUMBER
523: IS

Line 544: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

540:
541:
542: FUNCTION PAYMENT_TYPE_CODE
543: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
544: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
545: , x_on_operation_action OUT NOCOPY NUMBER
546:
547: ) RETURN NUMBER
548: IS

Line 570: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

566:
567:
568: FUNCTION PAYMENT_TRX
569: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
570: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
571: , x_on_operation_action OUT NOCOPY NUMBER
572:
573: ) RETURN NUMBER
574: IS

Line 594: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

590: END PAYMENT_TRX;
591:
592: FUNCTION RECEIPT_METHOD
593: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
594: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
595: , x_on_operation_action OUT NOCOPY NUMBER
596:
597: ) RETURN NUMBER
598: IS

Line 618: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

614: END RECEIPT_METHOD;
615:
616: FUNCTION PAYMENT_COLLECTION_EVENT
617: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
618: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
619: , x_on_operation_action OUT NOCOPY NUMBER
620:
621: ) RETURN NUMBER
622: IS

Line 643: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

639:
640:
641: FUNCTION CHECK_NUMBER
642: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
643: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
644: , x_on_operation_action OUT NOCOPY NUMBER
645:
646: ) RETURN NUMBER
647: IS

Line 667: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

663: END CHECK_NUMBER;
664:
665: FUNCTION COMMITMENT_APPLIED_AMOUNT
666: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
667: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
668: , x_on_operation_action OUT NOCOPY NUMBER
669:
670: ) RETURN NUMBER
671: IS

Line 691: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

687: END COMMITMENT_APPLIED_AMOUNT;
688:
689: FUNCTION CREDIT_CARD
690: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
691: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
692: , x_on_operation_action OUT NOCOPY NUMBER
693:
694: ) RETURN NUMBER
695: IS

Line 715: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

711: END CREDIT_CARD;
712:
713: FUNCTION CREDIT_CARD_NUMBER
714: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
715: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
716: , x_on_operation_action OUT NOCOPY NUMBER
717:
718: ) RETURN NUMBER
719: IS

Line 739: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

735: END CREDIT_CARD_NUMBER;
736:
737: FUNCTION CREDIT_CARD_HOLDER_NAME
738: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
739: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
740: , x_on_operation_action OUT NOCOPY NUMBER
741:
742: ) RETURN NUMBER
743: IS

Line 763: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

759: END CREDIT_CARD_HOLDER_NAME;
760:
761: FUNCTION CREDIT_CARD_EXPIRATION_DATE
762: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
763: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
764: , x_on_operation_action OUT NOCOPY NUMBER
765:
766: ) RETURN NUMBER
767: IS

Line 787: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

783: END CREDIT_CARD_EXPIRATION_DATE;
784:
785: FUNCTION CREDIT_CARD_APPROVAL
786: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
787: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
788: , x_on_operation_action OUT NOCOPY NUMBER
789:
790: ) RETURN NUMBER
791: IS

Line 811: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

807: END CREDIT_CARD_APPROVAL;
808:
809: FUNCTION CREDIT_CARD_APPROVAL_DATE
810: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
811: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
812: , x_on_operation_action OUT NOCOPY NUMBER
813:
814: ) RETURN NUMBER
815: IS

Line 835: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

831: END CREDIT_CARD_APPROVAL_DATE;
832:
833: FUNCTION PAYMENT_AMOUNT
834: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
835: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
836: , x_on_operation_action OUT NOCOPY NUMBER
837:
838: ) RETURN NUMBER
839: IS

Line 866: l_rowtype_rec OE_AK_HEADER_PAYMENTS_V%ROWTYPE;

862:
863: ) IS
864: l_operation VARCHAR2(1);
865: l_on_operation_action NUMBER;
866: l_rowtype_rec OE_AK_HEADER_PAYMENTS_V%ROWTYPE;
867: --
868: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
869: --
870: BEGIN

Line 933: l_rowtype_rec OE_AK_HEADER_PAYMENTS_V%ROWTYPE;

929: ) IS
930: l_operation VARCHAR2(1);
931: l_on_operation_action NUMBER;
932: l_result NUMBER;
933: l_rowtype_rec OE_AK_HEADER_PAYMENTS_V%ROWTYPE;
934: l_column_name VARCHAR2(30);
935: l_check_all_cols_constraint VARCHAR2(1);
936: --
937: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;