APPS.IRC_VACANCY_COMMIT dependencies on IRC_REC_TEAM_MEMBERS

Line 277: hr_utility.trace('Inserting IRC_REC_TEAM_MEMBERS records');

273: errorFlag := true;
274: end if;
275: end loop;
276: --
277: hr_utility.trace('Inserting IRC_REC_TEAM_MEMBERS records');
278: --
279: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcRecTeamDisplayVORow');
280: --
281: for j in 1..xmldom.getLength(commitNodes) loop

Line 285: hr_utility.trace('ERROR Inserting IRC_REC_TEAM_MEMBERS records');

281: for j in 1..xmldom.getLength(commitNodes) loop
282: commitNode:=xmldom.item(commitNodes,j-1);
283: commit_i_rec_team_member(commitNode, l_return_status);
284: if (l_return_status <> 'S' and is_error_message) then
285: hr_utility.trace('ERROR Inserting IRC_REC_TEAM_MEMBERS records');
286: errorFlag := true;
287: end if;
288: end loop;
289: --

Line 570: hr_utility.trace('Updating IRC_REC_TEAM_MEMBERS records');

566: errorFlag := true;
567: end if;
568: end loop;
569: --
570: hr_utility.trace('Updating IRC_REC_TEAM_MEMBERS records');
571: --
572: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcRecTeamDisplayVORow');
573: --
574: for j in 1..xmldom.getLength(commitNodes) loop

Line 586: hr_utility.trace('ERROR Updating IRC_REC_TEAM_MEMBERS records');

582: commit_i_rec_team_member(commitNode, l_return_status);
583: end if;
584: end if;
585: if (l_return_status <> 'S' and is_error_message) then
586: hr_utility.trace('ERROR Updating IRC_REC_TEAM_MEMBERS records');
587: errorFlag := true;
588: end if;
589: end loop;
590: --

Line 1590: irc_rec_team_members_swi.create_rec_team_member (

1586: hr_utility.trace('Entering commit_i_rec_team_member');
1587: --
1588: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1589: --
1590: irc_rec_team_members_swi.create_rec_team_member (
1591: P_REC_TEAM_MEMBER_ID => valueOf(commitNode,'RecTeamMemberId')
1592: ,P_PERSON_ID => valueOf(commitNode,'PersonId')
1593: ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1594: ,P_JOB_ID => valueOf(commitNode,'JobId')

Line 1629: irc_rec_team_members_swi.delete_rec_team_member (

1625: hr_utility.trace('Entering commit_d_rec_team_member');
1626: --
1627: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1628: --
1629: irc_rec_team_members_swi.delete_rec_team_member (
1630: P_REC_TEAM_MEMBER_ID => valueOf(commitNode,'RecTeamMemberId')
1631: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1632: ,P_RETURN_STATUS => l_return_status
1633: ,P_VALIDATE => g_validate);

Line 1661: irc_rec_team_members_swi.update_rec_team_member (

1657: hr_utility.trace('Entering commit_u_rec_team_member');
1658: --
1659: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1660: --
1661: irc_rec_team_members_swi.update_rec_team_member (
1662: P_REC_TEAM_MEMBER_ID => valueOf(commitNode,'RecTeamMemberId')
1663: ,P_PERSON_ID => valueOf(commitNode,'PersonId')
1664: ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1665: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 2462: from irc_rec_team_members

2458: l_vacancy_id := valueOf(commitNode,'VacancyId');
2459: --
2460: select count(*)
2461: into l_row_count
2462: from irc_rec_team_members
2463: where party_id = l_party_id
2464: and vacancy_id = l_vacancy_id;
2465: --
2466: if (l_row_count = 0) then