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 1080: delete from PAY_ELEMENT_TYPES_F_TL

1076: if p_delete_mode = 'ZAP' then
1077: --
1078: -- delete from MLS table (TL)
1079: --
1080: delete from PAY_ELEMENT_TYPES_F_TL
1081: where ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID;
1082: --
1083: if sql%notfound then -- trap system errors during deletion
1084: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1221: from PAY_ELEMENT_TYPES_F_TL

1217: select ELEMENT_NAME,
1218: REPORTING_NAME,
1219: DESCRIPTION,
1220: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1221: from PAY_ELEMENT_TYPES_F_TL
1222: where ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
1223: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1224: for update of ELEMENT_TYPE_ID nowait;
1225: --

Line 2458: pay_element_types_f_tl et_tl

2454: --
2455: cursor csr_duplicate is
2456: select null
2457: from pay_element_types_f et,
2458: pay_element_types_f_tl et_tl
2459: where upper(translate(p_element_name,'x_','x '))
2460: = upper(translate(et_tl.element_name,'x_','x '))
2461: and (et.element_type_id <> p_element_type_id
2462: or p_element_type_id is null)

Line 2582: delete from PAY_ELEMENT_TYPES_F_TL T

2578: -----------------------------------------------------------------------------
2579: procedure ADD_LANGUAGE
2580: is
2581: begin
2582: delete from PAY_ELEMENT_TYPES_F_TL T
2583: where not exists
2584: (select NULL
2585: from PAY_ELEMENT_TYPES_F B
2586: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID

Line 2589: update PAY_ELEMENT_TYPES_F_TL T set (

2585: from PAY_ELEMENT_TYPES_F B
2586: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
2587: );
2588:
2589: update PAY_ELEMENT_TYPES_F_TL T set (
2590: ELEMENT_NAME,
2591: REPORTING_NAME,
2592: DESCRIPTION
2593: ) = (select

Line 2597: from PAY_ELEMENT_TYPES_F_TL B

2593: ) = (select
2594: B.ELEMENT_NAME,
2595: B.REPORTING_NAME,
2596: B.DESCRIPTION
2597: from PAY_ELEMENT_TYPES_F_TL B
2598: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
2599: and B.LANGUAGE = T.SOURCE_LANG)
2600: where (
2601: T.ELEMENT_TYPE_ID,

Line 2606: from PAY_ELEMENT_TYPES_F_TL SUBB, PAY_ELEMENT_TYPES_F_TL SUBT

2602: T.LANGUAGE
2603: ) in (select
2604: SUBT.ELEMENT_TYPE_ID,
2605: SUBT.LANGUAGE
2606: from PAY_ELEMENT_TYPES_F_TL SUBB, PAY_ELEMENT_TYPES_F_TL SUBT
2607: where SUBB.ELEMENT_TYPE_ID = SUBT.ELEMENT_TYPE_ID
2608: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2609: and (SUBB.ELEMENT_NAME <> SUBT.ELEMENT_NAME
2610: or SUBB.REPORTING_NAME <> SUBT.REPORTING_NAME

Line 2618: insert into PAY_ELEMENT_TYPES_F_TL (

2614: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
2615: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
2616: ));
2617:
2618: insert into PAY_ELEMENT_TYPES_F_TL (
2619: ELEMENT_TYPE_ID,
2620: ELEMENT_NAME,
2621: REPORTING_NAME,
2622: DESCRIPTION,

Line 2642: from PAY_ELEMENT_TYPES_F_TL B, FND_LANGUAGES L

2638: B.CREATED_BY,
2639: B.CREATION_DATE,
2640: L.LANGUAGE_CODE,
2641: B.SOURCE_LANG
2642: from PAY_ELEMENT_TYPES_F_TL B, FND_LANGUAGES L
2643: where L.INSTALLED_FLAG in ('I', 'B')
2644: and B.LANGUAGE = userenv('LANG')
2645: and not exists
2646: (select NULL

Line 2647: from PAY_ELEMENT_TYPES_F_TL T

2643: where L.INSTALLED_FLAG in ('I', 'B')
2644: and B.LANGUAGE = userenv('LANG')
2645: and not exists
2646: (select NULL
2647: from PAY_ELEMENT_TYPES_F_TL T
2648: where T.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID
2649: and T.LANGUAGE = L.LANGUAGE_CODE);
2650: end ADD_LANGUAGE;
2651: -----------------------------------------------------------------------------

Line 2714: from pay_element_types_f_tl

2710: ,p_language in varchar2
2711: ) is
2712: select element_name
2713: , language
2714: from pay_element_types_f_tl
2715: where element_type_id = p_element_type_id
2716: and p_language in (language, source_lang)
2717: ;
2718: --

Line 2755: UPDATE pay_element_types_f_tl

2751: end if;
2752: end loop;
2753: end if;
2754:
2755: UPDATE pay_element_types_f_tl
2756: SET element_name = nvl(x_element_name,element_name),
2757: reporting_name = nvl(x_reporting_name,reporting_name),
2758: description = nvl(x_description,description),
2759: last_update_date = SYSDATE,