APPS.FND_GLOBAL SQL Statements

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

Line: 133

  FND_DELETE_VALUE VARCHAR2(30) := '**FND_DELETE_VALUE**';

Line: 156

          select fpov.profile_option_value
            into debug_trace_name
            from fnd_profile_option_values fpov, fnd_profile_options fpo
           where fpo.profile_option_name = 'AFGLOBAL_TRACE_NAME'
             and fpo.profile_option_id = fpov.profile_option_id
             and fpov.level_id = 10001
             and fpo.application_id = fpov.application_id;

Line: 218

                'insert into fnd_global_debug_table
                 values (:text,:debug_counter,sysdate,userenv(''sessionid''))'
                using text,debug_counter;

Line: 658

      select a.application_name
        into buffer
        from fnd_application_vl a
       where a.application_id = v_raid;

Line: 686

      select language_code
        into buffer
        from fnd_languages
       where installed_flag = 'B';

Line: 771

      select count(1)
        into buffer
        from fnd_languages
       where installed_flag in ('I', 'B');

Line: 804

        select name into v_org_name
        from hr_operating_units
        where organization_id = v_org_id;

Line: 877

      select r.responsibility_name
        into buffer
        from fnd_responsibility_vl r
       where r.responsibility_id = v_rid
         and r.application_id = v_raid;

Line: 908

    select r.responsibility_key
    into buffer
    from fnd_responsibility_vl r
    where r.responsibility_id = v_rid
    and r.application_id      = v_raid;

Line: 1034

      select max(lt.security_group_id)
        into retval
        from fnd_lookup_types lt
       where lt.view_application_id = lookup_security_group.view_application_id
         and lt.lookup_type         = lookup_security_group.lookup_type
         and lt.security_group_id in (0,
                        to_number(decode(substrb(userenv('CLIENT_INFO'),55,1),
                                        ' ', '0',
                                        null, '0',
                                        substrb(userenv('CLIENT_INFO'),55,10))));

Line: 1104

    p_hash.delete;

Line: 1123

    p_names.delete;

Line: 1124

    p_values.delete;

Line: 1142

    p_hash.delete;

Line: 1161

    p_names.delete;

Line: 1162

    p_values.delete;

Line: 1280

        select nls_date_language
          into v_nls_date_language
          from (select utf8_date_language nls_date_language
                  from fnd_languages
                 where nls_charset_name(nls_charset_id('CHAR_CS'))
                       in ('UTF8', 'AL32UTF8')
                   and installed_flag <>'D'
                   and nls_language = t_nls_date_language
                 union
                select local_date_language nls_date_language
                  from fnd_languages
                 where nls_charset_name(nls_charset_id('CHAR_CS'))
                       not in ('UTF8', 'AL32UTF8')
                   and installed_flag <>'D'
                   and nls_language = t_nls_date_language);

Line: 1305

        select decode(v_nls_charset_name,
               'UTF8', fl.utf8_date_language,
               'AL32UTF8', fl.utf8_date_language,
               fl.local_date_language
               ) data_rtn
        into  v_nls_date_language
        from fnd_languages fl
        where fl.nls_language = t_nls_date_language
        and fl.installed_flag <>'D' ;

Line: 1373

    for nls in (select *
                  from v$nls_parameters
                 where parameter in (
                          'NLS_LANGUAGE',
                          'NLS_DATE_LANGUAGE',
                          'NLS_SORT',
                          'NLS_TERRITORY',
                          'NLS_DATE_FORMAT',
                          'NLS_NUMERIC_CHARACTERS',
                          'NLS_CHARACTERSET'
                      )) loop
        nls_context_change := put(nls.parameter,nls.value) or nls_context_change;

Line: 2059

          select count(*)
            into v_count
            from fnd_user_resp_groups u
           where sysdate between u.start_date and nvl(u.end_date, sysdate)
             and u.security_group_id in (0, v_sgid)
             and u.user_id = v_uid
             and u.responsibility_id = v_rid
             and u.responsibility_application_id = v_raid;

Line: 2104

        select u.user_name,
               nvl(u.employee_id, FND_CONST.UNDEFINED_I) employee_id,
               nvl(u.customer_id, FND_CONST.UNDEFINED_I) customer_id,
               nvl(u.supplier_id, FND_CONST.UNDEFINED_I) supplier_id,
               nvl(u.person_party_id, FND_CONST.UNDEFINED_I) person_party_id
          into v_user.user_name,
               v_user.employee_id,
               v_user.customer_id,
               v_user.supplier_id,
               v_user.person_party_id
          from fnd_user u
         where u.user_id = v_user.user_id;

Line: 2143

        select       fu.user_name
        into         l_tab_user_name
        from         fnd_user fu
        where        fu.user_id = l_user_id;

Line: 2174

          select a.application_short_name
            into v_asn
            from fnd_application a
           where a.application_id = v_raid;

Line: 2586

      fnd_profile.put(FND_CONST.PER_BUSINESS_GROUP_ID, FND_DELETE_VALUE);

Line: 2587

      fnd_profile.put(FND_CONST.PER_SECURITY_PROFILE_ID, FND_DELETE_VALUE);

Line: 2642

      z_init.delete;

Line: 2684

    z_init.delete;

Line: 3006

  select data_length
  into len
  from all_tab_columns
  where owner = 'SYS' and table_name = 'V_$SESSION' and column_name = cname;