APPS.PER_BG_NUMBERING_METHOD_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 257: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,

253: PRAGMA EXCEPTION_INIT(e_ResourceBusy, -54);
254:
255: TYPE t_bgRecord IS RECORD
256: (
257: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
258: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
259: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
260: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
261: );

Line 258: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,

254:
255: TYPE t_bgRecord IS RECORD
256: (
257: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
258: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
259: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
260: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
261: );
262:

Line 259: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,

255: TYPE t_bgRecord IS RECORD
256: (
257: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
258: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
259: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
260: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
261: );
262:
263: l_max_num_found number := 0;

Line 260: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE

256: (
257: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
258: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
259: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
260: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
261: );
262:
263: l_max_num_found number := 0;
264: l_message varchar2(200) := null;

Line 277: from hr_organization_information

273: -- Returns the current method of number generation
274: --
275: cursor csr_method(cp_bg_id per_all_people.business_group_id%TYPE) is
276: SELECT organization_id, Org_information2, Org_information3, Org_information16
277: from hr_organization_information
278: where organization_id = cp_bg_id
279: and ORG_INFORMATION_CONTEXT = g_bg_context_name
280: FOR UPDATE of Org_information3 -- method_of_generation_apl_num
281: , Org_information2 -- method_of_generation_emp_num

Line 341: UPDATE HR_ORGANIZATION_INFORMATION

337:
338: hr_utility.set_location(c_proc_name,12);
339: l_max_num_found := get_max_applicant_number(p_business_group_id);
340:
341: UPDATE HR_ORGANIZATION_INFORMATION
342: SET Org_information3 = g_automatic_method -- method_of_generation_apl_num
343: WHERE organization_id = l_organization_id
344: AND ORG_INFORMATION_CONTEXT = g_bg_context_name;
345:

Line 367: UPDATE HR_ORGANIZATION_INFORMATION

363: else
364: l_max_num_found := get_max_employee_number(p_business_group_id);
365: end if;
366:
367: UPDATE HR_ORGANIZATION_INFORMATION
368: SET Org_information2 = g_automatic_method -- method_of_generation_emp_num
369: WHERE organization_id = l_organization_id
370: AND ORG_INFORMATION_CONTEXT = g_bg_context_name;
371:

Line 392: UPDATE HR_ORGANIZATION_INFORMATION

388: else
389: l_max_num_found := get_max_cwk_number(p_business_group_id);
390: end if;
391:
392: UPDATE HR_ORGANIZATION_INFORMATION
393: SET Org_information16 = g_automatic_method -- method_of_generation_cwk_num
394: WHERE organization_id = l_organization_id
395: AND ORG_INFORMATION_CONTEXT = g_bg_context_name;
396:

Line 649: ,hr_organization_information hoi

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;

Line 658: ,hr_organization_information hoi

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;

Line 667: ,hr_organization_information hoi

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