APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_I_VERSION_LABELS

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

3031: THEN
3032: IF ((p_instance_rec.version_label IS NOT NULL) AND
3033: (p_instance_rec.version_label <> FND_API.G_MISS_CHAR))
3034: THEN
3035: -- Check if version label already exists in csi_i_version_labels
3036: -- If exists then raise an error message
3037: BEGIN
3038:
3039: SELECT 'x'

Line 3041: FROM csi_i_version_labels

3037: BEGIN
3038:
3039: SELECT 'x'
3040: INTO l_dummy
3041: FROM csi_i_version_labels
3042: WHERE instance_id = p_instance_rec.instance_id
3043: AND version_label = p_instance_rec.version_label
3044: AND ROWNUM=1;
3045:

Line 4952: l_select_stmt VARCHAR2(20000) := ' SELECT * FROM CSI_I_VERSION_LABELS ';

4948: l_get_ver_cursor_id NUMBER ;
4949: l_flag VARCHAR2(1) :='N';
4950: l_rows_processed NUMBER ;
4951: l_version_label_rec csi_datastructures_pub.version_label_rec;
4952: l_select_stmt VARCHAR2(20000) := ' SELECT * FROM CSI_I_VERSION_LABELS ';
4953:
4954: BEGIN
4955: -- Standard Start of API savepoint
4956: -- SAVEPOINT get_version_label_pub;