DBA Data[Home] [Help]

APPS.JTF_DSPMGRVALIDATION_GRP SQL Statements

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

Line: 20

	SELECT 1 FROM dual WHERE exists (
     SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
     WHERE attachment_id = p_attachment_id);
Line: 26

	SELECT 1 FROM dual WHERE exists (
     SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
     WHERE attachment_id = p_attachment_id
	AND object_version_number=p_object_version_number);
Line: 95

	SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
	WHERE attachment_id = p_attachment_id;
Line: 152

        SELECT context_type_code FROM JTF_DSP_CONTEXT_B WHERE
        context_id = p_context_id ;
Line: 199

   SELECT 1 from dual where exists(
        SELECT context_id FROM JTF_DSP_CONTEXT_B WHERE
        context_id = p_context_id and context_type_code = p_context_type);
Line: 205

   SELECT 1 from dual where exists(
        SELECT context_id FROM JTF_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: 266

	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: 317

	select 1 from dual where exists (
	select lookup_code 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: 386

   SELECT 1 from dual where exists(
        SELECT access_name FROM JTF_DSP_CONTEXT_B WHERE
        access_name = p_context_accessname  );
Line: 394

   SELECT 1 from dual where exists(
        SELECT access_name FROM JTF_DSP_CONTEXT_B WHERE
        access_name = p_context_accessname and
        context_id  <> p_context_id );
Line: 455

   SELECT 1 from dual where exists (select tpl_ctg_id from jtf_dsp_tpl_ctg where
				    category_id = p_category_id and item_id = p_template_id);
Line: 494

   SELECT 1 from dual where exists (
		select category_id from mtl_categories where category_id=p_category_id);
Line: 539

   SELECT 1 from dual where exists (
	select distinct inventory_item_id from mtl_system_items
		where inventory_item_id = p_item_id);
Line: 585

   SELECT 1 from dual where exists (
		select section_id from jtf_dsp_sections_b where
		section_id = p_section_id);
Line: 630

   SELECT 1 from dual where exists (
		select section_id from jtf_dsp_sections_b where
		section_id = p_section_id );
Line: 730

     select 1 from dual where exists (
		SELECT item_id FROM JTF_AMV_ITEMS_B
			WHERE item_id = p_deliverable_id and
		      deliverable_type_code = p_item_type );
Line: 737

     select 1 from dual where exists (
		SELECT item_id 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);
Line: 803

	select 1 from dual where exists (
     SELECT item_id FROM JTF_AMV_ITEMS_B
     WHERE item_id = p_deliverable_id);
Line: 809

     select 1 from dual where exists (
     SELECT item_id FROM JTF_AMV_ITEMS_B
     WHERE item_id = p_deliverable_id and
	object_version_number = p_object_version_number);
Line: 883

        SELECT 1 from dual where exists (
	 	SELECT obj_lgl_ctnt_id  FROM JTF_DSP_OBJ_LGL_CTNT
	        WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id);
Line: 889

        SELECT 1 from dual where exists (
	select obj_lgl_ctnt_id  FROM JTF_DSP_OBJ_LGL_CTNT
        WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id and
	      object_version_number = p_object_version_number);
Line: 956

	SELECT 1 FROM dual WHERE EXISTS (
	SELECT file_name FROM JTF_AMV_ATTACHMENTS
	WHERE file_name = p_file_name);
Line: 962

	SELECT 1 FROM dual WHERE EXISTS (
	SELECT file_name FROM JTF_AMV_ATTACHMENTS
	WHERE file_name = p_file_name and attachment_id <> p_attachment_id);
Line: 1036

	SELECT 1 from dual where exists (
	SELECT msite_id  FROM JTF_MSITES_B where msite_id = p_msite_id);
Line: 1044

	select 1 from dual where exists (
	SELECT msite_id FROM JTF_MSITES_B
	WHERE msite_id = p_msite_id
	and object_version_number = p_object_version_number);
Line: 1116

	SELECT 1 from dual where exists (
	SELECT lgl_phys_map_id  FROM JTF_DSP_LGL_PHYS_MAP
	where lgl_phys_map_id = p_lgl_phys_map_id);
Line: 1180

      SELECT 1 FROM dual WHERE EXISTS (
	 SELECT access_name  FROM JTF_AMV_ITEMS_B
	 WHERE access_name = p_access_name);
Line: 1186

	SELECT 1 FROM dual WHERE EXISTS (
	SELECT access_name  FROM JTF_AMV_ITEMS_B
	WHERE access_name = p_access_name AND item_id <> p_item_id);
Line: 1202

			-- update
 			OPEN deliverable_accessname_cur(p_deliverable_id, p_access_name);
Line: 1263

	SELECT 1 from dual where exists (
	SELECT b.language_code FROM
	JTF_MSITES_B A, JTF_MSITE_LANGUAGES B where
	A.msite_id = p_msite_id and
	B.msite_id = A.msite_id and
    --    A.end_date_active is null AND
	B.language_code = p_language_code );
Line: 1318

	 SELECT 1 from dual where exists
		(SELECT A.ITEM_ID from JTF_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: 1378

	 SELECT 1 from dual where exists
		(SELECT ITEM_ID from JTF_DSP_TPL_CTG where category_id = p_category_id and
									  ITEM_ID= p_deliverable_id );
Line: 1430

	SELECT msite_id  FROM JTF_MSITES_B where master_msite_flag='Y';
Line: 1461

     SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
     WHERE file_name = p_file_name;
Line: 1496

     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: 1502

     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: 1545

     SELECT 1 FROM DUAL WHERE EXISTS (
     SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
     WHERE attachment_id = p_attachment_id
     AND attachment_used_by_id = p_deliverable_id);
Line: 1595

     SELECT 1 FROM DUAL WHERE EXISTS (
     SELECT attachment_id FROM JTF_DSP_LGL_PHYS_MAP
     WHERE attachment_id = p_attachment_id
     AND default_site = 'Y'
     AND default_language = 'Y');
Line: 1637

   Select 'x'
   From   jtf_msites_b
   Where  access_name = p_access_name ;