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.

APPS.OE_HEADER_PAYMENT_SECURITY dependencies on OE_PC_GLOBALS

Line 46: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_PAYMENT

42: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
43: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
44: , p_operation => p_operation
45: , p_qualifier_attribute => l_transaction_phase_code
46: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_PAYMENT
47: , p_column_name => p_column_name
48: , p_check_all_cols_constraint => g_check_all_cols_constraint
49: , p_is_caller_defaulting => g_is_caller_defaulting
50: , p_use_cached_results => 'Y'

Line 56: if l_result = OE_PC_GLOBALS.YES then

52: , x_constraining_conditions_grp => l_grp
53: , x_on_operation_action => x_on_operation_action
54: );
55:
56: if l_result = OE_PC_GLOBALS.YES then
57:
58: IF g_check_all_cols_constraint = 'Y' AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
59: OR p_operation = OE_PC_GLOBALS.CREATE_OP) AND p_column_name IS NOT NULL THEN
60: SELECT column_name

Line 58: IF g_check_all_cols_constraint = 'Y' AND (p_operation = OE_PC_GLOBALS.UPDATE_OP

54: );
55:
56: if l_result = OE_PC_GLOBALS.YES then
57:
58: IF g_check_all_cols_constraint = 'Y' AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
59: OR p_operation = OE_PC_GLOBALS.CREATE_OP) AND p_column_name IS NOT NULL THEN
60: SELECT column_name
61: INTO l_constrained_column
62: FROM oe_pc_constraints

Line 59: OR p_operation = OE_PC_GLOBALS.CREATE_OP) AND p_column_name IS NOT NULL THEN

55:
56: if l_result = OE_PC_GLOBALS.YES then
57:
58: IF g_check_all_cols_constraint = 'Y' AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
59: OR p_operation = OE_PC_GLOBALS.CREATE_OP) AND p_column_name IS NOT NULL THEN
60: SELECT column_name
61: INTO l_constrained_column
62: FROM oe_pc_constraints
63: WHERE constraint_id = l_constraint_id;

Line 70: elsif l_result = OE_PC_GLOBALS.ERROR then

66: RAISE FND_API.G_EXC_ERROR;
67: end if;
68: END IF;
69:
70: elsif l_result = OE_PC_GLOBALS.ERROR then
71:
72: raise FND_API.G_EXC_UNEXPECTED_ERROR;
73:
74: end if;

Line 79: l_result := OE_PC_GLOBALS.NO;

75:
76: g_check_all_cols_constraint := 'N';
77:
78: IF x_on_operation_action > 0 THEN
79: l_result := OE_PC_GLOBALS.NO;
80: END IF;
81:
82: RETURN l_result;
83:

Line 92: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

88:
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

Line 117: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

113: END ATTRIBUTE1;
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

Line 142: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

138: END ATTRIBUTE10;
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

Line 167: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

163: END ATTRIBUTE11;
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

Line 192: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

188: END ATTRIBUTE12;
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

Line 217: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

213: END ATTRIBUTE13;
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

Line 242: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

238: END ATTRIBUTE14;
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

Line 267: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

263: END ATTRIBUTE15;
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

Line 292: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

288: END ATTRIBUTE2;
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

Line 317: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

313: END ATTRIBUTE3;
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

Line 342: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

338: END ATTRIBUTE4;
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

Line 367: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

363: END ATTRIBUTE5;
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

Line 392: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

388: END ATTRIBUTE6;
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

Line 417: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

413: END ATTRIBUTE7;
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

Line 442: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

438: END ATTRIBUTE8;
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

Line 467: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

463: END ATTRIBUTE9;
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

Line 493: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

489:
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

Line 518: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

514: END CREATED_BY;
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

Line 543: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

539: END PAYMENT_LEVEL_CODE;
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

Line 569: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

565:
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

Line 593: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

589:
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

Line 617: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

613:
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

Line 642: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

638: END PAYMENT_COLLECTION_EVENT;
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

Line 666: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

662:
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

Line 690: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

686:
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

Line 714: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

710:
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

Line 738: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

734:
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

Line 762: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

758:
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

Line 786: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

782:
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

Line 810: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

806:
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

Line 834: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

830:
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

Line 880: l_operation := OE_PC_GLOBALS.CREATE_OP;

876: -- Initializing return status to SUCCESS
877: x_return_status := FND_API.G_RET_STS_SUCCESS;
878:
879: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
880: l_operation := OE_PC_GLOBALS.CREATE_OP;
881: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
882: l_operation := OE_PC_GLOBALS.UPDATE_OP;
883: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
884: l_operation := OE_PC_GLOBALS.DELETE_OP;

Line 882: l_operation := OE_PC_GLOBALS.UPDATE_OP;

878:
879: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
880: l_operation := OE_PC_GLOBALS.CREATE_OP;
881: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
882: l_operation := OE_PC_GLOBALS.UPDATE_OP;
883: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
884: l_operation := OE_PC_GLOBALS.DELETE_OP;
885: ELSE
886: IF l_debug_level > 0 THEN

Line 884: l_operation := OE_PC_GLOBALS.DELETE_OP;

880: l_operation := OE_PC_GLOBALS.CREATE_OP;
881: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
882: l_operation := OE_PC_GLOBALS.UPDATE_OP;
883: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
884: l_operation := OE_PC_GLOBALS.DELETE_OP;
885: ELSE
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
888: END IF;

Line 948: x_result := OE_PC_GLOBALS.NO;

944: -- Initializing return status to SUCCESS
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: -- Initializing out result to NOT CONSTRAINED
948: x_result := OE_PC_GLOBALS.NO;
949:
950: -- Get the operation code to be passed to the security framework API
951: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
952:

Line 953: l_operation := OE_PC_GLOBALS.CREATE_OP;

949:
950: -- Get the operation code to be passed to the security framework API
951: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
952:
953: l_operation := OE_PC_GLOBALS.CREATE_OP;
954:
955: -- Bug 1755817: if there are no attribute-specific insert
956: -- constraints, then no need to go further. Entity level
957: -- security check for CREATE will be called again from

Line 960: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_PAYMENT

956: -- constraints, then no need to go further. Entity level
957: -- security check for CREATE will be called again from
958: -- process order after defaulting.
959: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
960: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_PAYMENT
961: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
962: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
963: )
964: THEN

Line 969: l_operation := OE_PC_GLOBALS.UPDATE_OP;

965: RETURN;
966: END IF;
967:
968: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
969: l_operation := OE_PC_GLOBALS.UPDATE_OP;
970: ELSE
971: IF l_debug_level > 0 THEN
972: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
973: END IF;

Line 996: IF l_result = OE_PC_GLOBALS.YES THEN

992: ,p_record => l_rowtype_rec
993: ,x_on_operation_action => l_on_operation_action
994: );
995:
996: IF l_result = OE_PC_GLOBALS.YES THEN
997: -- set OUT result to CONSTRAINED
998: x_result := OE_PC_GLOBALS.YES;
999: END IF;
1000:

Line 998: x_result := OE_PC_GLOBALS.YES;

994: );
995:
996: IF l_result = OE_PC_GLOBALS.YES THEN
997: -- set OUT result to CONSTRAINED
998: x_result := OE_PC_GLOBALS.YES;
999: END IF;
1000:
1001: END IF;
1002:

Line 1012: IF l_result = OE_PC_GLOBALS.YES THEN

1008: ,p_record => l_rowtype_rec
1009: ,x_on_operation_action => l_on_operation_action
1010: );
1011:
1012: IF l_result = OE_PC_GLOBALS.YES THEN
1013: -- set OUT result to CONSTRAINED
1014: x_result := OE_PC_GLOBALS.YES;
1015: END IF;
1016:

Line 1014: x_result := OE_PC_GLOBALS.YES;

1010: );
1011:
1012: IF l_result = OE_PC_GLOBALS.YES THEN
1013: -- set OUT result to CONSTRAINED
1014: x_result := OE_PC_GLOBALS.YES;
1015: END IF;
1016:
1017: END IF;
1018:

Line 1028: IF l_result = OE_PC_GLOBALS.YES THEN

1024: ,p_record => l_rowtype_rec
1025: ,x_on_operation_action => l_on_operation_action
1026: );
1027:
1028: IF l_result = OE_PC_GLOBALS.YES THEN
1029: -- set OUT result to CONSTRAINED
1030: x_result := OE_PC_GLOBALS.YES;
1031: END IF;
1032:

Line 1030: x_result := OE_PC_GLOBALS.YES;

1026: );
1027:
1028: IF l_result = OE_PC_GLOBALS.YES THEN
1029: -- set OUT result to CONSTRAINED
1030: x_result := OE_PC_GLOBALS.YES;
1031: END IF;
1032:
1033: END IF;
1034: --R12 CC Encryption

Line 1051: IF l_result = OE_PC_GLOBALS.YES THEN

1047: ,p_record => l_rowtype_rec
1048: ,x_on_operation_action => l_on_operation_action
1049: );
1050:
1051: IF l_result = OE_PC_GLOBALS.YES THEN
1052: -- set OUT result to CONSTRAINED
1053: x_result := OE_PC_GLOBALS.YES;
1054: END IF;
1055:

Line 1053: x_result := OE_PC_GLOBALS.YES;

1049: );
1050:
1051: IF l_result = OE_PC_GLOBALS.YES THEN
1052: -- set OUT result to CONSTRAINED
1053: x_result := OE_PC_GLOBALS.YES;
1054: END IF;
1055:
1056: END IF;
1057:

Line 1067: IF l_result = OE_PC_GLOBALS.YES THEN

1063: ,p_record => l_rowtype_rec
1064: ,x_on_operation_action => l_on_operation_action
1065: );
1066:
1067: IF l_result = OE_PC_GLOBALS.YES THEN
1068: -- set OUT result to CONSTRAINED
1069: x_result := OE_PC_GLOBALS.YES;
1070: END IF;
1071:

Line 1069: x_result := OE_PC_GLOBALS.YES;

1065: );
1066:
1067: IF l_result = OE_PC_GLOBALS.YES THEN
1068: -- set OUT result to CONSTRAINED
1069: x_result := OE_PC_GLOBALS.YES;
1070: END IF;
1071:
1072: END IF;
1073:

Line 1083: IF l_result = OE_PC_GLOBALS.YES THEN

1079: ,p_record => l_rowtype_rec
1080: ,x_on_operation_action => l_on_operation_action
1081: );
1082:
1083: IF l_result = OE_PC_GLOBALS.YES THEN
1084: -- set OUT result to CONSTRAINED
1085: x_result := OE_PC_GLOBALS.YES;
1086: END IF;
1087:

Line 1085: x_result := OE_PC_GLOBALS.YES;

1081: );
1082:
1083: IF l_result = OE_PC_GLOBALS.YES THEN
1084: -- set OUT result to CONSTRAINED
1085: x_result := OE_PC_GLOBALS.YES;
1086: END IF;
1087:
1088: END IF;
1089:

Line 1099: IF l_result = OE_PC_GLOBALS.YES THEN

1095: ,p_record => l_rowtype_rec
1096: ,x_on_operation_action => l_on_operation_action
1097: );
1098:
1099: IF l_result = OE_PC_GLOBALS.YES THEN
1100: -- set OUT result to CONSTRAINED
1101: x_result := OE_PC_GLOBALS.YES;
1102: END IF;
1103:

Line 1101: x_result := OE_PC_GLOBALS.YES;

1097: );
1098:
1099: IF l_result = OE_PC_GLOBALS.YES THEN
1100: -- set OUT result to CONSTRAINED
1101: x_result := OE_PC_GLOBALS.YES;
1102: END IF;
1103:
1104: END IF;
1105:

Line 1115: IF l_result = OE_PC_GLOBALS.YES THEN

1111: ,p_record => l_rowtype_rec
1112: ,x_on_operation_action => l_on_operation_action
1113: );
1114:
1115: IF l_result = OE_PC_GLOBALS.YES THEN
1116: -- set OUT result to CONSTRAINED
1117: x_result := OE_PC_GLOBALS.YES;
1118: END IF;
1119:

Line 1117: x_result := OE_PC_GLOBALS.YES;

1113: );
1114:
1115: IF l_result = OE_PC_GLOBALS.YES THEN
1116: -- set OUT result to CONSTRAINED
1117: x_result := OE_PC_GLOBALS.YES;
1118: END IF;
1119:
1120: END IF;
1121:

Line 1131: IF l_result = OE_PC_GLOBALS.YES THEN

1127: ,p_record => l_rowtype_rec
1128: ,x_on_operation_action => l_on_operation_action
1129: );
1130:
1131: IF l_result = OE_PC_GLOBALS.YES THEN
1132: -- set OUT result to CONSTRAINED
1133: x_result := OE_PC_GLOBALS.YES;
1134: END IF;
1135:

Line 1133: x_result := OE_PC_GLOBALS.YES;

1129: );
1130:
1131: IF l_result = OE_PC_GLOBALS.YES THEN
1132: -- set OUT result to CONSTRAINED
1133: x_result := OE_PC_GLOBALS.YES;
1134: END IF;
1135:
1136: END IF;
1137:

Line 1147: IF l_result = OE_PC_GLOBALS.YES THEN

1143: ,p_record => l_rowtype_rec
1144: ,x_on_operation_action => l_on_operation_action
1145: );
1146:
1147: IF l_result = OE_PC_GLOBALS.YES THEN
1148: -- set OUT result to CONSTRAINED
1149: x_result := OE_PC_GLOBALS.YES;
1150: END IF;
1151:

Line 1149: x_result := OE_PC_GLOBALS.YES;

1145: );
1146:
1147: IF l_result = OE_PC_GLOBALS.YES THEN
1148: -- set OUT result to CONSTRAINED
1149: x_result := OE_PC_GLOBALS.YES;
1150: END IF;
1151:
1152: END IF;
1153:

Line 1162: IF l_result = OE_PC_GLOBALS.YES THEN

1158: (p_operation => l_operation
1159: ,p_record => l_rowtype_rec
1160: ,x_on_operation_action => l_on_operation_action
1161: );
1162: IF l_result = OE_PC_GLOBALS.YES THEN
1163: -- set OUT result to CONSTRAINED
1164: x_result := OE_PC_GLOBALS.YES;
1165: END IF;
1166:

Line 1164: x_result := OE_PC_GLOBALS.YES;

1160: ,x_on_operation_action => l_on_operation_action
1161: );
1162: IF l_result = OE_PC_GLOBALS.YES THEN
1163: -- set OUT result to CONSTRAINED
1164: x_result := OE_PC_GLOBALS.YES;
1165: END IF;
1166:
1167: END IF;
1168:

Line 1178: IF l_result = OE_PC_GLOBALS.YES THEN

1174: (p_operation => l_operation
1175: ,p_record => l_rowtype_rec
1176: ,x_on_operation_action => l_on_operation_action
1177: );
1178: IF l_result = OE_PC_GLOBALS.YES THEN
1179: -- set OUT result to CONSTRAINED
1180: x_result := OE_PC_GLOBALS.YES;
1181: END IF;
1182:

Line 1180: x_result := OE_PC_GLOBALS.YES;

1176: ,x_on_operation_action => l_on_operation_action
1177: );
1178: IF l_result = OE_PC_GLOBALS.YES THEN
1179: -- set OUT result to CONSTRAINED
1180: x_result := OE_PC_GLOBALS.YES;
1181: END IF;
1182:
1183: END IF;
1184:

Line 1194: IF l_result = OE_PC_GLOBALS.YES THEN

1190: (p_operation => l_operation
1191: ,p_record => l_rowtype_rec
1192: ,x_on_operation_action => l_on_operation_action
1193: );
1194: IF l_result = OE_PC_GLOBALS.YES THEN
1195: -- set OUT result to CONSTRAINED
1196: x_result := OE_PC_GLOBALS.YES;
1197: END IF;
1198:

Line 1196: x_result := OE_PC_GLOBALS.YES;

1192: ,x_on_operation_action => l_on_operation_action
1193: );
1194: IF l_result = OE_PC_GLOBALS.YES THEN
1195: -- set OUT result to CONSTRAINED
1196: x_result := OE_PC_GLOBALS.YES;
1197: END IF;
1198:
1199: END IF;
1200:

Line 1209: IF l_result = OE_PC_GLOBALS.YES THEN

1205: (p_operation => l_operation
1206: ,p_record => l_rowtype_rec
1207: ,x_on_operation_action => l_on_operation_action
1208: );
1209: IF l_result = OE_PC_GLOBALS.YES THEN
1210: -- set OUT result to CONSTRAINED
1211: x_result := OE_PC_GLOBALS.YES;
1212: END IF;
1213:

Line 1211: x_result := OE_PC_GLOBALS.YES;

1207: ,x_on_operation_action => l_on_operation_action
1208: );
1209: IF l_result = OE_PC_GLOBALS.YES THEN
1210: -- set OUT result to CONSTRAINED
1211: x_result := OE_PC_GLOBALS.YES;
1212: END IF;
1213:
1214: END IF;
1215:

Line 1227: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN

1223: -- updated and profile was set to 'N', global at the end should
1224: -- be re-set to 'Y' - this indicates to process order that no
1225: -- constrainable attributes were updated and thus, it would
1226: -- suppress entity level security check also.
1227: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1228: l_check_all_cols_constraint := g_check_all_cols_constraint;
1229: g_check_all_cols_constraint := 'N';
1230: END IF;
1231:

Line 1241: IF l_result = OE_PC_GLOBALS.YES THEN

1237: ,p_record => l_rowtype_rec
1238: ,x_on_operation_action => l_on_operation_action
1239: );
1240:
1241: IF l_result = OE_PC_GLOBALS.YES THEN
1242: -- set OUT result to CONSTRAINED
1243: x_result := OE_PC_GLOBALS.YES;
1244: END IF;
1245:

Line 1243: x_result := OE_PC_GLOBALS.YES;

1239: );
1240:
1241: IF l_result = OE_PC_GLOBALS.YES THEN
1242: -- set OUT result to CONSTRAINED
1243: x_result := OE_PC_GLOBALS.YES;
1244: END IF;
1245:
1246: END IF;
1247:

Line 1257: IF l_result = OE_PC_GLOBALS.YES THEN

1253: ,p_record => l_rowtype_rec
1254: ,x_on_operation_action => l_on_operation_action
1255: );
1256:
1257: IF l_result = OE_PC_GLOBALS.YES THEN
1258: -- set OUT result to CONSTRAINED
1259: x_result := OE_PC_GLOBALS.YES;
1260: END IF;
1261:

Line 1259: x_result := OE_PC_GLOBALS.YES;

1255: );
1256:
1257: IF l_result = OE_PC_GLOBALS.YES THEN
1258: -- set OUT result to CONSTRAINED
1259: x_result := OE_PC_GLOBALS.YES;
1260: END IF;
1261:
1262: END IF;
1263:

Line 1273: IF l_result = OE_PC_GLOBALS.YES THEN

1269: ,p_record => l_rowtype_rec
1270: ,x_on_operation_action => l_on_operation_action
1271: );
1272:
1273: IF l_result = OE_PC_GLOBALS.YES THEN
1274: -- set OUT result to CONSTRAINED
1275: x_result := OE_PC_GLOBALS.YES;
1276: END IF;
1277:

Line 1275: x_result := OE_PC_GLOBALS.YES;

1271: );
1272:
1273: IF l_result = OE_PC_GLOBALS.YES THEN
1274: -- set OUT result to CONSTRAINED
1275: x_result := OE_PC_GLOBALS.YES;
1276: END IF;
1277:
1278: END IF;
1279:

Line 1289: IF l_result = OE_PC_GLOBALS.YES THEN

1285: ,p_record => l_rowtype_rec
1286: ,x_on_operation_action => l_on_operation_action
1287: );
1288:
1289: IF l_result = OE_PC_GLOBALS.YES THEN
1290: -- set OUT result to CONSTRAINED
1291: x_result := OE_PC_GLOBALS.YES;
1292: END IF;
1293:

Line 1291: x_result := OE_PC_GLOBALS.YES;

1287: );
1288:
1289: IF l_result = OE_PC_GLOBALS.YES THEN
1290: -- set OUT result to CONSTRAINED
1291: x_result := OE_PC_GLOBALS.YES;
1292: END IF;
1293:
1294: END IF;
1295:

Line 1305: IF l_result = OE_PC_GLOBALS.YES THEN

1301: ,p_record => l_rowtype_rec
1302: ,x_on_operation_action => l_on_operation_action
1303: );
1304:
1305: IF l_result = OE_PC_GLOBALS.YES THEN
1306: -- set OUT result to CONSTRAINED
1307: x_result := OE_PC_GLOBALS.YES;
1308: END IF;
1309:

Line 1307: x_result := OE_PC_GLOBALS.YES;

1303: );
1304:
1305: IF l_result = OE_PC_GLOBALS.YES THEN
1306: -- set OUT result to CONSTRAINED
1307: x_result := OE_PC_GLOBALS.YES;
1308: END IF;
1309:
1310: END IF;
1311:

Line 1321: IF l_result = OE_PC_GLOBALS.YES THEN

1317: ,p_record => l_rowtype_rec
1318: ,x_on_operation_action => l_on_operation_action
1319: );
1320:
1321: IF l_result = OE_PC_GLOBALS.YES THEN
1322: -- set OUT result to CONSTRAINED
1323: x_result := OE_PC_GLOBALS.YES;
1324: END IF;
1325:

Line 1323: x_result := OE_PC_GLOBALS.YES;

1319: );
1320:
1321: IF l_result = OE_PC_GLOBALS.YES THEN
1322: -- set OUT result to CONSTRAINED
1323: x_result := OE_PC_GLOBALS.YES;
1324: END IF;
1325:
1326: END IF;
1327:

Line 1337: IF l_result = OE_PC_GLOBALS.YES THEN

1333: ,p_record => l_rowtype_rec
1334: ,x_on_operation_action => l_on_operation_action
1335: );
1336:
1337: IF l_result = OE_PC_GLOBALS.YES THEN
1338: -- set OUT result to CONSTRAINED
1339: x_result := OE_PC_GLOBALS.YES;
1340: END IF;
1341:

Line 1339: x_result := OE_PC_GLOBALS.YES;

1335: );
1336:
1337: IF l_result = OE_PC_GLOBALS.YES THEN
1338: -- set OUT result to CONSTRAINED
1339: x_result := OE_PC_GLOBALS.YES;
1340: END IF;
1341:
1342: END IF;
1343:

Line 1353: IF l_result = OE_PC_GLOBALS.YES THEN

1349: ,p_record => l_rowtype_rec
1350: ,x_on_operation_action => l_on_operation_action
1351: );
1352:
1353: IF l_result = OE_PC_GLOBALS.YES THEN
1354: -- set OUT result to CONSTRAINED
1355: x_result := OE_PC_GLOBALS.YES;
1356: END IF;
1357:

Line 1355: x_result := OE_PC_GLOBALS.YES;

1351: );
1352:
1353: IF l_result = OE_PC_GLOBALS.YES THEN
1354: -- set OUT result to CONSTRAINED
1355: x_result := OE_PC_GLOBALS.YES;
1356: END IF;
1357:
1358: END IF;
1359:

Line 1369: IF l_result = OE_PC_GLOBALS.YES THEN

1365: ,p_record => l_rowtype_rec
1366: ,x_on_operation_action => l_on_operation_action
1367: );
1368:
1369: IF l_result = OE_PC_GLOBALS.YES THEN
1370: -- set OUT result to CONSTRAINED
1371: x_result := OE_PC_GLOBALS.YES;
1372: END IF;
1373:

Line 1371: x_result := OE_PC_GLOBALS.YES;

1367: );
1368:
1369: IF l_result = OE_PC_GLOBALS.YES THEN
1370: -- set OUT result to CONSTRAINED
1371: x_result := OE_PC_GLOBALS.YES;
1372: END IF;
1373:
1374: END IF;
1375:

Line 1385: IF l_result = OE_PC_GLOBALS.YES THEN

1381: ,p_record => l_rowtype_rec
1382: ,x_on_operation_action => l_on_operation_action
1383: );
1384:
1385: IF l_result = OE_PC_GLOBALS.YES THEN
1386: -- set OUT result to CONSTRAINED
1387: x_result := OE_PC_GLOBALS.YES;
1388: END IF;
1389:

Line 1387: x_result := OE_PC_GLOBALS.YES;

1383: );
1384:
1385: IF l_result = OE_PC_GLOBALS.YES THEN
1386: -- set OUT result to CONSTRAINED
1387: x_result := OE_PC_GLOBALS.YES;
1388: END IF;
1389:
1390: END IF;
1391:

Line 1401: IF l_result = OE_PC_GLOBALS.YES THEN

1397: ,p_record => l_rowtype_rec
1398: ,x_on_operation_action => l_on_operation_action
1399: );
1400:
1401: IF l_result = OE_PC_GLOBALS.YES THEN
1402: -- set OUT result to CONSTRAINED
1403: x_result := OE_PC_GLOBALS.YES;
1404: END IF;
1405:

Line 1403: x_result := OE_PC_GLOBALS.YES;

1399: );
1400:
1401: IF l_result = OE_PC_GLOBALS.YES THEN
1402: -- set OUT result to CONSTRAINED
1403: x_result := OE_PC_GLOBALS.YES;
1404: END IF;
1405:
1406: END IF;
1407:

Line 1417: IF l_result = OE_PC_GLOBALS.YES THEN

1413: ,p_record => l_rowtype_rec
1414: ,x_on_operation_action => l_on_operation_action
1415: );
1416:
1417: IF l_result = OE_PC_GLOBALS.YES THEN
1418: -- set OUT result to CONSTRAINED
1419: x_result := OE_PC_GLOBALS.YES;
1420: END IF;
1421:

Line 1419: x_result := OE_PC_GLOBALS.YES;

1415: );
1416:
1417: IF l_result = OE_PC_GLOBALS.YES THEN
1418: -- set OUT result to CONSTRAINED
1419: x_result := OE_PC_GLOBALS.YES;
1420: END IF;
1421:
1422: END IF;
1423:

Line 1433: IF l_result = OE_PC_GLOBALS.YES THEN

1429: ,p_record => l_rowtype_rec
1430: ,x_on_operation_action => l_on_operation_action
1431: );
1432:
1433: IF l_result = OE_PC_GLOBALS.YES THEN
1434: -- set OUT result to CONSTRAINED
1435: x_result := OE_PC_GLOBALS.YES;
1436: END IF;
1437:

Line 1435: x_result := OE_PC_GLOBALS.YES;

1431: );
1432:
1433: IF l_result = OE_PC_GLOBALS.YES THEN
1434: -- set OUT result to CONSTRAINED
1435: x_result := OE_PC_GLOBALS.YES;
1436: END IF;
1437:
1438: END IF;
1439:

Line 1449: IF l_result = OE_PC_GLOBALS.YES THEN

1445: ,p_record => l_rowtype_rec
1446: ,x_on_operation_action => l_on_operation_action
1447: );
1448:
1449: IF l_result = OE_PC_GLOBALS.YES THEN
1450: -- set OUT result to CONSTRAINED
1451: x_result := OE_PC_GLOBALS.YES;
1452: END IF;
1453:

Line 1451: x_result := OE_PC_GLOBALS.YES;

1447: );
1448:
1449: IF l_result = OE_PC_GLOBALS.YES THEN
1450: -- set OUT result to CONSTRAINED
1451: x_result := OE_PC_GLOBALS.YES;
1452: END IF;
1453:
1454: END IF;
1455:

Line 1465: IF l_result = OE_PC_GLOBALS.YES THEN

1461: ,p_record => l_rowtype_rec
1462: ,x_on_operation_action => l_on_operation_action
1463: );
1464:
1465: IF l_result = OE_PC_GLOBALS.YES THEN
1466: -- set OUT result to CONSTRAINED
1467: x_result := OE_PC_GLOBALS.YES;
1468: END IF;
1469:

Line 1467: x_result := OE_PC_GLOBALS.YES;

1463: );
1464:
1465: IF l_result = OE_PC_GLOBALS.YES THEN
1466: -- set OUT result to CONSTRAINED
1467: x_result := OE_PC_GLOBALS.YES;
1468: END IF;
1469:
1470: END IF;
1471:

Line 1481: IF l_result = OE_PC_GLOBALS.YES THEN

1477: ,p_record => l_rowtype_rec
1478: ,x_on_operation_action => l_on_operation_action
1479: );
1480:
1481: IF l_result = OE_PC_GLOBALS.YES THEN
1482: -- set OUT result to CONSTRAINED
1483: x_result := OE_PC_GLOBALS.YES;
1484: END IF;
1485:

Line 1483: x_result := OE_PC_GLOBALS.YES;

1479: );
1480:
1481: IF l_result = OE_PC_GLOBALS.YES THEN
1482: -- set OUT result to CONSTRAINED
1483: x_result := OE_PC_GLOBALS.YES;
1484: END IF;
1485:
1486: END IF;
1487:

Line 1488: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN

1484: END IF;
1485:
1486: END IF;
1487:
1488: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1489: IF l_debug_level > 0 THEN
1490: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1491: END IF;
1492: g_check_all_cols_constraint := l_check_all_cols_constraint;