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

APPS.IGS_AS_CGR_WF_PKG dependencies on WF_ENGINE

Line 21: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (

17: resultout OUT NOCOPY VARCHAR2
18: ) IS
19: l_api_name CONSTANT VARCHAR2 (30) := 'Select_Approver';
20: l_return_status VARCHAR2 (1);
21: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (
22: itemtype,
23: itemkey,
24: 'UOO_ID'
25: );

Line 26: l_requester_id NUMBER (15) := wf_engine.getitemattrtext (

22: itemtype,
23: itemkey,
24: 'UOO_ID'
25: );
26: l_requester_id NUMBER (15) := wf_engine.getitemattrtext (
27: itemtype,
28: itemkey,
29: 'REQUESTER_ID'
30: );

Line 55: wf_engine.setitemattrtext (itemtype, itemkey, 'REQUESTER_USER_NAME', l_user_name_req);

51: BEGIN
52: OPEN cur_user (l_requester_id);
53: FETCH cur_user INTO l_user_name_req;
54: CLOSE cur_user;
55: wf_engine.setitemattrtext (itemtype, itemkey, 'REQUESTER_USER_NAME', l_user_name_req);
56: EXCEPTION
57: WHEN NO_DATA_FOUND THEN
58: resultout := 'FAILURE';
59: RETURN;

Line 66: wf_engine.setitemattrtext (itemtype, itemkey, 'TO_USER_ID', l_instructor_id);

62: BEGIN
63: OPEN cur_instruct (l_uoo_id);
64: FETCH cur_instruct INTO l_instructor_id;
65: CLOSE cur_instruct;
66: wf_engine.setitemattrtext (itemtype, itemkey, 'TO_USER_ID', l_instructor_id);
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: resultout := 'FAILURE';
70: RETURN;

Line 77: wf_engine.setitemattrtext (itemtype, itemkey, 'TO_USER', l_user_name_app);

73: BEGIN
74: OPEN cur_user1 (l_instructor_id);
75: FETCH cur_user1 INTO l_user_name_app;
76: CLOSE cur_user1;
77: wf_engine.setitemattrtext (itemtype, itemkey, 'TO_USER', l_user_name_app);
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN
80: resultout := 'FAILURE';
81: RETURN;

Line 126: l_person_id NUMBER (15) := wf_engine.getitemattrtext (

122: l_api_name CONSTANT VARCHAR2 (30) := 'Approve_Request';
123: l_return_status VARCHAR2 (1);
124: l_rowid VARCHAR2 (25);
125: l_org_id igs_as_su_stmptout.org_id%TYPE;
126: l_person_id NUMBER (15) := wf_engine.getitemattrtext (
127: itemtype,
128: itemkey,
129: 'PERSON_ID'
130: );

Line 131: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (

127: itemtype,
128: itemkey,
129: 'PERSON_ID'
130: );
131: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (
132: itemtype,
133: itemkey,
134: 'UNIT_CODE'
135: );

Line 136: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (

132: itemtype,
133: itemkey,
134: 'UNIT_CODE'
135: );
136: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (
137: itemtype,
138: itemkey,
139: 'COURSE_CD'
140: );

Line 141: l_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (

137: itemtype,
138: itemkey,
139: 'COURSE_CD'
140: );
141: l_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (
142: itemtype,
143: itemkey,
144: 'CAL_TYPE'
145: );

Line 146: l_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (

142: itemtype,
143: itemkey,
144: 'CAL_TYPE'
145: );
146: l_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
147: itemtype,
148: itemkey,
149: 'CI_SEQUENCE_NUMBER'
150: );

Line 151: l_ci_start_dt DATE := wf_engine.getitemattrtext (

147: itemtype,
148: itemkey,
149: 'CI_SEQUENCE_NUMBER'
150: );
151: l_ci_start_dt DATE := wf_engine.getitemattrtext (
152: itemtype,
153: itemkey,
154: 'CI_START_DT'
155: );

Line 156: l_ci_end_dt DATE := wf_engine.getitemattrtext (

152: itemtype,
153: itemkey,
154: 'CI_START_DT'
155: );
156: l_ci_end_dt DATE := wf_engine.getitemattrtext (
157: itemtype,
158: itemkey,
159: 'CI_END_DT'
160: );

Line 161: l_grading_schema VARCHAR2 (10) := wf_engine.getitemattrtext (

157: itemtype,
158: itemkey,
159: 'CI_END_DT'
160: );
161: l_grading_schema VARCHAR2 (10) := wf_engine.getitemattrtext (
162: itemtype,
163: itemkey,
164: 'GRADING_SCHEMA'
165: );

Line 166: l_change_grade_version_num NUMBER (6) := wf_engine.getitemattrtext (

162: itemtype,
163: itemkey,
164: 'GRADING_SCHEMA'
165: );
166: l_change_grade_version_num NUMBER (6) := wf_engine.getitemattrtext (
167: itemtype,
168: itemkey,
169: 'CHANGE_GRADE_VERSION_NUM'
170: );

Line 171: l_change_grade VARCHAR2 (5) := wf_engine.getitemattrtext (

167: itemtype,
168: itemkey,
169: 'CHANGE_GRADE_VERSION_NUM'
170: );
171: l_change_grade VARCHAR2 (5) := wf_engine.getitemattrtext (
172: itemtype,
173: itemkey,
174: 'CHANGE_GRADE'
175: );

Line 176: l_change_mark NUMBER (6, 3) := wf_engine.getitemattrtext (

172: itemtype,
173: itemkey,
174: 'CHANGE_GRADE'
175: );
176: l_change_mark NUMBER (6, 3) := wf_engine.getitemattrtext (
177: itemtype,
178: itemkey,
179: 'CHANGE_MARK'
180: );

Line 181: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (

177: itemtype,
178: itemkey,
179: 'CHANGE_MARK'
180: );
181: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (
182: itemtype,
183: itemkey,
184: 'TEACH_CAL_TYPE'
185: );

Line 186: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (

182: itemtype,
183: itemkey,
184: 'TEACH_CAL_TYPE'
185: );
186: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
187: itemtype,
188: itemkey,
189: 'TEACH_CI_SEQUENCE_NUMBER'
190: );

Line 191: l_request_date DATE := wf_engine.getitemattrtext (

187: itemtype,
188: itemkey,
189: 'TEACH_CI_SEQUENCE_NUMBER'
190: );
191: l_request_date DATE := wf_engine.getitemattrtext (
192: itemtype,
193: itemkey,
194: 'REQUEST_DATE'
195: );

Line 196: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (

192: itemtype,
193: itemkey,
194: 'REQUEST_DATE'
195: );
196: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (
197: itemtype,
198: itemkey,
199: 'UOO_ID'
200: );

Line 201: l_grading_period_cd VARCHAR2 (30) := wf_engine.getitemattrtext (

197: itemtype,
198: itemkey,
199: 'UOO_ID'
200: );
201: l_grading_period_cd VARCHAR2 (30) := wf_engine.getitemattrtext (
202: itemtype,
203: itemkey,
204: 'GRADING_PERIOD_CD'
205: );

Line 206: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (

202: itemtype,
203: itemkey,
204: 'GRADING_PERIOD_CD'
205: );
206: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (
207: itemtype,
208: itemkey,
209: 'TO_USER_ID'
210: );

Line 211: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (

207: itemtype,
208: itemkey,
209: 'TO_USER_ID'
210: );
211: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (
212: itemtype,
213: itemkey,
214: 'WF_NOTE'
215: );

Line 337: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');

333: resultout OUT NOCOPY VARCHAR2
334: ) IS
335: l_api_name CONSTANT VARCHAR2 (30) := 'Reject_Request';
336: l_return_status VARCHAR2 (1);
337: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
338: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
339: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
340: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
341: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (

Line 338: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');

334: ) IS
335: l_api_name CONSTANT VARCHAR2 (30) := 'Reject_Request';
336: l_return_status VARCHAR2 (1);
337: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
338: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
339: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
340: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
341: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
342: itemtype,

Line 339: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');

335: l_api_name CONSTANT VARCHAR2 (30) := 'Reject_Request';
336: l_return_status VARCHAR2 (1);
337: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
338: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
339: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
340: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
341: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
342: itemtype,
343: itemkey,

Line 340: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');

336: l_return_status VARCHAR2 (1);
337: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
338: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
339: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
340: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
341: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
342: itemtype,
343: itemkey,
344: 'TEACH_CI_SEQUENCE_NUMBER'

Line 341: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (

337: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
338: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
339: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
340: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
341: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
342: itemtype,
343: itemkey,
344: 'TEACH_CI_SEQUENCE_NUMBER'
345: );

Line 346: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');

342: itemtype,
343: itemkey,
344: 'TEACH_CI_SEQUENCE_NUMBER'
345: );
346: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');
347: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');
348: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');
349: -- anilk, 22-Apr-2003, Bug# 2829262
350: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');

Line 347: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');

343: itemkey,
344: 'TEACH_CI_SEQUENCE_NUMBER'
345: );
346: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');
347: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');
348: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');
349: -- anilk, 22-Apr-2003, Bug# 2829262
350: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');
351: BEGIN

Line 348: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');

344: 'TEACH_CI_SEQUENCE_NUMBER'
345: );
346: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');
347: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');
348: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');
349: -- anilk, 22-Apr-2003, Bug# 2829262
350: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');
351: BEGIN
352: SAVEPOINT reject_request;

Line 350: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');

346: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');
347: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');
348: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');
349: -- anilk, 22-Apr-2003, Bug# 2829262
350: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');
351: BEGIN
352: SAVEPOINT reject_request;
353: /**************************Start : Updating Change Grade Request Table *********************/
354: UPDATE igs_as_chn_grd_req

Line 385: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');

381: resultout OUT NOCOPY VARCHAR2
382: ) IS
383: l_api_name CONSTANT VARCHAR2 (30) := 'Need_Information';
384: l_return_status VARCHAR2 (1);
385: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
386: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
387: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
388: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
389: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (

Line 386: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');

382: ) IS
383: l_api_name CONSTANT VARCHAR2 (30) := 'Need_Information';
384: l_return_status VARCHAR2 (1);
385: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
386: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
387: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
388: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
389: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
390: itemtype,

Line 387: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');

383: l_api_name CONSTANT VARCHAR2 (30) := 'Need_Information';
384: l_return_status VARCHAR2 (1);
385: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
386: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
387: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
388: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
389: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
390: itemtype,
391: itemkey,

Line 388: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');

384: l_return_status VARCHAR2 (1);
385: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
386: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
387: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
388: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
389: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
390: itemtype,
391: itemkey,
392: 'TEACH_CI_SEQUENCE_NUMBER'

Line 389: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (

385: l_person_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'PERSON_ID');
386: l_unit_code VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'UNIT_CODE');
387: l_course_cd VARCHAR2 (6) := wf_engine.getitemattrtext (itemtype, itemkey, 'COURSE_CD');
388: l_teach_cal_type VARCHAR2 (10) := wf_engine.getitemattrtext (itemtype, itemkey, 'TEACH_CAL_TYPE');
389: l_teach_ci_sequence_number NUMBER (6) := wf_engine.getitemattrtext (
390: itemtype,
391: itemkey,
392: 'TEACH_CI_SEQUENCE_NUMBER'
393: );

Line 394: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');

390: itemtype,
391: itemkey,
392: 'TEACH_CI_SEQUENCE_NUMBER'
393: );
394: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');
395: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');
396: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');
397: -- anilk, 22-Apr-2003, Bug# 2829262
398: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');

Line 395: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');

391: itemkey,
392: 'TEACH_CI_SEQUENCE_NUMBER'
393: );
394: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');
395: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');
396: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');
397: -- anilk, 22-Apr-2003, Bug# 2829262
398: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');
399: BEGIN

Line 396: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');

392: 'TEACH_CI_SEQUENCE_NUMBER'
393: );
394: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');
395: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');
396: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');
397: -- anilk, 22-Apr-2003, Bug# 2829262
398: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');
399: BEGIN
400: SAVEPOINT need_information;

Line 398: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');

394: l_request_date DATE := wf_engine.getitemattrtext (itemtype, itemkey, 'REQUEST_DATE');
395: l_approver_id NUMBER (15) := wf_engine.getitemattrtext (itemtype, itemkey, 'TO_USER_ID');
396: l_comment VARCHAR2 (360) := wf_engine.getitemattrtext (itemtype, itemkey, 'WF_NOTE');
397: -- anilk, 22-Apr-2003, Bug# 2829262
398: l_uoo_id NUMBER (7) := wf_engine.getitemattrtext (itemtype, itemkey, 'UOO_ID');
399: BEGIN
400: SAVEPOINT need_information;
401: /**************************Start : Updating Change Grade Request Table *************************/
402: UPDATE igs_as_chn_grd_req