1 Package pay_shadow_element_api as
2 /* $Header: pysetapi.pkh 120.0 2005/05/29 08:38:26 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< update_shadow_element >-----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API allows a shadow element to be modified before it has been used
11 -- to generate a row in PAY_ELEMENT_TYPES_F.
12 --
13 -- Prerequisites:
14 -- The shadow element must exist, and not have been used to generate an
15 -- element type in the core schema.
16 --
17 -- In Parameters:
18 -- Name Reqd Type Description
19 -- p_validate Yes boolean If true, the database is not
20 -- changed. If false then the
21 -- shadow element is updated.
22 -- p_effective_date Yes date Effective date (used for
23 -- business rule validation).
24 -- p_element_type_id Yes number Identifies the shadow element
25 -- to be updated.
26 -- p_classification_name No varchar2 Primary classification for
27 -- this element type.
28 -- p_additional_entry_allowed_fla No varchar2
29 -- p_adjustment_only_flag No varchar2
30 -- p_closed_for_entry_flag No varchar2
31 -- p_element_name No varchar2
32 -- p_indirect_only_flag No varchar2
33 -- p_multiple_entries_allowed_fla No varchar2
34 -- p_multiply_value_flag No varchar2
35 -- p_post_termination_rule No varchar2
36 -- p_process_in_run_flag No varchar2
37 -- p_relative_processing_priority No number Processing Priority relative
38 -- to Base Processing Priority
39 -- on PAY_ELEMENT_TEMPLATES row.
40 -- p_processing_type No varchar2
41 -- p_standard_link_flag No varchar2
42 -- p_input_currency_code No varchar2
43 -- p_output_currency_code No varchar2
44 -- p_benefit_classification_name No varchar2 Name of Benefit Classification
45 -- for this element type.
46 -- p_description No varchar2
47 -- p_qualifying_age No number
48 -- p_qualifying_length_of_service No number
49 -- p_qualifying_units No varchar2
50 -- p_reporting_name No varchar2
51 -- p_attribute_category No varchar2
52 -- p_attribute1 No varchar2
53 -- p_attribute2 No varchar2
54 -- p_attribute3 No varchar2
55 -- p_attribute4 No varchar2
56 -- p_attribute5 No varchar2
57 -- p_attribute6 No varchar2
58 -- p_attribute7 No varchar2
59 -- p_attribute8 No varchar2
60 -- p_attribute9 No varchar2
61 -- p_attribute10 No varchar2
62 -- p_attribute11 No varchar2
63 -- p_attribute12 No varchar2
64 -- p_attribute13 No varchar2
65 -- p_attribute14 No varchar2
66 -- p_attribute15 No varchar2
67 -- p_attribute16 No varchar2
68 -- p_attribute17 No varchar2
69 -- p_attribute18 No varchar2
70 -- p_attribute19 No varchar2
71 -- p_attribute20 No varchar2
72 -- p_element_information_category No varchar2
73 -- p_element_information1 No varchar2
74 -- p_element_information2 No varchar2
75 -- p_element_information3 No varchar2
76 -- p_element_information4 No varchar2
77 -- p_element_information5 No varchar2
78 -- p_element_information6 No varchar2
79 -- p_element_information7 No varchar2
80 -- p_element_information8 No varchar2
81 -- p_element_information9 No varchar2
82 -- p_element_information10 No varchar2
83 -- p_element_information11 No varchar2
84 -- p_element_information12 No varchar2
85 -- p_element_information13 No varchar2
86 -- p_element_information14 No varchar2
87 -- p_third_party_pay_only_flag No varchar2
88 -- p_skip_formula No varchar2 Name of Element Skip formula
89 -- for this element type.
90 -- p_payroll_formula_id No number Identifies the shadow payroll
91 -- formula (PAY_SHADOW_FORMULAS)
92 -- for the shadow element.
93 -- p_exclusion_rule_id No number Identifies the exclusion rule
94 -- (PAY_TEMPLATE_EXCLUSION_RULES)
95 -- for the shadow element.
96 -- p_iterative_flag No varchar2
97 -- p_iterative_priority No number
98 -- p_iterative_formula_name No varchar2
99 -- p_process_mode No varchar2
100 -- p_grossup_flag No varchar2
101 -- p_advance_payable No varchar2
102 -- p_advance_deduction No varchar2
103 -- p_process_advance_entry No varchar2
104 -- p_proration_group No varchar2 Name of Proration group for
105 -- this element type.
106 -- p_proration_formula No varchar2 Name of Proration formula
107 -- for this element type.
108 -- p_recalc_event_group No varchar2 Name of Recalculation event
109 -- group for this element type.
110 -- p_once_each_period_flag No varchar2
111 --
112 -- Post Success:
113 -- If p_validate is false, the shadow element is updated. Otherwise the
114 -- shadow element is unchanged.
115 --
116 -- Name Reqd Type Description
117 -- p_object_version_number Yes number If p_validate is false,
118 -- this is set to the updated
119 -- object version number for
120 -- the shadow element.
121 -- Not changed if p_validate is
122 -- true.
123 --
124 -- Post Failure:
125 -- Any work done is rolled back and an exception is raised.
126 --
127 -- Access Status:
128 -- Public.
129 --
130 -- {End Of Comments}
131 --
132 procedure update_shadow_element
133 (p_validate in boolean default false
134 ,p_effective_date in date
135 ,p_element_type_id in number
136 ,p_classification_name in varchar2 default hr_api.g_varchar2
137 ,p_additional_entry_allowed_fla in varchar2 default hr_api.g_varchar2
138 ,p_adjustment_only_flag in varchar2 default hr_api.g_varchar2
139 ,p_closed_for_entry_flag in varchar2 default hr_api.g_varchar2
140 ,p_element_name in varchar2 default hr_api.g_varchar2
141 ,p_indirect_only_flag in varchar2 default hr_api.g_varchar2
142 ,p_multiple_entries_allowed_fla in varchar2 default hr_api.g_varchar2
143 ,p_multiply_value_flag in varchar2 default hr_api.g_varchar2
144 ,p_post_termination_rule in varchar2 default hr_api.g_varchar2
145 ,p_process_in_run_flag in varchar2 default hr_api.g_varchar2
146 ,p_relative_processing_priority in number default hr_api.g_number
147 ,p_processing_type in varchar2 default hr_api.g_varchar2
148 ,p_standard_link_flag in varchar2 default hr_api.g_varchar2
149 ,p_input_currency_code in varchar2 default hr_api.g_varchar2
150 ,p_output_currency_code in varchar2 default hr_api.g_varchar2
151 ,p_benefit_classification_name in varchar2 default hr_api.g_varchar2
152 ,p_description in varchar2 default hr_api.g_varchar2
153 ,p_qualifying_age in number default hr_api.g_number
154 ,p_qualifying_length_of_service in number default hr_api.g_number
155 ,p_qualifying_units in varchar2 default hr_api.g_varchar2
156 ,p_reporting_name in varchar2 default hr_api.g_varchar2
157 ,p_attribute_category in varchar2 default hr_api.g_varchar2
158 ,p_attribute1 in varchar2 default hr_api.g_varchar2
159 ,p_attribute2 in varchar2 default hr_api.g_varchar2
160 ,p_attribute3 in varchar2 default hr_api.g_varchar2
161 ,p_attribute4 in varchar2 default hr_api.g_varchar2
162 ,p_attribute5 in varchar2 default hr_api.g_varchar2
163 ,p_attribute6 in varchar2 default hr_api.g_varchar2
164 ,p_attribute7 in varchar2 default hr_api.g_varchar2
165 ,p_attribute8 in varchar2 default hr_api.g_varchar2
166 ,p_attribute9 in varchar2 default hr_api.g_varchar2
167 ,p_attribute10 in varchar2 default hr_api.g_varchar2
168 ,p_attribute11 in varchar2 default hr_api.g_varchar2
169 ,p_attribute12 in varchar2 default hr_api.g_varchar2
170 ,p_attribute13 in varchar2 default hr_api.g_varchar2
171 ,p_attribute14 in varchar2 default hr_api.g_varchar2
172 ,p_attribute15 in varchar2 default hr_api.g_varchar2
173 ,p_attribute16 in varchar2 default hr_api.g_varchar2
174 ,p_attribute17 in varchar2 default hr_api.g_varchar2
175 ,p_attribute18 in varchar2 default hr_api.g_varchar2
176 ,p_attribute19 in varchar2 default hr_api.g_varchar2
177 ,p_attribute20 in varchar2 default hr_api.g_varchar2
178 ,p_element_information_category in varchar2 default hr_api.g_varchar2
179 ,p_element_information1 in varchar2 default hr_api.g_varchar2
180 ,p_element_information2 in varchar2 default hr_api.g_varchar2
181 ,p_element_information3 in varchar2 default hr_api.g_varchar2
182 ,p_element_information4 in varchar2 default hr_api.g_varchar2
183 ,p_element_information5 in varchar2 default hr_api.g_varchar2
184 ,p_element_information6 in varchar2 default hr_api.g_varchar2
185 ,p_element_information7 in varchar2 default hr_api.g_varchar2
186 ,p_element_information8 in varchar2 default hr_api.g_varchar2
187 ,p_element_information9 in varchar2 default hr_api.g_varchar2
188 ,p_element_information10 in varchar2 default hr_api.g_varchar2
189 ,p_element_information11 in varchar2 default hr_api.g_varchar2
190 ,p_element_information12 in varchar2 default hr_api.g_varchar2
191 ,p_element_information13 in varchar2 default hr_api.g_varchar2
192 ,p_element_information14 in varchar2 default hr_api.g_varchar2
193 ,p_element_information15 in varchar2 default hr_api.g_varchar2
194 ,p_element_information16 in varchar2 default hr_api.g_varchar2
195 ,p_element_information17 in varchar2 default hr_api.g_varchar2
196 ,p_element_information18 in varchar2 default hr_api.g_varchar2
197 ,p_element_information19 in varchar2 default hr_api.g_varchar2
198 ,p_element_information20 in varchar2 default hr_api.g_varchar2
199 ,p_third_party_pay_only_flag in varchar2 default hr_api.g_varchar2
200 ,p_skip_formula in varchar2 default hr_api.g_varchar2
201 ,p_payroll_formula_id in number default hr_api.g_number
202 ,p_exclusion_rule_id in number default hr_api.g_number
203 ,p_iterative_flag in varchar2 default hr_api.g_varchar2
204 ,p_iterative_priority in number default hr_api.g_number
205 ,p_iterative_formula_name in varchar2 default hr_api.g_varchar2
206 ,p_process_mode in varchar2 default hr_api.g_varchar2
207 ,p_grossup_flag in varchar2 default hr_api.g_varchar2
208 ,p_advance_indicator in varchar2 default hr_api.g_varchar2
209 ,p_advance_payable in varchar2 default hr_api.g_varchar2
210 ,p_advance_deduction in varchar2 default hr_api.g_varchar2
211 ,p_process_advance_entry in varchar2 default hr_api.g_varchar2
212 ,p_proration_group in varchar2 default hr_api.g_varchar2
213 ,p_proration_formula in varchar2 default hr_api.g_varchar2
214 ,p_recalc_event_group in varchar2 default hr_api.g_varchar2
215 ,p_once_each_period_flag in varchar2 default hr_api.g_varchar2
216 ,p_object_version_number in out nocopy number
217 );
218 --
219 end pay_shadow_element_api;