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