APPS.JMF_GTA_BATCH_NUMBER_UTIL SQL Statements

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

Line: 70

    SELECT
      COUNT(*)
    FROM jmf_gta_batch_numbering
    WHERE org_id = p_org_id;

Line: 97

      INSERT INTO jmf_gta_batch_numbering
      ( org_id
      , next_value
      , last_update_date
      , last_updated_by
      , creation_date
      , created_by
      , last_update_login
      )
      VALUES
      ( p_org_id
      , l_next_value
      , SYSDATE
      , fnd_global.LOGIN_ID()
      , SYSDATE
      , fnd_global.LOGIN_ID()
      , fnd_global.LOGIN_ID()
      );

Line: 168

    SELECT COUNT(*)
    FROM jmf_gta_batch_numbering
    WHERE org_id = p_org_id;

Line: 187

      UPDATE jmf_gta_batch_numbering
      SET next_value = p_next_value
        , last_update_date = SYSDATE
        , last_updated_by = fnd_global.LOGIN_ID()
        , last_update_login = fnd_global.LOGIN_ID()
      WHERE  org_id = p_org_id;

Line: 247

    SELECT auto_batch_numbering_flag
    FROM jmf_gta_system_parameters
    WHERE org_id = p_org_id;

Line: 252

    SELECT next_value
    FROM jmf_gta_batch_numbering
    WHERE org_id = p_org_id
    FOR UPDATE OF next_value NOWAIT;

Line: 281

      UPDATE jmf_gta_batch_numbering
      SET next_value = l_next_val + 1
        , last_update_date = SYSDATE
        , last_updated_by = fnd_global.LOGIN_ID()
        , last_update_login = fnd_global.LOGIN_ID()
      WHERE CURRENT OF c_next_val;

Line: 336

    SELECT COUNT(*)
    FROM   jmf_gta_batch_numbering
    WHERE  org_id = p_org_id;

Line: 355

      DELETE FROM jmf_gta_batch_numbering
      WHERE  org_id = p_org_id;

Line: 415

    SELECT
      to_number(p_value)
    INTO
      l_number_value
    FROM
      dual;

Line: 474

    SELECT
      COUNT(*)
    FROM jmf_gta_trx_headers_all
    WHERE org_id = p_org_id
      AND is_number(gta_batch_number) >= p_next_value
      AND instr(gta_batch_number,'-') <= 0;

Line: 542

    SELECT
      COUNT(*)
    FROM
      jmf_gta_batch_numbering
    WHERE org_id = p_org_id;

Line: 607

    SELECT
      next_value
    FROM
      jmf_gta_batch_numbering
    WHERE org_id = p_org_id;