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: 195

      SELECT flex_value_low, flex_value_high
        FROM fnd_flex_value_rule_lines
       WHERE flex_value_rule_id = rule_id
         AND include_exclude_indicator = 'I'
       ORDER BY nlssort(decode(flex_value_low,
                               NULL,
                               '1',
                               '2' || flex_value_low),
                        'NLS_SORT=BINARY'),
                nlssort(decode(flex_value_high,
                               NULL,
                               '3',
                               '2' || flex_value_high),
                        'NLS_SORT=BINARY');

Line: 211

      SELECT flex_value_low, flex_value_high
        FROM fnd_flex_value_rule_lines
       WHERE flex_value_rule_id = rule_id
         AND include_exclude_indicator <> 'I'
       ORDER BY nlssort(decode(flex_value_low,
                               NULL,
                               '1',
                               '2' || flex_value_low),
                        'NLS_SORT=BINARY'),
                nlssort(decode(flex_value_high,
                               NULL,
                               '3',
                               '2' || flex_value_high),
                        'NLS_SORT=BINARY');

Line: 326

        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: 337

        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: 342

        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: 351

        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: 420

        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: 927

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

Line: 945

        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: 1018

          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: 1031

          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: 1044

          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: 1057

          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: 1070

          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: 1083

          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: 1096

          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: 1109

          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: 1122

          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: 1135

          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: 1148

          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: 1161

          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: 1174

          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: 1187

          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: 1200

          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: 1213

          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: 1226

          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: 1239

          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: 1252

          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: 1265

          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: 1278

          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: 1291

          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: 1304

          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: 1317

          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: 1330

          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: 1343

          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: 1356

          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: 1369

          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: 1382

          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: 1395

          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: 1427

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

Line: 1439

              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: 1490

        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: 1509

                    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: 1532

        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: 1552

                    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: 1591

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