DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_DMLS_PKG dependencies on FND_GLOBAL

Line 405: last_updated_by = fnd_global.user_id,

401:
402: --always update the number of rows processed
403: UPDATE fnd_oam_dscram_dmls
404: SET rows_processed = NVL(rows_processed, 0) + l_rows_processed, --needed since its different for each dml and not stored in AD
405: last_updated_by = fnd_global.user_id,
406: last_update_login = fnd_global.user_id,
407: last_update_date = SYSDATE
408: WHERE dml_id = p_dml_id;
409:

Line 406: last_update_login = fnd_global.user_id,

402: --always update the number of rows processed
403: UPDATE fnd_oam_dscram_dmls
404: SET rows_processed = NVL(rows_processed, 0) + l_rows_processed, --needed since its different for each dml and not stored in AD
405: last_updated_by = fnd_global.user_id,
406: last_update_login = fnd_global.user_id,
407: last_update_date = SYSDATE
408: WHERE dml_id = p_dml_id;
409:
410: --exit without committing, leave that to the parent

Line 518: last_updated_by = fnd_global.user_id,

514: --store this string as the final stmt
515: UPDATE fnd_oam_dscram_dmls
516: SET dml_final_stmt = l_final_dml_stmt,
517: stats_finished = FND_API.G_FALSE,
518: last_updated_by = fnd_global.user_id,
519: last_update_login = fnd_global.user_id,
520: last_update_date = SYSDATE
521: WHERE dml_id = p_dml_id;
522:

Line 519: last_update_login = fnd_global.user_id,

515: UPDATE fnd_oam_dscram_dmls
516: SET dml_final_stmt = l_final_dml_stmt,
517: stats_finished = FND_API.G_FALSE,
518: last_updated_by = fnd_global.user_id,
519: last_update_login = fnd_global.user_id,
520: last_update_date = SYSDATE
521: WHERE dml_id = p_dml_id;
522:
523: --commit the autonomous txn to release the lock