567:
568: UPDATE po_requisition_headers_all
569: SET preparer_id = p_new_personid,
570: last_update_date = sysdate,
571: last_updated_by = fnd_global.user_id,
572: last_update_login = fnd_global.login_id
573: WHERE rowid = l_req_rowid;
574:
575: l_progress := '005';
568: UPDATE po_requisition_headers_all
569: SET preparer_id = p_new_personid,
570: last_update_date = sysdate,
571: last_updated_by = fnd_global.user_id,
572: last_update_login = fnd_global.login_id
573: WHERE rowid = l_req_rowid;
574:
575: l_progress := '005';
576:
1443: requester_email = l_requester_email,-- Bug 14153104
1444: requester_phone = l_requester_phone,
1445: requester_fax = l_requester_fax,
1446: last_update_date = sysdate,
1447: last_updated_by = fnd_global.user_id,
1448: last_update_login = fnd_global.login_id
1449: WHERE rowid = l_req_rowid;
1450:
1451:
1444: requester_phone = l_requester_phone,
1445: requester_fax = l_requester_fax,
1446: last_update_date = sysdate,
1447: last_updated_by = fnd_global.user_id,
1448: last_update_login = fnd_global.login_id
1449: WHERE rowid = l_req_rowid;
1450:
1451:
1452: l_progress := '005';