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.43.12020000.8 2012/12/12 06:38:11 abellur ship $ */
3: /*
4: ******************************************************************
5: * *

Line 316: l_pkg_name := 'pay_us_rules.';

312: l_override_adr_city per_addresses.add_information17%type;
313: l_override_adr_postal_code per_addresses.add_information17%type;
314:
315: BEGIN
316: l_pkg_name := 'pay_us_rules.';
317: l_proc_name := l_pkg_name||'default_jurisdiction';
318: hr_utility.trace('Entering '||l_proc_name);
319:
320: open csr_ele_classification;

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

356:
357: FUNCTION element_template_pre_process (p_rec IN pay_ele_tmplt_obj)
358: RETURN pay_ele_tmplt_obj IS
359: BEGIN
360: hr_utility.TRACE ('Entering pay_us_rules.element_template_pre_process');
361: hr_utility.TRACE ('Legislation Code ' || lrec.legislation_code);
362: -- INITIALIZING THE GLOBAL VARIABLE
363: lrec := NULL;
364: -- DEFAULTING TO input VARIABLE

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

722: IF lrec.process_mode = 'N' THEN-- value sent as N for earnings
723: lrec.process_mode := 'S';
724: END IF;
725:
726: hr_utility.TRACE ('Leaving pay_us_rules.element_template_pre_process');
727: RETURN lrec;
728: END element_template_pre_process;
729:
730: /****************************************************************************/

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

763: ln_sf_process_priority NUMBER(9);
764: ln_fc_process_priority NUMBER(9);
765: ln_fpa_process_priority NUMBER(9);
766: BEGIN
767: hr_utility.TRACE ('Entering pay_us_rules.element_template_upd_user_stru');
768: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
769:
770: -----------------------------------------------------------
771: -- Update Base shadow Element with user-specified details

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

975: ,p_object_version_number => l_ovn
976: );
977: END IF;
978:
979: hr_utility.TRACE ('Leaving pay_us_rules.element_template_upd_user_stru');
980: END element_template_upd_user_stru;
981:
982: /****************************************************************************/
983: /* PROCEDURE element_template_post_process */

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

1142: legislation_code will be present
1143: */
1144:
1145: BEGIN
1146: hr_utility.TRACE ('Entering pay_us_rules.element_template_post_process');
1147: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
1148:
1149: -- FLSA Changes
1150: IF (lrec.calculation_rule = 'US ' || lrec.element_classification) THEN

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

1503: ,p_effective_end_date => l_fc_eff_end_date
1504: ,p_object_version_number => l_fc_obj_ver_num
1505: );
1506: ELSE
1507: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1508: hr_utility.TRACE ('Error in fetching formula id for FLSA_PREMIUM_AMOUNT_CALCULATION');
1509: END IF;/*End of c_formula_id%FOUND*/
1510:
1511: CLOSE c_formula_id;

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

1519: SET proration_group_id = ln_proration_group_id
1520: WHERE business_group_id = ln_business_group_id
1521: AND element_type_id = l_fc_ele_type_id;
1522: ELSE
1523: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1524: hr_utility.TRACE ('Error in fetching proration group id for Entry Changes for Proration');
1525: END IF;
1526: CLOSE get_proration_group_id;
1527:

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

1556: ,p_replace_run_flag => 'N'
1557: ,p_use_override_dates => 'N'
1558: );
1559: ELSE
1560: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1561: hr_utility.TRACE ('Error in fetching retro component id');
1562: END IF;
1563: CLOSE get_retro_comp_id;
1564: ELSE

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

1561: hr_utility.TRACE ('Error in fetching retro component id');
1562: END IF;
1563: CLOSE get_retro_comp_id;
1564: ELSE
1565: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1566: hr_utility.TRACE ('Error in fetching retro group id for Entry Changes');
1567: END IF;
1568: CLOSE get_proration_group_id;
1569:

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

1679: AND element_type_id = l_fc_ele_type_id;
1680: END IF;
1681:
1682:
1683: hr_utility.TRACE ('Leaving pay_us_rules.element_template_post_process');
1684: END element_template_post_process;
1685:
1686: /****************************************************************************/
1687: /* PROCEDURE delete_pre_process */

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

1752:
1753:
1754: BEGIN
1755:
1756: hr_utility.TRACE ('Entering pay_us_rules.delete_pre_process');
1757:
1758: OPEN c_ele_name(pay_us_earn_templ_wrapper.g_ele_type_id);
1759: FETCH c_ele_name INTO lv_ele_name
1760: , lv_business_group_id

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

1827: END IF;/*l_shadow_ele_type_id IS NOT NULL*/
1828: END LOOP;/*tshadoweledetails.FIRST .. tshadoweledetails.LAST*/
1829:
1830: ELSE
1831: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');
1832: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1833: END IF;/*c_ele_name%FOUND*/
1834: CLOSE c_ele_name;
1835:

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

1832: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1833: END IF;/*c_ele_name%FOUND*/
1834: CLOSE c_ele_name;
1835:
1836: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');
1837: END delete_pre_process;
1838:
1839: /****************************************************************************/
1840: /* PROCEDURE delete_post_process */

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

1841: /****************************************************************************/
1842:
1843: PROCEDURE delete_post_process(p_element_template_id IN NUMBER) IS
1844: BEGIN
1845: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');
1846: NULL;
1847: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');
1848: END delete_post_process;
1849:

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

1843: PROCEDURE delete_post_process(p_element_template_id IN NUMBER) IS
1844: BEGIN
1845: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');
1846: NULL;
1847: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');
1848: END delete_post_process;
1849:
1850:
1851: --=======================================================================

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

1969: v_total_hours := 0;
1970: c_ws_tab_name := 'COMPANY WORK SCHEDULES';
1971:
1972: /* get ID FLEX NUM */
1973: --IF pay_us_rules.g_id_flex_num IS NULL THEN
1974: hr_utility.trace('Getting ID_FLEX_NUM for US legislation ');
1975: OPEN get_id_flex_num;
1976: FETCH get_id_flex_num INTO l_id_flex_num;
1977: -- pay_us_rules.g_id_flex_num := l_id_flex_num;

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

1973: --IF pay_us_rules.g_id_flex_num IS NULL THEN
1974: hr_utility.trace('Getting ID_FLEX_NUM for US legislation ');
1975: OPEN get_id_flex_num;
1976: FETCH get_id_flex_num INTO l_id_flex_num;
1977: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1978: CLOSE get_id_flex_num;
1979: --END IF;
1980:
1981: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);

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

1977: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1978: CLOSE get_id_flex_num;
1979: --END IF;
1980:
1981: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1982: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);

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

1988: hr_utility.trace('element_entry_id=' || element_entry_id);
1989: hr_utility.trace('date_earned ' || date_earned);
1990:
1991: /* get work schedule_name */
1992: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1993: IF l_id_flex_num IS NOT NULL THEN
1994: hr_utility.trace('getting work schedule name ');
1995: OPEN get_ws_name (l_id_flex_num,--pay_us_rules.g_id_flex_num,
1996: date_earned,

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

1991: /* get work schedule_name */
1992: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1993: IF l_id_flex_num IS NOT NULL THEN
1994: hr_utility.trace('getting work schedule name ');
1995: OPEN get_ws_name (l_id_flex_num,--pay_us_rules.g_id_flex_num,
1996: date_earned,
1997: assignment_id);
1998: FETCH get_ws_name INTO p_ws_name;
1999: CLOSE get_ws_name;

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

2181:
2182: BEGIN
2183:
2184: --hr_utility.trace_on(null, 'TIME');
2185: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2186: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2187: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2188: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2189: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);

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

2264: g_current_asg_id := p_assignment_id;
2265: end if;
2266:
2267: hr_utility.trace('p_time_definition_id = ' || p_time_definition_id);
2268: hr_utility.trace('Leaving PAY_US_RULES.get_time_def_for_entry');
2269: return;
2270: END;
2271:
2272:

Line 2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');

2717: lv_employer_zip_code pay_action_information.action_information12%type;
2718: lv_employer_country pay_action_information.action_information13%type;
2719:
2720: BEGIN
2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');
2722: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
2723: hr_utility.trace('p_action_information_category '|| p_action_information_category);
2724: hr_utility.trace('p_document_type '|| p_document_type);
2725:

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

2944: /* Put transit info here*/
2945:
2946: END IF;
2947: -- 13029999 end
2948: hr_utility.trace('exiting PAY_US_RULES.add_custom_xml');
2949: END add_custom_xml;
2950:
2951:
2952: FUNCTION CF_word_amountFormula(CP_LN_AMOUNT IN NUMBER) RETURN VARCHAR2 IS

Line 3116: hr_utility.trace('Entering pay_us_rules.payslip_range_cursor');

3112:
3113: lv_sqlstr VARCHAR2(32000);
3114:
3115: BEGIN
3116: hr_utility.trace('Entering pay_us_rules.payslip_range_cursor');
3117: lv_sqlstr := NULL;
3118: pay_us_deposit_advice_pkg.DAxml_range_cursor(pactid => p_pactid
3119: ,psqlstr => lv_sqlstr);
3120: hr_utility.trace('Returning lv_sqlstr := ' || lv_sqlstr);

Line 3182: END PAY_US_RULES;

3178: END IF;
3179:
3180: END;
3181:
3182: END PAY_US_RULES;
3183: