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.PAY_ELEMENT_TYPES_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 76: FROM pay_element_types_f_tl ettl,

72: cursor c_translation(p_language IN VARCHAR2,
73: p_element_name IN VARCHAR2,
74: p_element_type_id IN NUMBER) IS
75: SELECT 1
76: FROM pay_element_types_f_tl ettl,
77: pay_element_types_f et
78: WHERE upper(translate(ettl.element_name,'x_','x '))
79: = upper(translate(p_element_name,'x_','x '))
80: AND ettl.element_type_id = et.element_type_id

Line 544: insert into PAY_ELEMENT_TYPES_F_TL (

540: --
541: -- **************************************************************************
542: -- insert into MLS table (TL)
543: --
544: insert into PAY_ELEMENT_TYPES_F_TL (
545: ELEMENT_TYPE_ID,
546: ELEMENT_NAME,
547: REPORTING_NAME,
548: DESCRIPTION,

Line 572: from PAY_ELEMENT_TYPES_F_TL T

568: from FND_LANGUAGES L
569: where L.INSTALLED_FLAG in ('I', 'B')
570: and not exists
571: (select NULL
572: from PAY_ELEMENT_TYPES_F_TL T
573: where T.ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
574: and T.LANGUAGE = L.LANGUAGE_CODE);
575: --
576: --

Line 936: update PAY_ELEMENT_TYPES_F_TL

932: -- ****************************************************************************************
933: --
934: -- update MLS table (TL)
935: --
936: update PAY_ELEMENT_TYPES_F_TL
937: set
938: ELEMENT_NAME = P_ELEMENT_NAME,
939: REPORTING_NAME = P_REPORTING_NAME,
940: DESCRIPTION = P_DESCRIPTION,

Line 1085: delete from PAY_ELEMENT_TYPES_F_TL

1081: if p_delete_mode = 'ZAP' then
1082: --
1083: -- delete from MLS table (TL)
1084: --
1085: delete from PAY_ELEMENT_TYPES_F_TL
1086: where ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID;
1087: --
1088: if sql%notfound then -- trap system errors during deletion
1089: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1226: from PAY_ELEMENT_TYPES_F_TL

1222: select ELEMENT_NAME,
1223: REPORTING_NAME,
1224: DESCRIPTION,
1225: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1226: from PAY_ELEMENT_TYPES_F_TL
1227: where ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
1228: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1229: for update of ELEMENT_TYPE_ID nowait;
1230: --

Line 2491: pay_element_types_f_tl et_tl

2487: --
2488: cursor csr_duplicate is
2489: select null
2490: from pay_element_types_f et,
2491: pay_element_types_f_tl et_tl
2492: where upper(translate(p_element_name,'x_','x '))
2493: = upper(translate(et_tl.element_name,'x_','x '))
2494: and (et.element_type_id <> p_element_type_id
2495: or p_element_type_id is null)

Line 2615: delete from PAY_ELEMENT_TYPES_F_TL T

2611: -----------------------------------------------------------------------------
2612: procedure ADD_LANGUAGE
2613: is
2614: begin
2615: delete from PAY_ELEMENT_TYPES_F_TL T
2616: where not exists
2617: (select NULL
2618: from PAY_ELEMENT_TYPES_F B
2619: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID

Line 2622: update PAY_ELEMENT_TYPES_F_TL T set (

2618: from PAY_ELEMENT_TYPES_F B
2619: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
2620: );
2621:
2622: update PAY_ELEMENT_TYPES_F_TL T set (
2623: ELEMENT_NAME,
2624: REPORTING_NAME,
2625: DESCRIPTION
2626: ) = (select

Line 2630: from PAY_ELEMENT_TYPES_F_TL B

2626: ) = (select
2627: B.ELEMENT_NAME,
2628: B.REPORTING_NAME,
2629: B.DESCRIPTION
2630: from PAY_ELEMENT_TYPES_F_TL B
2631: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
2632: and B.LANGUAGE = T.SOURCE_LANG)
2633: where (
2634: T.ELEMENT_TYPE_ID,

Line 2639: from PAY_ELEMENT_TYPES_F_TL SUBB, PAY_ELEMENT_TYPES_F_TL SUBT

2635: T.LANGUAGE
2636: ) in (select
2637: SUBT.ELEMENT_TYPE_ID,
2638: SUBT.LANGUAGE
2639: from PAY_ELEMENT_TYPES_F_TL SUBB, PAY_ELEMENT_TYPES_F_TL SUBT
2640: where SUBB.ELEMENT_TYPE_ID = SUBT.ELEMENT_TYPE_ID
2641: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2642: and (SUBB.ELEMENT_NAME <> SUBT.ELEMENT_NAME
2643: or SUBB.REPORTING_NAME <> SUBT.REPORTING_NAME

Line 2651: insert into PAY_ELEMENT_TYPES_F_TL (

2647: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
2648: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
2649: ));
2650:
2651: insert into PAY_ELEMENT_TYPES_F_TL (
2652: ELEMENT_TYPE_ID,
2653: ELEMENT_NAME,
2654: REPORTING_NAME,
2655: DESCRIPTION,

Line 2675: from PAY_ELEMENT_TYPES_F_TL B, FND_LANGUAGES L

2671: B.CREATED_BY,
2672: B.CREATION_DATE,
2673: L.LANGUAGE_CODE,
2674: B.SOURCE_LANG
2675: from PAY_ELEMENT_TYPES_F_TL B, FND_LANGUAGES L
2676: where L.INSTALLED_FLAG in ('I', 'B')
2677: and B.LANGUAGE = userenv('LANG')
2678: and not exists
2679: (select NULL

Line 2680: from PAY_ELEMENT_TYPES_F_TL T

2676: where L.INSTALLED_FLAG in ('I', 'B')
2677: and B.LANGUAGE = userenv('LANG')
2678: and not exists
2679: (select NULL
2680: from PAY_ELEMENT_TYPES_F_TL T
2681: where T.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID
2682: and T.LANGUAGE = L.LANGUAGE_CODE);
2683: end ADD_LANGUAGE;
2684: -----------------------------------------------------------------------------

Line 2747: from pay_element_types_f_tl

2743: ,p_language in varchar2
2744: ) is
2745: select element_name
2746: , language
2747: from pay_element_types_f_tl
2748: where element_type_id = p_element_type_id
2749: and p_language in (language, source_lang)
2750: ;
2751: --

Line 2788: UPDATE pay_element_types_f_tl

2784: end if;
2785: end loop;
2786: end if;
2787:
2788: UPDATE pay_element_types_f_tl
2789: SET element_name = nvl(x_element_name,element_name),
2790: reporting_name = nvl(x_reporting_name,reporting_name),
2791: description = nvl(x_description,description),
2792: last_update_date = SYSDATE,