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

APPS.OE_LINE_SECURITY dependencies on OE_AK_ORDER_LINES_V

Line 15: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

11:
12: FUNCTION Is_Op_Constrained
13: ( p_operation IN VARCHAR2
14: , p_column_name IN VARCHAR2 DEFAULT NULL
15: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
16: , x_on_operation_action OUT NOCOPY NUMBER /* file.sql.39 change */
17: ) RETURN NUMBER IS
18: l_constraint_id NUMBER;
19: l_grp NUMBER;

Line 519: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 539: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 558: ,p_record IN oe_ak_order_lines_v%ROWTYPE

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

Line 576: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 595: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 615: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 637: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 658: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 678: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 698: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 718: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 738: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 759: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 780: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 800: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 820: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 840: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 860: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 880: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 900: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 920: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 940: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 960: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 980: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1000: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1020: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1040: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1062: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1083: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1104: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1125: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1146: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1167: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1188: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1209: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1230: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1251: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1272: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1292: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1313: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1334: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1355: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1376: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1398: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1419: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1439: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1460: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1480: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1500: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1521: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1542: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1563: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1584: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1605: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1626: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1689: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1741: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1762: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1783: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1804: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1825: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1845: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1867: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1887: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1908: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1929: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1950: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1971: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 1992: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2013: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2033: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2053: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2074: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2095: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2116: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2136: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2156: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2177: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2197: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2218: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2239: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2260: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2282: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2303: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2324: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2345: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2367: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2387: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2411: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2432: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2452: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2472: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2493: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2514: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2535: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2556: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2577: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2598: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2619: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2640: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2661: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2682: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2703: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2724: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2745: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2768: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2790: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2811: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2831: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2851: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2873: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2893: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2913: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2933: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2953: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2973: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 2993: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 3014: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 3036: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 3056: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 3076: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 3096: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 3122: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;

3118: , x_return_status OUT NOCOPY VARCHAR2 /* file.sql.39 change */
3119: ) IS
3120: l_operation VARCHAR2(1);
3121: l_on_operation_action NUMBER;
3122: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
3123: l_flow_status_code VARCHAR2(30);
3124: --
3125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3126: --

Line 3249: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;

3245: ) IS
3246: l_operation VARCHAR2(1);
3247: l_on_operation_action NUMBER;
3248: l_result NUMBER;
3249: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
3250: l_column_name VARCHAR2(30);
3251: l_active_flag VARCHAR2(1);
3252: l_check_all_cols_constraint VARCHAR2(1);
3253: --

Line 5379: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 5399: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 5418: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 5437: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 5458: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 5479: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 5541: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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

Line 5559: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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