DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_ITEM_CATEGORIES

Line 971: PROCEDURE C_MTL_ITEM_CATEGORIES (

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,
974: X_eng_item_id IN NUMBER,
975: X_mfg_item_id IN NUMBER,

Line 982: INSERT INTO MTL_ITEM_CATEGORIES(

978: X_ecn_name IN VARCHAR2
979: )
980: IS
981: BEGIN
982: INSERT INTO MTL_ITEM_CATEGORIES(
983: CATEGORY_ID,
984: CATEGORY_SET_ID,
985: CREATED_BY,
986: CREATION_DATE,

Line 1010: FROM MTL_ITEM_CATEGORIES

1006: PROGRAM_APPLICATION_ID,
1007: PROGRAM_ID,
1008: PROGRAM_UPDATE_DATE,
1009: REQUEST_ID
1010: FROM MTL_ITEM_CATEGORIES
1011: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1012: AND ORGANIZATION_ID = X_org_id;
1013:
1014: EXCEPTION

Line 1016: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_CATEGORIES',

1012: AND ORGANIZATION_ID = X_org_id;
1013:
1014: EXCEPTION
1015: WHEN OTHERS THEN
1016: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_CATEGORIES',
1017: stmt_num => 1003,
1018: message_name => 'ENG_ENUBRT_ERROR',
1019: token => SQLERRM);
1020:

Line 1021: END C_MTL_ITEM_CATEGORIES;

1017: stmt_num => 1003,
1018: message_name => 'ENG_ENUBRT_ERROR',
1019: token => SQLERRM);
1020:
1021: END C_MTL_ITEM_CATEGORIES;
1022:
1023: PROCEDURE C_MTL_DESCR_ELEMENT_VALUES (
1024: X_org_id IN NUMBER,
1025: X_master_org IN NUMBER,