[Home] [Help]
PACKAGE: APPS.PAY_US_TAX_BALS_ADJ_PKG
Source
1 PACKAGE pay_us_tax_bals_adj_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyustxba.pkh 120.0 2005/05/29 10:00:43 appldev noship $ */
3 -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
4 /* ------------------------------------------------------------------------
5 NAME
6 pyustxba.pkh
7 --
8 DESCRIPTION
9 See description in pyustxba.pkb
10 --
11 Version MODIFIED Date Description
12 ------- -------- ----------- ---------------------
13 0 S Panwar 23-OCT-1995 Created
14
15 40.0 S Desai 17-Nov-1995 Initial arcs version
16
17 40.1 S Desai 20-Nov-1995 Use city, state, county and zip
18 to derive the jurisdiction.
19 Use assignment_number, bg_name,
20 consolidation_set instead of the
21 system keys.
22 Added parameter for net amount.
23
24 40.2 S Desai 22-Nov-1995 Cleaned up code
25
26 40.3 R Murthy 10-Sep-1996 Added the parameter p_FIT_THIRD
27 to allow for adjusting the balance
28 for FIT Withheld by Third Party.
29
30 110.2 S Billing 28-Apr-1998 added extra parameter p_cost,
31 used to pass value of costed
32 checkbox
33
34 110.3 S Billing 15-Jul-1998 added the extra paramters:
35 - p_futa_er
36 - p_sui_er
37 - p_sdi_er
38 - p_sch_dist_wh_ee
39 - p_sch_dist_jur
40
41 These relate to new fields added to
42 PAYWSTBA.fmb. If null is passed through
43 any of these paramters, the corresponding
44 tax element is not processed.
45 115.1 R Murthy Added new parameter, p_tax_unit_id.
46 115.5 A Handa Added commit before exit statement.
47
48 ----------------------------------------------------------------------------- */
49
50
51 PROCEDURE create_tax_balance_adjustment(
52 --
53 -- Common parameters
54 --
55 p_adjustment_date DATE,
56 p_business_group_name varchar2,
57 p_assignment_number varchar2,
58 p_tax_unit_id NUMBER,
59 p_consolidation_set varchar2,
60 --
61 -- Earnings
62 --
63 p_earning_element_type varchar2 default null,
64 p_gross_amount NUMBER default 0,
65 p_net_amount NUMBER default 0,
66 --
67 -- Taxes withheld
68 --
69 p_FIT NUMBER default 0,
70 p_FIT_THIRD varchar2 default null,
71 p_SS NUMBER default 0,
72 p_Medicare NUMBER default 0,
73 p_SIT NUMBER default 0,
74 p_SUI NUMBER default 0,
75 p_SDI NUMBER default 0,
76 p_County NUMBER default 0,
77 p_City NUMBER default 0,
78 --
79 -- Location parameters
80 --
81 p_city_name varchar2 default null,
82 p_state_abbrev varchar2 default null,
83 p_county_name varchar2 default null,
84 p_zip_code varchar2 default null,
85 p_cost varchar2 default null,
86 p_futa_er NUMBER DEFAULT 0,
87 p_sui_er NUMBER DEFAULT 0,
88 p_sdi_er NUMBER DEFAULT 0,
89 p_sch_dist_wh_ee NUMBER DEFAULT 0,
90 p_sch_dist_jur varchar2 default null
91 )
92 ;
93
94 END pay_us_tax_bals_adj_pkg;