[Home] [Help]
285: --
286: cursor csr_next_value(cp_bg_id per_all_people.business_group_id%TYPE
287: ,cp_person_type per_person_types.system_person_type%TYPE) is
288: SELECT business_group_id
289: from per_number_generation_controls
290: where business_group_id = cp_bg_id
291: and type = cp_person_type
292: FOR UPDATE of next_value NOWAIT;
293: --
415: hr_utility.set_location(c_proc_name,25);
416: set_global_sequence(p_person_type,l_max_num_found);
417: else
418: hr_utility.set_location(c_proc_name,26);
419: UPDATE per_number_generation_controls
420: SET next_value = l_max_num_found + 1
421: WHERE business_group_id = l_organization_id
422: and type = p_person_type;
423: if csr_next_value%ISOPEN then
644: e_SeqError EXCEPTION;
645: --
646: cursor csr_max_emp_num(cp_person_type varchar2) is
647: select max(next_value)
648: from per_number_generation_controls png
649: ,hr_organization_information hoi
650: where png.business_group_id = hoi.organization_id
651: and hoi.ORG_INFORMATION_CONTEXT = g_bg_context_name
652: and hoi.Org_information2 = g_automatic_method
653: and png.type = cp_person_type;
654:
655: cursor csr_max_apl_num(cp_person_type varchar2) is
656: select max(next_value)
657: from per_number_generation_controls png
658: ,hr_organization_information hoi
659: where png.business_group_id = hoi.organization_id
660: and hoi.ORG_INFORMATION_CONTEXT = g_bg_context_name
661: and hoi.Org_information3 = g_automatic_method
662: and png.type = cp_person_type;
663:
664: cursor csr_max_cwk_num(cp_person_type varchar2) is
665: select max(next_value)
666: from per_number_generation_controls png
667: ,hr_organization_information hoi
668: where png.business_group_id = hoi.organization_id
669: and hoi.ORG_INFORMATION_CONTEXT = g_bg_context_name
670: and hoi.Org_information16 = g_automatic_method