51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqp_pcv_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: --
129: pqp_pcv_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
134: pqp_pcv_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
139: pqp_pcv_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: --
143: Raise;
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure pre_update
179: (p_rec in pqp_pcv_shd.g_rec_type
180: ) is
181: --
182: l_proc varchar2(72) := g_package||'pre_update';
183: --
220: -- {End Of Comments}
221: -- ----------------------------------------------------------------------------
222: Procedure post_update
223: (p_effective_date in date
224: ,p_rec in pqp_pcv_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) := g_package||'post_update';
228: --
326: => p_rec.object_version_number
327: ,p_configuration_name
328: => p_rec.configuration_name
329: ,p_business_group_id_o
330: => pqp_pcv_shd.g_old_rec.business_group_id
331: ,p_legislation_code_o
332: => pqp_pcv_shd.g_old_rec.legislation_code
333: ,p_pcv_attribute_category_o
334: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
328: => p_rec.configuration_name
329: ,p_business_group_id_o
330: => pqp_pcv_shd.g_old_rec.business_group_id
331: ,p_legislation_code_o
332: => pqp_pcv_shd.g_old_rec.legislation_code
333: ,p_pcv_attribute_category_o
334: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
335: ,p_pcv_attribute1_o
336: => pqp_pcv_shd.g_old_rec.pcv_attribute1
330: => pqp_pcv_shd.g_old_rec.business_group_id
331: ,p_legislation_code_o
332: => pqp_pcv_shd.g_old_rec.legislation_code
333: ,p_pcv_attribute_category_o
334: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
335: ,p_pcv_attribute1_o
336: => pqp_pcv_shd.g_old_rec.pcv_attribute1
337: ,p_pcv_attribute2_o
338: => pqp_pcv_shd.g_old_rec.pcv_attribute2
332: => pqp_pcv_shd.g_old_rec.legislation_code
333: ,p_pcv_attribute_category_o
334: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
335: ,p_pcv_attribute1_o
336: => pqp_pcv_shd.g_old_rec.pcv_attribute1
337: ,p_pcv_attribute2_o
338: => pqp_pcv_shd.g_old_rec.pcv_attribute2
339: ,p_pcv_attribute3_o
340: => pqp_pcv_shd.g_old_rec.pcv_attribute3
334: => pqp_pcv_shd.g_old_rec.pcv_attribute_category
335: ,p_pcv_attribute1_o
336: => pqp_pcv_shd.g_old_rec.pcv_attribute1
337: ,p_pcv_attribute2_o
338: => pqp_pcv_shd.g_old_rec.pcv_attribute2
339: ,p_pcv_attribute3_o
340: => pqp_pcv_shd.g_old_rec.pcv_attribute3
341: ,p_pcv_attribute4_o
342: => pqp_pcv_shd.g_old_rec.pcv_attribute4
336: => pqp_pcv_shd.g_old_rec.pcv_attribute1
337: ,p_pcv_attribute2_o
338: => pqp_pcv_shd.g_old_rec.pcv_attribute2
339: ,p_pcv_attribute3_o
340: => pqp_pcv_shd.g_old_rec.pcv_attribute3
341: ,p_pcv_attribute4_o
342: => pqp_pcv_shd.g_old_rec.pcv_attribute4
343: ,p_pcv_attribute5_o
344: => pqp_pcv_shd.g_old_rec.pcv_attribute5
338: => pqp_pcv_shd.g_old_rec.pcv_attribute2
339: ,p_pcv_attribute3_o
340: => pqp_pcv_shd.g_old_rec.pcv_attribute3
341: ,p_pcv_attribute4_o
342: => pqp_pcv_shd.g_old_rec.pcv_attribute4
343: ,p_pcv_attribute5_o
344: => pqp_pcv_shd.g_old_rec.pcv_attribute5
345: ,p_pcv_attribute6_o
346: => pqp_pcv_shd.g_old_rec.pcv_attribute6
340: => pqp_pcv_shd.g_old_rec.pcv_attribute3
341: ,p_pcv_attribute4_o
342: => pqp_pcv_shd.g_old_rec.pcv_attribute4
343: ,p_pcv_attribute5_o
344: => pqp_pcv_shd.g_old_rec.pcv_attribute5
345: ,p_pcv_attribute6_o
346: => pqp_pcv_shd.g_old_rec.pcv_attribute6
347: ,p_pcv_attribute7_o
348: => pqp_pcv_shd.g_old_rec.pcv_attribute7
342: => pqp_pcv_shd.g_old_rec.pcv_attribute4
343: ,p_pcv_attribute5_o
344: => pqp_pcv_shd.g_old_rec.pcv_attribute5
345: ,p_pcv_attribute6_o
346: => pqp_pcv_shd.g_old_rec.pcv_attribute6
347: ,p_pcv_attribute7_o
348: => pqp_pcv_shd.g_old_rec.pcv_attribute7
349: ,p_pcv_attribute8_o
350: => pqp_pcv_shd.g_old_rec.pcv_attribute8
344: => pqp_pcv_shd.g_old_rec.pcv_attribute5
345: ,p_pcv_attribute6_o
346: => pqp_pcv_shd.g_old_rec.pcv_attribute6
347: ,p_pcv_attribute7_o
348: => pqp_pcv_shd.g_old_rec.pcv_attribute7
349: ,p_pcv_attribute8_o
350: => pqp_pcv_shd.g_old_rec.pcv_attribute8
351: ,p_pcv_attribute9_o
352: => pqp_pcv_shd.g_old_rec.pcv_attribute9
346: => pqp_pcv_shd.g_old_rec.pcv_attribute6
347: ,p_pcv_attribute7_o
348: => pqp_pcv_shd.g_old_rec.pcv_attribute7
349: ,p_pcv_attribute8_o
350: => pqp_pcv_shd.g_old_rec.pcv_attribute8
351: ,p_pcv_attribute9_o
352: => pqp_pcv_shd.g_old_rec.pcv_attribute9
353: ,p_pcv_attribute10_o
354: => pqp_pcv_shd.g_old_rec.pcv_attribute10
348: => pqp_pcv_shd.g_old_rec.pcv_attribute7
349: ,p_pcv_attribute8_o
350: => pqp_pcv_shd.g_old_rec.pcv_attribute8
351: ,p_pcv_attribute9_o
352: => pqp_pcv_shd.g_old_rec.pcv_attribute9
353: ,p_pcv_attribute10_o
354: => pqp_pcv_shd.g_old_rec.pcv_attribute10
355: ,p_pcv_attribute11_o
356: => pqp_pcv_shd.g_old_rec.pcv_attribute11
350: => pqp_pcv_shd.g_old_rec.pcv_attribute8
351: ,p_pcv_attribute9_o
352: => pqp_pcv_shd.g_old_rec.pcv_attribute9
353: ,p_pcv_attribute10_o
354: => pqp_pcv_shd.g_old_rec.pcv_attribute10
355: ,p_pcv_attribute11_o
356: => pqp_pcv_shd.g_old_rec.pcv_attribute11
357: ,p_pcv_attribute12_o
358: => pqp_pcv_shd.g_old_rec.pcv_attribute12
352: => pqp_pcv_shd.g_old_rec.pcv_attribute9
353: ,p_pcv_attribute10_o
354: => pqp_pcv_shd.g_old_rec.pcv_attribute10
355: ,p_pcv_attribute11_o
356: => pqp_pcv_shd.g_old_rec.pcv_attribute11
357: ,p_pcv_attribute12_o
358: => pqp_pcv_shd.g_old_rec.pcv_attribute12
359: ,p_pcv_attribute13_o
360: => pqp_pcv_shd.g_old_rec.pcv_attribute13
354: => pqp_pcv_shd.g_old_rec.pcv_attribute10
355: ,p_pcv_attribute11_o
356: => pqp_pcv_shd.g_old_rec.pcv_attribute11
357: ,p_pcv_attribute12_o
358: => pqp_pcv_shd.g_old_rec.pcv_attribute12
359: ,p_pcv_attribute13_o
360: => pqp_pcv_shd.g_old_rec.pcv_attribute13
361: ,p_pcv_attribute14_o
362: => pqp_pcv_shd.g_old_rec.pcv_attribute14
356: => pqp_pcv_shd.g_old_rec.pcv_attribute11
357: ,p_pcv_attribute12_o
358: => pqp_pcv_shd.g_old_rec.pcv_attribute12
359: ,p_pcv_attribute13_o
360: => pqp_pcv_shd.g_old_rec.pcv_attribute13
361: ,p_pcv_attribute14_o
362: => pqp_pcv_shd.g_old_rec.pcv_attribute14
363: ,p_pcv_attribute15_o
364: => pqp_pcv_shd.g_old_rec.pcv_attribute15
358: => pqp_pcv_shd.g_old_rec.pcv_attribute12
359: ,p_pcv_attribute13_o
360: => pqp_pcv_shd.g_old_rec.pcv_attribute13
361: ,p_pcv_attribute14_o
362: => pqp_pcv_shd.g_old_rec.pcv_attribute14
363: ,p_pcv_attribute15_o
364: => pqp_pcv_shd.g_old_rec.pcv_attribute15
365: ,p_pcv_attribute16_o
366: => pqp_pcv_shd.g_old_rec.pcv_attribute16
360: => pqp_pcv_shd.g_old_rec.pcv_attribute13
361: ,p_pcv_attribute14_o
362: => pqp_pcv_shd.g_old_rec.pcv_attribute14
363: ,p_pcv_attribute15_o
364: => pqp_pcv_shd.g_old_rec.pcv_attribute15
365: ,p_pcv_attribute16_o
366: => pqp_pcv_shd.g_old_rec.pcv_attribute16
367: ,p_pcv_attribute17_o
368: => pqp_pcv_shd.g_old_rec.pcv_attribute17
362: => pqp_pcv_shd.g_old_rec.pcv_attribute14
363: ,p_pcv_attribute15_o
364: => pqp_pcv_shd.g_old_rec.pcv_attribute15
365: ,p_pcv_attribute16_o
366: => pqp_pcv_shd.g_old_rec.pcv_attribute16
367: ,p_pcv_attribute17_o
368: => pqp_pcv_shd.g_old_rec.pcv_attribute17
369: ,p_pcv_attribute18_o
370: => pqp_pcv_shd.g_old_rec.pcv_attribute18
364: => pqp_pcv_shd.g_old_rec.pcv_attribute15
365: ,p_pcv_attribute16_o
366: => pqp_pcv_shd.g_old_rec.pcv_attribute16
367: ,p_pcv_attribute17_o
368: => pqp_pcv_shd.g_old_rec.pcv_attribute17
369: ,p_pcv_attribute18_o
370: => pqp_pcv_shd.g_old_rec.pcv_attribute18
371: ,p_pcv_attribute19_o
372: => pqp_pcv_shd.g_old_rec.pcv_attribute19
366: => pqp_pcv_shd.g_old_rec.pcv_attribute16
367: ,p_pcv_attribute17_o
368: => pqp_pcv_shd.g_old_rec.pcv_attribute17
369: ,p_pcv_attribute18_o
370: => pqp_pcv_shd.g_old_rec.pcv_attribute18
371: ,p_pcv_attribute19_o
372: => pqp_pcv_shd.g_old_rec.pcv_attribute19
373: ,p_pcv_attribute20_o
374: => pqp_pcv_shd.g_old_rec.pcv_attribute20
368: => pqp_pcv_shd.g_old_rec.pcv_attribute17
369: ,p_pcv_attribute18_o
370: => pqp_pcv_shd.g_old_rec.pcv_attribute18
371: ,p_pcv_attribute19_o
372: => pqp_pcv_shd.g_old_rec.pcv_attribute19
373: ,p_pcv_attribute20_o
374: => pqp_pcv_shd.g_old_rec.pcv_attribute20
375: ,p_pcv_information_category_o
376: => pqp_pcv_shd.g_old_rec.pcv_information_category
370: => pqp_pcv_shd.g_old_rec.pcv_attribute18
371: ,p_pcv_attribute19_o
372: => pqp_pcv_shd.g_old_rec.pcv_attribute19
373: ,p_pcv_attribute20_o
374: => pqp_pcv_shd.g_old_rec.pcv_attribute20
375: ,p_pcv_information_category_o
376: => pqp_pcv_shd.g_old_rec.pcv_information_category
377: ,p_pcv_information1_o
378: => pqp_pcv_shd.g_old_rec.pcv_information1
372: => pqp_pcv_shd.g_old_rec.pcv_attribute19
373: ,p_pcv_attribute20_o
374: => pqp_pcv_shd.g_old_rec.pcv_attribute20
375: ,p_pcv_information_category_o
376: => pqp_pcv_shd.g_old_rec.pcv_information_category
377: ,p_pcv_information1_o
378: => pqp_pcv_shd.g_old_rec.pcv_information1
379: ,p_pcv_information2_o
380: => pqp_pcv_shd.g_old_rec.pcv_information2
374: => pqp_pcv_shd.g_old_rec.pcv_attribute20
375: ,p_pcv_information_category_o
376: => pqp_pcv_shd.g_old_rec.pcv_information_category
377: ,p_pcv_information1_o
378: => pqp_pcv_shd.g_old_rec.pcv_information1
379: ,p_pcv_information2_o
380: => pqp_pcv_shd.g_old_rec.pcv_information2
381: ,p_pcv_information3_o
382: => pqp_pcv_shd.g_old_rec.pcv_information3
376: => pqp_pcv_shd.g_old_rec.pcv_information_category
377: ,p_pcv_information1_o
378: => pqp_pcv_shd.g_old_rec.pcv_information1
379: ,p_pcv_information2_o
380: => pqp_pcv_shd.g_old_rec.pcv_information2
381: ,p_pcv_information3_o
382: => pqp_pcv_shd.g_old_rec.pcv_information3
383: ,p_pcv_information4_o
384: => pqp_pcv_shd.g_old_rec.pcv_information4
378: => pqp_pcv_shd.g_old_rec.pcv_information1
379: ,p_pcv_information2_o
380: => pqp_pcv_shd.g_old_rec.pcv_information2
381: ,p_pcv_information3_o
382: => pqp_pcv_shd.g_old_rec.pcv_information3
383: ,p_pcv_information4_o
384: => pqp_pcv_shd.g_old_rec.pcv_information4
385: ,p_pcv_information5_o
386: => pqp_pcv_shd.g_old_rec.pcv_information5
380: => pqp_pcv_shd.g_old_rec.pcv_information2
381: ,p_pcv_information3_o
382: => pqp_pcv_shd.g_old_rec.pcv_information3
383: ,p_pcv_information4_o
384: => pqp_pcv_shd.g_old_rec.pcv_information4
385: ,p_pcv_information5_o
386: => pqp_pcv_shd.g_old_rec.pcv_information5
387: ,p_pcv_information6_o
388: => pqp_pcv_shd.g_old_rec.pcv_information6
382: => pqp_pcv_shd.g_old_rec.pcv_information3
383: ,p_pcv_information4_o
384: => pqp_pcv_shd.g_old_rec.pcv_information4
385: ,p_pcv_information5_o
386: => pqp_pcv_shd.g_old_rec.pcv_information5
387: ,p_pcv_information6_o
388: => pqp_pcv_shd.g_old_rec.pcv_information6
389: ,p_pcv_information7_o
390: => pqp_pcv_shd.g_old_rec.pcv_information7
384: => pqp_pcv_shd.g_old_rec.pcv_information4
385: ,p_pcv_information5_o
386: => pqp_pcv_shd.g_old_rec.pcv_information5
387: ,p_pcv_information6_o
388: => pqp_pcv_shd.g_old_rec.pcv_information6
389: ,p_pcv_information7_o
390: => pqp_pcv_shd.g_old_rec.pcv_information7
391: ,p_pcv_information8_o
392: => pqp_pcv_shd.g_old_rec.pcv_information8
386: => pqp_pcv_shd.g_old_rec.pcv_information5
387: ,p_pcv_information6_o
388: => pqp_pcv_shd.g_old_rec.pcv_information6
389: ,p_pcv_information7_o
390: => pqp_pcv_shd.g_old_rec.pcv_information7
391: ,p_pcv_information8_o
392: => pqp_pcv_shd.g_old_rec.pcv_information8
393: ,p_pcv_information9_o
394: => pqp_pcv_shd.g_old_rec.pcv_information9
388: => pqp_pcv_shd.g_old_rec.pcv_information6
389: ,p_pcv_information7_o
390: => pqp_pcv_shd.g_old_rec.pcv_information7
391: ,p_pcv_information8_o
392: => pqp_pcv_shd.g_old_rec.pcv_information8
393: ,p_pcv_information9_o
394: => pqp_pcv_shd.g_old_rec.pcv_information9
395: ,p_pcv_information10_o
396: => pqp_pcv_shd.g_old_rec.pcv_information10
390: => pqp_pcv_shd.g_old_rec.pcv_information7
391: ,p_pcv_information8_o
392: => pqp_pcv_shd.g_old_rec.pcv_information8
393: ,p_pcv_information9_o
394: => pqp_pcv_shd.g_old_rec.pcv_information9
395: ,p_pcv_information10_o
396: => pqp_pcv_shd.g_old_rec.pcv_information10
397: ,p_pcv_information11_o
398: => pqp_pcv_shd.g_old_rec.pcv_information11
392: => pqp_pcv_shd.g_old_rec.pcv_information8
393: ,p_pcv_information9_o
394: => pqp_pcv_shd.g_old_rec.pcv_information9
395: ,p_pcv_information10_o
396: => pqp_pcv_shd.g_old_rec.pcv_information10
397: ,p_pcv_information11_o
398: => pqp_pcv_shd.g_old_rec.pcv_information11
399: ,p_pcv_information12_o
400: => pqp_pcv_shd.g_old_rec.pcv_information12
394: => pqp_pcv_shd.g_old_rec.pcv_information9
395: ,p_pcv_information10_o
396: => pqp_pcv_shd.g_old_rec.pcv_information10
397: ,p_pcv_information11_o
398: => pqp_pcv_shd.g_old_rec.pcv_information11
399: ,p_pcv_information12_o
400: => pqp_pcv_shd.g_old_rec.pcv_information12
401: ,p_pcv_information13_o
402: => pqp_pcv_shd.g_old_rec.pcv_information13
396: => pqp_pcv_shd.g_old_rec.pcv_information10
397: ,p_pcv_information11_o
398: => pqp_pcv_shd.g_old_rec.pcv_information11
399: ,p_pcv_information12_o
400: => pqp_pcv_shd.g_old_rec.pcv_information12
401: ,p_pcv_information13_o
402: => pqp_pcv_shd.g_old_rec.pcv_information13
403: ,p_pcv_information14_o
404: => pqp_pcv_shd.g_old_rec.pcv_information14
398: => pqp_pcv_shd.g_old_rec.pcv_information11
399: ,p_pcv_information12_o
400: => pqp_pcv_shd.g_old_rec.pcv_information12
401: ,p_pcv_information13_o
402: => pqp_pcv_shd.g_old_rec.pcv_information13
403: ,p_pcv_information14_o
404: => pqp_pcv_shd.g_old_rec.pcv_information14
405: ,p_pcv_information15_o
406: => pqp_pcv_shd.g_old_rec.pcv_information15
400: => pqp_pcv_shd.g_old_rec.pcv_information12
401: ,p_pcv_information13_o
402: => pqp_pcv_shd.g_old_rec.pcv_information13
403: ,p_pcv_information14_o
404: => pqp_pcv_shd.g_old_rec.pcv_information14
405: ,p_pcv_information15_o
406: => pqp_pcv_shd.g_old_rec.pcv_information15
407: ,p_pcv_information16_o
408: => pqp_pcv_shd.g_old_rec.pcv_information16
402: => pqp_pcv_shd.g_old_rec.pcv_information13
403: ,p_pcv_information14_o
404: => pqp_pcv_shd.g_old_rec.pcv_information14
405: ,p_pcv_information15_o
406: => pqp_pcv_shd.g_old_rec.pcv_information15
407: ,p_pcv_information16_o
408: => pqp_pcv_shd.g_old_rec.pcv_information16
409: ,p_pcv_information17_o
410: => pqp_pcv_shd.g_old_rec.pcv_information17
404: => pqp_pcv_shd.g_old_rec.pcv_information14
405: ,p_pcv_information15_o
406: => pqp_pcv_shd.g_old_rec.pcv_information15
407: ,p_pcv_information16_o
408: => pqp_pcv_shd.g_old_rec.pcv_information16
409: ,p_pcv_information17_o
410: => pqp_pcv_shd.g_old_rec.pcv_information17
411: ,p_pcv_information18_o
412: => pqp_pcv_shd.g_old_rec.pcv_information18
406: => pqp_pcv_shd.g_old_rec.pcv_information15
407: ,p_pcv_information16_o
408: => pqp_pcv_shd.g_old_rec.pcv_information16
409: ,p_pcv_information17_o
410: => pqp_pcv_shd.g_old_rec.pcv_information17
411: ,p_pcv_information18_o
412: => pqp_pcv_shd.g_old_rec.pcv_information18
413: ,p_pcv_information19_o
414: => pqp_pcv_shd.g_old_rec.pcv_information19
408: => pqp_pcv_shd.g_old_rec.pcv_information16
409: ,p_pcv_information17_o
410: => pqp_pcv_shd.g_old_rec.pcv_information17
411: ,p_pcv_information18_o
412: => pqp_pcv_shd.g_old_rec.pcv_information18
413: ,p_pcv_information19_o
414: => pqp_pcv_shd.g_old_rec.pcv_information19
415: ,p_pcv_information20_o
416: => pqp_pcv_shd.g_old_rec.pcv_information20
410: => pqp_pcv_shd.g_old_rec.pcv_information17
411: ,p_pcv_information18_o
412: => pqp_pcv_shd.g_old_rec.pcv_information18
413: ,p_pcv_information19_o
414: => pqp_pcv_shd.g_old_rec.pcv_information19
415: ,p_pcv_information20_o
416: => pqp_pcv_shd.g_old_rec.pcv_information20
417: ,p_object_version_number_o
418: => pqp_pcv_shd.g_old_rec.object_version_number
412: => pqp_pcv_shd.g_old_rec.pcv_information18
413: ,p_pcv_information19_o
414: => pqp_pcv_shd.g_old_rec.pcv_information19
415: ,p_pcv_information20_o
416: => pqp_pcv_shd.g_old_rec.pcv_information20
417: ,p_object_version_number_o
418: => pqp_pcv_shd.g_old_rec.object_version_number
419: ,p_configuration_name_o
420: => pqp_pcv_shd.g_old_rec.configuration_name
414: => pqp_pcv_shd.g_old_rec.pcv_information19
415: ,p_pcv_information20_o
416: => pqp_pcv_shd.g_old_rec.pcv_information20
417: ,p_object_version_number_o
418: => pqp_pcv_shd.g_old_rec.object_version_number
419: ,p_configuration_name_o
420: => pqp_pcv_shd.g_old_rec.configuration_name
421: );
422: --
416: => pqp_pcv_shd.g_old_rec.pcv_information20
417: ,p_object_version_number_o
418: => pqp_pcv_shd.g_old_rec.object_version_number
419: ,p_configuration_name_o
420: => pqp_pcv_shd.g_old_rec.configuration_name
421: );
422: --
423: exception
424: --
476: --
477: -- {End Of Comments}
478: -- ----------------------------------------------------------------------------
479: Procedure convert_defs
480: (p_rec in out nocopy pqp_pcv_shd.g_rec_type
481: ) is
482: --
483: Begin
484: --
488: -- is being used then we must set to the 'current' argument value.
489: --
490: If (p_rec.business_group_id = hr_api.g_number) then
491: p_rec.business_group_id :=
492: pqp_pcv_shd.g_old_rec.business_group_id;
493: End If;
494: If (p_rec.legislation_code = hr_api.g_varchar2) then
495: p_rec.legislation_code :=
496: pqp_pcv_shd.g_old_rec.legislation_code;
492: pqp_pcv_shd.g_old_rec.business_group_id;
493: End If;
494: If (p_rec.legislation_code = hr_api.g_varchar2) then
495: p_rec.legislation_code :=
496: pqp_pcv_shd.g_old_rec.legislation_code;
497: End If;
498: If (p_rec.pcv_attribute_category = hr_api.g_varchar2) then
499: p_rec.pcv_attribute_category :=
500: pqp_pcv_shd.g_old_rec.pcv_attribute_category;
496: pqp_pcv_shd.g_old_rec.legislation_code;
497: End If;
498: If (p_rec.pcv_attribute_category = hr_api.g_varchar2) then
499: p_rec.pcv_attribute_category :=
500: pqp_pcv_shd.g_old_rec.pcv_attribute_category;
501: End If;
502: If (p_rec.pcv_attribute1 = hr_api.g_varchar2) then
503: p_rec.pcv_attribute1 :=
504: pqp_pcv_shd.g_old_rec.pcv_attribute1;
500: pqp_pcv_shd.g_old_rec.pcv_attribute_category;
501: End If;
502: If (p_rec.pcv_attribute1 = hr_api.g_varchar2) then
503: p_rec.pcv_attribute1 :=
504: pqp_pcv_shd.g_old_rec.pcv_attribute1;
505: End If;
506: If (p_rec.pcv_attribute2 = hr_api.g_varchar2) then
507: p_rec.pcv_attribute2 :=
508: pqp_pcv_shd.g_old_rec.pcv_attribute2;
504: pqp_pcv_shd.g_old_rec.pcv_attribute1;
505: End If;
506: If (p_rec.pcv_attribute2 = hr_api.g_varchar2) then
507: p_rec.pcv_attribute2 :=
508: pqp_pcv_shd.g_old_rec.pcv_attribute2;
509: End If;
510: If (p_rec.pcv_attribute3 = hr_api.g_varchar2) then
511: p_rec.pcv_attribute3 :=
512: pqp_pcv_shd.g_old_rec.pcv_attribute3;
508: pqp_pcv_shd.g_old_rec.pcv_attribute2;
509: End If;
510: If (p_rec.pcv_attribute3 = hr_api.g_varchar2) then
511: p_rec.pcv_attribute3 :=
512: pqp_pcv_shd.g_old_rec.pcv_attribute3;
513: End If;
514: If (p_rec.pcv_attribute4 = hr_api.g_varchar2) then
515: p_rec.pcv_attribute4 :=
516: pqp_pcv_shd.g_old_rec.pcv_attribute4;
512: pqp_pcv_shd.g_old_rec.pcv_attribute3;
513: End If;
514: If (p_rec.pcv_attribute4 = hr_api.g_varchar2) then
515: p_rec.pcv_attribute4 :=
516: pqp_pcv_shd.g_old_rec.pcv_attribute4;
517: End If;
518: If (p_rec.pcv_attribute5 = hr_api.g_varchar2) then
519: p_rec.pcv_attribute5 :=
520: pqp_pcv_shd.g_old_rec.pcv_attribute5;
516: pqp_pcv_shd.g_old_rec.pcv_attribute4;
517: End If;
518: If (p_rec.pcv_attribute5 = hr_api.g_varchar2) then
519: p_rec.pcv_attribute5 :=
520: pqp_pcv_shd.g_old_rec.pcv_attribute5;
521: End If;
522: If (p_rec.pcv_attribute6 = hr_api.g_varchar2) then
523: p_rec.pcv_attribute6 :=
524: pqp_pcv_shd.g_old_rec.pcv_attribute6;
520: pqp_pcv_shd.g_old_rec.pcv_attribute5;
521: End If;
522: If (p_rec.pcv_attribute6 = hr_api.g_varchar2) then
523: p_rec.pcv_attribute6 :=
524: pqp_pcv_shd.g_old_rec.pcv_attribute6;
525: End If;
526: If (p_rec.pcv_attribute7 = hr_api.g_varchar2) then
527: p_rec.pcv_attribute7 :=
528: pqp_pcv_shd.g_old_rec.pcv_attribute7;
524: pqp_pcv_shd.g_old_rec.pcv_attribute6;
525: End If;
526: If (p_rec.pcv_attribute7 = hr_api.g_varchar2) then
527: p_rec.pcv_attribute7 :=
528: pqp_pcv_shd.g_old_rec.pcv_attribute7;
529: End If;
530: If (p_rec.pcv_attribute8 = hr_api.g_varchar2) then
531: p_rec.pcv_attribute8 :=
532: pqp_pcv_shd.g_old_rec.pcv_attribute8;
528: pqp_pcv_shd.g_old_rec.pcv_attribute7;
529: End If;
530: If (p_rec.pcv_attribute8 = hr_api.g_varchar2) then
531: p_rec.pcv_attribute8 :=
532: pqp_pcv_shd.g_old_rec.pcv_attribute8;
533: End If;
534: If (p_rec.pcv_attribute9 = hr_api.g_varchar2) then
535: p_rec.pcv_attribute9 :=
536: pqp_pcv_shd.g_old_rec.pcv_attribute9;
532: pqp_pcv_shd.g_old_rec.pcv_attribute8;
533: End If;
534: If (p_rec.pcv_attribute9 = hr_api.g_varchar2) then
535: p_rec.pcv_attribute9 :=
536: pqp_pcv_shd.g_old_rec.pcv_attribute9;
537: End If;
538: If (p_rec.pcv_attribute10 = hr_api.g_varchar2) then
539: p_rec.pcv_attribute10 :=
540: pqp_pcv_shd.g_old_rec.pcv_attribute10;
536: pqp_pcv_shd.g_old_rec.pcv_attribute9;
537: End If;
538: If (p_rec.pcv_attribute10 = hr_api.g_varchar2) then
539: p_rec.pcv_attribute10 :=
540: pqp_pcv_shd.g_old_rec.pcv_attribute10;
541: End If;
542: If (p_rec.pcv_attribute11 = hr_api.g_varchar2) then
543: p_rec.pcv_attribute11 :=
544: pqp_pcv_shd.g_old_rec.pcv_attribute11;
540: pqp_pcv_shd.g_old_rec.pcv_attribute10;
541: End If;
542: If (p_rec.pcv_attribute11 = hr_api.g_varchar2) then
543: p_rec.pcv_attribute11 :=
544: pqp_pcv_shd.g_old_rec.pcv_attribute11;
545: End If;
546: If (p_rec.pcv_attribute12 = hr_api.g_varchar2) then
547: p_rec.pcv_attribute12 :=
548: pqp_pcv_shd.g_old_rec.pcv_attribute12;
544: pqp_pcv_shd.g_old_rec.pcv_attribute11;
545: End If;
546: If (p_rec.pcv_attribute12 = hr_api.g_varchar2) then
547: p_rec.pcv_attribute12 :=
548: pqp_pcv_shd.g_old_rec.pcv_attribute12;
549: End If;
550: If (p_rec.pcv_attribute13 = hr_api.g_varchar2) then
551: p_rec.pcv_attribute13 :=
552: pqp_pcv_shd.g_old_rec.pcv_attribute13;
548: pqp_pcv_shd.g_old_rec.pcv_attribute12;
549: End If;
550: If (p_rec.pcv_attribute13 = hr_api.g_varchar2) then
551: p_rec.pcv_attribute13 :=
552: pqp_pcv_shd.g_old_rec.pcv_attribute13;
553: End If;
554: If (p_rec.pcv_attribute14 = hr_api.g_varchar2) then
555: p_rec.pcv_attribute14 :=
556: pqp_pcv_shd.g_old_rec.pcv_attribute14;
552: pqp_pcv_shd.g_old_rec.pcv_attribute13;
553: End If;
554: If (p_rec.pcv_attribute14 = hr_api.g_varchar2) then
555: p_rec.pcv_attribute14 :=
556: pqp_pcv_shd.g_old_rec.pcv_attribute14;
557: End If;
558: If (p_rec.pcv_attribute15 = hr_api.g_varchar2) then
559: p_rec.pcv_attribute15 :=
560: pqp_pcv_shd.g_old_rec.pcv_attribute15;
556: pqp_pcv_shd.g_old_rec.pcv_attribute14;
557: End If;
558: If (p_rec.pcv_attribute15 = hr_api.g_varchar2) then
559: p_rec.pcv_attribute15 :=
560: pqp_pcv_shd.g_old_rec.pcv_attribute15;
561: End If;
562: If (p_rec.pcv_attribute16 = hr_api.g_varchar2) then
563: p_rec.pcv_attribute16 :=
564: pqp_pcv_shd.g_old_rec.pcv_attribute16;
560: pqp_pcv_shd.g_old_rec.pcv_attribute15;
561: End If;
562: If (p_rec.pcv_attribute16 = hr_api.g_varchar2) then
563: p_rec.pcv_attribute16 :=
564: pqp_pcv_shd.g_old_rec.pcv_attribute16;
565: End If;
566: If (p_rec.pcv_attribute17 = hr_api.g_varchar2) then
567: p_rec.pcv_attribute17 :=
568: pqp_pcv_shd.g_old_rec.pcv_attribute17;
564: pqp_pcv_shd.g_old_rec.pcv_attribute16;
565: End If;
566: If (p_rec.pcv_attribute17 = hr_api.g_varchar2) then
567: p_rec.pcv_attribute17 :=
568: pqp_pcv_shd.g_old_rec.pcv_attribute17;
569: End If;
570: If (p_rec.pcv_attribute18 = hr_api.g_varchar2) then
571: p_rec.pcv_attribute18 :=
572: pqp_pcv_shd.g_old_rec.pcv_attribute18;
568: pqp_pcv_shd.g_old_rec.pcv_attribute17;
569: End If;
570: If (p_rec.pcv_attribute18 = hr_api.g_varchar2) then
571: p_rec.pcv_attribute18 :=
572: pqp_pcv_shd.g_old_rec.pcv_attribute18;
573: End If;
574: If (p_rec.pcv_attribute19 = hr_api.g_varchar2) then
575: p_rec.pcv_attribute19 :=
576: pqp_pcv_shd.g_old_rec.pcv_attribute19;
572: pqp_pcv_shd.g_old_rec.pcv_attribute18;
573: End If;
574: If (p_rec.pcv_attribute19 = hr_api.g_varchar2) then
575: p_rec.pcv_attribute19 :=
576: pqp_pcv_shd.g_old_rec.pcv_attribute19;
577: End If;
578: If (p_rec.pcv_attribute20 = hr_api.g_varchar2) then
579: p_rec.pcv_attribute20 :=
580: pqp_pcv_shd.g_old_rec.pcv_attribute20;
576: pqp_pcv_shd.g_old_rec.pcv_attribute19;
577: End If;
578: If (p_rec.pcv_attribute20 = hr_api.g_varchar2) then
579: p_rec.pcv_attribute20 :=
580: pqp_pcv_shd.g_old_rec.pcv_attribute20;
581: End If;
582: If (p_rec.pcv_information_category = hr_api.g_varchar2) then
583: p_rec.pcv_information_category :=
584: pqp_pcv_shd.g_old_rec.pcv_information_category;
580: pqp_pcv_shd.g_old_rec.pcv_attribute20;
581: End If;
582: If (p_rec.pcv_information_category = hr_api.g_varchar2) then
583: p_rec.pcv_information_category :=
584: pqp_pcv_shd.g_old_rec.pcv_information_category;
585: End If;
586: If (p_rec.pcv_information1 = hr_api.g_varchar2) then
587: p_rec.pcv_information1 :=
588: pqp_pcv_shd.g_old_rec.pcv_information1;
584: pqp_pcv_shd.g_old_rec.pcv_information_category;
585: End If;
586: If (p_rec.pcv_information1 = hr_api.g_varchar2) then
587: p_rec.pcv_information1 :=
588: pqp_pcv_shd.g_old_rec.pcv_information1;
589: End If;
590: If (p_rec.pcv_information2 = hr_api.g_varchar2) then
591: p_rec.pcv_information2 :=
592: pqp_pcv_shd.g_old_rec.pcv_information2;
588: pqp_pcv_shd.g_old_rec.pcv_information1;
589: End If;
590: If (p_rec.pcv_information2 = hr_api.g_varchar2) then
591: p_rec.pcv_information2 :=
592: pqp_pcv_shd.g_old_rec.pcv_information2;
593: End If;
594: If (p_rec.pcv_information3 = hr_api.g_varchar2) then
595: p_rec.pcv_information3 :=
596: pqp_pcv_shd.g_old_rec.pcv_information3;
592: pqp_pcv_shd.g_old_rec.pcv_information2;
593: End If;
594: If (p_rec.pcv_information3 = hr_api.g_varchar2) then
595: p_rec.pcv_information3 :=
596: pqp_pcv_shd.g_old_rec.pcv_information3;
597: End If;
598: If (p_rec.pcv_information4 = hr_api.g_varchar2) then
599: p_rec.pcv_information4 :=
600: pqp_pcv_shd.g_old_rec.pcv_information4;
596: pqp_pcv_shd.g_old_rec.pcv_information3;
597: End If;
598: If (p_rec.pcv_information4 = hr_api.g_varchar2) then
599: p_rec.pcv_information4 :=
600: pqp_pcv_shd.g_old_rec.pcv_information4;
601: End If;
602: If (p_rec.pcv_information5 = hr_api.g_varchar2) then
603: p_rec.pcv_information5 :=
604: pqp_pcv_shd.g_old_rec.pcv_information5;
600: pqp_pcv_shd.g_old_rec.pcv_information4;
601: End If;
602: If (p_rec.pcv_information5 = hr_api.g_varchar2) then
603: p_rec.pcv_information5 :=
604: pqp_pcv_shd.g_old_rec.pcv_information5;
605: End If;
606: If (p_rec.pcv_information6 = hr_api.g_varchar2) then
607: p_rec.pcv_information6 :=
608: pqp_pcv_shd.g_old_rec.pcv_information6;
604: pqp_pcv_shd.g_old_rec.pcv_information5;
605: End If;
606: If (p_rec.pcv_information6 = hr_api.g_varchar2) then
607: p_rec.pcv_information6 :=
608: pqp_pcv_shd.g_old_rec.pcv_information6;
609: End If;
610: If (p_rec.pcv_information7 = hr_api.g_varchar2) then
611: p_rec.pcv_information7 :=
612: pqp_pcv_shd.g_old_rec.pcv_information7;
608: pqp_pcv_shd.g_old_rec.pcv_information6;
609: End If;
610: If (p_rec.pcv_information7 = hr_api.g_varchar2) then
611: p_rec.pcv_information7 :=
612: pqp_pcv_shd.g_old_rec.pcv_information7;
613: End If;
614: If (p_rec.pcv_information8 = hr_api.g_varchar2) then
615: p_rec.pcv_information8 :=
616: pqp_pcv_shd.g_old_rec.pcv_information8;
612: pqp_pcv_shd.g_old_rec.pcv_information7;
613: End If;
614: If (p_rec.pcv_information8 = hr_api.g_varchar2) then
615: p_rec.pcv_information8 :=
616: pqp_pcv_shd.g_old_rec.pcv_information8;
617: End If;
618: If (p_rec.pcv_information9 = hr_api.g_varchar2) then
619: p_rec.pcv_information9 :=
620: pqp_pcv_shd.g_old_rec.pcv_information9;
616: pqp_pcv_shd.g_old_rec.pcv_information8;
617: End If;
618: If (p_rec.pcv_information9 = hr_api.g_varchar2) then
619: p_rec.pcv_information9 :=
620: pqp_pcv_shd.g_old_rec.pcv_information9;
621: End If;
622: If (p_rec.pcv_information10 = hr_api.g_varchar2) then
623: p_rec.pcv_information10 :=
624: pqp_pcv_shd.g_old_rec.pcv_information10;
620: pqp_pcv_shd.g_old_rec.pcv_information9;
621: End If;
622: If (p_rec.pcv_information10 = hr_api.g_varchar2) then
623: p_rec.pcv_information10 :=
624: pqp_pcv_shd.g_old_rec.pcv_information10;
625: End If;
626: If (p_rec.pcv_information11 = hr_api.g_varchar2) then
627: p_rec.pcv_information11 :=
628: pqp_pcv_shd.g_old_rec.pcv_information11;
624: pqp_pcv_shd.g_old_rec.pcv_information10;
625: End If;
626: If (p_rec.pcv_information11 = hr_api.g_varchar2) then
627: p_rec.pcv_information11 :=
628: pqp_pcv_shd.g_old_rec.pcv_information11;
629: End If;
630: If (p_rec.pcv_information12 = hr_api.g_varchar2) then
631: p_rec.pcv_information12 :=
632: pqp_pcv_shd.g_old_rec.pcv_information12;
628: pqp_pcv_shd.g_old_rec.pcv_information11;
629: End If;
630: If (p_rec.pcv_information12 = hr_api.g_varchar2) then
631: p_rec.pcv_information12 :=
632: pqp_pcv_shd.g_old_rec.pcv_information12;
633: End If;
634: If (p_rec.pcv_information13 = hr_api.g_varchar2) then
635: p_rec.pcv_information13 :=
636: pqp_pcv_shd.g_old_rec.pcv_information13;
632: pqp_pcv_shd.g_old_rec.pcv_information12;
633: End If;
634: If (p_rec.pcv_information13 = hr_api.g_varchar2) then
635: p_rec.pcv_information13 :=
636: pqp_pcv_shd.g_old_rec.pcv_information13;
637: End If;
638: If (p_rec.pcv_information14 = hr_api.g_varchar2) then
639: p_rec.pcv_information14 :=
640: pqp_pcv_shd.g_old_rec.pcv_information14;
636: pqp_pcv_shd.g_old_rec.pcv_information13;
637: End If;
638: If (p_rec.pcv_information14 = hr_api.g_varchar2) then
639: p_rec.pcv_information14 :=
640: pqp_pcv_shd.g_old_rec.pcv_information14;
641: End If;
642: If (p_rec.pcv_information15 = hr_api.g_varchar2) then
643: p_rec.pcv_information15 :=
644: pqp_pcv_shd.g_old_rec.pcv_information15;
640: pqp_pcv_shd.g_old_rec.pcv_information14;
641: End If;
642: If (p_rec.pcv_information15 = hr_api.g_varchar2) then
643: p_rec.pcv_information15 :=
644: pqp_pcv_shd.g_old_rec.pcv_information15;
645: End If;
646: If (p_rec.pcv_information16 = hr_api.g_varchar2) then
647: p_rec.pcv_information16 :=
648: pqp_pcv_shd.g_old_rec.pcv_information16;
644: pqp_pcv_shd.g_old_rec.pcv_information15;
645: End If;
646: If (p_rec.pcv_information16 = hr_api.g_varchar2) then
647: p_rec.pcv_information16 :=
648: pqp_pcv_shd.g_old_rec.pcv_information16;
649: End If;
650: If (p_rec.pcv_information17 = hr_api.g_varchar2) then
651: p_rec.pcv_information17 :=
652: pqp_pcv_shd.g_old_rec.pcv_information17;
648: pqp_pcv_shd.g_old_rec.pcv_information16;
649: End If;
650: If (p_rec.pcv_information17 = hr_api.g_varchar2) then
651: p_rec.pcv_information17 :=
652: pqp_pcv_shd.g_old_rec.pcv_information17;
653: End If;
654: If (p_rec.pcv_information18 = hr_api.g_varchar2) then
655: p_rec.pcv_information18 :=
656: pqp_pcv_shd.g_old_rec.pcv_information18;
652: pqp_pcv_shd.g_old_rec.pcv_information17;
653: End If;
654: If (p_rec.pcv_information18 = hr_api.g_varchar2) then
655: p_rec.pcv_information18 :=
656: pqp_pcv_shd.g_old_rec.pcv_information18;
657: End If;
658: If (p_rec.pcv_information19 = hr_api.g_varchar2) then
659: p_rec.pcv_information19 :=
660: pqp_pcv_shd.g_old_rec.pcv_information19;
656: pqp_pcv_shd.g_old_rec.pcv_information18;
657: End If;
658: If (p_rec.pcv_information19 = hr_api.g_varchar2) then
659: p_rec.pcv_information19 :=
660: pqp_pcv_shd.g_old_rec.pcv_information19;
661: End If;
662: If (p_rec.pcv_information20 = hr_api.g_varchar2) then
663: p_rec.pcv_information20 :=
664: pqp_pcv_shd.g_old_rec.pcv_information20;
660: pqp_pcv_shd.g_old_rec.pcv_information19;
661: End If;
662: If (p_rec.pcv_information20 = hr_api.g_varchar2) then
663: p_rec.pcv_information20 :=
664: pqp_pcv_shd.g_old_rec.pcv_information20;
665: End If;
666: If (p_rec.configuration_name = hr_api.g_varchar2) then
667: p_rec.configuration_name :=
668: pqp_pcv_shd.g_old_rec.configuration_name;
664: pqp_pcv_shd.g_old_rec.pcv_information20;
665: End If;
666: If (p_rec.configuration_name = hr_api.g_varchar2) then
667: p_rec.configuration_name :=
668: pqp_pcv_shd.g_old_rec.configuration_name;
669: End If;
670: --
671: End convert_defs;
672: --
674: -- |---------------------------------< upd >----------------------------------|
675: -- ----------------------------------------------------------------------------
676: Procedure upd
677: (p_effective_date in date
678: ,p_rec in out nocopy pqp_pcv_shd.g_rec_type
679: ) is
680: --
681: l_proc varchar2(72) := g_package||'upd';
682: --
684: hr_utility.set_location('Entering:'||l_proc, 5);
685: --
686: -- We must lock the row which we need to update.
687: --
688: pqp_pcv_shd.lck
689: (p_rec.configuration_value_id
690: ,p_rec.object_version_number
691: );
692: --
777: ,p_pcv_information20 in varchar2
778: ,p_configuration_name in varchar2
779: ) is
780: --
781: l_rec pqp_pcv_shd.g_rec_type;
782: l_proc varchar2(72) := g_package||'upd';
783: --
784: Begin
785: hr_utility.set_location('Entering:'||l_proc, 5);
787: -- Call conversion function to turn arguments into the
788: -- l_rec structure.
789: --
790: l_rec :=
791: pqp_pcv_shd.convert_args
792: (p_configuration_value_id
793: ,p_business_group_id
794: ,p_legislation_code
795: ,p_pcv_attribute_category