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.PAY_US_RULES dependencies on PAY_US_RULES

Line 1: PACKAGE BODY PAY_US_RULES AS

1: PACKAGE BODY PAY_US_RULES AS
2: /* $Header: pyusrule.pkb 120.24.12010000.2 2008/08/29 08:57:55 sudedas ship $ */
3: /*
4: ******************************************************************
5: * *

Line 261: l_pkg_name := 'pay_us_rules.';

257: l_override_adr_city per_addresses.add_information17%type;
258: l_override_adr_postal_code per_addresses.add_information17%type;
259:
260: BEGIN
261: l_pkg_name := 'pay_us_rules.';
262: l_proc_name := l_pkg_name||'default_jurisdiction';
263: hr_utility.trace('Entering '||l_proc_name);
264:
265: open csr_ele_classification;

Line 305: hr_utility.TRACE ('Entering pay_us_rules.element_template_pre_process');

301:
302: FUNCTION element_template_pre_process (p_rec IN pay_ele_tmplt_obj)
303: RETURN pay_ele_tmplt_obj IS
304: BEGIN
305: hr_utility.TRACE ('Entering pay_us_rules.element_template_pre_process');
306: hr_utility.TRACE ('Legislation Code ' || lrec.legislation_code);
307: -- INITIALIZING THE GLOBAL VARIABLE
308: lrec := NULL;
309: -- DEFAULTING TO input VARIABLE

Line 671: hr_utility.TRACE ('Leaving pay_us_rules.element_template_pre_process');

667: IF lrec.process_mode = 'N' THEN-- value sent as N for earnings
668: lrec.process_mode := 'S';
669: END IF;
670:
671: hr_utility.TRACE ('Leaving pay_us_rules.element_template_pre_process');
672: RETURN lrec;
673: END element_template_pre_process;
674:
675: /****************************************************************************/

Line 712: hr_utility.TRACE ('Entering pay_us_rules.element_template_upd_user_stru');

708: ln_sf_process_priority NUMBER(9);
709: ln_fc_process_priority NUMBER(9);
710: ln_fpa_process_priority NUMBER(9);
711: BEGIN
712: hr_utility.TRACE ('Entering pay_us_rules.element_template_upd_user_stru');
713: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
714:
715: -----------------------------------------------------------
716: -- Update Base shadow Element with user-specified details

Line 924: hr_utility.TRACE ('Leaving pay_us_rules.element_template_upd_user_stru');

920: ,p_object_version_number => l_ovn
921: );
922: END IF;
923:
924: hr_utility.TRACE ('Leaving pay_us_rules.element_template_upd_user_stru');
925: END element_template_upd_user_stru;
926:
927: /****************************************************************************/
928: /* PROCEDURE element_template_post_process */

Line 1091: hr_utility.TRACE ('Entering pay_us_rules.element_template_post_process');

1087: legislation_code will be present
1088: */
1089:
1090: BEGIN
1091: hr_utility.TRACE ('Entering pay_us_rules.element_template_post_process');
1092: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
1093:
1094: -- FLSA Changes
1095: IF (lrec.calculation_rule = 'US ' || lrec.element_classification) THEN

Line 1452: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

1448: ,p_effective_end_date => l_fc_eff_end_date
1449: ,p_object_version_number => l_fc_obj_ver_num
1450: );
1451: ELSE
1452: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1453: hr_utility.TRACE ('Error in fetching formula id for FLSA_PREMIUM_AMOUNT_CALCULATION');
1454: END IF;/*End of c_formula_id%FOUND*/
1455:
1456: CLOSE c_formula_id;

Line 1468: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

1464: SET proration_group_id = ln_proration_group_id
1465: WHERE business_group_id = ln_business_group_id
1466: AND element_type_id = l_fc_ele_type_id;
1467: ELSE
1468: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1469: hr_utility.TRACE ('Error in fetching proration group id for Entry Changes for Proration');
1470: END IF;
1471: CLOSE get_proration_group_id;
1472:

Line 1505: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

1501: ,p_replace_run_flag => 'N'
1502: ,p_use_override_dates => 'N'
1503: );
1504: ELSE
1505: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1506: hr_utility.TRACE ('Error in fetching retro component id');
1507: END IF;
1508: CLOSE get_retro_comp_id;
1509: ELSE

Line 1510: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

1506: hr_utility.TRACE ('Error in fetching retro component id');
1507: END IF;
1508: CLOSE get_retro_comp_id;
1509: ELSE
1510: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1511: hr_utility.TRACE ('Error in fetching retro group id for Entry Changes');
1512: END IF;
1513: CLOSE get_proration_group_id;
1514:

Line 1628: hr_utility.TRACE ('Leaving pay_us_rules.element_template_post_process');

1624: AND element_type_id = l_fc_ele_type_id;
1625: END IF;
1626:
1627:
1628: hr_utility.TRACE ('Leaving pay_us_rules.element_template_post_process');
1629: END element_template_post_process;
1630:
1631: /****************************************************************************/
1632: /* PROCEDURE delete_pre_process */

Line 1701: hr_utility.TRACE ('Entering pay_us_rules.delete_pre_process');

1697:
1698:
1699: BEGIN
1700:
1701: hr_utility.TRACE ('Entering pay_us_rules.delete_pre_process');
1702:
1703: OPEN c_ele_name(pay_us_earn_templ_wrapper.g_ele_type_id);
1704: FETCH c_ele_name INTO lv_ele_name
1705: , lv_business_group_id

Line 1776: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');

1772: END IF;/*l_shadow_ele_type_id IS NOT NULL*/
1773: END LOOP;/*tshadoweledetails.FIRST .. tshadoweledetails.LAST*/
1774:
1775: ELSE
1776: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');
1777: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1778: END IF;/*c_ele_name%FOUND*/
1779: CLOSE c_ele_name;
1780:

Line 1781: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');

1777: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1778: END IF;/*c_ele_name%FOUND*/
1779: CLOSE c_ele_name;
1780:
1781: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');
1782: END delete_pre_process;
1783:
1784: /****************************************************************************/
1785: /* PROCEDURE delete_post_process */

Line 1790: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');

1786: /****************************************************************************/
1787:
1788: PROCEDURE delete_post_process(p_element_template_id IN NUMBER) IS
1789: BEGIN
1790: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');
1791: NULL;
1792: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');
1793: END delete_post_process;
1794:

Line 1792: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');

1788: PROCEDURE delete_post_process(p_element_template_id IN NUMBER) IS
1789: BEGIN
1790: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');
1791: NULL;
1792: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');
1793: END delete_post_process;
1794:
1795:
1796: --=======================================================================

Line 1917: --IF pay_us_rules.g_id_flex_num IS NULL THEN

1913: v_total_hours := 0;
1914: c_ws_tab_name := 'COMPANY WORK SCHEDULES';
1915:
1916: /* get ID FLEX NUM */
1917: --IF pay_us_rules.g_id_flex_num IS NULL THEN
1918: hr_utility.trace('Getting ID_FLEX_NUM for US legislation ');
1919: OPEN get_id_flex_num;
1920: FETCH get_id_flex_num INTO l_id_flex_num;
1921: -- pay_us_rules.g_id_flex_num := l_id_flex_num;

Line 1921: -- pay_us_rules.g_id_flex_num := l_id_flex_num;

1917: --IF pay_us_rules.g_id_flex_num IS NULL THEN
1918: hr_utility.trace('Getting ID_FLEX_NUM for US legislation ');
1919: OPEN get_id_flex_num;
1920: FETCH get_id_flex_num INTO l_id_flex_num;
1921: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1922: CLOSE get_id_flex_num;
1923: --END IF;
1924:
1925: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);

Line 1925: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);

1921: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1922: CLOSE get_id_flex_num;
1923: --END IF;
1924:
1925: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1926: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1927: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);

Line 1936: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN

1932: hr_utility.trace('element_entry_id=' || element_entry_id);
1933: hr_utility.trace('date_earned ' || date_earned);
1934:
1935: /* get work schedule_name */
1936: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1937: IF l_id_flex_num IS NOT NULL THEN
1938: hr_utility.trace('getting work schedule name ');
1939: OPEN get_ws_name (l_id_flex_num,--pay_us_rules.g_id_flex_num,
1940: date_earned,

Line 1939: OPEN get_ws_name (l_id_flex_num,--pay_us_rules.g_id_flex_num,

1935: /* get work schedule_name */
1936: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1937: IF l_id_flex_num IS NOT NULL THEN
1938: hr_utility.trace('getting work schedule name ');
1939: OPEN get_ws_name (l_id_flex_num,--pay_us_rules.g_id_flex_num,
1940: date_earned,
1941: assignment_id);
1942: FETCH get_ws_name INTO p_ws_name;
1943: CLOSE get_ws_name;

Line 2125: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');

2121:
2122: BEGIN
2123:
2124: --hr_utility.trace_on(null, 'TIME');
2125: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2126: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2127: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2128: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2129: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);

Line 2208: hr_utility.trace('Leaving PAY_US_RULES.get_time_def_for_entry');

2204: g_current_asg_id := p_assignment_id;
2205: end if;
2206:
2207: hr_utility.trace('p_time_definition_id = ' || p_time_definition_id);
2208: hr_utility.trace('Leaving PAY_US_RULES.get_time_def_for_entry');
2209: return;
2210: END;
2211:
2212:

Line 2543: --hr_utility.trace ('Entering '|| 'pay_us_rules. _xml');

2539: lv_category varchar2(200) := 'DA';
2540: ln_account_number1 number ;
2541:
2542: BEGIN
2543: --hr_utility.trace ('Entering '|| 'pay_us_rules. _xml');
2544:
2545: IF p_action_information_category = 'EMPLOYEE DETAILS' THEN
2546:
2547:

Line 2649: hr_utility.trace('exiting PAY_US_RULES.add_custom_xml');

2645:
2646: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
2647:
2648: END IF;
2649: hr_utility.trace('exiting PAY_US_RULES.add_custom_xml');
2650: END add_custom_xml;
2651:
2652: FUNCTION CF_word_amountFormula(CP_LN_AMOUNT IN NUMBER) RETURN VARCHAR2 IS
2653:

Line 2787: END PAY_US_RULES;

2783:
2784: END get_token_names;
2785: --
2786: --
2787: END PAY_US_RULES;
2788: