1 PACKAGE PY_SE_TAX_CARD AUTHID CURRENT_USER AS
2 /* $Header: pysetaxc.pkh 120.0.12000000.1 2007/04/24 06:36:29 rsahai noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_taxcard >----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API will insert a tax card entry for a Sweden Assignment.
11 -- This API delegates to the create_element_entry procedure of the
12 -- pay_element_entry_api package.
13 --
14 -- Prerequisites:
15 -- The element entry (of element type 'Tax Card') and the corresponding
16 -- element link should exist for the given assignment and business group.
17 --
18 -- In Parameters:
19 -- Name Reqd Type Description
20 -- p_legislation_code Yes VARCHAR2 Legislation code.
21 -- p_effective_date Yes DATE The effective date of the
22 -- change.
23 -- p_assignment_id Yes VARCHAR2 Id of the assignment.
24 -- p_person_id Yes VARCHAR2 Id of the person.
25 -- p_business_group_id Yes VARCHAR2 Id of the business group.
26 -- p_tax_percentage NUMBER Element entry value
27 -- p_tax_free_threshold NUMBER Element entry value
28 -- p_calculation_sum NUMBER Element entry value
29 -- p_method_of_receipt Yes VARCHAR2 Element entry value
30 -- p_tax_column VARCHAR2 Element entry value
31 -- p_tax_card_type yes VARCHAR2 Element entry value
32 -- p_tax_table_number VARCHAR2 Element entry value
33 -- p_calculation_code VARCHAR2 Element entry value.
34 -- p_element_entry_id VARCHAR2 Id of the element entry.
35 -- p_element_link_id VARCHAR2 Id of the element link.
36 --
37 --
38 -- Post Success:
39 --
40 -- The API successfully updates the tax card entry.
41 --
42 -- Post Failure:
43 -- The API will raise an error.
44 --
45 -- Access Status:
46 -- Private. For Internal Development Use only.
47 --
48 -- {End Of Comments}
49 --
50 PROCEDURE insert_taxcard (
51 p_legislation_code IN VARCHAR2
52 ,p_effective_date IN DATE
53 ,p_assignment_id IN VARCHAR2
54 ,p_person_id IN VARCHAR2
55 ,p_business_group_id IN VARCHAR2
56 ,p_tax_percentage IN NUMBER DEFAULT NULL
57 ,p_tax_free_threshold IN NUMBER DEFAULT NULL
58 ,p_calculation_sum IN NUMBER DEFAULT NULL
59 ,p_method_of_receipt IN VARCHAR2 DEFAULT NULL
60 ,p_tax_column IN VARCHAR2 DEFAULT NULL
61 ,p_tax_card_type IN VARCHAR2 DEFAULT NULL
62 ,p_tax_table_number IN VARCHAR2 DEFAULT NULL
63 ,p_calculation_code IN VARCHAR2 DEFAULT NULL);
64 --
65 -- ----------------------------------------------------------------------------
66 -- |--------------------------< update_taxcard >----------------------------|
67 -- ----------------------------------------------------------------------------
68 -- {Start Of Comments}
69 --
70 -- Description:
71 -- This API will update the tax card entry for a Sweden Assignment.
72 -- This API delegates to the update_element_entry procedure of the
73 -- pay_element_entry_api package.
74 --
75 -- Prerequisites:
76 -- The element entry (of element type 'Tax Card') and the corresponding
77 -- element link should exist for the given assignment and business group.
78 --
79 -- In Parameters:
80 -- Name Reqd Type Description
81 -- p_legislation_code Yes VARCHAR2 Legislation code.
82 -- p_effective_date Yes DATE The effective date of the
83 -- change.
84 -- p_assignment_id Yes VARCHAR2 Id of the assignment.
85 -- p_person_id Yes VARCHAR2 Id of the person.
86 -- p_business_group_id Yes VARCHAR2 Id of the business group.
87 -- p_tax_percentage NUMBER Element entry value
88 -- p_tax_free_threshold NUMBER Element entry value
89 -- p_calculation_sum NUMBER Element entry value
90 -- p_method_of_receipt Yes VARCHAR2 Element entry value
91 -- p_tax_column VARCHAR2 Element entry value
92 -- p_tax_card_type yes VARCHAR2 Element entry value
93 -- p_tax_table_number VARCHAR2 Element entry value
94 -- p_calculation_code VARCHAR2 Element entry value.
95 -- p_element_entry_id VARCHAR2 Id of the element entry.
96 -- p_element_link_id VARCHAR2 Id of the element link.
97 -- p_object_version_number Yes VARCHAR2 Version number of the element
98 -- entry record.
99 -- p_input_value_id1 VARCHAR2 Id of the input value 1 for the
100 -- element.
101 -- p_input_value_id2 VARCHAR2 Id of the input value 2 for the
102 -- element.
103 -- p_input_value_id3 VARCHAR2 Id of the input value 3 for the
104 -- element.
105 -- p_input_value_id4 VARCHAR2 Id of the input value 4 for the
106 -- element.
107 -- p_input_value_id5 VARCHAR2 Id of the input value 5 for the
108 -- element.
109 -- p_input_value_id6 VARCHAR2 Id of the input value 6 for the
110 -- element.
111 -- p_input_value_id7 VARCHAR2 Id of the input value 7 for the
112 -- element.
113 -- p_input_value_id8 VARCHAR2 Id of the input value 8 for the
114 -- element.
115 -- p_datetrack_update_mode VARCHAR2 The date track update mode for
116 -- the record
117 --
118 --
119 -- Post Success:
120 --
121 -- The API successfully updates the tax card entry.
122 --
123 -- Post Failure:
124 -- The API will raise an error.
125 --
126 -- Access Status:
127 -- Private. For Internal Development Use only.
128 --
129 -- {End Of Comments}
130 --
131 PROCEDURE update_taxcard (
132 p_legislation_code IN VARCHAR2
133 ,p_effective_date IN DATE
134 ,p_assignment_id IN VARCHAR2
135 ,p_person_id IN VARCHAR2
136 ,p_business_group_id IN VARCHAR2
137 ,p_tax_percentage IN NUMBER DEFAULT NULL
138 ,p_tax_free_threshold IN NUMBER DEFAULT NULL
139 ,p_calculation_sum IN NUMBER DEFAULT NULL
140 ,p_method_of_receipt IN VARCHAR2 DEFAULT NULL
141 ,p_tax_column IN VARCHAR2 DEFAULT NULL
142 ,p_tax_card_type IN VARCHAR2 DEFAULT NULL
143 ,p_tax_table_number IN VARCHAR2 DEFAULT NULL
144 ,p_calculation_code IN VARCHAR2 DEFAULT NULL
145 ,p_element_entry_id IN VARCHAR2
146 ,p_element_link_id IN VARCHAR2
147 ,p_object_version_number IN VARCHAR2
148 ,p_input_value_id1 IN VARCHAR2 DEFAULT NULL
149 ,p_input_value_id2 IN VARCHAR2 DEFAULT NULL
150 ,p_input_value_id3 IN VARCHAR2 DEFAULT NULL
151 ,p_input_value_id4 IN VARCHAR2 DEFAULT NULL
152 ,p_input_value_id5 IN VARCHAR2 DEFAULT NULL
153 ,p_input_value_id6 IN VARCHAR2 DEFAULT NULL
154 ,p_input_value_id7 IN VARCHAR2 DEFAULT NULL
155 ,p_input_value_id8 IN VARCHAR2 DEFAULT NULL
156 ,p_datetrack_update_mode IN VARCHAR2 DEFAULT NULL);
157 --
158 -- ----------------------------------------------------------------------------
159 -- |--------------------------< find_dt_upd_modes >----------------------------|
160 -- ----------------------------------------------------------------------------
161 -- {Start Of Comments}
162 --
163 -- Description:
164 -- This API returns the DT modes for pay_element_entries_f for a given
165 -- element_entry_id (base key value) on a specified date
166 --
167 -- Prerequisites:
168 -- The element_entry (p_base_key_value) must exist as of the effective date
169 -- of the change (p_effective_date).
170 --
171 -- In Parameters:
172 -- Name Reqd Type Description
173 -- p_effective_date Yes DATE The effective date of the
174 -- change.
175 -- p_base_key_value Yes NUMBER ID of the element entry.
176 --
177 --
178 -- Post Success:
179 --
180 -- The API sets the following out parameters:
181 --
182 -- Name Type Description
183 -- p_correction BOOLEAN True if correction mode is valid.
184 -- p_update BOOLEAN True if update mode is valid.
185 -- p_update_override BOOLEAN True if update override mode is valid.
186 -- p_update_change_insert BOOLEAN True if update change insert mode is
187 -- valid.
188 -- p_update_start_date DATE Start date for Update record.
189 -- p_update_end_date DATE End date for Update record.
190 -- p_override_start_date DATE Start date for Override.
191 -- p_override_end_date DATE End date for Overrride.
192 -- p_upd_chg_start_date DATE Start date for Update Change.
193 -- p_upd_chg_end_date DATE End date for Update Change.
194
195 -- Post Failure:
196 -- The API will raise an error.
197 --
198 -- Access Status:
199 -- Private. For Internal Development Use only.
200 --
201 -- {End Of Comments}
202 --
203 PROCEDURE find_dt_upd_modes(
204 p_effective_date IN DATE
205 ,p_base_key_value IN NUMBER
206 ,p_correction OUT NOCOPY BOOLEAN
207 ,p_update OUT NOCOPY BOOLEAN
208 ,p_update_override OUT NOCOPY BOOLEAN
209 ,p_update_change_insert OUT NOCOPY BOOLEAN
210 ,p_correction_start_date OUT NOCOPY DATE
211 ,p_correction_end_date OUT NOCOPY DATE
212 ,p_update_start_date OUT NOCOPY DATE
213 ,p_update_end_date OUT NOCOPY DATE
214 ,p_override_start_date OUT NOCOPY DATE
215 ,p_override_end_date OUT NOCOPY DATE
216 ,p_upd_chg_start_date OUT NOCOPY DATE
217 ,p_upd_chg_end_date OUT NOCOPY DATE);
218 --
219 -- -----------------------------------------------------------------------------
220 -- |--------------------------< get_global_value >-----------------------------|
221 -- -----------------------------------------------------------------------------
222 --
223 -- {Start of Comments}
224 --
225 -- Description:
226 -- Returns the value for the global on a given date.
227 --
228 -- Prerequisites:
229 -- None
230 --
231 -- In Parameters
232 -- Name Reqd Type Description
233 -- p_global_name Yes VARCHAR2 Assignment id
234 -- p_legislation_code Yes VARCHAR2 Legislation Code
235 -- p_effective_date Yes DATE Effective date
236 --
237 -- Post Success:
238 -- The value of the global of type FF_GLOBALS_F.GLOBAL_VALUE is returned
239 --
240 -- Post Failure:
241 -- An error is raised
242 --
243 -- Access Status:
244 -- Internal Development Use Only
245 --
246 -- {End of Comments}
247 --
248 FUNCTION get_global_value(
249 p_global_name VARCHAR2
250 ,p_legislation_code VARCHAR2
251 ,p_effective_date DATE) RETURN ff_globals_f.global_value%TYPE;
252
253
254 END py_se_tax_card;
255
[Home] [Help]