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.PER_VACANCY_BE2

Source


1 package body per_vacancy_be2 as 
2 --Code generated on 27/11/2012 03:58:44
3 /* $Header: hrapiwfe.pkb 120.11 2011/12/24 13:28:35 vboggava ship $*/
4 procedure update_vacancy_a (
5 p_effective_date               date,
6 p_vacancy_id                   number,
7 p_object_version_number        number,
8 p_date_from                    date,
9 p_position_id                  number,
10 p_job_id                       number,
11 p_grade_id                     number,
12 p_organization_id              number,
13 p_people_group_id              number,
14 p_location_id                  number,
15 p_recruiter_id                 number,
16 p_date_to                      date,
17 p_security_method              varchar2,
18 p_description                  varchar2,
19 p_number_of_openings           number,
20 p_status                       varchar2,
21 p_budget_measurement_type      varchar2,
22 p_budget_measurement_value     number,
23 p_vacancy_category             varchar2,
24 p_manager_id                   number,
25 p_primary_posting_id           number,
26 p_assessment_id                number,
27 p_attribute_category           varchar2,
28 p_attribute1                   varchar2,
29 p_attribute2                   varchar2,
30 p_attribute3                   varchar2,
31 p_attribute4                   varchar2,
32 p_attribute5                   varchar2,
33 p_attribute6                   varchar2,
34 p_attribute7                   varchar2,
35 p_attribute8                   varchar2,
36 p_attribute9                   varchar2,
37 p_attribute10                  varchar2,
38 p_attribute11                  varchar2,
39 p_attribute12                  varchar2,
40 p_attribute13                  varchar2,
41 p_attribute14                  varchar2,
42 p_attribute15                  varchar2,
43 p_attribute16                  varchar2,
44 p_attribute17                  varchar2,
45 p_attribute18                  varchar2,
46 p_attribute19                  varchar2,
47 p_attribute20                  varchar2,
48 p_attribute21                  varchar2,
49 p_attribute22                  varchar2,
50 p_attribute23                  varchar2,
51 p_attribute24                  varchar2,
52 p_attribute25                  varchar2,
53 p_attribute26                  varchar2,
54 p_attribute27                  varchar2,
55 p_attribute28                  varchar2,
56 p_attribute29                  varchar2,
57 p_attribute30                  varchar2,
58 p_vacancy_region_type          varchar2,
59 p_assignment_changed           boolean,
60 p_inv_pos_grade_warning        boolean,
61 p_inv_job_grade_warning        boolean) is
62   l_event_key number;
63   l_event_data clob;
64   l_event_name varchar2(250);
65   l_text varchar2(2000);
66   l_message varchar2(10);
67   --
68   cursor get_seq is
69   select per_wf_events_s.nextval from dual;
70   --
71   l_proc varchar2(72):='  per_vacancy_be2.update_vacancy_a';
72 begin
73   hr_utility.set_location('Entering: '||l_proc,10);
74   -- check the status of the business event
75   l_event_name:='oracle.apps.per.api.vacancy.update_vacancy';
76   l_message:=wf_event.test(l_event_name);
77   --
78   if (l_message='MESSAGE') then
79     hr_utility.set_location(l_proc,20);
80     --
81     -- get a key for the event
82     --
83     open get_seq;
84     fetch get_seq into l_event_key;
85     close get_seq;
86     --
87     -- build the xml data for the event
88     --
89     dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
90     l_text:='<?xml version =''1.0'' encoding =''ASCII''?>';
91     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92     l_text:='<vacancy>';
93     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
94     --
95     l_text:='<effective_date>';
96     l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
97     l_text:=l_text||'</effective_date>';
98     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99     l_text:='<vacancy_id>';
100     l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
101     l_text:=l_text||'</vacancy_id>';
102     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103     l_text:='<object_version_number>';
104     l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
105     l_text:=l_text||'</object_version_number>';
106     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
107     l_text:='<date_from>';
108     l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
109     l_text:=l_text||'</date_from>';
110     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111     l_text:='<position_id>';
112     l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
113     l_text:=l_text||'</position_id>';
114     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
115     l_text:='<job_id>';
116     l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
117     l_text:=l_text||'</job_id>';
118     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
119     l_text:='<grade_id>';
120     l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
121     l_text:=l_text||'</grade_id>';
122     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123     l_text:='<organization_id>';
124     l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
125     l_text:=l_text||'</organization_id>';
126     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
127     l_text:='<people_group_id>';
128     l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
129     l_text:=l_text||'</people_group_id>';
130     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
131     l_text:='<location_id>';
132     l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
133     l_text:=l_text||'</location_id>';
134     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135     l_text:='<recruiter_id>';
136     l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
137     l_text:=l_text||'</recruiter_id>';
138     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
139     l_text:='<date_to>';
140     l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
141     l_text:=l_text||'</date_to>';
142     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143     l_text:='<security_method>';
144     l_text:=l_text||irc_utilities_pkg.removeTags(p_security_method);
145     l_text:=l_text||'</security_method>';
146     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
147     l_text:='<description>';
148     l_text:=l_text||irc_utilities_pkg.removeTags(p_description);
149     l_text:=l_text||'</description>';
150     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151     l_text:='<number_of_openings>';
152     l_text:=l_text||fnd_number.number_to_canonical(p_number_of_openings);
153     l_text:=l_text||'</number_of_openings>';
154     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
155     l_text:='<status>';
156     l_text:=l_text||irc_utilities_pkg.removeTags(p_status);
157     l_text:=l_text||'</status>';
158     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159     l_text:='<budget_measurement_type>';
160     l_text:=l_text||irc_utilities_pkg.removeTags(p_budget_measurement_type);
161     l_text:=l_text||'</budget_measurement_type>';
162     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
163     l_text:='<budget_measurement_value>';
164     l_text:=l_text||fnd_number.number_to_canonical(p_budget_measurement_value);
165     l_text:=l_text||'</budget_measurement_value>';
166     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
167     l_text:='<vacancy_category>';
168     l_text:=l_text||irc_utilities_pkg.removeTags(p_vacancy_category);
169     l_text:=l_text||'</vacancy_category>';
170     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
171     l_text:='<manager_id>';
172     l_text:=l_text||fnd_number.number_to_canonical(p_manager_id);
173     l_text:=l_text||'</manager_id>';
174     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175     l_text:='<primary_posting_id>';
176     l_text:=l_text||fnd_number.number_to_canonical(p_primary_posting_id);
177     l_text:=l_text||'</primary_posting_id>';
178     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
179     l_text:='<assessment_id>';
180     l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);
181     l_text:=l_text||'</assessment_id>';
182     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
183     l_text:='<attribute_category>';
184     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
185     l_text:=l_text||'</attribute_category>';
186     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
187     l_text:='<attribute1>';
188     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute1);
189     l_text:=l_text||'</attribute1>';
190     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
191     l_text:='<attribute2>';
192     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute2);
193     l_text:=l_text||'</attribute2>';
194     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
195     l_text:='<attribute3>';
196     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);
197     l_text:=l_text||'</attribute3>';
198     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
199     l_text:='<attribute4>';
200     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);
201     l_text:=l_text||'</attribute4>';
202     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
203     l_text:='<attribute5>';
204     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);
205     l_text:=l_text||'</attribute5>';
206     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
207     l_text:='<attribute6>';
208     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);
209     l_text:=l_text||'</attribute6>';
210     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
211     l_text:='<attribute7>';
212     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute7);
213     l_text:=l_text||'</attribute7>';
214     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
215     l_text:='<attribute8>';
216     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute8);
217     l_text:=l_text||'</attribute8>';
218     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
219     l_text:='<attribute9>';
220     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute9);
221     l_text:=l_text||'</attribute9>';
222     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
223     l_text:='<attribute10>';
224     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute10);
225     l_text:=l_text||'</attribute10>';
226     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
227     l_text:='<attribute11>';
228     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute11);
229     l_text:=l_text||'</attribute11>';
230     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
231     l_text:='<attribute12>';
232     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);
233     l_text:=l_text||'</attribute12>';
234     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
235     l_text:='<attribute13>';
236     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);
237     l_text:=l_text||'</attribute13>';
238     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239     l_text:='<attribute14>';
240     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);
241     l_text:=l_text||'</attribute14>';
242     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
243     l_text:='<attribute15>';
244     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);
245     l_text:=l_text||'</attribute15>';
246     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247     l_text:='<attribute16>';
248     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);
249     l_text:=l_text||'</attribute16>';
250     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
251     l_text:='<attribute17>';
252     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute17);
253     l_text:=l_text||'</attribute17>';
254     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255     l_text:='<attribute18>';
256     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute18);
257     l_text:=l_text||'</attribute18>';
258     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259     l_text:='<attribute19>';
260     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute19);
261     l_text:=l_text||'</attribute19>';
262     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
263     l_text:='<attribute20>';
264     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
265     l_text:=l_text||'</attribute20>';
266     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
267     l_text:='<attribute21>';
268     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute21);
269     l_text:=l_text||'</attribute21>';
270     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
271     l_text:='<attribute22>';
272     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute22);
273     l_text:=l_text||'</attribute22>';
274     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
275     l_text:='<attribute23>';
276     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute23);
277     l_text:=l_text||'</attribute23>';
278     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279     l_text:='<attribute24>';
280     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute24);
281     l_text:=l_text||'</attribute24>';
282     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283     l_text:='<attribute25>';
284     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute25);
285     l_text:=l_text||'</attribute25>';
286     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
287     l_text:='<attribute26>';
288     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute26);
289     l_text:=l_text||'</attribute26>';
290     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
291     l_text:='<attribute27>';
292     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute27);
293     l_text:=l_text||'</attribute27>';
294     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
295     l_text:='<attribute28>';
296     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute28);
297     l_text:=l_text||'</attribute28>';
298     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
299     l_text:='<attribute29>';
300     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute29);
301     l_text:=l_text||'</attribute29>';
302     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
303     l_text:='<attribute30>';
304     l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute30);
305     l_text:=l_text||'</attribute30>';
306     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307     l_text:='<vacancy_region_type>';
308     l_text:=l_text||irc_utilities_pkg.removeTags(p_vacancy_region_type);
309     l_text:=l_text||'</vacancy_region_type>';
310     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
311     l_text:='<assignment_changed>';
312 if(P_ASSIGNMENT_CHANGED) then
313 l_text:=l_text||'TRUE';
314 else
315 l_text:=l_text||'FALSE';
316 end if;
317     l_text:=l_text||'</assignment_changed>';
318     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319     l_text:='<inv_pos_grade_warning>';
320 if(P_INV_POS_GRADE_WARNING) then
321 l_text:=l_text||'TRUE';
322 else
323 l_text:=l_text||'FALSE';
324 end if;
325     l_text:=l_text||'</inv_pos_grade_warning>';
326     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
327     l_text:='<inv_job_grade_warning>';
328 if(P_INV_JOB_GRADE_WARNING) then
329 l_text:=l_text||'TRUE';
330 else
331 l_text:=l_text||'FALSE';
332 end if;
333     l_text:=l_text||'</inv_job_grade_warning>';
334     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
335     l_text:='</vacancy>';
336     --
337     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
338     --
339     -- raise the event with the event data
340     wf_event.raise(p_event_name=>l_event_name
341                   ,p_event_key=>l_event_key
342                   ,p_event_data=>l_event_data);
343   elsif (l_message='KEY') then
344     hr_utility.set_location(l_proc,30);
345     -- get a key for the event
346     open get_seq;
347     fetch get_seq into l_event_key;
348     close get_seq;
349     -- this is a key event, so just raise the event
350     -- without the event data
351     wf_event.raise(p_event_name=>l_event_name
352                   ,p_event_key=>l_event_key);
353   elsif (l_message='NONE') then
354     hr_utility.set_location(l_proc,40);
355     -- no event is required, so do nothing
356     null;
357   end if;
358     hr_utility.set_location('Leaving: '||l_proc,50);
359 end update_vacancy_a;
360 end per_vacancy_be2;