eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_VACANCY_COMMIT dependencies on XMLDOM

Line 6: function valueOf(N xmldom.DOMNode, pattern varchar2)

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);

Line 131: xmldoc xmldom.DOMDocument;

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;

Line 132: xmlelt xmldom.DOMElement;

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);

Line 140: commitNodes xmldom.DOMNodeList;

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;

Line 141: commitNode xmldom.DOMNode;

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);

Line 201: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRequisitionsVORow');

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);

Line 203: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 204: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 214: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcPostingContentsVlVORow');

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);

Line 216: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 217: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 227: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditVacancyVORow');

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);

Line 229: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 230: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 240: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancySearchCriteriaVORow');

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);

Line 242: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 243: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 253: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVariableCompElementsVORow');

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);

Line 255: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 256: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 266: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancyCompetenceVORow');

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);

Line 268: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 269: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 279: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcRecTeamDisplayVORow');

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);

Line 281: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 282: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 292: commitNodes := xmldom.getElementsByTagName(xmldoc, 'AgencyVacanciesVORow');

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);

Line 294: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 295: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 305: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivitiesVORow');

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

Line 309: for j in 1..xmldom.getLength(commitNodes) loop

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);

Line 310: commitNode:=xmldom.item(commitNodes,j-1);

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

Line 326: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');

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);

Line 328: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 329: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 407: xmldoc xmldom.DOMDocument;

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;

Line 408: xmlelt xmldom.DOMElement;

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);

Line 416: commitNodes xmldom.DOMNodeList;

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);

Line 417: commitNode xmldom.DOMNode;

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;

Line 472: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRequisitionsVORow');

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);

Line 474: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 475: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 485: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcPostingContentsVlVORow');

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

Line 487: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 488: commitNode:=xmldom.item(commitNodes,j-1);

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);

Line 502: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditVacancyVORow');

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);

Line 504: for j in 1..xmldom.getLength(commitNodes) loop

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');

Line 505: commitNode:=xmldom.item(commitNodes,j-1);

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;

Line 515: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancySearchCriteriaVORow');

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

Line 517: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 518: commitNode:=xmldom.item(commitNodes,j-1);

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);

Line 532: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVariableCompElementsVORow');

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

Line 534: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 535: commitNode:=xmldom.item(commitNodes,j-1);

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

Line 551: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancyCompetenceVORow');

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

Line 553: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 554: commitNode:=xmldom.item(commitNodes,j-1);

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

Line 572: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcRecTeamDisplayVORow');

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

Line 574: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 575: commitNode:=xmldom.item(commitNodes,j-1);

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

Line 593: commitNodes := xmldom.getElementsByTagName(xmldoc, 'AgencyVacanciesVORow');

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

Line 595: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 596: commitNode:=xmldom.item(commitNodes,j-1);

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

Line 614: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');

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);

Line 616: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 618: commitNode:=xmldom.item(commitNodes,j-1);

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

Line 632: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivitiesVORow');

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);

Line 634: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 636: commitNode:=xmldom.item(commitNodes,j-1);

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

Line 657: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcEditRecruitmentActivityForVORow');

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);

Line 659: for j in 1..xmldom.getLength(commitNodes) loop

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

Line 661: commitNode:=xmldom.item(commitNodes,j-1);

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);

Line 734: PROCEDURE commit_i_requisition (commitNode in xmldom.DOMNode

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);

Line 794: PROCEDURE commit_d_requisition (commitNode in xmldom.DOMNode

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);

Line 826: PROCEDURE commit_u_requisition (commitNode in xmldom.DOMNode

822: ----------------------------------------------------------
823: -- --
824: ----------------------------------------------------------
825: ----------------------------------------------------------
826: PROCEDURE commit_u_requisition (commitNode in xmldom.DOMNode
827: ,p_return_status out nocopy varchar2
828: ) AS
829: --
830: --

Line 886: PROCEDURE commit_i_vacancy (commitNode in xmldom.DOMNode

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: --

Line 965: PROCEDURE commit_u_vacancy (commitNode in xmldom.DOMNode

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: --

Line 1049: PROCEDURE commit_i_search_criteria (commitNode in xmldom.DOMNode

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: --

Line 1163: PROCEDURE commit_d_search_criteria (commitNode in xmldom.DOMNode

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: --

Line 1197: PROCEDURE commit_u_search_criteria (commitNode in xmldom.DOMNode

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: --

Line 1311: PROCEDURE commit_i_competence_element (commitNode in xmldom.DOMNode

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: --

Line 1402: PROCEDURE commit_u_competence_element (commitNode in xmldom.DOMNode

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: --

Line 1477: PROCEDURE commit_d_competence_element (commitNode in xmldom.DOMNode

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);

Line 1509: PROCEDURE commit_i_variable_comp_element (commitNode in xmldom.DOMNode

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: --

Line 1544: PROCEDURE commit_d_variable_comp_element (commitNode in xmldom.DOMNode

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);

Line 1577: PROCEDURE commit_i_rec_team_member (commitNode in xmldom.DOMNode

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;

Line 1616: PROCEDURE commit_d_rec_team_member (commitNode in xmldom.DOMNode

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;

Line 1648: PROCEDURE commit_u_rec_team_member (commitNode in xmldom.DOMNode

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;

Line 1685: PROCEDURE commit_i_agency_vacancy (commitNode in xmldom.DOMNode

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);

Line 1751: PROCEDURE commit_d_agency_vacancy (commitNode in xmldom.DOMNode

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);

Line 1780: PROCEDURE commit_u_agency_vacancy (commitNode in xmldom.DOMNode

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: --

Line 1851: PROCEDURE commit_i_rec_activity_for (commitNode in xmldom.DOMNode

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;

Line 1886: PROCEDURE commit_d_rec_activity_for (commitNode in xmldom.DOMNode

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: --

Line 1919: PROCEDURE commit_u_rec_activity_for (commitNode in xmldom.DOMNode

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;

Line 1953: PROCEDURE commit_i_recruitment_activity (commitNode in xmldom.DOMNode

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: --

Line 2027: PROCEDURE commit_d_recruitment_activity (commitNode in xmldom.DOMNode

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);

Line 2058: PROCEDURE commit_u_recruitment_activity (commitNode in xmldom.DOMNode

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;

Line 2130: PROCEDURE commit_i_posting_content (commitNode in xmldom.DOMNode

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: --

Line 2240: PROCEDURE commit_d_posting_content (commitNode in xmldom.DOMNode

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;

Line 2272: PROCEDURE commit_u_posting_content (commitNode in xmldom.DOMNode

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;

Line 2418: FUNCTION found_IrcVacancyCompetence (commitNode in xmldom.DOMNode)

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;

Line 2448: FUNCTION found_IrcRecTeamDisplay (commitNode in xmldom.DOMNode)

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;

Line 2476: FUNCTION found_agency_vacancy (commitNode in xmldom.DOMNode)

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;

Line 2501: FUNCTION found_IrcVariableCompElements (commitNode in xmldom.DOMNode)

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);

Line 2530: FUNCTION found_rec_activity(commitNode in xmldom.DOMNode)

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;

Line 2557: FUNCTION found_rec_activity_for(commitNode in xmldom.DOMNode)

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;

Line 2584: FUNCTION found_IrcSearchCriteria(commitNode in xmldom.DOMNode)

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;

Line 2611: FUNCTION found_IrcPostingContent(commitNode in xmldom.DOMNode)

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;

Line 2708: commitNodes xmldom.DOMNodeList,

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;

Line 2712: commitNode xmldom.DOMNode;

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: --

Line 2734: for j in 1..xmldom.getLength(commitNodes) loop

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);

Line 2738: commitNode:=xmldom.item(commitNodes,j-1);

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'));