DBA Data[Home] [Help]

APPS.INVPVLM2 dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 130: from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

126: ,msii.REPAIR_LEADTIME
127: ,msii.REPAIR_PROGRAM
128: ,msii.REPAIR_YIELD
129: ,msii.PREPOSITION_POINT
130: from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
131: where ((msii.organization_id = org_id) or
132: (all_Org = 1))
133: and msii.process_flag = 2
134: and msii.organization_id = mp.organization_id

Line 615: 'MTL_SYSTEM_ITEMS_INTERFACE',

611: request_id,
612: cr.TRANSACTION_ID,
613: error_msg,
614: 'MASTER_CHILD_4A',
615: 'MTL_SYSTEM_ITEMS_INTERFACE',
616: 'INV_IOI_MASTER_CHILD_4A',
617: err_text);
618: If dumm_status < 0 Then
619: raise LOGGING_ERR ;

Line 621: update mtl_system_items_interface msii

617: err_text);
618: If dumm_status < 0 Then
619: raise LOGGING_ERR ;
620: End if ;
621: update mtl_system_items_interface msii
622: set process_flag = 3
623: where msii.transaction_id = cr.transaction_id;
624:
625: end; /* MASTER_CHILD_4A */

Line 655: 'MTL_SYSTEM_ITEMS_INTERFACE',

651: request_id,
652: cr.TRANSACTION_ID,
653: error_msg,
654: 'MASTER_CHILD_4B',
655: 'MTL_SYSTEM_ITEMS_INTERFACE',
656: 'INV_IOI_MASTER_CHILD_4B',
657: err_text);
658: If dumm_status < 0 Then
659: raise LOGGING_ERR ;

Line 661: update mtl_system_items_interface msii

657: err_text);
658: If dumm_status < 0 Then
659: raise LOGGING_ERR ;
660: End if ;
661: update mtl_system_items_interface msii
662: set process_flag = 3
663: where msii.transaction_id = cr.transaction_id;
664:
665: end; /* MASTER_CHILD_4B */

Line 694: 'MTL_SYSTEM_ITEMS_INTERFACE',

690: request_id,
691: cr.TRANSACTION_ID,
692: error_msg,
693: 'MASTER_CHILD_4C',
694: 'MTL_SYSTEM_ITEMS_INTERFACE',
695: 'INV_IOI_MASTER_CHILD_4C',
696: err_text);
697: If dumm_status < 0 Then
698: raise LOGGING_ERR ;

Line 700: update mtl_system_items_interface msii

696: err_text);
697: If dumm_status < 0 Then
698: raise LOGGING_ERR ;
699: End if ;
700: update mtl_system_items_interface msii
701: set process_flag = 3
702: where msii.transaction_id = cr.transaction_id;
703:
704: end; /* MASTER_CHILD_4C */

Line 734: 'MTL_SYSTEM_ITEMS_INTERFACE',

730: request_id,
731: cr.TRANSACTION_ID,
732: error_msg,
733: 'MASTER_CHILD_4D',
734: 'MTL_SYSTEM_ITEMS_INTERFACE',
735: 'INV_IOI_MASTER_CHILD_4D',
736: err_text);
737: If dumm_status < 0 Then
738: raise LOGGING_ERR ;

Line 740: update mtl_system_items_interface msii

736: err_text);
737: If dumm_status < 0 Then
738: raise LOGGING_ERR ;
739: End if ;
740: update mtl_system_items_interface msii
741: set process_flag = 3
742: where msii.transaction_id = cr.transaction_id;
743:
744: end; /* MASTER_CHILD_4D */

Line 773: 'MTL_SYSTEM_ITEMS_INTERFACE',

769: request_id,
770: cr.TRANSACTION_ID,
771: error_msg,
772: 'MASTER_CHILD_4E',
773: 'MTL_SYSTEM_ITEMS_INTERFACE',
774: 'INV_IOI_MASTER_CHILD_4E',
775: err_text);
776: If dumm_status < 0 Then
777: raise LOGGING_ERR ;

Line 779: update mtl_system_items_interface msii

775: err_text);
776: If dumm_status < 0 Then
777: raise LOGGING_ERR ;
778: End if ;
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_4E */

Line 813: 'MTL_SYSTEM_ITEMS_INTERFACE',

809: request_id,
810: cr.TRANSACTION_ID,
811: error_msg,
812: 'MASTER_CHILD_4F',
813: 'MTL_SYSTEM_ITEMS_INTERFACE',
814: 'INV_IOI_MASTER_CHILD_4F',
815: err_text);
816: If dumm_status < 0 Then
817: raise LOGGING_ERR ;

Line 819: update mtl_system_items_interface msii

815: err_text);
816: If dumm_status < 0 Then
817: raise LOGGING_ERR ;
818: End if ;
819: update mtl_system_items_interface msii
820: set process_flag = 3
821: where msii.transaction_id = cr.transaction_id;
822:
823: end; /* MASTER_CHILD_4F */

Line 854: 'MTL_SYSTEM_ITEMS_INTERFACE',

850: request_id,
851: cr.TRANSACTION_ID,
852: error_msg,
853: 'MASTER_CHILD_4G',
854: 'MTL_SYSTEM_ITEMS_INTERFACE',
855: 'INV_IOI_MASTER_CHILD_4G',
856: err_text);
857: If dumm_status < 0 Then
858: raise LOGGING_ERR ;

Line 860: update mtl_system_items_interface msii

856: err_text);
857: If dumm_status < 0 Then
858: raise LOGGING_ERR ;
859: End if ;
860: update mtl_system_items_interface msii
861: set process_flag = 3
862: where msii.transaction_id = cr.transaction_id;
863:
864: end; /* MASTER_CHILD_4G */

Line 894: 'MTL_SYSTEM_ITEMS_INTERFACE',

890: request_id,
891: cr.TRANSACTION_ID,
892: error_msg,
893: 'MASTER_CHILD_4H',
894: 'MTL_SYSTEM_ITEMS_INTERFACE',
895: 'INV_IOI_MASTER_CHILD_4H',
896: err_text);
897: If dumm_status < 0 Then
898: raise LOGGING_ERR ;

Line 900: update mtl_system_items_interface msii

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

Line 934: 'MTL_SYSTEM_ITEMS_INTERFACE',

930: request_id,
931: cr.TRANSACTION_ID,
932: error_msg,
933: 'MASTER_CHILD_4I',
934: 'MTL_SYSTEM_ITEMS_INTERFACE',
935: 'INV_IOI_MASTER_CHILD_4I',
936: err_text);
937: If dumm_status < 0 Then
938: raise LOGGING_ERR ;

Line 940: update mtl_system_items_interface msii

936: err_text);
937: If dumm_status < 0 Then
938: raise LOGGING_ERR ;
939: End if ;
940: update mtl_system_items_interface msii
941: set process_flag = 3
942: where msii.transaction_id = cr.transaction_id;
943:
944: end; /* MASTER_CHILD_4I */

Line 972: 'MTL_SYSTEM_ITEMS_INTERFACE',

968: request_id,
969: cr.TRANSACTION_ID,
970: error_msg,
971: 'MASTER_CHILD_4J',
972: 'MTL_SYSTEM_ITEMS_INTERFACE',
973: 'INV_IOI_MASTER_CHILD_4J',
974: err_text);
975: If dumm_status < 0 Then
976: raise LOGGING_ERR ;

Line 978: update mtl_system_items_interface msii

974: err_text);
975: If dumm_status < 0 Then
976: raise LOGGING_ERR ;
977: End if ;
978: update mtl_system_items_interface msii
979: set process_flag = 3
980: where msii.transaction_id = cr.transaction_id;
981:
982: end; /* MASTER_CHILD_4J */

Line 1013: 'MTL_SYSTEM_ITEMS_INTERFACE',

1009: request_id,
1010: cr.TRANSACTION_ID,
1011: error_msg,
1012: 'MASTER_CHILD_4K',
1013: 'MTL_SYSTEM_ITEMS_INTERFACE',
1014: 'INV_IOI_MASTER_CHILD_4K',
1015: err_text);
1016: If dumm_status < 0 Then
1017: raise LOGGING_ERR ;

Line 1019: update mtl_system_items_interface msii

1015: err_text);
1016: If dumm_status < 0 Then
1017: raise LOGGING_ERR ;
1018: End if ;
1019: update mtl_system_items_interface msii
1020: set process_flag = 3
1021: where msii.transaction_id = cr.transaction_id;
1022:
1023: end; /* MASTER_CHILD_4K */

Line 1052: 'MTL_SYSTEM_ITEMS_INTERFACE',

1048: request_id,
1049: cr.TRANSACTION_ID,
1050: error_msg,
1051: 'MASTER_CHILD_4L',
1052: 'MTL_SYSTEM_ITEMS_INTERFACE',
1053: 'INV_IOI_MASTER_CHILD_4L',
1054: err_text);
1055: If dumm_status < 0 Then
1056: raise LOGGING_ERR ;

Line 1058: update mtl_system_items_interface msii

1054: err_text);
1055: If dumm_status < 0 Then
1056: raise LOGGING_ERR ;
1057: End if ;
1058: update mtl_system_items_interface msii
1059: set process_flag = 3
1060: where msii.transaction_id = cr.transaction_id;
1061:
1062: end; /* MASTER_CHILD_4L */

Line 1086: 'MTL_SYSTEM_ITEMS_INTERFACE',

1082: request_id,
1083: cr.TRANSACTION_ID,
1084: error_msg,
1085: 'MASTER_CHILD_4M',
1086: 'MTL_SYSTEM_ITEMS_INTERFACE',
1087: 'INV_IOI_MASTER_CHILD_4M',
1088: err_text);
1089: If dumm_status < 0 Then
1090: raise LOGGING_ERR ;

Line 1092: update mtl_system_items_interface msii

1088: err_text);
1089: If dumm_status < 0 Then
1090: raise LOGGING_ERR ;
1091: End if ;
1092: update mtl_system_items_interface msii
1093: set process_flag = 3
1094: where msii.transaction_id = cr.transaction_id;
1095:
1096: end; /* MASTER_CHILD_4M */

Line 1118: 'MTL_SYSTEM_ITEMS_INTERFACE',

1114: request_id,
1115: cr.TRANSACTION_ID,
1116: error_msg,
1117: 'MASTER_CHILD_4M',
1118: 'MTL_SYSTEM_ITEMS_INTERFACE',
1119: 'INV_IOI_MASTER_CHILD_4N',
1120: err_text);
1121: If dumm_status < 0 Then
1122: raise LOGGING_ERR ;

Line 1124: update mtl_system_items_interface msii

1120: err_text);
1121: If dumm_status < 0 Then
1122: raise LOGGING_ERR ;
1123: End if ;
1124: update mtl_system_items_interface msii
1125: set process_flag = 3
1126: where msii.transaction_id = cr.transaction_id;
1127:
1128: end; /* MASTER_CHILD_4N */

Line 1151: 'MTL_SYSTEM_ITEMS_INTERFACE',

1147: request_id,
1148: cr.TRANSACTION_ID,
1149: error_msg,
1150: 'MASTER_CHILD_4M',
1151: 'MTL_SYSTEM_ITEMS_INTERFACE',
1152: 'INV_IOI_MASTER_CHILD_4O',
1153: err_text);
1154: If dumm_status < 0 Then
1155: raise LOGGING_ERR ;

Line 1157: update mtl_system_items_interface msii

1153: err_text);
1154: If dumm_status < 0 Then
1155: raise LOGGING_ERR ;
1156: End if ;
1157: update mtl_system_items_interface msii
1158: set process_flag = 3
1159: where msii.transaction_id = cr.transaction_id;
1160:
1161: end; /* MASTER_CHILD_40 */

Line 1183: 'MTL_SYSTEM_ITEMS_INTERFACE',

1179: request_id,
1180: trans_id,
1181: err_text,
1182: 'MASTER_CHILD_4',
1183: 'MTL_SYSTEM_ITEMS_INTERFACE',
1184: 'BOM_OP_VALIDATION_ERR',
1185: err_text);
1186:
1187: return(status);