eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGP_VW_GEN_002_PKG dependencies on WF_EVENT

Line 316: l_event_t wf_event_t;

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);

Line 345: -- initialize the wf_event_t object

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: --

Line 347: wf_event_t.initialize(l_event_t);

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: --

Line 360: wf_event.addparametertolist( p_name => 'P_VIEWER_NAME',

356: OPEN c_get_CC_name(p_CC_user_name);
357: FETCH c_get_CC_name INTO l_cc_name;
358: CLOSE c_get_CC_name;
359:
360: wf_event.addparametertolist( p_name => 'P_VIEWER_NAME',
361: p_value => rec_viewer_info.viewer,
362: p_parameterlist => l_parameter_list_t);
363: wf_event.addparametertolist( p_name => 'FROM',
364: p_value => rec_viewer_info.user_name,

Line 363: wf_event.addparametertolist( p_name => 'FROM',

359:
360: wf_event.addparametertolist( p_name => 'P_VIEWER_NAME',
361: p_value => rec_viewer_info.viewer,
362: p_parameterlist => l_parameter_list_t);
363: wf_event.addparametertolist( p_name => 'FROM',
364: p_value => rec_viewer_info.user_name,
365: p_parameterlist => l_parameter_list_t);
366:
367: wf_event.addparametertolist( p_name => 'P_VIEWER_ID',

Line 367: wf_event.addparametertolist( p_name => 'P_VIEWER_ID',

363: wf_event.addparametertolist( p_name => 'FROM',
364: p_value => rec_viewer_info.user_name,
365: p_parameterlist => l_parameter_list_t);
366:
367: wf_event.addparametertolist( p_name => 'P_VIEWER_ID',
368: p_value => p_viewer_id ,
369: p_parameterlist => l_parameter_list_t);
370:
371: wf_event.addparametertolist( p_name => 'P_PORTFOLIO_IDS',

Line 371: wf_event.addparametertolist( p_name => 'P_PORTFOLIO_IDS',

367: wf_event.addparametertolist( p_name => 'P_VIEWER_ID',
368: p_value => p_viewer_id ,
369: p_parameterlist => l_parameter_list_t);
370:
371: wf_event.addparametertolist( p_name => 'P_PORTFOLIO_IDS',
372: p_value => p_portfolio_ids,
373: p_parameterlist => l_parameter_list_t);
374:
375: wf_event.addparametertolist( p_name => 'P_ACTION',

Line 375: wf_event.addparametertolist( p_name => 'P_ACTION',

371: wf_event.addparametertolist( p_name => 'P_PORTFOLIO_IDS',
372: p_value => p_portfolio_ids,
373: p_parameterlist => l_parameter_list_t);
374:
375: wf_event.addparametertolist( p_name => 'P_ACTION',
376: p_value => 'R',
377: p_parameterlist => l_parameter_list_t);
378:
379: wf_event.addparametertolist( p_name => 'P_SOURCE',

Line 379: wf_event.addparametertolist( p_name => 'P_SOURCE',

375: wf_event.addparametertolist( p_name => 'P_ACTION',
376: p_value => 'R',
377: p_parameterlist => l_parameter_list_t);
378:
379: wf_event.addparametertolist( p_name => 'P_SOURCE',
380: p_value => 'CC',
381: p_parameterlist => l_parameter_list_t);
382:
383: wf_event.addparametertolist( p_name => 'P_CC_NAME', -- nsidana 4/22/2004 : This param added to the WF to display the CC name when the notification for removal is sent to Author / CC.

Line 383: wf_event.addparametertolist( p_name => 'P_CC_NAME', -- nsidana 4/22/2004 : This param added to the WF to display the CC name when the notification for removal is sent to Author / CC.

379: wf_event.addparametertolist( p_name => 'P_SOURCE',
380: p_value => 'CC',
381: p_parameterlist => l_parameter_list_t);
382:
383: wf_event.addparametertolist( p_name => 'P_CC_NAME', -- nsidana 4/22/2004 : This param added to the WF to display the CC name when the notification for removal is sent to Author / CC.
384: p_value => l_cc_name,
385: p_parameterlist => l_parameter_list_t);
386:
387: --Raise the events...

Line 388: wf_event.raise (p_event_name => l_viewer_event,

384: p_value => l_cc_name,
385: p_parameterlist => l_parameter_list_t);
386:
387: --Raise the events...
388: wf_event.raise (p_event_name => l_viewer_event,
389: p_event_key => l_seq_val_vw,
390: p_parameters => l_parameter_list_t);
391:
392: --

Line 421: l_event_t wf_event_t;

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);

Line 474: -- initialize the wf_event_t object

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: --

Line 476: wf_event_t.initialize(l_event_t);

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: --

Line 494: wf_event.addparametertolist( p_name => 'P_VIEWER_NAME',

490: FETCH c_get_CC_name INTO l_cc_name;
491: CLOSE c_get_CC_name;
492:
493:
494: wf_event.addparametertolist( p_name => 'P_VIEWER_NAME',
495: p_value => rec_viewer_info.viewer,
496: p_parameterlist => l_parameter_list_t);
497: wf_event.addparametertolist( p_name => 'P_VIEWER_EMAIL',
498: p_value => rec_viewer_info.email_address,

Line 497: wf_event.addparametertolist( p_name => 'P_VIEWER_EMAIL',

493:
494: wf_event.addparametertolist( p_name => 'P_VIEWER_NAME',
495: p_value => rec_viewer_info.viewer,
496: p_parameterlist => l_parameter_list_t);
497: wf_event.addparametertolist( p_name => 'P_VIEWER_EMAIL',
498: p_value => rec_viewer_info.email_address,
499: p_parameterlist => l_parameter_list_t);
500: wf_event.addparametertolist( p_name => 'FROM',
501: p_value => rec_viewer_info.user_name,

Line 500: wf_event.addparametertolist( p_name => 'FROM',

496: p_parameterlist => l_parameter_list_t);
497: wf_event.addparametertolist( p_name => 'P_VIEWER_EMAIL',
498: p_value => rec_viewer_info.email_address,
499: p_parameterlist => l_parameter_list_t);
500: wf_event.addparametertolist( p_name => 'FROM',
501: p_value => rec_viewer_info.user_name,
502: p_parameterlist => l_parameter_list_t);
503:
504:

Line 529: wf_event.addparametertolist( p_name => 'P_PORT_NAME',

525: OPEN c_port_info(l_port_id);
526: FETCH c_port_info INTO rec_port_info;
527: CLOSE c_port_info;
528:
529: wf_event.addparametertolist( p_name => 'P_PORT_NAME',
530: p_value => rec_port_info.portfolio_name,
531: p_parameterlist => l_parameter_list_t);
532:
533: wf_event.addparametertolist( p_name => 'P_AUTHOR_ROLE',

Line 533: wf_event.addparametertolist( p_name => 'P_AUTHOR_ROLE',

529: wf_event.addparametertolist( p_name => 'P_PORT_NAME',
530: p_value => rec_port_info.portfolio_name,
531: p_parameterlist => l_parameter_list_t);
532:
533: wf_event.addparametertolist( p_name => 'P_AUTHOR_ROLE',
534: p_value => rec_port_info.user_name,
535: p_parameterlist => l_parameter_list_t);
536:
537: wf_event.addparametertolist( p_name => 'P_SOURCE', -- nsidana 4/21/2004 : This param P_SOURCE indicates if the Viewer / Career Center removed the Portfolio Access. As this procedure

Line 537: wf_event.addparametertolist( p_name => 'P_SOURCE', -- nsidana 4/21/2004 : This param P_SOURCE indicates if the Viewer / Career Center removed the Portfolio Access. As this procedure

533: wf_event.addparametertolist( p_name => 'P_AUTHOR_ROLE',
534: p_value => rec_port_info.user_name,
535: p_parameterlist => l_parameter_list_t);
536:
537: wf_event.addparametertolist( p_name => 'P_SOURCE', -- nsidana 4/21/2004 : This param P_SOURCE indicates if the Viewer / Career Center removed the Portfolio Access. As this procedure
538: p_value => 'CC', -- is called only from the SS page, I am defaulting this value to 'CC'. The viewer page does not call this procedure. It directly raises the
539: p_parameterlist => l_parameter_list_t); -- BE, so we have set this param there in the Java code. (File : AssignPortfolioSearchAMImpl.java
540:
541: wf_event.addparametertolist( p_name => 'P_CC_NAME', -- nsidana 4/22/2004 : This param added to the WF to display the CC name when the notification for removal is sent to Author / CC.

Line 541: wf_event.addparametertolist( p_name => 'P_CC_NAME', -- nsidana 4/22/2004 : This param added to the WF to display the CC name when the notification for removal is sent to Author / CC.

537: wf_event.addparametertolist( p_name => 'P_SOURCE', -- nsidana 4/21/2004 : This param P_SOURCE indicates if the Viewer / Career Center removed the Portfolio Access. As this procedure
538: p_value => 'CC', -- is called only from the SS page, I am defaulting this value to 'CC'. The viewer page does not call this procedure. It directly raises the
539: p_parameterlist => l_parameter_list_t); -- BE, so we have set this param there in the Java code. (File : AssignPortfolioSearchAMImpl.java
540:
541: wf_event.addparametertolist( p_name => 'P_CC_NAME', -- nsidana 4/22/2004 : This param added to the WF to display the CC name when the notification for removal is sent to Author / CC.
542: p_value => l_cc_name,
543: p_parameterlist => l_parameter_list_t);
544:
545: --Raise the event...

Line 546: wf_event.raise ( p_event_name => l_author_event,

542: p_value => l_cc_name,
543: p_parameterlist => l_parameter_list_t);
544:
545: --Raise the event...
546: wf_event.raise ( p_event_name => l_author_event,
547: p_event_key => l_seq_val_au,
548: p_parameters => l_parameter_list_t);
549:
550: IF (l_cur_pos = 0) THEN

Line 637: l_event_t wf_event_t;

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);

Line 646: -- initialize the wf_event_t object

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',

Line 648: wf_event_t.initialize(l_event_t);

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);

Line 650: wf_event.addparametertolist( p_name => 'P_INVALID_ASSIGN_LIST',

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);
653:
654: wf_event.addparametertolist( p_name => 'P_ACTION',

Line 654: wf_event.addparametertolist( p_name => 'P_ACTION',

650: wf_event.addparametertolist( p_name => 'P_INVALID_ASSIGN_LIST',
651: p_value => p_invalid_assignments,
652: p_parameterlist => l_parameter_list_t);
653:
654: wf_event.addparametertolist( p_name => 'P_ACTION',
655: p_value => 'A',
656: p_parameterlist => l_parameter_list_t);
657:
658: --Raise the events...

Line 659: wf_event.raise (p_event_name => l_viewer_event,

655: p_value => 'A',
656: p_parameterlist => l_parameter_list_t);
657:
658: --Raise the events...
659: wf_event.raise (p_event_name => l_viewer_event,
660: p_event_key => l_seq_val_vw,
661: p_parameters => l_parameter_list_t);
662:
663: --