8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_configuration_value >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_configuration_value
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_legislation_code in varchar2 default null
16: ,p_pcv_attribute_category in varchar2 default null
84: --
85: -- Convert constant values to their corresponding boolean value
86: --
87: l_validate :=
88: hr_api.constant_to_boolean
89: (p_constant_value => p_validate);
90: --
91: -- Register Surrogate ID or user key values
92: --
199: -- ----------------------------------------------------------------------------
200: -- |----------------------< update_configuration_value >----------------------|
201: -- ----------------------------------------------------------------------------
202: PROCEDURE update_configuration_value
203: (p_validate in number default hr_api.g_false_num
204: ,p_effective_date in date
205: ,p_business_group_id in number
206: ,p_configuration_value_id in number
207: ,p_legislation_code in varchar2 default hr_api.g_varchar2
203: (p_validate in number default hr_api.g_false_num
204: ,p_effective_date in date
205: ,p_business_group_id in number
206: ,p_configuration_value_id in number
207: ,p_legislation_code in varchar2 default hr_api.g_varchar2
208: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
204: ,p_effective_date in date
205: ,p_business_group_id in number
206: ,p_configuration_value_id in number
207: ,p_legislation_code in varchar2 default hr_api.g_varchar2
208: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
205: ,p_business_group_id in number
206: ,p_configuration_value_id in number
207: ,p_legislation_code in varchar2 default hr_api.g_varchar2
208: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
206: ,p_configuration_value_id in number
207: ,p_legislation_code in varchar2 default hr_api.g_varchar2
208: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
207: ,p_legislation_code in varchar2 default hr_api.g_varchar2
208: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
208: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
209: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
210: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
211: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
212: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
213: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
214: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
215: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
216: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
217: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
218: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
219: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
220: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
221: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
222: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
223: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
224: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
225: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
226: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
227: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
228: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
229: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
230: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
231: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
232: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
233: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
234: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
235: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
236: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
237: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
238: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
239: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
247: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
240: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
247: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
248: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
241: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
247: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
248: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
249: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
242: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
247: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
248: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
249: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
250: ,p_configuration_name in varchar2 default hr_api.g_varchar2
243: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
247: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
248: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
249: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
250: ,p_configuration_name in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
244: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
247: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
248: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
249: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
250: ,p_configuration_name in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_return_status out nocopy varchar2
245: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
247: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
248: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
249: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
250: ,p_configuration_name in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_return_status out nocopy varchar2
253: ) is
246: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
247: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
248: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
249: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
250: ,p_configuration_name in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_return_status out nocopy varchar2
253: ) is
254: --
277: --
278: -- Convert constant values to their corresponding boolean value
279: --
280: l_validate :=
281: hr_api.constant_to_boolean
282: (p_constant_value => p_validate);
283: --
284: -- Register Surrogate ID or user key values
285: --
390: -- ----------------------------------------------------------------------------
391: -- |----------------------< delete_configuration_value >----------------------|
392: -- ----------------------------------------------------------------------------
393: PROCEDURE delete_configuration_value
394: (p_validate in number default hr_api.g_false_num
395: ,p_business_group_id in number
396: ,p_configuration_value_id in number
397: ,p_object_version_number in number
398: ,p_return_status out nocopy varchar2
421: --
422: -- Convert constant values to their corresponding boolean value
423: --
424: l_validate :=
425: hr_api.constant_to_boolean
426: (p_constant_value => p_validate);
427: --
428: -- Register Surrogate ID or user key values
429: --