APPS.IRC_VACANCY_COMMIT dependencies on PER_RECRUITMENT_ACTIVITIES

Line 303: hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITIES 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);

Line 319: hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITIES records');

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

Line 630: hr_utility.trace('Updating PER_RECRUITMENT_ACTIVITIES records');

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

Line 649: hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITIES records');

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;

Line 2543: from per_recruitment_activities

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