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.

[Home] [Help]

APPS.PER_PER_BUS dependencies on PER_BUSINESS_GROUPS

Line 1440: ,p_legislation_code in per_business_groups.legislation_code%TYPE

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

Line 1511: ,p_legislation_code in per_business_groups.legislation_code%TYPE

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

Line 1735: from per_business_groups pbg

1731: l_emp_ni boolean := false;
1732: --
1733: cursor csr_gen_method is
1734: select pbg.method_of_generation_emp_num
1735: from per_business_groups pbg
1736: where pbg.business_group_id = p_business_group_id;
1737: --
1738: -- Declare the function emp_sys_per_type_change
1739: --

Line 2228: from per_business_groups pbg

2224: l_npw_ni boolean := false;
2225: --
2226: cursor csr_gen_method is
2227: select pbg.method_of_generation_cwk_num
2228: from per_business_groups pbg
2229: where pbg.business_group_id = p_business_group_id;
2230: --
2231: -- Declare the function emp_ni_change
2232: --

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

2945: p_town_of_birth in per_all_people_f.town_of_birth%TYPE,
2946: p_effective_date in date,
2947: p_validation_start_date in date,
2948: p_validation_end_date in date,
2949: p_legislation_code in per_business_groups.legislation_code%TYPE) is
2950: --
2951: --
2952: CURSOR csr_plfi is
2953: SELECT rule_type

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

3059: p_region_of_birth in per_all_people_f.region_of_birth%TYPE,
3060: p_effective_date in date,
3061: p_validation_start_date in date,
3062: p_validation_end_date in date,
3063: p_legislation_code in per_business_groups.legislation_code%TYPE) is
3064: --
3065: --
3066: CURSOR csr_plfi is
3067: SELECT rule_type

Line 6297: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;

6293: is
6294: --
6295: l_proc varchar2(72) := g_package||'chk_applicant_number';
6296: l_api_updating boolean;
6297: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;
6298: l_system_person_type per_person_types.system_person_type%TYPE;
6299: l_employee_number per_all_people_f.employee_number%TYPE;
6300: l_npw_number per_all_people_f.npw_number%TYPE;
6301: l_apl_sys boolean := false;

Line 6307: from per_business_groups pbg

6303: -- Cursor to get number generation method for Bus Group
6304: --
6305: cursor csr_gen_meth is
6306: select pbg.method_of_generation_apl_num
6307: from per_business_groups pbg
6308: where pbg.business_group_id = p_business_group_id;
6309: --
6310: --
6311: -- Declare the function apl_sys_per_type_change

Line 7070: ,p_legislation_code in per_business_groups.legislation_code%TYPE

7066: -- Internal Table Handler Use Only.
7067: --
7068: procedure chk_per_information_category
7069: (p_per_information_category in out nocopy per_all_people_f.per_information_category%TYPE
7070: ,p_legislation_code in per_business_groups.legislation_code%TYPE
7071: ) is
7072: --
7073: l_ddf_exists varchar2(1);
7074: --

Line 7735: l_legislation_code per_business_groups.legislation_code%TYPE;

7731: p_dob_null_warning out nocopy boolean,
7732: p_orig_hire_warning out nocopy boolean) is
7733: --
7734: l_proc varchar2(72);
7735: l_legislation_code per_business_groups.legislation_code%TYPE;
7736: --
7737: l_first_name per_all_people_f.first_name%TYPE;
7738: l_last_name per_all_people_f.last_name%TYPE;
7739: l_output varchar2(150);

Line 7745: from per_business_groups pbg

7741: l_duplicate_flag varchar2(1);
7742: --
7743: cursor csr_bg is
7744: select legislation_code
7745: from per_business_groups pbg
7746: where pbg.business_group_id = p_rec.business_group_id;
7747: --
7748: -- Added for 3104595 starts here
7749: cursor csr_bg_start_date is

Line 7751: from per_business_groups pbg

7747: --
7748: -- Added for 3104595 starts here
7749: cursor csr_bg_start_date is
7750: select date_from
7751: from per_business_groups pbg
7752: where pbg.business_group_id = p_rec.business_group_id;
7753: --
7754: l_bg_start_date date;
7755: -- Added for 3104595 ends here

Line 8458: l_legislation_code per_business_groups.legislation_code%TYPE;

8454: p_dob_null_warning out nocopy boolean,
8455: p_orig_hire_warning out nocopy boolean) is
8456: --
8457: l_proc varchar2(72);
8458: l_legislation_code per_business_groups.legislation_code%TYPE;
8459: --
8460: l_first_name per_all_people_f.first_name%TYPE;
8461: l_last_name per_all_people_f.last_name%TYPE;
8462: l_output varchar2(150);

Line 8468: from per_business_groups pbg

8464: l_duplicate_flag varchar2(1);
8465: --
8466: cursor csr_bg is
8467: select legislation_code
8468: from per_business_groups pbg
8469: where pbg.business_group_id = p_rec.business_group_id;
8470: --
8471: Begin
8472: if g_debug then

Line 9307: from per_business_groups pbg

9303: -- Declare cursor
9304: --
9305: cursor csr_leg_code is
9306: select pbg.legislation_code
9307: from per_business_groups pbg
9308: , per_all_people_f per
9309: where per.person_id = p_person_id
9310: and pbg.business_group_id = per.business_group_id
9311: order by per.effective_start_date;