APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_I_VERSION_LABELS_H

Line 418: select CSI_I_VERSION_LABELS_H_S.nextval

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;

Line 1989: INSERT INTO CSI_I_VERSION_LABELS_H(

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,

Line 9609: DELETE FROM CSI_I_VERSION_LABELS_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;

Line 10236: DELETE FROM CSI_I_VERSION_LABELS_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;