APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_ITEM_INSTANCES_H

Line 821: select CSI_ITEM_INSTANCES_H_S.nextval

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

Line 3481: INSERT INTO CSI_ITEM_INSTANCES_H(

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

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

8088: DELETE FROM CSI_IEA_VALUES WHERE instance_id = l_del_inst_tbl(j);
8089: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8090: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
8091: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8092: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
8093: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8094: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
8095: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8096: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);