APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_IEA_VALUES_H

Line 1543: select CSI_IEA_VALUES_H_S.nextval

1539: l_count NUMBER;
1540: l_hist_id NUMBER;
1541: BEGIN
1542: l_count := p_ext_attr_hist_tbl.count + 1;
1543: select CSI_IEA_VALUES_H_S.nextval
1544: into l_hist_id
1545: from sys.dual;
1546:
1547: p_ext_attr_hist_tbl(l_count).attribute_value_history_id := l_hist_id;

Line 5552: INSERT INTO CSI_IEA_VALUES_H(

5548: --
5549: l_ctr := l_ext_attr_hist_rec_tab.attribute_value_history_id.count;
5550: --
5551: FORALL i in 1 .. l_ctr
5552: INSERT INTO CSI_IEA_VALUES_H(
5553: ATTRIBUTE_VALUE_HISTORY_ID,
5554: ATTRIBUTE_VALUE_ID,
5555: TRANSACTION_ID,
5556: OLD_ATTRIBUTE_VALUE,

Line 7567: DELETE FROM CSI_IEA_VALUES_H WHERE transaction_id = l_del_txn_tbl(j);

7563: DELETE FROM CSI_I_PRICING_ATTRIBS_H WHERE transaction_id = l_del_txn_tbl(j);
7564: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
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);