[Home] [Help]
PACKAGE BODY: APPS.IRC_VACANCY_COMMIT
Source
1 PACKAGE BODY IRC_VACANCY_COMMIT AS
2 /* $Header: ircvaccm.pkb 120.3 2006/04/01 01:52:18 mmillmor noship $ */
3 --
4 -- private function for 9i and 10g compatability
5 --
6 function valueOf(N xmldom.DOMNode, pattern varchar2)
7 return varchar2 is
8 l_retval varchar2(32767);
9 begin
10 xslprocessor.valueOf(N,pattern,l_retval);
11 return l_retval;
12 end valueOf;
13
14 ----------------------------------------------------------
15 ----------------------------------------------------------
16 -- --
17 -- This function can be called to check if there are --
18 -- any errors in the stack. --
19 -- --
20 -- It returns: --
21 -- - TRUE if there are any errors in the stack. --
22 -- - FALSE otherwise. --
23 -- --
24 ----------------------------------------------------------
25 ----------------------------------------------------------
26 FUNCTION is_error_message return boolean IS
27 --
28 l_no_of_messages number := 0;
29 l_current_no number := 0;
30 l_message varchar2(2000);
31 l_message_type varchar2(1);
32 l_error_found boolean := false;
33 --
34 BEGIN
35 --
36 hr_utility.trace('Entering is_error_message');
37 --
38 l_no_of_messages := fnd_msg_pub.count_msg();
39 --
40 hr_utility.trace('Number of messages found :' || to_char(l_no_of_messages) || ':');
41 --
42 while(l_current_no < l_no_of_messages)
43 loop
44 if l_current_no = 0
45 then
46 l_message := fnd_msg_pub.get_detail(fnd_msg_pub.g_first);
47 else
48 l_message := fnd_msg_pub.get_detail(fnd_msg_pub.g_next);
49 end if;
50 --
51 fnd_message.set_encoded(l_message);
52 l_message_type := fnd_message.get_token('FND_MESSAGE_TYPE','Y');
53 --
54 if l_message_type = 'E'
55 then
56 --
57 hr_utility.trace('Error message found');
58 --
59 l_error_found := true;
60 exit;
61 end if;
62 --
63 l_current_no := l_current_no + 1;
64 end loop;
65 --
66 hr_utility.trace('Exiting is_error_message');
67 --
68 return l_error_found;
69 --
70 end is_error_message;
71 --
72 --
73 ----------------------------------------------------------
74 ----------------------------------------------------------
75 -- --
76 -- This Procedure can be called when an approver has --
77 -- rejected the transaction outright. --
78 -- --
79 -- It performs the following functions: --
80 -- - it updates the AME transaction as 'REJECTED'. --
81 -- - it removes the HR_WIP_TRANSACTION record --
82 -- --
83 ----------------------------------------------------------
84 ----------------------------------------------------------
85 --
86 procedure reject_transaction (itemtype in varchar2,
87 itemkey in varchar2,
88 actid in number,
89 funcmode in varchar2,
90 resultout out nocopy varchar2) is
91 --
92 BEGIN
93 --
94 hr_utility.trace('Entering reject_transaction');
95 --
96 -- Mark Approval as Rejected
97 --
98 -- mmillmor commented out the following to make this compile
99 -- with the new approvals code
100 -- IRC_APPROVALS.updateAsRejected
101 -- (itemtype, itemkey, actid, funcmode, resultout);
102 --
103 -- Remove hr_wip_transaction record
104 --
105 hr_wip_txns.delete_transaction(
106 p_item_type => itemtype
107 ,p_item_key => itemkey);
108 --
109 hr_utility.trace('Exiting reject_transaction');
110 --
111 ----------------------------------------------------------
112 END reject_transaction;
113 ----------------------------------------------------------
114 --
115 ----------------------------------------------------------
116 ----------------------------------------------------------
117 -- --
118 ----------------------------------------------------------
119 ----------------------------------------------------------
120 --
121 procedure commit_insert (itemtype in varchar2,
122 itemkey in varchar2,
123 actid in number,
124 funcmode in varchar2,
125 resultout out nocopy varchar2) is
126 --
127 transaction_number number;
128 transaction_id varchar2(30);
129 --
130 parser xmlparser.Parser;
131 xmldoc xmldom.DOMDocument;
132 xmlelt xmldom.DOMElement;
133 XMLParseError EXCEPTION;
134 xmlClob CLOB;
135 wellFormed BOOLEAN;
136 error VARCHAR2(4000);
137 errorFlag BOOLEAN;
138 nodeName varchar2(240);
139 --
140 commitNodes xmldom.DOMNodeList;
141 commitNode xmldom.DOMNode;
142 --
143 internal_date_change number;
144 external_date_change number;
145 dummyVarchar varchar2(20);
146 l_return_status varchar2(1);
147 --
148 internalStartDate date;
149 l_effective_date date;
150 --
151 PRAGMA EXCEPTION_INIT(XMLParseError, -20100);
152 --
153 BEGIN
154 --
155 hr_utility.trace('Entering commit_insert for :' || itemtype || '-' || itemkey || ':');
156 --
157 savepoint vacancy_commit;
158 --
159 errorFlag := false;
160 --
161 if (isSelfApprove(itemtype, itemkey)) then
162 --
163 hr_utility.trace('Exiting - Self Approve');
164 --
165 resultout := 'SELF';
166 return;
167 end if;
168 --
169 l_effective_date := to_date(
170 wf_engine.getItemAttrText
171 (itemtype => itemtype,
172 itemkey => itemkey,
173 aname => 'IRC_EFFECTIVE_DATE'), 'YYYY-MM-DD');
174 --
175 hr_utility.trace('Effective date is :' || to_char(l_effective_date) || ':');
176 --
177 select transaction_id
178 into transaction_number
179 from hr_wip_transactions
180 where item_key = itemkey
181 and item_type = itemtype;
182 --
183 transaction_id := to_char(transaction_number);
184 --
185 hr_utility.trace('Transaction Id is :' || transaction_id || ':');
186 --
187 select vo_cache
188 into xmlClob
189 from hr_wip_transactions
190 where transaction_id = transaction_number;
191 --
192 parser := xmlparser.newParser;
193 --
194 xmlparser.ParseCLOB(parser,xmlClob);
195 xmldoc := xmlparser.getDocument(parser);
196 --
197 l_return_status := 'S';
198 --
199 hr_utility.trace('Inserting PER_REQUISITIONS records');
200 --
201 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRequisitionsVORow');
202 --
203 for j in 1..xmldom.getLength(commitNodes) loop
204 commitNode:=xmldom.item(commitNodes,j-1);
205 commit_i_requisition(commitNode, l_return_status);
206 if (l_return_status <> 'S' and is_error_message) then
207 hr_utility.trace('ERROR Inserting PER_REQUISITIONS records');
208 errorFlag := true;
209 end if;
210 end loop;
211 --
212 hr_utility.trace('Inserting IRC_POSTING_CONTENTS records');
213 --
214 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcPostingContentsVlVORow');
215 --
216 for j in 1..xmldom.getLength(commitNodes) loop
217 commitNode:=xmldom.item(commitNodes,j-1);
218 commit_i_posting_content(commitNode, l_effective_date, l_return_status);
219 if (l_return_status <> 'S' and is_error_message) then
220 hr_utility.trace('ERROR Inserting IRC_POSTING_CONTENTS records');
221 errorFlag := true;
222 end if;
223 end loop;
224 --
225 hr_utility.trace('Inserting PER_ALL_VACANCIES records');
226 --
227 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditVacancyVORow');
228 --
229 for j in 1..xmldom.getLength(commitNodes) loop
230 commitNode:=xmldom.item(commitNodes,j-1);
231 commit_i_vacancy(commitNode, l_effective_date, l_return_status);
232 if (l_return_status <> 'S' and is_error_message) then
233 hr_utility.trace('ERROR Inserting PER_ALL_VACANCIES records');
234 errorFlag := true;
235 end if;
236 end loop;
237 --
238 hr_utility.trace('Inserting IRC_SEARCH_CRITERIA records');
239 --
240 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancySearchCriteriaVORow');
241 --
242 for j in 1..xmldom.getLength(commitNodes) loop
243 commitNode:=xmldom.item(commitNodes,j-1);
244 commit_i_search_criteria(commitNode, l_effective_date, l_return_status);
245 if (l_return_status <> 'S' and is_error_message) then
246 hr_utility.trace('ERROR Inserting IRC_SEARCH_CRITERIA records');
247 errorFlag := true;
248 end if;
249 end loop;
250 --
251 hr_utility.trace('Inserting IRC_VARIABLE_COMP_ELEMENTS records');
252 --
253 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVariableCompElementsVORow');
254 --
255 for j in 1..xmldom.getLength(commitNodes) loop
256 commitNode:=xmldom.item(commitNodes,j-1);
257 commit_i_variable_comp_element(commitNode, l_effective_date, l_return_status);
258 if (l_return_status <> 'S' and is_error_message) then
259 hr_utility.trace('ERROR Inserting IRC_VARIABLE_COMP_ELEMENTS records');
260 errorFlag := true;
261 end if;
262 end loop;
263 --
264 hr_utility.trace('Inserting PER_COMPETENCE_ELEMENTS records');
265 --
266 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancyCompetenceVORow');
267 --
268 for j in 1..xmldom.getLength(commitNodes) loop
269 commitNode:=xmldom.item(commitNodes,j-1);
270 commit_i_competence_element(commitNode, l_effective_date, l_return_status);
271 if (l_return_status <> 'S' and is_error_message) then
272 hr_utility.trace('ERROR Inserting PER_COMPETENCE_ELEMENTS records');
273 errorFlag := true;
274 end if;
275 end loop;
276 --
277 hr_utility.trace('Inserting IRC_REC_TEAM_MEMBERS records');
278 --
279 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcRecTeamDisplayVORow');
280 --
281 for j in 1..xmldom.getLength(commitNodes) loop
282 commitNode:=xmldom.item(commitNodes,j-1);
283 commit_i_rec_team_member(commitNode, l_return_status);
284 if (l_return_status <> 'S' and is_error_message) then
285 hr_utility.trace('ERROR Inserting IRC_REC_TEAM_MEMBERS records');
286 errorFlag := true;
287 end if;
288 end loop;
289 --
290 hr_utility.trace('Inserting IRC_AGENCY_VACANCY records');
291 --
292 commitNodes := xmldom.getElementsByTagName(xmldoc, 'AgencyVacanciesVORow');
293 --
294 for j in 1..xmldom.getLength(commitNodes) loop
295 commitNode:=xmldom.item(commitNodes,j-1);
296 commit_i_agency_vacancy(commitNode, l_return_status);
297 if (l_return_status <> 'S' and is_error_message) then
298 hr_utility.trace('ERROR Inserting IRC_AGENCY_VACANCY records');
299 errorFlag := true;
300 end if;
301 end loop;
302 --
303 hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITIES records');
304 --
305 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivitiesVORow');
306 --
307 get_date_changes (commitNodes, external_date_change, internal_date_change);
308 --
309 for j in 1..xmldom.getLength(commitNodes) loop
310 commitNode:=xmldom.item(commitNodes,j-1);
311 if (is_site_internal(valueOf(commitNode,'RecruitingSiteId')) = 'I') then
312 hr_utility.trace('Committing internal site');
313 commit_i_recruitment_activity(commitNode, internal_date_change, l_return_status);
314 else
315 hr_utility.trace('Committing external site');
316 commit_i_recruitment_activity(commitNode, external_date_change, l_return_status);
317 end if;
318 if (l_return_status <> 'S' and is_error_message) then
319 hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITIES records');
320 errorFlag := true;
321 end if;
322 end loop;
323 --
324 hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITY_FOR records');
325 --
326 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');
327 --
328 for j in 1..xmldom.getLength(commitNodes) loop
329 commitNode:=xmldom.item(commitNodes,j-1);
330 commit_i_rec_activity_for(commitNode, l_return_status);
331 if (l_return_status <> 'S' and is_error_message) then
332 hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITY_FOR records');
333 errorFlag := true;
334 end if;
335 end loop;
336 --
337 xmlparser.freeParser(parser);
338 wellFormed := TRUE;
339 --
340 if(errorFlag) then
341 --
342 hr_utility.trace('Error found');
343 --
344 error := get_error(itemtype, itemkey);
345 rollback to vacancy_commit;
346 set_up_error_message(itemtype, itemkey, error);
347 resultout := 'COMMITERROR';
348 --
349 else
350 --
351 hr_utility.trace('No error found');
352 --
353 -- Remove hr_wip_transaction record
354 --
355 hr_wip_txns.delete_transaction(
356 p_item_type => itemtype
357 ,p_item_key => itemkey);
358 --
359 resultout := 'OK';
360 end if;
361 --
362 hr_utility.trace('Exiting commit_insert');
363 --
364 EXCEPTION
365 --
366 WHEN XMLParseError THEN
367 --
368 hr_utility.trace('XMLParseError found');
369 --
370 xmlparser.freeParser(parser);
371 wellFormed := FALSE;
372 error := SQLERRM;
373 --
374 rollback to vacancy_commit;
375 set_up_error_message(itemtype, itemkey, error);
376 resultout := 'COMMITERROR';
377 --
378 WHEN others THEN
379 --
380 hr_utility.trace('other error found');
381 --
382 error := SQLERRM;
383 rollback to vacancy_commit;
384 set_up_error_message(itemtype, itemkey, error);
385 resultout := 'COMMITERROR';
386 --
387 ----------------------------------------------------------
388 END commit_insert;
389 ----------------------------------------------------------
390 --
391 ----------------------------------------------------------
392 ----------------------------------------------------------
393 -- --
394 ----------------------------------------------------------
395 ----------------------------------------------------------
396 --
397 procedure commit_update (itemtype in varchar2,
398 itemkey in varchar2,
399 actid in number,
400 funcmode in varchar2,
401 resultout out nocopy varchar2) is
402 --
403 transaction_number number;
404 transaction_id varchar2(30);
405 --
406 parser xmlparser.Parser;
407 xmldoc xmldom.DOMDocument;
408 xmlelt xmldom.DOMElement;
409 XMLParseError EXCEPTION;
410 xmlClob CLOB;
411 wellFormed BOOLEAN;
412 error VARCHAR2(240);
413 nodeName varchar2(240);
414 errorFlag BOOLEAN;
415 --
416 commitNodes xmldom.DOMNodeList;
417 commitNode xmldom.DOMNode;
418 --
419 dummyVarchar varchar2(20);
420 l_return_status varchar2(1);
421 l_effective_date date;
422 --
423 PRAGMA EXCEPTION_INIT(XMLParseError, -20100);
424 --
425 BEGIN
426 --
427 hr_utility.trace('Entering commit_update');
428 --
429 savepoint vacancy_commit;
430 errorFlag := false;
431 --
432 if (isSelfApprove(itemtype, itemkey)) then
433 --
434 hr_utility.trace('Exiting - Self Approve');
435 --
436 resultout := 'SELF';
437 return;
438 end if;
439 --
440 l_effective_date := to_date(
441 wf_engine.getItemAttrText
442 (itemtype => itemtype,
443 itemkey => itemkey,
444 aname => 'IRC_EFFECTIVE_DATE'), 'YYYY-MM-DD');
445 --
446 hr_utility.trace('Effective date is :' || to_char(l_effective_date) || ':');
447 --
448 select transaction_id
449 into transaction_number
450 from hr_wip_transactions
451 where item_key = itemkey
452 and item_type = itemtype;
453 --
454 transaction_id := to_char(transaction_number);
455 --
456 hr_utility.trace('Transaction Id is :' || transaction_id || ':');
457 --
458 select vo_cache
459 into xmlClob
460 from hr_wip_transactions
461 where transaction_id = transaction_number;
462 --
463 parser := xmlparser.newParser;
464 --
465 xmlparser.ParseCLOB(parser,xmlClob);
466 xmldoc := xmlparser.getDocument(parser);
467 --
468 l_return_status := 'S';
469 --
470 hr_utility.trace('Updating PER_REQUISITIONS records');
471 --
472 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRequisitionsVORow');
473 --
474 for j in 1..xmldom.getLength(commitNodes) loop
475 commitNode:=xmldom.item(commitNodes,j-1);
476 commit_u_requisition(commitNode, l_return_status);
477 if (l_return_status <> 'S' and is_error_message) then
478 hr_utility.trace('ERROR Updating PER_REQUISITIONS records');
479 errorFlag := true;
480 end if;
481 end loop;
482 --
483 hr_utility.trace('Updating IRC_POSTING_CONTENTS records');
484 --
485 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcPostingContentsVlVORow');
486 --
487 for j in 1..xmldom.getLength(commitNodes) loop
488 commitNode:=xmldom.item(commitNodes,j-1);
489 if(found_IrcPostingContent(commitNode)) then
490 commit_u_posting_content(commitNode, l_return_status);
491 else
492 commit_i_posting_content(commitNode, l_effective_date, l_return_status);
493 end if;
494 if (l_return_status <> 'S' and is_error_message) then
495 hr_utility.trace('ERROR Updating IRC_POSTING_CONTENTS records');
496 errorFlag := true;
497 end if;
498 end loop;
499 --
500 hr_utility.trace('Updating PER_ALL_VACANCIES records');
501 --
502 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditVacancyVORow');
503 --
504 for j in 1..xmldom.getLength(commitNodes) loop
505 commitNode:=xmldom.item(commitNodes,j-1);
506 commit_u_vacancy(commitNode, l_effective_date, l_return_status);
507 if (l_return_status <> 'S' and is_error_message) then
508 hr_utility.trace('ERROR Updating PER_ALL_VACANCIES records');
509 errorFlag := true;
510 end if;
511 end loop;
512 --
513 hr_utility.trace('Updating IRC_SEARCH_CRITERIA records');
514 --
515 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancySearchCriteriaVORow');
516 --
517 for j in 1..xmldom.getLength(commitNodes) loop
518 commitNode:=xmldom.item(commitNodes,j-1);
519 if (found_IrcSearchCriteria(commitNode)) then
520 commit_u_search_criteria(commitNode, l_effective_date, l_return_status);
521 else
522 commit_i_search_criteria(commitNode, l_effective_date, l_return_status);
523 end if;
524 if (l_return_status <> 'S' and is_error_message) then
525 hr_utility.trace('ERROR Updating IRC_SEARCH_CRITERIA records');
526 errorFlag := true;
527 end if;
528 end loop;
529 --
530 hr_utility.trace('Updating IRC_VARIABLE_COMP_ELEMENTS records');
531 --
532 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVariableCompElementsVORow');
533 --
534 for j in 1..xmldom.getLength(commitNodes) loop
535 commitNode:=xmldom.item(commitNodes,j-1);
536 if (valueOf(commitNode,'@bc4j-action') = 'remove') then
537 commit_d_variable_comp_element(commitNode, l_return_status);
538 else
539 if (not found_IrcVariableCompElements(commitNode)) then
540 commit_i_variable_comp_element(commitNode, l_effective_date, l_return_status);
541 end if;
542 end if;
543 if (l_return_status <> 'S' and is_error_message) then
544 hr_utility.trace('ERROR Updating IRC_VARIABLE_COMP_ELEMENTS records');
545 errorFlag := true;
546 end if;
547 end loop;
548 --
549 hr_utility.trace('Updating PER_COMPETENCE_ELEMENTS records');
550 --
551 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancyCompetenceVORow');
552 --
553 for j in 1..xmldom.getLength(commitNodes) loop
554 commitNode:=xmldom.item(commitNodes,j-1);
555 if (valueOf(commitNode,'@bc4j-action') = 'remove') then
556 commit_d_competence_element(commitNode, l_return_status);
557 else
558 if (found_IrcVacancyCompetence(commitNode)) then
559 commit_u_competence_element(commitNode, l_effective_date, l_return_status);
560 else
561 commit_i_competence_element(commitNode, l_effective_date, l_return_status);
562 end if;
563 end if;
564 if (l_return_status <> 'S' and is_error_message) then
565 hr_utility.trace('ERROR Updating PER_COMPETENCE_ELEMENTS records');
566 errorFlag := true;
567 end if;
568 end loop;
569 --
570 hr_utility.trace('Updating IRC_REC_TEAM_MEMBERS records');
571 --
572 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcRecTeamDisplayVORow');
573 --
574 for j in 1..xmldom.getLength(commitNodes) loop
575 commitNode:=xmldom.item(commitNodes,j-1);
576 if (valueOf(commitNode,'@bc4j-action') = 'remove') then
577 commit_d_rec_team_member(commitNode, l_return_status);
578 else
579 if (found_IrcRecTeamDisplay(commitNode)) then
580 commit_u_rec_team_member(commitNode, l_return_status);
581 else
582 commit_i_rec_team_member(commitNode, l_return_status);
583 end if;
584 end if;
585 if (l_return_status <> 'S' and is_error_message) then
586 hr_utility.trace('ERROR Updating IRC_REC_TEAM_MEMBERS records');
587 errorFlag := true;
588 end if;
589 end loop;
590 --
591 hr_utility.trace('Updating IRC_AGENCY_VACANCY records');
592 --
593 commitNodes := xmldom.getElementsByTagName(xmldoc, 'AgencyVacanciesVORow');
594 --
595 for j in 1..xmldom.getLength(commitNodes) loop
596 commitNode:=xmldom.item(commitNodes,j-1);
597 if (valueOf(commitNode,'@bc4j-action') = 'remove') then
598 commit_d_agency_vacancy(commitNode, l_return_status);
599 else
600 if (found_agency_vacancy(commitNode)) then
601 commit_u_agency_vacancy(commitNode, l_return_status);
602 else
603 commit_i_agency_vacancy(commitNode, l_return_status);
604 end if;
605 end if;
606 if (l_return_status <> 'S' and is_error_message) then
607 hr_utility.trace('ERROR Updating IRC_AGENCY_VACANCY records');
608 errorFlag := true;
609 end if;
610 end loop;
611 --
612 hr_utility.trace('Deleting PER_RECRUITMENT_ACTIVITY_FOR records');
613 --
614 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');
615 --
616 for j in 1..xmldom.getLength(commitNodes) loop
617 --
618 commitNode:=xmldom.item(commitNodes,j-1);
619 --
620 if (valueOf(commitNode,'@bc4j-action') = 'remove') then
621 commit_d_rec_activity_for(commitNode, l_return_status);
622 if (l_return_status <> 'S' and is_error_message) then
623 hr_utility.trace('ERROR Deleting PER_RECRUITMENT_ACTIVITY_FOR records');
624 errorFlag := true;
625 end if;
626 end if;
627 --
628 end loop;
629 --
630 hr_utility.trace('Updating PER_RECRUITMENT_ACTIVITIES records');
631 --
632 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivitiesVORow');
633 --
634 for j in 1..xmldom.getLength(commitNodes) loop
635 --
636 commitNode:=xmldom.item(commitNodes,j-1);
637 --
638 if (valueOf(commitNode,'@bc4j-action') = 'remove') then
639 commit_d_recruitment_activity(commitNode, l_return_status);
640 else
641 if (found_rec_activity(commitNode)) then
642 commit_u_recruitment_activity(commitNode, l_return_status);
643 else
644 commit_i_recruitment_activity(commitNode, 0, l_return_status);
645 end if;
646 end if;
647 --
648 if (l_return_status <> 'S' and is_error_message) then
649 hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITIES records');
650 errorFlag := true;
651 end if;
652 --
653 end loop;
654 --
655 hr_utility.trace('Updating PER_RECRUITMENT_ACTIVITY_FOR records');
656 --
657 commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');
658 --
659 for j in 1..xmldom.getLength(commitNodes) loop
660 --
661 commitNode:=xmldom.item(commitNodes,j-1);
662 --
663 if (nvl(valueOf(commitNode,'@bc4j-action'),' ') <> 'remove') then
664 if (not found_rec_activity_for(commitNode)) then
665 commit_i_rec_activity_for(commitNode, l_return_status);
666 end if;
667 end if;
668 --
669 if (l_return_status <> 'S' and is_error_message) then
670 hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITY_FOR records');
671 errorFlag := true;
672 end if;
673 end loop;
674 --
675 --
676 xmlparser.freeParser(parser);
677 wellFormed := TRUE;
678 --
679 if(errorFlag) then
680 --
681 hr_utility.trace('Error found');
682 --
683 error := get_error(itemtype, itemkey);
684 rollback to vacancy_commit;
685 set_up_error_message(itemtype, itemkey, error);
686 resultout := 'COMMITERROR';
687 --
688 else
689 --
690 hr_utility.trace('No error found');
691 --
692 -- Remove hr_wip_transaction record
693 --
694 hr_wip_txns.delete_transaction(
695 p_item_type => itemtype
696 ,p_item_key => itemkey);
697 resultout := 'OK';
698 --
699 end if;
700 --
701 hr_utility.trace('Exiting commit_update');
702 --
703 EXCEPTION
704 --
705 WHEN XMLParseError THEN
706 --
707 hr_utility.trace('XMLParseError found');
708 --
709 xmlparser.freeParser(parser);
710 wellFormed := FALSE;
711 error := SQLERRM;
712 rollback to vacancy_commit;
713 set_up_error_message(itemtype, itemkey, error);
714 resultout := 'COMMITERROR';
715 --
716 WHEN others then
717 --
718 hr_utility.trace('other error found');
719 --
720 error := SQLERRM;
721 rollback to vacancy_commit;
722 set_up_error_message(itemtype, itemkey, error);
723 resultout := 'COMMITERROR';
724 --
725 ----------------------------------------------------------
726 END commit_update;
727 ----------------------------------------------------------
728 --
729 ----------------------------------------------------------
730 ----------------------------------------------------------
731 -- --
732 ----------------------------------------------------------
733 ----------------------------------------------------------
734 PROCEDURE commit_i_requisition (commitNode in xmldom.DOMNode
735 ,p_return_status out nocopy varchar2
736 ) AS
737 --
738 l_return_status varchar2(1);
739 l_object_version_number number;
740 --
741 BEGIN
742 --
743 hr_utility.trace('Entering commit_i_requisition');
744 --
745 l_object_version_number := to_number(valueOf(commitNode,'ObjectVersionNumber'));
746 --
747 per_requisitions_swi.create_requisition (
748 P_BUSINESS_GROUP_ID => valueOf(commitNode,'BusinessGroupId')
749 ,P_DATE_FROM => date_value(valueOf(commitNode,'DateFrom'))
750 ,P_NAME => valueOf(commitNode,'Name')
751 ,P_PERSON_ID => valueOf(commitNode,'PersonId')
752 ,P_COMMENTS => valueOf(commitNode,'Comments')
753 ,P_DATE_TO => date_value(valueOf(commitNode,'DateTo'))
754 ,P_DESCRIPTION => valueOf(commitNode,'Description')
755 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
756 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
757 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
758 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
759 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
760 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
761 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
762 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
763 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
764 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
765 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
766 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
767 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
768 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
769 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
770 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
771 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
772 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
773 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
774 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
775 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
776 ,P_REQUISITION_ID => valueOf(commitNode,'RequisitionId')
777 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
778 ,P_RETURN_STATUS => l_return_status
779 ,P_VALIDATE => g_validate);
780 --
781 p_return_status := l_return_status;
782 --
783 hr_utility.trace('Exiting commit_i_requisition');
784 --
785 ----------------------------------------------------------
786 END commit_i_requisition;
787 ----------------------------------------------------------
788 --
789 ----------------------------------------------------------
790 ----------------------------------------------------------
791 -- --
792 ----------------------------------------------------------
793 ----------------------------------------------------------
794 PROCEDURE commit_d_requisition (commitNode in xmldom.DOMNode
795 ,p_return_status out nocopy varchar2
796 ) AS
797 --
798 l_return_status varchar2(1);
799 l_object_version_number number;
800 --
801 BEGIN
802 --
803 hr_utility.trace('Entering commit_d_requisition');
804 --
805 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
806 --
807 per_requisitions_swi.delete_requisition (
808 P_REQUISITION_ID => valueOf(commitNode,'RequisitionId')
809 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
810 ,P_RETURN_STATUS => l_return_status
811 ,P_VALIDATE => valueOf(commitNode,''));
812 --
813 p_return_status := l_return_status;
814 --
815 hr_utility.trace('Exiting commit_d_requisition');
816 --
817 ----------------------------------------------------------
818 END commit_d_requisition;
819 ----------------------------------------------------------
820 --
821 ----------------------------------------------------------
822 ----------------------------------------------------------
823 -- --
824 ----------------------------------------------------------
825 ----------------------------------------------------------
826 PROCEDURE commit_u_requisition (commitNode in xmldom.DOMNode
827 ,p_return_status out nocopy varchar2
828 ) AS
829 --
830 --
831 --
832 l_return_status varchar2(1);
833 l_object_version_number number;
834 --
835 BEGIN
836 --
837 hr_utility.trace('Entering commit_u_requisition');
838 --
839 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
840 --
841 per_requisitions_swi.update_requisition (
842 P_REQUISITION_ID => valueOf(commitNode,'RequisitionId')
843 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
844 ,P_DATE_FROM => date_value(valueOf(commitNode,'DateFrom'))
845 ,P_PERSON_ID => valueOf(commitNode,'PersonId')
846 ,P_COMMENTS => valueOf(commitNode,'Comments')
847 ,P_DATE_TO => date_value(valueOf(commitNode,'DateTo'))
848 ,P_DESCRIPTION => valueOf(commitNode,'Description')
849 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
850 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
851 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
852 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
853 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
854 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
855 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
856 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
857 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
858 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
859 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
860 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
861 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
862 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
863 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
864 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
865 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
866 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
867 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
868 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
869 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
870 ,P_RETURN_STATUS => l_return_status
871 ,P_VALIDATE => g_validate);
872 --
873 p_return_status := l_return_status;
874 --
875 hr_utility.trace('Exiting commit_u_requisition');
876 --
877 ----------------------------------------------------------
878 END commit_u_requisition;
879 ----------------------------------------------------------
880 --
881 ----------------------------------------------------------
882 ----------------------------------------------------------
883 -- --
884 ----------------------------------------------------------
885 ----------------------------------------------------------
886 PROCEDURE commit_i_vacancy (commitNode in xmldom.DOMNode
887 ,l_effective_date in date
888 ,p_return_status out nocopy varchar2
889 ) AS
890 --
891 --
892 --
893 l_return_status varchar2(1);
894 l_object_version_number number;
895 --
896 BEGIN
897 --
898 hr_utility.trace('Entering commit_i_vacancy');
899 --
900 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
901 --
902 per_vacancy_swi.CREATE_VACANCY (
903 P_REQUISITION_ID => valueOf(commitNode,'RequisitionId')
904 ,P_DATE_FROM => date_value(valueOf(commitNode,'DateFrom'))
905 ,P_NAME => valueOf(commitNode,'Name')
906 ,P_SECURITY_METHOD => valueOf(commitNode,'SecurityMethod')
907 ,P_BUSINESS_GROUP_ID => valueOf(commitNode,'BusinessGroupId')
908 ,P_POSITION_ID => valueOf(commitNode,'PositionId')
909 ,P_JOB_ID => valueOf(commitNode,'JobId')
910 ,P_GRADE_ID => valueOf(commitNode,'GradeId')
911 ,P_ORGANIZATION_ID => valueOf(commitNode,'OrganizationId')
912 ,P_PEOPLE_GROUP_ID => valueOf(commitNode,'PeopleGroupId')
913 ,P_LOCATION_ID => valueOf(commitNode,'LocationId')
914 ,P_RECRUITER_ID => valueOf(commitNode,'RecruiterId')
915 ,P_DATE_TO => date_value(valueOf(commitNode,'DateTo'))
916 ,P_DESCRIPTION => valueOf(commitNode,'Description')
917 ,P_NUMBER_OF_OPENINGS => valueOf(commitNode,'NumberOfOpenings')
918 ,P_STATUS => 'APPROVED'
919 ,P_BUDGET_MEASUREMENT_TYPE => valueOf(commitNode,'BudgetMeasurementType')
920 ,P_BUDGET_MEASUREMENT_VALUE => valueOf(commitNode,'BudgetMeasurementValue')
921 ,P_VACANCY_CATEGORY => valueOf(commitNode,'VacancyCategory')
922 ,P_MANAGER_ID => valueOf(commitNode,'ManagerId')
923 ,P_PRIMARY_POSTING_ID => valueOf(commitNode,'PrimaryPostingId')
924 ,P_ASSESSMENT_ID => valueOf(commitNode,'AssessmentId')
925 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
926 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
927 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
928 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
929 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
930 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
931 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
932 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
933 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
934 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
935 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
936 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
937 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
938 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
939 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
940 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
941 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
942 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
943 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
944 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
945 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
946 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
947 ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
948 ,P_RETURN_STATUS => l_return_status
949 ,P_VALIDATE => g_validate
950 ,P_EFFECTIVE_DATE => l_effective_date);
951 --
952 p_return_status := l_return_status;
953 --
954 hr_utility.trace('Exiting commit_i_vacancy');
955 --
956 ----------------------------------------------------------
957 END commit_i_vacancy;
958 ----------------------------------------------------------
959 --
960 ----------------------------------------------------------
961 ----------------------------------------------------------
962 -- --
963 ----------------------------------------------------------
964 ----------------------------------------------------------
965 PROCEDURE commit_u_vacancy (commitNode in xmldom.DOMNode
966 ,l_effective_date in date
967 ,p_return_status out nocopy varchar2
968 ) AS
969 --
970 l_inv_pos_grade_warning boolean;
971 l_inv_job_grade_warning boolean;
972 l_assignment_changed number;
973 l_return_status varchar2(1);
974 l_object_version_number number;
975 status varchar2(20);
976 --
977 BEGIN
978 --
979 hr_utility.trace('Entering commit_u_vacancy');
980 --
981 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
982 --
983 status := valueOf(commitNode,'StatusCode');
984 if (status = 'PENDING') then
985 status := 'APPROVED';
986 end if;
987 --
988 per_vacancy_swi.UPDATE_VACANCY (
989 P_VACANCY_ID => valueOf(commitNode,'VacancyId')
990 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
991 ,P_DATE_FROM => date_value(valueOf(commitNode,'DateFrom'))
992 ,P_POSITION_ID => valueOf(commitNode,'PositionId')
993 ,P_JOB_ID => valueOf(commitNode,'JobId')
994 ,P_GRADE_ID => valueOf(commitNode,'GradeId')
995 ,P_ORGANIZATION_ID => valueOf(commitNode,'OrganizationId')
996 ,P_PEOPLE_GROUP_ID => valueOf(commitNode,'PeopleGroupId')
997 ,P_LOCATION_ID => valueOf(commitNode,'LocationId')
998 ,P_RECRUITER_ID => valueOf(commitNode,'RecruiterId')
999 ,P_DATE_TO => date_value(valueOf(commitNode,'DateTo'))
1000 ,P_SECURITY_METHOD => valueOf(commitNode,'SecurityMethod')
1001 ,P_DESCRIPTION => valueOf(commitNode,'Description')
1002 ,P_NUMBER_OF_OPENINGS => valueOf(commitNode,'NumberOfOpenings')
1003 ,P_STATUS => status
1004 ,P_BUDGET_MEASUREMENT_TYPE => valueOf(commitNode,'BudgetMeasurementType')
1005 ,P_BUDGET_MEASUREMENT_VALUE => valueOf(commitNode,'BudgetMeasurementValue')
1006 ,P_VACANCY_CATEGORY => valueOf(commitNode,'VacancyCategory')
1007 ,P_MANAGER_ID => valueOf(commitNode,'ManagerId')
1008 ,P_PRIMARY_POSTING_ID => valueOf(commitNode,'PrimaryPostingId')
1009 ,P_ASSESSMENT_ID => valueOf(commitNode,'AssessmentId')
1010 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
1011 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
1012 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
1013 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
1014 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
1015 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
1016 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
1017 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
1018 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
1019 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
1020 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
1021 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
1022 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
1023 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
1024 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
1025 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
1026 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
1027 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
1028 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
1029 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
1030 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
1031 ,P_ASSIGNMENT_CHANGED => l_assignment_changed
1032 ,P_RETURN_STATUS => l_return_status
1033 ,P_VALIDATE => g_validate
1034 ,P_EFFECTIVE_DATE => l_effective_date);
1035 --
1036 p_return_status := l_return_status;
1037 --
1038 hr_utility.trace('Exiting commit_u_vacancy');
1039 --
1040 ----------------------------------------------------------
1041 END commit_u_vacancy;
1042 ----------------------------------------------------------
1043 --
1044 ----------------------------------------------------------
1045 ----------------------------------------------------------
1046 -- --
1047 ----------------------------------------------------------
1048 ----------------------------------------------------------
1049 PROCEDURE commit_i_search_criteria (commitNode in xmldom.DOMNode
1050 ,l_effective_date in date
1051 ,p_return_status out nocopy varchar2
1052 ) AS
1053 --
1054 --
1055 --
1056 l_return_status varchar2(1);
1057 l_object_version_number number;
1058 --
1059 BEGIN
1060 --
1061 hr_utility.trace('Entering commit_i_search_criteria');
1062 --
1063 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1064 --
1065 irc_search_criteria_swi.create_vacancy_criteria (
1066 P_VACANCY_ID => valueOf(commitNode,'ObjectId')
1067 ,P_EFFECTIVE_DATE => l_effective_date
1068 ,P_LOCATION => valueOf(commitNode,'Location')
1069 ,P_EMPLOYEE => valueOf(commitNode,'Employee')
1070 ,P_CONTRACTOR => valueOf(commitNode,'Contractor')
1071 ,P_EMPLOYMENT_CATEGORY => valueOf(commitNode,'EmploymentCategory')
1072 ,P_KEYWORDS => valueOf(commitNode,'Keywords')
1073 ,P_TRAVEL_PERCENTAGE => valueOf(commitNode,'TravelPercentage')
1074 ,P_MIN_SALARY => valueOf(commitNode,'MinSalary')
1075 ,P_MAX_SALARY => valueOf(commitNode,'MaxSalary')
1076 ,P_SALARY_CURRENCY => valueOf(commitNode,'SalaryCurrency')
1077 ,P_SALARY_PERIOD => valueOf(commitNode,'SalaryPeriod')
1078 ,P_PROFESSIONAL_AREA => valueOf(commitNode,'ProfessionalArea')
1079 ,P_WORK_AT_HOME => valueOf(commitNode,'WorkAtHome')
1080 ,P_MIN_QUAL_LEVEL => valueOf(commitNode,'MinQualLevel')
1081 ,P_MAX_QUAL_LEVEL => valueOf(commitNode,'MaxQualLevel')
1082 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
1083 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
1084 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
1085 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
1086 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
1087 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
1088 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
1089 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
1090 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
1091 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
1092 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
1093 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
1094 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
1095 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
1096 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
1097 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
1098 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
1099 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
1100 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
1101 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
1102 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
1103 ,P_ATTRIBUTE21 => valueOf(commitNode,'Attribute21')
1104 ,P_ATTRIBUTE22 => valueOf(commitNode,'Attribute22')
1105 ,P_ATTRIBUTE23 => valueOf(commitNode,'Attribute23')
1106 ,P_ATTRIBUTE24 => valueOf(commitNode,'Attribute24')
1107 ,P_ATTRIBUTE25 => valueOf(commitNode,'Attribute25')
1108 ,P_ATTRIBUTE26 => valueOf(commitNode,'Attribute26')
1109 ,P_ATTRIBUTE27 => valueOf(commitNode,'Attribute27')
1110 ,P_ATTRIBUTE28 => valueOf(commitNode,'Attribute28')
1111 ,P_ATTRIBUTE29 => valueOf(commitNode,'Attribute29')
1112 ,P_ATTRIBUTE30 => valueOf(commitNode,'Attribute30')
1113 ,P_ISC_INFORMATION_CATEGORY => valueOf(commitNode,'IscInformationCategory')
1114 ,P_ISC_INFORMATION1 => valueOf(commitNode,'IscInformation1')
1115 ,P_ISC_INFORMATION2 => valueOf(commitNode,'IscInformation2')
1116 ,P_ISC_INFORMATION3 => valueOf(commitNode,'IscInformation3')
1117 ,P_ISC_INFORMATION4 => valueOf(commitNode,'IscInformation4')
1118 ,P_ISC_INFORMATION5 => valueOf(commitNode,'IscInformation5')
1119 ,P_ISC_INFORMATION6 => valueOf(commitNode,'IscInformation6')
1120 ,P_ISC_INFORMATION7 => valueOf(commitNode,'IscInformation7')
1121 ,P_ISC_INFORMATION8 => valueOf(commitNode,'IscInformation8')
1122 ,P_ISC_INFORMATION9 => valueOf(commitNode,'IscInformation9')
1123 ,P_ISC_INFORMATION10 => valueOf(commitNode,'IscInformation10')
1124 ,P_ISC_INFORMATION11 => valueOf(commitNode,'IscInformation11')
1125 ,P_ISC_INFORMATION12 => valueOf(commitNode,'IscInformation12')
1126 ,P_ISC_INFORMATION13 => valueOf(commitNode,'IscInformation13')
1127 ,P_ISC_INFORMATION14 => valueOf(commitNode,'IscInformation14')
1128 ,P_ISC_INFORMATION15 => valueOf(commitNode,'IscInformation15')
1129 ,P_ISC_INFORMATION16 => valueOf(commitNode,'IscInformation16')
1130 ,P_ISC_INFORMATION17 => valueOf(commitNode,'IscInformation17')
1131 ,P_ISC_INFORMATION18 => valueOf(commitNode,'IscInformation18')
1132 ,P_ISC_INFORMATION19 => valueOf(commitNode,'IscInformation19')
1133 ,P_ISC_INFORMATION20 => valueOf(commitNode,'IscInformation20')
1134 ,P_ISC_INFORMATION21 => valueOf(commitNode,'IscInformation21')
1135 ,P_ISC_INFORMATION22 => valueOf(commitNode,'IscInformation22')
1136 ,P_ISC_INFORMATION23 => valueOf(commitNode,'IscInformation23')
1137 ,P_ISC_INFORMATION24 => valueOf(commitNode,'IscInformation24')
1138 ,P_ISC_INFORMATION25 => valueOf(commitNode,'IscInformation25')
1139 ,P_ISC_INFORMATION26 => valueOf(commitNode,'IscInformation26')
1140 ,P_ISC_INFORMATION27 => valueOf(commitNode,'IscInformation27')
1141 ,P_ISC_INFORMATION28 => valueOf(commitNode,'IscInformation28')
1142 ,P_ISC_INFORMATION29 => valueOf(commitNode,'IscInformation29')
1143 ,P_ISC_INFORMATION30 => valueOf(commitNode,'IscInformation30')
1144 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1145 ,P_RETURN_STATUS => l_return_status
1146 ,P_VALIDATE => g_validate
1147 ,P_SEARCH_CRITERIA_ID => valueOf(commitNode,'SearchCriteriaId')
1148 ,P_DESCRIPTION => valueOf(commitNode,'Description'));
1149 --
1150 p_return_status := l_return_status;
1151 --
1152 hr_utility.trace('Exiting commit_i_search_criteria');
1153 --
1154 ----------------------------------------------------------
1155 END commit_i_search_criteria;
1156 ----------------------------------------------------------
1157 --
1158 ----------------------------------------------------------
1159 ----------------------------------------------------------
1160 -- --
1161 ----------------------------------------------------------
1162 ----------------------------------------------------------
1163 PROCEDURE commit_d_search_criteria (commitNode in xmldom.DOMNode
1164 ,p_return_status out nocopy varchar2
1165 ) AS
1166 --
1167 --
1168 --
1169 l_return_status varchar2(1);
1170 l_object_version_number number;
1171 --
1172 BEGIN
1173 --
1174 hr_utility.trace('Entering commit_d_search_criteria');
1175 --
1176 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1177 --
1178 irc_search_criteria_swi.delete_vacancy_criteria (
1179 P_SEARCH_CRITERIA_ID => valueOf(commitNode,'SearchCriteriaId')
1180 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1181 ,P_RETURN_STATUS => l_return_status
1182 ,P_VALIDATE => g_validate);
1183 --
1184 p_return_status := l_return_status;
1185 --
1186 hr_utility.trace('Exiting commit_d_search_criteria');
1187 --
1188 ----------------------------------------------------------
1189 END commit_d_search_criteria;
1190 ----------------------------------------------------------
1191 --
1192 ----------------------------------------------------------
1193 ----------------------------------------------------------
1194 -- --
1195 ----------------------------------------------------------
1196 ----------------------------------------------------------
1197 PROCEDURE commit_u_search_criteria (commitNode in xmldom.DOMNode
1198 ,l_effective_date in date
1199 ,p_return_status out nocopy varchar2
1200 ) AS
1201 --
1202 --
1203 --
1204 l_return_status varchar2(1);
1205 l_object_version_number number;
1206 --
1207 BEGIN
1208 --
1209 hr_utility.trace('Entering commit_u_search_criteria');
1210 --
1211 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1212 --
1213 irc_search_criteria_swi.update_vacancy_criteria (
1214 P_VACANCY_ID => valueOf(commitNode,'ObjectId')
1215 ,P_EFFECTIVE_DATE => l_effective_date
1216 ,P_LOCATION => valueOf(commitNode,'Location')
1217 ,P_EMPLOYEE => valueOf(commitNode,'Employee')
1218 ,P_CONTRACTOR => valueOf(commitNode,'Contractor')
1219 ,P_EMPLOYMENT_CATEGORY => valueOf(commitNode,'EmploymentCategory')
1220 ,P_KEYWORDS => valueOf(commitNode,'Keywords')
1221 ,P_TRAVEL_PERCENTAGE => valueOf(commitNode,'TravelPercentage')
1222 ,P_MIN_SALARY => valueOf(commitNode,'MinSalary')
1223 ,P_MAX_SALARY => valueOf(commitNode,'MaxSalary')
1224 ,P_SALARY_CURRENCY => valueOf(commitNode,'SalaryCurrency')
1225 ,P_SALARY_PERIOD => valueOf(commitNode,'SalaryPeriod')
1226 ,P_PROFESSIONAL_AREA => valueOf(commitNode,'ProfessionalArea')
1227 ,P_WORK_AT_HOME => valueOf(commitNode,'WorkAtHome')
1228 ,P_MIN_QUAL_LEVEL => valueOf(commitNode,'MinQualLevel')
1229 ,P_MAX_QUAL_LEVEL => valueOf(commitNode,'MaxQualLevel')
1230 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
1231 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
1232 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
1233 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
1234 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
1235 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
1236 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
1237 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
1238 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
1239 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
1240 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
1241 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
1242 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
1243 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
1244 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
1245 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
1246 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
1247 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
1248 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
1249 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
1250 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
1251 ,P_ATTRIBUTE21 => valueOf(commitNode,'Attribute21')
1252 ,P_ATTRIBUTE22 => valueOf(commitNode,'Attribute22')
1253 ,P_ATTRIBUTE23 => valueOf(commitNode,'Attribute23')
1254 ,P_ATTRIBUTE24 => valueOf(commitNode,'Attribute24')
1255 ,P_ATTRIBUTE25 => valueOf(commitNode,'Attribute25')
1256 ,P_ATTRIBUTE26 => valueOf(commitNode,'Attribute26')
1257 ,P_ATTRIBUTE27 => valueOf(commitNode,'Attribute27')
1258 ,P_ATTRIBUTE28 => valueOf(commitNode,'Attribute28')
1259 ,P_ATTRIBUTE29 => valueOf(commitNode,'Attribute29')
1260 ,P_ATTRIBUTE30 => valueOf(commitNode,'Attribute30')
1261 ,P_ISC_INFORMATION_CATEGORY => valueOf(commitNode,'IscInformationCategory')
1262 ,P_ISC_INFORMATION1 => valueOf(commitNode,'IscInformation1')
1263 ,P_ISC_INFORMATION2 => valueOf(commitNode,'IscInformation2')
1264 ,P_ISC_INFORMATION3 => valueOf(commitNode,'IscInformation3')
1265 ,P_ISC_INFORMATION4 => valueOf(commitNode,'IscInformation4')
1266 ,P_ISC_INFORMATION5 => valueOf(commitNode,'IscInformation5')
1267 ,P_ISC_INFORMATION6 => valueOf(commitNode,'IscInformation6')
1268 ,P_ISC_INFORMATION7 => valueOf(commitNode,'IscInformation7')
1269 ,P_ISC_INFORMATION8 => valueOf(commitNode,'IscInformation8')
1270 ,P_ISC_INFORMATION9 => valueOf(commitNode,'IscInformation9')
1271 ,P_ISC_INFORMATION10 => valueOf(commitNode,'IscInformation10')
1272 ,P_ISC_INFORMATION11 => valueOf(commitNode,'IscInformation11')
1273 ,P_ISC_INFORMATION12 => valueOf(commitNode,'IscInformation12')
1274 ,P_ISC_INFORMATION13 => valueOf(commitNode,'IscInformation13')
1275 ,P_ISC_INFORMATION14 => valueOf(commitNode,'IscInformation14')
1276 ,P_ISC_INFORMATION15 => valueOf(commitNode,'IscInformation15')
1277 ,P_ISC_INFORMATION16 => valueOf(commitNode,'IscInformation16')
1278 ,P_ISC_INFORMATION17 => valueOf(commitNode,'IscInformation17')
1279 ,P_ISC_INFORMATION18 => valueOf(commitNode,'IscInformation18')
1280 ,P_ISC_INFORMATION19 => valueOf(commitNode,'IscInformation19')
1281 ,P_ISC_INFORMATION20 => valueOf(commitNode,'IscInformation20')
1282 ,P_ISC_INFORMATION21 => valueOf(commitNode,'IscInformation21')
1283 ,P_ISC_INFORMATION22 => valueOf(commitNode,'IscInformation22')
1284 ,P_ISC_INFORMATION23 => valueOf(commitNode,'IscInformation23')
1285 ,P_ISC_INFORMATION24 => valueOf(commitNode,'IscInformation24')
1286 ,P_ISC_INFORMATION25 => valueOf(commitNode,'IscInformation25')
1287 ,P_ISC_INFORMATION26 => valueOf(commitNode,'IscInformation26')
1288 ,P_ISC_INFORMATION27 => valueOf(commitNode,'IscInformation27')
1289 ,P_ISC_INFORMATION28 => valueOf(commitNode,'IscInformation28')
1290 ,P_ISC_INFORMATION29 => valueOf(commitNode,'IscInformation29')
1291 ,P_ISC_INFORMATION30 => valueOf(commitNode,'IscInformation30')
1292 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1293 ,P_RETURN_STATUS => l_return_status
1294 ,P_VALIDATE => g_validate
1295 ,P_SEARCH_CRITERIA_ID => valueOf(commitNode,'SearchCriteriaId')
1296 ,P_DESCRIPTION => valueOf(commitNode,'Description'));
1297 --
1298 p_return_status := l_return_status;
1299 --
1300 hr_utility.trace('Exiting commit_u_search_criteria');
1301 --
1302 ----------------------------------------------------------
1303 END commit_u_search_criteria;
1304 ----------------------------------------------------------
1305 --
1306 ----------------------------------------------------------
1307 ----------------------------------------------------------
1308 -- --
1309 ----------------------------------------------------------
1310 ----------------------------------------------------------
1311 PROCEDURE commit_i_competence_element (commitNode in xmldom.DOMNode
1312 ,l_effective_date in date
1313 ,p_return_status out nocopy varchar2
1314 ) AS
1315 --
1316 --
1317 --
1318 l_return_status varchar2(1);
1319 l_object_version_number number;
1320 --
1321 BEGIN
1322 --
1323 hr_utility.trace('Entering commit_i_competence_element');
1324 --
1325 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1326 --
1327 hr_competence_element_swi.create_competence_element (
1328 P_COMPETENCE_ELEMENT_ID => valueOf(commitNode,'CompetenceElementId')
1329 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1330 ,P_TYPE => valueOf(commitNode,'Type')
1331 ,P_BUSINESS_GROUP_ID => valueOf(commitNode,'BusinessGroupId')
1332 ,P_ENTERPRISE_ID => valueOf(commitNode,'EnterpriseId')
1333 ,P_COMPETENCE_ID => valueOf(commitNode,'CompetenceId')
1334 ,P_PROFICIENCY_LEVEL_ID => valueOf(commitNode,'ProficiencyLevelId')
1335 ,P_HIGH_PROFICIENCY_LEVEL_ID => valueOf(commitNode,'HighProficiencyLevelId')
1336 ,P_WEIGHTING_LEVEL_ID => valueOf(commitNode,'WeightingLevelId')
1337 ,P_RATING_LEVEL_ID => valueOf(commitNode,'RatingLevelId')
1338 ,P_PERSON_ID => valueOf(commitNode,'PersonId')
1339 ,P_JOB_ID => valueOf(commitNode,'JobId')
1340 ,P_VALID_GRADE_ID => valueOf(commitNode,'ValidGradeId')
1341 ,P_POSITION_ID => valueOf(commitNode,'PositionId')
1342 ,P_ORGANIZATION_ID => valueOf(commitNode,'OrganizationId')
1343 ,P_PARENT_COMPETENCE_ELEMENT_ID => valueOf(commitNode,'ParentCompetenceElementId')
1344 ,P_ACTIVITY_VERSION_ID => valueOf(commitNode,'ActivityVersionId')
1345 ,P_ASSESSMENT_ID => valueOf(commitNode,'AssessmentId')
1346 ,P_ASSESSMENT_TYPE_ID => valueOf(commitNode,'AssessmentTypeId')
1347 ,P_MANDATORY => valueOf(commitNode,'Mandatory')
1348 ,P_EFFECTIVE_DATE_FROM => valueOf(commitNode,'EffectiveDateFrom')
1349 ,P_EFFECTIVE_DATE_TO => valueOf(commitNode,'EffectiveDateTo')
1350 ,P_GROUP_COMPETENCE_TYPE => valueOf(commitNode,'GroupCompetenceType')
1351 ,P_COMPETENCE_TYPE => valueOf(commitNode,'CompetenceType')
1352 ,P_NORMAL_ELAPSE_DURATION => valueOf(commitNode,'NormalElapseDuration')
1353 ,P_NORMAL_ELAPSE_DURATION_UNIT => valueOf(commitNode,'NormalElapseDurationUnit')
1354 ,P_SEQUENCE_NUMBER => valueOf(commitNode,'SequenceNumber')
1355 ,P_SOURCE_OF_PROFICIENCY_LEVEL => valueOf(commitNode,'SourceOfProficiencyLevel')
1356 ,P_LINE_SCORE => valueOf(commitNode,'LineScore')
1357 ,P_CERTIFICATION_DATE => date_value(valueOf(commitNode,'CertificationDate'))
1358 ,P_CERTIFICATION_METHOD => valueOf(commitNode,'CertificationMethod')
1359 ,P_NEXT_CERTIFICATION_DATE => valueOf(commitNode,'NextCertificationDate')
1360 ,P_COMMENTS => valueOf(commitNode,'Comments')
1361 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
1362 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
1363 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
1364 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
1365 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
1366 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
1367 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
1368 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
1369 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
1370 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
1371 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
1372 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
1373 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
1374 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
1375 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
1376 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
1377 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
1378 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
1379 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
1380 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
1381 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
1382 ,P_EFFECTIVE_DATE => l_effective_date
1383 ,P_OBJECT_ID => valueOf(commitNode,'ObjectId')
1384 ,P_OBJECT_NAME => valueOf(commitNode,'ObjectName')
1385 ,P_PARTY_ID => valueOf(commitNode,'PartyId')
1386 ,P_RETURN_STATUS => l_return_status
1387 ,P_VALIDATE => g_validate);
1388 --
1389 p_return_status := l_return_status;
1390 --
1391 hr_utility.trace('Exiting commit_i_competence_element');
1392 --
1393 ----------------------------------------------------------
1394 END commit_i_competence_element;
1395 ----------------------------------------------------------
1396 --
1397 ----------------------------------------------------------
1398 ----------------------------------------------------------
1399 -- --
1400 ----------------------------------------------------------
1401 ----------------------------------------------------------
1402 PROCEDURE commit_u_competence_element (commitNode in xmldom.DOMNode
1403 ,l_effective_date in date
1404 ,p_return_status out nocopy varchar2
1405 ) AS
1406 --
1407 l_return_status varchar2(1);
1408 l_object_version_number number;
1409 --
1410 BEGIN
1411 --
1412 hr_utility.trace('Entering commit_u_competence_element');
1413 --
1414 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1415 --
1416 hr_competence_element_swi.update_competence_element (
1417 P_COMPETENCE_ELEMENT_ID => valueOf(commitNode,'CompetenceElementId')
1418 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1419 ,P_PROFICIENCY_LEVEL_ID => valueOf(commitNode,'ProficiencyLevelId')
1420 ,P_HIGH_PROFICIENCY_LEVEL_ID => valueOf(commitNode,'HighProficiencyLevelId')
1421 ,P_WEIGHTING_LEVEL_ID => valueOf(commitNode,'WeightingLevelId')
1422 ,P_RATING_LEVEL_ID => valueOf(commitNode,'RatingLevelId')
1423 ,P_MANDATORY => valueOf(commitNode,'Mandatory')
1424 ,P_EFFECTIVE_DATE_FROM => date_value(valueOf(commitNode,'EffectiveDateFrom'))
1425 ,P_EFFECTIVE_DATE_TO => date_value(valueOf(commitNode,'EffectiveDateTo'))
1426 ,P_GROUP_COMPETENCE_TYPE => valueOf(commitNode,'GroupCompetenceType')
1427 ,P_COMPETENCE_TYPE => valueOf(commitNode,'CompetenceType')
1428 ,P_NORMAL_ELAPSE_DURATION => valueOf(commitNode,'NormalElapseDuration')
1429 ,P_NORMAL_ELAPSE_DURATION_UNIT => valueOf(commitNode,'NormalElapseDurationUnit')
1430 ,P_SEQUENCE_NUMBER => valueOf(commitNode,'SequenceNumber')
1431 ,P_SOURCE_OF_PROFICIENCY_LEVEL => valueOf(commitNode,'SourceOfProficiencyLevel')
1432 ,P_LINE_SCORE => valueOf(commitNode,'LineScore')
1433 ,P_CERTIFICATION_DATE => date_value(valueOf(commitNode,'CertificationDate'))
1434 ,P_CERTIFICATION_METHOD => valueOf(commitNode,'CertificationMethod')
1435 ,P_NEXT_CERTIFICATION_DATE => date_value(valueOf(commitNode,'NextCertificationDate'))
1436 ,P_COMMENTS => valueOf(commitNode,'Comments')
1437 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
1438 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
1439 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
1440 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
1441 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
1442 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
1443 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
1444 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
1445 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
1446 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
1447 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
1448 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
1449 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
1450 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
1451 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
1452 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
1453 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
1454 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
1455 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
1456 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
1457 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
1458 ,P_EFFECTIVE_DATE => l_effective_date
1459 ,P_PARTY_ID => valueOf(commitNode,'PartyId')
1460 ,P_RETURN_STATUS => l_return_status
1461 ,P_VALIDATE => g_validate
1462 ,P_COMPETENCE_ID => valueOf(commitNode,'CompetenceId'));
1463 --
1464 p_return_status := l_return_status;
1465 --
1466 hr_utility.trace('Exiting commit_u_competence_element');
1467 --
1468 ----------------------------------------------------------
1469 END commit_u_competence_element;
1470 ----------------------------------------------------------
1471 --
1472 ----------------------------------------------------------
1473 ----------------------------------------------------------
1474 -- --
1475 ----------------------------------------------------------
1476 ----------------------------------------------------------
1477 PROCEDURE commit_d_competence_element (commitNode in xmldom.DOMNode
1478 ,p_return_status out nocopy varchar2
1479 ) AS
1480 --
1481 l_return_status varchar2(1);
1482 l_object_version_number number;
1483 --
1484 BEGIN
1485 --
1486 hr_utility.trace('Entering commit_d_competence_element');
1487 --
1488 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1489 --
1490 hr_competence_element_swi.delete_competence_element (
1491 P_COMPETENCE_ELEMENT_ID => valueOf(commitNode,'CompetenceElementId')
1492 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1493 ,P_RETURN_STATUS => l_return_status
1494 ,P_VALIDATE => g_validate);
1495 --
1496 p_return_status := l_return_status;
1497 --
1498 hr_utility.trace('Exiting commit_d_competence_element');
1499 --
1500 ----------------------------------------------------------
1501 END commit_d_competence_element;
1502 ----------------------------------------------------------
1503 --
1504 ----------------------------------------------------------
1505 ----------------------------------------------------------
1506 -- --
1507 ----------------------------------------------------------
1508 ----------------------------------------------------------
1509 PROCEDURE commit_i_variable_comp_element (commitNode in xmldom.DOMNode
1510 ,l_effective_date in date
1511 ,p_return_status out nocopy varchar2
1512 ) AS
1513 --
1514 l_return_status varchar2(1);
1515 l_object_version_number number;
1516 --
1517 BEGIN
1518 --
1519 hr_utility.trace('Entering commit_i_variable_comp_element');
1520 --
1521 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1522 --
1523 irc_variable_comp_element_swi.create_variable_compensation (
1524 P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1525 ,P_VARIABLE_COMP_LOOKUP => valueOf(commitNode,'LookupCode')
1526 ,P_EFFECTIVE_DATE => l_effective_date
1527 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1528 ,P_RETURN_STATUS => l_return_status
1529 ,P_VALIDATE => g_validate);
1530 --
1531 p_return_status := l_return_status;
1532 --
1533 hr_utility.trace('Exiting commit_i_variable_comp_element');
1534 --
1535 ----------------------------------------------------------
1536 END commit_i_variable_comp_element;
1537 ----------------------------------------------------------
1538 --
1539 ----------------------------------------------------------
1540 ----------------------------------------------------------
1541 -- --
1542 ----------------------------------------------------------
1543 ----------------------------------------------------------
1544 PROCEDURE commit_d_variable_comp_element (commitNode in xmldom.DOMNode
1545 ,p_return_status out nocopy varchar2
1546 ) AS
1547 --
1548 l_return_status varchar2(1);
1549 l_object_version_number number;
1550 --
1551 BEGIN
1552 --
1553 hr_utility.trace('Entering commit_d_variable_comp_element');
1554 --
1555 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1556 --
1557 irc_variable_comp_element_swi.delete_variable_compensation (
1558 P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1559 ,P_VARIABLE_COMP_LOOKUP => valueOf(commitNode,'LookupCode')
1560 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1561 ,P_RETURN_STATUS => l_return_status
1562 ,P_VALIDATE => g_validate);
1563 --
1564 p_return_status := l_return_status;
1565 --
1566 hr_utility.trace('Exiting commit_d_variable_comp_element');
1567 --
1568 ----------------------------------------------------------
1569 END commit_d_variable_comp_element;
1570 ----------------------------------------------------------
1571 --
1572 ----------------------------------------------------------
1573 ----------------------------------------------------------
1574 -- --
1575 ----------------------------------------------------------
1576 ----------------------------------------------------------
1577 PROCEDURE commit_i_rec_team_member (commitNode in xmldom.DOMNode
1578 ,p_return_status out nocopy varchar2
1579 ) AS
1580 --
1581 l_object_version_number number;
1582 l_return_status varchar2(1);
1583 --
1584 BEGIN
1585 --
1586 hr_utility.trace('Entering commit_i_rec_team_member');
1587 --
1588 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1589 --
1590 irc_rec_team_members_swi.create_rec_team_member (
1591 P_REC_TEAM_MEMBER_ID => valueOf(commitNode,'RecTeamMemberId')
1592 ,P_PERSON_ID => valueOf(commitNode,'PersonId')
1593 ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1594 ,P_JOB_ID => valueOf(commitNode,'JobId')
1595 ,P_START_DATE => date_value(valueOf(commitNode,'StartDate'))
1596 ,P_END_DATE => date_value(valueOf(commitNode,'EndDate'))
1597 ,P_UPDATE_ALLOWED => valueOf(commitNode,'UpdateAllowed')
1598 ,P_DELETE_ALLOWED => valueOf(commitNode,'DeleteAllowed')
1599 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1600 ,P_RETURN_STATUS => l_return_status
1601 ,P_VALIDATE => g_validate);
1602 --
1603 p_return_status := l_return_status;
1604 --
1605 hr_utility.trace('Exiting commit_i_rec_team_member');
1606 --
1607 ----------------------------------------------------------
1608 END commit_i_rec_team_member;
1609 ----------------------------------------------------------
1610 --
1611 ----------------------------------------------------------
1612 ----------------------------------------------------------
1613 -- --
1614 ----------------------------------------------------------
1615 ----------------------------------------------------------
1616 PROCEDURE commit_d_rec_team_member (commitNode in xmldom.DOMNode
1617 ,p_return_status out nocopy varchar2
1618 ) AS
1619 --
1620 l_object_version_number number;
1621 l_return_status varchar2(1);
1622 --
1623 BEGIN
1624 --
1625 hr_utility.trace('Entering commit_d_rec_team_member');
1626 --
1627 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1628 --
1629 irc_rec_team_members_swi.delete_rec_team_member (
1630 P_REC_TEAM_MEMBER_ID => valueOf(commitNode,'RecTeamMemberId')
1631 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1632 ,P_RETURN_STATUS => l_return_status
1633 ,P_VALIDATE => g_validate);
1634 --
1635 p_return_status := l_return_status;
1636 --
1637 hr_utility.trace('Exiting commit_d_rec_team_member');
1638 --
1639 ----------------------------------------------------------
1640 END commit_d_rec_team_member;
1641 ----------------------------------------------------------
1642 --
1643 ----------------------------------------------------------
1644 ----------------------------------------------------------
1645 -- --
1646 ----------------------------------------------------------
1647 ----------------------------------------------------------
1648 PROCEDURE commit_u_rec_team_member (commitNode in xmldom.DOMNode
1649 ,p_return_status out nocopy varchar2
1650 ) AS
1651 --
1652 l_object_version_number number;
1653 l_return_status varchar2(1);
1654 --
1655 BEGIN
1656 --
1657 hr_utility.trace('Entering commit_u_rec_team_member');
1658 --
1659 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1660 --
1661 irc_rec_team_members_swi.update_rec_team_member (
1662 P_REC_TEAM_MEMBER_ID => valueOf(commitNode,'RecTeamMemberId')
1663 ,P_PERSON_ID => valueOf(commitNode,'PersonId')
1664 ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1665 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1666 ,P_JOB_ID => valueOf(commitNode,'JobId')
1667 ,P_START_DATE => date_value(valueOf(commitNode,'StartDate'))
1668 ,P_END_DATE => date_value(valueOf(commitNode,'EndDate'))
1669 ,P_UPDATE_ALLOWED => valueOf(commitNode,'UpdateAllowed')
1670 ,P_DELETE_ALLOWED => valueOf(commitNode,'DeleteAllowed')
1671 ,P_RETURN_STATUS => l_return_status
1672 ,P_VALIDATE => g_validate);
1673 --
1674 p_return_status := l_return_status;
1675 --
1676 hr_utility.trace('Exiting commit_u_rec_team_member');
1677 --
1678 ----------------------------------------------------------
1679 END commit_u_rec_team_member;
1680 ----------------------------------------------------------
1681 --
1682 -- --
1683 ----------------------------------------------------------
1684 ----------------------------------------------------------
1685 PROCEDURE commit_i_agency_vacancy (commitNode in xmldom.DOMNode
1686 ,p_return_status out nocopy varchar2
1687 ) AS
1688 --
1689 l_return_status varchar2(1);
1690 l_object_version_number number;
1691 --
1692 BEGIN
1693 --
1694 hr_utility.trace('Entering commit_i_agency_vacancy');
1695 --
1696 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1697 --
1698 irc_agency_vacancies_swi.create_agency_vacancy (
1699 P_VALIDATE => g_validate
1700 ,P_AGENCY_ID => valueOf(commitNode,'AgencyId')
1701 ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1702 ,P_START_DATE => date_value(valueOf(commitNode,'StartDate'))
1703 ,P_END_DATE => date_value(valueOf(commitNode,'EndDate'))
1704 ,P_MAX_ALLOWED_APPLICANTS => valueOf(commitNode,'MaxAllowedApplicants')
1705 ,P_MANAGE_APPLICANTS_ALLOWED => valueOf(commitNode,'ManageApplicantsAllowed')
1706 ,P_AGENCY_VACANCY_ID => valueOf(commitNode,'AgencyVacancyId')
1707 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
1708 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
1709 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
1710 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
1711 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
1712 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
1713 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
1714 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
1715 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
1716 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
1717 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
1718 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
1719 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
1720 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
1721 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
1722 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
1723 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
1724 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
1725 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
1726 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
1727 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
1728 ,P_ATTRIBUTE21 => valueOf(commitNode,'Attribute21')
1729 ,P_ATTRIBUTE22 => valueOf(commitNode,'Attribute22')
1730 ,P_ATTRIBUTE23 => valueOf(commitNode,'Attribute23')
1731 ,P_ATTRIBUTE24 => valueOf(commitNode,'Attribute24')
1732 ,P_ATTRIBUTE25 => valueOf(commitNode,'Attribute25')
1733 ,P_ATTRIBUTE26 => valueOf(commitNode,'Attribute26')
1734 ,P_ATTRIBUTE27 => valueOf(commitNode,'Attribute27')
1735 ,P_ATTRIBUTE28 => valueOf(commitNode,'Attribute28')
1736 ,P_ATTRIBUTE29 => valueOf(commitNode,'Attribute29')
1737 ,P_ATTRIBUTE30 => valueOf(commitNode,'Attribute30')
1738 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1739 ,P_RETURN_STATUS => l_return_status);
1740 --
1741 p_return_status := l_return_status;
1742 --
1743 hr_utility.trace('Exiting commit_i_agency_vacancy');
1744 --
1745 ----------------------------------------------------------
1746 END commit_i_agency_vacancy;
1747 ----------------------------------------------------------
1748 --
1749 ----------------------------------------------------------
1750 ----------------------------------------------------------
1751 PROCEDURE commit_d_agency_vacancy (commitNode in xmldom.DOMNode
1752 ,p_return_status out nocopy varchar2
1753 ) AS
1754 --
1755 l_return_status varchar2(1);
1756 l_object_version_number number;
1757 --
1758 BEGIN
1759 --
1760 hr_utility.trace('Entering commit_d_agency_vacancy');
1761 --
1762 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1763 --
1764 irc_agency_vacancies_swi.delete_agency_vacancy (
1765 P_AGENCY_VACANCY_ID => valueOf(commitNode,'AgencyVacancyId')
1766 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1767 ,P_RETURN_STATUS => l_return_status
1768 ,P_VALIDATE => g_validate);
1769 --
1770 p_return_status := l_return_status;
1771 --
1772 hr_utility.trace('Exiting commit_d_agency_vacancy');
1773 --
1774 ----------------------------------------------------------
1775 END commit_d_agency_vacancy;
1776 ----------------------------------------------------------
1777 --
1778 ----------------------------------------------------------
1779 ----------------------------------------------------------
1780 PROCEDURE commit_u_agency_vacancy (commitNode in xmldom.DOMNode
1781 ,p_return_status out nocopy varchar2
1782 ) AS
1783 --
1784 --
1785 --
1786 l_return_status varchar2(1);
1787 l_object_version_number number;
1788 --
1789 BEGIN
1790 --
1791 hr_utility.trace('Entering commit_u_agency_vacancy');
1792 --
1793 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1794 --
1795 irc_agency_vacancies_swi.update_agency_vacancy (
1796 P_AGENCY_ID => valueOf(commitNode,'AgencyId')
1797 ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1798 ,P_START_DATE => date_value(valueOf(commitNode,'StartDate'))
1799 ,P_END_DATE => date_value(valueOf(commitNode,'EndDate'))
1800 ,P_MAX_ALLOWED_APPLICANTS => valueOf(commitNode,'MaxAllowedApplicants')
1801 ,P_MANAGE_APPLICANTS_ALLOWED => valueOf(commitNode,'ManageApplicantsAllowed')
1802 ,P_AGENCY_VACANCY_ID => valueOf(commitNode,'AgencyVacancyId')
1803 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1804 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
1805 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
1806 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
1807 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
1808 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
1809 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
1810 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
1811 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
1812 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
1813 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
1814 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
1815 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
1816 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
1817 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
1818 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
1819 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
1820 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
1821 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
1822 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
1823 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
1824 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
1825 ,P_ATTRIBUTE21 => valueOf(commitNode,'Attribute21')
1826 ,P_ATTRIBUTE22 => valueOf(commitNode,'Attribute22')
1827 ,P_ATTRIBUTE23 => valueOf(commitNode,'Attribute23')
1828 ,P_ATTRIBUTE24 => valueOf(commitNode,'Attribute24')
1829 ,P_ATTRIBUTE25 => valueOf(commitNode,'Attribute25')
1830 ,P_ATTRIBUTE26 => valueOf(commitNode,'Attribute26')
1831 ,P_ATTRIBUTE27 => valueOf(commitNode,'Attribute27')
1832 ,P_ATTRIBUTE28 => valueOf(commitNode,'Attribute28')
1833 ,P_ATTRIBUTE29 => valueOf(commitNode,'Attribute29')
1834 ,P_ATTRIBUTE30 => valueOf(commitNode,'Attribute30')
1835 ,P_RETURN_STATUS => l_return_status
1836 ,P_VALIDATE => g_validate);
1837 --
1838 p_return_status := l_return_status;
1839 --
1840 hr_utility.trace('Exiting commit_u_agency_vacancy');
1841 --
1842 ----------------------------------------------------------
1843 END commit_u_agency_vacancy;
1844 ----------------------------------------------------------
1845 --
1846 ----------------------------------------------------------
1847 ----------------------------------------------------------
1848 -- --
1849 ----------------------------------------------------------
1850 ----------------------------------------------------------
1851 PROCEDURE commit_i_rec_activity_for (commitNode in xmldom.DOMNode
1852 ,p_return_status out nocopy varchar2
1853 ) AS
1854 --
1855 l_object_version_number number;
1856 l_return_status varchar2(1);
1857 --
1858 BEGIN
1859 --
1860 hr_utility.trace('Entering commit_i_rec_activity_for');
1861 --
1862 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1863 --
1864 per_rec_activity_for_swi.create_rec_activity_for (
1865 P_REC_ACTIVITY_FOR_ID => valueOf(commitNode,'RecruitmentActivityForId')
1866 ,P_BUSINESS_GROUP_ID => valueOf(commitNode,'BusinessGroupId')
1867 ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1868 ,P_REC_ACTIVITY_ID => valueOf(commitNode,'RecruitmentActivityId')
1869 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1870 ,P_RETURN_STATUS => l_return_status
1871 ,P_VALIDATE => g_validate);
1872 --
1873 p_return_status := l_return_status;
1874 --
1875 hr_utility.trace('Exiting commit_i_rec_activity_for');
1876 --
1877 ----------------------------------------------------------
1878 END commit_i_rec_activity_for;
1879 ----------------------------------------------------------
1880 --
1881 ----------------------------------------------------------
1882 ----------------------------------------------------------
1883 -- --
1884 ----------------------------------------------------------
1885 ----------------------------------------------------------
1886 PROCEDURE commit_d_rec_activity_for (commitNode in xmldom.DOMNode
1887 ,p_return_status out nocopy varchar2
1888 ) AS
1889 --
1890 --
1891 l_object_version_number number;
1892 l_return_status varchar2(1);
1893 --
1894 BEGIN
1895 --
1896 hr_utility.trace('Entering commit_d_rec_activity_for');
1897 --
1898 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1899 --
1900 per_rec_activity_for_swi.delete_rec_activity_for (
1901 P_REC_ACTIVITY_FOR_ID => valueOf(commitNode,'RecruitmentActivityForId')
1902 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1903 ,P_RETURN_STATUS => l_return_status
1904 ,P_VALIDATE => g_validate);
1905 --
1906 p_return_status := l_return_status;
1907 --
1908 hr_utility.trace('Exiting commit_d_rec_activity_for');
1909 --
1910 ----------------------------------------------------------
1911 END commit_d_rec_activity_for;
1912 ----------------------------------------------------------
1913 --
1914 ----------------------------------------------------------
1915 ----------------------------------------------------------
1916 -- --
1917 ----------------------------------------------------------
1918 ----------------------------------------------------------
1919 PROCEDURE commit_u_rec_activity_for (commitNode in xmldom.DOMNode
1920 ,p_return_status out nocopy varchar2
1921 ) AS
1922 --
1923 l_object_version_number number;
1924 l_return_status varchar2(1);
1925 --
1926 BEGIN
1927 --
1928 hr_utility.trace('Entering commit_u_rec_activity_for');
1929 --
1930 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1931 --
1932 per_rec_activity_for_swi.update_rec_activity_for (
1933 P_REC_ACTIVITY_FOR_ID => valueOf(commitNode,'RecruitmentActivityForId')
1934 ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1935 ,P_REC_ACTIVITY_ID => valueOf(commitNode,'RecruitmentActivityId')
1936 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1937 ,P_RETURN_STATUS => l_return_status
1938 ,P_VALIDATE => g_validate);
1939 --
1940 p_return_status := l_return_status;
1941 --
1942 hr_utility.trace('Exiting commit_u_rec_activity_for');
1943 --
1944 ----------------------------------------------------------
1945 END commit_u_rec_activity_for;
1946 ----------------------------------------------------------
1947 --
1948 ----------------------------------------------------------
1949 ----------------------------------------------------------
1950 -- --
1951 ----------------------------------------------------------
1952 ----------------------------------------------------------
1953 PROCEDURE commit_i_recruitment_activity (commitNode in xmldom.DOMNode
1954 ,p_date_change in number
1955 ,p_return_status out nocopy varchar2
1956 ) AS
1957 --
1958 l_object_version_number number;
1959 l_return_status varchar2(1);
1960 --
1961 BEGIN
1962 --
1963 hr_utility.trace('Entering commit_i_recruitment_activity');
1964 --
1965 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1966 --
1967 per_recruitment_activity_swi.create_recruitment_activity (
1968 P_BUSINESS_GROUP_ID => valueOf(commitNode,'BusinessGroupId')
1969 ,P_DATE_START => date_value(valueOf(commitNode,'DateStart')) + nvl(p_date_change,0)
1970 ,P_NAME => valueOf(commitNode,'Name')
1971 ,P_AUTHORISING_PERSON_ID => valueOf(commitNode,'AuthorisingPersonId')
1972 ,P_RUN_BY_ORGANIZATION_ID => valueOf(commitNode,'RunByOrganizationId')
1973 ,P_INTERNAL_CONTACT_PERSON_ID => valueOf(commitNode,'InternalContactPersonId')
1974 ,P_PARENT_RECRUITMENT_ACTIVITY=> valueOf(commitNode,'ParentRecruitmentActivityId')
1975 ,P_CURRENCY_CODE => valueOf(commitNode,'CurrencyCode')
1976 ,P_ACTUAL_COST => valueOf(commitNode,'ActualCost')
1977 ,P_COMMENTS => valueOf(commitNode,'Comments')
1978 ,P_CONTACT_TELEPHONE_NUMBER => valueOf(commitNode,'ContactTelephoneNumber')
1979 ,P_DATE_CLOSING => date_value(valueOf(commitNode,'DateClosing'))
1980 ,P_DATE_END => date_value(valueOf(commitNode,'DateEnd'))
1981 ,P_EXTERNAL_CONTACT => valueOf(commitNode,'ExternalContact')
1982 ,P_PLANNED_COST => valueOf(commitNode,'PlannedCost')
1983 ,P_TYPE => valueOf(commitNode,'Type')
1984 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
1985 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
1986 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
1987 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
1988 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
1989 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
1990 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
1991 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
1992 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
1993 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
1994 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
1995 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
1996 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
1997 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
1998 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
1999 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
2000 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
2001 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
2002 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
2003 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
2004 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
2005 ,P_POSTING_CONTENT_ID => valueOf(commitNode,'PostingContentId')
2006 ,P_STATUS => valueOf(commitNode,'Status')
2007 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2008 ,P_RECRUITMENT_ACTIVITY_ID => valueOf(commitNode,'RecruitmentActivityId')
2009 ,P_RETURN_STATUS => l_return_status
2010 ,P_VALIDATE => g_validate
2011 ,P_RECRUITING_SITE_ID => valueOf(commitNode,'RecruitingSiteId')
2012 ,P_RECRUITING_SITE_RESPONSE => valueOf(commitNode,'RecruitingSiteResponse'));
2013 --
2014 p_return_status := l_return_status;
2015 --
2016 hr_utility.trace('Exiting commit_i_recruitment_activity');
2017 --
2018 ----------------------------------------------------------
2019 END commit_i_recruitment_activity;
2020 ----------------------------------------------------------
2021 --
2022 ----------------------------------------------------------
2023 ----------------------------------------------------------
2024 -- --
2025 ----------------------------------------------------------
2026 ----------------------------------------------------------
2027 PROCEDURE commit_d_recruitment_activity (commitNode in xmldom.DOMNode
2028 ,p_return_status out nocopy varchar2
2029 ) AS
2030 l_object_version_number number;
2031 l_return_status varchar2(1);
2032 --
2033 BEGIN
2034 --
2035 hr_utility.trace('Entering commit_d_recruitment_activity');
2036 --
2037 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2038 --
2039 per_recruitment_activity_swi.delete_recruitment_activity (
2040 P_OBJECT_VERSION_NUMBER => l_object_version_number
2041 ,P_RECRUITMENT_ACTIVITY_ID => valueOf(commitNode,'RecruitmentActivityId')
2042 ,P_RETURN_STATUS => l_return_status
2043 ,P_VALIDATE => g_validate);
2044 --
2045 p_return_status := l_return_status;
2046 --
2047 hr_utility.trace('Exiting commit_d_recruitment_activity');
2048 --
2049 ----------------------------------------------------------
2050 END commit_d_recruitment_activity;
2051 ----------------------------------------------------------
2052 --
2053 ----------------------------------------------------------
2054 ----------------------------------------------------------
2055 -- --
2056 ----------------------------------------------------------
2057 ----------------------------------------------------------
2058 PROCEDURE commit_u_recruitment_activity (commitNode in xmldom.DOMNode
2059 ,p_return_status out nocopy varchar2
2060 ) AS
2061 --
2062 l_object_version_number number;
2063 l_return_status varchar2(1);
2064 --
2065 BEGIN
2066 --
2067 hr_utility.trace('Entering commit_u_recruitment_activity');
2068 --
2069 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2070 --
2071 per_recruitment_activity_swi.update_recruitment_activity (
2072 P_RECRUITMENT_ACTIVITY_ID => valueOf(commitNode,'RecruitmentActivityId')
2073 ,P_AUTHORISING_PERSON_ID => valueOf(commitNode,'AuthorisingPersonId')
2074 ,P_RUN_BY_ORGANIZATION_ID => valueOf(commitNode,'RunByOrganizationId')
2075 ,P_INTERNAL_CONTACT_PERSON_ID => valueOf(commitNode,'InternalContactPersonId')
2076 ,P_PARENT_RECRUITMENT_ACTIVITY => valueOf(commitNode,'ParentRecruitmentActivityId')
2077 ,P_CURRENCY_CODE => valueOf(commitNode,'CurrencyCode')
2078 ,P_DATE_START => date_value(valueOf(commitNode,'DateStart'))
2079 ,P_NAME => valueOf(commitNode,'Name')
2080 ,P_ACTUAL_COST => valueOf(commitNode,'ActualCost')
2081 ,P_COMMENTS => valueOf(commitNode,'Comments')
2082 ,P_CONTACT_TELEPHONE_NUMBER => valueOf(commitNode,'ContactTelephoneNumber')
2083 ,P_DATE_CLOSING => date_value(valueOf(commitNode,'DateClosing'))
2084 ,P_DATE_END => date_value(valueOf(commitNode,'DateEnd'))
2085 ,P_EXTERNAL_CONTACT => valueOf(commitNode,'ExternalContact')
2086 ,P_PLANNED_COST => valueOf(commitNode,'PlannedCost')
2087 ,P_TYPE => valueOf(commitNode,'Type')
2088 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
2089 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
2090 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
2091 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
2092 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
2093 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
2094 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
2095 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
2096 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
2097 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
2098 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
2099 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
2100 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
2101 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
2102 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
2103 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
2104 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
2105 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
2106 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
2107 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
2108 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
2109 ,P_POSTING_CONTENT_ID => valueOf(commitNode,'PostingContentId')
2110 ,P_STATUS => valueOf(commitNode,'Status')
2111 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2112 ,P_RETURN_STATUS => l_return_status
2113 ,P_VALIDATE => g_validate
2114 ,P_RECRUITING_SITE_ID => valueOf(commitNode,'RecruitingSiteId')
2115 ,P_RECRUITING_SITE_RESPONSE => valueOf(commitNode,'RecruitingSiteResponse'));
2116 --
2117 p_return_status := l_return_status;
2118 --
2119 hr_utility.trace('Exiting commit_u_recruitment_activity');
2120 --
2121 ----------------------------------------------------------
2122 END commit_u_recruitment_activity;
2123 ----------------------------------------------------------
2124 --
2125 ----------------------------------------------------------
2126 ----------------------------------------------------------
2127 -- --
2128 ----------------------------------------------------------
2129 ----------------------------------------------------------
2130 PROCEDURE commit_i_posting_content (commitNode in xmldom.DOMNode
2131 ,l_effective_date in date
2132 ,p_return_status out nocopy varchar2
2133 ) AS
2134 --
2135 l_object_version_number number;
2136 l_return_status varchar2(1);
2137 --
2138 BEGIN
2139 --
2140 hr_utility.trace('Entering commit_i_posting_content');
2141 --
2142 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2143 --
2144 irc_posting_content_swi.create_posting_content (
2145 P_DISPLAY_MANAGER_INFO => valueOf(commitNode,'DisplayManagerInfo')
2146 ,P_DISPLAY_RECRUITER_INFO => valueOf(commitNode,'DisplayRecruiterInfo')
2147 ,P_NAME => valueOf(commitNode,'Name')
2148 ,P_ORG_NAME => valueOf(commitNode,'OrgName')
2149 ,P_ORG_DESCRIPTION => valueOf(commitNode,'OrgDescription')
2150 ,P_JOB_TITLE => valueOf(commitNode,'JobTitle')
2151 ,P_BRIEF_DESCRIPTION => valueOf(commitNode,'BriefDescription')
2152 ,P_DETAILED_DESCRIPTION => valueOf(commitNode,'DetailedDescription')
2153 ,P_JOB_REQUIREMENTS => valueOf(commitNode,'JobRequirements')
2154 ,P_ADDITIONAL_DETAILS => valueOf(commitNode,'AdditionalDetails')
2155 ,P_HOW_TO_APPLY => valueOf(commitNode,'HowToApply')
2156 ,P_BENEFIT_INFO => valueOf(commitNode,'BenefitInfo')
2157 ,P_IMAGE_URL => valueOf(commitNode,'ImageUrl')
2158 ,P_ALT_IMAGE_URL => valueOf(commitNode,'ImageUrlAlt')
2159 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
2160 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
2161 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
2162 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
2163 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
2164 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
2165 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
2166 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
2167 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
2168 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
2169 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
2170 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
2171 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
2172 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
2173 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
2174 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
2175 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
2176 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
2177 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
2178 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
2179 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
2180 ,P_ATTRIBUTE21 => valueOf(commitNode,'Attribute21')
2181 ,P_ATTRIBUTE22 => valueOf(commitNode,'Attribute22')
2182 ,P_ATTRIBUTE23 => valueOf(commitNode,'Attribute23')
2183 ,P_ATTRIBUTE24 => valueOf(commitNode,'Attribute24')
2184 ,P_ATTRIBUTE25 => valueOf(commitNode,'Attribute25')
2185 ,P_ATTRIBUTE26 => valueOf(commitNode,'Attribute26')
2186 ,P_ATTRIBUTE27 => valueOf(commitNode,'Attribute27')
2187 ,P_ATTRIBUTE28 => valueOf(commitNode,'Attribute28')
2188 ,P_ATTRIBUTE29 => valueOf(commitNode,'Attribute29')
2189 ,P_ATTRIBUTE30 => valueOf(commitNode,'Attribute30')
2190 ,P_IPC_INFORMATION_CATEGORY => valueOf(commitNode,'IpcInformationCategory')
2191 ,P_IPC_INFORMATION1 => valueOf(commitNode,'IpcInformation1')
2192 ,P_IPC_INFORMATION2 => valueOf(commitNode,'IpcInformation2')
2193 ,P_IPC_INFORMATION3 => valueOf(commitNode,'IpcInformation3')
2194 ,P_IPC_INFORMATION4 => valueOf(commitNode,'IpcInformation4')
2195 ,P_IPC_INFORMATION5 => valueOf(commitNode,'IpcInformation5')
2196 ,P_IPC_INFORMATION6 => valueOf(commitNode,'IpcInformation6')
2197 ,P_IPC_INFORMATION7 => valueOf(commitNode,'IpcInformation7')
2198 ,P_IPC_INFORMATION8 => valueOf(commitNode,'IpcInformation8')
2199 ,P_IPC_INFORMATION9 => valueOf(commitNode,'IpcInformation9')
2200 ,P_IPC_INFORMATION10 => valueOf(commitNode,'IpcInformation10')
2201 ,P_IPC_INFORMATION11 => valueOf(commitNode,'IpcInformation11')
2202 ,P_IPC_INFORMATION12 => valueOf(commitNode,'IpcInformation12')
2203 ,P_IPC_INFORMATION13 => valueOf(commitNode,'IpcInformation13')
2204 ,P_IPC_INFORMATION14 => valueOf(commitNode,'IpcInformation14')
2205 ,P_IPC_INFORMATION15 => valueOf(commitNode,'IpcInformation15')
2206 ,P_IPC_INFORMATION16 => valueOf(commitNode,'IpcInformation16')
2207 ,P_IPC_INFORMATION17 => valueOf(commitNode,'IpcInformation17')
2208 ,P_IPC_INFORMATION18 => valueOf(commitNode,'IpcInformation18')
2209 ,P_IPC_INFORMATION19 => valueOf(commitNode,'IpcInformation19')
2210 ,P_IPC_INFORMATION20 => valueOf(commitNode,'IpcInformation20')
2211 ,P_IPC_INFORMATION21 => valueOf(commitNode,'IpcInformation21')
2212 ,P_IPC_INFORMATION22 => valueOf(commitNode,'IpcInformation22')
2213 ,P_IPC_INFORMATION23 => valueOf(commitNode,'IpcInformation23')
2214 ,P_IPC_INFORMATION24 => valueOf(commitNode,'IpcInformation24')
2215 ,P_IPC_INFORMATION25 => valueOf(commitNode,'IpcInformation25')
2216 ,P_IPC_INFORMATION26 => valueOf(commitNode,'IpcInformation26')
2217 ,P_IPC_INFORMATION27 => valueOf(commitNode,'IpcInformation27')
2218 ,P_IPC_INFORMATION28 => valueOf(commitNode,'IpcInformation28')
2219 ,P_IPC_INFORMATION29 => valueOf(commitNode,'IpcInformation29')
2220 ,P_IPC_INFORMATION30 => valueOf(commitNode,'IpcInformation30')
2221 ,P_POSTING_CONTENT_ID => valueOf(commitNode,'PostingContentId')
2222 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2223 ,P_RETURN_STATUS => l_return_status
2224 ,P_VALIDATE => g_validate
2225 ,P_DATE_APPROVED => l_effective_date);
2226 --
2227 p_return_status := l_return_status;
2228 --
2229 hr_utility.trace('Exiting commit_i_posting_content');
2230 --
2231 ----------------------------------------------------------
2232 END commit_i_posting_content;
2233 ----------------------------------------------------------
2234 --
2235 ----------------------------------------------------------
2236 ----------------------------------------------------------
2237 -- --
2238 ----------------------------------------------------------
2239 ----------------------------------------------------------
2240 PROCEDURE commit_d_posting_content (commitNode in xmldom.DOMNode
2241 ,p_return_status out nocopy varchar2
2242 ) AS
2243 --
2244 l_object_version_number number;
2245 l_return_status varchar2(1);
2246 --
2247 BEGIN
2248 --
2249 hr_utility.trace('Entering commit_d_posting_content');
2250 --
2251 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2252 --
2253 irc_posting_content_swi.delete_posting_content (
2254 P_POSTING_CONTENT_ID => valueOf(commitNode,'PostingContentId')
2255 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2256 ,P_RETURN_STATUS => l_return_status
2257 ,P_VALIDATE => g_validate);
2258 --
2259 p_return_status := l_return_status;
2260 --
2261 hr_utility.trace('Exiting commit_d_posting_content');
2262 --
2263 ----------------------------------------------------------
2264 END commit_d_posting_content;
2265 ----------------------------------------------------------
2266 --
2267 ----------------------------------------------------------
2268 ----------------------------------------------------------
2269 -- --
2270 ----------------------------------------------------------
2271 ----------------------------------------------------------
2272 PROCEDURE commit_u_posting_content (commitNode in xmldom.DOMNode
2273 ,p_return_status out nocopy varchar2
2274 ) AS
2275 --
2276 l_object_version_number number;
2277 l_return_status varchar2(1);
2278 --
2279 BEGIN
2280 --
2281 hr_utility.trace('Entering commit_u_posting_content');
2282 --
2283 l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
2284 --
2285 irc_posting_content_swi.update_posting_content (
2286 P_POSTING_CONTENT_ID => valueOf(commitNode,'PostingContentId')
2287 ,P_DISPLAY_MANAGER_INFO => valueOf(commitNode,'DisplayManagerInfo')
2288 ,P_DISPLAY_RECRUITER_INFO => valueOf(commitNode,'DisplayRecruiterInfo')
2289 ,P_NAME => valueOf(commitNode,'Name')
2290 ,P_ORG_NAME => valueOf(commitNode,'OrgName')
2291 ,P_ORG_DESCRIPTION => valueOf(commitNode,'OrgDescription')
2292 ,P_JOB_TITLE => valueOf(commitNode,'JobTitle')
2293 ,P_BRIEF_DESCRIPTION => valueOf(commitNode,'BriefDescription')
2294 ,P_DETAILED_DESCRIPTION => valueOf(commitNode,'DetailedDescription')
2295 ,P_JOB_REQUIREMENTS => valueOf(commitNode,'JobRequirements')
2296 ,P_ADDITIONAL_DETAILS => valueOf(commitNode,'AdditionalDetails')
2297 ,P_HOW_TO_APPLY => valueOf(commitNode,'HowToApply')
2298 ,P_BENEFIT_INFO => valueOf(commitNode,'BenefitInfo')
2299 ,P_IMAGE_URL => valueOf(commitNode,'ImageUrl')
2300 ,P_ALT_IMAGE_URL => valueOf(commitNode,'ImageUrlAlt')
2301 ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
2302 ,P_ATTRIBUTE1 => valueOf(commitNode,'Attribute1')
2303 ,P_ATTRIBUTE2 => valueOf(commitNode,'Attribute2')
2304 ,P_ATTRIBUTE3 => valueOf(commitNode,'Attribute3')
2305 ,P_ATTRIBUTE4 => valueOf(commitNode,'Attribute4')
2306 ,P_ATTRIBUTE5 => valueOf(commitNode,'Attribute5')
2307 ,P_ATTRIBUTE6 => valueOf(commitNode,'Attribute6')
2308 ,P_ATTRIBUTE7 => valueOf(commitNode,'Attribute7')
2309 ,P_ATTRIBUTE8 => valueOf(commitNode,'Attribute8')
2310 ,P_ATTRIBUTE9 => valueOf(commitNode,'Attribute9')
2311 ,P_ATTRIBUTE10 => valueOf(commitNode,'Attribute10')
2312 ,P_ATTRIBUTE11 => valueOf(commitNode,'Attribute11')
2313 ,P_ATTRIBUTE12 => valueOf(commitNode,'Attribute12')
2314 ,P_ATTRIBUTE13 => valueOf(commitNode,'Attribute13')
2315 ,P_ATTRIBUTE14 => valueOf(commitNode,'Attribute14')
2316 ,P_ATTRIBUTE15 => valueOf(commitNode,'Attribute15')
2317 ,P_ATTRIBUTE16 => valueOf(commitNode,'Attribute16')
2318 ,P_ATTRIBUTE17 => valueOf(commitNode,'Attribute17')
2319 ,P_ATTRIBUTE18 => valueOf(commitNode,'Attribute18')
2320 ,P_ATTRIBUTE19 => valueOf(commitNode,'Attribute19')
2321 ,P_ATTRIBUTE20 => valueOf(commitNode,'Attribute20')
2322 ,P_ATTRIBUTE21 => valueOf(commitNode,'Attribute21')
2323 ,P_ATTRIBUTE22 => valueOf(commitNode,'Attribute22')
2324 ,P_ATTRIBUTE23 => valueOf(commitNode,'Attribute23')
2325 ,P_ATTRIBUTE24 => valueOf(commitNode,'Attribute24')
2326 ,P_ATTRIBUTE25 => valueOf(commitNode,'Attribute25')
2327 ,P_ATTRIBUTE26 => valueOf(commitNode,'Attribute26')
2328 ,P_ATTRIBUTE27 => valueOf(commitNode,'Attribute27')
2329 ,P_ATTRIBUTE28 => valueOf(commitNode,'Attribute28')
2330 ,P_ATTRIBUTE29 => valueOf(commitNode,'Attribute29')
2331 ,P_ATTRIBUTE30 => valueOf(commitNode,'Attribute30')
2332 ,P_IPC_INFORMATION_CATEGORY => valueOf(commitNode,' IpcInformationCategory')
2333 ,P_IPC_INFORMATION1 => valueOf(commitNode,'IpcInformation1')
2334 ,P_IPC_INFORMATION2 => valueOf(commitNode,'IpcInformation2')
2335 ,P_IPC_INFORMATION3 => valueOf(commitNode,'IpcInformation3')
2336 ,P_IPC_INFORMATION4 => valueOf(commitNode,'IpcInformation4')
2337 ,P_IPC_INFORMATION5 => valueOf(commitNode,'IpcInformation5')
2338 ,P_IPC_INFORMATION6 => valueOf(commitNode,'IpcInformation6')
2339 ,P_IPC_INFORMATION7 => valueOf(commitNode,'IpcInformation7')
2340 ,P_IPC_INFORMATION8 => valueOf(commitNode,'IpcInformation8')
2341 ,P_IPC_INFORMATION9 => valueOf(commitNode,'IpcInformation9')
2342 ,P_IPC_INFORMATION10 => valueOf(commitNode,'IpcInformation10')
2343 ,P_IPC_INFORMATION11 => valueOf(commitNode,'IpcInformation11')
2344 ,P_IPC_INFORMATION12 => valueOf(commitNode,'IpcInformation12')
2345 ,P_IPC_INFORMATION13 => valueOf(commitNode,'IpcInformation13')
2346 ,P_IPC_INFORMATION14 => valueOf(commitNode,'IpcInformation14')
2347 ,P_IPC_INFORMATION15 => valueOf(commitNode,'IpcInformation15')
2348 ,P_IPC_INFORMATION16 => valueOf(commitNode,'IpcInformation16')
2349 ,P_IPC_INFORMATION17 => valueOf(commitNode,'IpcInformation17')
2350 ,P_IPC_INFORMATION18 => valueOf(commitNode,'IpcInformation18')
2351 ,P_IPC_INFORMATION19 => valueOf(commitNode,'IpcInformation19')
2352 ,P_IPC_INFORMATION20 => valueOf(commitNode,'IpcInformation20')
2353 ,P_IPC_INFORMATION21 => valueOf(commitNode,'IpcInformation21')
2354 ,P_IPC_INFORMATION22 => valueOf(commitNode,'IpcInformation22')
2355 ,P_IPC_INFORMATION23 => valueOf(commitNode,'IpcInformation23')
2356 ,P_IPC_INFORMATION24 => valueOf(commitNode,'IpcInformation24')
2357 ,P_IPC_INFORMATION25 => valueOf(commitNode,'IpcInformation25')
2358 ,P_IPC_INFORMATION26 => valueOf(commitNode,'IpcInformation26')
2359 ,P_IPC_INFORMATION27 => valueOf(commitNode,'IpcInformation27')
2360 ,P_IPC_INFORMATION28 => valueOf(commitNode,'IpcInformation28')
2361 ,P_IPC_INFORMATION29 => valueOf(commitNode,'IpcInformation29')
2362 ,P_IPC_INFORMATION30 => valueOf(commitNode,'IpcInformation30')
2363 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2364 ,P_RETURN_STATUS => l_return_status
2365 ,P_VALIDATE => g_validate
2366 ,P_DATE_APPROVED => date_value(valueOf(commitNode,'DateApproved')));
2367 --
2368 p_return_status := l_return_status;
2369 --
2370 hr_utility.trace('Exiting commit_u_posting_content');
2371 --
2372 ----------------------------------------------------------
2373 END commit_u_posting_content;
2374 ----------------------------------------------------------
2375 --
2376 ----------------------------------------------------------
2377 ----------------------------------------------------------
2378 -- --
2379 ----------------------------------------------------------
2380 ----------------------------------------------------------
2381 function date_value(string_value varchar2)
2382 return date IS
2383 --
2384 BEGIN
2385 --
2386 return trunc(to_date(substrb(string_value, 0, 19), 'YYYY/MM/DD HH24:MI:SS'));
2387 --
2388 ----------------------------------------------------------
2389 END date_value;
2390 ----------------------------------------------------------
2391 --
2392 FUNCTION isSelfApprove(itemtype in varchar2,
2393 itemkey in varchar2)
2394 return boolean as
2395 --
2396 approver varchar2(240);
2397 requestor varchar2(240);
2398 --
2399 BEGIN
2400 --
2401 hr_utility.trace('Entering isSelfApprove');
2402 --
2403 approver := wf_engine.getItemAttrText
2404 (itemtype => itemtype,
2405 itemkey => itemkey,
2406 aname => 'IRC_APPROVER');
2407 --
2408 if (approver is null) then
2409 hr_utility.trace('Exiting isSelfApprove returning TRUE');
2410 return true;
2411 end if;
2412 --
2413 hr_utility.trace('Exiting isSelfApprove returning FALSE');
2414 return false;
2415 --
2416 END isSelfApprove;
2417 --
2418 FUNCTION found_IrcVacancyCompetence (commitNode in xmldom.DOMNode)
2419 return boolean as
2420 --
2421 l_competence_element_id number;
2422 l_row_count number;
2423 --
2424 BEGIN
2425 --
2426 hr_utility.trace('Entering found_IrcVacancyCompetence');
2427 --
2428 l_competence_element_id :=
2429 valueOf(commitNode,'CompetenceElementId');
2430 --
2431 select count(*)
2432 into l_row_count
2433 from per_competence_elements
2434 where competence_element_id = l_competence_element_id;
2435 --
2436 if (l_row_count = 0) then
2437 hr_utility.trace('Exiting found_IrcVacancyCompetence returning FALSE');
2438 return false;
2439 end if;
2440 --
2441 hr_utility.trace('Exiting found_IrcVacancyCompetence returning TRUE');
2442 --
2443 return true;
2444 --
2445 END found_IrcVacancyCompetence;
2446 --
2447 --
2448 FUNCTION found_IrcRecTeamDisplay (commitNode in xmldom.DOMNode)
2449 return boolean as
2450 --
2451 l_party_id number;
2452 l_vacancy_id number;
2453 l_row_count number;
2454 --
2455 BEGIN
2456 --
2457 l_party_id := valueOf(commitNode,'PartyId');
2458 l_vacancy_id := valueOf(commitNode,'VacancyId');
2459 --
2460 select count(*)
2461 into l_row_count
2462 from irc_rec_team_members
2463 where party_id = l_party_id
2464 and vacancy_id = l_vacancy_id;
2465 --
2466 if (l_row_count = 0) then
2467 hr_utility.trace('Exiting found_IrcRecTeamDisplay returning FALSE');
2468 return false;
2469 end if;
2470 --
2471 hr_utility.trace('Exiting found_IrcRecTeamDisplay returning TRUE');
2472 return true;
2473 --
2474 END found_IrcRecTeamDisplay;
2475 --
2476 FUNCTION found_agency_vacancy (commitNode in xmldom.DOMNode)
2477 return boolean as
2478 --
2479 l_agency_vacancy_id number;
2480 l_row_count number;
2481 --
2482 BEGIN
2483 --
2484 l_agency_vacancy_id := valueOf(commitNode,'AgencyVacancyId');
2485 --
2486 select count(*)
2487 into l_row_count
2488 from IRC_AGENCY_VACANCIES
2489 where agency_vacancy_id = l_agency_vacancy_id;
2490 --
2491 if (l_row_count = 0) then
2492 hr_utility.trace('Exiting found_agency_vacancy returning FALSE');
2493 return false;
2494 end if;
2495 --
2496 hr_utility.trace('Exiting found_agency_vacancy returning TRUE');
2497 return true;
2498 --
2499 END found_agency_vacancy;
2500 --
2501 FUNCTION found_IrcVariableCompElements (commitNode in xmldom.DOMNode)
2502 return boolean as
2503 --
2504 l_vacancy_id number;
2505 l_lookup_code varchar2(10);
2506 l_row_count number;
2507 --
2508 BEGIN
2509 --
2510 l_vacancy_id := valueOf(commitNode,'VacancyId');
2511 l_lookup_code := valueOf(commitNode,'LookupCode');
2512 --
2513 select count(*)
2514 into l_row_count
2515 from irc_variable_comp_elements
2516 where vacancy_id = l_vacancy_id
2517 and variable_comp_lookup = l_lookup_code;
2518 --
2519 if (l_row_count = 0) then
2520 hr_utility.trace('Exiting found_IrcVariableCompElements returning FALSE');
2521 return false;
2522 end if;
2523 --
2524 hr_utility.trace('Exiting found_IrcVariableCompElements returning TRUE');
2525 return true;
2526 --
2527 END found_IrcVariableCompElements;
2528 --
2529 --
2530 FUNCTION found_rec_activity(commitNode in xmldom.DOMNode)
2531 return boolean as
2532 --
2533 l_recruitment_activity_id number;
2534 l_row_count number;
2535 --
2536 BEGIN
2537 --
2538 l_recruitment_activity_id :=
2539 valueOf(commitNode,'RecruitmentActivityId');
2540 --
2541 select count(*)
2542 into l_row_count
2543 from per_recruitment_activities
2544 where recruitment_activity_id = l_recruitment_activity_id;
2545 --
2546 if (l_row_count = 0) then
2547 hr_utility.trace('Exiting found_rec_activity returning FALSE');
2548 return false;
2549 end if;
2550 --
2551 hr_utility.trace('Exiting found_rec_activity returning TRUE');
2552 return true;
2553 --
2554 END found_rec_activity;
2555 --
2556 --
2557 FUNCTION found_rec_activity_for(commitNode in xmldom.DOMNode)
2558 return boolean as
2559 --
2560 l_recruitment_activity_for_id number;
2561 l_row_count number;
2562 --
2563 BEGIN
2564 --
2565 l_recruitment_activity_for_id :=
2566 valueOf(commitNode,'RecruitmentActivityForId');
2567 --
2568 select count(*)
2569 into l_row_count
2570 from per_recruitment_activity_for
2571 where recruitment_activity_for_id = l_recruitment_activity_for_id;
2572 --
2573 if (l_row_count = 0) then
2574 hr_utility.trace('Exiting found_rec_activity_for returning FALSE');
2575 return false;
2576 end if;
2577 --
2578 hr_utility.trace('Exiting found_rec_activity_for returning TRUE');
2579 return true;
2580 --
2581 END found_rec_activity_for;
2582 --
2583 --
2584 FUNCTION found_IrcSearchCriteria(commitNode in xmldom.DOMNode)
2585 return boolean as
2586 --
2587 l_search_criteria_id number;
2588 l_row_count number;
2589 --
2590 BEGIN
2591 --
2592 l_search_criteria_id :=
2593 valueOf(commitNode,'SearchCriteriaId');
2594 --
2595 select count(*)
2596 into l_row_count
2597 from irc_search_criteria
2598 where search_criteria_id = l_search_criteria_id;
2599 --
2600 if (l_row_count = 0) then
2601 hr_utility.trace('Exiting found_IrcSearchCriteria returning FALSE');
2602 return false;
2603 end if;
2604 --
2605 hr_utility.trace('Exiting found_IrcSearchCriteria returning TRUE');
2606 return true;
2607 --
2608 END found_IrcSearchCriteria;
2609 --
2610 --
2611 FUNCTION found_IrcPostingContent(commitNode in xmldom.DOMNode)
2612 return boolean as
2613 --
2614 l_posting_content_id number;
2615 l_row_count number;
2616 --
2617 BEGIN
2618 --
2619 l_posting_content_id :=
2620 valueOf(commitNode,'PostingContentId');
2621 --
2622 select count(*)
2623 into l_row_count
2624 from irc_posting_contents
2625 where posting_content_id = l_posting_content_id;
2626 --
2627 if (l_row_count = 0) then
2628 hr_utility.trace('Exiting found_IrcPostingContent returning FALSE');
2629 return false;
2630 end if;
2631 --
2632 hr_utility.trace('Exiting found_IrcPostingContent returning TRUE');
2633 return true;
2634 --
2635 END found_IrcPostingContent;
2636 --
2637 --
2638 ----------------------------------------------------------
2639 ----------------------------------------------------------
2640 FUNCTION get_internal_posting_days return number IS
2641 --
2642 number_of_days varchar2(10);
2643 --
2644 BEGIN
2645 --
2646 hr_utility.trace('Entering get_internal_posting_days');
2647 --
2648 number_of_days := fnd_profile.value('IRC_INTERNAL_POSTING_DAYS');
2649
2650 if (number_of_days is null) then
2651 hr_utility.trace('Number of days is null - returning -1');
2652 return -1;
2653 else
2654 hr_utility.trace('Returning number of days as :' || number_of_days || ':');
2655 return to_number(number_of_days);
2656 end if;
2657 --
2658 END get_internal_posting_days;
2659 --
2660 --
2661 ----------------------------------------------------------
2662 ----------------------------------------------------------
2663 FUNCTION is_site_internal (p_site_id varchar2
2664 ) return varchar2 IS
2665 --
2666 l_internal irc_all_recruiting_sites.INTERNAL%type;
2667 l_external irc_all_recruiting_sites.EXTERNAL%type;
2668 l_third_party irc_all_recruiting_sites.THIRD_PARTY%type;
2669 --
2670 cursor csr_irs(c_site_id irc_all_recruiting_sites.RECRUITING_SITE_ID%type) is
2671 --
2672 select INTERNAL, EXTERNAL, THIRD_PARTY
2673 from irc_all_recruiting_sites
2674 where RECRUITING_SITE_ID = c_site_id;
2675 --
2676 BEGIN
2677 --
2678 hr_utility.trace('Entering is_site_internal');
2679 --
2680 open csr_irs(p_site_id);
2681 fetch csr_irs into l_internal, l_external, l_third_party;
2682 if csr_irs%notfound then
2683 close csr_irs;
2684 return '0';
2685 end if;
2686 close csr_irs;
2687 --
2688 if (l_internal = 'Y') then
2689 --
2690 hr_utility.trace('internal=Y so return I');
2691 --
2692 return 'I';
2693 end if;
2694 --
2695 if (l_external = 'Y') then
2696 --
2697 hr_utility.trace('external=Y so return X');
2698 --
2699 return 'X';
2700 end if;
2701 --
2702 hr_utility.trace('neither internal nor external is Y so return 3');
2703 return '3';
2704 --
2705 END is_site_internal;
2706 --
2707 PROCEDURE get_date_changes (
2708 commitNodes xmldom.DOMNodeList,
2709 external_date_change out nocopy number,
2710 internal_date_change out nocopy number) as
2711 --
2712 commitNode xmldom.DOMNode;
2713 internalStartDate date;
2714 --
2715 BEGIN
2716 --
2717 hr_utility.trace('Entering get_date_changes');
2718 --
2719 -- If the start date of the external posting was not enterable
2720 -- because the IRC: Internal Posting Days profile option was set then
2721 -- the start date of the external posting will be set to be that
2722 -- number of days after the start date of the internal posting.
2723 --
2724 -- external_date_change := get_internal_posting_days();
2725 external_date_change := 0;
2726 --
2727 -- find the internal site and determine any correction to
2728 -- the start date required
2729 --
2730 -- If the start date of the internal posting is before the approval date then
2731 -- the start date of the internal posting will be moved to the approval date
2732 -- the start date of the external posting will be moved by the same amount.
2733 --
2734 for j in 1..xmldom.getLength(commitNodes) loop
2735 --
2736 hr_utility.trace('Checking node :' || to_char(j) || ':');
2737 --
2738 commitNode:=xmldom.item(commitNodes,j-1);
2739 --
2740 if (is_site_internal(valueOf(commitNode,'RecruitingSiteId')) = 'I') then
2741 --
2742 internalStartDate := date_value(valueOf(commitNode,'DateStart'));
2743 --
2744 hr_utility.trace('Internal Site date found :' || to_char(internalStartDate) || ':');
2745 --
2746 if (internalStartDate < sysdate) then
2747 internal_date_change := sysdate - internalStartDate;
2748 --
2749 hr_utility.trace('internalStartDate < sysdate, internal change :'
2750 || internal_date_change || ':');
2751 --
2752 if (external_date_change = -1) then
2753 external_date_change := internal_date_change;
2754 --
2755 hr_utility.trace('external_date_change found as -1, changing to :'
2756 || external_date_change || ':');
2757 --
2758 else
2759 external_date_change := internal_date_change + external_date_change;
2760 --
2761 hr_utility.trace('external_date_change set to :' || external_date_change || ':');
2762 --
2763 end if;
2764 end if;
2765 end if;
2766 end loop;
2767 --
2768 if (external_date_change = -1) then
2769 --
2770 hr_utility.trace('external_date_change is still -1, changing it to 0');
2771 --
2772 external_date_change := 0;
2773 end if;
2774 --
2775 hr_utility.trace('Exiting get_date_changes');
2776 --
2777 return;
2778 --
2779 END get_date_changes;
2780 --
2781 -- --
2782 ----------------------------------------------------------
2783 ----------------------------------------------------------
2784 function get_error(itemtype in varchar2,
2785 itemkey in varchar2) return varchar2 is
2786 --
2787 error_tabs error_tab;
2788 --
2789 pMessageCount number;
2790 messageBuffer varchar2(1000);
2791 error_list varchar2(4000);
2792 error_tabs1 varchar2(4000);
2793 errorField varchar2(1000);
2794 messageType varchar2(1000);
2795 messageText varchar2(1000);
2796 --
2797 BEGIN
2798 --
2799 hr_utility.trace('Entering get_error for :' || itemtype || '-' || itemkey || ':');
2800 --
2801 pMessageCount := FND_MSG_PUB.COUNT_MSG();
2802 --
2803 messageBuffer := FND_MSG_PUB.GET_DETAIL(p_msg_index => FND_MSG_PUB.G_FIRST);
2804 FND_MESSAGE.Set_Encoded(messageBuffer);
2805 errorField := FND_MESSAGE.GET_TOKEN('FND_ERROR_LOCATION_FIELD','Y');
2806 messageType := FND_MESSAGE.GET_TOKEN('FND_MESSAGE_TYPE','Y');
2807 error_tabs1 := FND_MESSAGE.GET;
2808 --
2809 hr_utility.trace('Exiting get_error returning :' || error_tabs1 || ':');
2810 --
2811 return error_tabs1;
2812 --
2813 ----------------------------------------------------------
2814 END get_error;
2815 ----------------------------------------------------------
2816 --
2817 ----------------------------------------------------------
2818 ----------------------------------------------------------
2819 --
2820 PROCEDURE set_up_error_message(itemtype in varchar2,
2821 itemkey in varchar2,
2822 error_tabs in varchar2) as
2823 --
2824 apr_item_type varchar2(240);
2825 vacancy_name varchar2(4000);
2826 launching_page varchar2(4000);
2827 transId varchar2(4000);
2828 apr_message varchar2(4000);
2829 urlBase varchar2(4000);
2830 htmlCall fnd_form_functions.web_html_call%type;
2831 approval_process varchar2(4000);
2832 l_encrypted_id varchar2(2000);
2833 --
2834 BEGIN
2835 --
2836 hr_utility.trace('Entering set_up_error_message with message :'
2837 || error_tabs || ':');
2838 --
2839 apr_item_type := wf_engine.getItemAttrText
2840 (itemtype => itemtype,
2841 itemkey => itemkey,
2842 aname => 'IRCAPPROVALITEM');
2843 --
2844 approval_process := wf_engine.getItemAttrText
2845 (itemtype => itemtype,
2846 itemkey => itemkey,
2847 aname => 'IRCAPPROVALPROCESS');
2848 --
2849 vacancy_name := wf_engine.getItemAttrText
2850 (itemtype => itemtype,
2851 itemkey => itemkey,
2852 aname => 'IRC_APPROVAL_ITEM_NAME');
2853 --
2854 transId := wf_engine.getItemAttrText
2855 (itemtype => itemtype,
2856 itemkey => itemkey,
2857 aname => 'IRC_APPROVE_TRANS_ID');
2858 --
2859 fnd_message.set_name('PER','IRC_' || apr_item_type || '_CORRECTION_SUBJECT');
2860 fnd_message.set_token('VACANCYNAME',vacancy_name, false);
2861 apr_message := fnd_message.get;
2862 wf_engine.setItemAttrText
2863 (itemtype => itemtype,
2864 itemkey => itemkey,
2865 aname => 'IRCAPPROVALSUBJECT',
2866 avalue => apr_message);
2867 --
2868 fnd_message.set_name('PER','IRC_' || apr_item_type || '_AUTO_CORRECT_TEXT');
2869 fnd_message.set_token('ERROR_TEXT1',error_tabs, false);
2870 apr_message := fnd_message.get;
2871 wf_engine.setItemAttrText
2872 (itemtype => itemtype,
2873 itemkey => itemkey,
2874 aname => 'IRCAPPROVALTEXTBODY',
2875 avalue => apr_message);
2876 --
2877 fnd_message.set_name('PER','IRC_' || apr_item_type || '_AUTO_CORRECT_HTML');
2878 fnd_message.set_token('ERROR_TEXT1',error_tabs, false);
2879 apr_message := fnd_message.get;
2880 wf_engine.setItemAttrText
2881 (itemtype => itemtype,
2882 itemkey => itemkey,
2883 aname => 'IRCAPPROVALHTMLBODY',
2884 avalue => apr_message);
2885 --
2886 launching_page := wf_engine.getItemAttrText
2887 (itemtype => itemtype,
2888 itemkey => itemkey,
2889 aname => 'IRC_LAUNCHING_PAGE');
2890 --
2891 urlBase:='JSP:/OA_HTML/OA.jsp?OAFunc='||launching_page
2892 ||'&correctionTransactionId='||transId||'&retainAM=Y';
2893 --
2894 wf_engine.setItemAttrText
2895 (itemtype => itemtype,
2896 itemkey => itemkey,
2897 aname => 'IRCAPPROVALURL',
2898 avalue => urlBase);
2899 --
2900 hr_utility.trace('Exiting set_up_error_message');
2901 --
2902 return;
2903 --
2904 ----------------------------------------------------------
2905 END set_up_error_message;
2906 ----------------------------------------------------------
2907 --
2908 END IRC_VACANCY_COMMIT;