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 8: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,

4: g_package varchar2(33) := ' GHR_SF52_DDF_INFO.';
5:
6:
7: Procedure term_ret_grade
8: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
9: p_person_id in per_people_f.person_id%type,
10: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
11: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
12: p_effective_date in ghr_pa_requests.effective_date%type,

Line 10: p_first_noa_id in ghr_pa_requests.first_noa_id%type,

6:
7: Procedure term_ret_grade
8: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
9: p_person_id in per_people_f.person_id%type,
10: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
11: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
12: p_effective_date in ghr_pa_requests.effective_date%type,
13: p_refresh_flag in varchar2 )
14: is

Line 11: p_second_noa_id in ghr_pa_requests.second_noa_id%type,

7: Procedure term_ret_grade
8: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
9: p_person_id in per_people_f.person_id%type,
10: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
11: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
12: p_effective_date in ghr_pa_requests.effective_date%type,
13: p_refresh_flag in varchar2 )
14: is
15:

Line 12: p_effective_date in ghr_pa_requests.effective_date%type,

8: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
9: p_person_id in per_people_f.person_id%type,
10: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
11: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
12: p_effective_date in ghr_pa_requests.effective_date%type,
13: p_refresh_flag in varchar2 )
14: is
15:
16: --Begin Bug 5923620

Line 37: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;

33: l_noa_code ghr_nature_of_actions.code%type;
34: l_first_noa_code ghr_nature_of_actions.code%type;
35: l_second_noa_code ghr_nature_of_actions.code%type;
36: l_existed BOOLEAN := FALSE;
37: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
38: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
39:
40: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
41: select code from ghr_nature_of_actions

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

36: l_existed BOOLEAN := FALSE;
37: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
38: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
39:
40: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
41: select code from ghr_nature_of_actions
42: where nature_of_action_id = p_noa_id;
43:
44: Cursor c_702 is

Line 179: select altered_pa_request_id from ghr_pa_requests

175: where pa_request_id = p_pa_request_id
176: and information_type = 'GHR_US_PAR_TERM_RG_PROMO';
177:
178: cursor c_altered_par_rec is
179: select altered_pa_request_id from ghr_pa_requests
180: where pa_request_id = p_pa_request_id;
181:
182: --Bug#4126188 Begin
183: cursor c_position is

Line 185: FROM ghr_pa_requests

181:
182: --Bug#4126188 Begin
183: cursor c_position is
184: SELECT from_position_id,to_position_id
185: FROM ghr_pa_requests
186: WHERE pa_request_id = p_pa_request_id;
187:
188: l_pos_ei_data per_position_extra_info%rowtype;
189: l_from_position_id ghr_pa_requests.from_position_id%type;

Line 189: l_from_position_id ghr_pa_requests.from_position_id%type;

185: FROM ghr_pa_requests
186: WHERE pa_request_id = p_pa_request_id;
187:
188: l_pos_ei_data per_position_extra_info%rowtype;
189: l_from_position_id ghr_pa_requests.from_position_id%type;
190: l_to_position_id ghr_pa_requests.to_position_id%type;
191: l_from_poid ghr_pa_requests.personnel_office_id%type;
192: l_to_poid ghr_pa_requests.personnel_office_id%type;
193: --Bug#4126188 End

Line 190: l_to_position_id ghr_pa_requests.to_position_id%type;

186: WHERE pa_request_id = p_pa_request_id;
187:
188: l_pos_ei_data per_position_extra_info%rowtype;
189: l_from_position_id ghr_pa_requests.from_position_id%type;
190: l_to_position_id ghr_pa_requests.to_position_id%type;
191: l_from_poid ghr_pa_requests.personnel_office_id%type;
192: l_to_poid ghr_pa_requests.personnel_office_id%type;
193: --Bug#4126188 End
194:

Line 191: l_from_poid ghr_pa_requests.personnel_office_id%type;

187:
188: l_pos_ei_data per_position_extra_info%rowtype;
189: l_from_position_id ghr_pa_requests.from_position_id%type;
190: l_to_position_id ghr_pa_requests.to_position_id%type;
191: l_from_poid ghr_pa_requests.personnel_office_id%type;
192: l_to_poid ghr_pa_requests.personnel_office_id%type;
193: --Bug#4126188 End
194:
195:

Line 192: l_to_poid ghr_pa_requests.personnel_office_id%type;

188: l_pos_ei_data per_position_extra_info%rowtype;
189: l_from_position_id ghr_pa_requests.from_position_id%type;
190: l_to_position_id ghr_pa_requests.to_position_id%type;
191: l_from_poid ghr_pa_requests.personnel_office_id%type;
192: l_to_poid ghr_pa_requests.personnel_office_id%type;
193: --Bug#4126188 End
194:
195:
196: BEGIN

Line 470: p_effective_date in ghr_pa_requests.effective_date%type ,

466: p_second_noa_id in number ,
467: p_person_id in per_people_f.person_id%type ,
468: p_assignment_id in per_assignments_f.assignment_id%type ,
469: p_position_id in per_positions.position_id%type ,
470: p_effective_date in ghr_pa_requests.effective_date%type ,
471: p_refresh_flag in varchar2 default 'Y'
472: )
473: is
474: l_proc varchar2(72) := g_package || 'populate_noa_spec_extra_info';

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

499: and fam.pa_info_type_flag = 'Y'
500: and pit.noa_family_code = fam.noa_family_code);
501: ---- and pit.information_type LIKE 'GHR_US%');
502:
503: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
504: select code from ghr_nature_of_actions
505: where nature_of_action_id = p_noa_id;
506:
507: cursor c_altered_par_rec is

Line 508: select altered_pa_request_id from ghr_pa_requests

504: select code from ghr_nature_of_actions
505: where nature_of_action_id = p_noa_id;
506:
507: cursor c_altered_par_rec is
508: select altered_pa_request_id from ghr_pa_requests
509: where pa_request_id = p_pa_request_id;
510:
511: l_noa_code ghr_nature_of_actions.code%type;
512: l_first_noa_code ghr_nature_of_actions.code%type;

Line 514: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;

510:
511: l_noa_code ghr_nature_of_actions.code%type;
512: l_first_noa_code ghr_nature_of_actions.code%type;
513: l_second_noa_code ghr_nature_of_actions.code%type;
514: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
515:
516: cursor c_orig_rei_rec is
517: select *
518: from ghr_pa_request_extra_info a

Line 634: p_effective_date in ghr_pa_requests.effective_date%type,

630: p_noa_id in number,
631: p_person_id in per_people_f.person_id%type,
632: p_assignment_id in per_assignments_f.assignment_id%type,
633: p_position_id in per_positions.position_id%type,
634: p_effective_date in ghr_pa_requests.effective_date%type,
635: p_refresh_flag in varchar2 default 'Y'
636: )
637: is
638:

Line 666: l_first_noa_code ghr_pa_requests.first_noa_code%type;

662: l_pos_refresh_flag varchar2(1);
663: -- Bug#4089400
664: l_noa_family_code ghr_noa_families.noa_family_code%type;
665: -- Bug#5039072 Added the following two parameters.
666: l_first_noa_code ghr_pa_requests.first_noa_code%type;
667: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
668: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
669: l_application_id fnd_application.application_id%type;
670: l_resp_id fnd_responsibility.responsibility_id%type;

Line 667: l_la_code1 ghr_pa_requests.first_action_la_code1%type;

663: -- Bug#4089400
664: l_noa_family_code ghr_noa_families.noa_family_code%type;
665: -- Bug#5039072 Added the following two parameters.
666: l_first_noa_code ghr_pa_requests.first_noa_code%type;
667: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
668: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
669: l_application_id fnd_application.application_id%type;
670: l_resp_id fnd_responsibility.responsibility_id%type;
671:

Line 668: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;

664: l_noa_family_code ghr_noa_families.noa_family_code%type;
665: -- Bug#5039072 Added the following two parameters.
666: l_first_noa_code ghr_pa_requests.first_noa_code%type;
667: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
668: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
669: l_application_id fnd_application.application_id%type;
670: l_resp_id fnd_responsibility.responsibility_id%type;
671:
672: -- Begin Bug#4126188

Line 673: l_from_position_id ghr_pa_requests.from_position_id%type;

669: l_application_id fnd_application.application_id%type;
670: l_resp_id fnd_responsibility.responsibility_id%type;
671:
672: -- Begin Bug#4126188
673: l_from_position_id ghr_pa_requests.from_position_id%type;
674: l_to_position_id ghr_pa_requests.to_position_id%type;
675: l_second_noa_code ghr_pa_requests.second_noa_code%type;
676: l_from_poid ghr_pa_requests.personnel_office_id%type;
677: l_to_poid ghr_pa_requests.personnel_office_id%type;

Line 674: l_to_position_id ghr_pa_requests.to_position_id%type;

670: l_resp_id fnd_responsibility.responsibility_id%type;
671:
672: -- Begin Bug#4126188
673: l_from_position_id ghr_pa_requests.from_position_id%type;
674: l_to_position_id ghr_pa_requests.to_position_id%type;
675: l_second_noa_code ghr_pa_requests.second_noa_code%type;
676: l_from_poid ghr_pa_requests.personnel_office_id%type;
677: l_to_poid ghr_pa_requests.personnel_office_id%type;
678: l_session ghr_history_api.g_session_var_type;

Line 675: l_second_noa_code ghr_pa_requests.second_noa_code%type;

671:
672: -- Begin Bug#4126188
673: l_from_position_id ghr_pa_requests.from_position_id%type;
674: l_to_position_id ghr_pa_requests.to_position_id%type;
675: l_second_noa_code ghr_pa_requests.second_noa_code%type;
676: l_from_poid ghr_pa_requests.personnel_office_id%type;
677: l_to_poid ghr_pa_requests.personnel_office_id%type;
678: l_session ghr_history_api.g_session_var_type;
679: l_session1 ghr_history_api.g_session_var_type;

Line 676: l_from_poid ghr_pa_requests.personnel_office_id%type;

672: -- Begin Bug#4126188
673: l_from_position_id ghr_pa_requests.from_position_id%type;
674: l_to_position_id ghr_pa_requests.to_position_id%type;
675: l_second_noa_code ghr_pa_requests.second_noa_code%type;
676: l_from_poid ghr_pa_requests.personnel_office_id%type;
677: l_to_poid ghr_pa_requests.personnel_office_id%type;
678: l_session ghr_history_api.g_session_var_type;
679: l_session1 ghr_history_api.g_session_var_type;
680:

Line 677: l_to_poid ghr_pa_requests.personnel_office_id%type;

673: l_from_position_id ghr_pa_requests.from_position_id%type;
674: l_to_position_id ghr_pa_requests.to_position_id%type;
675: l_second_noa_code ghr_pa_requests.second_noa_code%type;
676: l_from_poid ghr_pa_requests.personnel_office_id%type;
677: l_to_poid ghr_pa_requests.personnel_office_id%type;
678: l_session ghr_history_api.g_session_var_type;
679: l_session1 ghr_history_api.g_session_var_type;
680:
681: CURSOR c_pa_req_2noa_dtls is

Line 683: FROM ghr_pa_requests

679: l_session1 ghr_history_api.g_session_var_type;
680:
681: CURSOR c_pa_req_2noa_dtls is
682: SELECT second_noa_code
683: FROM ghr_pa_requests
684: WHERE pa_request_id = p_pa_request_id;
685: -- End Bug#4126188
686:
687: cursor c_rei_rec is

Line 783: from ghr_pa_requests

779:
780:
781: cursor c_get_effective_date is
782: Select effective_date
783: from ghr_pa_requests
784: where pa_request_id = p_pa_request_id;
785:
786: -- Bug#4089400
787: cursor c_noa_fam_code is

Line 792: from ghr_pa_requests par

788: select par.noa_family_code noa_family_code,
789: par.first_noa_code first_noa_code,
790: par.first_action_la_code1 la_code1,
791: par.pa_incentive_payment_option payment_option
792: from ghr_pa_requests par
793: where pa_request_id = p_pa_request_id;
794:
795: cursor c_noac_1xx is
796: SELECT par.effective_date

Line 798: ghr_pa_requests par,

794:
795: cursor c_noac_1xx is
796: SELECT par.effective_date
797: FROM ghr_nature_of_actions noa,
798: ghr_pa_requests par,
799: ghr_pay_plans pp
800: WHERE noa.nature_of_action_id = par.first_noa_id
801: and par.pa_request_id = p_pa_request_id
802: and pp.pay_plan = par.to_pay_plan

Line 810: ghr_pa_requests par,

806:
807: cursor c_noac_5xx is
808: SELECT par.effective_date
809: FROM ghr_nature_of_actions noa,
810: ghr_pa_requests par,
811: ghr_pay_plans pp
812: WHERE noa.nature_of_action_id = par.first_noa_id
813: and par.pa_request_id = p_pa_request_id
814: and pp.pay_plan = par.to_pay_plan

Line 822: ghr_pa_requests par,

818:
819: cursor c_noac_130 is
820: SELECT par.effective_date
821: FROM ghr_nature_of_actions noa,
822: ghr_pa_requests par,
823: ghr_pay_plans pp
824: WHERE noa.nature_of_action_id = par.first_noa_id
825: and par.pa_request_id = p_pa_request_id
826: and pp.pay_plan = par.to_pay_plan

Line 834: ghr_pa_requests par,

830:
831: cursor c_noac_sal_chg is
832: SELECT par.effective_date
833: FROM ghr_nature_of_actions noa,
834: ghr_pa_requests par,
835: ghr_pay_plans pp
836: WHERE noa.nature_of_action_id = par.first_noa_id
837: AND par.pa_request_id = p_pa_request_id
838: AND pp.pay_plan = par.to_pay_plan

Line 845: FROM ghr_pa_requests par

841:
842: -- Bug#5657744 Created the cursor
843: CURSOR c_afhr_noac_sal_chg IS
844: SELECT par.effective_date
845: FROM ghr_pa_requests par
846: WHERE par.pa_request_id = p_pa_request_id
847: AND par.first_noa_code IN ('890','891','892','893');
848:
849:

Line 853: FROM ghr_pa_requests

849:
850: cursor c_pp_and_grade is
851: SELECT to_pay_plan,to_grade_or_level,
852: from_pay_plan,from_grade_or_level
853: FROM ghr_pa_requests
854: WHERE pa_request_id = p_pa_request_id;
855:
856: -- Bug 4280026
857: cursor c_position is

Line 859: FROM ghr_pa_requests

855:
856: -- Bug 4280026
857: cursor c_position is
858: SELECT from_position_id,to_position_id
859: FROM ghr_pa_requests
860: WHERE pa_request_id = p_pa_request_id;
861:
862:
863: l_dummy varchar2(1);

Line 869: select request_number from ghr_pa_requests

865: -- Bug#5657744
866: l_psi VARCHAR2(10);
867:
868: cursor c_req_num is
869: select request_number from ghr_pa_requests
870: where pa_request_id = p_pa_request_id;
871: /*Start - BUG 6129752-DATE ARRIVED PERSONNEL OFFICE CHANGING TO WRONG DATE ON CORRECTION TO PROMOTION
872: Following cursor has been added to fetch assignment id when p_assignment_id is null. */
873:

Line 1043: l_tenure ghr_pa_requests.tenure%type;

1039: END IF;
1040: End appt_info;
1041:
1042: Procedure appt_benefits is
1043: l_tenure ghr_pa_requests.tenure%type;
1044: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1045: l_noa_code ghr_pa_requests.first_noa_code%type;
1046: l_fegli ghr_pa_requests.fegli%type;
1047: l_prev_fegli ghr_pa_requests.fegli%type;

Line 1044: l_retirement_plan ghr_pa_requests.retirement_plan%type;

1040: End appt_info;
1041:
1042: Procedure appt_benefits is
1043: l_tenure ghr_pa_requests.tenure%type;
1044: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1045: l_noa_code ghr_pa_requests.first_noa_code%type;
1046: l_fegli ghr_pa_requests.fegli%type;
1047: l_prev_fegli ghr_pa_requests.fegli%type;
1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;

Line 1045: l_noa_code ghr_pa_requests.first_noa_code%type;

1041:
1042: Procedure appt_benefits is
1043: l_tenure ghr_pa_requests.tenure%type;
1044: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1045: l_noa_code ghr_pa_requests.first_noa_code%type;
1046: l_fegli ghr_pa_requests.fegli%type;
1047: l_prev_fegli ghr_pa_requests.fegli%type;
1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1049: l_payroll_id pay_payrolls_f.payroll_id%type;

Line 1046: l_fegli ghr_pa_requests.fegli%type;

1042: Procedure appt_benefits is
1043: l_tenure ghr_pa_requests.tenure%type;
1044: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1045: l_noa_code ghr_pa_requests.first_noa_code%type;
1046: l_fegli ghr_pa_requests.fegli%type;
1047: l_prev_fegli ghr_pa_requests.fegli%type;
1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1049: l_payroll_id pay_payrolls_f.payroll_id%type;
1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;

Line 1047: l_prev_fegli ghr_pa_requests.fegli%type;

1043: l_tenure ghr_pa_requests.tenure%type;
1044: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1045: l_noa_code ghr_pa_requests.first_noa_code%type;
1046: l_fegli ghr_pa_requests.fegli%type;
1047: l_prev_fegli ghr_pa_requests.fegli%type;
1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1049: l_payroll_id pay_payrolls_f.payroll_id%type;
1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1051: l_effective_date ghr_pa_requests.effective_date%type;

Line 1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;

1044: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1045: l_noa_code ghr_pa_requests.first_noa_code%type;
1046: l_fegli ghr_pa_requests.fegli%type;
1047: l_prev_fegli ghr_pa_requests.fegli%type;
1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1049: l_payroll_id pay_payrolls_f.payroll_id%type;
1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1051: l_effective_date ghr_pa_requests.effective_date%type;
1052: l_start_date per_time_periods.start_date%type;

Line 1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;

1046: l_fegli ghr_pa_requests.fegli%type;
1047: l_prev_fegli ghr_pa_requests.fegli%type;
1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1049: l_payroll_id pay_payrolls_f.payroll_id%type;
1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1051: l_effective_date ghr_pa_requests.effective_date%type;
1052: l_start_date per_time_periods.start_date%type;
1053: l_family_code ghr_pa_requests.noa_family_code%type;
1054: l_new_element_name pay_element_types_f.element_name%type;

Line 1051: l_effective_date ghr_pa_requests.effective_date%type;

1047: l_prev_fegli ghr_pa_requests.fegli%type;
1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1049: l_payroll_id pay_payrolls_f.payroll_id%type;
1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1051: l_effective_date ghr_pa_requests.effective_date%type;
1052: l_start_date per_time_periods.start_date%type;
1053: l_family_code ghr_pa_requests.noa_family_code%type;
1054: l_new_element_name pay_element_types_f.element_name%type;
1055: l_bus_group_id per_all_people_f.business_group_id%type;

Line 1053: l_family_code ghr_pa_requests.noa_family_code%type;

1049: l_payroll_id pay_payrolls_f.payroll_id%type;
1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1051: l_effective_date ghr_pa_requests.effective_date%type;
1052: l_start_date per_time_periods.start_date%type;
1053: l_family_code ghr_pa_requests.noa_family_code%type;
1054: l_new_element_name pay_element_types_f.element_name%type;
1055: l_bus_group_id per_all_people_f.business_group_id%type;
1056: l_fehb_exists BOOLEAN;
1057: l_tsp_exists BOOLEAN;

Line 1065: l_second_noa_code ghr_pa_requests.second_noa_code%type;

1061: l_date_temp_elig date;
1062: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1063: l_tsp_status_date date;
1064: l_agency_contrib_date date;
1065: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1066:
1067: CURSOR c_pa_req_details is
1068: SELECT *
1069: FROM ghr_pa_requests

Line 1069: FROM ghr_pa_requests

1065: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1066:
1067: CURSOR c_pa_req_details is
1068: SELECT *
1069: FROM ghr_pa_requests
1070: WHERE pa_request_id = p_pa_request_id;
1071:
1072: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1073: SELECT rei_information3 payroll_id

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

1068: SELECT *
1069: FROM ghr_pa_requests
1070: WHERE pa_request_id = p_pa_request_id;
1071:
1072: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1073: SELECT rei_information3 payroll_id
1074: FROM ghr_pa_request_extra_info
1075: WHERE pa_request_id = c_pa_request_id
1076: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';

Line 2225: l_agency_code ghr_pa_requests.agency_code%type;

2221: cursor c_bg is
2222: SELECT business_group_id
2223: FROM per_positions
2224: WHERE position_id = l_position_id;
2225: l_agency_code ghr_pa_requests.agency_code%type;
2226: l_bg_id per_positions.business_group_id%type;
2227: Begin
2228: If l_position_id is not null then
2229: l_refresh_flag := l_pos_refresh_flag;

Line 2407: l_agency_code ghr_pa_requests.agency_code%type;

2403: FROM ghr_nature_of_actions
2404: WHERE nature_of_action_id = p_noa_id
2405: and code in ('825','840','841','842','843','844','845','846',
2406: '847','848','849','878','879' ); -- Bug 3266198 Added 848 and 849 to the NOA codes.
2407: l_agency_code ghr_pa_requests.agency_code%type;
2408: l_bg_id per_positions.business_group_id%type;
2409:
2410: --
2411: begin

Line 2517: from ghr_pa_requests

2513: Procedure chg_sched_hours is
2514: -- Bug#2468297
2515: Cursor c_work_sch is
2516: select work_schedule
2517: from ghr_pa_requests
2518: where pa_request_id = p_pa_request_id;
2519:
2520: l_work_schedule ghr_pa_requests.work_schedule%type;
2521: Begin

Line 2520: l_work_schedule ghr_pa_requests.work_schedule%type;

2516: select work_schedule
2517: from ghr_pa_requests
2518: where pa_request_id = p_pa_request_id;
2519:
2520: l_work_schedule ghr_pa_requests.work_schedule%type;
2521: Begin
2522: If l_assignment_id is not null then
2523: l_refresh_flag := l_asg_refresh_flag;
2524: ghr_history_fetch.fetch_asgei

Line 2741: l_tenure ghr_pa_requests.tenure%type;

2737:
2738: -- Bug 5482191
2739: Procedure ghr_conv_dates is
2740: /* --Begin Bug# 4588575
2741: l_tenure ghr_pa_requests.tenure%type;
2742: l_pos_occpied ghr_pa_requests.position_occupied%type;
2743: l_pos_intel_pos VARCHAR(30);
2744: CURSOR c_pa_req_details is
2745: SELECT tenure,position_occupied

Line 2742: l_pos_occpied ghr_pa_requests.position_occupied%type;

2738: -- Bug 5482191
2739: Procedure ghr_conv_dates is
2740: /* --Begin Bug# 4588575
2741: l_tenure ghr_pa_requests.tenure%type;
2742: l_pos_occpied ghr_pa_requests.position_occupied%type;
2743: l_pos_intel_pos VARCHAR(30);
2744: CURSOR c_pa_req_details is
2745: SELECT tenure,position_occupied
2746: FROM ghr_pa_requests

Line 2746: FROM ghr_pa_requests

2742: l_pos_occpied ghr_pa_requests.position_occupied%type;
2743: l_pos_intel_pos VARCHAR(30);
2744: CURSOR c_pa_req_details is
2745: SELECT tenure,position_occupied
2746: FROM ghr_pa_requests
2747: WHERE pa_request_id = p_pa_request_id;
2748: */ --Backout the changes done for Bug# 4588575
2749:
2750: Begin

Line 2825: l_pos_occpied ghr_pa_requests.position_occupied%type;

2821: End ghr_conv_dates;
2822:
2823: /* --Begin Bug# 4588575
2824: Procedure ghr_prob_info is
2825: l_pos_occpied ghr_pa_requests.position_occupied%type;
2826: CURSOR c_pa_req_details is
2827: SELECT position_occupied
2828: FROM ghr_pa_requests
2829: WHERE pa_request_id = p_pa_request_id;

Line 2828: FROM ghr_pa_requests

2824: Procedure ghr_prob_info is
2825: l_pos_occpied ghr_pa_requests.position_occupied%type;
2826: CURSOR c_pa_req_details is
2827: SELECT position_occupied
2828: FROM ghr_pa_requests
2829: WHERE pa_request_id = p_pa_request_id;
2830: Begin
2831: l_per_ei_data := null;
2832: If l_person_id is not null then

Line 2868: l_retirement_plan ghr_pa_requests.retirement_plan%type;

2864: end if;
2865: End ghr_prob_info;
2866:
2867: Procedure ghr_scd_info is
2868: l_retirement_plan ghr_pa_requests.retirement_plan%type;
2869: l_service_comp_date ghr_pa_requests.service_comp_date%type;
2870: CURSOR c_pa_req_details is
2871: SELECT retirement_plan,service_comp_date
2872: FROM ghr_pa_requests

Line 2869: l_service_comp_date ghr_pa_requests.service_comp_date%type;

2865: End ghr_prob_info;
2866:
2867: Procedure ghr_scd_info is
2868: l_retirement_plan ghr_pa_requests.retirement_plan%type;
2869: l_service_comp_date ghr_pa_requests.service_comp_date%type;
2870: CURSOR c_pa_req_details is
2871: SELECT retirement_plan,service_comp_date
2872: FROM ghr_pa_requests
2873: WHERE pa_request_id = p_pa_request_id;

Line 2872: FROM ghr_pa_requests

2868: l_retirement_plan ghr_pa_requests.retirement_plan%type;
2869: l_service_comp_date ghr_pa_requests.service_comp_date%type;
2870: CURSOR c_pa_req_details is
2871: SELECT retirement_plan,service_comp_date
2872: FROM ghr_pa_requests
2873: WHERE pa_request_id = p_pa_request_id;
2874: Begin
2875: l_per_ei_data := null;
2876: If l_person_id is not null then

Line 3274: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator

3270: -- would not want to see the existing data.
3271: -- Bug#4089400 Added condition to skip the DLEI Processing for Correction Actions.
3272: IF l_information_type = 'GHR_US_PAR_SALARY_CHG' THEN
3273: IF NVL(l_noa_family_code,'C') <> 'CORRECT' THEN
3274: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator
3275: (p_position_id,
3276: p_effective_date);
3277:
3278: IF l_psi <> '00' THEN

Line 3561: from ghr_pa_requests par

3557: and asg.effective_end_date;
3558:
3559: cursor c_noa_fam is
3560: select par.noa_family_code
3561: from ghr_pa_requests par
3562: where pa_request_id = p_pa_request_id;
3563:
3564: Cursor c_def_payroll is
3565: select pay.payroll_id

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

4035:
4036: End get_information_type;
4037:
4038: Procedure determine_operation
4039: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4040: p_information_type in ghr_pa_request_info_types.information_type%type,
4041: p_update_rei in varchar2,
4042: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4043: p_operation_flag out NOCOPY varchar2,

Line 4045: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type

4041: p_update_rei in varchar2,
4042: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4043: p_operation_flag out NOCOPY varchar2,
4044: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,
4045: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
4046: ) is
4047:
4048: l_proc varchar2(72) := 'determine_operation';
4049: l_object_version_number ghr_pa_requests.object_version_number%type;

Line 4049: l_object_version_number ghr_pa_requests.object_version_number%type;

4045: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
4046: ) is
4047:
4048: l_proc varchar2(72) := 'determine_operation';
4049: l_object_version_number ghr_pa_requests.object_version_number%type;
4050: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
4051: l_exists boolean := FALSE;
4052: l_dummy ghr_pa_request_extra_info%rowtype;
4053: l_rei_rec ghr_pa_request_extra_info%rowtype;