APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_REF_DESGS_INTERFACE

Line 1770: INSERT INTO BOM_REF_DESGS_INTERFACE (

1766:
1767:
1768: getListOfRefDesigs(L_COMP_REF_DESIG, l_comp_ref_desig_tbl);
1769: FOR I IN 1..l_comp_ref_desig_tbl.COUNT LOOP
1770: INSERT INTO BOM_REF_DESGS_INTERFACE (
1771: BATCH_ID,
1772: REQUEST_ID,
1773: TRANSACTION_TYPE,
1774: TRANSACTION_ID,

Line 1805: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1801:
1802: Dbms_Sql.Close_Cursor(l_cursor_select);
1803: END IF;
1804:
1805: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1806: SET(effectivity_date, operation_seq_num, from_end_item_unit_number, component_sequence_id, assembly_item_revision_code)
1807: = (SELECT Decode(effectivity_date,NULL,new_effectivity_date,effectivity_date),
1808: Decode(operation_seq_num,NULL,new_operation_seq_num,operation_seq_num),
1809: Decode(from_end_item_unit_number,NULL,new_from_end_item_unit_number,from_end_item_unit_number),