APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_VERSION_LABELS_H

Line 1035: select CSI_I_VERSION_LABELS_H_S.nextval

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

Line 3975: INSERT INTO CSI_I_VERSION_LABELS_H(

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

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

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