PACKAGE: APPS.PAY_AU_RECONCILIATION_PKG

Source

1 package pay_au_reconciliation_pkg as
2 /* $Header: pyaurecs.pkh 120.0 2005/05/29 03:09:59 appldev noship $ */
3 
4 procedure get_au_rec_balances
5   (p_assignment_action_id  in pay_assignment_actions.assignment_action_id%type,
6    p_registered_employer        in NUMBER, --2610141
7    p_gross_earnings             out NOCOPY number,  /*Bug 3953706*/
8    p_non_taxable_earnings       out NOCOPY number,
9    p_pre_tax_deductions         out NOCOPY number, /*Bug 3953706*/
10    p_taxable_earnings           out NOCOPY number,
11    p_tax    			out NOCOPY number,
12    p_deductions			out NOCOPY number,
13    p_direct_payments            out NOCOPY number, /*Bug 3953706*/
14    p_net_payment        	out NOCOPY number,
15    p_employer_charges 		out NOCOPY number);
16 
17 procedure get_ytd_au_rec_balances
18   (p_assignment_action_id  	in pay_assignment_actions.assignment_action_id%type,
19    p_registered_employer        in NUMBER, --2610141
20    p_ytd_gross_earnings         out NOCOPY number,   /*Bug 3953706*/
21    p_ytd_non_taxable_earnings   out NOCOPY number,
22    p_ytd_pre_tax_deductions     out NOCOPY number,   /*Bug 3953706*/
23    p_ytd_taxable_earnings       out NOCOPY number,
24    p_ytd_tax    		out NOCOPY number,
25    p_ytd_deductions		out NOCOPY number,
26    p_ytd_direct_payments        out NOCOPY number,   /*Bug 3953706*/
27    p_ytd_net_payment        	out NOCOPY number,
28    p_ytd_employer_charges 	out NOCOPY number);
29 
30 g_balance_value_tab  pay_balance_pkg.t_balance_value_tab;
31 g_ytd_balance_value_tab  pay_balance_pkg.t_balance_value_tab; /*Bug 4040688*/
32 g_context_table         pay_balance_pkg.t_context_tab;  -- Bug 2610141
33 g_result_table          pay_balance_pkg.t_detailed_bal_out_tab; -- Bug 2610141
34 
35 PROCEDURE populate_defined_balance_ids
36           (p_ytd_totals   IN varchar2,
37   	   p_registered_employer NUMBER); --2610141
38 
39 g_parameters pay_au_rec_det_archive.parameters;
40 
41 procedure range_code
42 (p_payroll_action_id        in pay_payroll_actions.payroll_action_id%type
43 ,p_sql                      out NOCOPY varchar2
44 );
45 
46 procedure initialization_code
47 (p_payroll_action_id        in pay_payroll_actions.payroll_action_id%type);
48 
49 procedure assignment_action_code
50 (p_payroll_action_id        in pay_payroll_actions.payroll_action_id%type
51 ,p_start_person             in per_all_people_f.person_id%type
52 ,p_end_person               in per_all_people_f.person_id%type
53 ,p_chunk                    in number
54 );
55 
56 procedure archive_code
57 (p_assignment_action_id     in pay_assignment_actions.assignment_action_id%type
58 ,p_effective_date           in pay_payroll_actions.effective_date%type
59 );
60 
61 procedure spawn_archive_reports
62 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
63 
64 procedure check_report_parameters
65           (p_start_date      IN date,
66            p_end_date        IN date,
67            p_period_end_date IN date);
68 
69 end pay_au_reconciliation_pkg;