414: ,p_ver_label_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
415: ) IS
416: BEGIN
417: FOR i in p_version_label_tbl.FIRST .. p_version_label_tbl.LAST LOOP
418: select CSI_I_VERSION_LABELS_H_S.nextval
419: into p_ver_label_hist_tbl(i) from dual;
420: --
421: p_version_label_rec_tab.version_label_id(i) := p_version_label_tbl(i).version_label_id;
422: p_version_label_rec_tab.instance_id(i) := p_version_label_tbl(i).instance_id;
1240: FOR l_ind IN l_vl_tbl.FIRST .. l_vl_tbl.LAST
1241: LOOP
1242: SELECT object_version_number
1243: INTO l_vl_tbl(l_ind).object_version_number
1244: FROM csi_i_version_labels
1245: WHERE version_label_id = l_vl_tbl(l_ind).version_label_id;
1246: END LOOP;
1247:
1248: csi_item_instance_pub.update_version_label(
1985: l_ctr := l_version_label_rec_tab.version_label_id.count;
1986: -- Insert into History
1987: log('Before Inserting into Version Labels history ..');
1988: FORALL i in 1 .. l_version_label_rec_tab.version_label_id.count
1989: INSERT INTO CSI_I_VERSION_LABELS_H(
1990: VERSION_LABEL_HISTORY_ID,
1991: VERSION_LABEL_ID,
1992: TRANSACTION_ID,
1993: NEW_VERSION_LABEL,
9599: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_instance_tbl(j);
9600: FORALL j in l_instance_tbl.FIRST .. l_instance_tbl.LAST
9601: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_instance_tbl(j);
9602: FORALL j in l_instance_tbl.FIRST .. l_instance_tbl.LAST
9603: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_instance_tbl(j);
9604: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9605: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_txn_tbl(j);
9606: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9607: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_txn_tbl(j);
9605: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_txn_tbl(j);
9606: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9607: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_txn_tbl(j);
9608: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9609: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_txn_tbl(j);
9610: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9611: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_txn_tbl(j);
9612: END;
9613: END IF;
10226: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_del_inst_tbl(j);
10227: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
10228: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);
10229: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
10230: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);
10231: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10232: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
10233: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10234: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
10232: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
10233: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10234: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
10235: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10236: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_del_txn_tbl(j);
10237: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10238: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);
10239: END;
10240: END IF;