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.3 2006/08/18 11:29:35 schowta 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 72: gv_package varchar2(50) := 'pay_us_mwr_reporting_pkg';

68: 18-aug-2006 schowta 115.21 5399921 added code fix to include the work at home employee count in load_rpt_totals
69: /******************************************************************
70: ** Package Local Variables
71: ******************************************************************/
72: gv_package varchar2(50) := 'pay_us_mwr_reporting_pkg';
73:
74:
75: PROCEDURE get_payroll_action_info (
76: p_payroll_action_id in number,

Line 1252: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id

1248: RETURN NUMBER
1249: IS
1250: BEGIN
1251:
1252: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1253: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1254: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1255: pay_us_mwr_reporting_pkg.estab_count := 0;
1256: pay_us_mwr_reporting_pkg.est_id := p_estab_id;

Line 1253: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev

1249: IS
1250: BEGIN
1251:
1252: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1253: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1254: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1255: pay_us_mwr_reporting_pkg.estab_count := 0;
1256: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1257: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;

Line 1254: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN

1250: BEGIN
1251:
1252: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1253: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1254: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1255: pay_us_mwr_reporting_pkg.estab_count := 0;
1256: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1257: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1258: ELSE

Line 1255: pay_us_mwr_reporting_pkg.estab_count := 0;

1251:
1252: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1253: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1254: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1255: pay_us_mwr_reporting_pkg.estab_count := 0;
1256: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1257: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1258: ELSE
1259: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;

Line 1256: pay_us_mwr_reporting_pkg.est_id := p_estab_id;

1252: IF p_estab_id <> pay_us_mwr_reporting_pkg.est_id
1253: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1254: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1255: pay_us_mwr_reporting_pkg.estab_count := 0;
1256: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1257: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1258: ELSE
1259: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;
1260: END IF;

Line 1257: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;

1253: OR p_state_abbrev <> pay_us_mwr_reporting_pkg.state_abbrev
1254: OR pay_us_mwr_reporting_pkg.estab_count = 20 THEN
1255: pay_us_mwr_reporting_pkg.estab_count := 0;
1256: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1257: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1258: ELSE
1259: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;
1260: END IF;
1261:

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

1255: pay_us_mwr_reporting_pkg.estab_count := 0;
1256: pay_us_mwr_reporting_pkg.est_id := p_estab_id;
1257: pay_us_mwr_reporting_pkg.state_abbrev := p_state_abbrev;
1258: ELSE
1259: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;
1260: END IF;
1261:
1262:
1263: return (pay_us_mwr_reporting_pkg.estab_count);

Line 1263: return (pay_us_mwr_reporting_pkg.estab_count);

1259: pay_us_mwr_reporting_pkg.estab_count := pay_us_mwr_reporting_pkg.estab_count + 1;
1260: END IF;
1261:
1262:
1263: return (pay_us_mwr_reporting_pkg.estab_count);
1264: END update_global_values;
1265:
1266: END pay_us_mwr_reporting_pkg;

Line 1266: END pay_us_mwr_reporting_pkg;

1262:
1263: return (pay_us_mwr_reporting_pkg.estab_count);
1264: END update_global_values;
1265:
1266: END pay_us_mwr_reporting_pkg;