APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on FND_OAM_DSCRAM_RUNS_B

Line 315: FROM fnd_oam_dscram_runs_b

311: l_id := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID;
312: fnd_oam_debug.log(1, l_ctxt, 'Attempting to stop Run ID: '||l_id);
313: SELECT run_status
314: INTO l_current_status
315: FROM fnd_oam_dscram_runs_b
316: WHERE run_id = l_id
317: FOR UPDATE;
318:
319: IF STATUS_IS_PROCESSING(l_current_status) THEN

Line 320: UPDATE fnd_oam_dscram_runs_b

316: WHERE run_id = l_id
317: FOR UPDATE;
318:
319: IF STATUS_IS_PROCESSING(l_current_status) THEN
320: UPDATE fnd_oam_dscram_runs_b
321: SET run_status = G_STATUS_STOPPING,
322: last_updated_by = fnd_global.user_id,
323: last_update_login = fnd_global.user_id,
324: last_update_date = SYSDATE

Line 901: DELETE FROM fnd_oam_dscram_runs_b

897: p_run_id);
898:
899: --delete the actual run
900: fnd_oam_debug.log(1, l_ctxt, 'Deleting entity...');
901: DELETE FROM fnd_oam_dscram_runs_b
902: WHERE run_id = p_run_id;
903: DELETE FROM fnd_oam_dscram_runs_tl
904: WHERE run_id = p_run_id;
905:

Line 916: FROM fnd_oam_dscram_runs_b;

912: END IF;
913:
914: SELECT count(*)
915: INTO k
916: FROM fnd_oam_dscram_runs_b;
917: fnd_oam_debug.log(1, l_ctxt, 'Found '||k||' remaining base run rows.');
918: SELECT count(*)
919: INTO k
920: FROM fnd_oam_dscram_runs_tl;

Line 1604: UPDATE fnd_oam_dscram_runs_b

1600: END IF;
1601:
1602: --and finally update the local entities
1603: FORALL k in p_run_ids.FIRST..p_run_ids.LAST
1604: UPDATE fnd_oam_dscram_runs_b
1605: SET run_status = G_STATUS_RESTARTABLE
1606: WHERE run_id = p_run_ids(k)
1607: AND run_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);
1608:

Line 1644: FROM fnd_oam_dscram_runs_b

1640:
1641: --make sure the run's in a state where we can retry it
1642: SELECT run_status
1643: INTO l_status
1644: FROM fnd_oam_dscram_runs_b
1645: WHERE run_id = p_run_id;
1646:
1647: IF l_status NOT IN (G_STATUS_STOPPED, G_STATUS_ERROR_UNKNOWN, G_STATUS_ERROR_FATAL) THEN
1648: RAISE_APPLICATION_ERROR(-20000, 'Run is in an invalid status('||l_status||') and cannot be retried.');

Line 1665: UPDATE fnd_oam_dscram_runs_b

1661: FND_API.G_TRUE);
1662: END IF;
1663:
1664: --update the run
1665: UPDATE fnd_oam_dscram_runs_b
1666: SET run_status = G_STATUS_RESTARTABLE
1667: WHERE run_id = p_run_id;
1668:
1669: --release the lock on the run