APPS.IRC_VACANCY_COMMIT dependencies on PER_COMPETENCE_ELEMENTS

Line 264: hr_utility.trace('Inserting PER_COMPETENCE_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

Line 272: hr_utility.trace('ERROR Inserting PER_COMPETENCE_ELEMENTS records');

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

Line 549: hr_utility.trace('Updating PER_COMPETENCE_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

Line 565: hr_utility.trace('ERROR Updating PER_COMPETENCE_ELEMENTS records');

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

Line 2433: from per_competence_elements

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