APPS.IBE_M_MIGRATION_PVT SQL Statements

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

Line: 37

    SELECT 1
	 FROM IBE_MIGRATION_HISTORY
     WHERE migration_code = c_code
	  AND status = c_status;

Line: 43

    SELECT lgl_phys_map_id
	 FROM ibe_dsp_lgl_phys_map
     WHERE content_item_key IS NOT NULL;

Line: 72

  DELETE FROM IBE_MIGRATION_HISTORY
	   WHERE MIGRATION_CODE = p_code;

Line: 74

  INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
    OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
    LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
  VALUES(p_code,0, FND_GLOBAL.user_id, SYSDATE,
    FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);

Line: 85

PROCEDURE update_log(p_code IN VARCHAR2,
				 p_old_status IN VARCHAR2,
				 p_new_status IN VARCHAR2,
				 x_status OUT NOCOPY VARCHAR2)
IS
BEGIN
  UPDATE IBE_MIGRATION_HISTORY
     SET STATUS = p_new_status,
   	    LAST_UPDATE_DATE = SYSDATE
   WHERE MIGRATION_CODE = p_code
	AND STATUS = p_old_status;

Line: 100

END update_log;

Line: 111

    SELECT CONTEXT_ID, ACCESS_NAME, COMPONENT_TYPE_CODE
	 FROM IBE_DSP_CONTEXT_B
     WHERE CONTEXT_TYPE_CODE = 'MEDIA'
	  AND (COMPONENT_TYPE_CODE IS NULL
	  OR CONTEXT_ID < 10000);

Line: 119

    SELECT DISTINCT OBJECT_TYPE
	 FROM IBE_DSP_OBJ_LGL_CTNT
	WHERE CONTEXT_ID = c_context_id;

Line: 124

    SELECT creation_date, last_update_date
	 FROM IBE_MIGRATION_HISTORY
     WHERE MIGRATION_CODE = 'IBE_CONTENT_COMPONENT'
	  AND STATUS = 'SUCCESS';

Line: 144

    SELECT 1
	 FROM IBE_MIGRATION_HISTORY
     WHERE MIGRATION_CODE = c_migcode;

Line: 158

      INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
	   OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
	   LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
      VALUES(l_migcode, 0, FND_GLOBAL.user_id, SYSDATE,
        FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, 'START');

Line: 216

	   -- No update on last_updated_by based on the review feedback
	   UPDATE IBE_DSP_CONTEXT_B
		 SET COMPONENT_TYPE_CODE
		   = NVL(l_content_component_tbl(l_j).component_type_code,
			COMPONENT_TYPE_CODE),
                     LAST_UPDATE_DATE = SYSDATE
           WHERE context_id = l_content_component_tbl(l_j).context_id;

Line: 231

    UPDATE IBE_MIGRATION_HISTORY
      SET STATUS = 'SUCCESS',
  	     LAST_UPDATE_DATE = SYSDATE
     WHERE MIGRATION_CODE = l_migcode
	  AND STATUS = 'START';

Line: 297

    SELECT content_type_name
	 FROM ibc_content_types_vl
     WHERE content_type_code = c_type_code;

Line: 302

    SELECT meaning
	 FROM fnd_lookups
     WHERE lookup_type='IBE_M_AUTOPLACEMENT_MODE'
	  and Lookup_code=c_mode;

Line: 308

    SELECT description
	 FROM fnd_languages_vl
     WHERE language_code=c_lang_code;

Line: 567

    SELECT DISTINCT file_name
	 FROM jtf_amv_attachments a
     WHERE application_id = 671
	  AND file_id IS NOT NULL
	  AND attachment_used_by = 'ITEM'
	  AND NOT EXISTS (
		  SELECT NULL
		    FROM ibe_dsp_lgl_phys_map b, jtf_amv_items_b c
             WHERE a.attachment_id = b.attachment_id
               AND c.item_id = b.item_id
			AND c.deliverable_type_code = 'TEMPLATE');

Line: 625

    SELECT b.file_id, b.display_height, b.display_width, b.file_name
	 FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
     WHERE a.attachment_id = b.attachment_id
	  AND a.default_language = c_default_lang
	  AND a.language_code = c_language_code
	  AND a.default_site = c_default_msite
	  AND a.msite_id = c_msite_id
	  AND a.item_id = c_item_id;

Line: 637

    SELECT b.file_id, b.display_height, b.display_width, b.file_name
	 FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
     WHERE a.attachment_id = b.attachment_id
	  AND a.default_site = c_default_msite
	  AND a.msite_id = c_msite_id
	  AND a.item_id = c_item_id;

Line: 764

    SELECT b.file_id, b.display_height, b.display_width, b.file_name
	 FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
     WHERE a.attachment_id = b.attachment_id
	  AND a.default_language = c_default_lang
	  AND a.language_code = c_language_code
	  AND a.default_site = c_default_msite
	  AND a.msite_id = c_msite_id
	  AND a.item_id = c_item_id;

Line: 975

    SELECT a.content_item_id, b.citem_version_id
	 FROM ibc_content_items a, ibc_citem_version_labels b
     WHERE a.item_reference_code = c_item_ref_code
	  AND a.content_item_id = b.content_item_id
	  AND b.label_code = c_label_code;

Line: 982

    SELECT a.content_item_id, b.citem_version_id
	 FROM ibc_content_items a, ibc_citem_versions_b b
     WHERE a.item_reference_code = c_item_ref_code
	  AND a.content_item_id = b.citem_version_id
	  AND b.citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED;

Line: 989

    SELECT content_item_id
	 FROM ibc_content_items
     WHERE item_reference_code = c_item_ref_code;

Line: 994

    SELECT IBE_DSP_LGL_PHYS_MAP_S1.nextval
	 FROM dual;

Line: 999

    SELECT 1
	 FROM IBE_DSP_LGL_PHYS_MAP
     WHERE item_id = c_item_id
	  AND msite_id = c_msite_id
       AND language_code = c_lang_code
	  AND default_site = c_def_msite
	  AND default_language = c_def_lang
	  AND attachment_id = -1;

Line: 1009

    SELECT version_number
	 FROM ibc_citem_versions_b
     WHERE citem_version_id = c_citem_version_id;

Line: 1298

        printDebugLog('Update_Label_Association Starts');

Line: 1307

        IBE_M_IBC_INT_PVT.Update_Label_Association(
          p_api_version => 1.0,
	     p_init_msg_list => FND_API.G_FALSE,
  	     p_commit => FND_API.G_FALSE,
	     p_old_content_item_id => l_old_item,
	     p_old_version_number => l_old_ver_num,
	     p_new_content_item_id => l_content_item_id,
	     p_new_version_number => l_version_number,
	     p_media_object_id => px_attachment_rec.item_id,
	     p_association_type_code => l_association_type,
	     x_return_status => l_return_status,
	     x_msg_count => l_msg_count,
	     x_msg_data => l_msg_data);

Line: 1369

      INSERT INTO ibe_dsp_lgl_phys_map
        (LGL_PHYS_MAP_ID,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
         LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,MSITE_ID,
         LANGUAGE_CODE, ATTACHMENT_ID, ITEM_ID, DEFAULT_LANGUAGE,
         DEFAULT_SITE, CONTENT_ITEM_KEY)
      VALUES
        (l_lgl_phys_map_id, 1, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,
         SYSDATE, FND_GLOBAL.user_id, px_attachment_rec.msite_id,
         'OCM', -1, px_attachment_rec.item_id,
         'Y', px_attachment_rec.default_site, TO_CHAR(l_content_item_id));

Line: 1411

    SELECT content_item_id, creation_date
	 FROM ibc_content_items
     WHERE item_reference_code = c_item_ref_code;

Line: 1610

    SELECT last_update_date
	 FROM IBE_MIGRATION_HISTORY
     WHERE migration_code = c_code
	  AND status = c_status;

Line: 1615

        SELECT  attachment_id,object_version_number FROM jtf_amv_attachments a
        WHERE file_id IS NOT NULL
          AND application_id = 671
	    AND last_update_date < l_date
    	 AND attachment_used_by = 'ITEM'
          AND NOT EXISTS (
	       	 SELECT NULL
    		   FROM ibe_dsp_lgl_phys_map b, jtf_amv_items_b c
                WHERE a.attachment_id = b.attachment_id
		      AND b.item_id = c.item_id
		        AND c.deliverable_type_code = 'TEMPLATE');

Line: 1642

    DELETE FROM ibe_dsp_lgl_phys_map a
    WHERE lgl_phys_map_id >= 10000
      AND content_item_key IS NULL
	 AND last_update_date <= l_date
	 AND attachment_id <> -1
	 AND EXISTS (
	   SELECT NULL
		FROM jtf_amv_items_b c
         WHERE a.item_id = c.item_id
		 AND c.deliverable_type_code = 'MEDIA'
		 AND c.application_id = 671);

Line: 1657

       JTF_AMV_ATTACHMENT_PUB.delete_act_attachment(
            p_api_version		=> l_api_version,
            x_return_status	=> x_return_status,
            x_msg_count		=> x_msg_count,
            x_msg_data		=> x_msg_data,
            p_act_attachment_id	=>r1.attachment_id,
            p_object_version	=>r1.object_version_number);

Line: 1695

    SELECT language_code, description
	 FROM fnd_languages_vl
     WHERE installed_flag in ('I','B');

Line: 1703

    select b.item_id, b.access_name
	 from jtf_amv_items_b b
     where b.deliverable_type_code <> 'TEMPLATE'
	  and b.application_id = 671
     ORDER BY b.item_id;

Line: 1722

   SELECT b.msite_id, b.msite_name, decode(b.msite_id,1,'Y','N'),
	b.default_language_code
    from ibe_msites_vl b
   where EXISTS (select NULL
                   FROM ibe_dsp_lgl_phys_map a
	             WHERE a.msite_id = b.msite_id
	               AND a.item_id = c_item_id
				   AND b.site_type = 'I'
		          AND a.content_item_key IS NULL)
  ORDER BY b.msite_id ASC;

Line: 1736

    SELECT 'Y'
	 FROM ibe_dsp_lgl_phys_map
     WHERE content_item_key IS NULL
	  AND default_site = 'Y'
	  AND item_id = c_item_id
	  AND lgl_phys_map_id < 10000;

Line: 1748

    SELECT distinct file_id, file_name, display_height, display_width
	 FROM jtf_amv_attachments a
     WHERE application_id = 671
       AND file_id IS NOT NULL
	  AND attachment_used_by = 'ITEM'
	  AND NOT EXISTS (
		 SELECT NULL
		   FROM ibe_dsp_lgl_phys_map b
		  WHERE b.attachment_id = a.attachment_id);

Line: 1811

    l_attachment_tbl.delete;

Line: 1812

    l_trans_attachment_tbl.delete;

Line: 1956

  l_attachment_tbl.delete;

Line: 1957

  l_trans_attachment_tbl.delete;

Line: 2054

	 -- Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
	 --  p_DIRECTORY_NODE_ID => 9 ,
	 --  p_DIRECTORY_NODE_CODE => NULL,
	 --  p_HIDDEN_FLAG  => 'Y');

Line: 2059

	 EXECUTE IMMEDIATE 'begin Ibc_Directory_Nodes_Pkg.UPDATE_ROW '||
	   '(p_DIRECTORY_NODE_ID => 9 ,p_DIRECTORY_NODE_CODE => NULL, '||
	   'p_HIDDEN_FLAG  => ''Y''); END;';

Line: 2124

	 --Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
	 --  p_DIRECTORY_NODE_ID => 9 , -- This is the Folder id of iStore
	 --  p_DIRECTORY_NODE_CODE => NULL,
	 --  p_HIDDEN_FLAG  => 'N');

Line: 2129

	 EXECUTE IMMEDIATE 'begin Ibc_Directory_Nodes_Pkg.UPDATE_ROW '||
	   '(p_DIRECTORY_NODE_ID => 9 ,p_DIRECTORY_NODE_CODE => NULL, '||
	   'p_HIDDEN_FLAG  => ''N''); END;';

Line: 2138

  	   printDebuglog('Update log for migration');

Line: 2140

      update_log(p_code => 'IBE_OCM_MIG',
			  p_old_status => 'START',
			  p_new_status => 'SUCCESS',
			  x_status => l_status);

Line: 2177

	 --Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
	 --  p_DIRECTORY_NODE_ID => 9 , -- This is the Folder id of iStore
	 --  p_DIRECTORY_NODE_CODE => NULL,
	 --  p_HIDDEN_FLAG  => 'N');

Line: 2182

	 EXECUTE IMMEDIATE 'begin Ibc_Directory_Nodes_Pkg.UPDATE_ROW '||
	   '(p_DIRECTORY_NODE_ID => 9 ,p_DIRECTORY_NODE_CODE => NULL, '||
	   'p_HIDDEN_FLAG  => ''N''); END;';