40: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
41: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
42: , p_operation => p_operation
43: , p_qualifier_attribute => p_record.transaction_phase_code
44: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_BLANKET_LINE
45: , p_column_name => p_column_name
46: , p_check_all_cols_constraint => g_check_all_cols_constraint
47: , p_is_caller_defaulting => g_is_caller_defaulting
48: , p_use_cached_results => 'Y'
50: , x_constraining_conditions_grp => l_grp
51: , x_on_operation_action => x_on_operation_action
52: );
53:
54: if l_result = OE_PC_GLOBALS.YES then
55:
56: IF g_check_all_cols_constraint = 'Y'
57: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
58: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
53:
54: if l_result = OE_PC_GLOBALS.YES then
55:
56: IF g_check_all_cols_constraint = 'Y'
57: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
58: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
59: AND p_column_name IS NOT NULL THEN
60: SELECT column_name
61: INTO l_column_name
54: if l_result = OE_PC_GLOBALS.YES then
55:
56: IF g_check_all_cols_constraint = 'Y'
57: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
58: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
59: AND p_column_name IS NOT NULL THEN
60: SELECT column_name
61: INTO l_column_name
62: FROM oe_pc_constraints
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;
86:
87: /*
88: OE_DEBUG_PUB.add('Action performed code : '||x_on_operation_action,1);
89:
90: IF l_result = OE_PC_GLOBALS.YES THEN
91: IF x_on_operation_action = 1 THEN
92: IF p_column_name = 'ORDERED_QUANTITY' THEN
93: oe_debug_pub.add('Setting Cancellation Flag to True',1);
94: oe_sales_can_util.G_REQUIRE_REASON := TRUE;
106: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
107: OE_DEBUG_PUB.add('Audit Trail enabled for booked orders only ...',5);
108:
109: IF p_record.booked_flag = 'Y' THEN
110: IF l_result = OE_PC_GLOBALS.YES THEN
111: l_history_captured := FALSE;
112: IF x_on_operation_action = 1 THEN
113: BEGIN
114: FOR l_ind in 1..l_ctr LOOP
151: END IF;
152: END IF;
153:
154: ELSE -- capture audit for all orders
155: IF l_result = OE_PC_GLOBALS.YES THEN
156: l_history_captured := FALSE;
157: IF x_on_operation_action = 1 THEN
158: BEGIN
159: FOR l_ind in 1..l_ctr LOOP
201: END IF;
202: */
203: /* End AuditTrail */
204: IF x_on_operation_action > 0 THEN
205: l_result := OE_PC_GLOBALS.NO;
206: END IF;
207: RETURN l_result;
208:
209: END Is_Op_Constrained;
210:
211: -- PUBLIC PROCEDURES
212:
213: FUNCTION ACCOUNTING_RULE
214: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
215: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
216: , x_on_operation_action OUT NOCOPY NUMBER
217: ) RETURN NUMBER
218: IS
231: END ACCOUNTING_RULE;
232:
233:
234: FUNCTION CUST_PO_NUMBER
235: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
236: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
237: , x_on_operation_action OUT NOCOPY NUMBER
238: ) RETURN NUMBER
239: IS
252: END CUST_PO_NUMBER;
253:
254:
255: FUNCTION DELIVER_TO_ORG
256: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
257: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
258: , x_on_operation_action OUT NOCOPY NUMBER
259: ) RETURN NUMBER
260: IS
273: END DELIVER_TO_ORG;
274:
275:
276: FUNCTION FREIGHT_TERMS
277: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
278: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
279: , x_on_operation_action OUT NOCOPY NUMBER
280: ) RETURN NUMBER
281: IS
294: END FREIGHT_TERMS;
295:
296:
297: FUNCTION INVENTORY_ITEM
298: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
299: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
300: , x_on_operation_action OUT NOCOPY NUMBER
301: ) RETURN NUMBER
302: IS
314:
315: END INVENTORY_ITEM;
316:
317: FUNCTION INVOICE_TO_ORG
318: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
319: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
320: , x_on_operation_action OUT NOCOPY NUMBER
321: ) RETURN NUMBER
322: IS
334:
335: END INVOICE_TO_ORG;
336:
337: FUNCTION INVOICING_RULE
338: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
339: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
340: , x_on_operation_action OUT NOCOPY NUMBER
341: ) RETURN NUMBER
342: IS
354:
355: END INVOICING_RULE;
356:
357: FUNCTION LINE_NUMBER
358: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
359: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
360: , x_on_operation_action OUT NOCOPY NUMBER
361: ) RETURN NUMBER
362: IS
375: END LINE_NUMBER;
376:
377:
378: FUNCTION LINE_TYPE
379: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
380: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
381: , x_on_operation_action OUT NOCOPY NUMBER
382: ) RETURN NUMBER
383: IS
397:
398:
399:
400: FUNCTION ORDER_QUANTITY_UOM
401: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
402: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
403: , x_on_operation_action OUT NOCOPY NUMBER
404: ) RETURN NUMBER
405: IS
418: END ORDER_QUANTITY_UOM;
419:
420:
421: FUNCTION PACKING_INSTRUCTIONS
422: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
423: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
424: , x_on_operation_action OUT NOCOPY NUMBER
425: ) RETURN NUMBER
426: IS
440: END PACKING_INSTRUCTIONS;
441:
442:
443: FUNCTION PAYMENT_TERM
444: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
445: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
446: , x_on_operation_action OUT NOCOPY NUMBER
447: ) RETURN NUMBER
448: IS
460:
461: END PAYMENT_TERM;
462:
463: FUNCTION PLANNING_PRIORITY
464: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
465: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
466: , x_on_operation_action OUT NOCOPY NUMBER
467: ) RETURN NUMBER
468: IS
481: END PLANNING_PRIORITY;
482:
483:
484: FUNCTION PRICE_LIST
485: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
486: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
487: , x_on_operation_action OUT NOCOPY NUMBER
488: ) RETURN NUMBER
489: IS
502: END PRICE_LIST;
503:
504:
505: FUNCTION PRICING_DATE
506: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
507: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
508: , x_on_operation_action OUT NOCOPY NUMBER
509: ) RETURN NUMBER
510: IS
523: END PRICING_DATE;
524:
525:
526: FUNCTION PRICING_QUANTITY
527: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
528: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
529: , x_on_operation_action OUT NOCOPY NUMBER
530: ) RETURN NUMBER
531: IS
544: END PRICING_QUANTITY;
545:
546:
547: FUNCTION PRICING_QUANTITY_UOM
548: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
549: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
550: , x_on_operation_action OUT NOCOPY NUMBER
551: ) RETURN NUMBER
552: IS
565: END PRICING_QUANTITY_UOM;
566:
567:
568: FUNCTION PROJECT
569: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
570: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
571: , x_on_operation_action OUT NOCOPY NUMBER
572: ) RETURN NUMBER
573: IS
586: END PROJECT;
587:
588:
589: FUNCTION PROMISE_DATE
590: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
591: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
592: , x_on_operation_action OUT NOCOPY NUMBER
593: ) RETURN NUMBER
594: IS
606:
607: END PROMISE_DATE;
608:
609: FUNCTION REFERENCE_CUST_TRX_LINE
610: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
611: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
612: , x_on_operation_action OUT NOCOPY NUMBER
613: ) RETURN NUMBER
614: IS
626:
627: END REFERENCE_CUST_TRX_LINE;
628:
629: FUNCTION REFERENCE_TYPE
630: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
631: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
632: , x_on_operation_action OUT NOCOPY NUMBER
633: ) RETURN NUMBER
634: IS
647: END REFERENCE_TYPE;
648:
649:
650: FUNCTION REQUEST_DATE
651: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
652: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
653: , x_on_operation_action OUT NOCOPY NUMBER
654: ) RETURN NUMBER
655: IS
668: END REQUEST_DATE;
669:
670:
671: FUNCTION RETURN_REASON
672: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
673: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
674: , x_on_operation_action OUT NOCOPY NUMBER
675: ) RETURN NUMBER
676: IS
689: END RETURN_REASON;
690:
691:
692: FUNCTION SALESREP
693: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
694: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
695: , x_on_operation_action OUT NOCOPY NUMBER
696: ) RETURN NUMBER
697: IS
709:
710: END SALESREP;
711:
712: FUNCTION SHIP_SET
713: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
714: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
715: , x_on_operation_action OUT NOCOPY NUMBER
716: ) RETURN NUMBER
717: IS
729:
730: END SHIP_SET;
731:
732: FUNCTION ARRIVAL_SET
733: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
734: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
735: , x_on_operation_action OUT NOCOPY NUMBER
736: ) RETURN NUMBER
737: IS
750: END ARRIVAL_SET;
751:
752:
753: FUNCTION SCHEDULE_ARRIVAL_DATE
754: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
755: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
756: , x_on_operation_action OUT NOCOPY NUMBER
757: ) RETURN NUMBER
758: IS
770:
771: END SCHEDULE_ARRIVAL_DATE;
772:
773: FUNCTION SCHEDULE_SHIP_DATE
774: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
775: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
776: , x_on_operation_action OUT NOCOPY NUMBER
777: ) RETURN NUMBER
778: IS
791: END SCHEDULE_SHIP_DATE;
792:
793:
794: FUNCTION SHIPMENT_NUMBER
795: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
796: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
797: , x_on_operation_action OUT NOCOPY NUMBER
798: ) RETURN NUMBER
799: IS
812: END SHIPMENT_NUMBER;
813:
814:
815: FUNCTION SHIPMENT_PRIORITY
816: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
817: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
818: , x_on_operation_action OUT NOCOPY NUMBER
819: ) RETURN NUMBER
820: IS
833: END SHIPMENT_PRIORITY;
834:
835:
836: FUNCTION SHIPPED_QUANTITY
837: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
838: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
839: , x_on_operation_action OUT NOCOPY NUMBER
840: ) RETURN NUMBER
841: IS
853:
854: END SHIPPED_QUANTITY;
855:
856: FUNCTION SHIPPING_INSTRUCTIONS
857: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
858: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
859: , x_on_operation_action OUT NOCOPY NUMBER
860: ) RETURN NUMBER
861: IS
874: END SHIPPING_INSTRUCTIONS;
875:
876:
877: FUNCTION SHIPPING_METHOD
878: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
879: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
880: , x_on_operation_action OUT NOCOPY NUMBER
881: ) RETURN NUMBER
882: IS
895: END SHIPPING_METHOD;
896:
897:
898: FUNCTION SHIPPING_QUANTITY
899: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
900: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
901: , x_on_operation_action OUT NOCOPY NUMBER
902: ) RETURN NUMBER
903: IS
916: END SHIPPING_QUANTITY;
917:
918:
919: FUNCTION SHIPPING_QUANTITY_UOM
920: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
921: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
922: , x_on_operation_action OUT NOCOPY NUMBER
923: ) RETURN NUMBER
924: IS
937: END SHIPPING_QUANTITY_UOM;
938:
939:
940: FUNCTION SHIP_FROM_ORG
941: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
942: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
943: , x_on_operation_action OUT NOCOPY NUMBER
944: ) RETURN NUMBER
945: IS
957:
958: END SHIP_FROM_ORG;
959:
960: FUNCTION SUBINVENTORY
961: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
962: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
963: , x_on_operation_action OUT NOCOPY NUMBER
964: ) RETURN NUMBER
965: IS
977:
978: END SUBINVENTORY;
979:
980: FUNCTION SHIP_MODEL_COMPLETE
981: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
982: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
983: , x_on_operation_action OUT NOCOPY NUMBER
984: ) RETURN NUMBER
985: IS
998: END SHIP_MODEL_COMPLETE;
999:
1000:
1001: FUNCTION SHIP_TOLERANCE_ABOVE
1002: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1003: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1004: , x_on_operation_action OUT NOCOPY NUMBER
1005: ) RETURN NUMBER
1006: IS
1019: END SHIP_TOLERANCE_ABOVE;
1020:
1021:
1022: FUNCTION SHIP_TOLERANCE_BELOW
1023: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1024: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1025: , x_on_operation_action OUT NOCOPY NUMBER
1026: ) RETURN NUMBER
1027: IS
1040: END SHIP_TOLERANCE_BELOW;
1041:
1042:
1043: FUNCTION SHIP_TO_CONTACT
1044: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1045: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1046: , x_on_operation_action OUT NOCOPY NUMBER
1047: ) RETURN NUMBER
1048: IS
1061: END SHIP_TO_CONTACT;
1062:
1063:
1064: FUNCTION SHIP_TO_ORG
1065: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1066: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1067: , x_on_operation_action OUT NOCOPY NUMBER
1068: ) RETURN NUMBER
1069: IS
1082: END SHIP_TO_ORG;
1083:
1084:
1085: FUNCTION SOLD_TO_ORG
1086: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1087: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1088: , x_on_operation_action OUT NOCOPY NUMBER
1089: ) RETURN NUMBER
1090: IS
1103: END SOLD_TO_ORG;
1104:
1105:
1106: FUNCTION SOURCE_TYPE
1107: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1108: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1109: , x_on_operation_action OUT NOCOPY NUMBER
1110: ) RETURN NUMBER
1111: IS
1124: END SOURCE_TYPE;
1125:
1126:
1127: FUNCTION TASK
1128: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1129: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1130: , x_on_operation_action OUT NOCOPY NUMBER
1131: ) RETURN NUMBER
1132: IS
1145: END TASK;
1146:
1147:
1148: FUNCTION TAX
1149: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1150: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1151: , x_on_operation_action OUT NOCOPY NUMBER
1152: ) RETURN NUMBER
1153: IS
1166: END TAX;
1167:
1168:
1169: FUNCTION TAX_DATE
1170: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1171: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1172: , x_on_operation_action OUT NOCOPY NUMBER
1173: ) RETURN NUMBER
1174: IS
1187: END TAX_DATE;
1188:
1189:
1190: FUNCTION TAX_EXEMPT
1191: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1192: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1193: , x_on_operation_action OUT NOCOPY NUMBER
1194: ) RETURN NUMBER
1195: IS
1208: END TAX_EXEMPT;
1209:
1210:
1211: FUNCTION TAX_EXEMPT_NUMBER
1212: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1213: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1214: , x_on_operation_action OUT NOCOPY NUMBER
1215: ) RETURN NUMBER
1216: IS
1229: END TAX_EXEMPT_NUMBER;
1230:
1231:
1232: FUNCTION TAX_EXEMPT_REASON
1233: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1234: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1235: , x_on_operation_action OUT NOCOPY NUMBER
1236: ) RETURN NUMBER
1237: IS
1250: END TAX_EXEMPT_REASON;
1251:
1252:
1253: FUNCTION UNIT_LIST_PRICE
1254: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1255: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1256: , x_on_operation_action OUT NOCOPY NUMBER
1257: ) RETURN NUMBER
1258: IS
1272:
1273:
1274: /*1449220*/
1275: FUNCTION ITEM_IDENTIFIER_TYPE
1276: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1277: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1278: , x_on_operation_action OUT NOCOPY NUMBER
1279: ) RETURN NUMBER
1280: IS
1294: /*1449220*/
1295:
1296:
1297: FUNCTION BLANKET_LINE_MIN_AMOUNT
1298: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1299: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1300: , x_on_operation_action OUT NOCOPY NUMBER
1301: ) RETURN NUMBER
1302: IS
1314:
1315: END BLANKET_LINE_MIN_AMOUNT;
1316:
1317: FUNCTION BLANKET_LINE_MAX_AMOUNT
1318: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1319: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1320: , x_on_operation_action OUT NOCOPY NUMBER
1321: ) RETURN NUMBER
1322: IS
1334:
1335: END BLANKET_LINE_MAX_AMOUNT;
1336:
1337: FUNCTION BLANKET_MIN_QUANTITY
1338: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1339: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1340: , x_on_operation_action OUT NOCOPY NUMBER
1341: ) RETURN NUMBER
1342: IS
1354:
1355: END BLANKET_MIN_QUANTITY;
1356:
1357: FUNCTION BLANKET_MAX_QUANTITY
1358: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1359: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1360: , x_on_operation_action OUT NOCOPY NUMBER
1361: ) RETURN NUMBER
1362: IS
1374:
1375: END BLANKET_MAX_QUANTITY;
1376:
1377: FUNCTION MIN_RELEASE_AMOUNT
1378: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1379: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1380: , x_on_operation_action OUT NOCOPY NUMBER
1381: ) RETURN NUMBER
1382: IS
1394:
1395: END MIN_RELEASE_AMOUNT;
1396:
1397: FUNCTION MAX_RELEASE_AMOUNT
1398: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1399: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1400: , x_on_operation_action OUT NOCOPY NUMBER
1401: ) RETURN NUMBER
1402: IS
1414:
1415: END MAX_RELEASE_AMOUNT;
1416:
1417: FUNCTION MIN_RELEASE_QUANTITY
1418: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1419: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1420: , x_on_operation_action OUT NOCOPY NUMBER
1421: ) RETURN NUMBER
1422: IS
1434:
1435: END MIN_RELEASE_QUANTITY;
1436:
1437: FUNCTION MAX_RELEASE_QUANTITY
1438: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1439: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1440: , x_on_operation_action OUT NOCOPY NUMBER
1441: ) RETURN NUMBER
1442: IS
1454:
1455: END MAX_RELEASE_QUANTITY;
1456:
1457: FUNCTION OVERRIDE_BLANKET_CONTROLS_FLAG
1458: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1459: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1460: , x_on_operation_action OUT NOCOPY NUMBER
1461: ) RETURN NUMBER
1462: IS
1474:
1475: END OVERRIDE_BLANKET_CONTROLS_FLAG;
1476:
1477: FUNCTION OVERRIDE_RELEASE_CONTROLS_FLAG
1478: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1479: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1480: , x_on_operation_action OUT NOCOPY NUMBER
1481: ) RETURN NUMBER
1482: IS
1494:
1495: END OVERRIDE_RELEASE_CONTROLS_FLAG;
1496:
1497: FUNCTION ENFORCE_ACCOUNTING_RULE_FLAG
1498: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1499: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1500: , x_on_operation_action OUT NOCOPY NUMBER
1501: ) RETURN NUMBER
1502: IS
1514:
1515: END ENFORCE_ACCOUNTING_RULE_FLAG;
1516:
1517: FUNCTION ENFORCE_INVOICE_TO_FLAG
1518: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1519: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1520: , x_on_operation_action OUT NOCOPY NUMBER
1521: ) RETURN NUMBER
1522: IS
1534:
1535: END ENFORCE_INVOICE_TO_FLAG;
1536:
1537: FUNCTION ENFORCE_PRICE_LIST_FLAG
1538: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1539: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1540: , x_on_operation_action OUT NOCOPY NUMBER
1541: ) RETURN NUMBER
1542: IS
1554:
1555: END ENFORCE_PRICE_LIST_FLAG;
1556:
1557: FUNCTION ENFORCE_PAYMENT_TERM_FLAG
1558: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1559: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1560: , x_on_operation_action OUT NOCOPY NUMBER
1561: ) RETURN NUMBER
1562: IS
1574:
1575: END ENFORCE_PAYMENT_TERM_FLAG;
1576:
1577: FUNCTION ENFORCE_INVOICING_RULE_FLAG
1578: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1579: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1580: , x_on_operation_action OUT NOCOPY NUMBER
1581: ) RETURN NUMBER
1582: IS
1594:
1595: END ENFORCE_INVOICING_RULE_FLAG;
1596:
1597: FUNCTION ENFORCE_SHIP_TO_FLAG
1598: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1599: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1600: , x_on_operation_action OUT NOCOPY NUMBER
1601: ) RETURN NUMBER
1602: IS
1614:
1615: END ENFORCE_SHIP_TO_FLAG;
1616:
1617: FUNCTION ENFORCE_FREIGHT_TERM_FLAG
1618: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1619: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1620: , x_on_operation_action OUT NOCOPY NUMBER
1621: ) RETURN NUMBER
1622: IS
1634:
1635: END ENFORCE_FREIGHT_TERM_FLAG;
1636:
1637: FUNCTION ENFORCE_SHIPPING_METHOD_FLAG
1638: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1639: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1640: , x_on_operation_action OUT NOCOPY NUMBER
1641: ) RETURN NUMBER
1642: IS
1654:
1655: END ENFORCE_SHIPPING_METHOD_FLAG;
1656:
1657: FUNCTION START_DATE_ACTIVE
1658: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1659: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1660: , x_on_operation_action OUT NOCOPY NUMBER
1661: ) RETURN NUMBER
1662: IS
1674:
1675: END START_DATE_ACTIVE;
1676:
1677: FUNCTION END_DATE_ACTIVE
1678: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1679: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1680: , x_on_operation_action OUT NOCOPY NUMBER
1681: ) RETURN NUMBER
1682: IS
1694:
1695: END END_DATE_ACTIVE;
1696:
1697: FUNCTION PREFERRED_GRADE
1698: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1699: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1700: , x_on_operation_action OUT NOCOPY NUMBER
1701: ) RETURN NUMBER
1702: IS
1714:
1715: END PREFERRED_GRADE;
1716:
1717: FUNCTION DISCOUNT_PERCENT
1718: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1719: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1720: , x_on_operation_action OUT NOCOPY NUMBER
1721: ) RETURN NUMBER
1722: IS
1734:
1735: END DISCOUNT_PERCENT;
1736:
1737: FUNCTION DISCOUNT_AMOUNT
1738: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1739: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1740: , x_on_operation_action OUT NOCOPY NUMBER
1741: ) RETURN NUMBER
1742: IS
1754:
1755: END DISCOUNT_AMOUNT;
1756: --bug 6531947
1757: FUNCTION CONTEXT
1758: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1759: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1760: , x_on_operation_action OUT NOCOPY NUMBER
1761: ) RETURN NUMBER
1762: IS
1774:
1775: END CONTEXT;
1776:
1777: FUNCTION ATTRIBUTE1
1778: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1779: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1780: , x_on_operation_action OUT NOCOPY NUMBER
1781: ) RETURN NUMBER
1782: IS
1794:
1795: END ATTRIBUTE1;
1796:
1797: FUNCTION ATTRIBUTE2
1798: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1799: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1800: , x_on_operation_action OUT NOCOPY NUMBER
1801: ) RETURN NUMBER
1802: IS
1814:
1815: END ATTRIBUTE2;
1816:
1817: FUNCTION ATTRIBUTE3
1818: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1819: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1820: , x_on_operation_action OUT NOCOPY NUMBER
1821: ) RETURN NUMBER
1822: IS
1834:
1835: END ATTRIBUTE3;
1836:
1837: FUNCTION ATTRIBUTE4
1838: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1839: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1840: , x_on_operation_action OUT NOCOPY NUMBER
1841: ) RETURN NUMBER
1842: IS
1854:
1855: END ATTRIBUTE4;
1856:
1857: FUNCTION ATTRIBUTE5
1858: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1859: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1860: , x_on_operation_action OUT NOCOPY NUMBER
1861: ) RETURN NUMBER
1862: IS
1874:
1875: END ATTRIBUTE5;
1876:
1877: FUNCTION ATTRIBUTE6
1878: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1879: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1880: , x_on_operation_action OUT NOCOPY NUMBER
1881: ) RETURN NUMBER
1882: IS
1894:
1895: END ATTRIBUTE6;
1896:
1897: FUNCTION ATTRIBUTE7
1898: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1899: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1900: , x_on_operation_action OUT NOCOPY NUMBER
1901: ) RETURN NUMBER
1902: IS
1914:
1915: END ATTRIBUTE7;
1916:
1917: FUNCTION ATTRIBUTE8
1918: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1919: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1920: , x_on_operation_action OUT NOCOPY NUMBER
1921: ) RETURN NUMBER
1922: IS
1934:
1935: END ATTRIBUTE8;
1936:
1937: FUNCTION ATTRIBUTE9
1938: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1939: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1940: , x_on_operation_action OUT NOCOPY NUMBER
1941: ) RETURN NUMBER
1942: IS
1954:
1955: END ATTRIBUTE9;
1956:
1957: FUNCTION ATTRIBUTE10
1958: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1959: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1960: , x_on_operation_action OUT NOCOPY NUMBER
1961: ) RETURN NUMBER
1962: IS
1974:
1975: END ATTRIBUTE10;
1976:
1977: FUNCTION ATTRIBUTE11
1978: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1979: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
1980: , x_on_operation_action OUT NOCOPY NUMBER
1981: ) RETURN NUMBER
1982: IS
1994:
1995: END ATTRIBUTE11;
1996:
1997: FUNCTION ATTRIBUTE12
1998: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1999: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2000: , x_on_operation_action OUT NOCOPY NUMBER
2001: ) RETURN NUMBER
2002: IS
2014:
2015: END ATTRIBUTE12;
2016:
2017: FUNCTION ATTRIBUTE13
2018: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2019: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2020: , x_on_operation_action OUT NOCOPY NUMBER
2021: ) RETURN NUMBER
2022: IS
2034:
2035: END ATTRIBUTE13;
2036:
2037: FUNCTION ATTRIBUTE14
2038: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2039: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2040: , x_on_operation_action OUT NOCOPY NUMBER
2041: ) RETURN NUMBER
2042: IS
2054:
2055: END ATTRIBUTE14;
2056:
2057: FUNCTION ATTRIBUTE15
2058: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2059: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2060: , x_on_operation_action OUT NOCOPY NUMBER
2061: ) RETURN NUMBER
2062: IS
2074:
2075: END ATTRIBUTE15;
2076:
2077: FUNCTION ATTRIBUTE16
2078: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2079: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2080: , x_on_operation_action OUT NOCOPY NUMBER
2081: ) RETURN NUMBER
2082: IS
2094:
2095: END ATTRIBUTE16;
2096:
2097: FUNCTION ATTRIBUTE17
2098: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2099: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2100: , x_on_operation_action OUT NOCOPY NUMBER
2101: ) RETURN NUMBER
2102: IS
2114:
2115: END ATTRIBUTE17;
2116:
2117: FUNCTION ATTRIBUTE18
2118: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2119: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2120: , x_on_operation_action OUT NOCOPY NUMBER
2121: ) RETURN NUMBER
2122: IS
2134:
2135: END ATTRIBUTE18;
2136:
2137: FUNCTION ATTRIBUTE19
2138: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2139: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2140: , x_on_operation_action OUT NOCOPY NUMBER
2141: ) RETURN NUMBER
2142: IS
2154:
2155: END ATTRIBUTE19;
2156:
2157: FUNCTION ATTRIBUTE20
2158: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2159: , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
2160: , x_on_operation_action OUT NOCOPY NUMBER
2161: ) RETURN NUMBER
2162: IS
2190: -- Initializing return status to SUCCESS
2191: x_return_status := FND_API.G_RET_STS_SUCCESS;
2192:
2193: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2194: l_operation := OE_PC_GLOBALS.CREATE_OP;
2195: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2196: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2198: l_operation := OE_PC_GLOBALS.DELETE_OP;
2192:
2193: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2194: l_operation := OE_PC_GLOBALS.CREATE_OP;
2195: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2196: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2198: l_operation := OE_PC_GLOBALS.DELETE_OP;
2199: ELSE
2200: oe_debug_pub.add('Invalid operation',1);
2194: l_operation := OE_PC_GLOBALS.CREATE_OP;
2195: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2196: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2198: l_operation := OE_PC_GLOBALS.DELETE_OP;
2199: ELSE
2200: oe_debug_pub.add('Invalid operation',1);
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2251: -- Initializing return status to SUCCESS
2252: x_return_status := FND_API.G_RET_STS_SUCCESS;
2253:
2254: -- Initializing out result to NOT CONSTRAINED
2255: x_result := OE_PC_GLOBALS.NO;
2256:
2257: -- Get the operation code to be passed to the security framework API
2258: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2259:
2262: -- IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
2263: -- THEN
2264: -- RETURN;
2265: -- ELSE
2266: l_operation := OE_PC_GLOBALS.CREATE_OP;
2267: -- END IF;
2268:
2269: -- Bug 1755817: if there are no attribute-specific insert
2270: -- constraints, then no need to go further. Entity level
2270: -- constraints, then no need to go further. Entity level
2271: -- security check for CREATE will be called again from
2272: -- process order after defaulting.
2273: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
2274: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE
2275: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
2276: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
2277: )
2278: THEN
2279: RETURN;
2280: END IF;
2281:
2282: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2283: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2284: ELSE
2285: oe_debug_pub.add('Invalid operation',1);
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2304: ,p_record => l_rowtype_rec
2305: ,x_on_operation_action => l_on_operation_action
2306: );
2307:
2308: IF l_result = OE_PC_GLOBALS.YES THEN
2309: -- set OUT result to CONSTRAINED
2310: x_result := OE_PC_GLOBALS.YES;
2311: END IF;
2312:
2306: );
2307:
2308: IF l_result = OE_PC_GLOBALS.YES THEN
2309: -- set OUT result to CONSTRAINED
2310: x_result := OE_PC_GLOBALS.YES;
2311: END IF;
2312:
2313: END IF;
2314:
2320: ,p_record => l_rowtype_rec
2321: ,x_on_operation_action => l_on_operation_action
2322: );
2323:
2324: IF l_result = OE_PC_GLOBALS.YES THEN
2325: -- set OUT result to CONSTRAINED
2326: x_result := OE_PC_GLOBALS.YES;
2327: END IF;
2328:
2322: );
2323:
2324: IF l_result = OE_PC_GLOBALS.YES THEN
2325: -- set OUT result to CONSTRAINED
2326: x_result := OE_PC_GLOBALS.YES;
2327: END IF;
2328:
2329: END IF;
2330:
2336: ,p_record => l_rowtype_rec
2337: ,x_on_operation_action => l_on_operation_action
2338: );
2339:
2340: IF l_result = OE_PC_GLOBALS.YES THEN
2341: -- set OUT result to CONSTRAINED
2342: x_result := OE_PC_GLOBALS.YES;
2343: END IF;
2344:
2338: );
2339:
2340: IF l_result = OE_PC_GLOBALS.YES THEN
2341: -- set OUT result to CONSTRAINED
2342: x_result := OE_PC_GLOBALS.YES;
2343: END IF;
2344:
2345: END IF;
2346:
2352: ,p_record => l_rowtype_rec
2353: ,x_on_operation_action => l_on_operation_action
2354: );
2355:
2356: IF l_result = OE_PC_GLOBALS.YES THEN
2357: -- set OUT result to CONSTRAINED
2358: x_result := OE_PC_GLOBALS.YES;
2359: END IF;
2360:
2354: );
2355:
2356: IF l_result = OE_PC_GLOBALS.YES THEN
2357: -- set OUT result to CONSTRAINED
2358: x_result := OE_PC_GLOBALS.YES;
2359: END IF;
2360:
2361: END IF;
2362:
2368: ,p_record => l_rowtype_rec
2369: ,x_on_operation_action => l_on_operation_action
2370: );
2371:
2372: IF l_result = OE_PC_GLOBALS.YES THEN
2373: -- set OUT result to CONSTRAINED
2374: x_result := OE_PC_GLOBALS.YES;
2375: END IF;
2376:
2370: );
2371:
2372: IF l_result = OE_PC_GLOBALS.YES THEN
2373: -- set OUT result to CONSTRAINED
2374: x_result := OE_PC_GLOBALS.YES;
2375: END IF;
2376:
2377: END IF;
2378:
2384: ,p_record => l_rowtype_rec
2385: ,x_on_operation_action => l_on_operation_action
2386: );
2387:
2388: IF l_result = OE_PC_GLOBALS.YES THEN
2389: -- set OUT result to CONSTRAINED
2390: x_result := OE_PC_GLOBALS.YES;
2391: END IF;
2392:
2386: );
2387:
2388: IF l_result = OE_PC_GLOBALS.YES THEN
2389: -- set OUT result to CONSTRAINED
2390: x_result := OE_PC_GLOBALS.YES;
2391: END IF;
2392:
2393: END IF;
2394:
2400: ,p_record => l_rowtype_rec
2401: ,x_on_operation_action => l_on_operation_action
2402: );
2403:
2404: IF l_result = OE_PC_GLOBALS.YES THEN
2405: -- set OUT result to CONSTRAINED
2406: x_result := OE_PC_GLOBALS.YES;
2407: END IF;
2408:
2402: );
2403:
2404: IF l_result = OE_PC_GLOBALS.YES THEN
2405: -- set OUT result to CONSTRAINED
2406: x_result := OE_PC_GLOBALS.YES;
2407: END IF;
2408:
2409: END IF;
2410:
2416: ,p_record => l_rowtype_rec
2417: ,x_on_operation_action => l_on_operation_action
2418: );
2419:
2420: IF l_result = OE_PC_GLOBALS.YES THEN
2421: -- set OUT result to CONSTRAINED
2422: x_result := OE_PC_GLOBALS.YES;
2423: END IF;
2424:
2418: );
2419:
2420: IF l_result = OE_PC_GLOBALS.YES THEN
2421: -- set OUT result to CONSTRAINED
2422: x_result := OE_PC_GLOBALS.YES;
2423: END IF;
2424:
2425: END IF;
2426:
2432: ,p_record => l_rowtype_rec
2433: ,x_on_operation_action => l_on_operation_action
2434: );
2435:
2436: IF l_result = OE_PC_GLOBALS.YES THEN
2437: -- set OUT result to CONSTRAINED
2438: x_result := OE_PC_GLOBALS.YES;
2439: END IF;
2440:
2434: );
2435:
2436: IF l_result = OE_PC_GLOBALS.YES THEN
2437: -- set OUT result to CONSTRAINED
2438: x_result := OE_PC_GLOBALS.YES;
2439: END IF;
2440:
2441: END IF;
2442:
2448: ,p_record => l_rowtype_rec
2449: ,x_on_operation_action => l_on_operation_action
2450: );
2451:
2452: IF l_result = OE_PC_GLOBALS.YES THEN
2453: -- set OUT result to CONSTRAINED
2454: x_result := OE_PC_GLOBALS.YES;
2455: END IF;
2456:
2450: );
2451:
2452: IF l_result = OE_PC_GLOBALS.YES THEN
2453: -- set OUT result to CONSTRAINED
2454: x_result := OE_PC_GLOBALS.YES;
2455: END IF;
2456:
2457: END IF;
2458:
2464: ,p_record => l_rowtype_rec
2465: ,x_on_operation_action => l_on_operation_action
2466: );
2467:
2468: IF l_result = OE_PC_GLOBALS.YES THEN
2469: -- set OUT result to CONSTRAINED
2470: x_result := OE_PC_GLOBALS.YES;
2471: END IF;
2472:
2466: );
2467:
2468: IF l_result = OE_PC_GLOBALS.YES THEN
2469: -- set OUT result to CONSTRAINED
2470: x_result := OE_PC_GLOBALS.YES;
2471: END IF;
2472:
2473: END IF;
2474:
2480: ,p_record => l_rowtype_rec
2481: ,x_on_operation_action => l_on_operation_action
2482: );
2483:
2484: IF l_result = OE_PC_GLOBALS.YES THEN
2485: -- set OUT result to CONSTRAINED
2486: x_result := OE_PC_GLOBALS.YES;
2487: END IF;
2488:
2482: );
2483:
2484: IF l_result = OE_PC_GLOBALS.YES THEN
2485: -- set OUT result to CONSTRAINED
2486: x_result := OE_PC_GLOBALS.YES;
2487: END IF;
2488:
2489: END IF;
2490:
2496: ,p_record => l_rowtype_rec
2497: ,x_on_operation_action => l_on_operation_action
2498: );
2499:
2500: IF l_result = OE_PC_GLOBALS.YES THEN
2501: -- set OUT result to CONSTRAINED
2502: x_result := OE_PC_GLOBALS.YES;
2503: END IF;
2504:
2498: );
2499:
2500: IF l_result = OE_PC_GLOBALS.YES THEN
2501: -- set OUT result to CONSTRAINED
2502: x_result := OE_PC_GLOBALS.YES;
2503: END IF;
2504:
2505: END IF;
2506:
2512: ,p_record => l_rowtype_rec
2513: ,x_on_operation_action => l_on_operation_action
2514: );
2515:
2516: IF l_result = OE_PC_GLOBALS.YES THEN
2517: -- set OUT result to CONSTRAINED
2518: x_result := OE_PC_GLOBALS.YES;
2519: END IF;
2520:
2514: );
2515:
2516: IF l_result = OE_PC_GLOBALS.YES THEN
2517: -- set OUT result to CONSTRAINED
2518: x_result := OE_PC_GLOBALS.YES;
2519: END IF;
2520:
2521: END IF;
2522:
2528: ,p_record => l_rowtype_rec
2529: ,x_on_operation_action => l_on_operation_action
2530: );
2531:
2532: IF l_result = OE_PC_GLOBALS.YES THEN
2533: -- set OUT result to CONSTRAINED
2534: x_result := OE_PC_GLOBALS.YES;
2535: END IF;
2536:
2530: );
2531:
2532: IF l_result = OE_PC_GLOBALS.YES THEN
2533: -- set OUT result to CONSTRAINED
2534: x_result := OE_PC_GLOBALS.YES;
2535: END IF;
2536:
2537: END IF;
2538:
2544: ,p_record => l_rowtype_rec
2545: ,x_on_operation_action => l_on_operation_action
2546: );
2547:
2548: IF l_result = OE_PC_GLOBALS.YES THEN
2549: -- set OUT result to CONSTRAINED
2550: x_result := OE_PC_GLOBALS.YES;
2551: END IF;
2552:
2546: );
2547:
2548: IF l_result = OE_PC_GLOBALS.YES THEN
2549: -- set OUT result to CONSTRAINED
2550: x_result := OE_PC_GLOBALS.YES;
2551: END IF;
2552:
2553: END IF;
2554:
2560: ,p_record => l_rowtype_rec
2561: ,x_on_operation_action => l_on_operation_action
2562: );
2563:
2564: IF l_result = OE_PC_GLOBALS.YES THEN
2565: -- set OUT result to CONSTRAINED
2566: x_result := OE_PC_GLOBALS.YES;
2567: END IF;
2568:
2562: );
2563:
2564: IF l_result = OE_PC_GLOBALS.YES THEN
2565: -- set OUT result to CONSTRAINED
2566: x_result := OE_PC_GLOBALS.YES;
2567: END IF;
2568:
2569: END IF;
2570:
2576: ,p_record => l_rowtype_rec
2577: ,x_on_operation_action => l_on_operation_action
2578: );
2579:
2580: IF l_result = OE_PC_GLOBALS.YES THEN
2581: -- set OUT result to CONSTRAINED
2582: x_result := OE_PC_GLOBALS.YES;
2583: END IF;
2584:
2578: );
2579:
2580: IF l_result = OE_PC_GLOBALS.YES THEN
2581: -- set OUT result to CONSTRAINED
2582: x_result := OE_PC_GLOBALS.YES;
2583: END IF;
2584:
2585: END IF;
2586:
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:
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:
2608: ,p_record => l_rowtype_rec
2609: ,x_on_operation_action => l_on_operation_action
2610: );
2611:
2612: IF l_result = OE_PC_GLOBALS.YES THEN
2613: -- set OUT result to CONSTRAINED
2614: x_result := OE_PC_GLOBALS.YES;
2615: END IF;
2616:
2610: );
2611:
2612: IF l_result = OE_PC_GLOBALS.YES THEN
2613: -- set OUT result to CONSTRAINED
2614: x_result := OE_PC_GLOBALS.YES;
2615: END IF;
2616:
2617: END IF;
2618:
2624: ,p_record => l_rowtype_rec
2625: ,x_on_operation_action => l_on_operation_action
2626: );
2627:
2628: IF l_result = OE_PC_GLOBALS.YES THEN
2629: -- set OUT result to CONSTRAINED
2630: x_result := OE_PC_GLOBALS.YES;
2631: END IF;
2632:
2626: );
2627:
2628: IF l_result = OE_PC_GLOBALS.YES THEN
2629: -- set OUT result to CONSTRAINED
2630: x_result := OE_PC_GLOBALS.YES;
2631: END IF;
2632:
2633: END IF;
2634:
2640: ,p_record => l_rowtype_rec
2641: ,x_on_operation_action => l_on_operation_action
2642: );
2643:
2644: IF l_result = OE_PC_GLOBALS.YES THEN
2645: -- set OUT result to CONSTRAINED
2646: x_result := OE_PC_GLOBALS.YES;
2647: END IF;
2648:
2642: );
2643:
2644: IF l_result = OE_PC_GLOBALS.YES THEN
2645: -- set OUT result to CONSTRAINED
2646: x_result := OE_PC_GLOBALS.YES;
2647: END IF;
2648:
2649: END IF;
2650:
2656: ,p_record => l_rowtype_rec
2657: ,x_on_operation_action => l_on_operation_action
2658: );
2659:
2660: IF l_result = OE_PC_GLOBALS.YES THEN
2661: -- set OUT result to CONSTRAINED
2662: x_result := OE_PC_GLOBALS.YES;
2663: END IF;
2664:
2658: );
2659:
2660: IF l_result = OE_PC_GLOBALS.YES THEN
2661: -- set OUT result to CONSTRAINED
2662: x_result := OE_PC_GLOBALS.YES;
2663: END IF;
2664:
2665: END IF;
2666:
2672: ,p_record => l_rowtype_rec
2673: ,x_on_operation_action => l_on_operation_action
2674: );
2675:
2676: IF l_result = OE_PC_GLOBALS.YES THEN
2677: -- set OUT result to CONSTRAINED
2678: x_result := OE_PC_GLOBALS.YES;
2679: END IF;
2680:
2674: );
2675:
2676: IF l_result = OE_PC_GLOBALS.YES THEN
2677: -- set OUT result to CONSTRAINED
2678: x_result := OE_PC_GLOBALS.YES;
2679: END IF;
2680:
2681: END IF;
2682:
2688: ,p_record => l_rowtype_rec
2689: ,x_on_operation_action => l_on_operation_action
2690: );
2691:
2692: IF l_result = OE_PC_GLOBALS.YES THEN
2693: -- set OUT result to CONSTRAINED
2694: x_result := OE_PC_GLOBALS.YES;
2695: END IF;
2696:
2690: );
2691:
2692: IF l_result = OE_PC_GLOBALS.YES THEN
2693: -- set OUT result to CONSTRAINED
2694: x_result := OE_PC_GLOBALS.YES;
2695: END IF;
2696:
2697: END IF;
2698:
2704: ,p_record => l_rowtype_rec
2705: ,x_on_operation_action => l_on_operation_action
2706: );
2707:
2708: IF l_result = OE_PC_GLOBALS.YES THEN
2709: -- set OUT result to CONSTRAINED
2710: x_result := OE_PC_GLOBALS.YES;
2711: END IF;
2712:
2706: );
2707:
2708: IF l_result = OE_PC_GLOBALS.YES THEN
2709: -- set OUT result to CONSTRAINED
2710: x_result := OE_PC_GLOBALS.YES;
2711: END IF;
2712:
2713: END IF;
2714:
2720: ,p_record => l_rowtype_rec
2721: ,x_on_operation_action => l_on_operation_action
2722: );
2723:
2724: IF l_result = OE_PC_GLOBALS.YES THEN
2725: -- set OUT result to CONSTRAINED
2726: x_result := OE_PC_GLOBALS.YES;
2727: END IF;
2728:
2722: );
2723:
2724: IF l_result = OE_PC_GLOBALS.YES THEN
2725: -- set OUT result to CONSTRAINED
2726: x_result := OE_PC_GLOBALS.YES;
2727: END IF;
2728:
2729: END IF;
2730:
2736: ,p_record => l_rowtype_rec
2737: ,x_on_operation_action => l_on_operation_action
2738: );
2739:
2740: IF l_result = OE_PC_GLOBALS.YES THEN
2741: -- set OUT result to CONSTRAINED
2742: x_result := OE_PC_GLOBALS.YES;
2743: END IF;
2744:
2738: );
2739:
2740: IF l_result = OE_PC_GLOBALS.YES THEN
2741: -- set OUT result to CONSTRAINED
2742: x_result := OE_PC_GLOBALS.YES;
2743: END IF;
2744:
2745: END IF;
2746:
2752: ,p_record => l_rowtype_rec
2753: ,x_on_operation_action => l_on_operation_action
2754: );
2755:
2756: IF l_result = OE_PC_GLOBALS.YES THEN
2757: -- set OUT result to CONSTRAINED
2758: x_result := OE_PC_GLOBALS.YES;
2759: END IF;
2760:
2754: );
2755:
2756: IF l_result = OE_PC_GLOBALS.YES THEN
2757: -- set OUT result to CONSTRAINED
2758: x_result := OE_PC_GLOBALS.YES;
2759: END IF;
2760:
2761: END IF;
2762:
2768: ,p_record => l_rowtype_rec
2769: ,x_on_operation_action => l_on_operation_action
2770: );
2771:
2772: IF l_result = OE_PC_GLOBALS.YES THEN
2773: -- set OUT result to CONSTRAINED
2774: x_result := OE_PC_GLOBALS.YES;
2775: END IF;
2776:
2770: );
2771:
2772: IF l_result = OE_PC_GLOBALS.YES THEN
2773: -- set OUT result to CONSTRAINED
2774: x_result := OE_PC_GLOBALS.YES;
2775: END IF;
2776:
2777: END IF;
2778:
2784: ,p_record => l_rowtype_rec
2785: ,x_on_operation_action => l_on_operation_action
2786: );
2787:
2788: IF l_result = OE_PC_GLOBALS.YES THEN
2789: -- set OUT result to CONSTRAINED
2790: x_result := OE_PC_GLOBALS.YES;
2791: END IF;
2792:
2786: );
2787:
2788: IF l_result = OE_PC_GLOBALS.YES THEN
2789: -- set OUT result to CONSTRAINED
2790: x_result := OE_PC_GLOBALS.YES;
2791: END IF;
2792:
2793: END IF;
2794:
2800: ,p_record => l_rowtype_rec
2801: ,x_on_operation_action => l_on_operation_action
2802: );
2803:
2804: IF l_result = OE_PC_GLOBALS.YES THEN
2805: -- set OUT result to CONSTRAINED
2806: x_result := OE_PC_GLOBALS.YES;
2807: END IF;
2808:
2802: );
2803:
2804: IF l_result = OE_PC_GLOBALS.YES THEN
2805: -- set OUT result to CONSTRAINED
2806: x_result := OE_PC_GLOBALS.YES;
2807: END IF;
2808:
2809: END IF;
2810:
2816: ,p_record => l_rowtype_rec
2817: ,x_on_operation_action => l_on_operation_action
2818: );
2819:
2820: IF l_result = OE_PC_GLOBALS.YES THEN
2821: -- set OUT result to CONSTRAINED
2822: x_result := OE_PC_GLOBALS.YES;
2823: END IF;
2824:
2818: );
2819:
2820: IF l_result = OE_PC_GLOBALS.YES THEN
2821: -- set OUT result to CONSTRAINED
2822: x_result := OE_PC_GLOBALS.YES;
2823: END IF;
2824:
2825: END IF;
2826:
2832: ,p_record => l_rowtype_rec
2833: ,x_on_operation_action => l_on_operation_action
2834: );
2835:
2836: IF l_result = OE_PC_GLOBALS.YES THEN
2837: -- set OUT result to CONSTRAINED
2838: x_result := OE_PC_GLOBALS.YES;
2839: END IF;
2840:
2834: );
2835:
2836: IF l_result = OE_PC_GLOBALS.YES THEN
2837: -- set OUT result to CONSTRAINED
2838: x_result := OE_PC_GLOBALS.YES;
2839: END IF;
2840:
2841: END IF;
2842:
2848: ,p_record => l_rowtype_rec
2849: ,x_on_operation_action => l_on_operation_action
2850: );
2851:
2852: IF l_result = OE_PC_GLOBALS.YES THEN
2853: -- set OUT result to CONSTRAINED
2854: x_result := OE_PC_GLOBALS.YES;
2855: END IF;
2856:
2850: );
2851:
2852: IF l_result = OE_PC_GLOBALS.YES THEN
2853: -- set OUT result to CONSTRAINED
2854: x_result := OE_PC_GLOBALS.YES;
2855: END IF;
2856:
2857: END IF;
2858:
2864: ,p_record => l_rowtype_rec
2865: ,x_on_operation_action => l_on_operation_action
2866: );
2867:
2868: IF l_result = OE_PC_GLOBALS.YES THEN
2869: -- set OUT result to CONSTRAINED
2870: x_result := OE_PC_GLOBALS.YES;
2871: END IF;
2872:
2866: );
2867:
2868: IF l_result = OE_PC_GLOBALS.YES THEN
2869: -- set OUT result to CONSTRAINED
2870: x_result := OE_PC_GLOBALS.YES;
2871: END IF;
2872:
2873: END IF;
2874:
2880: ,p_record => l_rowtype_rec
2881: ,x_on_operation_action => l_on_operation_action
2882: );
2883:
2884: IF l_result = OE_PC_GLOBALS.YES THEN
2885: -- set OUT result to CONSTRAINED
2886: x_result := OE_PC_GLOBALS.YES;
2887: END IF;
2888:
2882: );
2883:
2884: IF l_result = OE_PC_GLOBALS.YES THEN
2885: -- set OUT result to CONSTRAINED
2886: x_result := OE_PC_GLOBALS.YES;
2887: END IF;
2888:
2889: END IF;
2890:
2896: ,p_record => l_rowtype_rec
2897: ,x_on_operation_action => l_on_operation_action
2898: );
2899:
2900: IF l_result = OE_PC_GLOBALS.YES THEN
2901: -- set OUT result to CONSTRAINED
2902: x_result := OE_PC_GLOBALS.YES;
2903: END IF;
2904:
2898: );
2899:
2900: IF l_result = OE_PC_GLOBALS.YES THEN
2901: -- set OUT result to CONSTRAINED
2902: x_result := OE_PC_GLOBALS.YES;
2903: END IF;
2904:
2905: END IF;
2906:
2912: ,p_record => l_rowtype_rec
2913: ,x_on_operation_action => l_on_operation_action
2914: );
2915:
2916: IF l_result = OE_PC_GLOBALS.YES THEN
2917: -- set OUT result to CONSTRAINED
2918: x_result := OE_PC_GLOBALS.YES;
2919: END IF;
2920:
2914: );
2915:
2916: IF l_result = OE_PC_GLOBALS.YES THEN
2917: -- set OUT result to CONSTRAINED
2918: x_result := OE_PC_GLOBALS.YES;
2919: END IF;
2920:
2921: END IF;
2922:
2928: ,p_record => l_rowtype_rec
2929: ,x_on_operation_action => l_on_operation_action
2930: );
2931:
2932: IF l_result = OE_PC_GLOBALS.YES THEN
2933: -- set OUT result to CONSTRAINED
2934: x_result := OE_PC_GLOBALS.YES;
2935: END IF;
2936:
2930: );
2931:
2932: IF l_result = OE_PC_GLOBALS.YES THEN
2933: -- set OUT result to CONSTRAINED
2934: x_result := OE_PC_GLOBALS.YES;
2935: END IF;
2936:
2937: END IF;
2938:
2944: ,p_record => l_rowtype_rec
2945: ,x_on_operation_action => l_on_operation_action
2946: );
2947:
2948: IF l_result = OE_PC_GLOBALS.YES THEN
2949: -- set OUT result to CONSTRAINED
2950: x_result := OE_PC_GLOBALS.YES;
2951: END IF;
2952:
2946: );
2947:
2948: IF l_result = OE_PC_GLOBALS.YES THEN
2949: -- set OUT result to CONSTRAINED
2950: x_result := OE_PC_GLOBALS.YES;
2951: END IF;
2952:
2953: END IF;
2954:
2960: ,p_record => l_rowtype_rec
2961: ,x_on_operation_action => l_on_operation_action
2962: );
2963:
2964: IF l_result = OE_PC_GLOBALS.YES THEN
2965: -- set OUT result to CONSTRAINED
2966: x_result := OE_PC_GLOBALS.YES;
2967: END IF;
2968:
2962: );
2963:
2964: IF l_result = OE_PC_GLOBALS.YES THEN
2965: -- set OUT result to CONSTRAINED
2966: x_result := OE_PC_GLOBALS.YES;
2967: END IF;
2968:
2969: END IF;
2970:
2976: ,p_record => l_rowtype_rec
2977: ,x_on_operation_action => l_on_operation_action
2978: );
2979:
2980: IF l_result = OE_PC_GLOBALS.YES THEN
2981: -- set OUT result to CONSTRAINED
2982: x_result := OE_PC_GLOBALS.YES;
2983: END IF;
2984:
2978: );
2979:
2980: IF l_result = OE_PC_GLOBALS.YES THEN
2981: -- set OUT result to CONSTRAINED
2982: x_result := OE_PC_GLOBALS.YES;
2983: END IF;
2984:
2985: END IF;
2986:
2992: ,p_record => l_rowtype_rec
2993: ,x_on_operation_action => l_on_operation_action
2994: );
2995:
2996: IF l_result = OE_PC_GLOBALS.YES THEN
2997: -- set OUT result to CONSTRAINED
2998: x_result := OE_PC_GLOBALS.YES;
2999: END IF;
3000:
2994: );
2995:
2996: IF l_result = OE_PC_GLOBALS.YES THEN
2997: -- set OUT result to CONSTRAINED
2998: x_result := OE_PC_GLOBALS.YES;
2999: END IF;
3000:
3001: END IF;
3002:
3008: ,p_record => l_rowtype_rec
3009: ,x_on_operation_action => l_on_operation_action
3010: );
3011:
3012: IF l_result = OE_PC_GLOBALS.YES THEN
3013: -- set OUT result to CONSTRAINED
3014: x_result := OE_PC_GLOBALS.YES;
3015: END IF;
3016:
3010: );
3011:
3012: IF l_result = OE_PC_GLOBALS.YES THEN
3013: -- set OUT result to CONSTRAINED
3014: x_result := OE_PC_GLOBALS.YES;
3015: END IF;
3016:
3017: END IF;
3018:
3024: (p_operation => l_operation
3025: ,p_record => l_rowtype_rec
3026: ,x_on_operation_action => l_on_operation_action
3027: );
3028: IF l_result = OE_PC_GLOBALS.YES THEN
3029: -- set OUT result to CONSTRAINED
3030: x_result := OE_PC_GLOBALS.YES;
3031: END IF;
3032:
3026: ,x_on_operation_action => l_on_operation_action
3027: );
3028: IF l_result = OE_PC_GLOBALS.YES THEN
3029: -- set OUT result to CONSTRAINED
3030: x_result := OE_PC_GLOBALS.YES;
3031: END IF;
3032:
3033: END IF;
3034:
3039: (p_operation => l_operation
3040: ,p_record => l_rowtype_rec
3041: ,x_on_operation_action => l_on_operation_action
3042: );
3043: IF l_result = OE_PC_GLOBALS.YES THEN
3044: -- set OUT result to CONSTRAINED
3045: x_result := OE_PC_GLOBALS.YES;
3046: END IF;
3047:
3041: ,x_on_operation_action => l_on_operation_action
3042: );
3043: IF l_result = OE_PC_GLOBALS.YES THEN
3044: -- set OUT result to CONSTRAINED
3045: x_result := OE_PC_GLOBALS.YES;
3046: END IF;
3047:
3048: END IF;
3049:
3053: (p_operation => l_operation
3054: ,p_record => l_rowtype_rec
3055: ,x_on_operation_action => l_on_operation_action
3056: );
3057: IF l_result = OE_PC_GLOBALS.YES THEN
3058: -- set OUT result to CONSTRAINED
3059: x_result := OE_PC_GLOBALS.YES;
3060: END IF;
3061:
3055: ,x_on_operation_action => l_on_operation_action
3056: );
3057: IF l_result = OE_PC_GLOBALS.YES THEN
3058: -- set OUT result to CONSTRAINED
3059: x_result := OE_PC_GLOBALS.YES;
3060: END IF;
3061:
3062: END IF;
3063:
3067: (p_operation => l_operation
3068: ,p_record => l_rowtype_rec
3069: ,x_on_operation_action => l_on_operation_action
3070: );
3071: IF l_result = OE_PC_GLOBALS.YES THEN
3072: -- set OUT result to CONSTRAINED
3073: x_result := OE_PC_GLOBALS.YES;
3074: END IF;
3075:
3069: ,x_on_operation_action => l_on_operation_action
3070: );
3071: IF l_result = OE_PC_GLOBALS.YES THEN
3072: -- set OUT result to CONSTRAINED
3073: x_result := OE_PC_GLOBALS.YES;
3074: END IF;
3075:
3076: END IF;
3077:
3081: (p_operation => l_operation
3082: ,p_record => l_rowtype_rec
3083: ,x_on_operation_action => l_on_operation_action
3084: );
3085: IF l_result = OE_PC_GLOBALS.YES THEN
3086: -- set OUT result to CONSTRAINED
3087: x_result := OE_PC_GLOBALS.YES;
3088: END IF;
3089:
3083: ,x_on_operation_action => l_on_operation_action
3084: );
3085: IF l_result = OE_PC_GLOBALS.YES THEN
3086: -- set OUT result to CONSTRAINED
3087: x_result := OE_PC_GLOBALS.YES;
3088: END IF;
3089:
3090: END IF;
3091:
3095: (p_operation => l_operation
3096: ,p_record => l_rowtype_rec
3097: ,x_on_operation_action => l_on_operation_action
3098: );
3099: IF l_result = OE_PC_GLOBALS.YES THEN
3100: -- set OUT result to CONSTRAINED
3101: x_result := OE_PC_GLOBALS.YES;
3102: END IF;
3103:
3097: ,x_on_operation_action => l_on_operation_action
3098: );
3099: IF l_result = OE_PC_GLOBALS.YES THEN
3100: -- set OUT result to CONSTRAINED
3101: x_result := OE_PC_GLOBALS.YES;
3102: END IF;
3103:
3104: END IF;
3105:
3109: (p_operation => l_operation
3110: ,p_record => l_rowtype_rec
3111: ,x_on_operation_action => l_on_operation_action
3112: );
3113: IF l_result = OE_PC_GLOBALS.YES THEN
3114: -- set OUT result to CONSTRAINED
3115: x_result := OE_PC_GLOBALS.YES;
3116: END IF;
3117:
3111: ,x_on_operation_action => l_on_operation_action
3112: );
3113: IF l_result = OE_PC_GLOBALS.YES THEN
3114: -- set OUT result to CONSTRAINED
3115: x_result := OE_PC_GLOBALS.YES;
3116: END IF;
3117:
3118: END IF;
3119:
3123: (p_operation => l_operation
3124: ,p_record => l_rowtype_rec
3125: ,x_on_operation_action => l_on_operation_action
3126: );
3127: IF l_result = OE_PC_GLOBALS.YES THEN
3128: -- set OUT result to CONSTRAINED
3129: x_result := OE_PC_GLOBALS.YES;
3130: END IF;
3131:
3125: ,x_on_operation_action => l_on_operation_action
3126: );
3127: IF l_result = OE_PC_GLOBALS.YES THEN
3128: -- set OUT result to CONSTRAINED
3129: x_result := OE_PC_GLOBALS.YES;
3130: END IF;
3131:
3132: END IF;
3133:
3137: (p_operation => l_operation
3138: ,p_record => l_rowtype_rec
3139: ,x_on_operation_action => l_on_operation_action
3140: );
3141: IF l_result = OE_PC_GLOBALS.YES THEN
3142: -- set OUT result to CONSTRAINED
3143: x_result := OE_PC_GLOBALS.YES;
3144: END IF;
3145:
3139: ,x_on_operation_action => l_on_operation_action
3140: );
3141: IF l_result = OE_PC_GLOBALS.YES THEN
3142: -- set OUT result to CONSTRAINED
3143: x_result := OE_PC_GLOBALS.YES;
3144: END IF;
3145:
3146: END IF;
3147:
3151: (p_operation => l_operation
3152: ,p_record => l_rowtype_rec
3153: ,x_on_operation_action => l_on_operation_action
3154: );
3155: IF l_result = OE_PC_GLOBALS.YES THEN
3156: -- set OUT result to CONSTRAINED
3157: x_result := OE_PC_GLOBALS.YES;
3158: END IF;
3159:
3153: ,x_on_operation_action => l_on_operation_action
3154: );
3155: IF l_result = OE_PC_GLOBALS.YES THEN
3156: -- set OUT result to CONSTRAINED
3157: x_result := OE_PC_GLOBALS.YES;
3158: END IF;
3159:
3160: END IF;
3161:
3165: (p_operation => l_operation
3166: ,p_record => l_rowtype_rec
3167: ,x_on_operation_action => l_on_operation_action
3168: );
3169: IF l_result = OE_PC_GLOBALS.YES THEN
3170: -- set OUT result to CONSTRAINED
3171: x_result := OE_PC_GLOBALS.YES;
3172: END IF;
3173:
3167: ,x_on_operation_action => l_on_operation_action
3168: );
3169: IF l_result = OE_PC_GLOBALS.YES THEN
3170: -- set OUT result to CONSTRAINED
3171: x_result := OE_PC_GLOBALS.YES;
3172: END IF;
3173:
3174: END IF;
3175:
3179: (p_operation => l_operation
3180: ,p_record => l_rowtype_rec
3181: ,x_on_operation_action => l_on_operation_action
3182: );
3183: IF l_result = OE_PC_GLOBALS.YES THEN
3184: -- set OUT result to CONSTRAINED
3185: x_result := OE_PC_GLOBALS.YES;
3186: END IF;
3187:
3181: ,x_on_operation_action => l_on_operation_action
3182: );
3183: IF l_result = OE_PC_GLOBALS.YES THEN
3184: -- set OUT result to CONSTRAINED
3185: x_result := OE_PC_GLOBALS.YES;
3186: END IF;
3187:
3188: END IF;
3189:
3193: (p_operation => l_operation
3194: ,p_record => l_rowtype_rec
3195: ,x_on_operation_action => l_on_operation_action
3196: );
3197: IF l_result = OE_PC_GLOBALS.YES THEN
3198: -- set OUT result to CONSTRAINED
3199: x_result := OE_PC_GLOBALS.YES;
3200: END IF;
3201:
3195: ,x_on_operation_action => l_on_operation_action
3196: );
3197: IF l_result = OE_PC_GLOBALS.YES THEN
3198: -- set OUT result to CONSTRAINED
3199: x_result := OE_PC_GLOBALS.YES;
3200: END IF;
3201:
3202: END IF;
3203:
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:
3221: (p_operation => l_operation
3222: ,p_record => l_rowtype_rec
3223: ,x_on_operation_action => l_on_operation_action
3224: );
3225: IF l_result = OE_PC_GLOBALS.YES THEN
3226: -- set OUT result to CONSTRAINED
3227: x_result := OE_PC_GLOBALS.YES;
3228: END IF;
3229:
3223: ,x_on_operation_action => l_on_operation_action
3224: );
3225: IF l_result = OE_PC_GLOBALS.YES THEN
3226: -- set OUT result to CONSTRAINED
3227: x_result := OE_PC_GLOBALS.YES;
3228: END IF;
3229:
3230: END IF;
3231:
3235: (p_operation => l_operation
3236: ,p_record => l_rowtype_rec
3237: ,x_on_operation_action => l_on_operation_action
3238: );
3239: IF l_result = OE_PC_GLOBALS.YES THEN
3240: -- set OUT result to CONSTRAINED
3241: x_result := OE_PC_GLOBALS.YES;
3242: END IF;
3243:
3237: ,x_on_operation_action => l_on_operation_action
3238: );
3239: IF l_result = OE_PC_GLOBALS.YES THEN
3240: -- set OUT result to CONSTRAINED
3241: x_result := OE_PC_GLOBALS.YES;
3242: END IF;
3243:
3244: END IF;
3245:
3249: (p_operation => l_operation
3250: ,p_record => l_rowtype_rec
3251: ,x_on_operation_action => l_on_operation_action
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:
3251: ,x_on_operation_action => l_on_operation_action
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:
3263: (p_operation => l_operation
3264: ,p_record => l_rowtype_rec
3265: ,x_on_operation_action => l_on_operation_action
3266: );
3267: IF l_result = OE_PC_GLOBALS.YES THEN
3268: -- set OUT result to CONSTRAINED
3269: x_result := OE_PC_GLOBALS.YES;
3270: END IF;
3271:
3265: ,x_on_operation_action => l_on_operation_action
3266: );
3267: IF l_result = OE_PC_GLOBALS.YES THEN
3268: -- set OUT result to CONSTRAINED
3269: x_result := OE_PC_GLOBALS.YES;
3270: END IF;
3271:
3272: END IF;
3273:
3277: (p_operation => l_operation
3278: ,p_record => l_rowtype_rec
3279: ,x_on_operation_action => l_on_operation_action
3280: );
3281: IF l_result = OE_PC_GLOBALS.YES THEN
3282: -- set OUT result to CONSTRAINED
3283: x_result := OE_PC_GLOBALS.YES;
3284: END IF;
3285:
3279: ,x_on_operation_action => l_on_operation_action
3280: );
3281: IF l_result = OE_PC_GLOBALS.YES THEN
3282: -- set OUT result to CONSTRAINED
3283: x_result := OE_PC_GLOBALS.YES;
3284: END IF;
3285:
3286: END IF;
3287:
3291: (p_operation => l_operation
3292: ,p_record => l_rowtype_rec
3293: ,x_on_operation_action => l_on_operation_action
3294: );
3295: IF l_result = OE_PC_GLOBALS.YES THEN
3296: -- set OUT result to CONSTRAINED
3297: x_result := OE_PC_GLOBALS.YES;
3298: END IF;
3299:
3293: ,x_on_operation_action => l_on_operation_action
3294: );
3295: IF l_result = OE_PC_GLOBALS.YES THEN
3296: -- set OUT result to CONSTRAINED
3297: x_result := OE_PC_GLOBALS.YES;
3298: END IF;
3299:
3300: END IF;
3301:
3305: (p_operation => l_operation
3306: ,p_record => l_rowtype_rec
3307: ,x_on_operation_action => l_on_operation_action
3308: );
3309: IF l_result = OE_PC_GLOBALS.YES THEN
3310: -- set OUT result to CONSTRAINED
3311: x_result := OE_PC_GLOBALS.YES;
3312: END IF;
3313:
3307: ,x_on_operation_action => l_on_operation_action
3308: );
3309: IF l_result = OE_PC_GLOBALS.YES THEN
3310: -- set OUT result to CONSTRAINED
3311: x_result := OE_PC_GLOBALS.YES;
3312: END IF;
3313:
3314: END IF;
3315: