DBA Data[Home] [Help]

APPS.INVPVALM dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 140: MTL_SYSTEM_ITEMS_INTERFACE msii

136: , msii.CREATE_SUPPLY_FLAG
137: , msii.SUBSTITUTION_WINDOW_CODE
138: , msii.SUBSTITUTION_WINDOW_DAYS
139: FROM
140: MTL_SYSTEM_ITEMS_INTERFACE msii
141: , MTL_PARAMETERS mp
142: WHERE
143: ( (msii.organization_id = org_id) OR (all_Org = 1) )
144: AND msii.process_flag = 2

Line 687: 'MTL_SYSTEM_ITEMS_INTERFACE',

683: request_id,
684: cr.TRANSACTION_ID,
685: error_msg,
686: 'MASTER_CHILD_1A',
687: 'MTL_SYSTEM_ITEMS_INTERFACE',
688: 'INV_IOI_MASTER_CHILD_1A',
689: err_text);
690: If dumm_status < 0 then
691: raise LOGGING_ERR ;

Line 693: update mtl_system_items_interface msii

689: err_text);
690: If dumm_status < 0 then
691: raise LOGGING_ERR ;
692: End If;
693: update mtl_system_items_interface msii
694: set process_flag = 3
695: where msii.transaction_id = cr.transaction_id;
696:
697: end; /* MASTER_CHILD_1A */

Line 723: 'MTL_SYSTEM_ITEMS_INTERFACE',

719: request_id,
720: cr.TRANSACTION_ID,
721: error_msg,
722: 'MASTER_CHILD_1C',
723: 'MTL_SYSTEM_ITEMS_INTERFACE',
724: 'INV_IOI_MASTER_CHILD_1C',
725: err_text);
726: If dumm_status < 0 then
727: raise LOGGING_ERR ;

Line 729: update mtl_system_items_interface msii

725: err_text);
726: If dumm_status < 0 then
727: raise LOGGING_ERR ;
728: End If;
729: update mtl_system_items_interface msii
730: set process_flag = 3
731: where msii.transaction_id = cr.transaction_id;
732:
733: end; /* MASTER_CHILD_1C */

Line 771: 'MTL_SYSTEM_ITEMS_INTERFACE',

767: request_id,
768: cr.TRANSACTION_ID,
769: error_msg,
770: 'MASTER_CHILD_1B',
771: 'MTL_SYSTEM_ITEMS_INTERFACE',
772: 'INV_IOI_MASTER_CHILD_1B',
773: err_text);
774:
775: If dumm_status < 0 then

Line 779: update mtl_system_items_interface msii

775: If dumm_status < 0 then
776: raise LOGGING_ERR ;
777: End If;
778:
779: update mtl_system_items_interface msii
780: set process_flag = 3
781: where msii.transaction_id = cr.transaction_id;
782:
783: end; /* MASTER_CHILD_1B */

Line 817: 'MTL_SYSTEM_ITEMS_INTERFACE',

813: request_id,
814: cr.TRANSACTION_ID,
815: error_msg,
816: 'MASTER_CHILD_1D',
817: 'MTL_SYSTEM_ITEMS_INTERFACE',
818: 'INV_IOI_MASTER_CHILD_1D',
819: err_text);
820: If dumm_status < 0 then
821: raise LOGGING_ERR ;

Line 823: update mtl_system_items_interface msii

819: err_text);
820: If dumm_status < 0 then
821: raise LOGGING_ERR ;
822: End If;
823: update mtl_system_items_interface msii
824: set process_flag = 3
825: where msii.transaction_id = cr.transaction_id;
826:
827: end; /* MASTER_CHILD_1D */

Line 857: 'MTL_SYSTEM_ITEMS_INTERFACE',

853: request_id,
854: cr.TRANSACTION_ID,
855: error_msg,
856: 'MASTER_CHILD_1E',
857: 'MTL_SYSTEM_ITEMS_INTERFACE',
858: 'INV_IOI_MASTER_CHILD_1E',
859: err_text);
860: If dumm_status < 0 then
861: raise LOGGING_ERR ;

Line 863: update mtl_system_items_interface msii

859: err_text);
860: If dumm_status < 0 then
861: raise LOGGING_ERR ;
862: End If;
863: update mtl_system_items_interface msii
864: set process_flag = 3
865: where msii.transaction_id = cr.transaction_id;
866:
867: end; /* MASTER_CHILD_1E */

Line 893: 'MTL_SYSTEM_ITEMS_INTERFACE',

889: request_id,
890: cr.TRANSACTION_ID,
891: error_msg,
892: 'MASTER_CHILD_1F',
893: 'MTL_SYSTEM_ITEMS_INTERFACE',
894: 'INV_IOI_MASTER_CHILD_1F',
895: err_text);
896: If dumm_status < 0 then
897: raise LOGGING_ERR ;

Line 899: update mtl_system_items_interface msii

895: err_text);
896: If dumm_status < 0 then
897: raise LOGGING_ERR ;
898: End If;
899: update mtl_system_items_interface msii
900: set process_flag = 3
901: where msii.transaction_id = cr.transaction_id;
902:
903: end; /* MASTER_CHILD_1F */

Line 937: 'MTL_SYSTEM_ITEMS_INTERFACE',

933: request_id,
934: cr.TRANSACTION_ID,
935: error_msg,
936: 'MASTER_CHILD_1G',
937: 'MTL_SYSTEM_ITEMS_INTERFACE',
938: 'INV_IOI_MASTER_CHILD_1G',
939: err_text);
940: If dumm_status < 0 then
941: raise LOGGING_ERR ;

Line 943: update mtl_system_items_interface msii

939: err_text);
940: If dumm_status < 0 then
941: raise LOGGING_ERR ;
942: End If;
943: update mtl_system_items_interface msii
944: set process_flag = 3
945: where msii.transaction_id = cr.transaction_id;
946:
947: end; /* MASTER_CHILD_1G */

Line 991: 'MTL_SYSTEM_ITEMS_INTERFACE',

987: request_id,
988: cr.TRANSACTION_ID,
989: error_msg,
990: 'MASTER_CHILD_1HA',
991: 'MTL_SYSTEM_ITEMS_INTERFACE',
992: 'INV_IOI_MASTER_CHILD_1HA',
993: err_text );
994:
995: IF dumm_status < 0 THEN

Line 999: update mtl_system_items_interface msii

995: IF dumm_status < 0 THEN
996: raise LOGGING_ERR ;
997: END IF;
998:
999: update mtl_system_items_interface msii
1000: set process_flag = 3
1001: where msii.transaction_id = cr.transaction_id;
1002:
1003: END; /* MASTER_CHILD_1HA */

Line 1051: 'MTL_SYSTEM_ITEMS_INTERFACE',

1047: request_id,
1048: cr.TRANSACTION_ID,
1049: error_msg,
1050: 'MASTER_CHILD_1HB',
1051: 'MTL_SYSTEM_ITEMS_INTERFACE',
1052: 'INV_IOI_MASTER_CHILD_1HB',
1053: err_text );
1054:
1055: IF dumm_status < 0 THEN

Line 1059: update mtl_system_items_interface msii

1055: IF dumm_status < 0 THEN
1056: raise LOGGING_ERR ;
1057: END IF;
1058:
1059: update mtl_system_items_interface msii
1060: set process_flag = 3
1061: where msii.transaction_id = cr.transaction_id;
1062:
1063: END; /* MASTER_CHILD_1HB */

Line 1111: 'MTL_SYSTEM_ITEMS_INTERFACE',

1107: request_id,
1108: cr.TRANSACTION_ID,
1109: error_msg,
1110: 'MASTER_CHILD_1HC',
1111: 'MTL_SYSTEM_ITEMS_INTERFACE',
1112: 'INV_IOI_MASTER_CHILD_1HC',
1113: err_text );
1114:
1115: IF dumm_status < 0 THEN

Line 1119: update mtl_system_items_interface msii

1115: IF dumm_status < 0 THEN
1116: raise LOGGING_ERR ;
1117: END IF;
1118:
1119: update mtl_system_items_interface msii
1120: set process_flag = 3
1121: where msii.transaction_id = cr.transaction_id;
1122:
1123: END; /* MASTER_CHILD_1HC */

Line 1172: 'MTL_SYSTEM_ITEMS_INTERFACE',

1168: request_id,
1169: cr.TRANSACTION_ID,
1170: error_msg,
1171: 'MASTER_CHILD_1HD',
1172: 'MTL_SYSTEM_ITEMS_INTERFACE',
1173: 'INV_IOI_MASTER_CHILD_1HD',
1174: err_text );
1175:
1176: IF dumm_status < 0 THEN

Line 1180: update mtl_system_items_interface msii

1176: IF dumm_status < 0 THEN
1177: raise LOGGING_ERR ;
1178: END IF;
1179:
1180: update mtl_system_items_interface msii
1181: set process_flag = 3
1182: where msii.transaction_id = cr.transaction_id;
1183:
1184: END; /* MASTER_CHILD_1HD */

Line 1242: 'MTL_SYSTEM_ITEMS_INTERFACE',

1238: request_id,
1239: cr.TRANSACTION_ID,
1240: error_msg,
1241: 'MASTER_CHILD_1IA',
1242: 'MTL_SYSTEM_ITEMS_INTERFACE',
1243: 'INV_IOI_MASTER_CHILD_1IA',
1244: err_text );
1245:
1246: IF dumm_status < 0 THEN

Line 1250: update mtl_system_items_interface msii

1246: IF dumm_status < 0 THEN
1247: raise LOGGING_ERR ;
1248: END IF;
1249:
1250: update mtl_system_items_interface msii
1251: set process_flag = 3
1252: where msii.transaction_id = cr.transaction_id;
1253:
1254: END; /* MASTER_CHILD_1IA */

Line 1298: 'MTL_SYSTEM_ITEMS_INTERFACE',

1294: request_id,
1295: cr.TRANSACTION_ID,
1296: error_msg,
1297: 'MASTER_CHILD_1IB',
1298: 'MTL_SYSTEM_ITEMS_INTERFACE',
1299: 'INV_IOI_MASTER_CHILD_1IB',
1300: err_text );
1301:
1302: IF dumm_status < 0 THEN

Line 1306: update mtl_system_items_interface msii

1302: IF dumm_status < 0 THEN
1303: raise LOGGING_ERR ;
1304: END IF;
1305:
1306: update mtl_system_items_interface msii
1307: set process_flag = 3
1308: where msii.transaction_id = cr.transaction_id;
1309:
1310: END; /* MASTER_CHILD_1IB */

Line 1348: 'MTL_SYSTEM_ITEMS_INTERFACE',

1344: request_id,
1345: cr.TRANSACTION_ID,
1346: error_msg,
1347: 'MASTER_CHILD_1IC',
1348: 'MTL_SYSTEM_ITEMS_INTERFACE',
1349: 'INV_IOI_MASTER_CHILD_1IC',
1350: err_text );
1351:
1352: IF dumm_status < 0 THEN

Line 1356: update mtl_system_items_interface msii

1352: IF dumm_status < 0 THEN
1353: raise LOGGING_ERR ;
1354: END IF;
1355:
1356: update mtl_system_items_interface msii
1357: set process_flag = 3
1358: where msii.transaction_id = cr.transaction_id;
1359:
1360: END; /* MASTER_CHILD_1Ic */

Line 1448: 'MTL_SYSTEM_ITEMS_INTERFACE',

1444: request_id,
1445: cr.TRANSACTION_ID,
1446: error_msg,
1447: 'MASTER_CHILD_1J',
1448: 'MTL_SYSTEM_ITEMS_INTERFACE',
1449: 'INV_IOI_MASTER_CHILD_1J',
1450: err_text );
1451:
1452: IF dumm_status < 0 THEN

Line 1456: update mtl_system_items_interface msii

1452: IF dumm_status < 0 THEN
1453: raise LOGGING_ERR;
1454: END IF;
1455:
1456: update mtl_system_items_interface msii
1457: set process_flag = 3
1458: where msii.transaction_id = cr.transaction_id;
1459:
1460: END; /* MASTER_CHILD_1J */

Line 1529: 'MTL_SYSTEM_ITEMS_INTERFACE',

1525: request_id,
1526: cr.TRANSACTION_ID,
1527: error_msg,
1528: 'MASTER_CHILD_1K',
1529: 'MTL_SYSTEM_ITEMS_INTERFACE',
1530: 'INV_IOI_MASTER_CHILD_1K',
1531: err_text );
1532:
1533: IF dumm_status < 0 THEN

Line 1537: update mtl_system_items_interface msii

1533: IF dumm_status < 0 THEN
1534: raise LOGGING_ERR;
1535: END IF;
1536:
1537: update mtl_system_items_interface msii
1538: set process_flag = 3
1539: where msii.transaction_id = cr.transaction_id;
1540:
1541: END; /* MASTER_CHILD_1K */

Line 1563: 'MTL_SYSTEM_ITEMS_INTERFACE',

1559: request_id,
1560: trans_id,
1561: err_text,
1562: 'MASTER_CHILD_1',
1563: 'MTL_SYSTEM_ITEMS_INTERFACE',
1564: 'BOM_OP_VALIDATION_ERR',
1565: err_text);
1566: return(status);
1567: