The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_update => Fnd_Api.g_true
,p_commit => Fnd_Api.G_FALSE
,p_api_version_number => 1.0
,p_init_msg_list => Fnd_Api.G_FALSE
,px_content_item_id => px_content_item_id
,px_citem_ver_id => px_citem_ver_id
,px_object_version_number => l_object_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
SELECT a.content_item_id
,a.CITEM_VERSION_ID
,a.CITEM_VERSION_STATUS
,a.version_number
FROM
ibc_citem_versions_vl a,
ibc_content_items b
WHERE
a.content_item_id=b.content_item_id AND
b.directory_node_id = l_dir_node_id AND
a.content_item_name = l_content_item_name AND
a.version_number = (SELECT MAX(version_number) FROM ibc_citem_versions_b c
WHERE c.content_item_id = a.content_item_id);
SELECT --a.ROWID
a.content_item_id
,citem_version_id
,content_type_code
,content_item_name
,directory_node_id
,owner_resource_id
,owner_resource_type
,translation_required_flag
,start_date
,end_date
,attachment_file_id
,'IBC_UPLOAD_ITEM_STATUS_SUBMIT' citem_version_status
,'US' language_code
,NULL content_creation_status
,'IBC_UPLOAD_ITEMEXIST_NEW' user_option_for_item
,'IBC_UPLOAD_FILEAS_RENDITION' citem_upload_as
FROM ibc_content_items a, ibc_citem_versions_vl b
WHERE content_type_code='IBC_FILE'
AND a.content_item_id=b.content_item_id
AND citem_version_id=16799;
-- UPDATE IBC_BULK_UPLOAD SET content_item_id=l_content_item_id
-- WHERE ROWID=i_rec.ROWID;