APPS.IRC_VACANCY_COMMIT dependencies on IRC_VARIABLE_COMP_ELEMENTS

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

Line 259: hr_utility.trace('ERROR Inserting IRC_VARIABLE_COMP_ELEMENTS records');

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

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

Line 544: hr_utility.trace('ERROR Updating IRC_VARIABLE_COMP_ELEMENTS records');

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

Line 2515: from irc_variable_comp_elements

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