[Home] [Help]
1363: AUDSID IN VARCHAR2,
1364: DB_INSTANCE IN VARCHAR2) is
1365: pragma AUTONOMOUS_TRANSACTION;
1366: begin
1367: insert into FND_LOG_METRICS
1368: (MODULE,
1369: METRIC_CODE,
1370: METRIC_SEQUENCE,
1371: TYPE,
1482: into l_context(11).a_val, l_context(12).a_val
1483: from v$session
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
1550:
1551: begin
1552:
1553: /*
1554: 2983052: Check for rows in FND_LOG_METRICS
1555: If no metrics actually logged, don't raise an event.
1556: */
1557: select count(1)
1558: into cnt
1555: If no metrics actually logged, don't raise an event.
1556: */
1557: select count(1)
1558: into cnt
1559: from FND_LOG_METRICS
1560: where TRANSACTION_CONTEXT_ID = CONTEXT_ID;
1561:
1562: if cnt = 0 then
1563: return;
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
1573: and TRANSACTION_CONTEXT_ID = CONTEXT_ID;
1574: