8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_accrual_plan >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_accrual_plan
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_business_group_id in number
15: ,p_accrual_formula_id in number
16: ,p_co_formula_id in number
101: --
102: -- Convert constant values to their corresponding boolean value
103: --
104: l_validate :=
105: hr_api.constant_to_boolean
106: (p_constant_value => p_validate);
107: l_no_link_message :=
108: hr_api.constant_to_boolean
109: (p_constant_value => p_no_link_message);
104: l_validate :=
105: hr_api.constant_to_boolean
106: (p_constant_value => p_validate);
107: l_no_link_message :=
108: hr_api.constant_to_boolean
109: (p_constant_value => p_no_link_message);
110: l_check_accrual_ff :=
111: hr_api.constant_to_boolean
112: (p_constant_value => p_check_accrual_ff);
107: l_no_link_message :=
108: hr_api.constant_to_boolean
109: (p_constant_value => p_no_link_message);
110: l_check_accrual_ff :=
111: hr_api.constant_to_boolean
112: (p_constant_value => p_check_accrual_ff);
113: --
114: -- Register Surrogate ID or user key values
115: --
187: --
188: -- Convert API non-warning boolean parameter values
189: --
190: p_no_link_message :=
191: hr_api.boolean_to_constant
192: (p_boolean_value => l_no_link_message
193: );
194: p_check_accrual_ff :=
195: hr_api.boolean_to_constant
191: hr_api.boolean_to_constant
192: (p_boolean_value => l_no_link_message
193: );
194: p_check_accrual_ff :=
195: hr_api.boolean_to_constant
196: (p_boolean_value => l_check_accrual_ff
197: );
198: --
199: -- Derive the API return status value based on whether
270: -- ----------------------------------------------------------------------------
271: -- |--------------------------< update_accrual_plan >-------------------------|
272: -- ----------------------------------------------------------------------------
273: PROCEDURE update_accrual_plan
274: (p_validate in number default hr_api.g_false_num
275: ,p_effective_date in date
276: ,p_accrual_plan_id in number
277: ,p_pto_input_value_id in number default hr_api.g_number
278: ,p_accrual_category in varchar2 default hr_api.g_varchar2
273: PROCEDURE update_accrual_plan
274: (p_validate in number default hr_api.g_false_num
275: ,p_effective_date in date
276: ,p_accrual_plan_id in number
277: ,p_pto_input_value_id in number default hr_api.g_number
278: ,p_accrual_category in varchar2 default hr_api.g_varchar2
279: ,p_accrual_start in varchar2 default hr_api.g_varchar2
280: ,p_ineligible_period_length in number default hr_api.g_number
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
274: (p_validate in number default hr_api.g_false_num
275: ,p_effective_date in date
276: ,p_accrual_plan_id in number
277: ,p_pto_input_value_id in number default hr_api.g_number
278: ,p_accrual_category in varchar2 default hr_api.g_varchar2
279: ,p_accrual_start in varchar2 default hr_api.g_varchar2
280: ,p_ineligible_period_length in number default hr_api.g_number
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
275: ,p_effective_date in date
276: ,p_accrual_plan_id in number
277: ,p_pto_input_value_id in number default hr_api.g_number
278: ,p_accrual_category in varchar2 default hr_api.g_varchar2
279: ,p_accrual_start in varchar2 default hr_api.g_varchar2
280: ,p_ineligible_period_length in number default hr_api.g_number
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
283: ,p_co_formula_id in number default hr_api.g_number
276: ,p_accrual_plan_id in number
277: ,p_pto_input_value_id in number default hr_api.g_number
278: ,p_accrual_category in varchar2 default hr_api.g_varchar2
279: ,p_accrual_start in varchar2 default hr_api.g_varchar2
280: ,p_ineligible_period_length in number default hr_api.g_number
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
283: ,p_co_formula_id in number default hr_api.g_number
284: ,p_description in varchar2 default hr_api.g_varchar2
277: ,p_pto_input_value_id in number default hr_api.g_number
278: ,p_accrual_category in varchar2 default hr_api.g_varchar2
279: ,p_accrual_start in varchar2 default hr_api.g_varchar2
280: ,p_ineligible_period_length in number default hr_api.g_number
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
283: ,p_co_formula_id in number default hr_api.g_number
284: ,p_description in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
278: ,p_accrual_category in varchar2 default hr_api.g_varchar2
279: ,p_accrual_start in varchar2 default hr_api.g_varchar2
280: ,p_ineligible_period_length in number default hr_api.g_number
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
283: ,p_co_formula_id in number default hr_api.g_number
284: ,p_description in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
286: ,p_balance_dimension_id in number default hr_api.g_number
279: ,p_accrual_start in varchar2 default hr_api.g_varchar2
280: ,p_ineligible_period_length in number default hr_api.g_number
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
283: ,p_co_formula_id in number default hr_api.g_number
284: ,p_description in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
286: ,p_balance_dimension_id in number default hr_api.g_number
287: ,p_information_category in varchar2 default hr_api.g_varchar2
280: ,p_ineligible_period_length in number default hr_api.g_number
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
283: ,p_co_formula_id in number default hr_api.g_number
284: ,p_description in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
286: ,p_balance_dimension_id in number default hr_api.g_number
287: ,p_information_category in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
281: ,p_ineligible_period_type in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
283: ,p_co_formula_id in number default hr_api.g_number
284: ,p_description in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
286: ,p_balance_dimension_id in number default hr_api.g_number
287: ,p_information_category in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
282: ,p_accrual_formula_id in number default hr_api.g_number
283: ,p_co_formula_id in number default hr_api.g_number
284: ,p_description in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
286: ,p_balance_dimension_id in number default hr_api.g_number
287: ,p_information_category in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
283: ,p_co_formula_id in number default hr_api.g_number
284: ,p_description in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
286: ,p_balance_dimension_id in number default hr_api.g_number
287: ,p_information_category in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
284: ,p_description in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
286: ,p_balance_dimension_id in number default hr_api.g_number
287: ,p_information_category in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
285: ,p_ineligibility_formula_id in number default hr_api.g_number
286: ,p_balance_dimension_id in number default hr_api.g_number
287: ,p_information_category in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
286: ,p_balance_dimension_id in number default hr_api.g_number
287: ,p_information_category in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
287: ,p_information_category in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
288: ,p_information1 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
289: ,p_information2 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
290: ,p_information3 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
291: ,p_information4 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
292: ,p_information5 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
293: ,p_information6 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
294: ,p_information7 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
295: ,p_information8 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
296: ,p_information9 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
297: ,p_information10 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
298: ,p_information11 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
299: ,p_information12 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
300: ,p_information13 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
301: ,p_information14 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
302: ,p_information15 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
303: ,p_information16 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
311: ,p_information24 in varchar2 default hr_api.g_varchar2
304: ,p_information17 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
311: ,p_information24 in varchar2 default hr_api.g_varchar2
312: ,p_information25 in varchar2 default hr_api.g_varchar2
305: ,p_information18 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
311: ,p_information24 in varchar2 default hr_api.g_varchar2
312: ,p_information25 in varchar2 default hr_api.g_varchar2
313: ,p_information26 in varchar2 default hr_api.g_varchar2
306: ,p_information19 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
311: ,p_information24 in varchar2 default hr_api.g_varchar2
312: ,p_information25 in varchar2 default hr_api.g_varchar2
313: ,p_information26 in varchar2 default hr_api.g_varchar2
314: ,p_information27 in varchar2 default hr_api.g_varchar2
307: ,p_information20 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
311: ,p_information24 in varchar2 default hr_api.g_varchar2
312: ,p_information25 in varchar2 default hr_api.g_varchar2
313: ,p_information26 in varchar2 default hr_api.g_varchar2
314: ,p_information27 in varchar2 default hr_api.g_varchar2
315: ,p_information28 in varchar2 default hr_api.g_varchar2
308: ,p_information21 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
311: ,p_information24 in varchar2 default hr_api.g_varchar2
312: ,p_information25 in varchar2 default hr_api.g_varchar2
313: ,p_information26 in varchar2 default hr_api.g_varchar2
314: ,p_information27 in varchar2 default hr_api.g_varchar2
315: ,p_information28 in varchar2 default hr_api.g_varchar2
316: ,p_information29 in varchar2 default hr_api.g_varchar2
309: ,p_information22 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
311: ,p_information24 in varchar2 default hr_api.g_varchar2
312: ,p_information25 in varchar2 default hr_api.g_varchar2
313: ,p_information26 in varchar2 default hr_api.g_varchar2
314: ,p_information27 in varchar2 default hr_api.g_varchar2
315: ,p_information28 in varchar2 default hr_api.g_varchar2
316: ,p_information29 in varchar2 default hr_api.g_varchar2
317: ,p_information30 in varchar2 default hr_api.g_varchar2
310: ,p_information23 in varchar2 default hr_api.g_varchar2
311: ,p_information24 in varchar2 default hr_api.g_varchar2
312: ,p_information25 in varchar2 default hr_api.g_varchar2
313: ,p_information26 in varchar2 default hr_api.g_varchar2
314: ,p_information27 in varchar2 default hr_api.g_varchar2
315: ,p_information28 in varchar2 default hr_api.g_varchar2
316: ,p_information29 in varchar2 default hr_api.g_varchar2
317: ,p_information30 in varchar2 default hr_api.g_varchar2
318: ,p_object_version_number in out nocopy number
311: ,p_information24 in varchar2 default hr_api.g_varchar2
312: ,p_information25 in varchar2 default hr_api.g_varchar2
313: ,p_information26 in varchar2 default hr_api.g_varchar2
314: ,p_information27 in varchar2 default hr_api.g_varchar2
315: ,p_information28 in varchar2 default hr_api.g_varchar2
316: ,p_information29 in varchar2 default hr_api.g_varchar2
317: ,p_information30 in varchar2 default hr_api.g_varchar2
318: ,p_object_version_number in out nocopy number
319: ,p_payroll_formula_id out nocopy number
312: ,p_information25 in varchar2 default hr_api.g_varchar2
313: ,p_information26 in varchar2 default hr_api.g_varchar2
314: ,p_information27 in varchar2 default hr_api.g_varchar2
315: ,p_information28 in varchar2 default hr_api.g_varchar2
316: ,p_information29 in varchar2 default hr_api.g_varchar2
317: ,p_information30 in varchar2 default hr_api.g_varchar2
318: ,p_object_version_number in out nocopy number
319: ,p_payroll_formula_id out nocopy number
320: ,p_defined_balance_id out nocopy number
313: ,p_information26 in varchar2 default hr_api.g_varchar2
314: ,p_information27 in varchar2 default hr_api.g_varchar2
315: ,p_information28 in varchar2 default hr_api.g_varchar2
316: ,p_information29 in varchar2 default hr_api.g_varchar2
317: ,p_information30 in varchar2 default hr_api.g_varchar2
318: ,p_object_version_number in out nocopy number
319: ,p_payroll_formula_id out nocopy number
320: ,p_defined_balance_id out nocopy number
321: ,p_balance_element_type_id out nocopy number
351: --
352: -- Convert constant values to their corresponding boolean value
353: --
354: l_validate :=
355: hr_api.constant_to_boolean
356: (p_constant_value => p_validate);
357: l_check_accrual_ff :=
358: hr_api.constant_to_boolean
359: (p_constant_value => p_check_accrual_ff);
354: l_validate :=
355: hr_api.constant_to_boolean
356: (p_constant_value => p_validate);
357: l_check_accrual_ff :=
358: hr_api.constant_to_boolean
359: (p_constant_value => p_check_accrual_ff);
360: --
361: -- Register Surrogate ID or user key values
362: --
422: --
423: -- Convert API non-warning boolean parameter values
424: --
425: p_check_accrual_ff :=
426: hr_api.boolean_to_constant
427: (p_boolean_value => l_check_accrual_ff
428: );
429: --
430: -- Derive the API return status value based on whether
481: -- ----------------------------------------------------------------------------
482: -- |--------------------------< delete_accrual_plan >-------------------------|
483: -- ----------------------------------------------------------------------------
484: PROCEDURE delete_accrual_plan
485: (p_validate in number default hr_api.g_false_num
486: ,p_effective_date in date
487: ,p_accrual_plan_id in number
488: ,p_accrual_plan_element_type_id in number
489: ,p_co_element_type_id in number
519: --
520: -- Convert constant values to their corresponding boolean value
521: --
522: l_validate :=
523: hr_api.constant_to_boolean
524: (p_constant_value => p_validate);
525: --
526: -- Register Surrogate ID or user key values
527: --