APPS.GL_BC_EVENT_TSTAMPS_PKG SQL Statements

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

Line: 8

  PROCEDURE insert_event_timestamp(
			x_chart_of_accounts_id	NUMBER,
                        x_event_code            VARCHAR2,
			x_last_updated_by	NUMBER,
                        x_last_update_login     NUMBER) IS

  BEGIN

    INSERT INTO GL_BC_EVENT_TIMESTAMPS
          (chart_of_accounts_id, event_code, date_timestamp,
           last_update_date, last_updated_by,
           creation_date, created_by,
           last_update_login)
    SELECT x_chart_of_accounts_id, x_event_code, sysdate,
           sysdate, x_last_updated_by,
           sysdate, x_last_updated_by,
           x_last_update_login
    FROM fnd_dual
    WHERE rownum = 1
    AND NOT EXISTS
          (SELECT 'row already exists'
           FROM gl_bc_event_timestamps
           WHERE chart_of_accounts_id = x_chart_of_accounts_id
           AND   event_code = x_event_code);

Line: 42

        'gl_bc_event_tstamps_pkg.insert_event_timestamp');

Line: 44

  END insert_event_timestamp;

Line: 49

			x_last_updated_by	NUMBER,
                        x_last_update_login     NUMBER) IS

  BEGIN

    UPDATE gl_bc_event_timestamps
    SET  date_timestamp    = sysdate,
         last_update_date  = sysdate,
         last_updated_by   = x_last_updated_by,
         last_update_login = x_last_update_login
    WHERE chart_of_accounts_id = x_chart_of_accounts_id
    AND   event_code = x_event_code;

Line: 77

      SELECT 'Locked stamp'
      FROM   GL_BC_EVENT_TIMESTAMPS
      WHERE  chart_of_accounts_id = x_chart_of_accounts_id
      AND    event_code = x_event_code
      FOR UPDATE OF date_timestamp;