APPS.FND_LOG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 182

     select count(*)
       into dummy
       from FND_LOG_TRANSACTION_CONTEXT
      where TRANSACTION_CONTEXT_ID = TRANS_CONTEXT_ID;

Line: 374

       FND_LOG_REPOSITORY.INSERT_BLOB(l_sequence, P_CHARSET, P_MIMETYPE,
			P_ENCODING, P_LANG, P_FILE_EXTN, P_DESC);

Line: 482

   **     session to the Business Event system and updates the pending
   **     metrics with the event key. The metrics will be bundled in an
   **     XML message included in the event.  The event will be named:
   **     "oracle.apps.fnd.system.metrics"
   **
   ** Arguments:
   **     CONTEXT_ID    ID of the context to post the metrics event for.
   **                   Use NULL for the current context.
   */

   PROCEDURE WORK_METRICS_EVENT(CONTEXT_ID IN NUMBER DEFAULT NULL) IS
   begin

      FND_LOG_REPOSITORY.METRICS_EVENT_INT_WITH_CONTEXT(CONTEXT_ID);

Line: 540

        select MESSAGE_TEXT, DECODE(ENCODED, 'Y', 'Y', 'N')
          into msg_text, encoded
          from FND_LOG_MESSAGES
         where LOG_SEQUENCE = LOG_SEQUENCE_ID;

Line: 667

     * buffers messages in PL/SQL Collection for Bulk-Inserting.
     */
    PROCEDURE SET_BUFFERED_MODE is
    begin
	FND_LOG_REPOSITORY.SET_BUFFERED_MODE;