APPS.XDP_ENG_UTIL SQL Statements

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

Line: 32

	 SELECT parameter_name,
                NVL(evaluation_seq,0)
	   FROM xdp_fa_parameters
          WHERE fulfillment_action_id = l_fa_id
	  ORDER by evaluation_seq;

Line: 39

         SELECT fulfillment_action_id
           FROM XDP_FULFILL_ACTIONS
           WHERE fulfillment_action = p_fa_name;

Line: 44

         SELECT fe_id
           FROM XDP_FES
          WHERE fulfillment_element_name = p_fe_name;

Line: 123

	SELECT parameter_name,
               NVL(evaluation_seq,0)
	  FROM xdp_fa_parameters
         WHERE fulfillment_action_id = p_fulfillment_action_id
 	 ORDER BY evaluation_seq;

Line: 130

         SELECT fe_id
           FROM XDP_FES
           WHERE fulfillment_element_name = p_fe_name;

Line: 136

  select 1 into lv_dummy
  from XDP_FULFILL_ACTIONS
  where fulfillment_action_id = p_fulfillment_action_id;

Line: 197

	select parameter_name,
             NVL(evaluation_seq,0)
	from xdp_fa_parameters
      where
         fulfillment_action_id = l_fa_id
	order by evaluation_seq;

Line: 205

   select fulfillment_action_id
  from XDP_FULFILL_ACTIONS
  where fulfillment_action = p_fa_name;

Line: 254

  select XDP_FA_RUNTIME_LIST_S.nextval
  into lv_fa_instance_id
  from  dual;

Line: 258

  insert into xdp_fa_runtime_list
  (fa_instance_id,
   workitem_instance_id,
   fulfillment_action_id,
   status_code,
   resubmission_job_id,
   fe_id,
   provisioning_sequence,
   priority,
   start_provisioning_date,
   created_by,
   creation_date,
   last_updated_by,
   last_update_date,
   last_update_login
   )
  select
   lv_fa_instance_id,
   workitem_instance_id,
   fulfillment_action_id ,
   'STANDBY',
   p_resubmission_job_id ,
   fe_id,
   provisioning_sequence,
   priority,
   sysdate,
   FND_GLOBAL.USER_ID,
   sysdate,
   FND_GLOBAL.USER_ID,
   sysdate,
   FND_GLOBAL.LOGIN_ID
  from
    xdp_fa_runtime_list
  where
    fa_instance_id = p_resub_fa_instance_id;

Line: 294

  insert into xdp_fa_details(
    fa_instance_id,
    parameter_name,
    fulfillment_action_id,
    is_value_evaluated,
    parameter_value,
    parameter_ref_value,
    created_by,
    creation_date,
    last_updated_by,
    last_update_date,
    last_update_login
  )
  select
    lv_fa_instance_id,
    parameter_name,
    fulfillment_action_id,
    is_value_evaluated,
    parameter_value,
    parameter_ref_value,
    FND_GLOBAL.USER_ID,
    sysdate,
    FND_GLOBAL.USER_ID,
    sysdate,
    FND_GLOBAL.LOGIN_ID
  from
    xdp_fa_details
  where
    fa_instance_id = p_resub_fa_instance_id;

Line: 356

   select priority
   from xdp_fa_runtime_list
   where
     fa_instance_id = p_fa_instance_id;

Line: 439

   select priority
   from xdp_fa_runtime_list
   where
     fa_instance_id = p_fa_instance_id;

Line: 507

  insert into xdp_fa_runtime_list
  (fa_instance_id,
   workitem_instance_id,
   fulfillment_action_id,
   status_code,
   fe_id,
   provisioning_sequence,
   priority,
   start_provisioning_date,
   created_by,
   creation_date,
   last_updated_by,
   last_update_date,
   last_update_login
   )
  values
  ( XDP_FA_RUNTIME_LIST_S.nextval,
   p_wi_instance_id,
   p_fa_id,
   p_status,
   p_fe_id,
   p_prov_seq,
   p_priority,
   sysdate,
   FND_GLOBAL.USER_ID,
   sysdate,
   FND_GLOBAL.USER_ID,
   sysdate,
   FND_GLOBAL.LOGIN_ID
  ) returning fa_instance_id into p_fa_instance_id;