[Home] [Help]
PACKAGE: APPS.PAY_AU_PAYTAX_PKG
Source
1 PACKAGE PAY_AU_PAYTAX_PKG AS
2 /* $Header: pyaupyt.pkh 120.4.12010000.1 2008/07/27 22:06:29 appldev 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 -------------------------------------------------------------------------------*/
25
26
27 procedure get_balances
28 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
29 p_registered_employer in NUMBER,
30 p_tax_state in varchar2,
31 p_salaries_wages out NOCOPY number,
32 p_commission out NOCOPY number,
33 p_bonus_allowances out NOCOPY number,
34 p_director_fees out NOCOPY number,
35 p_termination_payments out NOCOPY number,
36 p_eligible_term_payments out NOCOPY number,
37 p_Fringe_Benefits out NOCOPY number,
38 p_Superannuation out NOCOPY number,
39 p_Contractor_Payments out NOCOPY number,
40 p_Other_Taxable_Income out NOCOPY number,
41 p_taxable_income out NOCOPY number);
42
43
44 g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
45 g_ytd_balance_value_tab pay_balance_pkg.t_balance_value_tab;
46 g_context_table pay_balance_pkg.t_context_tab;
47 g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
48
49 PROCEDURE populate_defined_balance_ids
50 ( p_registered_employer NUMBER);
51
52 TYPE parameters IS RECORD ( business_group_id number,
53 legal_employer number,
54 period date, /*4709766 */
55 start_date date,
56 end_date date,
57 tax_state varchar2(3),
58 report_type varchar2(1),
59 report_name varchar2(30),
60 act_override_threshold number,
61 vic_override_threshold number,
62 nsw_override_threshold number,
63 qld_override_threshold number,
64 wa_override_threshold number,
65 nt_override_threshold number,
66 sa_override_threshold number,
67 tas_override_threshold number);
68
69 g_parameters parameters;
70
71
72 FUNCTION GET_TAX(p_no_of_states number,
73 p_dge_state varchar2,
74 p_dge_group_name varchar2,
75 p_state_code varchar2,
76 p_taxable_income NUMBER,
77 p_le_taxable_income NUMBER,
78 p_message out NOCOPY varchar2,
79 p_ot_message out NOCOPY varchar2,
80 p_start_date date,
81 p_End_date date,
82 p_override_threshold NUMBER ) RETURN NUMBER;
83
84
85 procedure range_code
86 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
87 ,p_sql out NOCOPY varchar2
88 );
89
90 procedure initialization_code
91 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
92
93 procedure assignment_action_code
94 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
95 ,p_start_person in per_all_people_f.person_id%type
96 ,p_end_person in per_all_people_f.person_id%type
97 ,p_chunk in number
98 );
99
100 procedure archive_code
101 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
102 ,p_effective_date in pay_payroll_actions.effective_date%type
103 );
104
105 procedure spawn_archive_reports
106 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
107
108
109 end pay_au_paytax_pkg;