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 414: -- to pay_db_pay_setup from do_insertions.

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

Line 433: v_eletype_id := pay_db_pay_setup.create_element(

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

Line 853: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 912: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 971: v_inpval_id := pay_db_pay_setup.create_input_value (

967: g_inpval_disp_seq := g_inpval_disp_seq + 1;
968: v_inpval_name := 'Rate Code';
969: v_inpval_uom := 'C';
970: v_gen_dbi := 'N';
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_code => v_inpval_uom,
975: p_mandatory_flag => 'N',

Line 1041: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 1103: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 1330: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 1389: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 1448: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 1507: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 1757: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 1891: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2096: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2170: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2264: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2360: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2438: v_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2508: gi_repl_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2580: gi_addl_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2668: g_repl_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2740: g_addl_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2815: g_neg_earn_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2888: g_reduce_hrs_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 2961: g_reduce_pay_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 3033: g_reduce_sal_hrs_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 3105: g_reduce_sal_pay_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 3177: g_reduce_wag_hrs_inpval_id := pay_db_pay_setup.create_input_value (

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

Line 3249: g_reduce_wag_pay_inpval_id := pay_db_pay_setup.create_input_value (

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

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

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

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

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

Line 3838: v_bal_type_id := pay_db_pay_setup.create_balance_type(

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

Line 3855: v_neg_earn_bal_type_id := pay_db_pay_setup.create_balance_type(

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

Line 3878: v_addl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(

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

Line 3894: v_repl_amt_bal_type_id := pay_db_pay_setup.create_balance_type(

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

Line 3916: pay_db_pay_setup.create_defined_balance (

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

Line 3923: pay_db_pay_setup.create_defined_balance (

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

Line 3930: pay_db_pay_setup.create_defined_balance (

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

Line 3937: pay_db_pay_setup.create_defined_balance (

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

Line 3945: pay_db_pay_setup.create_defined_balance (

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

Line 3952: pay_db_pay_setup.create_defined_balance (

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

Line 3959: pay_db_pay_setup.create_defined_balance (

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

Line 3966: pay_db_pay_setup.create_defined_balance (

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

Line 3973: pay_db_pay_setup.create_defined_balance (

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

Line 3980: pay_db_pay_setup.create_defined_balance (

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

Line 3987: pay_db_pay_setup.create_defined_balance (

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

Line 3994: pay_db_pay_setup.create_defined_balance (

3990: p_business_group_name => v_bg_name,
3991: p_legislation_code => NULL);
3992:
3993: hr_utility.set_location('pyusuiet',880);
3994: pay_db_pay_setup.create_defined_balance (
3995: p_balance_name => p_ele_name,
3996: p_balance_dimension => 'Person Quarter to Date',
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('pyusuiet',885);
4001: pay_db_pay_setup.create_defined_balance (
4002: p_balance_name => p_ele_name,
4003: p_balance_dimension => 'Person Year to Date',
4004: p_business_group_name => v_bg_name,
4005: p_legislation_code => NULL);

Line 4008: pay_db_pay_setup.create_defined_balance (

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

Line 4015: pay_db_pay_setup.create_defined_balance (

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

Line 4022: pay_db_pay_setup.create_defined_balance (

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

Line 4029: pay_db_pay_setup.create_defined_balance (

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

Line 4036: pay_db_pay_setup.create_defined_balance (

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

Line 4043: pay_db_pay_setup.create_defined_balance (

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

Line 4052: pay_db_pay_setup.create_defined_balance (

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

Line 4061: pay_db_pay_setup.create_defined_balance (

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

Line 4076: pay_db_pay_setup.create_defined_balance (

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

Line 4083: pay_db_pay_setup.create_defined_balance (

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

Line 4098: pay_db_pay_setup.create_defined_balance (

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

Line 4108: pay_db_pay_setup.create_defined_balance (

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

Line 4115: pay_db_pay_setup.create_defined_balance (

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

Line 4138: v_hrs_bal_type_id := pay_db_pay_setup.create_balance_type(

4134: v_hrs_bal_name := SUBSTR(p_ele_name, 1, 73)||' Hours';
4135: --v_hrs_bal_repname := SUBSTR(p_ele_reporting_name, 1, 23)||' Hours';
4136:
4137: hr_utility.set_location('pyusuiet',960);
4138: v_hrs_bal_type_id := pay_db_pay_setup.create_balance_type(
4139: p_balance_name => v_hrs_bal_name,
4140: p_uom => null,
4141: p_uom_code => 'H_DECIMAL2',
4142: p_reporting_name => v_hrs_bal_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('pyusuiet',965);
4151: pay_db_pay_setup.create_defined_balance (
4152: p_balance_name => v_hrs_bal_name,
4153: p_balance_dimension => 'Assignment-Level Current Run',
4154: p_business_group_name => v_bg_name,
4155: p_legislation_code => NULL);

Line 4158: pay_db_pay_setup.create_defined_balance (

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

Line 4167: pay_db_pay_setup.create_defined_balance (

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

Line 4174: pay_db_pay_setup.create_defined_balance (

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

Line 4181: pay_db_pay_setup.create_defined_balance (

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

Line 4188: pay_db_pay_setup.create_defined_balance (

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

Line 4194: pay_db_pay_setup.create_defined_balance (

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

Line 4201: pay_db_pay_setup.create_defined_balance (

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

Line 4388: v_info_payval_id := pay_db_pay_setup.create_input_value (

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

Line 4478: v_shadow_info_payval_id := pay_db_pay_setup.create_input_value (

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

Line 4544: v_inputs_info_payval_id := pay_db_pay_setup.create_input_value (

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