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 834: pay_formula_results.ins_stat_proc_rule (

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

Line 1211: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1226: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1241: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1255: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1269: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1285: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1313: pay_formula_results.ins_stat_proc_rule (

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

Line 1624: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1639: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1654: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1668: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1682: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1696: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1712: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1741: pay_formula_results.ins_stat_proc_rule (

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

Line 1815: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1830: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1847: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1876: pay_formula_results.ins_stat_proc_rule (

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

Line 1950: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1965: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 1982: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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

Line 2006: pay_formula_results.ins_stat_proc_rule (

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

Line 3325: v_resrule_id := pay_formula_results.ins_form_res_rule (

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

Line 3339: v_resrule_id := pay_formula_results.ins_form_res_rule (

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

Line 3357: v_resrule_id := pay_formula_results.ins_form_res_rule (

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

Line 3381: v_resrule_id := pay_formula_results.ins_form_res_rule (

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

Line 3397: v_resrule_id := pay_formula_results.ins_form_res_rule (

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

Line 3411: v_resrule_id := pay_formula_results.ins_form_res_rule (

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

Line 3427: v_resrule_id := pay_formula_results.ins_form_res_rule (

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

Line 3442: v_resrule_id := pay_formula_results.ins_form_res_rule (

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

Line 3459: v_fres_rule_id := pay_formula_results.ins_form_res_rule (

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