APPS.PER_BG_NUMBERING_METHOD_PKG SQL Statements

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

Line: 74

        select applicant_number
        from   per_all_people_f
        where  business_group_id = p_business_group_id
        and    applicant_number is not null;

Line: 132

        select employee_number
        from   per_all_people_f
        where  business_group_id = p_business_group_id
        and    employee_number is not null;

Line: 191

        select npw_number
        from   per_all_people_f
        where  business_group_id = p_business_group_id
        and    npw_number is not null;

Line: 259

   l_rows_updated      number;

Line: 270

      SELECT organization_id, Org_information2, Org_information3, Org_information16
        from  hr_organization_information
       where organization_id = cp_bg_id
         and ORG_INFORMATION_CONTEXT  = g_bg_context_name
      FOR UPDATE of Org_information3          -- method_of_generation_apl_num
                  , Org_information2          -- method_of_generation_emp_num
                  , Org_information16 NOWAIT; -- method_of_generation_cwk_num

Line: 282

      SELECT business_group_id
        from per_number_generation_controls
       where business_group_id   = cp_bg_id
         and type = cp_person_type
      FOR UPDATE of next_value NOWAIT;

Line: 302

       l_rows_updated    := 0;

Line: 335

               UPDATE HR_ORGANIZATION_INFORMATION
                  SET Org_information3 = g_automatic_method  -- method_of_generation_apl_num
                WHERE organization_id = l_organization_id
                  AND ORG_INFORMATION_CONTEXT  = g_bg_context_name;

Line: 341

               l_rows_updated := SQL%ROWCOUNT;

Line: 361

               UPDATE HR_ORGANIZATION_INFORMATION
                  SET Org_information2 = g_automatic_method  -- method_of_generation_emp_num
                WHERE organization_id = l_organization_id
                  AND ORG_INFORMATION_CONTEXT  = g_bg_context_name;

Line: 367

               l_rows_updated := SQL%ROWCOUNT;

Line: 386

               UPDATE HR_ORGANIZATION_INFORMATION
                  SET Org_information16 = g_automatic_method  -- method_of_generation_cwk_num
                WHERE organization_id = l_organization_id
                  AND ORG_INFORMATION_CONTEXT  = g_bg_context_name;

Line: 392

               l_rows_updated := SQL%ROWCOUNT;

Line: 404

                if l_rows_updated > 0 and l_max_num_found is not null then
                    hr_utility.set_location(c_proc_name,24);

Line: 413

                       UPDATE per_number_generation_controls
                          SET next_value = l_max_num_found + 1
                       WHERE business_group_id = l_organization_id
                         and type = p_person_type;

Line: 486

        SELECT sequence_owner, last_number, cache_size,
             min_value, max_value, cycle_flag
        FROM all_sequences
        WHERE sequence_name = cp_seq_name
          and sequence_owner = l_owner;

Line: 533

   l_string := 'SELECT ' || l_seq_owner || '.' || l_seq_name ||
              '.NEXTVAL FROM sys.dual';

Line: 569

       l_string := 'SELECT ' || l_seq_owner || '.' || l_seq_name ||
                  '.nextval FROM sys.dual';

Line: 601

       l_string := 'SELECT ' || l_seq_owner || '.' || l_seq_name ||
                  '.nextval FROM sys.dual';

Line: 641

       select max(next_value)
        from per_number_generation_controls png
            ,hr_organization_information    hoi
        where png.business_group_id = hoi.organization_id
          and hoi.ORG_INFORMATION_CONTEXT  = g_bg_context_name
          and hoi.Org_information2 = g_automatic_method
          and png.type = cp_person_type;

Line: 650

       select max(next_value)
        from per_number_generation_controls png
            ,hr_organization_information    hoi
        where png.business_group_id = hoi.organization_id
          and hoi.ORG_INFORMATION_CONTEXT  = g_bg_context_name
          and hoi.Org_information3 = g_automatic_method
          and png.type = cp_person_type;

Line: 659

       select max(next_value)
        from per_number_generation_controls png
            ,hr_organization_information    hoi
        where png.business_group_id = hoi.organization_id
          and hoi.ORG_INFORMATION_CONTEXT  = g_bg_context_name
          and hoi.Org_information16 = g_automatic_method
          and png.type = cp_person_type;

Line: 839

      select PER_GLOBAL_EMP_NUM_S.NEXTVAL
        into l_next_value
        from dual;

Line: 843

      select PER_GLOBAL_APL_NUM_S.NEXTVAL
        into l_next_value
        from dual;

Line: 848

      select PER_GLOBAL_CWK_NUM_S.NEXTVAL
        into l_next_value
        from dual;

Line: 886

       select ff.formula_id
       into   l_formula_id
       from   ff_formulas_f ff
       where  ff.formula_name = l_formula_name
       and    ff.business_group_id = 0 -- global FF defined in Setup BG
                                       -- we ignore the Legislation Code
       and    p_effective_date between ff.effective_start_date and
                                       ff.effective_end_date;