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

Line 42: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER

38: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
39: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
40: , p_operation => p_operation
41: , p_qualifier_attribute => p_record.transaction_phase_code
42: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER
43: , p_column_name => p_column_name
44: , p_check_all_cols_constraint => g_check_all_cols_constraint
45: , p_is_caller_defaulting => g_is_caller_defaulting
46: , x_constraint_id => l_constraint_id

Line 51: if l_result = OE_PC_GLOBALS.YES then

47: , x_constraining_conditions_grp => l_grp
48: , x_on_operation_action => x_on_operation_action
49: );
50:
51: if l_result = OE_PC_GLOBALS.YES then
52:
53: IF g_check_all_cols_constraint = 'Y'
54: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
55: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

Line 54: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP

50:
51: if l_result = OE_PC_GLOBALS.YES then
52:
53: IF g_check_all_cols_constraint = 'Y'
54: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
55: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
56: AND x_on_operation_action = 0
57: AND p_column_name IS NOT NULL THEN
58: SELECT column_name

Line 55: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

51: if l_result = OE_PC_GLOBALS.YES then
52:
53: IF g_check_all_cols_constraint = 'Y'
54: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
55: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
56: AND x_on_operation_action = 0
57: AND p_column_name IS NOT NULL THEN
58: SELECT column_name
59: INTO l_column_name

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 91: l_result = OE_PC_GLOBALS.YES And

87:
88: --Start Integration Framework Code
89:
90: If l_code_level >= '110510' And
91: l_result = OE_PC_GLOBALS.YES And
92: x_on_operation_action = 3 And
93: nvl(p_record.transaction_phase_code,'F') = 'F'
94: Then
95:

Line 137: l_result = OE_PC_GLOBALS.YES And

133:
134: End If;
135:
136: If l_code_level >= '110510' And
137: l_result = OE_PC_GLOBALS.YES And
138: x_on_operation_action = 0.05 And
139: nvl(p_record.transaction_phase_code,'F') = 'F'
140: Then
141:

Line 187: l_result = OE_PC_GLOBALS.YES And

183:
184: End If;
185:
186: If l_code_level >= '110510' And
187: l_result = OE_PC_GLOBALS.YES And
188: x_on_operation_action = 0.5 And
189: nvl(p_record.transaction_phase_code,'F') = 'F'
190: Then
191: If g_is_caller_defaulting = 'N' And

Line 257: IF l_result = OE_PC_GLOBALS.YES THEN

253: nvl(p_record.transaction_phase_code,'F') = 'F' and
254: not OE_GLOBALS.G_HEADER_CREATED THEN
255: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
256: IF p_record.booked_flag = 'Y' THEN
257: IF l_result = OE_PC_GLOBALS.YES THEN
258: IF x_on_operation_action = 1 THEN
259: -- set OUT result to NOT CONSTRAINED
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

Line 277: IF l_result = OE_PC_GLOBALS.YES THEN

273: END IF;
274: END IF;
275: END IF;
276: ELSE -- capture audit trail for all orders
277: IF l_result = OE_PC_GLOBALS.YES THEN
278: IF x_on_operation_action = 1 THEN
279: -- set OUT result to NOT CONSTRAINED
280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

Line 301: l_result := OE_PC_GLOBALS.NO;

297: END IF;
298:
299:
300: IF x_on_operation_action > 0 THEN
301: l_result := OE_PC_GLOBALS.NO;
302: END IF;
303: /* End AuditTrail */
304: RETURN l_result;
305:

Line 313: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

309: -- PUBLIC PROCEDURES
310:
311:
312: FUNCTION ACCOUNTING_RULE
313: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
314: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
315: , x_on_operation_action OUT NOCOPY NUMBER
316:
317: ) RETURN NUMBER

Line 334: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

330:
331: END ACCOUNTING_RULE;
332:
333: FUNCTION ACCOUNTING_RULE_DURATION
334: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
335: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
336: , x_on_operation_action OUT NOCOPY NUMBER
337:
338: ) RETURN NUMBER

Line 358: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

354:
355: -- Start of fix #1459428 for function definition
356:
357: FUNCTION ATTRIBUTE1
358: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
359: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
360: , x_on_operation_action OUT NOCOPY NUMBER
361:
362: ) RETURN NUMBER

Line 379: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

375:
376: END ATTRIBUTE1;
377:
378: FUNCTION ATTRIBUTE10
379: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
380: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
381: , x_on_operation_action OUT NOCOPY NUMBER
382:
383: ) RETURN NUMBER

Line 400: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

396:
397: END ATTRIBUTE10;
398:
399: FUNCTION ATTRIBUTE11
400: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
401: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
402: , x_on_operation_action OUT NOCOPY NUMBER
403:
404: ) RETURN NUMBER

Line 422: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

418: END ATTRIBUTE11;
419:
420:
421: FUNCTION ATTRIBUTE12
422: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
423: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
424: , x_on_operation_action OUT NOCOPY NUMBER
425:
426: ) RETURN NUMBER

Line 443: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

439:
440: END ATTRIBUTE12;
441:
442: FUNCTION ATTRIBUTE13
443: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
444: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
445: , x_on_operation_action OUT NOCOPY NUMBER
446:
447: ) RETURN NUMBER

Line 465: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

461: END ATTRIBUTE13;
462:
463:
464: FUNCTION ATTRIBUTE14
465: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
466: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
467: , x_on_operation_action OUT NOCOPY NUMBER
468:
469: ) RETURN NUMBER

Line 486: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

482:
483: END ATTRIBUTE14;
484:
485: FUNCTION ATTRIBUTE15
486: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
487: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
488: , x_on_operation_action OUT NOCOPY NUMBER
489:
490: ) RETURN NUMBER

Line 508: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

504: END ATTRIBUTE15;
505:
506: -- For bug 2184255
507: FUNCTION ATTRIBUTE16
508: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
509: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
510: , x_on_operation_action OUT NOCOPY NUMBER
511:
512: ) RETURN NUMBER

Line 530: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

526: END ATTRIBUTE16;
527:
528:
529: FUNCTION ATTRIBUTE17
530: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
531: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
532: , x_on_operation_action OUT NOCOPY NUMBER
533:
534: ) RETURN NUMBER

Line 551: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

547:
548: END ATTRIBUTE17;
549:
550: FUNCTION ATTRIBUTE18
551: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
552: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
553: , x_on_operation_action OUT NOCOPY NUMBER
554:
555: ) RETURN NUMBER

Line 573: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

569: END ATTRIBUTE18;
570:
571:
572: FUNCTION ATTRIBUTE19
573: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
574: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
575: , x_on_operation_action OUT NOCOPY NUMBER
576:
577: ) RETURN NUMBER

Line 595: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 616: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

612:
613: END ATTRIBUTE2;
614:
615: FUNCTION ATTRIBUTE20
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

Line 637: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

633:
634: END ATTRIBUTE20;
635:
636: FUNCTION ATTRIBUTE3
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

Line 659: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

655: END ATTRIBUTE3;
656:
657:
658: FUNCTION ATTRIBUTE4
659: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
660: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
661: , x_on_operation_action OUT NOCOPY NUMBER
662:
663: ) RETURN NUMBER

Line 680: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

676:
677: END ATTRIBUTE4;
678:
679: FUNCTION ATTRIBUTE5
680: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
681: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
682: , x_on_operation_action OUT NOCOPY NUMBER
683:
684: ) RETURN NUMBER

Line 702: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

698: END ATTRIBUTE5;
699:
700:
701: FUNCTION ATTRIBUTE6
702: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
703: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
704: , x_on_operation_action OUT NOCOPY NUMBER
705:
706: ) RETURN NUMBER

Line 723: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

719:
720: END ATTRIBUTE6;
721:
722: FUNCTION ATTRIBUTE7
723: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
724: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
725: , x_on_operation_action OUT NOCOPY NUMBER
726:
727: ) RETURN NUMBER

Line 745: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

741: END ATTRIBUTE7;
742:
743:
744: FUNCTION ATTRIBUTE8
745: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
746: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
747: , x_on_operation_action OUT NOCOPY NUMBER
748:
749: ) RETURN NUMBER

Line 766: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

762:
763: END ATTRIBUTE8;
764:
765: FUNCTION ATTRIBUTE9
766: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
767: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
768: , x_on_operation_action OUT NOCOPY NUMBER
769:
770: ) RETURN NUMBER

Line 787: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 797: (p_operation => OE_PC_GLOBALS.CANCEL_OP

793: l_result NUMBER;
794: BEGIN
795:
796: l_result := Is_OP_constrained
797: (p_operation => OE_PC_GLOBALS.CANCEL_OP
798: ,p_column_name => null
799: ,p_record => p_record
800: ,x_on_operation_action => x_on_operation_action
801: );

Line 808: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

804:
805: END CANCELLED;
806:
807: FUNCTION AGREEMENT
808: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
809: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
810: , x_on_operation_action OUT NOCOPY NUMBER
811:
812: ) RETURN NUMBER

Line 829: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

825:
826: END AGREEMENT;
827:
828: FUNCTION CONTEXT
829: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
830: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
831: , x_on_operation_action OUT NOCOPY NUMBER
832:
833: ) RETURN NUMBER

Line 852: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

848:
849: -- End of fix #1459428 for function definition
850:
851: FUNCTION CONVERSION_RATE
852: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
853: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
854: , x_on_operation_action OUT NOCOPY NUMBER
855:
856: ) RETURN NUMBER

Line 874: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

870: END CONVERSION_RATE;
871:
872:
873: FUNCTION CONVERSION_RATE_DATE
874: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
875: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
876: , x_on_operation_action OUT NOCOPY NUMBER
877:
878: ) RETURN NUMBER

Line 895: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

891:
892: END CONVERSION_RATE_DATE;
893:
894: FUNCTION CUSTOMER_PREFERENCE_SET
895: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
896: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
897: , x_on_operation_action OUT NOCOPY NUMBER
898:
899: ) RETURN NUMBER

Line 916: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

912:
913: END CUSTOMER_PREFERENCE_SET;
914:
915: FUNCTION CONVERSION_TYPE
916: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
917: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
918: , x_on_operation_action OUT NOCOPY NUMBER
919:
920: ) RETURN NUMBER

Line 938: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

934: END CONVERSION_TYPE;
935:
936:
937: FUNCTION CREATED_BY
938: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
939: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
940: , x_on_operation_action OUT NOCOPY NUMBER
941:
942: ) RETURN NUMBER

Line 960: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

956: END CREATED_BY;
957:
958:
959: FUNCTION CUST_PO_NUMBER
960: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
961: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
962: , x_on_operation_action OUT NOCOPY NUMBER
963:
964: ) RETURN NUMBER

Line 982: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

978: END CUST_PO_NUMBER;
979:
980:
981: FUNCTION DELIVER_TO_CONTACT
982: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
983: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
984: , x_on_operation_action OUT NOCOPY NUMBER
985:
986: ) RETURN NUMBER

Line 1003: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

999:
1000: END DELIVER_TO_CONTACT;
1001:
1002: FUNCTION IB_OWNER
1003: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1004: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1005: , x_on_operation_action OUT NOCOPY NUMBER
1006:
1007: ) RETURN NUMBER

Line 1024: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1020:
1021: END IB_OWNER;
1022:
1023: FUNCTION IB_INSTALLED_AT_LOCATION
1024: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1025: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1026: , x_on_operation_action OUT NOCOPY NUMBER
1027:
1028: ) RETURN NUMBER

Line 1045: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1041:
1042: END IB_INSTALLED_AT_LOCATION;
1043:
1044: FUNCTION IB_CURRENT_LOCATION
1045: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1046: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1047: , x_on_operation_action OUT NOCOPY NUMBER
1048:
1049: ) RETURN NUMBER

Line 1066: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1062:
1063: END IB_CURRENT_LOCATION;
1064:
1065: FUNCTION END_CUSTOMER_CONTACT
1066: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1067: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1068: , x_on_operation_action OUT NOCOPY NUMBER
1069:
1070: ) RETURN NUMBER

Line 1088: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1084: END END_CUSTOMER_CONTACT;
1085:
1086:
1087: FUNCTION END_CUSTOMER_SITE_USE
1088: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1089: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1090: , x_on_operation_action OUT NOCOPY NUMBER
1091:
1092: ) RETURN NUMBER

Line 1110: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1106: END END_CUSTOMER_SITE_USE;
1107:
1108:
1109: FUNCTION END_CUSTOMER
1110: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1111: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1112: , x_on_operation_action OUT NOCOPY NUMBER
1113:
1114: ) RETURN NUMBER

Line 1132: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1128: END END_CUSTOMER;
1129:
1130:
1131: FUNCTION DELIVER_TO_ORG
1132: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1133: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1134: , x_on_operation_action OUT NOCOPY NUMBER
1135:
1136: ) RETURN NUMBER

Line 1154: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1150: END DELIVER_TO_ORG;
1151:
1152:
1153: FUNCTION DEMAND_CLASS
1154: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1155: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1156: , x_on_operation_action OUT NOCOPY NUMBER
1157:
1158: ) RETURN NUMBER

Line 1175: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1171:
1172: END DEMAND_CLASS;
1173:
1174: FUNCTION EARLIEST_SCHEDULE_LIMIT
1175: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1176: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1177: , x_on_operation_action OUT NOCOPY NUMBER
1178:
1179: ) RETURN NUMBER

Line 1196: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1192:
1193: END EARLIEST_SCHEDULE_LIMIT;
1194:
1195: FUNCTION FOB_POINT
1196: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1197: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1198: , x_on_operation_action OUT NOCOPY NUMBER
1199:
1200: ) RETURN NUMBER

Line 1218: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1214: END FOB_POINT;
1215:
1216:
1217: FUNCTION FREIGHT_CARRIER
1218: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1219: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1220: , x_on_operation_action OUT NOCOPY NUMBER
1221:
1222: ) RETURN NUMBER

Line 1240: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1236: END FREIGHT_CARRIER;
1237:
1238:
1239: FUNCTION FREIGHT_TERMS
1240: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1241: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1242: , x_on_operation_action OUT NOCOPY NUMBER
1243:
1244: ) RETURN NUMBER

Line 1261: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1257:
1258: END FREIGHT_TERMS;
1259:
1260: FUNCTION INVOICE_TO_CONTACT
1261: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1262: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1263: , x_on_operation_action OUT NOCOPY NUMBER
1264:
1265: ) RETURN NUMBER

Line 1282: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1278:
1279: END INVOICE_TO_CONTACT;
1280:
1281: FUNCTION INVOICE_TO_ORG
1282: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1283: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1284: , x_on_operation_action OUT NOCOPY NUMBER
1285:
1286: ) RETURN NUMBER

Line 1303: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1299:
1300: END INVOICE_TO_ORG;
1301:
1302: FUNCTION INVOICING_RULE
1303: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1304: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1305: , x_on_operation_action OUT NOCOPY NUMBER
1306:
1307: ) RETURN NUMBER

Line 1324: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1320:
1321: END INVOICING_RULE;
1322:
1323: FUNCTION LATEST_SCHEDULE_LIMIT
1324: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1325: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1326: , x_on_operation_action OUT NOCOPY NUMBER
1327:
1328: ) RETURN NUMBER

Line 1346: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1342: END LATEST_SCHEDULE_LIMIT;
1343:
1344:
1345: FUNCTION ORDERED_DATE
1346: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1347: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1348: , x_on_operation_action OUT NOCOPY NUMBER
1349:
1350: ) RETURN NUMBER

Line 1368: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1364: END ORDERED_DATE;
1365:
1366:
1367: FUNCTION ORDER_DATE_TYPE_CODE
1368: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1369: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1370: , x_on_operation_action OUT NOCOPY NUMBER
1371:
1372: ) RETURN NUMBER

Line 1389: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1385:
1386: END ORDER_DATE_TYPE_CODE;
1387:
1388: FUNCTION ORDER_NUMBER
1389: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1390: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1391: , x_on_operation_action OUT NOCOPY NUMBER
1392:
1393: ) RETURN NUMBER

Line 1411: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1407: END ORDER_NUMBER;
1408:
1409:
1410: FUNCTION ORDER_SOURCE
1411: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1412: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1413: , x_on_operation_action OUT NOCOPY NUMBER
1414:
1415: ) RETURN NUMBER

Line 1433: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1429: END ORDER_SOURCE;
1430:
1431:
1432: FUNCTION ORDER_TYPE
1433: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1434: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1435: , x_on_operation_action OUT NOCOPY NUMBER
1436:
1437: ) RETURN NUMBER

Line 1456: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1452:
1453:
1454:
1455: FUNCTION ORIG_SYS_DOCUMENT_REF
1456: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1457: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1458: , x_on_operation_action OUT NOCOPY NUMBER
1459:
1460: ) RETURN NUMBER

Line 1477: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1473:
1474: END ORIG_SYS_DOCUMENT_REF;
1475:
1476: FUNCTION PACKING_INSTRUCTIONS
1477: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1478: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1479: , x_on_operation_action OUT NOCOPY NUMBER
1480:
1481: ) RETURN NUMBER

Line 1499: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1495: END PACKING_INSTRUCTIONS;
1496:
1497:
1498: FUNCTION PAYMENT_TERM
1499: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1500: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1501: , x_on_operation_action OUT NOCOPY NUMBER
1502:
1503: ) RETURN NUMBER

Line 1521: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1517: END PAYMENT_TERM;
1518:
1519:
1520: FUNCTION PRICE_LIST
1521: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1522: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1523: , x_on_operation_action OUT NOCOPY NUMBER
1524:
1525: ) RETURN NUMBER

Line 1543: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1539: END PRICE_LIST;
1540:
1541:
1542: FUNCTION PRICING_DATE
1543: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1544: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1545: , x_on_operation_action OUT NOCOPY NUMBER
1546:
1547: ) RETURN NUMBER

Line 1564: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1560:
1561: END PRICING_DATE;
1562:
1563: FUNCTION REQUEST_DATE
1564: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1565: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1566: , x_on_operation_action OUT NOCOPY NUMBER
1567:
1568: ) RETURN NUMBER

Line 1586: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1582: END REQUEST_DATE;
1583:
1584:
1585: FUNCTION RETURN_REASON
1586: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1587: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1588: , x_on_operation_action OUT NOCOPY NUMBER
1589:
1590: ) RETURN NUMBER

Line 1608: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1604: END RETURN_REASON;
1605:
1606:
1607: FUNCTION SALESREP
1608: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1609: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1610: , x_on_operation_action OUT NOCOPY NUMBER
1611:
1612: ) RETURN NUMBER

Line 1630: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1626: END SALESREP;
1627:
1628:
1629: FUNCTION SHIPMENT_PRIORITY
1630: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1631: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1632: , x_on_operation_action OUT NOCOPY NUMBER
1633:
1634: ) RETURN NUMBER

Line 1651: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1647:
1648: END SHIPMENT_PRIORITY;
1649:
1650: FUNCTION SHIPPING_INSTRUCTIONS
1651: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1652: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1653: , x_on_operation_action OUT NOCOPY NUMBER
1654:
1655: ) RETURN NUMBER

Line 1672: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1668:
1669: END SHIPPING_INSTRUCTIONS;
1670:
1671: FUNCTION SHIPPING_METHOD
1672: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1673: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1674: , x_on_operation_action OUT NOCOPY NUMBER
1675:
1676: ) RETURN NUMBER

Line 1693: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1689:
1690: END SHIPPING_METHOD;
1691:
1692: FUNCTION SHIP_FROM_ORG
1693: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1694: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1695: , x_on_operation_action OUT NOCOPY NUMBER
1696:
1697: ) RETURN NUMBER

Line 1715: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1711: END SHIP_FROM_ORG;
1712:
1713:
1714: FUNCTION SHIP_TOLERANCE_ABOVE
1715: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1716: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1717: , x_on_operation_action OUT NOCOPY NUMBER
1718:
1719: ) RETURN NUMBER

Line 1737: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1733: END SHIP_TOLERANCE_ABOVE;
1734:
1735:
1736: FUNCTION SHIP_TOLERANCE_BELOW
1737: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1738: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1739: , x_on_operation_action OUT NOCOPY NUMBER
1740:
1741: ) RETURN NUMBER

Line 1759: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1755: END SHIP_TOLERANCE_BELOW;
1756:
1757:
1758: FUNCTION SHIP_TO_CONTACT
1759: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1760: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1761: , x_on_operation_action OUT NOCOPY NUMBER
1762:
1763: ) RETURN NUMBER

Line 1781: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1777: END SHIP_TO_CONTACT;
1778:
1779:
1780: FUNCTION SHIP_TO_ORG
1781: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1782: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1783: , x_on_operation_action OUT NOCOPY NUMBER
1784:
1785: ) RETURN NUMBER

Line 1803: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1799: END SHIP_TO_ORG;
1800:
1801:
1802: FUNCTION SOLD_TO_CONTACT
1803: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1804: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1805: , x_on_operation_action OUT NOCOPY NUMBER
1806:
1807: ) RETURN NUMBER

Line 1825: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1821: END SOLD_TO_CONTACT;
1822:
1823:
1824: FUNCTION SOLD_TO_ORG
1825: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1826: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1827: , x_on_operation_action OUT NOCOPY NUMBER
1828:
1829: ) RETURN NUMBER

Line 1847: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1843: END SOLD_TO_ORG;
1844:
1845:
1846: FUNCTION SOURCE_DOCUMENT_TYPE
1847: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1848: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1849: , x_on_operation_action OUT NOCOPY NUMBER
1850:
1851: ) RETURN NUMBER

Line 1869: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1865: END SOURCE_DOCUMENT_TYPE;
1866:
1867:
1868: FUNCTION TAX_EXEMPT
1869: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1870: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1871: , x_on_operation_action OUT NOCOPY NUMBER
1872:
1873: ) RETURN NUMBER

Line 1891: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1887: END TAX_EXEMPT;
1888:
1889:
1890: FUNCTION TAX_EXEMPT_NUMBER
1891: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1892: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1893: , x_on_operation_action OUT NOCOPY NUMBER
1894:
1895: ) RETURN NUMBER

Line 1913: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1909: END TAX_EXEMPT_NUMBER;
1910:
1911:
1912: FUNCTION TAX_EXEMPT_REASON
1913: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1914: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1915: , x_on_operation_action OUT NOCOPY NUMBER
1916:
1917: ) RETURN NUMBER

Line 1936: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1932:
1933:
1934:
1935: FUNCTION TRANSACTIONAL_CURR
1936: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1937: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1938: , x_on_operation_action OUT NOCOPY NUMBER
1939:
1940: ) RETURN NUMBER

Line 1958: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1954: END TRANSACTIONAL_CURR;
1955:
1956:
1957: FUNCTION CREDIT_CARD_APPROVAL_DATE
1958: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1959: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1960: , x_on_operation_action OUT NOCOPY NUMBER
1961:
1962: ) RETURN NUMBER

Line 1982: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1978: /* The following Function is added to fix the issue #1651331 to enable
1979: the Sales Channel Field be allowed to set the security rules */
1980:
1981: FUNCTION SALES_CHANNEL_CODE
1982: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1983: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1984: , x_on_operation_action OUT NOCOPY NUMBER
1985:
1986: ) RETURN NUMBER

Line 2004: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2000: END SALES_CHANNEL_CODE;
2001:
2002: /* START PREPAYMENT */
2003: FUNCTION PAYMENT_TYPE
2004: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2005: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2006: , x_on_operation_action OUT NOCOPY NUMBER
2007:
2008: ) RETURN NUMBER

Line 2025: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2021:
2022: END PAYMENT_TYPE;
2023:
2024: FUNCTION CREDIT_CARD_HOLDER_NAME
2025: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2026: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2027: , x_on_operation_action OUT NOCOPY NUMBER
2028:
2029: ) RETURN NUMBER

Line 2046: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2042:
2043: END CREDIT_CARD_HOLDER_NAME;
2044:
2045: FUNCTION CREDIT_CARD
2046: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2047: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2048: , x_on_operation_action OUT NOCOPY NUMBER
2049:
2050: ) RETURN NUMBER

Line 2067: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2063:
2064: END CREDIT_CARD;
2065:
2066: FUNCTION CREDIT_CARD_NUMBER
2067: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2068: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2069: , x_on_operation_action OUT NOCOPY NUMBER
2070:
2071: ) RETURN NUMBER

Line 2088: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2084:
2085: END CREDIT_CARD_NUMBER;
2086:
2087: FUNCTION CREDIT_CARD_EXPIRATION_DATE
2088: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2089: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2090: , x_on_operation_action OUT NOCOPY NUMBER
2091:
2092: ) RETURN NUMBER

Line 2112: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2108:
2109: /* For bug 2395032 */
2110:
2111: FUNCTION PAYMENT_AMOUNT
2112: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2113: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2114: , x_on_operation_action OUT NOCOPY NUMBER
2115:
2116: ) RETURN NUMBER

Line 2133: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2129:
2130: END PAYMENT_AMOUNT;
2131:
2132: FUNCTION CHECK_NUMBER
2133: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2134: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2135: , x_on_operation_action OUT NOCOPY NUMBER
2136:
2137: ) RETURN NUMBER

Line 2156: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2152:
2153: /* End 2395032 */
2154:
2155: FUNCTION BLANKET_NUMBER
2156: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2157: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2158: , x_on_operation_action OUT NOCOPY NUMBER
2159:
2160: ) RETURN NUMBER

Line 2179: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2175:
2176: -- QUOTING changes
2177:
2178: FUNCTION QUOTE_NUMBER
2179: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2180: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2181: , x_on_operation_action OUT NOCOPY NUMBER
2182:
2183: ) RETURN NUMBER

Line 2200: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2196:
2197: END QUOTE_NUMBER;
2198:
2199: FUNCTION QUOTE_DATE
2200: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2201: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2202: , x_on_operation_action OUT NOCOPY NUMBER
2203:
2204: ) RETURN NUMBER

Line 2221: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2217:
2218: END QUOTE_DATE;
2219:
2220: FUNCTION SALES_DOCUMENT_NAME
2221: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2222: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2223: , x_on_operation_action OUT NOCOPY NUMBER
2224:
2225: ) RETURN NUMBER

Line 2242: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2238:
2239: END SALES_DOCUMENT_NAME;
2240:
2241: FUNCTION TRANSACTION_PHASE
2242: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2243: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2244: , x_on_operation_action OUT NOCOPY NUMBER
2245:
2246: ) RETURN NUMBER

Line 2263: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2259:
2260: END TRANSACTION_PHASE;
2261:
2262: FUNCTION USER_STATUS
2263: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2264: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2265: , x_on_operation_action OUT NOCOPY NUMBER
2266:
2267: ) RETURN NUMBER

Line 2284: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2280:
2281: END USER_STATUS;
2282:
2283: FUNCTION EXPIRATION_DATE
2284: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2285: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2286: , x_on_operation_action OUT NOCOPY NUMBER
2287:
2288: ) RETURN NUMBER

Line 2305: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2301:
2302: END EXPIRATION_DATE;
2303:
2304: FUNCTION VERSION_NUMBER
2305: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2306: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2307: , x_on_operation_action OUT NOCOPY NUMBER
2308:
2309: ) RETURN NUMBER

Line 2326: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2322:
2323: END VERSION_NUMBER;
2324:
2325: FUNCTION SOLD_TO_SITE_USE
2326: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2327: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2328: , x_on_operation_action OUT NOCOPY NUMBER
2329:
2330: ) RETURN NUMBER

Line 2372: l_operation := OE_PC_GLOBALS.CREATE_OP;

2368: -- Initializing return status to SUCCESS
2369: x_return_status := FND_API.G_RET_STS_SUCCESS;
2370:
2371: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2372: l_operation := OE_PC_GLOBALS.CREATE_OP;
2373: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2374: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2375: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2376: l_operation := OE_PC_GLOBALS.DELETE_OP;

Line 2374: l_operation := OE_PC_GLOBALS.UPDATE_OP;

2370:
2371: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2372: l_operation := OE_PC_GLOBALS.CREATE_OP;
2373: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2374: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2375: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2376: l_operation := OE_PC_GLOBALS.DELETE_OP;
2377: ELSE
2378: IF l_debug_level > 0 THEN

Line 2376: l_operation := OE_PC_GLOBALS.DELETE_OP;

2372: l_operation := OE_PC_GLOBALS.CREATE_OP;
2373: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2374: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2375: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2376: l_operation := OE_PC_GLOBALS.DELETE_OP;
2377: ELSE
2378: IF l_debug_level > 0 THEN
2379: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2380: END IF;

Line 2440: x_result := OE_PC_GLOBALS.NO;

2436: -- Initializing return status to SUCCESS
2437: x_return_status := FND_API.G_RET_STS_SUCCESS;
2438:
2439: -- Initializing out result to NOT CONSTRAINED
2440: x_result := OE_PC_GLOBALS.NO;
2441:
2442: -- Get the operation code to be passed to the security framework API
2443: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2444: -- Bug 1987983 : if the order source is Copy then skip the Attribute

Line 2450: l_operation := OE_PC_GLOBALS.CREATE_OP;

2446: IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
2447: THEN
2448: RETURN;
2449: ELSE
2450: l_operation := OE_PC_GLOBALS.CREATE_OP;
2451: END IF;
2452: -- Bug 1755817: if there are no attribute-specific insert
2453: -- constraints, then no need to go further. Entity level
2454: -- security check for CREATE will be called again from

Line 2457: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER

2453: -- constraints, then no need to go further. Entity level
2454: -- security check for CREATE will be called again from
2455: -- process order after defaulting.
2456: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
2457: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER
2458: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
2459: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
2460: )
2461: THEN

Line 2466: l_operation := OE_PC_GLOBALS.UPDATE_OP;

2462: RETURN;
2463: END IF;
2464:
2465: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2466: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2467: ELSE
2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2470: END IF;

Line 2492: IF l_result = OE_PC_GLOBALS.YES THEN

2488: (p_operation => l_operation
2489: ,p_record => l_rowtype_rec
2490: ,x_on_operation_action => l_on_operation_action
2491: );
2492: IF l_result = OE_PC_GLOBALS.YES THEN
2493: -- set OUT result to CONSTRAINED
2494: x_result := OE_PC_GLOBALS.YES;
2495: --RAISE;
2496: END IF;

Line 2494: x_result := OE_PC_GLOBALS.YES;

2490: ,x_on_operation_action => l_on_operation_action
2491: );
2492: IF l_result = OE_PC_GLOBALS.YES THEN
2493: -- set OUT result to CONSTRAINED
2494: x_result := OE_PC_GLOBALS.YES;
2495: --RAISE;
2496: END IF;
2497: END IF;
2498:

Line 2535: IF l_result = OE_PC_GLOBALS.YES THEN

2531: ,p_record => l_rowtype_rec
2532: ,x_on_operation_action => l_on_operation_action
2533: );
2534:
2535: IF l_result = OE_PC_GLOBALS.YES THEN
2536: -- set OUT result to CONSTRAINED
2537: x_result := OE_PC_GLOBALS.YES;
2538: END IF;
2539:

Line 2537: x_result := OE_PC_GLOBALS.YES;

2533: );
2534:
2535: IF l_result = OE_PC_GLOBALS.YES THEN
2536: -- set OUT result to CONSTRAINED
2537: x_result := OE_PC_GLOBALS.YES;
2538: END IF;
2539:
2540: END IF;
2541:

Line 2551: IF l_result = OE_PC_GLOBALS.YES THEN

2547: ,p_record => l_rowtype_rec
2548: ,x_on_operation_action => l_on_operation_action
2549: );
2550:
2551: IF l_result = OE_PC_GLOBALS.YES THEN
2552: -- set OUT result to CONSTRAINED
2553: x_result := OE_PC_GLOBALS.YES;
2554: END IF;
2555:

Line 2553: x_result := OE_PC_GLOBALS.YES;

2549: );
2550:
2551: IF l_result = OE_PC_GLOBALS.YES THEN
2552: -- set OUT result to CONSTRAINED
2553: x_result := OE_PC_GLOBALS.YES;
2554: END IF;
2555:
2556: END IF;
2557: IF p_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;

Line 2566: IF l_result = OE_PC_GLOBALS.YES THEN

2562: ,p_record => l_rowtype_rec
2563: ,x_on_operation_action => l_on_operation_action
2564: );
2565:
2566: IF l_result = OE_PC_GLOBALS.YES THEN
2567: -- set OUT result to CONSTRAINED
2568: x_result := OE_PC_GLOBALS.YES;
2569: END IF;
2570:

Line 2568: x_result := OE_PC_GLOBALS.YES;

2564: );
2565:
2566: IF l_result = OE_PC_GLOBALS.YES THEN
2567: -- set OUT result to CONSTRAINED
2568: x_result := OE_PC_GLOBALS.YES;
2569: END IF;
2570:
2571: END IF;
2572: IF p_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;

Line 2581: IF l_result = OE_PC_GLOBALS.YES THEN

2577: ,p_record => l_rowtype_rec
2578: ,x_on_operation_action => l_on_operation_action
2579: );
2580:
2581: IF l_result = OE_PC_GLOBALS.YES THEN
2582: -- set OUT result to CONSTRAINED
2583: x_result := OE_PC_GLOBALS.YES;
2584: END IF;
2585:

Line 2583: x_result := OE_PC_GLOBALS.YES;

2579: );
2580:
2581: IF l_result = OE_PC_GLOBALS.YES THEN
2582: -- set OUT result to CONSTRAINED
2583: x_result := OE_PC_GLOBALS.YES;
2584: END IF;
2585:
2586: END IF;
2587: IF p_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;

Line 2596: IF l_result = OE_PC_GLOBALS.YES THEN

2592: ,p_record => l_rowtype_rec
2593: ,x_on_operation_action => l_on_operation_action
2594: );
2595:
2596: IF l_result = OE_PC_GLOBALS.YES THEN
2597: -- set OUT result to CONSTRAINED
2598: x_result := OE_PC_GLOBALS.YES;
2599: END IF;
2600:

Line 2598: x_result := OE_PC_GLOBALS.YES;

2594: );
2595:
2596: IF l_result = OE_PC_GLOBALS.YES THEN
2597: -- set OUT result to CONSTRAINED
2598: x_result := OE_PC_GLOBALS.YES;
2599: END IF;
2600:
2601: END IF;
2602: IF p_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;

Line 2611: IF l_result = OE_PC_GLOBALS.YES THEN

2607: ,p_record => l_rowtype_rec
2608: ,x_on_operation_action => l_on_operation_action
2609: );
2610:
2611: IF l_result = OE_PC_GLOBALS.YES THEN
2612: -- set OUT result to CONSTRAINED
2613: x_result := OE_PC_GLOBALS.YES;
2614: END IF;
2615:

Line 2613: x_result := OE_PC_GLOBALS.YES;

2609: );
2610:
2611: IF l_result = OE_PC_GLOBALS.YES THEN
2612: -- set OUT result to CONSTRAINED
2613: x_result := OE_PC_GLOBALS.YES;
2614: END IF;
2615:
2616: END IF;
2617: IF p_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;

Line 2626: IF l_result = OE_PC_GLOBALS.YES THEN

2622: ,p_record => l_rowtype_rec
2623: ,x_on_operation_action => l_on_operation_action
2624: );
2625:
2626: IF l_result = OE_PC_GLOBALS.YES THEN
2627: -- set OUT result to CONSTRAINED
2628: x_result := OE_PC_GLOBALS.YES;
2629: END IF;
2630:

Line 2628: x_result := OE_PC_GLOBALS.YES;

2624: );
2625:
2626: IF l_result = OE_PC_GLOBALS.YES THEN
2627: -- set OUT result to CONSTRAINED
2628: x_result := OE_PC_GLOBALS.YES;
2629: END IF;
2630:
2631: END IF;
2632:

Line 2642: IF l_result = OE_PC_GLOBALS.YES THEN

2638: ,p_record => l_rowtype_rec
2639: ,x_on_operation_action => l_on_operation_action
2640: );
2641:
2642: IF l_result = OE_PC_GLOBALS.YES THEN
2643: -- set OUT result to CONSTRAINED
2644: x_result := OE_PC_GLOBALS.YES;
2645: END IF;
2646:

Line 2644: x_result := OE_PC_GLOBALS.YES;

2640: );
2641:
2642: IF l_result = OE_PC_GLOBALS.YES THEN
2643: -- set OUT result to CONSTRAINED
2644: x_result := OE_PC_GLOBALS.YES;
2645: END IF;
2646:
2647: END IF;
2648:

Line 2658: IF l_result = OE_PC_GLOBALS.YES THEN

2654: ,p_record => l_rowtype_rec
2655: ,x_on_operation_action => l_on_operation_action
2656: );
2657:
2658: IF l_result = OE_PC_GLOBALS.YES THEN
2659: -- set OUT result to CONSTRAINED
2660: x_result := OE_PC_GLOBALS.YES;
2661: END IF;
2662:

Line 2660: x_result := OE_PC_GLOBALS.YES;

2656: );
2657:
2658: IF l_result = OE_PC_GLOBALS.YES THEN
2659: -- set OUT result to CONSTRAINED
2660: x_result := OE_PC_GLOBALS.YES;
2661: END IF;
2662:
2663: END IF;
2664:

Line 2674: IF l_result = OE_PC_GLOBALS.YES THEN

2670: ,p_record => l_rowtype_rec
2671: ,x_on_operation_action => l_on_operation_action
2672: );
2673:
2674: IF l_result = OE_PC_GLOBALS.YES THEN
2675: -- set OUT result to CONSTRAINED
2676: x_result := OE_PC_GLOBALS.YES;
2677: END IF;
2678:

Line 2676: x_result := OE_PC_GLOBALS.YES;

2672: );
2673:
2674: IF l_result = OE_PC_GLOBALS.YES THEN
2675: -- set OUT result to CONSTRAINED
2676: x_result := OE_PC_GLOBALS.YES;
2677: END IF;
2678:
2679: END IF;
2680:

Line 2690: IF l_result = OE_PC_GLOBALS.YES THEN

2686: ,p_record => l_rowtype_rec
2687: ,x_on_operation_action => l_on_operation_action
2688: );
2689:
2690: IF l_result = OE_PC_GLOBALS.YES THEN
2691: -- set OUT result to CONSTRAINED
2692: x_result := OE_PC_GLOBALS.YES;
2693: END IF;
2694:

Line 2692: x_result := OE_PC_GLOBALS.YES;

2688: );
2689:
2690: IF l_result = OE_PC_GLOBALS.YES THEN
2691: -- set OUT result to CONSTRAINED
2692: x_result := OE_PC_GLOBALS.YES;
2693: END IF;
2694:
2695: END IF;
2696:

Line 2706: IF l_result = OE_PC_GLOBALS.YES THEN

2702: ,p_record => l_rowtype_rec
2703: ,x_on_operation_action => l_on_operation_action
2704: );
2705:
2706: IF l_result = OE_PC_GLOBALS.YES THEN
2707: -- set OUT result to CONSTRAINED
2708: x_result := OE_PC_GLOBALS.YES;
2709: END IF;
2710:

Line 2708: x_result := OE_PC_GLOBALS.YES;

2704: );
2705:
2706: IF l_result = OE_PC_GLOBALS.YES THEN
2707: -- set OUT result to CONSTRAINED
2708: x_result := OE_PC_GLOBALS.YES;
2709: END IF;
2710:
2711: END IF;
2712:

Line 2722: IF l_result = OE_PC_GLOBALS.YES THEN

2718: ,p_record => l_rowtype_rec
2719: ,x_on_operation_action => l_on_operation_action
2720: );
2721:
2722: IF l_result = OE_PC_GLOBALS.YES THEN
2723: -- set OUT result to CONSTRAINED
2724: x_result := OE_PC_GLOBALS.YES;
2725: END IF;
2726:

Line 2724: x_result := OE_PC_GLOBALS.YES;

2720: );
2721:
2722: IF l_result = OE_PC_GLOBALS.YES THEN
2723: -- set OUT result to CONSTRAINED
2724: x_result := OE_PC_GLOBALS.YES;
2725: END IF;
2726:
2727: END IF;
2728:

Line 2738: IF l_result = OE_PC_GLOBALS.YES THEN

2734: ,p_record => l_rowtype_rec
2735: ,x_on_operation_action => l_on_operation_action
2736: );
2737:
2738: IF l_result = OE_PC_GLOBALS.YES THEN
2739: -- set OUT result to CONSTRAINED
2740: x_result := OE_PC_GLOBALS.YES;
2741: END IF;
2742:

Line 2740: x_result := OE_PC_GLOBALS.YES;

2736: );
2737:
2738: IF l_result = OE_PC_GLOBALS.YES THEN
2739: -- set OUT result to CONSTRAINED
2740: x_result := OE_PC_GLOBALS.YES;
2741: END IF;
2742:
2743: END IF;
2744:

Line 2754: IF l_result = OE_PC_GLOBALS.YES THEN

2750: ,p_record => l_rowtype_rec
2751: ,x_on_operation_action => l_on_operation_action
2752: );
2753:
2754: IF l_result = OE_PC_GLOBALS.YES THEN
2755: -- set OUT result to CONSTRAINED
2756: x_result := OE_PC_GLOBALS.YES;
2757: END IF;
2758:

Line 2756: x_result := OE_PC_GLOBALS.YES;

2752: );
2753:
2754: IF l_result = OE_PC_GLOBALS.YES THEN
2755: -- set OUT result to CONSTRAINED
2756: x_result := OE_PC_GLOBALS.YES;
2757: END IF;
2758:
2759: END IF;
2760:

Line 2770: IF l_result = OE_PC_GLOBALS.YES THEN

2766: ,p_record => l_rowtype_rec
2767: ,x_on_operation_action => l_on_operation_action
2768: );
2769:
2770: IF l_result = OE_PC_GLOBALS.YES THEN
2771: -- set OUT result to CONSTRAINED
2772: x_result := OE_PC_GLOBALS.YES;
2773: END IF;
2774:

Line 2772: x_result := OE_PC_GLOBALS.YES;

2768: );
2769:
2770: IF l_result = OE_PC_GLOBALS.YES THEN
2771: -- set OUT result to CONSTRAINED
2772: x_result := OE_PC_GLOBALS.YES;
2773: END IF;
2774:
2775: END IF;
2776:

Line 2786: IF l_result = OE_PC_GLOBALS.YES THEN

2782: ,p_record => l_rowtype_rec
2783: ,x_on_operation_action => l_on_operation_action
2784: );
2785:
2786: IF l_result = OE_PC_GLOBALS.YES THEN
2787: -- set OUT result to CONSTRAINED
2788: x_result := OE_PC_GLOBALS.YES;
2789: END IF;
2790:

Line 2788: x_result := OE_PC_GLOBALS.YES;

2784: );
2785:
2786: IF l_result = OE_PC_GLOBALS.YES THEN
2787: -- set OUT result to CONSTRAINED
2788: x_result := OE_PC_GLOBALS.YES;
2789: END IF;
2790:
2791: END IF;
2792:

Line 2802: IF l_result = OE_PC_GLOBALS.YES THEN

2798: ,p_record => l_rowtype_rec
2799: ,x_on_operation_action => l_on_operation_action
2800: );
2801:
2802: IF l_result = OE_PC_GLOBALS.YES THEN
2803: -- set OUT result to CONSTRAINED
2804: x_result := OE_PC_GLOBALS.YES;
2805: END IF;
2806:

Line 2804: x_result := OE_PC_GLOBALS.YES;

2800: );
2801:
2802: IF l_result = OE_PC_GLOBALS.YES THEN
2803: -- set OUT result to CONSTRAINED
2804: x_result := OE_PC_GLOBALS.YES;
2805: END IF;
2806:
2807: END IF;
2808:

Line 2818: IF l_result = OE_PC_GLOBALS.YES THEN

2814: ,p_record => l_rowtype_rec
2815: ,x_on_operation_action => l_on_operation_action
2816: );
2817:
2818: IF l_result = OE_PC_GLOBALS.YES THEN
2819: -- set OUT result to CONSTRAINED
2820: x_result := OE_PC_GLOBALS.YES;
2821: END IF;
2822:

Line 2820: x_result := OE_PC_GLOBALS.YES;

2816: );
2817:
2818: IF l_result = OE_PC_GLOBALS.YES THEN
2819: -- set OUT result to CONSTRAINED
2820: x_result := OE_PC_GLOBALS.YES;
2821: END IF;
2822:
2823: END IF;
2824:

Line 2834: IF l_result = OE_PC_GLOBALS.YES THEN

2830: ,p_record => l_rowtype_rec
2831: ,x_on_operation_action => l_on_operation_action
2832: );
2833:
2834: IF l_result = OE_PC_GLOBALS.YES THEN
2835: -- set OUT result to CONSTRAINED
2836: x_result := OE_PC_GLOBALS.YES;
2837: END IF;
2838:

Line 2836: x_result := OE_PC_GLOBALS.YES;

2832: );
2833:
2834: IF l_result = OE_PC_GLOBALS.YES THEN
2835: -- set OUT result to CONSTRAINED
2836: x_result := OE_PC_GLOBALS.YES;
2837: END IF;
2838:
2839: END IF;
2840:

Line 2850: IF l_result = OE_PC_GLOBALS.YES THEN

2846: ,p_record => l_rowtype_rec
2847: ,x_on_operation_action => l_on_operation_action
2848: );
2849:
2850: IF l_result = OE_PC_GLOBALS.YES THEN
2851: -- set OUT result to CONSTRAINED
2852: x_result := OE_PC_GLOBALS.YES;
2853: END IF;
2854:

Line 2852: x_result := OE_PC_GLOBALS.YES;

2848: );
2849:
2850: IF l_result = OE_PC_GLOBALS.YES THEN
2851: -- set OUT result to CONSTRAINED
2852: x_result := OE_PC_GLOBALS.YES;
2853: END IF;
2854:
2855: END IF;
2856:

Line 2866: IF l_result = OE_PC_GLOBALS.YES THEN

2862: ,p_record => l_rowtype_rec
2863: ,x_on_operation_action => l_on_operation_action
2864: );
2865:
2866: IF l_result = OE_PC_GLOBALS.YES THEN
2867: -- set OUT result to CONSTRAINED
2868: x_result := OE_PC_GLOBALS.YES;
2869: END IF;
2870:

Line 2868: x_result := OE_PC_GLOBALS.YES;

2864: );
2865:
2866: IF l_result = OE_PC_GLOBALS.YES THEN
2867: -- set OUT result to CONSTRAINED
2868: x_result := OE_PC_GLOBALS.YES;
2869: END IF;
2870:
2871: END IF;
2872:

Line 2882: IF l_result = OE_PC_GLOBALS.YES THEN

2878: ,p_record => l_rowtype_rec
2879: ,x_on_operation_action => l_on_operation_action
2880: );
2881:
2882: IF l_result = OE_PC_GLOBALS.YES THEN
2883: -- set OUT result to CONSTRAINED
2884: x_result := OE_PC_GLOBALS.YES;
2885: END IF;
2886:

Line 2884: x_result := OE_PC_GLOBALS.YES;

2880: );
2881:
2882: IF l_result = OE_PC_GLOBALS.YES THEN
2883: -- set OUT result to CONSTRAINED
2884: x_result := OE_PC_GLOBALS.YES;
2885: END IF;
2886:
2887: END IF;
2888:

Line 2898: IF l_result = OE_PC_GLOBALS.YES THEN

2894: ,p_record => l_rowtype_rec
2895: ,x_on_operation_action => l_on_operation_action
2896: );
2897:
2898: IF l_result = OE_PC_GLOBALS.YES THEN
2899: -- set OUT result to CONSTRAINED
2900: x_result := OE_PC_GLOBALS.YES;
2901: END IF;
2902:

Line 2900: x_result := OE_PC_GLOBALS.YES;

2896: );
2897:
2898: IF l_result = OE_PC_GLOBALS.YES THEN
2899: -- set OUT result to CONSTRAINED
2900: x_result := OE_PC_GLOBALS.YES;
2901: END IF;
2902:
2903: END IF;
2904:

Line 2914: IF l_result = OE_PC_GLOBALS.YES THEN

2910: ,p_record => l_rowtype_rec
2911: ,x_on_operation_action => l_on_operation_action
2912: );
2913:
2914: IF l_result = OE_PC_GLOBALS.YES THEN
2915: -- set OUT result to CONSTRAINED
2916: x_result := OE_PC_GLOBALS.YES;
2917: END IF;
2918:

Line 2916: x_result := OE_PC_GLOBALS.YES;

2912: );
2913:
2914: IF l_result = OE_PC_GLOBALS.YES THEN
2915: -- set OUT result to CONSTRAINED
2916: x_result := OE_PC_GLOBALS.YES;
2917: END IF;
2918:
2919: END IF;
2920:

Line 2930: IF l_result = OE_PC_GLOBALS.YES THEN

2926: ,p_record => l_rowtype_rec
2927: ,x_on_operation_action => l_on_operation_action
2928: );
2929:
2930: IF l_result = OE_PC_GLOBALS.YES THEN
2931: -- set OUT result to CONSTRAINED
2932: x_result := OE_PC_GLOBALS.YES;
2933: END IF;
2934:

Line 2932: x_result := OE_PC_GLOBALS.YES;

2928: );
2929:
2930: IF l_result = OE_PC_GLOBALS.YES THEN
2931: -- set OUT result to CONSTRAINED
2932: x_result := OE_PC_GLOBALS.YES;
2933: END IF;
2934:
2935: END IF;
2936:

Line 2946: IF l_result = OE_PC_GLOBALS.YES THEN

2942: ,p_record => l_rowtype_rec
2943: ,x_on_operation_action => l_on_operation_action
2944: );
2945:
2946: IF l_result = OE_PC_GLOBALS.YES THEN
2947: -- set OUT result to CONSTRAINED
2948: x_result := OE_PC_GLOBALS.YES;
2949: END IF;
2950:

Line 2948: x_result := OE_PC_GLOBALS.YES;

2944: );
2945:
2946: IF l_result = OE_PC_GLOBALS.YES THEN
2947: -- set OUT result to CONSTRAINED
2948: x_result := OE_PC_GLOBALS.YES;
2949: END IF;
2950:
2951: END IF;
2952:

Line 2962: IF l_result = OE_PC_GLOBALS.YES THEN

2958: ,p_record => l_rowtype_rec
2959: ,x_on_operation_action => l_on_operation_action
2960: );
2961:
2962: IF l_result = OE_PC_GLOBALS.YES THEN
2963: -- set OUT result to CONSTRAINED
2964: x_result := OE_PC_GLOBALS.YES;
2965: END IF;
2966:

Line 2964: x_result := OE_PC_GLOBALS.YES;

2960: );
2961:
2962: IF l_result = OE_PC_GLOBALS.YES THEN
2963: -- set OUT result to CONSTRAINED
2964: x_result := OE_PC_GLOBALS.YES;
2965: END IF;
2966:
2967: END IF;
2968:

Line 2978: IF l_result = OE_PC_GLOBALS.YES THEN

2974: ,p_record => l_rowtype_rec
2975: ,x_on_operation_action => l_on_operation_action
2976: );
2977:
2978: IF l_result = OE_PC_GLOBALS.YES THEN
2979: -- set OUT result to CONSTRAINED
2980: x_result := OE_PC_GLOBALS.YES;
2981: END IF;
2982:

Line 2980: x_result := OE_PC_GLOBALS.YES;

2976: );
2977:
2978: IF l_result = OE_PC_GLOBALS.YES THEN
2979: -- set OUT result to CONSTRAINED
2980: x_result := OE_PC_GLOBALS.YES;
2981: END IF;
2982:
2983: END IF;
2984:

Line 2994: IF l_result = OE_PC_GLOBALS.YES THEN

2990: ,p_record => l_rowtype_rec
2991: ,x_on_operation_action => l_on_operation_action
2992: );
2993:
2994: IF l_result = OE_PC_GLOBALS.YES THEN
2995: -- set OUT result to CONSTRAINED
2996: x_result := OE_PC_GLOBALS.YES;
2997: END IF;
2998:

Line 2996: x_result := OE_PC_GLOBALS.YES;

2992: );
2993:
2994: IF l_result = OE_PC_GLOBALS.YES THEN
2995: -- set OUT result to CONSTRAINED
2996: x_result := OE_PC_GLOBALS.YES;
2997: END IF;
2998:
2999: END IF;
3000:

Line 3010: IF l_result = OE_PC_GLOBALS.YES THEN

3006: ,p_record => l_rowtype_rec
3007: ,x_on_operation_action => l_on_operation_action
3008: );
3009:
3010: IF l_result = OE_PC_GLOBALS.YES THEN
3011: -- set OUT result to CONSTRAINED
3012: x_result := OE_PC_GLOBALS.YES;
3013: END IF;
3014:

Line 3012: x_result := OE_PC_GLOBALS.YES;

3008: );
3009:
3010: IF l_result = OE_PC_GLOBALS.YES THEN
3011: -- set OUT result to CONSTRAINED
3012: x_result := OE_PC_GLOBALS.YES;
3013: END IF;
3014:
3015: END IF;
3016:

Line 3026: IF l_result = OE_PC_GLOBALS.YES THEN

3022: ,p_record => l_rowtype_rec
3023: ,x_on_operation_action => l_on_operation_action
3024: );
3025:
3026: IF l_result = OE_PC_GLOBALS.YES THEN
3027: -- set OUT result to CONSTRAINED
3028: x_result := OE_PC_GLOBALS.YES;
3029: END IF;
3030:

Line 3028: x_result := OE_PC_GLOBALS.YES;

3024: );
3025:
3026: IF l_result = OE_PC_GLOBALS.YES THEN
3027: -- set OUT result to CONSTRAINED
3028: x_result := OE_PC_GLOBALS.YES;
3029: END IF;
3030:
3031: END IF;
3032:

Line 3042: IF l_result = OE_PC_GLOBALS.YES THEN

3038: ,p_record => l_rowtype_rec
3039: ,x_on_operation_action => l_on_operation_action
3040: );
3041:
3042: IF l_result = OE_PC_GLOBALS.YES THEN
3043: -- set OUT result to CONSTRAINED
3044: x_result := OE_PC_GLOBALS.YES;
3045: END IF;
3046:

Line 3044: x_result := OE_PC_GLOBALS.YES;

3040: );
3041:
3042: IF l_result = OE_PC_GLOBALS.YES THEN
3043: -- set OUT result to CONSTRAINED
3044: x_result := OE_PC_GLOBALS.YES;
3045: END IF;
3046:
3047: END IF;
3048:

Line 3058: IF l_result = OE_PC_GLOBALS.YES THEN

3054: ,p_record => l_rowtype_rec
3055: ,x_on_operation_action => l_on_operation_action
3056: );
3057:
3058: IF l_result = OE_PC_GLOBALS.YES THEN
3059: -- set OUT result to CONSTRAINED
3060: x_result := OE_PC_GLOBALS.YES;
3061: END IF;
3062:

Line 3060: x_result := OE_PC_GLOBALS.YES;

3056: );
3057:
3058: IF l_result = OE_PC_GLOBALS.YES THEN
3059: -- set OUT result to CONSTRAINED
3060: x_result := OE_PC_GLOBALS.YES;
3061: END IF;
3062:
3063: END IF;
3064:

Line 3074: IF l_result = OE_PC_GLOBALS.YES THEN

3070: ,p_record => l_rowtype_rec
3071: ,x_on_operation_action => l_on_operation_action
3072: );
3073:
3074: IF l_result = OE_PC_GLOBALS.YES THEN
3075: -- set OUT result to CONSTRAINED
3076: x_result := OE_PC_GLOBALS.YES;
3077: END IF;
3078:

Line 3076: x_result := OE_PC_GLOBALS.YES;

3072: );
3073:
3074: IF l_result = OE_PC_GLOBALS.YES THEN
3075: -- set OUT result to CONSTRAINED
3076: x_result := OE_PC_GLOBALS.YES;
3077: END IF;
3078:
3079: END IF;
3080:

Line 3090: IF l_result = OE_PC_GLOBALS.YES THEN

3086: ,p_record => l_rowtype_rec
3087: ,x_on_operation_action => l_on_operation_action
3088: );
3089:
3090: IF l_result = OE_PC_GLOBALS.YES THEN
3091: -- set OUT result to CONSTRAINED
3092: x_result := OE_PC_GLOBALS.YES;
3093: END IF;
3094:

Line 3092: x_result := OE_PC_GLOBALS.YES;

3088: );
3089:
3090: IF l_result = OE_PC_GLOBALS.YES THEN
3091: -- set OUT result to CONSTRAINED
3092: x_result := OE_PC_GLOBALS.YES;
3093: END IF;
3094:
3095: END IF;
3096:

Line 3106: IF l_result = OE_PC_GLOBALS.YES THEN

3102: (p_operation => l_operation
3103: ,p_record => l_rowtype_rec
3104: ,x_on_operation_action => l_on_operation_action
3105: );
3106: IF l_result = OE_PC_GLOBALS.YES THEN
3107: -- set OUT result to CONSTRAINED
3108: x_result := OE_PC_GLOBALS.YES;
3109: END IF;
3110:

Line 3108: x_result := OE_PC_GLOBALS.YES;

3104: ,x_on_operation_action => l_on_operation_action
3105: );
3106: IF l_result = OE_PC_GLOBALS.YES THEN
3107: -- set OUT result to CONSTRAINED
3108: x_result := OE_PC_GLOBALS.YES;
3109: END IF;
3110:
3111: END IF;
3112:

Line 3121: IF l_result = OE_PC_GLOBALS.YES THEN

3117: (p_operation => l_operation
3118: ,p_record => l_rowtype_rec
3119: ,x_on_operation_action => l_on_operation_action
3120: );
3121: IF l_result = OE_PC_GLOBALS.YES THEN
3122: -- set OUT result to CONSTRAINED
3123: x_result := OE_PC_GLOBALS.YES;
3124: END IF;
3125:

Line 3123: x_result := OE_PC_GLOBALS.YES;

3119: ,x_on_operation_action => l_on_operation_action
3120: );
3121: IF l_result = OE_PC_GLOBALS.YES THEN
3122: -- set OUT result to CONSTRAINED
3123: x_result := OE_PC_GLOBALS.YES;
3124: END IF;
3125:
3126: END IF;
3127:

Line 3136: IF l_result = OE_PC_GLOBALS.YES THEN

3132: (p_operation => l_operation
3133: ,p_record => l_rowtype_rec
3134: ,x_on_operation_action => l_on_operation_action
3135: );
3136: IF l_result = OE_PC_GLOBALS.YES THEN
3137: -- set OUT result to CONSTRAINED
3138: x_result := OE_PC_GLOBALS.YES;
3139: END IF;
3140:

Line 3138: x_result := OE_PC_GLOBALS.YES;

3134: ,x_on_operation_action => l_on_operation_action
3135: );
3136: IF l_result = OE_PC_GLOBALS.YES THEN
3137: -- set OUT result to CONSTRAINED
3138: x_result := OE_PC_GLOBALS.YES;
3139: END IF;
3140:
3141: END IF;
3142:

Line 3157: IF l_result = OE_PC_GLOBALS.YES THEN

3153: (p_operation => l_operation
3154: ,p_record => l_rowtype_rec
3155: ,x_on_operation_action => l_on_operation_action
3156: );
3157: IF l_result = OE_PC_GLOBALS.YES THEN
3158: -- set OUT result to CONSTRAINED
3159: x_result := OE_PC_GLOBALS.YES;
3160: END IF;
3161:

Line 3159: x_result := OE_PC_GLOBALS.YES;

3155: ,x_on_operation_action => l_on_operation_action
3156: );
3157: IF l_result = OE_PC_GLOBALS.YES THEN
3158: -- set OUT result to CONSTRAINED
3159: x_result := OE_PC_GLOBALS.YES;
3160: END IF;
3161:
3162: END IF;
3163:

Line 3172: IF l_result = OE_PC_GLOBALS.YES THEN

3168: (p_operation => l_operation
3169: ,p_record => l_rowtype_rec
3170: ,x_on_operation_action => l_on_operation_action
3171: );
3172: IF l_result = OE_PC_GLOBALS.YES THEN
3173: -- set OUT result to CONSTRAINED
3174: x_result := OE_PC_GLOBALS.YES;
3175: END IF;
3176:

Line 3174: x_result := OE_PC_GLOBALS.YES;

3170: ,x_on_operation_action => l_on_operation_action
3171: );
3172: IF l_result = OE_PC_GLOBALS.YES THEN
3173: -- set OUT result to CONSTRAINED
3174: x_result := OE_PC_GLOBALS.YES;
3175: END IF;
3176:
3177: END IF;
3178: /* END PREPAYMENT */

Line 3189: IF l_result = OE_PC_GLOBALS.YES THEN

3185: ,p_record => l_rowtype_rec
3186: ,x_on_operation_action => l_on_operation_action
3187: );
3188:
3189: IF l_result = OE_PC_GLOBALS.YES THEN
3190: -- set OUT result to CONSTRAINED
3191: x_result := OE_PC_GLOBALS.YES;
3192: END IF;
3193:

Line 3191: x_result := OE_PC_GLOBALS.YES;

3187: );
3188:
3189: IF l_result = OE_PC_GLOBALS.YES THEN
3190: -- set OUT result to CONSTRAINED
3191: x_result := OE_PC_GLOBALS.YES;
3192: END IF;
3193:
3194: END IF;
3195:

Line 3205: IF l_result = OE_PC_GLOBALS.YES THEN

3201: ,p_record => l_rowtype_rec
3202: ,x_on_operation_action => l_on_operation_action
3203: );
3204:
3205: IF l_result = OE_PC_GLOBALS.YES THEN
3206: -- set OUT result to CONSTRAINED
3207: x_result := OE_PC_GLOBALS.YES;
3208: END IF;
3209:

Line 3207: x_result := OE_PC_GLOBALS.YES;

3203: );
3204:
3205: IF l_result = OE_PC_GLOBALS.YES THEN
3206: -- set OUT result to CONSTRAINED
3207: x_result := OE_PC_GLOBALS.YES;
3208: END IF;
3209:
3210: END IF;
3211:

Line 3221: IF l_result = OE_PC_GLOBALS.YES THEN

3217: ,p_record => l_rowtype_rec
3218: ,x_on_operation_action => l_on_operation_action
3219: );
3220:
3221: IF l_result = OE_PC_GLOBALS.YES THEN
3222: -- set OUT result to CONSTRAINED
3223: x_result := OE_PC_GLOBALS.YES;
3224: END IF;
3225:

Line 3223: x_result := OE_PC_GLOBALS.YES;

3219: );
3220:
3221: IF l_result = OE_PC_GLOBALS.YES THEN
3222: -- set OUT result to CONSTRAINED
3223: x_result := OE_PC_GLOBALS.YES;
3224: END IF;
3225:
3226: END IF;
3227:

Line 3237: IF l_result = OE_PC_GLOBALS.YES THEN

3233: ,p_record => l_rowtype_rec
3234: ,x_on_operation_action => l_on_operation_action
3235: );
3236:
3237: IF l_result = OE_PC_GLOBALS.YES THEN
3238: -- set OUT result to CONSTRAINED
3239: x_result := OE_PC_GLOBALS.YES;
3240: END IF;
3241:

Line 3239: x_result := OE_PC_GLOBALS.YES;

3235: );
3236:
3237: IF l_result = OE_PC_GLOBALS.YES THEN
3238: -- set OUT result to CONSTRAINED
3239: x_result := OE_PC_GLOBALS.YES;
3240: END IF;
3241:
3242: END IF;
3243:

Line 3253: IF l_result = OE_PC_GLOBALS.YES THEN

3249: ,p_record => l_rowtype_rec
3250: ,x_on_operation_action => l_on_operation_action
3251: );
3252:
3253: IF l_result = OE_PC_GLOBALS.YES THEN
3254: -- set OUT result to CONSTRAINED
3255: x_result := OE_PC_GLOBALS.YES;
3256: END IF;
3257:

Line 3255: x_result := OE_PC_GLOBALS.YES;

3251: );
3252:
3253: IF l_result = OE_PC_GLOBALS.YES THEN
3254: -- set OUT result to CONSTRAINED
3255: x_result := OE_PC_GLOBALS.YES;
3256: END IF;
3257:
3258: END IF;
3259:

Line 3269: IF l_result = OE_PC_GLOBALS.YES THEN

3265: ,p_record => l_rowtype_rec
3266: ,x_on_operation_action => l_on_operation_action
3267: );
3268:
3269: IF l_result = OE_PC_GLOBALS.YES THEN
3270: -- set OUT result to CONSTRAINED
3271: x_result := OE_PC_GLOBALS.YES;
3272: END IF;
3273:

Line 3271: x_result := OE_PC_GLOBALS.YES;

3267: );
3268:
3269: IF l_result = OE_PC_GLOBALS.YES THEN
3270: -- set OUT result to CONSTRAINED
3271: x_result := OE_PC_GLOBALS.YES;
3272: END IF;
3273:
3274: END IF;
3275:

Line 3285: IF l_result = OE_PC_GLOBALS.YES THEN

3281: ,p_record => l_rowtype_rec
3282: ,x_on_operation_action => l_on_operation_action
3283: );
3284:
3285: IF l_result = OE_PC_GLOBALS.YES THEN
3286: -- set OUT result to CONSTRAINED
3287: x_result := OE_PC_GLOBALS.YES;
3288: END IF;
3289:

Line 3287: x_result := OE_PC_GLOBALS.YES;

3283: );
3284:
3285: IF l_result = OE_PC_GLOBALS.YES THEN
3286: -- set OUT result to CONSTRAINED
3287: x_result := OE_PC_GLOBALS.YES;
3288: END IF;
3289:
3290: END IF;
3291:

Line 3301: IF l_result = OE_PC_GLOBALS.YES THEN

3297: ,p_record => l_rowtype_rec
3298: ,x_on_operation_action => l_on_operation_action
3299: );
3300:
3301: IF l_result = OE_PC_GLOBALS.YES THEN
3302: -- set OUT result to CONSTRAINED
3303: x_result := OE_PC_GLOBALS.YES;
3304: END IF;
3305:

Line 3303: x_result := OE_PC_GLOBALS.YES;

3299: );
3300:
3301: IF l_result = OE_PC_GLOBALS.YES THEN
3302: -- set OUT result to CONSTRAINED
3303: x_result := OE_PC_GLOBALS.YES;
3304: END IF;
3305:
3306: END IF;
3307:

Line 3317: IF l_result = OE_PC_GLOBALS.YES THEN

3313: ,p_record => l_rowtype_rec
3314: ,x_on_operation_action => l_on_operation_action
3315: );
3316:
3317: IF l_result = OE_PC_GLOBALS.YES THEN
3318: -- set OUT result to CONSTRAINED
3319: x_result := OE_PC_GLOBALS.YES;
3320: END IF;
3321:

Line 3319: x_result := OE_PC_GLOBALS.YES;

3315: );
3316:
3317: IF l_result = OE_PC_GLOBALS.YES THEN
3318: -- set OUT result to CONSTRAINED
3319: x_result := OE_PC_GLOBALS.YES;
3320: END IF;
3321:
3322: END IF;
3323:

Line 3333: IF l_result = OE_PC_GLOBALS.YES THEN

3329: ,p_record => l_rowtype_rec
3330: ,x_on_operation_action => l_on_operation_action
3331: );
3332:
3333: IF l_result = OE_PC_GLOBALS.YES THEN
3334: -- set OUT result to CONSTRAINED
3335: x_result := OE_PC_GLOBALS.YES;
3336: END IF;
3337:

Line 3335: x_result := OE_PC_GLOBALS.YES;

3331: );
3332:
3333: IF l_result = OE_PC_GLOBALS.YES THEN
3334: -- set OUT result to CONSTRAINED
3335: x_result := OE_PC_GLOBALS.YES;
3336: END IF;
3337:
3338: END IF;
3339:

Line 3349: IF l_result = OE_PC_GLOBALS.YES THEN

3345: ,p_record => l_rowtype_rec
3346: ,x_on_operation_action => l_on_operation_action
3347: );
3348:
3349: IF l_result = OE_PC_GLOBALS.YES THEN
3350: -- set OUT result to CONSTRAINED
3351: x_result := OE_PC_GLOBALS.YES;
3352: END IF;
3353:

Line 3351: x_result := OE_PC_GLOBALS.YES;

3347: );
3348:
3349: IF l_result = OE_PC_GLOBALS.YES THEN
3350: -- set OUT result to CONSTRAINED
3351: x_result := OE_PC_GLOBALS.YES;
3352: END IF;
3353:
3354: END IF;
3355:

Line 3365: IF l_result = OE_PC_GLOBALS.YES THEN

3361: ,p_record => l_rowtype_rec
3362: ,x_on_operation_action => l_on_operation_action
3363: );
3364:
3365: IF l_result = OE_PC_GLOBALS.YES THEN
3366: -- set OUT result to CONSTRAINED
3367: x_result := OE_PC_GLOBALS.YES;
3368: END IF;
3369:

Line 3367: x_result := OE_PC_GLOBALS.YES;

3363: );
3364:
3365: IF l_result = OE_PC_GLOBALS.YES THEN
3366: -- set OUT result to CONSTRAINED
3367: x_result := OE_PC_GLOBALS.YES;
3368: END IF;
3369:
3370: END IF;
3371:

Line 3381: IF l_result = OE_PC_GLOBALS.YES THEN

3377: ,p_record => l_rowtype_rec
3378: ,x_on_operation_action => l_on_operation_action
3379: );
3380:
3381: IF l_result = OE_PC_GLOBALS.YES THEN
3382: -- set OUT result to CONSTRAINED
3383: x_result := OE_PC_GLOBALS.YES;
3384: END IF;
3385:

Line 3383: x_result := OE_PC_GLOBALS.YES;

3379: );
3380:
3381: IF l_result = OE_PC_GLOBALS.YES THEN
3382: -- set OUT result to CONSTRAINED
3383: x_result := OE_PC_GLOBALS.YES;
3384: END IF;
3385:
3386: END IF;
3387:

Line 3397: IF l_result = OE_PC_GLOBALS.YES THEN

3393: ,p_record => l_rowtype_rec
3394: ,x_on_operation_action => l_on_operation_action
3395: );
3396:
3397: IF l_result = OE_PC_GLOBALS.YES THEN
3398: -- set OUT result to CONSTRAINED
3399: x_result := OE_PC_GLOBALS.YES;
3400: END IF;
3401:

Line 3399: x_result := OE_PC_GLOBALS.YES;

3395: );
3396:
3397: IF l_result = OE_PC_GLOBALS.YES THEN
3398: -- set OUT result to CONSTRAINED
3399: x_result := OE_PC_GLOBALS.YES;
3400: END IF;
3401:
3402: END IF;
3403:

Line 3414: IF l_result = OE_PC_GLOBALS.YES THEN

3410: ,p_record => l_rowtype_rec
3411: ,x_on_operation_action => l_on_operation_action
3412: );
3413:
3414: IF l_result = OE_PC_GLOBALS.YES THEN
3415: -- set OUT result to CONSTRAINED
3416: x_result := OE_PC_GLOBALS.YES;
3417: END IF;
3418:

Line 3416: x_result := OE_PC_GLOBALS.YES;

3412: );
3413:
3414: IF l_result = OE_PC_GLOBALS.YES THEN
3415: -- set OUT result to CONSTRAINED
3416: x_result := OE_PC_GLOBALS.YES;
3417: END IF;
3418:
3419: END IF;
3420:

Line 3430: IF l_result = OE_PC_GLOBALS.YES THEN

3426: ,p_record => l_rowtype_rec
3427: ,x_on_operation_action => l_on_operation_action
3428: );
3429:
3430: IF l_result = OE_PC_GLOBALS.YES THEN
3431: -- set OUT result to CONSTRAINED
3432: x_result := OE_PC_GLOBALS.YES;
3433: END IF;
3434:

Line 3432: x_result := OE_PC_GLOBALS.YES;

3428: );
3429:
3430: IF l_result = OE_PC_GLOBALS.YES THEN
3431: -- set OUT result to CONSTRAINED
3432: x_result := OE_PC_GLOBALS.YES;
3433: END IF;
3434:
3435: END IF;
3436: -- end 2395032

Line 3448: IF l_result = OE_PC_GLOBALS.YES THEN

3444: ,p_record => l_rowtype_rec
3445: ,x_on_operation_action => l_on_operation_action
3446: );
3447:
3448: IF l_result = OE_PC_GLOBALS.YES THEN
3449: -- set OUT result to CONSTRAINED
3450: x_result := OE_PC_GLOBALS.YES;
3451: END IF;
3452:

Line 3450: x_result := OE_PC_GLOBALS.YES;

3446: );
3447:
3448: IF l_result = OE_PC_GLOBALS.YES THEN
3449: -- set OUT result to CONSTRAINED
3450: x_result := OE_PC_GLOBALS.YES;
3451: END IF;
3452:
3453: END IF;
3454: -- END: Blankets Code Merge

Line 3467: IF l_result = OE_PC_GLOBALS.YES THEN

3463: ,p_record => l_rowtype_rec
3464: ,x_on_operation_action => l_on_operation_action
3465: );
3466:
3467: IF l_result = OE_PC_GLOBALS.YES THEN
3468: -- set OUT result to CONSTRAINED
3469: x_result := OE_PC_GLOBALS.YES;
3470: END IF;
3471:

Line 3469: x_result := OE_PC_GLOBALS.YES;

3465: );
3466:
3467: IF l_result = OE_PC_GLOBALS.YES THEN
3468: -- set OUT result to CONSTRAINED
3469: x_result := OE_PC_GLOBALS.YES;
3470: END IF;
3471:
3472: END IF;
3473:

Line 3483: IF l_result = OE_PC_GLOBALS.YES THEN

3479: ,p_record => l_rowtype_rec
3480: ,x_on_operation_action => l_on_operation_action
3481: );
3482:
3483: IF l_result = OE_PC_GLOBALS.YES THEN
3484: -- set OUT result to CONSTRAINED
3485: x_result := OE_PC_GLOBALS.YES;
3486: END IF;
3487:

Line 3485: x_result := OE_PC_GLOBALS.YES;

3481: );
3482:
3483: IF l_result = OE_PC_GLOBALS.YES THEN
3484: -- set OUT result to CONSTRAINED
3485: x_result := OE_PC_GLOBALS.YES;
3486: END IF;
3487:
3488: END IF;
3489:

Line 3499: IF l_result = OE_PC_GLOBALS.YES THEN

3495: ,p_record => l_rowtype_rec
3496: ,x_on_operation_action => l_on_operation_action
3497: );
3498:
3499: IF l_result = OE_PC_GLOBALS.YES THEN
3500: -- set OUT result to CONSTRAINED
3501: x_result := OE_PC_GLOBALS.YES;
3502: END IF;
3503:

Line 3501: x_result := OE_PC_GLOBALS.YES;

3497: );
3498:
3499: IF l_result = OE_PC_GLOBALS.YES THEN
3500: -- set OUT result to CONSTRAINED
3501: x_result := OE_PC_GLOBALS.YES;
3502: END IF;
3503:
3504: END IF;
3505:

Line 3515: IF l_result = OE_PC_GLOBALS.YES THEN

3511: ,p_record => l_rowtype_rec
3512: ,x_on_operation_action => l_on_operation_action
3513: );
3514:
3515: IF l_result = OE_PC_GLOBALS.YES THEN
3516: -- set OUT result to CONSTRAINED
3517: x_result := OE_PC_GLOBALS.YES;
3518: END IF;
3519:

Line 3517: x_result := OE_PC_GLOBALS.YES;

3513: );
3514:
3515: IF l_result = OE_PC_GLOBALS.YES THEN
3516: -- set OUT result to CONSTRAINED
3517: x_result := OE_PC_GLOBALS.YES;
3518: END IF;
3519:
3520: END IF;
3521:

Line 3531: IF l_result = OE_PC_GLOBALS.YES THEN

3527: ,p_record => l_rowtype_rec
3528: ,x_on_operation_action => l_on_operation_action
3529: );
3530:
3531: IF l_result = OE_PC_GLOBALS.YES THEN
3532: -- set OUT result to CONSTRAINED
3533: x_result := OE_PC_GLOBALS.YES;
3534: END IF;
3535:

Line 3533: x_result := OE_PC_GLOBALS.YES;

3529: );
3530:
3531: IF l_result = OE_PC_GLOBALS.YES THEN
3532: -- set OUT result to CONSTRAINED
3533: x_result := OE_PC_GLOBALS.YES;
3534: END IF;
3535:
3536: END IF;
3537:

Line 3547: IF l_result = OE_PC_GLOBALS.YES THEN

3543: ,p_record => l_rowtype_rec
3544: ,x_on_operation_action => l_on_operation_action
3545: );
3546:
3547: IF l_result = OE_PC_GLOBALS.YES THEN
3548: -- set OUT result to CONSTRAINED
3549: x_result := OE_PC_GLOBALS.YES;
3550: END IF;
3551:

Line 3549: x_result := OE_PC_GLOBALS.YES;

3545: );
3546:
3547: IF l_result = OE_PC_GLOBALS.YES THEN
3548: -- set OUT result to CONSTRAINED
3549: x_result := OE_PC_GLOBALS.YES;
3550: END IF;
3551:
3552: END IF;
3553:

Line 3563: IF l_result = OE_PC_GLOBALS.YES THEN

3559: ,p_record => l_rowtype_rec
3560: ,x_on_operation_action => l_on_operation_action
3561: );
3562:
3563: IF l_result = OE_PC_GLOBALS.YES THEN
3564: -- set OUT result to CONSTRAINED
3565: x_result := OE_PC_GLOBALS.YES;
3566: END IF;
3567:

Line 3565: x_result := OE_PC_GLOBALS.YES;

3561: );
3562:
3563: IF l_result = OE_PC_GLOBALS.YES THEN
3564: -- set OUT result to CONSTRAINED
3565: x_result := OE_PC_GLOBALS.YES;
3566: END IF;
3567:
3568: END IF;
3569:

Line 3579: IF l_result = OE_PC_GLOBALS.YES THEN

3575: ,p_record => l_rowtype_rec
3576: ,x_on_operation_action => l_on_operation_action
3577: );
3578:
3579: IF l_result = OE_PC_GLOBALS.YES THEN
3580: -- set OUT result to CONSTRAINED
3581: x_result := OE_PC_GLOBALS.YES;
3582: END IF;
3583:

Line 3581: x_result := OE_PC_GLOBALS.YES;

3577: );
3578:
3579: IF l_result = OE_PC_GLOBALS.YES THEN
3580: -- set OUT result to CONSTRAINED
3581: x_result := OE_PC_GLOBALS.YES;
3582: END IF;
3583:
3584: END IF;
3585:

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

3595: -- updated and profile was set to 'N', global at the end should
3596: -- be re-set to 'Y' - this indicates to process order that no
3597: -- constrainable attributes were updated and thus, it would
3598: -- suppress entity level security check also.
3599: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
3600: l_check_all_cols_constraint := g_check_all_cols_constraint;
3601: g_check_all_cols_constraint := 'N';
3602: END IF;
3603:

Line 3613: IF l_result = OE_PC_GLOBALS.YES THEN

3609: ,p_record => l_rowtype_rec
3610: ,x_on_operation_action => l_on_operation_action
3611: );
3612:
3613: IF l_result = OE_PC_GLOBALS.YES THEN
3614: -- set OUT result to CONSTRAINED
3615: x_result := OE_PC_GLOBALS.YES;
3616: END IF;
3617:

Line 3615: x_result := OE_PC_GLOBALS.YES;

3611: );
3612:
3613: IF l_result = OE_PC_GLOBALS.YES THEN
3614: -- set OUT result to CONSTRAINED
3615: x_result := OE_PC_GLOBALS.YES;
3616: END IF;
3617:
3618: END IF;
3619:

Line 3629: IF l_result = OE_PC_GLOBALS.YES THEN

3625: ,p_record => l_rowtype_rec
3626: ,x_on_operation_action => l_on_operation_action
3627: );
3628:
3629: IF l_result = OE_PC_GLOBALS.YES THEN
3630: -- set OUT result to CONSTRAINED
3631: x_result := OE_PC_GLOBALS.YES;
3632: END IF;
3633:

Line 3631: x_result := OE_PC_GLOBALS.YES;

3627: );
3628:
3629: IF l_result = OE_PC_GLOBALS.YES THEN
3630: -- set OUT result to CONSTRAINED
3631: x_result := OE_PC_GLOBALS.YES;
3632: END IF;
3633:
3634: END IF;
3635:

Line 3645: IF l_result = OE_PC_GLOBALS.YES THEN

3641: ,p_record => l_rowtype_rec
3642: ,x_on_operation_action => l_on_operation_action
3643: );
3644:
3645: IF l_result = OE_PC_GLOBALS.YES THEN
3646: -- set OUT result to CONSTRAINED
3647: x_result := OE_PC_GLOBALS.YES;
3648: END IF;
3649:

Line 3647: x_result := OE_PC_GLOBALS.YES;

3643: );
3644:
3645: IF l_result = OE_PC_GLOBALS.YES THEN
3646: -- set OUT result to CONSTRAINED
3647: x_result := OE_PC_GLOBALS.YES;
3648: END IF;
3649:
3650: END IF;
3651:

Line 3661: IF l_result = OE_PC_GLOBALS.YES THEN

3657: ,p_record => l_rowtype_rec
3658: ,x_on_operation_action => l_on_operation_action
3659: );
3660:
3661: IF l_result = OE_PC_GLOBALS.YES THEN
3662: -- set OUT result to CONSTRAINED
3663: x_result := OE_PC_GLOBALS.YES;
3664: END IF;
3665:

Line 3663: x_result := OE_PC_GLOBALS.YES;

3659: );
3660:
3661: IF l_result = OE_PC_GLOBALS.YES THEN
3662: -- set OUT result to CONSTRAINED
3663: x_result := OE_PC_GLOBALS.YES;
3664: END IF;
3665:
3666: END IF;
3667:

Line 3677: IF l_result = OE_PC_GLOBALS.YES THEN

3673: ,p_record => l_rowtype_rec
3674: ,x_on_operation_action => l_on_operation_action
3675: );
3676:
3677: IF l_result = OE_PC_GLOBALS.YES THEN
3678: -- set OUT result to CONSTRAINED
3679: x_result := OE_PC_GLOBALS.YES;
3680: END IF;
3681:

Line 3679: x_result := OE_PC_GLOBALS.YES;

3675: );
3676:
3677: IF l_result = OE_PC_GLOBALS.YES THEN
3678: -- set OUT result to CONSTRAINED
3679: x_result := OE_PC_GLOBALS.YES;
3680: END IF;
3681:
3682: END IF;
3683:

Line 3693: IF l_result = OE_PC_GLOBALS.YES THEN

3689: ,p_record => l_rowtype_rec
3690: ,x_on_operation_action => l_on_operation_action
3691: );
3692:
3693: IF l_result = OE_PC_GLOBALS.YES THEN
3694: -- set OUT result to CONSTRAINED
3695: x_result := OE_PC_GLOBALS.YES;
3696: END IF;
3697:

Line 3695: x_result := OE_PC_GLOBALS.YES;

3691: );
3692:
3693: IF l_result = OE_PC_GLOBALS.YES THEN
3694: -- set OUT result to CONSTRAINED
3695: x_result := OE_PC_GLOBALS.YES;
3696: END IF;
3697:
3698: END IF;
3699:

Line 3709: IF l_result = OE_PC_GLOBALS.YES THEN

3705: ,p_record => l_rowtype_rec
3706: ,x_on_operation_action => l_on_operation_action
3707: );
3708:
3709: IF l_result = OE_PC_GLOBALS.YES THEN
3710: -- set OUT result to CONSTRAINED
3711: x_result := OE_PC_GLOBALS.YES;
3712: END IF;
3713:

Line 3711: x_result := OE_PC_GLOBALS.YES;

3707: );
3708:
3709: IF l_result = OE_PC_GLOBALS.YES THEN
3710: -- set OUT result to CONSTRAINED
3711: x_result := OE_PC_GLOBALS.YES;
3712: END IF;
3713:
3714: END IF;
3715:

Line 3725: IF l_result = OE_PC_GLOBALS.YES THEN

3721: ,p_record => l_rowtype_rec
3722: ,x_on_operation_action => l_on_operation_action
3723: );
3724:
3725: IF l_result = OE_PC_GLOBALS.YES THEN
3726: -- set OUT result to CONSTRAINED
3727: x_result := OE_PC_GLOBALS.YES;
3728: END IF;
3729:

Line 3727: x_result := OE_PC_GLOBALS.YES;

3723: );
3724:
3725: IF l_result = OE_PC_GLOBALS.YES THEN
3726: -- set OUT result to CONSTRAINED
3727: x_result := OE_PC_GLOBALS.YES;
3728: END IF;
3729:
3730: END IF;
3731:

Line 3742: IF l_result = OE_PC_GLOBALS.YES THEN

3738: ,p_record => l_rowtype_rec
3739: ,x_on_operation_action => l_on_operation_action
3740: );
3741:
3742: IF l_result = OE_PC_GLOBALS.YES THEN
3743: -- set OUT result to CONSTRAINED
3744: x_result := OE_PC_GLOBALS.YES;
3745: END IF;
3746:

Line 3744: x_result := OE_PC_GLOBALS.YES;

3740: );
3741:
3742: IF l_result = OE_PC_GLOBALS.YES THEN
3743: -- set OUT result to CONSTRAINED
3744: x_result := OE_PC_GLOBALS.YES;
3745: END IF;
3746:
3747: END IF;
3748:

Line 3758: IF l_result = OE_PC_GLOBALS.YES THEN

3754: ,p_record => l_rowtype_rec
3755: ,x_on_operation_action => l_on_operation_action
3756: );
3757:
3758: IF l_result = OE_PC_GLOBALS.YES THEN
3759: -- set OUT result to CONSTRAINED
3760: x_result := OE_PC_GLOBALS.YES;
3761: END IF;
3762:

Line 3760: x_result := OE_PC_GLOBALS.YES;

3756: );
3757:
3758: IF l_result = OE_PC_GLOBALS.YES THEN
3759: -- set OUT result to CONSTRAINED
3760: x_result := OE_PC_GLOBALS.YES;
3761: END IF;
3762:
3763: END IF;
3764:

Line 3774: IF l_result = OE_PC_GLOBALS.YES THEN

3770: ,p_record => l_rowtype_rec
3771: ,x_on_operation_action => l_on_operation_action
3772: );
3773:
3774: IF l_result = OE_PC_GLOBALS.YES THEN
3775: -- set OUT result to CONSTRAINED
3776: x_result := OE_PC_GLOBALS.YES;
3777: END IF;
3778:

Line 3776: x_result := OE_PC_GLOBALS.YES;

3772: );
3773:
3774: IF l_result = OE_PC_GLOBALS.YES THEN
3775: -- set OUT result to CONSTRAINED
3776: x_result := OE_PC_GLOBALS.YES;
3777: END IF;
3778:
3779: END IF;
3780:

Line 3790: IF l_result = OE_PC_GLOBALS.YES THEN

3786: ,p_record => l_rowtype_rec
3787: ,x_on_operation_action => l_on_operation_action
3788: );
3789:
3790: IF l_result = OE_PC_GLOBALS.YES THEN
3791: -- set OUT result to CONSTRAINED
3792: x_result := OE_PC_GLOBALS.YES;
3793: END IF;
3794:

Line 3792: x_result := OE_PC_GLOBALS.YES;

3788: );
3789:
3790: IF l_result = OE_PC_GLOBALS.YES THEN
3791: -- set OUT result to CONSTRAINED
3792: x_result := OE_PC_GLOBALS.YES;
3793: END IF;
3794:
3795: END IF;
3796:

Line 3806: IF l_result = OE_PC_GLOBALS.YES THEN

3802: ,p_record => l_rowtype_rec
3803: ,x_on_operation_action => l_on_operation_action
3804: );
3805:
3806: IF l_result = OE_PC_GLOBALS.YES THEN
3807: -- set OUT result to CONSTRAINED
3808: x_result := OE_PC_GLOBALS.YES;
3809: END IF;
3810:

Line 3808: x_result := OE_PC_GLOBALS.YES;

3804: );
3805:
3806: IF l_result = OE_PC_GLOBALS.YES THEN
3807: -- set OUT result to CONSTRAINED
3808: x_result := OE_PC_GLOBALS.YES;
3809: END IF;
3810:
3811: END IF;
3812:

Line 3822: IF l_result = OE_PC_GLOBALS.YES THEN

3818: ,p_record => l_rowtype_rec
3819: ,x_on_operation_action => l_on_operation_action
3820: );
3821:
3822: IF l_result = OE_PC_GLOBALS.YES THEN
3823: -- set OUT result to CONSTRAINED
3824: x_result := OE_PC_GLOBALS.YES;
3825: END IF;
3826:

Line 3824: x_result := OE_PC_GLOBALS.YES;

3820: );
3821:
3822: IF l_result = OE_PC_GLOBALS.YES THEN
3823: -- set OUT result to CONSTRAINED
3824: x_result := OE_PC_GLOBALS.YES;
3825: END IF;
3826:
3827: END IF;
3828:

Line 3840: IF l_result = OE_PC_GLOBALS.YES THEN

3836: ,p_record => l_rowtype_rec
3837: ,x_on_operation_action => l_on_operation_action
3838: );
3839:
3840: IF l_result = OE_PC_GLOBALS.YES THEN
3841: -- set OUT result to CONSTRAINED
3842: x_result := OE_PC_GLOBALS.YES;
3843: END IF;
3844:

Line 3842: x_result := OE_PC_GLOBALS.YES;

3838: );
3839:
3840: IF l_result = OE_PC_GLOBALS.YES THEN
3841: -- set OUT result to CONSTRAINED
3842: x_result := OE_PC_GLOBALS.YES;
3843: END IF;
3844:
3845: END IF;
3846:

Line 3856: IF l_result = OE_PC_GLOBALS.YES THEN

3852: ,p_record => l_rowtype_rec
3853: ,x_on_operation_action => l_on_operation_action
3854: );
3855:
3856: IF l_result = OE_PC_GLOBALS.YES THEN
3857: -- set OUT result to CONSTRAINED
3858: x_result := OE_PC_GLOBALS.YES;
3859: END IF;
3860:

Line 3858: x_result := OE_PC_GLOBALS.YES;

3854: );
3855:
3856: IF l_result = OE_PC_GLOBALS.YES THEN
3857: -- set OUT result to CONSTRAINED
3858: x_result := OE_PC_GLOBALS.YES;
3859: END IF;
3860:
3861: END IF;
3862:

Line 3872: IF l_result = OE_PC_GLOBALS.YES THEN

3868: ,p_record => l_rowtype_rec
3869: ,x_on_operation_action => l_on_operation_action
3870: );
3871:
3872: IF l_result = OE_PC_GLOBALS.YES THEN
3873: -- set OUT result to CONSTRAINED
3874: x_result := OE_PC_GLOBALS.YES;
3875: END IF;
3876:

Line 3874: x_result := OE_PC_GLOBALS.YES;

3870: );
3871:
3872: IF l_result = OE_PC_GLOBALS.YES THEN
3873: -- set OUT result to CONSTRAINED
3874: x_result := OE_PC_GLOBALS.YES;
3875: END IF;
3876:
3877: END IF;
3878:

Line 3888: IF l_result = OE_PC_GLOBALS.YES THEN

3884: ,p_record => l_rowtype_rec
3885: ,x_on_operation_action => l_on_operation_action
3886: );
3887:
3888: IF l_result = OE_PC_GLOBALS.YES THEN
3889: -- set OUT result to CONSTRAINED
3890: x_result := OE_PC_GLOBALS.YES;
3891: END IF;
3892:

Line 3890: x_result := OE_PC_GLOBALS.YES;

3886: );
3887:
3888: IF l_result = OE_PC_GLOBALS.YES THEN
3889: -- set OUT result to CONSTRAINED
3890: x_result := OE_PC_GLOBALS.YES;
3891: END IF;
3892:
3893: END IF;
3894:

Line 3904: IF l_result = OE_PC_GLOBALS.YES THEN

3900: ,p_record => l_rowtype_rec
3901: ,x_on_operation_action => l_on_operation_action
3902: );
3903:
3904: IF l_result = OE_PC_GLOBALS.YES THEN
3905: -- set OUT result to CONSTRAINED
3906: x_result := OE_PC_GLOBALS.YES;
3907: END IF;
3908:

Line 3906: x_result := OE_PC_GLOBALS.YES;

3902: );
3903:
3904: IF l_result = OE_PC_GLOBALS.YES THEN
3905: -- set OUT result to CONSTRAINED
3906: x_result := OE_PC_GLOBALS.YES;
3907: END IF;
3908:
3909: END IF;
3910:

Line 3920: IF l_result = OE_PC_GLOBALS.YES THEN

3916: ,p_record => l_rowtype_rec
3917: ,x_on_operation_action => l_on_operation_action
3918: );
3919:
3920: IF l_result = OE_PC_GLOBALS.YES THEN
3921: -- set OUT result to CONSTRAINED
3922: x_result := OE_PC_GLOBALS.YES;
3923: END IF;
3924:

Line 3922: x_result := OE_PC_GLOBALS.YES;

3918: );
3919:
3920: IF l_result = OE_PC_GLOBALS.YES THEN
3921: -- set OUT result to CONSTRAINED
3922: x_result := OE_PC_GLOBALS.YES;
3923: END IF;
3924:
3925: END IF;
3926:

Line 3936: IF l_result = OE_PC_GLOBALS.YES THEN

3932: ,p_record => l_rowtype_rec
3933: ,x_on_operation_action => l_on_operation_action
3934: );
3935:
3936: IF l_result = OE_PC_GLOBALS.YES THEN
3937: -- set OUT result to CONSTRAINED
3938: x_result := OE_PC_GLOBALS.YES;
3939: END IF;
3940:

Line 3938: x_result := OE_PC_GLOBALS.YES;

3934: );
3935:
3936: IF l_result = OE_PC_GLOBALS.YES THEN
3937: -- set OUT result to CONSTRAINED
3938: x_result := OE_PC_GLOBALS.YES;
3939: END IF;
3940:
3941: END IF;
3942:

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

3939: END IF;
3940:
3941: END IF;
3942:
3943: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
3944: IF l_debug_level > 0 THEN
3945: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
3946: END IF;
3947: g_check_all_cols_constraint := l_check_all_cols_constraint;