1 package pay_us_tax_bal_summary_pkg AUTHID CURRENT_USER as
2 /* $Header: pyustxbs.pkh 120.1 2010/12/20 16:44:29 tclewis ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_us_tax_bal_summary_pkg
21
22 Description : This package is used by the Tax Balance Summary form
23 to fetch tax balances. Balances and their values for
24 different time dimensions are populated into PL/SQL
25 tables and returned back to Tax Balance Summary form.
26
27 Change List
28 -----------
29 Date Name Vers Bug No Description
30 ----------- ---------- ------ ------- -------------------------------
31 05-DEC-2003 sdahiya 115.0 3129694 Created.
32 22-DEC-2003 sdahiya 115.1 3129694 Component 'prompt' of taxes_rec
33 record declared using %type.
34 15-DEC-2010 tclewis 115.2 10294839 Added p_emp_asg_ctx to GET_FED.
35 This is used to bypass the fetch
36 of the FUTA_CREDIT PTD balance.
37
38 *****************************************************************************/
39
40
41 -- record to store tax name and values for different time dimensions
42
43 TYPE taxes_rec IS RECORD (
44 prompt pay_us_tax_balances.balance_category_code%type,
45 ptd_val number,
46 mtd_val number,
47 qtd_val number,
48 ytd_val number
49 );
50
51 TYPE tab_taxes IS TABLE of taxes_rec INDEX BY BINARY_INTEGER;
52
53
54 /*****************************************************************************
55 Name : GET_FED
56 Purpose : This procedure obtains federal EE/ER balances for a given
57 assignment action and populates them into a PL/SQL table. This
58 table is returned as an out parameter to the calling procedure
59 of Tax Balance Summary form.
60 *****************************************************************************/
61
62 PROCEDURE GET_FED (p_ee_er IN VARCHAR2
63 , p_assg_id IN NUMBER
64 , p_asact_id IN NUMBER
65 , p_tax_unit_id IN NUMBER
66 , p_emp_asg_ctx IN VARCHAR2
67 , p_fed_taxes_tab OUT NOCOPY tab_taxes);
68
69
70
71 /*****************************************************************************
72 Name : GET_STATE
73 Purpose : This procedure obtains state EE/ER balances for a given
74 state and populates them into a PL/SQL table. This
75 table is returned as an out parameter to the calling procedure
76 of Tax Balance Summary form.
77 *****************************************************************************/
78
79 PROCEDURE GET_STATE (p_ee_er IN VARCHAR2
80 , p_assg_id IN NUMBER
81 , p_asact_id IN NUMBER
82 , p_tax_unit_id IN NUMBER
83 , p_state_code IN VARCHAR2
84 , p_state_taxes_tab OUT NOCOPY tab_taxes);
85
86
87 /*****************************************************************************
88 Name : GET_LOCAL
89 Purpose : This procedure obtains local EE balances for a given
90 jurisdiction code and populates them into a PL/SQL table. This
91 table is returned as an out parameter to the calling procedure
92 of Tax Balance Summary form.
93 *****************************************************************************/
94 PROCEDURE GET_LOCAL (p_ee_er IN VARCHAR2
95 , p_assg_id IN NUMBER
96 , p_asact_id IN NUMBER
97 , p_tax_unit_id NUMBER
98 , p_jurisdiction IN VARCHAR2
99 , p_school IN VARCHAR2
100 , p_local_taxes_tab OUT NOCOPY tab_taxes);
101
102 end;