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 459: -- to pay_db_pay_setup from ins_deduction_template.

455: BEGIN
456:
457: --
458: -- Unless this function actually has to do anything, we can make call
459: -- to pay_db_pay_setup from ins_deduction_template.
460: --
461:
462: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',10);
463:

Line 484: ret := pay_db_pay_setup.create_element(

480:
481: END IF;
482:
483: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',30);
484: ret := pay_db_pay_setup.create_element(
485: p_element_name => p_ele_name,
486: p_description => p_ele_description,
487: p_classification_name => p_ele_class,
488: p_post_termination_rule => 'Final Close',

Line 959: v_inpval_id := pay_db_pay_setup.create_input_value (

955: v_inpval_uom := 'Number';
956: v_gen_dbi := 'Y';
957: v_lkp_type := NULL;
958: v_dflt_value := NULL;
959: v_inpval_id := pay_db_pay_setup.create_input_value (
960: p_element_name => p_ele_name,
961: p_name => v_inpval_name,
962: p_uom => v_inpval_uom,
963: p_uom_code => NULL,

Line 1197: v_inpval_id := pay_db_pay_setup.create_input_value (

1193: -- Should be: v_dflt_value := p_paytab_col; but procedure checks for valid
1194: -- values according to lookup - which is cool, since we'll have validated
1195: -- this client side anyway. ( ) Update procedure when appropriate.
1196: --
1197: v_inpval_id := pay_db_pay_setup.create_input_value (
1198: p_element_name => p_ele_name,
1199: p_name => v_inpval_name,
1200: p_uom => v_inpval_uom,
1201: p_uom_code => NULL,

Line 1285: v_inpval_id := pay_db_pay_setup.create_input_value (

1281: v_lkp_type := NULL;
1282: -- lkp could be created to validate user_Table_columns based on user_table.
1283: v_dflt_value := NULL;
1284:
1285: v_inpval_id := pay_db_pay_setup.create_input_value (
1286: p_element_name => p_ele_name,
1287: p_name => v_inpval_name,
1288: p_uom => v_inpval_uom,
1289: p_uom_code => NULL,

Line 1481: v_inpval_id := pay_db_pay_setup.create_input_value (

1477: v_gen_dbi := 'Y';
1478: v_lkp_type := 'US_BENEFIT_COVERAGE';
1479: v_dflt_value := 'EMP ONLY';
1480: v_val_formula_id := NULL; -- ??? By a formula to do some special sql?
1481: v_inpval_id := pay_db_pay_setup.create_input_value (
1482: p_element_name => p_ele_name,
1483: p_name => v_inpval_name,
1484: p_uom => v_inpval_uom,
1485: p_uom_code => NULL,

Line 1556: v_inpval_id := pay_db_pay_setup.create_input_value (

1552: v_gen_dbi := 'Y';
1553: v_lkp_type := NULL;
1554: v_dflt_value := NULL;
1555: v_val_formula_id := NULL;
1556: v_inpval_id := pay_db_pay_setup.create_input_value (
1557: p_element_name => p_ele_name,
1558: p_name => v_inpval_name,
1559: p_uom => v_inpval_uom,
1560: p_uom_code => NULL,

Line 1631: v_er_contr_inpval_id := pay_db_pay_setup.create_input_value (

1627: v_gen_dbi := 'Y';
1628: v_lkp_type := NULL;
1629: v_dflt_value := NULL;
1630: v_val_formula_id := NULL;
1631: v_er_contr_inpval_id := pay_db_pay_setup.create_input_value (
1632: p_element_name => p_ele_name,
1633: p_name => v_inpval_name,
1634: p_uom => v_inpval_uom,
1635: p_uom_code => NULL,

Line 1842: v_inpval_id := pay_db_pay_setup.create_input_value (

1838: v_gen_dbi := 'Y';
1839: v_lkp_type := NULL;
1840: v_dflt_value := NULL;
1841:
1842: v_inpval_id := pay_db_pay_setup.create_input_value (
1843: p_element_name => p_ele_name,
1844: p_name => v_inpval_name,
1845: p_uom => v_inpval_uom,
1846: p_uom_code => NULL,

Line 1957: v_actdedn_inpval_id := pay_db_pay_setup.create_input_value (

1953: v_gen_dbi := 'N';
1954: v_lkp_type := NULL;
1955: v_dflt_value := NULL;
1956:
1957: v_actdedn_inpval_id := pay_db_pay_setup.create_input_value (
1958: p_element_name => v_er_charge_ele_name,
1959: p_name => v_inpval_name,
1960: p_uom => v_inpval_uom,
1961: p_uom_code => NULL,

Line 2062: v_inpval_id := pay_db_pay_setup.create_input_value (

2058: v_inpval_uom := 'Money';
2059: v_gen_dbi := 'N'; -- Can be 'N', not needed by any other formulae
2060: v_lkp_type := NULL;
2061: v_dflt_value := NULL;
2062: v_inpval_id := pay_db_pay_setup.create_input_value (
2063: p_element_name => p_ele_name,
2064: p_name => v_inpval_name,
2065: p_uom => v_inpval_uom,
2066: p_uom_code => NULL,

Line 2136: g_topurch_inpval_id := pay_db_pay_setup.create_input_value (

2132: v_inpval_uom := 'Money';
2133: v_gen_dbi := 'N'; -- Can be 'N', not needed by any other formulae
2134: v_lkp_type := NULL;
2135: v_dflt_value := NULL;
2136: g_topurch_inpval_id := pay_db_pay_setup.create_input_value (
2137: p_element_name => p_shadow_ele_name,
2138: p_name => v_inpval_name,
2139: p_uom => v_inpval_uom,
2140: p_uom_code => NULL,

Line 2270: v_inpval_id := pay_db_pay_setup.create_input_value (

2266: v_inpval_uom := 'Money';
2267: v_gen_dbi := 'N';
2268: v_lkp_type := NULL;
2269: v_dflt_value := NULL;
2270: v_inpval_id := pay_db_pay_setup.create_input_value (
2271: p_element_name => p_ele_name,
2272: p_name => v_inpval_name,
2273: p_uom => v_inpval_uom,
2274: p_uom_code => NULL,

Line 2347: v_inpval_id := pay_db_pay_setup.create_input_value (

2343: v_inpval_uom := 'Character';
2344: v_gen_dbi := 'N';
2345: -- v_lkp_type := 'US_VALID_ELE_TYPES'; User can define.
2346: v_dflt_value := NULL;
2347: v_inpval_id := pay_db_pay_setup.create_input_value (
2348: p_element_name => p_ele_name,
2349: p_name => v_inpval_name,
2350: p_uom => v_inpval_uom,
2351: p_uom_code => NULL,

Line 2434: v_inpval_id := pay_db_pay_setup.create_input_value (

2430: v_inpval_uom := 'Money';
2431: v_gen_dbi := 'N';
2432: v_lkp_type := NULL;
2433: v_dflt_value := NULL;
2434: v_inpval_id := pay_db_pay_setup.create_input_value (
2435: p_element_name => p_ele_name,
2436: p_name => v_inpval_name,
2437: p_uom => v_inpval_uom,
2438: p_uom_code => NULL,

Line 2508: g_to_tot_inpval_id := pay_db_pay_setup.create_input_value (

2504: v_inpval_uom := 'Money';
2505: v_gen_dbi := 'N';
2506: v_lkp_type := NULL;
2507: v_dflt_value := NULL;
2508: g_to_tot_inpval_id := pay_db_pay_setup.create_input_value (
2509: p_element_name => p_shadow_ele_name,
2510: p_name => v_inpval_name,
2511: p_uom => v_inpval_uom,
2512: p_uom_code => NULL,

Line 2582: v_inpval_id :=pay_db_pay_setup.create_input_value (

2578: v_inpval_uom := 'Character';
2579: v_gen_dbi := 'N';
2580: v_lkp_type := 'YES_NO';
2581: v_dflt_value := 'Y';
2582: v_inpval_id :=pay_db_pay_setup.create_input_value (
2583: p_element_name => p_ele_name,
2584: p_name => v_inpval_name,
2585: p_uom => v_inpval_uom,
2586: p_uom_code => NULL,

Line 2692: v_inpval_id :=pay_db_pay_setup.create_input_value (

2688: v_inpval_uom := 'Character';
2689: v_gen_dbi := 'N';
2690: v_lkp_type := 'YES_NO';
2691: v_dflt_value := 'N';
2692: v_inpval_id :=pay_db_pay_setup.create_input_value (
2693: p_element_name => p_ele_name,
2694: p_name => v_inpval_name,
2695: p_uom => v_inpval_uom,
2696: p_uom_code => NULL,

Line 2780: g_arrears_contr_inpval_id := pay_db_pay_setup.create_input_value (

2776: v_inpval_uom := 'Money';
2777: v_gen_dbi := 'N';
2778: v_lkp_type := NULL;
2779: v_dflt_value := NULL;
2780: g_arrears_contr_inpval_id := pay_db_pay_setup.create_input_value (
2781: p_element_name => p_shadow_ele_name,
2782: p_name => v_inpval_name,
2783: p_uom => v_inpval_uom,
2784: p_uom_code => NULL,

Line 2878: g_notaken_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_notaken_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 2979: v_passthru_inpval_id := pay_db_pay_setup.create_input_value (

2975: v_gen_dbi := 'N';
2976: v_lkp_type := 'YES_NO';
2977: v_dflt_value := 'N';
2978:
2979: v_passthru_inpval_id := pay_db_pay_setup.create_input_value (
2980: p_element_name => p_ele_name,
2981: p_name => v_inpval_name,
2982: p_uom => v_inpval_uom,
2983: p_uom_code => NULL,

Line 3104: gi_repl_inpval_id := pay_db_pay_setup.create_input_value (

3100: v_gen_dbi := 'N';
3101: v_lkp_type := NULL;
3102: v_dflt_value := NULL;
3103:
3104: gi_repl_inpval_id := pay_db_pay_setup.create_input_value (
3105: p_element_name => p_inputs_ele_name,
3106: p_name => v_inpval_name,
3107: p_uom => v_inpval_uom,
3108: p_uom_code => NULL,

Line 3176: gi_addl_inpval_id := pay_db_pay_setup.create_input_value (

3172: v_gen_dbi := 'N';
3173: v_lkp_type := NULL;
3174: v_dflt_value := NULL;
3175:
3176: gi_addl_inpval_id := pay_db_pay_setup.create_input_value (
3177: p_element_name => p_inputs_ele_name,
3178: p_name => v_inpval_name,
3179: p_uom => v_inpval_uom,
3180: p_uom_code => NULL,

Line 3247: g_adj_arrears_inpval_id := pay_db_pay_setup.create_input_value (

3243: v_gen_dbi := 'N';
3244: v_lkp_type := NULL;
3245: v_dflt_value := NULL;
3246:
3247: g_adj_arrears_inpval_id := pay_db_pay_setup.create_input_value (
3248: p_element_name => p_inputs_ele_name,
3249: p_name => v_inpval_name,
3250: p_uom => v_inpval_uom,
3251: p_uom_code => NULL,

Line 3326: g_repl_inpval_id := pay_db_pay_setup.create_input_value (

3322: v_gen_dbi := 'N';
3323: v_lkp_type := NULL;
3324: v_dflt_value := NULL;
3325:
3326: g_repl_inpval_id := pay_db_pay_setup.create_input_value (
3327: p_element_name => p_shadow_ele_name,
3328: p_name => v_inpval_name,
3329: p_uom => v_inpval_uom,
3330: p_uom_code => NULL,

Line 3398: g_addl_inpval_id := pay_db_pay_setup.create_input_value (

3394: v_gen_dbi := 'N';
3395: v_lkp_type := NULL;
3396: v_dflt_value := NULL;
3397:
3398: g_addl_inpval_id := pay_db_pay_setup.create_input_value (
3399: p_element_name => p_shadow_ele_name,
3400: p_name => v_inpval_name,
3401: p_uom => v_inpval_uom,
3402: p_uom_code => NULL,

Line 3627: pay_db_pay_setup.create_defined_balance(

3623: NULL;
3624:
3625: ELSIF suffixes(i) = '_ASG_GRE_RUN' THEN
3626:
3627: pay_db_pay_setup.create_defined_balance(
3628: p_balance_name => p_bal_name,
3629: p_balance_dimension => dim_name,
3630: p_business_group_name => p_bg_name,
3631: p_legislation_code => NULL,

Line 3636: pay_db_pay_setup.create_defined_balance(

3632: p_save_run_bal => 'Y');
3633:
3634: ELSE
3635:
3636: pay_db_pay_setup.create_defined_balance(
3637: p_balance_name => p_bal_name,
3638: p_balance_dimension => dim_name,
3639: p_business_group_name => p_bg_name,
3640: p_legislation_code => NULL);

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

3655:
3656: --
3657: -- Set session date
3658: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',10);
3659: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
3660: g_eff_start_date := nvl(p_ele_eff_start_date, sysdate);
3661: g_eff_end_date := nvl(p_ele_eff_end_date, c_end_of_time);
3662:
3663:

Line 3721: v_bal_type_id := pay_db_pay_setup.create_balance_type(

3717: else
3718: l_balance_category := 'After-Tax Deductions';
3719: end if;
3720:
3721: v_bal_type_id := pay_db_pay_setup.create_balance_type(
3722: p_balance_name => p_ele_name,
3723: p_uom => 'Money',
3724: p_reporting_name => p_ele_name,
3725: p_business_group_name => v_bg_name,

Line 3744: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(

3740:
3741: v_addl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Additional';
3742: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Additional';
3743: hr_utility.set_location('pyusuidt',119);
3744: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3745: p_balance_name => v_addl_amt_bal_name,
3746: p_uom => 'Money',
3747: p_reporting_name => v_addl_amt_bal_name,
3748: p_business_group_name => v_bg_name,

Line 3756: pay_db_pay_setup.create_defined_balance (

3752: p_bc_leg_code => 'US',
3753: p_effective_date => g_eff_start_date);
3754:
3755: hr_utility.set_location('pyusuidt',127);
3756: pay_db_pay_setup.create_defined_balance (
3757: p_balance_name => v_addl_amt_bal_name,
3758: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3759: p_business_group_name => v_bg_name,
3760: p_legislation_code => NULL);

Line 3765: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(

3761:
3762: v_repl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Replacement';
3763: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Replacement';
3764: hr_utility.set_location('pyusuidt',119);
3765: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3766: p_balance_name => v_repl_amt_bal_name,
3767: p_uom => 'Money',
3768: p_reporting_name => v_repl_amt_bal_name,
3769: p_business_group_name => v_bg_name,

Line 3777: pay_db_pay_setup.create_defined_balance (

3773: p_bc_leg_code => 'US',
3774: p_effective_date => g_eff_start_date);
3775:
3776: hr_utility.set_location('pyusuidt',129);
3777: pay_db_pay_setup.create_defined_balance (
3778: p_balance_name => v_repl_amt_bal_name,
3779: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3780: p_business_group_name => v_bg_name,
3781: p_legislation_code => NULL);

Line 3788: v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(

3784:
3785: v_balance_name := SUBSTR(p_ele_name, 1, 67)||' Not Taken';
3786: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Not Taken';
3787: hr_utility.set_location('pyusuidt',130);
3788: v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(
3789: p_balance_name => v_balance_name,
3790: p_uom => 'Money',
3791: p_reporting_name => v_balance_name,
3792: p_business_group_name => v_bg_name,

Line 3800: pay_db_pay_setup.create_defined_balance (

3796: p_bc_leg_code => 'US',
3797: p_effective_date => g_eff_start_date);
3798:
3799: hr_utility.set_location('pyusuidt',131);
3800: pay_db_pay_setup.create_defined_balance (
3801: p_balance_name => v_balance_name,
3802: p_balance_dimension => 'Person Run',
3803: p_business_group_name => v_bg_name,
3804: p_legislation_code => NULL);

Line 3806: pay_db_pay_setup.create_defined_balance (

3802: p_balance_dimension => 'Person Run',
3803: p_business_group_name => v_bg_name,
3804: p_legislation_code => NULL);
3805:
3806: pay_db_pay_setup.create_defined_balance (
3807: p_balance_name => v_balance_name,
3808: p_balance_dimension => 'Person within Government Reporting Entity Run',
3809: p_business_group_name => v_bg_name,
3810: p_legislation_code => NULL);

Line 3813: pay_db_pay_setup.create_defined_balance (

3809: p_business_group_name => v_bg_name,
3810: p_legislation_code => NULL);
3811:
3812: hr_utility.set_location('pyusuidt',131);
3813: pay_db_pay_setup.create_defined_balance (
3814: p_balance_name => v_balance_name,
3815: p_balance_dimension => 'Assignment-Level Current Run',
3816: p_business_group_name => v_bg_name,
3817: p_legislation_code => NULL);

Line 3819: pay_db_pay_setup.create_defined_balance (

3815: p_balance_dimension => 'Assignment-Level Current Run',
3816: p_business_group_name => v_bg_name,
3817: p_legislation_code => NULL);
3818:
3819: pay_db_pay_setup.create_defined_balance (
3820: p_balance_name => v_balance_name,
3821: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
3822: p_business_group_name => v_bg_name,
3823: p_legislation_code => NULL,

Line 3832: v_eepurch_bal_type_id := pay_db_pay_setup.create_balance_type(

3828:
3829: v_balance_name := substr(p_ele_name, 1, 55)||' Toward Bond Purchase';
3830: --v_bal_rpt_name := substr(p_ele_name, 1, 13)||' To Bond Purch';
3831: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',39);
3832: v_eepurch_bal_type_id := pay_db_pay_setup.create_balance_type(
3833: p_balance_name => v_balance_name,
3834: p_uom => 'Money',
3835: p_reporting_name => v_balance_name,
3836: p_business_group_name => v_bg_name,

Line 3844: pay_db_pay_setup.create_defined_balance (

3840: p_bc_leg_code => 'US',
3841: p_effective_date => g_eff_start_date);
3842:
3843: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',41);
3844: pay_db_pay_setup.create_defined_balance (
3845: p_balance_name => v_balance_name,
3846: p_balance_dimension => 'Assignment Inception to Date',
3847: p_business_group_name => v_bg_name,
3848: p_legislation_code => NULL);

Line 3850: pay_db_pay_setup.create_defined_balance (

3846: p_balance_dimension => 'Assignment Inception to Date',
3847: p_business_group_name => v_bg_name,
3848: p_legislation_code => NULL);
3849:
3850: pay_db_pay_setup.create_defined_balance (
3851: p_balance_name => v_balance_name,
3852: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3853: p_business_group_name => v_bg_name,
3854: p_legislation_code => NULL);

Line 3859: v_totowed_bal_type_id := pay_db_pay_setup.create_balance_type(

3855:
3856: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',43);
3857: v_balance_name := substr(p_ele_name, 1, 71)||' Accrued';
3858: --v_bal_rpt_name := substr(p_ele_name, 1, 21)||' Accrued';
3859: v_totowed_bal_type_id := pay_db_pay_setup.create_balance_type(
3860: p_balance_name => v_balance_name,
3861: p_uom => 'Money',
3862: p_reporting_name => v_balance_name,
3863: p_business_group_name => v_bg_name,

Line 3871: pay_db_pay_setup.create_defined_balance (

3867: p_bc_leg_code => 'US',
3868: p_effective_date => g_eff_start_date);
3869:
3870: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',45);
3871: pay_db_pay_setup.create_defined_balance (
3872: p_balance_name => v_balance_name,
3873: p_balance_dimension => 'Assignment Inception to Date',
3874: p_business_group_name => v_bg_name,
3875: p_legislation_code => NULL);

Line 3877: pay_db_pay_setup.create_defined_balance (

3873: p_balance_dimension => 'Assignment Inception to Date',
3874: p_business_group_name => v_bg_name,
3875: p_legislation_code => NULL);
3876:
3877: pay_db_pay_setup.create_defined_balance (
3878: p_balance_name => v_balance_name,
3879: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3880: p_business_group_name => v_bg_name,
3881: p_legislation_code => NULL);

Line 3883: pay_db_pay_setup.create_defined_balance(

3879: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3880: p_business_group_name => v_bg_name,
3881: p_legislation_code => NULL);
3882:
3883: pay_db_pay_setup.create_defined_balance(
3884: p_balance_name => v_balance_name,
3885: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
3886: p_business_group_name => v_bg_name,
3887: p_legislation_code => NULL,

Line 3892: pay_db_pay_setup.create_defined_balance (

3888: p_save_run_bal => 'Y');
3889: --
3890: -- Adding _ENTRY_ITD Balance Dimension For Bug# 6270794
3891: --
3892: pay_db_pay_setup.create_defined_balance (
3893: p_balance_name => v_balance_name,
3894: p_balance_dimension => 'US Element Entry Inception to Date',
3895: p_business_group_name => v_bg_name,
3896: p_legislation_code => NULL);

Line 3901: v_arrears_bal_type_id := pay_db_pay_setup.create_balance_type(

3897:
3898: v_balance_name := substr(p_ele_name, 1, 71)||' Arrears';
3899: --v_bal_rpt_name := substr(p_ele_name, 1, 21)||' Arrears';
3900: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',47);
3901: v_arrears_bal_type_id := pay_db_pay_setup.create_balance_type(
3902: p_balance_name => v_balance_name,
3903: p_uom => 'Money',
3904: p_reporting_name => v_balance_name,
3905: p_business_group_name => v_bg_name,

Line 3913: pay_db_pay_setup.create_defined_balance (

3909: p_bc_leg_code => 'US',
3910: p_effective_date => g_eff_start_date);
3911:
3912: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',49);
3913: pay_db_pay_setup.create_defined_balance (
3914: p_balance_name => v_balance_name,
3915: p_balance_dimension => 'Assignment Inception to Date',
3916: p_business_group_name => v_bg_name,
3917: p_legislation_code => NULL);

Line 3919: pay_db_pay_setup.create_defined_balance (

3915: p_balance_dimension => 'Assignment Inception to Date',
3916: p_business_group_name => v_bg_name,
3917: p_legislation_code => NULL);
3918:
3919: pay_db_pay_setup.create_defined_balance (
3920: p_balance_name => v_balance_name,
3921: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
3922: p_business_group_name => v_bg_name,
3923: p_legislation_code => NULL);

Line 3927: pay_db_pay_setup.create_defined_balance (

3923: p_legislation_code => NULL);
3924:
3925: -- WWbug333133 - create _GRE_ITD dimension for arrears
3926:
3927: pay_db_pay_setup.create_defined_balance (
3928: p_balance_name => v_balance_name,
3929: p_balance_dimension => 'Government Reporting Entity Inception to Date',
3930: p_business_group_name => v_bg_name,
3931: p_legislation_code => NULL);

Line 3934: pay_db_pay_setup.create_defined_balance(

3930: p_business_group_name => v_bg_name,
3931: p_legislation_code => NULL);
3932:
3933: --
3934: pay_db_pay_setup.create_defined_balance(
3935: p_balance_name => v_balance_name,
3936: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
3937: p_business_group_name => v_bg_name,
3938: p_legislation_code => NULL,

Line 3948: v_eligiblecomp_bal_type_id := pay_db_pay_setup.create_balance_type(

3944: -- Begin Create Eligible Comp Balance
3945: v_balance_name := SUBSTR(p_ele_name, 1, 66)||' Eligible Comp';
3946: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 16)||' Eligible Comp';
3947: hr_utility.set_location('pyusuidt',240);
3948: v_eligiblecomp_bal_type_id := pay_db_pay_setup.create_balance_type(
3949: p_balance_name => v_balance_name,
3950: p_uom => 'Money',
3951: p_reporting_name => v_balance_name,
3952: p_business_group_name => v_bg_name,

Line 3988: pay_db_pay_setup.create_defined_balance (

3984:
3985: end if;
3986:
3987: hr_utility.set_location('pyusuidt',241);
3988: pay_db_pay_setup.create_defined_balance (
3989: p_balance_name => v_balance_name,
3990: p_balance_dimension => 'Person Run',
3991: p_business_group_name => v_bg_name,
3992: p_legislation_code => NULL);

Line 3994: pay_db_pay_setup.create_defined_balance (

3990: p_balance_dimension => 'Person Run',
3991: p_business_group_name => v_bg_name,
3992: p_legislation_code => NULL);
3993:
3994: pay_db_pay_setup.create_defined_balance (
3995: p_balance_name => v_balance_name,
3996: p_balance_dimension => 'Person within Government Reporting Entity Run',
3997: p_business_group_name => v_bg_name,
3998: p_legislation_code => NULL);

Line 4001: pay_db_pay_setup.create_defined_balance (

3997: p_business_group_name => v_bg_name,
3998: p_legislation_code => NULL);
3999:
4000: hr_utility.set_location('pyusuidt',243);
4001: pay_db_pay_setup.create_defined_balance (
4002: p_balance_name => v_balance_name,
4003: p_balance_dimension => 'Assignment-Level Current Run',
4004: p_business_group_name => v_bg_name,
4005: p_legislation_code => NULL);

Line 4007: pay_db_pay_setup.create_defined_balance (

4003: p_balance_dimension => 'Assignment-Level Current Run',
4004: p_business_group_name => v_bg_name,
4005: p_legislation_code => NULL);
4006:
4007: pay_db_pay_setup.create_defined_balance (
4008: p_balance_name => v_balance_name,
4009: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
4010: p_business_group_name => v_bg_name,
4011: p_legislation_code => NULL);

Line 4014: pay_db_pay_setup.create_defined_balance (

4010: p_business_group_name => v_bg_name,
4011: p_legislation_code => NULL);
4012:
4013:
4014: pay_db_pay_setup.create_defined_balance (
4015: p_balance_name => v_balance_name,
4016: p_balance_dimension => 'Assignment within Government Reporting Entity Year to Date',
4017: p_business_group_name => v_bg_name,
4018: p_legislation_code => NULL);

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

4026: --IF p_ele_at_component = 'Y' THEN
4027: v_balance_name := SUBSTR(p_ele_name, 1, 67)||' Overlimit';
4028: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Overlimit';
4029: hr_utility.set_location('pyusuidt',245);
4030: --v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(
4031: v_overlimit_bal_type_id := pay_db_pay_setup.create_balance_type(
4032: p_balance_name => v_balance_name,
4033: p_uom => 'Money',
4034: p_reporting_name => v_balance_name,

Line 4031: v_overlimit_bal_type_id := pay_db_pay_setup.create_balance_type(

4027: v_balance_name := SUBSTR(p_ele_name, 1, 67)||' Overlimit';
4028: --v_bal_rpt_name := SUBSTR(p_ele_name, 1, 17)||' Overlimit';
4029: hr_utility.set_location('pyusuidt',245);
4030: --v_notaken_bal_type_id := pay_db_pay_setup.create_balance_type(
4031: v_overlimit_bal_type_id := pay_db_pay_setup.create_balance_type(
4032: p_balance_name => v_balance_name,
4033: p_uom => 'Money',
4034: p_reporting_name => v_balance_name,
4035: p_business_group_name => v_bg_name,

Line 4043: pay_db_pay_setup.create_defined_balance (

4039: p_bc_leg_code => 'US',
4040: p_effective_date => g_eff_start_date);
4041:
4042: hr_utility.set_location('pyusuidt',246);
4043: pay_db_pay_setup.create_defined_balance (
4044: p_balance_name => v_balance_name,
4045: p_balance_dimension => 'Person Run',
4046: p_business_group_name => v_bg_name,
4047: p_legislation_code => NULL);

Line 4051: pay_db_pay_setup.create_defined_balance (

4047: p_legislation_code => NULL);
4048:
4049:
4050: hr_utility.set_location('pyusuidt',247);
4051: pay_db_pay_setup.create_defined_balance (
4052: p_balance_name => v_balance_name,
4053: p_balance_dimension => 'Assignment-Level Current Run',
4054: p_business_group_name => v_bg_name,
4055: p_legislation_code => NULL);

Line 4057: pay_db_pay_setup.create_defined_balance (

4053: p_balance_dimension => 'Assignment-Level Current Run',
4054: p_business_group_name => v_bg_name,
4055: p_legislation_code => NULL);
4056:
4057: pay_db_pay_setup.create_defined_balance (
4058: p_balance_name => v_balance_name,
4059: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
4060: p_business_group_name => v_bg_name,
4061: p_legislation_code => NULL);

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

4254: --
4255: -- Create Pay Value for this element.
4256: --
4257: -- NO, "Employer Liabilities" has non-payments flag = 'N'!
4258: -- So a payvalue is created by pay_db_pay_setup.create_element
4259: -- Need to do this for Non-Payments where non_payments_flag = 'Y',
4260: -- (done for Earnings, but was snagging on "dbi name already used"
4261: -- which i think is a bug.
4262:

Line 4269: v_er_charge_baltype_id := pay_db_pay_setup.create_balance_type(

4265: --
4266: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',58);
4267: v_balance_name := v_er_charge_ele_name;
4268: --v_bal_rpt_name := v_ele_repname;
4269: v_er_charge_baltype_id := pay_db_pay_setup.create_balance_type(
4270: p_balance_name => v_balance_name,
4271: p_uom => 'Money',
4272: p_reporting_name => v_balance_name,
4273: p_business_group_name => v_bg_name,

Line 4365: v_eerefund_baltype_id := pay_db_pay_setup.create_balance_type(

4361: --
4362: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',58);
4363: v_balance_name := v_eerefund_ele_name;
4364: --v_bal_rpt_name := v_ele_repname;
4365: v_eerefund_baltype_id := pay_db_pay_setup.create_balance_type(
4366: p_balance_name => v_balance_name,
4367: p_uom => 'Money',
4368: p_reporting_name => v_balance_name,
4369: p_business_group_name => v_bg_name,

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

4949: -- Populate vars.
4950: v_del_val_end := nvl(p_del_val_end_date, c_end_of_time);
4951: v_del_val_start := nvl(p_del_val_start_date, sysdate);
4952: v_del_sess_date := nvl(p_del_sess_date, sysdate);
4953: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));
4954:
4955: assoc_eles(1) := fnd_number.canonical_to_number(p_ele_info_18); -- Special Inputs ele
4956: assoc_eles(2) := fnd_number.canonical_to_number(p_ele_info_19); -- Special Features ele
4957: assoc_eles(3) := fnd_number.canonical_to_number(p_ele_info_20); -- Withholding ele