APPS.IRC_LCV_BUS dependencies on IRC_SEARCH_CRITERIA

Line 144: -- IRC_SEARCH_CRITERIA

140: -- {Start Of Comments}
141: --
142: -- Description:
143: -- This procedure is used to ensure that search criteria id exists in
144: -- IRC_SEARCH_CRITERIA
145: --
146: -- Pre Conditions:
147: --
148: -- In Arguments:

Line 167: select null from irc_search_criteria isc

163: l_proc varchar2(72) := g_package || 'chk_search_criteria_id';
164: l_search_criteria_id varchar2(1);
165: --
166: cursor csr_search_criteria is
167: select null from irc_search_criteria isc
168: where isc.search_criteria_id = p_search_criteria_id;
169: --
170: begin
171: hr_utility.set_location('Entering:'||l_proc,10);

Line 178: -- Check that search_criteria_id exists in irc_search_criteria.

174: (p_api_name => l_proc
175: ,p_argument => 'SEARCH_CRITERIA_ID'
176: ,p_argument_value => p_search_criteria_id
177: );
178: -- Check that search_criteria_id exists in irc_search_criteria.
179: hr_utility.set_location(l_proc,20);
180: if p_search_criteria_id is not null then
181: -- Check that search_criteria_id exists in irc_search_criteria.
182: hr_utility.set_location(l_proc,30);

Line 181: -- Check that search_criteria_id exists in irc_search_criteria.

177: );
178: -- Check that search_criteria_id exists in irc_search_criteria.
179: hr_utility.set_location(l_proc,20);
180: if p_search_criteria_id is not null then
181: -- Check that search_criteria_id exists in irc_search_criteria.
182: hr_utility.set_location(l_proc,30);
183: open csr_search_criteria;
184: fetch csr_search_criteria into l_search_criteria_id;
185: hr_utility.set_location(l_proc,40);