DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE dependencies on FND_GLOBAL

Line 232: last_updated_by = fnd_global.user_id,

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.

Line 233: last_update_login = fnd_global.login_id

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:

Line 242: last_updated_by = fnd_global.user_id,

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

Line 243: last_update_login = fnd_global.login_id

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

Line 377: last_updated_by = fnd_global.user_id,

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.

Line 378: last_update_login = fnd_global.login_id

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

Line 386: last_updated_by = fnd_global.user_id,

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:

Line 387: last_update_login = fnd_global.login_id

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