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 GHR_PA_REQUESTS

Line 7: (p_pa_req_rec IN ghr_pa_requests%rowtype,

3: g_effective_date date;
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)

Line 44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,

40: --
41: -- This procedure retrieve data from HR extra information tables and all other data required for CPDF Validations
42: --
43: Procedure populate_record_groups
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,

Line 405: -- With the new ghr_pa_requests table, we just need to fetch the agency_code.

401: hr_utility.set_location('Relocation EXP ' || l_imm_relocation_bonus.p_date_reloc_exp,2);
402: hr_utility.set_location('Recruitment EXP ' || l_imm_recruitment_bonus.p_date_recruit_exp,3);
403:
404:
405: -- With the new ghr_pa_requests table, we just need to fetch the agency_code.
406: -- And this info. is required by CPDF edits and later by the SF50 Report
407:
408: SF52_br_extra_info
409: (P_PA_REQUEST_REC => p_pa_request_rec,

Line 470: -- as it is not stored in the ghr_pa_requests table

466: hr_utility.set_location('from_duty_station '||l_imm_sf52_from_data.duty_station_location_id,4 );
467:
468:
469: -- Should retrieve Employee_sex(per_people_f for the person_id , for a specific date),
470: -- as it is not stored in the ghr_pa_requests table
471:
472: For per_sex in c_person_sex loop
473: l_imm_personal_info.p_sex := per_sex.sex;
474: End loop;

Line 777: (p_pa_request_rec in ghr_pa_requests%rowtype,

773: -- *******************************
774: --
775:
776: Procedure retrieve_all_extra_info
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,

Line 847: c_effective_date ghr_pa_requests.effective_date%type) IS

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,
847: c_effective_date ghr_pa_requests.effective_date%type) IS
848: SELECT
849: ast.user_status,
850: ast.per_system_status,
851: asg.effective_start_date

Line 868: l_request_id ghr_pa_requests.pa_request_id%type;

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
872: FROM ghr_pa_requests par

Line 872: FROM ghr_pa_requests par

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
872: FROM ghr_pa_requests par
873: WHERE par.pa_request_id = c_request_id;
874:
875: CURSOR c2 (c_request_id number) is
876: SELECT par.pa_request_id, par.altered_pa_request_id, pei.rei_information3

Line 877: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei

873: WHERE par.pa_request_id = c_request_id;
874:
875: CURSOR c2 (c_request_id number) is
876: SELECT par.pa_request_id, par.altered_pa_request_id, pei.rei_information3
877: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei
878: WHERE par.pa_request_id = pei.pa_request_id
879: AND pei.pa_request_id = c_request_id
880: AND pei.information_type = 'GHR_US_PAR_TERM_RET_GRADE';
881:

Line 1655: P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE

1651: --
1652:
1653: procedure SF52_br_extra_info
1654: (
1655: P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE
1656: ,p_agency_code out nocopy varchar2
1657: ) is
1658: --
1659: l_bus_gp number;

Line 1735: (p_pa_request_rec in ghr_pa_requests%rowtype,

1731:
1732: -- This procedure Updates the various Record Groups with Data from the SF52 Form.
1733:
1734: procedure Process_Sf52_Extra_Info
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,

Line 2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,

2188: -- **********************************************************
2189: --
2190: PROCEDURE Process_Non_Sf52_Extra_Info
2191: --
2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,

Line 2357: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;

2353: and user_status='Active Appointment';
2354: --end Bug# 6083404
2355:
2356: --Begin Bug# 10182526
2357: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;
2358: CURSOR c_detail_first_nte_date is
2359: SELECT first_noa_information1
2360: FROM ghr_pa_requests
2361: WHERE pa_request_id = p_pa_request_rec.pa_request_id;

Line 2360: FROM ghr_pa_requests

2356: --Begin Bug# 10182526
2357: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;
2358: CURSOR c_detail_first_nte_date is
2359: SELECT first_noa_information1
2360: FROM ghr_pa_requests
2361: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
2362:
2363: CURSOR c_detail_second_nte_date is
2364: SELECT second_noa_information1

Line 2365: FROM ghr_pa_requests

2361: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
2362:
2363: CURSOR c_detail_second_nte_date is
2364: SELECT second_noa_information1
2365: FROM ghr_pa_requests
2366: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
2367: --end Bug# 10182526
2368: --Begin Bug# 13942237
2369: /*l_pos_extra_info_rec per_position_extra_info%rowtype;

Line 3408: -- ghr_pa_requests table - 10/08/98

3404:
3405: Begin
3406: --
3407: -- commented award percentage, as a new column has been added in the
3408: -- ghr_pa_requests table - 10/08/98
3409: --
3410: --Begin Bug 9538056
3411: IF NOT(p_pa_request_rec.first_noa_code = '892' AND
3412: (NVL(p_pa_request_rec.first_action_la_code1,'111') = 'RBM' or NVL(p_pa_request_rec.first_action_la_code2,'111') = 'RBM')) THEN

Line 3679: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei

3675: Function fetch_extra_info_id (p_request_id number)
3676: return number is
3677: CURSOR c2 (c_request_id number) is
3678: SELECT par.pa_request_id, par.altered_pa_request_id, pei.rei_information3
3679: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei
3680: WHERE par.pa_request_id = pei.pa_request_id(+)
3681: AND pei.pa_request_id = c_request_id
3682: AND pei.information_type = 'GHR_US_PAR_TERM_RET_GRADE';
3683:

Line 3684: l_request_id ghr_pa_requests.pa_request_id%type;

3680: WHERE par.pa_request_id = pei.pa_request_id(+)
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;

Line 5531: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator

5527:
5528: -- Bug#5668878 Begin
5529: IF p_pa_request_rec.first_noa_code = '892' THEN
5530:
5531: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator
5532: (p_pa_request_rec.to_position_id,
5533: p_pa_request_rec.effective_date);
5534:
5535: IF l_psi <> '00' THEN