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_MWR_REPORTING_PKG dependencies on PAY_US_MWR_REPORTING_PKG

Line 1: PACKAGE BODY pay_us_mwr_reporting_pkg AS

1: PACKAGE BODY pay_us_mwr_reporting_pkg AS
2: /* $Header: pyusmwrp.pkb 120.9 2011/08/08 08:50:00 nkjaladi noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_mwr_reporting_pkg

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_mwr_reporting_pkg
21:
22: Description : Generate Multi Worksite magnetic reports.
23:
24: Uses :

Line 89: gv_package varchar2(50) := 'pay_us_mwr_reporting_pkg';

85: the assignment location.
86: /******************************************************************
87: ** Package Local Variables
88: ******************************************************************/
89: gv_package varchar2(50) := 'pay_us_mwr_reporting_pkg';
90:
91:
92: PROCEDURE get_payroll_action_info (
93: p_payroll_action_id in number,

Line 678: hr_utility.trace('Returing location_id as '||l_location_id||' from pay_us_mwr_reporting_pkg.get_location_id');

674:
675: END IF;
676:
677: CLOSE asg_with_action_loc_id;
678: hr_utility.trace('Returing location_id as '||l_location_id||' from pay_us_mwr_reporting_pkg.get_location_id');
679: RETURN l_location_id;
680:
681: EXCEPTION
682: WHEN OTHERS THEN

Line 1540: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id

1536: RETURN NUMBER
1537: IS
1538: BEGIN
1539:
1540: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1541: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1542: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1543: pay_us_mwr_reporting_pkg.estab_count := 0;
1544: pay_us_mwr_reporting_pkg.est_id := p_estab_id;

Line 1541: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev

1537: IS
1538: BEGIN
1539:
1540: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1541: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1542: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1543: pay_us_mwr_reporting_pkg.estab_count := 0;
1544: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1545: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;

Line 1542: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN

1538: BEGIN
1539:
1540: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1541: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1542: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1543: pay_us_mwr_reporting_pkg.estab_count := 0;
1544: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1545: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1546: ELSE

Line 1543: pay_us_mwr_reporting_pkg.estab_count := 0;

1539:
1540: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1541: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1542: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1543: pay_us_mwr_reporting_pkg.estab_count := 0;
1544: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1545: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1546: ELSE
1547: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;

Line 1544: pay_us_mwr_reporting_pkg.est_id := p_estab_id;

1540: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1541: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1542: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1543: pay_us_mwr_reporting_pkg.estab_count := 0;
1544: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1545: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1546: ELSE
1547: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;
1548: END IF;

Line 1545: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;

1541: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1542: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1543: pay_us_mwr_reporting_pkg.estab_count := 0;
1544: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1545: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1546: ELSE
1547: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;
1548: END IF;
1549:

Line 1547: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;

1543: pay_us_mwr_reporting_pkg.estab_count := 0;
1544: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1545: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1546: ELSE
1547: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;
1548: END IF;
1549:
1550:
1551: return (pay_us_mwr_reporting_pkg.estab_count);

Line 1551: return (pay_us_mwr_reporting_pkg.estab_count);

1547: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;
1548: END IF;
1549:
1550:
1551: return (pay_us_mwr_reporting_pkg.estab_count);
1552: END update_global_values;
1553:
1554:
1555: END pay_us_mwr_reporting_pkg;

Line 1555: END pay_us_mwr_reporting_pkg;

1551: return (pay_us_mwr_reporting_pkg.estab_count);
1552: END update_global_values;
1553:
1554:
1555: END pay_us_mwr_reporting_pkg;