eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PER_BUS dependencies on PER_BUSINESS_GROUPS

Line 1444: ,p_legislation_code in per_business_groups.legislation_code%TYPE

1440: ,p_date_of_birth in date
1441: ,p_sex in per_all_people_f.sex%TYPE
1442: ,p_effective_date in date
1443: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1444: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1445: ,p_person_type_id in per_all_people_f.person_type_id%TYPE) is
1446:
1447: -- declaring those variable which are not present in the previous
1448: -- chk_national_identifier

Line 1515: ,p_legislation_code in per_business_groups.legislation_code%TYPE

1511: ,p_date_of_birth in date
1512: ,p_sex in per_all_people_f.sex%TYPE
1513: ,p_effective_date in date
1514: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1515: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1516: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1517:
1518: --added new parameter for bug 6241572
1519: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL

Line 1739: from per_business_groups pbg

1735: l_emp_ni boolean := false;
1736: --
1737: cursor csr_gen_method is
1738: select pbg.method_of_generation_emp_num
1739: from per_business_groups pbg
1740: where pbg.business_group_id = p_business_group_id;
1741: --
1742: -- Declare the function emp_sys_per_type_change
1743: --

Line 2232: from per_business_groups pbg

2228: l_npw_ni boolean := false;
2229: --
2230: cursor csr_gen_method is
2231: select pbg.method_of_generation_cwk_num
2232: from per_business_groups pbg
2233: where pbg.business_group_id = p_business_group_id;
2234: --
2235: -- Declare the function emp_ni_change
2236: --

Line 2959: p_legislation_code in per_business_groups.legislation_code%TYPE) is

2955: p_town_of_birth in per_all_people_f.town_of_birth%TYPE,
2956: p_effective_date in date,
2957: p_validation_start_date in date,
2958: p_validation_end_date in date,
2959: p_legislation_code in per_business_groups.legislation_code%TYPE) is
2960: --
2961: --
2962: CURSOR csr_plfi is
2963: SELECT rule_type

Line 3073: p_legislation_code in per_business_groups.legislation_code%TYPE) is

3069: p_region_of_birth in per_all_people_f.region_of_birth%TYPE,
3070: p_effective_date in date,
3071: p_validation_start_date in date,
3072: p_validation_end_date in date,
3073: p_legislation_code in per_business_groups.legislation_code%TYPE) is
3074: --
3075: --
3076: CURSOR csr_plfi is
3077: SELECT rule_type

Line 6308: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;

6304: is
6305: --
6306: l_proc varchar2(72) := g_package||'chk_applicant_number';
6307: l_api_updating boolean;
6308: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;
6309: l_system_person_type per_person_types.system_person_type%TYPE;
6310: l_employee_number per_all_people_f.employee_number%TYPE;
6311: l_npw_number per_all_people_f.npw_number%TYPE;
6312: l_apl_sys boolean := false;

Line 6318: from per_business_groups pbg

6314: -- Cursor to get number generation method for Bus Group
6315: --
6316: cursor csr_gen_meth is
6317: select pbg.method_of_generation_apl_num
6318: from per_business_groups pbg
6319: where pbg.business_group_id = p_business_group_id;
6320: --
6321: --
6322: -- Declare the function apl_sys_per_type_change

Line 7081: ,p_legislation_code in per_business_groups.legislation_code%TYPE

7077: -- Internal Table Handler Use Only.
7078: --
7079: procedure chk_per_information_category
7080: (p_per_information_category in out nocopy per_all_people_f.per_information_category%TYPE
7081: ,p_legislation_code in per_business_groups.legislation_code%TYPE
7082: ) is
7083: --
7084: l_ddf_exists varchar2(1);
7085: --

Line 7746: l_legislation_code per_business_groups.legislation_code%TYPE;

7742: p_dob_null_warning out nocopy boolean,
7743: p_orig_hire_warning out nocopy boolean) is
7744: --
7745: l_proc varchar2(72);
7746: l_legislation_code per_business_groups.legislation_code%TYPE;
7747: --
7748: l_first_name per_all_people_f.first_name%TYPE;
7749: l_last_name per_all_people_f.last_name%TYPE;
7750: l_output varchar2(150);

Line 7756: from per_business_groups pbg

7752: l_duplicate_flag varchar2(1);
7753: --
7754: cursor csr_bg is
7755: select legislation_code
7756: from per_business_groups pbg
7757: where pbg.business_group_id = p_rec.business_group_id;
7758: --
7759: -- Added for 3104595 starts here
7760: cursor csr_bg_start_date is

Line 7762: from per_business_groups pbg

7758: --
7759: -- Added for 3104595 starts here
7760: cursor csr_bg_start_date is
7761: select date_from
7762: from per_business_groups pbg
7763: where pbg.business_group_id = p_rec.business_group_id;
7764: --
7765: l_bg_start_date date;
7766: -- Added for 3104595 ends here

Line 8469: l_legislation_code per_business_groups.legislation_code%TYPE;

8465: p_dob_null_warning out nocopy boolean,
8466: p_orig_hire_warning out nocopy boolean) is
8467: --
8468: l_proc varchar2(72);
8469: l_legislation_code per_business_groups.legislation_code%TYPE;
8470: --
8471: l_first_name per_all_people_f.first_name%TYPE;
8472: l_last_name per_all_people_f.last_name%TYPE;
8473: l_output varchar2(150);

Line 8479: from per_business_groups pbg

8475: l_duplicate_flag varchar2(1);
8476: --
8477: cursor csr_bg is
8478: select legislation_code
8479: from per_business_groups pbg
8480: where pbg.business_group_id = p_rec.business_group_id;
8481: --
8482: Begin
8483: if g_debug then