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.HR_USER_INIT_EARN dependencies on PAY_ELEMENT_TYPES_F

Line 662: UPDATE pay_element_types_f

658: --
659: IF UPPER(p_ele_class_name) = 'EARNINGS' THEN
660: v_ele_info_cat := 'US_EARNINGS';
661: hr_utility.set_location('pyusuiet',45);
662: UPDATE pay_element_types_f
663: SET element_information_category = v_ele_info_cat,
664: element_information1 = p_ele_cat,
665: element_information8 = p_include_in_ot,
666: element_information11 = p_flsa_hrs,

Line 673: UPDATE pay_element_types_f

669: WHERE element_type_id = p_ele_id
670: AND business_group_id = p_bg_id;
671: --
672: hr_utility.set_location('pyusuiet',50);
673: UPDATE pay_element_types_f
674: SET element_information_category = v_ele_info_cat,
675: element_information1 = p_ele_cat,
676: element_information8 = p_include_in_ot
677: WHERE element_type_id = p_shadow_ele_id

Line 684: UPDATE pay_element_types_f

680:
681: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
682:
683: hr_utility.set_location('pyusuiet',55);
684: UPDATE pay_element_types_f
685: SET element_information_category = v_ele_info_cat,
686: element_information1 = p_ele_cat,
687: element_information8 = p_include_in_ot
688: WHERE element_type_id = p_inputs_ele_id

Line 698: UPDATE pay_element_types_f

694: ELSIF UPPER(p_ele_class_name) = 'SUPPLEMENTAL EARNINGS' THEN
695:
696: v_ele_info_cat := 'US_SUPPLEMENTAL EARNINGS';
697: hr_utility.set_location('pyusuiet',60);
698: UPDATE pay_element_types_f
699: SET element_information_category = v_ele_info_cat,
700: element_information1 = p_ele_cat,
701: element_information8 = p_include_in_ot,
702: element_information11 = p_flsa_hrs,

Line 709: UPDATE pay_element_types_f

705: WHERE element_type_id = p_ele_id
706: AND business_group_id = p_bg_id;
707: --
708: hr_utility.set_location('pyusuiet',65);
709: UPDATE pay_element_types_f
710: SET element_information_category = v_ele_info_cat,
711: element_information1 = p_ele_cat,
712: element_information8 = p_include_in_ot
713: WHERE element_type_id = p_shadow_ele_id

Line 719: UPDATE pay_element_types_f

715: --
716: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
717:
718: hr_utility.set_location('pyusuiet',70);
719: UPDATE pay_element_types_f
720: SET element_information_category = v_ele_info_cat,
721: element_information1 = p_ele_cat,
722: element_information8 = p_include_in_ot
723: WHERE element_type_id = p_inputs_ele_id

Line 732: UPDATE pay_element_types_f

728: ELSIF UPPER(p_ele_class_name) = 'IMPUTED EARNINGS' THEN
729:
730: v_ele_info_cat := 'US_IMPUTED EARNINGS';
731: hr_utility.set_location('pyusuiet',75);
732: UPDATE pay_element_types_f
733: SET element_information_category = v_ele_info_cat,
734: element_information1 = p_ele_cat,
735: element_information9 = v_mix_category,
736: element_information12 = p_hrs_baltype_id

Line 741: UPDATE pay_element_types_f

737: WHERE element_type_id = p_ele_id
738: AND business_group_id = p_bg_id;
739: --
740: hr_utility.set_location('pyusuiet',80);
741: UPDATE pay_element_types_f
742: SET element_information_category = v_ele_info_cat,
743: element_information1 = p_ele_cat
744: WHERE element_type_id = p_shadow_ele_id
745: AND business_group_id = p_bg_id;

Line 751: UPDATE pay_element_types_f

747:
748: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
749:
750: hr_utility.set_location('pyusuiet',85);
751: UPDATE pay_element_types_f
752: SET element_information_category = v_ele_info_cat,
753: element_information1 = p_ele_cat
754: WHERE element_type_id = p_inputs_ele_id
755: AND business_group_id = p_bg_id;

Line 764: UPDATE pay_element_types_f

760: ELSIF UPPER(p_ele_class_name) = 'NON-PAYROLL PAYMENTS' THEN
761:
762: v_ele_info_cat := 'US_NON-PAYROLL PAYMENTS';
763: hr_utility.set_location('pyusuiet',90);
764: UPDATE pay_element_types_f
765: SET element_information_category = v_ele_info_cat,
766: element_information1 = p_ele_cat,
767: element_information9 = v_mix_category
768: WHERE element_type_id = p_ele_id

Line 772: UPDATE pay_element_types_f

768: WHERE element_type_id = p_ele_id
769: AND business_group_id = p_bg_id;
770: --
771: hr_utility.set_location('pyusuiet',95);
772: UPDATE pay_element_types_f
773: SET element_information_category = v_ele_info_cat,
774: element_information1 = p_ele_cat
775: WHERE element_type_id = p_shadow_ele_id
776: AND business_group_id = p_bg_id;

Line 781: UPDATE pay_element_types_f

777: --
778: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
779:
780: hr_utility.set_location('pyusuiet',100);
781: UPDATE pay_element_types_f
782: SET element_information_category = v_ele_info_cat,
783: element_information1 = p_ele_cat
784: WHERE element_type_id = p_inputs_ele_id
785: AND business_group_id = p_bg_id;

Line 796: UPDATE pay_element_types_f

792: --
793: ELSE
794: -- Ele is a grossup ele, Information classification, just set mix flag.
795: hr_utility.set_location('pyusuiet',105);
796: UPDATE pay_element_types_f
797: SET element_information9 = v_mix_category
798: WHERE element_type_id = p_ele_id
799: AND business_group_id = p_bg_id;
800: --

Line 1173: from pay_element_types_f

1169: hr_utility.trace('Get Hours By Rate Element Id');
1170: hr_utility.set_location('pyusuiet',195);
1171: select element_type_id
1172: into v_hbyr_ele_type_id
1173: from pay_element_types_f
1174: where element_name = 'Hours by Rate'
1175: and legislation_code = g_template_leg_code
1176: and sysdate between effective_start_date
1177: and effective_end_date;

Line 1576: from pay_element_types_f

1572: hr_utility.trace('Get Hours By Rate Element Id');
1573: hr_utility.set_location('pyusuiet',320);
1574: select element_type_id
1575: into v_hbyr_ele_type_id
1576: from pay_element_types_f
1577: where element_name = 'Hours by Rate'
1578: and legislation_code = g_template_leg_code
1579: and sysdate between effective_start_date
1580: and effective_end_date;

Line 3522: from pay_element_types_f e,

3518: l_pv_name := hr_input_values.get_pay_value_name(g_template_leg_code);
3519:
3520: select i.input_value_id
3521: into l_pv_id
3522: from pay_element_types_f e,
3523: pay_input_values_f i
3524: where e.element_name = 'Regular Salary'
3525: and p_eff_start_date between e.effective_start_date
3526: and e.effective_end_date

Line 3575: from pay_element_types_f e,

3571:
3572:
3573: select i.input_value_id
3574: into l_pv_id
3575: from pay_element_types_f e,
3576: pay_input_values_f i
3577: where e.element_name = 'Regular Wages'
3578: and p_eff_start_date between e.effective_start_date
3579: and e.effective_end_date

Line 3662: from pay_element_types_f e,

3658: l_pv_name := hr_input_values.get_pay_value_name(g_template_leg_code);
3659:
3660: select i.input_value_id
3661: into l_pv_id
3662: from pay_element_types_f e,
3663: pay_input_values_f i
3664: where e.element_name = 'Regular Salary'
3665: and p_eff_start_date between e.effective_start_date
3666: and e.effective_end_date

Line 3715: from pay_element_types_f e,

3711:
3712:
3713: select i.input_value_id
3714: into l_pv_id
3715: from pay_element_types_f e,
3716: pay_input_values_f i
3717: where e.element_name = 'Regular Wages'
3718: and p_eff_start_date between e.effective_start_date
3719: and e.effective_end_date

Line 4298: from pay_element_types_f

4294: -- Need to find PRIMARY_CLASSIFICATION_ID of element type.
4295: hr_utility.set_location('pyusuiet',1020);
4296: select distinct(classification_id)
4297: into v_primary_class_id
4298: from pay_element_types_f
4299: where element_type_id = v_ele_type_id;
4300: --
4301: hr_utility.set_location('pyusuiet',1025);
4302: SELECT default_low_priority,

Line 4667: UPDATE pay_element_types_f

4663: -- Also, update element type DDF with associated balances for this
4664: -- earning. Current associated balances for Regular/Supplemental/Imputed
4665: -- Earnings: "Primary Balance" - hold in ELEMENT_INFORMATION10
4666: -- Update Termination Rule for the base element.
4667: UPDATE pay_element_types_f
4668: SET element_information10 = v_bal_type_id,
4669: post_termination_rule = p_termination_rule
4670: WHERE element_type_id = v_ele_type_id
4671: AND business_group_id = p_bg_id;

Line 5221: update pay_element_types_f

5217:
5218: -- Create feeds to all bals fed by RegSal and Wages pay values.
5219: create_reduce_regpay_feeds (p_eff_start_date => g_eff_start_date);
5220:
5221: update pay_element_types_f
5222: set element_information13 = 'Y'
5223: where element_type_id = v_ele_type_id;
5224:
5225: end if;

Line 5444: FROM pay_element_types_f

5440: SELECT element_type_id,
5441: processing_priority
5442: INTO v_shadow_eletype_id,
5443: v_shadow_ele_priority
5444: FROM pay_element_types_f
5445: WHERE element_name = SUBSTR(p_ele_name || ' Special Features', 1, 80)
5446: AND business_group_id = p_business_group_id;
5447:
5448: exception when NO_DATA_FOUND then

Line 5460: FROM pay_element_types_f

5456: SELECT element_type_id,
5457: processing_priority
5458: INTO v_inputs_eletype_id,
5459: v_inputs_ele_priority
5460: FROM pay_element_types_f
5461: WHERE element_name = SUBSTR(p_ele_name || ' Special Inputs', 1, 80)
5462: AND business_group_id = p_business_group_id;
5463:
5464: exception when NO_DATA_FOUND then

Line 5488: delete from PAY_ELEMENT_TYPES_F

5484: p_startup_mode => v_startup_mode);
5485:
5486: -- Delete element type record:
5487: hr_utility.set_location('pyusuiet',1257);
5488: delete from PAY_ELEMENT_TYPES_F
5489: where element_type_id = p_ele_type_id;
5490:
5491: --
5492: -- DELETE ASSOCIATED BALANCES AND OTHER BALANCES CREATED FOR THIS DEDN.

Line 5646: delete from PAY_ELEMENT_TYPES_F

5642: p_val_end_date => v_del_val_end,
5643: p_startup_mode => v_startup_mode);
5644:
5645: hr_utility.set_location('pyusuiet',1295);
5646: delete from PAY_ELEMENT_TYPES_F
5647: where element_type_id = v_shadow_eletype_id;
5648:
5649: --
5650: -- Delete Special Inputs element...

Line 5671: delete from PAY_ELEMENT_TYPES_F

5667: p_val_end_date => v_del_val_end,
5668: p_startup_mode => v_startup_mode);
5669:
5670: hr_utility.set_location('pyusuiet',1310);
5671: delete from PAY_ELEMENT_TYPES_F
5672: where element_type_id = v_inputs_eletype_id;
5673: --
5674: EXCEPTION
5675: WHEN NO_DATA_FOUND THEN NULL;