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.

[Home] [Help]

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: CURSOR csr_translated_info (

Line 2513: p_meaning hr_lookups.meaning%TYPE,

2509: IS
2510: l_proc proc_name ;
2511:
2512: CURSOR csr_translated_info (
2513: p_meaning hr_lookups.meaning%TYPE,
2514: p_date_active hr_lookups.start_date_active%TYPE
2515: )
2516: IS
2517: SELECT lookup_code, start_date_active, end_date_active

Line 2514: p_date_active hr_lookups.start_date_active%TYPE

2510: l_proc proc_name ;
2511:
2512: CURSOR csr_translated_info (
2513: p_meaning hr_lookups.meaning%TYPE,
2514: p_date_active hr_lookups.start_date_active%TYPE
2515: )
2516: IS
2517: SELECT lookup_code, start_date_active, end_date_active
2518: FROM hr_lookups

Line 2518: FROM hr_lookups

2514: p_date_active hr_lookups.start_date_active%TYPE
2515: )
2516: IS
2517: SELECT lookup_code, start_date_active, end_date_active
2518: FROM hr_lookups
2519: WHERE meaning = p_meaning
2520: AND lookup_type = g_element_iv_translations
2521: AND application_id = g_per_app_id
2522: AND enabled_flag = g_lookup_enabled

Line 2527: l_translated_iv hr_lookups.lookup_code%TYPE;

2523: AND p_date_active BETWEEN NVL (start_date_active, p_date_active)
2524: AND NVL (end_date_active, p_date_active);
2525:
2526: l_translated_info csr_translated_info%ROWTYPE;
2527: l_translated_iv hr_lookups.lookup_code%TYPE;
2528: l_hashed_id PLS_INTEGER;
2529: l_found_in_cache BOOLEAN := FALSE;
2530: BEGIN
2531: g_debug :=hr_utility.debug_enabled;