APPS.OKC_ASYNC_PVT SQL Statements

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

Line: 27

select
NVL(wf_pref.get_pref(USR.USER_NAME, 'LANGUAGE'), FNDL.NLS_LANGUAGE) language,
NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,
NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
notification_preference
from fnd_languages fndl,
fnd_user usr
where usr.user_name = p_recipient
and fndl.installed_flag = 'B';

Line: 121

    select value into L_NLS_LANGUAGE
    from NLS_SESSION_PARAMETERS
    where PARAMETER='NLS_LANGUAGE';

Line: 124

    select value into L_NLS_TERRITORY
    from NLS_SESSION_PARAMETERS
    where PARAMETER='NLS_TERRITORY';

Line: 275

  select to_char(okc_wf_notify_s1.nextval) into l_key from dual;

Line: 477

  select ''''||value||''''
  from NLS_SESSION_PARAMETERS
  where PARAMETER=p;

Line: 561

procedure Selector  ( 	item_type	in varchar2,
				item_key  	in varchar2,
				activity_id	in number,
				command	in varchar2,
				resultout out nocopy varchar2	) is
-- local declarations
   --
   l_proc varchar2(72) := '  OKC_ASYNC_PVT.'||'Selector';

Line: 576

   SELECT requested_by
     FROM fnd_concurrent_requests
    WHERE CONCURRENT_PROGRAM_ID
       IN (SELECT concurrent_program_id
             FROM FND_CONCURRENT_PROGRAMS
            WHERE CONCURRENT_PROGRAM_NAME='FNDWFBG'
          )
      AND ACTUAL_START_DATE IS NOT NULL
      AND Nvl(ARGUMENT1,'OKCALERT')='OKCALERT'
    ORDER BY ACTUAL_START_DATE desc;

Line: 641

          okc_debug.Log('100-15: Inside Selector selector/callback mode : '||command,2);

Line: 642

          okc_debug.Log('100-16: Inside Selector resultout is : '||resultout,2);

Line: 652

           okc_debug.Log('100-17: Inside Selector if mode is SET_CTX resultout is : '||resultout,2);

Line: 670

          okc_debug.Log('100-18: Inside Selector if mode is TEST_CTX resultout is : '||resultout,2);

Line: 688

		'SELECTOR',
		item_type,
		item_key,
		to_char(activity_id),
		command);

Line: 694

          okc_debug.Log('100-19: Inside Selector exception resultout is : '||resultout,2);

Line: 699

end Selector;

Line: 914

   SELECT CONTRACT_NUMBER
   FROM   OKC_K_HEADERS_ALL_B
   WHERE  ID = contract_id;

Line: 1082

select
NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
notification_preference
from fnd_user usr
where usr.user_name = p_recipient;

Line: 1108

/* End of code insert */

	if (funcmode = 'RUN') then
          IF (l_debug = 'Y') THEN
             okc_debug.Log('20: funcmode = RUN ',2);

Line: 1647

  select to_char(okc_wf_notify_s1.nextval) into l_key from dual;

Line: 2030

   SELECT NUMBER_DEFAULT
   from   WF_ITEM_ATTRIBUTES
   where  ITEM_TYPE = G_WF_NAME
   and    NAME      = 'P_TIMEOUT_MINUTES';

Line: 2107

  select to_char(okc_wf_notify_s1.nextval) into l_key from dual;

Line: 2290

	  update wf_notifications
	  set mail_status=NULL
	  where NOTIFICATION_ID=wf_engine.context_nid;

Line: 2338

  select user_id from fnd_user
  where user_name=p_name;

Line: 2439

  select user_id from fnd_user
  where user_name=p_name;

Line: 2545

  select user_id from fnd_user
  where user_name=p_name;

Line: 2655

  select user_id from fnd_user
  where user_name=p_name;

Line: 2765

  select user_id from fnd_user
  where user_name=p_name;

Line: 2875

  select user_id from fnd_user
  where user_name=p_name;