APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_ITEM_INSTANCES_H

Line 818: select CSI_ITEM_INSTANCES_H_S.nextval

814: l_count NUMBER;
815: l_hist_id NUMBER;
816: BEGIN
817: l_count := p_inst_hist_tbl.count + 1;
818: select CSI_ITEM_INSTANCES_H_S.nextval
819: into l_hist_id
820: from sys.dual;
821: p_inst_hist_tbl(l_count).instance_id := p_inst_rec.instance_id;
822: p_inst_hist_tbl(l_count).instance_history_id := l_hist_id;

Line 3478: INSERT INTO CSI_ITEM_INSTANCES_H(

3474: --
3475: l_ctr := l_inst_hist_rec_tab.instance_history_id.count;
3476: --
3477: FORALL i in 1 .. l_ctr
3478: INSERT INTO CSI_ITEM_INSTANCES_H(
3479: INSTANCE_HISTORY_ID,
3480: INSTANCE_ID,
3481: TRANSACTION_ID,
3482: OLD_INSTANCE_NUMBER,

Line 7555: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);

7551: DELETE FROM CSI_IEA_VALUES WHERE instance_id = l_del_inst_tbl(j);
7552: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7553: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
7554: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7555: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
7556: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7557: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
7558: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7559: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);