[Home] [Help]
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;
5477: --
5478: l_ctr := l_ext_attr_rec_tab.attribute_value_id.count;
5479: --
5480: FORALL i in 1 .. l_ctr
5481: INSERT INTO CSI_IEA_VALUES(
5482: ATTRIBUTE_VALUE_ID,
5483: ATTRIBUTE_ID,
5484: INSTANCE_ID,
5485: ATTRIBUTE_VALUE,
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,
7547: DELETE FROM CSI_I_PRICING_ATTRIBS WHERE instance_id = l_del_inst_tbl(j);
7548: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7549: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);
7550: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
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);
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);