APPS.FND_EVENT SQL Statements

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

Line: 134

       select fnd_events_s.nextval
         into g_event_id
         from sys.dual;

Line: 234

    insert_error       exception;

Line: 269

       select USERENV('SESSIONID')
         into g_audsid
         from sys.dual;

Line: 273

       select MACHINE
	 into g_node
	from v$session
	 where audsid = g_audsid;

Line: 279

		select module
			into g_module
		from v$session
			where audsid = g_audsid;

Line: 297

          insert into fnd_events
 	     (event_id, source_application_id, source_id,
              source_type, dest_type, message_appl_short_name,
	      message_name, module, user_id, resp_appl_id,
	      responsibility_id, security_group_id, session_id, node,
	      db_instance, audsid, time,
              severity, processed, tokens)
          values
	     (g_event_id, g_source_appl_id, g_source_id,
              g_source_type, g_dest_type, g_message_appl,
              g_message_name, g_module, g_user_id, g_resp_appl_id,
	      g_responsibility_id, g_security_group_id, g_session_id,
	      g_node, g_db_instance, g_audsid, sysdate,
              g_severity, 'N', has_tokens);

Line: 313

             raise insert_error;

Line: 324

              insert into fnd_event_tokens
                     (event_id, token,
                      type, value)
              values
                     ( post.event_id, p_token_name,
                       p_token_translate, p_token_value);

Line: 331

                 raise insert_error;

Line: 349

      when insert_error then
         fnd_message.set_name ('FND', 'SQL-Generic error');

Line: 354

                        'ROUTINE', 'FND_EVENT.post: insert_error', FALSE);

Line: 384

   update fnd_events
      set processed = upper(flag)
    where event_id = set_processed.event_id;

Line: 423

     select /*+ index(FND_EVENTS) */ event_id, message_name, tokens
       from fnd_events
      where source_id = p_source_id
        and source_type = p_source_type
            order by event_id;

Line: 430

     select token, type, value
       from fnd_event_tokens
      where event_id = p_event_id;

Line: 450

       select USERENV('SESSIONID')
         into l_source_id
         from sys.dual;

Line: 582

         select event_id
           from fnd_events
          where processed = 'N';

Line: 587

         select token, type, value
           from fnd_event_tokens
          where event_id = instance_id;

Line: 609

        select message_appl_short_name, message_name,
               time, severity, tokens
          into msg_appl_sn, msg_name, t, sev, token_flag
          from fnd_events
         where event_id = inst_id
           and processed = 'N'
         for update of processed nowait;

Line: 624

      update fnd_events
         set processed = 'Y'
       where event_id = inst_id;

Line: 710

         select token, type, value
           from fnd_event_tokens
          where event_id = instance_id;

Line: 721

      select message_appl_short_name, message_name, tokens
          into msg_appl_sn, msg_name, token_flag
          from fnd_events
         where event_id = oem_get_text.event_id;