APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on FND_OAM_DSCRAM_RUNS_PKG

Line 225: l_interval := FND_OAM_DSCRAM_RUNS_PKG.GET_VALID_CHECK_INTERVAL;

221: IF p_last_validated IS NULL THEN
222: RETURN TRUE;
223: END IF;
224:
225: l_interval := FND_OAM_DSCRAM_RUNS_PKG.GET_VALID_CHECK_INTERVAL;
226:
227: --allows the user to turn off status checking
228: IF l_interval IS NULL OR l_interval <= 0 THEN
229: RETURN FALSE;

Line 311: l_id := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID;

307: ELSE
308: fnd_oam_debug.log(1, l_ctxt, 'Skipping stopping bundle due to current status: '||l_current_status);
309: END IF;
310: ELSIF p_fatality_level = G_TYPE_RUN THEN
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

Line 355: RETURN G_DSCRAM_GLOBAL_PREFIX||to_char(FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID)||'_'||to_char(p_unit_id);

351: FUNCTION MAKE_AD_SCRIPT_KEY(p_unit_id IN NUMBER)
352: RETURN VARCHAR2
353: IS
354: BEGIN
355: RETURN G_DSCRAM_GLOBAL_PREFIX||to_char(FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID)||'_'||to_char(p_unit_id);
356: END;
357:
358: -- Helper to lock_run to provide the named lock's name
359: FUNCTION MAKE_RUN_LOCK_NAME(p_run_id IN NUMBER)

Line 941: l_mode := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE;

937: RETURN BOOLEAN
938: IS
939: l_mode VARCHAR2(30);
940: BEGIN
941: l_mode := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE;
942: IF l_mode IS NULL THEN
943: RETURN FALSE;
944: END IF;
945: RETURN l_mode = G_MODE_NORMAL;

Line 957: l_mode := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE;

953: RETURN BOOLEAN
954: IS
955: l_mode VARCHAR2(30);
956: BEGIN
957: l_mode := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE;
958: IF l_mode IS NULL THEN
959: RETURN FALSE;
960: END IF;
961: RETURN l_mode = G_MODE_DIAGNOSTIC;

Line 1067: l_progress_alert_name := MAKE_PROGRESS_ALERT_NAME(FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID);

1063: l_msg VARCHAR2(3);
1064: l_status INTEGER;
1065: l_wait NUMBER := B_PROGRESS_ALERT_MAX_WAIT;
1066: BEGIN
1067: l_progress_alert_name := MAKE_PROGRESS_ALERT_NAME(FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID);
1068: --register first
1069: DBMS_ALERT.REGISTER(l_progress_alert_name);
1070:
1071: --if we're in a mode where the work is very quuick, cut down the max end of run wait

Line 1072: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE IN (G_MODE_DIAGNOSTIC,

1068: --register first
1069: DBMS_ALERT.REGISTER(l_progress_alert_name);
1070:
1071: --if we're in a mode where the work is very quuick, cut down the max end of run wait
1072: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE IN (G_MODE_DIAGNOSTIC,
1073: G_MODE_TEST_NO_EXEC) THEN
1074: l_wait := B_PROGRESS_ALERT_DIAG_WAIT;
1075: END IF;
1076: DBMS_ALERT.WAITONE(l_progress_alert_name,

Line 1097: l_progress_alert_name := MAKE_PROGRESS_ALERT_NAME(FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID);

1093: l_ctxt VARCHAR2(60) := PKG_NAME||'SIGNAL_PROGRESS_ALERT';
1094:
1095: l_progress_alert_name VARCHAR2(30);
1096: BEGIN
1097: l_progress_alert_name := MAKE_PROGRESS_ALERT_NAME(FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_ID);
1098: DBMS_ALERT.SIGNAL(l_progress_alert_name,
1099: NULL);
1100: EXCEPTION
1101: WHEN OTHERS THEN