APPS.XDP_UTILITIES SQL Statements

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

Line: 602

	p_last_update_date IN DATE,
	p_last_updated_by IN NUMBER,
	p_last_update_login IN NUMBER,
	return_code OUT NOCOPY NUMBER,
	error_description OUT NOCOPY VARCHAR2) IS
  lv_lob clob;

Line: 610

   insert into xdp_proc_body
   (proc_name, proc_type, protected_flag, proc_spec, proc_body, creation_date, created_by, last_update_date,
    last_updated_by, last_update_login)
   values
   (p_proc_name, p_proc_type, 'N', p_proc_spec, empty_clob(),
    p_creation_date, p_created_by, p_last_update_date, p_last_updated_by,p_last_update_login)
   returning proc_body into lv_lob;

Line: 629

 PROCEDURE Update_Proc_Body(
		p_proc_name IN VARCHAR2,
		p_proc_type IN VARCHAR2 := 'CONNECT',
		p_proc_body IN VARCHAR2,
		p_last_update_date IN DATE,
		p_last_updated_by IN NUMBER,
		p_last_update_login IN NUMBER,
		return_code OUT NOCOPY NUMBER,
		error_description OUT NOCOPY VARCHAR2) IS

   lv_lob clob;

Line: 644

      update xdp_proc_body
      set
	  last_update_date = p_last_update_date,
	  last_updated_by = p_last_updated_by,
	  last_update_login = p_last_update_login,
	  proc_body = empty_clob()
      where
 	    proc_type = p_proc_type
	and proc_name = p_proc_name
      returning proc_body into lv_lob;

Line: 663

  END Update_Proc_Body;

Line: 676

    select proc_body
    from xdp_proc_body
    where proc_name = p_proc_name;

Line: 685

    select proc_body into lv_lob
    from xdp_proc_body
    where proc_name = p_proc_name;

Line: 750

    SELECT DECODE(p_Code, 0, 'IN',
                          1, 'IN OUT',
                          2, 'OUT')
      INTO v_Output
      FROM dual;

Line: 905

      select parameter_value
      from XDP_ORDER_LINEITEM_DETS
      where
	 line_item_id = p_line_item_id AND
	 line_parameter_name = p_line_param_name;

Line: 915

    select parameter_value into lv_param_value
    from XDP_ORDER_LINEITEM_DETS
    where
	 line_item_id = p_line_item_id AND
	 line_parameter_name = p_line_param_name;

Line: 956

      select parameter_value
      from
	xdp_worklist_details wdl
      where
	 wdl.workitem_instance_id = p_wi_instance_id AND
	 wdl.parameter_name = p_wi_param_name;

Line: 966

    select parameter_value into lv_param_value
    from
	xdp_worklist_details wdl,
	xdp_parameter_pool ppl
    where
	 wdl.workitem_instance_id = p_wi_instance_id AND
	 wdl.wi_parameter_id = ppl.parameter_id AND
	 ppl.parameter_name = p_wi_param_name;

Line: 1010

	select workitem_id
	from xdp_order_line_items
	where
		line_item_id = p_line_item_id;

Line: 1019

	select decode(workitem_id,NULL,'N','Y')
	into lv_flag
	from xdp_order_line_items
	where
		line_item_id = p_line_item_id;

Line: 1056

        select workitem_name
	from xdp_workitems wim,
	     XDP_FULFILL_WORKLIST fwt
	where
		fwt.workitem_instance_id = p_wi_instance_id and
		fwt.workitem_id = wim.workitem_id;

Line: 1068

	select workitem_name
	into lv_wi
	from xdp_workitems wim,
	     XDP_FULFILL_WORKLIST fwt
	where
		fwt.workitem_instance_id = p_wi_instance_id and
		fwt.workitem_id = wim.workitem_id;

Line: 1331

   select item_type, item_key
   from wf_items_v wi
   where
	wi.parent_item_type = p_item_type and
      wi.parent_item_key = p_item_key ;

Line: 1342

     select 'Y' into lv_attr_defined
     from dual
     where exists(
         select 1
        from WF_ITEM_ATTRIBUTE_values WIA
        where WIA.ITEM_TYPE = p_item_type
	  and WIA.ITEM_KEY = p_item_key
        and WIA.NAME = 'XDP_NUMBER_OF_CHILDREN');

Line: 1369

  select XDP_WF_COORDINATION_ID_S.NextVal
  into lv_id from dual;

Line: 1374

     select 'N' into lv_error_wf
     from dual
     where not exists(
         select 1
        from WF_ITEM_ATTRIBUTE_values WIA
        where WIA.ITEM_TYPE = lv_child_rec.item_type
	  and WIA.ITEM_KEY = lv_child_rec.item_key
        and WIA.NAME = 'ERROR_ITEM_KEY'
        and WIA.TEXT_VALUE = p_item_key);

Line: 1390

       select 'Y' into lv_attr_defined
       from dual
       where exists(
         select 1
        from WF_ITEM_ATTRIBUTE_values WIA
        where WIA.ITEM_TYPE = lv_child_rec.item_type
	  and WIA.ITEM_KEY = lv_child_rec.item_key
        and WIA.NAME = 'XDP_WF_COORDINATION_ID');

Line: 1418

  insert into XDP_WF_PROCESS_COORD
  (wf_coordination_id,
   wf_item_type,
   wf_item_key,
   wf_activity_name,
   child_process_num,
   created_by,
   creation_date,
   last_updated_by,
   last_update_date,
   last_update_login
  )
  values
  (
    lv_id,
    p_item_type,
    p_item_key,
    p_activity_name,
    lv_child_count - lv_previous_count,
	FND_GLOBAL.USER_ID,
	sysdate,
	FND_GLOBAL.USER_ID,
	sysdate,
	FND_GLOBAL.LOGIN_ID
  );

Line: 1472

  Select child_process_num,wf_item_type,wf_item_key,wf_activity_name
  into lv_child_count,lv_type,lv_key,lv_act
  from XDP_WF_PROCESS_COORD
  where wf_coordination_id = lv_id for update;

Line: 1480

	update XDP_WF_PROCESS_COORD
      set child_process_num = lv_child_count
      where wf_coordination_id = lv_id ;

Line: 1484

	delete from XDP_WF_PROCESS_COORD
      where wf_coordination_id = lv_id ;

Line: 1523

	  select status, owner
	  from all_objects
	  where object_name = lv_pkg_name and
		   object_type = 'PACKAGE' and
                   owner = lf_owner and
		   status <> 'VALID';

Line: 1530

	 select text from all_errors
	 where
	   owner = l_owner and
	   name = lv_pkg_name
	   order by line;

Line: 1537

        select user into lf_owner from dual;

Line: 1567

					'Please insert a character return to break up the line.'||
					SUBSTR(lv_tmp,1,257);

Line: 1585

					'Please insert a character return to break up the line.'||
					SUBSTR(lv_tmp,1,257);

Line: 1652

	  select status, owner
	  from all_objects
	  where object_name = lv_pkg_name and
		   object_type = 'PACKAGE BODY' and
                   owner = lf_owner and
		   status <> 'VALID';

Line: 1659

	 select text from all_errors
	 where
	   owner = l_owner and
	   name = p_pkg_name
	   order by line;

Line: 1666

        select user into lf_owner from dual;

Line: 1694

					'Please insert a character return to break up the line.'||
					SUBSTR(lv_tmp,1,257);

Line: 1712

					'Please insert a character return to break up the line.'||
					SUBSTR(lv_tmp,1,257);

Line: 1799

  select application_id, responsibility_id
    into l_ApplicationID, l_ResponsibilityID
  from fnd_responsibility
    where RESPONSIBILITY_KEY = p_responsibility_key;

Line: 1870

   SELECT PROC_NAME,PROC_TYPE
   FROM XDP_PROC_BODY
   WHERE protected_flag = 'N'
   ORDER BY PROC_TYPE, PROC_NAME;

Line: 1876

   SELECT ADAPTER_TYPE
   FROM xdp_fe_sw_gen_lookup
   WHERE FE_SW_GEN_LOOKUP_ID = lv_sw_gen_id;

Line: 1896

      select proc_body into lv_lob2
      from xdp_proc_body
      where proc_name = lv_rec.proc_name
      and proc_type = lv_rec.proc_type;

Line: 1932

           SELECT FULFILLMENT_ACTION_ID, FE_SW_GEN_LOOKUP_ID
           INTO lv_fa_id, lv_sw_gen_id
           FROM
              XDP_FA_FULFILLMENT_PROC fp
           where
             fp.fulfillment_proc = lv_rec.proc_name AND
             rownum = 1;

Line: 1950

           SELECT FETYPE_ID
           INTO lv_fetype_id
           FROM
              xdp_fe_sw_gen_lookup fp
           where
              fp.sw_start_proc = lv_rec.proc_name AND
              rownum = 1;

Line: 1960

              SELECT fa.FETYPE_ID
              INTO lv_fetype_id
              FROM XDP_FES fa,
               xdp_fe_generic_config fp
              where
               fa.fe_id = fp.fe_id AND
               fp.sw_start_proc = lv_rec.proc_name AND
               rownum = 1;

Line: 1975

           SELECT FETYPE_ID
           INTO lv_fetype_id
           FROM
              xdp_fe_sw_gen_lookup fp
           where
              fp.sw_exit_proc = lv_rec.proc_name AND
              rownum = 1;

Line: 1985

              SELECT fa.FETYPE_ID
              INTO lv_fetype_id
              FROM XDP_FES fa,
               xdp_fe_generic_config fp
              where
               fa.fe_id = fp.fe_id AND
               fp.sw_exit_proc = lv_rec.proc_name AND
               rownum = 1;

Line: 2242

g_message_list.DELETE ;

Line: 2284

       SELECT status, owner
         FROM all_objects
        WHERE object_name = lv_pkg_name
          AND object_type = p_pkg_type
          AND owner = lf_owner
          AND status <> 'VALID';

Line: 2292

       SELECT text
         FROM all_errors
        WHERE owner = l_owner
          AND name  = lv_pkg_name
        ORDER BY line;

Line: 2299

        select user into lf_owner from dual;

Line: 2338

	             'Please insert a character return to break up the line.'|| SUBSTR(lv_tmp,1,257);

Line: 2356

			'Please insert a character return to break up the line.'||
			SUBSTR(lv_tmp,1,257);

Line: 2519

  SELECT response_long into l_clob
  FROM xdp_fe_cmd_aud_trails
  WHERE fa_instance_id = p_FAInstanceID
  AND fe_command_seq = p_FECmdSequence;