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

Line 8: c_base_table constant varchar2(30) := 'PAY_ELEMENT_TYPES_F';

4: --------------------------------------------------------------------------------
5: -- Declaration of package-wide (global) variables and cursors
6: --
7: -- Constant for name of table being manipulated (useful for generic code)
8: c_base_table constant varchar2(30) := 'PAY_ELEMENT_TYPES_F';
9: --
10: c_user_id number;
11: c_login_id number;
12: --

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 77: pay_element_types_f et

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
81: AND ettl.language = p_language

Line 333: from pay_element_types_f

329: -- Returns the system-generated columns for return to the
330: -- form, and for use in cascading action
331: --
332: select rowid
333: from pay_element_types_f
334: where element_type_id = p_element_type_id
335: and effective_start_date = p_effective_start_date;
336: --
337: --

Line 346: insert into pay_element_types_f ( element_type_id,

342: open csr_new_id;
343: fetch csr_new_id into p_element_type_id;
344: close csr_new_id;
345: --
346: insert into pay_element_types_f ( element_type_id,
347: effective_start_date,
348: effective_end_date,
349: business_group_id,
350: legislation_code,

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 827: update pay_element_types_f

823: begin
824: --
825: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.UPDATE_ROW',1);
826: --
827: update pay_element_types_f
828: set
829: element_type_id = p_element_type_id,
830: effective_start_date = p_effective_start_date,
831: effective_end_date = p_effective_end_date,

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 1062: from pay_element_types_f

1058: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DELETE_ROW',5);
1059: --
1060: -- Delete the element itself
1061: delete
1062: from pay_element_types_f
1063: where rowid = p_rowid;
1064: --
1065: if sql%notfound then -- trap system errors during deletion
1066: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

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 1207: from pay_element_types_f

1203: ) is
1204: --
1205: cursor csr_element_type is
1206: select *
1207: from pay_element_types_f
1208: where rowid = p_rowid
1209: for update of element_type_id nowait;
1210: --
1211: element_record csr_element_type%rowtype;

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 1233: l_time_definition_type pay_element_types_f.time_definition_type%type;

1229: --
1230: l_count NUMBER := 0;
1231: --
1232: -- Bug 6411503. l_time_definition_type added. If it is N then it will be changed to NULL
1233: l_time_definition_type pay_element_types_f.time_definition_type%type;
1234: --
1235: begin
1236: --
1237: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.LOCK_ROW',10);

Line 1520: from pay_element_types_f

1516: v_dated_updates boolean := FALSE;
1517: --
1518: cursor csr_dated_updates is
1519: select 1
1520: from pay_element_types_f
1521: where element_type_id = p_element_type_id
1522: and rowid <> p_rowid;
1523: --
1524: begin

Line 2289: pay_element_types_f ELEMENT

2285: select 1
2286: from pay_status_processing_rules_f STATUS,
2287: pay_formula_result_rules_f RESULT,
2288: pay_input_values_f INPUT,
2289: pay_element_types_f ELEMENT
2290: where status.status_processing_rule_id = result.status_processing_rule_id
2291: and result.input_value_id = input.input_value_id
2292: and input.element_type_id = element.element_type_id
2293: and result.result_rule_type = 'I'

Line 2349: pay_element_types_f ELEMENT

2345: select 1
2346: from pay_status_processing_rules_f STATUS,
2347: pay_formula_result_rules_f RESULT,
2348: pay_input_values_f INPUT,
2349: pay_element_types_f ELEMENT
2350: where result.input_value_id = input.input_value_id
2351: and status.element_type_id = element.element_type_id
2352: and result.status_processing_rule_id= status.status_processing_rule_id
2353: and result.result_rule_type = 'I'

Line 2457: from pay_element_types_f et,

2453: v_name_duplicated boolean := FALSE;
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

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 2500: from pay_element_types_f

2496: --******************************************************************************
2497: --
2498: cursor csr_date is
2499: select min (effective_start_date)
2500: from pay_element_types_f
2501: where element_type_id = p_element_type_id;
2502: --
2503: v_start_date date;
2504: --

Line 2523: from pay_element_types_f

2519: --******************************************************************************
2520: --
2521: cursor csr_end_date is
2522: select max (effective_end_date)
2523: from pay_element_types_f
2524: where element_type_id = p_element_type_id;
2525: --
2526: v_end_date date;
2527: --

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 2585: from PAY_ELEMENT_TYPES_F B

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
2587: );
2588:
2589: update PAY_ELEMENT_TYPES_F_TL T set (

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 2658: FROM pay_element_types_f

2654: is
2655: result varchar2(255);
2656: Begin
2657: SELECT count(*) INTO result
2658: FROM pay_element_types_f
2659: WHERE nvl(ELEMENT_NAME,'~null~') = nvl(X_E_ELEMENT_NAME,'~null~')
2660: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_E_LEGISLATION_CODE,'~null~')
2661: and EFFECTIVE_START_DATE = X_E_EFFECTIVE_START_DATE
2662: and EFFECTIVE_end_DATE = X_E_EFFECTIVE_END_DATE

Line 2696: from pay_element_types_f

2692: -- statement.
2693: --
2694: cursor csr_ele_id is
2695: select element_type_id
2696: from pay_element_types_f
2697: where nvl(ELEMENT_NAME,'~null~') = nvl(X_E_ELEMENT_NAME,'~null~')
2698: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_E_LEGISLATION_CODE,'~null~')
2699: and EFFECTIVE_START_DATE = X_E_EFFECTIVE_START_DATE
2700: and EFFECTIVE_end_DATE = X_E_EFFECTIVE_END_DATE

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,