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

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

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

1208: ) is
1209: --
1210: cursor csr_element_type is
1211: select *
1212: from pay_element_types_f
1213: where rowid = p_rowid
1214: for update of element_type_id nowait;
1215: --
1216: element_record csr_element_type%rowtype;

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

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

Line 1525: from pay_element_types_f

1521: v_dated_updates boolean := FALSE;
1522: --
1523: cursor csr_dated_updates is
1524: select 1
1525: from pay_element_types_f
1526: where element_type_id = p_element_type_id
1527: and rowid <> p_rowid;
1528: --
1529: begin

Line 2322: pay_element_types_f ELEMENT

2318: select 1
2319: from pay_status_processing_rules_f STATUS,
2320: pay_formula_result_rules_f RESULT,
2321: pay_input_values_f INPUT,
2322: pay_element_types_f ELEMENT
2323: where status.status_processing_rule_id = result.status_processing_rule_id
2324: and result.input_value_id = input.input_value_id
2325: and input.element_type_id = element.element_type_id
2326: and result.result_rule_type = 'I'

Line 2382: pay_element_types_f ELEMENT

2378: select 1
2379: from pay_status_processing_rules_f STATUS,
2380: pay_formula_result_rules_f RESULT,
2381: pay_input_values_f INPUT,
2382: pay_element_types_f ELEMENT
2383: where result.input_value_id = input.input_value_id
2384: and status.element_type_id = element.element_type_id
2385: and result.status_processing_rule_id= status.status_processing_rule_id
2386: and result.result_rule_type = 'I'

Line 2490: from pay_element_types_f et,

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

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

2529: --******************************************************************************
2530: --
2531: cursor csr_date is
2532: select min (effective_start_date)
2533: from pay_element_types_f
2534: where element_type_id = p_element_type_id;
2535: --
2536: v_start_date date;
2537: --

Line 2556: from pay_element_types_f

2552: --******************************************************************************
2553: --
2554: cursor csr_end_date is
2555: select max (effective_end_date)
2556: from pay_element_types_f
2557: where element_type_id = p_element_type_id;
2558: --
2559: v_end_date date;
2560: --

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

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
2620: );
2621:
2622: update PAY_ELEMENT_TYPES_F_TL T set (

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

2687: is
2688: result varchar2(255);
2689: Begin
2690: SELECT count(*) INTO result
2691: FROM pay_element_types_f
2692: WHERE nvl(ELEMENT_NAME,'~null~') = nvl(X_E_ELEMENT_NAME,'~null~')
2693: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_E_LEGISLATION_CODE,'~null~')
2694: and EFFECTIVE_START_DATE = X_E_EFFECTIVE_START_DATE
2695: and EFFECTIVE_end_DATE = X_E_EFFECTIVE_END_DATE

Line 2729: from pay_element_types_f

2725: -- statement.
2726: --
2727: cursor csr_ele_id is
2728: select element_type_id
2729: from pay_element_types_f
2730: where nvl(ELEMENT_NAME,'~null~') = nvl(X_E_ELEMENT_NAME,'~null~')
2731: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_E_LEGISLATION_CODE,'~null~')
2732: and EFFECTIVE_START_DATE = X_E_EFFECTIVE_START_DATE
2733: and EFFECTIVE_end_DATE = X_E_EFFECTIVE_END_DATE

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,