1 package py_za_tax_certificates AUTHID CURRENT_USER as
2 /* $Header: pyzatcer.pkh 120.3.12010000.1 2008/07/28 00:05:39 appldev ship $ */
3 /*
4 -- +======================================================================+
5 -- | Copyright (c) 1998 Oracle Corporation South Africa Ltd |
6 -- | Cape Town, Western Cape, South Africa |
7 -- | All rights reserved. |
8 -- +======================================================================+
9 -- SQL Script File Name : pyzatcer.pkh
10 -- Description : This sql script seeds the py_za_tax_certificates
11 -- package for the ZA localisation. This package
12 -- is used in the Tax Certificate reports.
13 --
14 -- Change List:
15 -- ------------
16 --
17 -- Name Date Version Bug Text
18 -- -------------- ----------- ------- ------- -----------------------------
19 -- F.D. Loubser 08-May-2000 110.0 Initial version
20 --
21 -- J.N. Louw 24-Aug-2000 115.0 Updated for ZAPatch11i.01
22 -- F.D. Loubser 11-Sep-2000 115.1 Updated for CBO
23 -- L. Kloppers 12 Sep 2002 115.2 2224332 Added Function get_sars_code to return correct SARS Code
24 -- in case of a Director or Foreign Income
25 -- Nageswara 17-Feb-2004 115.3 3396163 commented 'serverout on' - GSCC
26 A. Mahanty 18-May-2006 115.5 5231652 the unused procedure get_tax_data
27 commented out
28 -- ========================================================================
29 */
30 ---------------------------------------------------------------------------
31 -- Global variables
32 ---------------------------------------------------------------------------
33 g_assignment_id pay_assignment_actions.assignment_id%type;
34 g_tax_status pay_run_result_values.result_value%type;
35
36 ---------------------------------------------------------------------------
37 -- This function is used to populate the temporary table for the IRP5 and
38 -- IT3A reports
39 -- It returns the sequence number of the temporary values
40 ---------------------------------------------------------------------------
41 function populate_temporary_table
42 (
43 p_irp5_indicator in varchar2,
44 p_payroll_action_id in varchar2,
45 p_employee in number
46 ) return number;
47
48 ---------------------------------------------------------------------------
49 -- This function is used to indicate whether the Certificate is an IRP5 or
50 -- an IT3A
51 ---------------------------------------------------------------------------
52 function irp5_indicator
53 (
54 p_assignment_action_id in number
55 ) return varchar2;
56 pragma restrict_references(irp5_indicator, WNDS, WNPS);
57
58 ---------------------------------------------------------------------------
59 -- This function is used to retrieve the Tax Status, Tax Directive Number
60 -- and Tax Directive Value Input Values from the ZA_Tax element
61 ---------------------------------------------------------------------------
62 /* Bug 5231652
63 procedure get_tax_data
64 (
65 assignment_id in number,
66 assignment_action_id in number,
67 date_earned in date,
68 p_tax_status in out nocopy varchar2,
69 p_directive_number in out nocopy varchar2,
70 p_directive_value in out nocopy number,
71 p_lump_sum_indicator in varchar2
72 );
73 */
74
75 function get_sars_code
76 (
77 p_sars_code in varchar2,
78 p_tax_status in varchar2,
79 p_nature in varchar2
80 ) return varchar2;
81
82
83 end py_za_tax_certificates;