APPS.JA_TW_SH_GUI_UTILS SQL Statements

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

Line: 13

    l_sql_stmt := 'SELECT '
                 || p_sequence_name
                 || '.nextval seq_number '
                 || 'FROM dual';

Line: 40

    SELECT last_number - 1
      FROM all_sequences
     WHERE sequence_name  = x_seq_name
       AND sequence_owner = x_seq_owner;

Line: 116

       SELECT
              src.auto_trx_numbering_flag      auto_trx_num_flag
            , src.global_attribute3            inv_word
            , src.global_attribute2            init_trx_num
            , src.global_attribute4            fin_trx_num
            , src.global_attribute5            last_trx_date
            , TO_NUMBER(src.global_attribute6) adv_days
         FROM ra_batch_sources src
        WHERE src.batch_source_id = x_batch_source_id
        -- Bug 4673732 : R12 MOAC change
        AND   decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);

Line: 163

       SELECT
              ctt.type inv_class
              -- R12 Change : , ctt.global_attribute1 gui_type
            , NULL  gui_type
         FROM ra_cust_trx_types ctt
        WHERE ctt.cust_trx_type_id = p_cust_trx_type_id
         -- Bug 4673732 : R12 MOAC change
        AND   decode(nvl(x_org_id,1), 1, 1, ctt.org_id) = nvl(x_org_id, 1);

Line: 206

       SELECT src.global_attribute1
         FROM ra_batch_sources src
        WHERE src.batch_source_id = x_batch_source_id
         -- Bug 4673732 : R12 MOAC change
        AND   decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);

Line: 239

       SELECT src.global_attribute3
         FROM ra_batch_sources src
        WHERE src.batch_source_id = x_batch_source_id
         -- Bug 4673732 : R12 MOAC change
        AND   decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);

Line: 278

       SELECT decode(src.global_attribute1
                       , NULL
                       , x_batch_source_id
                       , src.global_attribute1)
         FROM ra_batch_sources src
        WHERE src.batch_source_id = x_batch_source_id
        -- Bug 4673732 : R12 MOAC change
        AND   decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);

Line: 318

    SELECT
           DECODE(x_ini_or_fin
                , 'INI'
                , src.global_attribute2
                , 'FIN'
                , src.global_attribute4
                , NULL)
      FROM
           ra_batch_sources src
     WHERE
           src.batch_source_id = x_batch_source_id
           -- Bug 4673732 : R12 MOAC change
     AND   decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);

Line: 363

       SELECT fnd_date.chardate_to_date(src.global_attribute5)
         FROM ra_batch_sources src
        WHERE src.batch_source_id = x_gui_source_id
        -- Bug 4673732 : R12 MOAC change
        AND   decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);

Line: 397

       SELECT src.global_attribute6
         FROM ra_batch_sources src
        WHERE src.batch_source_id = x_batch_source_id
        -- Bug 4673732 : R12 MOAC change
        AND   decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);

Line: 449

    SELECT 'SUCCESS'
      INTO l_dummy
      FROM jg_zz_ar_src_trx_ty st
     WHERE st.batch_source_id  = l_batch_source_id
       AND st.cust_trx_type_id = l_cust_trx_type_id
       AND st.enable_flag = 'Y';  -- Bug 1865837

Line: 475

        arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');

Line: 545

    arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');

Line: 593

          IF NOT update_last_trx_date(
                     l_batch_source_id
                   , l_trx_date
                   , l_created_from
                   , p_org_id)
          THEN
            app_exception.raise_exception;

Line: 645

    arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');

Line: 674

    SELECT
           COUNT(DISTINCT l.tax_code)
      FROM
           ra_interface_lines_gt l
     WHERE
           l.customer_trx_id = x_customer_trx_id;

Line: 684

    SELECT
           COUNT(DISTINCT tl.vat_tax_id)
      FROM
           ra_customer_trx_lines tl
     WHERE
           tl.customer_trx_id = x_customer_trx_id
       AND tl.line_type = 'TAX';                 -- Bug 2753541

Line: 738

    arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');

Line: 751

  FUNCTION  update_last_trx_date(
             p_batch_source_id IN NUMBER
           , p_last_trx_date   IN DATE
           , p_created_from    IN VARCHAR2
           , p_org_id          IN NUMBER) RETURN BOOLEAN IS

    CURSOR c_last_issued_date(
           x_batch_source_id NUMBER,
           x_org_id          NUMBER) IS
    SELECT global_attribute5
      FROM ra_batch_sources   src
     WHERE batch_source_id = x_batch_source_id
     -- Bug 4673732 : R12 MOAC change
     AND   decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1)
       FOR UPDATE OF global_attribute5 NOWAIT;

Line: 782

    UPDATE ra_batch_sources
       SET global_attribute5 = l_last_trx_date
     WHERE CURRENT OF c_last_issued_date;

Line: 792

  END update_last_trx_date;

Line: 816

    UPDATE ra_interface_lines_gt
       SET header_gdf_attribute1 = l_gui_type
     WHERE interface_line_id = l_interface_line_id;