DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_PLSQLS_PKG dependencies on FND_GLOBAL

Line 387: last_updated_by = fnd_global.user_id,

383:
384: --update the plsql
385: UPDATE fnd_oam_dscram_plsqls
386: SET finished_ret_sts = l_finished_ret_sts,
387: last_updated_by = fnd_global.user_id,
388: last_update_login = fnd_global.user_id,
389: last_update_date = SYSDATE
390: WHERE plsql_id = p_plsql_id;
391:

Line 388: last_update_login = fnd_global.user_id,

384: --update the plsql
385: UPDATE fnd_oam_dscram_plsqls
386: SET finished_ret_sts = l_finished_ret_sts,
387: last_updated_by = fnd_global.user_id,
388: last_update_login = fnd_global.user_id,
389: last_update_date = SYSDATE
390: WHERE plsql_id = p_plsql_id;
391:
392: --dump a stats row as well

Line 492: last_updated_by = fnd_global.user_id,

488: --store this string as the final text
489: UPDATE fnd_oam_dscram_plsqls
490: SET plsql_final_text = l_final_plsql_text,
491: stats_finished = FND_API.G_FALSE,
492: last_updated_by = fnd_global.user_id,
493: last_update_login = fnd_global.user_id,
494: last_update_date = SYSDATE
495: WHERE plsql_id = p_plsql_id;
496:

Line 493: last_update_login = fnd_global.user_id,

489: UPDATE fnd_oam_dscram_plsqls
490: SET plsql_final_text = l_final_plsql_text,
491: stats_finished = FND_API.G_FALSE,
492: last_updated_by = fnd_global.user_id,
493: last_update_login = fnd_global.user_id,
494: last_update_date = SYSDATE
495: WHERE plsql_id = p_plsql_id;
496:
497: --commit the autonomous txn to release the lock