DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_RUNS_PKG dependencies on FND_OAM_DSCRAM_RUNS_B

Line 136: FROM fnd_oam_dscram_runs_b

132:
133: CURSOR C1
134: IS
135: SELECT run_status, target_dbname
136: FROM fnd_oam_dscram_runs_b
137: WHERE run_id = p_run_id;
138: BEGIN
139: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
140: x_return_status := FND_API.G_RET_STS_ERROR;

Line 224: FROM fnd_oam_dscram_runs_b

220:
221: CURSOR C1
222: IS
223: SELECT run_status
224: FROM fnd_oam_dscram_runs_b
225: WHERE run_id = b_run_info.run_id;
226: BEGIN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: x_return_msg := '';

Line 306: FROM fnd_oam_dscram_runs_b

302:
303: CURSOR C1
304: IS
305: SELECT last_run_stat_id, valid_check_interval, run_mode
306: FROM fnd_oam_dscram_runs_b
307: WHERE run_id = p_run_id;
308: CURSOR C2(c_stat_id NUMBER)
309: IS
310: SELECT 1

Line 377: from FND_OAM_DSCRAM_RUNS_B B

373:
374: delete from FND_OAM_DSCRAM_RUNS_TL T
375: where not exists
376: (select NULL
377: from FND_OAM_DSCRAM_RUNS_B B
378: where B.RUN_ID = T.RUN_ID
379: );
380:
381: update FND_OAM_DSCRAM_RUNS_TL T set (