APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_REF_DESGS_INTERFACE

Line 1713: INSERT INTO BOM_REF_DESGS_INTERFACE (

1709:
1710:
1711: getListOfRefDesigs(L_COMP_REF_DESIG, l_comp_ref_desig_tbl);
1712: FOR I IN 1..l_comp_ref_desig_tbl.COUNT LOOP
1713: INSERT INTO BOM_REF_DESGS_INTERFACE (
1714: BATCH_ID,
1715: REQUEST_ID,
1716: TRANSACTION_TYPE,
1717: TRANSACTION_ID,

Line 1748: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1744:
1745: Dbms_Sql.Close_Cursor(l_cursor_select);
1746: END IF;
1747:
1748: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1749: SET(effectivity_date, operation_seq_num, from_end_item_unit_number, component_sequence_id, assembly_item_revision_code)
1750: = (SELECT Decode(effectivity_date,NULL,new_effectivity_date,effectivity_date),
1751: Decode(operation_seq_num,NULL,new_operation_seq_num,operation_seq_num),
1752: Decode(from_end_item_unit_number,NULL,new_from_end_item_unit_number,from_end_item_unit_number),