DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on FND_GLOBAL

Line 667: last_updated_by = fnd_global.user_id,

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.

Line 668: last_update_login = fnd_global.login_id

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

Line 675: last_updated_by = fnd_global.user_id,

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

Line 676: last_update_login = fnd_global.login_id

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

Line 1074: last_updated_by = fnd_global.user_id,

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:

Line 1075: last_update_login = fnd_global.login_id

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

Line 1082: last_updated_by = fnd_global.user_id,

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:

Line 1083: last_update_login = fnd_global.login_id

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

Line 2184: last_updated_by = fnd_global.user_id,

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:

Line 2185: last_update_login = fnd_global.login_id

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:

Line 2394: last_updated_by = fnd_global.user_id,

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';

Line 2395: last_update_login = fnd_global.login_id

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: