DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_JOB_API_BK2

Source


1 package body HR_JOB_API_BK2 as
2 /* $Header: pejobapi.pkb 120.0 2008/07/28 04:55:31 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:46:35 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_JOB_A
6 (P_JOB_ID in NUMBER
7 ,P_DATE_FROM in DATE
8 ,P_COMMENTS in VARCHAR2
9 ,P_DATE_TO in DATE
10 ,P_APPROVAL_AUTHORITY in NUMBER
11 ,P_BENCHMARK_JOB_FLAG in VARCHAR2
12 ,P_BENCHMARK_JOB_ID in NUMBER
13 ,P_EMP_RIGHTS_FLAG in VARCHAR2
14 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
15 ,P_ATTRIBUTE1 in VARCHAR2
16 ,P_ATTRIBUTE2 in VARCHAR2
17 ,P_ATTRIBUTE3 in VARCHAR2
18 ,P_ATTRIBUTE4 in VARCHAR2
19 ,P_ATTRIBUTE5 in VARCHAR2
20 ,P_ATTRIBUTE6 in VARCHAR2
21 ,P_ATTRIBUTE7 in VARCHAR2
22 ,P_ATTRIBUTE8 in VARCHAR2
23 ,P_ATTRIBUTE9 in VARCHAR2
24 ,P_ATTRIBUTE10 in VARCHAR2
25 ,P_ATTRIBUTE11 in VARCHAR2
26 ,P_ATTRIBUTE12 in VARCHAR2
27 ,P_ATTRIBUTE13 in VARCHAR2
28 ,P_ATTRIBUTE14 in VARCHAR2
29 ,P_ATTRIBUTE15 in VARCHAR2
30 ,P_ATTRIBUTE16 in VARCHAR2
31 ,P_ATTRIBUTE17 in VARCHAR2
32 ,P_ATTRIBUTE18 in VARCHAR2
33 ,P_ATTRIBUTE19 in VARCHAR2
34 ,P_ATTRIBUTE20 in VARCHAR2
35 ,P_JOB_INFORMATION_CATEGORY in VARCHAR2
36 ,P_JOB_INFORMATION1 in VARCHAR2
37 ,P_JOB_INFORMATION2 in VARCHAR2
38 ,P_JOB_INFORMATION3 in VARCHAR2
39 ,P_JOB_INFORMATION4 in VARCHAR2
40 ,P_JOB_INFORMATION5 in VARCHAR2
41 ,P_JOB_INFORMATION6 in VARCHAR2
42 ,P_JOB_INFORMATION7 in VARCHAR2
43 ,P_JOB_INFORMATION8 in VARCHAR2
44 ,P_JOB_INFORMATION9 in VARCHAR2
45 ,P_JOB_INFORMATION10 in VARCHAR2
46 ,P_JOB_INFORMATION11 in VARCHAR2
47 ,P_JOB_INFORMATION12 in VARCHAR2
48 ,P_JOB_INFORMATION13 in VARCHAR2
49 ,P_JOB_INFORMATION14 in VARCHAR2
50 ,P_JOB_INFORMATION15 in VARCHAR2
51 ,P_JOB_INFORMATION16 in VARCHAR2
52 ,P_JOB_INFORMATION17 in VARCHAR2
53 ,P_JOB_INFORMATION18 in VARCHAR2
54 ,P_JOB_INFORMATION19 in VARCHAR2
55 ,P_JOB_INFORMATION20 in VARCHAR2
56 ,P_SEGMENT1 in VARCHAR2
57 ,P_SEGMENT2 in VARCHAR2
58 ,P_SEGMENT3 in VARCHAR2
59 ,P_SEGMENT4 in VARCHAR2
60 ,P_SEGMENT5 in VARCHAR2
61 ,P_SEGMENT6 in VARCHAR2
62 ,P_SEGMENT7 in VARCHAR2
63 ,P_SEGMENT8 in VARCHAR2
64 ,P_SEGMENT9 in VARCHAR2
65 ,P_SEGMENT10 in VARCHAR2
66 ,P_SEGMENT11 in VARCHAR2
67 ,P_SEGMENT12 in VARCHAR2
68 ,P_SEGMENT13 in VARCHAR2
69 ,P_SEGMENT14 in VARCHAR2
70 ,P_SEGMENT15 in VARCHAR2
71 ,P_SEGMENT16 in VARCHAR2
72 ,P_SEGMENT17 in VARCHAR2
73 ,P_SEGMENT18 in VARCHAR2
74 ,P_SEGMENT19 in VARCHAR2
75 ,P_SEGMENT20 in VARCHAR2
76 ,P_SEGMENT21 in VARCHAR2
77 ,P_SEGMENT22 in VARCHAR2
78 ,P_SEGMENT23 in VARCHAR2
79 ,P_SEGMENT24 in VARCHAR2
80 ,P_SEGMENT25 in VARCHAR2
81 ,P_SEGMENT26 in VARCHAR2
82 ,P_SEGMENT27 in VARCHAR2
83 ,P_SEGMENT28 in VARCHAR2
84 ,P_SEGMENT29 in VARCHAR2
85 ,P_SEGMENT30 in VARCHAR2
86 ,P_CONCAT_SEGMENTS in VARCHAR2
87 ,P_OBJECT_VERSION_NUMBER in NUMBER
88 ,P_NAME in VARCHAR2
89 ,P_JOB_DEFINITION_ID in NUMBER
90 ,P_EFFECTIVE_DATE in DATE
91 )is
92 l_commit_unit_number number;
93 l_legislation_code   varchar2(30);
94 begin
95 hr_utility.set_location('Entering: HR_JOB_API_BK2.UPDATE_JOB_A', 10);
96 l_commit_unit_number := hr_api.return_commit_unit;
97 if hr_api.call_app_hooks then
98 hr_job_api_be2.UPDATE_JOB_A
99 (P_JOB_ID => P_JOB_ID
100 ,P_DATE_FROM => P_DATE_FROM
101 ,P_COMMENTS => P_COMMENTS
102 ,P_DATE_TO => P_DATE_TO
103 ,P_APPROVAL_AUTHORITY => P_APPROVAL_AUTHORITY
104 ,P_BENCHMARK_JOB_FLAG => P_BENCHMARK_JOB_FLAG
105 ,P_BENCHMARK_JOB_ID => P_BENCHMARK_JOB_ID
106 ,P_EMP_RIGHTS_FLAG => P_EMP_RIGHTS_FLAG
107 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
108 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
109 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
110 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
111 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
112 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
113 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
114 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
115 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
116 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
117 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
118 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
119 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
120 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
121 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
122 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
123 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
124 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
125 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
126 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
127 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
128 ,P_JOB_INFORMATION_CATEGORY => P_JOB_INFORMATION_CATEGORY
129 ,P_JOB_INFORMATION1 => P_JOB_INFORMATION1
130 ,P_JOB_INFORMATION2 => P_JOB_INFORMATION2
131 ,P_JOB_INFORMATION3 => P_JOB_INFORMATION3
132 ,P_JOB_INFORMATION4 => P_JOB_INFORMATION4
133 ,P_JOB_INFORMATION5 => P_JOB_INFORMATION5
134 ,P_JOB_INFORMATION6 => P_JOB_INFORMATION6
135 ,P_JOB_INFORMATION7 => P_JOB_INFORMATION7
136 ,P_JOB_INFORMATION8 => P_JOB_INFORMATION8
137 ,P_JOB_INFORMATION9 => P_JOB_INFORMATION9
138 ,P_JOB_INFORMATION10 => P_JOB_INFORMATION10
139 ,P_JOB_INFORMATION11 => P_JOB_INFORMATION11
140 ,P_JOB_INFORMATION12 => P_JOB_INFORMATION12
141 ,P_JOB_INFORMATION13 => P_JOB_INFORMATION13
142 ,P_JOB_INFORMATION14 => P_JOB_INFORMATION14
143 ,P_JOB_INFORMATION15 => P_JOB_INFORMATION15
144 ,P_JOB_INFORMATION16 => P_JOB_INFORMATION16
145 ,P_JOB_INFORMATION17 => P_JOB_INFORMATION17
146 ,P_JOB_INFORMATION18 => P_JOB_INFORMATION18
147 ,P_JOB_INFORMATION19 => P_JOB_INFORMATION19
148 ,P_JOB_INFORMATION20 => P_JOB_INFORMATION20
149 ,P_SEGMENT1 => P_SEGMENT1
150 ,P_SEGMENT2 => P_SEGMENT2
151 ,P_SEGMENT3 => P_SEGMENT3
152 ,P_SEGMENT4 => P_SEGMENT4
153 ,P_SEGMENT5 => P_SEGMENT5
154 ,P_SEGMENT6 => P_SEGMENT6
155 ,P_SEGMENT7 => P_SEGMENT7
156 ,P_SEGMENT8 => P_SEGMENT8
157 ,P_SEGMENT9 => P_SEGMENT9
158 ,P_SEGMENT10 => P_SEGMENT10
159 ,P_SEGMENT11 => P_SEGMENT11
160 ,P_SEGMENT12 => P_SEGMENT12
161 ,P_SEGMENT13 => P_SEGMENT13
162 ,P_SEGMENT14 => P_SEGMENT14
163 ,P_SEGMENT15 => P_SEGMENT15
164 ,P_SEGMENT16 => P_SEGMENT16
165 ,P_SEGMENT17 => P_SEGMENT17
166 ,P_SEGMENT18 => P_SEGMENT18
167 ,P_SEGMENT19 => P_SEGMENT19
168 ,P_SEGMENT20 => P_SEGMENT20
169 ,P_SEGMENT21 => P_SEGMENT21
170 ,P_SEGMENT22 => P_SEGMENT22
171 ,P_SEGMENT23 => P_SEGMENT23
172 ,P_SEGMENT24 => P_SEGMENT24
173 ,P_SEGMENT25 => P_SEGMENT25
174 ,P_SEGMENT26 => P_SEGMENT26
175 ,P_SEGMENT27 => P_SEGMENT27
176 ,P_SEGMENT28 => P_SEGMENT28
177 ,P_SEGMENT29 => P_SEGMENT29
178 ,P_SEGMENT30 => P_SEGMENT30
179 ,P_CONCAT_SEGMENTS => P_CONCAT_SEGMENTS
180 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
181 ,P_NAME => P_NAME
182 ,P_JOB_DEFINITION_ID => P_JOB_DEFINITION_ID
183 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
184 );
185 end if;
186 hr_multi_message.end_validation_set;
187 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_JOB', 'AP');
188 hr_utility.set_location(' Leaving: HR_JOB_API_BK2.UPDATE_JOB_A', 20);
189 end UPDATE_JOB_A;
190 procedure UPDATE_JOB_B
191 (P_JOB_ID in NUMBER
192 ,P_DATE_FROM in DATE
193 ,P_COMMENTS in VARCHAR2
194 ,P_DATE_TO in DATE
195 ,P_APPROVAL_AUTHORITY in NUMBER
196 ,P_BENCHMARK_JOB_FLAG in VARCHAR2
197 ,P_BENCHMARK_JOB_ID in NUMBER
198 ,P_EMP_RIGHTS_FLAG in VARCHAR2
199 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
200 ,P_ATTRIBUTE1 in VARCHAR2
201 ,P_ATTRIBUTE2 in VARCHAR2
202 ,P_ATTRIBUTE3 in VARCHAR2
203 ,P_ATTRIBUTE4 in VARCHAR2
204 ,P_ATTRIBUTE5 in VARCHAR2
205 ,P_ATTRIBUTE6 in VARCHAR2
206 ,P_ATTRIBUTE7 in VARCHAR2
207 ,P_ATTRIBUTE8 in VARCHAR2
208 ,P_ATTRIBUTE9 in VARCHAR2
209 ,P_ATTRIBUTE10 in VARCHAR2
210 ,P_ATTRIBUTE11 in VARCHAR2
211 ,P_ATTRIBUTE12 in VARCHAR2
212 ,P_ATTRIBUTE13 in VARCHAR2
213 ,P_ATTRIBUTE14 in VARCHAR2
214 ,P_ATTRIBUTE15 in VARCHAR2
215 ,P_ATTRIBUTE16 in VARCHAR2
216 ,P_ATTRIBUTE17 in VARCHAR2
217 ,P_ATTRIBUTE18 in VARCHAR2
218 ,P_ATTRIBUTE19 in VARCHAR2
219 ,P_ATTRIBUTE20 in VARCHAR2
220 ,P_JOB_INFORMATION_CATEGORY in VARCHAR2
221 ,P_JOB_INFORMATION1 in VARCHAR2
222 ,P_JOB_INFORMATION2 in VARCHAR2
223 ,P_JOB_INFORMATION3 in VARCHAR2
224 ,P_JOB_INFORMATION4 in VARCHAR2
225 ,P_JOB_INFORMATION5 in VARCHAR2
226 ,P_JOB_INFORMATION6 in VARCHAR2
227 ,P_JOB_INFORMATION7 in VARCHAR2
228 ,P_JOB_INFORMATION8 in VARCHAR2
229 ,P_JOB_INFORMATION9 in VARCHAR2
230 ,P_JOB_INFORMATION10 in VARCHAR2
231 ,P_JOB_INFORMATION11 in VARCHAR2
232 ,P_JOB_INFORMATION12 in VARCHAR2
233 ,P_JOB_INFORMATION13 in VARCHAR2
234 ,P_JOB_INFORMATION14 in VARCHAR2
235 ,P_JOB_INFORMATION15 in VARCHAR2
236 ,P_JOB_INFORMATION16 in VARCHAR2
237 ,P_JOB_INFORMATION17 in VARCHAR2
238 ,P_JOB_INFORMATION18 in VARCHAR2
239 ,P_JOB_INFORMATION19 in VARCHAR2
240 ,P_JOB_INFORMATION20 in VARCHAR2
241 ,P_SEGMENT1 in VARCHAR2
242 ,P_SEGMENT2 in VARCHAR2
243 ,P_SEGMENT3 in VARCHAR2
244 ,P_SEGMENT4 in VARCHAR2
245 ,P_SEGMENT5 in VARCHAR2
246 ,P_SEGMENT6 in VARCHAR2
247 ,P_SEGMENT7 in VARCHAR2
248 ,P_SEGMENT8 in VARCHAR2
249 ,P_SEGMENT9 in VARCHAR2
250 ,P_SEGMENT10 in VARCHAR2
251 ,P_SEGMENT11 in VARCHAR2
252 ,P_SEGMENT12 in VARCHAR2
253 ,P_SEGMENT13 in VARCHAR2
254 ,P_SEGMENT14 in VARCHAR2
255 ,P_SEGMENT15 in VARCHAR2
256 ,P_SEGMENT16 in VARCHAR2
257 ,P_SEGMENT17 in VARCHAR2
258 ,P_SEGMENT18 in VARCHAR2
259 ,P_SEGMENT19 in VARCHAR2
260 ,P_SEGMENT20 in VARCHAR2
261 ,P_SEGMENT21 in VARCHAR2
262 ,P_SEGMENT22 in VARCHAR2
263 ,P_SEGMENT23 in VARCHAR2
264 ,P_SEGMENT24 in VARCHAR2
265 ,P_SEGMENT25 in VARCHAR2
266 ,P_SEGMENT26 in VARCHAR2
267 ,P_SEGMENT27 in VARCHAR2
268 ,P_SEGMENT28 in VARCHAR2
269 ,P_SEGMENT29 in VARCHAR2
270 ,P_SEGMENT30 in VARCHAR2
271 ,P_CONCAT_SEGMENTS in VARCHAR2
272 ,P_NAME in VARCHAR2
273 ,P_OBJECT_VERSION_NUMBER in NUMBER
274 ,P_JOB_DEFINITION_ID in NUMBER
275 ,P_EFFECTIVE_DATE in DATE
276 )is
277 begin
278 hr_utility.set_location('Entering: HR_JOB_API_BK2.UPDATE_JOB_B', 10);
279 hr_utility.set_location(' Leaving: HR_JOB_API_BK2.UPDATE_JOB_B', 20);
280 end UPDATE_JOB_B;
281 end HR_JOB_API_BK2;