The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT b.description
FROM ibc_citem_versions_tl a, fnd_languages_vl b
WHERE a.language = b.language_code
AND a.source_lang <> c_base_lang
AND a.source_lang = a.language
AND a.citem_version_id = c_citem_version_id;
SELECT b.description
FROM ibc_citem_versions_tl a, fnd_languages_vl b
WHERE a.language = b.language_code
AND a.source_lang = a.language
AND a.citem_version_id = c_citem_version_id;
SELECT 1
FROM ibc_citem_version_labels
WHERE citem_version_id = c_item_version_id
AND content_item_id = c_citem_id
AND label_code = 'IBE';
SELECT b.version_number
FROM ibc_citem_version_labels a, ibc_citem_versions_b b
WHERE a.citem_version_id = b.citem_version_id
AND a.content_item_id = c_citem_id
AND a.label_code = 'IBE';
SELECT decode(b.msite_id, 1, 'All', b.msite_name)
FROM ibe_dsp_lgl_phys_map a, ibe_msites_vl b
WHERE a.msite_id = b.msite_id and b.site_type = 'I'
AND a.content_item_key = c_item_key
AND a.attachment_id = -1;
SELECT MAX(a.version_number)
FROM ibc_citem_versions_b a
WHERE a.citem_version_status = 'APPROVED'
AND a.content_item_id = c_citem_id;
SELECT MAX(a.citem_version_id)
FROM ibc_citem_versions_b a
WHERE a.citem_version_status = 'APPROVED'
AND a.content_item_id = c_citem_id;
PROCEDURE Batch_Update_Labels(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_content_item_id_tbl IN JTF_NUMBER_TABLE,
p_version_number_tbl IN JTF_NUMBER_TABLE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_version NUMBER := 1.0;
l_api_name VARCHAR2(50) := 'Batch_Update_Labels';
SAVEPOINT BATCH_UPDATE_LABELS_SAVE;
IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Batch_Update_Labels Starts +');
IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Batch_Update_Labels Ends +');
ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
END Batch_Update_Labels;
PROCEDURE Update_Label_Association(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_old_content_item_id IN NUMBER,
p_old_version_number IN NUMBER,
p_new_content_item_id IN NUMBER,
p_new_version_number IN NUMBER,
p_media_object_id IN NUMBER,
p_association_type_code IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_version NUMBER := 1.0;
l_api_name VARCHAR2(50) := 'Update_Label_Association';
SELECT citem_version_id
FROM ibc_citem_versions_b
WHERE content_item_id = c_content_item_id
AND version_number = c_version_number;
SELECT ASSOCIATED_OBJECT_VAL1
FROM ibc_associations
WHERE content_item_id = c_content_item_id
AND association_type_code = c_label_code;
SELECT object_version_number
FROM IBC_CITEM_VERSION_LABELS
WHERE content_item_id = c_content_item_id
AND label_code = c_label_code;
SELECT 1
FROM IBC_ASSOCIATIONS
WHERE content_item_id = c_content_item_id
AND association_type_code = c_association_type_code;
SELECT 1
FROM IBC_ASSOCIATIONS
WHERE content_item_id = c_content_item_id
AND association_type_code = c_association_type_code
AND associated_object_val1 = c_assoc_object;
SAVEPOINT UPDATE_LABEL_ASSOCIATION_SAVE;
IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Update_Label_Association starts +');
l_cv_label_rec.last_updated_by := FND_GLOBAL.user_id;
l_cv_label_rec.last_update_date := SYSDATE;
l_cv_label_rec.last_update_login := FND_GLOBAL.login_id;
IBE_UTIL.debug('Before calling Ibc_Cv_Label_Grp.Update_CV_Label');
IBE_UTIL.debug('l_cv_label_rec.last_updated_by = '||l_cv_label_rec.last_updated_by);
Ibc_Cv_Label_Grp.Update_CV_Label(
p_api_version_number => 1.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
P_CV_Label_Rec => l_cv_label_rec,
x_CV_Label_Rec => r_cv_label_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Update_CV_Label:'||x_return_status);
IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Delete_CV_Label');
Ibc_Cv_Label_Grp.Delete_CV_Label(
P_Api_Version_Number => 1.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
p_label_code => l_label_code,
p_content_item_id => l_old_item_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Delete_CV_Label:'||x_return_status);
IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
l_cv_label_rec.last_updated_by := FND_GLOBAL.user_id;
l_cv_label_rec.last_update_date := SYSDATE;
l_cv_label_rec.last_update_login := FND_GLOBAL.login_id;
IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Update_CV_Label');
IBE_UTIL.debug('P_CV_Label_Rec.last_updated_by = '
||l_cv_label_rec.last_updated_by);
IBE_UTIL.debug('P_CV_Label_Rec.last_update_date = '
||to_char(l_cv_label_rec.last_update_date,'MM-DD-RRRR HH24:MI:SS'));
IBE_UTIL.debug('P_CV_Label_Rec.last_update_login = '
||l_cv_label_rec.last_update_login);
Ibc_Cv_Label_Grp.Update_CV_Label(
p_api_version_number => 1.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
P_CV_Label_Rec => l_cv_label_rec,
x_CV_Label_Rec => r_cv_label_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Update_CV_Label:'||x_return_status);
IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Update_CV_Label');
IBE_UTIL.debug('P_CV_Label_Rec.last_updated_by = '
||l_cv_label_rec.last_updated_by);
IBE_UTIL.debug('P_CV_Label_Rec.last_update_date = '
||to_char(l_cv_label_rec.last_update_date,'MM-DD-RRRR HH24:MI:SS'));
IBE_UTIL.debug('P_CV_Label_Rec.last_update_login = '
||l_cv_label_rec.last_update_login);
IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Update_Label_Association ends +');
ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
END Update_Label_Association;
PROCEDURE Delete_Label_Association(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_content_item_id IN NUMBER,
p_version_number IN NUMBER,
p_media_object_id IN NUMBER,
p_association_type_code IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_version NUMBER := 1.0;
l_api_name VARCHAR2(50) := 'Delete_Label_Association';
SELECT 1
FROM IBC_ASSOCIATIONS
WHERE content_item_id = c_content_item_id
AND association_type_code = c_association_type_code;
SAVEPOINT DELETE_LABEL_ASSOCIATION_SAVE;
IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Delete_Label_Association Starts +');
IBE_UTIL.debug('Calling IBC_CITEM_ADMIN_GRP.delete_association starts');
IBC_CITEM_ADMIN_GRP.delete_association(
p_content_item_id => l_content_item_id,
p_association_type_code => l_association_type_code,
p_associated_object_val1 => TO_CHAR(p_media_object_id),
p_commit => FND_API.g_false,
p_api_version_number => 1.0,
p_init_msg_list => FND_API.g_false,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
IBE_UTIL.debug('Calling IBC_CITEM_ADMIN_GRP.delete_association ends:'||x_return_status);
IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Delete_CV_Label');
Ibc_Cv_Label_Grp.Delete_CV_Label(
P_Api_Version_Number => 1.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
p_label_code => l_label_code,
p_content_item_id => l_content_item_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Delete_CV_Label:'||x_return_status);
IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Delete_Label_Association ends +');
ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
END Delete_Label_Association;
SELECT item_name, access_name
FROM JTF_AMV_ITEMS_VL
WHERE item_id = c_media_obj_id;