APPS.IBC_BULKUPLOAD_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 75

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

Line: 97

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

Line: 177

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;

Line: 322

	-- UPDATE IBC_BULK_UPLOAD SET content_item_id=l_content_item_id
	-- WHERE ROWID=i_rec.ROWID;