eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PER_GB_TAX_BEN_PKG

Source


1 PACKAGE per_gb_tax_ben_pkg
2 /* $Header: pegbtaxb.pkh 115.4 2003/01/28 11:35:44 gbutler noship $ */
3 AUTHID CURRENT_USER AS
4 
5 -- This constant is now defined in the spec as the defualts needs
6 -- to be the same in the header and the body.
7 
8    c_default_action_if_exists   CONSTANT VARCHAR2 (1)  := 'I';
9 
10    TYPE g_batch_line IS RECORD (
11       session_date                  DATE,
12       batch_id                      pay_batch_lines.batch_id%TYPE,
13       assignment_id                 pay_batch_lines.assignment_id%TYPE,
14       assignment_number             pay_batch_lines.assignment_number%TYPE,
15       attribute_category            pay_batch_lines.attribute_category%TYPE,
16       attribute1                    pay_batch_lines.attribute1%TYPE,
17       attribute2                    pay_batch_lines.attribute2%TYPE,
18       attribute3                    pay_batch_lines.attribute3%TYPE,
19       attribute4                    pay_batch_lines.attribute4%TYPE,
20       attribute5                    pay_batch_lines.attribute5%TYPE,
21       attribute6                    pay_batch_lines.attribute6%TYPE,
22       attribute7                    pay_batch_lines.attribute7%TYPE,
23       attribute8                    pay_batch_lines.attribute8%TYPE,
24       attribute9                    pay_batch_lines.attribute9%TYPE,
25       attribute10                   pay_batch_lines.attribute10%TYPE,
26       attribute11                   pay_batch_lines.attribute11%TYPE,
27       attribute12                   pay_batch_lines.attribute12%TYPE,
28       attribute13                   pay_batch_lines.attribute13%TYPE,
29       attribute14                   pay_batch_lines.attribute14%TYPE,
30       attribute15                   pay_batch_lines.attribute15%TYPE,
31       attribute16                   pay_batch_lines.attribute16%TYPE,
32       attribute17                   pay_batch_lines.attribute17%TYPE,
33       attribute18                   pay_batch_lines.attribute18%TYPE,
34       attribute19                   pay_batch_lines.attribute19%TYPE,
35       attribute20                   pay_batch_lines.attribute20%TYPE,
36       batch_sequence                pay_batch_lines.batch_sequence%TYPE,
37       concatenated_segments         pay_batch_lines.concatenated_segments%TYPE,
38       cost_allocation_keyflex_id    pay_batch_lines.cost_allocation_keyflex_id%TYPE,
39       effective_date                pay_batch_lines.effective_date%TYPE,
40       effective_start_date          pay_batch_lines.effective_start_date%TYPE,
41       effective_end_date            pay_batch_lines.effective_end_date%TYPE,
42       element_name                  pay_batch_lines.element_name%TYPE,
43       element_type_id               pay_batch_lines.element_type_id%TYPE,
44       reason                        pay_batch_lines.reason%TYPE,
45       segment1                      pay_batch_lines.segment1%TYPE,
46       segment2                      pay_batch_lines.segment2%TYPE,
47       segment3                      pay_batch_lines.segment3%TYPE,
48       segment4                      pay_batch_lines.segment4%TYPE,
49       segment5                      pay_batch_lines.segment5%TYPE,
50       segment6                      pay_batch_lines.segment6%TYPE,
51       segment7                      pay_batch_lines.segment7%TYPE,
52       segment8                      pay_batch_lines.segment8%TYPE,
53       segment9                      pay_batch_lines.segment9%TYPE,
54       segment10                     pay_batch_lines.segment10%TYPE,
55       segment11                     pay_batch_lines.segment11%TYPE,
56       segment12                     pay_batch_lines.segment12%TYPE,
57       segment13                     pay_batch_lines.segment13%TYPE,
58       segment14                     pay_batch_lines.segment14%TYPE,
59       segment15                     pay_batch_lines.segment15%TYPE,
60       segment16                     pay_batch_lines.segment16%TYPE,
61       segment17                     pay_batch_lines.segment17%TYPE,
62       segment18                     pay_batch_lines.segment18%TYPE,
63       segment19                     pay_batch_lines.segment19%TYPE,
64       segment20                     pay_batch_lines.segment20%TYPE,
65       segment21                     pay_batch_lines.segment21%TYPE,
66       segment22                     pay_batch_lines.segment22%TYPE,
67       segment23                     pay_batch_lines.segment23%TYPE,
68       segment24                     pay_batch_lines.segment24%TYPE,
69       segment25                     pay_batch_lines.segment25%TYPE,
70       segment26                     pay_batch_lines.segment26%TYPE,
71       segment27                     pay_batch_lines.segment27%TYPE,
72       segment28                     pay_batch_lines.segment28%TYPE,
73       segment29                     pay_batch_lines.segment29%TYPE,
74       segment30                     pay_batch_lines.segment30%TYPE,
75       value_1                       pay_batch_lines.value_1%TYPE,
76       value_2                       pay_batch_lines.value_2%TYPE,
77       value_3                       pay_batch_lines.value_3%TYPE,
78       value_4                       pay_batch_lines.value_4%TYPE,
79       value_5                       pay_batch_lines.value_5%TYPE,
80       value_6                       pay_batch_lines.value_6%TYPE,
81       value_7                       pay_batch_lines.value_7%TYPE,
82       value_8                       pay_batch_lines.value_8%TYPE,
83       value_9                       pay_batch_lines.value_9%TYPE,
84       value_10                      pay_batch_lines.value_10%TYPE,
85       value_11                      pay_batch_lines.value_11%TYPE,
86       value_12                      pay_batch_lines.value_12%TYPE,
87       value_13                      pay_batch_lines.value_13%TYPE,
88       value_14                      pay_batch_lines.value_14%TYPE,
89       value_15                      pay_batch_lines.value_15%TYPE,
90       entry_information_category    pay_batch_lines.entry_information_category%TYPE,
91       entry_information1  pay_batch_lines.entry_information1%TYPE,
92       entry_information2  pay_batch_lines.entry_information1%TYPE,
93       entry_information3  pay_batch_lines.entry_information1%TYPE,
94       entry_information4  pay_batch_lines.entry_information1%TYPE,
95       entry_information5  pay_batch_lines.entry_information1%TYPE,
96       entry_information6  pay_batch_lines.entry_information1%TYPE,
97       entry_information7  pay_batch_lines.entry_information1%TYPE,
98       entry_information8  pay_batch_lines.entry_information1%TYPE,
99       entry_information9  pay_batch_lines.entry_information1%TYPE,
100       entry_information10  pay_batch_lines.entry_information1%TYPE,
101       entry_information11  pay_batch_lines.entry_information1%TYPE,
102       entry_information12  pay_batch_lines.entry_information1%TYPE,
103       entry_information13  pay_batch_lines.entry_information1%TYPE,
104       entry_information14  pay_batch_lines.entry_information1%TYPE,
105       entry_information15  pay_batch_lines.entry_information1%TYPE,
106       entry_information16  pay_batch_lines.entry_information1%TYPE,
107       entry_information17  pay_batch_lines.entry_information1%TYPE,
108       entry_information18  pay_batch_lines.entry_information1%TYPE,
109       entry_information19  pay_batch_lines.entry_information1%TYPE,
110       entry_information20  pay_batch_lines.entry_information1%TYPE,
111       entry_information21  pay_batch_lines.entry_information1%TYPE,
112       entry_information22  pay_batch_lines.entry_information1%TYPE,
113       entry_information23  pay_batch_lines.entry_information1%TYPE,
114       entry_information24  pay_batch_lines.entry_information1%TYPE,
115       entry_information25  pay_batch_lines.entry_information1%TYPE,
116       entry_information26  pay_batch_lines.entry_information1%TYPE,
117       entry_information27  pay_batch_lines.entry_information1%TYPE,
118       entry_information28  pay_batch_lines.entry_information1%TYPE,
119       entry_information29  pay_batch_lines.entry_information1%TYPE,
120       entry_information30  pay_batch_lines.entry_information1%TYPE
121                                                                  );
122 
123    -- OVERLOADING PROCEDURE
124    PROCEDURE create_tax_ben_batch_line (
125       p_batch_line   IN       g_batch_line,
126       p_bline_id     OUT NOCOPY      NUMBER,
127       p_obj_vn       OUT NOCOPY      NUMBER
128    );
129 
130    PROCEDURE upload_tax_ben (
131       errbuf                     OUT NOCOPY      VARCHAR2,
132       retcode                    OUT NOCOPY      NUMBER,
133       p_file_name                IN       VARCHAR2,
134       p_effective_date           IN       VARCHAR2,
135       p_business_group_id        IN       per_business_groups.business_group_id%TYPE,
136       p_delimiter                IN       VARCHAR2,
137       p_action_if_exists         IN       VARCHAR2 DEFAULT NULL,
138       p_date_effective_changes   IN       VARCHAR2 DEFAULT NULL,
139       p_batch_name               IN       VARCHAR2 DEFAULT NULL
140    );
141 
142    PROCEDURE break_up_line (
143       p_line           IN       VARCHAR2,
144       p_session_date   IN       DATE,
145       p_batch_id       IN       pay_batch_lines.batch_id%TYPE,
146       p_batch_seq      IN       pay_batch_lines.batch_sequence%TYPE,
147       p_delimiter      IN       VARCHAR2,
148       p_bg_id          IN       per_business_groups.business_group_id%TYPE,
149       p_leg_cd         IN       per_business_groups.legislation_code%TYPE,
150       p_batch_line     OUT NOCOPY      g_batch_line
151    );
152 
153    PROCEDURE create_tax_ben_batch_header (
154       p_effective_date           IN       DATE,
155       p_name                     IN       VARCHAR2,
156       p_bg_id                    IN       NUMBER,
157       p_action_if_exists         IN       VARCHAR2 DEFAULT c_default_action_if_exists ,
158       p_date_effective_changes   IN       VARCHAR2 DEFAULT NULL,
159       p_batch_id                 OUT NOCOPY      NUMBER,
160       p_ovn                      OUT NOCOPY      NUMBER
161    );
162 
163    PROCEDURE create_tax_ben_batch_line (
164       p_session_date                 IN       DATE,
165       p_batch_id                     IN       NUMBER,
166       p_assignment_id                IN       NUMBER DEFAULT NULL,
167       p_assignment_number            IN       VARCHAR2 DEFAULT NULL,
168       p_attribute_category           IN       VARCHAR2 DEFAULT NULL,
169       p_attribute1                   IN       VARCHAR2 DEFAULT NULL,
170       p_attribute2                   IN       VARCHAR2 DEFAULT NULL,
171       p_attribute3                   IN       VARCHAR2 DEFAULT NULL,
172       p_attribute4                   IN       VARCHAR2 DEFAULT NULL,
173       p_attribute5                   IN       VARCHAR2 DEFAULT NULL,
174       p_attribute6                   IN       VARCHAR2 DEFAULT NULL,
175       p_attribute7                   IN       VARCHAR2 DEFAULT NULL,
176       p_attribute8                   IN       VARCHAR2 DEFAULT NULL,
177       p_attribute9                   IN       VARCHAR2 DEFAULT NULL,
178       p_attribute10                  IN       VARCHAR2 DEFAULT NULL,
179       p_attribute11                  IN       VARCHAR2 DEFAULT NULL,
180       p_attribute12                  IN       VARCHAR2 DEFAULT NULL,
181       p_attribute13                  IN       VARCHAR2 DEFAULT NULL,
182       p_attribute14                  IN       VARCHAR2 DEFAULT NULL,
183       p_attribute15                  IN       VARCHAR2 DEFAULT NULL,
184       p_attribute16                  IN       VARCHAR2 DEFAULT NULL,
185       p_attribute17                  IN       VARCHAR2 DEFAULT NULL,
186       p_attribute18                  IN       VARCHAR2 DEFAULT NULL,
187       p_attribute19                  IN       VARCHAR2 DEFAULT NULL,
188       p_attribute20                  IN       VARCHAR2 DEFAULT NULL,
189       p_batch_sequence               IN       NUMBER DEFAULT NULL,
190       p_concatenated_segments        IN       VARCHAR2 DEFAULT NULL,
191       p_cost_allocation_keyflex_id   IN       NUMBER DEFAULT NULL,
192       p_effective_date               IN       DATE,
193       p_effective_start_date         IN       DATE DEFAULT NULL,
194       p_effective_end_date           IN       DATE DEFAULT NULL,
195       p_element_name                 IN       VARCHAR2 DEFAULT NULL,
196       p_element_type_id              IN       NUMBER DEFAULT NULL,
197       p_reason                       IN       VARCHAR2 DEFAULT NULL,
198       p_segment1                     IN       VARCHAR2 DEFAULT NULL,
199       p_segment2                     IN       VARCHAR2 DEFAULT NULL,
200       p_segment3                     IN       VARCHAR2 DEFAULT NULL,
201       p_segment4                     IN       VARCHAR2 DEFAULT NULL,
202       p_segment5                     IN       VARCHAR2 DEFAULT NULL,
203       p_segment6                     IN       VARCHAR2 DEFAULT NULL,
204       p_segment7                     IN       VARCHAR2 DEFAULT NULL,
205       p_segment8                     IN       VARCHAR2 DEFAULT NULL,
206       p_segment9                     IN       VARCHAR2 DEFAULT NULL,
207       p_segment10                    IN       VARCHAR2 DEFAULT NULL,
208       p_segment11                    IN       VARCHAR2 DEFAULT NULL,
209       p_segment12                    IN       VARCHAR2 DEFAULT NULL,
210       p_segment13                    IN       VARCHAR2 DEFAULT NULL,
211       p_segment14                    IN       VARCHAR2 DEFAULT NULL,
212       p_segment15                    IN       VARCHAR2 DEFAULT NULL,
213       p_segment16                    IN       VARCHAR2 DEFAULT NULL,
214       p_segment17                    IN       VARCHAR2 DEFAULT NULL,
215       p_segment18                    IN       VARCHAR2 DEFAULT NULL,
216       p_segment19                    IN       VARCHAR2 DEFAULT NULL,
217       p_segment20                    IN       VARCHAR2 DEFAULT NULL,
218       p_segment21                    IN       VARCHAR2 DEFAULT NULL,
219       p_segment22                    IN       VARCHAR2 DEFAULT NULL,
220       p_segment23                    IN       VARCHAR2 DEFAULT NULL,
221       p_segment24                    IN       VARCHAR2 DEFAULT NULL,
222       p_segment25                    IN       VARCHAR2 DEFAULT NULL,
223       p_segment26                    IN       VARCHAR2 DEFAULT NULL,
224       p_segment27                    IN       VARCHAR2 DEFAULT NULL,
225       p_segment28                    IN       VARCHAR2 DEFAULT NULL,
226       p_segment29                    IN       VARCHAR2 DEFAULT NULL,
227       p_segment30                    IN       VARCHAR2 DEFAULT NULL,
228       p_value_1                      IN       VARCHAR2 DEFAULT NULL,
229       p_value_2                      IN       VARCHAR2 DEFAULT NULL,
230       p_value_3                      IN       VARCHAR2 DEFAULT NULL,
231       p_value_4                      IN       VARCHAR2 DEFAULT NULL,
232       p_value_5                      IN       VARCHAR2 DEFAULT NULL,
233       p_value_6                      IN       VARCHAR2 DEFAULT NULL,
234       p_value_7                      IN       VARCHAR2 DEFAULT NULL,
235       p_value_8                      IN       VARCHAR2 DEFAULT NULL,
236       p_value_9                      IN       VARCHAR2 DEFAULT NULL,
237       p_value_10                     IN       VARCHAR2 DEFAULT NULL,
238       p_value_11                     IN       VARCHAR2 DEFAULT NULL,
239       p_value_12                     IN       VARCHAR2 DEFAULT NULL,
240       p_value_13                     IN       VARCHAR2 DEFAULT NULL,
241       p_value_14                     IN       VARCHAR2 DEFAULT NULL,
242       p_value_15                     IN       VARCHAR2 DEFAULT NULL,
243       p_entry_information_category   IN       VARCHAR2 DEFAULT NULL,
244       p_entry_information1           IN       VARCHAR2 DEFAULT NULL,
245       p_entry_information2           IN       VARCHAR2 DEFAULT NULL,
246       p_entry_information3           IN       VARCHAR2 DEFAULT NULL,
247       p_entry_information4           IN       VARCHAR2 DEFAULT NULL,
248       p_entry_information5           IN       VARCHAR2 DEFAULT NULL,
249       p_entry_information6           IN       VARCHAR2 DEFAULT NULL,
250       p_entry_information7           IN       VARCHAR2 DEFAULT NULL,
251       p_entry_information8           IN       VARCHAR2 DEFAULT NULL,
252       p_entry_information9           IN       VARCHAR2 DEFAULT NULL,
253       p_entry_information10          IN       VARCHAR2 DEFAULT NULL,
254       p_entry_information11          IN       VARCHAR2 DEFAULT NULL,
255       p_entry_information12          IN       VARCHAR2 DEFAULT NULL,
256       p_entry_information13          IN       VARCHAR2 DEFAULT NULL,
257       p_entry_information14          IN       VARCHAR2 DEFAULT NULL,
258       p_entry_information15          IN       VARCHAR2 DEFAULT NULL,
259       p_entry_information16          IN       VARCHAR2 DEFAULT NULL,
260       p_entry_information17          IN       VARCHAR2 DEFAULT NULL,
261       p_entry_information18          IN       VARCHAR2 DEFAULT NULL,
262       p_entry_information19          IN       VARCHAR2 DEFAULT NULL,
263       p_entry_information20          IN       VARCHAR2 DEFAULT NULL,
264       p_entry_information21          IN       VARCHAR2 DEFAULT NULL,
265       p_entry_information22          IN       VARCHAR2 DEFAULT NULL,
266       p_entry_information23          IN       VARCHAR2 DEFAULT NULL,
267       p_entry_information24          IN       VARCHAR2 DEFAULT NULL,
268       p_entry_information25          IN       VARCHAR2 DEFAULT NULL,
269       p_entry_information26          IN       VARCHAR2 DEFAULT NULL,
270       p_entry_information27          IN       VARCHAR2 DEFAULT NULL,
271       p_entry_information28          IN       VARCHAR2 DEFAULT NULL,
272       p_entry_information29          IN       VARCHAR2 DEFAULT NULL,
273       p_entry_information30          IN       VARCHAR2 DEFAULT NULL,
274       p_bl_id                        OUT NOCOPY      NUMBER,
275       p_ovn                          OUT NOCOPY      NUMBER
276    );
277 
278    FUNCTION validate_tax_ben_element (
279       p_element_name   IN   VARCHAR2,
280       p_leg_cd              VARCHAR2
281    )
282       RETURN BOOLEAN;
283 
284    PROCEDURE get_assignment_info (
285       p_bus_group_id         IN       per_all_assignments_f.business_group_id%TYPE
286             DEFAULT NULL,
287       p_id_type              IN       VARCHAR2,
288       p_id                   IN       VARCHAR2,
289       p_effective_date       IN       DATE,
290       p_assg_id              OUT NOCOPY      per_all_assignments_f.assignment_id%TYPE,
291       p_assg_nr              OUT NOCOPY      per_all_assignments_f.assignment_number%TYPE,
292       p_start_date           OUT NOCOPY      per_periods_of_service.date_start%TYPE,
293       p_final_process_date   OUT NOCOPY      per_periods_of_service.final_process_date%TYPE
294    );
295 
296    PROCEDURE get_element_info (
297       p_leg_cd            IN       VARCHAR2,
298       p_element_name      IN OUT NOCOPY   VARCHAR2,
299       p_element_type_id   IN OUT NOCOPY   NUMBER
300    );
301 
302    FUNCTION get_field (
303       p_line        IN OUT NOCOPY   VARCHAR2,
304       p_delimiter   IN       VARCHAR2,
305       p_start_pos   IN       NUMBER DEFAULT 1,
306       p_occurance   IN       NUMBER DEFAULT 1
307    )
308       RETURN VARCHAR2;
309 
310    FUNCTION correct_type_id (p_id_type VARCHAR2)
311       RETURN BOOLEAN;
312 END per_gb_tax_ben_pkg;