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_DEDN dependencies on PAY_DB_PAY_SETUP

Line 71: to PAY_DB_PAY_SETUP.

67: "...Towards Bond Purchase" to
68: "...Toward Bond Purchase" in
69: formula and deletion.
70: 05-OCT-94 rfine 40.7 Changed calls to DB_PAY_SETUP
71: to PAY_DB_PAY_SETUP.
72: 18-OCT-94 spanwar 40.8 Removed "PER_PTD" and "PER_LR"
73: balance dimension from
74: dimension list since it is no
75: longer supported.

Line 471: -- to pay_db_pay_setup from ins_deduction_template.

467: BEGIN
468:
469: --
470: -- Unless this function actually has to do anything, we can make call
471: -- to pay_db_pay_setup from ins_deduction_template.
472: --
473:
474: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',10);
475:

Line 496: ret := pay_db_pay_setup.create_element(

492:
493: END IF;
494:
495: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',30);
496: ret := pay_db_pay_setup.create_element(
497: p_element_name => p_ele_name,
498: p_description => p_ele_description,
499: p_classification_name => p_ele_class,
500: p_post_termination_rule => 'Final Close',

Line 971: v_inpval_id := pay_db_pay_setup.create_input_value (

967: v_inpval_uom := 'Number';
968: v_gen_dbi := 'Y';
969: v_lkp_type := NULL;
970: v_dflt_value := NULL;
971: v_inpval_id := pay_db_pay_setup.create_input_value (
972: p_element_name => p_ele_name,
973: p_name => v_inpval_name,
974: p_uom => v_inpval_uom,
975: p_uom_code => NULL,

Line 1209: v_inpval_id := pay_db_pay_setup.create_input_value (

1205: -- Should be: v_dflt_value := p_paytab_col; but procedure checks for valid
1206: -- values according to lookup - which is cool, since we'll have validated
1207: -- this client side anyway. ( ) Update procedure when appropriate.
1208: --
1209: v_inpval_id := pay_db_pay_setup.create_input_value (
1210: p_element_name => p_ele_name,
1211: p_name => v_inpval_name,
1212: p_uom => v_inpval_uom,
1213: p_uom_code => NULL,

Line 1297: v_inpval_id := pay_db_pay_setup.create_input_value (

1293: v_lkp_type := NULL;
1294: -- lkp could be created to validate user_Table_columns based on user_table.
1295: v_dflt_value := NULL;
1296:
1297: v_inpval_id := pay_db_pay_setup.create_input_value (
1298: p_element_name => p_ele_name,
1299: p_name => v_inpval_name,
1300: p_uom => v_inpval_uom,
1301: p_uom_code => NULL,

Line 1493: v_inpval_id := pay_db_pay_setup.create_input_value (

1489: v_gen_dbi := 'Y';
1490: v_lkp_type := 'US_BENEFIT_COVERAGE';
1491: v_dflt_value := 'EMP ONLY';
1492: v_val_formula_id := NULL; -- ??? By a formula to do some special sql?
1493: v_inpval_id := pay_db_pay_setup.create_input_value (
1494: p_element_name => p_ele_name,
1495: p_name => v_inpval_name,
1496: p_uom => v_inpval_uom,
1497: p_uom_code => NULL,

Line 1568: v_inpval_id := pay_db_pay_setup.create_input_value (

1564: v_gen_dbi := 'Y';
1565: v_lkp_type := NULL;
1566: v_dflt_value := NULL;
1567: v_val_formula_id := NULL;
1568: v_inpval_id := pay_db_pay_setup.create_input_value (
1569: p_element_name => p_ele_name,
1570: p_name => v_inpval_name,
1571: p_uom => v_inpval_uom,
1572: p_uom_code => NULL,

Line 1643: v_er_contr_inpval_id := pay_db_pay_setup.create_input_value (

1639: v_gen_dbi := 'Y';
1640: v_lkp_type := NULL;
1641: v_dflt_value := NULL;
1642: v_val_formula_id := NULL;
1643: v_er_contr_inpval_id := pay_db_pay_setup.create_input_value (
1644: p_element_name => p_ele_name,
1645: p_name => v_inpval_name,
1646: p_uom => v_inpval_uom,
1647: p_uom_code => NULL,

Line 1854: v_inpval_id := pay_db_pay_setup.create_input_value (

1850: v_gen_dbi := 'Y';
1851: v_lkp_type := NULL;
1852: v_dflt_value := NULL;
1853:
1854: v_inpval_id := pay_db_pay_setup.create_input_value (
1855: p_element_name => p_ele_name,
1856: p_name => v_inpval_name,
1857: p_uom => v_inpval_uom,
1858: p_uom_code => NULL,

Line 1969: v_actdedn_inpval_id := pay_db_pay_setup.create_input_value (

1965: v_gen_dbi := 'N';
1966: v_lkp_type := NULL;
1967: v_dflt_value := NULL;
1968:
1969: v_actdedn_inpval_id := pay_db_pay_setup.create_input_value (
1970: p_element_name => v_er_charge_ele_name,
1971: p_name => v_inpval_name,
1972: p_uom => v_inpval_uom,
1973: p_uom_code => NULL,

Line 2074: v_inpval_id := pay_db_pay_setup.create_input_value (

2070: v_inpval_uom := 'Money';
2071: v_gen_dbi := 'N'; -- Can be 'N', not needed by any other formulae
2072: v_lkp_type := NULL;
2073: v_dflt_value := NULL;
2074: v_inpval_id := pay_db_pay_setup.create_input_value (
2075: p_element_name => p_ele_name,
2076: p_name => v_inpval_name,
2077: p_uom => v_inpval_uom,
2078: p_uom_code => NULL,

Line 2148: g_topurch_inpval_id := pay_db_pay_setup.create_input_value (

2144: v_inpval_uom := 'Money';
2145: v_gen_dbi := 'N'; -- Can be 'N', not needed by any other formulae
2146: v_lkp_type := NULL;
2147: v_dflt_value := NULL;
2148: g_topurch_inpval_id := pay_db_pay_setup.create_input_value (
2149: p_element_name => p_shadow_ele_name,
2150: p_name => v_inpval_name,
2151: p_uom => v_inpval_uom,
2152: p_uom_code => NULL,

Line 2282: v_inpval_id := pay_db_pay_setup.create_input_value (

2278: v_inpval_uom := 'Money';
2279: v_gen_dbi := 'N';
2280: v_lkp_type := NULL;
2281: v_dflt_value := NULL;
2282: v_inpval_id := pay_db_pay_setup.create_input_value (
2283: p_element_name => p_ele_name,
2284: p_name => v_inpval_name,
2285: p_uom => v_inpval_uom,
2286: p_uom_code => NULL,

Line 2359: v_inpval_id := pay_db_pay_setup.create_input_value (

2355: v_inpval_uom := 'Character';
2356: v_gen_dbi := 'N';
2357: -- v_lkp_type := 'US_VALID_ELE_TYPES'; User can define.
2358: v_dflt_value := NULL;
2359: v_inpval_id := pay_db_pay_setup.create_input_value (
2360: p_element_name => p_ele_name,
2361: p_name => v_inpval_name,
2362: p_uom => v_inpval_uom,
2363: p_uom_code => NULL,

Line 2446: v_inpval_id := pay_db_pay_setup.create_input_value (

2442: v_inpval_uom := 'Money';
2443: v_gen_dbi := 'N';
2444: v_lkp_type := NULL;
2445: v_dflt_value := NULL;
2446: v_inpval_id := pay_db_pay_setup.create_input_value (
2447: p_element_name => p_ele_name,
2448: p_name => v_inpval_name,
2449: p_uom => v_inpval_uom,
2450: p_uom_code => NULL,

Line 2520: g_to_tot_inpval_id := pay_db_pay_setup.create_input_value (

2516: v_inpval_uom := 'Money';
2517: v_gen_dbi := 'N';
2518: v_lkp_type := NULL;
2519: v_dflt_value := NULL;
2520: g_to_tot_inpval_id := pay_db_pay_setup.create_input_value (
2521: p_element_name => p_shadow_ele_name,
2522: p_name => v_inpval_name,
2523: p_uom => v_inpval_uom,
2524: p_uom_code => NULL,

Line 2592: g_clraccr_inpval_id := pay_db_pay_setup.create_input_value (

2588: v_inpval_uom := 'Money';
2589: v_gen_dbi := 'N';
2590: v_lkp_type := NULL;
2591: v_dflt_value := NULL;
2592: g_clraccr_inpval_id := pay_db_pay_setup.create_input_value (
2593: p_element_name => p_shadow_ele_name,
2594: p_name => v_inpval_name,
2595: p_uom => v_inpval_uom,
2596: p_uom_code => NULL,

Line 2665: v_inpval_id :=pay_db_pay_setup.create_input_value (

2661: v_inpval_uom := 'Character';
2662: v_gen_dbi := 'N';
2663: v_lkp_type := 'YES_NO';
2664: v_dflt_value := 'Y';
2665: v_inpval_id :=pay_db_pay_setup.create_input_value (
2666: p_element_name => p_ele_name,
2667: p_name => v_inpval_name,
2668: p_uom => v_inpval_uom,
2669: p_uom_code => NULL,

Line 2790: v_inpval_id :=pay_db_pay_setup.create_input_value (

2786: v_inpval_uom := 'Character';
2787: v_gen_dbi := 'N';
2788: v_lkp_type := 'YES_NO';
2789: v_dflt_value := 'N';
2790: v_inpval_id :=pay_db_pay_setup.create_input_value (
2791: p_element_name => p_ele_name,
2792: p_name => v_inpval_name,
2793: p_uom => v_inpval_uom,
2794: p_uom_code => NULL,

Line 2878: g_arrears_contr_inpval_id := pay_db_pay_setup.create_input_value (

2874: v_inpval_uom := 'Money';
2875: v_gen_dbi := 'N';
2876: v_lkp_type := NULL;
2877: v_dflt_value := NULL;
2878: g_arrears_contr_inpval_id := pay_db_pay_setup.create_input_value (
2879: p_element_name => p_shadow_ele_name,
2880: p_name => v_inpval_name,
2881: p_uom => v_inpval_uom,
2882: p_uom_code => NULL,

Line 2976: g_notaken_inpval_id := pay_db_pay_setup.create_input_value (

2972: v_inpval_uom := 'Money';
2973: v_gen_dbi := 'N';
2974: v_lkp_type := NULL;
2975: v_dflt_value := NULL;
2976: g_notaken_inpval_id := pay_db_pay_setup.create_input_value (
2977: p_element_name => p_shadow_ele_name,
2978: p_name => v_inpval_name,
2979: p_uom => v_inpval_uom,
2980: p_uom_code => NULL,

Line 3077: v_passthru_inpval_id := pay_db_pay_setup.create_input_value (

3073: v_gen_dbi := 'N';
3074: v_lkp_type := 'YES_NO';
3075: v_dflt_value := 'N';
3076:
3077: v_passthru_inpval_id := pay_db_pay_setup.create_input_value (
3078: p_element_name => p_ele_name,
3079: p_name => v_inpval_name,
3080: p_uom => v_inpval_uom,
3081: p_uom_code => NULL,

Line 3202: gi_repl_inpval_id := pay_db_pay_setup.create_input_value (

3198: v_gen_dbi := 'N';
3199: v_lkp_type := NULL;
3200: v_dflt_value := NULL;
3201:
3202: gi_repl_inpval_id := pay_db_pay_setup.create_input_value (
3203: p_element_name => p_inputs_ele_name,
3204: p_name => v_inpval_name,
3205: p_uom => v_inpval_uom,
3206: p_uom_code => NULL,

Line 3274: gi_addl_inpval_id := pay_db_pay_setup.create_input_value (

3270: v_gen_dbi := 'N';
3271: v_lkp_type := NULL;
3272: v_dflt_value := NULL;
3273:
3274: gi_addl_inpval_id := pay_db_pay_setup.create_input_value (
3275: p_element_name => p_inputs_ele_name,
3276: p_name => v_inpval_name,
3277: p_uom => v_inpval_uom,
3278: p_uom_code => NULL,

Line 3345: g_adj_arrears_inpval_id := pay_db_pay_setup.create_input_value (

3341: v_gen_dbi := 'N';
3342: v_lkp_type := NULL;
3343: v_dflt_value := NULL;
3344:
3345: g_adj_arrears_inpval_id := pay_db_pay_setup.create_input_value (
3346: p_element_name => p_inputs_ele_name,
3347: p_name => v_inpval_name,
3348: p_uom => v_inpval_uom,
3349: p_uom_code => NULL,

Line 3424: g_repl_inpval_id := pay_db_pay_setup.create_input_value (

3420: v_gen_dbi := 'N';
3421: v_lkp_type := NULL;
3422: v_dflt_value := NULL;
3423:
3424: g_repl_inpval_id := pay_db_pay_setup.create_input_value (
3425: p_element_name => p_shadow_ele_name,
3426: p_name => v_inpval_name,
3427: p_uom => v_inpval_uom,
3428: p_uom_code => NULL,

Line 3496: g_addl_inpval_id := pay_db_pay_setup.create_input_value (

3492: v_gen_dbi := 'N';
3493: v_lkp_type := NULL;
3494: v_dflt_value := NULL;
3495:
3496: g_addl_inpval_id := pay_db_pay_setup.create_input_value (
3497: p_element_name => p_shadow_ele_name,
3498: p_name => v_inpval_name,
3499: p_uom => v_inpval_uom,
3500: p_uom_code => NULL,

Line 3726: pay_db_pay_setup.create_defined_balance(

3722: NULL;
3723:
3724: ELSIF suffixes(i) = '_ASG_GRE_RUN' THEN
3725:
3726: pay_db_pay_setup.create_defined_balance(
3727: p_balance_name => p_bal_name,
3728: p_balance_dimension => dim_name,
3729: p_business_group_name => p_bg_name,
3730: p_legislation_code => NULL,

Line 3735: pay_db_pay_setup.create_defined_balance(

3731: p_save_run_bal => 'Y');
3732:
3733: ELSE
3734:
3735: pay_db_pay_setup.create_defined_balance(
3736: p_balance_name => p_bal_name,
3737: p_balance_dimension => dim_name,
3738: p_business_group_name => p_bg_name,
3739: p_legislation_code => NULL);

Line 3758: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));

3754:
3755: --
3756: -- Set session date
3757: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',10);
3758: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
3759: g_eff_start_date := nvl(p_ele_eff_start_date, sysdate);
3760: g_eff_end_date := nvl(p_ele_eff_end_date, c_end_of_time);
3761:
3762:

Line 3820: v_bal_type_id := pay_db_pay_setup.create_balance_type(

3816: else
3817: l_balance_category := 'After-Tax Deductions';
3818: end if;
3819:
3820: v_bal_type_id := pay_db_pay_setup.create_balance_type(
3821: p_balance_name => p_ele_name,
3822: p_uom => 'Money',
3823: p_reporting_name => p_ele_name,
3824: p_business_group_name => v_bg_name,

Line 3843: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(

3839:
3840: v_addl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Additional';
3841: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Additional';
3842: hr_utility.set_location('pyusuidt',119);
3843: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3844: p_balance_name => v_addl_amt_bal_name,
3845: p_uom => 'Money',
3846: p_reporting_name => v_addl_amt_bal_name,
3847: p_business_group_name => v_bg_name,

Line 3855: pay_db_pay_setup.create_defined_balance (

3851: p_bc_leg_code => 'US',
3852: p_effective_date => g_eff_start_date);
3853:
3854: hr_utility.set_location('pyusuidt',127);
3855: pay_db_pay_setup.create_defined_balance (
3856: p_balance_name => v_addl_amt_bal_name,
3857: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3858: p_business_group_name => v_bg_name,
3859: p_legislation_code => NULL);

Line 3864: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(

3860:
3861: v_repl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Replacement';
3862: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Replacement';
3863: hr_utility.set_location('pyusuidt',119);
3864: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3865: p_balance_name => v_repl_amt_bal_name,
3866: p_uom => 'Money',
3867: p_reporting_name => v_repl_amt_bal_name,
3868: p_business_group_name => v_bg_name,

Line 3876: pay_db_pay_setup.create_defined_balance (

3872: p_bc_leg_code => 'US',
3873: p_effective_date => g_eff_start_date);
3874:
3875: hr_utility.set_location('pyusuidt',129);
3876: pay_db_pay_setup.create_defined_balance (
3877: p_balance_name => v_repl_amt_bal_name,
3878: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3879: p_business_group_name => v_bg_name,
3880: p_legislation_code => NULL);

Line 3887: v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(

3883:
3884: v_balance_name := SUBSTR(p_ele_name, 1, 67)||' Not Taken';
3885: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Not Taken';
3886: hr_utility.set_location('pyusuidt',130);
3887: v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(
3888: p_balance_name => v_balance_name,
3889: p_uom => 'Money',
3890: p_reporting_name => v_balance_name,
3891: p_business_group_name => v_bg_name,

Line 3899: pay_db_pay_setup.create_defined_balance (

3895: p_bc_leg_code => 'US',
3896: p_effective_date => g_eff_start_date);
3897:
3898: hr_utility.set_location('pyusuidt',131);
3899: pay_db_pay_setup.create_defined_balance (
3900: p_balance_name => v_balance_name,
3901: p_balance_dimension => 'Person Run',
3902: p_business_group_name => v_bg_name,
3903: p_legislation_code => NULL);

Line 3905: pay_db_pay_setup.create_defined_balance (

3901: p_balance_dimension => 'Person Run',
3902: p_business_group_name => v_bg_name,
3903: p_legislation_code => NULL);
3904:
3905: pay_db_pay_setup.create_defined_balance (
3906: p_balance_name => v_balance_name,
3907: p_balance_dimension => 'Person within Government Reporting Entity Run',
3908: p_business_group_name => v_bg_name,
3909: p_legislation_code => NULL);

Line 3912: pay_db_pay_setup.create_defined_balance (

3908: p_business_group_name => v_bg_name,
3909: p_legislation_code => NULL);
3910:
3911: hr_utility.set_location('pyusuidt',131);
3912: pay_db_pay_setup.create_defined_balance (
3913: p_balance_name => v_balance_name,
3914: p_balance_dimension => 'Assignment-Level Current Run',
3915: p_business_group_name => v_bg_name,
3916: p_legislation_code => NULL);

Line 3918: pay_db_pay_setup.create_defined_balance (

3914: p_balance_dimension => 'Assignment-Level Current Run',
3915: p_business_group_name => v_bg_name,
3916: p_legislation_code => NULL);
3917:
3918: pay_db_pay_setup.create_defined_balance (
3919: p_balance_name => v_balance_name,
3920: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
3921: p_business_group_name => v_bg_name,
3922: p_legislation_code => NULL,

Line 3931: v_eepurch_bal_type_id := pay_db_pay_setup.create_balance_type(

3927:
3928: v_balance_name := substr(p_ele_name, 1, 55)||' Toward Bond Purchase';
3929: --v_bal_rpt_name := substr(p_ele_name, 1, 13)||' To Bond Purch';
3930: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',39);
3931: v_eepurch_bal_type_id := pay_db_pay_setup.create_balance_type(
3932: p_balance_name => v_balance_name,
3933: p_uom => 'Money',
3934: p_reporting_name => v_balance_name,
3935: p_business_group_name => v_bg_name,

Line 3943: pay_db_pay_setup.create_defined_balance (

3939: p_bc_leg_code => 'US',
3940: p_effective_date => g_eff_start_date);
3941:
3942: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',41);
3943: pay_db_pay_setup.create_defined_balance (
3944: p_balance_name => v_balance_name,
3945: p_balance_dimension => 'Assignment Inception to Date',
3946: p_business_group_name => v_bg_name,
3947: p_legislation_code => NULL);

Line 3949: pay_db_pay_setup.create_defined_balance (

3945: p_balance_dimension => 'Assignment Inception to Date',
3946: p_business_group_name => v_bg_name,
3947: p_legislation_code => NULL);
3948:
3949: pay_db_pay_setup.create_defined_balance (
3950: p_balance_name => v_balance_name,
3951: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3952: p_business_group_name => v_bg_name,
3953: p_legislation_code => NULL);

Line 3958: v_totowed_bal_type_id := pay_db_pay_setup.create_balance_type(

3954:
3955: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',43);
3956: v_balance_name := substr(p_ele_name, 1, 71)||' Accrued';
3957: --v_bal_rpt_name := substr(p_ele_name, 1, 21)||' Accrued';
3958: v_totowed_bal_type_id := pay_db_pay_setup.create_balance_type(
3959: p_balance_name => v_balance_name,
3960: p_uom => 'Money',
3961: p_reporting_name => v_balance_name,
3962: p_business_group_name => v_bg_name,

Line 3970: pay_db_pay_setup.create_defined_balance (

3966: p_bc_leg_code => 'US',
3967: p_effective_date => g_eff_start_date);
3968:
3969: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',45);
3970: pay_db_pay_setup.create_defined_balance (
3971: p_balance_name => v_balance_name,
3972: p_balance_dimension => 'Assignment Inception to Date',
3973: p_business_group_name => v_bg_name,
3974: p_legislation_code => NULL);

Line 3976: pay_db_pay_setup.create_defined_balance (

3972: p_balance_dimension => 'Assignment Inception to Date',
3973: p_business_group_name => v_bg_name,
3974: p_legislation_code => NULL);
3975:
3976: pay_db_pay_setup.create_defined_balance (
3977: p_balance_name => v_balance_name,
3978: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3979: p_business_group_name => v_bg_name,
3980: p_legislation_code => NULL);

Line 3982: pay_db_pay_setup.create_defined_balance(

3978: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3979: p_business_group_name => v_bg_name,
3980: p_legislation_code => NULL);
3981:
3982: pay_db_pay_setup.create_defined_balance(
3983: p_balance_name => v_balance_name,
3984: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
3985: p_business_group_name => v_bg_name,
3986: p_legislation_code => NULL,

Line 3991: pay_db_pay_setup.create_defined_balance (

3987: p_save_run_bal => 'Y');
3988: --
3989: -- Adding _ENTRY_ITD Balance Dimension For Bug# 6270794
3990: --
3991: pay_db_pay_setup.create_defined_balance (
3992: p_balance_name => v_balance_name,
3993: p_balance_dimension => 'US Element Entry Inception to Date',
3994: p_business_group_name => v_bg_name,
3995: p_legislation_code => NULL);

Line 3999: pay_db_pay_setup.create_defined_balance (

3995: p_legislation_code => NULL);
3996:
3997: -- Adding _ASG_PTD Balance Dimension For Bug#13512417
3998: --
3999: pay_db_pay_setup.create_defined_balance (
4000: p_balance_name => v_balance_name,
4001: p_balance_dimension => 'Assignment Period to Date',
4002: p_business_group_name => v_bg_name,
4003: p_legislation_code => NULL);

Line 4008: v_arrears_bal_type_id := pay_db_pay_setup.create_balance_type(

4004:
4005: v_balance_name := substr(p_ele_name, 1, 71)||' Arrears';
4006: --v_bal_rpt_name := substr(p_ele_name, 1, 21)||' Arrears';
4007: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',47);
4008: v_arrears_bal_type_id := pay_db_pay_setup.create_balance_type(
4009: p_balance_name => v_balance_name,
4010: p_uom => 'Money',
4011: p_reporting_name => v_balance_name,
4012: p_business_group_name => v_bg_name,

Line 4020: pay_db_pay_setup.create_defined_balance (

4016: p_bc_leg_code => 'US',
4017: p_effective_date => g_eff_start_date);
4018:
4019: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',49);
4020: pay_db_pay_setup.create_defined_balance (
4021: p_balance_name => v_balance_name,
4022: p_balance_dimension => 'Assignment Inception to Date',
4023: p_business_group_name => v_bg_name,
4024: p_legislation_code => NULL);

Line 4026: pay_db_pay_setup.create_defined_balance (

4022: p_balance_dimension => 'Assignment Inception to Date',
4023: p_business_group_name => v_bg_name,
4024: p_legislation_code => NULL);
4025:
4026: pay_db_pay_setup.create_defined_balance (
4027: p_balance_name => v_balance_name,
4028: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4029: p_business_group_name => v_bg_name,
4030: p_legislation_code => NULL);

Line 4034: pay_db_pay_setup.create_defined_balance (

4030: p_legislation_code => NULL);
4031:
4032: -- WWbug333133 - create _GRE_ITD dimension for arrears
4033:
4034: pay_db_pay_setup.create_defined_balance (
4035: p_balance_name => v_balance_name,
4036: p_balance_dimension => 'Government Reporting Entity Inception to Date',
4037: p_business_group_name => v_bg_name,
4038: p_legislation_code => NULL);

Line 4041: pay_db_pay_setup.create_defined_balance(

4037: p_business_group_name => v_bg_name,
4038: p_legislation_code => NULL);
4039:
4040: --
4041: pay_db_pay_setup.create_defined_balance(
4042: p_balance_name => v_balance_name,
4043: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
4044: p_business_group_name => v_bg_name,
4045: p_legislation_code => NULL,

Line 4055: v_eligiblecomp_bal_type_id := pay_db_pay_setup.create_balance_type(

4051: -- Begin Create Eligible Comp Balance
4052: v_balance_name := SUBSTR(p_ele_name, 1, 66)||' Eligible Comp';
4053: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 16)||' Eligible Comp';
4054: hr_utility.set_location('pyusuidt',240);
4055: v_eligiblecomp_bal_type_id := pay_db_pay_setup.create_balance_type(
4056: p_balance_name => v_balance_name,
4057: p_uom => 'Money',
4058: p_reporting_name => v_balance_name,
4059: p_business_group_name => v_bg_name,

Line 4096: pay_db_pay_setup.create_defined_balance (

4092:
4093: end if;
4094:
4095: hr_utility.set_location('pyusuidt',241);
4096: pay_db_pay_setup.create_defined_balance (
4097: p_balance_name => v_balance_name,
4098: p_balance_dimension => 'Person Run',
4099: p_business_group_name => v_bg_name,
4100: p_legislation_code => NULL);

Line 4102: pay_db_pay_setup.create_defined_balance (

4098: p_balance_dimension => 'Person Run',
4099: p_business_group_name => v_bg_name,
4100: p_legislation_code => NULL);
4101:
4102: pay_db_pay_setup.create_defined_balance (
4103: p_balance_name => v_balance_name,
4104: p_balance_dimension => 'Person within Government Reporting Entity Run',
4105: p_business_group_name => v_bg_name,
4106: p_legislation_code => NULL);

Line 4109: pay_db_pay_setup.create_defined_balance (

4105: p_business_group_name => v_bg_name,
4106: p_legislation_code => NULL);
4107:
4108: hr_utility.set_location('pyusuidt',243);
4109: pay_db_pay_setup.create_defined_balance (
4110: p_balance_name => v_balance_name,
4111: p_balance_dimension => 'Assignment-Level Current Run',
4112: p_business_group_name => v_bg_name,
4113: p_legislation_code => NULL);

Line 4115: pay_db_pay_setup.create_defined_balance (

4111: p_balance_dimension => 'Assignment-Level Current Run',
4112: p_business_group_name => v_bg_name,
4113: p_legislation_code => NULL);
4114:
4115: pay_db_pay_setup.create_defined_balance (
4116: p_balance_name => v_balance_name,
4117: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
4118: p_business_group_name => v_bg_name,
4119: p_legislation_code => NULL);

Line 4122: pay_db_pay_setup.create_defined_balance (

4118: p_business_group_name => v_bg_name,
4119: p_legislation_code => NULL);
4120:
4121:
4122: pay_db_pay_setup.create_defined_balance (
4123: p_balance_name => v_balance_name,
4124: p_balance_dimension => 'Assignment within Government Reporting Entity Year to Date',
4125: p_business_group_name => v_bg_name,
4126: p_legislation_code => NULL);

Line 4138: --v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(

4134: --IF p_ele_at_component = 'Y' THEN
4135: v_balance_name := SUBSTR(p_ele_name, 1, 67)||' Overlimit';
4136: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Overlimit';
4137: hr_utility.set_location('pyusuidt',245);
4138: --v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(
4139: v_overlimit_bal_type_id := pay_db_pay_setup.create_balance_type(
4140: p_balance_name => v_balance_name,
4141: p_uom => 'Money',
4142: p_reporting_name => v_balance_name,

Line 4139: v_overlimit_bal_type_id := pay_db_pay_setup.create_balance_type(

4135: v_balance_name := SUBSTR(p_ele_name, 1, 67)||' Overlimit';
4136: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Overlimit';
4137: hr_utility.set_location('pyusuidt',245);
4138: --v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(
4139: v_overlimit_bal_type_id := pay_db_pay_setup.create_balance_type(
4140: p_balance_name => v_balance_name,
4141: p_uom => 'Money',
4142: p_reporting_name => v_balance_name,
4143: p_business_group_name => v_bg_name,

Line 4151: pay_db_pay_setup.create_defined_balance (

4147: p_bc_leg_code => 'US',
4148: p_effective_date => g_eff_start_date);
4149:
4150: hr_utility.set_location('pyusuidt',246);
4151: pay_db_pay_setup.create_defined_balance (
4152: p_balance_name => v_balance_name,
4153: p_balance_dimension => 'Person Run',
4154: p_business_group_name => v_bg_name,
4155: p_legislation_code => NULL);

Line 4159: pay_db_pay_setup.create_defined_balance (

4155: p_legislation_code => NULL);
4156:
4157:
4158: hr_utility.set_location('pyusuidt',247);
4159: pay_db_pay_setup.create_defined_balance (
4160: p_balance_name => v_balance_name,
4161: p_balance_dimension => 'Assignment-Level Current Run',
4162: p_business_group_name => v_bg_name,
4163: p_legislation_code => NULL);

Line 4165: pay_db_pay_setup.create_defined_balance (

4161: p_balance_dimension => 'Assignment-Level Current Run',
4162: p_business_group_name => v_bg_name,
4163: p_legislation_code => NULL);
4164:
4165: pay_db_pay_setup.create_defined_balance (
4166: p_balance_name => v_balance_name,
4167: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
4168: p_business_group_name => v_bg_name,
4169: p_legislation_code => NULL);

Line 4366: -- So a payvalue is created by pay_db_pay_setup.create_element

4362: --
4363: -- Create Pay Value for this element.
4364: --
4365: -- NO, "Employer Liabilities" has non-payments flag = 'N'!
4366: -- So a payvalue is created by pay_db_pay_setup.create_element
4367: -- Need to do this for Non-Payments where non_payments_flag = 'Y',
4368: -- (done for Earnings, but was snagging on "dbi name already used"
4369: -- which i think is a bug.
4370:

Line 4377: v_er_charge_baltype_id := pay_db_pay_setup.create_balance_type(

4373: --
4374: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',58);
4375: v_balance_name := v_er_charge_ele_name;
4376: --v_bal_rpt_name := v_ele_repname;
4377: v_er_charge_baltype_id := pay_db_pay_setup.create_balance_type(
4378: p_balance_name => v_balance_name,
4379: p_uom => 'Money',
4380: p_reporting_name => v_balance_name,
4381: p_business_group_name => v_bg_name,

Line 4473: v_eerefund_baltype_id := pay_db_pay_setup.create_balance_type(

4469: --
4470: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',58);
4471: v_balance_name := v_eerefund_ele_name;
4472: --v_bal_rpt_name := v_ele_repname;
4473: v_eerefund_baltype_id := pay_db_pay_setup.create_balance_type(
4474: p_balance_name => v_balance_name,
4475: p_uom => 'Money',
4476: p_reporting_name => v_balance_name,
4477: p_business_group_name => v_bg_name,

Line 5079: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));

5075: -- Populate vars.
5076: v_del_val_end := nvl(p_del_val_end_date, c_end_of_time);
5077: v_del_val_start := nvl(p_del_val_start_date, sysdate);
5078: v_del_sess_date := nvl(p_del_sess_date, sysdate);
5079: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));
5080:
5081: assoc_eles(1) := fnd_number.canonical_to_number(p_ele_info_18); -- Special Inputs ele
5082: assoc_eles(2) := fnd_number.canonical_to_number(p_ele_info_19); -- Special Features ele
5083: assoc_eles(3) := fnd_number.canonical_to_number(p_ele_info_20); -- Withholding ele