APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_VERSION_LABELS_H

Line 1032: select CSI_I_VERSION_LABELS_H_S.nextval

1028: l_count NUMBER;
1029: l_hist_id NUMBER;
1030: BEGIN
1031: l_count := p_ver_label_history_tbl.count + 1;
1032: select CSI_I_VERSION_LABELS_H_S.nextval
1033: into l_hist_id
1034: from sys.dual;
1035: --
1036: p_ver_label_history_tbl(l_count).VERSION_LABEL_HISTORY_ID := l_hist_id;

Line 3972: INSERT INTO CSI_I_VERSION_LABELS_H(

3968: --
3969: l_ctr := l_ver_label_hist_rec_tab.version_label_history_id.count;
3970: --
3971: FORALL i in 1 .. l_ctr
3972: INSERT INTO CSI_I_VERSION_LABELS_H(
3973: VERSION_LABEL_HISTORY_ID,
3974: VERSION_LABEL_ID,
3975: TRANSACTION_ID,
3976: OLD_VERSION_LABEL,

Line 7565: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_del_txn_tbl(j);

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