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 351: ( p_imm_pa_request_rec in out nocopy ghr_pa_requests%rowtype,

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

Line 359: l_imm_pa_request_rec ghr_pa_requests%rowtype;

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

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

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

Line 446: l_pa_request_id ghr_pa_requests.pa_request_id%type;

442: --
443: l_health_plan pay_element_entry_values.screen_entry_value%type;
444: l_error_flag boolean;
445: --
446: l_pa_request_id ghr_pa_requests.pa_request_id%type;
447: l_pay_calc_in_rec ghr_pay_calc.pay_calc_in_rec_type;
448: l_pay_calc_out_rec ghr_pay_calc.pay_calc_out_rec_type;
449: l_message_set boolean;
450: l_calculated boolean;

Line 519: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

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

Line 520: l_pay_plan ghr_pa_requests.to_pay_plan%type;

516:
517: --end of Bug # 5195518
518: --Begin Bug# 4691288
519: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
520: l_pay_plan ghr_pa_requests.to_pay_plan%type;
521: l_record_found BOOLEAN := FALSE;
522:
523:
524: CURSOR cur_grd1 IS

Line 556: from ghr_pa_requests

552: select noa_family_code,
553: second_noa_id,
554: second_action_la_code1,
555: second_action_la_code2
556: from ghr_pa_requests
557: where pa_request_id = l_session.pa_request_id
558: and second_noa_code is not null
559: and first_noa_code not in ('001','002')
560: and first_noa_id = p_imm_pa_request_rec.first_noa_id;

Line 566: from ghr_pa_requests

562: --8850376
563: cursor chk_sec_dual
564: is
565: select noa_family_code
566: from ghr_pa_requests
567: where pa_request_id = l_session.pa_request_id
568: and second_noa_code is not null
569: and first_noa_code not in ('001','002')
570: and second_noa_id = p_imm_pa_request_rec.first_noa_id;

Line 575: from ghr_pa_requests

571:
572: cursor chk_dual_corr
573: is
574: select mass_action_id
575: from ghr_pa_requests
576: where pa_request_id = l_session.pa_request_id
577: and first_noa_code = '002'
578: and rpa_type = 'DUAL'
579: and mass_action_id is not null;

Line 587: from ghr_pa_requests

583: is
584: select pa_request_id,first_noa_code,second_noa_code,
585: first_noa_id,second_noa_id,second_action_la_code1,second_action_la_code2,
586: noa_family_code
587: from ghr_pa_requests
588: where pa_request_id = (select min(pa_request_id)
589: from ghr_pa_requests
590: where pa_notification_id is not null
591: connect by pa_request_id = prior altered_pa_request_id

Line 589: from ghr_pa_requests

585: first_noa_id,second_noa_id,second_action_la_code1,second_action_la_code2,
586: noa_family_code
587: from ghr_pa_requests
588: where pa_request_id = (select min(pa_request_id)
589: from ghr_pa_requests
590: where pa_notification_id is not null
591: connect by pa_request_id = prior altered_pa_request_id
592: start with pa_request_id = l_session.altered_pa_request_id)
593: and second_noa_code is not null;

Line 608: l_noa_id ghr_pa_requests.second_noa_id%type;

604: between nvl(fam.start_date_active,p_imm_pa_request_rec.effective_date)
605: and nvl(fam.end_date_active,p_imm_pa_request_rec.effective_date);
606:
607:
608: l_noa_id ghr_pa_requests.second_noa_id%type;
609: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
610: l_asg_ei_data per_assignment_extra_info%rowtype;
611: l_prev_info_type per_position_extra_info.information_type%type;
612: --End of 8267598

Line 609: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;

605: and nvl(fam.end_date_active,p_imm_pa_request_rec.effective_date);
606:
607:
608: l_noa_id ghr_pa_requests.second_noa_id%type;
609: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
610: l_asg_ei_data per_assignment_extra_info%rowtype;
611: l_prev_info_type per_position_extra_info.information_type%type;
612: --End of 8267598
613:

Line 1120: ,p_ghr_pa_requests => p_imm_pa_request_rec

1116: p_pos_grp1_type => l_imm_pos_grp1
1117: ,p_pos_grp2_type => l_imm_pos_grp2
1118: ,p_pos_oblig_type => l_imm_pos_oblig
1119: ,p_pos_valid_grade_type => l_imm_pos_valid_grade
1120: ,p_ghr_pa_requests => p_imm_pa_request_rec
1121: ,p_asg_sf52_type => l_imm_asg_sf52
1122: );
1123:
1124:

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

1512: -- p_pa_request_extra_info - pa_request_extra_info for the current pa_Request
1513: --
1514:
1515: PROCEDURE MAIN
1516: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
1517: p_pa_request_ei_rec in ghr_pa_request_extra_info%rowtype,
1518: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
1519: p_capped_other_pay in number default null
1520: )

Line 1524: --l_rec ghr_pa_requests%rowtype ;

1520: )
1521: IS
1522:
1523: l_proc varchar2(70) := 'Main';
1524: --l_rec ghr_pa_requests%rowtype ;
1525: l_notification_id ghr_pa_requests.pa_notification_id%type;
1526: l_person_type per_person_types.system_person_type%type;
1527: l_pa_request_rec ghr_pa_requests%rowtype;
1528: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */

Line 1525: l_notification_id ghr_pa_requests.pa_notification_id%type;

1521: IS
1522:
1523: l_proc varchar2(70) := 'Main';
1524: --l_rec ghr_pa_requests%rowtype ;
1525: l_notification_id ghr_pa_requests.pa_notification_id%type;
1526: l_person_type per_person_types.system_person_type%type;
1527: l_pa_request_rec ghr_pa_requests%rowtype;
1528: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1529: l_position_id per_positions.position_id%type;

Line 1527: l_pa_request_rec ghr_pa_requests%rowtype;

1523: l_proc varchar2(70) := 'Main';
1524: --l_rec ghr_pa_requests%rowtype ;
1525: l_notification_id ghr_pa_requests.pa_notification_id%type;
1526: l_person_type per_person_types.system_person_type%type;
1527: l_pa_request_rec ghr_pa_requests%rowtype;
1528: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1529: l_position_id per_positions.position_id%type;
1530: l_date_end per_positions.date_end%type;
1531:

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

1524: --l_rec ghr_pa_requests%rowtype ;
1525: l_notification_id ghr_pa_requests.pa_notification_id%type;
1526: l_person_type per_person_types.system_person_type%type;
1527: l_pa_request_rec ghr_pa_requests%rowtype;
1528: l_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
1529: l_position_id per_positions.position_id%type;
1530: l_date_end per_positions.date_end%type;
1531:
1532: Cursor c_sf50 is

Line 1534: from ghr_pa_requests par

1530: l_date_end per_positions.date_end%type;
1531:
1532: Cursor c_sf50 is
1533: select pa_notification_id
1534: from ghr_pa_requests par
1535: where par.pa_request_id = p_pa_request_rec.pa_request_id;
1536:
1537: Cursor c_pos_end_date is
1538: select date_end