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_LINE_PAYMENT_SECURITY dependencies on OE_PC_GLOBALS

Line 48: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_PAYMENT

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

Line 58: if l_result = OE_PC_GLOBALS.YES then

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

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

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

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

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

Line 72: elsif l_result = OE_PC_GLOBALS.ERROR then

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

Line 81: l_result := OE_PC_GLOBALS.NO;

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

Line 94: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 119: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

115: END ATTRIBUTE1;
116:
117:
118: FUNCTION ATTRIBUTE10
119: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
120: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
121: , x_on_operation_action OUT NOCOPY NUMBER
122:
123: ) RETURN NUMBER

Line 144: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

140: END ATTRIBUTE10;
141:
142:
143: FUNCTION ATTRIBUTE11
144: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
145: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
146: , x_on_operation_action OUT NOCOPY NUMBER
147:
148: ) RETURN NUMBER

Line 169: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

165: END ATTRIBUTE11;
166:
167:
168: FUNCTION ATTRIBUTE12
169: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
170: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
171: , x_on_operation_action OUT NOCOPY NUMBER
172:
173: ) RETURN NUMBER

Line 194: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

190: END ATTRIBUTE12;
191:
192:
193: FUNCTION ATTRIBUTE13
194: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
195: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
196: , x_on_operation_action OUT NOCOPY NUMBER
197:
198: ) RETURN NUMBER

Line 219: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

215: END ATTRIBUTE13;
216:
217:
218: FUNCTION ATTRIBUTE14
219: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
220: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
221: , x_on_operation_action OUT NOCOPY NUMBER
222:
223: ) RETURN NUMBER

Line 244: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

240: END ATTRIBUTE14;
241:
242:
243: FUNCTION ATTRIBUTE15
244: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
245: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
246: , x_on_operation_action OUT NOCOPY NUMBER
247:
248: ) RETURN NUMBER

Line 269: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

265: END ATTRIBUTE15;
266:
267:
268: FUNCTION ATTRIBUTE2
269: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
270: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
271: , x_on_operation_action OUT NOCOPY NUMBER
272:
273: ) RETURN NUMBER

Line 294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

290: END ATTRIBUTE2;
291:
292:
293: FUNCTION ATTRIBUTE3
294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
295: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
296: , x_on_operation_action OUT NOCOPY NUMBER
297:
298: ) RETURN NUMBER

Line 319: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

315: END ATTRIBUTE3;
316:
317:
318: FUNCTION ATTRIBUTE4
319: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
320: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
321: , x_on_operation_action OUT NOCOPY NUMBER
322:
323: ) RETURN NUMBER

Line 344: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

340: END ATTRIBUTE4;
341:
342:
343: FUNCTION ATTRIBUTE5
344: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
345: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
346: , x_on_operation_action OUT NOCOPY NUMBER
347:
348: ) RETURN NUMBER

Line 369: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

365: END ATTRIBUTE5;
366:
367:
368: FUNCTION ATTRIBUTE6
369: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
370: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
371: , x_on_operation_action OUT NOCOPY NUMBER
372:
373: ) RETURN NUMBER

Line 394: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

390: END ATTRIBUTE6;
391:
392:
393: FUNCTION ATTRIBUTE7
394: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
395: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
396: , x_on_operation_action OUT NOCOPY NUMBER
397:
398: ) RETURN NUMBER

Line 419: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

415: END ATTRIBUTE7;
416:
417:
418: FUNCTION ATTRIBUTE8
419: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
420: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
421: , x_on_operation_action OUT NOCOPY NUMBER
422:
423: ) RETURN NUMBER

Line 444: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

440: END ATTRIBUTE8;
441:
442:
443: FUNCTION ATTRIBUTE9
444: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
445: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
446: , x_on_operation_action OUT NOCOPY NUMBER
447:
448: ) RETURN NUMBER

Line 469: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

465: END ATTRIBUTE9;
466:
467:
468: FUNCTION CONTEXT
469: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
470: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
471: , x_on_operation_action OUT NOCOPY NUMBER
472:
473: ) RETURN NUMBER

Line 495: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 520: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

516: END CREATED_BY;
517:
518:
519: FUNCTION PAYMENT_LEVEL_CODE
520: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
521: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
522: , x_on_operation_action OUT NOCOPY NUMBER
523:
524: ) RETURN NUMBER

Line 545: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

541: END PAYMENT_LEVEL_CODE;
542:
543:
544: FUNCTION PAYMENT_TYPE_CODE
545: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
546: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
547: , x_on_operation_action OUT NOCOPY NUMBER
548:
549: ) RETURN NUMBER

Line 570: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 595: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 620: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 645: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

641: END PAYMENT_COLLECTION_EVENT;
642:
643:
644: FUNCTION CHECK_NUMBER
645: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
646: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
647: , x_on_operation_action OUT NOCOPY NUMBER
648:
649: ) RETURN NUMBER

Line 669: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 693: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 717: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 741: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 765: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 789: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 813: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 837: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 883: l_operation := OE_PC_GLOBALS.CREATE_OP;

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

Line 885: l_operation := OE_PC_GLOBALS.UPDATE_OP;

881:
882: IF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
883: l_operation := OE_PC_GLOBALS.CREATE_OP;
884: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
885: l_operation := OE_PC_GLOBALS.UPDATE_OP;
886: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
887: l_operation := OE_PC_GLOBALS.DELETE_OP;
888: ELSE
889: IF l_debug_level > 0 THEN

Line 887: l_operation := OE_PC_GLOBALS.DELETE_OP;

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

Line 951: x_result := OE_PC_GLOBALS.NO;

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

Line 956: l_operation := OE_PC_GLOBALS.CREATE_OP;

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

Line 963: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_PAYMENT

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

Line 972: l_operation := OE_PC_GLOBALS.UPDATE_OP;

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

Line 999: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1001: x_result := OE_PC_GLOBALS.YES;

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

Line 1015: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1017: x_result := OE_PC_GLOBALS.YES;

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

Line 1030: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1032: x_result := OE_PC_GLOBALS.YES;

1028: ,x_on_operation_action => l_on_operation_action
1029: );
1030: IF l_result = OE_PC_GLOBALS.YES THEN
1031: -- set OUT result to CONSTRAINED
1032: x_result := OE_PC_GLOBALS.YES;
1033: END IF;
1034:
1035: END IF;
1036:

Line 1046: IF l_result = OE_PC_GLOBALS.YES THEN

1042: (p_operation => l_operation
1043: ,p_record => l_rowtype_rec
1044: ,x_on_operation_action => l_on_operation_action
1045: );
1046: IF l_result = OE_PC_GLOBALS.YES THEN
1047: -- set OUT result to CONSTRAINED
1048: x_result := OE_PC_GLOBALS.YES;
1049: END IF;
1050:

Line 1048: x_result := OE_PC_GLOBALS.YES;

1044: ,x_on_operation_action => l_on_operation_action
1045: );
1046: IF l_result = OE_PC_GLOBALS.YES THEN
1047: -- set OUT result to CONSTRAINED
1048: x_result := OE_PC_GLOBALS.YES;
1049: END IF;
1050:
1051: END IF;
1052:

Line 1062: IF l_result = OE_PC_GLOBALS.YES THEN

1058: (p_operation => l_operation
1059: ,p_record => l_rowtype_rec
1060: ,x_on_operation_action => l_on_operation_action
1061: );
1062: IF l_result = OE_PC_GLOBALS.YES THEN
1063: -- set OUT result to CONSTRAINED
1064: x_result := OE_PC_GLOBALS.YES;
1065: END IF;
1066:

Line 1064: x_result := OE_PC_GLOBALS.YES;

1060: ,x_on_operation_action => l_on_operation_action
1061: );
1062: IF l_result = OE_PC_GLOBALS.YES THEN
1063: -- set OUT result to CONSTRAINED
1064: x_result := OE_PC_GLOBALS.YES;
1065: END IF;
1066:
1067: END IF;
1068:

Line 1078: IF l_result = OE_PC_GLOBALS.YES THEN

1074: (p_operation => l_operation
1075: ,p_record => l_rowtype_rec
1076: ,x_on_operation_action => l_on_operation_action
1077: );
1078: IF l_result = OE_PC_GLOBALS.YES THEN
1079: -- set OUT result to CONSTRAINED
1080: x_result := OE_PC_GLOBALS.YES;
1081: END IF;
1082:

Line 1080: x_result := OE_PC_GLOBALS.YES;

1076: ,x_on_operation_action => l_on_operation_action
1077: );
1078: IF l_result = OE_PC_GLOBALS.YES THEN
1079: -- set OUT result to CONSTRAINED
1080: x_result := OE_PC_GLOBALS.YES;
1081: END IF;
1082:
1083: END IF;
1084:

Line 1094: IF l_result = OE_PC_GLOBALS.YES THEN

1090: (p_operation => l_operation
1091: ,p_record => l_rowtype_rec
1092: ,x_on_operation_action => l_on_operation_action
1093: );
1094: IF l_result = OE_PC_GLOBALS.YES THEN
1095: -- set OUT result to CONSTRAINED
1096: x_result := OE_PC_GLOBALS.YES;
1097: END IF;
1098:

Line 1096: x_result := OE_PC_GLOBALS.YES;

1092: ,x_on_operation_action => l_on_operation_action
1093: );
1094: IF l_result = OE_PC_GLOBALS.YES THEN
1095: -- set OUT result to CONSTRAINED
1096: x_result := OE_PC_GLOBALS.YES;
1097: END IF;
1098:
1099: END IF;
1100:

Line 1110: IF l_result = OE_PC_GLOBALS.YES THEN

1106: (p_operation => l_operation
1107: ,p_record => l_rowtype_rec
1108: ,x_on_operation_action => l_on_operation_action
1109: );
1110: IF l_result = OE_PC_GLOBALS.YES THEN
1111: -- set OUT result to CONSTRAINED
1112: x_result := OE_PC_GLOBALS.YES;
1113: END IF;
1114:

Line 1112: x_result := OE_PC_GLOBALS.YES;

1108: ,x_on_operation_action => l_on_operation_action
1109: );
1110: IF l_result = OE_PC_GLOBALS.YES THEN
1111: -- set OUT result to CONSTRAINED
1112: x_result := OE_PC_GLOBALS.YES;
1113: END IF;
1114:
1115: END IF;
1116:

Line 1138: IF l_result = OE_PC_GLOBALS.YES THEN

1134: (p_operation => l_operation
1135: ,p_record => l_rowtype_rec
1136: ,x_on_operation_action => l_on_operation_action
1137: );
1138: IF l_result = OE_PC_GLOBALS.YES THEN
1139: -- set OUT result to CONSTRAINED
1140: x_result := OE_PC_GLOBALS.YES;
1141: END IF;
1142:

Line 1140: x_result := OE_PC_GLOBALS.YES;

1136: ,x_on_operation_action => l_on_operation_action
1137: );
1138: IF l_result = OE_PC_GLOBALS.YES THEN
1139: -- set OUT result to CONSTRAINED
1140: x_result := OE_PC_GLOBALS.YES;
1141: END IF;
1142:
1143: END IF;
1144:

Line 1154: IF l_result = OE_PC_GLOBALS.YES THEN

1150: (p_operation => l_operation
1151: ,p_record => l_rowtype_rec
1152: ,x_on_operation_action => l_on_operation_action
1153: );
1154: IF l_result = OE_PC_GLOBALS.YES THEN
1155: -- set OUT result to CONSTRAINED
1156: x_result := OE_PC_GLOBALS.YES;
1157: END IF;
1158:

Line 1156: x_result := OE_PC_GLOBALS.YES;

1152: ,x_on_operation_action => l_on_operation_action
1153: );
1154: IF l_result = OE_PC_GLOBALS.YES THEN
1155: -- set OUT result to CONSTRAINED
1156: x_result := OE_PC_GLOBALS.YES;
1157: END IF;
1158:
1159: END IF;
1160:

Line 1170: IF l_result = OE_PC_GLOBALS.YES THEN

1166: (p_operation => l_operation
1167: ,p_record => l_rowtype_rec
1168: ,x_on_operation_action => l_on_operation_action
1169: );
1170: IF l_result = OE_PC_GLOBALS.YES THEN
1171: -- set OUT result to CONSTRAINED
1172: x_result := OE_PC_GLOBALS.YES;
1173: END IF;
1174:

Line 1172: x_result := OE_PC_GLOBALS.YES;

1168: ,x_on_operation_action => l_on_operation_action
1169: );
1170: IF l_result = OE_PC_GLOBALS.YES THEN
1171: -- set OUT result to CONSTRAINED
1172: x_result := OE_PC_GLOBALS.YES;
1173: END IF;
1174:
1175: END IF;
1176:

Line 1186: IF l_result = OE_PC_GLOBALS.YES THEN

1182: (p_operation => l_operation
1183: ,p_record => l_rowtype_rec
1184: ,x_on_operation_action => l_on_operation_action
1185: );
1186: IF l_result = OE_PC_GLOBALS.YES THEN
1187: -- set OUT result to CONSTRAINED
1188: x_result := OE_PC_GLOBALS.YES;
1189: END IF;
1190:

Line 1188: x_result := OE_PC_GLOBALS.YES;

1184: ,x_on_operation_action => l_on_operation_action
1185: );
1186: IF l_result = OE_PC_GLOBALS.YES THEN
1187: -- set OUT result to CONSTRAINED
1188: x_result := OE_PC_GLOBALS.YES;
1189: END IF;
1190:
1191: END IF;
1192:

Line 1202: IF l_result = OE_PC_GLOBALS.YES THEN

1198: (p_operation => l_operation
1199: ,p_record => l_rowtype_rec
1200: ,x_on_operation_action => l_on_operation_action
1201: );
1202: IF l_result = OE_PC_GLOBALS.YES THEN
1203: -- set OUT result to CONSTRAINED
1204: x_result := OE_PC_GLOBALS.YES;
1205: END IF;
1206:

Line 1204: x_result := OE_PC_GLOBALS.YES;

1200: ,x_on_operation_action => l_on_operation_action
1201: );
1202: IF l_result = OE_PC_GLOBALS.YES THEN
1203: -- set OUT result to CONSTRAINED
1204: x_result := OE_PC_GLOBALS.YES;
1205: END IF;
1206:
1207: END IF;
1208:

Line 1218: IF l_result = OE_PC_GLOBALS.YES THEN

1214: (p_operation => l_operation
1215: ,p_record => l_rowtype_rec
1216: ,x_on_operation_action => l_on_operation_action
1217: );
1218: IF l_result = OE_PC_GLOBALS.YES THEN
1219: -- set OUT result to CONSTRAINED
1220: x_result := OE_PC_GLOBALS.YES;
1221: END IF;
1222:

Line 1220: x_result := OE_PC_GLOBALS.YES;

1216: ,x_on_operation_action => l_on_operation_action
1217: );
1218: IF l_result = OE_PC_GLOBALS.YES THEN
1219: -- set OUT result to CONSTRAINED
1220: x_result := OE_PC_GLOBALS.YES;
1221: END IF;
1222:
1223: END IF;
1224:

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

1233: -- updated and profile was set to 'N', global at the end should
1234: -- be re-set to 'Y' - this indicates to process order that no
1235: -- constrainable attributes were updated and thus, it would
1236: -- suppress entity level security check also.
1237: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1238: l_check_all_cols_constraint := g_check_all_cols_constraint;
1239: g_check_all_cols_constraint := 'N';
1240: END IF;
1241:

Line 1251: IF l_result = OE_PC_GLOBALS.YES THEN

1247: ,p_record => l_rowtype_rec
1248: ,x_on_operation_action => l_on_operation_action
1249: );
1250:
1251: IF l_result = OE_PC_GLOBALS.YES THEN
1252: -- set OUT result to CONSTRAINED
1253: x_result := OE_PC_GLOBALS.YES;
1254: END IF;
1255:

Line 1253: x_result := OE_PC_GLOBALS.YES;

1249: );
1250:
1251: IF l_result = OE_PC_GLOBALS.YES THEN
1252: -- set OUT result to CONSTRAINED
1253: x_result := OE_PC_GLOBALS.YES;
1254: END IF;
1255:
1256: END IF;
1257:

Line 1267: IF l_result = OE_PC_GLOBALS.YES THEN

1263: ,p_record => l_rowtype_rec
1264: ,x_on_operation_action => l_on_operation_action
1265: );
1266:
1267: IF l_result = OE_PC_GLOBALS.YES THEN
1268: -- set OUT result to CONSTRAINED
1269: x_result := OE_PC_GLOBALS.YES;
1270: END IF;
1271:

Line 1269: x_result := OE_PC_GLOBALS.YES;

1265: );
1266:
1267: IF l_result = OE_PC_GLOBALS.YES THEN
1268: -- set OUT result to CONSTRAINED
1269: x_result := OE_PC_GLOBALS.YES;
1270: END IF;
1271:
1272: END IF;
1273:

Line 1283: IF l_result = OE_PC_GLOBALS.YES THEN

1279: ,p_record => l_rowtype_rec
1280: ,x_on_operation_action => l_on_operation_action
1281: );
1282:
1283: IF l_result = OE_PC_GLOBALS.YES THEN
1284: -- set OUT result to CONSTRAINED
1285: x_result := OE_PC_GLOBALS.YES;
1286: END IF;
1287:

Line 1285: x_result := OE_PC_GLOBALS.YES;

1281: );
1282:
1283: IF l_result = OE_PC_GLOBALS.YES THEN
1284: -- set OUT result to CONSTRAINED
1285: x_result := OE_PC_GLOBALS.YES;
1286: END IF;
1287:
1288: END IF;
1289:

Line 1299: IF l_result = OE_PC_GLOBALS.YES THEN

1295: ,p_record => l_rowtype_rec
1296: ,x_on_operation_action => l_on_operation_action
1297: );
1298:
1299: IF l_result = OE_PC_GLOBALS.YES THEN
1300: -- set OUT result to CONSTRAINED
1301: x_result := OE_PC_GLOBALS.YES;
1302: END IF;
1303:

Line 1301: x_result := OE_PC_GLOBALS.YES;

1297: );
1298:
1299: IF l_result = OE_PC_GLOBALS.YES THEN
1300: -- set OUT result to CONSTRAINED
1301: x_result := OE_PC_GLOBALS.YES;
1302: END IF;
1303:
1304: END IF;
1305:

Line 1315: IF l_result = OE_PC_GLOBALS.YES THEN

1311: ,p_record => l_rowtype_rec
1312: ,x_on_operation_action => l_on_operation_action
1313: );
1314:
1315: IF l_result = OE_PC_GLOBALS.YES THEN
1316: -- set OUT result to CONSTRAINED
1317: x_result := OE_PC_GLOBALS.YES;
1318: END IF;
1319:

Line 1317: x_result := OE_PC_GLOBALS.YES;

1313: );
1314:
1315: IF l_result = OE_PC_GLOBALS.YES THEN
1316: -- set OUT result to CONSTRAINED
1317: x_result := OE_PC_GLOBALS.YES;
1318: END IF;
1319:
1320: END IF;
1321:

Line 1331: IF l_result = OE_PC_GLOBALS.YES THEN

1327: ,p_record => l_rowtype_rec
1328: ,x_on_operation_action => l_on_operation_action
1329: );
1330:
1331: IF l_result = OE_PC_GLOBALS.YES THEN
1332: -- set OUT result to CONSTRAINED
1333: x_result := OE_PC_GLOBALS.YES;
1334: END IF;
1335:

Line 1333: x_result := OE_PC_GLOBALS.YES;

1329: );
1330:
1331: IF l_result = OE_PC_GLOBALS.YES THEN
1332: -- set OUT result to CONSTRAINED
1333: x_result := OE_PC_GLOBALS.YES;
1334: END IF;
1335:
1336: END IF;
1337:

Line 1347: IF l_result = OE_PC_GLOBALS.YES THEN

1343: ,p_record => l_rowtype_rec
1344: ,x_on_operation_action => l_on_operation_action
1345: );
1346:
1347: IF l_result = OE_PC_GLOBALS.YES THEN
1348: -- set OUT result to CONSTRAINED
1349: x_result := OE_PC_GLOBALS.YES;
1350: END IF;
1351:

Line 1349: x_result := OE_PC_GLOBALS.YES;

1345: );
1346:
1347: IF l_result = OE_PC_GLOBALS.YES THEN
1348: -- set OUT result to CONSTRAINED
1349: x_result := OE_PC_GLOBALS.YES;
1350: END IF;
1351:
1352: END IF;
1353:

Line 1363: IF l_result = OE_PC_GLOBALS.YES THEN

1359: ,p_record => l_rowtype_rec
1360: ,x_on_operation_action => l_on_operation_action
1361: );
1362:
1363: IF l_result = OE_PC_GLOBALS.YES THEN
1364: -- set OUT result to CONSTRAINED
1365: x_result := OE_PC_GLOBALS.YES;
1366: END IF;
1367:

Line 1365: x_result := OE_PC_GLOBALS.YES;

1361: );
1362:
1363: IF l_result = OE_PC_GLOBALS.YES THEN
1364: -- set OUT result to CONSTRAINED
1365: x_result := OE_PC_GLOBALS.YES;
1366: END IF;
1367:
1368: END IF;
1369:

Line 1379: IF l_result = OE_PC_GLOBALS.YES THEN

1375: ,p_record => l_rowtype_rec
1376: ,x_on_operation_action => l_on_operation_action
1377: );
1378:
1379: IF l_result = OE_PC_GLOBALS.YES THEN
1380: -- set OUT result to CONSTRAINED
1381: x_result := OE_PC_GLOBALS.YES;
1382: END IF;
1383:

Line 1381: x_result := OE_PC_GLOBALS.YES;

1377: );
1378:
1379: IF l_result = OE_PC_GLOBALS.YES THEN
1380: -- set OUT result to CONSTRAINED
1381: x_result := OE_PC_GLOBALS.YES;
1382: END IF;
1383:
1384: END IF;
1385:

Line 1395: IF l_result = OE_PC_GLOBALS.YES THEN

1391: ,p_record => l_rowtype_rec
1392: ,x_on_operation_action => l_on_operation_action
1393: );
1394:
1395: IF l_result = OE_PC_GLOBALS.YES THEN
1396: -- set OUT result to CONSTRAINED
1397: x_result := OE_PC_GLOBALS.YES;
1398: END IF;
1399:

Line 1397: x_result := OE_PC_GLOBALS.YES;

1393: );
1394:
1395: IF l_result = OE_PC_GLOBALS.YES THEN
1396: -- set OUT result to CONSTRAINED
1397: x_result := OE_PC_GLOBALS.YES;
1398: END IF;
1399:
1400: END IF;
1401:

Line 1411: IF l_result = OE_PC_GLOBALS.YES THEN

1407: ,p_record => l_rowtype_rec
1408: ,x_on_operation_action => l_on_operation_action
1409: );
1410:
1411: IF l_result = OE_PC_GLOBALS.YES THEN
1412: -- set OUT result to CONSTRAINED
1413: x_result := OE_PC_GLOBALS.YES;
1414: END IF;
1415:

Line 1413: x_result := OE_PC_GLOBALS.YES;

1409: );
1410:
1411: IF l_result = OE_PC_GLOBALS.YES THEN
1412: -- set OUT result to CONSTRAINED
1413: x_result := OE_PC_GLOBALS.YES;
1414: END IF;
1415:
1416: END IF;
1417:

Line 1427: IF l_result = OE_PC_GLOBALS.YES THEN

1423: ,p_record => l_rowtype_rec
1424: ,x_on_operation_action => l_on_operation_action
1425: );
1426:
1427: IF l_result = OE_PC_GLOBALS.YES THEN
1428: -- set OUT result to CONSTRAINED
1429: x_result := OE_PC_GLOBALS.YES;
1430: END IF;
1431:

Line 1429: x_result := OE_PC_GLOBALS.YES;

1425: );
1426:
1427: IF l_result = OE_PC_GLOBALS.YES THEN
1428: -- set OUT result to CONSTRAINED
1429: x_result := OE_PC_GLOBALS.YES;
1430: END IF;
1431:
1432: END IF;
1433:

Line 1443: IF l_result = OE_PC_GLOBALS.YES THEN

1439: ,p_record => l_rowtype_rec
1440: ,x_on_operation_action => l_on_operation_action
1441: );
1442:
1443: IF l_result = OE_PC_GLOBALS.YES THEN
1444: -- set OUT result to CONSTRAINED
1445: x_result := OE_PC_GLOBALS.YES;
1446: END IF;
1447:

Line 1445: x_result := OE_PC_GLOBALS.YES;

1441: );
1442:
1443: IF l_result = OE_PC_GLOBALS.YES THEN
1444: -- set OUT result to CONSTRAINED
1445: x_result := OE_PC_GLOBALS.YES;
1446: END IF;
1447:
1448: END IF;
1449:

Line 1459: IF l_result = OE_PC_GLOBALS.YES THEN

1455: ,p_record => l_rowtype_rec
1456: ,x_on_operation_action => l_on_operation_action
1457: );
1458:
1459: IF l_result = OE_PC_GLOBALS.YES THEN
1460: -- set OUT result to CONSTRAINED
1461: x_result := OE_PC_GLOBALS.YES;
1462: END IF;
1463:

Line 1461: x_result := OE_PC_GLOBALS.YES;

1457: );
1458:
1459: IF l_result = OE_PC_GLOBALS.YES THEN
1460: -- set OUT result to CONSTRAINED
1461: x_result := OE_PC_GLOBALS.YES;
1462: END IF;
1463:
1464: END IF;
1465:

Line 1475: IF l_result = OE_PC_GLOBALS.YES THEN

1471: ,p_record => l_rowtype_rec
1472: ,x_on_operation_action => l_on_operation_action
1473: );
1474:
1475: IF l_result = OE_PC_GLOBALS.YES THEN
1476: -- set OUT result to CONSTRAINED
1477: x_result := OE_PC_GLOBALS.YES;
1478: END IF;
1479:

Line 1477: x_result := OE_PC_GLOBALS.YES;

1473: );
1474:
1475: IF l_result = OE_PC_GLOBALS.YES THEN
1476: -- set OUT result to CONSTRAINED
1477: x_result := OE_PC_GLOBALS.YES;
1478: END IF;
1479:
1480: END IF;
1481:

Line 1491: IF l_result = OE_PC_GLOBALS.YES THEN

1487: ,p_record => l_rowtype_rec
1488: ,x_on_operation_action => l_on_operation_action
1489: );
1490:
1491: IF l_result = OE_PC_GLOBALS.YES THEN
1492: -- set OUT result to CONSTRAINED
1493: x_result := OE_PC_GLOBALS.YES;
1494: END IF;
1495:

Line 1493: x_result := OE_PC_GLOBALS.YES;

1489: );
1490:
1491: IF l_result = OE_PC_GLOBALS.YES THEN
1492: -- set OUT result to CONSTRAINED
1493: x_result := OE_PC_GLOBALS.YES;
1494: END IF;
1495:
1496: END IF;
1497:

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

1494: END IF;
1495:
1496: END IF;
1497:
1498: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1499: IF l_debug_level > 0 THEN
1500: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1501: END IF;
1502: g_check_all_cols_constraint := l_check_all_cols_constraint;