DBA Data[Home] [Help]

APPS.FND_LOG_REPOSITORY dependencies on FND_LOG_METRICS

Line 1389: insert into FND_LOG_METRICS

1385: AUDSID IN VARCHAR2,
1386: DB_INSTANCE IN VARCHAR2) is
1387: pragma AUTONOMOUS_TRANSACTION;
1388: begin
1389: insert into FND_LOG_METRICS
1390: (MODULE,
1391: METRIC_CODE,
1392: METRIC_SEQUENCE,
1393: TYPE,

Line 1508: select FND_LOG_METRICS_S.NEXTVAL

1504: into l_context(11).a_val, l_context(12).a_val
1505: from v$session
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

Line 1576: 2983052: Check for rows in FND_LOG_METRICS

1572:
1573: begin
1574:
1575: /*
1576: 2983052: Check for rows in FND_LOG_METRICS
1577: If no metrics actually logged, don't raise an event.
1578: */
1579: select count(1)
1580: into cnt

Line 1581: from FND_LOG_METRICS

1577: If no metrics actually logged, don't raise an event.
1578: */
1579: select count(1)
1580: into cnt
1581: from FND_LOG_METRICS
1582: where TRANSACTION_CONTEXT_ID = CONTEXT_ID;
1583:
1584: if cnt = 0 then
1585: return;

Line 1592: update FND_LOG_METRICS

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
1595: and TRANSACTION_CONTEXT_ID = CONTEXT_ID;
1596: