APPS.FND_OAM_KBF_SUBS SQL Statements

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

Line: 24

    select count(*) into l_count
    from FND_OAM_BIZEX_SENT_NOTIF
    where
        UNIQUE_EXCEPTION_ID = pUniqueExId
    and SUBSCRIPTION_ID = pSubID
    ;

Line: 181

	SELECT
         b.CONCURRENT_PROGRAM_NAME, t.USER_CONCURRENT_PROGRAM_NAME
      INTO
         l_comp_name, l_comp_display_name
         --, b.APPLICATION_ID, b.CONCURRENT_PROGRAM_ID, t.DESCRIPTION
      FROM
         FND_CONCURRENT_PROGRAMS B,FND_CONCURRENT_PROGRAMS_TL t
      WHERE
             b.application_id = app_id
         and b.concurrent_program_id   = comp_id
         and b.application_id = t.application_id
         and b.concurrent_program_id = t.concurrent_program_id
         and t.language = userenv('LANG');

Line: 196

	SELECT
         b.FORM_NAME, t.USER_FORM_NAME
      INTO
         l_comp_name, l_comp_display_name
         --, b.APPLICATION_ID, b.FORM_ID, t.DESCRIPTION
      FROM
         FND_FORM B, FND_FORM_TL t
      WHERE
             b.application_id = app_id
         and b.form_id   = comp_id
         and b.application_id = t.application_id
         and b.form_id = t.form_id
         and t.language = userenv('LANG');

Line: 211

	SELECT
         b.CONCURRENT_QUEUE_NAME, t.USER_CONCURRENT_QUEUE_NAME
      INTO
         l_comp_name, l_comp_display_name
         --, b.APPLICATION_ID, b.concurrent_queue_id , t.DESCRIPTION
      FROM
         FND_CONCURRENT_QUEUES b, FND_CONCURRENT_QUEUES_TL t
      WHERE
             b.application_id = app_id
         and b.concurrent_queue_id   = comp_id
	   and b.application_id = t.application_id
   	   and b.concurrent_queue_id = t.concurrent_queue_id
         and t.language = userenv('LANG');

Line: 229

	SELECT
           b.function_name, t.user_function_name
        INTO
           l_comp_name, l_comp_display_name
           --, b.APPLICATION_ID, b.function_id, t.DESCRIPTION
        FROM
           FND_FORM_FUNCTIONS b, FND_FORM_FUNCTIONS_TL t
        WHERE
           b.function_id   = comp_id
   	   and b.function_id = t.function_id
           and t.language = userenv('LANG');

Line: 271

      SELECT  fa.application_short_name
         , flue.severity, fltc.component_appl_id, fltc.component_type
         , fltc.component_id
      INTO
        l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
      FROM 	fnd_log_transaction_context fltc,
     	  fnd_log_messages flm,
     	  fnd_log_exceptions fle,
     	  FND_LOG_UNIQUE_EXCEPTIONS flue,
     	  fnd_application fa
     WHERE
        flm.log_sequence = to_number(itemkey)
        and	flm.log_sequence = fle.log_sequence
        and fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
 	  and fltc.transaction_context_id = flm.transaction_context_id
	  and fltc.component_appl_id = fa.application_id (+);

Line: 289

    select VALUE into l_system from  V$PARAMETER where NAME='db_name';

Line: 338

     SELECT subscription_id, role_id, component_type, severity, category, component_id
     FROM FND_OAM_BIZEX_SUBSCRIP
     WHERE
        (application_id = l_app_id)
      OR(application_id IS NULL)
      ;

Line: 349

    SELECT fltc.COMPONENT_APPL_ID, fltc.COMPONENT_TYPE
       ,flue.CATEGORY, flue.SEVERITY
       ,fltc.component_id, fle.UNIQUE_EXCEPTION_ID
    INTO
       l_app_id, l_comp_type
      ,l_category, l_severity
      ,l_comp_id, l_unique_ex_id
    FROM FND_LOG_MESSAGES flm
      ,FND_LOG_TRANSACTION_CONTEXT fltc
      ,FND_LOG_EXCEPTIONS fle
      ,FND_LOG_UNIQUE_EXCEPTIONS flue
    WHERE
        flm.LOG_SEQUENCE = TO_NUMBER(itemkey)
    AND fle.LOG_SEQUENCE = flm.LOG_SEQUENCE
    AND fltc.TRANSACTION_CONTEXT_ID = flm.TRANSACTION_CONTEXT_ID
    AND fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID;

Line: 423

       insert into FND_OAM_BIZEX_SENT_NOTIF(UNIQUE_EXCEPTION_ID,  SUBSCRIPTION_ID, SENT) values
        (l_unique_ex_id, subs_record.SUBSCRIPTION_ID, sysdate);

Line: 507

      SELECT
        fa.application_short_name, fl.meaning,
	  fltc.component_appl_id, fltc.component_type, fltc.component_id
      INTO
        l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
      FROM 	fnd_log_transaction_context fltc,
     	  fnd_log_messages flm,
     	  fnd_log_exceptions fle,
     	  FND_LOG_UNIQUE_EXCEPTIONS flue,
     	  fnd_application_vl fa,
        fnd_lookups fl
     WHERE
        flm.log_sequence = document_id
            and flm.log_sequence = fle.log_sequence
            and fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
		and fltc.transaction_context_id = flm.transaction_context_id
	      and fltc.component_appl_id = fa.application_id (+)
	      and flue.severity = fl.lookup_code (+)
	      and fl.lookup_type = 'FND_KBF_SEVERITY'
	      and	flm.log_sequence = document_id;

Line: 529

    select VALUE into l_system from  V$PARAMETER where NAME='db_name';

Line: 602

      SELECT  fa.application_short_name, fa.application_name
         , flu.meaning, fltc.component_appl_id, fltc.component_type
         , fltc.component_id
      INTO
        l_app_sn, l_app_fn, l_comp_type_d, l_app_id, l_comp_type, l_comp_id
      FROM 	fnd_log_transaction_context fltc,
     	  fnd_log_messages flm,
     	  fnd_application_vl fa,
        fnd_lookups flu
     WHERE
                  flm.log_sequence = document_id
   	      and   fltc.transaction_context_id = flm.transaction_context_id
	      and 	fltc.component_appl_id = fa.application_id (+)
     and decode(fltc.component_type,'FUNCTION','ICX_APP_MODULE',fltc.component_type) = flu.lookup_code (+)
            and   flu.lookup_type = 'FND_COMPONENT_TYPE';

Line: 695

	    l_parameter_list.DELETE;