[Home] [Help]
279: --
280: cursor csr_next_value(cp_bg_id per_all_people.business_group_id%TYPE
281: ,cp_person_type per_person_types.system_person_type%TYPE) is
282: SELECT business_group_id
283: from per_number_generation_controls
284: where business_group_id = cp_bg_id
285: and type = cp_person_type
286: FOR UPDATE of next_value NOWAIT;
287: --
409: hr_utility.set_location(c_proc_name,25);
410: set_global_sequence(p_person_type,l_max_num_found);
411: else
412: hr_utility.set_location(c_proc_name,26);
413: UPDATE per_number_generation_controls
414: SET next_value = l_max_num_found + 1
415: WHERE business_group_id = l_organization_id
416: and type = p_person_type;
417: if csr_next_value%ISOPEN then
638: e_SeqError EXCEPTION;
639: --
640: cursor csr_max_emp_num(cp_person_type varchar2) is
641: select max(next_value)
642: from per_number_generation_controls png
643: ,hr_organization_information hoi
644: where png.business_group_id = hoi.organization_id
645: and hoi.ORG_INFORMATION_CONTEXT = g_bg_context_name
646: and hoi.Org_information2 = g_automatic_method
647: and png.type = cp_person_type;
648:
649: cursor csr_max_apl_num(cp_person_type varchar2) is
650: select max(next_value)
651: from per_number_generation_controls png
652: ,hr_organization_information hoi
653: where png.business_group_id = hoi.organization_id
654: and hoi.ORG_INFORMATION_CONTEXT = g_bg_context_name
655: and hoi.Org_information3 = g_automatic_method
656: and png.type = cp_person_type;
657:
658: cursor csr_max_cwk_num(cp_person_type varchar2) is
659: select max(next_value)
660: from per_number_generation_controls png
661: ,hr_organization_information hoi
662: where png.business_group_id = hoi.organization_id
663: and hoi.ORG_INFORMATION_CONTEXT = g_bg_context_name
664: and hoi.Org_information16 = g_automatic_method