APPS.OKC_OUTCOME_INIT_PVT SQL Statements

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

Line: 54

	SELECT opval.profile_option_value profile_value
	FROM   fnd_profile_options op,
	       fnd_profile_option_values opval
	WHERE  op.profile_option_id = opval.profile_option_id
	AND    op.application_id    = opval.application_id
	AND    op.profile_option_name = 'OKC_S_RECIPIENT';

Line: 63

	SELECT opval.profile_option_value profile_value
	FROM   fnd_profile_options op,
	       fnd_profile_option_values opval
	WHERE  op.profile_option_id = opval.profile_option_id
	AND    op.application_id    = opval.application_id
	AND    op.profile_option_name = 'OKC_E_RECIPIENT';

Line: 73

	SELECT f.user_name success_user
	FROM   jtf_rs_resource_extns r,
	       okc_outcomes_v  o,
	       fnd_user f
        WHERE  f.user_id = r.user_id
	AND    o.success_resource_id = r.resource_id
	AND    r.category = 'EMPLOYEE'
	AND    o.id = x;

Line: 85

	SELECT f.user_name failure_user
	FROM   jtf_rs_resource_extns r,
	       okc_outcomes_v  o,
	       fnd_user f
        WHERE  f.user_id = r.user_id
	AND    o.failure_resource_id = r.resource_id
	AND    r.category = 'EMPLOYEE'
	AND    o.id = x;

Line: 276

     okc_debug.Log('Inserting data into interface table OKS_DA_INTERFACE_B',2);

Line: 279

         INSERT INTO OKS_DA_INTERFACE_B
        (id,contract_id,enque_date,status,proc,proc_name,s_recipient,e_recipient,extra_attr_text)values
        (OKS_DA_INTERFACE_S.NEXTVAL,l_contract_id,SYSDATE,'PENDING',l_proc,l_proc_name,l_s_recipient,l_e_recipient,okc_wf.get_wf_string);

Line: 373

   SELECT NAME
   FROM OKC_PROCESS_DEFS_V
   WHERE PROCEDURE_NAME = l_procedure_name
   AND PACKAGE_NAME = l_package_name;

Line: 631

   SELECT NAME
   FROM OKC_PROCESS_DEFS_V
   WHERE WF_NAME=l_wf_name
   AND WF_PROCESS_NAME = l_wf_process_name;

Line: 687

	--Select the sequence number into l_item_key
	select okc_wf_outcome_s1.nextval into l_item_key from dual;

Line: 795

    SELECT * from
    (SELECT *
    FROM OKS_DA_INTERFACE_B
    WHERE status IN ('PENDING','ERROR')
    ORDER BY enque_date)
    where ROWNUM<=l_tot_que;

Line: 851

          UPDATE OKS_DA_INTERFACE_B
          SET    status='ERROR'
          WHERE id=launch_wf_rec.id;

Line: 859

         DELETE from OKS_DA_INTERFACE_B
         WHERE id=launch_wf_rec.id;