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 788: l_per_extra_info_rec per_people_extra_info%rowtype;

784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
786: )
787: is
788: l_per_extra_info_rec per_people_extra_info%rowtype;
789: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
790: l_pos_extra_info_rec per_position_extra_info%rowtype;
791: l_proc varchar2(70) := 'Retrieve_all_extra_info';
792: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;

Line 822: from per_people_Extra_info pei

818: pei_information5 pay_plan,
819: pei_information6 pay_table_id,
820: pei_information7 locality_percent,
821: pei_information8 pay_basis
822: from per_people_Extra_info pei
823: where pei.person_Extra_info_id = p_per_retained_grade.person_extra_info_id;
824:
825: -- Bug 3390876 Get User Status
826: CURSOR c_user_status(c_assignment_id per_all_assignments_f.assignment_id%type,

Line 847: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

843: p_person_extra_info_id out nocopy number
844: )
845: is
846: l_proc varchar2(72) := 'get_ret_grade';
847: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
848: l_request_id ghr_pa_requests.pa_request_id%type;
849:
850: CURSOR c1(c_request_id in number) is
851: SELECT par.altered_pa_request_id

Line 3262: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

3258: AND pei.pa_request_id = c_request_id
3259: AND pei.information_type = 'GHR_US_PAR_TERM_RET_GRADE';
3260:
3261: l_request_id ghr_pa_requests.pa_request_id%type;
3262: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
3263:
3264: begin
3265: l_request_id := p_request_id;
3266: loop

Line 3287: FROM per_people_extra_info

3283: --
3284: Procedure term_retained_grade is
3285: CURSOR c1 (p_pei_id number) is
3286: SELECT person_extra_info_id, object_version_number
3287: FROM per_people_extra_info
3288: WHERE person_extra_info_id = p_pei_id;
3289:
3290: l_proc varchar2(72) := 'non_sf52_extra - sss';
3291: l_per_extra_info_rec per_people_extra_info%rowtype;

Line 3291: l_per_extra_info_rec per_people_extra_info%rowtype;

3287: FROM per_people_extra_info
3288: WHERE person_extra_info_id = p_pei_id;
3289:
3290: l_proc varchar2(72) := 'non_sf52_extra - sss';
3291: l_per_extra_info_rec per_people_extra_info%rowtype;
3292: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
3293: l_result_code varchar2(100);
3294:
3295: Begin

Line 3292: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;

3288: WHERE person_extra_info_id = p_pei_id;
3289:
3290: l_proc varchar2(72) := 'non_sf52_extra - sss';
3291: l_per_extra_info_rec per_people_extra_info%rowtype;
3292: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
3293: l_result_code varchar2(100);
3294:
3295: Begin
3296: -- If it is a termination of retention grade , let us nullify all the entries in the per_retained_grade