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

APPS.IGS_AS_NOTIFY_STUDENT dependencies on WF_EVENT

Line 22: l_event_t wf_event_t;

18: Who When What
19: ******************************************************************/
20:
21:
22: l_event_t wf_event_t;
23: l_parameter_list_t wf_parameter_list_t;
24: l_itemKey varchar2(100);
25: ln_seq_val NUMBER;
26:

Line 49: -- initialize the wf_event_t object

45: CLOSE c_seq_num ;
46:
47:
48: --
49: -- initialize the wf_event_t object
50: --
51:
52: wf_event_t.Initialize(l_event_t);
53:

Line 52: wf_event_t.Initialize(l_event_t);

48: --
49: -- initialize the wf_event_t object
50: --
51:
52: wf_event_t.Initialize(l_event_t);
53:
54:
55:
56: --

Line 61: wf_event.AddParameterToList (p_name=>'IA_NAME',p_value=>p_name,p_parameterlist=>l_parameter_list_t);

57: -- Adding the parameters to the parameter list
58: --
59:
60:
61: wf_event.AddParameterToList (p_name=>'IA_NAME',p_value=>p_name,p_parameterlist=>l_parameter_list_t);
62: wf_event.AddParameterToList ( p_Name => 'IA_USERS', p_Value => p_users, p_ParameterList => l_parameter_list_t);
63: wf_event.AddParameterToList ( p_Name => 'IA_SUBJECT', p_Value => p_subject, p_ParameterList => l_parameter_list_t);
64: wf_event.AddParameterToList ( p_Name => 'IA_MESSAGE', p_Value => p_message, p_ParameterList => l_parameter_list_t);
65:

Line 62: wf_event.AddParameterToList ( p_Name => 'IA_USERS', p_Value => p_users, p_ParameterList => l_parameter_list_t);

58: --
59:
60:
61: wf_event.AddParameterToList (p_name=>'IA_NAME',p_value=>p_name,p_parameterlist=>l_parameter_list_t);
62: wf_event.AddParameterToList ( p_Name => 'IA_USERS', p_Value => p_users, p_ParameterList => l_parameter_list_t);
63: wf_event.AddParameterToList ( p_Name => 'IA_SUBJECT', p_Value => p_subject, p_ParameterList => l_parameter_list_t);
64: wf_event.AddParameterToList ( p_Name => 'IA_MESSAGE', p_Value => p_message, p_ParameterList => l_parameter_list_t);
65:
66:

Line 63: wf_event.AddParameterToList ( p_Name => 'IA_SUBJECT', p_Value => p_subject, p_ParameterList => l_parameter_list_t);

59:
60:
61: wf_event.AddParameterToList (p_name=>'IA_NAME',p_value=>p_name,p_parameterlist=>l_parameter_list_t);
62: wf_event.AddParameterToList ( p_Name => 'IA_USERS', p_Value => p_users, p_ParameterList => l_parameter_list_t);
63: wf_event.AddParameterToList ( p_Name => 'IA_SUBJECT', p_Value => p_subject, p_ParameterList => l_parameter_list_t);
64: wf_event.AddParameterToList ( p_Name => 'IA_MESSAGE', p_Value => p_message, p_ParameterList => l_parameter_list_t);
65:
66:
67: -- Raise the Event

Line 64: wf_event.AddParameterToList ( p_Name => 'IA_MESSAGE', p_Value => p_message, p_ParameterList => l_parameter_list_t);

60:
61: wf_event.AddParameterToList (p_name=>'IA_NAME',p_value=>p_name,p_parameterlist=>l_parameter_list_t);
62: wf_event.AddParameterToList ( p_Name => 'IA_USERS', p_Value => p_users, p_ParameterList => l_parameter_list_t);
63: wf_event.AddParameterToList ( p_Name => 'IA_SUBJECT', p_Value => p_subject, p_ParameterList => l_parameter_list_t);
64: wf_event.AddParameterToList ( p_Name => 'IA_MESSAGE', p_Value => p_message, p_ParameterList => l_parameter_list_t);
65:
66:
67: -- Raise the Event
68:

Line 71: WF_EVENT.RAISE (p_event_name => p_busEvent,

67: -- Raise the Event
68:
69:
70:
71: WF_EVENT.RAISE (p_event_name => p_busEvent,
72: p_event_key => 'AS006'||ln_seq_val,
73: p_parameters => l_parameter_list_t);
74:
75:

Line 304: l_event_t wf_event_t;

300:
301: (reverse chronological order - newest change first)
302: ***************************************************************/
303:
304: l_event_t wf_event_t;
305: l_parameter_list_t wf_parameter_list_t;
306: l_itemKey varchar2(100);
307: ln_seq_val NUMBER;
308:

Line 365: -- initialize the wf_event_t object

361: FETCH c_user_name INTO l_c_user_name;
362: CLOSE c_user_name ;
363:
364: --
365: -- initialize the wf_event_t object
366: --
367:
368: wf_event_t.Initialize(l_event_t);
369:

Line 368: wf_event_t.Initialize(l_event_t);

364: --
365: -- initialize the wf_event_t object
366: --
367:
368: wf_event_t.Initialize(l_event_t);
369:
370:
371: --
372: -- Adding the parameters to the parameter list

Line 375: wf_event.AddParameterToList (p_name => 'P_UNIT_CD',p_value=>p_unit_cd,p_parameterlist=>l_parameter_list_t);

371: --
372: -- Adding the parameters to the parameter list
373: --
374:
375: wf_event.AddParameterToList (p_name => 'P_UNIT_CD',p_value=>p_unit_cd,p_parameterlist=>l_parameter_list_t);
376: wf_event.AddParameterToList (p_name => 'P_TERM', p_Value => p_term, p_ParameterList => l_parameter_list_t);
377: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);

Line 376: wf_event.AddParameterToList (p_name => 'P_TERM', p_Value => p_term, p_ParameterList => l_parameter_list_t);

372: -- Adding the parameters to the parameter list
373: --
374:
375: wf_event.AddParameterToList (p_name => 'P_UNIT_CD',p_value=>p_unit_cd,p_parameterlist=>l_parameter_list_t);
376: wf_event.AddParameterToList (p_name => 'P_TERM', p_Value => p_term, p_ParameterList => l_parameter_list_t);
377: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);
380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);

Line 377: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);

373: --
374:
375: wf_event.AddParameterToList (p_name => 'P_UNIT_CD',p_value=>p_unit_cd,p_parameterlist=>l_parameter_list_t);
376: wf_event.AddParameterToList (p_name => 'P_TERM', p_Value => p_term, p_ParameterList => l_parameter_list_t);
377: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);
380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);

Line 378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);

374:
375: wf_event.AddParameterToList (p_name => 'P_UNIT_CD',p_value=>p_unit_cd,p_parameterlist=>l_parameter_list_t);
376: wf_event.AddParameterToList (p_name => 'P_TERM', p_Value => p_term, p_ParameterList => l_parameter_list_t);
377: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);
380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);

Line 379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);

375: wf_event.AddParameterToList (p_name => 'P_UNIT_CD',p_value=>p_unit_cd,p_parameterlist=>l_parameter_list_t);
376: wf_event.AddParameterToList (p_name => 'P_TERM', p_Value => p_term, p_ParameterList => l_parameter_list_t);
377: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);
380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);
383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);

Line 380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);

376: wf_event.AddParameterToList (p_name => 'P_TERM', p_Value => p_term, p_ParameterList => l_parameter_list_t);
377: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);
380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);
383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
384: wf_event.AddParameterToList (p_name => 'P_REFERENCE', p_Value => p_reference, p_ParameterList => l_parameter_list_t);

Line 381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);

377: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);
380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);
383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
384: wf_event.AddParameterToList (p_name => 'P_REFERENCE', p_Value => p_reference, p_ParameterList => l_parameter_list_t);
385: wf_event.AddParameterToList (p_name => 'IA_FROM_ROLE',p_value=>l_c_user_name,p_parameterlist=>l_parameter_list_t);

Line 382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);

378: wf_event.AddParameterToList (p_name => 'P_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);
380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);
383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
384: wf_event.AddParameterToList (p_name => 'P_REFERENCE', p_Value => p_reference, p_ParameterList => l_parameter_list_t);
385: wf_event.AddParameterToList (p_name => 'IA_FROM_ROLE',p_value=>l_c_user_name,p_parameterlist=>l_parameter_list_t);
386: wf_event.AddParameterToList (p_name => 'IA_USER_ROLE', p_Value => l_c_user_name, p_ParameterList => l_parameter_list_t);

Line 383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);

379: wf_event.AddParameterToList (p_name => 'P_TEACHING_CAL', p_Value => p_teaching_cal, p_ParameterList => l_parameter_list_t);
380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);
383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
384: wf_event.AddParameterToList (p_name => 'P_REFERENCE', p_Value => p_reference, p_ParameterList => l_parameter_list_t);
385: wf_event.AddParameterToList (p_name => 'IA_FROM_ROLE',p_value=>l_c_user_name,p_parameterlist=>l_parameter_list_t);
386: wf_event.AddParameterToList (p_name => 'IA_USER_ROLE', p_Value => l_c_user_name, p_ParameterList => l_parameter_list_t);
387:

Line 384: wf_event.AddParameterToList (p_name => 'P_REFERENCE', p_Value => p_reference, p_ParameterList => l_parameter_list_t);

380: wf_event.AddParameterToList (p_name => 'P_SEC_NUMBER',p_value=>p_sec_number,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);
383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
384: wf_event.AddParameterToList (p_name => 'P_REFERENCE', p_Value => p_reference, p_ParameterList => l_parameter_list_t);
385: wf_event.AddParameterToList (p_name => 'IA_FROM_ROLE',p_value=>l_c_user_name,p_parameterlist=>l_parameter_list_t);
386: wf_event.AddParameterToList (p_name => 'IA_USER_ROLE', p_Value => l_c_user_name, p_ParameterList => l_parameter_list_t);
387:
388:

Line 385: wf_event.AddParameterToList (p_name => 'IA_FROM_ROLE',p_value=>l_c_user_name,p_parameterlist=>l_parameter_list_t);

381: wf_event.AddParameterToList (p_name => 'P_INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);
383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
384: wf_event.AddParameterToList (p_name => 'P_REFERENCE', p_Value => p_reference, p_ParameterList => l_parameter_list_t);
385: wf_event.AddParameterToList (p_name => 'IA_FROM_ROLE',p_value=>l_c_user_name,p_parameterlist=>l_parameter_list_t);
386: wf_event.AddParameterToList (p_name => 'IA_USER_ROLE', p_Value => l_c_user_name, p_ParameterList => l_parameter_list_t);
387:
388:
389: IF (p_event = 'RELDATE') THEN

Line 386: wf_event.AddParameterToList (p_name => 'IA_USER_ROLE', p_Value => l_c_user_name, p_ParameterList => l_parameter_list_t);

382: wf_event.AddParameterToList (p_name => 'P_ASS_ID', p_Value => p_ass_type, p_ParameterList => l_parameter_list_t);
383: wf_event.AddParameterToList (p_name => 'P_ASS_TYPE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
384: wf_event.AddParameterToList (p_name => 'P_REFERENCE', p_Value => p_reference, p_ParameterList => l_parameter_list_t);
385: wf_event.AddParameterToList (p_name => 'IA_FROM_ROLE',p_value=>l_c_user_name,p_parameterlist=>l_parameter_list_t);
386: wf_event.AddParameterToList (p_name => 'IA_USER_ROLE', p_Value => l_c_user_name, p_ParameterList => l_parameter_list_t);
387:
388:
389: IF (p_event = 'RELDATE') THEN
390:

Line 391: wf_event.AddParameterToList (p_name => 'P_RELEASE_DT', p_Value => p_rel_sub_dt, p_ParameterList => l_parameter_list_t);

387:
388:
389: IF (p_event = 'RELDATE') THEN
390:
391: wf_event.AddParameterToList (p_name => 'P_RELEASE_DT', p_Value => p_rel_sub_dt, p_ParameterList => l_parameter_list_t);
392:
393:
394: -- Raise the Release Grade Business Event
395:

Line 396: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.aigrdrel',

392:
393:
394: -- Raise the Release Grade Business Event
395:
396: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.aigrdrel',
397: p_event_key => 'IGSAS010'||ln_seq_val,
398: p_parameters => l_parameter_list_t);
399:
400:

Line 404: wf_event.AddParameterToList (p_name => 'P_SUB_DT', p_Value => p_rel_sub_dt, p_ParameterList => l_parameter_list_t);

400:
401:
402: ELSIF (p_event = 'SUBDATE') THEN
403:
404: wf_event.AddParameterToList (p_name => 'P_SUB_DT', p_Value => p_rel_sub_dt, p_ParameterList => l_parameter_list_t);
405: wf_event.AddParameterToList (p_name => 'P_GRADING_PERIOD', p_Value => p_grading_period, p_ParameterList => l_parameter_list_t);
406:
407: -- Raise the Submit Grade Business Event
408:

Line 405: wf_event.AddParameterToList (p_name => 'P_GRADING_PERIOD', p_Value => p_grading_period, p_ParameterList => l_parameter_list_t);

401:
402: ELSIF (p_event = 'SUBDATE') THEN
403:
404: wf_event.AddParameterToList (p_name => 'P_SUB_DT', p_Value => p_rel_sub_dt, p_ParameterList => l_parameter_list_t);
405: wf_event.AddParameterToList (p_name => 'P_GRADING_PERIOD', p_Value => p_grading_period, p_ParameterList => l_parameter_list_t);
406:
407: -- Raise the Submit Grade Business Event
408:
409: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.usgrdsub',

Line 409: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.usgrdsub',

405: wf_event.AddParameterToList (p_name => 'P_GRADING_PERIOD', p_Value => p_grading_period, p_ParameterList => l_parameter_list_t);
406:
407: -- Raise the Submit Grade Business Event
408:
409: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.usgrdsub',
410: p_event_key => 'IGSAS011'||ln_seq_val,
411: p_parameters => l_parameter_list_t);
412:
413: END IF;