APPS.FND_GLOBAL SQL Statements

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

Line: 121

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

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

Line: 566

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

Line: 594

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

Line: 679

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

Line: 712

        execute immediate 'select name
                             from hr_operating_units
                            where organization_id = :v_org_id'
                into v_org_name using v_org_id;

Line: 785

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

Line: 923

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

    p_hash.delete;

Line: 1012

    p_names.delete;

Line: 1013

    p_values.delete;

Line: 1031

    p_hash.delete;

Line: 1050

    p_names.delete;

Line: 1051

    p_values.delete;

Line: 1158

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

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

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

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

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

Line: 2299

      z_init.delete;

Line: 2341

   z_init.delete;