APPS.IRC_SEARCH_CRITERIA_VALUES_UPG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

procedure update_criteria_values(
	  p_process_ctrl  IN varchar2,
	  p_start_pkid  IN  number,
	  p_end_pkid  IN  number,
	  p_rows_processed  OUT  nocopy  number)
is
	cursor cur_upd_search_criteria is
	  select search_criteria_id,
                 professional_area,
                 derived_location,
	         last_update_date,
	         last_updated_by,
	         last_update_login,
	         created_by,
	         creation_date
	  from irc_search_criteria
	  where search_criteria_id between p_start_pkid and p_end_pkid
                and object_type in ('WPREF','PERSON')
                and (derived_location is not null
                     or professional_area is not null);

Line: 30

          TYPE update_date_tbl  IS TABLE OF irc_search_criteria.last_update_date%TYPE;

Line: 31

          TYPE updated_by_tbl   IS TABLE OF irc_search_criteria.last_updated_by%TYPE;

Line: 32

          TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;

Line: 39

          l_update_date   update_date_tbl;

Line: 40

          l_updated_by    updated_by_tbl;

Line: 41

          l_update_login  update_login_tbl;

Line: 50

                l_update_date,
                l_updated_by,
                l_update_login,
                l_created_by,
                l_create_date;

Line: 61

	      insert into irc_prof_area_criteria_values
                (prof_area_criteria_value_id
                ,search_criteria_id
                ,professional_area
                ,last_update_date
                ,last_updated_by
                ,last_update_login
                ,created_by
                ,creation_date
                ,object_version_number
                )
                select irc_prof_area_criteria_value_s.nextval,
                        l_criteria_id(i),
                        l_prof_area(i),
                        l_update_date(i),
                        l_updated_by(i),
                        l_update_login(i),
                        l_created_by(i),
                        l_create_date(i),
                        1
                from dual where l_prof_area(i) is not null;

Line: 84

	      insert into irc_location_criteria_values
                (location_criteria_value_id
                ,search_criteria_id
                ,derived_locale
                ,last_update_date
                ,last_updated_by
                ,last_update_login
                ,created_by
                ,creation_date
                ,object_version_number
                )
                select irc_location_criteria_values_s.nextval,
                        l_criteria_id(i),
                        l_location(i),
                        l_update_date(i),
                        l_updated_by(i),
                        l_update_login(i),
                        l_created_by(i),
                        l_create_date(i),
                        1
                from dual where l_location(i) is not null;

Line: 106

          update irc_search_criteria
	    set professional_area = null, derived_location = null
	    where search_criteria_id between p_start_pkid and p_end_pkid
                  and object_type in ('WPREF','PERSON');

Line: 112

end update_criteria_values;