PACKAGE: APPS.PY_ZA_TAX_REG

Source

1 PACKAGE py_za_tax_reg AS
2 /* $Header: pyzatreg.pkh 120.2 2005/06/28 00:12:04 kapalani noship $ */
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 J.N. Louw      04/02/2002    115.5               Removed OUT parameter
12                                                  p_cmpy_tax_ref_num from
13                                                  pre_process
14 J.N. Louw      04/02/2002    115.4               Added
15                                                  include_assignment
16 J.N. Louw      25/01/2002    115.2     1756600   Register was updated to
17                                        1756617   accommodate bug changes
18                                        1858619   and merge of both
19                                        2117507   current and terminated
20                                        2132644   assignments reports
21 A vd Berg      22-Jan-2001   110.11              Amended Version Number
22 G. Fraser      24-May-2000   110.3               Speed improvements
23 L.J.Kloppers   23-FEB-2000   110.2               Added p_tax_register_id
24                                                  IN OUT NOCOPY parameter
25 L.J.Kloppers   13-FEB-2000   110.1               Added p_total_employees
26                                                  and p_total_assignments
27                                                  IN OUT NOCOPY parameters
28 L.J.Kloppers   13-FEB-2000   110.0               Initial Version
29 */
30 -------------------------------------------------------------------------------
31 --                           PACKAGE SPECIFICATION                           --
32 -------------------------------------------------------------------------------
33 
34 -------------------------------------------------------------------------------
35 -- include_assignment
36 -- It is called from the value set PY_SRS_ZA_TX_RGSTR_ASG
37 -------------------------------------------------------------------------------
38 FUNCTION include_assignment (
39    p_asg_id          IN per_all_assignments_f.assignment_id%TYPE
40  , p_period_end_date IN per_time_periods.end_date%TYPE
41  , p_include_flag    IN VARCHAR2
42  ) RETURN VARCHAR2;
43 
44 -------------------------------------------------------------------------------
45 -- pre_process
46 -------------------------------------------------------------------------------
47 PROCEDURE pre_process (
48    p_payroll_id        IN     pay_all_payrolls_f.payroll_id%TYPE
49  , p_start_period_id   IN     per_time_periods.time_period_id%TYPE     DEFAULT NULL
50  , p_end_period_id     IN     per_time_periods.time_period_id%TYPE
51  , p_include           IN     VARCHAR2
52  , p_assignment_id     IN     per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
53  , p_retrieve_ptd      IN     VARCHAR2
54  , p_retrieve_mtd      IN     VARCHAR2
55  , p_retrieve_ytd      IN     VARCHAR2
56  , p_tax_register_id      OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
57  , p_payroll_name         OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
58  , p_period_num           OUT NOCOPY per_time_periods.period_num%TYPE
59  , p_period_start_date    OUT NOCOPY per_time_periods.start_date%TYPE
60  , p_period_end_date      OUT NOCOPY per_time_periods.end_date%TYPE
61  , p_tot_employees        OUT NOCOPY NUMBER
62  , p_tot_assignments      OUT NOCOPY NUMBER
63  );
64 
65 -------------------------------------------------------------------------------
66 -- clear_register
67 -------------------------------------------------------------------------------
68 PROCEDURE clear_register (
69    p_id IN pay_za_tax_registers.tax_register_id%TYPE
70  );
71 
72 end py_za_tax_reg;