APPS.GL_SECURITY_PKG SQL Statements

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

Line: 81

    SELECT application_id
      into appl_id
      FROM FND_RESPONSIBILITY
     WHERE responsibility_id = resp_id;

Line: 98

        SELECT chart_of_accounts_id
          INTO COA_ID
          FROM GL_LEDGERS
         WHERE ledger_id = l_ledger_id;

Line: 109

        SELECT chart_of_accounts_id, security_segment_code
          INTO COA_ID, SECURITY_SEGMENT_CODE
          FROM GL_ACCESS_SETS
         WHERE access_set_id = ACCESS_ID;

Line: 162

    delete from GL_BIS_SEGVAL_INT; -- 6341771, clean up the existing rows

Line: 176

      SELECT sg.application_column_name,
             sg.flex_value_set_id,
             sg.segment_num,
             vs.validation_type
        FROM FND_FLEX_VALUE_SETS vs, FND_ID_FLEX_SEGMENTS sg
       WHERE sg.application_id = 101
         AND sg.id_flex_code = 'GL#'
         AND sg.id_flex_num = coa_id
         AND sg.security_enabled_flag = 'Y'
         AND vs.flex_value_set_id = sg.flex_value_set_id;

Line: 188

      SELECT flex_value_rule_id, parent_flex_value_low
        FROM fnd_flex_value_rule_usages
       WHERE application_id = appl_id
         AND responsibility_id = resp_id
         AND flex_value_set_id = v_id;

Line: 196

     SELECT low,high from
     (SELECT flex_value_low low,flex_value_high high
      FROM   fnd_flex_value_rule_lines
      WHERE  flex_value_rule_id = rule_id
      AND    include_exclude_indicator = 'I'
      UNION
      SELECT h1.child_flex_value_low low,h1.child_flex_value_high high
      FROM   fnd_flex_value_rule_lines l,
             fnd_flex_value_hier_all h1,
             fnd_flex_value_sets fv
      WHERE  l.flex_value_rule_id = rule_id
      AND    l.include_exclude_indicator = 'I'
      AND    h1.flex_value_set_id = l.flex_value_set_id
      AND    h1.parent_flex_value BETWEEN l.flex_value_low AND l.flex_value_high
      AND    h1.range_attribute = 'C'
      AND    fv.flex_value_set_id =l.flex_value_set_id
      AND    fv.security_enabled_flag = 'H'
      )
     ORDER BY nlssort(decode(low,NULL,'1','2'||
                       low),'NLS_SORT=BINARY') ,
               nlssort(decode(high,NULL,'3','2'||
                       high),'NLS_SORT=BINARY') ;

Line: 220

    SELECT low,high from
     (SELECT flex_value_low low,flex_value_high high
      FROM   fnd_flex_value_rule_lines
      WHERE  flex_value_rule_id = rule_id
      AND    include_exclude_indicator <> 'I'
      UNION
      SELECT h1.child_flex_value_low low,h1.child_flex_value_high high
      FROM   fnd_flex_value_rule_lines l,
             fnd_flex_value_hier_all h1,
             fnd_flex_value_sets fv
      WHERE  l.flex_value_rule_id = rule_id
      AND    l.include_exclude_indicator <> 'I'
      AND    h1.flex_value_set_id = l.flex_value_set_id
      AND    h1.parent_flex_value BETWEEN l.flex_value_low AND l.flex_value_high
      AND    h1.range_attribute = 'C'
      AND    fv.flex_value_set_id =l.flex_value_set_id
      AND    fv.security_enabled_flag = 'H'
      )
    ORDER BY nlssort(decode(low,NULL,'1','2'||
                       low),'NLS_SORT=BINARY') ,
               nlssort(decode(high,NULL,'3','2'||
                       high),'NLS_SORT=BINARY') ;

Line: 343

        sql_stmt := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||
                    'segment_column_name,' ||
                    'segment_value,      ' ||
                    'parent_segment) ' ||
                    'SELECT ''' || segment_column_name || ''',' ||
                    'flex_value, parent_flex_value_low ' ||
                    'FROM FND_FLEX_VALUES ' ||
                    'WHERE flex_value_set_id=' || value_set_id;

Line: 354

        SELECT value_column_name, application_table_name
        INTO   v_column_name, v_appl_table_name
        FROM   FND_FLEX_VALIDATION_TABLES
        WHERE  flex_value_set_id = value_set_id;

Line: 359

        sql_stmt := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||
                    'segment_column_name,' ||
                    'segment_value,' ||
                    'parent_segment) ' ||
                    ' SELECT ''' || segment_column_name || ''',' ||
                                    v_column_name || ',' || 'NULL' ||
                    ' FROM ' || v_appl_table_name;

Line: 368

        sql_stmt2 := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||
                     'segment_column_name,' ||
                     'segment_value,      ' ||
                     'parent_segment) ' ||
                     ' SELECT ''' || segment_column_name || ''',' ||
                                     ' flex_value, NULL' ||
                     ' FROM FND_FLEX_VALUES ' ||
                     ' WHERE flex_value_set_id= ' || value_set_id ||
                     ' AND summary_flag = ''Y'' ';

Line: 437

        del_stmt := 'DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */ FROM GL_BIS_SEGVAL_INT ' ||
                    'WHERE segment_column_name=''' || segment_column_name || '''';

Line: 944

         SELECT count(*)
         INTO total_count
         FROM gl_access_set_ledgers
         WHERE ledger_id = p_ledger_id
            AND access_set_id = ACCESS_ID;

Line: 962

        SELECT segment1,
               segment2,
               segment3,
               segment4,
               segment5,
               segment6,
               segment7,
               segment8,
               segment9,
               segment10,
               segment11,
               segment12,
               segment13,
               segment14,
               segment15,
               segment16,
               segment17,
               segment18,
               segment19,
               segment20,
               segment21,
               segment22,
               segment23,
               segment24,
               segment25,
               segment26,
               segment27,
               segment28,
               segment29,
               segment30
          INTO segment1,
               segment2,
               segment3,
               segment4,
               segment5,
               segment6,
               segment7,
               segment8,
               segment9,
               segment10,
               segment11,
               segment12,
               segment13,
               segment14,
               segment15,
               segment16,
               segment17,
               segment18,
               segment19,
               segment20,
               segment21,
               segment22,
               segment23,
               segment24,
               segment25,
               segment26,
               segment27,
               segment28,
               segment29,
               segment30
          FROM GL_CODE_COMBINATIONS
         WHERE code_combination_id = ccid;

Line: 1035

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT1'
             AND segment_value = segment1;

Line: 1048

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT2'
             AND segment_value = segment2;

Line: 1061

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT3'
             AND segment_value = segment3;

Line: 1074

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT4'
             AND segment_value = segment4;

Line: 1087

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT5'
             AND segment_value = segment5;

Line: 1100

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT6'
             AND segment_value = segment6;

Line: 1113

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT7'
             AND segment_value = segment7;

Line: 1126

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT8'
             AND segment_value = segment8;

Line: 1139

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT9'
             AND segment_value = segment9;

Line: 1152

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT10'
             AND segment_value = segment10;

Line: 1165

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT11'
             AND segment_value = segment11;

Line: 1178

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT12'
             AND segment_value = segment12;

Line: 1191

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT13'
             AND segment_value = segment13;

Line: 1204

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT14'
             AND segment_value = segment14;

Line: 1217

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT15'
             AND segment_value = segment15;

Line: 1230

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT16'
             AND segment_value = segment16;

Line: 1243

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT17'
             AND segment_value = segment17;

Line: 1256

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT18'
             AND segment_value = segment18;

Line: 1269

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT19'
             AND segment_value = segment19;

Line: 1282

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT20'
             AND segment_value = segment20;

Line: 1295

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT21'
             AND segment_value = segment21;

Line: 1308

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT22'
             AND segment_value = segment22;

Line: 1321

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT23'
             AND segment_value = segment23;

Line: 1334

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT24'
             AND segment_value = segment24;

Line: 1347

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT25'
             AND segment_value = segment25;

Line: 1360

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT26'
             AND segment_value = segment26;

Line: 1373

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT27'
             AND segment_value = segment27;

Line: 1386

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT28'
             AND segment_value = segment28;

Line: 1399

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT29'
             AND segment_value = segment29;

Line: 1412

          SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
           count(*)
            into total_count
            FROM GL_BIS_SEGVAL_INT
           WHERE segment_column_name = 'SEGMENT30'
             AND segment_value = segment30;

Line: 1444

              SELECT count(*) into total_count
              FROM gl_access_set_ledgers
              WHERE ledger_id = p_ledger_id
              AND access_set_id = ACCESS_ID;

Line: 1456

              SELECT count(*) into total_count
              FROM   gl_access_set_assignments gasa
              WHERE  gasa.segment_value = l_seg_value
              AND    gasa.ledger_id = p_ledger_id
              AND    gasa.access_set_id = ACCESS_ID;

Line: 1507

        SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
         count(*)
          into count1
          FROM GL_BIS_SEGVAL_INT
         WHERE segment_column_name = seg1_name
           AND segment_value = segval1;

Line: 1526

                    SELECT count(*) into count1
                    FROM   gl_access_set_assignments gasa
                    WHERE  gasa.segment_value = segval1
                    AND    gasa.ledger_id = p_ledger_id
                    AND    gasa.access_set_id = ACCESS_ID;

Line: 1549

        SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
         count(*)
          into count1
          FROM GL_BIS_SEGVAL_INT
         WHERE segment_column_name = seg2_name
           AND segment_value = segval2;

Line: 1569

                    SELECT count(*)
                    INTO   count1
                    FROM   gl_access_set_assignments gasa
                    WHERE  gasa.segment_value = segval2
                    AND    gasa.ledger_id = p_ledger_id
                    AND    gasa.access_set_id = ACCESS_ID;

Line: 1608

    SELECT count(*)
    INTO l_total_count
    FROM gl_access_set_ledgers
    WHERE ledger_id = p_ledger_id
       AND access_set_id = ACCESS_ID;