DBA Data[Home] [Help]

APPS.IGS_AS_CGR_WF_PKG dependencies on IGS_AS_CHN_GRD_REQ

Line 226: UPDATE igs_as_chn_grd_req

222:
223: IF (funcmode = 'RUN') THEN
224: l_sysdate := SYSDATE;
225: /**************************Updating Change Grade Request Table *************************/
226: UPDATE igs_as_chn_grd_req
227: SET current_status = 'APPROVED',
228: approver_id = l_approver_id,
229: approver_date = l_sysdate,
230: approver_comments = l_comment

Line 354: UPDATE igs_as_chn_grd_req

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
355: SET current_status = 'REJECTED',
356: approver_id = l_approver_id,
357: approver_date = SYSDATE,
358: approver_comments = l_comment

Line 402: UPDATE igs_as_chn_grd_req

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
403: SET current_status = 'NEED MORE INFO',
404: approver_id = l_approver_id,
405: approver_date = SYSDATE,
406: approver_comments = l_comment