[Home] [Help]
1542: l_count NUMBER;
1543: l_hist_id NUMBER;
1544: BEGIN
1545: l_count := p_ext_attr_hist_tbl.count + 1;
1546: select CSI_IEA_VALUES_H_S.nextval
1547: into l_hist_id
1548: from sys.dual;
1549:
1550: p_ext_attr_hist_tbl(l_count).attribute_value_history_id := l_hist_id;
5480: --
5481: l_ctr := l_ext_attr_rec_tab.attribute_value_id.count;
5482: --
5483: FORALL i in 1 .. l_ctr
5484: INSERT INTO CSI_IEA_VALUES(
5485: ATTRIBUTE_VALUE_ID,
5486: ATTRIBUTE_ID,
5487: INSTANCE_ID,
5488: ATTRIBUTE_VALUE,
5551: --
5552: l_ctr := l_ext_attr_hist_rec_tab.attribute_value_history_id.count;
5553: --
5554: FORALL i in 1 .. l_ctr
5555: INSERT INTO CSI_IEA_VALUES_H(
5556: ATTRIBUTE_VALUE_HISTORY_ID,
5557: ATTRIBUTE_VALUE_ID,
5558: TRANSACTION_ID,
5559: OLD_ATTRIBUTE_VALUE,
8084: DELETE FROM CSI_I_PRICING_ATTRIBS WHERE instance_id = l_del_inst_tbl(j);
8085: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8086: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);
8087: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
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);
8100: DELETE FROM CSI_I_PRICING_ATTRIBS_H WHERE transaction_id = l_del_txn_tbl(j);
8101: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8102: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_del_txn_tbl(j);
8103: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8104: DELETE FROM CSI_IEA_VALUES_H WHERE transaction_id = l_del_txn_tbl(j);
8105: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8106: DELETE FROM CSI_I_ASSETS_H WHERE transaction_id = l_del_txn_tbl(j);
8107: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8108: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);