APPS.IRC_VACANCY_COMMIT dependencies on IRC_POSTING_CONTENTS

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

Line 220: hr_utility.trace('ERROR Inserting IRC_POSTING_CONTENTS records');

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

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

Line 495: hr_utility.trace('ERROR Updating IRC_POSTING_CONTENTS records');

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

Line 2624: from irc_posting_contents

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