DBA Data[Home] [Help]

APPS.IGS_PE_GEN_002 dependencies on WF_EVENT

Line 157: l_event_t wf_event_t;

153: FROM
154: DUAL;
155:
156: ln_seq_val NUMBER;
157: l_event_t wf_event_t;
158: l_parameter_list_t wf_parameter_list_t;
159:
160: BEGIN
161:

Line 163: wf_event_t.Initialize(l_event_t);

159:
160: BEGIN
161:
162: -- initialize the parameter list.
163: wf_event_t.Initialize(l_event_t);
164:
165: -- set the parameters.
166: wf_event.AddParameterToList ( p_name => 'P_PERSON_NUMBER' , p_value => p_person_number , p_parameterlist => l_parameter_list_t);
167: wf_event.AddParameterToList ( p_Name => 'P_HOLD_TYPE' , p_Value => p_hold_type , p_ParameterList => l_parameter_list_t);

Line 166: wf_event.AddParameterToList ( p_name => 'P_PERSON_NUMBER' , p_value => p_person_number , p_parameterlist => l_parameter_list_t);

162: -- initialize the parameter list.
163: wf_event_t.Initialize(l_event_t);
164:
165: -- set the parameters.
166: wf_event.AddParameterToList ( p_name => 'P_PERSON_NUMBER' , p_value => p_person_number , p_parameterlist => l_parameter_list_t);
167: wf_event.AddParameterToList ( p_Name => 'P_HOLD_TYPE' , p_Value => p_hold_type , p_ParameterList => l_parameter_list_t);
168: wf_event.AddParameterToList ( p_Name => 'P_START_DT' , p_Value => p_start_dt , p_ParameterList => l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'P_END_DT' , p_Value => p_end_dt , p_ParameterList => l_parameter_list_t);
170:

Line 167: wf_event.AddParameterToList ( p_Name => 'P_HOLD_TYPE' , p_Value => p_hold_type , p_ParameterList => l_parameter_list_t);

163: wf_event_t.Initialize(l_event_t);
164:
165: -- set the parameters.
166: wf_event.AddParameterToList ( p_name => 'P_PERSON_NUMBER' , p_value => p_person_number , p_parameterlist => l_parameter_list_t);
167: wf_event.AddParameterToList ( p_Name => 'P_HOLD_TYPE' , p_Value => p_hold_type , p_ParameterList => l_parameter_list_t);
168: wf_event.AddParameterToList ( p_Name => 'P_START_DT' , p_Value => p_start_dt , p_ParameterList => l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'P_END_DT' , p_Value => p_end_dt , p_ParameterList => l_parameter_list_t);
170:
171: -- get the sequence value to be added to EVENT KEY to make it unique.

Line 168: wf_event.AddParameterToList ( p_Name => 'P_START_DT' , p_Value => p_start_dt , p_ParameterList => l_parameter_list_t);

164:
165: -- set the parameters.
166: wf_event.AddParameterToList ( p_name => 'P_PERSON_NUMBER' , p_value => p_person_number , p_parameterlist => l_parameter_list_t);
167: wf_event.AddParameterToList ( p_Name => 'P_HOLD_TYPE' , p_Value => p_hold_type , p_ParameterList => l_parameter_list_t);
168: wf_event.AddParameterToList ( p_Name => 'P_START_DT' , p_Value => p_start_dt , p_ParameterList => l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'P_END_DT' , p_Value => p_end_dt , p_ParameterList => l_parameter_list_t);
170:
171: -- get the sequence value to be added to EVENT KEY to make it unique.
172: OPEN c_seq_num;

Line 169: wf_event.AddParameterToList ( p_Name => 'P_END_DT' , p_Value => p_end_dt , p_ParameterList => l_parameter_list_t);

165: -- set the parameters.
166: wf_event.AddParameterToList ( p_name => 'P_PERSON_NUMBER' , p_value => p_person_number , p_parameterlist => l_parameter_list_t);
167: wf_event.AddParameterToList ( p_Name => 'P_HOLD_TYPE' , p_Value => p_hold_type , p_ParameterList => l_parameter_list_t);
168: wf_event.AddParameterToList ( p_Name => 'P_START_DT' , p_Value => p_start_dt , p_ParameterList => l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'P_END_DT' , p_Value => p_end_dt , p_ParameterList => l_parameter_list_t);
170:
171: -- get the sequence value to be added to EVENT KEY to make it unique.
172: OPEN c_seq_num;
173: FETCH c_seq_num INTO ln_seq_val ;

Line 177: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pe.extholdss',

173: FETCH c_seq_num INTO ln_seq_val ;
174: CLOSE c_seq_num ;
175:
176:
177: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pe.extholdss',
178: p_event_key => 'PE003C'||ln_seq_val,
179: p_parameters => l_parameter_list_t
180: );
181: END raise_success_event;