DBA Data[Home] [Help]

APPS.IGS_PS_WF_EVENT_PKG dependencies on WF_PARAMETER_LIST_T

Line 31: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

27: p_message OUT NOCOPY VARCHAR2
28: )
29: IS
30: l_wf_event_t WF_EVENT_T;
31: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
32:
33: --
34: -- cursor to fetch the usec_occur_id
35: --

Line 81: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );

77: l_wf_event_t.setEventKey ( pEventKey => p_event_key||l_key );
78: --
79: -- set the parameter list
80: --
81: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
82: --
83: -- now add the parameters to the parameter list
84: --
85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));

Line 99: p_parameters => l_wf_parameter_list_t);

95: --
96: WF_EVENT.RAISE (p_event_name => p_event_name,
97: p_event_key => p_event_key||l_key,
98: p_event_data => NULL,
99: p_parameters => l_wf_parameter_list_t);
100: END raise_event;
101:
102: --
103: -- procedure to update igs_ps_usec_occurs

Line 323: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

319: -------------------------------------------------------------------------------------
320: AS
321: l_n_key NUMBER;
322: l_wf_event_t WF_EVENT_T;
323: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
324:
325: l_c_user_name fnd_user.user_name%TYPE:=fnd_global.user_name;
326: l_c_cal_type igs_ca_inst.cal_type%TYPE;
327: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;

Line 382: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );

378: CLOSE c_seq;
379: --
380: -- set the parameter list
381: --
382: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);

Line 386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);

382: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event

Line 387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);

383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event
391:

Line 388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);

384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event
391:
392: wf_event.raise (

Line 395: p_parameters => l_wf_parameter_list_t

391:
392: wf_event.raise (
393: p_event_name => 'oracle.apps.igs.ps.fac_workload.exceed',
394: p_event_key => 'FACEXCEEDWL'||l_n_key,
395: p_parameters => l_wf_parameter_list_t
396: );
397: EXCEPTION
398: WHEN OTHERS THEN
399: ROLLBACK;