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_ILP_BUS dependencies on IRC_LOCATION_PREFERENCES

Line 39: (p_business_group_id in irc_location_preferences.business_group_id%TYPE

35: --
36: -- {End Of Comments}
37: -- ----------------------------------------------------------------------------
38: Procedure chk_business_group_id
39: (p_business_group_id in irc_location_preferences.business_group_id%TYPE
40: )
41: IS
42: --
43: l_proc varchar2(72) := g_package || 'chk_business_group_id';

Line 44: l_business_group_id irc_location_preferences.business_group_id%TYPE;

40: )
41: IS
42: --
43: l_proc varchar2(72) := g_package || 'chk_business_group_id';
44: l_business_group_id irc_location_preferences.business_group_id%TYPE;
45: --
46: cursor csr_chk_bg_id is
47: select 1
48: from per_business_groups

Line 76: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.BUSINESS_GROUP_ID'

72: hr_utility.set_location(' Leaving:'||l_proc,20);
73: exception
74: when app_exception.application_exception then
75: if hr_multi_message.exception_add
76: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.BUSINESS_GROUP_ID'
77: ) then
78: hr_utility.set_location(' Leaving:'|| l_proc, 25);
79: raise;
80: end if;

Line 108: (p_country_code in irc_location_preferences.country_code%TYPE

104: --
105: -- {End Of Comments}
106: -- ----------------------------------------------------------------------------
107: Procedure chk_country_code
108: (p_country_code in irc_location_preferences.country_code%TYPE
109: )
110: IS
111: --
112: l_proc varchar2(72) := g_package || 'chk_country_code';

Line 113: l_country_code irc_location_preferences.country_code%TYPE;

109: )
110: IS
111: --
112: l_proc varchar2(72) := g_package || 'chk_country_code';
113: l_country_code irc_location_preferences.country_code%TYPE;
114: --
115: cursor csr_chk_country_code is
116: select 1
117: from fnd_territories

Line 145: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.COUNTRY_CODE'

141: hr_utility.set_location(' Leaving:'||l_proc,20);
142: exception
143: when app_exception.application_exception then
144: if hr_multi_message.exception_add
145: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.COUNTRY_CODE'
146: ) then
147: hr_utility.set_location(' Leaving:'|| l_proc, 25);
148: raise;
149: end if;

Line 177: (p_location_id in irc_location_preferences.location_id%TYPE

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure chk_location_id
177: (p_location_id in irc_location_preferences.location_id%TYPE
178: )
179: IS
180: --
181: l_proc varchar2(72) := g_package || 'chk_location_id';

Line 182: l_location_id irc_location_preferences.location_id%TYPE;

178: )
179: IS
180: --
181: l_proc varchar2(72) := g_package || 'chk_location_id';
182: l_location_id irc_location_preferences.location_id%TYPE;
183: --
184: cursor csr_chk_loc_id is
185: select 1
186: from hr_locations_all

Line 214: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.LOCATION_ID'

210: hr_utility.set_location(' Leaving:'||l_proc,20);
211: exception
212: when app_exception.application_exception then
213: if hr_multi_message.exception_add
214: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.LOCATION_ID'
215: ) then
216: hr_utility.set_location(' Leaving:'|| l_proc, 25);
217: raise;
218: end if;

Line 250: (p_object_id in irc_location_preferences.object_id%TYPE

246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure chk_duplicate_loc_pref
250: (p_object_id in irc_location_preferences.object_id%TYPE
251: ,p_object_type in irc_location_preferences.object_type%TYPE
252: ,p_business_group_id in irc_location_preferences.business_group_id%TYPE
253: ,p_country_code in irc_location_preferences.country_code%TYPE
254: ,p_location_id in irc_location_preferences.location_id%TYPE

Line 251: ,p_object_type in irc_location_preferences.object_type%TYPE

247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure chk_duplicate_loc_pref
250: (p_object_id in irc_location_preferences.object_id%TYPE
251: ,p_object_type in irc_location_preferences.object_type%TYPE
252: ,p_business_group_id in irc_location_preferences.business_group_id%TYPE
253: ,p_country_code in irc_location_preferences.country_code%TYPE
254: ,p_location_id in irc_location_preferences.location_id%TYPE
255: )

Line 252: ,p_business_group_id in irc_location_preferences.business_group_id%TYPE

248: -- ----------------------------------------------------------------------------
249: Procedure chk_duplicate_loc_pref
250: (p_object_id in irc_location_preferences.object_id%TYPE
251: ,p_object_type in irc_location_preferences.object_type%TYPE
252: ,p_business_group_id in irc_location_preferences.business_group_id%TYPE
253: ,p_country_code in irc_location_preferences.country_code%TYPE
254: ,p_location_id in irc_location_preferences.location_id%TYPE
255: )
256: IS

Line 253: ,p_country_code in irc_location_preferences.country_code%TYPE

249: Procedure chk_duplicate_loc_pref
250: (p_object_id in irc_location_preferences.object_id%TYPE
251: ,p_object_type in irc_location_preferences.object_type%TYPE
252: ,p_business_group_id in irc_location_preferences.business_group_id%TYPE
253: ,p_country_code in irc_location_preferences.country_code%TYPE
254: ,p_location_id in irc_location_preferences.location_id%TYPE
255: )
256: IS
257: --

Line 254: ,p_location_id in irc_location_preferences.location_id%TYPE

250: (p_object_id in irc_location_preferences.object_id%TYPE
251: ,p_object_type in irc_location_preferences.object_type%TYPE
252: ,p_business_group_id in irc_location_preferences.business_group_id%TYPE
253: ,p_country_code in irc_location_preferences.country_code%TYPE
254: ,p_location_id in irc_location_preferences.location_id%TYPE
255: )
256: IS
257: --
258: l_proc varchar2(72) := g_package || 'chk_duplicate_loc_pref';

Line 263: from irc_location_preferences

259: l_count number;
260: --
261: cursor csr_chk_duplicate_loc_pref is
262: select 1
263: from irc_location_preferences
264: where object_id = p_object_id
265: and object_type = p_object_type
266: and business_group_id = p_business_group_id
267: and country_code = p_country_code

Line 289: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.OBJECT_ID'

285: hr_utility.set_location(' Leaving:'||l_proc,20);
286: exception
287: when app_exception.application_exception then
288: if hr_multi_message.exception_add
289: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.OBJECT_ID'
290: ,p_associated_column2 => 'IRC_LOCATION_PREFERENCES.OBJECT_TYPE'
291: ) then
292: hr_utility.set_location(' Leaving:'|| l_proc, 25);
293: raise;

Line 290: ,p_associated_column2 => 'IRC_LOCATION_PREFERENCES.OBJECT_TYPE'

286: exception
287: when app_exception.application_exception then
288: if hr_multi_message.exception_add
289: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.OBJECT_ID'
290: ,p_associated_column2 => 'IRC_LOCATION_PREFERENCES.OBJECT_TYPE'
291: ) then
292: hr_utility.set_location(' Leaving:'|| l_proc, 25);
293: raise;
294: end if;