DBA Data[Home] [Help]

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 521: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
525: l_result NUMBER;

Line 541: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
545: l_result NUMBER;

Line 560: ,p_record IN oe_ak_order_lines_v%ROWTYPE

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;
564: BEGIN

Line 578: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
582: l_result NUMBER :=0;

Line 597: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
601: l_result NUMBER;

Line 617: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
621: l_result NUMBER;

Line 639: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
643: l_result NUMBER;

Line 660: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
664: l_result NUMBER;

Line 680: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
684: l_result NUMBER;

Line 700: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
704: l_result NUMBER;

Line 720: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
724: l_result NUMBER;

Line 740: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
744: l_result NUMBER;

Line 761: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
765: l_result NUMBER;

Line 782: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
786: l_result NUMBER;

Line 802: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
806: l_result NUMBER;

Line 822: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
826: l_result NUMBER;

Line 842: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
846: l_result NUMBER;

Line 862: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
866: l_result NUMBER;

Line 882: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
886: l_result NUMBER;

Line 902: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
906: l_result NUMBER;

Line 922: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
926: l_result NUMBER;

Line 942: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
946: l_result NUMBER;

Line 962: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
966: l_result NUMBER;

Line 982: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
986: l_result NUMBER;

Line 1002: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1006: l_result NUMBER;

Line 1022: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1026: l_result NUMBER;

Line 1042: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1046: l_result NUMBER;

Line 1063: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1067: l_result NUMBER;

Line 1082: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1086: l_result NUMBER;

Line 1102: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1106: l_result NUMBER;

Line 1127: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1131: l_result NUMBER;

Line 1148: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1152: l_result NUMBER;

Line 1169: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1173: l_result NUMBER;

Line 1190: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1194: l_result NUMBER;

Line 1211: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1215: l_result NUMBER;

Line 1232: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1236: l_result NUMBER;

Line 1253: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1257: l_result NUMBER;

Line 1274: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1278: l_result NUMBER;

Line 1295: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1299: l_result NUMBER;

Line 1316: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1320: l_result NUMBER;

Line 1337: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1341: l_result NUMBER;

Line 1358: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1362: l_result NUMBER;

Line 1378: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1382: l_result NUMBER;

Line 1399: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1403: l_result NUMBER;

Line 1420: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1424: l_result NUMBER;

Line 1441: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1445: l_result NUMBER;

Line 1462: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1466: l_result NUMBER;

Line 1484: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1488: l_result NUMBER;

Line 1505: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1509: l_result NUMBER;

Line 1525: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1529: l_result NUMBER;

Line 1546: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1550: l_result NUMBER;

Line 1566: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1570: l_result NUMBER;

Line 1586: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1590: l_result NUMBER;

Line 1607: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1611: l_result NUMBER;

Line 1628: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1632: l_result NUMBER;

Line 1649: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1653: l_result NUMBER;

Line 1670: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1674: l_result NUMBER;

Line 1691: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1695: l_result NUMBER;

Line 1712: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1716: l_result NUMBER;

Line 1775: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1779: l_result NUMBER;

Line 1827: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1831: l_result NUMBER;

Line 1848: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1852: l_result NUMBER;

Line 1869: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1873: l_result NUMBER;

Line 1890: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1894: l_result NUMBER;

Line 1911: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1915: l_result NUMBER;

Line 1931: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1935: l_result NUMBER;

Line 1953: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1957: l_result NUMBER;

Line 1973: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1977: l_result NUMBER;

Line 1994: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
1998: l_result NUMBER;

Line 2015: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2019: l_result NUMBER;

Line 2036: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2040: l_result NUMBER;

Line 2057: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2061: l_result NUMBER;

Line 2078: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2082: l_result NUMBER;

Line 2099: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2103: l_result NUMBER;

Line 2119: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2123: l_result NUMBER;

Line 2139: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2143: l_result NUMBER;

Line 2160: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2164: l_result NUMBER;

Line 2181: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2185: l_result NUMBER;

Line 2202: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2206: l_result NUMBER;

Line 2222: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2226: l_result NUMBER;

Line 2242: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2246: l_result NUMBER;

Line 2263: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2267: l_result NUMBER;

Line 2283: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2287: l_result NUMBER;

Line 2304: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2308: l_result NUMBER;

Line 2325: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2329: l_result NUMBER;

Line 2346: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2350: l_result NUMBER;

Line 2368: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2372: l_result NUMBER;

Line 2389: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2393: l_result NUMBER;

Line 2410: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2414: l_result NUMBER;

Line 2431: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2435: l_result NUMBER;

Line 2453: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2457: l_result NUMBER;

Line 2473: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2477: l_result NUMBER;

Line 2497: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2501: l_result NUMBER;

Line 2518: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2522: l_result NUMBER;

Line 2538: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2542: l_result NUMBER;

Line 2558: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2562: l_result NUMBER;

Line 2579: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2583: l_result NUMBER;

Line 2600: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2604: l_result NUMBER;

Line 2621: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2625: l_result NUMBER;

Line 2642: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2646: l_result NUMBER;

Line 2663: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2667: l_result NUMBER;

Line 2684: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2688: l_result NUMBER;

Line 2705: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2709: l_result NUMBER;

Line 2726: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2730: l_result NUMBER;

Line 2747: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2751: l_result NUMBER;

Line 2768: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2772: l_result NUMBER;

Line 2789: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2793: l_result NUMBER;

Line 2810: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2814: l_result NUMBER;

Line 2831: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2835: l_result NUMBER;

Line 2854: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2858: l_result NUMBER;

Line 2876: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2880: l_result NUMBER;

Line 2897: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2901: l_result NUMBER;

Line 2917: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2921: l_result NUMBER;

Line 2937: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2941: l_result NUMBER;

Line 2959: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2963: l_result NUMBER;

Line 2979: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
2983: l_result NUMBER;

Line 2999: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3003: l_result NUMBER;

Line 3019: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3023: l_result NUMBER;

Line 3039: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3043: l_result NUMBER;

Line 3059: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3063: l_result NUMBER;

Line 3079: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3083: l_result NUMBER;

Line 3099: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3103: l_result NUMBER;

Line 3116: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3120: l_result NUMBER;

Line 3133: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3137: l_result NUMBER;

Line 3150: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3154: l_result NUMBER;

Line 3167: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3171: l_result NUMBER;

Line 3186: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3190: l_result NUMBER;

Line 3208: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3212: l_result NUMBER;

Line 3228: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3232: l_result NUMBER;

Line 3248: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3252: l_result NUMBER;

Line 3268: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
3272: l_result NUMBER;

Line 3294: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;

3290: , x_return_status OUT NOCOPY VARCHAR2 /* file.sql.39 change */
3291: ) IS
3292: l_operation VARCHAR2(1);
3293: l_on_operation_action NUMBER;
3294: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
3295: l_flow_status_code VARCHAR2(30);
3296: --
3297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3298: --

Line 3427: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;

3423: ) IS
3424: l_operation VARCHAR2(1);
3425: l_on_operation_action NUMBER;
3426: l_result NUMBER;
3427: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
3428: l_column_name VARCHAR2(30);
3429: l_active_flag VARCHAR2(1);
3430: l_check_all_cols_constraint VARCHAR2(1);
3431: --

Line 5696: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
5700: l_result NUMBER;

Line 5716: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
5720: l_result NUMBER;

Line 5735: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
5739: l_result NUMBER;

Line 5754: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
5758: l_result NUMBER;

Line 5775: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
5779: l_result NUMBER;

Line 5796: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
5800: l_result NUMBER;

Line 5858: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
5862: l_result NUMBER;

Line 5876: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

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
5880: l_result NUMBER;