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.PQH_GENERIC dependencies on HR_API

Line 237: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and

233: for erec in c_all loop
234: hr_utility.set_location(' appl shrt nam :'||rec.application_short_name||'-'||erec.application_short_name, 53);
235: hr_utility.set_location(' Leg code :'||rec.legislation_code||'-'||erec.legislation_code, 54);
236: hr_utility.set_location(' Resp Key :'||rec.responsibility_key||'-'||erec.responsibility_key, 55);
237: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
238: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and
239: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then
240: --
241: p_function_type_cd := erec.function_type_cd ;

Line 238: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and

234: hr_utility.set_location(' appl shrt nam :'||rec.application_short_name||'-'||erec.application_short_name, 53);
235: hr_utility.set_location(' Leg code :'||rec.legislation_code||'-'||erec.legislation_code, 54);
236: hr_utility.set_location(' Resp Key :'||rec.responsibility_key||'-'||erec.responsibility_key, 55);
237: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
238: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and
239: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then
240: --
241: p_function_type_cd := erec.function_type_cd ;
242: p_pre_copy_function_name := erec.pre_copy_function_name ;

Line 239: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then

235: hr_utility.set_location(' Leg code :'||rec.legislation_code||'-'||erec.legislation_code, 54);
236: hr_utility.set_location(' Resp Key :'||rec.responsibility_key||'-'||erec.responsibility_key, 55);
237: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
238: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and
239: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then
240: --
241: p_function_type_cd := erec.function_type_cd ;
242: p_pre_copy_function_name := erec.pre_copy_function_name ;
243: p_copy_function_name := erec.copy_function_name ;

Line 250: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and

246: end if;
247: end loop;
248: --
249: for erec in c_all loop
250: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
251: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and
252: erec.responsibility_key is null then
253: --
254: p_function_type_cd := erec.function_type_cd ;

Line 251: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and

247: end loop;
248: --
249: for erec in c_all loop
250: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
251: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and
252: erec.responsibility_key is null then
253: --
254: p_function_type_cd := erec.function_type_cd ;
255: p_pre_copy_function_name := erec.pre_copy_function_name ;

Line 263: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and

259: end if;
260: end loop;
261: --
262: for erec in c_all loop
263: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
264: erec.legislation_code is null and
265: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then
266: --
267: p_function_type_cd := erec.function_type_cd ;

Line 265: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then

261: --
262: for erec in c_all loop
263: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
264: erec.legislation_code is null and
265: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then
266: --
267: p_function_type_cd := erec.function_type_cd ;
268: p_pre_copy_function_name := erec.pre_copy_function_name ;
269: p_copy_function_name := erec.copy_function_name ;

Line 276: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and

272: end if;
273: end loop;
274: --
275: for erec in c_all loop
276: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
277: erec.legislation_code is null and
278: erec.responsibility_key is null then
279: --
280: p_function_type_cd := erec.function_type_cd ;