DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_JOB_BK1

Source


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