APPS.IBE_DSPMGRVALIDATION_GRP SQL Statements

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

Line: 21

     SELECT 1
     FROM JTF_AMV_ATTACHMENTS
     WHERE attachment_id = p_attachment_id;

Line: 28

    SELECT 1
    FROM JTF_AMV_ATTACHMENTS
     WHERE attachment_id = p_attachment_id
	AND object_version_number=p_object_version_number;

Line: 97

	SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
	WHERE attachment_id = p_attachment_id;

Line: 154

        SELECT context_type_code FROM IBE_DSP_CONTEXT_B WHERE
        context_id = p_context_id ;

Line: 202

        SELECT 1
        FROM IBE_DSP_CONTEXT_B WHERE
        context_id = p_context_id and context_type_code = p_context_type;

Line: 209

        SELECT 1
        FROM IBE_DSP_CONTEXT_B WHERE
        context_id = p_context_id  and context_type_code = p_context_type
	   and object_version_number = p_object_version_number;

Line: 270

	select count(*) from FND_LOOKUP_VALUES_VL WHERE
	lookup_type = 'JTF_AMV_DELV_TYPE_CODE' and
	lookup_code = p_context_type and
	enabled_flag = 'Y';

Line: 321

	-- select lookup_code
        select 1
        from FND_LOOKUP_VALUES_VL WHERE
	lookup_type = 'IBE_RELATIONSHIP_RULE_OBJ_TYPE' and
	lookup_code = p_object_type and
	lookup_code <> 'N' and
	enabled_flag = 'Y';

Line: 392

        SELECT 1
        FROM IBE_DSP_CONTEXT_B WHERE
        access_name = p_context_accessname ;

Line: 401

        SELECT 1
        FROM IBE_DSP_CONTEXT_B WHERE
        access_name = p_context_accessname and
        context_id  <> p_context_id ;

Line: 463

  select 1
  from ibe_dsp_tpl_ctg
  where category_id = p_category_id and item_id = p_template_id;

Line: 504

 		-- select category_id
                select 1
                from mtl_categories
                where category_id=p_category_id;

Line: 551

	-- select distinct inventory_item_id
        select 1
        from mtl_system_items
		where inventory_item_id = p_item_id;

Line: 598

		-- select section_id
                select 1
                from ibe_dsp_sections_b where
		section_id = p_section_id;

Line: 644

 		-- select section_id
                select 1
                from ibe_dsp_sections_b where
		section_id = p_section_id ;

Line: 747

  		-- SELECT item_id
                SELECT 1
                FROM JTF_AMV_ITEMS_B
			WHERE item_id = p_deliverable_id and
		      deliverable_type_code = p_item_type ;

Line: 755

 		-- SELECT item_id
                    SELECT 1
                    FROM JTF_AMV_ITEMS_B
			WHERE item_id = p_deliverable_id and
		      deliverable_type_code = p_item_type and
			 (applicable_to_code    = p_applicable_to OR
			  applicable_to_code    = 'GENERIC');

Line: 826

     SELECT 1
     FROM JTF_AMV_ITEMS_B
     WHERE item_id = p_deliverable_id;

Line: 833

     SELECT 1
     FROM JTF_AMV_ITEMS_B
     WHERE item_id = p_deliverable_id and
	object_version_number = p_object_version_number;

Line: 907

  	 	-- SELECT obj_lgl_ctnt_id
                SELECT 1
                FROM IBE_DSP_OBJ_LGL_CTNT
	        WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id;

Line: 914

  	-- select obj_lgl_ctnt_id
        select 1
        FROM IBE_DSP_OBJ_LGL_CTNT
        WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id and
	      object_version_number = p_object_version_number;

Line: 982

	-- SELECT file_name
        SELECT 1
        FROM JTF_AMV_ATTACHMENTS
	WHERE file_name = p_file_name;

Line: 989

	-- SELECT file_name
        SELECT 1
        FROM JTF_AMV_ATTACHMENTS
	WHERE file_name = p_file_name and attachment_id <> p_attachment_id;

Line: 1064

	-- SELECT msite_id
        SELECT 1
        FROM IBE_MSITES_B where msite_id = p_msite_id and site_type = 'I';

Line: 1073

	-- SELECT msite_id
        SELECT 1
        FROM IBE_MSITES_B
	WHERE msite_id = p_msite_id
	and object_version_number = p_object_version_number and site_type = 'I';

Line: 1146

	-- SELECT lgl_phys_map_id
        SELECT 1
        FROM IBE_DSP_LGL_PHYS_MAP
	where lgl_phys_map_id = p_lgl_phys_map_id;

Line: 1211

   	 -- SELECT access_name
         SELECT 1
         FROM JTF_AMV_ITEMS_B
	 WHERE access_name = p_access_name;

Line: 1218

	-- SELECT access_name
        SELECT 1
        FROM JTF_AMV_ITEMS_B
	WHERE access_name = p_access_name AND item_id <> p_item_id;

Line: 1235

			-- update
 			OPEN deliverable_accessname_cur(p_deliverable_id, p_access_name);

Line: 1296

	-- SELECT b.language_code
        SELECT 1 FROM
	IBE_MSITES_B A, IBE_MSITE_LANGUAGES B where
	A.msite_id = p_msite_id and
	B.msite_id = A.msite_id and
	A.site_type = 'I' and
	B.language_code = p_language_code ;

Line: 1350

		-- SELECT A.ITEM_ID
                 SELECT 1
                      from IBE_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where
				B.INVENTORY_ITEM_ID = p_item_id and
			      B.CATEGORY_ID = A.CATEGORY_ID AND
				A.ITEM_ID= p_deliverable_id ;

Line: 1411

		-- SELECT ITEM_ID
                 SELECT 1
                 from IBE_DSP_TPL_CTG where category_id = p_category_id and
									  ITEM_ID= p_deliverable_id ;

Line: 1464

	SELECT msite_id  FROM IBE_MSITES_B where master_msite_flag='Y' and site_type = 'I';

Line: 1495

     SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
     WHERE file_name = p_file_name;

Line: 1531

     SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
     WHERE file_name = p_file_name AND
     	   file_id = p_file_id AND
     	   attachment_used_by_id = p_deliverable_id;

Line: 1537

     SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
     WHERE file_name = p_file_name AND
     	   file_id is null AND
     	   attachment_used_by_id = p_deliverable_id;

Line: 1544

     SELECT jta.attachment_id
	FROM   JTF_AMV_ATTACHMENTS jta,
		  JTF_AMV_ITEMS_B jtai,
		  IBE_DSP_LGL_PHYS_MAP idlpm
     WHERE  jta.file_name = p_file_name AND
     	  jta.file_id = p_file_id AND
		  jta.attachment_id = idlpm.attachment_id AND
		  idlpm.item_id = jtai.item_id AND
		  rownum=1;

Line: 1555

     SELECT jta.attachment_id
	FROM   JTF_AMV_ATTACHMENTS jta,
		  JTF_AMV_ITEMS_B jtai,
		  IBE_DSP_LGL_PHYS_MAP idlpm
     WHERE  jta.file_name = p_file_name AND
     	  jta.file_id is null AND
            jta.attachment_id = idlpm.attachment_id AND
		  idlpm.item_id = jtai.item_id AND
		  rownum = 1;

Line: 1604

     SELECT 1
     FROM JTF_AMV_ATTACHMENTS
     WHERE attachment_id = p_attachment_id
     AND attachment_used_by_id = p_deliverable_id;

Line: 1655

     SELECT 1
     FROM IBE_DSP_LGL_PHYS_MAP
     WHERE attachment_id = p_attachment_id
     AND default_site = 'Y'
     AND default_language = 'Y';

Line: 1697

   Select 'x'
   From   ibe_msites_b
   Where  access_name = p_access_name  and site_type = 'I';

Line: 1727

    select COUNT(*) FROM FND_LOOKUP_VALUES WHERE lookup_type = c_lookup_type
    And lookup_code = c_lookup_code And enabled_flag = 'Y';

Line: 1788

  ELSIF (p_operation = 'UPDATE') THEN
    IF (p_access_name is NULL) THEN
      -- Access name cannot be null
      RETURN -1;