1 Package hr_psf_rku AUTHID CURRENT_USER as
2 /* $Header: hrpsfrhi.pkh 120.3.12020000.2 2013/04/19 03:06:04 pathota ship $ */
3 --
4 --
5 g_debug boolean := hr_utility.debug_enabled;
6 --
7 --
8 --
9 -- ----------------------------------------------------------------------------
10 -- |----------------------------< after_update >------------------------------|
11 -- ----------------------------------------------------------------------------
12 --
13 procedure after_update(
14 p_position_id in number ,
15 p_effective_start_date in date ,
16 p_effective_end_date in date ,
17 p_availability_status_id in number ,
18 p_entry_step_id in number ,
19 p_entry_grade_rule_id in number ,
20 p_location_id in number ,
21 p_pay_freq_payroll_id in number ,
22 p_position_definition_id in number ,
23 p_position_transaction_id in number ,
24 p_prior_position_id in number ,
25 p_relief_position_id in number ,
26 p_entry_grade_id in number ,
27 p_successor_position_id in number ,
28 p_supervisor_position_id in number ,
29 p_amendment_date in date ,
30 p_amendment_recommendation in varchar2,
31 p_amendment_ref_number in varchar2,
32 p_bargaining_unit_cd in varchar2,
33 p_comments in varchar2,
34 p_current_job_prop_end_date in date ,
35 p_current_org_prop_end_date in date ,
36 p_avail_status_prop_end_date in date ,
37 p_date_effective in date ,
38 p_date_end in date ,
39 p_earliest_hire_date in date ,
40 p_fill_by_date in date ,
41 p_frequency in varchar2,
42 p_fte in number ,
43 p_max_persons in number ,
44 p_name in varchar2,
45 p_overlap_period in number ,
46 p_overlap_unit_cd in varchar2,
47 p_pay_term_end_day_cd in varchar2,
48 p_pay_term_end_month_cd in varchar2,
49 p_permanent_temporary_flag in varchar2,
50 p_permit_recruitment_flag in varchar2,
51 p_position_type in varchar2,
52 p_posting_description in varchar2,
53 p_probation_period in number ,
54 p_probation_period_unit_cd in varchar2,
55 p_replacement_required_flag in varchar2,
56 p_review_flag in varchar2,
57 p_seasonal_flag in varchar2,
58 p_security_requirements in varchar2,
59 p_status in varchar2,
60 p_term_start_day_cd in varchar2,
61 p_term_start_month_cd in varchar2,
62 p_time_normal_finish in varchar2,
63 p_time_normal_start in varchar2,
64 p_update_source_cd in varchar2,
65 p_working_hours in number ,
66 p_works_council_approval_flag in varchar2,
67 p_work_period_type_cd in varchar2,
68 p_work_term_end_day_cd in varchar2,
69 p_work_term_end_month_cd in varchar2,
70 p_proposed_fte_for_layoff in number ,
71 p_proposed_date_for_layoff in date ,
72 p_pay_basis_id in number,
73 p_supervisor_id in number,
74 p_copied_to_old_table_flag in varchar2,
75 p_information1 in varchar2,
76 p_information2 in varchar2,
77 p_information3 in varchar2,
78 p_information4 in varchar2,
79 p_information5 in varchar2,
80 p_information6 in varchar2,
81 p_information7 in varchar2,
82 p_information8 in varchar2,
83 p_information9 in varchar2,
84 p_information10 in varchar2,
85 p_information11 in varchar2,
86 p_information12 in varchar2,
87 p_information13 in varchar2,
88 p_information14 in varchar2,
89 p_information15 in varchar2,
90 p_information16 in varchar2,
91 p_information17 in varchar2,
92 p_information18 in varchar2,
93 p_information19 in varchar2,
94 p_information20 in varchar2,
95 p_information21 in varchar2,
96 p_information22 in varchar2,
97 p_information23 in varchar2,
98 p_information24 in varchar2,
99 p_information25 in varchar2,
100 p_information26 in varchar2,
101 p_information27 in varchar2,
102 p_information28 in varchar2,
103 p_information29 in varchar2,
104 p_information30 in varchar2,
105 p_information_category in varchar2,
106 p_attribute1 in varchar2,
107 p_attribute2 in varchar2,
108 p_attribute3 in varchar2,
109 p_attribute4 in varchar2,
110 p_attribute5 in varchar2,
111 p_attribute6 in varchar2,
112 p_attribute7 in varchar2,
113 p_attribute8 in varchar2,
114 p_attribute9 in varchar2,
115 p_attribute10 in varchar2,
116 p_attribute11 in varchar2,
117 p_attribute12 in varchar2,
118 p_attribute13 in varchar2,
119 p_attribute14 in varchar2,
120 p_attribute15 in varchar2,
121 p_attribute16 in varchar2,
122 p_attribute17 in varchar2,
123 p_attribute18 in varchar2,
124 p_attribute19 in varchar2,
125 p_attribute20 in varchar2,
126 p_attribute21 in varchar2,
127 p_attribute22 in varchar2,
128 p_attribute23 in varchar2,
129 p_attribute24 in varchar2,
130 p_attribute25 in varchar2,
131 p_attribute26 in varchar2,
132 p_attribute27 in varchar2,
133 p_attribute28 in varchar2,
134 p_attribute29 in varchar2,
135 p_attribute30 in varchar2,
136 p_attribute_category in varchar2,
137 p_request_id in number ,
138 p_program_application_id in number ,
139 p_program_id in number ,
140 p_program_update_date in date ,
141 p_object_version_number in number ,
142 p_effective_date in date ,
143 p_datetrack_mode in varchar2,
144 p_effective_start_date_o in date ,
145 p_effective_end_date_o in date ,
146 p_availability_status_id_o in number ,
147 p_business_group_id_o in number ,
148 p_entry_step_id_o in number ,
149 p_entry_grade_rule_id_o in number ,
150 p_job_id_o in number ,
151 p_location_id_o in number ,
152 p_organization_id_o in number ,
153 p_pay_freq_payroll_id_o in number ,
154 p_position_definition_id_o in number ,
155 p_position_transaction_id_o in number ,
156 p_prior_position_id_o in number ,
157 p_relief_position_id_o in number ,
158 p_entry_grade_id_o in number ,
159 p_successor_position_id_o in number ,
160 p_supervisor_position_id_o in number ,
161 p_amendment_date_o in date ,
162 p_amendment_recommendation_o in varchar2,
163 p_amendment_ref_number_o in varchar2,
164 p_bargaining_unit_cd_o in varchar2,
165 p_comments_o in varchar2,
166 p_current_job_prop_end_date_o in date ,
167 p_current_org_prop_end_date_o in date ,
168 p_avail_status_prop_end_date_o in date ,
169 p_date_effective_o in date ,
170 p_date_end_o in date ,
171 p_earliest_hire_date_o in date ,
172 p_fill_by_date_o in date ,
173 p_frequency_o in varchar2,
174 p_fte_o in number ,
175 p_max_persons_o in number ,
176 p_name_o in varchar2,
177 p_overlap_period_o in number ,
178 p_overlap_unit_cd_o in varchar2,
179 p_pay_term_end_day_cd_o in varchar2,
180 p_pay_term_end_month_cd_o in varchar2,
181 p_permanent_temporary_flag_o in varchar2,
182 p_permit_recruitment_flag_o in varchar2,
183 p_position_type_o in varchar2,
184 p_posting_description_o in varchar2,
185 p_probation_period_o in number ,
186 p_probation_period_unit_cd_o in varchar2,
187 p_replacement_required_flag_o in varchar2,
188 p_review_flag_o in varchar2,
189 p_seasonal_flag_o in varchar2,
190 p_security_requirements_o in varchar2,
191 p_status_o in varchar2,
192 p_term_start_day_cd_o in varchar2,
193 p_term_start_month_cd_o in varchar2,
194 p_time_normal_finish_o in varchar2,
195 p_time_normal_start_o in varchar2,
196 p_update_source_cd_o in varchar2,
197 p_working_hours_o in number ,
198 p_works_council_approval_fla_o in varchar2,
199 p_work_period_type_cd_o in varchar2,
200 p_work_term_end_day_cd_o in varchar2,
201 p_work_term_end_month_cd_o in varchar2,
202 p_proposed_fte_for_layoff_o in number ,
203 p_proposed_date_for_layoff_o in date ,
204 p_pay_basis_id_o in number,
205 p_supervisor_id_o in number,
206 p_copied_to_old_table_flag_o in varchar2,
207 p_information1_o in varchar2,
208 p_information2_o in varchar2,
209 p_information3_o in varchar2,
210 p_information4_o in varchar2,
211 p_information5_o in varchar2,
212 p_information6_o in varchar2,
213 p_information7_o in varchar2,
214 p_information8_o in varchar2,
215 p_information9_o in varchar2,
216 p_information10_o in varchar2,
217 p_information11_o in varchar2,
218 p_information12_o in varchar2,
219 p_information13_o in varchar2,
220 p_information14_o in varchar2,
221 p_information15_o in varchar2,
222 p_information16_o in varchar2,
223 p_information17_o in varchar2,
224 p_information18_o in varchar2,
225 p_information19_o in varchar2,
226 p_information20_o in varchar2,
227 p_information21_o in varchar2,
228 p_information22_o in varchar2,
229 p_information23_o in varchar2,
230 p_information24_o in varchar2,
231 p_information25_o in varchar2,
232 p_information26_o in varchar2,
233 p_information27_o in varchar2,
234 p_information28_o in varchar2,
235 p_information29_o in varchar2,
236 p_information30_o in varchar2,
237 p_information_category_o in varchar2,
238 p_attribute1_o in varchar2,
239 p_attribute2_o in varchar2,
240 p_attribute3_o in varchar2,
241 p_attribute4_o in varchar2,
242 p_attribute5_o in varchar2,
243 p_attribute6_o in varchar2,
244 p_attribute7_o in varchar2,
245 p_attribute8_o in varchar2,
246 p_attribute9_o in varchar2,
247 p_attribute10_o in varchar2,
248 p_attribute11_o in varchar2,
249 p_attribute12_o in varchar2,
250 p_attribute13_o in varchar2,
251 p_attribute14_o in varchar2,
252 p_attribute15_o in varchar2,
253 p_attribute16_o in varchar2,
254 p_attribute17_o in varchar2,
255 p_attribute18_o in varchar2,
256 p_attribute19_o in varchar2,
257 p_attribute20_o in varchar2,
258 p_attribute21_o in varchar2,
259 p_attribute22_o in varchar2,
260 p_attribute23_o in varchar2,
261 p_attribute24_o in varchar2,
262 p_attribute25_o in varchar2,
263 p_attribute26_o in varchar2,
264 p_attribute27_o in varchar2,
265 p_attribute28_o in varchar2,
266 p_attribute29_o in varchar2,
267 p_attribute30_o in varchar2,
268 p_attribute_category_o in varchar2,
269 p_request_id_o in number ,
270 p_program_application_id_o in number ,
271 p_program_id_o in number ,
272 p_program_update_date_o in date ,
273 p_object_version_number_o in number
274 );
275 end hr_psf_rku;