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.HXT_INTERFACE_UTILITIES dependencies on HR_LOOKUPS

Line 2505: p_iv_name IN hr_lookups.meaning%TYPE,

2501: end if;
2502: END convert_attr_to_costsegment;
2503:
2504: FUNCTION translated_iv (
2505: p_iv_name IN hr_lookups.meaning%TYPE,
2506: p_date_active IN hr_lookups.start_date_active%TYPE
2507: )
2508: RETURN hr_lookups.lookup_code%TYPE
2509: IS

Line 2506: p_date_active IN hr_lookups.start_date_active%TYPE

2502: END convert_attr_to_costsegment;
2503:
2504: FUNCTION translated_iv (
2505: p_iv_name IN hr_lookups.meaning%TYPE,
2506: p_date_active IN hr_lookups.start_date_active%TYPE
2507: )
2508: RETURN hr_lookups.lookup_code%TYPE
2509: IS
2510: l_proc proc_name ;

Line 2508: RETURN hr_lookups.lookup_code%TYPE

2504: FUNCTION translated_iv (
2505: p_iv_name IN hr_lookups.meaning%TYPE,
2506: p_date_active IN hr_lookups.start_date_active%TYPE
2507: )
2508: RETURN hr_lookups.lookup_code%TYPE
2509: IS
2510: l_proc proc_name ;
2511:
2512: -- Bug 14081101

Line 2514: -- instead of hr_lookups

2510: l_proc proc_name ;
2511:
2512: -- Bug 14081101
2513: -- Modified the below cursor to look from fnd_lookup_values
2514: -- instead of hr_lookups
2515: /*
2516: CURSOR csr_translated_info (
2517: p_meaning hr_lookups.meaning%TYPE,
2518: p_date_active hr_lookups.start_date_active%TYPE

Line 2517: p_meaning hr_lookups.meaning%TYPE,

2513: -- Modified the below cursor to look from fnd_lookup_values
2514: -- instead of hr_lookups
2515: /*
2516: CURSOR csr_translated_info (
2517: p_meaning hr_lookups.meaning%TYPE,
2518: p_date_active hr_lookups.start_date_active%TYPE
2519: )
2520: IS
2521: SELECT lookup_code, start_date_active, end_date_active

Line 2518: p_date_active hr_lookups.start_date_active%TYPE

2514: -- instead of hr_lookups
2515: /*
2516: CURSOR csr_translated_info (
2517: p_meaning hr_lookups.meaning%TYPE,
2518: p_date_active hr_lookups.start_date_active%TYPE
2519: )
2520: IS
2521: SELECT lookup_code, start_date_active, end_date_active
2522: FROM hr_lookups

Line 2522: FROM hr_lookups

2518: p_date_active hr_lookups.start_date_active%TYPE
2519: )
2520: IS
2521: SELECT lookup_code, start_date_active, end_date_active
2522: FROM hr_lookups
2523: WHERE meaning = p_meaning
2524: AND lookup_type = g_element_iv_translations
2525: AND application_id = g_per_app_id
2526: AND enabled_flag = g_lookup_enabled

Line 2532: p_meaning hr_lookups.meaning%TYPE,

2528: AND NVL (end_date_active, p_date_active);
2529: */
2530:
2531: CURSOR csr_translated_info (
2532: p_meaning hr_lookups.meaning%TYPE,
2533: p_date_active hr_lookups.start_date_active%TYPE
2534: )
2535: IS
2536: SELECT lookup_code, start_date_active, end_date_active

Line 2533: p_date_active hr_lookups.start_date_active%TYPE

2529: */
2530:
2531: CURSOR csr_translated_info (
2532: p_meaning hr_lookups.meaning%TYPE,
2533: p_date_active hr_lookups.start_date_active%TYPE
2534: )
2535: IS
2536: SELECT lookup_code, start_date_active, end_date_active
2537: FROM fnd_lookup_values

Line 2547: l_translated_iv hr_lookups.lookup_code%TYPE;

2543: AND NVL (end_date_active, p_date_active);
2544:
2545:
2546: l_translated_info csr_translated_info%ROWTYPE;
2547: l_translated_iv hr_lookups.lookup_code%TYPE;
2548: l_hashed_id PLS_INTEGER;
2549: l_found_in_cache BOOLEAN := FALSE;
2550: BEGIN
2551: g_debug :=hr_utility.debug_enabled;