DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on FND_GLOBAL

Line 5558: ,last_updated_by = fnd_global.user_id

5554: End If;
5555:
5556: UPDATE mtl_transaction_lots_interface
5557: SET status_id = l_mtli_status_id
5558: ,last_updated_by = fnd_global.user_id
5559: ,last_update_date = sysdate
5560: ,last_update_login = fnd_global.login_id
5561: ,request_id = fnd_global.conc_request_id
5562: ,program_application_id = fnd_global.prog_appl_id

Line 5560: ,last_update_login = fnd_global.login_id

5556: UPDATE mtl_transaction_lots_interface
5557: SET status_id = l_mtli_status_id
5558: ,last_updated_by = fnd_global.user_id
5559: ,last_update_date = sysdate
5560: ,last_update_login = fnd_global.login_id
5561: ,request_id = fnd_global.conc_request_id
5562: ,program_application_id = fnd_global.prog_appl_id
5563: ,program_id = fnd_global.conc_program_id
5564: ,program_update_date = Decode(fnd_global.conc_request_id, -1, NULL, SYSDATE)

Line 5561: ,request_id = fnd_global.conc_request_id

5557: SET status_id = l_mtli_status_id
5558: ,last_updated_by = fnd_global.user_id
5559: ,last_update_date = sysdate
5560: ,last_update_login = fnd_global.login_id
5561: ,request_id = fnd_global.conc_request_id
5562: ,program_application_id = fnd_global.prog_appl_id
5563: ,program_id = fnd_global.conc_program_id
5564: ,program_update_date = Decode(fnd_global.conc_request_id, -1, NULL, SYSDATE)
5565: WHERE ROWID = lots_rec.rowid;

Line 5562: ,program_application_id = fnd_global.prog_appl_id

5558: ,last_updated_by = fnd_global.user_id
5559: ,last_update_date = sysdate
5560: ,last_update_login = fnd_global.login_id
5561: ,request_id = fnd_global.conc_request_id
5562: ,program_application_id = fnd_global.prog_appl_id
5563: ,program_id = fnd_global.conc_program_id
5564: ,program_update_date = Decode(fnd_global.conc_request_id, -1, NULL, SYSDATE)
5565: WHERE ROWID = lots_rec.rowid;
5566:

Line 5563: ,program_id = fnd_global.conc_program_id

5559: ,last_update_date = sysdate
5560: ,last_update_login = fnd_global.login_id
5561: ,request_id = fnd_global.conc_request_id
5562: ,program_application_id = fnd_global.prog_appl_id
5563: ,program_id = fnd_global.conc_program_id
5564: ,program_update_date = Decode(fnd_global.conc_request_id, -1, NULL, SYSDATE)
5565: WHERE ROWID = lots_rec.rowid;
5566:
5567: IF (l_debug = 1) THEN

Line 5564: ,program_update_date = Decode(fnd_global.conc_request_id, -1, NULL, SYSDATE)

5560: ,last_update_login = fnd_global.login_id
5561: ,request_id = fnd_global.conc_request_id
5562: ,program_application_id = fnd_global.prog_appl_id
5563: ,program_id = fnd_global.conc_program_id
5564: ,program_update_date = Decode(fnd_global.conc_request_id, -1, NULL, SYSDATE)
5565: WHERE ROWID = lots_rec.rowid;
5566:
5567: IF (l_debug = 1) THEN
5568: inv_log_util.trace('After Update of MTLI', 'INV_TXN_MANAGER_GRP','1');

Line 11566: l_user_id := fnd_global.user_id;

11562:
11563: l_validation_status := 'Y';
11564: x_return_status := fnd_api.g_ret_sts_success;
11565: l_sysdate := SYSDATE;
11566: l_user_id := fnd_global.user_id;
11567: l_login_id := fnd_global.login_id;
11568:
11569: --bug 4574806. this will be used in the statements below for final
11570: --completion flag AS a decode

Line 11567: l_login_id := fnd_global.login_id;

11563: l_validation_status := 'Y';
11564: x_return_status := fnd_api.g_ret_sts_success;
11565: l_sysdate := SYSDATE;
11566: l_user_id := fnd_global.user_id;
11567: l_login_id := fnd_global.login_id;
11568:
11569: --bug 4574806. this will be used in the statements below for final
11570: --completion flag AS a decode
11571: IF (wip_constants.DMF_PATCHSET_LEVEL>=