APPS.JA_CN_FSG_FORMULA_EXTRACT_PKG SQL Statements

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

Line: 78

ln_axis_seq_update          rg_report_axes.axis_seq%TYPE;

Line: 83

SELECT
  axis_seq
FROM
  ja_cn_cfs_row_cgs_gt
WHERE axis_set_id=ln_axis_set_id
  AND display_flag='Y'
ORDER BY axis_seq
FOR UPDATE;

Line: 94

SELECT
      type
     ,change_sign_flag
     ,rowcnt
     ,lincnt
FROM
  ja_cn_cfs_row_cgs_gt
WHERE axis_set_id=ln_axis_set_id
  AND axis_seq = ln_axis_seq
  AND display_flag='Y';

Line: 107

SELECT
  jcccg.operator
 ,jccrcg.lincnt
 ,jccrcg.change_sign_flag
FROM
  ja_cn_cfs_calculations_gt jcccg
 ,ja_cn_cfs_row_cgs_gt jccrcg
WHERE jcccg.axis_set_id=ln_axis_set_id
  AND jcccg.axis_seq=ln_axis_seq
  AND jcccg.axis_set_id=jccrcg.axis_set_id
  AND jcccg.cal_axis_seq=jccrcg.axis_seq
ORDER BY jcccg.calculation_seq;

Line: 172

  FETCH c_axis_seq INTO ln_axis_seq_update;

Line: 180

      ln_axis_seq := ln_axis_seq_update;

Line: 188

    UPDATE
      ja_cn_cfs_row_cgs_gt
    SET
      rowcnt=lv_rowcnt
     ,lincnt=lv_lincnt
    WHERE CURRENT OF c_axis_seq;

Line: 195

    FETCH c_axis_seq INTO ln_axis_seq_update;

Line: 200

    SELECT COUNT(*)
    INTO ln_row_count
    FROM
      ja_cn_cfs_row_cgs_gt
    WHERE axis_set_id=ln_axis_set_id
      AND axis_seq = ln_axis_seq
      AND display_flag='Y'
      AND calculation_flag='Y';

Line: 230

           SELECT
             decode(l_calculation_lines.operator,'+','-','-','+','+')
           INTO
             lv_operator
           FROM dual;

Line: 333

SELECT
  DISTINCT
  rra.application_id
 ,rra.display_flag
 ,rra.display_zero_amount_flag
 ,rra.change_sign_flag
FROM
  rg_report_axes rra
 ,rg_report_calculations rrc
WHERE rra.axis_set_id=ln_axis_set_id
  AND rra.axis_set_id=rrc.axis_set_id
  AND rra.axis_seq=rrc.axis_seq
  AND rra.axis_seq=ln_axis_seq;

Line: 349

SELECT
  operator
 ,axis_seq_low
 ,axis_seq_high
 ,axis_name_low
 ,constant
FROM
  rg_report_calculations
WHERE application_id=ln_application_id
  AND axis_set_id=ln_axis_set_id
  AND axis_seq=ln_axis_seq
ORDER BY calculation_seq;

Line: 364

SELECT
  rra.axis_seq
FROM
  rg_report_axes rra
WHERE rra.axis_set_id=ln_axis_set_id
  AND rra.axis_seq BETWEEN ln_axis_seq_low AND ln_axis_seq_high
  AND (EXISTS (SELECT
                 rrac.axis_seq
              FROM
                rg_report_axis_contents rrac
              WHERE rrac.application_id=rra.application_id
                AND rrac.axis_set_id=rra.axis_set_id
                AND rrac.axis_seq=rra.axis_seq
             )
     OR
        EXISTS (SELECT
                  jccaa.axis_seq
               FROM
                 ja_cn_cfs_assignments_all jccaa
               WHERE jccaa.chart_of_accounts_id=ln_coa
                 AND rra.axis_set_id=jccaa.axis_set_id
                 AND jccaa.axis_seq=rra.axis_seq
              )
      OR
        EXISTS (SELECT
                  rrc.axis_seq
FROM
                 rg_report_calculations rrc
               WHERE rrc.application_id=rra.application_id
                 AND rra.axis_set_id=rrc.axis_set_id
                 AND rrc.axis_seq=rra.axis_seq
              )
        );

Line: 400

SELECT
  axis_seq
FROM
  rg_report_axes
WHERE application_id=ln_application_id
  AND axis_set_id=ln_axis_set_id
  AND axis_name=lv_axis_name_low;

Line: 505

             INSERT
             INTO
               ja_cn_cfs_calculations_gt
               (application_id,axis_set_id
               ,axis_seq
               ,calculation_seq
               ,operator
               ,operator_flag
               ,cal_axis_seq
               ,constant
               )
             VALUES
               (ln_application_id
               ,ln_axis_set_id
               ,ln_axis_seq
               ,ln_calculation_seq
               ,lv_operator
               ,ln_operator_flag
               ,ln_cal_axis_seq
               ,''
               );

Line: 542

           INSERT
           INTO
             ja_cn_cfs_calculations_gt
               (application_id,axis_set_id
               ,axis_seq
               ,calculation_seq
               ,operator
               ,operator_flag
               ,cal_axis_seq
               ,constant
               )
           VALUES
             (ln_application_id
             ,ln_axis_set_id
             ,ln_axis_seq
             ,ln_calculation_seq
             ,lv_operator
             ,ln_operator_flag
             ,ln_cal_axis_seq
             ,''
             );

Line: 571

           INSERT
           INTO
             ja_cn_cfs_calculations_gt
              (application_id,axis_set_id
              ,axis_seq
              ,calculation_seq
              ,operator
              ,operator_flag
              ,cal_axis_seq
              ,constant
               )
           VALUES
             (ln_application_id
             ,ln_axis_set_id
             ,ln_axis_seq
             ,ln_calculation_seq
             ,lv_operator
             ,ln_operator_flag
             ,''
             ,ln_constant
             );

Line: 612

    INSERT
      INTO
        ja_cn_cfs_row_cgs_gt
        (application_id
        ,axis_set_id
        ,axis_seq
        ,type
        ,calculation_flag
        ,display_flag
        ,display_zero_amount_flag
        ,change_sign_flag
        )
    VALUES
     (ln_application_id
     ,ln_axis_set_id
     ,ln_axis_seq
     ,lv_type
     ,'Y'
     ,lv_display_flag
     ,lv_display_zero_flag
     ,lv_change_sign_flag
     );

Line: 636

    SELECT COUNT(DISTINCT rra.axis_seq)
    INTO ln_row_count
    FROM
      rg_report_axes rra
     ,rg_report_calculations rrc
    WHERE rra.axis_set_id=ln_axis_set_id
      AND rra.axis_set_id=rrc.axis_set_id
      AND rra.axis_seq=rrc.axis_seq
      AND rrc.axis_seq<=ln_axis_seq;

Line: 647

     UPDATE
        ja_cn_cfs_row_cgs_gt
      SET
        rowcnt='r1'||lpad(to_char(ln_row_count),5,'0')
       ,lincnt='l1'||lpad(to_char(ln_row_count),5,'0')
      WHERE
            application_id=ln_application_id
        AND axis_set_id=ln_axis_set_id
        AND axis_seq=ln_axis_seq;