APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on DBMS_ALERT

Line 1069: DBMS_ALERT.REGISTER(l_progress_alert_name);

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
1072: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE IN (G_MODE_DIAGNOSTIC,
1073: G_MODE_TEST_NO_EXEC) THEN

Line 1076: DBMS_ALERT.WAITONE(l_progress_alert_name,

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,
1077: l_msg,
1078: l_status,
1079: l_wait);
1080: --ignore the message and status, we just want the notification

Line 1098: DBMS_ALERT.SIGNAL(l_progress_alert_name,

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
1102: --log it but don't throw it since this is only to help minimize delay