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,
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,
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
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:
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,