APPS.IBE_DELIVERABLE_EXPIMP_PVT SQL Statements

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

Line: 80

          SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL
          FROM DUAL;

Line: 84

    SELECT item_id,object_version_number
      FROM jtf_amv_items_b
     WHERE access_name = c_access_name
       AND application_id = 671
       AND deliverable_type_code = 'TEMPLATE';

Line: 96

    SELECT lgl_phys_map_id, attachment_id
      FROM ibe_dsp_lgl_phys_map
      WHERE item_id = c_item_id
       AND msite_id = c_site_id
       AND language_code = c_lang_code
       AND default_site = c_default_site
       AND default_language = c_default_lang;

Line: 106

    SELECT
    attachment_id,		-- Bug#5882497, scnagara
    object_version_number,
	attachment_used_by,
  	enabled_flag,
  	can_fulfill_electronic_flag,
  	file_id,
  	file_extension,
  	keywords,
  	send_for_preview_flag,
  	attachment_type,
  	language_code,
  	application_id,
  	description
   FROM JTF_AMV_ATTACHMENTS
   WHERE attachment_id=c_attachment_id;

Line: 126

    SELECT
	ibemap.attachment_id
	FROM
	jtf_amv_attachments jtfach,ibe_dsp_lgl_phys_map ibemap
	WHERE
        ibemap.attachment_id = jtfach.attachment_id
	and ibemap.item_id   = c_item_id
	and jtfach.file_name = c_file_name
	group by ibemap.attachment_id;

Line: 375

          FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 7: inserting into ibe_dsp_lgl_phys_map');

Line: 385

        INSERT INTO IBE_DSP_LGL_PHYS_MAP(lgl_phys_map_id, item_id,
          msite_id, language_code, default_site, default_language,
          attachment_id, content_item_key,object_version_number,
          created_by,creation_date,last_updated_by,last_update_date)
        VALUES (IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL, l_item_id,
          p_minisite_ids(l_i), p_language_codes(l_i), p_default_sites(l_i),
          p_default_languages(l_i), l_attachment_id, NULL,
          1,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,sysdate);

Line: 395

          FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 8 :after insertion into ibe_sp_lgl_phys_map');