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_PARAMETER_LIST_T

Line 47: l_wf_parameter_list_t WF_PARAMETER_LIST_T:= wf_parameter_list_t();

43: SELECT igs_en_status_mail_req_s.nextval seq_val
44: FROM DUAL;
45:
46: l_cur_seq_val cur_seq_val%ROWTYPE;
47: l_wf_parameter_list_t WF_PARAMETER_LIST_T:= wf_parameter_list_t();
48: l_wf_installed fnd_lookups.lookup_code%TYPE;
49:
50: BEGIN
51: -- get the profile value that is set for checking if workflow is installed

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 69: p_parameters=>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:
72: END sua_status_change_mail;
73:

Line 104: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();

100: SELECT igs_en_inst_action_s.nextval seq_val
101: FROM DUAL;
102:
103: l_cur_seq_val cur_seq_val%ROWTYPE;
104: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();
105: l_wf_installed fnd_lookups.lookup_code%TYPE;
106:
107: BEGIN
108:

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

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:
134: END inform_stdnt_instruct_action;
135: PROCEDURE inform_instruct_stdnt_petition( p_student_id IN NUMBER,

Line 162: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();

158:
159: CURSOR cur_seq_val IS SELECT igs_en_stud_splperm_req_s.NEXTVAL seq_val FROM DUAL;
160:
161: l_cur_seq_val cur_seq_val%ROWTYPE;
162: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();
163: l_wf_installed fnd_lookups.lookup_code%TYPE;
164:
165: BEGIN
166:

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 187: p_parameters => 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;
190:
191:

Line 220: l_parameter_list_t wf_parameter_list_t;

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:
224: -- Gets a unique sequence number

Line 356: l_parameter_list_t wf_parameter_list_t;

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:
360: -- Gets a unique sequence number

Line 485: l_parameter_list_t wf_parameter_list_t;

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:
489: -- Gets a unique sequence number

Line 603: l_parameter_list_t wf_parameter_list_t;

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:
607: -- Gets a unique sequence number

Line 1580: l_parameter_list_t wf_parameter_list_t;

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:
1584: BEGIN

Line 1654: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

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,
1658: p_n_load_seq_num IN NUMBER) IS

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 1762: p_parameters => l_wf_parameter_list_t

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: );
1764: EXCEPTION
1765: WHEN OTHERS THEN
1766: ROLLBACK;

Line 1804: l_wf_parameter_list_t WF_PARAMETER_LIST_T:= wf_parameter_list_t();

1800: l_person_name hz_parties.party_name%TYPE;
1801: l_user_name fnd_user.user_name%TYPE;
1802:
1803: l_cur_seq_val cur_seq_val%ROWTYPE;
1804: l_wf_parameter_list_t WF_PARAMETER_LIST_T:= wf_parameter_list_t();
1805: l_wf_installed fnd_lookups.lookup_code%TYPE;
1806:
1807: BEGIN
1808: -- get the profile value that is set for checking if workflow is installed

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 1837: p_parameters=>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:
1840: END raise_spi_rcond_event;
1841: