228: */
229: update po_headers_all
230: set agent_id = x_new_buyer_id,
231: last_update_date = sysdate,
232: last_updated_by = fnd_global.user_id,
233: last_update_login = fnd_global.login_id
234: where rowid = x_po_rowid;
235:
236: --Bug 8551445, update archive also.
229: update po_headers_all
230: set agent_id = x_new_buyer_id,
231: last_update_date = sysdate,
232: last_updated_by = fnd_global.user_id,
233: last_update_login = fnd_global.login_id
234: where rowid = x_po_rowid;
235:
236: --Bug 8551445, update archive also.
237:
238: BEGIN
239: UPDATE po_headers_archive_all
240: SET agent_id = x_new_buyer_id,
241: last_update_date = sysdate,
242: last_updated_by = fnd_global.user_id,
243: last_update_login = fnd_global.login_id
244: WHERE po_header_id=l_document_id
245: AND latest_external_flag= 'Y';
246: EXCEPTION
239: UPDATE po_headers_archive_all
240: SET agent_id = x_new_buyer_id,
241: last_update_date = sysdate,
242: last_updated_by = fnd_global.user_id,
243: last_update_login = fnd_global.login_id
244: WHERE po_header_id=l_document_id
245: AND latest_external_flag= 'Y';
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
373: */
374: update po_releases_all
375: set agent_id = x_new_buyer_id,
376: last_update_date = sysdate,
377: last_updated_by = fnd_global.user_id,
378: last_update_login = fnd_global.login_id
379: where rowid = x_rel_rowid;
380:
381: --Bug 8551445, update archive also.
374: update po_releases_all
375: set agent_id = x_new_buyer_id,
376: last_update_date = sysdate,
377: last_updated_by = fnd_global.user_id,
378: last_update_login = fnd_global.login_id
379: where rowid = x_rel_rowid;
380:
381: --Bug 8551445, update archive also.
382: BEGIN
382: BEGIN
383: UPDATE po_releases_archive_all
384: SET agent_id = x_new_buyer_id,
385: last_update_date = sysdate,
386: last_updated_by = fnd_global.user_id,
387: last_update_login = fnd_global.login_id
388: WHERE po_release_id=l_document_id
389: AND latest_external_flag= 'Y';
390:
383: UPDATE po_releases_archive_all
384: SET agent_id = x_new_buyer_id,
385: last_update_date = sysdate,
386: last_updated_by = fnd_global.user_id,
387: last_update_login = fnd_global.login_id
388: WHERE po_release_id=l_document_id
389: AND latest_external_flag= 'Y';
390:
391: EXCEPTION