1 package pay_us_tax_bal_summary_pkg AUTHID CURRENT_USER as
2 /* $Header: pyustxbs.pkh 115.1 2003/12/22 07:35:03 sdahiya noship $ */
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
35 *****************************************************************************/
36
37
38 -- record to store tax name and values for different time dimensions
39
40 TYPE taxes_rec IS RECORD (
41 prompt pay_us_tax_balances.balance_category_code%type,
42 ptd_val number,
43 mtd_val number,
44 qtd_val number,
45 ytd_val number
46 );
47
48 TYPE tab_taxes IS TABLE of taxes_rec INDEX BY BINARY_INTEGER;
49
50
51 /*****************************************************************************
52 Name : GET_FED
53 Purpose : This procedure obtains federal EE/ER balances for a given
54 assignment action and populates them into a PL/SQL table. This
55 table is returned as an out parameter to the calling procedure
56 of Tax Balance Summary form.
57 *****************************************************************************/
58
59 PROCEDURE GET_FED (p_ee_er IN VARCHAR2
60 , p_assg_id IN NUMBER
61 , p_asact_id IN NUMBER
62 , p_tax_unit_id IN NUMBER
63 , p_fed_taxes_tab OUT NOCOPY tab_taxes);
64
65
66
67 /*****************************************************************************
68 Name : GET_STATE
69 Purpose : This procedure obtains state EE/ER balances for a given
70 state and populates them into a PL/SQL table. This
71 table is returned as an out parameter to the calling procedure
72 of Tax Balance Summary form.
73 *****************************************************************************/
74
75 PROCEDURE GET_STATE (p_ee_er IN VARCHAR2
76 , p_assg_id IN NUMBER
77 , p_asact_id IN NUMBER
78 , p_tax_unit_id IN NUMBER
79 , p_state_code IN VARCHAR2
80 , p_state_taxes_tab OUT NOCOPY tab_taxes);
81
82
83 /*****************************************************************************
84 Name : GET_LOCAL
85 Purpose : This procedure obtains local EE balances for a given
86 jurisdiction code and populates them into a PL/SQL table. This
87 table is returned as an out parameter to the calling procedure
88 of Tax Balance Summary form.
89 *****************************************************************************/
90 PROCEDURE GET_LOCAL (p_ee_er IN VARCHAR2
91 , p_assg_id IN NUMBER
92 , p_asact_id IN NUMBER
93 , p_tax_unit_id NUMBER
94 , p_jurisdiction IN VARCHAR2
95 , p_school IN VARCHAR2
96 , p_local_taxes_tab OUT NOCOPY tab_taxes);
97
98 end;