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.HR_RU_PEOPLE_LEG_HOOK dependencies on PER_ALL_PEOPLE_F

Line 41: l_per_information5 per_all_people_f.per_information5%TYPE;

37: := g_package || 'VALIDATE_PERSON_UPD';
38: l_effective_date DATE;
39: l_err NUMBER;
40: l_age NUMBER;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;

Line 42: l_per_information6 per_all_people_f.per_information6%TYPE;

38: l_effective_date DATE;
39: l_err NUMBER;
40: l_age NUMBER;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;

Line 43: l_per_information7 per_all_people_f.per_information7%TYPE;

39: l_err NUMBER;
40: l_age NUMBER;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;

Line 44: l_per_information8 per_all_people_f.per_information8%TYPE;

40: l_age NUMBER;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;

Line 45: l_per_information9 per_all_people_f.per_information9%TYPE;

41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;

Line 46: l_per_information10 per_all_people_f.per_information10%TYPE;

42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;

Line 47: l_per_information11 per_all_people_f.per_information11%TYPE;

43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;

Line 48: l_per_information12 per_all_people_f.per_information12%TYPE;

44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
52:

Line 49: l_per_information14 per_all_people_f.per_information14%TYPE;

45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
52:
53: CURSOR csr_get_mil_info (p_id NUMBER)

Line 50: l_per_information15 per_all_people_f.per_information15%TYPE;

46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
52:
53: CURSOR csr_get_mil_info (p_id NUMBER)
54: IS

Line 51: l_per_information18 per_all_people_f.per_information18%TYPE;

47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
52:
53: CURSOR csr_get_mil_info (p_id NUMBER)
54: IS
55: SELECT per_information5, per_information6, per_information7,

Line 59: FROM per_all_people_f papf

55: SELECT per_information5, per_information6, per_information7,
56: per_information8, per_information9, per_information10,
57: per_information11, per_information12, per_information13,
58: per_information14,per_information15,per_information18
59: FROM per_all_people_f papf
60: WHERE papf.person_id = p_id
61: AND p_effective_date BETWEEN papf.effective_start_date
62: AND papf.effective_end_date;
63:

Line 796: l_date_of_birth per_all_people_f.date_of_birth%TYPE;

792: IS
793: l_proc CONSTANT VARCHAR2 (72)
794: := g_package || 'UPDATE_RU_PERSON';
795: -- l_age NUMBER;
796: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
797: l_sex per_all_people_f.sex%TYPE;
798: l_per_information5 per_all_people_f.per_information5%TYPE;
799: l_system_person_type per_person_types.system_person_type%TYPE;
800: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;

Line 797: l_sex per_all_people_f.sex%TYPE;

793: l_proc CONSTANT VARCHAR2 (72)
794: := g_package || 'UPDATE_RU_PERSON';
795: -- l_age NUMBER;
796: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
797: l_sex per_all_people_f.sex%TYPE;
798: l_per_information5 per_all_people_f.per_information5%TYPE;
799: l_system_person_type per_person_types.system_person_type%TYPE;
800: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;
801: l_effective_date DATE;

Line 798: l_per_information5 per_all_people_f.per_information5%TYPE;

794: := g_package || 'UPDATE_RU_PERSON';
795: -- l_age NUMBER;
796: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
797: l_sex per_all_people_f.sex%TYPE;
798: l_per_information5 per_all_people_f.per_information5%TYPE;
799: l_system_person_type per_person_types.system_person_type%TYPE;
800: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;
801: l_effective_date DATE;
802:

Line 806: FROM per_all_people_f papf

802:
803: CURSOR csr_get_person_info (p_id NUMBER)
804: IS
805: SELECT date_of_birth, sex, per_information5
806: FROM per_all_people_f papf
807: WHERE papf.person_id = p_id
808: AND p_effective_date BETWEEN papf.effective_start_date
809: AND papf.effective_end_date;
810: