eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_SECURITY dependencies on OE_PC_GLOBALS

Line 55: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE

51: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
52: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
53: , p_operation => p_operation
54: , p_qualifier_attribute => p_record.transaction_phase_code
55: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE
56: , p_column_name => p_column_name
57: , p_check_all_cols_constraint => g_check_all_cols_constraint
58: , p_is_caller_defaulting => g_is_caller_defaulting
59: , p_use_cached_results => 'Y'

Line 65: if l_result = OE_PC_GLOBALS.YES then

61: , x_constraining_conditions_grp => l_grp
62: , x_on_operation_action => x_on_operation_action
63: );
64:
65: if l_result = OE_PC_GLOBALS.YES then
66:
67: IF g_check_all_cols_constraint = 'Y'
68: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
69: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

Line 68: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP

64:
65: if l_result = OE_PC_GLOBALS.YES then
66:
67: IF g_check_all_cols_constraint = 'Y'
68: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
69: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
70: AND x_on_operation_action = 0
71: AND p_column_name IS NOT NULL THEN
72: SELECT column_name

Line 69: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

65: if l_result = OE_PC_GLOBALS.YES then
66:
67: IF g_check_all_cols_constraint = 'Y'
68: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
69: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
70: AND x_on_operation_action = 0
71: AND p_column_name IS NOT NULL THEN
72: SELECT column_name
73: INTO l_column_name

Line 84: elsif l_result = OE_PC_GLOBALS.ERROR then

80: RAISE FND_API.G_EXC_ERROR;
81: end if;
82: END IF;
83:
84: elsif l_result = OE_PC_GLOBALS.ERROR then
85:
86: raise FND_API.G_EXC_UNEXPECTED_ERROR;
87:
88: end if;

Line 96: IF l_result = OE_PC_GLOBALS.YES THEN

92: IF l_debug_level > 0 THEN
93: OE_DEBUG_PUB.add('Action performed code : '||x_on_operation_action,1);
94: END IF;
95:
96: IF l_result = OE_PC_GLOBALS.YES THEN
97: IF x_on_operation_action IN (.05,.1,.2,.5,1) THEN
98: IF p_column_name = 'ORDERED_QUANTITY'
99: -- QUOTING change - set cancellation require reason flag only
100: -- for lines in fulfillment phase

Line 124: l_result = OE_PC_GLOBALS.YES And

120:
121: --Start Integration Framework Code
122:
123: If l_code_level >= '110510' And
124: l_result = OE_PC_GLOBALS.YES And
125: x_on_operation_action = 3 And
126: nvl(p_record.transaction_phase_code,'F') = 'F'
127: Then
128: If p_record.order_source_id = 20 Then

Line 190: l_result = OE_PC_GLOBALS.YES And

186:
187: End If;
188:
189: If l_code_level >= '110510' And
190: l_result = OE_PC_GLOBALS.YES And
191: x_on_operation_action = 0.05 And
192: nvl(p_record.transaction_phase_code,'F') = 'F'
193: Then
194: OE_Versioning_Util.Check_Security

Line 259: l_result = OE_PC_GLOBALS.YES And

255:
256: End If;
257:
258: If l_code_level >= '110510' And
259: l_result = OE_PC_GLOBALS.YES And
260: x_on_operation_action = 0.5 And
261: nvl(p_record.transaction_phase_code,'F') = 'F'
262: Then
263:

Line 386: IF l_result = OE_PC_GLOBALS.YES THEN

382: IF l_debug_level > 0 THEN
383: OE_DEBUG_PUB.add('Audit Trail enabled for booked orders only ...',5);
384: END IF;
385: IF p_record.booked_flag = 'Y' THEN
386: IF l_result = OE_PC_GLOBALS.YES THEN
387: l_history_captured := FALSE;
388: IF x_on_operation_action = 1 THEN
389: BEGIN
390: FOR l_ind in 1..l_ctr LOOP

Line 442: IF l_result = OE_PC_GLOBALS.YES THEN

438: END IF;
439: END IF;
440: END IF;
441: ELSE -- capture audit for all orders
442: IF l_result = OE_PC_GLOBALS.YES THEN
443: l_history_captured := FALSE;
444: IF x_on_operation_action = 1 THEN
445: BEGIN
446: FOR l_ind in 1..l_ctr LOOP

Line 507: l_result := OE_PC_GLOBALS.NO;

503: IF g_operation_action is null THEN
504: g_operation_action := x_on_operation_action;
505: END IF;
506: IF x_on_operation_action > 0 THEN
507: l_result := OE_PC_GLOBALS.NO;
508: END IF;
509:
510: /* End AuditTrail */
511: RETURN l_result;

Line 518: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

514:
515: -- PUBLIC PROCEDURES
516:
517: FUNCTION ACCOUNTING_RULE
518: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
519: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
520: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
521: ) RETURN NUMBER
522: IS

Line 538: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

534:
535: END ACCOUNTING_RULE;
536:
537: FUNCTION ACCOUNTING_RULE_DURATION
538: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
539: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
540: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
541: ) RETURN NUMBER
542: IS

Line 557: FUNCTION calculate_price_flag(p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

553: RETURN(l_result);
554:
555: END ACCOUNTING_RULE_DURATION;
556:
557: FUNCTION calculate_price_flag(p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
558: ,p_record IN oe_ak_order_lines_v%ROWTYPE
559: ,x_on_operation_action OUT NOCOPY NUMBER)
560: RETURN NUMBER IS
561: l_result NUMBER := 0;

Line 575: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

571:
572: ---bug#4399426
573:
574: FUNCTION COMMITMENT_ID
575: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
576: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
577: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
578: ) RETURN NUMBER
579: IS

Line 594: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

590:
591: END COMMITMENT_ID;
592:
593: FUNCTION AGREEMENT
594: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
595: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
596: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
597: ) RETURN NUMBER
598: IS

Line 614: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

610:
611: END AGREEMENT;
612:
613: FUNCTION AUTHORIZED_TO_SHIP
614: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
615: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
616: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
617: ) RETURN NUMBER
618: IS

Line 636: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

632:
633: -- Start of fix #1459428 for function definition
634:
635: FUNCTION ATTRIBUTE1
636: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
637: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
638: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
639: ) RETURN NUMBER
640: IS

Line 657: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

653: END ATTRIBUTE1;
654:
655:
656: FUNCTION ATTRIBUTE10
657: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
658: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
659: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
660: ) RETURN NUMBER
661: IS

Line 677: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

673:
674: END ATTRIBUTE10;
675:
676: FUNCTION ATTRIBUTE11
677: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
678: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
679: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
680: ) RETURN NUMBER
681: IS

Line 697: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

693:
694: END ATTRIBUTE11;
695:
696: FUNCTION ATTRIBUTE12
697: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
698: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
699: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
700: ) RETURN NUMBER
701: IS

Line 717: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

713:
714: END ATTRIBUTE12;
715:
716: FUNCTION ATTRIBUTE13
717: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
718: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
719: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
720: ) RETURN NUMBER
721: IS

Line 737: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

733:
734: END ATTRIBUTE13;
735:
736: FUNCTION ATTRIBUTE14
737: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
738: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
739: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
740: ) RETURN NUMBER
741: IS

Line 758: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

754: END ATTRIBUTE14;
755:
756:
757: FUNCTION ATTRIBUTE15
758: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
759: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
760: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
761: ) RETURN NUMBER
762: IS

Line 779: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

775: END ATTRIBUTE15;
776:
777: -- For Bug 2184255
778: FUNCTION ATTRIBUTE16
779: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
780: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
781: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
782: ) RETURN NUMBER
783: IS

Line 799: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

795:
796: END ATTRIBUTE16;
797:
798: FUNCTION ATTRIBUTE17
799: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
800: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
801: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
802: ) RETURN NUMBER
803: IS

Line 819: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

815:
816: END ATTRIBUTE17;
817:
818: FUNCTION ATTRIBUTE18
819: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
820: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
821: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
822: ) RETURN NUMBER
823: IS

Line 839: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

835:
836: END ATTRIBUTE18;
837:
838: FUNCTION ATTRIBUTE19
839: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
840: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
841: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
842: ) RETURN NUMBER
843: IS

Line 859: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

855:
856: END ATTRIBUTE19;
857:
858: FUNCTION ATTRIBUTE2
859: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
860: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
861: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
862: ) RETURN NUMBER
863: IS

Line 879: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

875:
876: END ATTRIBUTE2;
877:
878: FUNCTION ATTRIBUTE20
879: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
880: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
881: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
882: ) RETURN NUMBER
883: IS

Line 899: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

895:
896: END ATTRIBUTE20;
897:
898: FUNCTION ATTRIBUTE3
899: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
900: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
901: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
902: ) RETURN NUMBER
903: IS

Line 919: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

915:
916: END ATTRIBUTE3;
917:
918: FUNCTION ATTRIBUTE4
919: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
920: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
921: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
922: ) RETURN NUMBER
923: IS

Line 939: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

935:
936: END ATTRIBUTE4;
937:
938: FUNCTION ATTRIBUTE5
939: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
940: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
941: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
942: ) RETURN NUMBER
943: IS

Line 959: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

955:
956: END ATTRIBUTE5;
957:
958: FUNCTION ATTRIBUTE6
959: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
960: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
961: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
962: ) RETURN NUMBER
963: IS

Line 979: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

975:
976: END ATTRIBUTE6;
977:
978: FUNCTION ATTRIBUTE7
979: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
980: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
981: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
982: ) RETURN NUMBER
983: IS

Line 999: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

995:
996: END ATTRIBUTE7;
997:
998: FUNCTION ATTRIBUTE8
999: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1000: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1001: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1002: ) RETURN NUMBER
1003: IS

Line 1019: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1015:
1016: END ATTRIBUTE8;
1017:
1018: FUNCTION ATTRIBUTE9
1019: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1020: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1021: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1022: ) RETURN NUMBER
1023: IS

Line 1039: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1035:
1036: END ATTRIBUTE9;
1037:
1038: FUNCTION CONTEXT
1039: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1040: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1041: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1042: ) RETURN NUMBER
1043: IS

Line 1061: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1057:
1058: -- End of fix #1459428 for function definition
1059:
1060: FUNCTION CREATED_BY
1061: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1062: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1063: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1064: ) RETURN NUMBER
1065: IS

Line 1082: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1078: END CREATED_BY;
1079:
1080:
1081: FUNCTION CREDIT_INVOICE_LINE
1082: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1083: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1084: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1085: ) RETURN NUMBER
1086: IS

Line 1103: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1099: END CREDIT_INVOICE_LINE;
1100:
1101:
1102: FUNCTION CUSTOMER_LINE_NUMBER
1103: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1104: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1105: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1106: ) RETURN NUMBER
1107: IS

Line 1124: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1120: END CUSTOMER_LINE_NUMBER;
1121:
1122:
1123: FUNCTION CUSTOMER_TRX_LINE
1124: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1125: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1126: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1127: ) RETURN NUMBER
1128: IS

Line 1145: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1141: END CUSTOMER_TRX_LINE;
1142:
1143:
1144: FUNCTION CUST_PO_NUMBER
1145: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1146: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1147: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1148: ) RETURN NUMBER
1149: IS

Line 1166: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1162: END CUST_PO_NUMBER;
1163:
1164:
1165: FUNCTION DELIVERY_LEAD_TIME
1166: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1167: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1168: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1169: ) RETURN NUMBER
1170: IS

Line 1187: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1183: END DELIVERY_LEAD_TIME;
1184:
1185:
1186: FUNCTION DELIVER_TO_CONTACT
1187: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1188: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1189: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1190: ) RETURN NUMBER
1191: IS

Line 1208: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1204: END DELIVER_TO_CONTACT;
1205:
1206:
1207: FUNCTION DELIVER_TO_ORG
1208: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1209: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1210: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1211: ) RETURN NUMBER
1212: IS

Line 1229: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1225: END DELIVER_TO_ORG;
1226:
1227:
1228: FUNCTION DEMAND_CLASS
1229: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1230: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1231: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1232: ) RETURN NUMBER
1233: IS

Line 1250: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1246: END DEMAND_CLASS;
1247:
1248:
1249: FUNCTION DEP_PLAN_REQUIRED
1250: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1251: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1252: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1253: ) RETURN NUMBER
1254: IS

Line 1271: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1267: END DEP_PLAN_REQUIRED;
1268:
1269:
1270: FUNCTION EARLIEST_ACCEPTABLE_DATE
1271: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1272: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1273: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1274: ) RETURN NUMBER
1275: IS

Line 1291: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1287:
1288: END EARLIEST_ACCEPTABLE_DATE;
1289:
1290: FUNCTION END_ITEM_UNIT_NUMBER
1291: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1292: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1293: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1294: ) RETURN NUMBER
1295: IS

Line 1312: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1308: END END_ITEM_UNIT_NUMBER;
1309:
1310:
1311: FUNCTION FOB_POINT
1312: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1313: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1314: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1315: ) RETURN NUMBER
1316: IS

Line 1333: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1329: END FOB_POINT;
1330:
1331:
1332: FUNCTION FREIGHT_CARRIER
1333: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1334: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1335: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1336: ) RETURN NUMBER
1337: IS

Line 1354: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1350: END FREIGHT_CARRIER;
1351:
1352:
1353: FUNCTION FREIGHT_TERMS
1354: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1355: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1356: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1357: ) RETURN NUMBER
1358: IS

Line 1375: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1371: END FREIGHT_TERMS;
1372:
1373:
1374: FUNCTION FULFILLED_QUANTITY
1375: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1376: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1377: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1378: ) RETURN NUMBER
1379: IS

Line 1397: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1393:
1394: -- INVCONV
1395:
1396: FUNCTION FULFILLED_QUANTITY2
1397: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1398: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1399: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1400: ) RETURN NUMBER
1401: IS

Line 1418: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1414: END FULFILLED_QUANTITY2;
1415:
1416:
1417: FUNCTION INVENTORY_ITEM
1418: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1419: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1420: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1421: ) RETURN NUMBER
1422: IS

Line 1438: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1434:
1435: END INVENTORY_ITEM;
1436:
1437: FUNCTION INVOICE_TO_CONTACT
1438: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1439: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1440: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1441: ) RETURN NUMBER
1442: IS

Line 1459: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1455: END INVOICE_TO_CONTACT;
1456:
1457:
1458: FUNCTION INVOICE_TO_ORG
1459: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1460: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1461: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1462: ) RETURN NUMBER
1463: IS

Line 1479: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1475:
1476: END INVOICE_TO_ORG;
1477:
1478: FUNCTION INVOICING_RULE
1479: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1480: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1481: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1482: ) RETURN NUMBER
1483: IS

Line 1499: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1495:
1496: END INVOICING_RULE;
1497:
1498: FUNCTION ITEM_REVISION
1499: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1500: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1501: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1502: ) RETURN NUMBER
1503: IS

Line 1520: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1516: END ITEM_REVISION;
1517:
1518:
1519: FUNCTION ITEM_TYPE
1520: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1521: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1522: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1523: ) RETURN NUMBER
1524: IS

Line 1541: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1537: END ITEM_TYPE;
1538:
1539:
1540: FUNCTION LATEST_ACCEPTABLE_DATE
1541: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1542: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1543: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1544: ) RETURN NUMBER
1545: IS

Line 1562: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1558: END LATEST_ACCEPTABLE_DATE;
1559:
1560:
1561: FUNCTION LINE_CATEGORY
1562: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1563: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1564: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1565: ) RETURN NUMBER
1566: IS

Line 1583: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1579: END LINE_CATEGORY;
1580:
1581:
1582: FUNCTION LINE_NUMBER
1583: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1584: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1585: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1586: ) RETURN NUMBER
1587: IS

Line 1604: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1600: END LINE_NUMBER;
1601:
1602:
1603: FUNCTION LINE_TYPE
1604: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1605: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1606: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1607: ) RETURN NUMBER
1608: IS

Line 1625: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1621: END LINE_TYPE;
1622:
1623:
1624: FUNCTION ORDERED_QUANTITY
1625: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1626: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1627: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1628: ) RETURN NUMBER
1629: IS

Line 1637: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN

1633:
1634: -- to fix #2312158
1635: oe_sales_can_util.G_REQUIRE_REASON := FALSE;
1636:
1637: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
1638: SELECT Ordered_Quantity
1639: INTO l_old_qty
1640: FROM OE_ORDER_LINES
1641: WHERE line_id = p_record.line_id;

Line 1654: AND p_operation = OE_PC_GLOBALS.UPDATE_OP

1650: -- QUOTING change - check for cancellation constraint only for
1651: -- lines in fulfillment phase, ordered quantity reduction on
1652: -- quote lines should only check for quantity UPDATE constraints.
1653: IF NVL(p_record.transaction_phase_code,'F') = 'F'
1654: AND p_operation = OE_PC_GLOBALS.UPDATE_OP
1655: AND nvl(p_record.ordered_quantity,0) < nvl(l_old_qty,0)
1656: AND NOT(p_record.split_action_code IS NOT NULL AND
1657: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1658: l_result := ORDERED_QUANTITY

Line 1659: (p_operation => OE_PC_GLOBALS.CANCEL_OP

1655: AND nvl(p_record.ordered_quantity,0) < nvl(l_old_qty,0)
1656: AND NOT(p_record.split_action_code IS NOT NULL AND
1657: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1658: l_result := ORDERED_QUANTITY
1659: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1660: ,p_record => p_record
1661: ,x_on_operation_action => x_on_operation_action
1662: );
1663: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP

Line 1663: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP

1659: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1660: ,p_record => p_record
1661: ,x_on_operation_action => x_on_operation_action
1662: );
1663: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
1664: AND (p_record.split_action_code IS NOT NULL AND
1665: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1666: p_record.split_action_code = 'SPLIT') THEN
1667: l_result := ORDERED_QUANTITY

Line 1668: (p_operation => OE_PC_GLOBALS.SPLIT_OP

1664: AND (p_record.split_action_code IS NOT NULL AND
1665: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1666: p_record.split_action_code = 'SPLIT') THEN
1667: l_result := ORDERED_QUANTITY
1668: (p_operation => OE_PC_GLOBALS.SPLIT_OP
1669: ,p_record => p_record
1670: ,x_on_operation_action => x_on_operation_action
1671: );
1672: ELSE

Line 1688: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1684:
1685: -- OPM 1857167 start
1686:
1687: FUNCTION ORDERED_QUANTITY2
1688: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1689: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1690: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1691: ) RETURN NUMBER
1692: IS

Line 1697: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN

1693: l_result NUMBER;
1694: l_old_qty2 NUMBER;
1695: BEGIN
1696:
1697: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
1698: SELECT Ordered_Quantity2
1699: INTO l_old_qty2
1700: FROM OE_ORDER_LINES
1701: WHERE line_id = p_record.line_id;

Line 1705: IF p_operation = OE_PC_GLOBALS.UPDATE_OP

1701: WHERE line_id = p_record.line_id;
1702: END IF;
1703:
1704: -- CHECK CONSTRAINTS FOR CANCEL OPERATION IF QUANTITY IS REDUCED
1705: IF p_operation = OE_PC_GLOBALS.UPDATE_OP
1706: AND nvl(p_record.ordered_quantity2,0) < nvl(l_old_qty2,0)
1707: AND NOT(p_record.split_action_code IS NOT NULL AND
1708: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1709: l_result := ORDERED_QUANTITY2

Line 1710: (p_operation => OE_PC_GLOBALS.CANCEL_OP

1706: AND nvl(p_record.ordered_quantity2,0) < nvl(l_old_qty2,0)
1707: AND NOT(p_record.split_action_code IS NOT NULL AND
1708: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1709: l_result := ORDERED_QUANTITY2
1710: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1711: ,p_record => p_record
1712: ,x_on_operation_action => x_on_operation_action
1713: );
1714: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP

Line 1714: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP

1710: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1711: ,p_record => p_record
1712: ,x_on_operation_action => x_on_operation_action
1713: );
1714: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
1715: AND (p_record.split_action_code IS NOT NULL AND
1716: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1717: p_record.split_action_code = 'SPLIT') THEN
1718: l_result := ORDERED_QUANTITY2

Line 1719: (p_operation => OE_PC_GLOBALS.SPLIT_OP

1715: AND (p_record.split_action_code IS NOT NULL AND
1716: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1717: p_record.split_action_code = 'SPLIT') THEN
1718: l_result := ORDERED_QUANTITY2
1719: (p_operation => OE_PC_GLOBALS.SPLIT_OP
1720: ,p_record => p_record
1721: ,x_on_operation_action => x_on_operation_action
1722: );
1723: ELSE

Line 1740: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1736: -- OPM 1857167 end
1737:
1738:
1739: FUNCTION ORDER_QUANTITY_UOM
1740: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1741: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1742: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1743: ) RETURN NUMBER
1744: IS

Line 1761: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1757: END ORDER_QUANTITY_UOM;
1758:
1759:
1760: FUNCTION ORIG_SYS_DOCUMENT_REF
1761: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1762: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1763: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1764: ) RETURN NUMBER
1765: IS

Line 1782: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1778: END ORIG_SYS_DOCUMENT_REF;
1779:
1780:
1781: FUNCTION ORIG_SYS_LINE_REF
1782: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1783: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1784: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1785: ) RETURN NUMBER
1786: IS

Line 1803: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1799: END ORIG_SYS_LINE_REF;
1800:
1801:
1802: FUNCTION OVER_SHIP_REASON
1803: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1804: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1805: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1806: ) RETURN NUMBER
1807: IS

Line 1824: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1820: END OVER_SHIP_REASON;
1821:
1822:
1823: FUNCTION OVER_SHIP_RESOLVED
1824: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1825: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1826: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1827: ) RETURN NUMBER
1828: IS

Line 1844: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1840:
1841: END OVER_SHIP_RESOLVED;
1842:
1843: FUNCTION PACKING_INSTRUCTIONS
1844: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1845: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1846: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1847: ) RETURN NUMBER
1848: IS

Line 1866: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1862: END PACKING_INSTRUCTIONS;
1863:
1864:
1865: FUNCTION PAYMENT_TERM
1866: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1867: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1868: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1869: ) RETURN NUMBER
1870: IS

Line 1886: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1882:
1883: END PAYMENT_TERM;
1884:
1885: FUNCTION PLANNING_PRIORITY
1886: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1887: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1888: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1889: ) RETURN NUMBER
1890: IS

Line 1907: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1903: END PLANNING_PRIORITY;
1904:
1905:
1906: FUNCTION PRICE_LIST
1907: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1908: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1909: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1910: ) RETURN NUMBER
1911: IS

Line 1928: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1924: END PRICE_LIST;
1925:
1926:
1927: FUNCTION PRICING_DATE
1928: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1929: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1930: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1931: ) RETURN NUMBER
1932: IS

Line 1949: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1945: END PRICING_DATE;
1946:
1947:
1948: FUNCTION PRICING_QUANTITY
1949: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1950: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1951: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1952: ) RETURN NUMBER
1953: IS

Line 1970: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1966: END PRICING_QUANTITY;
1967:
1968:
1969: FUNCTION PRICING_QUANTITY_UOM
1970: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1971: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1972: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1973: ) RETURN NUMBER
1974: IS

Line 1991: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1987: END PRICING_QUANTITY_UOM;
1988:
1989:
1990: FUNCTION PROJECT
1991: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1992: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1993: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1994: ) RETURN NUMBER
1995: IS

Line 2012: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2008: END PROJECT;
2009:
2010:
2011: FUNCTION PROMISE_DATE
2012: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2013: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2014: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2015: ) RETURN NUMBER
2016: IS

Line 2032: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2028:
2029: END PROMISE_DATE;
2030:
2031: FUNCTION REFERENCE_CUST_TRX_LINE
2032: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2033: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2034: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2035: ) RETURN NUMBER
2036: IS

Line 2052: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2048:
2049: END REFERENCE_CUST_TRX_LINE;
2050:
2051: FUNCTION REFERENCE_TYPE
2052: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2053: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2054: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2055: ) RETURN NUMBER
2056: IS

Line 2073: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2069: END REFERENCE_TYPE;
2070:
2071:
2072: FUNCTION REQUEST_DATE
2073: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2074: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2075: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2076: ) RETURN NUMBER
2077: IS

Line 2094: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2090: END REQUEST_DATE;
2091:
2092:
2093: FUNCTION RETURN_REASON
2094: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2095: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2096: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2097: ) RETURN NUMBER
2098: IS

Line 2115: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2111: END RETURN_REASON;
2112:
2113:
2114: FUNCTION SALESREP
2115: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2116: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2117: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2118: ) RETURN NUMBER
2119: IS

Line 2135: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2131:
2132: END SALESREP;
2133:
2134: FUNCTION SHIP_SET
2135: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2136: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2137: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2138: ) RETURN NUMBER
2139: IS

Line 2155: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2151:
2152: END SHIP_SET;
2153:
2154: FUNCTION ARRIVAL_SET
2155: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2156: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2157: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2158: ) RETURN NUMBER
2159: IS

Line 2176: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2172: END ARRIVAL_SET;
2173:
2174:
2175: FUNCTION SCHEDULE_ARRIVAL_DATE
2176: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2177: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2178: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2179: ) RETURN NUMBER
2180: IS

Line 2196: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2192:
2193: END SCHEDULE_ARRIVAL_DATE;
2194:
2195: FUNCTION SCHEDULE_SHIP_DATE
2196: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2197: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2198: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2199: ) RETURN NUMBER
2200: IS

Line 2217: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2213: END SCHEDULE_SHIP_DATE;
2214:
2215:
2216: FUNCTION SHIPMENT_NUMBER
2217: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2218: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2219: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2220: ) RETURN NUMBER
2221: IS

Line 2238: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2234: END SHIPMENT_NUMBER;
2235:
2236:
2237: FUNCTION SHIPMENT_PRIORITY
2238: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2239: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2240: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2241: ) RETURN NUMBER
2242: IS

Line 2259: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2255: END SHIPMENT_PRIORITY;
2256:
2257:
2258: FUNCTION SHIPPED_QUANTITY
2259: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2260: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2261: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2262: ) RETURN NUMBER
2263: IS

Line 2281: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2277:
2278: -- INVCONV
2279:
2280: FUNCTION SHIPPED_QUANTITY2
2281: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2282: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2283: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2284: ) RETURN NUMBER
2285: IS

Line 2302: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2298: END SHIPPED_QUANTITY2;
2299:
2300:
2301: FUNCTION SHIPPING_INSTRUCTIONS
2302: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2303: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2304: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2305: ) RETURN NUMBER
2306: IS

Line 2323: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2319: END SHIPPING_INSTRUCTIONS;
2320:
2321:
2322: FUNCTION SHIPPING_METHOD
2323: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2324: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2325: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2326: ) RETURN NUMBER
2327: IS

Line 2344: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2340: END SHIPPING_METHOD;
2341:
2342:
2343: FUNCTION SHIPPING_QUANTITY
2344: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2345: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2346: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2347: ) RETURN NUMBER
2348: IS

Line 2366: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2362:
2363: -- INVCONV
2364:
2365: FUNCTION SHIPPING_QUANTITY2
2366: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2367: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2368: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2369: ) RETURN NUMBER
2370: IS

Line 2386: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2382:
2383: END SHIPPING_QUANTITY2;
2384:
2385: FUNCTION SHIPPING_QUANTITY_UOM
2386: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2387: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2388: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2389: ) RETURN NUMBER
2390: IS

Line 2410: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2406:
2407: -- INVCONV
2408:
2409: FUNCTION SHIPPING_QUANTITY_UOM2
2410: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2411: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2412: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2413: ) RETURN NUMBER
2414: IS

Line 2431: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2427: END SHIPPING_QUANTITY_UOM2;
2428:
2429:
2430: FUNCTION SHIP_FROM_ORG
2431: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2432: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2433: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2434: ) RETURN NUMBER
2435: IS

Line 2451: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2447:
2448: END SHIP_FROM_ORG;
2449:
2450: FUNCTION SUBINVENTORY
2451: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2452: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2453: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2454: ) RETURN NUMBER
2455: IS

Line 2471: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2467:
2468: END SUBINVENTORY;
2469:
2470: FUNCTION SHIP_MODEL_COMPLETE
2471: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2472: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2473: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2474: ) RETURN NUMBER
2475: IS

Line 2492: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2488: END SHIP_MODEL_COMPLETE;
2489:
2490:
2491: FUNCTION SHIP_TOLERANCE_ABOVE
2492: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2493: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2494: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2495: ) RETURN NUMBER
2496: IS

Line 2513: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2509: END SHIP_TOLERANCE_ABOVE;
2510:
2511:
2512: FUNCTION SHIP_TOLERANCE_BELOW
2513: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2514: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2515: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2516: ) RETURN NUMBER
2517: IS

Line 2534: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2530: END SHIP_TOLERANCE_BELOW;
2531:
2532:
2533: FUNCTION SHIP_TO_CONTACT
2534: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2535: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2536: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2537: ) RETURN NUMBER
2538: IS

Line 2555: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2551: END SHIP_TO_CONTACT;
2552:
2553:
2554: FUNCTION SHIP_TO_ORG
2555: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2556: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2557: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2558: ) RETURN NUMBER
2559: IS

Line 2576: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2572: END SHIP_TO_ORG;
2573:
2574:
2575: FUNCTION SOLD_TO_ORG
2576: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2577: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2578: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2579: ) RETURN NUMBER
2580: IS

Line 2597: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2593: END SOLD_TO_ORG;
2594:
2595:
2596: FUNCTION SOURCE_DOCUMENT_TYPE
2597: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2598: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2599: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2600: ) RETURN NUMBER
2601: IS

Line 2618: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2614: END SOURCE_DOCUMENT_TYPE;
2615:
2616:
2617: FUNCTION SOURCE_TYPE
2618: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2619: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2620: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2621: ) RETURN NUMBER
2622: IS

Line 2639: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2635: END SOURCE_TYPE;
2636:
2637:
2638: FUNCTION TASK
2639: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2640: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2641: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2642: ) RETURN NUMBER
2643: IS

Line 2660: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2656: END TASK;
2657:
2658:
2659: FUNCTION TAX
2660: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2661: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2662: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2663: ) RETURN NUMBER
2664: IS

Line 2681: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2677: END TAX;
2678:
2679:
2680: FUNCTION TAX_DATE
2681: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2682: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2683: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2684: ) RETURN NUMBER
2685: IS

Line 2702: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2698: END TAX_DATE;
2699:
2700:
2701: FUNCTION TAX_EXEMPT
2702: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2703: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2704: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2705: ) RETURN NUMBER
2706: IS

Line 2723: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2719: END TAX_EXEMPT;
2720:
2721:
2722: FUNCTION TAX_EXEMPT_NUMBER
2723: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2724: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2725: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2726: ) RETURN NUMBER
2727: IS

Line 2744: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2740: END TAX_EXEMPT_NUMBER;
2741:
2742:
2743: FUNCTION TAX_EXEMPT_REASON
2744: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2745: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2746: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2747: ) RETURN NUMBER
2748: IS

Line 2767: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2763:
2764:
2765:
2766: FUNCTION UNIT_LIST_PRICE
2767: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2768: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2769: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2770: ) RETURN NUMBER
2771: IS

Line 2789: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2785:
2786:
2787:
2788: FUNCTION UNIT_SELLING_PRICE
2789: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2790: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2791: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2792: ) RETURN NUMBER
2793: IS

Line 2810: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2806: END UNIT_SELLING_PRICE;
2807:
2808:
2809: FUNCTION SERVICE_REFERENCE_TYPE
2810: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2811: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2812: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2813: ) RETURN NUMBER
2814: IS

Line 2830: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2826:
2827: END SERVICE_REFERENCE_TYPE;
2828:
2829: FUNCTION SERVICE_REFERENCE_LINE
2830: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2831: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2832: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2833: ) RETURN NUMBER
2834: IS

Line 2850: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2846:
2847: END SERVICE_REFERENCE_LINE;
2848:
2849: FUNCTION SERVICE_REFERENCE_SYSTEM
2850: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2851: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2852: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2853: ) RETURN NUMBER
2854: IS

Line 2872: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2868:
2869: /* Fix to bug 2205900: Added constraints functions for
2870: some missing SERVICE fields */
2871: FUNCTION SERVICE_COTERMINATE
2872: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2873: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2874: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2875: ) RETURN NUMBER
2876: IS

Line 2892: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2888:
2889: END SERVICE_COTERMINATE;
2890:
2891: FUNCTION SERVICE_DURATION
2892: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2893: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2894: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2895: ) RETURN NUMBER
2896: IS

Line 2912: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2908:
2909: END SERVICE_DURATION;
2910:
2911: FUNCTION SERVICE_END_DATE
2912: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2913: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2914: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2915: ) RETURN NUMBER
2916: IS

Line 2932: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2928:
2929: END SERVICE_END_DATE;
2930:
2931: FUNCTION SERVICE_PERIOD
2932: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2933: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2934: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2935: ) RETURN NUMBER
2936: IS

Line 2952: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2948:
2949: END SERVICE_PERIOD;
2950:
2951: FUNCTION SERVICE_START_DATE
2952: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2953: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2954: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2955: ) RETURN NUMBER
2956: IS

Line 2972: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2968:
2969: END SERVICE_START_DATE;
2970:
2971: FUNCTION SERVICE_TXN_COMMENTS
2972: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2973: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2974: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2975: ) RETURN NUMBER
2976: IS

Line 2992: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2988:
2989: END SERVICE_TXN_COMMENTS;
2990:
2991: FUNCTION SERVICE_TXN_REASON
2992: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2993: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2994: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2995: ) RETURN NUMBER
2996: IS

Line 3013: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3009: END SERVICE_TXN_REASON;
3010:
3011: /*1449220*/
3012: FUNCTION ITEM_IDENTIFIER_TYPE
3013: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3014: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3015: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3016: ) RETURN NUMBER
3017: IS

Line 3035: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3031: /*1449220*/
3032:
3033: FUNCTION USER_ITEM_DESCRIPTION
3034:
3035: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3036: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3037: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3038: ) RETURN NUMBER
3039: IS

Line 3055: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3051:
3052: END USER_ITEM_DESCRIPTION;
3053:
3054: FUNCTION BLANKET_NUMBER
3055: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3056: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3057: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3058: ) RETURN NUMBER
3059: IS

Line 3075: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3071:
3072: END BLANKET_NUMBER;
3073:
3074: FUNCTION BLANKET_LINE_NUMBER
3075: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3076: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3077: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3078: ) RETURN NUMBER
3079: IS

Line 3095: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3091:
3092: END BLANKET_LINE_NUMBER;
3093:
3094: FUNCTION CUSTOMER_SHIPMENT_NUMBER
3095: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3096: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3097: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3098: ) RETURN NUMBER
3099: IS

Line 3163: x_result := OE_PC_GLOBALS.YES;

3159: IF l_flow_status_code = 'CANCELLED' THEN
3160: IF l_debug_level > 0 THEN
3161: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3162: END IF;
3163: x_result := OE_PC_GLOBALS.YES;
3164: IF l_debug_level > 0 THEN
3165: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3166: END IF;
3167: -- Add msg to stack

Line 3175: l_operation := OE_PC_GLOBALS.CREATE_OP;

3171: ELSE
3172: IF l_debug_level > 0 THEN
3173: oe_debug_pub.add('hash flow status is not cancelled');
3174: END IF;
3175: l_operation := OE_PC_GLOBALS.CREATE_OP;
3176: END IF; -- if cancelled
3177: ElSE
3178: IF l_debug_level > 0 THEN
3179: oe_debug_pub.add('hash not a service');

Line 3181: l_operation := OE_PC_GLOBALS.CREATE_OP;

3177: ElSE
3178: IF l_debug_level > 0 THEN
3179: oe_debug_pub.add('hash not a service');
3180: END IF;
3181: l_operation := OE_PC_GLOBALS.CREATE_OP;
3182: END IF; -- end if service
3183:
3184: --IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3185: -- l_operation := OE_PC_GLOBALS.CREATE_OP;

Line 3185: -- l_operation := OE_PC_GLOBALS.CREATE_OP;

3181: l_operation := OE_PC_GLOBALS.CREATE_OP;
3182: END IF; -- end if service
3183:
3184: --IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3185: -- l_operation := OE_PC_GLOBALS.CREATE_OP;
3186: /* end of bug 2922204 */
3187:
3188:
3189: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 3190: l_operation := OE_PC_GLOBALS.UPDATE_OP;

3186: /* end of bug 2922204 */
3187:
3188:
3189: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3190: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3191: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3192: l_operation := OE_PC_GLOBALS.DELETE_OP;
3193: ELSE
3194: IF l_debug_level > 0 THEN

Line 3192: l_operation := OE_PC_GLOBALS.DELETE_OP;

3188:
3189: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3190: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3191: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3192: l_operation := OE_PC_GLOBALS.DELETE_OP;
3193: ELSE
3194: IF l_debug_level > 0 THEN
3195: oe_debug_pub.add('Invalid operation',1);
3196: END IF;

Line 3212: l_operation := OE_PC_GLOBALS.SPLIT_OP;

3208: oe_debug_pub.add('OEXXLINB operation is ' || p_line_rec.operation);
3209: END IF;
3210: IF (p_line_rec.split_from_line_id IS NOT NULL AND p_line_rec.operation = 'CREATE')
3211: THEN
3212: l_operation := OE_PC_GLOBALS.SPLIT_OP;
3213: END IF;
3214: x_result := Is_OP_constrained
3215: (p_operation => l_operation
3216: ,p_record => l_rowtype_rec

Line 3267: x_result := OE_PC_GLOBALS.NO;

3263: -- Initialize g_operation_action to null
3264: g_operation_action := null;
3265:
3266: -- Initializing out result to NOT CONSTRAINED
3267: x_result := OE_PC_GLOBALS.NO;
3268:
3269: -- Get the operation code to be passed to the security framework API
3270: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3271:

Line 3280: l_operation := OE_PC_GLOBALS.CREATE_OP;

3276: OR p_line_rec.split_from_line_id <> FND_API.G_MISS_NUM
3277: THEN
3278: RETURN;
3279: ELSE
3280: l_operation := OE_PC_GLOBALS.CREATE_OP;
3281: END IF;
3282:
3283: -- Bug 1755817: if there are no attribute-specific insert
3284: -- constraints, then no need to go further. Entity level

Line 3288: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE

3284: -- constraints, then no need to go further. Entity level
3285: -- security check for CREATE will be called again from
3286: -- process order after defaulting.
3287: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
3288: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE
3289: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
3290: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
3291: )
3292: THEN

Line 3297: l_operation := OE_PC_GLOBALS.UPDATE_OP;

3293: RETURN;
3294: END IF;
3295:
3296: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3297: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3298: ELSE
3299: IF l_debug_level > 0 THEN
3300: oe_debug_pub.add('Invalid operation',1);
3301: END IF;

Line 3324: IF l_result = OE_PC_GLOBALS.YES THEN

3320: ,p_record => l_rowtype_rec
3321: ,x_on_operation_action => l_on_operation_action
3322: );
3323:
3324: IF l_result = OE_PC_GLOBALS.YES THEN
3325: -- set OUT result to CONSTRAINED
3326: x_result := OE_PC_GLOBALS.YES;
3327: END IF;
3328:

Line 3326: x_result := OE_PC_GLOBALS.YES;

3322: );
3323:
3324: IF l_result = OE_PC_GLOBALS.YES THEN
3325: -- set OUT result to CONSTRAINED
3326: x_result := OE_PC_GLOBALS.YES;
3327: END IF;
3328:
3329: END IF;
3330:

Line 3340: IF l_result = OE_PC_GLOBALS.YES THEN

3336: ,p_record => l_rowtype_rec
3337: ,x_on_operation_action => l_on_operation_action
3338: );
3339:
3340: IF l_result = OE_PC_GLOBALS.YES THEN
3341: -- set OUT result to CONSTRAINED
3342: x_result := OE_PC_GLOBALS.YES;
3343: END IF;
3344:

Line 3342: x_result := OE_PC_GLOBALS.YES;

3338: );
3339:
3340: IF l_result = OE_PC_GLOBALS.YES THEN
3341: -- set OUT result to CONSTRAINED
3342: x_result := OE_PC_GLOBALS.YES;
3343: END IF;
3344:
3345: END IF;
3346: IF p_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;

Line 3355: IF l_result = OE_PC_GLOBALS.YES THEN

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:

Line 3357: x_result := OE_PC_GLOBALS.YES;

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: IF p_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;

Line 3370: IF l_result = OE_PC_GLOBALS.YES THEN

3366: ,p_record => l_rowtype_rec
3367: ,x_on_operation_action => l_on_operation_action
3368: );
3369:
3370: IF l_result = OE_PC_GLOBALS.YES THEN
3371: -- set OUT result to CONSTRAINED
3372: x_result := OE_PC_GLOBALS.YES;
3373: END IF;
3374:

Line 3372: x_result := OE_PC_GLOBALS.YES;

3368: );
3369:
3370: IF l_result = OE_PC_GLOBALS.YES THEN
3371: -- set OUT result to CONSTRAINED
3372: x_result := OE_PC_GLOBALS.YES;
3373: END IF;
3374:
3375: END IF;
3376: IF p_line_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;

Line 3385: IF l_result = OE_PC_GLOBALS.YES THEN

3381: ,p_record => l_rowtype_rec
3382: ,x_on_operation_action => l_on_operation_action
3383: );
3384:
3385: IF l_result = OE_PC_GLOBALS.YES THEN
3386: -- set OUT result to CONSTRAINED
3387: x_result := OE_PC_GLOBALS.YES;
3388: END IF;
3389:

Line 3387: x_result := OE_PC_GLOBALS.YES;

3383: );
3384:
3385: IF l_result = OE_PC_GLOBALS.YES THEN
3386: -- set OUT result to CONSTRAINED
3387: x_result := OE_PC_GLOBALS.YES;
3388: END IF;
3389:
3390: END IF;
3391: IF p_line_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;

Line 3400: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3402: x_result := OE_PC_GLOBALS.YES;

3398: );
3399:
3400: IF l_result = OE_PC_GLOBALS.YES THEN
3401: -- set OUT result to CONSTRAINED
3402: x_result := OE_PC_GLOBALS.YES;
3403: END IF;
3404:
3405: END IF;
3406: IF p_line_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;

Line 3415: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3417: x_result := OE_PC_GLOBALS.YES;

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

Line 3431: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3433: x_result := OE_PC_GLOBALS.YES;

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

Line 3447: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3449: x_result := OE_PC_GLOBALS.YES;

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

Line 3463: IF l_result = OE_PC_GLOBALS.YES THEN

3459: ,p_record => l_rowtype_rec
3460: ,x_on_operation_action => l_on_operation_action
3461: );
3462:
3463: IF l_result = OE_PC_GLOBALS.YES THEN
3464: -- set OUT result to CONSTRAINED
3465: x_result := OE_PC_GLOBALS.YES;
3466: END IF;
3467:

Line 3465: x_result := OE_PC_GLOBALS.YES;

3461: );
3462:
3463: IF l_result = OE_PC_GLOBALS.YES THEN
3464: -- set OUT result to CONSTRAINED
3465: x_result := OE_PC_GLOBALS.YES;
3466: END IF;
3467:
3468: END IF;
3469:

Line 3480: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3482: x_result := OE_PC_GLOBALS.YES;

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

Line 3496: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3498: x_result := OE_PC_GLOBALS.YES;

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

Line 3512: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3514: x_result := OE_PC_GLOBALS.YES;

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

Line 3528: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3530: x_result := OE_PC_GLOBALS.YES;

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

Line 3544: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3546: x_result := OE_PC_GLOBALS.YES;

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

Line 3560: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3562: x_result := OE_PC_GLOBALS.YES;

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

Line 3576: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3578: x_result := OE_PC_GLOBALS.YES;

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

Line 3592: IF l_result = OE_PC_GLOBALS.YES THEN

3588: ,p_record => l_rowtype_rec
3589: ,x_on_operation_action => l_on_operation_action
3590: );
3591:
3592: IF l_result = OE_PC_GLOBALS.YES THEN
3593: -- set OUT result to CONSTRAINED
3594: x_result := OE_PC_GLOBALS.YES;
3595: END IF;
3596:

Line 3594: x_result := OE_PC_GLOBALS.YES;

3590: );
3591:
3592: IF l_result = OE_PC_GLOBALS.YES THEN
3593: -- set OUT result to CONSTRAINED
3594: x_result := OE_PC_GLOBALS.YES;
3595: END IF;
3596:
3597: END IF;
3598:

Line 3608: IF l_result = OE_PC_GLOBALS.YES THEN

3604: ,p_record => l_rowtype_rec
3605: ,x_on_operation_action => l_on_operation_action
3606: );
3607:
3608: IF l_result = OE_PC_GLOBALS.YES THEN
3609: -- set OUT result to CONSTRAINED
3610: x_result := OE_PC_GLOBALS.YES;
3611: END IF;
3612:

Line 3610: x_result := OE_PC_GLOBALS.YES;

3606: );
3607:
3608: IF l_result = OE_PC_GLOBALS.YES THEN
3609: -- set OUT result to CONSTRAINED
3610: x_result := OE_PC_GLOBALS.YES;
3611: END IF;
3612:
3613: END IF;
3614:

Line 3624: IF l_result = OE_PC_GLOBALS.YES THEN

3620: ,p_record => l_rowtype_rec
3621: ,x_on_operation_action => l_on_operation_action
3622: );
3623:
3624: IF l_result = OE_PC_GLOBALS.YES THEN
3625: -- set OUT result to CONSTRAINED
3626: x_result := OE_PC_GLOBALS.YES;
3627: END IF;
3628:

Line 3626: x_result := OE_PC_GLOBALS.YES;

3622: );
3623:
3624: IF l_result = OE_PC_GLOBALS.YES THEN
3625: -- set OUT result to CONSTRAINED
3626: x_result := OE_PC_GLOBALS.YES;
3627: END IF;
3628:
3629: END IF;
3630:

Line 3640: IF l_result = OE_PC_GLOBALS.YES THEN

3636: ,p_record => l_rowtype_rec
3637: ,x_on_operation_action => l_on_operation_action
3638: );
3639:
3640: IF l_result = OE_PC_GLOBALS.YES THEN
3641: -- set OUT result to CONSTRAINED
3642: x_result := OE_PC_GLOBALS.YES;
3643: END IF;
3644:

Line 3642: x_result := OE_PC_GLOBALS.YES;

3638: );
3639:
3640: IF l_result = OE_PC_GLOBALS.YES THEN
3641: -- set OUT result to CONSTRAINED
3642: x_result := OE_PC_GLOBALS.YES;
3643: END IF;
3644:
3645: END IF;
3646:

Line 3656: IF l_result = OE_PC_GLOBALS.YES THEN

3652: ,p_record => l_rowtype_rec
3653: ,x_on_operation_action => l_on_operation_action
3654: );
3655:
3656: IF l_result = OE_PC_GLOBALS.YES THEN
3657: -- set OUT result to CONSTRAINED
3658: x_result := OE_PC_GLOBALS.YES;
3659: END IF;
3660:

Line 3658: x_result := OE_PC_GLOBALS.YES;

3654: );
3655:
3656: IF l_result = OE_PC_GLOBALS.YES THEN
3657: -- set OUT result to CONSTRAINED
3658: x_result := OE_PC_GLOBALS.YES;
3659: END IF;
3660:
3661: END IF;
3662:

Line 3672: IF l_result = OE_PC_GLOBALS.YES THEN

3668: ,p_record => l_rowtype_rec
3669: ,x_on_operation_action => l_on_operation_action
3670: );
3671:
3672: IF l_result = OE_PC_GLOBALS.YES THEN
3673: -- set OUT result to CONSTRAINED
3674: x_result := OE_PC_GLOBALS.YES;
3675: END IF;
3676:

Line 3674: x_result := OE_PC_GLOBALS.YES;

3670: );
3671:
3672: IF l_result = OE_PC_GLOBALS.YES THEN
3673: -- set OUT result to CONSTRAINED
3674: x_result := OE_PC_GLOBALS.YES;
3675: END IF;
3676:
3677: END IF;
3678:

Line 3688: IF l_result = OE_PC_GLOBALS.YES THEN

3684: ,p_record => l_rowtype_rec
3685: ,x_on_operation_action => l_on_operation_action
3686: );
3687:
3688: IF l_result = OE_PC_GLOBALS.YES THEN
3689: -- set OUT result to CONSTRAINED
3690: x_result := OE_PC_GLOBALS.YES;
3691: END IF;
3692:

Line 3690: x_result := OE_PC_GLOBALS.YES;

3686: );
3687:
3688: IF l_result = OE_PC_GLOBALS.YES THEN
3689: -- set OUT result to CONSTRAINED
3690: x_result := OE_PC_GLOBALS.YES;
3691: END IF;
3692:
3693: END IF;
3694:

Line 3704: IF l_result = OE_PC_GLOBALS.YES THEN

3700: ,p_record => l_rowtype_rec
3701: ,x_on_operation_action => l_on_operation_action
3702: );
3703:
3704: IF l_result = OE_PC_GLOBALS.YES THEN
3705: -- set OUT result to CONSTRAINED
3706: x_result := OE_PC_GLOBALS.YES;
3707: END IF;
3708:

Line 3706: x_result := OE_PC_GLOBALS.YES;

3702: );
3703:
3704: IF l_result = OE_PC_GLOBALS.YES THEN
3705: -- set OUT result to CONSTRAINED
3706: x_result := OE_PC_GLOBALS.YES;
3707: END IF;
3708:
3709: END IF;
3710:

Line 3720: IF l_result = OE_PC_GLOBALS.YES THEN

3716: ,p_record => l_rowtype_rec
3717: ,x_on_operation_action => l_on_operation_action
3718: );
3719:
3720: IF l_result = OE_PC_GLOBALS.YES THEN
3721: -- set OUT result to CONSTRAINED
3722: x_result := OE_PC_GLOBALS.YES;
3723: END IF;
3724:

Line 3722: x_result := OE_PC_GLOBALS.YES;

3718: );
3719:
3720: IF l_result = OE_PC_GLOBALS.YES THEN
3721: -- set OUT result to CONSTRAINED
3722: x_result := OE_PC_GLOBALS.YES;
3723: END IF;
3724:
3725: END IF;
3726:

Line 3737: IF l_result = OE_PC_GLOBALS.YES THEN

3733: ,p_record => l_rowtype_rec
3734: ,x_on_operation_action => l_on_operation_action
3735: );
3736:
3737: IF l_result = OE_PC_GLOBALS.YES THEN
3738: -- set OUT result to CONSTRAINED
3739: x_result := OE_PC_GLOBALS.YES;
3740: END IF;
3741:

Line 3739: x_result := OE_PC_GLOBALS.YES;

3735: );
3736:
3737: IF l_result = OE_PC_GLOBALS.YES THEN
3738: -- set OUT result to CONSTRAINED
3739: x_result := OE_PC_GLOBALS.YES;
3740: END IF;
3741:
3742: END IF;
3743:

Line 3753: IF l_result = OE_PC_GLOBALS.YES THEN

3749: ,p_record => l_rowtype_rec
3750: ,x_on_operation_action => l_on_operation_action
3751: );
3752:
3753: IF l_result = OE_PC_GLOBALS.YES THEN
3754: -- set OUT result to CONSTRAINED
3755: x_result := OE_PC_GLOBALS.YES;
3756: END IF;
3757:

Line 3755: x_result := OE_PC_GLOBALS.YES;

3751: );
3752:
3753: IF l_result = OE_PC_GLOBALS.YES THEN
3754: -- set OUT result to CONSTRAINED
3755: x_result := OE_PC_GLOBALS.YES;
3756: END IF;
3757:
3758: END IF;
3759:

Line 3769: IF l_result = OE_PC_GLOBALS.YES THEN

3765: ,p_record => l_rowtype_rec
3766: ,x_on_operation_action => l_on_operation_action
3767: );
3768:
3769: IF l_result = OE_PC_GLOBALS.YES THEN
3770: -- set OUT result to CONSTRAINED
3771: x_result := OE_PC_GLOBALS.YES;
3772: END IF;
3773:

Line 3771: x_result := OE_PC_GLOBALS.YES;

3767: );
3768:
3769: IF l_result = OE_PC_GLOBALS.YES THEN
3770: -- set OUT result to CONSTRAINED
3771: x_result := OE_PC_GLOBALS.YES;
3772: END IF;
3773:
3774: END IF;
3775:

Line 3785: IF l_result = OE_PC_GLOBALS.YES THEN

3781: ,p_record => l_rowtype_rec
3782: ,x_on_operation_action => l_on_operation_action
3783: );
3784:
3785: IF l_result = OE_PC_GLOBALS.YES THEN
3786: -- set OUT result to CONSTRAINED
3787: x_result := OE_PC_GLOBALS.YES;
3788: END IF;
3789:

Line 3787: x_result := OE_PC_GLOBALS.YES;

3783: );
3784:
3785: IF l_result = OE_PC_GLOBALS.YES THEN
3786: -- set OUT result to CONSTRAINED
3787: x_result := OE_PC_GLOBALS.YES;
3788: END IF;
3789:
3790: END IF;
3791:

Line 3801: IF l_result = OE_PC_GLOBALS.YES THEN

3797: ,p_record => l_rowtype_rec
3798: ,x_on_operation_action => l_on_operation_action
3799: );
3800:
3801: IF l_result = OE_PC_GLOBALS.YES THEN
3802: -- set OUT result to CONSTRAINED
3803: x_result := OE_PC_GLOBALS.YES;
3804: END IF;
3805:

Line 3803: x_result := OE_PC_GLOBALS.YES;

3799: );
3800:
3801: IF l_result = OE_PC_GLOBALS.YES THEN
3802: -- set OUT result to CONSTRAINED
3803: x_result := OE_PC_GLOBALS.YES;
3804: END IF;
3805:
3806: END IF;
3807:

Line 3817: IF l_result = OE_PC_GLOBALS.YES THEN

3813: ,p_record => l_rowtype_rec
3814: ,x_on_operation_action => l_on_operation_action
3815: );
3816:
3817: IF l_result = OE_PC_GLOBALS.YES THEN
3818: -- set OUT result to CONSTRAINED
3819: x_result := OE_PC_GLOBALS.YES;
3820: END IF;
3821:

Line 3819: x_result := OE_PC_GLOBALS.YES;

3815: );
3816:
3817: IF l_result = OE_PC_GLOBALS.YES THEN
3818: -- set OUT result to CONSTRAINED
3819: x_result := OE_PC_GLOBALS.YES;
3820: END IF;
3821:
3822: END IF;
3823:

Line 3833: IF l_result = OE_PC_GLOBALS.YES THEN

3829: ,p_record => l_rowtype_rec
3830: ,x_on_operation_action => l_on_operation_action
3831: );
3832:
3833: IF l_result = OE_PC_GLOBALS.YES THEN
3834: -- set OUT result to CONSTRAINED
3835: x_result := OE_PC_GLOBALS.YES;
3836: END IF;
3837:

Line 3835: x_result := OE_PC_GLOBALS.YES;

3831: );
3832:
3833: IF l_result = OE_PC_GLOBALS.YES THEN
3834: -- set OUT result to CONSTRAINED
3835: x_result := OE_PC_GLOBALS.YES;
3836: END IF;
3837:
3838: END IF;
3839:

Line 3849: IF l_result = OE_PC_GLOBALS.YES THEN

3845: ,p_record => l_rowtype_rec
3846: ,x_on_operation_action => l_on_operation_action
3847: );
3848:
3849: IF l_result = OE_PC_GLOBALS.YES THEN
3850: -- set OUT result to CONSTRAINED
3851: x_result := OE_PC_GLOBALS.YES;
3852: END IF;
3853:

Line 3851: x_result := OE_PC_GLOBALS.YES;

3847: );
3848:
3849: IF l_result = OE_PC_GLOBALS.YES THEN
3850: -- set OUT result to CONSTRAINED
3851: x_result := OE_PC_GLOBALS.YES;
3852: END IF;
3853:
3854: END IF;
3855:

Line 3865: IF l_result = OE_PC_GLOBALS.YES THEN

3861: ,p_record => l_rowtype_rec
3862: ,x_on_operation_action => l_on_operation_action
3863: );
3864:
3865: IF l_result = OE_PC_GLOBALS.YES THEN
3866: -- set OUT result to CONSTRAINED
3867: x_result := OE_PC_GLOBALS.YES;
3868: END IF;
3869:

Line 3867: x_result := OE_PC_GLOBALS.YES;

3863: );
3864:
3865: IF l_result = OE_PC_GLOBALS.YES THEN
3866: -- set OUT result to CONSTRAINED
3867: x_result := OE_PC_GLOBALS.YES;
3868: END IF;
3869:
3870: END IF;
3871:

Line 3881: IF l_result = OE_PC_GLOBALS.YES THEN

3877: ,p_record => l_rowtype_rec
3878: ,x_on_operation_action => l_on_operation_action
3879: );
3880:
3881: IF l_result = OE_PC_GLOBALS.YES THEN
3882: -- set OUT result to CONSTRAINED
3883: x_result := OE_PC_GLOBALS.YES;
3884: END IF;
3885:

Line 3883: x_result := OE_PC_GLOBALS.YES;

3879: );
3880:
3881: IF l_result = OE_PC_GLOBALS.YES THEN
3882: -- set OUT result to CONSTRAINED
3883: x_result := OE_PC_GLOBALS.YES;
3884: END IF;
3885:
3886: END IF;
3887:

Line 3897: IF l_result = OE_PC_GLOBALS.YES THEN

3893: ,p_record => l_rowtype_rec
3894: ,x_on_operation_action => l_on_operation_action
3895: );
3896:
3897: IF l_result = OE_PC_GLOBALS.YES THEN
3898: -- set OUT result to CONSTRAINED
3899: x_result := OE_PC_GLOBALS.YES;
3900: END IF;
3901:

Line 3899: x_result := OE_PC_GLOBALS.YES;

3895: );
3896:
3897: IF l_result = OE_PC_GLOBALS.YES THEN
3898: -- set OUT result to CONSTRAINED
3899: x_result := OE_PC_GLOBALS.YES;
3900: END IF;
3901:
3902: END IF;
3903:

Line 3913: IF l_result = OE_PC_GLOBALS.YES THEN

3909: ,p_record => l_rowtype_rec
3910: ,x_on_operation_action => l_on_operation_action
3911: );
3912:
3913: IF l_result = OE_PC_GLOBALS.YES THEN
3914: -- set OUT result to CONSTRAINED
3915: x_result := OE_PC_GLOBALS.YES;
3916: END IF;
3917:

Line 3915: x_result := OE_PC_GLOBALS.YES;

3911: );
3912:
3913: IF l_result = OE_PC_GLOBALS.YES THEN
3914: -- set OUT result to CONSTRAINED
3915: x_result := OE_PC_GLOBALS.YES;
3916: END IF;
3917:
3918: END IF;
3919:

Line 3929: IF l_result = OE_PC_GLOBALS.YES THEN

3925: ,p_record => l_rowtype_rec
3926: ,x_on_operation_action => l_on_operation_action
3927: );
3928:
3929: IF l_result = OE_PC_GLOBALS.YES THEN
3930: -- set OUT result to CONSTRAINED
3931: x_result := OE_PC_GLOBALS.YES;
3932: END IF;
3933:

Line 3931: x_result := OE_PC_GLOBALS.YES;

3927: );
3928:
3929: IF l_result = OE_PC_GLOBALS.YES THEN
3930: -- set OUT result to CONSTRAINED
3931: x_result := OE_PC_GLOBALS.YES;
3932: END IF;
3933:
3934: END IF;
3935:

Line 3946: IF l_result = OE_PC_GLOBALS.YES THEN

3942: ,p_record => l_rowtype_rec
3943: ,x_on_operation_action => l_on_operation_action
3944: );
3945:
3946: IF l_result = OE_PC_GLOBALS.YES THEN
3947: -- set OUT result to CONSTRAINED
3948: x_result := OE_PC_GLOBALS.YES;
3949: END IF;
3950:

Line 3948: x_result := OE_PC_GLOBALS.YES;

3944: );
3945:
3946: IF l_result = OE_PC_GLOBALS.YES THEN
3947: -- set OUT result to CONSTRAINED
3948: x_result := OE_PC_GLOBALS.YES;
3949: END IF;
3950:
3951: END IF;
3952: -- OPM 1857167 end

Line 3965: IF l_result = OE_PC_GLOBALS.YES THEN

3961: ,p_record => l_rowtype_rec
3962: ,x_on_operation_action => l_on_operation_action
3963: );
3964:
3965: IF l_result = OE_PC_GLOBALS.YES THEN
3966: -- set OUT result to CONSTRAINED
3967: x_result := OE_PC_GLOBALS.YES;
3968: END IF;
3969:

Line 3967: x_result := OE_PC_GLOBALS.YES;

3963: );
3964:
3965: IF l_result = OE_PC_GLOBALS.YES THEN
3966: -- set OUT result to CONSTRAINED
3967: x_result := OE_PC_GLOBALS.YES;
3968: END IF;
3969:
3970: END IF;
3971:

Line 3981: IF l_result = OE_PC_GLOBALS.YES THEN

3977: ,p_record => l_rowtype_rec
3978: ,x_on_operation_action => l_on_operation_action
3979: );
3980:
3981: IF l_result = OE_PC_GLOBALS.YES THEN
3982: -- set OUT result to CONSTRAINED
3983: x_result := OE_PC_GLOBALS.YES;
3984: END IF;
3985:

Line 3983: x_result := OE_PC_GLOBALS.YES;

3979: );
3980:
3981: IF l_result = OE_PC_GLOBALS.YES THEN
3982: -- set OUT result to CONSTRAINED
3983: x_result := OE_PC_GLOBALS.YES;
3984: END IF;
3985:
3986: END IF;
3987:

Line 3997: IF l_result = OE_PC_GLOBALS.YES THEN

3993: ,p_record => l_rowtype_rec
3994: ,x_on_operation_action => l_on_operation_action
3995: );
3996:
3997: IF l_result = OE_PC_GLOBALS.YES THEN
3998: -- set OUT result to CONSTRAINED
3999: x_result := OE_PC_GLOBALS.YES;
4000: END IF;
4001:

Line 3999: x_result := OE_PC_GLOBALS.YES;

3995: );
3996:
3997: IF l_result = OE_PC_GLOBALS.YES THEN
3998: -- set OUT result to CONSTRAINED
3999: x_result := OE_PC_GLOBALS.YES;
4000: END IF;
4001:
4002: END IF;
4003:

Line 4013: IF l_result = OE_PC_GLOBALS.YES THEN

4009: ,p_record => l_rowtype_rec
4010: ,x_on_operation_action => l_on_operation_action
4011: );
4012:
4013: IF l_result = OE_PC_GLOBALS.YES THEN
4014: -- set OUT result to CONSTRAINED
4015: x_result := OE_PC_GLOBALS.YES;
4016: END IF;
4017:

Line 4015: x_result := OE_PC_GLOBALS.YES;

4011: );
4012:
4013: IF l_result = OE_PC_GLOBALS.YES THEN
4014: -- set OUT result to CONSTRAINED
4015: x_result := OE_PC_GLOBALS.YES;
4016: END IF;
4017:
4018: END IF;
4019:

Line 4029: IF l_result = OE_PC_GLOBALS.YES THEN

4025: ,p_record => l_rowtype_rec
4026: ,x_on_operation_action => l_on_operation_action
4027: );
4028:
4029: IF l_result = OE_PC_GLOBALS.YES THEN
4030: -- set OUT result to CONSTRAINED
4031: x_result := OE_PC_GLOBALS.YES;
4032: END IF;
4033:

Line 4031: x_result := OE_PC_GLOBALS.YES;

4027: );
4028:
4029: IF l_result = OE_PC_GLOBALS.YES THEN
4030: -- set OUT result to CONSTRAINED
4031: x_result := OE_PC_GLOBALS.YES;
4032: END IF;
4033:
4034: END IF;
4035:

Line 4045: IF l_result = OE_PC_GLOBALS.YES THEN

4041: ,p_record => l_rowtype_rec
4042: ,x_on_operation_action => l_on_operation_action
4043: );
4044:
4045: IF l_result = OE_PC_GLOBALS.YES THEN
4046: -- set OUT result to CONSTRAINED
4047: x_result := OE_PC_GLOBALS.YES;
4048: END IF;
4049:

Line 4047: x_result := OE_PC_GLOBALS.YES;

4043: );
4044:
4045: IF l_result = OE_PC_GLOBALS.YES THEN
4046: -- set OUT result to CONSTRAINED
4047: x_result := OE_PC_GLOBALS.YES;
4048: END IF;
4049:
4050: END IF;
4051:

Line 4061: IF l_result = OE_PC_GLOBALS.YES THEN

4057: ,p_record => l_rowtype_rec
4058: ,x_on_operation_action => l_on_operation_action
4059: );
4060:
4061: IF l_result = OE_PC_GLOBALS.YES THEN
4062: -- set OUT result to CONSTRAINED
4063: x_result := OE_PC_GLOBALS.YES;
4064: END IF;
4065:

Line 4063: x_result := OE_PC_GLOBALS.YES;

4059: );
4060:
4061: IF l_result = OE_PC_GLOBALS.YES THEN
4062: -- set OUT result to CONSTRAINED
4063: x_result := OE_PC_GLOBALS.YES;
4064: END IF;
4065:
4066: END IF;
4067:

Line 4077: IF l_result = OE_PC_GLOBALS.YES THEN

4073: ,p_record => l_rowtype_rec
4074: ,x_on_operation_action => l_on_operation_action
4075: );
4076:
4077: IF l_result = OE_PC_GLOBALS.YES THEN
4078: -- set OUT result to CONSTRAINED
4079: x_result := OE_PC_GLOBALS.YES;
4080: END IF;
4081:

Line 4079: x_result := OE_PC_GLOBALS.YES;

4075: );
4076:
4077: IF l_result = OE_PC_GLOBALS.YES THEN
4078: -- set OUT result to CONSTRAINED
4079: x_result := OE_PC_GLOBALS.YES;
4080: END IF;
4081:
4082: END IF;
4083:

Line 4093: IF l_result = OE_PC_GLOBALS.YES THEN

4089: ,p_record => l_rowtype_rec
4090: ,x_on_operation_action => l_on_operation_action
4091: );
4092:
4093: IF l_result = OE_PC_GLOBALS.YES THEN
4094: -- set OUT result to CONSTRAINED
4095: x_result := OE_PC_GLOBALS.YES;
4096: END IF;
4097:

Line 4095: x_result := OE_PC_GLOBALS.YES;

4091: );
4092:
4093: IF l_result = OE_PC_GLOBALS.YES THEN
4094: -- set OUT result to CONSTRAINED
4095: x_result := OE_PC_GLOBALS.YES;
4096: END IF;
4097:
4098: END IF;
4099:

Line 4109: IF l_result = OE_PC_GLOBALS.YES THEN

4105: ,p_record => l_rowtype_rec
4106: ,x_on_operation_action => l_on_operation_action
4107: );
4108:
4109: IF l_result = OE_PC_GLOBALS.YES THEN
4110: -- set OUT result to CONSTRAINED
4111: x_result := OE_PC_GLOBALS.YES;
4112: END IF;
4113:

Line 4111: x_result := OE_PC_GLOBALS.YES;

4107: );
4108:
4109: IF l_result = OE_PC_GLOBALS.YES THEN
4110: -- set OUT result to CONSTRAINED
4111: x_result := OE_PC_GLOBALS.YES;
4112: END IF;
4113:
4114: END IF;
4115:

Line 4125: IF l_result = OE_PC_GLOBALS.YES THEN

4121: ,p_record => l_rowtype_rec
4122: ,x_on_operation_action => l_on_operation_action
4123: );
4124:
4125: IF l_result = OE_PC_GLOBALS.YES THEN
4126: -- set OUT result to CONSTRAINED
4127: x_result := OE_PC_GLOBALS.YES;
4128: END IF;
4129:

Line 4127: x_result := OE_PC_GLOBALS.YES;

4123: );
4124:
4125: IF l_result = OE_PC_GLOBALS.YES THEN
4126: -- set OUT result to CONSTRAINED
4127: x_result := OE_PC_GLOBALS.YES;
4128: END IF;
4129:
4130: END IF;
4131:

Line 4141: IF l_result = OE_PC_GLOBALS.YES THEN

4137: ,p_record => l_rowtype_rec
4138: ,x_on_operation_action => l_on_operation_action
4139: );
4140:
4141: IF l_result = OE_PC_GLOBALS.YES THEN
4142: -- set OUT result to CONSTRAINED
4143: x_result := OE_PC_GLOBALS.YES;
4144: END IF;
4145:

Line 4143: x_result := OE_PC_GLOBALS.YES;

4139: );
4140:
4141: IF l_result = OE_PC_GLOBALS.YES THEN
4142: -- set OUT result to CONSTRAINED
4143: x_result := OE_PC_GLOBALS.YES;
4144: END IF;
4145:
4146: END IF;
4147:

Line 4157: IF l_result = OE_PC_GLOBALS.YES THEN

4153: ,p_record => l_rowtype_rec
4154: ,x_on_operation_action => l_on_operation_action
4155: );
4156:
4157: IF l_result = OE_PC_GLOBALS.YES THEN
4158: -- set OUT result to CONSTRAINED
4159: x_result := OE_PC_GLOBALS.YES;
4160: END IF;
4161:

Line 4159: x_result := OE_PC_GLOBALS.YES;

4155: );
4156:
4157: IF l_result = OE_PC_GLOBALS.YES THEN
4158: -- set OUT result to CONSTRAINED
4159: x_result := OE_PC_GLOBALS.YES;
4160: END IF;
4161:
4162: END IF;
4163:

Line 4173: IF l_result = OE_PC_GLOBALS.YES THEN

4169: ,p_record => l_rowtype_rec
4170: ,x_on_operation_action => l_on_operation_action
4171: );
4172:
4173: IF l_result = OE_PC_GLOBALS.YES THEN
4174: -- set OUT result to CONSTRAINED
4175: x_result := OE_PC_GLOBALS.YES;
4176: END IF;
4177:

Line 4175: x_result := OE_PC_GLOBALS.YES;

4171: );
4172:
4173: IF l_result = OE_PC_GLOBALS.YES THEN
4174: -- set OUT result to CONSTRAINED
4175: x_result := OE_PC_GLOBALS.YES;
4176: END IF;
4177:
4178: END IF;
4179:

Line 4189: IF l_result = OE_PC_GLOBALS.YES THEN

4185: ,p_record => l_rowtype_rec
4186: ,x_on_operation_action => l_on_operation_action
4187: );
4188:
4189: IF l_result = OE_PC_GLOBALS.YES THEN
4190: -- set OUT result to CONSTRAINED
4191: x_result := OE_PC_GLOBALS.YES;
4192: END IF;
4193:

Line 4191: x_result := OE_PC_GLOBALS.YES;

4187: );
4188:
4189: IF l_result = OE_PC_GLOBALS.YES THEN
4190: -- set OUT result to CONSTRAINED
4191: x_result := OE_PC_GLOBALS.YES;
4192: END IF;
4193:
4194: END IF;
4195:

Line 4205: IF l_result = OE_PC_GLOBALS.YES THEN

4201: ,p_record => l_rowtype_rec
4202: ,x_on_operation_action => l_on_operation_action
4203: );
4204:
4205: IF l_result = OE_PC_GLOBALS.YES THEN
4206: -- set OUT result to CONSTRAINED
4207: x_result := OE_PC_GLOBALS.YES;
4208: END IF;
4209:

Line 4207: x_result := OE_PC_GLOBALS.YES;

4203: );
4204:
4205: IF l_result = OE_PC_GLOBALS.YES THEN
4206: -- set OUT result to CONSTRAINED
4207: x_result := OE_PC_GLOBALS.YES;
4208: END IF;
4209:
4210: END IF;
4211:

Line 4221: IF l_result = OE_PC_GLOBALS.YES THEN

4217: ,p_record => l_rowtype_rec
4218: ,x_on_operation_action => l_on_operation_action
4219: );
4220:
4221: IF l_result = OE_PC_GLOBALS.YES THEN
4222: -- set OUT result to CONSTRAINED
4223: x_result := OE_PC_GLOBALS.YES;
4224: END IF;
4225:

Line 4223: x_result := OE_PC_GLOBALS.YES;

4219: );
4220:
4221: IF l_result = OE_PC_GLOBALS.YES THEN
4222: -- set OUT result to CONSTRAINED
4223: x_result := OE_PC_GLOBALS.YES;
4224: END IF;
4225:
4226: END IF;
4227:

Line 4237: IF l_result = OE_PC_GLOBALS.YES THEN

4233: ,p_record => l_rowtype_rec
4234: ,x_on_operation_action => l_on_operation_action
4235: );
4236:
4237: IF l_result = OE_PC_GLOBALS.YES THEN
4238: -- set OUT result to CONSTRAINED
4239: x_result := OE_PC_GLOBALS.YES;
4240: END IF;
4241:

Line 4239: x_result := OE_PC_GLOBALS.YES;

4235: );
4236:
4237: IF l_result = OE_PC_GLOBALS.YES THEN
4238: -- set OUT result to CONSTRAINED
4239: x_result := OE_PC_GLOBALS.YES;
4240: END IF;
4241:
4242: END IF;
4243:

Line 4253: IF l_result = OE_PC_GLOBALS.YES THEN

4249: ,p_record => l_rowtype_rec
4250: ,x_on_operation_action => l_on_operation_action
4251: );
4252:
4253: IF l_result = OE_PC_GLOBALS.YES THEN
4254: -- set OUT result to CONSTRAINED
4255: x_result := OE_PC_GLOBALS.YES;
4256: END IF;
4257:

Line 4255: x_result := OE_PC_GLOBALS.YES;

4251: );
4252:
4253: IF l_result = OE_PC_GLOBALS.YES THEN
4254: -- set OUT result to CONSTRAINED
4255: x_result := OE_PC_GLOBALS.YES;
4256: END IF;
4257:
4258: END IF;
4259:

Line 4269: IF l_result = OE_PC_GLOBALS.YES THEN

4265: ,p_record => l_rowtype_rec
4266: ,x_on_operation_action => l_on_operation_action
4267: );
4268:
4269: IF l_result = OE_PC_GLOBALS.YES THEN
4270: -- set OUT result to CONSTRAINED
4271: x_result := OE_PC_GLOBALS.YES;
4272: END IF;
4273:

Line 4271: x_result := OE_PC_GLOBALS.YES;

4267: );
4268:
4269: IF l_result = OE_PC_GLOBALS.YES THEN
4270: -- set OUT result to CONSTRAINED
4271: x_result := OE_PC_GLOBALS.YES;
4272: END IF;
4273:
4274: END IF;
4275:

Line 4288: IF l_result = OE_PC_GLOBALS.YES THEN

4284: ,p_record => l_rowtype_rec
4285: ,x_on_operation_action => l_on_operation_action
4286: );
4287:
4288: IF l_result = OE_PC_GLOBALS.YES THEN
4289: -- set OUT result to CONSTRAINED
4290: x_result := OE_PC_GLOBALS.YES;
4291: END IF;
4292:

Line 4290: x_result := OE_PC_GLOBALS.YES;

4286: );
4287:
4288: IF l_result = OE_PC_GLOBALS.YES THEN
4289: -- set OUT result to CONSTRAINED
4290: x_result := OE_PC_GLOBALS.YES;
4291: END IF;
4292:
4293: END IF;
4294:

Line 4304: IF l_result = OE_PC_GLOBALS.YES THEN

4300: ,p_record => l_rowtype_rec
4301: ,x_on_operation_action => l_on_operation_action
4302: );
4303:
4304: IF l_result = OE_PC_GLOBALS.YES THEN
4305: -- set OUT result to CONSTRAINED
4306: x_result := OE_PC_GLOBALS.YES;
4307: END IF;
4308:

Line 4306: x_result := OE_PC_GLOBALS.YES;

4302: );
4303:
4304: IF l_result = OE_PC_GLOBALS.YES THEN
4305: -- set OUT result to CONSTRAINED
4306: x_result := OE_PC_GLOBALS.YES;
4307: END IF;
4308:
4309: END IF;
4310:

Line 4320: IF l_result = OE_PC_GLOBALS.YES THEN

4316: ,p_record => l_rowtype_rec
4317: ,x_on_operation_action => l_on_operation_action
4318: );
4319:
4320: IF l_result = OE_PC_GLOBALS.YES THEN
4321: -- set OUT result to CONSTRAINED
4322: x_result := OE_PC_GLOBALS.YES;
4323: END IF;
4324:

Line 4322: x_result := OE_PC_GLOBALS.YES;

4318: );
4319:
4320: IF l_result = OE_PC_GLOBALS.YES THEN
4321: -- set OUT result to CONSTRAINED
4322: x_result := OE_PC_GLOBALS.YES;
4323: END IF;
4324:
4325: END IF;
4326:

Line 4336: IF l_result = OE_PC_GLOBALS.YES THEN

4332: ,p_record => l_rowtype_rec
4333: ,x_on_operation_action => l_on_operation_action
4334: );
4335:
4336: IF l_result = OE_PC_GLOBALS.YES THEN
4337: -- set OUT result to CONSTRAINED
4338: x_result := OE_PC_GLOBALS.YES;
4339: END IF;
4340:

Line 4338: x_result := OE_PC_GLOBALS.YES;

4334: );
4335:
4336: IF l_result = OE_PC_GLOBALS.YES THEN
4337: -- set OUT result to CONSTRAINED
4338: x_result := OE_PC_GLOBALS.YES;
4339: END IF;
4340:
4341: END IF;
4342:

Line 4352: IF l_result = OE_PC_GLOBALS.YES THEN

4348: ,p_record => l_rowtype_rec
4349: ,x_on_operation_action => l_on_operation_action
4350: );
4351:
4352: IF l_result = OE_PC_GLOBALS.YES THEN
4353: -- set OUT result to CONSTRAINED
4354: x_result := OE_PC_GLOBALS.YES;
4355: END IF;
4356:

Line 4354: x_result := OE_PC_GLOBALS.YES;

4350: );
4351:
4352: IF l_result = OE_PC_GLOBALS.YES THEN
4353: -- set OUT result to CONSTRAINED
4354: x_result := OE_PC_GLOBALS.YES;
4355: END IF;
4356:
4357: END IF;
4358:

Line 4368: IF l_result = OE_PC_GLOBALS.YES THEN

4364: ,p_record => l_rowtype_rec
4365: ,x_on_operation_action => l_on_operation_action
4366: );
4367:
4368: IF l_result = OE_PC_GLOBALS.YES THEN
4369: -- set OUT result to CONSTRAINED
4370: x_result := OE_PC_GLOBALS.YES;
4371: END IF;
4372:

Line 4370: x_result := OE_PC_GLOBALS.YES;

4366: );
4367:
4368: IF l_result = OE_PC_GLOBALS.YES THEN
4369: -- set OUT result to CONSTRAINED
4370: x_result := OE_PC_GLOBALS.YES;
4371: END IF;
4372:
4373: END IF;
4374:

Line 4384: IF l_result = OE_PC_GLOBALS.YES THEN

4380: ,p_record => l_rowtype_rec
4381: ,x_on_operation_action => l_on_operation_action
4382: );
4383:
4384: IF l_result = OE_PC_GLOBALS.YES THEN
4385: -- set OUT result to CONSTRAINED
4386: x_result := OE_PC_GLOBALS.YES;
4387: END IF;
4388:

Line 4386: x_result := OE_PC_GLOBALS.YES;

4382: );
4383:
4384: IF l_result = OE_PC_GLOBALS.YES THEN
4385: -- set OUT result to CONSTRAINED
4386: x_result := OE_PC_GLOBALS.YES;
4387: END IF;
4388:
4389: END IF;
4390:

Line 4400: IF l_result = OE_PC_GLOBALS.YES THEN

4396: ,p_record => l_rowtype_rec
4397: ,x_on_operation_action => l_on_operation_action
4398: );
4399:
4400: IF l_result = OE_PC_GLOBALS.YES THEN
4401: -- set OUT result to CONSTRAINED
4402: x_result := OE_PC_GLOBALS.YES;
4403: END IF;
4404:

Line 4402: x_result := OE_PC_GLOBALS.YES;

4398: );
4399:
4400: IF l_result = OE_PC_GLOBALS.YES THEN
4401: -- set OUT result to CONSTRAINED
4402: x_result := OE_PC_GLOBALS.YES;
4403: END IF;
4404:
4405: END IF;
4406:

Line 4416: IF l_result = OE_PC_GLOBALS.YES THEN

4412: ,p_record => l_rowtype_rec
4413: ,x_on_operation_action => l_on_operation_action
4414: );
4415:
4416: IF l_result = OE_PC_GLOBALS.YES THEN
4417: -- set OUT result to CONSTRAINED
4418: x_result := OE_PC_GLOBALS.YES;
4419: END IF;
4420:

Line 4418: x_result := OE_PC_GLOBALS.YES;

4414: );
4415:
4416: IF l_result = OE_PC_GLOBALS.YES THEN
4417: -- set OUT result to CONSTRAINED
4418: x_result := OE_PC_GLOBALS.YES;
4419: END IF;
4420:
4421: END IF;
4422:

Line 4432: IF l_result = OE_PC_GLOBALS.YES THEN

4428: ,p_record => l_rowtype_rec
4429: ,x_on_operation_action => l_on_operation_action
4430: );
4431:
4432: IF l_result = OE_PC_GLOBALS.YES THEN
4433: -- set OUT result to CONSTRAINED
4434: x_result := OE_PC_GLOBALS.YES;
4435: END IF;
4436:

Line 4434: x_result := OE_PC_GLOBALS.YES;

4430: );
4431:
4432: IF l_result = OE_PC_GLOBALS.YES THEN
4433: -- set OUT result to CONSTRAINED
4434: x_result := OE_PC_GLOBALS.YES;
4435: END IF;
4436:
4437: END IF;
4438:

Line 4449: IF l_result = OE_PC_GLOBALS.YES THEN

4445: ,p_record => l_rowtype_rec
4446: ,x_on_operation_action => l_on_operation_action
4447: );
4448:
4449: IF l_result = OE_PC_GLOBALS.YES THEN
4450: -- set OUT result to CONSTRAINED
4451: x_result := OE_PC_GLOBALS.YES;
4452: END IF;
4453:

Line 4451: x_result := OE_PC_GLOBALS.YES;

4447: );
4448:
4449: IF l_result = OE_PC_GLOBALS.YES THEN
4450: -- set OUT result to CONSTRAINED
4451: x_result := OE_PC_GLOBALS.YES;
4452: END IF;
4453:
4454: END IF;
4455:

Line 4466: IF l_result = OE_PC_GLOBALS.YES THEN

4462: ,p_record => l_rowtype_rec
4463: ,x_on_operation_action => l_on_operation_action
4464: );
4465:
4466: IF l_result = OE_PC_GLOBALS.YES THEN
4467: -- set OUT result to CONSTRAINED
4468: x_result := OE_PC_GLOBALS.YES;
4469: END IF;
4470:

Line 4468: x_result := OE_PC_GLOBALS.YES;

4464: );
4465:
4466: IF l_result = OE_PC_GLOBALS.YES THEN
4467: -- set OUT result to CONSTRAINED
4468: x_result := OE_PC_GLOBALS.YES;
4469: END IF;
4470:
4471: END IF;
4472:

Line 4482: IF l_result = OE_PC_GLOBALS.YES THEN

4478: ,p_record => l_rowtype_rec
4479: ,x_on_operation_action => l_on_operation_action
4480: );
4481:
4482: IF l_result = OE_PC_GLOBALS.YES THEN
4483: -- set OUT result to CONSTRAINED
4484: x_result := OE_PC_GLOBALS.YES;
4485: END IF;
4486:

Line 4484: x_result := OE_PC_GLOBALS.YES;

4480: );
4481:
4482: IF l_result = OE_PC_GLOBALS.YES THEN
4483: -- set OUT result to CONSTRAINED
4484: x_result := OE_PC_GLOBALS.YES;
4485: END IF;
4486:
4487: END IF;
4488:

Line 4498: IF l_result = OE_PC_GLOBALS.YES THEN

4494: ,p_record => l_rowtype_rec
4495: ,x_on_operation_action => l_on_operation_action
4496: );
4497:
4498: IF l_result = OE_PC_GLOBALS.YES THEN
4499: -- set OUT result to CONSTRAINED
4500: x_result := OE_PC_GLOBALS.YES;
4501: END IF;
4502:

Line 4500: x_result := OE_PC_GLOBALS.YES;

4496: );
4497:
4498: IF l_result = OE_PC_GLOBALS.YES THEN
4499: -- set OUT result to CONSTRAINED
4500: x_result := OE_PC_GLOBALS.YES;
4501: END IF;
4502:
4503: END IF;
4504:

Line 4515: IF l_result = OE_PC_GLOBALS.YES THEN

4511: ,p_record => l_rowtype_rec
4512: ,x_on_operation_action => l_on_operation_action
4513: );
4514:
4515: IF l_result = OE_PC_GLOBALS.YES THEN
4516: -- set OUT result to CONSTRAINED
4517: x_result := OE_PC_GLOBALS.YES;
4518: END IF;
4519:

Line 4517: x_result := OE_PC_GLOBALS.YES;

4513: );
4514:
4515: IF l_result = OE_PC_GLOBALS.YES THEN
4516: -- set OUT result to CONSTRAINED
4517: x_result := OE_PC_GLOBALS.YES;
4518: END IF;
4519:
4520: END IF;
4521:

Line 4533: IF l_result = OE_PC_GLOBALS.YES THEN

4529: ,p_record => l_rowtype_rec
4530: ,x_on_operation_action => l_on_operation_action
4531: );
4532:
4533: IF l_result = OE_PC_GLOBALS.YES THEN
4534: -- set OUT result to CONSTRAINED
4535: x_result := OE_PC_GLOBALS.YES;
4536: END IF;
4537:

Line 4535: x_result := OE_PC_GLOBALS.YES;

4531: );
4532:
4533: IF l_result = OE_PC_GLOBALS.YES THEN
4534: -- set OUT result to CONSTRAINED
4535: x_result := OE_PC_GLOBALS.YES;
4536: END IF;
4537:
4538: END IF;
4539:

Line 4550: IF l_result = OE_PC_GLOBALS.YES THEN

4546: ,p_record => l_rowtype_rec
4547: ,x_on_operation_action => l_on_operation_action
4548: );
4549:
4550: IF l_result = OE_PC_GLOBALS.YES THEN
4551: -- set OUT result to CONSTRAINED
4552: x_result := OE_PC_GLOBALS.YES;
4553: END IF;
4554:

Line 4552: x_result := OE_PC_GLOBALS.YES;

4548: );
4549:
4550: IF l_result = OE_PC_GLOBALS.YES THEN
4551: -- set OUT result to CONSTRAINED
4552: x_result := OE_PC_GLOBALS.YES;
4553: END IF;
4554:
4555: END IF;
4556:

Line 4567: IF l_result = OE_PC_GLOBALS.YES THEN

4563: ,p_record => l_rowtype_rec
4564: ,x_on_operation_action => l_on_operation_action
4565: );
4566:
4567: IF l_result = OE_PC_GLOBALS.YES THEN
4568: -- set OUT result to CONSTRAINED
4569: x_result := OE_PC_GLOBALS.YES;
4570: END IF;
4571:

Line 4569: x_result := OE_PC_GLOBALS.YES;

4565: );
4566:
4567: IF l_result = OE_PC_GLOBALS.YES THEN
4568: -- set OUT result to CONSTRAINED
4569: x_result := OE_PC_GLOBALS.YES;
4570: END IF;
4571:
4572: END IF;
4573:

Line 4583: IF l_result = OE_PC_GLOBALS.YES THEN

4579: ,p_record => l_rowtype_rec
4580: ,x_on_operation_action => l_on_operation_action
4581: );
4582:
4583: IF l_result = OE_PC_GLOBALS.YES THEN
4584: -- set OUT result to CONSTRAINED
4585: x_result := OE_PC_GLOBALS.YES;
4586: END IF;
4587:

Line 4585: x_result := OE_PC_GLOBALS.YES;

4581: );
4582:
4583: IF l_result = OE_PC_GLOBALS.YES THEN
4584: -- set OUT result to CONSTRAINED
4585: x_result := OE_PC_GLOBALS.YES;
4586: END IF;
4587:
4588: END IF;
4589:

Line 4600: IF l_result = OE_PC_GLOBALS.YES THEN

4596: ,p_record => l_rowtype_rec
4597: ,x_on_operation_action => l_on_operation_action
4598: );
4599:
4600: IF l_result = OE_PC_GLOBALS.YES THEN
4601: -- set OUT result to CONSTRAINED
4602: x_result := OE_PC_GLOBALS.YES;
4603: END IF;
4604:

Line 4602: x_result := OE_PC_GLOBALS.YES;

4598: );
4599:
4600: IF l_result = OE_PC_GLOBALS.YES THEN
4601: -- set OUT result to CONSTRAINED
4602: x_result := OE_PC_GLOBALS.YES;
4603: END IF;
4604:
4605: END IF;
4606:

Line 4616: IF l_result = OE_PC_GLOBALS.YES THEN

4612: ,p_record => l_rowtype_rec
4613: ,x_on_operation_action => l_on_operation_action
4614: );
4615:
4616: IF l_result = OE_PC_GLOBALS.YES THEN
4617: -- set OUT result to CONSTRAINED
4618: x_result := OE_PC_GLOBALS.YES;
4619: END IF;
4620:

Line 4618: x_result := OE_PC_GLOBALS.YES;

4614: );
4615:
4616: IF l_result = OE_PC_GLOBALS.YES THEN
4617: -- set OUT result to CONSTRAINED
4618: x_result := OE_PC_GLOBALS.YES;
4619: END IF;
4620:
4621: END IF;
4622:

Line 4632: IF l_result = OE_PC_GLOBALS.YES THEN

4628: ,p_record => l_rowtype_rec
4629: ,x_on_operation_action => l_on_operation_action
4630: );
4631:
4632: IF l_result = OE_PC_GLOBALS.YES THEN
4633: -- set OUT result to CONSTRAINED
4634: x_result := OE_PC_GLOBALS.YES;
4635: END IF;
4636:

Line 4634: x_result := OE_PC_GLOBALS.YES;

4630: );
4631:
4632: IF l_result = OE_PC_GLOBALS.YES THEN
4633: -- set OUT result to CONSTRAINED
4634: x_result := OE_PC_GLOBALS.YES;
4635: END IF;
4636:
4637: END IF;
4638:

Line 4648: IF l_result = OE_PC_GLOBALS.YES THEN

4644: ,p_record => l_rowtype_rec
4645: ,x_on_operation_action => l_on_operation_action
4646: );
4647:
4648: IF l_result = OE_PC_GLOBALS.YES THEN
4649: -- set OUT result to CONSTRAINED
4650: x_result := OE_PC_GLOBALS.YES;
4651: END IF;
4652:

Line 4650: x_result := OE_PC_GLOBALS.YES;

4646: );
4647:
4648: IF l_result = OE_PC_GLOBALS.YES THEN
4649: -- set OUT result to CONSTRAINED
4650: x_result := OE_PC_GLOBALS.YES;
4651: END IF;
4652:
4653: END IF;
4654:

Line 4664: IF l_result = OE_PC_GLOBALS.YES THEN

4660: ,p_record => l_rowtype_rec
4661: ,x_on_operation_action => l_on_operation_action
4662: );
4663:
4664: IF l_result = OE_PC_GLOBALS.YES THEN
4665: -- set OUT result to CONSTRAINED
4666: x_result := OE_PC_GLOBALS.YES;
4667: END IF;
4668:

Line 4666: x_result := OE_PC_GLOBALS.YES;

4662: );
4663:
4664: IF l_result = OE_PC_GLOBALS.YES THEN
4665: -- set OUT result to CONSTRAINED
4666: x_result := OE_PC_GLOBALS.YES;
4667: END IF;
4668:
4669: END IF;
4670:

Line 4680: IF l_result = OE_PC_GLOBALS.YES THEN

4676: ,p_record => l_rowtype_rec
4677: ,x_on_operation_action => l_on_operation_action
4678: );
4679:
4680: IF l_result = OE_PC_GLOBALS.YES THEN
4681: -- set OUT result to CONSTRAINED
4682: x_result := OE_PC_GLOBALS.YES;
4683: END IF;
4684:

Line 4682: x_result := OE_PC_GLOBALS.YES;

4678: );
4679:
4680: IF l_result = OE_PC_GLOBALS.YES THEN
4681: -- set OUT result to CONSTRAINED
4682: x_result := OE_PC_GLOBALS.YES;
4683: END IF;
4684:
4685: END IF;
4686:

Line 4696: IF l_result = OE_PC_GLOBALS.YES THEN

4692: ,p_record => l_rowtype_rec
4693: ,x_on_operation_action => l_on_operation_action
4694: );
4695:
4696: IF l_result = OE_PC_GLOBALS.YES THEN
4697: -- set OUT result to CONSTRAINED
4698: x_result := OE_PC_GLOBALS.YES;
4699: END IF;
4700:

Line 4698: x_result := OE_PC_GLOBALS.YES;

4694: );
4695:
4696: IF l_result = OE_PC_GLOBALS.YES THEN
4697: -- set OUT result to CONSTRAINED
4698: x_result := OE_PC_GLOBALS.YES;
4699: END IF;
4700:
4701: END IF;
4702:

Line 4712: IF l_result = OE_PC_GLOBALS.YES THEN

4708: ,p_record => l_rowtype_rec
4709: ,x_on_operation_action => l_on_operation_action
4710: );
4711:
4712: IF l_result = OE_PC_GLOBALS.YES THEN
4713: -- set OUT result to CONSTRAINED
4714: x_result := OE_PC_GLOBALS.YES;
4715: END IF;
4716:

Line 4714: x_result := OE_PC_GLOBALS.YES;

4710: );
4711:
4712: IF l_result = OE_PC_GLOBALS.YES THEN
4713: -- set OUT result to CONSTRAINED
4714: x_result := OE_PC_GLOBALS.YES;
4715: END IF;
4716:
4717: END IF;
4718:

Line 4728: IF l_result = OE_PC_GLOBALS.YES THEN

4724: ,p_record => l_rowtype_rec
4725: ,x_on_operation_action => l_on_operation_action
4726: );
4727:
4728: IF l_result = OE_PC_GLOBALS.YES THEN
4729: -- set OUT result to CONSTRAINED
4730: x_result := OE_PC_GLOBALS.YES;
4731: END IF;
4732:

Line 4730: x_result := OE_PC_GLOBALS.YES;

4726: );
4727:
4728: IF l_result = OE_PC_GLOBALS.YES THEN
4729: -- set OUT result to CONSTRAINED
4730: x_result := OE_PC_GLOBALS.YES;
4731: END IF;
4732:
4733: END IF;
4734:

Line 4744: IF l_result = OE_PC_GLOBALS.YES THEN

4740: ,p_record => l_rowtype_rec
4741: ,x_on_operation_action => l_on_operation_action
4742: );
4743:
4744: IF l_result = OE_PC_GLOBALS.YES THEN
4745: -- set OUT result to CONSTRAINED
4746: x_result := OE_PC_GLOBALS.YES;
4747: END IF;
4748:

Line 4746: x_result := OE_PC_GLOBALS.YES;

4742: );
4743:
4744: IF l_result = OE_PC_GLOBALS.YES THEN
4745: -- set OUT result to CONSTRAINED
4746: x_result := OE_PC_GLOBALS.YES;
4747: END IF;
4748:
4749: END IF;
4750:

Line 4760: IF l_result = OE_PC_GLOBALS.YES THEN

4756: ,p_record => l_rowtype_rec
4757: ,x_on_operation_action => l_on_operation_action
4758: );
4759:
4760: IF l_result = OE_PC_GLOBALS.YES THEN
4761: -- set OUT result to CONSTRAINED
4762: x_result := OE_PC_GLOBALS.YES;
4763: END IF;
4764:

Line 4762: x_result := OE_PC_GLOBALS.YES;

4758: );
4759:
4760: IF l_result = OE_PC_GLOBALS.YES THEN
4761: -- set OUT result to CONSTRAINED
4762: x_result := OE_PC_GLOBALS.YES;
4763: END IF;
4764:
4765: END IF;
4766:

Line 4776: IF l_result = OE_PC_GLOBALS.YES THEN

4772: ,p_record => l_rowtype_rec
4773: ,x_on_operation_action => l_on_operation_action
4774: );
4775:
4776: IF l_result = OE_PC_GLOBALS.YES THEN
4777: -- set OUT result to CONSTRAINED
4778: x_result := OE_PC_GLOBALS.YES;
4779: END IF;
4780:

Line 4778: x_result := OE_PC_GLOBALS.YES;

4774: );
4775:
4776: IF l_result = OE_PC_GLOBALS.YES THEN
4777: -- set OUT result to CONSTRAINED
4778: x_result := OE_PC_GLOBALS.YES;
4779: END IF;
4780:
4781: END IF;
4782:

Line 4792: IF l_result = OE_PC_GLOBALS.YES THEN

4788: ,p_record => l_rowtype_rec
4789: ,x_on_operation_action => l_on_operation_action
4790: );
4791:
4792: IF l_result = OE_PC_GLOBALS.YES THEN
4793: -- set OUT result to CONSTRAINED
4794: x_result := OE_PC_GLOBALS.YES;
4795: END IF;
4796:

Line 4794: x_result := OE_PC_GLOBALS.YES;

4790: );
4791:
4792: IF l_result = OE_PC_GLOBALS.YES THEN
4793: -- set OUT result to CONSTRAINED
4794: x_result := OE_PC_GLOBALS.YES;
4795: END IF;
4796:
4797: END IF;
4798:

Line 4808: IF l_result = OE_PC_GLOBALS.YES THEN

4804: ,p_record => l_rowtype_rec
4805: ,x_on_operation_action => l_on_operation_action
4806: );
4807:
4808: IF l_result = OE_PC_GLOBALS.YES THEN
4809: -- set OUT result to CONSTRAINED
4810: x_result := OE_PC_GLOBALS.YES;
4811: END IF;
4812:

Line 4810: x_result := OE_PC_GLOBALS.YES;

4806: );
4807:
4808: IF l_result = OE_PC_GLOBALS.YES THEN
4809: -- set OUT result to CONSTRAINED
4810: x_result := OE_PC_GLOBALS.YES;
4811: END IF;
4812:
4813: END IF;
4814:

Line 4824: IF l_result = OE_PC_GLOBALS.YES THEN

4820: ,p_record => l_rowtype_rec
4821: ,x_on_operation_action => l_on_operation_action
4822: );
4823:
4824: IF l_result = OE_PC_GLOBALS.YES THEN
4825: -- set OUT result to CONSTRAINED
4826: x_result := OE_PC_GLOBALS.YES;
4827: END IF;
4828:

Line 4826: x_result := OE_PC_GLOBALS.YES;

4822: );
4823:
4824: IF l_result = OE_PC_GLOBALS.YES THEN
4825: -- set OUT result to CONSTRAINED
4826: x_result := OE_PC_GLOBALS.YES;
4827: END IF;
4828:
4829: END IF;
4830:

Line 4840: IF l_result = OE_PC_GLOBALS.YES THEN

4836: ,p_record => l_rowtype_rec
4837: ,x_on_operation_action => l_on_operation_action
4838: );
4839:
4840: IF l_result = OE_PC_GLOBALS.YES THEN
4841: -- set OUT result to CONSTRAINED
4842: x_result := OE_PC_GLOBALS.YES;
4843: END IF;
4844:

Line 4842: x_result := OE_PC_GLOBALS.YES;

4838: );
4839:
4840: IF l_result = OE_PC_GLOBALS.YES THEN
4841: -- set OUT result to CONSTRAINED
4842: x_result := OE_PC_GLOBALS.YES;
4843: END IF;
4844:
4845: END IF;
4846:

Line 4857: IF l_result = OE_PC_GLOBALS.YES THEN

4853: ,p_record => l_rowtype_rec
4854: ,x_on_operation_action => l_on_operation_action
4855: );
4856:
4857: IF l_result = OE_PC_GLOBALS.YES THEN
4858: -- set OUT result to CONSTRAINED
4859: x_result := OE_PC_GLOBALS.YES;
4860: END IF;
4861:

Line 4859: x_result := OE_PC_GLOBALS.YES;

4855: );
4856:
4857: IF l_result = OE_PC_GLOBALS.YES THEN
4858: -- set OUT result to CONSTRAINED
4859: x_result := OE_PC_GLOBALS.YES;
4860: END IF;
4861:
4862: END IF;
4863:

Line 4873: IF l_result = OE_PC_GLOBALS.YES THEN

4869: ,p_record => l_rowtype_rec
4870: ,x_on_operation_action => l_on_operation_action
4871: );
4872:
4873: IF l_result = OE_PC_GLOBALS.YES THEN
4874: -- set OUT result to CONSTRAINED
4875: x_result := OE_PC_GLOBALS.YES;
4876: END IF;
4877:

Line 4875: x_result := OE_PC_GLOBALS.YES;

4871: );
4872:
4873: IF l_result = OE_PC_GLOBALS.YES THEN
4874: -- set OUT result to CONSTRAINED
4875: x_result := OE_PC_GLOBALS.YES;
4876: END IF;
4877:
4878: END IF;
4879: -- END: Blankets Code Merge

Line 4913: IF l_result = OE_PC_GLOBALS.YES THEN

4909: l_result := calculate_price_flag(p_operation => l_operation
4910: ,p_record => l_rowtype_rec
4911: ,x_on_operation_action => l_on_operation_action);
4912:
4913: IF l_result = OE_PC_GLOBALS.YES THEN
4914: -- set OUT result to CONSTRAINED
4915: x_result := OE_PC_GLOBALS.YES;
4916: END IF;
4917: END IF;

Line 4915: x_result := OE_PC_GLOBALS.YES;

4911: ,x_on_operation_action => l_on_operation_action);
4912:
4913: IF l_result = OE_PC_GLOBALS.YES THEN
4914: -- set OUT result to CONSTRAINED
4915: x_result := OE_PC_GLOBALS.YES;
4916: END IF;
4917: END IF;
4918:
4919: IF p_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR THEN

Line 4929: IF l_result = OE_PC_GLOBALS.YES THEN

4925: ,p_record => l_rowtype_rec
4926: ,x_on_operation_action => l_on_operation_action
4927: );
4928:
4929: IF l_result = OE_PC_GLOBALS.YES THEN
4930: -- set OUT result to CONSTRAINED
4931: x_result := OE_PC_GLOBALS.YES;
4932: END IF;
4933:

Line 4931: x_result := OE_PC_GLOBALS.YES;

4927: );
4928:
4929: IF l_result = OE_PC_GLOBALS.YES THEN
4930: -- set OUT result to CONSTRAINED
4931: x_result := OE_PC_GLOBALS.YES;
4932: END IF;
4933:
4934: END IF;
4935:

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

4945: -- updated and profile was set to 'N', global at the end should
4946: -- be re-set to 'Y' - this indicates to process order that no
4947: -- constrainable attributes were updated and thus, it would
4948: -- suppress entity level security check also.
4949: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
4950: l_check_all_cols_constraint := g_check_all_cols_constraint;
4951: g_check_all_cols_constraint := 'N';
4952: END IF;
4953:

Line 4963: IF l_result = OE_PC_GLOBALS.YES THEN

4959: ,p_record => l_rowtype_rec
4960: ,x_on_operation_action => l_on_operation_action
4961: );
4962:
4963: IF l_result = OE_PC_GLOBALS.YES THEN
4964: -- set OUT result to CONSTRAINED
4965: x_result := OE_PC_GLOBALS.YES;
4966: END IF;
4967:

Line 4965: x_result := OE_PC_GLOBALS.YES;

4961: );
4962:
4963: IF l_result = OE_PC_GLOBALS.YES THEN
4964: -- set OUT result to CONSTRAINED
4965: x_result := OE_PC_GLOBALS.YES;
4966: END IF;
4967:
4968: END IF;
4969:

Line 4979: IF l_result = OE_PC_GLOBALS.YES THEN

4975: ,p_record => l_rowtype_rec
4976: ,x_on_operation_action => l_on_operation_action
4977: );
4978:
4979: IF l_result = OE_PC_GLOBALS.YES THEN
4980: -- set OUT result to CONSTRAINED
4981: x_result := OE_PC_GLOBALS.YES;
4982: END IF;
4983:

Line 4981: x_result := OE_PC_GLOBALS.YES;

4977: );
4978:
4979: IF l_result = OE_PC_GLOBALS.YES THEN
4980: -- set OUT result to CONSTRAINED
4981: x_result := OE_PC_GLOBALS.YES;
4982: END IF;
4983:
4984: END IF;
4985:

Line 4995: IF l_result = OE_PC_GLOBALS.YES THEN

4991: ,p_record => l_rowtype_rec
4992: ,x_on_operation_action => l_on_operation_action
4993: );
4994:
4995: IF l_result = OE_PC_GLOBALS.YES THEN
4996: -- set OUT result to CONSTRAINED
4997: x_result := OE_PC_GLOBALS.YES;
4998: END IF;
4999:

Line 4997: x_result := OE_PC_GLOBALS.YES;

4993: );
4994:
4995: IF l_result = OE_PC_GLOBALS.YES THEN
4996: -- set OUT result to CONSTRAINED
4997: x_result := OE_PC_GLOBALS.YES;
4998: END IF;
4999:
5000: END IF;
5001:

Line 5011: IF l_result = OE_PC_GLOBALS.YES THEN

5007: ,p_record => l_rowtype_rec
5008: ,x_on_operation_action => l_on_operation_action
5009: );
5010:
5011: IF l_result = OE_PC_GLOBALS.YES THEN
5012: -- set OUT result to CONSTRAINED
5013: x_result := OE_PC_GLOBALS.YES;
5014: END IF;
5015:

Line 5013: x_result := OE_PC_GLOBALS.YES;

5009: );
5010:
5011: IF l_result = OE_PC_GLOBALS.YES THEN
5012: -- set OUT result to CONSTRAINED
5013: x_result := OE_PC_GLOBALS.YES;
5014: END IF;
5015:
5016: END IF;
5017:

Line 5027: IF l_result = OE_PC_GLOBALS.YES THEN

5023: ,p_record => l_rowtype_rec
5024: ,x_on_operation_action => l_on_operation_action
5025: );
5026:
5027: IF l_result = OE_PC_GLOBALS.YES THEN
5028: -- set OUT result to CONSTRAINED
5029: x_result := OE_PC_GLOBALS.YES;
5030: END IF;
5031:

Line 5029: x_result := OE_PC_GLOBALS.YES;

5025: );
5026:
5027: IF l_result = OE_PC_GLOBALS.YES THEN
5028: -- set OUT result to CONSTRAINED
5029: x_result := OE_PC_GLOBALS.YES;
5030: END IF;
5031:
5032: END IF;
5033:

Line 5043: IF l_result = OE_PC_GLOBALS.YES THEN

5039: ,p_record => l_rowtype_rec
5040: ,x_on_operation_action => l_on_operation_action
5041: );
5042:
5043: IF l_result = OE_PC_GLOBALS.YES THEN
5044: -- set OUT result to CONSTRAINED
5045: x_result := OE_PC_GLOBALS.YES;
5046: END IF;
5047:

Line 5045: x_result := OE_PC_GLOBALS.YES;

5041: );
5042:
5043: IF l_result = OE_PC_GLOBALS.YES THEN
5044: -- set OUT result to CONSTRAINED
5045: x_result := OE_PC_GLOBALS.YES;
5046: END IF;
5047:
5048: END IF;
5049:

Line 5059: IF l_result = OE_PC_GLOBALS.YES THEN

5055: ,p_record => l_rowtype_rec
5056: ,x_on_operation_action => l_on_operation_action
5057: );
5058:
5059: IF l_result = OE_PC_GLOBALS.YES THEN
5060: -- set OUT result to CONSTRAINED
5061: x_result := OE_PC_GLOBALS.YES;
5062: END IF;
5063:

Line 5061: x_result := OE_PC_GLOBALS.YES;

5057: );
5058:
5059: IF l_result = OE_PC_GLOBALS.YES THEN
5060: -- set OUT result to CONSTRAINED
5061: x_result := OE_PC_GLOBALS.YES;
5062: END IF;
5063:
5064: END IF;
5065:

Line 5075: IF l_result = OE_PC_GLOBALS.YES THEN

5071: ,p_record => l_rowtype_rec
5072: ,x_on_operation_action => l_on_operation_action
5073: );
5074:
5075: IF l_result = OE_PC_GLOBALS.YES THEN
5076: -- set OUT result to CONSTRAINED
5077: x_result := OE_PC_GLOBALS.YES;
5078: END IF;
5079:

Line 5077: x_result := OE_PC_GLOBALS.YES;

5073: );
5074:
5075: IF l_result = OE_PC_GLOBALS.YES THEN
5076: -- set OUT result to CONSTRAINED
5077: x_result := OE_PC_GLOBALS.YES;
5078: END IF;
5079:
5080: END IF;
5081:

Line 5093: IF l_result = OE_PC_GLOBALS.YES THEN

5089: ,p_record => l_rowtype_rec
5090: ,x_on_operation_action => l_on_operation_action
5091: );
5092:
5093: IF l_result = OE_PC_GLOBALS.YES THEN
5094: -- set OUT result to CONSTRAINED
5095: x_result := OE_PC_GLOBALS.YES;
5096: END IF;
5097:

Line 5095: x_result := OE_PC_GLOBALS.YES;

5091: );
5092:
5093: IF l_result = OE_PC_GLOBALS.YES THEN
5094: -- set OUT result to CONSTRAINED
5095: x_result := OE_PC_GLOBALS.YES;
5096: END IF;
5097:
5098: END IF;
5099:

Line 5109: IF l_result = OE_PC_GLOBALS.YES THEN

5105: ,p_record => l_rowtype_rec
5106: ,x_on_operation_action => l_on_operation_action
5107: );
5108:
5109: IF l_result = OE_PC_GLOBALS.YES THEN
5110: -- set OUT result to CONSTRAINED
5111: x_result := OE_PC_GLOBALS.YES;
5112: END IF;
5113:

Line 5111: x_result := OE_PC_GLOBALS.YES;

5107: );
5108:
5109: IF l_result = OE_PC_GLOBALS.YES THEN
5110: -- set OUT result to CONSTRAINED
5111: x_result := OE_PC_GLOBALS.YES;
5112: END IF;
5113:
5114: END IF;
5115:

Line 5125: IF l_result = OE_PC_GLOBALS.YES THEN

5121: ,p_record => l_rowtype_rec
5122: ,x_on_operation_action => l_on_operation_action
5123: );
5124:
5125: IF l_result = OE_PC_GLOBALS.YES THEN
5126: -- set OUT result to CONSTRAINED
5127: x_result := OE_PC_GLOBALS.YES;
5128: END IF;
5129:

Line 5127: x_result := OE_PC_GLOBALS.YES;

5123: );
5124:
5125: IF l_result = OE_PC_GLOBALS.YES THEN
5126: -- set OUT result to CONSTRAINED
5127: x_result := OE_PC_GLOBALS.YES;
5128: END IF;
5129:
5130: END IF;
5131:

Line 5141: IF l_result = OE_PC_GLOBALS.YES THEN

5137: ,p_record => l_rowtype_rec
5138: ,x_on_operation_action => l_on_operation_action
5139: );
5140:
5141: IF l_result = OE_PC_GLOBALS.YES THEN
5142: -- set OUT result to CONSTRAINED
5143: x_result := OE_PC_GLOBALS.YES;
5144: END IF;
5145:

Line 5143: x_result := OE_PC_GLOBALS.YES;

5139: );
5140:
5141: IF l_result = OE_PC_GLOBALS.YES THEN
5142: -- set OUT result to CONSTRAINED
5143: x_result := OE_PC_GLOBALS.YES;
5144: END IF;
5145:
5146: END IF;
5147:

Line 5157: IF l_result = OE_PC_GLOBALS.YES THEN

5153: ,p_record => l_rowtype_rec
5154: ,x_on_operation_action => l_on_operation_action
5155: );
5156:
5157: IF l_result = OE_PC_GLOBALS.YES THEN
5158: -- set OUT result to CONSTRAINED
5159: x_result := OE_PC_GLOBALS.YES;
5160: END IF;
5161:

Line 5159: x_result := OE_PC_GLOBALS.YES;

5155: );
5156:
5157: IF l_result = OE_PC_GLOBALS.YES THEN
5158: -- set OUT result to CONSTRAINED
5159: x_result := OE_PC_GLOBALS.YES;
5160: END IF;
5161:
5162: END IF;
5163:

Line 5174: IF l_result = OE_PC_GLOBALS.YES THEN

5170: ,p_record => l_rowtype_rec
5171: ,x_on_operation_action => l_on_operation_action
5172: );
5173:
5174: IF l_result = OE_PC_GLOBALS.YES THEN
5175: -- set OUT result to CONSTRAINED
5176: x_result := OE_PC_GLOBALS.YES;
5177: END IF;
5178:

Line 5176: x_result := OE_PC_GLOBALS.YES;

5172: );
5173:
5174: IF l_result = OE_PC_GLOBALS.YES THEN
5175: -- set OUT result to CONSTRAINED
5176: x_result := OE_PC_GLOBALS.YES;
5177: END IF;
5178:
5179: END IF;
5180:

Line 5192: IF l_result = OE_PC_GLOBALS.YES THEN

5188: ,p_record => l_rowtype_rec
5189: ,x_on_operation_action => l_on_operation_action
5190: );
5191:
5192: IF l_result = OE_PC_GLOBALS.YES THEN
5193: -- set OUT result to CONSTRAINED
5194: x_result := OE_PC_GLOBALS.YES;
5195: END IF;
5196:

Line 5194: x_result := OE_PC_GLOBALS.YES;

5190: );
5191:
5192: IF l_result = OE_PC_GLOBALS.YES THEN
5193: -- set OUT result to CONSTRAINED
5194: x_result := OE_PC_GLOBALS.YES;
5195: END IF;
5196:
5197: END IF;
5198:

Line 5208: IF l_result = OE_PC_GLOBALS.YES THEN

5204: ,p_record => l_rowtype_rec
5205: ,x_on_operation_action => l_on_operation_action
5206: );
5207:
5208: IF l_result = OE_PC_GLOBALS.YES THEN
5209: -- set OUT result to CONSTRAINED
5210: x_result := OE_PC_GLOBALS.YES;
5211: END IF;
5212:

Line 5210: x_result := OE_PC_GLOBALS.YES;

5206: );
5207:
5208: IF l_result = OE_PC_GLOBALS.YES THEN
5209: -- set OUT result to CONSTRAINED
5210: x_result := OE_PC_GLOBALS.YES;
5211: END IF;
5212:
5213: END IF;
5214:

Line 5224: IF l_result = OE_PC_GLOBALS.YES THEN

5220: ,p_record => l_rowtype_rec
5221: ,x_on_operation_action => l_on_operation_action
5222: );
5223:
5224: IF l_result = OE_PC_GLOBALS.YES THEN
5225: -- set OUT result to CONSTRAINED
5226: x_result := OE_PC_GLOBALS.YES;
5227: END IF;
5228:

Line 5226: x_result := OE_PC_GLOBALS.YES;

5222: );
5223:
5224: IF l_result = OE_PC_GLOBALS.YES THEN
5225: -- set OUT result to CONSTRAINED
5226: x_result := OE_PC_GLOBALS.YES;
5227: END IF;
5228:
5229: END IF;
5230:

Line 5240: IF l_result = OE_PC_GLOBALS.YES THEN

5236: ,p_record => l_rowtype_rec
5237: ,x_on_operation_action => l_on_operation_action
5238: );
5239:
5240: IF l_result = OE_PC_GLOBALS.YES THEN
5241: -- set OUT result to CONSTRAINED
5242: x_result := OE_PC_GLOBALS.YES;
5243: END IF;
5244:

Line 5242: x_result := OE_PC_GLOBALS.YES;

5238: );
5239:
5240: IF l_result = OE_PC_GLOBALS.YES THEN
5241: -- set OUT result to CONSTRAINED
5242: x_result := OE_PC_GLOBALS.YES;
5243: END IF;
5244:
5245: END IF;
5246:

Line 5256: IF l_result = OE_PC_GLOBALS.YES THEN

5252: ,p_record => l_rowtype_rec
5253: ,x_on_operation_action => l_on_operation_action
5254: );
5255:
5256: IF l_result = OE_PC_GLOBALS.YES THEN
5257: -- set OUT result to CONSTRAINED
5258: x_result := OE_PC_GLOBALS.YES;
5259: END IF;
5260:

Line 5258: x_result := OE_PC_GLOBALS.YES;

5254: );
5255:
5256: IF l_result = OE_PC_GLOBALS.YES THEN
5257: -- set OUT result to CONSTRAINED
5258: x_result := OE_PC_GLOBALS.YES;
5259: END IF;
5260:
5261: END IF;
5262:

Line 5272: IF l_result = OE_PC_GLOBALS.YES THEN

5268: ,p_record => l_rowtype_rec
5269: ,x_on_operation_action => l_on_operation_action
5270: );
5271:
5272: IF l_result = OE_PC_GLOBALS.YES THEN
5273: -- set OUT result to CONSTRAINED
5274: x_result := OE_PC_GLOBALS.YES;
5275: END IF;
5276:

Line 5274: x_result := OE_PC_GLOBALS.YES;

5270: );
5271:
5272: IF l_result = OE_PC_GLOBALS.YES THEN
5273: -- set OUT result to CONSTRAINED
5274: x_result := OE_PC_GLOBALS.YES;
5275: END IF;
5276:
5277: END IF;
5278:

Line 5288: IF l_result = OE_PC_GLOBALS.YES THEN

5284: ,p_record => l_rowtype_rec
5285: ,x_on_operation_action => l_on_operation_action
5286: );
5287:
5288: IF l_result = OE_PC_GLOBALS.YES THEN
5289: -- set OUT result to CONSTRAINED
5290: x_result := OE_PC_GLOBALS.YES;
5291: END IF;
5292:

Line 5290: x_result := OE_PC_GLOBALS.YES;

5286: );
5287:
5288: IF l_result = OE_PC_GLOBALS.YES THEN
5289: -- set OUT result to CONSTRAINED
5290: x_result := OE_PC_GLOBALS.YES;
5291: END IF;
5292:
5293: END IF;
5294:

Line 5304: IF l_result = OE_PC_GLOBALS.YES THEN

5300: ,p_record => l_rowtype_rec
5301: ,x_on_operation_action => l_on_operation_action
5302: );
5303:
5304: IF l_result = OE_PC_GLOBALS.YES THEN
5305: -- set OUT result to CONSTRAINED
5306: x_result := OE_PC_GLOBALS.YES;
5307: END IF;
5308:

Line 5306: x_result := OE_PC_GLOBALS.YES;

5302: );
5303:
5304: IF l_result = OE_PC_GLOBALS.YES THEN
5305: -- set OUT result to CONSTRAINED
5306: x_result := OE_PC_GLOBALS.YES;
5307: END IF;
5308:
5309: END IF;
5310:

Line 5321: IF l_result = OE_PC_GLOBALS.YES THEN

5317: ,p_record => l_rowtype_rec
5318: ,x_on_operation_action => l_on_operation_action
5319: );
5320:
5321: IF l_result = OE_PC_GLOBALS.YES THEN
5322: -- set OUT result to CONSTRAINED
5323: x_result := OE_PC_GLOBALS.YES;
5324: END IF;
5325:

Line 5323: x_result := OE_PC_GLOBALS.YES;

5319: );
5320:
5321: IF l_result = OE_PC_GLOBALS.YES THEN
5322: -- set OUT result to CONSTRAINED
5323: x_result := OE_PC_GLOBALS.YES;
5324: END IF;
5325:
5326: END IF;
5327:

Line 5337: IF l_result = OE_PC_GLOBALS.YES THEN

5333: ,p_record => l_rowtype_rec
5334: ,x_on_operation_action => l_on_operation_action
5335: );
5336:
5337: IF l_result = OE_PC_GLOBALS.YES THEN
5338: -- set OUT result to CONSTRAINED
5339: x_result := OE_PC_GLOBALS.YES;
5340: END IF;
5341:

Line 5339: x_result := OE_PC_GLOBALS.YES;

5335: );
5336:
5337: IF l_result = OE_PC_GLOBALS.YES THEN
5338: -- set OUT result to CONSTRAINED
5339: x_result := OE_PC_GLOBALS.YES;
5340: END IF;
5341:
5342: END IF;
5343: /* Customer Acceptance - End */

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

5341:
5342: END IF;
5343: /* Customer Acceptance - End */
5344:
5345: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
5346: IF l_debug_level > 0 THEN
5347: oe_debug_pub.add('setting check all cols constraint to:'||l_check_all_cols_constraint);
5348: END IF;
5349: g_check_all_cols_constraint := l_check_all_cols_constraint;

Line 5378: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5374: END Attributes;
5375:
5376:
5377: FUNCTION IB_OWNER
5378: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5379: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5380: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5381: ) RETURN NUMBER
5382: IS

Line 5398: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5394: END IB_OWNER;
5395:
5396:
5397: FUNCTION IB_INSTALLED_AT_LOCATION
5398: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5399: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5400: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5401: ) RETURN NUMBER
5402: IS

Line 5417: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5413: RETURN(l_result);
5414: END IB_INSTALLED_AT_LOCATION;
5415:
5416: FUNCTION IB_CURRENT_LOCATION
5417: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5418: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5419: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5420: ) RETURN NUMBER
5421: IS

Line 5436: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5432: RETURN(l_result);
5433: END IB_CURRENT_LOCATION;
5434:
5435: FUNCTION END_CUSTOMER
5436: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5437: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5438: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5439: ) RETURN NUMBER
5440: IS

Line 5457: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5453: END END_CUSTOMER;
5454:
5455:
5456: FUNCTION END_CUSTOMER_SITE_USE
5457: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5458: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5459: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5460: ) RETURN NUMBER
5461: IS

Line 5478: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5474: END END_CUSTOMER_SITE_USE;
5475:
5476:
5477: FUNCTION END_CUSTOMER_CONTACT
5478: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5479: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5480: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5481: ) RETURN NUMBER
5482: IS

Line 5540: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5536: END IF;
5537: END ALLOW_TRX_LINE_EXEMPTIONS;
5538:
5539: FUNCTION CONTINGENCY
5540: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5541: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5542: , x_on_operation_action OUT NOCOPY NUMBER
5543: ) RETURN NUMBER
5544: IS

Line 5558: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5554:
5555: END CONTINGENCY;
5556:
5557: FUNCTION REVREC_EXPIRATION_DAYS
5558: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5559: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5560: , x_on_operation_action OUT NOCOPY NUMBER
5561: ) RETURN NUMBER
5562: IS