eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_NOTIFY_PKG dependencies on WF_EVENT

Line 172: l_wf_event_t WF_EVENT_T;

168: || (reverse chronological order - newest change first)
169: */
170:
171:
172: l_wf_event_t WF_EVENT_T;
173: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
174: l_key NUMBER;
175: v_dummy VARCHAR2(1);
176: l_rowid ROWID;

Line 196: -- Initialize the wf_event_t object

192: END IF;
193: CLOSE c_nbe;
194: END IF;
195:
196: -- Initialize the wf_event_t object
197: WF_EVENT_T.Initialize(l_wf_event_t);
198:
199: -- Set the event name
200: l_wf_event_t.setEventName(pEventName => lp_internal_name);

Line 197: WF_EVENT_T.Initialize(l_wf_event_t);

193: CLOSE c_nbe;
194: END IF;
195:
196: -- Initialize the wf_event_t object
197: WF_EVENT_T.Initialize(l_wf_event_t);
198:
199: -- Set the event name
200: l_wf_event_t.setEventName(pEventName => lp_internal_name);
201:

Line 200: l_wf_event_t.setEventName(pEventName => lp_internal_name);

196: -- Initialize the wf_event_t object
197: WF_EVENT_T.Initialize(l_wf_event_t);
198:
199: -- Set the event name
200: l_wf_event_t.setEventName(pEventName => lp_internal_name);
201:
202: -- Set the event key
203: l_wf_event_t.setEventKey (pEventKey => lp_internal_name || lp_uoo_id);
204:

Line 203: l_wf_event_t.setEventKey (pEventKey => lp_internal_name || lp_uoo_id);

199: -- Set the event name
200: l_wf_event_t.setEventName(pEventName => lp_internal_name);
201:
202: -- Set the event key
203: l_wf_event_t.setEventKey (pEventKey => lp_internal_name || lp_uoo_id);
204:
205: -- Set the parameter list
206: l_wf_event_t.setParameterList (pParameterList => l_wf_parameter_list_t);
207:

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

202: -- Set the event key
203: l_wf_event_t.setEventKey (pEventKey => lp_internal_name || lp_uoo_id);
204:
205: -- Set the parameter list
206: l_wf_event_t.setParameterList (pParameterList => l_wf_parameter_list_t);
207:
208: -- Add the parameters to the parameter list
209: wf_event.AddParameterToList (p_Name => 'UOO_ID', p_Value => lp_uoo_id, p_parameterlist => l_wf_parameter_list_t);
210: wf_event.AddParameterToList (p_Name => 'TEACH_DESCRIPTION', p_Value => lp_teach_description,p_parameterlist => l_wf_parameter_list_t);

Line 209: wf_event.AddParameterToList (p_Name => 'UOO_ID', p_Value => lp_uoo_id, p_parameterlist => l_wf_parameter_list_t);

205: -- Set the parameter list
206: l_wf_event_t.setParameterList (pParameterList => l_wf_parameter_list_t);
207:
208: -- Add the parameters to the parameter list
209: wf_event.AddParameterToList (p_Name => 'UOO_ID', p_Value => lp_uoo_id, p_parameterlist => l_wf_parameter_list_t);
210: wf_event.AddParameterToList (p_Name => 'TEACH_DESCRIPTION', p_Value => lp_teach_description,p_parameterlist => l_wf_parameter_list_t);
211: wf_event.AddParameterToList (p_Name => 'LOAD_DESCRIPTION', p_Value => lp_load_description,p_parameterlist => l_wf_parameter_list_t);
212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);
213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);

Line 210: wf_event.AddParameterToList (p_Name => 'TEACH_DESCRIPTION', p_Value => lp_teach_description,p_parameterlist => l_wf_parameter_list_t);

206: l_wf_event_t.setParameterList (pParameterList => l_wf_parameter_list_t);
207:
208: -- Add the parameters to the parameter list
209: wf_event.AddParameterToList (p_Name => 'UOO_ID', p_Value => lp_uoo_id, p_parameterlist => l_wf_parameter_list_t);
210: wf_event.AddParameterToList (p_Name => 'TEACH_DESCRIPTION', p_Value => lp_teach_description,p_parameterlist => l_wf_parameter_list_t);
211: wf_event.AddParameterToList (p_Name => 'LOAD_DESCRIPTION', p_Value => lp_load_description,p_parameterlist => l_wf_parameter_list_t);
212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);
213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);
214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);

Line 211: wf_event.AddParameterToList (p_Name => 'LOAD_DESCRIPTION', p_Value => lp_load_description,p_parameterlist => l_wf_parameter_list_t);

207:
208: -- Add the parameters to the parameter list
209: wf_event.AddParameterToList (p_Name => 'UOO_ID', p_Value => lp_uoo_id, p_parameterlist => l_wf_parameter_list_t);
210: wf_event.AddParameterToList (p_Name => 'TEACH_DESCRIPTION', p_Value => lp_teach_description,p_parameterlist => l_wf_parameter_list_t);
211: wf_event.AddParameterToList (p_Name => 'LOAD_DESCRIPTION', p_Value => lp_load_description,p_parameterlist => l_wf_parameter_list_t);
212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);
213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);
214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);
215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);

Line 212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);

208: -- Add the parameters to the parameter list
209: wf_event.AddParameterToList (p_Name => 'UOO_ID', p_Value => lp_uoo_id, p_parameterlist => l_wf_parameter_list_t);
210: wf_event.AddParameterToList (p_Name => 'TEACH_DESCRIPTION', p_Value => lp_teach_description,p_parameterlist => l_wf_parameter_list_t);
211: wf_event.AddParameterToList (p_Name => 'LOAD_DESCRIPTION', p_Value => lp_load_description,p_parameterlist => l_wf_parameter_list_t);
212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);
213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);
214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);
215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);
216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);

Line 213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);

209: wf_event.AddParameterToList (p_Name => 'UOO_ID', p_Value => lp_uoo_id, p_parameterlist => l_wf_parameter_list_t);
210: wf_event.AddParameterToList (p_Name => 'TEACH_DESCRIPTION', p_Value => lp_teach_description,p_parameterlist => l_wf_parameter_list_t);
211: wf_event.AddParameterToList (p_Name => 'LOAD_DESCRIPTION', p_Value => lp_load_description,p_parameterlist => l_wf_parameter_list_t);
212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);
213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);
214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);
215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);
216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);
217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);

Line 214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);

210: wf_event.AddParameterToList (p_Name => 'TEACH_DESCRIPTION', p_Value => lp_teach_description,p_parameterlist => l_wf_parameter_list_t);
211: wf_event.AddParameterToList (p_Name => 'LOAD_DESCRIPTION', p_Value => lp_load_description,p_parameterlist => l_wf_parameter_list_t);
212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);
213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);
214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);
215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);
216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);
217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);
218: wf_event.AddParameterToList (p_Name => 'TITLE', p_Value => lp_title,p_parameterlist => l_wf_parameter_list_t);

Line 215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);

211: wf_event.AddParameterToList (p_Name => 'LOAD_DESCRIPTION', p_Value => lp_load_description,p_parameterlist => l_wf_parameter_list_t);
212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);
213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);
214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);
215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);
216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);
217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);
218: wf_event.AddParameterToList (p_Name => 'TITLE', p_Value => lp_title,p_parameterlist => l_wf_parameter_list_t);
219: wf_event.AddParameterToList (p_Name => 'SHORT_TITLE', p_Value => lp_short_title,p_parameterlist => l_wf_parameter_list_t);

Line 216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);

212: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_START_DT', p_Value => lp_grading_period_start_dt,p_parameterlist => l_wf_parameter_list_t);
213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);
214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);
215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);
216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);
217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);
218: wf_event.AddParameterToList (p_Name => 'TITLE', p_Value => lp_title,p_parameterlist => l_wf_parameter_list_t);
219: wf_event.AddParameterToList (p_Name => 'SHORT_TITLE', p_Value => lp_short_title,p_parameterlist => l_wf_parameter_list_t);
220: wf_event.AddParameterToList (p_Name => 'INSTRUCTOR_ID', p_Value => lp_instructor_id,p_parameterlist => l_wf_parameter_list_t);

Line 217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);

213: wf_event.AddParameterToList (p_Name => 'GRADING_PERIOD_END_DT', p_Value => lp_grading_period_end_dt,p_parameterlist => l_wf_parameter_list_t);
214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);
215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);
216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);
217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);
218: wf_event.AddParameterToList (p_Name => 'TITLE', p_Value => lp_title,p_parameterlist => l_wf_parameter_list_t);
219: wf_event.AddParameterToList (p_Name => 'SHORT_TITLE', p_Value => lp_short_title,p_parameterlist => l_wf_parameter_list_t);
220: wf_event.AddParameterToList (p_Name => 'INSTRUCTOR_ID', p_Value => lp_instructor_id,p_parameterlist => l_wf_parameter_list_t);
221:

Line 218: wf_event.AddParameterToList (p_Name => 'TITLE', p_Value => lp_title,p_parameterlist => l_wf_parameter_list_t);

214: wf_event.AddParameterToList (p_Name => 'UNIT_CD', p_Value => lp_unit_cd,p_parameterlist => l_wf_parameter_list_t);
215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);
216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);
217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);
218: wf_event.AddParameterToList (p_Name => 'TITLE', p_Value => lp_title,p_parameterlist => l_wf_parameter_list_t);
219: wf_event.AddParameterToList (p_Name => 'SHORT_TITLE', p_Value => lp_short_title,p_parameterlist => l_wf_parameter_list_t);
220: wf_event.AddParameterToList (p_Name => 'INSTRUCTOR_ID', p_Value => lp_instructor_id,p_parameterlist => l_wf_parameter_list_t);
221:
222: -- Raise the Business Event

Line 219: wf_event.AddParameterToList (p_Name => 'SHORT_TITLE', p_Value => lp_short_title,p_parameterlist => l_wf_parameter_list_t);

215: wf_event.AddParameterToList (p_Name => 'UNIT_CLASS', p_Value => lp_unit_class,p_parameterlist => l_wf_parameter_list_t);
216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);
217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);
218: wf_event.AddParameterToList (p_Name => 'TITLE', p_Value => lp_title,p_parameterlist => l_wf_parameter_list_t);
219: wf_event.AddParameterToList (p_Name => 'SHORT_TITLE', p_Value => lp_short_title,p_parameterlist => l_wf_parameter_list_t);
220: wf_event.AddParameterToList (p_Name => 'INSTRUCTOR_ID', p_Value => lp_instructor_id,p_parameterlist => l_wf_parameter_list_t);
221:
222: -- Raise the Business Event
223: WF_EVENT.RAISE (p_event_name => lp_internal_name,

Line 220: wf_event.AddParameterToList (p_Name => 'INSTRUCTOR_ID', p_Value => lp_instructor_id,p_parameterlist => l_wf_parameter_list_t);

216: wf_event.AddParameterToList (p_Name => 'LOCATION_CD', p_Value => lp_location_cd,p_parameterlist => l_wf_parameter_list_t);
217: wf_event.AddParameterToList (p_Name => 'LOCATION_DESCRIPTION', p_Value => lp_location_description,p_parameterlist => l_wf_parameter_list_t);
218: wf_event.AddParameterToList (p_Name => 'TITLE', p_Value => lp_title,p_parameterlist => l_wf_parameter_list_t);
219: wf_event.AddParameterToList (p_Name => 'SHORT_TITLE', p_Value => lp_short_title,p_parameterlist => l_wf_parameter_list_t);
220: wf_event.AddParameterToList (p_Name => 'INSTRUCTOR_ID', p_Value => lp_instructor_id,p_parameterlist => l_wf_parameter_list_t);
221:
222: -- Raise the Business Event
223: WF_EVENT.RAISE (p_event_name => lp_internal_name,
224: p_event_key => lp_internal_name || lp_uoo_id,

Line 223: WF_EVENT.RAISE (p_event_name => lp_internal_name,

219: wf_event.AddParameterToList (p_Name => 'SHORT_TITLE', p_Value => lp_short_title,p_parameterlist => l_wf_parameter_list_t);
220: wf_event.AddParameterToList (p_Name => 'INSTRUCTOR_ID', p_Value => lp_instructor_id,p_parameterlist => l_wf_parameter_list_t);
221:
222: -- Raise the Business Event
223: WF_EVENT.RAISE (p_event_name => lp_internal_name,
224: p_event_key => lp_internal_name || lp_uoo_id,
225: p_event_data => NULL,
226: p_parameters => l_wf_parameter_list_t);
227:

Line 965: l_event_t wf_event_t;

961: CURSOR c_seq_num IS
962: SELECT IGS_AS_WF_BESUAREFCDS_S.nextval
963: FROM DUAL;
964: ln_seq_val NUMBER;
965: l_event_t wf_event_t;
966: l_parameter_list_t wf_parameter_list_t;
967: BEGIN
968:
969: -- initialize the parameter list.

Line 970: wf_event_t.Initialize(l_event_t);

966: l_parameter_list_t wf_parameter_list_t;
967: BEGIN
968:
969: -- initialize the parameter list.
970: wf_event_t.Initialize(l_event_t);
971:
972: -- set the parameters.
973: wf_event.AddParameterToList ( p_name => 'AUTH_PERSON_ID' , p_value => P_AUTH_PERSON_ID , p_parameterlist => l_parameter_list_t);
974: wf_event.AddParameterToList ( p_name => 'PERSON_ID' , p_value => P_PERSON_ID , p_parameterlist => l_parameter_list_t);

Line 973: wf_event.AddParameterToList ( p_name => 'AUTH_PERSON_ID' , p_value => P_AUTH_PERSON_ID , p_parameterlist => l_parameter_list_t);

969: -- initialize the parameter list.
970: wf_event_t.Initialize(l_event_t);
971:
972: -- set the parameters.
973: wf_event.AddParameterToList ( p_name => 'AUTH_PERSON_ID' , p_value => P_AUTH_PERSON_ID , p_parameterlist => l_parameter_list_t);
974: wf_event.AddParameterToList ( p_name => 'PERSON_ID' , p_value => P_PERSON_ID , p_parameterlist => l_parameter_list_t);
975: wf_event.AddParameterToList ( p_Name => 'SUAR_ID' , p_Value => P_SUAR_ID , p_ParameterList => l_parameter_list_t);
976: wf_event.AddParameterToList ( p_Name => 'ACTION' , p_Value => p_action , p_ParameterList => l_parameter_list_t);
977:

Line 974: wf_event.AddParameterToList ( p_name => 'PERSON_ID' , p_value => P_PERSON_ID , p_parameterlist => l_parameter_list_t);

970: wf_event_t.Initialize(l_event_t);
971:
972: -- set the parameters.
973: wf_event.AddParameterToList ( p_name => 'AUTH_PERSON_ID' , p_value => P_AUTH_PERSON_ID , p_parameterlist => l_parameter_list_t);
974: wf_event.AddParameterToList ( p_name => 'PERSON_ID' , p_value => P_PERSON_ID , p_parameterlist => l_parameter_list_t);
975: wf_event.AddParameterToList ( p_Name => 'SUAR_ID' , p_Value => P_SUAR_ID , p_ParameterList => l_parameter_list_t);
976: wf_event.AddParameterToList ( p_Name => 'ACTION' , p_Value => p_action , p_ParameterList => l_parameter_list_t);
977:
978: -- get the sequence value to be added to EVENT KEY to make it unique.

Line 975: wf_event.AddParameterToList ( p_Name => 'SUAR_ID' , p_Value => P_SUAR_ID , p_ParameterList => l_parameter_list_t);

971:
972: -- set the parameters.
973: wf_event.AddParameterToList ( p_name => 'AUTH_PERSON_ID' , p_value => P_AUTH_PERSON_ID , p_parameterlist => l_parameter_list_t);
974: wf_event.AddParameterToList ( p_name => 'PERSON_ID' , p_value => P_PERSON_ID , p_parameterlist => l_parameter_list_t);
975: wf_event.AddParameterToList ( p_Name => 'SUAR_ID' , p_Value => P_SUAR_ID , p_ParameterList => l_parameter_list_t);
976: wf_event.AddParameterToList ( p_Name => 'ACTION' , p_Value => p_action , p_ParameterList => l_parameter_list_t);
977:
978: -- get the sequence value to be added to EVENT KEY to make it unique.
979: OPEN c_seq_num;

Line 976: wf_event.AddParameterToList ( p_Name => 'ACTION' , p_Value => p_action , p_ParameterList => l_parameter_list_t);

972: -- set the parameters.
973: wf_event.AddParameterToList ( p_name => 'AUTH_PERSON_ID' , p_value => P_AUTH_PERSON_ID , p_parameterlist => l_parameter_list_t);
974: wf_event.AddParameterToList ( p_name => 'PERSON_ID' , p_value => P_PERSON_ID , p_parameterlist => l_parameter_list_t);
975: wf_event.AddParameterToList ( p_Name => 'SUAR_ID' , p_Value => P_SUAR_ID , p_ParameterList => l_parameter_list_t);
976: wf_event.AddParameterToList ( p_Name => 'ACTION' , p_Value => p_action , p_ParameterList => l_parameter_list_t);
977:
978: -- get the sequence value to be added to EVENT KEY to make it unique.
979: OPEN c_seq_num;
980: FETCH c_seq_num INTO ln_seq_val ;

Line 984: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.SUArefcd.update',

980: FETCH c_seq_num INTO ln_seq_val ;
981: CLOSE c_seq_num ;
982: -- raise event
983: if (P_ACTION = 'UPDATE') then
984: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.SUArefcd.update',
985: p_event_key => 'SUA_REF'||ln_seq_val,
986: p_parameters => l_parameter_list_t);
987: end if ;
988: if (P_ACTION = 'INSERT') then

Line 989: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.SUArefcd.insert',

985: p_event_key => 'SUA_REF'||ln_seq_val,
986: p_parameters => l_parameter_list_t);
987: end if ;
988: if (P_ACTION = 'INSERT') then
989: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.SUArefcd.insert',
990: p_event_key => 'SUA_REF'||ln_seq_val,
991: p_parameters => l_parameter_list_t);
992: end if ;
993: END raise_sua_ref_cd_be;