APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_OAM_DSCRAM_RUNS_B

Line 579: FROM fnd_oam_dscram_runs_b

575:
576: --query out all runs in the diagnostic space
577: SELECT run_id
578: BULK COLLECT INTO l_ids
579: FROM fnd_oam_dscram_runs_b
580: WHERE run_id between 0 and 999;
581:
582: IF SQL%NOTFOUND THEN
583: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 1695: INSERT INTO FND_OAM_DSCRAM_RUNS_B (RUN_ID,

1691: INTO l_dbname
1692: FROM v$database
1693: WHERE rownum < 2;
1694:
1695: INSERT INTO FND_OAM_DSCRAM_RUNS_B (RUN_ID,
1696: RUN_STATUS,
1697: RUN_MODE,
1698: TARGET_DBNAME,
1699: WEIGHT,

Line 1756: UPDATE fnd_oam_dscram_runs_b

1752: RETURN FALSE;
1753: END IF;
1754:
1755: --update the run with this run stat id
1756: UPDATE fnd_oam_dscram_runs_b
1757: SET last_run_stat_id = l_run_stat_id
1758: WHERE run_id = p_run_id;
1759:
1760: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 2050: FROM fnd_oam_dscram_runs_b

2046: --after getting the lock, see if the run's there
2047: BEGIN
2048: SELECT 1
2049: INTO l_retval
2050: FROM fnd_oam_dscram_runs_b
2051: WHERE run_id = p_run_id;
2052:
2053: --select suceeded, release and return
2054: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);

Line 3783: FROM fnd_oam_dscram_runs_b

3779: --query out the run with this run_id, also validate run_mode
3780: BEGIN
3781: SELECT run_mode
3782: INTO l_run_mode
3783: FROM fnd_oam_dscram_runs_b
3784: WHERE run_id = p_run_id;
3785: EXCEPTION
3786: WHEN no_data_found THEN
3787: x_return_msg := 'Failed to query run for run_id: '||p_run_id;