[Home] [Help]
PACKAGE: APPS.PAY_ZA_IRP5_ARCHIVE_PKG
Source
1 package pay_za_irp5_archive_pkg AUTHID CURRENT_USER as
2 /* $Header: pyzaarch.pkh 120.1.12010000.1 2008/07/28 00:02:38 appldev ship $ */
3 /*+======================================================================+
4 | Copyright (c) 1998 Oracle Corporation South Africa Ltd |
5 | Cape Town, Western Cape, South Africa |
6 | All rights reserved. |
7 +======================================================================+
8 SQL Script File name : pyzaarch.pkb
9 Description : This sql script seeds the Package that creates
10 the IRP5 Archive code
11
12 Change List:
13 ------------
14
15 Name Date Version Bug Text
16 -------------- ----------- ------- ------ ------------------------------
17 N. Bristow 23-Jun-1999 110.0 Initial Version created from
18 pyusarch.pkb
19 F.D. Loubser 29-Mar-2000 110.1 Added payroll_id insert on
20 payroll_action_id
21 F.D. Loubser 01-Jun-2000 110.2 Added za_to_char function
22 F.D. Loubser 18-Jul-2000 110.3 Limit initials to 5 characters
23 R.Kingham 23-Aug-2000 110.11 34307 Changed boolean to true to cater
24 for ass_sets with exclude assignments. See TAR34307
25 R.Kingham 25-Nov-2000 110.12 37293 The above fix created problems for Assignment Sets
26 with assignments set to Include.
27 See TAR37293 for comments
28 F.D. Loubser 19-Nov-2001 115.2 Added dbdrv line
29 L.Kloppers 12-Sep-2002 115.3 2224332 Modified Function set_size to accept two extra
30 non-mandatory parameters: Tax Status and Nature of
31 Person
32 L.Kloppers 27-Nov-2002 115.4 2686708 Added nocopy to out parameters
33 ========================================================================
34 */
35 type char240_data_type_table is table of varchar2(240)
36 index by binary_integer;
37
38 max_num varchar2(30) := 'START';
39 g_nature varchar2(1);
40 g_3696 number;
41 g_3699 number;
42 level_cnt number;
43
44 procedure range_cursor
45 (
46 pactid in number,
47 sqlstr out nocopy varchar2
48 );
49
50 procedure action_creation
51 (
52 pactid in number,
53 stperson in number,
54 endperson in number,
55 chunk in number
56 );
57
58 procedure archive_data
59 (
60 p_assactid in number,
61 p_effective_date in date
62 );
63
64 procedure archinit
65 (
66 p_payroll_action_id in number
67 );
68
69 procedure archdinit
70 (
71 p_payroll_action_id in number
72 );
73
74 function get_parameter
75 (
76 name in varchar2,
77 parameter_list varchar2
78 ) return varchar2;
79 pragma restrict_references(get_parameter, WNDS, WNPS);
80
81 function get_lump_sum
82 (
83 p_assid in number, -- The Assignment ID
84 p_assactid in number, -- The Assignment Action ID of a Payroll Run
85 p_index in number -- Identifies the balance we are looking for
86 ) return varchar2;
87 --pragma restrict_references(get_lump_sum, WNDS);
88
89 function initials
90 (
91 name varchar2
92 ) return varchar2;
93 pragma restrict_references(initials, WNDS, WNPS);
94
95 function names
96 (
97 name varchar2
98 ) return varchar2;
99 pragma restrict_references(names, WNDS, WNPS);
100
101 function clean
102 (
103 name varchar2
104 ) return varchar2;
105
106 function get_size return number;
107
108 function get_employer_count return number;
109
110 function get_employer_code return number;
111
112 function get_employer_amounts return number;
113
114 function get_file_count return number;
115
116 function gen_x
117 (
118 p_code in varchar2,
119 p_bg_id in varchar2,
120 p_tax_year in varchar2,
121 p_test_flag in varchar2
122 ) return varchar2;
123
124 function cert_num
125 (
126 p_bg number,
127 p_tax_year varchar2,
128 p_pay varchar2,
129 p_ass number
130 ) return varchar2;
131
132 function set_size
133 (
134 p_code in varchar2,
135 p_type in varchar2,
136 p_value in varchar2,
137 p_tax_status in varchar2 default 'A',
138 p_nature in varchar2 default 'A'
139 ) return varchar2;
140
141 function za_power
142 (
143 p_number in number,
144 p_power in number
145 ) return number;
146
147 function za_to_char
148 (
149 p_number in number,
150 p_format in varchar2 default '&&&'
151 ) return varchar2;
152
153 function put_nature
154 (
155 p_nature in varchar2
156 ) return varchar2;
157
158 function put_3696
159 (
160 p_3696 in number
161 ) return varchar2;
162
163 function put_3699
164 (
165 p_3699 in number
166 ) return varchar2;
167
168 function get_stored_values
169 (
170 p_nature out nocopy varchar2,
171 p_3699 out nocopy number,
172 p_3696 out nocopy number
173 ) return varchar2;
174
175 end pay_za_irp5_archive_pkg;