312: -- nsidana 4/22/2004 Populating the WF param for displaying the name of the CC while sending
313: -- access removal notification to CC / Author.
314: --
315: ---------------------------------------------------------------------------*/
316: l_event_t wf_event_t;
317: l_viewer_event VARCHAR2(50);
318: l_seq_val_vw VARCHAR2(100) ;
319: l_parameter_list_t wf_parameter_list_t;
320: l_error_message VARCHAR2(500);
341:
342: l_seq_val_vw := 'IGPVW2CC'||to_char(SYSDATE,'YYYYMMDDHH24MISS');
343: l_viewer_event := 'oracle.apps.igs.igp.vw.inform_cc';
344: --
345: -- initialize the wf_event_t object
346: --
347: wf_event_t.initialize(l_event_t);
348:
349: --
343: l_viewer_event := 'oracle.apps.igs.igp.vw.inform_cc';
344: --
345: -- initialize the wf_event_t object
346: --
347: wf_event_t.initialize(l_event_t);
348:
349: --
350: -- Adding the parameters to the parameter list
351: --
417: -- nsidana 4/22/2004 Populating the WF param for displaying the name of the CC while sending
418: -- access removal notification to CC / Author.
419: --
420: --------------------------------------------------------------------------------------------------------------*/
421: l_event_t wf_event_t;
422: l_author_event VARCHAR2(50);
423: l_seq_val_au VARCHAR2(100);
424: l_parameter_list_t wf_parameter_list_t;
425: l_message_text VARCHAR2(32000);
470: l_basic_text :=null;
471: nbsp := fnd_global.local_chr(38) || 'nbsp;';
472: l_author_event := 'oracle.apps.igs.igp.vw.inform_author_rem';
473: --
474: -- initialize the wf_event_t object
475: --
476: wf_event_t.initialize(l_event_t);
477:
478: --
472: l_author_event := 'oracle.apps.igs.igp.vw.inform_author_rem';
473: --
474: -- initialize the wf_event_t object
475: --
476: wf_event_t.initialize(l_event_t);
477:
478: --
479: -- Adding the parameters to the parameter list
480: --
633: p_invalid_assignments IN varchar2
634: )
635: AS
636:
637: l_event_t wf_event_t;
638: l_viewer_event VARCHAR2(50);
639: l_seq_val_vw VARCHAR2(100);
640: l_parameter_list_t wf_parameter_list_t;
641: l_error_message VARCHAR2(500);
642: BEGIN
643: l_viewer_event := 'oracle.apps.igs.igp.vw.inform_cc';
644: l_seq_val_vw := 'IGPVW2CC'||to_char(SYSDATE,'YYYYMMDDHH24MISS');
645: --
646: -- initialize the wf_event_t object
647: --
648: wf_event_t.initialize(l_event_t);
649:
650: wf_event.addparametertolist( p_name => 'P_INVALID_ASSIGN_LIST',
644: l_seq_val_vw := 'IGPVW2CC'||to_char(SYSDATE,'YYYYMMDDHH24MISS');
645: --
646: -- initialize the wf_event_t object
647: --
648: wf_event_t.initialize(l_event_t);
649:
650: wf_event.addparametertolist( p_name => 'P_INVALID_ASSIGN_LIST',
651: p_value => p_invalid_assignments,
652: p_parameterlist => l_parameter_list_t);