DBA Data[Home] [Help]

APPS.IGS_AS_NOTIFY_PKG dependencies on WF_PARAMETER_LIST_T

Line 173: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

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

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 226: p_parameters => l_wf_parameter_list_t);

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,

Line 966: l_parameter_list_t wf_parameter_list_t;

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);