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;
177: CURSOR c_nbe
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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,
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,
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:
228: -- Record that the business event was created
229: igs_as_notify_be_pkg.insert_row (x_rowid =>l_rowid,
230: x_uoo_id =>lp_uoo_id,
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.
970: wf_event_t.Initialize(l_event_t);