[Home] [Help]
PACKAGE: APPS.PAY_AU_PAYTAX_PKG
Source
1 PACKAGE PAY_AU_PAYTAX_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyaupyt.pkh 120.4.12020000.3 2013/02/18 06:01:05 skshin ship $ */
3
4 /*
5 **
6 ** Copyright (C) 1999 Oracle Corporation
7 ** All Rights Reserved
8 **
9 ** AU HRMS Payroll Tax package
10 **
11 ** Change List
12 ** ===========
13 **
14 ** Date Author Reference Description
15 ** -----------+--------+---------+-------------
16 ** 29 JAN 2001 SHOSKATT N/A Created
17 ** 20 Jun 2002 Ragovind 2272424 Modified the Get_Tax Function Declaration
18 ** 03 Dec 2002 Ragovind 2689226 Added NOCOPY for the function get_tax
19 ** 09 AUG 2004 abhkumar 2610141 Added tax_unit_id in function GET_BALANCE for Legal Employer enhancement
20 ** 25 Aug 2005 hnainani 3541814 Added / Modified functions for Payroll Tax Grouping
21 ** 03 Nov 2005 hnainani 4709766 Added Period to the Global Parameters
22 ** 26 Feb 2008 vdabgar 6839263 Added p_output_type to the Parameters type.
23 ** 18 Mar 2008 avenkatk 6839263 Backed out changes to Parameters Record Type
24 ** 18 Feb 2013 skshin 14134526 Added plsql table for each state balance
25 -------------------------------------------------------------------------------*/
26
27
28 procedure get_balances
29 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
30 p_registered_employer in NUMBER,
31 p_tax_state in varchar2,
32 p_salaries_wages out NOCOPY number,
33 p_commission out NOCOPY number,
34 p_bonus_allowances out NOCOPY number,
35 p_director_fees out NOCOPY number,
36 p_termination_payments out NOCOPY number,
37 p_eligible_term_payments out NOCOPY number,
38 p_Fringe_Benefits out NOCOPY number,
39 p_Superannuation out NOCOPY number,
40 p_Contractor_Payments out NOCOPY number,
41 p_Other_Taxable_Income out NOCOPY number,
42 p_taxable_income out NOCOPY number,
43 p_salaries_wages_2 out NOCOPY number,
44 p_commission_2 out NOCOPY number,
45 p_bonus_allowances_2 out NOCOPY number,
46 p_director_fees_2 out NOCOPY number,
47 p_Fringe_Benefits_2 out NOCOPY number,
48 p_Superannuation_2 out NOCOPY number,
49 p_Contractor_Payments_2 out NOCOPY number,
50 p_Other_Taxable_Income_2 out NOCOPY number );
51
52
53 g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
54 g_ytd_balance_value_tab pay_balance_pkg.t_balance_value_tab;
55 g_context_table pay_balance_pkg.t_context_tab;
56 g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
57
58 /* start 14134526 */
59 g_balance_value_tab_vic pay_balance_pkg.t_balance_value_tab;
60 g_balance_value_tab_nsw pay_balance_pkg.t_balance_value_tab;
61 g_balance_value_tab_act pay_balance_pkg.t_balance_value_tab;
62 g_balance_value_tab_sa pay_balance_pkg.t_balance_value_tab;
63 g_balance_value_tab_qld pay_balance_pkg.t_balance_value_tab;
64 g_balance_value_tab_tas pay_balance_pkg.t_balance_value_tab;
65 g_balance_value_tab_wa pay_balance_pkg.t_balance_value_tab;
66 g_balance_value_tab_nt pay_balance_pkg.t_balance_value_tab;
67 g_result_table_state pay_balance_pkg.t_detailed_bal_out_tab;
68 /* end 14134526 */
69
70 PROCEDURE populate_defined_balance_ids
71 ( p_registered_employer NUMBER);
72
73 TYPE parameters IS RECORD ( business_group_id number,
74 legal_employer number,
75 period date, /*4709766 */
76 start_date date,
77 end_date date,
78 tax_state varchar2(3),
79 report_type varchar2(1),
80 report_name varchar2(30),
81 act_override_threshold number,
82 vic_override_threshold number,
83 nsw_override_threshold number,
84 qld_override_threshold number,
85 wa_override_threshold number,
86 nt_override_threshold number,
87 sa_override_threshold number,
88 tas_override_threshold number);
89
90 g_parameters parameters;
91
92
93 FUNCTION GET_TAX(p_no_of_states number,
94 p_dge_state varchar2,
95 p_dge_group_name varchar2,
96 p_state_code varchar2,
97 p_taxable_income NUMBER,
98 p_le_taxable_income NUMBER,
99 p_message out NOCOPY varchar2,
100 p_ot_message out NOCOPY varchar2,
101 p_start_date date,
102 p_End_date date,
103 p_override_threshold NUMBER ) RETURN NUMBER;
104
105
106 procedure range_code
107 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
108 ,p_sql out NOCOPY varchar2
109 );
110
111 procedure initialization_code
112 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
113
114 procedure assignment_action_code
115 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
116 ,p_start_person in per_all_people_f.person_id%type
117 ,p_end_person in per_all_people_f.person_id%type
118 ,p_chunk in number
119 );
120
121 procedure archive_code
122 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
123 ,p_effective_date in pay_payroll_actions.effective_date%type
124 );
125
126 procedure spawn_archive_reports
127 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
128
129
130 end pay_au_paytax_pkg;