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

Line 16: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,

12: where GRADE_ID = to_number(p_grade_id);
13: --End Bug# 14514445
14:
15: Procedure term_ret_grade
16: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
17: p_person_id in per_people_f.person_id%type,
18: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
19: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
20: p_effective_date in ghr_pa_requests.effective_date%type,

Line 18: p_first_noa_id in ghr_pa_requests.first_noa_id%type,

14:
15: Procedure term_ret_grade
16: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
17: p_person_id in per_people_f.person_id%type,
18: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
19: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
20: p_effective_date in ghr_pa_requests.effective_date%type,
21: p_refresh_flag in varchar2 )
22: is

Line 19: p_second_noa_id in ghr_pa_requests.second_noa_id%type,

15: Procedure term_ret_grade
16: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
17: p_person_id in per_people_f.person_id%type,
18: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
19: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
20: p_effective_date in ghr_pa_requests.effective_date%type,
21: p_refresh_flag in varchar2 )
22: is
23:

Line 20: p_effective_date in ghr_pa_requests.effective_date%type,

16: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
17: p_person_id in per_people_f.person_id%type,
18: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
19: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
20: p_effective_date in ghr_pa_requests.effective_date%type,
21: p_refresh_flag in varchar2 )
22: is
23:
24: --Begin Bug 5923620

Line 45: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;

41: l_noa_code ghr_nature_of_actions.code%type;
42: l_first_noa_code ghr_nature_of_actions.code%type;
43: l_second_noa_code ghr_nature_of_actions.code%type;
44: l_existed BOOLEAN := FALSE;
45: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
46: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
47:
48: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
49: select code from ghr_nature_of_actions

Line 48: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is

44: l_existed BOOLEAN := FALSE;
45: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
46: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
47:
48: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
49: select code from ghr_nature_of_actions
50: where nature_of_action_id = p_noa_id;
51:
52: Cursor c_702 is

Line 212: select altered_pa_request_id from ghr_pa_requests

208: where pa_request_id = p_pa_request_id
209: and information_type = 'GHR_US_PAR_TERM_RG_PROMO';
210:
211: cursor c_altered_par_rec is
212: select altered_pa_request_id from ghr_pa_requests
213: where pa_request_id = p_pa_request_id;
214:
215: --Bug#4126188 Begin
216: cursor c_position(p_pa_req_id in number) is

Line 218: FROM ghr_pa_requests

214:
215: --Bug#4126188 Begin
216: cursor c_position(p_pa_req_id in number) is
217: SELECT from_position_id,to_position_id
218: FROM ghr_pa_requests
219: WHERE pa_request_id = p_pa_req_id;
220:
221: l_pos_ei_data per_position_extra_info%rowtype;
222: l_from_position_id ghr_pa_requests.from_position_id%type;

Line 222: l_from_position_id ghr_pa_requests.from_position_id%type;

218: FROM ghr_pa_requests
219: WHERE pa_request_id = p_pa_req_id;
220:
221: l_pos_ei_data per_position_extra_info%rowtype;
222: l_from_position_id ghr_pa_requests.from_position_id%type;
223: l_to_position_id ghr_pa_requests.to_position_id%type;
224: l_from_poid ghr_pa_requests.personnel_office_id%type;
225: l_to_poid ghr_pa_requests.personnel_office_id%type;
226: --Bug#4126188 End

Line 223: l_to_position_id ghr_pa_requests.to_position_id%type;

219: WHERE pa_request_id = p_pa_req_id;
220:
221: l_pos_ei_data per_position_extra_info%rowtype;
222: l_from_position_id ghr_pa_requests.from_position_id%type;
223: l_to_position_id ghr_pa_requests.to_position_id%type;
224: l_from_poid ghr_pa_requests.personnel_office_id%type;
225: l_to_poid ghr_pa_requests.personnel_office_id%type;
226: --Bug#4126188 End
227:

Line 224: l_from_poid ghr_pa_requests.personnel_office_id%type;

220:
221: l_pos_ei_data per_position_extra_info%rowtype;
222: l_from_position_id ghr_pa_requests.from_position_id%type;
223: l_to_position_id ghr_pa_requests.to_position_id%type;
224: l_from_poid ghr_pa_requests.personnel_office_id%type;
225: l_to_poid ghr_pa_requests.personnel_office_id%type;
226: --Bug#4126188 End
227:
228:

Line 225: l_to_poid ghr_pa_requests.personnel_office_id%type;

221: l_pos_ei_data per_position_extra_info%rowtype;
222: l_from_position_id ghr_pa_requests.from_position_id%type;
223: l_to_position_id ghr_pa_requests.to_position_id%type;
224: l_from_poid ghr_pa_requests.personnel_office_id%type;
225: l_to_poid ghr_pa_requests.personnel_office_id%type;
226: --Bug#4126188 End
227:
228:
229: BEGIN

Line 517: p_effective_date in ghr_pa_requests.effective_date%type ,

513: p_second_noa_id in number ,
514: p_person_id in per_people_f.person_id%type ,
515: p_assignment_id in per_assignments_f.assignment_id%type ,
516: p_position_id in per_positions.position_id%type ,
517: p_effective_date in ghr_pa_requests.effective_date%type ,
518: p_refresh_flag in varchar2 default 'Y'
519: )
520: is
521: l_proc varchar2(72) := g_package || 'populate_noa_spec_extra_info';

Line 550: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is

546: and fam.pa_info_type_flag = 'Y'
547: and pit.noa_family_code = fam.noa_family_code);
548: ---- and pit.information_type LIKE 'GHR_US%');
549:
550: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
551: select code from ghr_nature_of_actions
552: where nature_of_action_id = p_noa_id;
553:
554: cursor c_altered_par_rec is

Line 555: select altered_pa_request_id from ghr_pa_requests

551: select code from ghr_nature_of_actions
552: where nature_of_action_id = p_noa_id;
553:
554: cursor c_altered_par_rec is
555: select altered_pa_request_id from ghr_pa_requests
556: where pa_request_id = p_pa_request_id;
557:
558: l_noa_code ghr_nature_of_actions.code%type;
559: l_first_noa_code ghr_nature_of_actions.code%type;

Line 561: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;

557:
558: l_noa_code ghr_nature_of_actions.code%type;
559: l_first_noa_code ghr_nature_of_actions.code%type;
560: l_second_noa_code ghr_nature_of_actions.code%type;
561: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
562:
563: cursor c_orig_rei_rec is
564: select *
565: from ghr_pa_request_extra_info a

Line 693: p_effective_date in ghr_pa_requests.effective_date%type,

689: p_noa_id in number,
690: p_person_id in per_people_f.person_id%type,
691: p_assignment_id in per_assignments_f.assignment_id%type,
692: p_position_id in per_positions.position_id%type,
693: p_effective_date in ghr_pa_requests.effective_date%type,
694: p_refresh_flag in varchar2 default 'Y'
695: )
696: is
697:

Line 725: l_first_noa_code ghr_pa_requests.first_noa_code%type;

721: l_pos_refresh_flag varchar2(1);
722: -- Bug#4089400
723: l_noa_family_code ghr_noa_families.noa_family_code%type;
724: -- Bug#5039072 Added the following two parameters.
725: l_first_noa_code ghr_pa_requests.first_noa_code%type;
726: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
727: l_la_code2 ghr_pa_requests.first_action_la_code2%type;
728: l_sec_la_code1 ghr_pa_requests.second_action_la_code1%type;
729: l_sec_la_code2 ghr_pa_requests.second_action_la_code2%type;

Line 726: l_la_code1 ghr_pa_requests.first_action_la_code1%type;

722: -- Bug#4089400
723: l_noa_family_code ghr_noa_families.noa_family_code%type;
724: -- Bug#5039072 Added the following two parameters.
725: l_first_noa_code ghr_pa_requests.first_noa_code%type;
726: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
727: l_la_code2 ghr_pa_requests.first_action_la_code2%type;
728: l_sec_la_code1 ghr_pa_requests.second_action_la_code1%type;
729: l_sec_la_code2 ghr_pa_requests.second_action_la_code2%type;
730: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;

Line 727: l_la_code2 ghr_pa_requests.first_action_la_code2%type;

723: l_noa_family_code ghr_noa_families.noa_family_code%type;
724: -- Bug#5039072 Added the following two parameters.
725: l_first_noa_code ghr_pa_requests.first_noa_code%type;
726: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
727: l_la_code2 ghr_pa_requests.first_action_la_code2%type;
728: l_sec_la_code1 ghr_pa_requests.second_action_la_code1%type;
729: l_sec_la_code2 ghr_pa_requests.second_action_la_code2%type;
730: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
731: l_application_id fnd_application.application_id%type;

Line 728: l_sec_la_code1 ghr_pa_requests.second_action_la_code1%type;

724: -- Bug#5039072 Added the following two parameters.
725: l_first_noa_code ghr_pa_requests.first_noa_code%type;
726: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
727: l_la_code2 ghr_pa_requests.first_action_la_code2%type;
728: l_sec_la_code1 ghr_pa_requests.second_action_la_code1%type;
729: l_sec_la_code2 ghr_pa_requests.second_action_la_code2%type;
730: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
731: l_application_id fnd_application.application_id%type;
732: l_resp_id fnd_responsibility.responsibility_id%type;

Line 729: l_sec_la_code2 ghr_pa_requests.second_action_la_code2%type;

725: l_first_noa_code ghr_pa_requests.first_noa_code%type;
726: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
727: l_la_code2 ghr_pa_requests.first_action_la_code2%type;
728: l_sec_la_code1 ghr_pa_requests.second_action_la_code1%type;
729: l_sec_la_code2 ghr_pa_requests.second_action_la_code2%type;
730: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
731: l_application_id fnd_application.application_id%type;
732: l_resp_id fnd_responsibility.responsibility_id%type;
733:

Line 730: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;

726: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
727: l_la_code2 ghr_pa_requests.first_action_la_code2%type;
728: l_sec_la_code1 ghr_pa_requests.second_action_la_code1%type;
729: l_sec_la_code2 ghr_pa_requests.second_action_la_code2%type;
730: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
731: l_application_id fnd_application.application_id%type;
732: l_resp_id fnd_responsibility.responsibility_id%type;
733:
734: -- Begin Bug#4126188

Line 735: l_from_position_id ghr_pa_requests.from_position_id%type;

731: l_application_id fnd_application.application_id%type;
732: l_resp_id fnd_responsibility.responsibility_id%type;
733:
734: -- Begin Bug#4126188
735: l_from_position_id ghr_pa_requests.from_position_id%type;
736: l_to_position_id ghr_pa_requests.to_position_id%type;
737: l_second_noa_code ghr_pa_requests.second_noa_code%type;
738: l_from_poid ghr_pa_requests.personnel_office_id%type;
739: l_to_poid ghr_pa_requests.personnel_office_id%type;

Line 736: l_to_position_id ghr_pa_requests.to_position_id%type;

732: l_resp_id fnd_responsibility.responsibility_id%type;
733:
734: -- Begin Bug#4126188
735: l_from_position_id ghr_pa_requests.from_position_id%type;
736: l_to_position_id ghr_pa_requests.to_position_id%type;
737: l_second_noa_code ghr_pa_requests.second_noa_code%type;
738: l_from_poid ghr_pa_requests.personnel_office_id%type;
739: l_to_poid ghr_pa_requests.personnel_office_id%type;
740: l_session ghr_history_api.g_session_var_type;

Line 737: l_second_noa_code ghr_pa_requests.second_noa_code%type;

733:
734: -- Begin Bug#4126188
735: l_from_position_id ghr_pa_requests.from_position_id%type;
736: l_to_position_id ghr_pa_requests.to_position_id%type;
737: l_second_noa_code ghr_pa_requests.second_noa_code%type;
738: l_from_poid ghr_pa_requests.personnel_office_id%type;
739: l_to_poid ghr_pa_requests.personnel_office_id%type;
740: l_session ghr_history_api.g_session_var_type;
741: l_session1 ghr_history_api.g_session_var_type;

Line 738: l_from_poid ghr_pa_requests.personnel_office_id%type;

734: -- Begin Bug#4126188
735: l_from_position_id ghr_pa_requests.from_position_id%type;
736: l_to_position_id ghr_pa_requests.to_position_id%type;
737: l_second_noa_code ghr_pa_requests.second_noa_code%type;
738: l_from_poid ghr_pa_requests.personnel_office_id%type;
739: l_to_poid ghr_pa_requests.personnel_office_id%type;
740: l_session ghr_history_api.g_session_var_type;
741: l_session1 ghr_history_api.g_session_var_type;
742:

Line 739: l_to_poid ghr_pa_requests.personnel_office_id%type;

735: l_from_position_id ghr_pa_requests.from_position_id%type;
736: l_to_position_id ghr_pa_requests.to_position_id%type;
737: l_second_noa_code ghr_pa_requests.second_noa_code%type;
738: l_from_poid ghr_pa_requests.personnel_office_id%type;
739: l_to_poid ghr_pa_requests.personnel_office_id%type;
740: l_session ghr_history_api.g_session_var_type;
741: l_session1 ghr_history_api.g_session_var_type;
742:
743: CURSOR c_pa_req_2noa_dtls is

Line 745: FROM ghr_pa_requests

741: l_session1 ghr_history_api.g_session_var_type;
742:
743: CURSOR c_pa_req_2noa_dtls is
744: SELECT second_noa_code
745: FROM ghr_pa_requests
746: WHERE pa_request_id = p_pa_request_id;
747: -- End Bug#4126188
748:
749: cursor c_rei_rec is

Line 845: from ghr_pa_requests

841:
842:
843: cursor c_get_effective_date is
844: Select effective_date
845: from ghr_pa_requests
846: where pa_request_id = p_pa_request_id;
847:
848: -- Bug#4089400
849: cursor c_noa_fam_code is

Line 858: from ghr_pa_requests par

854: par.first_action_la_code2 la_code2,
855: par.second_action_la_code1 sec_la_code1,
856: par.second_action_la_code2 sec_la_code2,
857: par.pa_incentive_payment_option payment_option
858: from ghr_pa_requests par
859: where pa_request_id = p_pa_request_id;
860:
861: cursor c_noac_1xx is
862: SELECT par.effective_date

Line 864: ghr_pa_requests par,

860:
861: cursor c_noac_1xx is
862: SELECT par.effective_date
863: FROM ghr_nature_of_actions noa,
864: ghr_pa_requests par,
865: ghr_pay_plans pp
866: WHERE noa.nature_of_action_id = par.first_noa_id
867: and par.pa_request_id = p_pa_request_id
868: and pp.pay_plan = par.to_pay_plan

Line 876: ghr_pa_requests par,

872:
873: cursor c_noac_5xx is
874: SELECT par.effective_date
875: FROM ghr_nature_of_actions noa,
876: ghr_pa_requests par,
877: ghr_pay_plans pp
878: WHERE (noa.nature_of_action_id = par.first_noa_id
879: ---Bug# 8263918
880: OR

Line 894: ghr_pa_requests par,

890:
891: cursor c_noac_130 is
892: SELECT par.effective_date
893: FROM ghr_nature_of_actions noa,
894: ghr_pa_requests par,
895: ghr_pay_plans pp
896: WHERE noa.nature_of_action_id = par.first_noa_id
897: and par.pa_request_id = p_pa_request_id
898: and pp.pay_plan = par.to_pay_plan

Line 906: ghr_pa_requests par,

902:
903: cursor c_noac_sal_chg is
904: SELECT par.effective_date
905: FROM ghr_nature_of_actions noa,
906: ghr_pa_requests par,
907: ghr_pay_plans pp
908: WHERE (noa.nature_of_action_id = par.first_noa_id
909: ---Bug# 8263918
910: OR

Line 923: FROM ghr_pa_requests par

919:
920: -- Bug#5657744 Created the cursor
921: CURSOR c_afhr_noac_sal_chg IS
922: SELECT par.effective_date
923: FROM ghr_pa_requests par
924: WHERE par.pa_request_id = p_pa_request_id
925: AND par.first_noa_code IN ('890','891','892','893');
926:
927:

Line 931: FROM ghr_pa_requests

927:
928: cursor c_pp_and_grade is
929: SELECT to_pay_plan,to_grade_or_level,
930: from_pay_plan,from_grade_or_level
931: FROM ghr_pa_requests
932: WHERE pa_request_id = p_pa_request_id;
933:
934: -- Bug 4280026
935: cursor c_position is

Line 937: FROM ghr_pa_requests

933:
934: -- Bug 4280026
935: cursor c_position is
936: SELECT from_position_id,to_position_id
937: FROM ghr_pa_requests
938: WHERE pa_request_id = p_pa_request_id;
939:
940:
941: l_dummy varchar2(1);

Line 947: select request_number from ghr_pa_requests

943: -- Bug#5657744
944: l_psi VARCHAR2(10);
945:
946: cursor c_req_num is
947: select request_number from ghr_pa_requests
948: where pa_request_id = p_pa_request_id;
949: /*Start - BUG 6129752-DATE ARRIVED PERSONNEL OFFICE CHANGING TO WRONG DATE ON CORRECTION TO PROMOTION
950: Following cursor has been added to fetch assignment id when p_assignment_id is null. */
951:

Line 1181: l_tenure ghr_pa_requests.tenure%type;

1177:
1178: End appt_info;
1179:
1180: Procedure appt_benefits is
1181: l_tenure ghr_pa_requests.tenure%type;
1182: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1183: l_noa_code ghr_pa_requests.first_noa_code%type;
1184: l_fegli ghr_pa_requests.fegli%type;
1185: l_prev_fegli ghr_pa_requests.fegli%type;

Line 1182: l_retirement_plan ghr_pa_requests.retirement_plan%type;

1178: End appt_info;
1179:
1180: Procedure appt_benefits is
1181: l_tenure ghr_pa_requests.tenure%type;
1182: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1183: l_noa_code ghr_pa_requests.first_noa_code%type;
1184: l_fegli ghr_pa_requests.fegli%type;
1185: l_prev_fegli ghr_pa_requests.fegli%type;
1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;

Line 1183: l_noa_code ghr_pa_requests.first_noa_code%type;

1179:
1180: Procedure appt_benefits is
1181: l_tenure ghr_pa_requests.tenure%type;
1182: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1183: l_noa_code ghr_pa_requests.first_noa_code%type;
1184: l_fegli ghr_pa_requests.fegli%type;
1185: l_prev_fegli ghr_pa_requests.fegli%type;
1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1187: l_payroll_id pay_payrolls_f.payroll_id%type;

Line 1184: l_fegli ghr_pa_requests.fegli%type;

1180: Procedure appt_benefits is
1181: l_tenure ghr_pa_requests.tenure%type;
1182: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1183: l_noa_code ghr_pa_requests.first_noa_code%type;
1184: l_fegli ghr_pa_requests.fegli%type;
1185: l_prev_fegli ghr_pa_requests.fegli%type;
1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1187: l_payroll_id pay_payrolls_f.payroll_id%type;
1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;

Line 1185: l_prev_fegli ghr_pa_requests.fegli%type;

1181: l_tenure ghr_pa_requests.tenure%type;
1182: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1183: l_noa_code ghr_pa_requests.first_noa_code%type;
1184: l_fegli ghr_pa_requests.fegli%type;
1185: l_prev_fegli ghr_pa_requests.fegli%type;
1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1187: l_payroll_id pay_payrolls_f.payroll_id%type;
1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1189: l_effective_date ghr_pa_requests.effective_date%type;

Line 1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;

1182: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1183: l_noa_code ghr_pa_requests.first_noa_code%type;
1184: l_fegli ghr_pa_requests.fegli%type;
1185: l_prev_fegli ghr_pa_requests.fegli%type;
1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1187: l_payroll_id pay_payrolls_f.payroll_id%type;
1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1189: l_effective_date ghr_pa_requests.effective_date%type;
1190: l_start_date per_time_periods.start_date%type;

Line 1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;

1184: l_fegli ghr_pa_requests.fegli%type;
1185: l_prev_fegli ghr_pa_requests.fegli%type;
1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1187: l_payroll_id pay_payrolls_f.payroll_id%type;
1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1189: l_effective_date ghr_pa_requests.effective_date%type;
1190: l_start_date per_time_periods.start_date%type;
1191: l_family_code ghr_pa_requests.noa_family_code%type;
1192: l_new_element_name pay_element_types_f.element_name%type;

Line 1189: l_effective_date ghr_pa_requests.effective_date%type;

1185: l_prev_fegli ghr_pa_requests.fegli%type;
1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1187: l_payroll_id pay_payrolls_f.payroll_id%type;
1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1189: l_effective_date ghr_pa_requests.effective_date%type;
1190: l_start_date per_time_periods.start_date%type;
1191: l_family_code ghr_pa_requests.noa_family_code%type;
1192: l_new_element_name pay_element_types_f.element_name%type;
1193: l_bus_group_id per_all_people_f.business_group_id%type;

Line 1191: l_family_code ghr_pa_requests.noa_family_code%type;

1187: l_payroll_id pay_payrolls_f.payroll_id%type;
1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1189: l_effective_date ghr_pa_requests.effective_date%type;
1190: l_start_date per_time_periods.start_date%type;
1191: l_family_code ghr_pa_requests.noa_family_code%type;
1192: l_new_element_name pay_element_types_f.element_name%type;
1193: l_bus_group_id per_all_people_f.business_group_id%type;
1194: l_fehb_exists BOOLEAN;
1195: l_tsp_exists BOOLEAN;

Line 1203: l_second_noa_code ghr_pa_requests.second_noa_code%type;

1199: l_date_temp_elig date;
1200: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1201: l_tsp_status_date date;
1202: l_agency_contrib_date date;
1203: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1204: --8793163
1205: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1206: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;
1207: --8793163

Line 1205: l_second_noa_id ghr_pa_requests.second_noa_id%type;

1201: l_tsp_status_date date;
1202: l_agency_contrib_date date;
1203: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1204: --8793163
1205: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1206: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;
1207: --8793163
1208:
1209: CURSOR c_pa_req_details is

Line 1206: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;

1202: l_agency_contrib_date date;
1203: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1204: --8793163
1205: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1206: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;
1207: --8793163
1208:
1209: CURSOR c_pa_req_details is
1210: SELECT *

Line 1211: FROM ghr_pa_requests

1207: --8793163
1208:
1209: CURSOR c_pa_req_details is
1210: SELECT *
1211: FROM ghr_pa_requests
1212: WHERE pa_request_id = p_pa_request_id;
1213:
1214: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1215: SELECT rei_information3 payroll_id

Line 1214: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

1210: SELECT *
1211: FROM ghr_pa_requests
1212: WHERE pa_request_id = p_pa_request_id;
1213:
1214: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1215: SELECT rei_information3 payroll_id
1216: FROM ghr_pa_request_extra_info
1217: WHERE pa_request_id = c_pa_request_id
1218: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';

Line 1272: FROM ghr_pa_requests

1268:
1269: --Begin Bug 14062681
1270: CURSOR c_first_nte_date is
1271: SELECT first_noa_information1
1272: FROM ghr_pa_requests
1273: WHERE pa_request_id = p_pa_request_id;
1274:
1275: l_nte_date ghr_pa_requests.first_noa_information1%type;
1276: --End Bug 14062681

Line 1275: l_nte_date ghr_pa_requests.first_noa_information1%type;

1271: SELECT first_noa_information1
1272: FROM ghr_pa_requests
1273: WHERE pa_request_id = p_pa_request_id;
1274:
1275: l_nte_date ghr_pa_requests.first_noa_information1%type;
1276: --End Bug 14062681
1277:
1278:
1279: BEGIN

Line 1294: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family (l_second_noa_id,p_effective_date);

1290: l_person_id := pa_rec.person_id;
1291: l_second_noa_code := pa_rec.second_noa_code;
1292: --8793163
1293: l_second_noa_id := pa_rec.second_noa_id;
1294: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family (l_second_noa_id,p_effective_date);
1295: --8793163
1296: END LOOP;
1297:
1298: l_fehb_exists := FALSE;

Line 2654: l_agency_code ghr_pa_requests.agency_code%type;

2650: cursor c_bg is
2651: SELECT business_group_id
2652: FROM per_positions
2653: WHERE position_id = l_position_id;
2654: l_agency_code ghr_pa_requests.agency_code%type;
2655: l_bg_id per_positions.business_group_id%type;
2656: Begin
2657: If l_position_id is not null then
2658: l_refresh_flag := l_pos_refresh_flag;

Line 2942: l_agency_code ghr_pa_requests.agency_code%type;

2938: FROM ghr_nature_of_actions
2939: WHERE nature_of_action_id = p_noa_id
2940: and code in ('825','840','841','842','843','844','845','846',
2941: '847','848','849','878','879' ); -- Bug 3266198 Added 848 and 849 to the NOA codes.
2942: l_agency_code ghr_pa_requests.agency_code%type;
2943: l_bg_id per_positions.business_group_id%type;
2944:
2945: --
2946: begin

Line 3052: from ghr_pa_requests

3048: Procedure chg_sched_hours is
3049: -- Bug#2468297
3050: Cursor c_work_sch is
3051: select work_schedule
3052: from ghr_pa_requests
3053: where pa_request_id = p_pa_request_id;
3054:
3055: l_work_schedule ghr_pa_requests.work_schedule%type;
3056: Begin

Line 3055: l_work_schedule ghr_pa_requests.work_schedule%type;

3051: select work_schedule
3052: from ghr_pa_requests
3053: where pa_request_id = p_pa_request_id;
3054:
3055: l_work_schedule ghr_pa_requests.work_schedule%type;
3056: Begin
3057: If l_assignment_id is not null then
3058: l_refresh_flag := l_asg_refresh_flag;
3059: ghr_history_fetch.fetch_asgei

Line 3282: l_tenure ghr_pa_requests.tenure%type;

3278:
3279: -- Bug 5482191
3280: Procedure ghr_conv_dates is
3281: /* --Begin Bug# 4588575
3282: l_tenure ghr_pa_requests.tenure%type;
3283: l_pos_occpied ghr_pa_requests.position_occupied%type;
3284: l_pos_intel_pos VARCHAR(30);
3285: CURSOR c_pa_req_details is
3286: SELECT tenure,position_occupied

Line 3283: l_pos_occpied ghr_pa_requests.position_occupied%type;

3279: -- Bug 5482191
3280: Procedure ghr_conv_dates is
3281: /* --Begin Bug# 4588575
3282: l_tenure ghr_pa_requests.tenure%type;
3283: l_pos_occpied ghr_pa_requests.position_occupied%type;
3284: l_pos_intel_pos VARCHAR(30);
3285: CURSOR c_pa_req_details is
3286: SELECT tenure,position_occupied
3287: FROM ghr_pa_requests

Line 3287: FROM ghr_pa_requests

3283: l_pos_occpied ghr_pa_requests.position_occupied%type;
3284: l_pos_intel_pos VARCHAR(30);
3285: CURSOR c_pa_req_details is
3286: SELECT tenure,position_occupied
3287: FROM ghr_pa_requests
3288: WHERE pa_request_id = p_pa_request_id;
3289: */ --Backout the changes done for Bug# 4588575
3290:
3291: Begin

Line 3366: l_pos_occpied ghr_pa_requests.position_occupied%type;

3362: End ghr_conv_dates;
3363:
3364: /* --Begin Bug# 4588575
3365: Procedure ghr_prob_info is
3366: l_pos_occpied ghr_pa_requests.position_occupied%type;
3367: CURSOR c_pa_req_details is
3368: SELECT position_occupied
3369: FROM ghr_pa_requests
3370: WHERE pa_request_id = p_pa_request_id;

Line 3369: FROM ghr_pa_requests

3365: Procedure ghr_prob_info is
3366: l_pos_occpied ghr_pa_requests.position_occupied%type;
3367: CURSOR c_pa_req_details is
3368: SELECT position_occupied
3369: FROM ghr_pa_requests
3370: WHERE pa_request_id = p_pa_request_id;
3371: Begin
3372: l_per_ei_data := null;
3373: If l_person_id is not null then

Line 3414: FROM ghr_pa_requests

3410: Procedure ghr_scd_info is
3411:
3412: CURSOR c_pa_req_details is
3413: SELECT *
3414: FROM ghr_pa_requests
3415: WHERE pa_request_id = p_pa_request_id;
3416: --Begin Bug# 14001082
3417: l_service_comp_date ghr_pa_requests.service_comp_date%type;
3418: l_retirement_plan ghr_pa_requests.retirement_plan%type;

Line 3417: l_service_comp_date ghr_pa_requests.service_comp_date%type;

3413: SELECT *
3414: FROM ghr_pa_requests
3415: WHERE pa_request_id = p_pa_request_id;
3416: --Begin Bug# 14001082
3417: l_service_comp_date ghr_pa_requests.service_comp_date%type;
3418: l_retirement_plan ghr_pa_requests.retirement_plan%type;
3419: l_family_code ghr_pa_requests.noa_family_code%type;
3420: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3421: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;

Line 3418: l_retirement_plan ghr_pa_requests.retirement_plan%type;

3414: FROM ghr_pa_requests
3415: WHERE pa_request_id = p_pa_request_id;
3416: --Begin Bug# 14001082
3417: l_service_comp_date ghr_pa_requests.service_comp_date%type;
3418: l_retirement_plan ghr_pa_requests.retirement_plan%type;
3419: l_family_code ghr_pa_requests.noa_family_code%type;
3420: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3421: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;
3422: --End Bug# 14001082

Line 3419: l_family_code ghr_pa_requests.noa_family_code%type;

3415: WHERE pa_request_id = p_pa_request_id;
3416: --Begin Bug# 14001082
3417: l_service_comp_date ghr_pa_requests.service_comp_date%type;
3418: l_retirement_plan ghr_pa_requests.retirement_plan%type;
3419: l_family_code ghr_pa_requests.noa_family_code%type;
3420: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3421: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;
3422: --End Bug# 14001082
3423: Begin

Line 3420: l_second_noa_id ghr_pa_requests.second_noa_id%type;

3416: --Begin Bug# 14001082
3417: l_service_comp_date ghr_pa_requests.service_comp_date%type;
3418: l_retirement_plan ghr_pa_requests.retirement_plan%type;
3419: l_family_code ghr_pa_requests.noa_family_code%type;
3420: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3421: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;
3422: --End Bug# 14001082
3423: Begin
3424: hr_utility.set_location('Entering ddf ghr_scd_info '|| l_noa_family_code,1100);

Line 3421: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;

3417: l_service_comp_date ghr_pa_requests.service_comp_date%type;
3418: l_retirement_plan ghr_pa_requests.retirement_plan%type;
3419: l_family_code ghr_pa_requests.noa_family_code%type;
3420: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3421: l_second_noa_family_code ghr_pa_requests.noa_family_code%type;
3422: --End Bug# 14001082
3423: Begin
3424: hr_utility.set_location('Entering ddf ghr_scd_info '|| l_noa_family_code,1100);
3425: l_per_ei_data := null;

Line 3434: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family (l_second_noa_id,p_effective_date);

3430: --Begin Bug# 14001082
3431: l_retirement_plan := pa_rec.retirement_plan;
3432: l_family_code := pa_rec.noa_family_code;
3433: l_second_noa_id := pa_rec.second_noa_id;
3434: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family (l_second_noa_id,p_effective_date);
3435: --End Bug# 14001082
3436: END LOOP;
3437:
3438: IF substr(l_first_noa_code,1,1) ='1' THEN

Line 3662: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;

3658: --End of Bug# 6312144
3659:
3660: --Begin Bug# 8653508
3661: procedure detail_info is
3662: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;
3663: CURSOR c_detail_nte_date is
3664: SELECT first_noa_information1
3665: FROM ghr_pa_requests
3666: WHERE pa_request_id = p_pa_request_id;

Line 3665: FROM ghr_pa_requests

3661: procedure detail_info is
3662: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;
3663: CURSOR c_detail_nte_date is
3664: SELECT first_noa_information1
3665: FROM ghr_pa_requests
3666: WHERE pa_request_id = p_pa_request_id;
3667: begin
3668: If NVL(l_assignment_id,p_assignment_id) is not null then--bug# 11781442
3669: l_refresh_flag := l_asg_refresh_flag;

Line 3989: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator

3985: -- would not want to see the existing data.
3986: -- Bug#4089400 Added condition to skip the DLEI Processing for Correction Actions.
3987: IF l_information_type = 'GHR_US_PAR_SALARY_CHG' THEN
3988: IF NVL(l_noa_family_code,'C') <> 'CORRECT' THEN
3989: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator
3990: (p_position_id,
3991: p_effective_date);
3992:
3993: IF l_psi <> '00' THEN

Line 4318: from ghr_pa_requests par

4314: and asg.effective_end_date;
4315:
4316: cursor c_noa_fam is
4317: select par.noa_family_code
4318: from ghr_pa_requests par
4319: where pa_request_id = p_pa_request_id;
4320:
4321: Cursor c_def_payroll is
4322: select pay.payroll_id

Line 4796: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

4792:
4793: End get_information_type;
4794:
4795: Procedure determine_operation
4796: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4797: p_information_type in ghr_pa_request_info_types.information_type%type,
4798: p_update_rei in varchar2,
4799: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4800: p_operation_flag out NOCOPY varchar2,

Line 4802: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type

4798: p_update_rei in varchar2,
4799: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4800: p_operation_flag out NOCOPY varchar2,
4801: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,
4802: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
4803: ) is
4804:
4805: l_proc varchar2(72) := 'determine_operation';
4806: l_object_version_number ghr_pa_requests.object_version_number%type;

Line 4806: l_object_version_number ghr_pa_requests.object_version_number%type;

4802: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
4803: ) is
4804:
4805: l_proc varchar2(72) := 'determine_operation';
4806: l_object_version_number ghr_pa_requests.object_version_number%type;
4807: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
4808: l_exists boolean := FALSE;
4809: l_dummy ghr_pa_request_extra_info%rowtype;
4810: l_rei_rec ghr_pa_request_extra_info%rowtype;