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_UPDATE dependencies on GHR_PA_REQUESTS

Line 53: from ghr_pa_requests

49: -- Bug# 7269520 Added the below cursor to check pay plan
50: -- and valid grade combination for auto population of P11 remarks
51: CURSOR C5 is
52: select to_pay_plan, to_grade_or_level
53: from ghr_pa_requests
54: where pa_request_id = p_pa_request_id;
55:
56: --Bug # 7573846 Added the below cursor to fetch lac codes
57: CURSOR get_pa_det

Line 63: from ghr_pa_requests

59: select first_action_la_code1,first_action_la_code2
60: ,second_action_la_code1,second_action_la_code2,
61: first_noa_code,
62: second_noa_code
63: from ghr_pa_requests
64: where pa_request_id = p_pa_request_id;
65:
66:
67:

Line 80: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;

76: l_user_table_name pay_user_tables.user_table_name%type;
77: l_retained_grade_info ghr_pay_calc.retained_grade_rec_type;
78: l_retained_grade varchar2(10);
79: -- Bug # 7269520
80: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;
81: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%type;
82: -- Bug # 7269520
83:
84: begin

Line 81: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%type;

77: l_retained_grade_info ghr_pay_calc.retained_grade_rec_type;
78: l_retained_grade varchar2(10);
79: -- Bug # 7269520
80: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;
81: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%type;
82: -- Bug # 7269520
83:
84: begin
85: hr_utility.set_location('Entering ' ||l_proc,5);

Line 350: ( p_imm_pa_request_rec in out nocopy ghr_pa_requests%rowtype,

346: -- ********************************
347: --
348:
349: procedure Process_Immediate_Update
350: ( p_imm_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
351: p_imm_pa_request_ei_rec in ghr_pa_request_extra_info%rowtype,
352: p_imm_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
353: p_capped_other_pay in out nocopy number
354: )

Line 358: l_imm_pa_request_rec ghr_pa_requests%rowtype;

354: )
355: is
356:
357: l_session ghr_history_api.g_session_var_type;
358: l_imm_pa_request_rec ghr_pa_requests%rowtype;
359: l_imm_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
360: l_capped_other_pay_in number; /* Added for NOCOPY changes */
361: l_imm_asg_sf52 ghr_api.asg_sf52_type;
362: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;

Line 359: l_imm_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */

355: is
356:
357: l_session ghr_history_api.g_session_var_type;
358: l_imm_pa_request_rec ghr_pa_requests%rowtype;
359: l_imm_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
360: l_capped_other_pay_in number; /* Added for NOCOPY changes */
361: l_imm_asg_sf52 ghr_api.asg_sf52_type;
362: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
363: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;

Line 442: l_pa_request_id ghr_pa_requests.pa_request_id%type;

438: --
439: l_health_plan pay_element_entry_values.screen_entry_value%type;
440: l_error_flag boolean;
441: --
442: l_pa_request_id ghr_pa_requests.pa_request_id%type;
443: l_pay_calc_in_rec ghr_pay_calc.pay_calc_in_rec_type;
444: l_pay_calc_out_rec ghr_pay_calc.pay_calc_out_rec_type;
445: l_message_set boolean;
446: l_calculated boolean;

Line 515: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

511: AND c_effective_date between effective_start_date and effective_end_date;
512:
513: --end of Bug # 5195518
514: --Begin Bug# 4691288
515: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
516: l_pay_plan ghr_pa_requests.to_pay_plan%type;
517: l_record_found BOOLEAN := FALSE;
518:
519:

Line 516: l_pay_plan ghr_pa_requests.to_pay_plan%type;

512:
513: --end of Bug # 5195518
514: --Begin Bug# 4691288
515: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
516: l_pay_plan ghr_pa_requests.to_pay_plan%type;
517: l_record_found BOOLEAN := FALSE;
518:
519:
520: CURSOR cur_grd1 IS

Line 938: ,p_ghr_pa_requests => p_imm_pa_request_rec

934: p_pos_grp1_type => l_imm_pos_grp1
935: ,p_pos_grp2_type => l_imm_pos_grp2
936: ,p_pos_oblig_type => l_imm_pos_oblig
937: ,p_pos_valid_grade_type => l_imm_pos_valid_grade
938: ,p_ghr_pa_requests => p_imm_pa_request_rec
939: ,p_asg_sf52_type => l_imm_asg_sf52
940: );
941:
942:

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

1301: -- p_pa_request_extra_info - pa_request_extra_info for the current pa_Request
1302: --
1303:
1304: PROCEDURE MAIN
1305: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
1306: p_pa_request_ei_rec in ghr_pa_request_extra_info%rowtype,
1307: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
1308: p_capped_other_pay in number default null
1309: )

Line 1313: --l_rec ghr_pa_requests%rowtype ;

1309: )
1310: IS
1311:
1312: l_proc varchar2(70) := 'Main';
1313: --l_rec ghr_pa_requests%rowtype ;
1314: l_notification_id ghr_pa_requests.pa_notification_id%type;
1315: l_person_type per_person_types.system_person_type%type;
1316: l_pa_request_rec ghr_pa_requests%rowtype;
1317: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */

Line 1314: l_notification_id ghr_pa_requests.pa_notification_id%type;

1310: IS
1311:
1312: l_proc varchar2(70) := 'Main';
1313: --l_rec ghr_pa_requests%rowtype ;
1314: l_notification_id ghr_pa_requests.pa_notification_id%type;
1315: l_person_type per_person_types.system_person_type%type;
1316: l_pa_request_rec ghr_pa_requests%rowtype;
1317: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1318: l_position_id per_positions.position_id%type;

Line 1316: l_pa_request_rec ghr_pa_requests%rowtype;

1312: l_proc varchar2(70) := 'Main';
1313: --l_rec ghr_pa_requests%rowtype ;
1314: l_notification_id ghr_pa_requests.pa_notification_id%type;
1315: l_person_type per_person_types.system_person_type%type;
1316: l_pa_request_rec ghr_pa_requests%rowtype;
1317: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1318: l_position_id per_positions.position_id%type;
1319: l_date_end per_positions.date_end%type;
1320:

Line 1317: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */

1313: --l_rec ghr_pa_requests%rowtype ;
1314: l_notification_id ghr_pa_requests.pa_notification_id%type;
1315: l_person_type per_person_types.system_person_type%type;
1316: l_pa_request_rec ghr_pa_requests%rowtype;
1317: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1318: l_position_id per_positions.position_id%type;
1319: l_date_end per_positions.date_end%type;
1320:
1321: Cursor c_sf50 is

Line 1323: from ghr_pa_requests par

1319: l_date_end per_positions.date_end%type;
1320:
1321: Cursor c_sf50 is
1322: select pa_notification_id
1323: from ghr_pa_requests par
1324: where par.pa_request_id = p_pa_request_rec.pa_request_id;
1325:
1326: Cursor c_pos_end_date is
1327: select date_end