DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_DESCR_ELEMENT_VALUES

Line 1038: PROCEDURE C_MTL_DESCR_ELEMENT_VALUES (

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,
1041: X_eng_item_id IN NUMBER,
1042: X_mfg_item_id IN NUMBER,

Line 1050: INSERT INTO MTL_DESCR_ELEMENT_VALUES(

1046: )
1047: IS
1048: BEGIN
1049:
1050: INSERT INTO MTL_DESCR_ELEMENT_VALUES(
1051: CREATED_BY,
1052: CREATION_DATE,
1053: DEFAULT_ELEMENT_FLAG,
1054: ELEMENT_NAME,

Line 1080: FROM MTL_DESCR_ELEMENT_VALUES

1076: PROGRAM_APPLICATION_ID,
1077: PROGRAM_ID,
1078: PROGRAM_UPDATE_DATE,
1079: REQUEST_ID
1080: FROM MTL_DESCR_ELEMENT_VALUES
1081: WHERE INVENTORY_ITEM_ID = X_eng_item_id;
1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN

Line 1085: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_DESCR_ELEMENT_VALUES',

1081: WHERE INVENTORY_ITEM_ID = X_eng_item_id;
1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_DESCR_ELEMENT_VALUES',
1086: stmt_num => 1004,
1087: message_name => 'ENG_ENUBRT_ERROR',
1088: token => SQLERRM);
1089:

Line 1090: END C_MTL_DESCR_ELEMENT_VALUES;

1086: stmt_num => 1004,
1087: message_name => 'ENG_ENUBRT_ERROR',
1088: token => SQLERRM);
1089:
1090: END C_MTL_DESCR_ELEMENT_VALUES;
1091:
1092: PROCEDURE C_MTL_RELATED_ITEMS (
1093: X_org_id IN NUMBER,
1094: X_master_org IN NUMBER,