1 package GHR_AGENCY_CHECK AS
2 /* $Header: ghragncy.pkh 120.2.12010000.2 2008/08/05 15:11:20 ubhat ship $ */
3
4
5 procedure AGENCY_CHECK
6 (
7 p_pa_request_rec in ghr_pa_requests%rowtype,
8 p_asg_sf52 in ghr_api.asg_sf52_type,
9 p_asg_non_sf52 in ghr_api.asg_non_sf52_type,
10 p_asg_nte_dates in ghr_api.asg_nte_dates_type,
11 p_per_sf52 in ghr_api.per_sf52_type,
12 p_per_group1 in ghr_api.per_group1_type,
13 p_per_group2 in ghr_api.per_group2_type,
14 p_per_scd_info in ghr_api.per_scd_info_type,
15 p_per_retained_grade in ghr_api.per_retained_grade_type,
16 p_per_probations in ghr_api.per_probations_type,
17 p_per_sep_retire in ghr_api.per_sep_retire_type,
18 p_per_security in ghr_api.per_security_type,
19 p_per_conversions in ghr_api.per_conversions_type,
20 p_per_uniformed_services in ghr_api.per_uniformed_services_type,
21 p_pos_oblig in ghr_api.pos_oblig_type,
22 p_pos_grp2 in ghr_api.pos_grp2_type,
23 p_pos_grp1 in ghr_api.pos_grp1_type,
24 p_pos_valid_grade in ghr_api.pos_valid_grade_type,
25 p_pos_car_prog in ghr_api.pos_car_prog_type,
26 p_loc_info in ghr_api.loc_info_type,
27 p_wgi in ghr_api.within_grade_increase_type ,
28 p_recruitment_bonus in ghr_api.recruitment_bonus_type ,
29 p_relocation_bonus in ghr_api.relocation_bonus_type,
30
31 p_sf52_from_data in ghr_api.prior_sf52_data_type,
32 p_personal_info in ghr_api.personal_info_type,
33 p_gov_awards_type in ghr_api.government_awards_type,
34 p_perf_appraisal_type in ghr_api.performance_appraisal_type,
35 p_payroll_type in ghr_api.government_payroll_type,
36 p_conduct_perf_type in ghr_api.conduct_performance_type,
37 p_agency_sf52 in ghr_api.agency_sf52_type,
38 p_agency_code in varchar2,
39 p_health_plan in varchar2,
40 p_entitlement in ghr_api.entitlement_type,
41 p_foreign_lang_prof_pay in ghr_api.foreign_lang_prof_pay_type,
42 p_edp_pay in ghr_api.edp_pay_type,
43 p_hazard_pay in ghr_api.hazard_pay_type,
44 p_health_benefits in ghr_api.health_benefits_type,
45 p_danger_pay in ghr_api.danger_pay_type,
46 p_imminent_danger_pay in ghr_api.imminent_danger_pay_type,
47 p_living_quarters_allow in ghr_api.living_quarters_allow_type,
48 p_post_diff_amt in ghr_api.post_diff_amt_type,
49 p_post_diff_percent in ghr_api.post_diff_percent_type,
50 p_sep_maintenance_allow in ghr_api.sep_maintenance_allow_type,
51 p_supplemental_post_allow in ghr_api.supplemental_post_allow_type,
52 p_temp_lodge_allow in ghr_api.temp_lodge_allow_type,
53 p_premium_pay in ghr_api.premium_pay_type,
54 p_retirement_annuity in ghr_api.retirement_annuity_type,
55 p_severance_pay in ghr_api.severance_pay_type,
56 p_thrift_saving_plan in ghr_api.thrift_saving_plan,
57 p_retention_allow_review in ghr_api.retention_allow_review_type,
58 p_health_ben_pre_tax in ghr_api.health_ben_pre_tax_type,
59 p_per_benefit_info in ghr_api.per_benefit_info_type, -- TAR 4646592.993
60 p_imm_retirement_info in ghr_api.per_retirement_info_type --Bug# 7131104
61 );
62
63 procedure open_events_check
64 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
65 p_message_set in out NOCOPY boolean
66 );
67
68 function print_sf50
69 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
70 p_pa_notification_id in ghr_pa_requests.pa_notification_id%type
71 ) return boolean;
72
73 procedure mass_salary_lacs_remarks
74 (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
75 p_prd in ghr_pa_requests.pay_rate_determinant%TYPE,
76 p_eo_number in ghr_mass_salaries.executive_order_number%TYPE,
77 p_eo_date in ghr_mass_salaries.executive_order_date%TYPE,
78 p_opm_number in ghr_mass_salaries.opm_issuance_number%TYPE,
79 p_opm_date in ghr_mass_salaries.opm_issuance_date%TYPE,
80 p_retcode in out NOCOPY NUMBER,
81 p_errbuf in out NOCOPY VARCHAR2
82 );
83
84 procedure CANCEL_HIRE_CAO
85 (
86 p_pa_request_rec in ghr_pa_requests%rowtype,
87 p_asg_sf52 in ghr_api.asg_sf52_type,
88 p_asg_non_sf52 in ghr_api.asg_non_sf52_type,
89 p_asg_nte_dates in ghr_api.asg_nte_dates_type,
90 p_per_sf52 in ghr_api.per_sf52_type,
91 p_per_group1 in ghr_api.per_group1_type,
92 p_per_group2 in ghr_api.per_group2_type,
93 p_per_scd_info in ghr_api.per_scd_info_type,
94 p_per_retained_grade in ghr_api.per_retained_grade_type,
95 p_per_probations in ghr_api.per_probations_type,
96 p_per_sep_retire in ghr_api.per_sep_retire_type,
97 p_per_security in ghr_api.per_security_type,
98 p_per_conversions in ghr_api.per_conversions_type,
99 p_per_uniformed_services in ghr_api.per_uniformed_services_type,
100 p_pos_oblig in ghr_api.pos_oblig_type,
101 p_pos_grp2 in ghr_api.pos_grp2_type,
102 p_pos_grp1 in ghr_api.pos_grp1_type,
103 p_pos_valid_grade in ghr_api.pos_valid_grade_type,
104 p_pos_car_prog in ghr_api.pos_car_prog_type,
105 p_loc_info in ghr_api.loc_info_type,
106 p_wgi in ghr_api.within_grade_increase_type ,
107 p_recruitment_bonus in ghr_api.recruitment_bonus_type ,
108 p_relocation_bonus in ghr_api.relocation_bonus_type,
109 p_sf52_from_data in ghr_api.prior_sf52_data_type,
110 p_personal_info in ghr_api.personal_info_type,
111 p_gov_awards_type in ghr_api.government_awards_type,
112 p_perf_appraisal_type in ghr_api.performance_appraisal_type,
113 p_payroll_type in ghr_api.government_payroll_type,
114 p_conduct_perf_type in ghr_api.conduct_performance_type,
115 p_agency_sf52 in ghr_api.agency_sf52_type,
116 p_agency_code in varchar2,
117 p_health_plan in varchar2,
118 p_entitlement in ghr_api.entitlement_type,
119 p_foreign_lang_prof_pay in ghr_api.foreign_lang_prof_pay_type,
120 p_edp_pay in ghr_api.edp_pay_type,
121 p_hazard_pay in ghr_api.hazard_pay_type,
122 p_health_benefits in ghr_api.health_benefits_type,
123 p_danger_pay in ghr_api.danger_pay_type,
124 p_imminent_danger_pay in ghr_api.imminent_danger_pay_type,
125 p_living_quarters_allow in ghr_api.living_quarters_allow_type,
126 p_post_diff_amt in ghr_api.post_diff_amt_type,
127 p_post_diff_percent in ghr_api.post_diff_percent_type,
128 p_sep_maintenance_allow in ghr_api.sep_maintenance_allow_type,
129 p_supplemental_post_allow in ghr_api.supplemental_post_allow_type,
130 p_temp_lodge_allow in ghr_api.temp_lodge_allow_type,
131 p_premium_pay in ghr_api.premium_pay_type,
132 p_retirement_annuity in ghr_api.retirement_annuity_type,
133 p_severance_pay in ghr_api.severance_pay_type,
134 p_thrift_saving_plan in ghr_api.thrift_saving_plan,
135 p_retention_allow_review in ghr_api.retention_allow_review_type,
136 p_health_ben_pre_tax in ghr_api.health_ben_pre_tax_type,
137 p_cao_effective_date out NOCOPY date
138 );
139
140
141 end GHR_AGENCY_CHECK;