APPS.HR_EMPLOYEE_SWI dependencies on PER_ALL_PEOPLE

Line 1380: l_organization_id per_all_people_f.business_group_id%TYPE;

1376: );
1377:
1378: l_message varchar2(200) := null;
1379:
1380: l_organization_id per_all_people_f.business_group_id%TYPE;
1381: l_rec_per_bg_groups t_bgRecord;
1382: --
1383: -- Returns the current method of number generation
1384: --

Line 1385: cursor csr_method(cp_bg_id per_all_people.business_group_id%TYPE) is

1381: l_rec_per_bg_groups t_bgRecord;
1382: --
1383: -- Returns the current method of number generation
1384: --
1385: cursor csr_method(cp_bg_id per_all_people.business_group_id%TYPE) is
1386: SELECT organization_id,
1387: org_information2,
1388: org_information3,
1389: org_information16

Line 1406: -- Lock per_all_people_f to ensure person records are not

1402: --
1403: BEGIN
1404: l_organization_id := p_business_group_id;
1405:
1406: -- Lock per_all_people_f to ensure person records are not
1407: -- created/updated/deleted
1408: --
1409: hr_utility.set_location(c_proc_name,20);
1410:

Line 1411: --LOCK TABLE per_all_people_f

1407: -- created/updated/deleted
1408: --
1409: hr_utility.set_location(c_proc_name,20);
1410:
1411: --LOCK TABLE per_all_people_f
1412: -- IN EXCLUSIVE MODE NOWAIT;
1413: --
1414: open csr_method(p_business_group_id);
1415: fetch csr_method into l_rec_per_bg_groups;