APPS.IRC_VACANCY_COMMIT dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 324: hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITY_FOR records');

320: errorFlag := true;
321: end if;
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

Line 332: hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITY_FOR records');

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;
334: end if;
335: end loop;
336: --

Line 612: hr_utility.trace('Deleting PER_RECRUITMENT_ACTIVITY_FOR records');

608: errorFlag := true;
609: end if;
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

Line 623: hr_utility.trace('ERROR Deleting PER_RECRUITMENT_ACTIVITY_FOR records');

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
623: hr_utility.trace('ERROR Deleting PER_RECRUITMENT_ACTIVITY_FOR records');
624: errorFlag := true;
625: end if;
626: end if;
627: --

Line 655: hr_utility.trace('Updating PER_RECRUITMENT_ACTIVITY_FOR records');

651: end if;
652: --
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

Line 670: hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITY_FOR records');

666: end if;
667: end if;
668: --
669: if (l_return_status <> 'S' and is_error_message) then
670: hr_utility.trace('ERROR Updating PER_RECRUITMENT_ACTIVITY_FOR records');
671: errorFlag := true;
672: end if;
673: end loop;
674: --

Line 2570: from per_recruitment_activity_for

2566: valueOf(commitNode,'RecruitmentActivityForId');
2567: --
2568: select count(*)
2569: into l_row_count
2570: from per_recruitment_activity_for
2571: where recruitment_activity_for_id = l_recruitment_activity_for_id;
2572: --
2573: if (l_row_count = 0) then
2574: hr_utility.trace('Exiting found_rec_activity_for returning FALSE');