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

APPS.IGS_EN_WORKFLOW dependencies on WF_EVENT

Line 13: --kkillams 10-03-2003 Replaced wf_event_t.AddParameterToList with wf_event.AddParameterToList api

9: Change History
10: Who When What
11: ddey 30th April,2003 Bug # 2829275 The new procedures are added as a part of UK Correspondence - Part -1 FD
12: vchappid 25-Jul-01 Two new procedures are added
13: --kkillams 10-03-2003 Replaced wf_event_t.AddParameterToList with wf_event.AddParameterToList api
14: -- to show params in the workflow out queue and able to derive the parameters
15: from the outside after event is raised, w.r.t. bug 2840171
16: knaraset 18-Nov-2003 Added procedure student_placement_event, for placement build
17: stutta 14-Apr-2005 Replaced all references to FND_USER.customer_id to

Line 62: wf_event.AddParameterToList(p_name=>'STUDENT_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);

58: FETCH cur_seq_val INTO l_cur_seq_val;
59: CLOSE cur_seq_val;
60:
61: -- set the event parameters
62: wf_event.AddParameterToList(p_name=>'STUDENT_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);
63: wf_event.AddParameterToList(p_name=>'UOO_ID', p_value=>p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
64: wf_event.AddParameterToList(p_name=>'UNIT_STATUS',p_value=>p_unit_status,p_parameterlist=>l_wf_parameter_list_t);
65:
66: -- raise the event

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

59: CLOSE cur_seq_val;
60:
61: -- set the event parameters
62: wf_event.AddParameterToList(p_name=>'STUDENT_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);
63: wf_event.AddParameterToList(p_name=>'UOO_ID', p_value=>p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
64: wf_event.AddParameterToList(p_name=>'UNIT_STATUS',p_value=>p_unit_status,p_parameterlist=>l_wf_parameter_list_t);
65:
66: -- raise the event
67: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.enrp.statmail',

Line 64: wf_event.AddParameterToList(p_name=>'UNIT_STATUS',p_value=>p_unit_status,p_parameterlist=>l_wf_parameter_list_t);

60:
61: -- set the event parameters
62: wf_event.AddParameterToList(p_name=>'STUDENT_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);
63: wf_event.AddParameterToList(p_name=>'UOO_ID', p_value=>p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
64: wf_event.AddParameterToList(p_name=>'UNIT_STATUS',p_value=>p_unit_status,p_parameterlist=>l_wf_parameter_list_t);
65:
66: -- raise the event
67: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.enrp.statmail',
68: p_event_key =>'oracle.apps.igs.en.enrp.statmail'||l_cur_seq_val.seq_val,

Line 67: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.enrp.statmail',

63: wf_event.AddParameterToList(p_name=>'UOO_ID', p_value=>p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
64: wf_event.AddParameterToList(p_name=>'UNIT_STATUS',p_value=>p_unit_status,p_parameterlist=>l_wf_parameter_list_t);
65:
66: -- raise the event
67: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.enrp.statmail',
68: p_event_key =>'oracle.apps.igs.en.enrp.statmail'||l_cur_seq_val.seq_val,
69: p_parameters=>l_wf_parameter_list_t);
70: END IF;
71:

Line 120: wf_event.AddParameterToList(p_name=> 'STUDENT_ID', p_value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);

116: FETCH cur_seq_val INTO l_cur_seq_val;
117: CLOSE cur_seq_val;
118:
119: -- set the event parameters
120: wf_event.AddParameterToList(p_name=> 'STUDENT_ID', p_value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
121: wf_event.AddParameterToList(p_name => 'INSTRUCTOR_ID', p_value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
122: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
123: wf_event.AddParameterToList(p_name => 'APPROVAL_STATUS', p_value => p_approval_status,p_parameterlist=>l_wf_parameter_list_t);
124: wf_event.AddParameterToList(p_name => 'DATE_SUBMISSION', p_value => p_date_submission,p_parameterlist=>l_wf_parameter_list_t);

Line 121: wf_event.AddParameterToList(p_name => 'INSTRUCTOR_ID', p_value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);

117: CLOSE cur_seq_val;
118:
119: -- set the event parameters
120: wf_event.AddParameterToList(p_name=> 'STUDENT_ID', p_value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
121: wf_event.AddParameterToList(p_name => 'INSTRUCTOR_ID', p_value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
122: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
123: wf_event.AddParameterToList(p_name => 'APPROVAL_STATUS', p_value => p_approval_status,p_parameterlist=>l_wf_parameter_list_t);
124: wf_event.AddParameterToList(p_name => 'DATE_SUBMISSION', p_value => p_date_submission,p_parameterlist=>l_wf_parameter_list_t);
125: wf_event.AddParameterToList(p_name => 'REQUEST_TYPE', p_value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);

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

118:
119: -- set the event parameters
120: wf_event.AddParameterToList(p_name=> 'STUDENT_ID', p_value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
121: wf_event.AddParameterToList(p_name => 'INSTRUCTOR_ID', p_value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
122: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
123: wf_event.AddParameterToList(p_name => 'APPROVAL_STATUS', p_value => p_approval_status,p_parameterlist=>l_wf_parameter_list_t);
124: wf_event.AddParameterToList(p_name => 'DATE_SUBMISSION', p_value => p_date_submission,p_parameterlist=>l_wf_parameter_list_t);
125: wf_event.AddParameterToList(p_name => 'REQUEST_TYPE', p_value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
126:

Line 123: wf_event.AddParameterToList(p_name => 'APPROVAL_STATUS', p_value => p_approval_status,p_parameterlist=>l_wf_parameter_list_t);

119: -- set the event parameters
120: wf_event.AddParameterToList(p_name=> 'STUDENT_ID', p_value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
121: wf_event.AddParameterToList(p_name => 'INSTRUCTOR_ID', p_value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
122: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
123: wf_event.AddParameterToList(p_name => 'APPROVAL_STATUS', p_value => p_approval_status,p_parameterlist=>l_wf_parameter_list_t);
124: wf_event.AddParameterToList(p_name => 'DATE_SUBMISSION', p_value => p_date_submission,p_parameterlist=>l_wf_parameter_list_t);
125: wf_event.AddParameterToList(p_name => 'REQUEST_TYPE', p_value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
126:
127:

Line 124: wf_event.AddParameterToList(p_name => 'DATE_SUBMISSION', p_value => p_date_submission,p_parameterlist=>l_wf_parameter_list_t);

120: wf_event.AddParameterToList(p_name=> 'STUDENT_ID', p_value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
121: wf_event.AddParameterToList(p_name => 'INSTRUCTOR_ID', p_value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
122: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
123: wf_event.AddParameterToList(p_name => 'APPROVAL_STATUS', p_value => p_approval_status,p_parameterlist=>l_wf_parameter_list_t);
124: wf_event.AddParameterToList(p_name => 'DATE_SUBMISSION', p_value => p_date_submission,p_parameterlist=>l_wf_parameter_list_t);
125: wf_event.AddParameterToList(p_name => 'REQUEST_TYPE', p_value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
126:
127:
128: -- raise the event

Line 125: wf_event.AddParameterToList(p_name => 'REQUEST_TYPE', p_value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);

121: wf_event.AddParameterToList(p_name => 'INSTRUCTOR_ID', p_value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
122: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
123: wf_event.AddParameterToList(p_name => 'APPROVAL_STATUS', p_value => p_approval_status,p_parameterlist=>l_wf_parameter_list_t);
124: wf_event.AddParameterToList(p_name => 'DATE_SUBMISSION', p_value => p_date_submission,p_parameterlist=>l_wf_parameter_list_t);
125: wf_event.AddParameterToList(p_name => 'REQUEST_TYPE', p_value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
126:
127:
128: -- raise the event
129: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.enrp.instresp',

Line 129: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.enrp.instresp',

125: wf_event.AddParameterToList(p_name => 'REQUEST_TYPE', p_value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
126:
127:
128: -- raise the event
129: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.enrp.instresp',
130: p_event_key =>'oracle.apps.igs.en.enrp.instresp'||l_cur_seq_val.seq_val,
131: p_parameters=>l_wf_parameter_list_t);
132: END IF;
133:

Line 177: wf_event.AddParameterToList ( p_Name => 'STUDENT_ID', p_Value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);

173: OPEN cur_seq_val;
174: FETCH cur_seq_val INTO l_cur_seq_val;
175: CLOSE cur_seq_val;
176:
177: wf_event.AddParameterToList ( p_Name => 'STUDENT_ID', p_Value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
178: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR_ID', p_Value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
179: wf_event.AddParameterToList ( p_Name => 'UOO_ID', p_Value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
180: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMISSION', p_Value => p_date_submission, p_parameterlist=>l_wf_parameter_list_t);
181: wf_event.AddParameterToList ( p_Name => 'TRANSACTION_TYPE',p_Value => p_transaction_type, p_parameterlist=>l_wf_parameter_list_t);

Line 178: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR_ID', p_Value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);

174: FETCH cur_seq_val INTO l_cur_seq_val;
175: CLOSE cur_seq_val;
176:
177: wf_event.AddParameterToList ( p_Name => 'STUDENT_ID', p_Value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
178: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR_ID', p_Value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
179: wf_event.AddParameterToList ( p_Name => 'UOO_ID', p_Value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
180: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMISSION', p_Value => p_date_submission, p_parameterlist=>l_wf_parameter_list_t);
181: wf_event.AddParameterToList ( p_Name => 'TRANSACTION_TYPE',p_Value => p_transaction_type, p_parameterlist=>l_wf_parameter_list_t);
182: wf_event.AddParameterToList ( p_Name => 'REQUEST_TYPE', p_Value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);

Line 179: wf_event.AddParameterToList ( p_Name => 'UOO_ID', p_Value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);

175: CLOSE cur_seq_val;
176:
177: wf_event.AddParameterToList ( p_Name => 'STUDENT_ID', p_Value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
178: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR_ID', p_Value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
179: wf_event.AddParameterToList ( p_Name => 'UOO_ID', p_Value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
180: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMISSION', p_Value => p_date_submission, p_parameterlist=>l_wf_parameter_list_t);
181: wf_event.AddParameterToList ( p_Name => 'TRANSACTION_TYPE',p_Value => p_transaction_type, p_parameterlist=>l_wf_parameter_list_t);
182: wf_event.AddParameterToList ( p_Name => 'REQUEST_TYPE', p_Value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
183:

Line 180: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMISSION', p_Value => p_date_submission, p_parameterlist=>l_wf_parameter_list_t);

176:
177: wf_event.AddParameterToList ( p_Name => 'STUDENT_ID', p_Value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
178: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR_ID', p_Value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
179: wf_event.AddParameterToList ( p_Name => 'UOO_ID', p_Value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
180: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMISSION', p_Value => p_date_submission, p_parameterlist=>l_wf_parameter_list_t);
181: wf_event.AddParameterToList ( p_Name => 'TRANSACTION_TYPE',p_Value => p_transaction_type, p_parameterlist=>l_wf_parameter_list_t);
182: wf_event.AddParameterToList ( p_Name => 'REQUEST_TYPE', p_Value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
183:
184: -- raise the event

Line 181: wf_event.AddParameterToList ( p_Name => 'TRANSACTION_TYPE',p_Value => p_transaction_type, p_parameterlist=>l_wf_parameter_list_t);

177: wf_event.AddParameterToList ( p_Name => 'STUDENT_ID', p_Value => p_student_id, p_parameterlist=>l_wf_parameter_list_t);
178: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR_ID', p_Value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
179: wf_event.AddParameterToList ( p_Name => 'UOO_ID', p_Value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
180: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMISSION', p_Value => p_date_submission, p_parameterlist=>l_wf_parameter_list_t);
181: wf_event.AddParameterToList ( p_Name => 'TRANSACTION_TYPE',p_Value => p_transaction_type, p_parameterlist=>l_wf_parameter_list_t);
182: wf_event.AddParameterToList ( p_Name => 'REQUEST_TYPE', p_Value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
183:
184: -- raise the event
185: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.enrp.studreq',

Line 182: wf_event.AddParameterToList ( p_Name => 'REQUEST_TYPE', p_Value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);

178: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR_ID', p_Value => p_instructor_id, p_parameterlist=>l_wf_parameter_list_t);
179: wf_event.AddParameterToList ( p_Name => 'UOO_ID', p_Value => p_uoo_id, p_parameterlist=>l_wf_parameter_list_t);
180: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMISSION', p_Value => p_date_submission, p_parameterlist=>l_wf_parameter_list_t);
181: wf_event.AddParameterToList ( p_Name => 'TRANSACTION_TYPE',p_Value => p_transaction_type, p_parameterlist=>l_wf_parameter_list_t);
182: wf_event.AddParameterToList ( p_Name => 'REQUEST_TYPE', p_Value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
183:
184: -- raise the event
185: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.enrp.studreq',
186: p_event_key => 'oracle.apps.igs.en.enrp.studreq'||l_cur_seq_val.seq_val,

Line 185: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.enrp.studreq',

181: wf_event.AddParameterToList ( p_Name => 'TRANSACTION_TYPE',p_Value => p_transaction_type, p_parameterlist=>l_wf_parameter_list_t);
182: wf_event.AddParameterToList ( p_Name => 'REQUEST_TYPE', p_Value => p_request_type, p_parameterlist=>l_wf_parameter_list_t);
183:
184: -- raise the event
185: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.enrp.studreq',
186: p_event_key => 'oracle.apps.igs.en.enrp.studreq'||l_cur_seq_val.seq_val,
187: p_parameters => l_wf_parameter_list_t);
188: END IF;
189: END inform_instruct_stdnt_petition;

Line 219: l_event_t wf_event_t;

215: -- Change History:
216: -- Who When What
217: --
218: -------------------------------------------------------------------------------------------------
219: l_event_t wf_event_t;
220: l_parameter_list_t wf_parameter_list_t;
221: l_itemKey varchar2(100);
222: ln_seq_val NUMBER;
223:

Line 294: -- initialize the wf_event_t object

290: FETCH cur_int_type INTO l_cur_int_type;
291: CLOSE cur_int_type;
292:
293: --
294: -- initialize the wf_event_t object
295: --
296:
297: wf_event_t.Initialize(l_event_t);
298:

Line 297: wf_event_t.Initialize(l_event_t);

293: --
294: -- initialize the wf_event_t object
295: --
296:
297: wf_event_t.Initialize(l_event_t);
298:
299:
300: --
301: -- Adding the parameters to the parameter list

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

300: --
301: -- Adding the parameters to the parameter list
302: --
303:
304: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
305: wf_event.AddParameterToList (p_name => 'P_PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
306: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYPE', p_Value => l_cur_prog_type.course_type, p_ParameterList => l_parameter_list_t);
307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);
308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);

Line 305: wf_event.AddParameterToList (p_name => 'P_PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);

301: -- Adding the parameters to the parameter list
302: --
303:
304: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
305: wf_event.AddParameterToList (p_name => 'P_PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
306: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYPE', p_Value => l_cur_prog_type.course_type, p_ParameterList => l_parameter_list_t);
307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);
308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);

Line 306: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYPE', p_Value => l_cur_prog_type.course_type, p_ParameterList => l_parameter_list_t);

302: --
303:
304: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
305: wf_event.AddParameterToList (p_name => 'P_PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
306: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYPE', p_Value => l_cur_prog_type.course_type, p_ParameterList => l_parameter_list_t);
307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);
308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);

Line 307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);

303:
304: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
305: wf_event.AddParameterToList (p_name => 'P_PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
306: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYPE', p_Value => l_cur_prog_type.course_type, p_ParameterList => l_parameter_list_t);
307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);
308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);

Line 308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);

304: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
305: wf_event.AddParameterToList (p_name => 'P_PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
306: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYPE', p_Value => l_cur_prog_type.course_type, p_ParameterList => l_parameter_list_t);
307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);
308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);

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

305: wf_event.AddParameterToList (p_name => 'P_PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
306: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYPE', p_Value => l_cur_prog_type.course_type, p_ParameterList => l_parameter_list_t);
307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);
308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);
313: wf_event.AddParameterToList (p_name => 'P_MAX_TERM', p_Value => p_max_term, p_ParameterList => l_parameter_list_t);

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

306: wf_event.AddParameterToList (p_name => 'P_PROGRAM_TYPE', p_Value => l_cur_prog_type.course_type, p_ParameterList => l_parameter_list_t);
307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);
308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);
313: wf_event.AddParameterToList (p_name => 'P_MAX_TERM', p_Value => p_max_term, p_ParameterList => l_parameter_list_t);
314: wf_event.AddParameterToList (p_name => 'P_ANTI_CP',p_value=>p_anti_cp,p_parameterlist=>l_parameter_list_t);

Line 311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);

307: wf_event.AddParameterToList (p_name => 'P_INTMTYPE', p_Value => p_intmtype, p_ParameterList => l_parameter_list_t);
308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);
313: wf_event.AddParameterToList (p_name => 'P_MAX_TERM', p_Value => p_max_term, p_ParameterList => l_parameter_list_t);
314: wf_event.AddParameterToList (p_name => 'P_ANTI_CP',p_value=>p_anti_cp,p_parameterlist=>l_parameter_list_t);
315: wf_event.AddParameterToList (p_name => 'P_APPROVER', p_Value => p_approver, p_ParameterList => l_parameter_list_t);

Line 312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);

308: wf_event.AddParameterToList (p_name => 'P_INTMDESC',p_value=>l_cur_int_type.description,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);
313: wf_event.AddParameterToList (p_name => 'P_MAX_TERM', p_Value => p_max_term, p_ParameterList => l_parameter_list_t);
314: wf_event.AddParameterToList (p_name => 'P_ANTI_CP',p_value=>p_anti_cp,p_parameterlist=>l_parameter_list_t);
315: wf_event.AddParameterToList (p_name => 'P_APPROVER', p_Value => p_approver, p_ParameterList => l_parameter_list_t);
316:

Line 313: wf_event.AddParameterToList (p_name => 'P_MAX_TERM', p_Value => p_max_term, p_ParameterList => l_parameter_list_t);

309: wf_event.AddParameterToList (p_name => 'P_STARTDT', p_Value => p_startdt, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);
313: wf_event.AddParameterToList (p_name => 'P_MAX_TERM', p_Value => p_max_term, p_ParameterList => l_parameter_list_t);
314: wf_event.AddParameterToList (p_name => 'P_ANTI_CP',p_value=>p_anti_cp,p_parameterlist=>l_parameter_list_t);
315: wf_event.AddParameterToList (p_name => 'P_APPROVER', p_Value => p_approver, p_ParameterList => l_parameter_list_t);
316:
317:

Line 314: wf_event.AddParameterToList (p_name => 'P_ANTI_CP',p_value=>p_anti_cp,p_parameterlist=>l_parameter_list_t);

310: wf_event.AddParameterToList (p_name => 'P_ENDDT', p_Value => p_enddt, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);
313: wf_event.AddParameterToList (p_name => 'P_MAX_TERM', p_Value => p_max_term, p_ParameterList => l_parameter_list_t);
314: wf_event.AddParameterToList (p_name => 'P_ANTI_CP',p_value=>p_anti_cp,p_parameterlist=>l_parameter_list_t);
315: wf_event.AddParameterToList (p_name => 'P_APPROVER', p_Value => p_approver, p_ParameterList => l_parameter_list_t);
316:
317:
318: -- Raise the Event

Line 315: wf_event.AddParameterToList (p_name => 'P_APPROVER', p_Value => p_approver, p_ParameterList => l_parameter_list_t);

311: wf_event.AddParameterToList (p_name => 'P_INST_NAME', p_Value => p_inst_name, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList (p_name => 'P_MAX_CP',p_value=>p_max_cp,p_parameterlist=>l_parameter_list_t);
313: wf_event.AddParameterToList (p_name => 'P_MAX_TERM', p_Value => p_max_term, p_ParameterList => l_parameter_list_t);
314: wf_event.AddParameterToList (p_name => 'P_ANTI_CP',p_value=>p_anti_cp,p_parameterlist=>l_parameter_list_t);
315: wf_event.AddParameterToList (p_name => 'P_APPROVER', p_Value => p_approver, p_ParameterList => l_parameter_list_t);
316:
317:
318: -- Raise the Event
319:

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

317:
318: -- Raise the Event
319:
320:
321: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.prog.intrmn',
322: p_event_key => 'PROGINTRMN'||ln_seq_val,
323: p_parameters => l_parameter_list_t);
324:
325: --

Line 355: l_event_t wf_event_t;

351: -- Change History:
352: -- Who When What
353: --
354: -------------------------------------------------------------------------------------------------
355: l_event_t wf_event_t;
356: l_parameter_list_t wf_parameter_list_t;
357: l_itemKey varchar2(100);
358: ln_seq_val NUMBER;
359:

Line 421: -- initialize the wf_event_t object

417: FETCH cur_discontinue_reason INTO l_cur_discontinue_reason;
418: CLOSE cur_discontinue_reason;
419:
420: --
421: -- initialize the wf_event_t object
422: --
423:
424: wf_event_t.Initialize(l_event_t);
425:

Line 424: wf_event_t.Initialize(l_event_t);

420: --
421: -- initialize the wf_event_t object
422: --
423:
424: wf_event_t.Initialize(l_event_t);
425:
426:
427: --
428: -- Adding the parameters to the parameter list

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

427: --
428: -- Adding the parameters to the parameter list
429: --
430:
431: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
432: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
433: wf_event.AddParameterToList (p_name => 'P_DISCONTINDT', p_Value => p_discontindt, p_ParameterList => l_parameter_list_t);
434: wf_event.AddParameterToList (p_name => 'P_DISCONTINCD', p_Value => p_discontincd, p_ParameterList => l_parameter_list_t);
435: wf_event.AddParameterToList (p_name => 'P_DISCONTINTYPE',p_value=>l_cur_discontinue_reason.s_discontinuation_reason_type,p_parameterlist=>l_parameter_list_t);

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

428: -- Adding the parameters to the parameter list
429: --
430:
431: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
432: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
433: wf_event.AddParameterToList (p_name => 'P_DISCONTINDT', p_Value => p_discontindt, p_ParameterList => l_parameter_list_t);
434: wf_event.AddParameterToList (p_name => 'P_DISCONTINCD', p_Value => p_discontincd, p_ParameterList => l_parameter_list_t);
435: wf_event.AddParameterToList (p_name => 'P_DISCONTINTYPE',p_value=>l_cur_discontinue_reason.s_discontinuation_reason_type,p_parameterlist=>l_parameter_list_t);
436: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 433: wf_event.AddParameterToList (p_name => 'P_DISCONTINDT', p_Value => p_discontindt, p_ParameterList => l_parameter_list_t);

429: --
430:
431: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
432: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
433: wf_event.AddParameterToList (p_name => 'P_DISCONTINDT', p_Value => p_discontindt, p_ParameterList => l_parameter_list_t);
434: wf_event.AddParameterToList (p_name => 'P_DISCONTINCD', p_Value => p_discontincd, p_ParameterList => l_parameter_list_t);
435: wf_event.AddParameterToList (p_name => 'P_DISCONTINTYPE',p_value=>l_cur_discontinue_reason.s_discontinuation_reason_type,p_parameterlist=>l_parameter_list_t);
436: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
437:

Line 434: wf_event.AddParameterToList (p_name => 'P_DISCONTINCD', p_Value => p_discontincd, p_ParameterList => l_parameter_list_t);

430:
431: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
432: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
433: wf_event.AddParameterToList (p_name => 'P_DISCONTINDT', p_Value => p_discontindt, p_ParameterList => l_parameter_list_t);
434: wf_event.AddParameterToList (p_name => 'P_DISCONTINCD', p_Value => p_discontincd, p_ParameterList => l_parameter_list_t);
435: wf_event.AddParameterToList (p_name => 'P_DISCONTINTYPE',p_value=>l_cur_discontinue_reason.s_discontinuation_reason_type,p_parameterlist=>l_parameter_list_t);
436: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
437:
438:

Line 435: wf_event.AddParameterToList (p_name => 'P_DISCONTINTYPE',p_value=>l_cur_discontinue_reason.s_discontinuation_reason_type,p_parameterlist=>l_parameter_list_t);

431: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
432: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
433: wf_event.AddParameterToList (p_name => 'P_DISCONTINDT', p_Value => p_discontindt, p_ParameterList => l_parameter_list_t);
434: wf_event.AddParameterToList (p_name => 'P_DISCONTINCD', p_Value => p_discontincd, p_ParameterList => l_parameter_list_t);
435: wf_event.AddParameterToList (p_name => 'P_DISCONTINTYPE',p_value=>l_cur_discontinue_reason.s_discontinuation_reason_type,p_parameterlist=>l_parameter_list_t);
436: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
437:
438:
439: -- Raise the Event

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

432: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
433: wf_event.AddParameterToList (p_name => 'P_DISCONTINDT', p_Value => p_discontindt, p_ParameterList => l_parameter_list_t);
434: wf_event.AddParameterToList (p_name => 'P_DISCONTINCD', p_Value => p_discontincd, p_ParameterList => l_parameter_list_t);
435: wf_event.AddParameterToList (p_name => 'P_DISCONTINTYPE',p_value=>l_cur_discontinue_reason.s_discontinuation_reason_type,p_parameterlist=>l_parameter_list_t);
436: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
437:
438:
439: -- Raise the Event
440:

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

438:
439: -- Raise the Event
440:
441:
442: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.prog.discon',
443: p_event_key => 'PROGDISCON'||ln_seq_val,
444: p_parameters => l_parameter_list_t);
445:
446:

Line 484: l_event_t wf_event_t;

480: -- Who When What
481: --
482: -------------------------------------------------------------------------------------------------
483:
484: l_event_t wf_event_t;
485: l_parameter_list_t wf_parameter_list_t;
486: l_itemKey varchar2(100);
487: ln_seq_val NUMBER;
488:

Line 536: -- initialize the wf_event_t object

532: FETCH cur_user_id INTO l_cur_user_id ;
533: CLOSE cur_user_id ;
534:
535: --
536: -- initialize the wf_event_t object
537: --
538:
539: wf_event_t.Initialize(l_event_t);
540:

Line 539: wf_event_t.Initialize(l_event_t);

535: --
536: -- initialize the wf_event_t object
537: --
538:
539: wf_event_t.Initialize(l_event_t);
540:
541:
542: --
543: -- Adding the parameters to the parameter list

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

542: --
543: -- Adding the parameters to the parameter list
544: --
545:
546: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
547: wf_event.AddParameterToList (p_name => 'P_DESTPROGCD', p_Value => p_destprogcd, p_ParameterList => l_parameter_list_t);
548: wf_event.AddParameterToList (p_name => 'P_PROGSTARTDT', p_Value => p_progstartdt, p_ParameterList => l_parameter_list_t);
549: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);

Line 547: wf_event.AddParameterToList (p_name => 'P_DESTPROGCD', p_Value => p_destprogcd, p_ParameterList => l_parameter_list_t);

543: -- Adding the parameters to the parameter list
544: --
545:
546: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
547: wf_event.AddParameterToList (p_name => 'P_DESTPROGCD', p_Value => p_destprogcd, p_ParameterList => l_parameter_list_t);
548: wf_event.AddParameterToList (p_name => 'P_PROGSTARTDT', p_Value => p_progstartdt, p_ParameterList => l_parameter_list_t);
549: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);
551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);

Line 548: wf_event.AddParameterToList (p_name => 'P_PROGSTARTDT', p_Value => p_progstartdt, p_ParameterList => l_parameter_list_t);

544: --
545:
546: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
547: wf_event.AddParameterToList (p_name => 'P_DESTPROGCD', p_Value => p_destprogcd, p_ParameterList => l_parameter_list_t);
548: wf_event.AddParameterToList (p_name => 'P_PROGSTARTDT', p_Value => p_progstartdt, p_ParameterList => l_parameter_list_t);
549: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);
551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);
552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);

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

545:
546: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
547: wf_event.AddParameterToList (p_name => 'P_DESTPROGCD', p_Value => p_destprogcd, p_ParameterList => l_parameter_list_t);
548: wf_event.AddParameterToList (p_name => 'P_PROGSTARTDT', p_Value => p_progstartdt, p_ParameterList => l_parameter_list_t);
549: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);
551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);
552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);
553: wf_event.AddParameterToList (p_name => 'P_TRSNFRDT', p_Value => p_trsnfrdt, p_ParameterList => l_parameter_list_t);

Line 550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);

546: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
547: wf_event.AddParameterToList (p_name => 'P_DESTPROGCD', p_Value => p_destprogcd, p_ParameterList => l_parameter_list_t);
548: wf_event.AddParameterToList (p_name => 'P_PROGSTARTDT', p_Value => p_progstartdt, p_ParameterList => l_parameter_list_t);
549: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);
551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);
552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);
553: wf_event.AddParameterToList (p_name => 'P_TRSNFRDT', p_Value => p_trsnfrdt, p_ParameterList => l_parameter_list_t);
554: wf_event.AddParameterToList (p_name => 'P_SOURCEPROGCD',p_value=>p_sourceprogcd,p_parameterlist=>l_parameter_list_t);

Line 551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);

547: wf_event.AddParameterToList (p_name => 'P_DESTPROGCD', p_Value => p_destprogcd, p_ParameterList => l_parameter_list_t);
548: wf_event.AddParameterToList (p_name => 'P_PROGSTARTDT', p_Value => p_progstartdt, p_ParameterList => l_parameter_list_t);
549: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);
551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);
552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);
553: wf_event.AddParameterToList (p_name => 'P_TRSNFRDT', p_Value => p_trsnfrdt, p_ParameterList => l_parameter_list_t);
554: wf_event.AddParameterToList (p_name => 'P_SOURCEPROGCD',p_value=>p_sourceprogcd,p_parameterlist=>l_parameter_list_t);
555: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);

548: wf_event.AddParameterToList (p_name => 'P_PROGSTARTDT', p_Value => p_progstartdt, p_ParameterList => l_parameter_list_t);
549: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);
551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);
552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);
553: wf_event.AddParameterToList (p_name => 'P_TRSNFRDT', p_Value => p_trsnfrdt, p_ParameterList => l_parameter_list_t);
554: wf_event.AddParameterToList (p_name => 'P_SOURCEPROGCD',p_value=>p_sourceprogcd,p_parameterlist=>l_parameter_list_t);
555: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
556:

Line 553: wf_event.AddParameterToList (p_name => 'P_TRSNFRDT', p_Value => p_trsnfrdt, p_ParameterList => l_parameter_list_t);

549: wf_event.AddParameterToList (p_name => 'P_LOCATION', p_Value => p_location, p_ParameterList => l_parameter_list_t);
550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);
551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);
552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);
553: wf_event.AddParameterToList (p_name => 'P_TRSNFRDT', p_Value => p_trsnfrdt, p_ParameterList => l_parameter_list_t);
554: wf_event.AddParameterToList (p_name => 'P_SOURCEPROGCD',p_value=>p_sourceprogcd,p_parameterlist=>l_parameter_list_t);
555: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
556:
557:

Line 554: wf_event.AddParameterToList (p_name => 'P_SOURCEPROGCD',p_value=>p_sourceprogcd,p_parameterlist=>l_parameter_list_t);

550: wf_event.AddParameterToList (p_name => 'P_ATTEN_TYPE',p_value=>p_atten_type,p_parameterlist=>l_parameter_list_t);
551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);
552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);
553: wf_event.AddParameterToList (p_name => 'P_TRSNFRDT', p_Value => p_trsnfrdt, p_ParameterList => l_parameter_list_t);
554: wf_event.AddParameterToList (p_name => 'P_SOURCEPROGCD',p_value=>p_sourceprogcd,p_parameterlist=>l_parameter_list_t);
555: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
556:
557:
558: -- Raise the Event

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

551: wf_event.AddParameterToList (p_name => 'P_ATTEN_MODE', p_Value => p_atten_mode, p_ParameterList => l_parameter_list_t);
552: wf_event.AddParameterToList (p_name => 'P_PROG_STATUS', p_Value => p_prog_status, p_ParameterList => l_parameter_list_t);
553: wf_event.AddParameterToList (p_name => 'P_TRSNFRDT', p_Value => p_trsnfrdt, p_ParameterList => l_parameter_list_t);
554: wf_event.AddParameterToList (p_name => 'P_SOURCEPROGCD',p_value=>p_sourceprogcd,p_parameterlist=>l_parameter_list_t);
555: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
556:
557:
558: -- Raise the Event
559:

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

557:
558: -- Raise the Event
559:
560:
561: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.prog.transfer',
562: p_event_key => 'PROGTRANSFER'||ln_seq_val,
563: p_parameters => l_parameter_list_t);
564:
565: --

Line 602: l_event_t wf_event_t;

598: -- Who When What
599: --
600: -------------------------------------------------------------------------------------------------
601:
602: l_event_t wf_event_t;
603: l_parameter_list_t wf_parameter_list_t;
604: l_itemKey varchar2(100);
605: ln_seq_val NUMBER;
606:

Line 656: -- initialize the wf_event_t object

652: FETCH cur_user_id INTO l_cur_user_id ;
653: CLOSE cur_user_id ;
654:
655: --
656: -- initialize the wf_event_t object
657: --
658:
659: wf_event_t.Initialize(l_event_t);
660:

Line 659: wf_event_t.Initialize(l_event_t);

655: --
656: -- initialize the wf_event_t object
657: --
658:
659: wf_event_t.Initialize(l_event_t);
660:
661:
662: --
663: -- Adding the parameters to the parameter list

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

662: --
663: -- Adding the parameters to the parameter list
664: --
665:
666: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
667: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
668: wf_event.AddParameterToList (p_name => 'P_LOCATIONCD', p_Value => p_locationcd, p_ParameterList => l_parameter_list_t);
669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);
670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);

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

663: -- Adding the parameters to the parameter list
664: --
665:
666: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
667: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
668: wf_event.AddParameterToList (p_name => 'P_LOCATIONCD', p_Value => p_locationcd, p_ParameterList => l_parameter_list_t);
669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);
670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);
671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);

Line 668: wf_event.AddParameterToList (p_name => 'P_LOCATIONCD', p_Value => p_locationcd, p_ParameterList => l_parameter_list_t);

664: --
665:
666: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
667: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
668: wf_event.AddParameterToList (p_name => 'P_LOCATIONCD', p_Value => p_locationcd, p_ParameterList => l_parameter_list_t);
669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);
670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);
671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);
672: wf_event.AddParameterToList (p_name => 'P_ATTNDTYPE', p_Value => p_attndtype, p_ParameterList => l_parameter_list_t);

Line 669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);

665:
666: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
667: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
668: wf_event.AddParameterToList (p_name => 'P_LOCATIONCD', p_Value => p_locationcd, p_ParameterList => l_parameter_list_t);
669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);
670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);
671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);
672: wf_event.AddParameterToList (p_name => 'P_ATTNDTYPE', p_Value => p_attndtype, p_ParameterList => l_parameter_list_t);
673: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDTYPE', p_Value => p_prev_attndtype, p_ParameterList => l_parameter_list_t);

Line 670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);

666: wf_event.AddParameterToList (p_name => 'P_PERSONID',p_value=>p_personid,p_parameterlist=>l_parameter_list_t);
667: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
668: wf_event.AddParameterToList (p_name => 'P_LOCATIONCD', p_Value => p_locationcd, p_ParameterList => l_parameter_list_t);
669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);
670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);
671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);
672: wf_event.AddParameterToList (p_name => 'P_ATTNDTYPE', p_Value => p_attndtype, p_ParameterList => l_parameter_list_t);
673: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDTYPE', p_Value => p_prev_attndtype, p_ParameterList => l_parameter_list_t);
674: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);

Line 671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);

667: wf_event.AddParameterToList (p_name => 'P_PROGRAMCD', p_Value => p_programcd, p_ParameterList => l_parameter_list_t);
668: wf_event.AddParameterToList (p_name => 'P_LOCATIONCD', p_Value => p_locationcd, p_ParameterList => l_parameter_list_t);
669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);
670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);
671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);
672: wf_event.AddParameterToList (p_name => 'P_ATTNDTYPE', p_Value => p_attndtype, p_ParameterList => l_parameter_list_t);
673: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDTYPE', p_Value => p_prev_attndtype, p_ParameterList => l_parameter_list_t);
674: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
675:

Line 672: wf_event.AddParameterToList (p_name => 'P_ATTNDTYPE', p_Value => p_attndtype, p_ParameterList => l_parameter_list_t);

668: wf_event.AddParameterToList (p_name => 'P_LOCATIONCD', p_Value => p_locationcd, p_ParameterList => l_parameter_list_t);
669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);
670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);
671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);
672: wf_event.AddParameterToList (p_name => 'P_ATTNDTYPE', p_Value => p_attndtype, p_ParameterList => l_parameter_list_t);
673: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDTYPE', p_Value => p_prev_attndtype, p_ParameterList => l_parameter_list_t);
674: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
675:
676:

Line 673: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDTYPE', p_Value => p_prev_attndtype, p_ParameterList => l_parameter_list_t);

669: wf_event.AddParameterToList (p_name => 'P_PREV_LOCATION_CD', p_Value => p_prev_location_cd, p_ParameterList => l_parameter_list_t);
670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);
671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);
672: wf_event.AddParameterToList (p_name => 'P_ATTNDTYPE', p_Value => p_attndtype, p_ParameterList => l_parameter_list_t);
673: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDTYPE', p_Value => p_prev_attndtype, p_ParameterList => l_parameter_list_t);
674: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
675:
676:
677: -- Raise the Event

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

670: wf_event.AddParameterToList (p_name => 'P_ATTNDMODE',p_value=>p_attndmode,p_parameterlist=>l_parameter_list_t);
671: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDMODE', p_Value => p_prev_attndmode, p_ParameterList => l_parameter_list_t);
672: wf_event.AddParameterToList (p_name => 'P_ATTNDTYPE', p_Value => p_attndtype, p_ParameterList => l_parameter_list_t);
673: wf_event.AddParameterToList (p_name => 'P_PREV_ATTNDTYPE', p_Value => p_prev_attndtype, p_ParameterList => l_parameter_list_t);
674: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
675:
676:
677: -- Raise the Event
678:

Line 680: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.pgofop.update',

676:
677: -- Raise the Event
678:
679:
680: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.pgofop.update',
681: p_event_key => 'PROFOPUPDATE'||ln_seq_val,
682: p_parameters => l_parameter_list_t);
683:
684:

Line 1579: l_event_t wf_event_t;

1575: WHERE party_id = cp_person_id;
1576:
1577: l_cur_prof_value cur_prof_value%ROWTYPE;
1578: l_cur_pers_number cur_pers_number%ROWTYPE;
1579: l_event_t wf_event_t;
1580: l_parameter_list_t wf_parameter_list_t;
1581: l_itemKey varchar2(100);
1582: ln_seq_val NUMBER;
1583:

Line 1604: -- initialize the wf_event_t object

1600: FETCH cur_pers_number INTO l_cur_pers_number;
1601: CLOSE cur_pers_number;
1602:
1603: --
1604: -- initialize the wf_event_t object
1605: --
1606: wf_event_t.Initialize(l_event_t);
1607:
1608: --

Line 1606: wf_event_t.Initialize(l_event_t);

1602:
1603: --
1604: -- initialize the wf_event_t object
1605: --
1606: wf_event_t.Initialize(l_event_t);
1607:
1608: --
1609: -- Adding the parameters to the parameter list
1610: --

Line 1611: wf_event.AddParameterToList (p_name => 'STUDENT_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);

1607:
1608: --
1609: -- Adding the parameters to the parameter list
1610: --
1611: wf_event.AddParameterToList (p_name => 'STUDENT_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
1612: wf_event.AddParameterToList (p_name => 'PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
1613: wf_event.AddParameterToList (p_name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);

Line 1612: wf_event.AddParameterToList (p_name => 'PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);

1608: --
1609: -- Adding the parameters to the parameter list
1610: --
1611: wf_event.AddParameterToList (p_name => 'STUDENT_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
1612: wf_event.AddParameterToList (p_name => 'PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
1613: wf_event.AddParameterToList (p_name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);
1616: wf_event.AddParameterToList (p_name => 'UOO_ID', p_Value => p_uoo_id, p_ParameterList => l_parameter_list_t);

Line 1613: wf_event.AddParameterToList (p_name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);

1609: -- Adding the parameters to the parameter list
1610: --
1611: wf_event.AddParameterToList (p_name => 'STUDENT_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
1612: wf_event.AddParameterToList (p_name => 'PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
1613: wf_event.AddParameterToList (p_name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);
1616: wf_event.AddParameterToList (p_name => 'UOO_ID', p_Value => p_uoo_id, p_ParameterList => l_parameter_list_t);
1617: wf_event.AddParameterToList (p_name => 'STUDENT_NUMBER',p_Value =>l_cur_pers_number.party_number,p_ParameterList =>l_parameter_list_t);

Line 1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);

1610: --
1611: wf_event.AddParameterToList (p_name => 'STUDENT_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
1612: wf_event.AddParameterToList (p_name => 'PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
1613: wf_event.AddParameterToList (p_name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);
1616: wf_event.AddParameterToList (p_name => 'UOO_ID', p_Value => p_uoo_id, p_ParameterList => l_parameter_list_t);
1617: wf_event.AddParameterToList (p_name => 'STUDENT_NUMBER',p_Value =>l_cur_pers_number.party_number,p_ParameterList =>l_parameter_list_t);
1618: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => 'SYSADMIN', p_ParameterList => l_parameter_list_t);

Line 1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);

1611: wf_event.AddParameterToList (p_name => 'STUDENT_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
1612: wf_event.AddParameterToList (p_name => 'PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
1613: wf_event.AddParameterToList (p_name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);
1616: wf_event.AddParameterToList (p_name => 'UOO_ID', p_Value => p_uoo_id, p_ParameterList => l_parameter_list_t);
1617: wf_event.AddParameterToList (p_name => 'STUDENT_NUMBER',p_Value =>l_cur_pers_number.party_number,p_ParameterList =>l_parameter_list_t);
1618: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => 'SYSADMIN', p_ParameterList => l_parameter_list_t);
1619:

Line 1616: wf_event.AddParameterToList (p_name => 'UOO_ID', p_Value => p_uoo_id, p_ParameterList => l_parameter_list_t);

1612: wf_event.AddParameterToList (p_name => 'PROGRAM_CD', p_Value => p_program_cd, p_ParameterList => l_parameter_list_t);
1613: wf_event.AddParameterToList (p_name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);
1616: wf_event.AddParameterToList (p_name => 'UOO_ID', p_Value => p_uoo_id, p_ParameterList => l_parameter_list_t);
1617: wf_event.AddParameterToList (p_name => 'STUDENT_NUMBER',p_Value =>l_cur_pers_number.party_number,p_ParameterList =>l_parameter_list_t);
1618: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => 'SYSADMIN', p_ParameterList => l_parameter_list_t);
1619:
1620: -- Raise the Event

Line 1617: wf_event.AddParameterToList (p_name => 'STUDENT_NUMBER',p_Value =>l_cur_pers_number.party_number,p_ParameterList =>l_parameter_list_t);

1613: wf_event.AddParameterToList (p_name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);
1616: wf_event.AddParameterToList (p_name => 'UOO_ID', p_Value => p_uoo_id, p_ParameterList => l_parameter_list_t);
1617: wf_event.AddParameterToList (p_name => 'STUDENT_NUMBER',p_Value =>l_cur_pers_number.party_number,p_ParameterList =>l_parameter_list_t);
1618: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => 'SYSADMIN', p_ParameterList => l_parameter_list_t);
1619:
1620: -- Raise the Event
1621: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.student.placemnt',

Line 1618: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => 'SYSADMIN', p_ParameterList => l_parameter_list_t);

1614: wf_event.AddParameterToList (p_name => 'UNIT_CLASS', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
1615: wf_event.AddParameterToList (p_name => 'LOCATION_CD', p_Value => p_location_cd, p_ParameterList => l_parameter_list_t);
1616: wf_event.AddParameterToList (p_name => 'UOO_ID', p_Value => p_uoo_id, p_ParameterList => l_parameter_list_t);
1617: wf_event.AddParameterToList (p_name => 'STUDENT_NUMBER',p_Value =>l_cur_pers_number.party_number,p_ParameterList =>l_parameter_list_t);
1618: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => 'SYSADMIN', p_ParameterList => l_parameter_list_t);
1619:
1620: -- Raise the Event
1621: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.student.placemnt',
1622: p_event_key => 'STUDPLCMNT'||ln_seq_val,

Line 1621: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.student.placemnt',

1617: wf_event.AddParameterToList (p_name => 'STUDENT_NUMBER',p_Value =>l_cur_pers_number.party_number,p_ParameterList =>l_parameter_list_t);
1618: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => 'SYSADMIN', p_ParameterList => l_parameter_list_t);
1619:
1620: -- Raise the Event
1621: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.student.placemnt',
1622: p_event_key => 'STUDPLCMNT'||ln_seq_val,
1623: p_parameters => l_parameter_list_t);
1624: --
1625: -- Deleting the Parameter list after the event is raised

Line 1653: l_wf_event_t WF_EVENT_T;

1649: -------------------------------------------------------------------
1650: IS
1651:
1652: l_n_key NUMBER;
1653: l_wf_event_t WF_EVENT_T;
1654: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1655:
1656: CURSOR c_uoo( cp_n_uoo_id IN NUMBER,
1657: p_c_load_cal IN VARCHAR2,

Line 1701: -- initialize the wf_event_t object

1697: l_c_user_name fnd_user.user_name%TYPE;
1698: l_c_perm_type VARCHAR2(2000);
1699:
1700: BEGIN
1701: -- initialize the wf_event_t object
1702: --
1703: WF_EVENT_T.Initialize(l_wf_event_t);
1704: --
1705: -- set the event name

Line 1703: WF_EVENT_T.Initialize(l_wf_event_t);

1699:
1700: BEGIN
1701: -- initialize the wf_event_t object
1702: --
1703: WF_EVENT_T.Initialize(l_wf_event_t);
1704: --
1705: -- set the event name
1706: --
1707: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.en.withdraw_perm');

Line 1707: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.en.withdraw_perm');

1703: WF_EVENT_T.Initialize(l_wf_event_t);
1704: --
1705: -- set the event name
1706: --
1707: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.en.withdraw_perm');
1708: --
1709: -- event key to identify uniquely
1710: --
1711: -- set the parameter list

Line 1713: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );

1709: -- event key to identify uniquely
1710: --
1711: -- set the parameter list
1712: --
1713: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
1714: --
1715: -- now add the parameters to the parameter list
1716:
1717: OPEN c_uoo(p_n_uoo_id,p_c_load_cal, p_n_load_seq_num);

Line 1741: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value =>p_n_person_id , p_parameterlist => l_wf_parameter_list_t);

1737: END IF;
1738:
1739: l_c_perm_type := fnd_message.get;
1740:
1741: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value =>p_n_person_id , p_parameterlist => l_wf_parameter_list_t);
1742: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER', p_value =>l_c_person_num, p_parameterlist => l_wf_parameter_list_t);
1743: wf_event.AddParameterToList ( p_name => 'UOO_ID', p_value =>p_n_uoo_id , p_parameterlist => l_wf_parameter_list_t);
1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);
1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);

Line 1742: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER', p_value =>l_c_person_num, p_parameterlist => l_wf_parameter_list_t);

1738:
1739: l_c_perm_type := fnd_message.get;
1740:
1741: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value =>p_n_person_id , p_parameterlist => l_wf_parameter_list_t);
1742: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER', p_value =>l_c_person_num, p_parameterlist => l_wf_parameter_list_t);
1743: wf_event.AddParameterToList ( p_name => 'UOO_ID', p_value =>p_n_uoo_id , p_parameterlist => l_wf_parameter_list_t);
1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);
1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);
1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);

Line 1743: wf_event.AddParameterToList ( p_name => 'UOO_ID', p_value =>p_n_uoo_id , p_parameterlist => l_wf_parameter_list_t);

1739: l_c_perm_type := fnd_message.get;
1740:
1741: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value =>p_n_person_id , p_parameterlist => l_wf_parameter_list_t);
1742: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER', p_value =>l_c_person_num, p_parameterlist => l_wf_parameter_list_t);
1743: wf_event.AddParameterToList ( p_name => 'UOO_ID', p_value =>p_n_uoo_id , p_parameterlist => l_wf_parameter_list_t);
1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);
1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);
1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);
1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);

Line 1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);

1740:
1741: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value =>p_n_person_id , p_parameterlist => l_wf_parameter_list_t);
1742: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER', p_value =>l_c_person_num, p_parameterlist => l_wf_parameter_list_t);
1743: wf_event.AddParameterToList ( p_name => 'UOO_ID', p_value =>p_n_uoo_id , p_parameterlist => l_wf_parameter_list_t);
1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);
1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);
1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);
1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);
1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);

Line 1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);

1741: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value =>p_n_person_id , p_parameterlist => l_wf_parameter_list_t);
1742: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER', p_value =>l_c_person_num, p_parameterlist => l_wf_parameter_list_t);
1743: wf_event.AddParameterToList ( p_name => 'UOO_ID', p_value =>p_n_uoo_id , p_parameterlist => l_wf_parameter_list_t);
1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);
1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);
1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);
1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);
1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);
1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);

Line 1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);

1742: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER', p_value =>l_c_person_num, p_parameterlist => l_wf_parameter_list_t);
1743: wf_event.AddParameterToList ( p_name => 'UOO_ID', p_value =>p_n_uoo_id , p_parameterlist => l_wf_parameter_list_t);
1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);
1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);
1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);
1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);
1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);
1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);
1750: wf_event.AddParameterToList ( p_name => 'PERM_TYPE', p_value =>l_c_perm_type, p_parameterlist => l_wf_parameter_list_t);

Line 1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);

1743: wf_event.AddParameterToList ( p_name => 'UOO_ID', p_value =>p_n_uoo_id , p_parameterlist => l_wf_parameter_list_t);
1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);
1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);
1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);
1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);
1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);
1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);
1750: wf_event.AddParameterToList ( p_name => 'PERM_TYPE', p_value =>l_c_perm_type, p_parameterlist => l_wf_parameter_list_t);
1751: wf_event.AddParameterToList ( p_name => 'UNIT_SECTION', p_value =>rec_uoo.unit_section, p_parameterlist => l_wf_parameter_list_t);

Line 1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);

1744: wf_event.AddParameterToList ( p_name => 'UNIT_CD', p_value =>rec_uoo.unit_cd, p_parameterlist => l_wf_parameter_list_t);
1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);
1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);
1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);
1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);
1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);
1750: wf_event.AddParameterToList ( p_name => 'PERM_TYPE', p_value =>l_c_perm_type, p_parameterlist => l_wf_parameter_list_t);
1751: wf_event.AddParameterToList ( p_name => 'UNIT_SECTION', p_value =>rec_uoo.unit_section, p_parameterlist => l_wf_parameter_list_t);
1752: wf_event.AddParameterToList ( p_name => 'LEAD_INSTRUCTOR', p_value =>l_c_user_name, p_parameterlist => l_wf_parameter_list_t);

Line 1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);

1745: wf_event.AddParameterToList ( p_name => 'VERSION_NUMBER', p_value =>rec_uoo.version_number, p_parameterlist => l_wf_parameter_list_t);
1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);
1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);
1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);
1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);
1750: wf_event.AddParameterToList ( p_name => 'PERM_TYPE', p_value =>l_c_perm_type, p_parameterlist => l_wf_parameter_list_t);
1751: wf_event.AddParameterToList ( p_name => 'UNIT_SECTION', p_value =>rec_uoo.unit_section, p_parameterlist => l_wf_parameter_list_t);
1752: wf_event.AddParameterToList ( p_name => 'LEAD_INSTRUCTOR', p_value =>l_c_user_name, p_parameterlist => l_wf_parameter_list_t);
1753:

Line 1750: wf_event.AddParameterToList ( p_name => 'PERM_TYPE', p_value =>l_c_perm_type, p_parameterlist => l_wf_parameter_list_t);

1746: wf_event.AddParameterToList ( p_name => 'UNIT_LOCATION', p_value =>rec_uoo.location_cd, p_parameterlist => l_wf_parameter_list_t);
1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);
1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);
1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);
1750: wf_event.AddParameterToList ( p_name => 'PERM_TYPE', p_value =>l_c_perm_type, p_parameterlist => l_wf_parameter_list_t);
1751: wf_event.AddParameterToList ( p_name => 'UNIT_SECTION', p_value =>rec_uoo.unit_section, p_parameterlist => l_wf_parameter_list_t);
1752: wf_event.AddParameterToList ( p_name => 'LEAD_INSTRUCTOR', p_value =>l_c_user_name, p_parameterlist => l_wf_parameter_list_t);
1753:
1754: --

Line 1751: wf_event.AddParameterToList ( p_name => 'UNIT_SECTION', p_value =>rec_uoo.unit_section, p_parameterlist => l_wf_parameter_list_t);

1747: wf_event.AddParameterToList ( p_name => 'UNIT_CLASS', p_value =>rec_uoo.unit_class, p_parameterlist => l_wf_parameter_list_t);
1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);
1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);
1750: wf_event.AddParameterToList ( p_name => 'PERM_TYPE', p_value =>l_c_perm_type, p_parameterlist => l_wf_parameter_list_t);
1751: wf_event.AddParameterToList ( p_name => 'UNIT_SECTION', p_value =>rec_uoo.unit_section, p_parameterlist => l_wf_parameter_list_t);
1752: wf_event.AddParameterToList ( p_name => 'LEAD_INSTRUCTOR', p_value =>l_c_user_name, p_parameterlist => l_wf_parameter_list_t);
1753:
1754: --
1755: -- raise the event

Line 1752: wf_event.AddParameterToList ( p_name => 'LEAD_INSTRUCTOR', p_value =>l_c_user_name, p_parameterlist => l_wf_parameter_list_t);

1748: wf_event.AddParameterToList ( p_name => 'TEACHING_PRD', p_value =>rec_uoo.teaching_prd, p_parameterlist => l_wf_parameter_list_t);
1749: wf_event.AddParameterToList ( p_name => 'LOAD_CAL_DESC', p_value =>rec_uoo.load_description, p_parameterlist => l_wf_parameter_list_t);
1750: wf_event.AddParameterToList ( p_name => 'PERM_TYPE', p_value =>l_c_perm_type, p_parameterlist => l_wf_parameter_list_t);
1751: wf_event.AddParameterToList ( p_name => 'UNIT_SECTION', p_value =>rec_uoo.unit_section, p_parameterlist => l_wf_parameter_list_t);
1752: wf_event.AddParameterToList ( p_name => 'LEAD_INSTRUCTOR', p_value =>l_c_user_name, p_parameterlist => l_wf_parameter_list_t);
1753:
1754: --
1755: -- raise the event
1756:

Line 1759: wf_event.raise (

1755: -- raise the event
1756:
1757: SELECT igs_en_withdraw_perm_S.nextval INTO l_t_temp from dual;
1758:
1759: wf_event.raise (
1760: p_event_name => 'oracle.apps.igs.en.withdraw_perm',
1761: p_event_key => 'WITHDRAW'||l_t_temp,
1762: p_parameters => l_wf_parameter_list_t
1763: );

Line 1825: wf_event.AddParameterToList(p_name=>'P_PERSON_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);

1821:
1822: l_user_name := FND_GLOBAL.USER_NAME;
1823:
1824: -- set the event parameters
1825: wf_event.AddParameterToList(p_name=>'P_PERSON_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);
1826: wf_event.AddParameterToList(p_name=>'P_PROGRAM_CD', p_value=>p_program_cd, p_parameterlist=>l_wf_parameter_list_t);
1827: wf_event.AddParameterToList(p_name=>'P_INTM_TYPE', p_value=>p_intm_type, p_parameterlist=>l_wf_parameter_list_t);
1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);
1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);

Line 1826: wf_event.AddParameterToList(p_name=>'P_PROGRAM_CD', p_value=>p_program_cd, p_parameterlist=>l_wf_parameter_list_t);

1822: l_user_name := FND_GLOBAL.USER_NAME;
1823:
1824: -- set the event parameters
1825: wf_event.AddParameterToList(p_name=>'P_PERSON_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);
1826: wf_event.AddParameterToList(p_name=>'P_PROGRAM_CD', p_value=>p_program_cd, p_parameterlist=>l_wf_parameter_list_t);
1827: wf_event.AddParameterToList(p_name=>'P_INTM_TYPE', p_value=>p_intm_type, p_parameterlist=>l_wf_parameter_list_t);
1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);
1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);
1830: wf_event.AddParameterToList(p_name=>'P_FULL_NAME', p_value=>l_person_name, p_parameterlist=>l_wf_parameter_list_t);

Line 1827: wf_event.AddParameterToList(p_name=>'P_INTM_TYPE', p_value=>p_intm_type, p_parameterlist=>l_wf_parameter_list_t);

1823:
1824: -- set the event parameters
1825: wf_event.AddParameterToList(p_name=>'P_PERSON_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);
1826: wf_event.AddParameterToList(p_name=>'P_PROGRAM_CD', p_value=>p_program_cd, p_parameterlist=>l_wf_parameter_list_t);
1827: wf_event.AddParameterToList(p_name=>'P_INTM_TYPE', p_value=>p_intm_type, p_parameterlist=>l_wf_parameter_list_t);
1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);
1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);
1830: wf_event.AddParameterToList(p_name=>'P_FULL_NAME', p_value=>l_person_name, p_parameterlist=>l_wf_parameter_list_t);
1831: wf_event.AddParameterToList(p_name=>'P_PERSON_NUMBER', p_value=>l_person_number, p_parameterlist=>l_wf_parameter_list_t);

Line 1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);

1824: -- set the event parameters
1825: wf_event.AddParameterToList(p_name=>'P_PERSON_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);
1826: wf_event.AddParameterToList(p_name=>'P_PROGRAM_CD', p_value=>p_program_cd, p_parameterlist=>l_wf_parameter_list_t);
1827: wf_event.AddParameterToList(p_name=>'P_INTM_TYPE', p_value=>p_intm_type, p_parameterlist=>l_wf_parameter_list_t);
1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);
1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);
1830: wf_event.AddParameterToList(p_name=>'P_FULL_NAME', p_value=>l_person_name, p_parameterlist=>l_wf_parameter_list_t);
1831: wf_event.AddParameterToList(p_name=>'P_PERSON_NUMBER', p_value=>l_person_number, p_parameterlist=>l_wf_parameter_list_t);
1832: wf_event.AddParameterToList(p_name=>'P_USER_NAME', p_value=>l_user_name, p_parameterlist=>l_wf_parameter_list_t);

Line 1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);

1825: wf_event.AddParameterToList(p_name=>'P_PERSON_ID', p_value=>p_person_id, p_parameterlist=>l_wf_parameter_list_t);
1826: wf_event.AddParameterToList(p_name=>'P_PROGRAM_CD', p_value=>p_program_cd, p_parameterlist=>l_wf_parameter_list_t);
1827: wf_event.AddParameterToList(p_name=>'P_INTM_TYPE', p_value=>p_intm_type, p_parameterlist=>l_wf_parameter_list_t);
1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);
1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);
1830: wf_event.AddParameterToList(p_name=>'P_FULL_NAME', p_value=>l_person_name, p_parameterlist=>l_wf_parameter_list_t);
1831: wf_event.AddParameterToList(p_name=>'P_PERSON_NUMBER', p_value=>l_person_number, p_parameterlist=>l_wf_parameter_list_t);
1832: wf_event.AddParameterToList(p_name=>'P_USER_NAME', p_value=>l_user_name, p_parameterlist=>l_wf_parameter_list_t);
1833:

Line 1830: wf_event.AddParameterToList(p_name=>'P_FULL_NAME', p_value=>l_person_name, p_parameterlist=>l_wf_parameter_list_t);

1826: wf_event.AddParameterToList(p_name=>'P_PROGRAM_CD', p_value=>p_program_cd, p_parameterlist=>l_wf_parameter_list_t);
1827: wf_event.AddParameterToList(p_name=>'P_INTM_TYPE', p_value=>p_intm_type, p_parameterlist=>l_wf_parameter_list_t);
1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);
1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);
1830: wf_event.AddParameterToList(p_name=>'P_FULL_NAME', p_value=>l_person_name, p_parameterlist=>l_wf_parameter_list_t);
1831: wf_event.AddParameterToList(p_name=>'P_PERSON_NUMBER', p_value=>l_person_number, p_parameterlist=>l_wf_parameter_list_t);
1832: wf_event.AddParameterToList(p_name=>'P_USER_NAME', p_value=>l_user_name, p_parameterlist=>l_wf_parameter_list_t);
1833:
1834: -- raise the event

Line 1831: wf_event.AddParameterToList(p_name=>'P_PERSON_NUMBER', p_value=>l_person_number, p_parameterlist=>l_wf_parameter_list_t);

1827: wf_event.AddParameterToList(p_name=>'P_INTM_TYPE', p_value=>p_intm_type, p_parameterlist=>l_wf_parameter_list_t);
1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);
1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);
1830: wf_event.AddParameterToList(p_name=>'P_FULL_NAME', p_value=>l_person_name, p_parameterlist=>l_wf_parameter_list_t);
1831: wf_event.AddParameterToList(p_name=>'P_PERSON_NUMBER', p_value=>l_person_number, p_parameterlist=>l_wf_parameter_list_t);
1832: wf_event.AddParameterToList(p_name=>'P_USER_NAME', p_value=>l_user_name, p_parameterlist=>l_wf_parameter_list_t);
1833:
1834: -- raise the event
1835: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.prog.intm.rcond',

Line 1832: wf_event.AddParameterToList(p_name=>'P_USER_NAME', p_value=>l_user_name, p_parameterlist=>l_wf_parameter_list_t);

1828: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG', p_value=>p_changed_rconds, p_parameterlist=>l_wf_parameter_list_t);
1829: wf_event.AddParameterToList(p_name=>'P_RCOND_CHG_DESC', p_value=>p_changed_rconds_desc, p_parameterlist=>l_wf_parameter_list_t);
1830: wf_event.AddParameterToList(p_name=>'P_FULL_NAME', p_value=>l_person_name, p_parameterlist=>l_wf_parameter_list_t);
1831: wf_event.AddParameterToList(p_name=>'P_PERSON_NUMBER', p_value=>l_person_number, p_parameterlist=>l_wf_parameter_list_t);
1832: wf_event.AddParameterToList(p_name=>'P_USER_NAME', p_value=>l_user_name, p_parameterlist=>l_wf_parameter_list_t);
1833:
1834: -- raise the event
1835: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.prog.intm.rcond',
1836: p_event_key =>'INTMRCOND'||l_cur_seq_val.seq_val,

Line 1835: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.prog.intm.rcond',

1831: wf_event.AddParameterToList(p_name=>'P_PERSON_NUMBER', p_value=>l_person_number, p_parameterlist=>l_wf_parameter_list_t);
1832: wf_event.AddParameterToList(p_name=>'P_USER_NAME', p_value=>l_user_name, p_parameterlist=>l_wf_parameter_list_t);
1833:
1834: -- raise the event
1835: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.prog.intm.rcond',
1836: p_event_key =>'INTMRCOND'||l_cur_seq_val.seq_val,
1837: p_parameters=>l_wf_parameter_list_t);
1838: END IF;
1839: