APPS.PER_BG_NUMBERING_METHOD_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 251: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,

247: PRAGMA EXCEPTION_INIT(e_ResourceBusy, -54);
248:
249: TYPE t_bgRecord IS RECORD
250: (
251: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
252: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
253: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
254: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
255: );

Line 252: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,

248:
249: TYPE t_bgRecord IS RECORD
250: (
251: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
252: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
253: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
254: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
255: );
256:

Line 253: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,

249: TYPE t_bgRecord IS RECORD
250: (
251: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
252: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
253: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
254: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
255: );
256:
257: l_max_num_found number := 0;

Line 254: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE

250: (
251: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
252: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
253: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
254: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
255: );
256:
257: l_max_num_found number := 0;
258: l_message varchar2(200) := null;

Line 271: from hr_organization_information

267: -- Returns the current method of number generation
268: --
269: cursor csr_method(cp_bg_id per_all_people.business_group_id%TYPE) is
270: SELECT organization_id, Org_information2, Org_information3, Org_information16
271: from hr_organization_information
272: where organization_id = cp_bg_id
273: and ORG_INFORMATION_CONTEXT = g_bg_context_name
274: FOR UPDATE of Org_information3 -- method_of_generation_apl_num
275: , Org_information2 -- method_of_generation_emp_num

Line 335: UPDATE HR_ORGANIZATION_INFORMATION

331:
332: hr_utility.set_location(c_proc_name,12);
333: l_max_num_found := get_max_applicant_number(p_business_group_id);
334:
335: UPDATE HR_ORGANIZATION_INFORMATION
336: SET Org_information3 = g_automatic_method -- method_of_generation_apl_num
337: WHERE organization_id = l_organization_id
338: AND ORG_INFORMATION_CONTEXT = g_bg_context_name;
339:

Line 361: UPDATE HR_ORGANIZATION_INFORMATION

357: else
358: l_max_num_found := get_max_employee_number(p_business_group_id);
359: end if;
360:
361: UPDATE HR_ORGANIZATION_INFORMATION
362: SET Org_information2 = g_automatic_method -- method_of_generation_emp_num
363: WHERE organization_id = l_organization_id
364: AND ORG_INFORMATION_CONTEXT = g_bg_context_name;
365:

Line 386: UPDATE HR_ORGANIZATION_INFORMATION

382: else
383: l_max_num_found := get_max_cwk_number(p_business_group_id);
384: end if;
385:
386: UPDATE HR_ORGANIZATION_INFORMATION
387: SET Org_information16 = g_automatic_method -- method_of_generation_cwk_num
388: WHERE organization_id = l_organization_id
389: AND ORG_INFORMATION_CONTEXT = g_bg_context_name;
390:

Line 643: ,hr_organization_information hoi

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;

Line 652: ,hr_organization_information hoi

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;

Line 661: ,hr_organization_information hoi

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
665: and png.type = cp_person_type;