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_EN_WLST_GEN_PROC dependencies on WF_EVENT

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

209: SELECT igs_en_inform_stud_s.NEXTVAL INTO l_key FROM dual;
210: --
211: -- now add the parameters to the parameter list
212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);

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

210: --
211: -- now add the parameters to the parameter list
212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);

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

211: -- now add the parameters to the parameter list
212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);

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

212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);

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

213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);

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

214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --

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

215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --
223: -- raise the event

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

216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --
223: -- raise the event
224: --

Line 221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);

217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --
223: -- raise the event
224: --
225: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.prog.keyprim',

Line 225: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.prog.keyprim',

221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --
223: -- raise the event
224: --
225: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.prog.keyprim',
226: p_event_key => 'keyprim'||l_key,
227: p_event_data => NULL,
228: p_parameters => l_wf_parameter_list_t);
229: END IF;

Line 266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);

262: SELECT IGS_EN_WF_MAILSTUD_S.NEXTVAL INTO l_key FROM dual;
263: --
264: -- now add the parameters to the parameter list
265: --
266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);

Line 267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);

263: --
264: -- now add the parameters to the parameter list
265: --
266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);

Line 268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);

264: -- now add the parameters to the parameter list
265: --
266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);
272: --

Line 269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);

265: --
266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);
272: --
273: -- raise the event

Line 270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);

266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);
272: --
273: -- raise the event
274: --

Line 271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);

267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);
272: --
273: -- raise the event
274: --
275: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.wlst.mailstud',

Line 275: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.wlst.mailstud',

271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);
272: --
273: -- raise the event
274: --
275: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.wlst.mailstud',
276: p_event_key => 'mailstud'||l_key,
277: p_parameters => l_param_list);
278: END IF;
279:

Line 361: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);

357:
358: --
359: -- now add the parameters to the parameter list
360: --
361: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
362: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => l_USER_ID, p_parameterlist => l_param_list);
363: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => l_RESP_ID, p_parameterlist => l_param_list);
364: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID', p_value => l_RESP_APPL_ID, p_parameterlist => l_param_list);
365: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);

Line 362: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => l_USER_ID, p_parameterlist => l_param_list);

358: --
359: -- now add the parameters to the parameter list
360: --
361: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
362: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => l_USER_ID, p_parameterlist => l_param_list);
363: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => l_RESP_ID, p_parameterlist => l_param_list);
364: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID', p_value => l_RESP_APPL_ID, p_parameterlist => l_param_list);
365: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
366: wf_event.AddParameterToList(p_name => 'PERSON_ID_LIST', p_value => p_person_id_list, p_parameterlist => l_param_list);

Line 363: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => l_RESP_ID, p_parameterlist => l_param_list);

359: -- now add the parameters to the parameter list
360: --
361: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
362: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => l_USER_ID, p_parameterlist => l_param_list);
363: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => l_RESP_ID, p_parameterlist => l_param_list);
364: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID', p_value => l_RESP_APPL_ID, p_parameterlist => l_param_list);
365: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
366: wf_event.AddParameterToList(p_name => 'PERSON_ID_LIST', p_value => p_person_id_list, p_parameterlist => l_param_list);
367: --

Line 364: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID', p_value => l_RESP_APPL_ID, p_parameterlist => l_param_list);

360: --
361: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
362: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => l_USER_ID, p_parameterlist => l_param_list);
363: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => l_RESP_ID, p_parameterlist => l_param_list);
364: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID', p_value => l_RESP_APPL_ID, p_parameterlist => l_param_list);
365: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
366: wf_event.AddParameterToList(p_name => 'PERSON_ID_LIST', p_value => p_person_id_list, p_parameterlist => l_param_list);
367: --
368: -- raise the event

Line 365: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);

361: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
362: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => l_USER_ID, p_parameterlist => l_param_list);
363: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => l_RESP_ID, p_parameterlist => l_param_list);
364: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID', p_value => l_RESP_APPL_ID, p_parameterlist => l_param_list);
365: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
366: wf_event.AddParameterToList(p_name => 'PERSON_ID_LIST', p_value => p_person_id_list, p_parameterlist => l_param_list);
367: --
368: -- raise the event
369: --

Line 366: wf_event.AddParameterToList(p_name => 'PERSON_ID_LIST', p_value => p_person_id_list, p_parameterlist => l_param_list);

362: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => l_USER_ID, p_parameterlist => l_param_list);
363: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => l_RESP_ID, p_parameterlist => l_param_list);
364: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID', p_value => l_RESP_APPL_ID, p_parameterlist => l_param_list);
365: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
366: wf_event.AddParameterToList(p_name => 'PERSON_ID_LIST', p_value => p_person_id_list, p_parameterlist => l_param_list);
367: --
368: -- raise the event
369: --
370: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.wlst.mailadm',

Line 370: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.wlst.mailadm',

366: wf_event.AddParameterToList(p_name => 'PERSON_ID_LIST', p_value => p_person_id_list, p_parameterlist => l_param_list);
367: --
368: -- raise the event
369: --
370: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.wlst.mailadm',
371: p_event_key => 'mailadm'||l_key,
372: p_parameters => l_param_list);
373: END IF;
374: END wf_send_mail_adm;

Line 498: l_wf_event_t WF_EVENT_T;

494: waitlist_pos NUMBER;
495: counter NUMBER;
496:
497: -- Workflow variables
498: l_wf_event_t WF_EVENT_T;
499: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
500: l_key NUMBER;
501: l_tot_stud NUMBER;
502: l_param_list wf_parameter_list_t:=wf_parameter_list_t();

Line 725: wf_event.AddParameterToList(p_name => l_param_name, p_value => l_param_value,p_parameterlist => l_param_list);

721: END IF;
722:
723: l_param_value := RPAD(l_student_user_name,100,' ')||cur_sua_rec.WAITLIST_MANUAL_IND||LPAD(cur_sua_rec.ADMINISTRATIVE_PRIORITY,4,'0');
724:
725: wf_event.AddParameterToList(p_name => l_param_name, p_value => l_param_value,p_parameterlist => l_param_list);
726:
727: END IF; -- end of Workflow notification
728:
729: CLOSE c_stud_unit_attempt;

Line 739: WF_EVENT.AddParameterToList(p_name => 'TOTAL_STDNT_COUNT',p_value =>l_tot_stud,p_parameterlist => l_param_list);

735: -- Workflow notification ------------------------------
736:
737: SELECT igs_en_wf_be_en001_s.NEXTVAL INTO l_key FROM dual;
738:
739: WF_EVENT.AddParameterToList(p_name => 'TOTAL_STDNT_COUNT',p_value =>l_tot_stud,p_parameterlist => l_param_list);
740: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.be_en001',
741: p_event_key => 'wlst_pos_change'|| l_key,
742: p_parameters => l_param_list);
743:

Line 740: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.be_en001',

736:
737: SELECT igs_en_wf_be_en001_s.NEXTVAL INTO l_key FROM dual;
738:
739: WF_EVENT.AddParameterToList(p_name => 'TOTAL_STDNT_COUNT',p_value =>l_tot_stud,p_parameterlist => l_param_list);
740: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.be_en001',
741: p_event_key => 'wlst_pos_change'|| l_key,
742: p_parameters => l_param_list);
743:
744:

Line 774: l_event_message WF_EVENT_T;

770:
771: IS
772:
773: l_total_std NUMBER;
774: l_event_message WF_EVENT_T;
775: l_par_st_count NUMBER;
776: l_curr_student NUMBER;
777: l_user VARCHAR2(30);
778: l_param_name VARCHAR2(50);

Line 789: l_par_st_count := wf_event.getvalueforparameter('TOTAL_STDNT_COUNT',l_event_message.parameter_list);

785:
786: IF wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT') IS NULL THEN
787:
788: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
789: l_par_st_count := wf_event.getvalueforparameter('TOTAL_STDNT_COUNT',l_event_message.parameter_list);
790:
791: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_STD_COUNT',l_par_st_count);
792: l_chk_val := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');
793:

Line 834: l_event_message WF_EVENT_T;

830: IS
831:
832: l_event_name VARCHAR2(200);
833: l_event_key VARCHAR2(200);
834: l_event_message WF_EVENT_T;
835: l_curr_student NUMBER;
836: l_param_name VARCHAR2(100);
837: l_param_Value VARCHAR2(2000);
838: l_std_name VARCHAR2(30);

Line 853: l_param_value := wf_event.getvalueforparameter(l_param_name,l_event_message.parameter_list);

849: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');
850: l_curr_student := l_curr_student + 1;
851:
852: l_param_name := 'PARAM_'||l_Curr_student;
853: l_param_value := wf_event.getvalueforparameter(l_param_name,l_event_message.parameter_list);
854: l_send_wf := SUBSTR(l_param_Value,101,1);
855:
856: IF l_send_wf = 'Y' THEN
857: l_std_name := LTRIM(RTRIM(SUBSTR(l_param_Value,1,100)));