APPS.FND_LOG_REPOSITORY dependencies on DUAL

Line 700: from dual;

696: exception
697: when no_data_found then
698: select fnd_log_unique_exception_s.nextval
699: into l_ex_id
700: from dual;
701:
702: insert into fnd_log_unique_exceptions (
703: UNIQUE_EXCEPTION_ID,
704: ENCODED_MESSAGE,

Line 1009: from dual;

1005: /* if ( AFLOG_BUFFER_MODE_X = 2 ) then */
1006: -- Better to always do this so log_level>=4 messages are in sequence
1007: select FND_LOG_MESSAGES_S.NEXTVAL
1008: into LOG_SEQUENCE_TABLE(G_BUFFER_POS)
1009: from dual;
1010: /* end if; */
1011:
1012: TIMESTAMP_TABLE(G_BUFFER_POS) := SYSDATE;
1013: MODULE_TABLE(G_BUFFER_POS) := MODULE;

Line 1445: from dual;

1441: FND_LOG_REPOSITORY.G_METRIC_DATE := FND_CONC_DATE.STRING_TO_DATE(DATE_VC);
1442: if (FND_LOG_REPOSITORY.G_METRIC_DATE IS NULL) then
1443: select SYSDATE
1444: into FND_LOG_REPOSITORY.G_METRIC_DATE
1445: from dual;
1446: end if;
1447: else
1448: select SYSDATE
1449: into FND_LOG_REPOSITORY.G_METRIC_DATE

Line 1450: from dual;

1446: end if;
1447: else
1448: select SYSDATE
1449: into FND_LOG_REPOSITORY.G_METRIC_DATE
1450: from dual;
1451: end if;
1452:
1453: end METRIC_STRING_TO_DATE;
1454:

Line 1510: from dual;

1506: where audsid = TXN_SESSION;
1507:
1508: select FND_LOG_METRICS_S.NEXTVAL
1509: into l_metric_sequence
1510: from dual;
1511:
1512: if (METRIC_VALUE_STRING is NOT NULL) then
1513: l_type := 'S';
1514: elsif (METRIC_VALUE_NUMBER is NOT NULL) then

Line 1590: from dual;

1586: end if;
1587:
1588: select FND_METRICS_EVENT_KEY_S.nextval
1589: into l_event_key
1590: from dual;
1591:
1592: update FND_LOG_METRICS
1593: set EVENT_KEY = l_event_key
1594: where EVENT_KEY is NULL

Line 2076: from dual;

2072: end if;
2073:
2074: select FND_LOG_MESSAGES_S.NEXTVAL
2075: into LOG_SEQUENCE_OUT
2076: from dual;
2077:
2078: TIMESTAMP_OUT := sysdate;
2079: DBSESSIONID_OUT := TXN_SESSION;
2080: DBINSTANCE_OUT := TXN_INSTANCE;