APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 143: PROCEDURE C_MTL_SYSTEM_ITEMS (

139: token => SQLERRM);
140:
141: END C_MTL_ITEM_REVISIONS;
142:
143: PROCEDURE C_MTL_SYSTEM_ITEMS (
144: X_org_id IN NUMBER,
145: X_master_org IN NUMBER,
146: X_eng_item_id IN NUMBER,
147: X_mfg_item_id IN NUMBER,

Line 202: INSERT INTO MTL_SYSTEM_ITEMS(

198: where organization_id = X_master_org;
199: end if;
200: /* Bug 4466566 */
201:
202: INSERT INTO MTL_SYSTEM_ITEMS(
203: ACCEPTABLE_EARLY_DAYS,
204: ACCEPTABLE_RATE_DECREASE,
205: ACCEPTABLE_RATE_INCREASE,
206: ACCOUNTING_RULE_ID,

Line 930: FROM MTL_SYSTEM_ITEMS

926: HAZARDOUS_MATERIAL_FLAG,
927: CAS_NUMBER
928: /* End Bug 3713912 */
929:
930: FROM MTL_SYSTEM_ITEMS
931: WHERE INVENTORY_ITEM_ID = X_eng_item_id
932: AND ORGANIZATION_ID = X_org_id;
933:
934: /* Select Statement to fetch Long_Descrition -Bug 7591561 */

Line 937: FROM MTL_SYSTEM_ITEMS_TL

933:
934: /* Select Statement to fetch Long_Descrition -Bug 7591561 */
935: SELECT long_description
936: INTO X_long_description
937: FROM MTL_SYSTEM_ITEMS_TL
938: WHERE INVENTORY_ITEM_ID = X_eng_item_id
939: AND ORGANIZATION_ID = X_org_id
940: AND LANGUAGE=userenv('LANG');
941: /* End Bug 7591561 */

Line 943: insert into MTL_SYSTEM_ITEMS_TL (

939: AND ORGANIZATION_ID = X_org_id
940: AND LANGUAGE=userenv('LANG');
941: /* End Bug 7591561 */
942:
943: insert into MTL_SYSTEM_ITEMS_TL (
944: INVENTORY_ITEM_ID,
945: ORGANIZATION_ID,
946: LANGUAGE,
947: SOURCE_LANG,

Line 973: from MTL_SYSTEM_ITEMS_TL T

969: from FND_LANGUAGES L
970: where L.INSTALLED_FLAG in ('I', 'B')
971: and not exists
972: ( select NULL
973: from MTL_SYSTEM_ITEMS_TL T
974: where T.INVENTORY_ITEM_ID = X_mfg_item_id
975: and T.ORGANIZATION_ID = X_master_org
976: and T.LANGUAGE = L.LANGUAGE_CODE );
977: EXCEPTION

Line 979: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SYSTEM_ITEMS',

975: and T.ORGANIZATION_ID = X_master_org
976: and T.LANGUAGE = L.LANGUAGE_CODE );
977: EXCEPTION
978: WHEN OTHERS THEN
979: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SYSTEM_ITEMS',
980: stmt_num => 1002,
981: message_name => 'ENG_ENUBRT_ERROR',
982: token => SQLERRM);
983:

Line 984: END C_MTL_SYSTEM_ITEMS;

980: stmt_num => 1002,
981: message_name => 'ENG_ENUBRT_ERROR',
982: token => SQLERRM);
983:
984: END C_MTL_SYSTEM_ITEMS;
985:
986: PROCEDURE C_MTL_ITEM_CATEGORIES (
987: X_org_id IN NUMBER,
988: X_master_org IN NUMBER,