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

Line 158: l_event_t wf_event_t;

154: -- Who When What
155: --
156: -------------------------------------------------------------------------------------------------
157:
158: l_event_t wf_event_t;
159: l_parameter_list_t wf_parameter_list_t;
160: l_itemKey varchar2(100);
161: ln_seq_val NUMBER;
162:

Line 209: -- initialize the wf_event_t object

205: FETCH cur_user_id INTO l_cur_user_id ;
206: CLOSE cur_user_id ;
207:
208: --
209: -- initialize the wf_event_t object
210: --
211:
212: wf_event_t.Initialize(l_event_t);
213:

Line 212: wf_event_t.Initialize(l_event_t);

208: --
209: -- initialize the wf_event_t object
210: --
211:
212: wf_event_t.Initialize(l_event_t);
213:
214:
215: --
216: -- Adding the parameters to the parameter list

Line 219: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);

215: --
216: -- Adding the parameters to the parameter list
217: --
218:
219: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
220: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
221: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => p_restopic, p_ParameterList => l_parameter_list_t);
222: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
223:

Line 220: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);

216: -- Adding the parameters to the parameter list
217: --
218:
219: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
220: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
221: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => p_restopic, p_ParameterList => l_parameter_list_t);
222: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
223:
224:

Line 221: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => p_restopic, p_ParameterList => l_parameter_list_t);

217: --
218:
219: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
220: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
221: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => p_restopic, p_ParameterList => l_parameter_list_t);
222: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
223:
224:
225: -- Raise the Event

Line 222: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

218:
219: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
220: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
221: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => p_restopic, p_ParameterList => l_parameter_list_t);
222: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
223:
224:
225: -- Raise the Event
226:

Line 227: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.restop.update',

223:
224:
225: -- Raise the Event
226:
227: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.restop.update',
228: p_event_key => 'RESTOPUPDATE'||ln_seq_val,
229: p_parameters => l_parameter_list_t);
230:
231: --

Line 265: l_event_t wf_event_t;

261: -- Who When What
262: --
263: -------------------------------------------------------------------------------------------------
264:
265: l_event_t wf_event_t;
266: l_parameter_list_t wf_parameter_list_t;
267: l_itemKey varchar2(100);
268: ln_seq_val NUMBER;
269:

Line 331: -- initialize the wf_event_t object

327: FETCH cur_course_cd INTO l_cur_course_cd;
328: CLOSE cur_course_cd;
329:
330: --
331: -- initialize the wf_event_t object
332: --
333:
334: wf_event_t.Initialize(l_event_t);
335:

Line 334: wf_event_t.Initialize(l_event_t);

330: --
331: -- initialize the wf_event_t object
332: --
333:
334: wf_event_t.Initialize(l_event_t);
335:
336:
337:
338: --

Line 342: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);

338: --
339: -- Adding the parameters to the parameter list
340: --
341:
342: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
343: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
344: wf_event.AddParameterToList (p_name => 'P_THESISTOPIC', p_Value => p_thesistopic, p_ParameterList => l_parameter_list_t);
345: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
346: wf_event.AddParameterToList (p_name => 'P_APPROVED', p_Value => p_approved, p_ParameterList => l_parameter_list_t);

Line 343: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);

339: -- Adding the parameters to the parameter list
340: --
341:
342: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
343: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
344: wf_event.AddParameterToList (p_name => 'P_THESISTOPIC', p_Value => p_thesistopic, p_ParameterList => l_parameter_list_t);
345: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
346: wf_event.AddParameterToList (p_name => 'P_APPROVED', p_Value => p_approved, p_ParameterList => l_parameter_list_t);
347: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);

Line 344: wf_event.AddParameterToList (p_name => 'P_THESISTOPIC', p_Value => p_thesistopic, p_ParameterList => l_parameter_list_t);

340: --
341:
342: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
343: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
344: wf_event.AddParameterToList (p_name => 'P_THESISTOPIC', p_Value => p_thesistopic, p_ParameterList => l_parameter_list_t);
345: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
346: wf_event.AddParameterToList (p_name => 'P_APPROVED', p_Value => p_approved, p_ParameterList => l_parameter_list_t);
347: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
348: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 345: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);

341:
342: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
343: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
344: wf_event.AddParameterToList (p_name => 'P_THESISTOPIC', p_Value => p_thesistopic, p_ParameterList => l_parameter_list_t);
345: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
346: wf_event.AddParameterToList (p_name => 'P_APPROVED', p_Value => p_approved, p_ParameterList => l_parameter_list_t);
347: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
348: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
349:

Line 346: wf_event.AddParameterToList (p_name => 'P_APPROVED', p_Value => p_approved, p_ParameterList => l_parameter_list_t);

342: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
343: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
344: wf_event.AddParameterToList (p_name => 'P_THESISTOPIC', p_Value => p_thesistopic, p_ParameterList => l_parameter_list_t);
345: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
346: wf_event.AddParameterToList (p_name => 'P_APPROVED', p_Value => p_approved, p_ParameterList => l_parameter_list_t);
347: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
348: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
349:
350: -- Raise the Event

Line 347: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);

343: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
344: wf_event.AddParameterToList (p_name => 'P_THESISTOPIC', p_Value => p_thesistopic, p_ParameterList => l_parameter_list_t);
345: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
346: wf_event.AddParameterToList (p_name => 'P_APPROVED', p_Value => p_approved, p_ParameterList => l_parameter_list_t);
347: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
348: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
349:
350: -- Raise the Event
351:

Line 348: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

344: wf_event.AddParameterToList (p_name => 'P_THESISTOPIC', p_Value => p_thesistopic, p_ParameterList => l_parameter_list_t);
345: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
346: wf_event.AddParameterToList (p_name => 'P_APPROVED', p_Value => p_approved, p_ParameterList => l_parameter_list_t);
347: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
348: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
349:
350: -- Raise the Event
351:
352: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.update',

Line 352: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.update',

348: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
349:
350: -- Raise the Event
351:
352: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.update',
353: p_event_key => 'THESISUPDATE'||ln_seq_val,
354: p_parameters => l_parameter_list_t);
355:
356: --

Line 394: l_event_t wf_event_t;

390: -- Who When What
391: --
392: -------------------------------------------------------------------------------------------------
393:
394: l_event_t wf_event_t;
395: l_parameter_list_t wf_parameter_list_t;
396: l_itemKey varchar2(100);
397: ln_seq_val NUMBER;
398:

Line 479: -- initialize the wf_event_t object

475: OPEN cur_res_start_dt ;
476: FETCH cur_res_start_dt INTO l_cur_res_start_dt;
477: CLOSE cur_res_start_dt;
478: --
479: -- initialize the wf_event_t object
480: --
481:
482: wf_event_t.Initialize(l_event_t);
483:

Line 482: wf_event_t.Initialize(l_event_t);

478: --
479: -- initialize the wf_event_t object
480: --
481:
482: wf_event_t.Initialize(l_event_t);
483:
484:
485: l_staff_ind := IGS_EN_GEN_003.GET_STAFF_IND(p_supervisorid);
486:

Line 491: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);

487: --
488: -- Adding the parameters to the parameter list
489: --
490:
491: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
492: wf_event.AddParameterToList (p_name => 'P_PROG_CD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
493: wf_event.AddParameterToList (p_name => 'P_SUPERVISORID', p_Value => p_supervisorid, p_ParameterList => l_parameter_list_t);
494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);
495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);

Line 492: wf_event.AddParameterToList (p_name => 'P_PROG_CD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);

488: -- Adding the parameters to the parameter list
489: --
490:
491: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
492: wf_event.AddParameterToList (p_name => 'P_PROG_CD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
493: wf_event.AddParameterToList (p_name => 'P_SUPERVISORID', p_Value => p_supervisorid, p_ParameterList => l_parameter_list_t);
494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);
495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);

Line 493: wf_event.AddParameterToList (p_name => 'P_SUPERVISORID', p_Value => p_supervisorid, p_ParameterList => l_parameter_list_t);

489: --
490:
491: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
492: wf_event.AddParameterToList (p_name => 'P_PROG_CD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
493: wf_event.AddParameterToList (p_name => 'P_SUPERVISORID', p_Value => p_supervisorid, p_ParameterList => l_parameter_list_t);
494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);
495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);

Line 494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);

490:
491: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
492: wf_event.AddParameterToList (p_name => 'P_PROG_CD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
493: wf_event.AddParameterToList (p_name => 'P_SUPERVISORID', p_Value => p_supervisorid, p_ParameterList => l_parameter_list_t);
494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);
495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);
498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);

Line 495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);

491: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
492: wf_event.AddParameterToList (p_name => 'P_PROG_CD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
493: wf_event.AddParameterToList (p_name => 'P_SUPERVISORID', p_Value => p_supervisorid, p_ParameterList => l_parameter_list_t);
494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);
495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);
498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);
499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);

Line 496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);

492: wf_event.AddParameterToList (p_name => 'P_PROG_CD', p_Value => l_cur_course_cd.sca_course_cd, p_ParameterList => l_parameter_list_t);
493: wf_event.AddParameterToList (p_name => 'P_SUPERVISORID', p_Value => p_supervisorid, p_ParameterList => l_parameter_list_t);
494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);
495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);
498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);
499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);
500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);

Line 497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);

493: wf_event.AddParameterToList (p_name => 'P_SUPERVISORID', p_Value => p_supervisorid, p_ParameterList => l_parameter_list_t);
494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);
495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);
498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);
499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);
500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);
501: wf_event.AddParameterToList (p_name => 'P_REP_PERSON_ID', p_Value => p_rep_person_id, p_ParameterList => l_parameter_list_t);

Line 498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);

494: wf_event.AddParameterToList (p_name => 'P_STAFF_IND', p_Value => l_staff_ind, p_ParameterList => l_parameter_list_t);
495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);
498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);
499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);
500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);
501: wf_event.AddParameterToList (p_name => 'P_REP_PERSON_ID', p_Value => p_rep_person_id, p_ParameterList => l_parameter_list_t);
502: wf_event.AddParameterToList (p_name => 'P_REP_STARTDT', p_Value => l_cur_res_start_dt.start_dt, p_ParameterList => l_parameter_list_t);

Line 499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);

495: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);
498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);
499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);
500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);
501: wf_event.AddParameterToList (p_name => 'P_REP_PERSON_ID', p_Value => p_rep_person_id, p_ParameterList => l_parameter_list_t);
502: wf_event.AddParameterToList (p_name => 'P_REP_STARTDT', p_Value => l_cur_res_start_dt.start_dt, p_ParameterList => l_parameter_list_t);
503: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);

496: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);
498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);
499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);
500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);
501: wf_event.AddParameterToList (p_name => 'P_REP_PERSON_ID', p_Value => p_rep_person_id, p_ParameterList => l_parameter_list_t);
502: wf_event.AddParameterToList (p_name => 'P_REP_STARTDT', p_Value => l_cur_res_start_dt.start_dt, p_ParameterList => l_parameter_list_t);
503: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
504:

Line 501: wf_event.AddParameterToList (p_name => 'P_REP_PERSON_ID', p_Value => p_rep_person_id, p_ParameterList => l_parameter_list_t);

497: wf_event.AddParameterToList (p_name => 'P_SPR_PERCENT', p_Value => p_spr_percent, p_ParameterList => l_parameter_list_t);
498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);
499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);
500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);
501: wf_event.AddParameterToList (p_name => 'P_REP_PERSON_ID', p_Value => p_rep_person_id, p_ParameterList => l_parameter_list_t);
502: wf_event.AddParameterToList (p_name => 'P_REP_STARTDT', p_Value => l_cur_res_start_dt.start_dt, p_ParameterList => l_parameter_list_t);
503: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
504:
505: -- Raise the Event

Line 502: wf_event.AddParameterToList (p_name => 'P_REP_STARTDT', p_Value => l_cur_res_start_dt.start_dt, p_ParameterList => l_parameter_list_t);

498: wf_event.AddParameterToList (p_name => 'P_SPR_TYPE', p_Value => p_spr_type, p_ParameterList => l_parameter_list_t);
499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);
500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);
501: wf_event.AddParameterToList (p_name => 'P_REP_PERSON_ID', p_Value => p_rep_person_id, p_ParameterList => l_parameter_list_t);
502: wf_event.AddParameterToList (p_name => 'P_REP_STARTDT', p_Value => l_cur_res_start_dt.start_dt, p_ParameterList => l_parameter_list_t);
503: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
504:
505: -- Raise the Event
506:

Line 503: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

499: wf_event.AddParameterToList (p_name => 'P_FUND_PERCENT', p_Value => p_fund_percent, p_ParameterList => l_parameter_list_t);
500: wf_event.AddParameterToList (p_name => 'P_ORG_UNIT_CD', p_Value => p_org_unit_cd, p_ParameterList => l_parameter_list_t);
501: wf_event.AddParameterToList (p_name => 'P_REP_PERSON_ID', p_Value => p_rep_person_id, p_ParameterList => l_parameter_list_t);
502: wf_event.AddParameterToList (p_name => 'P_REP_STARTDT', p_Value => l_cur_res_start_dt.start_dt, p_ParameterList => l_parameter_list_t);
503: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
504:
505: -- Raise the Event
506:
507: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.sprvsn.update',

Line 507: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.sprvsn.update',

503: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
504:
505: -- Raise the Event
506:
507: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.sprvsn.update',
508: p_event_key => 'SPRVSNUPDATE'||ln_seq_val,
509: p_parameters => l_parameter_list_t);
510:
511: --

Line 544: l_event_t wf_event_t;

540: -- Who When What
541: --
542: -------------------------------------------------------------------------------------------------
543:
544: l_event_t wf_event_t;
545: l_parameter_list_t wf_parameter_list_t;
546: l_itemKey varchar2(100);
547: ln_seq_val NUMBER;
548:

Line 596: -- initialize the wf_event_t object

592: FETCH cur_user_id INTO l_cur_user_id ;
593: CLOSE cur_user_id ;
594:
595: --
596: -- initialize the wf_event_t object
597: --
598:
599: wf_event_t.Initialize(l_event_t);
600:

Line 599: wf_event_t.Initialize(l_event_t);

595: --
596: -- initialize the wf_event_t object
597: --
598:
599: wf_event_t.Initialize(l_event_t);
600:
601:
602: --
603: -- Adding the parameters to the parameter list

Line 606: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);

602: --
603: -- Adding the parameters to the parameter list
604: --
605:
606: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
607: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
608: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
609: wf_event.AddParameterToList (p_name => 'P_MAXSUBDT', p_Value => p_maxsubdt, p_ParameterList => l_parameter_list_t);
610: wf_event.AddParameterToList (p_name => 'P_SUPRVSR',p_value=>p_suprvsr,p_parameterlist=>l_parameter_list_t);

Line 607: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);

603: -- Adding the parameters to the parameter list
604: --
605:
606: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
607: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
608: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
609: wf_event.AddParameterToList (p_name => 'P_MAXSUBDT', p_Value => p_maxsubdt, p_ParameterList => l_parameter_list_t);
610: wf_event.AddParameterToList (p_name => 'P_SUPRVSR',p_value=>p_suprvsr,p_parameterlist=>l_parameter_list_t);
611: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 608: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);

604: --
605:
606: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
607: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
608: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
609: wf_event.AddParameterToList (p_name => 'P_MAXSUBDT', p_Value => p_maxsubdt, p_ParameterList => l_parameter_list_t);
610: wf_event.AddParameterToList (p_name => 'P_SUPRVSR',p_value=>p_suprvsr,p_parameterlist=>l_parameter_list_t);
611: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
612:

Line 609: wf_event.AddParameterToList (p_name => 'P_MAXSUBDT', p_Value => p_maxsubdt, p_ParameterList => l_parameter_list_t);

605:
606: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
607: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
608: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
609: wf_event.AddParameterToList (p_name => 'P_MAXSUBDT', p_Value => p_maxsubdt, p_ParameterList => l_parameter_list_t);
610: wf_event.AddParameterToList (p_name => 'P_SUPRVSR',p_value=>p_suprvsr,p_parameterlist=>l_parameter_list_t);
611: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
612:
613:

Line 610: wf_event.AddParameterToList (p_name => 'P_SUPRVSR',p_value=>p_suprvsr,p_parameterlist=>l_parameter_list_t);

606: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
607: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
608: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
609: wf_event.AddParameterToList (p_name => 'P_MAXSUBDT', p_Value => p_maxsubdt, p_ParameterList => l_parameter_list_t);
610: wf_event.AddParameterToList (p_name => 'P_SUPRVSR',p_value=>p_suprvsr,p_parameterlist=>l_parameter_list_t);
611: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
612:
613:
614: -- Raise the Event

Line 611: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

607: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
608: wf_event.AddParameterToList (p_name => 'P_THESISTITLE', p_Value => p_thesistitle, p_ParameterList => l_parameter_list_t);
609: wf_event.AddParameterToList (p_name => 'P_MAXSUBDT', p_Value => p_maxsubdt, p_ParameterList => l_parameter_list_t);
610: wf_event.AddParameterToList (p_name => 'P_SUPRVSR',p_value=>p_suprvsr,p_parameterlist=>l_parameter_list_t);
611: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
612:
613:
614: -- Raise the Event
615:

Line 617: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.subm.overdue',

613:
614: -- Raise the Event
615:
616:
617: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.subm.overdue',
618: p_event_key => 'SUBMOVERDUE'||ln_seq_val,
619: p_parameters => l_parameter_list_t);
620:
621:

Line 1658: l_event_t wf_event_t;

1654: -- Change History:
1655: -- Who When What
1656: --
1657: -------------------------------------------------------------------------------------------------
1658: l_event_t wf_event_t;
1659: l_parameter_list_t wf_parameter_list_t;
1660: l_itemKey varchar2(100);
1661: ln_seq_val NUMBER;
1662: l_programcd igs_re_candidature.sca_course_cd%TYPE;

Line 1737: -- initialize the wf_event_t object

1733: FETCH cur_user_id INTO l_cur_user_id ;
1734: CLOSE cur_user_id ;
1735:
1736: --
1737: -- initialize the wf_event_t object
1738: --
1739:
1740: wf_event_t.Initialize(l_event_t);
1741:

Line 1740: wf_event_t.Initialize(l_event_t);

1736: --
1737: -- initialize the wf_event_t object
1738: --
1739:
1740: wf_event_t.Initialize(l_event_t);
1741:
1742:
1743:
1744:

Line 1776: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);

1772: --
1773: -- Adding the parameters to the parameter list
1774: --
1775:
1776: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1777: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1778: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);
1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);

Line 1777: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);

1773: -- Adding the parameters to the parameter list
1774: --
1775:
1776: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1777: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1778: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);
1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);
1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);

Line 1778: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);

1774: --
1775:
1776: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1777: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1778: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);
1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);
1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);
1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);

Line 1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);

1775:
1776: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1777: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1778: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);
1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);
1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);
1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);
1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);

Line 1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);

1776: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1777: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1778: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);
1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);
1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);
1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);
1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);
1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);

Line 1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);

1777: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1778: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);
1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);
1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);
1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);
1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);
1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);
1785: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);

Line 1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);

1778: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);
1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);
1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);
1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);
1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);
1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);
1785: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
1786: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

Line 1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);

1779: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => p_milestn_typ , p_ParameterList => l_parameter_list_t);
1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);
1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);
1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);
1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);
1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);
1785: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
1786: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1787: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);

1780: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => p_due_dt , p_ParameterList => l_parameter_list_t);
1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);
1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);
1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);
1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);
1785: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
1786: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1787: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
1788:

Line 1785: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);

1781: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => p_milestn_stat, p_ParameterList => l_parameter_list_t);
1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);
1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);
1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);
1785: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
1786: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1787: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
1788:
1789:

Line 1786: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

1782: wf_event.AddParameterToList (p_name => 'P_DT_REACHED', p_Value => p_dt_reached, p_ParameterList => l_parameter_list_t);
1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);
1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);
1785: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
1786: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1787: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
1788:
1789:
1790:

Line 1787: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

1783: wf_event.AddParameterToList (p_name => 'P_MILESTN_SRC', p_Value => l_source, p_ParameterList => l_parameter_list_t);
1784: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_ver.attendance_type, p_ParameterList => l_parameter_list_t);
1785: wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
1786: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1787: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
1788:
1789:
1790:
1791: -- Raise the Event

Line 1793: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.milestone.change',

1789:
1790:
1791: -- Raise the Event
1792:
1793: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.milestone.change',
1794: p_event_key => 'MILESTONEEVENT'||ln_seq_val,
1795: p_parameters => l_parameter_list_t);
1796:
1797:

Line 1835: l_event_t wf_event_t;

1831: -- Who When What
1832: --
1833: -------------------------------------------------------------------------------------------------
1834:
1835: l_event_t wf_event_t;
1836: l_parameter_list_t wf_parameter_list_t;
1837: l_itemKey varchar2(100);
1838: ln_seq_val NUMBER;
1839: l_programcd igs_re_candidature.sca_course_cd%TYPE;

Line 1902: -- initialize the wf_event_t object

1898: FETCH cur_user_id INTO l_cur_user_id ;
1899: CLOSE cur_user_id ;
1900:
1901: --
1902: -- initialize the wf_event_t object
1903: --
1904:
1905: wf_event_t.Initialize(l_event_t);
1906:

Line 1905: wf_event_t.Initialize(l_event_t);

1901: --
1902: -- initialize the wf_event_t object
1903: --
1904:
1905: wf_event_t.Initialize(l_event_t);
1906:
1907:
1908: OPEN c_research(p_personid,p_ca_sequence_number);
1909: FETCH c_research INTO l_programcd,l_res_topic;

Line 1940: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);

1936: --
1937: -- Adding the parameters to the parameter list
1938: --
1939:
1940: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1941: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1942: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);

Line 1941: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);

1937: -- Adding the parameters to the parameter list
1938: --
1939:
1940: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1941: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1942: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);

Line 1942: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);

1938: --
1939:
1940: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1941: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1942: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);

Line 1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);

1939:
1940: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1941: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1942: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);
1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);

Line 1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);

1940: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
1941: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1942: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);
1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
1948: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);

Line 1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);

1941: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
1942: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);
1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
1948: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
1949: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

Line 1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);

1942: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);
1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
1948: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
1949: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1950: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);

1943: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);
1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
1948: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
1949: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1950: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
1951:

Line 1948: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);

1944: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);
1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
1948: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
1949: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1950: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
1951:
1952:

Line 1949: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

1945: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);
1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
1948: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
1949: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1950: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
1951:
1952:
1953:

Line 1950: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

1946: wf_event.AddParameterToList (p_name => 'P_SPA_STAT', p_Value => l_cur_prog_stat.course_attempt_status, p_ParameterList => l_parameter_list_t);
1947: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
1948: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
1949: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
1950: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
1951:
1952:
1953:
1954: -- Raise the Event

Line 1956: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.examsub',

1952:
1953:
1954: -- Raise the Event
1955:
1956: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.examsub',
1957: p_event_key => 'THESISEXAMEVENT'||ln_seq_val,
1958: p_parameters => l_parameter_list_t);
1959:
1960: --

Line 1994: l_event_t wf_event_t;

1990: -- Who When What
1991: --
1992: -------------------------------------------------------------------------------------------------
1993:
1994: l_event_t wf_event_t;
1995: l_parameter_list_t wf_parameter_list_t;
1996: l_itemKey varchar2(100);
1997: ln_seq_val NUMBER;
1998: l_programcd igs_re_candidature.sca_course_cd%TYPE;

Line 2053: -- initialize the wf_event_t object

2049: FETCH cur_user_id INTO l_cur_user_id ;
2050: CLOSE cur_user_id ;
2051:
2052: --
2053: -- initialize the wf_event_t object
2054: --
2055:
2056: wf_event_t.Initialize(l_event_t);
2057:

Line 2056: wf_event_t.Initialize(l_event_t);

2052: --
2053: -- initialize the wf_event_t object
2054: --
2055:
2056: wf_event_t.Initialize(l_event_t);
2057:
2058:
2059: OPEN c_research(p_personid,p_ca_sequence_number);
2060: FETCH c_research INTO l_programcd,l_res_topic;

Line 2088: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);

2084: --
2085: -- Adding the parameters to the parameter list
2086: --
2087:
2088: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2089: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
2090: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);

Line 2089: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);

2085: -- Adding the parameters to the parameter list
2086: --
2087:
2088: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2089: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
2090: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);

Line 2090: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);

2086: --
2087:
2088: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2089: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
2090: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);

Line 2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);

2087:
2088: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2089: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
2090: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);
2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);

Line 2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);

2088: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2089: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
2090: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);
2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
2096: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);

Line 2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);

2089: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_programcd, p_ParameterList => l_parameter_list_t);
2090: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);
2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
2096: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
2097: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

Line 2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);

2090: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_res_topic, p_ParameterList => l_parameter_list_t);
2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);
2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
2096: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
2097: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2098: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);

2091: wf_event.AddParameterToList (p_name => 'P_THESIS_TPC', p_Value => l_the_topic , p_ParameterList => l_parameter_list_t);
2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);
2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
2096: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
2097: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2098: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2099:

Line 2096: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);

2092: wf_event.AddParameterToList (p_name => 'P_THESIS_TITLE', p_Value => l_title , p_ParameterList => l_parameter_list_t);
2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);
2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
2096: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
2097: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2098: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2099:
2100:

Line 2097: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

2093: wf_event.AddParameterToList (p_name => 'P_SUB_ON', p_Value => p_submission_dt, p_ParameterList => l_parameter_list_t);
2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);
2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
2096: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
2097: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2098: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2099:
2100:
2101: -- Raise the Event

Line 2098: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

2094: wf_event.AddParameterToList (p_name => 'P_THESIS_RSLT', p_Value => p_thesis_result_cd, p_ParameterList => l_parameter_list_t);
2095: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_TYP', p_Value => p_thesis_exam_type, p_ParameterList => l_parameter_list_t);
2096: wf_event.AddParameterToList (p_name => 'P_THESIS_EXM_PNL', p_Value => l_panel_member, p_ParameterList => l_parameter_list_t);
2097: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2098: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2099:
2100:
2101: -- Raise the Event
2102:

Line 2104: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.resultupd',

2100:
2101: -- Raise the Event
2102:
2103:
2104: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.resultupd',
2105: p_event_key => 'THESISRESULTEVENT'||ln_seq_val,
2106: p_parameters => l_parameter_list_t);
2107:
2108: --

Line 2140: l_event_t wf_event_t;

2136: -- Who When What
2137: --
2138: -------------------------------------------------------------------------------------------------
2139:
2140: l_event_t wf_event_t;
2141: l_parameter_list_t wf_parameter_list_t;
2142: l_itemKey varchar2(100);
2143: ln_seq_val NUMBER;
2144: l_programcd igs_re_candidature.sca_course_cd%TYPE;

Line 2208: -- initialize the wf_event_t object

2204: FETCH cur_user_id INTO l_cur_user_id ;
2205: CLOSE cur_user_id ;
2206:
2207: --
2208: -- initialize the wf_event_t object
2209: --
2210:
2211: wf_event_t.Initialize(l_event_t);
2212:

Line 2211: wf_event_t.Initialize(l_event_t);

2207: --
2208: -- initialize the wf_event_t object
2209: --
2210:
2211: wf_event_t.Initialize(l_event_t);
2212:
2213:
2214:
2215: OPEN cur_res_top(p_personid,p_programcd);

Line 2233: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);

2229: --
2230: -- Adding the parameters to the parameter list
2231: --
2232:
2233: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2234: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
2235: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_res_top.research_topic, p_ParameterList => l_parameter_list_t);
2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);
2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);

Line 2234: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);

2230: -- Adding the parameters to the parameter list
2231: --
2232:
2233: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2234: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
2235: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_res_top.research_topic, p_ParameterList => l_parameter_list_t);
2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);
2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);
2238: wf_event.AddParameterToList (p_name => 'P_PROGRAMSTAT', p_Value => p_prog_attempt_stat, p_ParameterList => l_parameter_list_t);

Line 2235: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_res_top.research_topic, p_ParameterList => l_parameter_list_t);

2231: --
2232:
2233: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2234: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
2235: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_res_top.research_topic, p_ParameterList => l_parameter_list_t);
2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);
2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);
2238: wf_event.AddParameterToList (p_name => 'P_PROGRAMSTAT', p_Value => p_prog_attempt_stat, p_ParameterList => l_parameter_list_t);
2239: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

Line 2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);

2232:
2233: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2234: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
2235: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_res_top.research_topic, p_ParameterList => l_parameter_list_t);
2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);
2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);
2238: wf_event.AddParameterToList (p_name => 'P_PROGRAMSTAT', p_Value => p_prog_attempt_stat, p_ParameterList => l_parameter_list_t);
2239: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2240: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);

2233: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
2234: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
2235: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_res_top.research_topic, p_ParameterList => l_parameter_list_t);
2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);
2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);
2238: wf_event.AddParameterToList (p_name => 'P_PROGRAMSTAT', p_Value => p_prog_attempt_stat, p_ParameterList => l_parameter_list_t);
2239: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2240: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2241:

Line 2238: wf_event.AddParameterToList (p_name => 'P_PROGRAMSTAT', p_Value => p_prog_attempt_stat, p_ParameterList => l_parameter_list_t);

2234: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
2235: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_res_top.research_topic, p_ParameterList => l_parameter_list_t);
2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);
2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);
2238: wf_event.AddParameterToList (p_name => 'P_PROGRAMSTAT', p_Value => p_prog_attempt_stat, p_ParameterList => l_parameter_list_t);
2239: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2240: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2241:
2242:

Line 2239: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

2235: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_res_top.research_topic, p_ParameterList => l_parameter_list_t);
2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);
2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);
2238: wf_event.AddParameterToList (p_name => 'P_PROGRAMSTAT', p_Value => p_prog_attempt_stat, p_ParameterList => l_parameter_list_t);
2239: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2240: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2241:
2242:
2243: -- Raise the Event

Line 2240: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

2236: wf_event.AddParameterToList (p_name => 'P_SPA_START_DT', p_Value => p_spa_start_dt , p_ParameterList => l_parameter_list_t);
2237: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYP', p_Value => l_cur_course_type.course_type, p_ParameterList => l_parameter_list_t);
2238: wf_event.AddParameterToList (p_name => 'P_PROGRAMSTAT', p_Value => p_prog_attempt_stat, p_ParameterList => l_parameter_list_t);
2239: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2240: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2241:
2242:
2243: -- Raise the Event
2244:

Line 2245: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.registration.confirm',

2241:
2242:
2243: -- Raise the Event
2244:
2245: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.registration.confirm',
2246: p_event_key => 'CONFIRMREGEVENT'||ln_seq_val,
2247: p_parameters => l_parameter_list_t);
2248:
2249: --

Line 2331: l_event_t wf_event_t;

2327: l_supervisor VARCHAR2(32000);
2328: l_cur_prof_value cur_prof_value%ROWTYPE;
2329: l_cur_user_id cur_user_id%ROWTYPE;
2330: ln_seq_val NUMBER;
2331: l_event_t wf_event_t;
2332: l_parameter_list_t wf_parameter_list_t;
2333: l_itemKey varchar2(100);
2334: l_flag NUMBER := 0;
2335:

Line 2374: -- initialize the wf_event_t object

2370: FOR l_cur_achived_milestone IN cur_achived_milestone(l_cur_prog_atmpt.person_id,l_cur_prog_atmpt.sequence_number) LOOP
2371:
2372:
2373: --
2374: -- initialize the wf_event_t object
2375: --
2376:
2377:
2378: wf_event_t.Initialize(l_event_t);

Line 2378: wf_event_t.Initialize(l_event_t);

2374: -- initialize the wf_event_t object
2375: --
2376:
2377:
2378: wf_event_t.Initialize(l_event_t);
2379:
2380: -- Get the sequence value
2381:
2382: OPEN c_seq_num;

Line 2420: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>l_cur_prog_atmpt.person_id,p_parameterlist=>l_parameter_list_t);

2416: --
2417: -- Adding the parameters to the parameter list
2418: --
2419:
2420: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>l_cur_prog_atmpt.person_id,p_parameterlist=>l_parameter_list_t);
2421: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_prog_atmpt.course_cd, p_ParameterList => l_parameter_list_t);
2422: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_prog_atmpt.research_topic, p_ParameterList => l_parameter_list_t);
2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);
2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);

Line 2421: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_prog_atmpt.course_cd, p_ParameterList => l_parameter_list_t);

2417: -- Adding the parameters to the parameter list
2418: --
2419:
2420: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>l_cur_prog_atmpt.person_id,p_parameterlist=>l_parameter_list_t);
2421: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_prog_atmpt.course_cd, p_ParameterList => l_parameter_list_t);
2422: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_prog_atmpt.research_topic, p_ParameterList => l_parameter_list_t);
2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);
2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);
2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);

Line 2422: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_prog_atmpt.research_topic, p_ParameterList => l_parameter_list_t);

2418: --
2419:
2420: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>l_cur_prog_atmpt.person_id,p_parameterlist=>l_parameter_list_t);
2421: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_prog_atmpt.course_cd, p_ParameterList => l_parameter_list_t);
2422: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_prog_atmpt.research_topic, p_ParameterList => l_parameter_list_t);
2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);
2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);
2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);
2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);

Line 2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);

2419:
2420: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>l_cur_prog_atmpt.person_id,p_parameterlist=>l_parameter_list_t);
2421: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_prog_atmpt.course_cd, p_ParameterList => l_parameter_list_t);
2422: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_prog_atmpt.research_topic, p_ParameterList => l_parameter_list_t);
2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);
2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);
2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);
2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);
2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);

Line 2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);

2420: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>l_cur_prog_atmpt.person_id,p_parameterlist=>l_parameter_list_t);
2421: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_prog_atmpt.course_cd, p_ParameterList => l_parameter_list_t);
2422: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_prog_atmpt.research_topic, p_ParameterList => l_parameter_list_t);
2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);
2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);
2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);
2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);
2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);
2428: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_atmpt.attendance_type, p_ParameterList => l_parameter_list_t);

Line 2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);

2421: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => l_cur_prog_atmpt.course_cd, p_ParameterList => l_parameter_list_t);
2422: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_prog_atmpt.research_topic, p_ParameterList => l_parameter_list_t);
2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);
2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);
2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);
2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);
2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);
2428: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_atmpt.attendance_type, p_ParameterList => l_parameter_list_t);
2429: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

Line 2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);

2422: wf_event.AddParameterToList (p_name => 'P_RESTOPIC', p_Value => l_cur_prog_atmpt.research_topic, p_ParameterList => l_parameter_list_t);
2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);
2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);
2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);
2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);
2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);
2428: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_atmpt.attendance_type, p_ParameterList => l_parameter_list_t);
2429: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2430: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);

2423: wf_event.AddParameterToList (p_name => 'P_MILESTN_TYP', p_Value => l_cur_achived_milestone.milestone_type , p_ParameterList => l_parameter_list_t);
2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);
2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);
2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);
2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);
2428: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_atmpt.attendance_type, p_ParameterList => l_parameter_list_t);
2429: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2430: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2431:

Line 2428: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_atmpt.attendance_type, p_ParameterList => l_parameter_list_t);

2424: wf_event.AddParameterToList (p_name => 'P_DUEDT', p_Value => l_cur_achived_milestone.due_dt , p_ParameterList => l_parameter_list_t);
2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);
2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);
2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);
2428: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_atmpt.attendance_type, p_ParameterList => l_parameter_list_t);
2429: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2430: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2431:
2432:

Line 2429: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);

2425: wf_event.AddParameterToList (p_name => 'P_MILESTN_STAT', p_Value => l_cur_achived_milestone.milestone_status, p_ParameterList => l_parameter_list_t);
2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);
2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);
2428: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_atmpt.attendance_type, p_ParameterList => l_parameter_list_t);
2429: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2430: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2431:
2432:
2433:

Line 2430: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

2426: wf_event.AddParameterToList (p_name => 'P_NOTIFY_DAYS', p_Value => l_notifydays, p_ParameterList => l_parameter_list_t);
2427: wf_event.AddParameterToList (p_name => 'P_NOTIFYTYPE', p_Value => l_notifytype, p_ParameterList => l_parameter_list_t);
2428: wf_event.AddParameterToList (p_name => 'P_NOMI_ATT_TYP', p_Value => l_cur_prog_atmpt.attendance_type, p_ParameterList => l_parameter_list_t);
2429: wf_event.AddParameterToList (p_name => 'P_SUPERVISOR', p_Value => l_supervisor, p_ParameterList => l_parameter_list_t);
2430: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
2431:
2432:
2433:
2434: -- Raise the Event

Line 2436: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.milestone.notify' ,

2432:
2433:
2434: -- Raise the Event
2435:
2436: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.milestone.notify' ,
2437: p_event_key => 'MILSTNNOTIFYPRCS'||ln_seq_val,
2438: p_parameters => l_parameter_list_t);
2439:
2440: --