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.
PACKAGE BODY: APPS.HR_ASSIGNMENT_BKM

Source


1 package body HR_ASSIGNMENT_BKM as
2 /* $Header: peasgapi.pkb 120.37.12020000.11 2013/02/28 09:37:22 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2013/08/13 18:42:22 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_CWK_ASG_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
8 ,P_ASSIGNMENT_ID in NUMBER
9 ,P_OBJECT_VERSION_NUMBER in NUMBER
10 ,P_ASSIGNMENT_CATEGORY in VARCHAR2
11 ,P_ASSIGNMENT_NUMBER in VARCHAR2
12 ,P_CHANGE_REASON in VARCHAR2
13 ,P_COMMENTS in VARCHAR2
14 ,P_DEFAULT_CODE_COMB_ID in NUMBER
15 ,P_ESTABLISHMENT_ID in NUMBER
16 ,P_FREQUENCY in VARCHAR2
17 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
18 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
19 ,P_MANAGER_FLAG in VARCHAR2
20 ,P_NORMAL_HOURS in NUMBER
21 ,P_PROJECT_TITLE in VARCHAR2
22 ,P_SET_OF_BOOKS_ID in NUMBER
23 ,P_SOURCE_TYPE in VARCHAR2
24 ,P_SUPERVISOR_ID in NUMBER
25 ,P_TIME_NORMAL_FINISH in VARCHAR2
26 ,P_TIME_NORMAL_START in VARCHAR2
27 ,P_TITLE in VARCHAR2
28 ,P_VENDOR_ASSIGNMENT_NUMBER in VARCHAR2
29 ,P_VENDOR_EMPLOYEE_NUMBER in VARCHAR2
30 ,P_VENDOR_ID in NUMBER
31 ,P_VENDOR_SITE_ID in NUMBER
32 ,P_PO_HEADER_ID in NUMBER
33 ,P_PO_LINE_ID in NUMBER
34 ,P_PROJECTED_ASSIGNMENT_END in DATE
35 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
36 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
37 ,P_ATTRIBUTE1 in VARCHAR2
38 ,P_ATTRIBUTE2 in VARCHAR2
39 ,P_ATTRIBUTE3 in VARCHAR2
40 ,P_ATTRIBUTE4 in VARCHAR2
41 ,P_ATTRIBUTE5 in VARCHAR2
42 ,P_ATTRIBUTE6 in VARCHAR2
43 ,P_ATTRIBUTE7 in VARCHAR2
44 ,P_ATTRIBUTE8 in VARCHAR2
45 ,P_ATTRIBUTE9 in VARCHAR2
46 ,P_ATTRIBUTE10 in VARCHAR2
47 ,P_ATTRIBUTE11 in VARCHAR2
48 ,P_ATTRIBUTE12 in VARCHAR2
49 ,P_ATTRIBUTE13 in VARCHAR2
50 ,P_ATTRIBUTE14 in VARCHAR2
51 ,P_ATTRIBUTE15 in VARCHAR2
52 ,P_ATTRIBUTE16 in VARCHAR2
53 ,P_ATTRIBUTE17 in VARCHAR2
54 ,P_ATTRIBUTE18 in VARCHAR2
55 ,P_ATTRIBUTE19 in VARCHAR2
56 ,P_ATTRIBUTE20 in VARCHAR2
57 ,P_ATTRIBUTE21 in VARCHAR2
58 ,P_ATTRIBUTE22 in VARCHAR2
59 ,P_ATTRIBUTE23 in VARCHAR2
60 ,P_ATTRIBUTE24 in VARCHAR2
61 ,P_ATTRIBUTE25 in VARCHAR2
62 ,P_ATTRIBUTE26 in VARCHAR2
63 ,P_ATTRIBUTE27 in VARCHAR2
64 ,P_ATTRIBUTE28 in VARCHAR2
65 ,P_ATTRIBUTE29 in VARCHAR2
66 ,P_ATTRIBUTE30 in VARCHAR2
67 ,P_SCL_SEGMENT1 in VARCHAR2
68 ,P_SCL_SEGMENT2 in VARCHAR2
69 ,P_SCL_SEGMENT3 in VARCHAR2
70 ,P_SCL_SEGMENT4 in VARCHAR2
71 ,P_SCL_SEGMENT5 in VARCHAR2
72 ,P_SCL_SEGMENT6 in VARCHAR2
73 ,P_SCL_SEGMENT7 in VARCHAR2
74 ,P_SCL_SEGMENT8 in VARCHAR2
75 ,P_SCL_SEGMENT9 in VARCHAR2
76 ,P_SCL_SEGMENT10 in VARCHAR2
77 ,P_SCL_SEGMENT11 in VARCHAR2
78 ,P_SCL_SEGMENT12 in VARCHAR2
79 ,P_SCL_SEGMENT13 in VARCHAR2
80 ,P_SCL_SEGMENT14 in VARCHAR2
81 ,P_SCL_SEGMENT15 in VARCHAR2
82 ,P_SCL_SEGMENT16 in VARCHAR2
83 ,P_SCL_SEGMENT17 in VARCHAR2
84 ,P_SCL_SEGMENT18 in VARCHAR2
85 ,P_SCL_SEGMENT19 in VARCHAR2
86 ,P_SCL_SEGMENT20 in VARCHAR2
87 ,P_SCL_SEGMENT21 in VARCHAR2
88 ,P_SCL_SEGMENT22 in VARCHAR2
89 ,P_SCL_SEGMENT23 in VARCHAR2
90 ,P_SCL_SEGMENT24 in VARCHAR2
91 ,P_SCL_SEGMENT25 in VARCHAR2
92 ,P_SCL_SEGMENT26 in VARCHAR2
93 ,P_SCL_SEGMENT27 in VARCHAR2
94 ,P_SCL_SEGMENT28 in VARCHAR2
95 ,P_SCL_SEGMENT29 in VARCHAR2
96 ,P_SCL_SEGMENT30 in VARCHAR2
97 ,P_ORG_NOW_NO_MANAGER_WARNING in BOOLEAN
98 ,P_EFFECTIVE_START_DATE in DATE
99 ,P_EFFECTIVE_END_DATE in DATE
100 ,P_COMMENT_ID in NUMBER
101 ,P_NO_MANAGERS_WARNING in BOOLEAN
102 ,P_OTHER_MANAGER_WARNING in BOOLEAN
103 ,P_SOFT_CODING_KEYFLEX_ID in NUMBER
104 ,P_CONCATENATED_SEGMENTS in VARCHAR2
105 ,P_HOURLY_SALARIED_WARNING in BOOLEAN
106 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
107 )is
108 l_commit_unit_number number;
109 l_legislation_code   varchar2(30);
110 begin
111 hr_utility.set_location('Entering: HR_ASSIGNMENT_BKM.UPDATE_CWK_ASG_A', 10);
112 l_commit_unit_number := hr_api.return_commit_unit;
113 if hr_api.call_app_hooks then
114 hr_assignment_beM.UPDATE_CWK_ASG_A
115 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
116 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
117 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
118 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
119 ,P_ASSIGNMENT_CATEGORY => P_ASSIGNMENT_CATEGORY
120 ,P_ASSIGNMENT_NUMBER => P_ASSIGNMENT_NUMBER
121 ,P_CHANGE_REASON => P_CHANGE_REASON
122 ,P_COMMENTS => P_COMMENTS
123 ,P_DEFAULT_CODE_COMB_ID => P_DEFAULT_CODE_COMB_ID
124 ,P_ESTABLISHMENT_ID => P_ESTABLISHMENT_ID
125 ,P_FREQUENCY => P_FREQUENCY
126 ,P_INTERNAL_ADDRESS_LINE => P_INTERNAL_ADDRESS_LINE
127 ,P_LABOUR_UNION_MEMBER_FLAG => P_LABOUR_UNION_MEMBER_FLAG
128 ,P_MANAGER_FLAG => P_MANAGER_FLAG
129 ,P_NORMAL_HOURS => P_NORMAL_HOURS
130 ,P_PROJECT_TITLE => P_PROJECT_TITLE
131 ,P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
132 ,P_SOURCE_TYPE => P_SOURCE_TYPE
133 ,P_SUPERVISOR_ID => P_SUPERVISOR_ID
134 ,P_TIME_NORMAL_FINISH => P_TIME_NORMAL_FINISH
135 ,P_TIME_NORMAL_START => P_TIME_NORMAL_START
136 ,P_TITLE => P_TITLE
137 ,P_VENDOR_ASSIGNMENT_NUMBER => P_VENDOR_ASSIGNMENT_NUMBER
138 ,P_VENDOR_EMPLOYEE_NUMBER => P_VENDOR_EMPLOYEE_NUMBER
139 ,P_VENDOR_ID => P_VENDOR_ID
140 ,P_VENDOR_SITE_ID => P_VENDOR_SITE_ID
141 ,P_PO_HEADER_ID => P_PO_HEADER_ID
142 ,P_PO_LINE_ID => P_PO_LINE_ID
143 ,P_PROJECTED_ASSIGNMENT_END => P_PROJECTED_ASSIGNMENT_END
144 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
145 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
146 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
147 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
148 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
149 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
150 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
151 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
152 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
153 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
154 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
155 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
156 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
157 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
161 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
158 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
159 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
160 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
162 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
163 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
164 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
165 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
166 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
167 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
168 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
169 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
170 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
171 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
172 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
173 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
174 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
175 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
176 ,P_SCL_SEGMENT1 => P_SCL_SEGMENT1
177 ,P_SCL_SEGMENT2 => P_SCL_SEGMENT2
178 ,P_SCL_SEGMENT3 => P_SCL_SEGMENT3
179 ,P_SCL_SEGMENT4 => P_SCL_SEGMENT4
180 ,P_SCL_SEGMENT5 => P_SCL_SEGMENT5
181 ,P_SCL_SEGMENT6 => P_SCL_SEGMENT6
182 ,P_SCL_SEGMENT7 => P_SCL_SEGMENT7
183 ,P_SCL_SEGMENT8 => P_SCL_SEGMENT8
184 ,P_SCL_SEGMENT9 => P_SCL_SEGMENT9
185 ,P_SCL_SEGMENT10 => P_SCL_SEGMENT10
186 ,P_SCL_SEGMENT11 => P_SCL_SEGMENT11
187 ,P_SCL_SEGMENT12 => P_SCL_SEGMENT12
188 ,P_SCL_SEGMENT13 => P_SCL_SEGMENT13
189 ,P_SCL_SEGMENT14 => P_SCL_SEGMENT14
190 ,P_SCL_SEGMENT15 => P_SCL_SEGMENT15
191 ,P_SCL_SEGMENT16 => P_SCL_SEGMENT16
192 ,P_SCL_SEGMENT17 => P_SCL_SEGMENT17
193 ,P_SCL_SEGMENT18 => P_SCL_SEGMENT18
194 ,P_SCL_SEGMENT19 => P_SCL_SEGMENT19
195 ,P_SCL_SEGMENT20 => P_SCL_SEGMENT20
196 ,P_SCL_SEGMENT21 => P_SCL_SEGMENT21
197 ,P_SCL_SEGMENT22 => P_SCL_SEGMENT22
198 ,P_SCL_SEGMENT23 => P_SCL_SEGMENT23
199 ,P_SCL_SEGMENT24 => P_SCL_SEGMENT24
200 ,P_SCL_SEGMENT25 => P_SCL_SEGMENT25
201 ,P_SCL_SEGMENT26 => P_SCL_SEGMENT26
202 ,P_SCL_SEGMENT27 => P_SCL_SEGMENT27
203 ,P_SCL_SEGMENT28 => P_SCL_SEGMENT28
204 ,P_SCL_SEGMENT29 => P_SCL_SEGMENT29
205 ,P_SCL_SEGMENT30 => P_SCL_SEGMENT30
206 ,P_ORG_NOW_NO_MANAGER_WARNING => P_ORG_NOW_NO_MANAGER_WARNING
207 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
208 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
209 ,P_COMMENT_ID => P_COMMENT_ID
210 ,P_NO_MANAGERS_WARNING => P_NO_MANAGERS_WARNING
211 ,P_OTHER_MANAGER_WARNING => P_OTHER_MANAGER_WARNING
212 ,P_SOFT_CODING_KEYFLEX_ID => P_SOFT_CODING_KEYFLEX_ID
213 ,P_CONCATENATED_SEGMENTS => P_CONCATENATED_SEGMENTS
214 ,P_HOURLY_SALARIED_WARNING => P_HOURLY_SALARIED_WARNING
215 ,P_SUPERVISOR_ASSIGNMENT_ID => P_SUPERVISOR_ASSIGNMENT_ID
216 );
217 end if;
218 hr_multi_message.end_validation_set;
219 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_CWK_ASG', 'AP');
220 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BKM.UPDATE_CWK_ASG_A', 20);
221 end UPDATE_CWK_ASG_A;
222 procedure UPDATE_CWK_ASG_B
223 (P_EFFECTIVE_DATE in DATE
224 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
225 ,P_ASSIGNMENT_ID in NUMBER
226 ,P_OBJECT_VERSION_NUMBER in NUMBER
227 ,P_ASSIGNMENT_CATEGORY in VARCHAR2
228 ,P_ASSIGNMENT_NUMBER in VARCHAR2
229 ,P_CHANGE_REASON in VARCHAR2
230 ,P_COMMENTS in VARCHAR2
231 ,P_DEFAULT_CODE_COMB_ID in NUMBER
232 ,P_ESTABLISHMENT_ID in NUMBER
233 ,P_FREQUENCY in VARCHAR2
234 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
235 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
236 ,P_MANAGER_FLAG in VARCHAR2
237 ,P_NORMAL_HOURS in NUMBER
238 ,P_PROJECT_TITLE in VARCHAR2
239 ,P_SET_OF_BOOKS_ID in NUMBER
240 ,P_SOURCE_TYPE in VARCHAR2
241 ,P_SUPERVISOR_ID in NUMBER
242 ,P_TIME_NORMAL_FINISH in VARCHAR2
243 ,P_TIME_NORMAL_START in VARCHAR2
244 ,P_TITLE in VARCHAR2
245 ,P_VENDOR_ASSIGNMENT_NUMBER in VARCHAR2
246 ,P_VENDOR_EMPLOYEE_NUMBER in VARCHAR2
247 ,P_VENDOR_ID in NUMBER
248 ,P_VENDOR_SITE_ID in NUMBER
249 ,P_PO_HEADER_ID in NUMBER
250 ,P_PO_LINE_ID in NUMBER
251 ,P_PROJECTED_ASSIGNMENT_END in DATE
252 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
253 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
254 ,P_ATTRIBUTE1 in VARCHAR2
255 ,P_ATTRIBUTE2 in VARCHAR2
256 ,P_ATTRIBUTE3 in VARCHAR2
257 ,P_ATTRIBUTE4 in VARCHAR2
258 ,P_ATTRIBUTE5 in VARCHAR2
259 ,P_ATTRIBUTE6 in VARCHAR2
260 ,P_ATTRIBUTE7 in VARCHAR2
261 ,P_ATTRIBUTE8 in VARCHAR2
262 ,P_ATTRIBUTE9 in VARCHAR2
263 ,P_ATTRIBUTE10 in VARCHAR2
264 ,P_ATTRIBUTE11 in VARCHAR2
265 ,P_ATTRIBUTE12 in VARCHAR2
266 ,P_ATTRIBUTE13 in VARCHAR2
267 ,P_ATTRIBUTE14 in VARCHAR2
268 ,P_ATTRIBUTE15 in VARCHAR2
269 ,P_ATTRIBUTE16 in VARCHAR2
270 ,P_ATTRIBUTE17 in VARCHAR2
271 ,P_ATTRIBUTE18 in VARCHAR2
272 ,P_ATTRIBUTE19 in VARCHAR2
273 ,P_ATTRIBUTE20 in VARCHAR2
274 ,P_ATTRIBUTE21 in VARCHAR2
275 ,P_ATTRIBUTE22 in VARCHAR2
276 ,P_ATTRIBUTE23 in VARCHAR2
277 ,P_ATTRIBUTE24 in VARCHAR2
278 ,P_ATTRIBUTE25 in VARCHAR2
279 ,P_ATTRIBUTE26 in VARCHAR2
280 ,P_ATTRIBUTE27 in VARCHAR2
281 ,P_ATTRIBUTE28 in VARCHAR2
282 ,P_ATTRIBUTE29 in VARCHAR2
283 ,P_ATTRIBUTE30 in VARCHAR2
284 ,P_SCL_SEGMENT1 in VARCHAR2
285 ,P_SCL_SEGMENT2 in VARCHAR2
286 ,P_SCL_SEGMENT3 in VARCHAR2
287 ,P_SCL_SEGMENT4 in VARCHAR2
288 ,P_SCL_SEGMENT5 in VARCHAR2
289 ,P_SCL_SEGMENT6 in VARCHAR2
290 ,P_SCL_SEGMENT7 in VARCHAR2
291 ,P_SCL_SEGMENT8 in VARCHAR2
292 ,P_SCL_SEGMENT9 in VARCHAR2
293 ,P_SCL_SEGMENT10 in VARCHAR2
294 ,P_SCL_SEGMENT11 in VARCHAR2
295 ,P_SCL_SEGMENT12 in VARCHAR2
296 ,P_SCL_SEGMENT13 in VARCHAR2
297 ,P_SCL_SEGMENT14 in VARCHAR2
298 ,P_SCL_SEGMENT15 in VARCHAR2
299 ,P_SCL_SEGMENT16 in VARCHAR2
300 ,P_SCL_SEGMENT17 in VARCHAR2
301 ,P_SCL_SEGMENT18 in VARCHAR2
302 ,P_SCL_SEGMENT19 in VARCHAR2
303 ,P_SCL_SEGMENT20 in VARCHAR2
304 ,P_SCL_SEGMENT21 in VARCHAR2
305 ,P_SCL_SEGMENT22 in VARCHAR2
306 ,P_SCL_SEGMENT23 in VARCHAR2
307 ,P_SCL_SEGMENT24 in VARCHAR2
308 ,P_SCL_SEGMENT25 in VARCHAR2
309 ,P_SCL_SEGMENT26 in VARCHAR2
310 ,P_SCL_SEGMENT27 in VARCHAR2
311 ,P_SCL_SEGMENT28 in VARCHAR2
312 ,P_SCL_SEGMENT29 in VARCHAR2
313 ,P_SCL_SEGMENT30 in VARCHAR2
314 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
315 )is
316 begin
317 hr_utility.set_location('Entering: HR_ASSIGNMENT_BKM.UPDATE_CWK_ASG_B', 10);
318 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BKM.UPDATE_CWK_ASG_B', 20);
319 end UPDATE_CWK_ASG_B;
320 end HR_ASSIGNMENT_BKM;