APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_VERSION_LABELS

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

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

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

7320: END IF;
7321: --
7322: l_bulk_txn_tbl(l_bulk_inst_count) := p_txn_tbl(inst_tab_row);
7323: --
7324: select CSI_I_VERSION_LABELS_S.nextval
7325: into l_bulk_version_label_tbl(l_bulk_inst_count).version_label_id
7326: from sys.dual;
7327: --
7328: l_bulk_version_label_tbl(l_bulk_inst_count).version_label := p_instance_tbl(inst_tab_row).version_label;

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

8082: DELETE FROM CSI_I_ORG_ASSIGNMENTS WHERE instance_id = l_del_inst_tbl(j);
8083: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8084: DELETE FROM CSI_I_PRICING_ATTRIBS WHERE instance_id = l_del_inst_tbl(j);
8085: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8086: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);
8087: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8088: DELETE FROM CSI_IEA_VALUES WHERE instance_id = l_del_inst_tbl(j);
8089: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8090: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);

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

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

9360: THEN
9361: IF ((p_instance_tbl(ins_row).version_label IS NOT NULL) AND
9362: (p_instance_tbl(ins_row).version_label <> FND_API.G_MISS_CHAR))
9363: THEN
9364: -- Check if version label already exists in csi_i_version_labels
9365: -- If exists then raise an error message
9366: BEGIN
9367: SELECT 'x'
9368: INTO l_dummy

Line 9369: FROM csi_i_version_labels

9365: -- If exists then raise an error message
9366: BEGIN
9367: SELECT 'x'
9368: INTO l_dummy
9369: FROM csi_i_version_labels
9370: WHERE instance_id = p_instance_tbl(ins_row).instance_id
9371: AND version_label = p_instance_tbl(ins_row).version_label
9372: AND ROWNUM=1;
9373: l_iface_error_text := substr(x_msg_data,1,2000);

Line 10798: from CSI_I_VERSION_LABELS

10794: l_ver_label_desc := null;
10795: Begin
10796: select version_label,description
10797: into l_version_label,l_ver_label_desc
10798: from CSI_I_VERSION_LABELS
10799: where instance_id = p_source_instance_tbl(src_rec).instance_id
10800: and rownum < 2;
10801: Exception
10802: when no_data_found then