APPS.IGP_VW_GEN_001_PKG dependencies on WF_EVENT

Line 375: l_event_t wf_event_t;

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);
378: l_parameter_list_t wf_parameter_list_t;
379: l_error_message VARCHAR2(500);

Line 390: -- initialize the wf_event_t object

386: FETCH c_get_seq_val INTO l_seq_val;
387: CLOSE c_get_seq_val;
388: l_seq_val_vw:=to_char(l_seq_val);
389: --
390: -- initialize the wf_event_t object
391: --
392: wf_event_t.initialize(l_event_t);
393:
394: --

Line 392: wf_event_t.initialize(l_event_t);

388: l_seq_val_vw:=to_char(l_seq_val);
389: --
390: -- initialize the wf_event_t object
391: --
392: wf_event_t.initialize(l_event_t);
393:
394: --
395: -- Adding the parameters to the parameter list
396: --

Line 397: wf_event.addparametertolist( p_name => 'P_VIEWER_IDS',

393:
394: --
395: -- Adding the parameters to the parameter list
396: --
397: wf_event.addparametertolist( p_name => 'P_VIEWER_IDS',
398: p_value => p_viewer_ids ,
399: p_parameterlist => l_parameter_list_t);
400:
401: wf_event.addparametertolist( p_name => 'P_PORTFOLIO_IDS',

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

397: wf_event.addparametertolist( p_name => 'P_VIEWER_IDS',
398: p_value => p_viewer_ids ,
399: p_parameterlist => l_parameter_list_t);
400:
401: wf_event.addparametertolist( p_name => 'P_PORTFOLIO_IDS',
402: p_value => p_portfolio_ids,
403: p_parameterlist => l_parameter_list_t);
404:
405: wf_event.addparametertolist( p_name => 'P_EXPDATE',

Line 405: wf_event.addparametertolist( p_name => 'P_EXPDATE',

401: wf_event.addparametertolist( p_name => 'P_PORTFOLIO_IDS',
402: p_value => p_portfolio_ids,
403: p_parameterlist => l_parameter_list_t);
404:
405: wf_event.addparametertolist( p_name => 'P_EXPDATE',
406: p_value => p_access_exp_date,
407: p_parameterlist => l_parameter_list_t);
408:
409: --Raise the events...

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

406: p_value => p_access_exp_date,
407: p_parameterlist => l_parameter_list_t);
408:
409: --Raise the events...
410: wf_event.raise (p_event_name => l_viewer_event,
411: p_event_key => l_seq_val_vw,
412: p_parameters => l_parameter_list_t);
413:
414: --

Line 531: l_event_t wf_event_t;

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);
534: l_parameter_list_t wf_parameter_list_t;
535: l_message_text VARCHAR2(32000);

Line 571: -- initialize the wf_event_t object

567: CLOSE c_get_seq_val;
568: l_seq_val_au:=to_char(l_seq_num);
569:
570: --
571: -- initialize the wf_event_t object
572: --
573: wf_event_t.initialize(l_event_t);
574:
575: --

Line 573: wf_event_t.initialize(l_event_t);

569:
570: --
571: -- initialize the wf_event_t object
572: --
573: wf_event_t.initialize(l_event_t);
574:
575: --
576: -- Adding the parameters to the parameter list
577: --

Line 583: wf_event.addparametertolist( p_name => 'P_MESSAGE_TEXT',

579: --
580:
581: Create_Author_Message(p_viewer_ids,l_message_text);
582:
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.

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

607: OPEN c_port_info(l_port_id);
608: FETCH c_port_info INTO rec_port_info;
609: CLOSE c_port_info;
610:
611: wf_event.addparametertolist( p_name => 'P_PORT_NAME',
612: p_value => rec_port_info.portfolio_name,
613: p_parameterlist => l_parameter_list_t);
614:
615: wf_event.addparametertolist( p_name => 'P_AUTHOR_ROLE',

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

611: wf_event.addparametertolist( p_name => 'P_PORT_NAME',
612: p_value => rec_port_info.portfolio_name,
613: p_parameterlist => l_parameter_list_t);
614:
615: wf_event.addparametertolist( p_name => 'P_AUTHOR_ROLE',
616: p_value => rec_port_info.user_name,
617: p_parameterlist => l_parameter_list_t);
618:
619: --Raise the event...

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

616: p_value => rec_port_info.user_name,
617: p_parameterlist => l_parameter_list_t);
618:
619: --Raise the event...
620: wf_event.raise ( p_event_name => l_author_event,
621: p_event_key => l_seq_val_au,
622: p_parameters => l_parameter_list_t);
623:
624: IF (l_cur_pos = 0) THEN