APPS.IRC_ISC_UPDATE dependencies on IRC_SEARCH_CRITERIA

Line 19: from irc_search_criteria

15: -- entered by users in Work Preferences
16: --
17: cursor csr_keyword is
18: select keywords,search_criteria_id
19: from irc_search_criteria
20: where search_criteria_id between p_start_pkid and p_end_pkid
21: and object_type = 'WPREF'
22: and keywords is not null;
23: l_rows_processed number := 0;

Line 30: update irc_search_criteria

26: for l_data in csr_keyword
27: loop
28: if(irc_query_parser_pkg.isInvalidKeyword(l_data.keywords))
29: then
30: update irc_search_criteria
31: set keywords = ''
32: where search_criteria_id = l_data.search_criteria_id;
33: end if;
34: l_rows_processed := l_rows_processed + 1;