[Home] [Help]
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:
313: raise insert_error;
314: end if;
315: end;
316:
317: -- insert into fnd_event_tokens table
318: begin
319: for i in 1..g_token_count loop
320: p_token_name := g_tokens(i).token;
321: p_token_value := g_tokens(i).value;
320: p_token_name := g_tokens(i).token;
321: p_token_value := g_tokens(i).value;
322: p_token_translate := g_tokens(i).type;
323:
324: insert into fnd_event_tokens
325: (event_id, token,
326: type, value)
327: values
328: ( post.event_id, p_token_name,
427: order by event_id;
428:
429: cursor c_conc_tokens( p_event_id number) is
430: select token, type, value
431: from fnd_event_tokens
432: where event_id = p_event_id;
433:
434: l_event_id number;
435: l_message_name varchar2(30);
584: where processed = 'N';
585:
586: cursor c2 (instance_id number) is
587: select token, type, value
588: from fnd_event_tokens
589: where event_id = instance_id;
590:
591: inst_id number;
592: msg_appl_sn varchar2(50);
707: FUNCTION oem_get_text ( event_id number ) return varchar2 is
708:
709: cursor c (instance_id number) is
710: select token, type, value
711: from fnd_event_tokens
712: where event_id = instance_id;
713:
714: msg_appl_sn varchar2(50);
715: msg_name varchar2(30) default null;