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_FORMULA_RESULTS

Line 29: "pay_formula_results" for

25: 21-SEP-93 H.Parichabutr 1.0 First Created.
26: Initial Procedures
27: 01-NOV-93 hparicha 1.1 Replaced calls to "benchmark"
28: with calls to custom
29: "pay_formula_results" for
30: status proc and result rule
31: building blocks.
32: 05-NOV-93 hparicha 1.2 Populates element type SCL.
33: 07-NOV-93 hparicha 1.3 Defaults input value for

Line 832: pay_formula_results.ins_stat_proc_rule (

828: -- check for existence...return id...
829: --
830:
831: v_stat_proc_rule_id :=
832: pay_formula_results.ins_stat_proc_rule (
833: p_business_group_id => p_bg_id,
834: p_legislation_code => NULL,
835: p_legislation_subgroup => g_template_leg_subgroup,
836: p_effective_start_date => p_eff_start_date,

Line 1209: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1205: and effective_end_date;
1206:
1207:
1208: hr_utility.set_location('pyusuiet',215);
1209: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1210: p_business_group_id => p_bg_id,
1211: p_legislation_code => NULL,
1212: p_legislation_subgroup => g_template_leg_subgroup,
1213: p_effective_start_date => p_eff_start_date,

Line 1224: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1220: p_result_rule_type => 'D',
1221: p_severity_level => NULL);
1222: --
1223: hr_utility.set_location('pyusuiet',220);
1224: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1225: p_business_group_id => p_bg_id,
1226: p_legislation_code => NULL,
1227: p_legislation_subgroup => g_template_leg_subgroup,
1228: p_effective_start_date => p_eff_start_date,

Line 1239: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1235: p_result_rule_type => 'M',
1236: p_severity_level => 'W');
1237: --
1238: hr_utility.set_location('pyusuiet',225);
1239: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1240: p_business_group_id => p_bg_id,
1241: p_legislation_code => NULL,
1242: p_legislation_subgroup => g_template_leg_subgroup,
1243: p_effective_start_date => p_eff_start_date,

Line 1253: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1249: p_severity_level => NULL,
1250: p_element_type_id => v_hbyr_ele_type_id);
1251:
1252: hr_utility.set_location('pyusuiet',230);
1253: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1254: p_business_group_id => p_bg_id,
1255: p_legislation_code => NULL,
1256: p_legislation_subgroup => g_template_leg_subgroup,
1257: p_effective_start_date => p_eff_start_date,

Line 1267: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1263: p_severity_level => NULL,
1264: p_element_type_id => v_hbyr_ele_type_id);
1265:
1266: hr_utility.set_location('pyusuiet',235);
1267: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1268: p_business_group_id => p_bg_id,
1269: p_legislation_code => NULL,
1270: p_legislation_subgroup => g_template_leg_subgroup,
1271: p_effective_start_date => p_eff_start_date,

Line 1283: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1279:
1280: IF p_ele_proc_type = 'R' THEN
1281: --
1282: hr_utility.set_location('pyusuiet',240);
1283: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1284: p_business_group_id => p_bg_id,
1285: p_legislation_code => NULL,
1286: p_legislation_subgroup => g_template_leg_subgroup,
1287: p_effective_start_date => p_eff_start_date,

Line 1311: pay_formula_results.ins_stat_proc_rule (

1307: p_amt_rule => UPPER(p_calc_ff_name));
1308: --
1309: hr_utility.set_location('pyusuiet',250);
1310: v_stat_proc_rule_id :=
1311: pay_formula_results.ins_stat_proc_rule (
1312: p_business_group_id => p_bg_id,
1313: p_legislation_code => NULL,
1314: p_legislation_subgroup => g_template_leg_subgroup,
1315: p_effective_start_date => p_eff_start_date,

Line 1622: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1618: and effective_end_date;
1619:
1620:
1621: hr_utility.set_location('pyusuiet',345);
1622: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1623: p_business_group_id => p_bg_id,
1624: p_legislation_code => NULL,
1625: p_legislation_subgroup => g_template_leg_subgroup,
1626: p_effective_start_date => p_eff_start_date,

Line 1637: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1633: p_result_rule_type => 'D',
1634: p_severity_level => NULL);
1635: --
1636: hr_utility.set_location('pyusuiet',350);
1637: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1638: p_business_group_id => p_bg_id,
1639: p_legislation_code => NULL,
1640: p_legislation_subgroup => g_template_leg_subgroup,
1641: p_effective_start_date => p_eff_start_date,

Line 1652: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1648: p_result_rule_type => 'M',
1649: p_severity_level => 'W');
1650: --
1651: hr_utility.set_location('pyusuiet',355);
1652: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1653: p_business_group_id => p_bg_id,
1654: p_legislation_code => NULL,
1655: p_legislation_subgroup => g_template_leg_subgroup,
1656: p_effective_start_date => p_eff_start_date,

Line 1666: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1662: p_severity_level => NULL,
1663: p_element_type_id => v_hbyr_ele_type_id);
1664:
1665: hr_utility.set_location('pyusuiet',360);
1666: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1667: p_business_group_id => p_bg_id,
1668: p_legislation_code => NULL,
1669: p_legislation_subgroup => g_template_leg_subgroup,
1670: p_effective_start_date => p_eff_start_date,

Line 1680: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1676: p_severity_level => NULL,
1677: p_element_type_id => v_hbyr_ele_type_id);
1678:
1679: hr_utility.set_location('pyusuiet',365);
1680: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1681: p_business_group_id => p_bg_id,
1682: p_legislation_code => NULL,
1683: p_legislation_subgroup => g_template_leg_subgroup,
1684: p_effective_start_date => p_eff_start_date,

Line 1694: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1690: p_severity_level => NULL,
1691: p_element_type_id => v_hbyr_ele_type_id);
1692:
1693: hr_utility.set_location('pyusuiet',370);
1694: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1695: p_business_group_id => p_bg_id,
1696: p_legislation_code => NULL,
1697: p_legislation_subgroup => g_template_leg_subgroup,
1698: p_effective_start_date => p_eff_start_date,

Line 1710: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1706:
1707: IF p_ele_proc_type = 'R' THEN
1708: --
1709: hr_utility.set_location('pyusuiet',375);
1710: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1711: p_business_group_id => p_bg_id,
1712: p_legislation_code => NULL,
1713: p_legislation_subgroup => g_template_leg_subgroup,
1714: p_effective_start_date => p_eff_start_date,

Line 1739: pay_formula_results.ins_stat_proc_rule (

1735: p_amt_rule => UPPER(p_calc_ff_name));
1736: --
1737: hr_utility.set_location('pyusuiet',385);
1738: v_stat_proc_rule_id :=
1739: pay_formula_results.ins_stat_proc_rule (
1740: p_business_group_id => p_bg_id,
1741: p_legislation_code => NULL,
1742: p_legislation_subgroup => g_template_leg_subgroup,
1743: p_effective_start_date => p_eff_start_date,

Line 1813: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1809: -- Now insert appropriate formula_result_rules for "PERCENT SALARY"
1810: -- REMEMBER: Testing using 'HEP_TEST_01' formula.
1811:
1812: hr_utility.set_location('pyusuiet',405);
1813: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1814: p_business_group_id => p_bg_id,
1815: p_legislation_code => NULL,
1816: p_legislation_subgroup => g_template_leg_subgroup,
1817: p_effective_start_date => p_eff_start_date,

Line 1828: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1824: p_result_rule_type => 'D',
1825: p_severity_level => NULL);
1826: --
1827: hr_utility.set_location('pyusuiet',410);
1828: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1829: p_business_group_id => p_bg_id,
1830: p_legislation_code => NULL,
1831: p_legislation_subgroup => g_template_leg_subgroup,
1832: p_effective_start_date => p_eff_start_date,

Line 1845: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1841: --
1842: IF p_ele_proc_type = 'R' THEN
1843: --
1844: hr_utility.set_location('pyusuiet',415);
1845: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1846: p_business_group_id => p_bg_id,
1847: p_legislation_code => NULL,
1848: p_legislation_subgroup => g_template_leg_subgroup,
1849: p_effective_start_date => p_eff_start_date,

Line 1874: pay_formula_results.ins_stat_proc_rule (

1870: p_amt_rule => UPPER(p_calc_ff_name));
1871: --
1872: hr_utility.set_location('pyusuiet',425);
1873: v_stat_proc_rule_id :=
1874: pay_formula_results.ins_stat_proc_rule (
1875: p_business_group_id => p_bg_id,
1876: p_legislation_code => NULL,
1877: p_legislation_subgroup => g_template_leg_subgroup,
1878: p_effective_start_date => p_eff_start_date,

Line 1948: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1944: --
1945: -- Now insert appropriate formula_result_rules for "FLAT AMOUNT"
1946: --
1947: hr_utility.set_location('pyusuiet',445);
1948: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1949: p_business_group_id => p_bg_id,
1950: p_legislation_code => NULL,
1951: p_legislation_subgroup => g_template_leg_subgroup,
1952: p_effective_start_date => p_eff_start_date,

Line 1963: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1959: p_result_rule_type => 'D',
1960: p_severity_level => NULL);
1961: --
1962: hr_utility.set_location('pyusuiet',450);
1963: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1964: p_business_group_id => p_bg_id,
1965: p_legislation_code => NULL,
1966: p_legislation_subgroup => g_template_leg_subgroup,
1967: p_effective_start_date => p_eff_start_date,

Line 1980: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

1976: --
1977: IF p_ele_proc_type = 'R' THEN
1978: --
1979: hr_utility.set_location('pyusuiet',455);
1980: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
1981: p_business_group_id => p_bg_id,
1982: p_legislation_code => NULL,
1983: p_legislation_subgroup => g_template_leg_subgroup,
1984: p_effective_start_date => p_eff_start_date,

Line 2004: pay_formula_results.ins_stat_proc_rule (

2000: -- this earning.
2001: hr_utility.set_location('pyusuiet',460);
2002: v_calc_rule_formula_id := '';
2003: v_stat_proc_rule_id :=
2004: pay_formula_results.ins_stat_proc_rule (
2005: p_business_group_id => p_bg_id,
2006: p_legislation_code => NULL,
2007: p_legislation_subgroup => g_template_leg_subgroup,
2008: p_effective_start_date => p_eff_start_date,

Line 3323: v_resrule_id := pay_formula_results.ins_form_res_rule (

3319:
3320: If p_ele_proc_type = 'R' then /* Not required for NR Elements */
3321:
3322: hr_utility.set_location('pyusuiet',735);
3323: v_resrule_id := pay_formula_results.ins_form_res_rule (
3324: p_business_group_id => p_bg_id,
3325: p_legislation_code => NULL,
3326: p_legislation_subgroup => g_template_leg_subgroup,
3327: p_effective_start_date => p_eff_start,

Line 3337: v_resrule_id := pay_formula_results.ins_form_res_rule (

3333: p_severity_level => NULL,
3334: p_element_type_id => p_shadow_ele_type_id);
3335: --
3336: hr_utility.set_location('pyusuiet',740);
3337: v_resrule_id := pay_formula_results.ins_form_res_rule (
3338: p_business_group_id => p_bg_id,
3339: p_legislation_code => NULL,
3340: p_legislation_subgroup => g_template_leg_subgroup,
3341: p_effective_start_date => p_eff_start,

Line 3355: v_resrule_id := pay_formula_results.ins_form_res_rule (

3351: End if; /* Not required for NR Elements */
3352:
3353:
3354: hr_utility.set_location('pyusuiet',745);
3355: v_resrule_id := pay_formula_results.ins_form_res_rule (
3356: p_business_group_id => p_bg_id,
3357: p_legislation_code => NULL,
3358: p_legislation_subgroup => g_template_leg_subgroup,
3359: p_effective_start_date => p_eff_start,

Line 3379: v_resrule_id := pay_formula_results.ins_form_res_rule (

3375: where pivf.element_type_id = p_shadow_ele_type_id
3376: and pivf.name = 'Pay Value';
3377:
3378: hr_utility.set_location('pyusuiet',755);
3379: v_resrule_id := pay_formula_results.ins_form_res_rule (
3380: p_business_group_id => p_bg_id,
3381: p_legislation_code => NULL,
3382: p_legislation_subgroup => g_template_leg_subgroup,
3383: p_effective_start_date => p_eff_start,

Line 3395: v_resrule_id := pay_formula_results.ins_form_res_rule (

3391: --
3392:
3393: --
3394: hr_utility.set_location('pyusuiet',760);
3395: v_resrule_id := pay_formula_results.ins_form_res_rule (
3396: p_business_group_id => p_bg_id,
3397: p_legislation_code => NULL,
3398: p_legislation_subgroup => g_template_leg_subgroup,
3399: p_effective_start_date => p_eff_start,

Line 3409: v_resrule_id := pay_formula_results.ins_form_res_rule (

3405: p_severity_level => NULL,
3406: p_element_type_id => p_shadow_ele_type_id );
3407: --
3408: hr_utility.set_location('pyusuiet',765);
3409: v_resrule_id := pay_formula_results.ins_form_res_rule (
3410: p_business_group_id => p_bg_id,
3411: p_legislation_code => NULL,
3412: p_legislation_subgroup => g_template_leg_subgroup,
3413: p_effective_start_date => p_eff_start,

Line 3425: v_resrule_id := pay_formula_results.ins_form_res_rule (

3421: --
3422:
3423: --
3424: hr_utility.set_location('pyusuiet',770);
3425: v_resrule_id := pay_formula_results.ins_form_res_rule (
3426: p_business_group_id => p_bg_id,
3427: p_legislation_code => NULL,
3428: p_legislation_subgroup => g_template_leg_subgroup,
3429: p_effective_start_date => p_eff_start,

Line 3440: v_resrule_id := pay_formula_results.ins_form_res_rule (

3436: p_element_type_id => p_shadow_ele_type_id );
3437: --
3438:
3439: hr_utility.set_location('pyusuiet',775);
3440: v_resrule_id := pay_formula_results.ins_form_res_rule (
3441: p_business_group_id => p_bg_id,
3442: p_legislation_code => NULL,
3443: p_legislation_subgroup => g_template_leg_subgroup,
3444: p_effective_start_date => p_eff_start,

Line 3457: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

3453:
3454: IF UPPER(p_ele_proc_type) = 'R' THEN
3455: --
3456: hr_utility.set_location('pyusuiet',780);
3457: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
3458: p_business_group_id => p_bg_id,
3459: p_legislation_code => NULL,
3460: p_legislation_subgroup => g_template_leg_subgroup,
3461: p_effective_start_date => p_eff_start,