1143: token => SQLERRM);
1144:
1145: END C_MTL_RELATED_ITEMS;
1146:
1147: PROCEDURE C_CST_ITEM_COSTS (
1148: X_org_id IN NUMBER,
1149: X_master_org IN NUMBER,
1150: X_eng_item_id IN NUMBER,
1151: X_mfg_item_id IN NUMBER,
1155: )
1156: IS
1157: BEGIN
1158:
1159: INSERT INTO CST_ITEM_COSTS(
1160: ATTRIBUTE1,
1161: ATTRIBUTE10,
1162: ATTRIBUTE11,
1163: ATTRIBUTE12,
1265: TL_OUTSIDE_PROCESSING,
1266: TL_OVERHEAD,
1267: TL_RESOURCE,
1268: UNBURDENED_COST
1269: FROM CST_ITEM_COSTS
1270: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1271: AND ORGANIZATION_ID = X_org_id;
1272:
1273: EXCEPTION
1271: AND ORGANIZATION_ID = X_org_id;
1272:
1273: EXCEPTION
1274: WHEN OTHERS THEN
1275: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_ITEM_COSTS',
1276: stmt_num => 1006,
1277: message_name => 'ENG_ENUBRT_ERROR',
1278: token => SQLERRM);
1279:
1276: stmt_num => 1006,
1277: message_name => 'ENG_ENUBRT_ERROR',
1278: token => SQLERRM);
1279:
1280: END C_CST_ITEM_COSTS;
1281:
1282: PROCEDURE C_CST_ITEM_COST_DETAILS (
1283: X_org_id IN NUMBER,
1284: X_master_org IN NUMBER,