[Home] [Help]
26: p_portfolio_ids IN varchar2 ) AS
27:
28: /*--------------------------------------------------------------------------
29: -- Created by : ssawhney
30: -- Purpose : Get individual Viewers from the viewer's list.
31: -- Form an Adhoc Role and Add each viewer as a Role User.
32: --
33: -- History
34: ---------------------------------------------------------------------------*/
360: p_access_exp_date IN varchar2
361: ) AS
362: /*--------------------------------------------------------------------------
363: -- Created by : ssawhney
364: -- Purpose : Get individual Authors of the portfolio from the portfolios's list.
365: -- Get Viewers details.
366: -- Formulate a html message text to be sent to author for all viewers that got assigned to his portfolio.
367: -- History
368: ---------------------------------------------------------------------------*/
369:
370: CURSOR c_get_seq_val
371: IS
372: select igp_ac_bus_events_s.nextval
373: from dual;
374:
375: l_event_t wf_event_t;
376: l_viewer_event VARCHAR2(50);
377: l_seq_val_vw VARCHAR2(100);
458: nbsp := fnd_global.local_chr(38) || 'nbsp;';
459:
460: l_viewer_ids :=p_viewer_ids;
461:
462: -- LOOP through all viewer passed in the contacte-nated string. get details of individual and form a HTML text.
463: IF (l_viewer_ids IS NOT NULL) THEN
464:
465: l_start_pos := 1;
466: l_end_pos := LENGTH(l_viewer_ids);
516: p_portfolio_ids IN varchar2
517: ) AS
518: /*--------------------------------------------------------------------------
519: -- Created by : ssawhney
520: -- Purpose : Get individual Authors of the portfolio from the portfolios's list.
521: -- Get Viewers details.
522: -- Formulate a html message text to be sent to author for all viewers that got assigned to his portfolio.
523: -- History
524: ---------------------------------------------------------------------------*/
525:
526: CURSOR c_get_seq_val
527: IS
528: select igp_ac_bus_events_s.nextval
529: from dual;
530:
531: l_event_t wf_event_t;
532: l_author_event VARCHAR2(50);
533: l_seq_val_au VARCHAR2(100);
583: wf_event.addparametertolist( p_name => 'P_MESSAGE_TEXT',
584: p_value => l_message_text,
585: p_parameterlist => l_parameter_list_t);
586:
587: -- loop for items in the Portfolio List...get individual author and the portfolio name.
588: -- raise multiple BEs, cause we want to show author and portfolio information both
589: -- hence we can not have the ADHOC role logic here.
590:
591: l_portfolio_ids:= p_portfolio_ids;