eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_SEARCH_CRITERIA_VALUES_UPG dependencies on IRC_SEARCH_CRITERIA

Line 1: PACKAGE BODY irc_search_criteria_values_upg AS

1: PACKAGE BODY irc_search_criteria_values_upg AS
2: /* $Header: irscvupg.pkb 120.1 2005/10/20 20:03 gjaggava noship $ */
3: -- ----------------------------------------------------------------------------
4: -- |--------------------------< update_criteria_values>-----------------------|
5: -- ----------------------------------------------------------------------------

Line 21: from irc_search_criteria

17: last_updated_by,
18: last_update_login,
19: created_by,
20: creation_date
21: from irc_search_criteria
22: where search_criteria_id between p_start_pkid and p_end_pkid
23: and object_type in ('WPREF','PERSON')
24: and (derived_location is not null
25: or professional_area is not null);

Line 27: TYPE criteria_id_tbl IS TABLE OF irc_search_criteria.search_criteria_id%TYPE;

23: and object_type in ('WPREF','PERSON')
24: and (derived_location is not null
25: or professional_area is not null);
26: --
27: TYPE criteria_id_tbl IS TABLE OF irc_search_criteria.search_criteria_id%TYPE;
28: TYPE prof_area_tbl IS TABLE OF irc_search_criteria.professional_area%TYPE;
29: TYPE location_tbl IS TABLE OF irc_search_criteria.derived_location%TYPE;
30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;
31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;

Line 28: TYPE prof_area_tbl IS TABLE OF irc_search_criteria.professional_area%TYPE;

24: and (derived_location is not null
25: or professional_area is not null);
26: --
27: TYPE criteria_id_tbl IS TABLE OF irc_search_criteria.search_criteria_id%TYPE;
28: TYPE prof_area_tbl IS TABLE OF irc_search_criteria.professional_area%TYPE;
29: TYPE location_tbl IS TABLE OF irc_search_criteria.derived_location%TYPE;
30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;
31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;
32: TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;

Line 29: TYPE location_tbl IS TABLE OF irc_search_criteria.derived_location%TYPE;

25: or professional_area is not null);
26: --
27: TYPE criteria_id_tbl IS TABLE OF irc_search_criteria.search_criteria_id%TYPE;
28: TYPE prof_area_tbl IS TABLE OF irc_search_criteria.professional_area%TYPE;
29: TYPE location_tbl IS TABLE OF irc_search_criteria.derived_location%TYPE;
30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;
31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;
32: TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;
33: TYPE created_by_tbl IS TABLE OF irc_search_criteria.created_by%TYPE;

Line 30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;

26: --
27: TYPE criteria_id_tbl IS TABLE OF irc_search_criteria.search_criteria_id%TYPE;
28: TYPE prof_area_tbl IS TABLE OF irc_search_criteria.professional_area%TYPE;
29: TYPE location_tbl IS TABLE OF irc_search_criteria.derived_location%TYPE;
30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;
31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;
32: TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;
33: TYPE created_by_tbl IS TABLE OF irc_search_criteria.created_by%TYPE;
34: TYPE create_date_tbl IS TABLE OF irc_search_criteria.creation_date%TYPE;

Line 31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;

27: TYPE criteria_id_tbl IS TABLE OF irc_search_criteria.search_criteria_id%TYPE;
28: TYPE prof_area_tbl IS TABLE OF irc_search_criteria.professional_area%TYPE;
29: TYPE location_tbl IS TABLE OF irc_search_criteria.derived_location%TYPE;
30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;
31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;
32: TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;
33: TYPE created_by_tbl IS TABLE OF irc_search_criteria.created_by%TYPE;
34: TYPE create_date_tbl IS TABLE OF irc_search_criteria.creation_date%TYPE;
35: --

Line 32: TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;

28: TYPE prof_area_tbl IS TABLE OF irc_search_criteria.professional_area%TYPE;
29: TYPE location_tbl IS TABLE OF irc_search_criteria.derived_location%TYPE;
30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;
31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;
32: TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;
33: TYPE created_by_tbl IS TABLE OF irc_search_criteria.created_by%TYPE;
34: TYPE create_date_tbl IS TABLE OF irc_search_criteria.creation_date%TYPE;
35: --
36: l_criteria_id criteria_id_tbl;

Line 33: TYPE created_by_tbl IS TABLE OF irc_search_criteria.created_by%TYPE;

29: TYPE location_tbl IS TABLE OF irc_search_criteria.derived_location%TYPE;
30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;
31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;
32: TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;
33: TYPE created_by_tbl IS TABLE OF irc_search_criteria.created_by%TYPE;
34: TYPE create_date_tbl IS TABLE OF irc_search_criteria.creation_date%TYPE;
35: --
36: l_criteria_id criteria_id_tbl;
37: l_prof_area prof_area_tbl;

Line 34: TYPE create_date_tbl IS TABLE OF irc_search_criteria.creation_date%TYPE;

30: TYPE update_date_tbl IS TABLE OF irc_search_criteria.last_update_date%TYPE;
31: TYPE updated_by_tbl IS TABLE OF irc_search_criteria.last_updated_by%TYPE;
32: TYPE update_login_tbl IS TABLE OF irc_search_criteria.last_update_login%TYPE;
33: TYPE created_by_tbl IS TABLE OF irc_search_criteria.created_by%TYPE;
34: TYPE create_date_tbl IS TABLE OF irc_search_criteria.creation_date%TYPE;
35: --
36: l_criteria_id criteria_id_tbl;
37: l_prof_area prof_area_tbl;
38: l_location location_tbl;

Line 106: update irc_search_criteria

102: l_create_date(i),
103: 1
104: from dual where l_location(i) is not null;
105: --
106: update irc_search_criteria
107: set professional_area = null, derived_location = null
108: where search_criteria_id between p_start_pkid and p_end_pkid
109: and object_type in ('WPREF','PERSON');
110: END IF;

Line 114: end irc_search_criteria_values_upg;

110: END IF;
111: --
112: end update_criteria_values;
113: --
114: end irc_search_criteria_values_upg;