APPS.IRC_VACANCY_COMMIT dependencies on IRC_SEARCH_CRITERIA

Line 238: hr_utility.trace('Inserting IRC_SEARCH_CRITERIA records');

234: errorFlag := true;
235: end if;
236: end loop;
237: --
238: hr_utility.trace('Inserting IRC_SEARCH_CRITERIA records');
239: --
240: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancySearchCriteriaVORow');
241: --
242: for j in 1..xmldom.getLength(commitNodes) loop

Line 246: hr_utility.trace('ERROR Inserting IRC_SEARCH_CRITERIA records');

242: for j in 1..xmldom.getLength(commitNodes) loop
243: commitNode:=xmldom.item(commitNodes,j-1);
244: commit_i_search_criteria(commitNode, l_effective_date, l_return_status);
245: if (l_return_status <> 'S' and is_error_message) then
246: hr_utility.trace('ERROR Inserting IRC_SEARCH_CRITERIA records');
247: errorFlag := true;
248: end if;
249: end loop;
250: --

Line 513: hr_utility.trace('Updating IRC_SEARCH_CRITERIA records');

509: errorFlag := true;
510: end if;
511: end loop;
512: --
513: hr_utility.trace('Updating IRC_SEARCH_CRITERIA records');
514: --
515: commitNodes := xmldom.getElementsByTagName(xmldoc, 'IrcVacancySearchCriteriaVORow');
516: --
517: for j in 1..xmldom.getLength(commitNodes) loop

Line 525: hr_utility.trace('ERROR Updating IRC_SEARCH_CRITERIA records');

521: else
522: commit_i_search_criteria(commitNode, l_effective_date, l_return_status);
523: end if;
524: if (l_return_status <> 'S' and is_error_message) then
525: hr_utility.trace('ERROR Updating IRC_SEARCH_CRITERIA records');
526: errorFlag := true;
527: end if;
528: end loop;
529: --

Line 1065: irc_search_criteria_swi.create_vacancy_criteria (

1061: hr_utility.trace('Entering commit_i_search_criteria');
1062: --
1063: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1064: --
1065: irc_search_criteria_swi.create_vacancy_criteria (
1066: P_VACANCY_ID => valueOf(commitNode,'ObjectId')
1067: ,P_EFFECTIVE_DATE => l_effective_date
1068: ,P_LOCATION => valueOf(commitNode,'Location')
1069: ,P_EMPLOYEE => valueOf(commitNode,'Employee')

Line 1178: irc_search_criteria_swi.delete_vacancy_criteria (

1174: hr_utility.trace('Entering commit_d_search_criteria');
1175: --
1176: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1177: --
1178: irc_search_criteria_swi.delete_vacancy_criteria (
1179: P_SEARCH_CRITERIA_ID => valueOf(commitNode,'SearchCriteriaId')
1180: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1181: ,P_RETURN_STATUS => l_return_status
1182: ,P_VALIDATE => g_validate);

Line 1213: irc_search_criteria_swi.update_vacancy_criteria (

1209: hr_utility.trace('Entering commit_u_search_criteria');
1210: --
1211: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1212: --
1213: irc_search_criteria_swi.update_vacancy_criteria (
1214: P_VACANCY_ID => valueOf(commitNode,'ObjectId')
1215: ,P_EFFECTIVE_DATE => l_effective_date
1216: ,P_LOCATION => valueOf(commitNode,'Location')
1217: ,P_EMPLOYEE => valueOf(commitNode,'Employee')

Line 2597: from irc_search_criteria

2593: valueOf(commitNode,'SearchCriteriaId');
2594: --
2595: select count(*)
2596: into l_row_count
2597: from irc_search_criteria
2598: where search_criteria_id = l_search_criteria_id;
2599: --
2600: if (l_row_count = 0) then
2601: hr_utility.trace('Exiting found_IrcSearchCriteria returning FALSE');