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_DB_PAY_SETUP

Line 214: pay_db_pay_setup.create_input_value

210: Re-numbered hr_utility.set_location
211: number to avoid duplicates.
212: 08-Oct-2002 ekim 115.21 Changed to use p_uom_code instead of
213: p_uom in call to
214: pay_db_pay_setup.create_input_value
215: 10-Oct-2002 ekim 115.22 fixed GSCC warnings.
216: 11-Nov-2002 ekim 115.23 for Input value of Rate Code, changed
217: v_gen_dbi = 'N' for formula
218: HOURS_X_RATE_NONRECUR_V2.

Line 259: 'pay_db_pay_setup.create_input_value.

255: 03-FEB-2005 RMONGE 115.34 Bug 4134473.
256: Modified package hr_user_init_earn to null out
257: the default values of local variables
258: v_lkp_type and v_dflt_value before calling
259: 'pay_db_pay_setup.create_input_value.
260: This applies to the following Input Values
261: Neg Earnings
262: Reduce Reg Hours
263: Reduce Reg Pay

Line 416: -- to pay_db_pay_setup from do_insertions.

412:
413: BEGIN
414: --
415: -- Unless this function actually has to do anything, we can make call
416: -- to pay_db_pay_setup from do_insertions.
417: --
418:
419: hr_utility.set_location('pyusuiet',1);
420: IF p_ele_processing_type = 'N' THEN

Line 435: v_eletype_id := pay_db_pay_setup.create_element(

431: -- insert check for ele type existence here...return id if it does!
432: --
433:
434: hr_utility.set_location('pyusuiet',3);
435: v_eletype_id := pay_db_pay_setup.create_element(
436: p_element_name => p_ele_name,
437: p_description => p_ele_description,
438: p_classification_name => p_ele_class,
439: p_post_termination_rule => 'Final Close',

Line 855: v_inpval_id := pay_db_pay_setup.create_input_value (

851: v_gen_dbi := 'Y';
852:
853: -- check for input value existence before creating...return id if it exists...
854:
855: v_inpval_id := pay_db_pay_setup.create_input_value (
856: p_element_name => p_ele_name,
857: p_name => v_inpval_name,
858: p_uom_code => v_inpval_uom,
859: p_mandatory_flag => 'N',

Line 914: v_inpval_id := pay_db_pay_setup.create_input_value (

910: g_inpval_disp_seq := g_inpval_disp_seq + 1;
911: v_inpval_name := 'Rate';
912: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
913: v_gen_dbi := 'Y';
914: v_inpval_id := pay_db_pay_setup.create_input_value (
915: p_element_name => p_ele_name,
916: p_name => v_inpval_name,
917: p_uom_code => v_inpval_uom,
918: p_mandatory_flag => 'N',

Line 973: v_inpval_id := pay_db_pay_setup.create_input_value (

969: g_inpval_disp_seq := g_inpval_disp_seq + 1;
970: v_inpval_name := 'Rate Code';
971: v_inpval_uom := 'C';
972: v_gen_dbi := 'N';
973: v_inpval_id := pay_db_pay_setup.create_input_value (
974: p_element_name => p_ele_name,
975: p_name => v_inpval_name,
976: p_uom_code => v_inpval_uom,
977: p_mandatory_flag => 'N',

Line 1043: v_inpval_id := pay_db_pay_setup.create_input_value (

1039: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1040: v_inpval_name := 'Shift';
1041: v_inpval_uom := 'C';
1042: v_gen_dbi := 'N';
1043: v_inpval_id := pay_db_pay_setup.create_input_value (
1044: p_element_name => p_ele_name,
1045: p_name => v_inpval_name,
1046: p_uom_code => v_inpval_uom,
1047: p_mandatory_flag => 'N',

Line 1105: v_inpval_id := pay_db_pay_setup.create_input_value (

1101: v_inpval_uom := 'Date (DD-MON-YYYY)';
1102: v_gen_dbi := 'N';
1103:
1104: hr_utility.set_location('pyusuiet',180);
1105: v_inpval_id := pay_db_pay_setup.create_input_value (
1106: p_element_name => p_ele_name,
1107: p_name => v_inpval_name,
1108: p_uom_code => v_inpval_uom,
1109: p_mandatory_flag => 'N',

Line 1332: v_inpval_id := pay_db_pay_setup.create_input_value (

1328: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1329: v_inpval_name := 'Hours';
1330: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
1331: v_gen_dbi := 'Y';
1332: v_inpval_id := pay_db_pay_setup.create_input_value (
1333: p_element_name => p_ele_name,
1334: p_name => v_inpval_name,
1335: p_uom_code => v_inpval_uom,
1336: p_mandatory_flag => 'N',

Line 1391: v_inpval_id := pay_db_pay_setup.create_input_value (

1387: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1388: v_inpval_name := 'Multiple';
1389: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
1390: v_gen_dbi := 'Y';
1391: v_inpval_id := pay_db_pay_setup.create_input_value (
1392: p_element_name => p_ele_name,
1393: p_name => v_inpval_name,
1394: p_uom_code => v_inpval_uom,
1395: p_mandatory_flag => 'N',

Line 1450: v_inpval_id := pay_db_pay_setup.create_input_value (

1446: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1447: v_inpval_name := 'Rate';
1448: v_inpval_uom := 'N'; -- Check that this can go out to 5 dec.
1449: v_gen_dbi := 'Y';
1450: v_inpval_id := pay_db_pay_setup.create_input_value (
1451: p_element_name => p_ele_name,
1452: p_name => v_inpval_name,
1453: p_uom_code => v_inpval_uom,
1454: p_mandatory_flag => 'N',

Line 1509: v_inpval_id := pay_db_pay_setup.create_input_value (

1505: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1506: v_inpval_name := 'Rate Code';
1507: v_inpval_uom := 'C';
1508: v_gen_dbi := 'N';
1509: v_inpval_id := pay_db_pay_setup.create_input_value (
1510: p_element_name => p_ele_name,
1511: p_name => v_inpval_name,
1512: p_uom_code => v_inpval_uom,
1513: p_mandatory_flag => 'N',

Line 1759: v_inpval_id := pay_db_pay_setup.create_input_value (

1755: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1756: v_inpval_name := 'Percentage';
1757: v_inpval_uom := 'N';
1758: v_gen_dbi := 'Y';
1759: v_inpval_id := pay_db_pay_setup.create_input_value (
1760: p_element_name => p_ele_name,
1761: p_name => v_inpval_name,
1762: p_uom_code => v_inpval_uom,
1763: p_mandatory_flag => 'N',

Line 1893: v_inpval_id := pay_db_pay_setup.create_input_value (

1889: g_inpval_disp_seq := g_inpval_disp_seq + 1;
1890: v_inpval_name := 'Amount';
1891: v_inpval_uom := 'M';
1892: v_gen_dbi := 'Y';
1893: v_inpval_id := pay_db_pay_setup.create_input_value (
1894: p_element_name => p_ele_name,
1895: p_name => v_inpval_name,
1896: p_uom_code => v_inpval_uom,
1897: p_mandatory_flag => 'N',

Line 2098: v_inpval_id := pay_db_pay_setup.create_input_value (

2094: v_gen_dbi := 'N';
2095: v_lkp_type := NULL;
2096: --
2097: hr_utility.set_location('pyusuiet',470);
2098: v_inpval_id := pay_db_pay_setup.create_input_value (
2099: p_element_name => p_ele_name,
2100: p_name => v_inpval_name,
2101: p_uom_code => v_inpval_uom,
2102: p_mandatory_flag => 'N',

Line 2172: v_inpval_id := pay_db_pay_setup.create_input_value (

2168: v_gen_dbi := 'N';
2169: v_lkp_type := 'YES_NO';
2170: v_dflt_value := 'N';
2171: --
2172: v_inpval_id := pay_db_pay_setup.create_input_value (
2173: p_element_name => p_ele_name,
2174: p_name => v_inpval_name,
2175: p_uom_code => v_inpval_uom,
2176: p_mandatory_flag => 'N',

Line 2266: v_inpval_id := pay_db_pay_setup.create_input_value (

2262: v_mand_flag := 'Y';
2263: END IF;
2264:
2265: hr_utility.set_location('pyusuiet',510);
2266: v_inpval_id := pay_db_pay_setup.create_input_value (
2267: p_element_name => p_ele_name,
2268: p_name => v_inpval_name,
2269: p_uom_code => v_inpval_uom,
2270: p_mandatory_flag => v_mand_flag,

Line 2362: v_inpval_id := pay_db_pay_setup.create_input_value (

2358:
2359: END IF;
2360:
2361: hr_utility.set_location('pyusuiet',530);
2362: v_inpval_id := pay_db_pay_setup.create_input_value (
2363: p_element_name => p_ele_name,
2364: p_name => v_inpval_name,
2365: p_uom_code => v_inpval_uom,
2366: p_mandatory_flag => v_mand_flag,

Line 2440: v_inpval_id := pay_db_pay_setup.create_input_value (

2436: v_gen_dbi := 'N';
2437:
2438: hr_utility.trace('The input value name is '|| v_inpval_name );
2439: hr_utility.set_location('pyusuiet',550);
2440: v_inpval_id := pay_db_pay_setup.create_input_value (
2441: p_element_name => p_ele_name,
2442: p_name => v_inpval_name,
2443: p_uom_code => v_inpval_uom,
2444: p_mandatory_flag => 'N',

Line 2510: gi_repl_inpval_id := pay_db_pay_setup.create_input_value (

2506: v_inpval_uom := 'M';
2507: v_gen_dbi := 'N';
2508: v_lkp_type := NULL;
2509: v_dflt_value := NULL;
2510: gi_repl_inpval_id := pay_db_pay_setup.create_input_value (
2511: p_element_name => p_inputs_ele_name,
2512: p_name => v_inpval_name,
2513: p_uom_code => v_inpval_uom,
2514: p_mandatory_flag => 'N',

Line 2582: gi_addl_inpval_id := pay_db_pay_setup.create_input_value (

2578: v_inpval_uom := 'M';
2579: v_gen_dbi := 'N';
2580: v_lkp_type := NULL;
2581: v_dflt_value := NULL;
2582: gi_addl_inpval_id := pay_db_pay_setup.create_input_value (
2583: p_element_name => p_inputs_ele_name,
2584: p_name => v_inpval_name,
2585: p_uom_code => v_inpval_uom,
2586: p_mandatory_flag => 'N',

Line 2670: g_repl_inpval_id := pay_db_pay_setup.create_input_value (

2666: v_inpval_uom := 'M';
2667: v_gen_dbi := 'N';
2668: v_lkp_type := NULL;
2669: v_dflt_value := NULL;
2670: g_repl_inpval_id := pay_db_pay_setup.create_input_value (
2671: p_element_name => p_shadow_ele_name,
2672: p_name => v_inpval_name,
2673: p_uom_code => v_inpval_uom,
2674: p_mandatory_flag => 'N',

Line 2742: g_addl_inpval_id := pay_db_pay_setup.create_input_value (

2738: v_inpval_uom := 'M';
2739: v_gen_dbi := 'N';
2740: v_lkp_type := NULL;
2741: v_dflt_value := NULL;
2742: g_addl_inpval_id := pay_db_pay_setup.create_input_value (
2743: p_element_name => p_shadow_ele_name,
2744: p_name => v_inpval_name,
2745: p_uom_code => v_inpval_uom,
2746: p_mandatory_flag => 'N',

Line 2817: g_neg_earn_inpval_id := pay_db_pay_setup.create_input_value (

2813: v_inpval_uom := 'M';
2814: v_gen_dbi := 'N';
2815: v_lkp_type := NULL;
2816: v_dflt_value := NULL;
2817: g_neg_earn_inpval_id := pay_db_pay_setup.create_input_value (
2818: p_element_name => p_shadow_ele_name,
2819: p_name => v_inpval_name,
2820: p_uom_code => v_inpval_uom,
2821: p_mandatory_flag => 'N',

Line 2890: g_reduce_hrs_inpval_id := pay_db_pay_setup.create_input_value (

2886: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
2887: v_gen_dbi := 'N';
2888: v_lkp_type := NULL;
2889: v_dflt_value := NULL;
2890: g_reduce_hrs_inpval_id := pay_db_pay_setup.create_input_value (
2891: p_element_name => p_shadow_ele_name,
2892: p_name => v_inpval_name,
2893: p_uom_code => v_inpval_uom,
2894: p_mandatory_flag => 'N',

Line 2963: g_reduce_pay_inpval_id := pay_db_pay_setup.create_input_value (

2959: v_inpval_uom := 'M';
2960: v_gen_dbi := 'N';
2961: v_lkp_type := NULL;
2962: v_dflt_value := NULL;
2963: g_reduce_pay_inpval_id := pay_db_pay_setup.create_input_value (
2964: p_element_name => p_shadow_ele_name,
2965: p_name => v_inpval_name,
2966: p_uom_code => v_inpval_uom,
2967: p_mandatory_flag => 'N',

Line 3035: g_reduce_sal_hrs_inpval_id := pay_db_pay_setup.create_input_value (

3031: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
3032: v_gen_dbi := 'N';
3033: v_lkp_type := NULL;
3034: v_dflt_value := NULL;
3035: g_reduce_sal_hrs_inpval_id := pay_db_pay_setup.create_input_value (
3036: p_element_name => p_shadow_ele_name,
3037: p_name => v_inpval_name,
3038: p_uom_code => v_inpval_uom,
3039: p_mandatory_flag => 'N',

Line 3107: g_reduce_sal_pay_inpval_id := pay_db_pay_setup.create_input_value (

3103: v_inpval_uom := 'M';
3104: v_gen_dbi := 'N';
3105: v_lkp_type := NULL;
3106: v_dflt_value := NULL;
3107: g_reduce_sal_pay_inpval_id := pay_db_pay_setup.create_input_value (
3108: p_element_name => p_shadow_ele_name,
3109: p_name => v_inpval_name,
3110: p_uom_code => v_inpval_uom,
3111: p_mandatory_flag => 'N',

Line 3179: g_reduce_wag_hrs_inpval_id := pay_db_pay_setup.create_input_value (

3175: v_inpval_uom := 'H_DECIMAL2'; --Hours in Decimal format (2 places)
3176: v_gen_dbi := 'N';
3177: v_lkp_type := NULL;
3178: v_dflt_value := NULL;
3179: g_reduce_wag_hrs_inpval_id := pay_db_pay_setup.create_input_value (
3180: p_element_name => p_shadow_ele_name,
3181: p_name => v_inpval_name,
3182: p_uom_code => v_inpval_uom,
3183: p_mandatory_flag => 'N',

Line 3251: g_reduce_wag_pay_inpval_id := pay_db_pay_setup.create_input_value (

3247: v_inpval_uom := 'M';
3248: v_gen_dbi := 'N';
3249: v_lkp_type := NULL;
3250: v_dflt_value := NULL;
3251: g_reduce_wag_pay_inpval_id := pay_db_pay_setup.create_input_value (
3252: p_element_name => p_shadow_ele_name,
3253: p_name => v_inpval_name,
3254: p_uom_code => v_inpval_uom,
3255: p_mandatory_flag => 'N',

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

3773: --
3774: -- Set session date
3775:
3776: hr_utility.set_location('pyusuiet',785);
3777: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
3778: g_eff_start_date := NVL(p_ele_eff_start_date, sysdate);
3779: g_eff_end_date := NVL(p_ele_eff_end_date, c_end_of_time);
3780:
3781: -- Set globals: v_bg_name

Line 3827: -- in the call to 'pay_db_pay_setup.create_balance_type' for creating balances

3823:
3824: --
3825: -- Emp Balance form enhancement. Bug 3311781
3826: -- Used 'l_bal_cat_classification' for passing the value of p_balance_category
3827: -- in the call to 'pay_db_pay_setup.create_balance_type' for creating balances
3828:
3829: if upper(p_ele_classification) = 'EARNINGS' then
3830: l_bal_cat_classification := 'Earnings';
3831: elsif upper(p_ele_classification) = 'IMPUTED EARNINGS' then

Line 3840: v_bal_type_id := pay_db_pay_setup.create_balance_type(

3836: l_bal_cat_classification := 'Supplemental Earnings';
3837: end if;
3838:
3839: hr_utility.set_location('pyusuiet',805);
3840: v_bal_type_id := pay_db_pay_setup.create_balance_type(
3841: p_balance_name => p_ele_name,
3842: p_uom => null,
3843: p_uom_code => 'M',
3844: p_reporting_name => p_ele_name,

Line 3857: v_neg_earn_bal_type_id := pay_db_pay_setup.create_balance_type(

3853: v_neg_earnbal_name := SUBSTR(p_ele_name, 1, 65)||' Neg Earnings';
3854: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 15)||' Neg Earnings';
3855:
3856: hr_utility.set_location('pyusuiet',810);
3857: v_neg_earn_bal_type_id := pay_db_pay_setup.create_balance_type(
3858: p_balance_name => v_neg_earnbal_name,
3859: p_uom => null,
3860: p_uom_code => 'M',
3861: p_reporting_name => v_neg_earnbal_name,

Line 3880: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(

3876: v_addl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Additional';
3877: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 17)||' Additional';
3878:
3879: hr_utility.set_location('pyusuiet',815);
3880: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3881: p_balance_name => v_addl_amt_bal_name,
3882: p_uom => null,
3883: p_uom_code => 'M',
3884: p_reporting_name => v_addl_amt_bal_name,

Line 3896: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(

3892: v_repl_amt_bal_name := SUBSTR(p_ele_name, 1, 67)||' Replacement';
3893: --v_bal_repname := SUBSTR(p_ele_reporting_name, 1, 17)||' Replacement';
3894:
3895: hr_utility.set_location('pyusuiet',820);
3896: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(
3897: p_balance_name => v_repl_amt_bal_name,
3898: p_uom => null,
3899: p_uom_code => 'M',
3900: p_reporting_name => v_repl_amt_bal_name,

Line 3918: pay_db_pay_setup.create_defined_balance (

3914: --
3915: -- check for existence of defined balance before creating...return defbal id if already exists...
3916: --
3917:
3918: pay_db_pay_setup.create_defined_balance (
3919: p_balance_name => p_ele_name,
3920: p_balance_dimension => 'Assignment within Government Reporting Entity Year to Date',
3921: p_business_group_name => v_bg_name,
3922: p_legislation_code => NULL);

Line 3925: pay_db_pay_setup.create_defined_balance (

3921: p_business_group_name => v_bg_name,
3922: p_legislation_code => NULL);
3923:
3924: hr_utility.set_location('pyusuiet',830);
3925: pay_db_pay_setup.create_defined_balance (
3926: p_balance_name => p_ele_name,
3927: p_balance_dimension => 'Assignment within Government Reporting Entity Period to Date',
3928: p_business_group_name => v_bg_name,
3929: p_legislation_code => NULL);

Line 3932: pay_db_pay_setup.create_defined_balance (

3928: p_business_group_name => v_bg_name,
3929: p_legislation_code => NULL);
3930:
3931: hr_utility.set_location('pyusuiet',835);
3932: pay_db_pay_setup.create_defined_balance (
3933: p_balance_name => p_ele_name,
3934: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
3935: p_business_group_name => v_bg_name,
3936: p_legislation_code => NULL);

Line 3939: pay_db_pay_setup.create_defined_balance (

3935: p_business_group_name => v_bg_name,
3936: p_legislation_code => NULL);
3937:
3938: hr_utility.set_location('pyusuiet',840);
3939: pay_db_pay_setup.create_defined_balance (
3940: p_balance_name => p_ele_name,
3941: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
3942: p_business_group_name => v_bg_name,
3943: p_legislation_code => NULL,

Line 3947: pay_db_pay_setup.create_defined_balance (

3943: p_legislation_code => NULL,
3944: p_save_run_bal => 'Y');
3945:
3946: hr_utility.set_location('pyusuiet',845);
3947: pay_db_pay_setup.create_defined_balance (
3948: p_balance_name => p_ele_name,
3949: p_balance_dimension => 'Assignment within Government Reporting Entity Month',
3950: p_business_group_name => v_bg_name,
3951: p_legislation_code => NULL);

Line 3954: pay_db_pay_setup.create_defined_balance (

3950: p_business_group_name => v_bg_name,
3951: p_legislation_code => NULL);
3952:
3953: hr_utility.set_location('pyusuiet',850);
3954: pay_db_pay_setup.create_defined_balance (
3955: p_balance_name => p_ele_name,
3956: p_balance_dimension => 'Assignment-Level Current Run',
3957: p_business_group_name => v_bg_name,
3958: p_legislation_code => NULL);

Line 3961: pay_db_pay_setup.create_defined_balance (

3957: p_business_group_name => v_bg_name,
3958: p_legislation_code => NULL);
3959:
3960: hr_utility.set_location('pyusuiet',855);
3961: pay_db_pay_setup.create_defined_balance (
3962: p_balance_name => p_ele_name,
3963: p_balance_dimension => 'Assignment Period to Date',
3964: p_business_group_name => v_bg_name,
3965: p_legislation_code => NULL);

Line 3968: pay_db_pay_setup.create_defined_balance (

3964: p_business_group_name => v_bg_name,
3965: p_legislation_code => NULL);
3966:
3967: hr_utility.set_location('pyusuiet',860);
3968: pay_db_pay_setup.create_defined_balance (
3969: p_balance_name => p_ele_name,
3970: p_balance_dimension => 'Assignment Month',
3971: p_business_group_name => v_bg_name,
3972: p_legislation_code => NULL);

Line 3975: pay_db_pay_setup.create_defined_balance (

3971: p_business_group_name => v_bg_name,
3972: p_legislation_code => NULL);
3973:
3974: hr_utility.set_location('pyusuiet',865);
3975: pay_db_pay_setup.create_defined_balance (
3976: p_balance_name => p_ele_name,
3977: p_balance_dimension => 'Assignment Quarter to Date',
3978: p_business_group_name => v_bg_name,
3979: p_legislation_code => NULL);

Line 3982: pay_db_pay_setup.create_defined_balance (

3978: p_business_group_name => v_bg_name,
3979: p_legislation_code => NULL);
3980:
3981: hr_utility.set_location('pyusuiet',870);
3982: pay_db_pay_setup.create_defined_balance (
3983: p_balance_name => p_ele_name,
3984: p_balance_dimension => 'Assignment Year to Date',
3985: p_business_group_name => v_bg_name,
3986: p_legislation_code => NULL);

Line 3989: pay_db_pay_setup.create_defined_balance (

3985: p_business_group_name => v_bg_name,
3986: p_legislation_code => NULL);
3987:
3988: hr_utility.set_location('pyusuiet',875);
3989: pay_db_pay_setup.create_defined_balance (
3990: p_balance_name => p_ele_name,
3991: p_balance_dimension => 'Person Run',
3992: p_business_group_name => v_bg_name,
3993: p_legislation_code => NULL);

Line 3996: pay_db_pay_setup.create_defined_balance (

3992: p_business_group_name => v_bg_name,
3993: p_legislation_code => NULL);
3994:
3995: hr_utility.set_location('pyusuiet',880);
3996: pay_db_pay_setup.create_defined_balance (
3997: p_balance_name => p_ele_name,
3998: p_balance_dimension => 'Person Quarter to Date',
3999: p_business_group_name => v_bg_name,
4000: p_legislation_code => NULL);

Line 4003: pay_db_pay_setup.create_defined_balance (

3999: p_business_group_name => v_bg_name,
4000: p_legislation_code => NULL);
4001:
4002: hr_utility.set_location('pyusuiet',885);
4003: pay_db_pay_setup.create_defined_balance (
4004: p_balance_name => p_ele_name,
4005: p_balance_dimension => 'Person Year to Date',
4006: p_business_group_name => v_bg_name,
4007: p_legislation_code => NULL);

Line 4010: pay_db_pay_setup.create_defined_balance (

4006: p_business_group_name => v_bg_name,
4007: p_legislation_code => NULL);
4008:
4009: hr_utility.set_location('pyusuiet',890);
4010: pay_db_pay_setup.create_defined_balance (
4011: p_balance_name => p_ele_name,
4012: p_balance_dimension => 'Person Month',
4013: p_business_group_name => v_bg_name,
4014: p_legislation_code => NULL);

Line 4017: pay_db_pay_setup.create_defined_balance (

4013: p_business_group_name => v_bg_name,
4014: p_legislation_code => NULL);
4015:
4016: hr_utility.set_location('pyusuiet',895);
4017: pay_db_pay_setup.create_defined_balance (
4018: p_balance_name => p_ele_name,
4019: p_balance_dimension => 'Person within Government Reporting Entity Run',
4020: p_business_group_name => v_bg_name,
4021: p_legislation_code => NULL);

Line 4024: pay_db_pay_setup.create_defined_balance (

4020: p_business_group_name => v_bg_name,
4021: p_legislation_code => NULL);
4022:
4023: hr_utility.set_location('pyusuiet',900);
4024: pay_db_pay_setup.create_defined_balance (
4025: p_balance_name => p_ele_name,
4026: p_balance_dimension => 'Person within Government Reporting Entity Quarter to Date',
4027: p_business_group_name => v_bg_name,
4028: p_legislation_code => NULL);

Line 4031: pay_db_pay_setup.create_defined_balance (

4027: p_business_group_name => v_bg_name,
4028: p_legislation_code => NULL);
4029:
4030: hr_utility.set_location('pyusuiet',910);
4031: pay_db_pay_setup.create_defined_balance (
4032: p_balance_name => p_ele_name,
4033: p_balance_dimension => 'Person within Government Reporting Entity Year to Date',
4034: p_business_group_name => v_bg_name,
4035: p_legislation_code => NULL);

Line 4038: pay_db_pay_setup.create_defined_balance (

4034: p_business_group_name => v_bg_name,
4035: p_legislation_code => NULL);
4036:
4037: hr_utility.set_location('pyusuiet',915);
4038: pay_db_pay_setup.create_defined_balance (
4039: p_balance_name => p_ele_name,
4040: p_balance_dimension => 'Person within Government Reporting Entity Month',
4041: p_business_group_name => v_bg_name,
4042: p_legislation_code => NULL);

Line 4045: pay_db_pay_setup.create_defined_balance (

4041: p_business_group_name => v_bg_name,
4042: p_legislation_code => NULL);
4043:
4044: hr_utility.set_location('pyusuiet',920);
4045: pay_db_pay_setup.create_defined_balance (
4046: p_balance_name => p_ele_name,
4047: p_balance_dimension => 'Government Reporting Entity Year to Date',
4048: p_business_group_name => v_bg_name,
4049: p_legislation_code => NULL);

Line 4054: pay_db_pay_setup.create_defined_balance (

4050:
4051: /* *** WWBug 133133 start *** */
4052: /* Adding defined balances for GRE_RUN and GRE_ITD for primary balance */
4053: hr_utility.set_location('pyusuiet',925);
4054: pay_db_pay_setup.create_defined_balance (
4055: p_balance_name => p_ele_name,
4056: p_balance_dimension => 'Government Reporting Entity Run',
4057: p_business_group_name => v_bg_name,
4058: p_legislation_code => NULL);

Line 4063: pay_db_pay_setup.create_defined_balance (

4059:
4060: IF p_ele_processing_type = 'R' THEN /* Not required for NR Elements */
4061:
4062: hr_utility.set_location('pyusuiet',930);
4063: pay_db_pay_setup.create_defined_balance (
4064: p_balance_name => p_ele_name,
4065: p_balance_dimension => 'Government Reporting Entity Inception to Date',
4066: p_business_group_name => v_bg_name,
4067: p_legislation_code => NULL);

Line 4078: pay_db_pay_setup.create_defined_balance (

4074: IF UPPER(p_ele_classification) <> 'NON-PAYROLL PAYMENTS' THEN
4075: bug 1835350 end */
4076:
4077: hr_utility.set_location('pyusuiet',935);
4078: pay_db_pay_setup.create_defined_balance (
4079: p_balance_name => p_ele_name,
4080: p_balance_dimension => 'Payments',
4081: p_business_group_name => v_bg_name,
4082: p_legislation_code => NULL);

Line 4085: pay_db_pay_setup.create_defined_balance (

4081: p_business_group_name => v_bg_name,
4082: p_legislation_code => NULL);
4083:
4084: hr_utility.set_location('pyusuiet',940);
4085: pay_db_pay_setup.create_defined_balance (
4086: p_balance_name => p_ele_name,
4087: p_balance_dimension => 'Assignment Payments',
4088: p_business_group_name => v_bg_name,
4089: p_legislation_code => NULL);

Line 4100: pay_db_pay_setup.create_defined_balance (

4096: hr_utility.trace('p_ele_processing_type is '||p_ele_processing_type);
4097:
4098: IF p_ele_processing_type = 'R' THEN
4099: hr_utility.set_location('pyusuiet',945);
4100: pay_db_pay_setup.create_defined_balance (
4101: p_balance_name => v_neg_earnbal_name,
4102: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4103: p_business_group_name => v_bg_name,
4104: p_legislation_code => NULL);

Line 4110: pay_db_pay_setup.create_defined_balance (

4106: END IF;
4107: --
4108: IF p_ele_processing_type = 'R' THEN /* Not required for NR Elements */
4109: hr_utility.set_location('pyusuiet',950);
4110: pay_db_pay_setup.create_defined_balance (
4111: p_balance_name => v_addl_amt_bal_name,
4112: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4113: p_business_group_name => v_bg_name,
4114: p_legislation_code => NULL);

Line 4117: pay_db_pay_setup.create_defined_balance (

4113: p_business_group_name => v_bg_name,
4114: p_legislation_code => NULL);
4115:
4116: hr_utility.set_location('pyusuiet',955);
4117: pay_db_pay_setup.create_defined_balance (
4118: p_balance_name => v_repl_amt_bal_name,
4119: p_balance_dimension => 'Assignment within Government Reporting Entity Inception to Date',
4120: p_business_group_name => v_bg_name,
4121: p_legislation_code => NULL);

Line 4140: v_hrs_bal_type_id := pay_db_pay_setup.create_balance_type(

4136: v_hrs_bal_name := SUBSTR(p_ele_name, 1, 73)||' Hours';
4137: --v_hrs_bal_repname := SUBSTR(p_ele_reporting_name, 1, 23)||' Hours';
4138:
4139: hr_utility.set_location('pyusuiet',960);
4140: v_hrs_bal_type_id := pay_db_pay_setup.create_balance_type(
4141: p_balance_name => v_hrs_bal_name,
4142: p_uom => null,
4143: p_uom_code => 'H_DECIMAL2',
4144: p_reporting_name => v_hrs_bal_name,

Line 4153: pay_db_pay_setup.create_defined_balance (

4149: p_bc_leg_code => 'US',
4150: p_effective_date => g_eff_start_date);
4151:
4152: hr_utility.set_location('pyusuiet',965);
4153: pay_db_pay_setup.create_defined_balance (
4154: p_balance_name => v_hrs_bal_name,
4155: p_balance_dimension => 'Assignment-Level Current Run',
4156: p_business_group_name => v_bg_name,
4157: p_legislation_code => NULL);

Line 4160: pay_db_pay_setup.create_defined_balance (

4156: p_business_group_name => v_bg_name,
4157: p_legislation_code => NULL);
4158:
4159: hr_utility.set_location('pyusuiet',970);
4160: pay_db_pay_setup.create_defined_balance (
4161: p_balance_name => v_hrs_bal_name,
4162: p_balance_dimension => 'Assignment within Government Reporting Entity Run',
4163: p_business_group_name => v_bg_name,
4164: p_legislation_code => NULL,

Line 4169: pay_db_pay_setup.create_defined_balance (

4165: p_save_run_bal => 'Y');
4166:
4167: -- 16th Feb 1996 Fix - added Payments defined bal to Hours assoc bal.
4168: hr_utility.set_location('pyusuiet',975);
4169: pay_db_pay_setup.create_defined_balance (
4170: p_balance_name => v_hrs_bal_name,
4171: p_balance_dimension => 'Payments',
4172: p_business_group_name => v_bg_name,
4173: p_legislation_code => NULL);

Line 4176: pay_db_pay_setup.create_defined_balance (

4172: p_business_group_name => v_bg_name,
4173: p_legislation_code => NULL);
4174:
4175: hr_utility.set_location('pyusuiet',980);
4176: pay_db_pay_setup.create_defined_balance (
4177: p_balance_name => v_hrs_bal_name,
4178: p_balance_dimension => 'Assignment Quarter to Date',
4179: p_business_group_name => v_bg_name,
4180: p_legislation_code => NULL);

Line 4183: pay_db_pay_setup.create_defined_balance (

4179: p_business_group_name => v_bg_name,
4180: p_legislation_code => NULL);
4181:
4182: hr_utility.set_location('pyusuiet',985);
4183: pay_db_pay_setup.create_defined_balance (
4184: p_balance_name => v_hrs_bal_name,
4185: p_balance_dimension => 'Assignment Year to Date',
4186: p_business_group_name => v_bg_name,
4187: p_legislation_code => NULL);

Line 4190: pay_db_pay_setup.create_defined_balance (

4186: p_business_group_name => v_bg_name,
4187: p_legislation_code => NULL);
4188:
4189: hr_utility.set_location('pyusuiet',990);
4190: pay_db_pay_setup.create_defined_balance (
4191: p_balance_name => v_hrs_bal_name,
4192: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
4193: p_business_group_name => v_bg_name,
4194: p_legislation_code => NULL);

Line 4196: pay_db_pay_setup.create_defined_balance (

4192: p_balance_dimension => 'Assignment within Government Reporting Entity Quarter to Date',
4193: p_business_group_name => v_bg_name,
4194: p_legislation_code => NULL);
4195:
4196: pay_db_pay_setup.create_defined_balance (
4197: p_balance_name => v_hrs_bal_name,
4198: p_balance_dimension => 'Assignment within Government Reporting Entity Year to Date',
4199: p_business_group_name => v_bg_name,
4200: p_legislation_code => NULL);

Line 4203: pay_db_pay_setup.create_defined_balance (

4199: p_business_group_name => v_bg_name,
4200: p_legislation_code => NULL);
4201:
4202: hr_utility.set_location('pyusuiet',995);
4203: pay_db_pay_setup.create_defined_balance (
4204: p_balance_name => v_hrs_bal_name,
4205: p_balance_dimension => 'Assignment Payments',
4206: p_business_group_name => v_bg_name,
4207: p_legislation_code => NULL);

Line 4390: v_info_payval_id := pay_db_pay_setup.create_input_value (

4386: --
4387: v_grossup_class_name := p_ele_classification;
4388: --
4389: hr_utility.set_location('pyusuiet',1034);
4390: v_info_payval_id := pay_db_pay_setup.create_input_value (
4391: p_element_name => p_ele_name,
4392: p_name => 'Pay Value',
4393: p_uom_code => 'M',
4394: p_mandatory_flag => 'X',

Line 4480: v_shadow_info_payval_id := pay_db_pay_setup.create_input_value (

4476: 'N' ); -- process mode
4477:
4478: hr_utility.set_location('pyusuiet',1038);
4479:
4480: v_shadow_info_payval_id := pay_db_pay_setup.create_input_value (
4481: p_element_name => v_shadow_ele_name,
4482: p_name => 'Pay Value',
4483: p_uom_code => 'M',
4484: p_mandatory_flag => 'X',

Line 4546: v_inputs_info_payval_id := pay_db_pay_setup.create_input_value (

4542: v_bg_name,
4543: 'N' ); -- process mode
4544:
4545: hr_utility.set_location('pyusuiet',1045);
4546: v_inputs_info_payval_id := pay_db_pay_setup.create_input_value (
4547: p_element_name => v_inputs_ele_name,
4548: p_name => 'Pay Value',
4549: p_uom_code => 'M',
4550: p_mandatory_flag => 'X',