[Home] [Help]
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
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)
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
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
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;
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:
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:
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
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 ) ;
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 ) ;
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2365: ---------------------------------------------------------------------------------
2366:
2367: -- Bug 8217769 New Function added for Default Fulfillment Set
2368: FUNCTION DEFAULT_FULFILLMENT_SET
2369: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2370: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2371: , x_on_operation_action OUT NOCOPY NUMBER
2372: ) RETURN NUMBER
2373: IS
2404: -- Initializing return status to SUCCESS
2405: x_return_status := FND_API.G_RET_STS_SUCCESS;
2406:
2407: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2408: l_operation := OE_PC_GLOBALS.CREATE_OP;
2409: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2410: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2411: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2412: l_operation := OE_PC_GLOBALS.DELETE_OP;
2406:
2407: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2408: l_operation := OE_PC_GLOBALS.CREATE_OP;
2409: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2410: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2411: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2412: l_operation := OE_PC_GLOBALS.DELETE_OP;
2413: ELSE
2414: IF l_debug_level > 0 THEN
2408: l_operation := OE_PC_GLOBALS.CREATE_OP;
2409: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2410: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2411: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2412: l_operation := OE_PC_GLOBALS.DELETE_OP;
2413: ELSE
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2416: END IF;
2490: -- Initializing return status to SUCCESS
2491: x_return_status := FND_API.G_RET_STS_SUCCESS;
2492:
2493: -- Initializing out result to NOT CONSTRAINED
2494: x_result := OE_PC_GLOBALS.NO;
2495:
2496: -- Get the operation code to be passed to the security framework API
2497: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2498: -- Bug 1987983 : if the order source is Copy then skip the Attribute
2500: IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
2501: THEN
2502: RETURN;
2503: ELSE
2504: l_operation := OE_PC_GLOBALS.CREATE_OP;
2505: END IF;
2506: -- Bug 1755817: if there are no attribute-specific insert
2507: -- constraints, then no need to go further. Entity level
2508: -- security check for CREATE will be called again from
2507: -- constraints, then no need to go further. Entity level
2508: -- security check for CREATE will be called again from
2509: -- process order after defaulting.
2510: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
2511: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER
2512: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
2513: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
2514: )
2515: THEN
2516: RETURN;
2517: END IF;
2518:
2519: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2520: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2521: ELSE
2522: IF l_debug_level > 0 THEN
2523: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2524: END IF;
2542: (p_operation => l_operation
2543: ,p_record => l_rowtype_rec
2544: ,x_on_operation_action => l_on_operation_action
2545: );
2546: IF l_result = OE_PC_GLOBALS.YES THEN
2547: -- set OUT result to CONSTRAINED
2548: x_result := OE_PC_GLOBALS.YES;
2549: --RAISE;
2550: END IF;
2544: ,x_on_operation_action => l_on_operation_action
2545: );
2546: IF l_result = OE_PC_GLOBALS.YES THEN
2547: -- set OUT result to CONSTRAINED
2548: x_result := OE_PC_GLOBALS.YES;
2549: --RAISE;
2550: END IF;
2551: END IF;
2552:
2585: ,p_record => l_rowtype_rec
2586: ,x_on_operation_action => l_on_operation_action
2587: );
2588:
2589: IF l_result = OE_PC_GLOBALS.YES THEN
2590: -- set OUT result to CONSTRAINED
2591: x_result := OE_PC_GLOBALS.YES;
2592: END IF;
2593:
2587: );
2588:
2589: IF l_result = OE_PC_GLOBALS.YES THEN
2590: -- set OUT result to CONSTRAINED
2591: x_result := OE_PC_GLOBALS.YES;
2592: END IF;
2593:
2594: END IF;
2595:
2601: ,p_record => l_rowtype_rec
2602: ,x_on_operation_action => l_on_operation_action
2603: );
2604:
2605: IF l_result = OE_PC_GLOBALS.YES THEN
2606: -- set OUT result to CONSTRAINED
2607: x_result := OE_PC_GLOBALS.YES;
2608: END IF;
2609:
2603: );
2604:
2605: IF l_result = OE_PC_GLOBALS.YES THEN
2606: -- set OUT result to CONSTRAINED
2607: x_result := OE_PC_GLOBALS.YES;
2608: END IF;
2609:
2610: END IF;
2611: IF p_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2616: ,p_record => l_rowtype_rec
2617: ,x_on_operation_action => l_on_operation_action
2618: );
2619:
2620: IF l_result = OE_PC_GLOBALS.YES THEN
2621: -- set OUT result to CONSTRAINED
2622: x_result := OE_PC_GLOBALS.YES;
2623: END IF;
2624:
2618: );
2619:
2620: IF l_result = OE_PC_GLOBALS.YES THEN
2621: -- set OUT result to CONSTRAINED
2622: x_result := OE_PC_GLOBALS.YES;
2623: END IF;
2624:
2625: END IF;
2626: IF p_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2631: ,p_record => l_rowtype_rec
2632: ,x_on_operation_action => l_on_operation_action
2633: );
2634:
2635: IF l_result = OE_PC_GLOBALS.YES THEN
2636: -- set OUT result to CONSTRAINED
2637: x_result := OE_PC_GLOBALS.YES;
2638: END IF;
2639:
2633: );
2634:
2635: IF l_result = OE_PC_GLOBALS.YES THEN
2636: -- set OUT result to CONSTRAINED
2637: x_result := OE_PC_GLOBALS.YES;
2638: END IF;
2639:
2640: END IF;
2641: IF p_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;
2646: ,p_record => l_rowtype_rec
2647: ,x_on_operation_action => l_on_operation_action
2648: );
2649:
2650: IF l_result = OE_PC_GLOBALS.YES THEN
2651: -- set OUT result to CONSTRAINED
2652: x_result := OE_PC_GLOBALS.YES;
2653: END IF;
2654:
2648: );
2649:
2650: IF l_result = OE_PC_GLOBALS.YES THEN
2651: -- set OUT result to CONSTRAINED
2652: x_result := OE_PC_GLOBALS.YES;
2653: END IF;
2654:
2655: END IF;
2656: IF p_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
2661: ,p_record => l_rowtype_rec
2662: ,x_on_operation_action => l_on_operation_action
2663: );
2664:
2665: IF l_result = OE_PC_GLOBALS.YES THEN
2666: -- set OUT result to CONSTRAINED
2667: x_result := OE_PC_GLOBALS.YES;
2668: END IF;
2669:
2663: );
2664:
2665: IF l_result = OE_PC_GLOBALS.YES THEN
2666: -- set OUT result to CONSTRAINED
2667: x_result := OE_PC_GLOBALS.YES;
2668: END IF;
2669:
2670: END IF;
2671: IF p_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;
2676: ,p_record => l_rowtype_rec
2677: ,x_on_operation_action => l_on_operation_action
2678: );
2679:
2680: IF l_result = OE_PC_GLOBALS.YES THEN
2681: -- set OUT result to CONSTRAINED
2682: x_result := OE_PC_GLOBALS.YES;
2683: END IF;
2684:
2678: );
2679:
2680: IF l_result = OE_PC_GLOBALS.YES THEN
2681: -- set OUT result to CONSTRAINED
2682: x_result := OE_PC_GLOBALS.YES;
2683: END IF;
2684:
2685: END IF;
2686:
2692: ,p_record => l_rowtype_rec
2693: ,x_on_operation_action => l_on_operation_action
2694: );
2695:
2696: IF l_result = OE_PC_GLOBALS.YES THEN
2697: -- set OUT result to CONSTRAINED
2698: x_result := OE_PC_GLOBALS.YES;
2699: END IF;
2700:
2694: );
2695:
2696: IF l_result = OE_PC_GLOBALS.YES THEN
2697: -- set OUT result to CONSTRAINED
2698: x_result := OE_PC_GLOBALS.YES;
2699: END IF;
2700:
2701: END IF;
2702:
2708: ,p_record => l_rowtype_rec
2709: ,x_on_operation_action => l_on_operation_action
2710: );
2711:
2712: IF l_result = OE_PC_GLOBALS.YES THEN
2713: -- set OUT result to CONSTRAINED
2714: x_result := OE_PC_GLOBALS.YES;
2715: END IF;
2716:
2710: );
2711:
2712: IF l_result = OE_PC_GLOBALS.YES THEN
2713: -- set OUT result to CONSTRAINED
2714: x_result := OE_PC_GLOBALS.YES;
2715: END IF;
2716:
2717: END IF;
2718:
2724: ,p_record => l_rowtype_rec
2725: ,x_on_operation_action => l_on_operation_action
2726: );
2727:
2728: IF l_result = OE_PC_GLOBALS.YES THEN
2729: -- set OUT result to CONSTRAINED
2730: x_result := OE_PC_GLOBALS.YES;
2731: END IF;
2732:
2726: );
2727:
2728: IF l_result = OE_PC_GLOBALS.YES THEN
2729: -- set OUT result to CONSTRAINED
2730: x_result := OE_PC_GLOBALS.YES;
2731: END IF;
2732:
2733: END IF;
2734:
2740: ,p_record => l_rowtype_rec
2741: ,x_on_operation_action => l_on_operation_action
2742: );
2743:
2744: IF l_result = OE_PC_GLOBALS.YES THEN
2745: -- set OUT result to CONSTRAINED
2746: x_result := OE_PC_GLOBALS.YES;
2747: END IF;
2748:
2742: );
2743:
2744: IF l_result = OE_PC_GLOBALS.YES THEN
2745: -- set OUT result to CONSTRAINED
2746: x_result := OE_PC_GLOBALS.YES;
2747: END IF;
2748:
2749: END IF;
2750:
2756: ,p_record => l_rowtype_rec
2757: ,x_on_operation_action => l_on_operation_action
2758: );
2759:
2760: IF l_result = OE_PC_GLOBALS.YES THEN
2761: -- set OUT result to CONSTRAINED
2762: x_result := OE_PC_GLOBALS.YES;
2763: END IF;
2764:
2758: );
2759:
2760: IF l_result = OE_PC_GLOBALS.YES THEN
2761: -- set OUT result to CONSTRAINED
2762: x_result := OE_PC_GLOBALS.YES;
2763: END IF;
2764:
2765: END IF;
2766:
2772: ,p_record => l_rowtype_rec
2773: ,x_on_operation_action => l_on_operation_action
2774: );
2775:
2776: IF l_result = OE_PC_GLOBALS.YES THEN
2777: -- set OUT result to CONSTRAINED
2778: x_result := OE_PC_GLOBALS.YES;
2779: END IF;
2780:
2774: );
2775:
2776: IF l_result = OE_PC_GLOBALS.YES THEN
2777: -- set OUT result to CONSTRAINED
2778: x_result := OE_PC_GLOBALS.YES;
2779: END IF;
2780:
2781: END IF;
2782:
2788: ,p_record => l_rowtype_rec
2789: ,x_on_operation_action => l_on_operation_action
2790: );
2791:
2792: IF l_result = OE_PC_GLOBALS.YES THEN
2793: -- set OUT result to CONSTRAINED
2794: x_result := OE_PC_GLOBALS.YES;
2795: END IF;
2796:
2790: );
2791:
2792: IF l_result = OE_PC_GLOBALS.YES THEN
2793: -- set OUT result to CONSTRAINED
2794: x_result := OE_PC_GLOBALS.YES;
2795: END IF;
2796:
2797: END IF;
2798:
2804: ,p_record => l_rowtype_rec
2805: ,x_on_operation_action => l_on_operation_action
2806: );
2807:
2808: IF l_result = OE_PC_GLOBALS.YES THEN
2809: -- set OUT result to CONSTRAINED
2810: x_result := OE_PC_GLOBALS.YES;
2811: END IF;
2812:
2806: );
2807:
2808: IF l_result = OE_PC_GLOBALS.YES THEN
2809: -- set OUT result to CONSTRAINED
2810: x_result := OE_PC_GLOBALS.YES;
2811: END IF;
2812:
2813: END IF;
2814:
2820: ,p_record => l_rowtype_rec
2821: ,x_on_operation_action => l_on_operation_action
2822: );
2823:
2824: IF l_result = OE_PC_GLOBALS.YES THEN
2825: -- set OUT result to CONSTRAINED
2826: x_result := OE_PC_GLOBALS.YES;
2827: END IF;
2828:
2822: );
2823:
2824: IF l_result = OE_PC_GLOBALS.YES THEN
2825: -- set OUT result to CONSTRAINED
2826: x_result := OE_PC_GLOBALS.YES;
2827: END IF;
2828:
2829: END IF;
2830:
2836: ,p_record => l_rowtype_rec
2837: ,x_on_operation_action => l_on_operation_action
2838: );
2839:
2840: IF l_result = OE_PC_GLOBALS.YES THEN
2841: -- set OUT result to CONSTRAINED
2842: x_result := OE_PC_GLOBALS.YES;
2843: END IF;
2844:
2838: );
2839:
2840: IF l_result = OE_PC_GLOBALS.YES THEN
2841: -- set OUT result to CONSTRAINED
2842: x_result := OE_PC_GLOBALS.YES;
2843: END IF;
2844:
2845: END IF;
2846:
2852: ,p_record => l_rowtype_rec
2853: ,x_on_operation_action => l_on_operation_action
2854: );
2855:
2856: IF l_result = OE_PC_GLOBALS.YES THEN
2857: -- set OUT result to CONSTRAINED
2858: x_result := OE_PC_GLOBALS.YES;
2859: END IF;
2860:
2854: );
2855:
2856: IF l_result = OE_PC_GLOBALS.YES THEN
2857: -- set OUT result to CONSTRAINED
2858: x_result := OE_PC_GLOBALS.YES;
2859: END IF;
2860:
2861: END IF;
2862:
2868: ,p_record => l_rowtype_rec
2869: ,x_on_operation_action => l_on_operation_action
2870: );
2871:
2872: IF l_result = OE_PC_GLOBALS.YES THEN
2873: -- set OUT result to CONSTRAINED
2874: x_result := OE_PC_GLOBALS.YES;
2875: END IF;
2876:
2870: );
2871:
2872: IF l_result = OE_PC_GLOBALS.YES THEN
2873: -- set OUT result to CONSTRAINED
2874: x_result := OE_PC_GLOBALS.YES;
2875: END IF;
2876:
2877: END IF;
2878:
2884: ,p_record => l_rowtype_rec
2885: ,x_on_operation_action => l_on_operation_action
2886: );
2887:
2888: IF l_result = OE_PC_GLOBALS.YES THEN
2889: -- set OUT result to CONSTRAINED
2890: x_result := OE_PC_GLOBALS.YES;
2891: END IF;
2892:
2886: );
2887:
2888: IF l_result = OE_PC_GLOBALS.YES THEN
2889: -- set OUT result to CONSTRAINED
2890: x_result := OE_PC_GLOBALS.YES;
2891: END IF;
2892:
2893: END IF;
2894:
2900: ,p_record => l_rowtype_rec
2901: ,x_on_operation_action => l_on_operation_action
2902: );
2903:
2904: IF l_result = OE_PC_GLOBALS.YES THEN
2905: -- set OUT result to CONSTRAINED
2906: x_result := OE_PC_GLOBALS.YES;
2907: END IF;
2908:
2902: );
2903:
2904: IF l_result = OE_PC_GLOBALS.YES THEN
2905: -- set OUT result to CONSTRAINED
2906: x_result := OE_PC_GLOBALS.YES;
2907: END IF;
2908:
2909: END IF;
2910:
2916: ,p_record => l_rowtype_rec
2917: ,x_on_operation_action => l_on_operation_action
2918: );
2919:
2920: IF l_result = OE_PC_GLOBALS.YES THEN
2921: -- set OUT result to CONSTRAINED
2922: x_result := OE_PC_GLOBALS.YES;
2923: END IF;
2924:
2918: );
2919:
2920: IF l_result = OE_PC_GLOBALS.YES THEN
2921: -- set OUT result to CONSTRAINED
2922: x_result := OE_PC_GLOBALS.YES;
2923: END IF;
2924:
2925: END IF;
2926:
2932: ,p_record => l_rowtype_rec
2933: ,x_on_operation_action => l_on_operation_action
2934: );
2935:
2936: IF l_result = OE_PC_GLOBALS.YES THEN
2937: -- set OUT result to CONSTRAINED
2938: x_result := OE_PC_GLOBALS.YES;
2939: END IF;
2940:
2934: );
2935:
2936: IF l_result = OE_PC_GLOBALS.YES THEN
2937: -- set OUT result to CONSTRAINED
2938: x_result := OE_PC_GLOBALS.YES;
2939: END IF;
2940:
2941: END IF;
2942:
2948: ,p_record => l_rowtype_rec
2949: ,x_on_operation_action => l_on_operation_action
2950: );
2951:
2952: IF l_result = OE_PC_GLOBALS.YES THEN
2953: -- set OUT result to CONSTRAINED
2954: x_result := OE_PC_GLOBALS.YES;
2955: END IF;
2956:
2950: );
2951:
2952: IF l_result = OE_PC_GLOBALS.YES THEN
2953: -- set OUT result to CONSTRAINED
2954: x_result := OE_PC_GLOBALS.YES;
2955: END IF;
2956:
2957: END IF;
2958:
2964: ,p_record => l_rowtype_rec
2965: ,x_on_operation_action => l_on_operation_action
2966: );
2967:
2968: IF l_result = OE_PC_GLOBALS.YES THEN
2969: -- set OUT result to CONSTRAINED
2970: x_result := OE_PC_GLOBALS.YES;
2971: END IF;
2972:
2966: );
2967:
2968: IF l_result = OE_PC_GLOBALS.YES THEN
2969: -- set OUT result to CONSTRAINED
2970: x_result := OE_PC_GLOBALS.YES;
2971: END IF;
2972:
2973: END IF;
2974:
2980: ,p_record => l_rowtype_rec
2981: ,x_on_operation_action => l_on_operation_action
2982: );
2983:
2984: IF l_result = OE_PC_GLOBALS.YES THEN
2985: -- set OUT result to CONSTRAINED
2986: x_result := OE_PC_GLOBALS.YES;
2987: END IF;
2988:
2982: );
2983:
2984: IF l_result = OE_PC_GLOBALS.YES THEN
2985: -- set OUT result to CONSTRAINED
2986: x_result := OE_PC_GLOBALS.YES;
2987: END IF;
2988:
2989: END IF;
2990:
2996: ,p_record => l_rowtype_rec
2997: ,x_on_operation_action => l_on_operation_action
2998: );
2999:
3000: IF l_result = OE_PC_GLOBALS.YES THEN
3001: -- set OUT result to CONSTRAINED
3002: x_result := OE_PC_GLOBALS.YES;
3003: END IF;
3004:
2998: );
2999:
3000: IF l_result = OE_PC_GLOBALS.YES THEN
3001: -- set OUT result to CONSTRAINED
3002: x_result := OE_PC_GLOBALS.YES;
3003: END IF;
3004:
3005: END IF;
3006:
3012: ,p_record => l_rowtype_rec
3013: ,x_on_operation_action => l_on_operation_action
3014: );
3015:
3016: IF l_result = OE_PC_GLOBALS.YES THEN
3017: -- set OUT result to CONSTRAINED
3018: x_result := OE_PC_GLOBALS.YES;
3019: END IF;
3020:
3014: );
3015:
3016: IF l_result = OE_PC_GLOBALS.YES THEN
3017: -- set OUT result to CONSTRAINED
3018: x_result := OE_PC_GLOBALS.YES;
3019: END IF;
3020:
3021: END IF;
3022:
3028: ,p_record => l_rowtype_rec
3029: ,x_on_operation_action => l_on_operation_action
3030: );
3031:
3032: IF l_result = OE_PC_GLOBALS.YES THEN
3033: -- set OUT result to CONSTRAINED
3034: x_result := OE_PC_GLOBALS.YES;
3035: END IF;
3036:
3030: );
3031:
3032: IF l_result = OE_PC_GLOBALS.YES THEN
3033: -- set OUT result to CONSTRAINED
3034: x_result := OE_PC_GLOBALS.YES;
3035: END IF;
3036:
3037: END IF;
3038:
3044: ,p_record => l_rowtype_rec
3045: ,x_on_operation_action => l_on_operation_action
3046: );
3047:
3048: IF l_result = OE_PC_GLOBALS.YES THEN
3049: -- set OUT result to CONSTRAINED
3050: x_result := OE_PC_GLOBALS.YES;
3051: END IF;
3052:
3046: );
3047:
3048: IF l_result = OE_PC_GLOBALS.YES THEN
3049: -- set OUT result to CONSTRAINED
3050: x_result := OE_PC_GLOBALS.YES;
3051: END IF;
3052:
3053: END IF;
3054:
3060: ,p_record => l_rowtype_rec
3061: ,x_on_operation_action => l_on_operation_action
3062: );
3063:
3064: IF l_result = OE_PC_GLOBALS.YES THEN
3065: -- set OUT result to CONSTRAINED
3066: x_result := OE_PC_GLOBALS.YES;
3067: END IF;
3068:
3062: );
3063:
3064: IF l_result = OE_PC_GLOBALS.YES THEN
3065: -- set OUT result to CONSTRAINED
3066: x_result := OE_PC_GLOBALS.YES;
3067: END IF;
3068:
3069: END IF;
3070:
3076: ,p_record => l_rowtype_rec
3077: ,x_on_operation_action => l_on_operation_action
3078: );
3079:
3080: IF l_result = OE_PC_GLOBALS.YES THEN
3081: -- set OUT result to CONSTRAINED
3082: x_result := OE_PC_GLOBALS.YES;
3083: END IF;
3084:
3078: );
3079:
3080: IF l_result = OE_PC_GLOBALS.YES THEN
3081: -- set OUT result to CONSTRAINED
3082: x_result := OE_PC_GLOBALS.YES;
3083: END IF;
3084:
3085: END IF;
3086:
3092: ,p_record => l_rowtype_rec
3093: ,x_on_operation_action => l_on_operation_action
3094: );
3095:
3096: IF l_result = OE_PC_GLOBALS.YES THEN
3097: -- set OUT result to CONSTRAINED
3098: x_result := OE_PC_GLOBALS.YES;
3099: END IF;
3100:
3094: );
3095:
3096: IF l_result = OE_PC_GLOBALS.YES THEN
3097: -- set OUT result to CONSTRAINED
3098: x_result := OE_PC_GLOBALS.YES;
3099: END IF;
3100:
3101: END IF;
3102:
3108: ,p_record => l_rowtype_rec
3109: ,x_on_operation_action => l_on_operation_action
3110: );
3111:
3112: IF l_result = OE_PC_GLOBALS.YES THEN
3113: -- set OUT result to CONSTRAINED
3114: x_result := OE_PC_GLOBALS.YES;
3115: END IF;
3116:
3110: );
3111:
3112: IF l_result = OE_PC_GLOBALS.YES THEN
3113: -- set OUT result to CONSTRAINED
3114: x_result := OE_PC_GLOBALS.YES;
3115: END IF;
3116:
3117: END IF;
3118:
3124: ,p_record => l_rowtype_rec
3125: ,x_on_operation_action => l_on_operation_action
3126: );
3127:
3128: IF l_result = OE_PC_GLOBALS.YES THEN
3129: -- set OUT result to CONSTRAINED
3130: x_result := OE_PC_GLOBALS.YES;
3131: END IF;
3132:
3126: );
3127:
3128: IF l_result = OE_PC_GLOBALS.YES THEN
3129: -- set OUT result to CONSTRAINED
3130: x_result := OE_PC_GLOBALS.YES;
3131: END IF;
3132:
3133: END IF;
3134:
3140: ,p_record => l_rowtype_rec
3141: ,x_on_operation_action => l_on_operation_action
3142: );
3143:
3144: IF l_result = OE_PC_GLOBALS.YES THEN
3145: -- set OUT result to CONSTRAINED
3146: x_result := OE_PC_GLOBALS.YES;
3147: END IF;
3148:
3142: );
3143:
3144: IF l_result = OE_PC_GLOBALS.YES THEN
3145: -- set OUT result to CONSTRAINED
3146: x_result := OE_PC_GLOBALS.YES;
3147: END IF;
3148:
3149: END IF;
3150:
3156: (p_operation => l_operation
3157: ,p_record => l_rowtype_rec
3158: ,x_on_operation_action => l_on_operation_action
3159: );
3160: IF l_result = OE_PC_GLOBALS.YES THEN
3161: -- set OUT result to CONSTRAINED
3162: x_result := OE_PC_GLOBALS.YES;
3163: END IF;
3164:
3158: ,x_on_operation_action => l_on_operation_action
3159: );
3160: IF l_result = OE_PC_GLOBALS.YES THEN
3161: -- set OUT result to CONSTRAINED
3162: x_result := OE_PC_GLOBALS.YES;
3163: END IF;
3164:
3165: END IF;
3166:
3171: (p_operation => l_operation
3172: ,p_record => l_rowtype_rec
3173: ,x_on_operation_action => l_on_operation_action
3174: );
3175: IF l_result = OE_PC_GLOBALS.YES THEN
3176: -- set OUT result to CONSTRAINED
3177: x_result := OE_PC_GLOBALS.YES;
3178: END IF;
3179:
3173: ,x_on_operation_action => l_on_operation_action
3174: );
3175: IF l_result = OE_PC_GLOBALS.YES THEN
3176: -- set OUT result to CONSTRAINED
3177: x_result := OE_PC_GLOBALS.YES;
3178: END IF;
3179:
3180: END IF;
3181:
3186: (p_operation => l_operation
3187: ,p_record => l_rowtype_rec
3188: ,x_on_operation_action => l_on_operation_action
3189: );
3190: IF l_result = OE_PC_GLOBALS.YES THEN
3191: -- set OUT result to CONSTRAINED
3192: x_result := OE_PC_GLOBALS.YES;
3193: END IF;
3194:
3188: ,x_on_operation_action => l_on_operation_action
3189: );
3190: IF l_result = OE_PC_GLOBALS.YES THEN
3191: -- set OUT result to CONSTRAINED
3192: x_result := OE_PC_GLOBALS.YES;
3193: END IF;
3194:
3195: END IF;
3196:
3207: (p_operation => l_operation
3208: ,p_record => l_rowtype_rec
3209: ,x_on_operation_action => l_on_operation_action
3210: );
3211: IF l_result = OE_PC_GLOBALS.YES THEN
3212: -- set OUT result to CONSTRAINED
3213: x_result := OE_PC_GLOBALS.YES;
3214: END IF;
3215:
3209: ,x_on_operation_action => l_on_operation_action
3210: );
3211: IF l_result = OE_PC_GLOBALS.YES THEN
3212: -- set OUT result to CONSTRAINED
3213: x_result := OE_PC_GLOBALS.YES;
3214: END IF;
3215:
3216: END IF;
3217:
3222: (p_operation => l_operation
3223: ,p_record => l_rowtype_rec
3224: ,x_on_operation_action => l_on_operation_action
3225: );
3226: IF l_result = OE_PC_GLOBALS.YES THEN
3227: -- set OUT result to CONSTRAINED
3228: x_result := OE_PC_GLOBALS.YES;
3229: END IF;
3230:
3224: ,x_on_operation_action => l_on_operation_action
3225: );
3226: IF l_result = OE_PC_GLOBALS.YES THEN
3227: -- set OUT result to CONSTRAINED
3228: x_result := OE_PC_GLOBALS.YES;
3229: END IF;
3230:
3231: END IF;
3232: /* END PREPAYMENT */
3239: ,p_record => l_rowtype_rec
3240: ,x_on_operation_action => l_on_operation_action
3241: );
3242:
3243: IF l_result = OE_PC_GLOBALS.YES THEN
3244: -- set OUT result to CONSTRAINED
3245: x_result := OE_PC_GLOBALS.YES;
3246: END IF;
3247:
3241: );
3242:
3243: IF l_result = OE_PC_GLOBALS.YES THEN
3244: -- set OUT result to CONSTRAINED
3245: x_result := OE_PC_GLOBALS.YES;
3246: END IF;
3247:
3248: END IF;
3249:
3255: ,p_record => l_rowtype_rec
3256: ,x_on_operation_action => l_on_operation_action
3257: );
3258:
3259: IF l_result = OE_PC_GLOBALS.YES THEN
3260: -- set OUT result to CONSTRAINED
3261: x_result := OE_PC_GLOBALS.YES;
3262: END IF;
3263:
3257: );
3258:
3259: IF l_result = OE_PC_GLOBALS.YES THEN
3260: -- set OUT result to CONSTRAINED
3261: x_result := OE_PC_GLOBALS.YES;
3262: END IF;
3263:
3264: END IF;
3265:
3271: ,p_record => l_rowtype_rec
3272: ,x_on_operation_action => l_on_operation_action
3273: );
3274:
3275: IF l_result = OE_PC_GLOBALS.YES THEN
3276: -- set OUT result to CONSTRAINED
3277: x_result := OE_PC_GLOBALS.YES;
3278: END IF;
3279:
3273: );
3274:
3275: IF l_result = OE_PC_GLOBALS.YES THEN
3276: -- set OUT result to CONSTRAINED
3277: x_result := OE_PC_GLOBALS.YES;
3278: END IF;
3279:
3280: END IF;
3281:
3287: ,p_record => l_rowtype_rec
3288: ,x_on_operation_action => l_on_operation_action
3289: );
3290:
3291: IF l_result = OE_PC_GLOBALS.YES THEN
3292: -- set OUT result to CONSTRAINED
3293: x_result := OE_PC_GLOBALS.YES;
3294: END IF;
3295:
3289: );
3290:
3291: IF l_result = OE_PC_GLOBALS.YES THEN
3292: -- set OUT result to CONSTRAINED
3293: x_result := OE_PC_GLOBALS.YES;
3294: END IF;
3295:
3296: END IF;
3297:
3303: ,p_record => l_rowtype_rec
3304: ,x_on_operation_action => l_on_operation_action
3305: );
3306:
3307: IF l_result = OE_PC_GLOBALS.YES THEN
3308: -- set OUT result to CONSTRAINED
3309: x_result := OE_PC_GLOBALS.YES;
3310: END IF;
3311:
3305: );
3306:
3307: IF l_result = OE_PC_GLOBALS.YES THEN
3308: -- set OUT result to CONSTRAINED
3309: x_result := OE_PC_GLOBALS.YES;
3310: END IF;
3311:
3312: END IF;
3313:
3319: ,p_record => l_rowtype_rec
3320: ,x_on_operation_action => l_on_operation_action
3321: );
3322:
3323: IF l_result = OE_PC_GLOBALS.YES THEN
3324: -- set OUT result to CONSTRAINED
3325: x_result := OE_PC_GLOBALS.YES;
3326: END IF;
3327:
3321: );
3322:
3323: IF l_result = OE_PC_GLOBALS.YES THEN
3324: -- set OUT result to CONSTRAINED
3325: x_result := OE_PC_GLOBALS.YES;
3326: END IF;
3327:
3328: END IF;
3329:
3335: ,p_record => l_rowtype_rec
3336: ,x_on_operation_action => l_on_operation_action
3337: );
3338:
3339: IF l_result = OE_PC_GLOBALS.YES THEN
3340: -- set OUT result to CONSTRAINED
3341: x_result := OE_PC_GLOBALS.YES;
3342: END IF;
3343:
3337: );
3338:
3339: IF l_result = OE_PC_GLOBALS.YES THEN
3340: -- set OUT result to CONSTRAINED
3341: x_result := OE_PC_GLOBALS.YES;
3342: END IF;
3343:
3344: END IF;
3345:
3351: ,p_record => l_rowtype_rec
3352: ,x_on_operation_action => l_on_operation_action
3353: );
3354:
3355: IF l_result = OE_PC_GLOBALS.YES THEN
3356: -- set OUT result to CONSTRAINED
3357: x_result := OE_PC_GLOBALS.YES;
3358: END IF;
3359:
3353: );
3354:
3355: IF l_result = OE_PC_GLOBALS.YES THEN
3356: -- set OUT result to CONSTRAINED
3357: x_result := OE_PC_GLOBALS.YES;
3358: END IF;
3359:
3360: END IF;
3361:
3367: ,p_record => l_rowtype_rec
3368: ,x_on_operation_action => l_on_operation_action
3369: );
3370:
3371: IF l_result = OE_PC_GLOBALS.YES THEN
3372: -- set OUT result to CONSTRAINED
3373: x_result := OE_PC_GLOBALS.YES;
3374: END IF;
3375:
3369: );
3370:
3371: IF l_result = OE_PC_GLOBALS.YES THEN
3372: -- set OUT result to CONSTRAINED
3373: x_result := OE_PC_GLOBALS.YES;
3374: END IF;
3375:
3376: END IF;
3377:
3383: ,p_record => l_rowtype_rec
3384: ,x_on_operation_action => l_on_operation_action
3385: );
3386:
3387: IF l_result = OE_PC_GLOBALS.YES THEN
3388: -- set OUT result to CONSTRAINED
3389: x_result := OE_PC_GLOBALS.YES;
3390: END IF;
3391:
3385: );
3386:
3387: IF l_result = OE_PC_GLOBALS.YES THEN
3388: -- set OUT result to CONSTRAINED
3389: x_result := OE_PC_GLOBALS.YES;
3390: END IF;
3391:
3392: END IF;
3393:
3399: ,p_record => l_rowtype_rec
3400: ,x_on_operation_action => l_on_operation_action
3401: );
3402:
3403: IF l_result = OE_PC_GLOBALS.YES THEN
3404: -- set OUT result to CONSTRAINED
3405: x_result := OE_PC_GLOBALS.YES;
3406: END IF;
3407:
3401: );
3402:
3403: IF l_result = OE_PC_GLOBALS.YES THEN
3404: -- set OUT result to CONSTRAINED
3405: x_result := OE_PC_GLOBALS.YES;
3406: END IF;
3407:
3408: END IF;
3409:
3415: ,p_record => l_rowtype_rec
3416: ,x_on_operation_action => l_on_operation_action
3417: );
3418:
3419: IF l_result = OE_PC_GLOBALS.YES THEN
3420: -- set OUT result to CONSTRAINED
3421: x_result := OE_PC_GLOBALS.YES;
3422: END IF;
3423:
3417: );
3418:
3419: IF l_result = OE_PC_GLOBALS.YES THEN
3420: -- set OUT result to CONSTRAINED
3421: x_result := OE_PC_GLOBALS.YES;
3422: END IF;
3423:
3424: END IF;
3425:
3431: ,p_record => l_rowtype_rec
3432: ,x_on_operation_action => l_on_operation_action
3433: );
3434:
3435: IF l_result = OE_PC_GLOBALS.YES THEN
3436: -- set OUT result to CONSTRAINED
3437: x_result := OE_PC_GLOBALS.YES;
3438: END IF;
3439:
3433: );
3434:
3435: IF l_result = OE_PC_GLOBALS.YES THEN
3436: -- set OUT result to CONSTRAINED
3437: x_result := OE_PC_GLOBALS.YES;
3438: END IF;
3439:
3440: END IF;
3441:
3447: ,p_record => l_rowtype_rec
3448: ,x_on_operation_action => l_on_operation_action
3449: );
3450:
3451: IF l_result = OE_PC_GLOBALS.YES THEN
3452: -- set OUT result to CONSTRAINED
3453: x_result := OE_PC_GLOBALS.YES;
3454: END IF;
3455:
3449: );
3450:
3451: IF l_result = OE_PC_GLOBALS.YES THEN
3452: -- set OUT result to CONSTRAINED
3453: x_result := OE_PC_GLOBALS.YES;
3454: END IF;
3455:
3456: END IF;
3457:
3464: ,p_record => l_rowtype_rec
3465: ,x_on_operation_action => l_on_operation_action
3466: );
3467:
3468: IF l_result = OE_PC_GLOBALS.YES THEN
3469: -- set OUT result to CONSTRAINED
3470: x_result := OE_PC_GLOBALS.YES;
3471: END IF;
3472:
3466: );
3467:
3468: IF l_result = OE_PC_GLOBALS.YES THEN
3469: -- set OUT result to CONSTRAINED
3470: x_result := OE_PC_GLOBALS.YES;
3471: END IF;
3472:
3473: END IF;
3474:
3480: ,p_record => l_rowtype_rec
3481: ,x_on_operation_action => l_on_operation_action
3482: );
3483:
3484: IF l_result = OE_PC_GLOBALS.YES THEN
3485: -- set OUT result to CONSTRAINED
3486: x_result := OE_PC_GLOBALS.YES;
3487: END IF;
3488:
3482: );
3483:
3484: IF l_result = OE_PC_GLOBALS.YES THEN
3485: -- set OUT result to CONSTRAINED
3486: x_result := OE_PC_GLOBALS.YES;
3487: END IF;
3488:
3489: END IF;
3490: -- end 2395032
3498: ,p_record => l_rowtype_rec
3499: ,x_on_operation_action => l_on_operation_action
3500: );
3501:
3502: IF l_result = OE_PC_GLOBALS.YES THEN
3503: -- set OUT result to CONSTRAINED
3504: x_result := OE_PC_GLOBALS.YES;
3505: END IF;
3506:
3500: );
3501:
3502: IF l_result = OE_PC_GLOBALS.YES THEN
3503: -- set OUT result to CONSTRAINED
3504: x_result := OE_PC_GLOBALS.YES;
3505: END IF;
3506:
3507: END IF;
3508: -- END: Blankets Code Merge
3517: ,p_record => l_rowtype_rec
3518: ,x_on_operation_action => l_on_operation_action
3519: );
3520:
3521: IF l_result = OE_PC_GLOBALS.YES THEN
3522: -- set OUT result to CONSTRAINED
3523: x_result := OE_PC_GLOBALS.YES;
3524: END IF;
3525:
3519: );
3520:
3521: IF l_result = OE_PC_GLOBALS.YES THEN
3522: -- set OUT result to CONSTRAINED
3523: x_result := OE_PC_GLOBALS.YES;
3524: END IF;
3525:
3526: END IF;
3527:
3533: ,p_record => l_rowtype_rec
3534: ,x_on_operation_action => l_on_operation_action
3535: );
3536:
3537: IF l_result = OE_PC_GLOBALS.YES THEN
3538: -- set OUT result to CONSTRAINED
3539: x_result := OE_PC_GLOBALS.YES;
3540: END IF;
3541:
3535: );
3536:
3537: IF l_result = OE_PC_GLOBALS.YES THEN
3538: -- set OUT result to CONSTRAINED
3539: x_result := OE_PC_GLOBALS.YES;
3540: END IF;
3541:
3542: END IF;
3543:
3549: ,p_record => l_rowtype_rec
3550: ,x_on_operation_action => l_on_operation_action
3551: );
3552:
3553: IF l_result = OE_PC_GLOBALS.YES THEN
3554: -- set OUT result to CONSTRAINED
3555: x_result := OE_PC_GLOBALS.YES;
3556: END IF;
3557:
3551: );
3552:
3553: IF l_result = OE_PC_GLOBALS.YES THEN
3554: -- set OUT result to CONSTRAINED
3555: x_result := OE_PC_GLOBALS.YES;
3556: END IF;
3557:
3558: END IF;
3559:
3565: ,p_record => l_rowtype_rec
3566: ,x_on_operation_action => l_on_operation_action
3567: );
3568:
3569: IF l_result = OE_PC_GLOBALS.YES THEN
3570: -- set OUT result to CONSTRAINED
3571: x_result := OE_PC_GLOBALS.YES;
3572: END IF;
3573:
3567: );
3568:
3569: IF l_result = OE_PC_GLOBALS.YES THEN
3570: -- set OUT result to CONSTRAINED
3571: x_result := OE_PC_GLOBALS.YES;
3572: END IF;
3573:
3574: END IF;
3575:
3581: ,p_record => l_rowtype_rec
3582: ,x_on_operation_action => l_on_operation_action
3583: );
3584:
3585: IF l_result = OE_PC_GLOBALS.YES THEN
3586: -- set OUT result to CONSTRAINED
3587: x_result := OE_PC_GLOBALS.YES;
3588: END IF;
3589:
3583: );
3584:
3585: IF l_result = OE_PC_GLOBALS.YES THEN
3586: -- set OUT result to CONSTRAINED
3587: x_result := OE_PC_GLOBALS.YES;
3588: END IF;
3589:
3590: END IF;
3591:
3597: ,p_record => l_rowtype_rec
3598: ,x_on_operation_action => l_on_operation_action
3599: );
3600:
3601: IF l_result = OE_PC_GLOBALS.YES THEN
3602: -- set OUT result to CONSTRAINED
3603: x_result := OE_PC_GLOBALS.YES;
3604: END IF;
3605:
3599: );
3600:
3601: IF l_result = OE_PC_GLOBALS.YES THEN
3602: -- set OUT result to CONSTRAINED
3603: x_result := OE_PC_GLOBALS.YES;
3604: END IF;
3605:
3606: END IF;
3607:
3613: ,p_record => l_rowtype_rec
3614: ,x_on_operation_action => l_on_operation_action
3615: );
3616:
3617: IF l_result = OE_PC_GLOBALS.YES THEN
3618: -- set OUT result to CONSTRAINED
3619: x_result := OE_PC_GLOBALS.YES;
3620: END IF;
3621:
3615: );
3616:
3617: IF l_result = OE_PC_GLOBALS.YES THEN
3618: -- set OUT result to CONSTRAINED
3619: x_result := OE_PC_GLOBALS.YES;
3620: END IF;
3621:
3622: END IF;
3623:
3629: ,p_record => l_rowtype_rec
3630: ,x_on_operation_action => l_on_operation_action
3631: );
3632:
3633: IF l_result = OE_PC_GLOBALS.YES THEN
3634: -- set OUT result to CONSTRAINED
3635: x_result := OE_PC_GLOBALS.YES;
3636: END IF;
3637:
3631: );
3632:
3633: IF l_result = OE_PC_GLOBALS.YES THEN
3634: -- set OUT result to CONSTRAINED
3635: x_result := OE_PC_GLOBALS.YES;
3636: END IF;
3637:
3638: END IF;
3639:
3648: ,p_record => l_rowtype_rec
3649: ,x_on_operation_action => l_on_operation_action
3650: );
3651:
3652: IF l_result = OE_PC_GLOBALS.YES THEN
3653: -- set OUT result to CONSTRAINED
3654: x_result := OE_PC_GLOBALS.YES;
3655: END IF;
3656:
3650: );
3651:
3652: IF l_result = OE_PC_GLOBALS.YES THEN
3653: -- set OUT result to CONSTRAINED
3654: x_result := OE_PC_GLOBALS.YES;
3655: END IF;
3656:
3657: END IF;
3658: -- Bug 8217769 End IF
3667: -- updated and profile was set to 'N', global at the end should
3668: -- be re-set to 'Y' - this indicates to process order that no
3669: -- constrainable attributes were updated and thus, it would
3670: -- suppress entity level security check also.
3671: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
3672: l_check_all_cols_constraint := g_check_all_cols_constraint;
3673: g_check_all_cols_constraint := 'N';
3674: END IF;
3675:
3681: ,p_record => l_rowtype_rec
3682: ,x_on_operation_action => l_on_operation_action
3683: );
3684:
3685: IF l_result = OE_PC_GLOBALS.YES THEN
3686: -- set OUT result to CONSTRAINED
3687: x_result := OE_PC_GLOBALS.YES;
3688: END IF;
3689:
3683: );
3684:
3685: IF l_result = OE_PC_GLOBALS.YES THEN
3686: -- set OUT result to CONSTRAINED
3687: x_result := OE_PC_GLOBALS.YES;
3688: END IF;
3689:
3690: END IF;
3691:
3697: ,p_record => l_rowtype_rec
3698: ,x_on_operation_action => l_on_operation_action
3699: );
3700:
3701: IF l_result = OE_PC_GLOBALS.YES THEN
3702: -- set OUT result to CONSTRAINED
3703: x_result := OE_PC_GLOBALS.YES;
3704: END IF;
3705:
3699: );
3700:
3701: IF l_result = OE_PC_GLOBALS.YES THEN
3702: -- set OUT result to CONSTRAINED
3703: x_result := OE_PC_GLOBALS.YES;
3704: END IF;
3705:
3706: END IF;
3707:
3713: ,p_record => l_rowtype_rec
3714: ,x_on_operation_action => l_on_operation_action
3715: );
3716:
3717: IF l_result = OE_PC_GLOBALS.YES THEN
3718: -- set OUT result to CONSTRAINED
3719: x_result := OE_PC_GLOBALS.YES;
3720: END IF;
3721:
3715: );
3716:
3717: IF l_result = OE_PC_GLOBALS.YES THEN
3718: -- set OUT result to CONSTRAINED
3719: x_result := OE_PC_GLOBALS.YES;
3720: END IF;
3721:
3722: END IF;
3723:
3729: ,p_record => l_rowtype_rec
3730: ,x_on_operation_action => l_on_operation_action
3731: );
3732:
3733: IF l_result = OE_PC_GLOBALS.YES THEN
3734: -- set OUT result to CONSTRAINED
3735: x_result := OE_PC_GLOBALS.YES;
3736: END IF;
3737:
3731: );
3732:
3733: IF l_result = OE_PC_GLOBALS.YES THEN
3734: -- set OUT result to CONSTRAINED
3735: x_result := OE_PC_GLOBALS.YES;
3736: END IF;
3737:
3738: END IF;
3739:
3745: ,p_record => l_rowtype_rec
3746: ,x_on_operation_action => l_on_operation_action
3747: );
3748:
3749: IF l_result = OE_PC_GLOBALS.YES THEN
3750: -- set OUT result to CONSTRAINED
3751: x_result := OE_PC_GLOBALS.YES;
3752: END IF;
3753:
3747: );
3748:
3749: IF l_result = OE_PC_GLOBALS.YES THEN
3750: -- set OUT result to CONSTRAINED
3751: x_result := OE_PC_GLOBALS.YES;
3752: END IF;
3753:
3754: END IF;
3755:
3761: ,p_record => l_rowtype_rec
3762: ,x_on_operation_action => l_on_operation_action
3763: );
3764:
3765: IF l_result = OE_PC_GLOBALS.YES THEN
3766: -- set OUT result to CONSTRAINED
3767: x_result := OE_PC_GLOBALS.YES;
3768: END IF;
3769:
3763: );
3764:
3765: IF l_result = OE_PC_GLOBALS.YES THEN
3766: -- set OUT result to CONSTRAINED
3767: x_result := OE_PC_GLOBALS.YES;
3768: END IF;
3769:
3770: END IF;
3771:
3777: ,p_record => l_rowtype_rec
3778: ,x_on_operation_action => l_on_operation_action
3779: );
3780:
3781: IF l_result = OE_PC_GLOBALS.YES THEN
3782: -- set OUT result to CONSTRAINED
3783: x_result := OE_PC_GLOBALS.YES;
3784: END IF;
3785:
3779: );
3780:
3781: IF l_result = OE_PC_GLOBALS.YES THEN
3782: -- set OUT result to CONSTRAINED
3783: x_result := OE_PC_GLOBALS.YES;
3784: END IF;
3785:
3786: END IF;
3787:
3793: ,p_record => l_rowtype_rec
3794: ,x_on_operation_action => l_on_operation_action
3795: );
3796:
3797: IF l_result = OE_PC_GLOBALS.YES THEN
3798: -- set OUT result to CONSTRAINED
3799: x_result := OE_PC_GLOBALS.YES;
3800: END IF;
3801:
3795: );
3796:
3797: IF l_result = OE_PC_GLOBALS.YES THEN
3798: -- set OUT result to CONSTRAINED
3799: x_result := OE_PC_GLOBALS.YES;
3800: END IF;
3801:
3802: END IF;
3803:
3810: ,p_record => l_rowtype_rec
3811: ,x_on_operation_action => l_on_operation_action
3812: );
3813:
3814: IF l_result = OE_PC_GLOBALS.YES THEN
3815: -- set OUT result to CONSTRAINED
3816: x_result := OE_PC_GLOBALS.YES;
3817: END IF;
3818:
3812: );
3813:
3814: IF l_result = OE_PC_GLOBALS.YES THEN
3815: -- set OUT result to CONSTRAINED
3816: x_result := OE_PC_GLOBALS.YES;
3817: END IF;
3818:
3819: END IF;
3820:
3826: ,p_record => l_rowtype_rec
3827: ,x_on_operation_action => l_on_operation_action
3828: );
3829:
3830: IF l_result = OE_PC_GLOBALS.YES THEN
3831: -- set OUT result to CONSTRAINED
3832: x_result := OE_PC_GLOBALS.YES;
3833: END IF;
3834:
3828: );
3829:
3830: IF l_result = OE_PC_GLOBALS.YES THEN
3831: -- set OUT result to CONSTRAINED
3832: x_result := OE_PC_GLOBALS.YES;
3833: END IF;
3834:
3835: END IF;
3836:
3842: ,p_record => l_rowtype_rec
3843: ,x_on_operation_action => l_on_operation_action
3844: );
3845:
3846: IF l_result = OE_PC_GLOBALS.YES THEN
3847: -- set OUT result to CONSTRAINED
3848: x_result := OE_PC_GLOBALS.YES;
3849: END IF;
3850:
3844: );
3845:
3846: IF l_result = OE_PC_GLOBALS.YES THEN
3847: -- set OUT result to CONSTRAINED
3848: x_result := OE_PC_GLOBALS.YES;
3849: END IF;
3850:
3851: END IF;
3852:
3858: ,p_record => l_rowtype_rec
3859: ,x_on_operation_action => l_on_operation_action
3860: );
3861:
3862: IF l_result = OE_PC_GLOBALS.YES THEN
3863: -- set OUT result to CONSTRAINED
3864: x_result := OE_PC_GLOBALS.YES;
3865: END IF;
3866:
3860: );
3861:
3862: IF l_result = OE_PC_GLOBALS.YES THEN
3863: -- set OUT result to CONSTRAINED
3864: x_result := OE_PC_GLOBALS.YES;
3865: END IF;
3866:
3867: END IF;
3868:
3874: ,p_record => l_rowtype_rec
3875: ,x_on_operation_action => l_on_operation_action
3876: );
3877:
3878: IF l_result = OE_PC_GLOBALS.YES THEN
3879: -- set OUT result to CONSTRAINED
3880: x_result := OE_PC_GLOBALS.YES;
3881: END IF;
3882:
3876: );
3877:
3878: IF l_result = OE_PC_GLOBALS.YES THEN
3879: -- set OUT result to CONSTRAINED
3880: x_result := OE_PC_GLOBALS.YES;
3881: END IF;
3882:
3883: END IF;
3884:
3890: ,p_record => l_rowtype_rec
3891: ,x_on_operation_action => l_on_operation_action
3892: );
3893:
3894: IF l_result = OE_PC_GLOBALS.YES THEN
3895: -- set OUT result to CONSTRAINED
3896: x_result := OE_PC_GLOBALS.YES;
3897: END IF;
3898:
3892: );
3893:
3894: IF l_result = OE_PC_GLOBALS.YES THEN
3895: -- set OUT result to CONSTRAINED
3896: x_result := OE_PC_GLOBALS.YES;
3897: END IF;
3898:
3899: END IF;
3900:
3908: ,p_record => l_rowtype_rec
3909: ,x_on_operation_action => l_on_operation_action
3910: );
3911:
3912: IF l_result = OE_PC_GLOBALS.YES THEN
3913: -- set OUT result to CONSTRAINED
3914: x_result := OE_PC_GLOBALS.YES;
3915: END IF;
3916:
3910: );
3911:
3912: IF l_result = OE_PC_GLOBALS.YES THEN
3913: -- set OUT result to CONSTRAINED
3914: x_result := OE_PC_GLOBALS.YES;
3915: END IF;
3916:
3917: END IF;
3918:
3924: ,p_record => l_rowtype_rec
3925: ,x_on_operation_action => l_on_operation_action
3926: );
3927:
3928: IF l_result = OE_PC_GLOBALS.YES THEN
3929: -- set OUT result to CONSTRAINED
3930: x_result := OE_PC_GLOBALS.YES;
3931: END IF;
3932:
3926: );
3927:
3928: IF l_result = OE_PC_GLOBALS.YES THEN
3929: -- set OUT result to CONSTRAINED
3930: x_result := OE_PC_GLOBALS.YES;
3931: END IF;
3932:
3933: END IF;
3934:
3940: ,p_record => l_rowtype_rec
3941: ,x_on_operation_action => l_on_operation_action
3942: );
3943:
3944: IF l_result = OE_PC_GLOBALS.YES THEN
3945: -- set OUT result to CONSTRAINED
3946: x_result := OE_PC_GLOBALS.YES;
3947: END IF;
3948:
3942: );
3943:
3944: IF l_result = OE_PC_GLOBALS.YES THEN
3945: -- set OUT result to CONSTRAINED
3946: x_result := OE_PC_GLOBALS.YES;
3947: END IF;
3948:
3949: END IF;
3950:
3956: ,p_record => l_rowtype_rec
3957: ,x_on_operation_action => l_on_operation_action
3958: );
3959:
3960: IF l_result = OE_PC_GLOBALS.YES THEN
3961: -- set OUT result to CONSTRAINED
3962: x_result := OE_PC_GLOBALS.YES;
3963: END IF;
3964:
3958: );
3959:
3960: IF l_result = OE_PC_GLOBALS.YES THEN
3961: -- set OUT result to CONSTRAINED
3962: x_result := OE_PC_GLOBALS.YES;
3963: END IF;
3964:
3965: END IF;
3966:
3972: ,p_record => l_rowtype_rec
3973: ,x_on_operation_action => l_on_operation_action
3974: );
3975:
3976: IF l_result = OE_PC_GLOBALS.YES THEN
3977: -- set OUT result to CONSTRAINED
3978: x_result := OE_PC_GLOBALS.YES;
3979: END IF;
3980:
3974: );
3975:
3976: IF l_result = OE_PC_GLOBALS.YES THEN
3977: -- set OUT result to CONSTRAINED
3978: x_result := OE_PC_GLOBALS.YES;
3979: END IF;
3980:
3981: END IF;
3982:
3988: ,p_record => l_rowtype_rec
3989: ,x_on_operation_action => l_on_operation_action
3990: );
3991:
3992: IF l_result = OE_PC_GLOBALS.YES THEN
3993: -- set OUT result to CONSTRAINED
3994: x_result := OE_PC_GLOBALS.YES;
3995: END IF;
3996:
3990: );
3991:
3992: IF l_result = OE_PC_GLOBALS.YES THEN
3993: -- set OUT result to CONSTRAINED
3994: x_result := OE_PC_GLOBALS.YES;
3995: END IF;
3996:
3997: END IF;
3998:
4004: ,p_record => l_rowtype_rec
4005: ,x_on_operation_action => l_on_operation_action
4006: );
4007:
4008: IF l_result = OE_PC_GLOBALS.YES THEN
4009: -- set OUT result to CONSTRAINED
4010: x_result := OE_PC_GLOBALS.YES;
4011: END IF;
4012:
4006: );
4007:
4008: IF l_result = OE_PC_GLOBALS.YES THEN
4009: -- set OUT result to CONSTRAINED
4010: x_result := OE_PC_GLOBALS.YES;
4011: END IF;
4012:
4013: END IF;
4014:
4011: END IF;
4012:
4013: END IF;
4014:
4015: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
4016: IF l_debug_level > 0 THEN
4017: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
4018: END IF;
4019: g_check_all_cols_constraint := l_check_all_cols_constraint;