APPS.IRC_MDS_MIGRATION dependencies on IRC_SEARCH_CRITERIA

Line 16: from ak_customizations_tl ac, irc_search_criteria isc

12: is
13:
14: cursor csr_ak_customizations is
15: select SEARCH_CRITERIA_ID, name
16: from ak_customizations_tl ac, irc_search_criteria isc
17: where region_code = 'IRC_APPL_JOB_SEARCH_TBL'
18: and region_application_id = 800
19: and ac.customization_code = isc.search_name
20: and isc.SEARCH_CRITERIA_ID between p_start_pkid

Line 30: ** For each customization record which is stored in IRC_SEARCH_CRITERIA

26:
27: begin
28:
29: /*
30: ** For each customization record which is stored in IRC_SEARCH_CRITERIA
31: ** update the search_name.
32: */
33: for c_cust in csr_ak_customizations loop
34:

Line 44: update irc_search_criteria

40:
41: /*
42: ** Update the Search Criteria
43: */
44: update irc_search_criteria
45: set SEARCH_NAME = l_current_name
46: where SEARCH_CRITERIA_ID = l_current_id;
47:
48: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;

Line 88: from irc_search_criteria isc

84: order by inp_person_id,addtype ;
85: --
86: cursor csr_work_choices(p_person_id number) is
87: select null
88: from irc_search_criteria isc
89: where isc.object_id = p_person_id
90: and isc.object_type in ('WORK','WPREF');
91: --
92: l_rows_processed number := 0;

Line 101: ** insert a record in IRC_SEARCH_CRITERIA.

97: begin
98: --
99: /*
100: ** For each personid record in IRC_NOTIFICATION_PREFERENCES ,
101: ** insert a record in IRC_SEARCH_CRITERIA.
102: */
103: --
104: for c_notifs in csr_irc_notifications loop
105: /*

Line 119: irc_search_criteria_api.create_work_choices (

115: close csr_work_choices;
116: /*
117: ** insert the work preferences in Search Criteria
118: */
119: irc_search_criteria_api.create_work_choices (
120: p_effective_date => trunc(sysdate)
121: ,p_person_id => c_notifs.inp_person_id
122: ,p_employee => 'Y'
123: ,p_contractor => 'Y'