663:
664: UPDATE po_headers_all
665: SET agent_id = p_new_personid,
666: last_update_date = sysdate,
667: last_updated_by = fnd_global.user_id,
668: last_update_login = fnd_global.login_id
669: WHERE rowid = l_po_rowid;
670:
671: --Bug 8846315, update archive also.
664: UPDATE po_headers_all
665: SET agent_id = p_new_personid,
666: last_update_date = sysdate,
667: last_updated_by = fnd_global.user_id,
668: last_update_login = fnd_global.login_id
669: WHERE rowid = l_po_rowid;
670:
671: --Bug 8846315, update archive also.
672: UPDATE po_headers_archive_all
671: --Bug 8846315, update archive also.
672: UPDATE po_headers_archive_all
673: SET agent_id = p_new_personid,
674: last_update_date = sysdate,
675: last_updated_by = fnd_global.user_id,
676: last_update_login = fnd_global.login_id
677: WHERE po_header_id=l_document_id
678: AND latest_external_flag= 'Y';
679: EXCEPTION
672: UPDATE po_headers_archive_all
673: SET agent_id = p_new_personid,
674: last_update_date = sysdate,
675: last_updated_by = fnd_global.user_id,
676: last_update_login = fnd_global.login_id
677: WHERE po_header_id=l_document_id
678: AND latest_external_flag= 'Y';
679: EXCEPTION
680: WHEN NO_DATA_FOUND THEN
1070: BEGIN
1071: UPDATE po_releases_all
1072: SET agent_id = p_new_personid,
1073: last_update_date = sysdate,
1074: last_updated_by = fnd_global.user_id,
1075: last_update_login = fnd_global.login_id
1076: WHERE rowid = l_rel_rowid;
1077: --Bug 8846315, update archive also.
1078:
1071: UPDATE po_releases_all
1072: SET agent_id = p_new_personid,
1073: last_update_date = sysdate,
1074: last_updated_by = fnd_global.user_id,
1075: last_update_login = fnd_global.login_id
1076: WHERE rowid = l_rel_rowid;
1077: --Bug 8846315, update archive also.
1078:
1079: UPDATE po_releases_archive_all
1078:
1079: UPDATE po_releases_archive_all
1080: SET agent_id = p_new_personid,
1081: last_update_date = sysdate,
1082: last_updated_by = fnd_global.user_id,
1083: last_update_login = fnd_global.login_id
1084: WHERE po_release_id=l_document_id
1085: AND latest_external_flag= 'Y';
1086:
1079: UPDATE po_releases_archive_all
1080: SET agent_id = p_new_personid,
1081: last_update_date = sysdate,
1082: last_updated_by = fnd_global.user_id,
1083: last_update_login = fnd_global.login_id
1084: WHERE po_release_id=l_document_id
1085: AND latest_external_flag= 'Y';
1086:
1087: EXCEPTION
2180:
2181: UPDATE po_distributions_all
2182: SET deliver_to_person_id = p_new_personid,
2183: last_update_date = sysdate,
2184: last_updated_by = fnd_global.user_id,
2185: last_update_login = fnd_global.login_id
2186: WHERE rowid = l_po_rowid
2187: AND po_release_id IS NULL;
2188:
2181: UPDATE po_distributions_all
2182: SET deliver_to_person_id = p_new_personid,
2183: last_update_date = sysdate,
2184: last_updated_by = fnd_global.user_id,
2185: last_update_login = fnd_global.login_id
2186: WHERE rowid = l_po_rowid
2187: AND po_release_id IS NULL;
2188:
2189:
2390:
2391: UPDATE po_distributions_all
2392: SET deliver_to_person_id = p_new_personid,
2393: last_update_date = sysdate,
2394: last_updated_by = fnd_global.user_id,
2395: last_update_login = fnd_global.login_id
2396: WHERE rowid = l_rel_rowid;
2397:
2398: l_progress := '007';
2391: UPDATE po_distributions_all
2392: SET deliver_to_person_id = p_new_personid,
2393: last_update_date = sysdate,
2394: last_updated_by = fnd_global.user_id,
2395: last_update_login = fnd_global.login_id
2396: WHERE rowid = l_rel_rowid;
2397:
2398: l_progress := '007';
2399: