[Home] [Help]
PACKAGE: APPS.GHR_MASS_AWARDS_PKG
Source
1 PACKAGE GHR_MASS_AWARDS_PKG AS
2 /* $Header: ghrmarpa.pkh 120.1.12000000.1 2007/01/18 14:14:43 appldev noship $ */
3
4
5 type first_lac1_record is record
6 ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
7 first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
8 first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
9 first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
10 first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
11 first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
12 first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
13
14 type first_lac2_record is record
15 ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
16 first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
17 first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
18 first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
19 first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
20 first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
21 first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
22
23 PROCEDURE get_noa_code_desc
24 (
25 p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
26 p_effective_date in date default trunc(sysdate),
27 p_noa_code out nocopy ghr_nature_of_actions.code%type,
28 p_noa_desc out nocopy ghr_nature_of_actions.description%type
29 );
30
31 FUNCTION get_noa_id (
32 p_mass_award_id in ghr_mass_awards.mass_award_id%type)
33 RETURN NUMBER;
34
35 PROCEDURE get_business_group(p_person_id in number,
36 p_effective_date in date,
37 p_business_group_id in out nocopy number);
38
39 --Bug#3804067 Added new parameter p_mass_action_comments
40 PROCEDURE get_pa_request_id_ovn
41 (
42 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
43 p_effective_date in date,
44 p_person_id in per_people_f.person_id%TYPE,
45 p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
46 p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
47 p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
48 p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
49 p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
50 p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE
51 );
52
53 PROCEDURE get_award_details
54 (
55 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
56 p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
57 p_effective_date in date,
58 p_person_id in ghr_pa_requests.person_id%TYPE,
59 p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
60 p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
61 p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62 p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63 p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64 p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
65 p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
66 p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
67 p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
68
69 );
70
71 PROCEDURE get_award_lac
72 (
73 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
74 p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
75 p_effective_date in date,
76 p_first_lac1_record out nocopy first_lac1_record,
77 p_first_lac2_record out nocopy first_lac2_record
78 );
79
80
81 PROCEDURE get_award_details_shadow
82 (
83 p_pa_request_id in ghr_pa_request_ei_shadow.pa_request_id%type,
84 p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
85 p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
86 p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
87 p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88 p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89 p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
90 p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
91 p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
92 p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
93 );
94 ---- Fetch Remarks and Legal Authority codes.
95
96 PROCEDURE main_awards
97 (
98 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
99 p_action_type in varchar2,
100 p_errbuf out nocopy varchar2, --\___ error log
101 p_status out nocopy varchar2, --||
102 p_retcode out nocopy number, --/ in conc. manager.
103 p_maxcheck out nocopy number
104 );
105
106 PROCEDURE upd_elig_flag_bef_selection
107 (
108 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
109 p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
110 p_effective_date in date
111 );
112
113 Procedure marpa_process
114 (
115 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
116 p_action_type in VARCHAR2,
117 p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
118 p_effective_date in date,
119 p_person_id in per_people_f.person_id%TYPE,
120 p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
121 p_log_text out nocopy varchar2,
122 p_maxcheck out nocopy number
123 );
124
125 PROCEDURE build_rpa_for_mass_awards
126 (
127 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
128 p_action_type in varchar2,
129 p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
130 p_effective_date in date,
131 p_person_id in per_people_f.person_id%TYPE,
132 p_assignment_id in per_assignments_f.assignment_id%TYPE,
133 p_position_id in hr_positions_f.position_id%TYPE,
134 p_grade_id in number,
135 p_location_id in hr_locations.location_id%TYPE,
136 p_job_id in number,
137 p_errbuf out nocopy varchar2, --\ error log
138 p_status out nocopy varchar2, --||
139 p_retcode out nocopy number,
140 p_maxcheck out nocopy number --/ in conc. manager.
141 );
142
143 PROCEDURE refresh_award_details
144 (
145 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
146 p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
147 p_effective_date in date,
148 p_person_id in per_people_f.person_id%TYPE,
149 p_pa_request_id in ghr_pa_requests.pa_request_id%type
150 );
151
152 PROCEDURE del_elig_flag_aft_selection
153 (
154 p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
155 p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
156 p_effective_date in date
157 );
158
159 Procedure set_ei
160 (p_shadow in out nocopy varchar2,
161 p_template in varchar2,
162 p_person in out nocopy varchar2,
163 p_refresh_flag in varchar2 default 'Y');
164
165 Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype);
166
167 Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
168 p_result out nocopy Boolean );
169 Procedure create_remarks
170 (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
171 p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
172 p_effective_date in date,
173 p_pa_request_id in ghr_pa_requests.pa_request_id%type
174 );
175
176 Procedure mass_awards_error_handling
177 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
178 p_object_version_number in ghr_pa_requests.object_version_number%type,
179 p_error in varchar2 default null,
180 p_result out nocopy boolean
181 );
182
183 PROCEDURE check_award_amount
184 (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
185 p_effective_date ghr_pa_requests.effective_date%TYPE,
186 p_award_amount NUMBER,
187 p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
188 p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
189 p_to_position_id ghr_pa_requests.to_position_id%TYPE,
190 p_comments OUT NOCOPY varchar2,
191 p_error_flg OUT NOCOPY BOOLEAN
192 ) ;
193
194 END GHR_MASS_AWARDS_PKG;