DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_ITEM_CATEGORIES

Line 986: PROCEDURE C_MTL_ITEM_CATEGORIES (

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,
989: X_eng_item_id IN NUMBER,
990: X_mfg_item_id IN NUMBER,

Line 997: INSERT INTO MTL_ITEM_CATEGORIES(

993: X_ecn_name IN VARCHAR2
994: )
995: IS
996: BEGIN
997: INSERT INTO MTL_ITEM_CATEGORIES(
998: CATEGORY_ID,
999: CATEGORY_SET_ID,
1000: CREATED_BY,
1001: CREATION_DATE,

Line 1025: FROM MTL_ITEM_CATEGORIES

1021: PROGRAM_APPLICATION_ID,
1022: PROGRAM_ID,
1023: PROGRAM_UPDATE_DATE,
1024: REQUEST_ID
1025: FROM MTL_ITEM_CATEGORIES
1026: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1027: AND ORGANIZATION_ID = X_org_id;
1028:
1029: EXCEPTION

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

1027: AND ORGANIZATION_ID = X_org_id;
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_CATEGORIES',
1032: stmt_num => 1003,
1033: message_name => 'ENG_ENUBRT_ERROR',
1034: token => SQLERRM);
1035:

Line 1036: END C_MTL_ITEM_CATEGORIES;

1032: stmt_num => 1003,
1033: message_name => 'ENG_ENUBRT_ERROR',
1034: token => SQLERRM);
1035:
1036: END C_MTL_ITEM_CATEGORIES;
1037:
1038: PROCEDURE C_MTL_DESCR_ELEMENT_VALUES (
1039: X_org_id IN NUMBER,
1040: X_master_org IN NUMBER,