DBA Data[Home] [Help]

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 200: INSERT INTO MTL_SYSTEM_ITEMS(

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

Line 928: FROM MTL_SYSTEM_ITEMS

924: HAZARDOUS_MATERIAL_FLAG,
925: CAS_NUMBER
926: /* End Bug 3713912 */
927:
928: FROM MTL_SYSTEM_ITEMS
929: WHERE INVENTORY_ITEM_ID = X_eng_item_id
930: AND ORGANIZATION_ID = X_org_id;
931:
932: insert into MTL_SYSTEM_ITEMS_TL (

Line 932: insert into MTL_SYSTEM_ITEMS_TL (

928: FROM MTL_SYSTEM_ITEMS
929: WHERE INVENTORY_ITEM_ID = X_eng_item_id
930: AND ORGANIZATION_ID = X_org_id;
931:
932: insert into MTL_SYSTEM_ITEMS_TL (
933: INVENTORY_ITEM_ID,
934: ORGANIZATION_ID,
935: LANGUAGE,
936: SOURCE_LANG,

Line 958: from MTL_SYSTEM_ITEMS_TL T

954: from FND_LANGUAGES L
955: where L.INSTALLED_FLAG in ('I', 'B')
956: and not exists
957: ( select NULL
958: from MTL_SYSTEM_ITEMS_TL T
959: where T.INVENTORY_ITEM_ID = X_mfg_item_id
960: and T.ORGANIZATION_ID = X_master_org
961: and T.LANGUAGE = L.LANGUAGE_CODE );
962: EXCEPTION

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

960: and T.ORGANIZATION_ID = X_master_org
961: and T.LANGUAGE = L.LANGUAGE_CODE );
962: EXCEPTION
963: WHEN OTHERS THEN
964: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SYSTEM_ITEMS',
965: stmt_num => 1002,
966: message_name => 'ENG_ENUBRT_ERROR',
967: token => SQLERRM);
968:

Line 969: END C_MTL_SYSTEM_ITEMS;

965: stmt_num => 1002,
966: message_name => 'ENG_ENUBRT_ERROR',
967: token => SQLERRM);
968:
969: END C_MTL_SYSTEM_ITEMS;
970:
971: PROCEDURE C_MTL_ITEM_CATEGORIES (
972: X_org_id IN NUMBER,
973: X_master_org IN NUMBER,