APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_VERSION_LABELS

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 3899: INSERT INTO CSI_I_VERSION_LABELS(

3895: --
3896: l_ctr := l_version_label_rec_tab.version_label_id.count;
3897: --
3898: FORALL i in 1 .. l_ctr
3899: INSERT INTO CSI_I_VERSION_LABELS(
3900: VERSION_LABEL_ID,
3901: INSTANCE_ID,
3902: VERSION_LABEL,
3903: DATE_TIME_STAMP,

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 6986: select CSI_I_VERSION_LABELS_S.nextval

6982: END IF;
6983: --
6984: l_bulk_txn_tbl(l_bulk_inst_count) := p_txn_tbl(inst_tab_row);
6985: --
6986: select CSI_I_VERSION_LABELS_S.nextval
6987: into l_bulk_version_label_tbl(l_bulk_inst_count).version_label_id
6988: from sys.dual;
6989: --
6990: l_bulk_version_label_tbl(l_bulk_inst_count).version_label := p_instance_tbl(inst_tab_row).version_label;

Line 7549: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);

7545: DELETE FROM CSI_I_ORG_ASSIGNMENTS WHERE instance_id = l_del_inst_tbl(j);
7546: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7547: DELETE FROM CSI_I_PRICING_ATTRIBS WHERE instance_id = l_del_inst_tbl(j);
7548: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7549: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);
7550: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7551: DELETE FROM CSI_IEA_VALUES WHERE instance_id = l_del_inst_tbl(j);
7552: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7553: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);

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);

Line 8818: -- Check if version label already exists in csi_i_version_labels

8814: THEN
8815: IF ((p_instance_tbl(ins_row).version_label IS NOT NULL) AND
8816: (p_instance_tbl(ins_row).version_label <> FND_API.G_MISS_CHAR))
8817: THEN
8818: -- Check if version label already exists in csi_i_version_labels
8819: -- If exists then raise an error message
8820: BEGIN
8821: SELECT 'x'
8822: INTO l_dummy

Line 8823: FROM csi_i_version_labels

8819: -- If exists then raise an error message
8820: BEGIN
8821: SELECT 'x'
8822: INTO l_dummy
8823: FROM csi_i_version_labels
8824: WHERE instance_id = p_instance_tbl(ins_row).instance_id
8825: AND version_label = p_instance_tbl(ins_row).version_label
8826: AND ROWNUM=1;
8827: l_iface_error_text := substr(x_msg_data,1,2000);

Line 10233: from CSI_I_VERSION_LABELS

10229: l_ver_label_desc := null;
10230: Begin
10231: select version_label,description
10232: into l_version_label,l_ver_label_desc
10233: from CSI_I_VERSION_LABELS
10234: where instance_id = p_source_instance_tbl(src_rec).instance_id
10235: and rownum < 2;
10236: Exception
10237: when no_data_found then