APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_ASSETS_H

Line 1603: select CSI_I_ASSETS_H_S.nextval

1599: l_count NUMBER;
1600: l_hist_id NUMBER;
1601: BEGIN
1602: l_count := p_asset_hist_tbl.count + 1;
1603: select CSI_I_ASSETS_H_S.nextval
1604: into l_hist_id
1605: from sys.dual;
1606:
1607: p_asset_hist_tbl(l_count).instance_asset_history_id := l_hist_id;

Line 5710: INSERT INTO CSI_I_ASSETS_H(

5706: --
5707: l_ctr := l_asset_hist_rec_tab.instance_asset_history_id.count;
5708: --
5709: FORALL i in 1 .. l_ctr
5710: INSERT INTO CSI_I_ASSETS_H(
5711: INSTANCE_ASSET_HISTORY_ID,
5712: INSTANCE_ASSET_ID,
5713: TRANSACTION_ID,
5714: OLD_INSTANCE_ID,

Line 7569: DELETE FROM CSI_I_ASSETS_H WHERE transaction_id = l_del_txn_tbl(j);

7565: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_del_txn_tbl(j);
7566: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7567: DELETE FROM CSI_IEA_VALUES_H WHERE transaction_id = l_del_txn_tbl(j);
7568: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7569: DELETE FROM CSI_I_ASSETS_H WHERE transaction_id = l_del_txn_tbl(j);
7570: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7571: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);
7572: END;
7573: END IF;