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 98: IF l_result = OE_PC_GLOBALS.YES THEN

94: END IF;
95:
96: -- Bug 8537214, Reason requirement to be set for operation actions .1,.5 and 1 only
97:
98: IF l_result = OE_PC_GLOBALS.YES THEN
99: IF x_on_operation_action IN (.1,.5,1) THEN
100: IF p_column_name = 'ORDERED_QUANTITY'
101: -- QUOTING change - set cancellation require reason flag only
102: -- for lines in fulfillment phase

Line 126: l_result = OE_PC_GLOBALS.YES And

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

Line 192: l_result = OE_PC_GLOBALS.YES And

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

Line 261: l_result = OE_PC_GLOBALS.YES And

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

Line 388: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 444: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 509: l_result := OE_PC_GLOBALS.NO;

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

Line 520: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 540: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

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

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

Line 577: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 596: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 616: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 638: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 659: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 679: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 699: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 719: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 739: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 760: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 781: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 801: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 821: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 841: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 861: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 881: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 901: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 921: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 941: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 961: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 981: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1001: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1021: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1041: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1062: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1058: END CONTEXT;
1059:
1060: --START 14272033
1061: FUNCTION RETURN_CONTEXT
1062: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1063: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1064: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1065: ) RETURN NUMBER
1066: IS

Line 1081: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1101: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1126: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1122:
1123: -- End of fix #1459428 for function definition
1124:
1125: FUNCTION CREATED_BY
1126: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1127: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1128: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1129: ) RETURN NUMBER
1130: IS

Line 1147: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1168: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1189: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1210: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1231: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1227: END CUST_PO_NUMBER;
1228:
1229: -- Added for bug #7608170
1230: FUNCTION CUSTOMER_JOB
1231: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1232: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1233: , x_on_operation_action OUT NOCOPY NUMBER
1234: ) RETURN NUMBER
1235: IS

Line 1252: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1248: END CUSTOMER_JOB; -- Bug 8508275
1249:
1250:
1251: FUNCTION DELIVERY_LEAD_TIME
1252: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1253: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1254: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1255: ) RETURN NUMBER
1256: IS

Line 1273: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1290: END DELIVER_TO_CONTACT;
1291:
1292:
1293: FUNCTION DELIVER_TO_ORG
1294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1295: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1296: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1297: ) RETURN NUMBER
1298: IS

Line 1315: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1311: END DELIVER_TO_ORG;
1312:
1313:
1314: FUNCTION DEMAND_CLASS
1315: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1316: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1317: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1318: ) RETURN NUMBER
1319: IS

Line 1336: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1332: END DEMAND_CLASS;
1333:
1334:
1335: FUNCTION DEP_PLAN_REQUIRED
1336: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1337: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1338: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1339: ) RETURN NUMBER
1340: IS

Line 1357: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1353: END DEP_PLAN_REQUIRED;
1354:
1355:
1356: FUNCTION EARLIEST_ACCEPTABLE_DATE
1357: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1358: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1359: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1360: ) RETURN NUMBER
1361: IS

Line 1377: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1398: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1419: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1440: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1461: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1483: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1479:
1480: -- INVCONV
1481:
1482: FUNCTION FULFILLED_QUANTITY2
1483: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1484: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1485: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1486: ) RETURN NUMBER
1487: IS

Line 1504: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1500: END FULFILLED_QUANTITY2;
1501:
1502:
1503: FUNCTION INVENTORY_ITEM
1504: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1505: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1506: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1507: ) RETURN NUMBER
1508: IS

Line 1524: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1520:
1521: END INVENTORY_ITEM;
1522:
1523: FUNCTION INVOICE_TO_CONTACT
1524: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1525: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1526: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1527: ) RETURN NUMBER
1528: IS

Line 1545: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1541: END INVOICE_TO_CONTACT;
1542:
1543:
1544: FUNCTION INVOICE_TO_ORG
1545: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1546: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1547: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1548: ) RETURN NUMBER
1549: IS

Line 1565: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1561:
1562: END INVOICE_TO_ORG;
1563:
1564: FUNCTION INVOICING_RULE
1565: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1566: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1567: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1568: ) RETURN NUMBER
1569: IS

Line 1585: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1606: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1627: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1648: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1644: END LATEST_ACCEPTABLE_DATE;
1645:
1646:
1647: FUNCTION LINE_CATEGORY
1648: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1649: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1650: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1651: ) RETURN NUMBER
1652: IS

Line 1669: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1665: END LINE_CATEGORY;
1666:
1667:
1668: FUNCTION LINE_NUMBER
1669: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1670: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1671: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1672: ) RETURN NUMBER
1673: IS

Line 1690: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1686: END LINE_NUMBER;
1687:
1688:
1689: FUNCTION LINE_TYPE
1690: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1691: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1692: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1693: ) RETURN NUMBER
1694: IS

Line 1711: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1707: END LINE_TYPE;
1708:
1709:
1710: FUNCTION ORDERED_QUANTITY
1711: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1712: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1713: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1714: ) RETURN NUMBER
1715: IS

Line 1723: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN

1719:
1720: -- to fix #2312158
1721: oe_sales_can_util.G_REQUIRE_REASON := FALSE;
1722:
1723: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
1724: SELECT Ordered_Quantity
1725: INTO l_old_qty
1726: FROM OE_ORDER_LINES
1727: WHERE line_id = p_record.line_id;

Line 1740: AND p_operation = OE_PC_GLOBALS.UPDATE_OP

1736: -- QUOTING change - check for cancellation constraint only for
1737: -- lines in fulfillment phase, ordered quantity reduction on
1738: -- quote lines should only check for quantity UPDATE constraints.
1739: IF NVL(p_record.transaction_phase_code,'F') = 'F'
1740: AND p_operation = OE_PC_GLOBALS.UPDATE_OP
1741: AND nvl(p_record.ordered_quantity,0) < nvl(l_old_qty,0)
1742: AND NOT(p_record.split_action_code IS NOT NULL AND
1743: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1744: l_result := ORDERED_QUANTITY

Line 1745: (p_operation => OE_PC_GLOBALS.CANCEL_OP

1741: AND nvl(p_record.ordered_quantity,0) < nvl(l_old_qty,0)
1742: AND NOT(p_record.split_action_code IS NOT NULL AND
1743: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1744: l_result := ORDERED_QUANTITY
1745: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1746: ,p_record => p_record
1747: ,x_on_operation_action => x_on_operation_action
1748: );
1749: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP

Line 1749: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP

1745: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1746: ,p_record => p_record
1747: ,x_on_operation_action => x_on_operation_action
1748: );
1749: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
1750: AND (p_record.split_action_code IS NOT NULL AND
1751: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1752: p_record.split_action_code = 'SPLIT') THEN
1753: l_result := ORDERED_QUANTITY

Line 1754: (p_operation => OE_PC_GLOBALS.SPLIT_OP

1750: AND (p_record.split_action_code IS NOT NULL AND
1751: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1752: p_record.split_action_code = 'SPLIT') THEN
1753: l_result := ORDERED_QUANTITY
1754: (p_operation => OE_PC_GLOBALS.SPLIT_OP
1755: ,p_record => p_record
1756: ,x_on_operation_action => x_on_operation_action
1757: );
1758: ELSE

Line 1774: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1770:
1771: -- OPM 1857167 start
1772:
1773: FUNCTION ORDERED_QUANTITY2
1774: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1775: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1776: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1777: ) RETURN NUMBER
1778: IS

Line 1783: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN

1779: l_result NUMBER;
1780: l_old_qty2 NUMBER;
1781: BEGIN
1782:
1783: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
1784: SELECT Ordered_Quantity2
1785: INTO l_old_qty2
1786: FROM OE_ORDER_LINES
1787: WHERE line_id = p_record.line_id;

Line 1791: IF p_operation = OE_PC_GLOBALS.UPDATE_OP

1787: WHERE line_id = p_record.line_id;
1788: END IF;
1789:
1790: -- CHECK CONSTRAINTS FOR CANCEL OPERATION IF QUANTITY IS REDUCED
1791: IF p_operation = OE_PC_GLOBALS.UPDATE_OP
1792: AND nvl(p_record.ordered_quantity2,0) < nvl(l_old_qty2,0)
1793: AND NOT(p_record.split_action_code IS NOT NULL AND
1794: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1795: l_result := ORDERED_QUANTITY2

Line 1796: (p_operation => OE_PC_GLOBALS.CANCEL_OP

1792: AND nvl(p_record.ordered_quantity2,0) < nvl(l_old_qty2,0)
1793: AND NOT(p_record.split_action_code IS NOT NULL AND
1794: p_record.split_action_code <> FND_API.G_MISS_CHAR) THEN
1795: l_result := ORDERED_QUANTITY2
1796: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1797: ,p_record => p_record
1798: ,x_on_operation_action => x_on_operation_action
1799: );
1800: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP

Line 1800: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP

1796: (p_operation => OE_PC_GLOBALS.CANCEL_OP
1797: ,p_record => p_record
1798: ,x_on_operation_action => x_on_operation_action
1799: );
1800: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP
1801: AND (p_record.split_action_code IS NOT NULL AND
1802: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1803: p_record.split_action_code = 'SPLIT') THEN
1804: l_result := ORDERED_QUANTITY2

Line 1805: (p_operation => OE_PC_GLOBALS.SPLIT_OP

1801: AND (p_record.split_action_code IS NOT NULL AND
1802: p_record.split_action_code <> FND_API.G_MISS_CHAR AND
1803: p_record.split_action_code = 'SPLIT') THEN
1804: l_result := ORDERED_QUANTITY2
1805: (p_operation => OE_PC_GLOBALS.SPLIT_OP
1806: ,p_record => p_record
1807: ,x_on_operation_action => x_on_operation_action
1808: );
1809: ELSE

Line 1826: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1822: -- OPM 1857167 end
1823:
1824:
1825: FUNCTION ORDER_QUANTITY_UOM
1826: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1827: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1828: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1829: ) RETURN NUMBER
1830: IS

Line 1847: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1843: END ORDER_QUANTITY_UOM;
1844:
1845:
1846: FUNCTION ORIG_SYS_DOCUMENT_REF
1847: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1848: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1849: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1850: ) RETURN NUMBER
1851: IS

Line 1868: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1889: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1885: END ORIG_SYS_LINE_REF;
1886:
1887:
1888: FUNCTION OVER_SHIP_REASON
1889: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1890: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1891: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1892: ) RETURN NUMBER
1893: IS

Line 1910: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1906: END OVER_SHIP_REASON;
1907:
1908:
1909: FUNCTION OVER_SHIP_RESOLVED
1910: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1911: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1912: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1913: ) RETURN NUMBER
1914: IS

Line 1930: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1952: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1948: END PACKING_INSTRUCTIONS;
1949:
1950:
1951: FUNCTION PAYMENT_TERM
1952: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1953: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1954: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
1955: ) RETURN NUMBER
1956: IS

Line 1972: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1993: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2014: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2035: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2031: END PRICING_DATE;
2032:
2033:
2034: FUNCTION PRICING_QUANTITY
2035: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2036: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2037: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2038: ) RETURN NUMBER
2039: IS

Line 2056: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2052: END PRICING_QUANTITY;
2053:
2054:
2055: FUNCTION PRICING_QUANTITY_UOM
2056: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2057: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2058: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2059: ) RETURN NUMBER
2060: IS

Line 2077: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2073: END PRICING_QUANTITY_UOM;
2074:
2075:
2076: FUNCTION PROJECT
2077: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2078: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2079: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2080: ) RETURN NUMBER
2081: IS

Line 2098: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2094: END PROJECT;
2095:
2096:
2097: FUNCTION PROMISE_DATE
2098: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2099: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2100: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2101: ) RETURN NUMBER
2102: IS

Line 2118: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2114:
2115: END PROMISE_DATE;
2116:
2117: FUNCTION REFERENCE_CUST_TRX_LINE
2118: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2119: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2120: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2121: ) RETURN NUMBER
2122: IS

Line 2138: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2134:
2135: END REFERENCE_CUST_TRX_LINE;
2136:
2137: FUNCTION REFERENCE_TYPE
2138: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2139: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2140: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2141: ) RETURN NUMBER
2142: IS

Line 2159: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2155: END REFERENCE_TYPE;
2156:
2157:
2158: FUNCTION REQUEST_DATE
2159: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2160: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2161: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2162: ) RETURN NUMBER
2163: IS

Line 2180: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2176: END REQUEST_DATE;
2177:
2178:
2179: FUNCTION RETURN_REASON
2180: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2181: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2182: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2183: ) RETURN NUMBER
2184: IS

Line 2201: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2197: END RETURN_REASON;
2198:
2199:
2200: FUNCTION SALESREP
2201: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2202: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2203: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2204: ) RETURN NUMBER
2205: IS

Line 2221: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2217:
2218: END SALESREP;
2219:
2220: FUNCTION SHIP_SET
2221: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2222: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2223: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2224: ) RETURN NUMBER
2225: IS

Line 2241: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2237:
2238: END SHIP_SET;
2239:
2240: FUNCTION ARRIVAL_SET
2241: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2242: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2243: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2244: ) RETURN NUMBER
2245: IS

Line 2262: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2258: END ARRIVAL_SET;
2259:
2260:
2261: FUNCTION SCHEDULE_ARRIVAL_DATE
2262: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2263: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2264: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2265: ) RETURN NUMBER
2266: IS

Line 2282: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2303: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2324: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2345: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2367: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2388: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2409: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2430: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2452: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2472: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2496: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2492:
2493: -- INVCONV
2494:
2495: FUNCTION SHIPPING_QUANTITY_UOM2
2496: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2497: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2498: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2499: ) RETURN NUMBER
2500: IS

Line 2517: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2513: END SHIPPING_QUANTITY_UOM2;
2514:
2515:
2516: FUNCTION SHIP_FROM_ORG
2517: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2518: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2519: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2520: ) RETURN NUMBER
2521: IS

Line 2537: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2533:
2534: END SHIP_FROM_ORG;
2535:
2536: FUNCTION SUBINVENTORY
2537: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2538: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2539: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2540: ) RETURN NUMBER
2541: IS

Line 2557: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2578: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2599: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2620: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2641: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2662: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2683: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2704: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2725: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2746: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2767: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2763: END TAX;
2764:
2765:
2766: FUNCTION TAX_DATE
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 2788: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2809: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 2830: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2826: END TAX_EXEMPT_NUMBER;
2827:
2828:
2829: FUNCTION TAX_EXEMPT_REASON
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 2853: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2849:
2850:
2851:
2852: FUNCTION UNIT_LIST_PRICE
2853: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2854: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2855: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2856: ) RETURN NUMBER
2857: IS

Line 2875: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2871:
2872:
2873:
2874: FUNCTION UNIT_SELLING_PRICE
2875: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2876: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2877: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2878: ) RETURN NUMBER
2879: IS

Line 2896: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2892: END UNIT_SELLING_PRICE;
2893:
2894:
2895: FUNCTION SERVICE_REFERENCE_TYPE
2896: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2897: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2898: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2899: ) RETURN NUMBER
2900: IS

Line 2916: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2912:
2913: END SERVICE_REFERENCE_TYPE;
2914:
2915: FUNCTION SERVICE_REFERENCE_LINE
2916: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2917: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2918: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2919: ) RETURN NUMBER
2920: IS

Line 2936: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2932:
2933: END SERVICE_REFERENCE_LINE;
2934:
2935: FUNCTION SERVICE_REFERENCE_SYSTEM
2936: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2937: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2938: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2939: ) RETURN NUMBER
2940: IS

Line 2958: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2954:
2955: /* Fix to bug 2205900: Added constraints functions for
2956: some missing SERVICE fields */
2957: FUNCTION SERVICE_COTERMINATE
2958: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2959: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2960: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2961: ) RETURN NUMBER
2962: IS

Line 2978: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2974:
2975: END SERVICE_COTERMINATE;
2976:
2977: FUNCTION SERVICE_DURATION
2978: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2979: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2980: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
2981: ) RETURN NUMBER
2982: IS

Line 2998: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2994:
2995: END SERVICE_DURATION;
2996:
2997: FUNCTION SERVICE_END_DATE
2998: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2999: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3000: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3001: ) RETURN NUMBER
3002: IS

Line 3018: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3014:
3015: END SERVICE_END_DATE;
3016:
3017: FUNCTION SERVICE_PERIOD
3018: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3019: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3020: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3021: ) RETURN NUMBER
3022: IS

Line 3038: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3034:
3035: END SERVICE_PERIOD;
3036:
3037: FUNCTION SERVICE_START_DATE
3038: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3039: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3040: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3041: ) RETURN NUMBER
3042: IS

Line 3058: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3054:
3055: END SERVICE_START_DATE;
3056:
3057: FUNCTION SERVICE_TXN_COMMENTS
3058: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3059: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3060: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3061: ) RETURN NUMBER
3062: IS

Line 3078: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3074:
3075: END SERVICE_TXN_COMMENTS;
3076:
3077: FUNCTION SERVICE_TXN_REASON
3078: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3079: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3080: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3081: ) RETURN NUMBER
3082: IS

Line 3098: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3094:
3095: END SERVICE_TXN_REASON;
3096: --sol_ord_er #16014165
3097: FUNCTION SERVICE_BILLING_PROFILE
3098: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3099: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3100: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3101: ) RETURN NUMBER
3102: IS

Line 3115: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3111: RETURN(l_result);
3112: END SERVICE_BILLING_PROFILE;
3113:
3114: FUNCTION SERVICE_BILLING_OPTION
3115: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3116: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3117: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3118: ) RETURN NUMBER
3119: IS

Line 3132: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3128: RETURN(l_result);
3129: END SERVICE_BILLING_OPTION;
3130:
3131: FUNCTION SERVICE_COVERAGE_TEMPLATE
3132: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3133: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3134: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3135: ) RETURN NUMBER
3136: IS

Line 3149: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3145: RETURN(l_result);
3146: END SERVICE_COVERAGE_TEMPLATE;
3147:
3148: FUNCTION SERVICE_SUBSCRIPTION_TEMPLATE
3149: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3150: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3151: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3152: ) RETURN NUMBER
3153: IS

Line 3166: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3162: RETURN(l_result);
3163: END SERVICE_SUBSCRIPTION_TEMPLATE;
3164:
3165: FUNCTION SUBSCRIPTION_ENABLE_FLAG
3166: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3167: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3168: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3169: ) RETURN NUMBER
3170: IS

Line 3185: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3181: --sol_ord_er #16014165
3182:
3183: /*1449220*/
3184: FUNCTION ITEM_IDENTIFIER_TYPE
3185: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3186: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3187: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3188: ) RETURN NUMBER
3189: IS

Line 3207: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3203: /*1449220*/
3204:
3205: FUNCTION USER_ITEM_DESCRIPTION
3206:
3207: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3208: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3209: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3210: ) RETURN NUMBER
3211: IS

Line 3227: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3223:
3224: END USER_ITEM_DESCRIPTION;
3225:
3226: FUNCTION BLANKET_NUMBER
3227: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3228: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3229: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3230: ) RETURN NUMBER
3231: IS

Line 3247: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3243:
3244: END BLANKET_NUMBER;
3245:
3246: FUNCTION BLANKET_LINE_NUMBER
3247: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3248: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3249: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3250: ) RETURN NUMBER
3251: IS

Line 3267: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

3263:
3264: END BLANKET_LINE_NUMBER;
3265:
3266: FUNCTION CUSTOMER_SHIPMENT_NUMBER
3267: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
3268: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3269: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
3270: ) RETURN NUMBER
3271: IS

Line 3335: x_result := OE_PC_GLOBALS.YES;

3331: IF l_flow_status_code = 'CANCELLED' THEN
3332: IF l_debug_level > 0 THEN
3333: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3334: END IF;
3335: x_result := OE_PC_GLOBALS.YES;
3336: IF l_debug_level > 0 THEN
3337: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3338: END IF;
3339: -- Add msg to stack

Line 3347: l_operation := OE_PC_GLOBALS.CREATE_OP;

3343: ELSE
3344: IF l_debug_level > 0 THEN
3345: oe_debug_pub.add('hash flow status is not cancelled');
3346: END IF;
3347: l_operation := OE_PC_GLOBALS.CREATE_OP;
3348: END IF; -- if cancelled
3349: ElSE
3350: IF l_debug_level > 0 THEN
3351: oe_debug_pub.add('hash not a service');

Line 3353: l_operation := OE_PC_GLOBALS.CREATE_OP;

3349: ElSE
3350: IF l_debug_level > 0 THEN
3351: oe_debug_pub.add('hash not a service');
3352: END IF;
3353: l_operation := OE_PC_GLOBALS.CREATE_OP;
3354: END IF; -- end if service
3355:
3356: --IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3357: -- l_operation := OE_PC_GLOBALS.CREATE_OP;

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

3353: l_operation := OE_PC_GLOBALS.CREATE_OP;
3354: END IF; -- end if service
3355:
3356: --IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3357: -- l_operation := OE_PC_GLOBALS.CREATE_OP;
3358: /* end of bug 2922204 */
3359:
3360:
3361: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 3362: l_operation := OE_PC_GLOBALS.UPDATE_OP;

3358: /* end of bug 2922204 */
3359:
3360:
3361: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3362: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3363: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3364: l_operation := OE_PC_GLOBALS.DELETE_OP;
3365: ELSE
3366: IF l_debug_level > 0 THEN

Line 3364: l_operation := OE_PC_GLOBALS.DELETE_OP;

3360:
3361: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3362: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3363: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3364: l_operation := OE_PC_GLOBALS.DELETE_OP;
3365: ELSE
3366: IF l_debug_level > 0 THEN
3367: oe_debug_pub.add('Invalid operation',1);
3368: END IF;

Line 3384: l_operation := OE_PC_GLOBALS.SPLIT_OP;

3380: oe_debug_pub.add('OEXXLINB operation is ' || p_line_rec.operation);
3381: END IF;
3382: IF (p_line_rec.split_from_line_id IS NOT NULL AND p_line_rec.operation = 'CREATE')
3383: THEN
3384: l_operation := OE_PC_GLOBALS.SPLIT_OP;
3385: -- --12849745 Elsif below added
3386: ELSIF ( p_line_rec.operation = 'UPDATE' and p_line_rec.split_action_code='SPLIT' ) THEN
3387: IF l_debug_level > 0 THEN
3388: oe_debug_pub.add('resetting operation from Update to SPLIT before Is_OP_constrained');

Line 3390: l_operation := OE_PC_GLOBALS.SPLIT_OP; --12849745 End

3386: ELSIF ( p_line_rec.operation = 'UPDATE' and p_line_rec.split_action_code='SPLIT' ) THEN
3387: IF l_debug_level > 0 THEN
3388: oe_debug_pub.add('resetting operation from Update to SPLIT before Is_OP_constrained');
3389: END IF;
3390: l_operation := OE_PC_GLOBALS.SPLIT_OP; --12849745 End
3391: END IF;
3392: x_result := Is_OP_constrained
3393: (p_operation => l_operation
3394: ,p_record => l_rowtype_rec

Line 3445: x_result := OE_PC_GLOBALS.NO;

3441: -- Initialize g_operation_action to null
3442: g_operation_action := null;
3443:
3444: -- Initializing out result to NOT CONSTRAINED
3445: x_result := OE_PC_GLOBALS.NO;
3446:
3447: -- Get the operation code to be passed to the security framework API
3448: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3449:

Line 3458: l_operation := OE_PC_GLOBALS.CREATE_OP;

3454: OR p_line_rec.split_from_line_id <> FND_API.G_MISS_NUM
3455: THEN
3456: RETURN;
3457: ELSE
3458: l_operation := OE_PC_GLOBALS.CREATE_OP;
3459: END IF;
3460:
3461: -- Bug 1755817: if there are no attribute-specific insert
3462: -- constraints, then no need to go further. Entity level

Line 3466: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE

3462: -- constraints, then no need to go further. Entity level
3463: -- security check for CREATE will be called again from
3464: -- process order after defaulting.
3465: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
3466: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE
3467: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
3468: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
3469: )
3470: THEN

Line 3475: l_operation := OE_PC_GLOBALS.UPDATE_OP;

3471: RETURN;
3472: END IF;
3473:
3474: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3475: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3476: ELSE
3477: IF l_debug_level > 0 THEN
3478: oe_debug_pub.add('Invalid operation',1);
3479: END IF;

Line 3502: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3504: x_result := OE_PC_GLOBALS.YES;

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

Line 3518: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3520: x_result := OE_PC_GLOBALS.YES;

3516: );
3517:
3518: IF l_result = OE_PC_GLOBALS.YES THEN
3519: -- set OUT result to CONSTRAINED
3520: x_result := OE_PC_GLOBALS.YES;
3521: END IF;
3522:
3523: END IF;
3524: IF p_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;

Line 3533: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3535: x_result := OE_PC_GLOBALS.YES;

3531: );
3532:
3533: IF l_result = OE_PC_GLOBALS.YES THEN
3534: -- set OUT result to CONSTRAINED
3535: x_result := OE_PC_GLOBALS.YES;
3536: END IF;
3537:
3538: END IF;
3539: IF p_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;

Line 3548: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3550: x_result := OE_PC_GLOBALS.YES;

3546: );
3547:
3548: IF l_result = OE_PC_GLOBALS.YES THEN
3549: -- set OUT result to CONSTRAINED
3550: x_result := OE_PC_GLOBALS.YES;
3551: END IF;
3552:
3553: END IF;
3554: IF p_line_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;

Line 3563: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3565: x_result := OE_PC_GLOBALS.YES;

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

Line 3578: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3580: x_result := OE_PC_GLOBALS.YES;

3576: );
3577:
3578: IF l_result = OE_PC_GLOBALS.YES THEN
3579: -- set OUT result to CONSTRAINED
3580: x_result := OE_PC_GLOBALS.YES;
3581: END IF;
3582:
3583: END IF;
3584: IF p_line_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;

Line 3593: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3595: x_result := OE_PC_GLOBALS.YES;

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

Line 3609: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3611: x_result := OE_PC_GLOBALS.YES;

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

Line 3625: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3627: x_result := OE_PC_GLOBALS.YES;

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

Line 3641: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3643: x_result := OE_PC_GLOBALS.YES;

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

Line 3658: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3660: x_result := OE_PC_GLOBALS.YES;

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

Line 3674: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3676: x_result := OE_PC_GLOBALS.YES;

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

Line 3690: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3692: x_result := OE_PC_GLOBALS.YES;

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

Line 3706: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3708: x_result := OE_PC_GLOBALS.YES;

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

Line 3722: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3724: x_result := OE_PC_GLOBALS.YES;

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

Line 3738: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3740: x_result := OE_PC_GLOBALS.YES;

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

Line 3755: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3757: x_result := OE_PC_GLOBALS.YES;

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

Line 3771: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3773: x_result := OE_PC_GLOBALS.YES;

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

Line 3787: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3789: x_result := OE_PC_GLOBALS.YES;

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

Line 3803: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3805: x_result := OE_PC_GLOBALS.YES;

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

Line 3819: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3821: x_result := OE_PC_GLOBALS.YES;

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

Line 3835: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3837: x_result := OE_PC_GLOBALS.YES;

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

Line 3851: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3853: x_result := OE_PC_GLOBALS.YES;

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

Line 3867: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3869: x_result := OE_PC_GLOBALS.YES;

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

Line 3883: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3885: x_result := OE_PC_GLOBALS.YES;

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

Line 3899: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3901: x_result := OE_PC_GLOBALS.YES;

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

Line 3915: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3917: x_result := OE_PC_GLOBALS.YES;

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

Line 3932: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3934: x_result := OE_PC_GLOBALS.YES;

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

Line 3948: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3950: x_result := OE_PC_GLOBALS.YES;

3946: );
3947:
3948: IF l_result = OE_PC_GLOBALS.YES THEN
3949: -- set OUT result to CONSTRAINED
3950: x_result := OE_PC_GLOBALS.YES;
3951: END IF;
3952:
3953: END IF;
3954:

Line 3964: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3966: x_result := OE_PC_GLOBALS.YES;

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

Line 3980: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3982: x_result := OE_PC_GLOBALS.YES;

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

Line 3996: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 3998: x_result := OE_PC_GLOBALS.YES;

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

Line 4012: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4014: x_result := OE_PC_GLOBALS.YES;

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

Line 4028: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4030: x_result := OE_PC_GLOBALS.YES;

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

Line 4044: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4046: x_result := OE_PC_GLOBALS.YES;

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

Line 4060: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4062: x_result := OE_PC_GLOBALS.YES;

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

Line 4076: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4078: x_result := OE_PC_GLOBALS.YES;

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

Line 4092: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4094: x_result := OE_PC_GLOBALS.YES;

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

Line 4108: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4110: x_result := OE_PC_GLOBALS.YES;

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

Line 4124: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4126: x_result := OE_PC_GLOBALS.YES;

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

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: -- OPM 1857167 end

Line 4160: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4162: x_result := OE_PC_GLOBALS.YES;

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

Line 4176: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4178: x_result := OE_PC_GLOBALS.YES;

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

Line 4192: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4194: x_result := OE_PC_GLOBALS.YES;

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

Line 4208: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4210: x_result := OE_PC_GLOBALS.YES;

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

Line 4224: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4226: x_result := OE_PC_GLOBALS.YES;

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

Line 4240: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4242: x_result := OE_PC_GLOBALS.YES;

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

Line 4256: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4258: x_result := OE_PC_GLOBALS.YES;

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

Line 4272: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4274: x_result := OE_PC_GLOBALS.YES;

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

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 4448: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4450: x_result := OE_PC_GLOBALS.YES;

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

Line 4464: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4466: x_result := OE_PC_GLOBALS.YES;

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

Line 4483: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4485: x_result := OE_PC_GLOBALS.YES;

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

Line 4499: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4501: x_result := OE_PC_GLOBALS.YES;

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

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 4531: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4533: x_result := OE_PC_GLOBALS.YES;

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

Line 4547: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4549: x_result := OE_PC_GLOBALS.YES;

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

Line 4563: IF l_result = OE_PC_GLOBALS.YES THEN

4559: ,p_record => l_rowtype_rec
4560: ,x_on_operation_action => l_on_operation_action
4561: );
4562:
4563: IF l_result = OE_PC_GLOBALS.YES THEN
4564: -- set OUT result to CONSTRAINED
4565: x_result := OE_PC_GLOBALS.YES;
4566: END IF;
4567:

Line 4565: x_result := OE_PC_GLOBALS.YES;

4561: );
4562:
4563: IF l_result = OE_PC_GLOBALS.YES THEN
4564: -- set OUT result to CONSTRAINED
4565: x_result := OE_PC_GLOBALS.YES;
4566: END IF;
4567:
4568: END IF;
4569:

Line 4579: IF l_result = OE_PC_GLOBALS.YES THEN

4575: ,p_record => l_rowtype_rec
4576: ,x_on_operation_action => l_on_operation_action
4577: );
4578:
4579: IF l_result = OE_PC_GLOBALS.YES THEN
4580: -- set OUT result to CONSTRAINED
4581: x_result := OE_PC_GLOBALS.YES;
4582: END IF;
4583:

Line 4581: x_result := OE_PC_GLOBALS.YES;

4577: );
4578:
4579: IF l_result = OE_PC_GLOBALS.YES THEN
4580: -- set OUT result to CONSTRAINED
4581: x_result := OE_PC_GLOBALS.YES;
4582: END IF;
4583:
4584: END IF;
4585:

Line 4595: IF l_result = OE_PC_GLOBALS.YES THEN

4591: (p_operation => l_operation
4592: ,p_record => l_rowtype_rec
4593: ,x_on_operation_action => l_on_operation_action
4594: );
4595: IF l_result = OE_PC_GLOBALS.YES THEN
4596: -- set OUT result to CONSTRAINED
4597: x_result := OE_PC_GLOBALS.YES;
4598: END IF;
4599: END IF;

Line 4597: x_result := OE_PC_GLOBALS.YES;

4593: ,x_on_operation_action => l_on_operation_action
4594: );
4595: IF l_result = OE_PC_GLOBALS.YES THEN
4596: -- set OUT result to CONSTRAINED
4597: x_result := OE_PC_GLOBALS.YES;
4598: END IF;
4599: END IF;
4600:
4601: IF p_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR THEN

Line 4609: IF l_result = OE_PC_GLOBALS.YES THEN

4605: (p_operation => l_operation
4606: ,p_record => l_rowtype_rec
4607: ,x_on_operation_action => l_on_operation_action
4608: );
4609: IF l_result = OE_PC_GLOBALS.YES THEN
4610: -- set OUT result to CONSTRAINED
4611: x_result := OE_PC_GLOBALS.YES;
4612: END IF;
4613: END IF;

Line 4611: x_result := OE_PC_GLOBALS.YES;

4607: ,x_on_operation_action => l_on_operation_action
4608: );
4609: IF l_result = OE_PC_GLOBALS.YES THEN
4610: -- set OUT result to CONSTRAINED
4611: x_result := OE_PC_GLOBALS.YES;
4612: END IF;
4613: END IF;
4614:
4615: IF p_line_rec.service_cov_template_id = FND_API.G_MISS_NUM THEN

Line 4623: IF l_result = OE_PC_GLOBALS.YES THEN

4619: (p_operation => l_operation
4620: ,p_record => l_rowtype_rec
4621: ,x_on_operation_action => l_on_operation_action
4622: );
4623: IF l_result = OE_PC_GLOBALS.YES THEN
4624: -- set OUT result to CONSTRAINED
4625: x_result := OE_PC_GLOBALS.YES;
4626: END IF;
4627: END IF;

Line 4625: x_result := OE_PC_GLOBALS.YES;

4621: ,x_on_operation_action => l_on_operation_action
4622: );
4623: IF l_result = OE_PC_GLOBALS.YES THEN
4624: -- set OUT result to CONSTRAINED
4625: x_result := OE_PC_GLOBALS.YES;
4626: END IF;
4627: END IF;
4628:
4629: IF p_line_rec.service_subs_template_id = FND_API.G_MISS_NUM THEN

Line 4637: IF l_result = OE_PC_GLOBALS.YES THEN

4633: (p_operation => l_operation
4634: ,p_record => l_rowtype_rec
4635: ,x_on_operation_action => l_on_operation_action
4636: );
4637: IF l_result = OE_PC_GLOBALS.YES THEN
4638: -- set OUT result to CONSTRAINED
4639: x_result := OE_PC_GLOBALS.YES;
4640: END IF;
4641: END IF;

Line 4639: x_result := OE_PC_GLOBALS.YES;

4635: ,x_on_operation_action => l_on_operation_action
4636: );
4637: IF l_result = OE_PC_GLOBALS.YES THEN
4638: -- set OUT result to CONSTRAINED
4639: x_result := OE_PC_GLOBALS.YES;
4640: END IF;
4641: END IF;
4642:
4643: IF p_line_rec.SUBSCRIPTION_ENABLE_FLAG = FND_API.G_MISS_CHAR THEN

Line 4651: IF l_result = OE_PC_GLOBALS.YES THEN

4647: (p_operation => l_operation
4648: ,p_record => l_rowtype_rec
4649: ,x_on_operation_action => l_on_operation_action
4650: );
4651: IF l_result = OE_PC_GLOBALS.YES THEN
4652: -- set OUT result to CONSTRAINED
4653: x_result := OE_PC_GLOBALS.YES;
4654: END IF;
4655: END IF;

Line 4653: x_result := OE_PC_GLOBALS.YES;

4649: ,x_on_operation_action => l_on_operation_action
4650: );
4651: IF l_result = OE_PC_GLOBALS.YES THEN
4652: -- set OUT result to CONSTRAINED
4653: x_result := OE_PC_GLOBALS.YES;
4654: END IF;
4655: END IF;
4656: --sol_ord_er #16014165 end
4657:

Line 4667: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4669: x_result := OE_PC_GLOBALS.YES;

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

Line 4683: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4685: x_result := OE_PC_GLOBALS.YES;

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

Line 4699: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4701: x_result := OE_PC_GLOBALS.YES;

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

Line 4716: IF l_result = OE_PC_GLOBALS.YES THEN

4712: ,p_record => l_rowtype_rec
4713: ,x_on_operation_action => l_on_operation_action
4714: );
4715:
4716: IF l_result = OE_PC_GLOBALS.YES THEN
4717: -- set OUT result to CONSTRAINED
4718: x_result := OE_PC_GLOBALS.YES;
4719: END IF;
4720:

Line 4718: x_result := OE_PC_GLOBALS.YES;

4714: );
4715:
4716: IF l_result = OE_PC_GLOBALS.YES THEN
4717: -- set OUT result to CONSTRAINED
4718: x_result := OE_PC_GLOBALS.YES;
4719: END IF;
4720:
4721: END IF;
4722:

Line 4733: IF l_result = OE_PC_GLOBALS.YES THEN

4729: ,p_record => l_rowtype_rec
4730: ,x_on_operation_action => l_on_operation_action
4731: );
4732:
4733: IF l_result = OE_PC_GLOBALS.YES THEN
4734: -- set OUT result to CONSTRAINED
4735: x_result := OE_PC_GLOBALS.YES;
4736: END IF;
4737:

Line 4735: x_result := OE_PC_GLOBALS.YES;

4731: );
4732:
4733: IF l_result = OE_PC_GLOBALS.YES THEN
4734: -- set OUT result to CONSTRAINED
4735: x_result := OE_PC_GLOBALS.YES;
4736: END IF;
4737:
4738: END IF;
4739:

Line 4749: IF l_result = OE_PC_GLOBALS.YES THEN

4745: ,p_record => l_rowtype_rec
4746: ,x_on_operation_action => l_on_operation_action
4747: );
4748:
4749: IF l_result = OE_PC_GLOBALS.YES THEN
4750: -- set OUT result to CONSTRAINED
4751: x_result := OE_PC_GLOBALS.YES;
4752: END IF;
4753:

Line 4751: x_result := OE_PC_GLOBALS.YES;

4747: );
4748:
4749: IF l_result = OE_PC_GLOBALS.YES THEN
4750: -- set OUT result to CONSTRAINED
4751: x_result := OE_PC_GLOBALS.YES;
4752: END IF;
4753:
4754: END IF;
4755:

Line 4765: IF l_result = OE_PC_GLOBALS.YES THEN

4761: ,p_record => l_rowtype_rec
4762: ,x_on_operation_action => l_on_operation_action
4763: );
4764:
4765: IF l_result = OE_PC_GLOBALS.YES THEN
4766: -- set OUT result to CONSTRAINED
4767: x_result := OE_PC_GLOBALS.YES;
4768: END IF;
4769:

Line 4767: x_result := OE_PC_GLOBALS.YES;

4763: );
4764:
4765: IF l_result = OE_PC_GLOBALS.YES THEN
4766: -- set OUT result to CONSTRAINED
4767: x_result := OE_PC_GLOBALS.YES;
4768: END IF;
4769:
4770: END IF;
4771:

Line 4782: IF l_result = OE_PC_GLOBALS.YES THEN

4778: ,p_record => l_rowtype_rec
4779: ,x_on_operation_action => l_on_operation_action
4780: );
4781:
4782: IF l_result = OE_PC_GLOBALS.YES THEN
4783: -- set OUT result to CONSTRAINED
4784: x_result := OE_PC_GLOBALS.YES;
4785: END IF;
4786:

Line 4784: x_result := OE_PC_GLOBALS.YES;

4780: );
4781:
4782: IF l_result = OE_PC_GLOBALS.YES THEN
4783: -- set OUT result to CONSTRAINED
4784: x_result := OE_PC_GLOBALS.YES;
4785: END IF;
4786:
4787: END IF;
4788:

Line 4800: IF l_result = OE_PC_GLOBALS.YES THEN

4796: ,p_record => l_rowtype_rec
4797: ,x_on_operation_action => l_on_operation_action
4798: );
4799:
4800: IF l_result = OE_PC_GLOBALS.YES THEN
4801: -- set OUT result to CONSTRAINED
4802: x_result := OE_PC_GLOBALS.YES;
4803: END IF;
4804:

Line 4802: x_result := OE_PC_GLOBALS.YES;

4798: );
4799:
4800: IF l_result = OE_PC_GLOBALS.YES THEN
4801: -- set OUT result to CONSTRAINED
4802: x_result := OE_PC_GLOBALS.YES;
4803: END IF;
4804:
4805: END IF;
4806:

Line 4817: IF l_result = OE_PC_GLOBALS.YES THEN

4813: ,p_record => l_rowtype_rec
4814: ,x_on_operation_action => l_on_operation_action
4815: );
4816:
4817: IF l_result = OE_PC_GLOBALS.YES THEN
4818: -- set OUT result to CONSTRAINED
4819: x_result := OE_PC_GLOBALS.YES;
4820: END IF;
4821:

Line 4819: x_result := OE_PC_GLOBALS.YES;

4815: );
4816:
4817: IF l_result = OE_PC_GLOBALS.YES THEN
4818: -- set OUT result to CONSTRAINED
4819: x_result := OE_PC_GLOBALS.YES;
4820: END IF;
4821:
4822: END IF;
4823:

Line 4834: IF l_result = OE_PC_GLOBALS.YES THEN

4830: ,p_record => l_rowtype_rec
4831: ,x_on_operation_action => l_on_operation_action
4832: );
4833:
4834: IF l_result = OE_PC_GLOBALS.YES THEN
4835: -- set OUT result to CONSTRAINED
4836: x_result := OE_PC_GLOBALS.YES;
4837: END IF;
4838:

Line 4836: x_result := OE_PC_GLOBALS.YES;

4832: );
4833:
4834: IF l_result = OE_PC_GLOBALS.YES THEN
4835: -- set OUT result to CONSTRAINED
4836: x_result := OE_PC_GLOBALS.YES;
4837: END IF;
4838:
4839: END IF;
4840:

Line 4850: IF l_result = OE_PC_GLOBALS.YES THEN

4846: ,p_record => l_rowtype_rec
4847: ,x_on_operation_action => l_on_operation_action
4848: );
4849:
4850: IF l_result = OE_PC_GLOBALS.YES THEN
4851: -- set OUT result to CONSTRAINED
4852: x_result := OE_PC_GLOBALS.YES;
4853: END IF;
4854:

Line 4852: x_result := OE_PC_GLOBALS.YES;

4848: );
4849:
4850: IF l_result = OE_PC_GLOBALS.YES THEN
4851: -- set OUT result to CONSTRAINED
4852: x_result := OE_PC_GLOBALS.YES;
4853: END IF;
4854:
4855: END IF;
4856:

Line 4867: IF l_result = OE_PC_GLOBALS.YES THEN

4863: ,p_record => l_rowtype_rec
4864: ,x_on_operation_action => l_on_operation_action
4865: );
4866:
4867: IF l_result = OE_PC_GLOBALS.YES THEN
4868: -- set OUT result to CONSTRAINED
4869: x_result := OE_PC_GLOBALS.YES;
4870: END IF;
4871:

Line 4869: x_result := OE_PC_GLOBALS.YES;

4865: );
4866:
4867: IF l_result = OE_PC_GLOBALS.YES THEN
4868: -- set OUT result to CONSTRAINED
4869: x_result := OE_PC_GLOBALS.YES;
4870: END IF;
4871:
4872: END IF;
4873:

Line 4883: IF l_result = OE_PC_GLOBALS.YES THEN

4879: ,p_record => l_rowtype_rec
4880: ,x_on_operation_action => l_on_operation_action
4881: );
4882:
4883: IF l_result = OE_PC_GLOBALS.YES THEN
4884: -- set OUT result to CONSTRAINED
4885: x_result := OE_PC_GLOBALS.YES;
4886: END IF;
4887:

Line 4885: x_result := OE_PC_GLOBALS.YES;

4881: );
4882:
4883: IF l_result = OE_PC_GLOBALS.YES THEN
4884: -- set OUT result to CONSTRAINED
4885: x_result := OE_PC_GLOBALS.YES;
4886: END IF;
4887:
4888: END IF;
4889:

Line 4899: IF l_result = OE_PC_GLOBALS.YES THEN

4895: ,p_record => l_rowtype_rec
4896: ,x_on_operation_action => l_on_operation_action
4897: );
4898:
4899: IF l_result = OE_PC_GLOBALS.YES THEN
4900: -- set OUT result to CONSTRAINED
4901: x_result := OE_PC_GLOBALS.YES;
4902: END IF;
4903:

Line 4901: x_result := OE_PC_GLOBALS.YES;

4897: );
4898:
4899: IF l_result = OE_PC_GLOBALS.YES THEN
4900: -- set OUT result to CONSTRAINED
4901: x_result := OE_PC_GLOBALS.YES;
4902: END IF;
4903:
4904: END IF;
4905:

Line 4915: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4917: x_result := OE_PC_GLOBALS.YES;

4913: );
4914:
4915: IF l_result = OE_PC_GLOBALS.YES THEN
4916: -- set OUT result to CONSTRAINED
4917: x_result := OE_PC_GLOBALS.YES;
4918: END IF;
4919:
4920: END IF;
4921:

Line 4931: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 4933: x_result := OE_PC_GLOBALS.YES;

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

Line 4947: IF l_result = OE_PC_GLOBALS.YES THEN

4943: ,p_record => l_rowtype_rec
4944: ,x_on_operation_action => l_on_operation_action
4945: );
4946:
4947: IF l_result = OE_PC_GLOBALS.YES THEN
4948: -- set OUT result to CONSTRAINED
4949: x_result := OE_PC_GLOBALS.YES;
4950: END IF;
4951:

Line 4949: x_result := OE_PC_GLOBALS.YES;

4945: );
4946:
4947: IF l_result = OE_PC_GLOBALS.YES THEN
4948: -- set OUT result to CONSTRAINED
4949: x_result := OE_PC_GLOBALS.YES;
4950: END IF;
4951:
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 5091: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 5093: x_result := OE_PC_GLOBALS.YES;

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

Line 5107: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 5109: x_result := OE_PC_GLOBALS.YES;

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

Line 5124: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 5126: x_result := OE_PC_GLOBALS.YES;

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

Line 5140: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 5142: x_result := OE_PC_GLOBALS.YES;

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

Line 5180: IF l_result = OE_PC_GLOBALS.YES THEN

5176: l_result := calculate_price_flag(p_operation => l_operation
5177: ,p_record => l_rowtype_rec
5178: ,x_on_operation_action => l_on_operation_action);
5179:
5180: IF l_result = OE_PC_GLOBALS.YES THEN
5181: -- set OUT result to CONSTRAINED
5182: x_result := OE_PC_GLOBALS.YES;
5183: END IF;
5184: END IF;

Line 5182: x_result := OE_PC_GLOBALS.YES;

5178: ,x_on_operation_action => l_on_operation_action);
5179:
5180: IF l_result = OE_PC_GLOBALS.YES THEN
5181: -- set OUT result to CONSTRAINED
5182: x_result := OE_PC_GLOBALS.YES;
5183: END IF;
5184: END IF;
5185:
5186: IF p_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR THEN

Line 5196: IF l_result = OE_PC_GLOBALS.YES THEN

5192: ,p_record => l_rowtype_rec
5193: ,x_on_operation_action => l_on_operation_action
5194: );
5195:
5196: IF l_result = OE_PC_GLOBALS.YES THEN
5197: -- set OUT result to CONSTRAINED
5198: x_result := OE_PC_GLOBALS.YES;
5199: END IF;
5200:

Line 5198: x_result := OE_PC_GLOBALS.YES;

5194: );
5195:
5196: IF l_result = OE_PC_GLOBALS.YES THEN
5197: -- set OUT result to CONSTRAINED
5198: x_result := OE_PC_GLOBALS.YES;
5199: END IF;
5200:
5201: END IF;
5202:

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

5212: -- updated and profile was set to 'N', global at the end should
5213: -- be re-set to 'Y' - this indicates to process order that no
5214: -- constrainable attributes were updated and thus, it would
5215: -- suppress entity level security check also.
5216: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
5217: l_check_all_cols_constraint := g_check_all_cols_constraint;
5218: g_check_all_cols_constraint := 'N';
5219: END IF;
5220:

Line 5230: IF l_result = OE_PC_GLOBALS.YES THEN

5226: ,p_record => l_rowtype_rec
5227: ,x_on_operation_action => l_on_operation_action
5228: );
5229:
5230: IF l_result = OE_PC_GLOBALS.YES THEN
5231: -- set OUT result to CONSTRAINED
5232: x_result := OE_PC_GLOBALS.YES;
5233: END IF;
5234:

Line 5232: x_result := OE_PC_GLOBALS.YES;

5228: );
5229:
5230: IF l_result = OE_PC_GLOBALS.YES THEN
5231: -- set OUT result to CONSTRAINED
5232: x_result := OE_PC_GLOBALS.YES;
5233: END IF;
5234:
5235: END IF;
5236:

Line 5246: IF l_result = OE_PC_GLOBALS.YES THEN

5242: ,p_record => l_rowtype_rec
5243: ,x_on_operation_action => l_on_operation_action
5244: );
5245:
5246: IF l_result = OE_PC_GLOBALS.YES THEN
5247: -- set OUT result to CONSTRAINED
5248: x_result := OE_PC_GLOBALS.YES;
5249: END IF;
5250:

Line 5248: x_result := OE_PC_GLOBALS.YES;

5244: );
5245:
5246: IF l_result = OE_PC_GLOBALS.YES THEN
5247: -- set OUT result to CONSTRAINED
5248: x_result := OE_PC_GLOBALS.YES;
5249: END IF;
5250:
5251: END IF;
5252:

Line 5262: IF l_result = OE_PC_GLOBALS.YES THEN

5258: ,p_record => l_rowtype_rec
5259: ,x_on_operation_action => l_on_operation_action
5260: );
5261:
5262: IF l_result = OE_PC_GLOBALS.YES THEN
5263: -- set OUT result to CONSTRAINED
5264: x_result := OE_PC_GLOBALS.YES;
5265: END IF;
5266:

Line 5264: x_result := OE_PC_GLOBALS.YES;

5260: );
5261:
5262: IF l_result = OE_PC_GLOBALS.YES THEN
5263: -- set OUT result to CONSTRAINED
5264: x_result := OE_PC_GLOBALS.YES;
5265: END IF;
5266:
5267: END IF;
5268:

Line 5278: IF l_result = OE_PC_GLOBALS.YES THEN

5274: ,p_record => l_rowtype_rec
5275: ,x_on_operation_action => l_on_operation_action
5276: );
5277:
5278: IF l_result = OE_PC_GLOBALS.YES THEN
5279: -- set OUT result to CONSTRAINED
5280: x_result := OE_PC_GLOBALS.YES;
5281: END IF;
5282:

Line 5280: x_result := OE_PC_GLOBALS.YES;

5276: );
5277:
5278: IF l_result = OE_PC_GLOBALS.YES THEN
5279: -- set OUT result to CONSTRAINED
5280: x_result := OE_PC_GLOBALS.YES;
5281: END IF;
5282:
5283: END IF;
5284:

Line 5294: IF l_result = OE_PC_GLOBALS.YES THEN

5290: ,p_record => l_rowtype_rec
5291: ,x_on_operation_action => l_on_operation_action
5292: );
5293:
5294: IF l_result = OE_PC_GLOBALS.YES THEN
5295: -- set OUT result to CONSTRAINED
5296: x_result := OE_PC_GLOBALS.YES;
5297: END IF;
5298:

Line 5296: x_result := OE_PC_GLOBALS.YES;

5292: );
5293:
5294: IF l_result = OE_PC_GLOBALS.YES THEN
5295: -- set OUT result to CONSTRAINED
5296: x_result := OE_PC_GLOBALS.YES;
5297: END IF;
5298:
5299: END IF;
5300:

Line 5310: IF l_result = OE_PC_GLOBALS.YES THEN

5306: ,p_record => l_rowtype_rec
5307: ,x_on_operation_action => l_on_operation_action
5308: );
5309:
5310: IF l_result = OE_PC_GLOBALS.YES THEN
5311: -- set OUT result to CONSTRAINED
5312: x_result := OE_PC_GLOBALS.YES;
5313: END IF;
5314:

Line 5312: x_result := OE_PC_GLOBALS.YES;

5308: );
5309:
5310: IF l_result = OE_PC_GLOBALS.YES THEN
5311: -- set OUT result to CONSTRAINED
5312: x_result := OE_PC_GLOBALS.YES;
5313: END IF;
5314:
5315: END IF;
5316:

Line 5326: IF l_result = OE_PC_GLOBALS.YES THEN

5322: ,p_record => l_rowtype_rec
5323: ,x_on_operation_action => l_on_operation_action
5324: );
5325:
5326: IF l_result = OE_PC_GLOBALS.YES THEN
5327: -- set OUT result to CONSTRAINED
5328: x_result := OE_PC_GLOBALS.YES;
5329: END IF;
5330:

Line 5328: x_result := OE_PC_GLOBALS.YES;

5324: );
5325:
5326: IF l_result = OE_PC_GLOBALS.YES THEN
5327: -- set OUT result to CONSTRAINED
5328: x_result := OE_PC_GLOBALS.YES;
5329: END IF;
5330:
5331: END IF;
5332:

Line 5342: IF l_result = OE_PC_GLOBALS.YES THEN

5338: ,p_record => l_rowtype_rec
5339: ,x_on_operation_action => l_on_operation_action
5340: );
5341:
5342: IF l_result = OE_PC_GLOBALS.YES THEN
5343: -- set OUT result to CONSTRAINED
5344: x_result := OE_PC_GLOBALS.YES;
5345: END IF;
5346:

Line 5344: x_result := OE_PC_GLOBALS.YES;

5340: );
5341:
5342: IF l_result = OE_PC_GLOBALS.YES THEN
5343: -- set OUT result to CONSTRAINED
5344: x_result := OE_PC_GLOBALS.YES;
5345: END IF;
5346:
5347: END IF;
5348:

Line 5360: IF l_result = OE_PC_GLOBALS.YES THEN

5356: ,p_record => l_rowtype_rec
5357: ,x_on_operation_action => l_on_operation_action
5358: );
5359:
5360: IF l_result = OE_PC_GLOBALS.YES THEN
5361: -- set OUT result to CONSTRAINED
5362: x_result := OE_PC_GLOBALS.YES;
5363: END IF;
5364:

Line 5362: x_result := OE_PC_GLOBALS.YES;

5358: );
5359:
5360: IF l_result = OE_PC_GLOBALS.YES THEN
5361: -- set OUT result to CONSTRAINED
5362: x_result := OE_PC_GLOBALS.YES;
5363: END IF;
5364:
5365: END IF;
5366:

Line 5376: IF l_result = OE_PC_GLOBALS.YES THEN

5372: ,p_record => l_rowtype_rec
5373: ,x_on_operation_action => l_on_operation_action
5374: );
5375:
5376: IF l_result = OE_PC_GLOBALS.YES THEN
5377: -- set OUT result to CONSTRAINED
5378: x_result := OE_PC_GLOBALS.YES;
5379: END IF;
5380:

Line 5378: x_result := OE_PC_GLOBALS.YES;

5374: );
5375:
5376: IF l_result = OE_PC_GLOBALS.YES THEN
5377: -- set OUT result to CONSTRAINED
5378: x_result := OE_PC_GLOBALS.YES;
5379: END IF;
5380:
5381: END IF;
5382:

Line 5392: IF l_result = OE_PC_GLOBALS.YES THEN

5388: ,p_record => l_rowtype_rec
5389: ,x_on_operation_action => l_on_operation_action
5390: );
5391:
5392: IF l_result = OE_PC_GLOBALS.YES THEN
5393: -- set OUT result to CONSTRAINED
5394: x_result := OE_PC_GLOBALS.YES;
5395: END IF;
5396:

Line 5394: x_result := OE_PC_GLOBALS.YES;

5390: );
5391:
5392: IF l_result = OE_PC_GLOBALS.YES THEN
5393: -- set OUT result to CONSTRAINED
5394: x_result := OE_PC_GLOBALS.YES;
5395: END IF;
5396:
5397: END IF;
5398:

Line 5408: IF l_result = OE_PC_GLOBALS.YES THEN

5404: ,p_record => l_rowtype_rec
5405: ,x_on_operation_action => l_on_operation_action
5406: );
5407:
5408: IF l_result = OE_PC_GLOBALS.YES THEN
5409: -- set OUT result to CONSTRAINED
5410: x_result := OE_PC_GLOBALS.YES;
5411: END IF;
5412:

Line 5410: x_result := OE_PC_GLOBALS.YES;

5406: );
5407:
5408: IF l_result = OE_PC_GLOBALS.YES THEN
5409: -- set OUT result to CONSTRAINED
5410: x_result := OE_PC_GLOBALS.YES;
5411: END IF;
5412:
5413: END IF;
5414:

Line 5424: IF l_result = OE_PC_GLOBALS.YES THEN

5420: ,p_record => l_rowtype_rec
5421: ,x_on_operation_action => l_on_operation_action
5422: );
5423:
5424: IF l_result = OE_PC_GLOBALS.YES THEN
5425: -- set OUT result to CONSTRAINED
5426: x_result := OE_PC_GLOBALS.YES;
5427: END IF;
5428:

Line 5426: x_result := OE_PC_GLOBALS.YES;

5422: );
5423:
5424: IF l_result = OE_PC_GLOBALS.YES THEN
5425: -- set OUT result to CONSTRAINED
5426: x_result := OE_PC_GLOBALS.YES;
5427: END IF;
5428:
5429: END IF;
5430:

Line 5441: IF l_result = OE_PC_GLOBALS.YES THEN

5437: ,p_record => l_rowtype_rec
5438: ,x_on_operation_action => l_on_operation_action
5439: );
5440:
5441: IF l_result = OE_PC_GLOBALS.YES THEN
5442: -- set OUT result to CONSTRAINED
5443: x_result := OE_PC_GLOBALS.YES;
5444: END IF;
5445:

Line 5443: x_result := OE_PC_GLOBALS.YES;

5439: );
5440:
5441: IF l_result = OE_PC_GLOBALS.YES THEN
5442: -- set OUT result to CONSTRAINED
5443: x_result := OE_PC_GLOBALS.YES;
5444: END IF;
5445:
5446: END IF;
5447:

Line 5459: IF l_result = OE_PC_GLOBALS.YES THEN

5455: ,p_record => l_rowtype_rec
5456: ,x_on_operation_action => l_on_operation_action
5457: );
5458:
5459: IF l_result = OE_PC_GLOBALS.YES THEN
5460: -- set OUT result to CONSTRAINED
5461: x_result := OE_PC_GLOBALS.YES;
5462: END IF;
5463:

Line 5461: x_result := OE_PC_GLOBALS.YES;

5457: );
5458:
5459: IF l_result = OE_PC_GLOBALS.YES THEN
5460: -- set OUT result to CONSTRAINED
5461: x_result := OE_PC_GLOBALS.YES;
5462: END IF;
5463:
5464: END IF;
5465:

Line 5475: IF l_result = OE_PC_GLOBALS.YES THEN

5471: ,p_record => l_rowtype_rec
5472: ,x_on_operation_action => l_on_operation_action
5473: );
5474:
5475: IF l_result = OE_PC_GLOBALS.YES THEN
5476: -- set OUT result to CONSTRAINED
5477: x_result := OE_PC_GLOBALS.YES;
5478: END IF;
5479:

Line 5477: x_result := OE_PC_GLOBALS.YES;

5473: );
5474:
5475: IF l_result = OE_PC_GLOBALS.YES THEN
5476: -- set OUT result to CONSTRAINED
5477: x_result := OE_PC_GLOBALS.YES;
5478: END IF;
5479:
5480: END IF;
5481:

Line 5491: IF l_result = OE_PC_GLOBALS.YES THEN

5487: ,p_record => l_rowtype_rec
5488: ,x_on_operation_action => l_on_operation_action
5489: );
5490:
5491: IF l_result = OE_PC_GLOBALS.YES THEN
5492: -- set OUT result to CONSTRAINED
5493: x_result := OE_PC_GLOBALS.YES;
5494: END IF;
5495:

Line 5493: x_result := OE_PC_GLOBALS.YES;

5489: );
5490:
5491: IF l_result = OE_PC_GLOBALS.YES THEN
5492: -- set OUT result to CONSTRAINED
5493: x_result := OE_PC_GLOBALS.YES;
5494: END IF;
5495:
5496: END IF;
5497:

Line 5507: IF l_result = OE_PC_GLOBALS.YES THEN

5503: ,p_record => l_rowtype_rec
5504: ,x_on_operation_action => l_on_operation_action
5505: );
5506:
5507: IF l_result = OE_PC_GLOBALS.YES THEN
5508: -- set OUT result to CONSTRAINED
5509: x_result := OE_PC_GLOBALS.YES;
5510: END IF;
5511:

Line 5509: x_result := OE_PC_GLOBALS.YES;

5505: );
5506:
5507: IF l_result = OE_PC_GLOBALS.YES THEN
5508: -- set OUT result to CONSTRAINED
5509: x_result := OE_PC_GLOBALS.YES;
5510: END IF;
5511:
5512: END IF;
5513:

Line 5523: IF l_result = OE_PC_GLOBALS.YES THEN

5519: ,p_record => l_rowtype_rec
5520: ,x_on_operation_action => l_on_operation_action
5521: );
5522:
5523: IF l_result = OE_PC_GLOBALS.YES THEN
5524: -- set OUT result to CONSTRAINED
5525: x_result := OE_PC_GLOBALS.YES;
5526: END IF;
5527:

Line 5525: x_result := OE_PC_GLOBALS.YES;

5521: );
5522:
5523: IF l_result = OE_PC_GLOBALS.YES THEN
5524: -- set OUT result to CONSTRAINED
5525: x_result := OE_PC_GLOBALS.YES;
5526: END IF;
5527:
5528: END IF;
5529:

Line 5539: IF l_result = OE_PC_GLOBALS.YES THEN

5535: ,p_record => l_rowtype_rec
5536: ,x_on_operation_action => l_on_operation_action
5537: );
5538:
5539: IF l_result = OE_PC_GLOBALS.YES THEN
5540: -- set OUT result to CONSTRAINED
5541: x_result := OE_PC_GLOBALS.YES;
5542: END IF;
5543:

Line 5541: x_result := OE_PC_GLOBALS.YES;

5537: );
5538:
5539: IF l_result = OE_PC_GLOBALS.YES THEN
5540: -- set OUT result to CONSTRAINED
5541: x_result := OE_PC_GLOBALS.YES;
5542: END IF;
5543:
5544: END IF;
5545:

Line 5555: IF l_result = OE_PC_GLOBALS.YES THEN

5551: ,p_record => l_rowtype_rec
5552: ,x_on_operation_action => l_on_operation_action
5553: );
5554:
5555: IF l_result = OE_PC_GLOBALS.YES THEN
5556: -- set OUT result to CONSTRAINED
5557: x_result := OE_PC_GLOBALS.YES;
5558: END IF;
5559:

Line 5557: x_result := OE_PC_GLOBALS.YES;

5553: );
5554:
5555: IF l_result = OE_PC_GLOBALS.YES THEN
5556: -- set OUT result to CONSTRAINED
5557: x_result := OE_PC_GLOBALS.YES;
5558: END IF;
5559:
5560: END IF;
5561:

Line 5572: IF l_result = OE_PC_GLOBALS.YES THEN

5568: ,p_record => l_rowtype_rec
5569: ,x_on_operation_action => l_on_operation_action
5570: );
5571:
5572: IF l_result = OE_PC_GLOBALS.YES THEN
5573:
5574: x_result := OE_PC_GLOBALS.YES;
5575: END IF;
5576:

Line 5574: x_result := OE_PC_GLOBALS.YES;

5570: );
5571:
5572: IF l_result = OE_PC_GLOBALS.YES THEN
5573:
5574: x_result := OE_PC_GLOBALS.YES;
5575: END IF;
5576:
5577: END IF;
5578:

Line 5588: IF l_result = OE_PC_GLOBALS.YES THEN

5584: ,p_record => l_rowtype_rec
5585: ,x_on_operation_action => l_on_operation_action
5586: );
5587:
5588: IF l_result = OE_PC_GLOBALS.YES THEN
5589:
5590: x_result := OE_PC_GLOBALS.YES;
5591: END IF;
5592:

Line 5590: x_result := OE_PC_GLOBALS.YES;

5586: );
5587:
5588: IF l_result = OE_PC_GLOBALS.YES THEN
5589:
5590: x_result := OE_PC_GLOBALS.YES;
5591: END IF;
5592:
5593: END IF;
5594:

Line 5604: IF l_result = OE_PC_GLOBALS.YES THEN

5600: ,p_record => l_rowtype_rec
5601: ,x_on_operation_action => l_on_operation_action
5602: );
5603:
5604: IF l_result = OE_PC_GLOBALS.YES THEN
5605:
5606: x_result := OE_PC_GLOBALS.YES;
5607: END IF;
5608:

Line 5606: x_result := OE_PC_GLOBALS.YES;

5602: );
5603:
5604: IF l_result = OE_PC_GLOBALS.YES THEN
5605:
5606: x_result := OE_PC_GLOBALS.YES;
5607: END IF;
5608:
5609: END IF;
5610: ---END 14272033

Line 5621: IF l_result = OE_PC_GLOBALS.YES THEN

5617: ,p_record => l_rowtype_rec
5618: ,x_on_operation_action => l_on_operation_action
5619: );
5620:
5621: IF l_result = OE_PC_GLOBALS.YES THEN
5622: -- set OUT result to CONSTRAINED
5623: x_result := OE_PC_GLOBALS.YES;
5624: END IF;
5625:

Line 5623: x_result := OE_PC_GLOBALS.YES;

5619: );
5620:
5621: IF l_result = OE_PC_GLOBALS.YES THEN
5622: -- set OUT result to CONSTRAINED
5623: x_result := OE_PC_GLOBALS.YES;
5624: END IF;
5625:
5626: END IF;
5627:

Line 5638: IF l_result = OE_PC_GLOBALS.YES THEN

5634: ,p_record => l_rowtype_rec
5635: ,x_on_operation_action => l_on_operation_action
5636: );
5637:
5638: IF l_result = OE_PC_GLOBALS.YES THEN
5639: -- set OUT result to CONSTRAINED
5640: x_result := OE_PC_GLOBALS.YES;
5641: END IF;
5642:

Line 5640: x_result := OE_PC_GLOBALS.YES;

5636: );
5637:
5638: IF l_result = OE_PC_GLOBALS.YES THEN
5639: -- set OUT result to CONSTRAINED
5640: x_result := OE_PC_GLOBALS.YES;
5641: END IF;
5642:
5643: END IF;
5644:

Line 5654: IF l_result = OE_PC_GLOBALS.YES THEN

5650: ,p_record => l_rowtype_rec
5651: ,x_on_operation_action => l_on_operation_action
5652: );
5653:
5654: IF l_result = OE_PC_GLOBALS.YES THEN
5655: -- set OUT result to CONSTRAINED
5656: x_result := OE_PC_GLOBALS.YES;
5657: END IF;
5658:

Line 5656: x_result := OE_PC_GLOBALS.YES;

5652: );
5653:
5654: IF l_result = OE_PC_GLOBALS.YES THEN
5655: -- set OUT result to CONSTRAINED
5656: x_result := OE_PC_GLOBALS.YES;
5657: END IF;
5658:
5659: END IF;
5660: /* Customer Acceptance - End */

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

5658:
5659: END IF;
5660: /* Customer Acceptance - End */
5661:
5662: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
5663: IF l_debug_level > 0 THEN
5664: oe_debug_pub.add('setting check all cols constraint to:'||l_check_all_cols_constraint);
5665: END IF;
5666: g_check_all_cols_constraint := l_check_all_cols_constraint;

Line 5695: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5691: END Attributes;
5692:
5693:
5694: FUNCTION IB_OWNER
5695: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5696: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5697: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5698: ) RETURN NUMBER
5699: IS

Line 5715: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5711: END IB_OWNER;
5712:
5713:
5714: FUNCTION IB_INSTALLED_AT_LOCATION
5715: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5716: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5717: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5718: ) RETURN NUMBER
5719: IS

Line 5734: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5730: RETURN(l_result);
5731: END IB_INSTALLED_AT_LOCATION;
5732:
5733: FUNCTION IB_CURRENT_LOCATION
5734: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5735: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5736: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5737: ) RETURN NUMBER
5738: IS

Line 5753: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5749: RETURN(l_result);
5750: END IB_CURRENT_LOCATION;
5751:
5752: FUNCTION END_CUSTOMER
5753: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5754: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5755: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5756: ) RETURN NUMBER
5757: IS

Line 5774: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5770: END END_CUSTOMER;
5771:
5772:
5773: FUNCTION END_CUSTOMER_SITE_USE
5774: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5775: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5776: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5777: ) RETURN NUMBER
5778: IS

Line 5795: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5791: END END_CUSTOMER_SITE_USE;
5792:
5793:
5794: FUNCTION END_CUSTOMER_CONTACT
5795: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5796: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5797: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
5798: ) RETURN NUMBER
5799: IS

Line 5857: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5853: END IF;
5854: END ALLOW_TRX_LINE_EXEMPTIONS;
5855:
5856: FUNCTION CONTINGENCY
5857: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5858: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5859: , x_on_operation_action OUT NOCOPY NUMBER
5860: ) RETURN NUMBER
5861: IS

Line 5875: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

5871:
5872: END CONTINGENCY;
5873:
5874: FUNCTION REVREC_EXPIRATION_DAYS
5875: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
5876: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
5877: , x_on_operation_action OUT NOCOPY NUMBER
5878: ) RETURN NUMBER
5879: IS