132: SET authorization_status = nvl(X_authorization_status, authorization_status),
133: closed_code = nvl(X_closed_code, closed_code),
134: contractor_status = decode(X_authorization_status,'CANCELLED',null,
135: contractor_status), -- Bug 3495679
136: last_update_login = fnd_global.login_id,
137: last_updated_by = fnd_global.user_id,
138: last_update_date = sysdate
139: WHERE requisition_header_id = X_req_header_id;
140: END IF;
133: closed_code = nvl(X_closed_code, closed_code),
134: contractor_status = decode(X_authorization_status,'CANCELLED',null,
135: contractor_status), -- Bug 3495679
136: last_update_login = fnd_global.login_id,
137: last_updated_by = fnd_global.user_id,
138: last_update_date = sysdate
139: WHERE requisition_header_id = X_req_header_id;
140: END IF;
141: