APPS.FND_LOG_REPOSITORY dependencies on DUAL

Line 678: from dual;

674: exception
675: when no_data_found then
676: select fnd_log_unique_exception_s.nextval
677: into l_ex_id
678: from dual;
679:
680: insert into fnd_log_unique_exceptions (
681: UNIQUE_EXCEPTION_ID,
682: ENCODED_MESSAGE,

Line 987: from dual;

983: /* if ( AFLOG_BUFFER_MODE_X = 2 ) then */
984: -- Better to always do this so log_level>=4 messages are in sequence
985: select FND_LOG_MESSAGES_S.NEXTVAL
986: into LOG_SEQUENCE_TABLE(G_BUFFER_POS)
987: from dual;
988: /* end if; */
989:
990: TIMESTAMP_TABLE(G_BUFFER_POS) := SYSDATE;
991: MODULE_TABLE(G_BUFFER_POS) := MODULE;

Line 1423: from dual;

1419: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);
1420: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then
1421: select SYSDATE
1422: into FND_LOG_REPOSITORY.G_METRIC_DATE
1423: from dual;
1424: end if;
1425: else
1426: select SYSDATE
1427: into FND_LOG_REPOSITORY.G_METRIC_DATE

Line 1428: from dual;

1424: end if;
1425: else
1426: select SYSDATE
1427: into FND_LOG_REPOSITORY.G_METRIC_DATE
1428: from dual;
1429: end if;
1430:
1431: end METRIC_STRING_TO_DATE;
1432:

Line 1488: from dual;

1484: where audsid = TXN_SESSION;
1485:
1486: select FND_LOG_METRICS_S.NEXTVAL
1487: into l_metric_sequence
1488: from dual;
1489:
1490: if (METRIC_VALUE_STRING is NOT NULL) then
1491: l_type := 'S';
1492: elsif (METRIC_VALUE_NUMBER is NOT NULL) then

Line 1568: from dual;

1564: end if;
1565:
1566: select FND_METRICS_EVENT_KEY_S.nextval
1567: into l_event_key
1568: from dual;
1569:
1570: update FND_LOG_METRICS
1571: set EVENT_KEY = l_event_key
1572: where EVENT_KEY is NULL

Line 2027: from dual;

2023: end if;
2024:
2025: select FND_LOG_MESSAGES_S.NEXTVAL
2026: into LOG_SEQUENCE_OUT
2027: from dual;
2028:
2029: TIMESTAMP_OUT := sysdate;
2030: DBSESSIONID_OUT := TXN_SESSION;
2031: DBINSTANCE_OUT := TXN_INSTANCE;