APPS.IGP_WZ_PUBLISH_TEMPLATE_PKG dependencies on WF_EVENT

Line 28: l_event_t wf_event_t;

24: CURSOR c_seq_num IS
25: SELECT igp_wz_temp_approve_s.NEXTVAL
26: FROM dual;
27: ln_seq_val NUMBER;
28: l_event_t wf_event_t;
29: l_parameter_list_t wf_parameter_list_t;
30:
31: BEGIN
32:

Line 34: wf_event_t.Initialize(l_event_t);

30:
31: BEGIN
32:
33: -- initialize the parameter list.
34: wf_event_t.Initialize(l_event_t);
35:
36: -- set the parameters.
37: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_ID', p_value => p_template_id, p_parameterlist => l_parameter_list_t);
38: wf_event.AddParameterToList ( p_name => 'P_USER_ID' , p_value => p_user_id, p_parameterlist => l_parameter_list_t);

Line 37: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_ID', p_value => p_template_id, p_parameterlist => l_parameter_list_t);

33: -- initialize the parameter list.
34: wf_event_t.Initialize(l_event_t);
35:
36: -- set the parameters.
37: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_ID', p_value => p_template_id, p_parameterlist => l_parameter_list_t);
38: wf_event.AddParameterToList ( p_name => 'P_USER_ID' , p_value => p_user_id, p_parameterlist => l_parameter_list_t);
39: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_NAME' , p_value => p_template_name, p_parameterlist => l_parameter_list_t);
40:
41: -- get the sequence value to be added to EVENT KEY to make it unique.

Line 38: wf_event.AddParameterToList ( p_name => 'P_USER_ID' , p_value => p_user_id, p_parameterlist => l_parameter_list_t);

34: wf_event_t.Initialize(l_event_t);
35:
36: -- set the parameters.
37: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_ID', p_value => p_template_id, p_parameterlist => l_parameter_list_t);
38: wf_event.AddParameterToList ( p_name => 'P_USER_ID' , p_value => p_user_id, p_parameterlist => l_parameter_list_t);
39: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_NAME' , p_value => p_template_name, p_parameterlist => l_parameter_list_t);
40:
41: -- get the sequence value to be added to EVENT KEY to make it unique.
42: OPEN c_seq_num;

Line 39: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_NAME' , p_value => p_template_name, p_parameterlist => l_parameter_list_t);

35:
36: -- set the parameters.
37: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_ID', p_value => p_template_id, p_parameterlist => l_parameter_list_t);
38: wf_event.AddParameterToList ( p_name => 'P_USER_ID' , p_value => p_user_id, p_parameterlist => l_parameter_list_t);
39: wf_event.AddParameterToList ( p_name => 'P_TEMPLATE_NAME' , p_value => p_template_name, p_parameterlist => l_parameter_list_t);
40:
41: -- get the sequence value to be added to EVENT KEY to make it unique.
42: OPEN c_seq_num;
43: FETCH c_seq_num INTO ln_seq_val ;

Line 47: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.igp.wz.publish_template',

43: FETCH c_seq_num INTO ln_seq_val ;
44: CLOSE c_seq_num ;
45:
46: -- raise event
47: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.igp.wz.publish_template',
48: p_event_key => 'IGPWZ001'|| p_template_name ||ln_seq_val,
49: p_parameters => l_parameter_list_t
50: );
51: