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.GHR_SF52_PRE_UPDATE dependencies on PER_PEOPLE_EXTRA_INFO

Line 8: p_pei_auth_code1 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,

4: --
5:
6: PROCEDURE get_auth_codes
7: (p_pa_req_rec IN ghr_pa_requests%rowtype,
8: p_pei_auth_code1 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
9: p_pei_auth_code2 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
10: p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,
11: p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type)
12: IS

Line 9: p_pei_auth_code2 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,

5:
6: PROCEDURE get_auth_codes
7: (p_pa_req_rec IN ghr_pa_requests%rowtype,
8: p_pei_auth_code1 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
9: p_pei_auth_code2 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
10: p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,
11: p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type)
12: IS
13: l_proc varchar2(70) := 'get_auth_codes';

Line 10: p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,

6: PROCEDURE get_auth_codes
7: (p_pa_req_rec IN ghr_pa_requests%rowtype,
8: p_pei_auth_code1 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
9: p_pei_auth_code2 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
10: p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,
11: p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type)
12: IS
13: l_proc varchar2(70) := 'get_auth_codes';
14: l_pei_extra_info per_people_extra_info%rowtype;

Line 11: p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type)

7: (p_pa_req_rec IN ghr_pa_requests%rowtype,
8: p_pei_auth_code1 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
9: p_pei_auth_code2 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
10: p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,
11: p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type)
12: IS
13: l_proc varchar2(70) := 'get_auth_codes';
14: l_pei_extra_info per_people_extra_info%rowtype;
15:

Line 14: l_pei_extra_info per_people_extra_info%rowtype;

10: p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,
11: p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type)
12: IS
13: l_proc varchar2(70) := 'get_auth_codes';
14: l_pei_extra_info per_people_extra_info%rowtype;
15:
16: BEGIN
17:
18: hr_utility.set_location('Entering: ' || l_proc, 10);

Line 808: l_per_extra_info_rec per_people_extra_info%rowtype;

804: --BUG # 14276354 added new Person group2 segments
805: p_per_group2 in out nocopy ghr_api.per_group2_type
806: )
807: is
808: l_per_extra_info_rec per_people_extra_info%rowtype;
809: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
810: l_pos_extra_info_rec per_position_extra_info%rowtype;
811: l_proc varchar2(70) := 'Retrieve_all_extra_info';
812: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;

Line 842: from per_people_Extra_info pei

838: pei_information5 pay_plan,
839: pei_information6 pay_table_id,
840: pei_information7 locality_percent,
841: pei_information8 pay_basis
842: from per_people_Extra_info pei
843: where pei.person_Extra_info_id = p_per_retained_grade.person_extra_info_id;
844:
845: -- Bug 3390876 Get User Status
846: CURSOR c_user_status(c_assignment_id per_all_assignments_f.assignment_id%type,

Line 867: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

863: p_person_extra_info_id out nocopy number
864: )
865: is
866: l_proc varchar2(72) := 'get_ret_grade';
867: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
868: l_request_id ghr_pa_requests.pa_request_id%type;
869:
870: CURSOR c1(c_request_id in number) is
871: SELECT par.altered_pa_request_id

Line 3685: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

3681: AND pei.pa_request_id = c_request_id
3682: AND pei.information_type = 'GHR_US_PAR_TERM_RET_GRADE';
3683:
3684: l_request_id ghr_pa_requests.pa_request_id%type;
3685: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
3686:
3687: begin
3688: l_request_id := p_request_id;
3689: loop

Line 3710: FROM per_people_extra_info

3706: --
3707: Procedure term_retained_grade is
3708: CURSOR c1 (p_pei_id number) is
3709: SELECT person_extra_info_id, object_version_number
3710: FROM per_people_extra_info
3711: WHERE person_extra_info_id = p_pei_id;
3712:
3713: l_proc varchar2(72) := 'non_sf52_extra - sss';
3714: l_per_extra_info_rec per_people_extra_info%rowtype;

Line 3714: l_per_extra_info_rec per_people_extra_info%rowtype;

3710: FROM per_people_extra_info
3711: WHERE person_extra_info_id = p_pei_id;
3712:
3713: l_proc varchar2(72) := 'non_sf52_extra - sss';
3714: l_per_extra_info_rec per_people_extra_info%rowtype;
3715: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
3716: l_result_code varchar2(100);
3717:
3718: Begin

Line 3715: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;

3711: WHERE person_extra_info_id = p_pei_id;
3712:
3713: l_proc varchar2(72) := 'non_sf52_extra - sss';
3714: l_per_extra_info_rec per_people_extra_info%rowtype;
3715: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
3716: l_result_code varchar2(100);
3717:
3718: Begin
3719: -- If it is a termination of retention grade , let us nullify all the entries in the per_retained_grade