DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_PSF_RKU

Source


1 package body HR_PSF_RKU as
2 /* $Header: hrpsfrhi.pkb 120.14.12020000.5 2013/04/12 18:20:17 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2013/08/13 18:42:16 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_UPDATE
6 (P_POSITION_ID in NUMBER
7 ,P_EFFECTIVE_START_DATE in DATE
8 ,P_EFFECTIVE_END_DATE in DATE
9 ,P_AVAILABILITY_STATUS_ID in NUMBER
10 ,P_ENTRY_STEP_ID in NUMBER
11 ,P_ENTRY_GRADE_RULE_ID in NUMBER
12 ,P_LOCATION_ID in NUMBER
13 ,P_PAY_FREQ_PAYROLL_ID in NUMBER
14 ,P_POSITION_DEFINITION_ID in NUMBER
15 ,P_POSITION_TRANSACTION_ID in NUMBER
16 ,P_PRIOR_POSITION_ID in NUMBER
17 ,P_RELIEF_POSITION_ID in NUMBER
18 ,P_ENTRY_GRADE_ID in NUMBER
19 ,P_SUCCESSOR_POSITION_ID in NUMBER
20 ,P_SUPERVISOR_POSITION_ID in NUMBER
21 ,P_AMENDMENT_DATE in DATE
22 ,P_AMENDMENT_RECOMMENDATION in VARCHAR2
23 ,P_AMENDMENT_REF_NUMBER in VARCHAR2
24 ,P_BARGAINING_UNIT_CD in VARCHAR2
25 ,P_COMMENTS in VARCHAR2
26 ,P_CURRENT_JOB_PROP_END_DATE in DATE
27 ,P_CURRENT_ORG_PROP_END_DATE in DATE
28 ,P_AVAIL_STATUS_PROP_END_DATE in DATE
29 ,P_DATE_EFFECTIVE in DATE
30 ,P_DATE_END in DATE
31 ,P_EARLIEST_HIRE_DATE in DATE
32 ,P_FILL_BY_DATE in DATE
33 ,P_FREQUENCY in VARCHAR2
34 ,P_FTE in NUMBER
35 ,P_MAX_PERSONS in NUMBER
36 ,P_NAME in VARCHAR2
37 ,P_OVERLAP_PERIOD in NUMBER
38 ,P_OVERLAP_UNIT_CD in VARCHAR2
39 ,P_PAY_TERM_END_DAY_CD in VARCHAR2
40 ,P_PAY_TERM_END_MONTH_CD in VARCHAR2
41 ,P_PERMANENT_TEMPORARY_FLAG in VARCHAR2
42 ,P_PERMIT_RECRUITMENT_FLAG in VARCHAR2
43 ,P_POSITION_TYPE in VARCHAR2
44 ,P_POSTING_DESCRIPTION in VARCHAR2
45 ,P_PROBATION_PERIOD in NUMBER
46 ,P_PROBATION_PERIOD_UNIT_CD in VARCHAR2
47 ,P_REPLACEMENT_REQUIRED_FLAG in VARCHAR2
48 ,P_REVIEW_FLAG in VARCHAR2
49 ,P_SEASONAL_FLAG in VARCHAR2
50 ,P_SECURITY_REQUIREMENTS in VARCHAR2
51 ,P_STATUS in VARCHAR2
52 ,P_TERM_START_DAY_CD in VARCHAR2
53 ,P_TERM_START_MONTH_CD in VARCHAR2
54 ,P_TIME_NORMAL_FINISH in VARCHAR2
55 ,P_TIME_NORMAL_START in VARCHAR2
56 ,P_UPDATE_SOURCE_CD in VARCHAR2
57 ,P_WORKING_HOURS in NUMBER
58 ,P_WORKS_COUNCIL_APPROVAL_FLAG in VARCHAR2
59 ,P_WORK_PERIOD_TYPE_CD in VARCHAR2
60 ,P_WORK_TERM_END_DAY_CD in VARCHAR2
61 ,P_WORK_TERM_END_MONTH_CD in VARCHAR2
62 ,P_PROPOSED_FTE_FOR_LAYOFF in NUMBER
63 ,P_PROPOSED_DATE_FOR_LAYOFF in DATE
64 ,P_PAY_BASIS_ID in NUMBER
65 ,P_SUPERVISOR_ID in NUMBER
66 ,P_COPIED_TO_OLD_TABLE_FLAG in VARCHAR2
67 ,P_INFORMATION1 in VARCHAR2
68 ,P_INFORMATION2 in VARCHAR2
69 ,P_INFORMATION3 in VARCHAR2
70 ,P_INFORMATION4 in VARCHAR2
71 ,P_INFORMATION5 in VARCHAR2
72 ,P_INFORMATION6 in VARCHAR2
73 ,P_INFORMATION7 in VARCHAR2
74 ,P_INFORMATION8 in VARCHAR2
75 ,P_INFORMATION9 in VARCHAR2
76 ,P_INFORMATION10 in VARCHAR2
77 ,P_INFORMATION11 in VARCHAR2
78 ,P_INFORMATION12 in VARCHAR2
79 ,P_INFORMATION13 in VARCHAR2
80 ,P_INFORMATION14 in VARCHAR2
81 ,P_INFORMATION15 in VARCHAR2
82 ,P_INFORMATION16 in VARCHAR2
83 ,P_INFORMATION17 in VARCHAR2
84 ,P_INFORMATION18 in VARCHAR2
85 ,P_INFORMATION19 in VARCHAR2
86 ,P_INFORMATION20 in VARCHAR2
87 ,P_INFORMATION21 in VARCHAR2
88 ,P_INFORMATION22 in VARCHAR2
89 ,P_INFORMATION23 in VARCHAR2
90 ,P_INFORMATION24 in VARCHAR2
91 ,P_INFORMATION25 in VARCHAR2
92 ,P_INFORMATION26 in VARCHAR2
93 ,P_INFORMATION27 in VARCHAR2
94 ,P_INFORMATION28 in VARCHAR2
95 ,P_INFORMATION29 in VARCHAR2
96 ,P_INFORMATION30 in VARCHAR2
97 ,P_INFORMATION_CATEGORY in VARCHAR2
98 ,P_ATTRIBUTE1 in VARCHAR2
99 ,P_ATTRIBUTE2 in VARCHAR2
100 ,P_ATTRIBUTE3 in VARCHAR2
101 ,P_ATTRIBUTE4 in VARCHAR2
102 ,P_ATTRIBUTE5 in VARCHAR2
103 ,P_ATTRIBUTE6 in VARCHAR2
104 ,P_ATTRIBUTE7 in VARCHAR2
105 ,P_ATTRIBUTE8 in VARCHAR2
106 ,P_ATTRIBUTE9 in VARCHAR2
107 ,P_ATTRIBUTE10 in VARCHAR2
108 ,P_ATTRIBUTE11 in VARCHAR2
109 ,P_ATTRIBUTE12 in VARCHAR2
110 ,P_ATTRIBUTE13 in VARCHAR2
111 ,P_ATTRIBUTE14 in VARCHAR2
112 ,P_ATTRIBUTE15 in VARCHAR2
113 ,P_ATTRIBUTE16 in VARCHAR2
114 ,P_ATTRIBUTE17 in VARCHAR2
115 ,P_ATTRIBUTE18 in VARCHAR2
116 ,P_ATTRIBUTE19 in VARCHAR2
117 ,P_ATTRIBUTE20 in VARCHAR2
118 ,P_ATTRIBUTE21 in VARCHAR2
119 ,P_ATTRIBUTE22 in VARCHAR2
120 ,P_ATTRIBUTE23 in VARCHAR2
121 ,P_ATTRIBUTE24 in VARCHAR2
122 ,P_ATTRIBUTE25 in VARCHAR2
123 ,P_ATTRIBUTE26 in VARCHAR2
124 ,P_ATTRIBUTE27 in VARCHAR2
125 ,P_ATTRIBUTE28 in VARCHAR2
126 ,P_ATTRIBUTE29 in VARCHAR2
127 ,P_ATTRIBUTE30 in VARCHAR2
128 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
129 ,P_REQUEST_ID in NUMBER
130 ,P_PROGRAM_APPLICATION_ID in NUMBER
131 ,P_PROGRAM_ID in NUMBER
132 ,P_PROGRAM_UPDATE_DATE in DATE
133 ,P_OBJECT_VERSION_NUMBER in NUMBER
134 ,P_EFFECTIVE_DATE in DATE
135 ,P_DATETRACK_MODE in VARCHAR2
136 ,P_EFFECTIVE_START_DATE_O in DATE
137 ,P_EFFECTIVE_END_DATE_O in DATE
138 ,P_AVAILABILITY_STATUS_ID_O in NUMBER
139 ,P_BUSINESS_GROUP_ID_O in NUMBER
140 ,P_ENTRY_STEP_ID_O in NUMBER
141 ,P_ENTRY_GRADE_RULE_ID_O in NUMBER
142 ,P_JOB_ID_O in NUMBER
143 ,P_LOCATION_ID_O in NUMBER
144 ,P_ORGANIZATION_ID_O in NUMBER
145 ,P_PAY_FREQ_PAYROLL_ID_O in NUMBER
146 ,P_POSITION_DEFINITION_ID_O in NUMBER
147 ,P_POSITION_TRANSACTION_ID_O in NUMBER
148 ,P_PRIOR_POSITION_ID_O in NUMBER
149 ,P_RELIEF_POSITION_ID_O in NUMBER
150 ,P_ENTRY_GRADE_ID_O in NUMBER
151 ,P_SUCCESSOR_POSITION_ID_O in NUMBER
152 ,P_SUPERVISOR_POSITION_ID_O in NUMBER
153 ,P_AMENDMENT_DATE_O in DATE
154 ,P_AMENDMENT_RECOMMENDATION_O in VARCHAR2
155 ,P_AMENDMENT_REF_NUMBER_O in VARCHAR2
156 ,P_BARGAINING_UNIT_CD_O in VARCHAR2
157 ,P_COMMENTS_O in VARCHAR2
158 ,P_CURRENT_JOB_PROP_END_DATE_O in DATE
159 ,P_CURRENT_ORG_PROP_END_DATE_O in DATE
160 ,P_AVAIL_STATUS_PROP_END_DATE_O in DATE
161 ,P_DATE_EFFECTIVE_O in DATE
162 ,P_DATE_END_O in DATE
163 ,P_EARLIEST_HIRE_DATE_O in DATE
164 ,P_FILL_BY_DATE_O in DATE
165 ,P_FREQUENCY_O in VARCHAR2
166 ,P_FTE_O in NUMBER
167 ,P_MAX_PERSONS_O in NUMBER
168 ,P_NAME_O in VARCHAR2
169 ,P_OVERLAP_PERIOD_O in NUMBER
170 ,P_OVERLAP_UNIT_CD_O in VARCHAR2
171 ,P_PAY_TERM_END_DAY_CD_O in VARCHAR2
172 ,P_PAY_TERM_END_MONTH_CD_O in VARCHAR2
173 ,P_PERMANENT_TEMPORARY_FLAG_O in VARCHAR2
174 ,P_PERMIT_RECRUITMENT_FLAG_O in VARCHAR2
175 ,P_POSITION_TYPE_O in VARCHAR2
176 ,P_POSTING_DESCRIPTION_O in VARCHAR2
177 ,P_PROBATION_PERIOD_O in NUMBER
178 ,P_PROBATION_PERIOD_UNIT_CD_O in VARCHAR2
179 ,P_REPLACEMENT_REQUIRED_FLAG_O in VARCHAR2
180 ,P_REVIEW_FLAG_O in VARCHAR2
181 ,P_SEASONAL_FLAG_O in VARCHAR2
182 ,P_SECURITY_REQUIREMENTS_O in VARCHAR2
183 ,P_STATUS_O in VARCHAR2
184 ,P_TERM_START_DAY_CD_O in VARCHAR2
185 ,P_TERM_START_MONTH_CD_O in VARCHAR2
186 ,P_TIME_NORMAL_FINISH_O in VARCHAR2
187 ,P_TIME_NORMAL_START_O in VARCHAR2
188 ,P_UPDATE_SOURCE_CD_O in VARCHAR2
189 ,P_WORKING_HOURS_O in NUMBER
190 ,P_WORKS_COUNCIL_APPROVAL_FLA_O in VARCHAR2
191 ,P_WORK_PERIOD_TYPE_CD_O in VARCHAR2
192 ,P_WORK_TERM_END_DAY_CD_O in VARCHAR2
193 ,P_WORK_TERM_END_MONTH_CD_O in VARCHAR2
194 ,P_PROPOSED_FTE_FOR_LAYOFF_O in NUMBER
195 ,P_PROPOSED_DATE_FOR_LAYOFF_O in DATE
196 ,P_PAY_BASIS_ID_O in NUMBER
197 ,P_SUPERVISOR_ID_O in NUMBER
198 ,P_COPIED_TO_OLD_TABLE_FLAG_O in VARCHAR2
199 ,P_INFORMATION1_O in VARCHAR2
200 ,P_INFORMATION2_O in VARCHAR2
201 ,P_INFORMATION3_O in VARCHAR2
202 ,P_INFORMATION4_O in VARCHAR2
203 ,P_INFORMATION5_O in VARCHAR2
204 ,P_INFORMATION6_O in VARCHAR2
205 ,P_INFORMATION7_O in VARCHAR2
206 ,P_INFORMATION8_O in VARCHAR2
207 ,P_INFORMATION9_O in VARCHAR2
208 ,P_INFORMATION10_O in VARCHAR2
209 ,P_INFORMATION11_O in VARCHAR2
210 ,P_INFORMATION12_O in VARCHAR2
211 ,P_INFORMATION13_O in VARCHAR2
212 ,P_INFORMATION14_O in VARCHAR2
213 ,P_INFORMATION15_O in VARCHAR2
214 ,P_INFORMATION16_O in VARCHAR2
215 ,P_INFORMATION17_O in VARCHAR2
216 ,P_INFORMATION18_O in VARCHAR2
217 ,P_INFORMATION19_O in VARCHAR2
218 ,P_INFORMATION20_O in VARCHAR2
219 ,P_INFORMATION21_O in VARCHAR2
220 ,P_INFORMATION22_O in VARCHAR2
221 ,P_INFORMATION23_O in VARCHAR2
222 ,P_INFORMATION24_O in VARCHAR2
223 ,P_INFORMATION25_O in VARCHAR2
224 ,P_INFORMATION26_O in VARCHAR2
225 ,P_INFORMATION27_O in VARCHAR2
226 ,P_INFORMATION28_O in VARCHAR2
227 ,P_INFORMATION29_O in VARCHAR2
228 ,P_INFORMATION30_O in VARCHAR2
229 ,P_INFORMATION_CATEGORY_O in VARCHAR2
230 ,P_ATTRIBUTE1_O in VARCHAR2
231 ,P_ATTRIBUTE2_O in VARCHAR2
232 ,P_ATTRIBUTE3_O in VARCHAR2
233 ,P_ATTRIBUTE4_O in VARCHAR2
234 ,P_ATTRIBUTE5_O in VARCHAR2
235 ,P_ATTRIBUTE6_O in VARCHAR2
236 ,P_ATTRIBUTE7_O in VARCHAR2
237 ,P_ATTRIBUTE8_O in VARCHAR2
238 ,P_ATTRIBUTE9_O in VARCHAR2
239 ,P_ATTRIBUTE10_O in VARCHAR2
240 ,P_ATTRIBUTE11_O in VARCHAR2
241 ,P_ATTRIBUTE12_O in VARCHAR2
242 ,P_ATTRIBUTE13_O in VARCHAR2
243 ,P_ATTRIBUTE14_O in VARCHAR2
244 ,P_ATTRIBUTE15_O in VARCHAR2
245 ,P_ATTRIBUTE16_O in VARCHAR2
246 ,P_ATTRIBUTE17_O in VARCHAR2
247 ,P_ATTRIBUTE18_O in VARCHAR2
248 ,P_ATTRIBUTE19_O in VARCHAR2
249 ,P_ATTRIBUTE20_O in VARCHAR2
250 ,P_ATTRIBUTE21_O in VARCHAR2
251 ,P_ATTRIBUTE22_O in VARCHAR2
252 ,P_ATTRIBUTE23_O in VARCHAR2
253 ,P_ATTRIBUTE24_O in VARCHAR2
254 ,P_ATTRIBUTE25_O in VARCHAR2
255 ,P_ATTRIBUTE26_O in VARCHAR2
256 ,P_ATTRIBUTE27_O in VARCHAR2
257 ,P_ATTRIBUTE28_O in VARCHAR2
258 ,P_ATTRIBUTE29_O in VARCHAR2
259 ,P_ATTRIBUTE30_O in VARCHAR2
260 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
261 ,P_REQUEST_ID_O in NUMBER
262 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
263 ,P_PROGRAM_ID_O in NUMBER
264 ,P_PROGRAM_UPDATE_DATE_O in DATE
265 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
266 )is
267 begin
268 hr_utility.set_location('Entering: HR_PSF_RKU.AFTER_UPDATE', 10);
269 hr_utility.set_location(' Leaving: HR_PSF_RKU.AFTER_UPDATE', 20);
270 end AFTER_UPDATE;
271 end HR_PSF_RKU;