APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_I_ASSETS

Line 753: select CSI_I_ASSETS_H_S.nextval

749: ) IS
750:
751: BEGIN
752: FOR i in p_asset_tbl.FIRST .. p_asset_tbl.LAST LOOP
753: select CSI_I_ASSETS_H_S.nextval
754: into p_asset_hist_tbl(i) from dual;
755: --
756: p_asset_rec_tab.instance_asset_id(i) := p_asset_tbl(i).instance_asset_id;
757: p_asset_rec_tab.instance_id(i) := p_asset_tbl(i).instance_id;

Line 984: FROM csi_i_assets

980: x_asset_tbl(l_ind).active_start_date := p_asset_h_tbl(l_ind).active_start_date;
981: x_asset_tbl(l_ind).active_end_date := p_asset_h_tbl(l_ind).active_end_date;
982: SELECT object_version_number
983: INTO x_asset_tbl(l_ind).object_version_number
984: FROM csi_i_assets
985: WHERE instance_asset_id = p_asset_h_tbl(l_ind).instance_asset_id;
986:
987: END LOOP;
988: END IF;

Line 2657: INSERT INTO CSI_I_ASSETS_H(

2653: --
2654: -- Insert into History
2655: log('Before Inserting into Assets history');
2656: FORALL i in 1 .. l_asset_rec_tab.instance_asset_id.count
2657: INSERT INTO CSI_I_ASSETS_H(
2658: INSTANCE_ASSET_HISTORY_ID,
2659: INSTANCE_ASSET_ID,
2660: TRANSACTION_ID,
2661: NEW_INSTANCE_ID,