[Home] [Help]
PACKAGE: APPS.PY_ZA_TAX_REG
Source
1 PACKAGE PY_ZA_TAX_REG AUTHID CURRENT_USER AS
2 /* $Header: pyzatreg.pkh 120.3.12020000.2 2012/07/05 04:39:10 amnaraya ship $ */
3 /* Copyright (c) 2001 Oracle Corporation Redwood Shores, California, USA */
4 /* All rights reserved.
5 /*
6 Change List:
7 ------------
8
9 Name Date Version Bug Text
10 -------------- ----------- ------- ------- -----------------------
11 NCHINNAM 01/12/2011 115.10 13444804 New Tax Register Report(Using BI Publisher) Enhancement
12 P.Arusia 2/12/2009 115.9 9117260 Added pre_process_01032009
13 for use from 01-03-2009
14 J.N. Louw 04/02/2002 115.5 Removed OUT parameter
15 p_cmpy_tax_ref_num from
16 pre_process
17 J.N. Louw 04/02/2002 115.4 Added
18 include_assignment
19 J.N. Louw 25/01/2002 115.2 1756600 Register was updated to
20 1756617 accommodate bug changes
21 1858619 and merge of both
22 2117507 current and terminated
23 2132644 assignments reports
24 A vd Berg 22-Jan-2001 110.11 Amended Version Number
25 G. Fraser 24-May-2000 110.3 Speed improvements
26 L.J.Kloppers 23-FEB-2000 110.2 Added p_tax_register_id
27 IN OUT NOCOPY parameter
28 L.J.Kloppers 13-FEB-2000 110.1 Added p_total_employees
29 and p_total_assignments
30 IN OUT NOCOPY parameters
31 L.J.Kloppers 13-FEB-2000 110.0 Initial Version
32 */
33 -------------------------------------------------------------------------------
34 -- PACKAGE SPECIFICATION --
35 -------------------------------------------------------------------------------
36
37 -------------------------------------------------------------------------------
38 -- include_assignment
39 -- It is called from the value set PY_SRS_ZA_TX_RGSTR_ASG
40 -------------------------------------------------------------------------------
41 FUNCTION include_assignment (
42 p_asg_id IN per_all_assignments_f.assignment_id%TYPE
43 , p_period_end_date IN per_time_periods.end_date%TYPE
44 , p_include_flag IN VARCHAR2
45 ) RETURN VARCHAR2;
46
47 -------------------------------------------------------------------------------
48 -- pre_process
49 -------------------------------------------------------------------------------
50 PROCEDURE pre_process (
51 p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
52 , p_start_period_id IN per_time_periods.time_period_id%TYPE DEFAULT NULL
53 , p_end_period_id IN per_time_periods.time_period_id%TYPE
54 , p_include IN VARCHAR2
55 , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
56 , p_retrieve_ptd IN VARCHAR2
57 , p_retrieve_mtd IN VARCHAR2
58 , p_retrieve_ytd IN VARCHAR2
59 , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
60 , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
61 , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
62 , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
63 , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
64 , p_tot_employees OUT NOCOPY NUMBER
65 , p_tot_assignments OUT NOCOPY NUMBER
66 , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804
67 );
68
69 -------------------------------------------------------------------------------
70 -- pre_process_01032009
71 -------------------------------------------------------------------------------
72 PROCEDURE pre_process_01032009 (
73 p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
74 , p_start_period_id IN per_time_periods.time_period_id%TYPE DEFAULT NULL
75 , p_end_period_id IN per_time_periods.time_period_id%TYPE
76 , p_include IN VARCHAR2
77 , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
78 , p_retrieve_ptd IN VARCHAR2
79 , p_retrieve_mtd IN VARCHAR2
80 , p_retrieve_ytd IN VARCHAR2
81 , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
82 , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
83 , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
84 , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
85 , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
86 , p_tot_employees OUT NOCOPY NUMBER
87 , p_tot_assignments OUT NOCOPY NUMBER
88 , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804
89 );
90 -------------------------------------------------------------------------------
91 -- clear_register
92 -------------------------------------------------------------------------------
93 PROCEDURE clear_register (
94 p_id IN pay_za_tax_registers.tax_register_id%TYPE
95 );
96
97 PROCEDURE archive_set_globals (
98 p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
99 , p_start_period_id IN per_time_periods.time_period_id%TYPE
100 , p_end_period_id IN per_time_periods.time_period_id%TYPE
101 , p_include IN VARCHAR2
102 , p_retrieve_ptd IN VARCHAR2
103 , p_retrieve_mtd IN VARCHAR2
104 , p_retrieve_ytd IN VARCHAR2
105 , p_tax_year IN VARCHAR2
106 );
107
108 end py_za_tax_reg;