APPS.FND_EVENT dependencies on FND_EVENTS

Line 134: select fnd_events_s.nextval

130: g_tokens := empty_token;
131:
132: -- get next event_id from sequence
133: begin
134: select fnd_events_s.nextval
135: into g_event_id
136: from sys.dual;
137:
138: exception

Line 213: -- It inserts the cp_event into fnd_events table, fnd_event_tokens

209: END;
210:
211: -- Name : post
212: -- Description:
213: -- It inserts the cp_event into fnd_events table, fnd_event_tokens
214: -- Call this function after calling initialize and optionally set_token.
215: -- If successfull it returns TRUE else returns FALSE.
216: -- Arguments: event_id - event_id for which you want to post events.
217:

Line 295: -- insert into fnd_events table

291: g_source_type := 'O'; -- use source_type as Others
292: end if;
293:
294:
295: -- insert into fnd_events table
296: begin
297: insert into fnd_events
298: (event_id, source_application_id, source_id,
299: source_type, dest_type, message_appl_short_name,

Line 297: insert into fnd_events

293:
294:
295: -- insert into fnd_events table
296: begin
297: insert into fnd_events
298: (event_id, source_application_id, source_id,
299: source_type, dest_type, message_appl_short_name,
300: message_name, module, user_id, resp_appl_id,
301: responsibility_id, security_group_id, session_id, node,

Line 384: update fnd_events

380: if ( upper(flag) not in ('Y','N') ) then
381: raise invalid_flag;
382: end if;
383:
384: update fnd_events
385: set processed = upper(flag)
386: where event_id = set_processed.event_id;
387:
388: commit;

Line 423: select /*+ index(FND_EVENTS) */ event_id, message_name, tokens

419: message IN OUT NOCOPY varchar2,
420: remaining IN OUT NOCOPY number) return boolean is
421:
422: cursor c_conc_events(p_source_id number, p_source_type varchar2) is
423: select /*+ index(FND_EVENTS) */ event_id, message_name, tokens
424: from fnd_events
425: where source_id = p_source_id
426: and source_type = p_source_type
427: order by event_id;

Line 424: from fnd_events

420: remaining IN OUT NOCOPY number) return boolean is
421:
422: cursor c_conc_events(p_source_id number, p_source_type varchar2) is
423: select /*+ index(FND_EVENTS) */ event_id, message_name, tokens
424: from fnd_events
425: where source_id = p_source_id
426: and source_type = p_source_type
427: order by event_id;
428:

Line 556: -- of 'O' from the fnd_events table. The retrieved event is marked

552: -- OEM_GET
553: --
554: -- Purpose
555: -- Retrieves the next unprocessed event with a destination type
556: -- of 'O' from the fnd_events table. The retrieved event is marked
557: -- as processed.
558: --
559: -- Arguments
560: -- event_text - Text of the event. (out)

Line 583: from fnd_events

579: pragma exception_init(row_locked, -54);
580:
581: cursor c1 is
582: select event_id
583: from fnd_events
584: where processed = 'N';
585:
586: cursor c2 (instance_id number) is
587: select token, type, value

Line 612: from fnd_events

608: begin
609: select message_appl_short_name, message_name,
610: time, severity, tokens
611: into msg_appl_sn, msg_name, t, sev, token_flag
612: from fnd_events
613: where event_id = inst_id
614: and processed = 'N'
615: for update of processed nowait;
616: exception

Line 624: update fnd_events

620: goto loop_end;
621: end;
622:
623: /* We've got the lock. Mark the event has processed. */
624: update fnd_events
625: set processed = 'Y'
626: where event_id = inst_id;
627:
628: commit;

Line 723: from fnd_events

719: begin
720:
721: select message_appl_short_name, message_name, tokens
722: into msg_appl_sn, msg_name, token_flag
723: from fnd_events
724: where event_id = oem_get_text.event_id;
725:
726: if (msg_name is null) then
727: return null;