[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_crd_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: --
131: pqh_crd_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --
136: pqh_crd_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --
141: pqh_crd_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When Others Then
144: --
145: Raise;
177: --
178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure pre_update
181: (p_rec in pqh_crd_shd.g_rec_type
182: ) is
183: --
184: l_proc varchar2(72) := g_package||'pre_update';
185: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure post_update
225: (p_effective_date in date
226: ,p_rec in pqh_crd_shd.g_rec_type
227: ) is
228: --
229: l_proc varchar2(72) := g_package||'post_update';
230: --
332: => p_rec.attribute30
333: ,p_object_version_number
334: => p_rec.object_version_number
335: ,p_short_name_o
336: => pqh_crd_shd.g_old_rec.short_name
337: ,p_uom_o
338: => pqh_crd_shd.g_old_rec.uom
339: ,p_currency_code_o
340: => pqh_crd_shd.g_old_rec.currency_code
334: => p_rec.object_version_number
335: ,p_short_name_o
336: => pqh_crd_shd.g_old_rec.short_name
337: ,p_uom_o
338: => pqh_crd_shd.g_old_rec.uom
339: ,p_currency_code_o
340: => pqh_crd_shd.g_old_rec.currency_code
341: ,p_reference_period_cd_o
342: => pqh_crd_shd.g_old_rec.reference_period_cd
336: => pqh_crd_shd.g_old_rec.short_name
337: ,p_uom_o
338: => pqh_crd_shd.g_old_rec.uom
339: ,p_currency_code_o
340: => pqh_crd_shd.g_old_rec.currency_code
341: ,p_reference_period_cd_o
342: => pqh_crd_shd.g_old_rec.reference_period_cd
343: ,p_define_max_rate_flag_o
344: => pqh_crd_shd.g_old_rec.define_max_rate_flag
338: => pqh_crd_shd.g_old_rec.uom
339: ,p_currency_code_o
340: => pqh_crd_shd.g_old_rec.currency_code
341: ,p_reference_period_cd_o
342: => pqh_crd_shd.g_old_rec.reference_period_cd
343: ,p_define_max_rate_flag_o
344: => pqh_crd_shd.g_old_rec.define_max_rate_flag
345: ,p_define_min_rate_flag_o
346: => pqh_crd_shd.g_old_rec.define_min_rate_flag
340: => pqh_crd_shd.g_old_rec.currency_code
341: ,p_reference_period_cd_o
342: => pqh_crd_shd.g_old_rec.reference_period_cd
343: ,p_define_max_rate_flag_o
344: => pqh_crd_shd.g_old_rec.define_max_rate_flag
345: ,p_define_min_rate_flag_o
346: => pqh_crd_shd.g_old_rec.define_min_rate_flag
347: ,p_define_mid_rate_flag_o
348: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
342: => pqh_crd_shd.g_old_rec.reference_period_cd
343: ,p_define_max_rate_flag_o
344: => pqh_crd_shd.g_old_rec.define_max_rate_flag
345: ,p_define_min_rate_flag_o
346: => pqh_crd_shd.g_old_rec.define_min_rate_flag
347: ,p_define_mid_rate_flag_o
348: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
349: ,p_define_std_rate_flag_o
350: => pqh_crd_shd.g_old_rec.define_std_rate_flag
344: => pqh_crd_shd.g_old_rec.define_max_rate_flag
345: ,p_define_min_rate_flag_o
346: => pqh_crd_shd.g_old_rec.define_min_rate_flag
347: ,p_define_mid_rate_flag_o
348: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
349: ,p_define_std_rate_flag_o
350: => pqh_crd_shd.g_old_rec.define_std_rate_flag
351: ,p_rate_calc_cd_o
352: => pqh_crd_shd.g_old_rec.rate_calc_cd
346: => pqh_crd_shd.g_old_rec.define_min_rate_flag
347: ,p_define_mid_rate_flag_o
348: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
349: ,p_define_std_rate_flag_o
350: => pqh_crd_shd.g_old_rec.define_std_rate_flag
351: ,p_rate_calc_cd_o
352: => pqh_crd_shd.g_old_rec.rate_calc_cd
353: ,p_rate_calc_rule_o
354: => pqh_crd_shd.g_old_rec.rate_calc_rule
348: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
349: ,p_define_std_rate_flag_o
350: => pqh_crd_shd.g_old_rec.define_std_rate_flag
351: ,p_rate_calc_cd_o
352: => pqh_crd_shd.g_old_rec.rate_calc_cd
353: ,p_rate_calc_rule_o
354: => pqh_crd_shd.g_old_rec.rate_calc_rule
355: ,p_preferential_rate_cd_o
356: => pqh_crd_shd.g_old_rec.preferential_rate_cd
350: => pqh_crd_shd.g_old_rec.define_std_rate_flag
351: ,p_rate_calc_cd_o
352: => pqh_crd_shd.g_old_rec.rate_calc_cd
353: ,p_rate_calc_rule_o
354: => pqh_crd_shd.g_old_rec.rate_calc_rule
355: ,p_preferential_rate_cd_o
356: => pqh_crd_shd.g_old_rec.preferential_rate_cd
357: ,p_preferential_rate_rule_o
358: => pqh_crd_shd.g_old_rec.preferential_rate_rule
352: => pqh_crd_shd.g_old_rec.rate_calc_cd
353: ,p_rate_calc_rule_o
354: => pqh_crd_shd.g_old_rec.rate_calc_rule
355: ,p_preferential_rate_cd_o
356: => pqh_crd_shd.g_old_rec.preferential_rate_cd
357: ,p_preferential_rate_rule_o
358: => pqh_crd_shd.g_old_rec.preferential_rate_rule
359: ,p_rounding_cd_o
360: => pqh_crd_shd.g_old_rec.rounding_cd
354: => pqh_crd_shd.g_old_rec.rate_calc_rule
355: ,p_preferential_rate_cd_o
356: => pqh_crd_shd.g_old_rec.preferential_rate_cd
357: ,p_preferential_rate_rule_o
358: => pqh_crd_shd.g_old_rec.preferential_rate_rule
359: ,p_rounding_cd_o
360: => pqh_crd_shd.g_old_rec.rounding_cd
361: ,p_rounding_rule_o
362: => pqh_crd_shd.g_old_rec.rounding_rule
356: => pqh_crd_shd.g_old_rec.preferential_rate_cd
357: ,p_preferential_rate_rule_o
358: => pqh_crd_shd.g_old_rec.preferential_rate_rule
359: ,p_rounding_cd_o
360: => pqh_crd_shd.g_old_rec.rounding_cd
361: ,p_rounding_rule_o
362: => pqh_crd_shd.g_old_rec.rounding_rule
363: ,p_business_group_id_o
364: => pqh_crd_shd.g_old_rec.business_group_id
358: => pqh_crd_shd.g_old_rec.preferential_rate_rule
359: ,p_rounding_cd_o
360: => pqh_crd_shd.g_old_rec.rounding_cd
361: ,p_rounding_rule_o
362: => pqh_crd_shd.g_old_rec.rounding_rule
363: ,p_business_group_id_o
364: => pqh_crd_shd.g_old_rec.business_group_id
365: ,p_legislation_code_o
366: => pqh_crd_shd.g_old_rec.legislation_code
360: => pqh_crd_shd.g_old_rec.rounding_cd
361: ,p_rounding_rule_o
362: => pqh_crd_shd.g_old_rec.rounding_rule
363: ,p_business_group_id_o
364: => pqh_crd_shd.g_old_rec.business_group_id
365: ,p_legislation_code_o
366: => pqh_crd_shd.g_old_rec.legislation_code
367: ,p_attribute_category_o
368: => pqh_crd_shd.g_old_rec.attribute_category
362: => pqh_crd_shd.g_old_rec.rounding_rule
363: ,p_business_group_id_o
364: => pqh_crd_shd.g_old_rec.business_group_id
365: ,p_legislation_code_o
366: => pqh_crd_shd.g_old_rec.legislation_code
367: ,p_attribute_category_o
368: => pqh_crd_shd.g_old_rec.attribute_category
369: ,p_attribute1_o
370: => pqh_crd_shd.g_old_rec.attribute1
364: => pqh_crd_shd.g_old_rec.business_group_id
365: ,p_legislation_code_o
366: => pqh_crd_shd.g_old_rec.legislation_code
367: ,p_attribute_category_o
368: => pqh_crd_shd.g_old_rec.attribute_category
369: ,p_attribute1_o
370: => pqh_crd_shd.g_old_rec.attribute1
371: ,p_attribute2_o
372: => pqh_crd_shd.g_old_rec.attribute2
366: => pqh_crd_shd.g_old_rec.legislation_code
367: ,p_attribute_category_o
368: => pqh_crd_shd.g_old_rec.attribute_category
369: ,p_attribute1_o
370: => pqh_crd_shd.g_old_rec.attribute1
371: ,p_attribute2_o
372: => pqh_crd_shd.g_old_rec.attribute2
373: ,p_attribute3_o
374: => pqh_crd_shd.g_old_rec.attribute3
368: => pqh_crd_shd.g_old_rec.attribute_category
369: ,p_attribute1_o
370: => pqh_crd_shd.g_old_rec.attribute1
371: ,p_attribute2_o
372: => pqh_crd_shd.g_old_rec.attribute2
373: ,p_attribute3_o
374: => pqh_crd_shd.g_old_rec.attribute3
375: ,p_attribute4_o
376: => pqh_crd_shd.g_old_rec.attribute4
370: => pqh_crd_shd.g_old_rec.attribute1
371: ,p_attribute2_o
372: => pqh_crd_shd.g_old_rec.attribute2
373: ,p_attribute3_o
374: => pqh_crd_shd.g_old_rec.attribute3
375: ,p_attribute4_o
376: => pqh_crd_shd.g_old_rec.attribute4
377: ,p_attribute5_o
378: => pqh_crd_shd.g_old_rec.attribute5
372: => pqh_crd_shd.g_old_rec.attribute2
373: ,p_attribute3_o
374: => pqh_crd_shd.g_old_rec.attribute3
375: ,p_attribute4_o
376: => pqh_crd_shd.g_old_rec.attribute4
377: ,p_attribute5_o
378: => pqh_crd_shd.g_old_rec.attribute5
379: ,p_attribute6_o
380: => pqh_crd_shd.g_old_rec.attribute6
374: => pqh_crd_shd.g_old_rec.attribute3
375: ,p_attribute4_o
376: => pqh_crd_shd.g_old_rec.attribute4
377: ,p_attribute5_o
378: => pqh_crd_shd.g_old_rec.attribute5
379: ,p_attribute6_o
380: => pqh_crd_shd.g_old_rec.attribute6
381: ,p_attribute7_o
382: => pqh_crd_shd.g_old_rec.attribute7
376: => pqh_crd_shd.g_old_rec.attribute4
377: ,p_attribute5_o
378: => pqh_crd_shd.g_old_rec.attribute5
379: ,p_attribute6_o
380: => pqh_crd_shd.g_old_rec.attribute6
381: ,p_attribute7_o
382: => pqh_crd_shd.g_old_rec.attribute7
383: ,p_attribute8_o
384: => pqh_crd_shd.g_old_rec.attribute8
378: => pqh_crd_shd.g_old_rec.attribute5
379: ,p_attribute6_o
380: => pqh_crd_shd.g_old_rec.attribute6
381: ,p_attribute7_o
382: => pqh_crd_shd.g_old_rec.attribute7
383: ,p_attribute8_o
384: => pqh_crd_shd.g_old_rec.attribute8
385: ,p_attribute9_o
386: => pqh_crd_shd.g_old_rec.attribute9
380: => pqh_crd_shd.g_old_rec.attribute6
381: ,p_attribute7_o
382: => pqh_crd_shd.g_old_rec.attribute7
383: ,p_attribute8_o
384: => pqh_crd_shd.g_old_rec.attribute8
385: ,p_attribute9_o
386: => pqh_crd_shd.g_old_rec.attribute9
387: ,p_attribute10_o
388: => pqh_crd_shd.g_old_rec.attribute10
382: => pqh_crd_shd.g_old_rec.attribute7
383: ,p_attribute8_o
384: => pqh_crd_shd.g_old_rec.attribute8
385: ,p_attribute9_o
386: => pqh_crd_shd.g_old_rec.attribute9
387: ,p_attribute10_o
388: => pqh_crd_shd.g_old_rec.attribute10
389: ,p_attribute11_o
390: => pqh_crd_shd.g_old_rec.attribute11
384: => pqh_crd_shd.g_old_rec.attribute8
385: ,p_attribute9_o
386: => pqh_crd_shd.g_old_rec.attribute9
387: ,p_attribute10_o
388: => pqh_crd_shd.g_old_rec.attribute10
389: ,p_attribute11_o
390: => pqh_crd_shd.g_old_rec.attribute11
391: ,p_attribute12_o
392: => pqh_crd_shd.g_old_rec.attribute12
386: => pqh_crd_shd.g_old_rec.attribute9
387: ,p_attribute10_o
388: => pqh_crd_shd.g_old_rec.attribute10
389: ,p_attribute11_o
390: => pqh_crd_shd.g_old_rec.attribute11
391: ,p_attribute12_o
392: => pqh_crd_shd.g_old_rec.attribute12
393: ,p_attribute13_o
394: => pqh_crd_shd.g_old_rec.attribute13
388: => pqh_crd_shd.g_old_rec.attribute10
389: ,p_attribute11_o
390: => pqh_crd_shd.g_old_rec.attribute11
391: ,p_attribute12_o
392: => pqh_crd_shd.g_old_rec.attribute12
393: ,p_attribute13_o
394: => pqh_crd_shd.g_old_rec.attribute13
395: ,p_attribute14_o
396: => pqh_crd_shd.g_old_rec.attribute14
390: => pqh_crd_shd.g_old_rec.attribute11
391: ,p_attribute12_o
392: => pqh_crd_shd.g_old_rec.attribute12
393: ,p_attribute13_o
394: => pqh_crd_shd.g_old_rec.attribute13
395: ,p_attribute14_o
396: => pqh_crd_shd.g_old_rec.attribute14
397: ,p_attribute15_o
398: => pqh_crd_shd.g_old_rec.attribute15
392: => pqh_crd_shd.g_old_rec.attribute12
393: ,p_attribute13_o
394: => pqh_crd_shd.g_old_rec.attribute13
395: ,p_attribute14_o
396: => pqh_crd_shd.g_old_rec.attribute14
397: ,p_attribute15_o
398: => pqh_crd_shd.g_old_rec.attribute15
399: ,p_attribute16_o
400: => pqh_crd_shd.g_old_rec.attribute16
394: => pqh_crd_shd.g_old_rec.attribute13
395: ,p_attribute14_o
396: => pqh_crd_shd.g_old_rec.attribute14
397: ,p_attribute15_o
398: => pqh_crd_shd.g_old_rec.attribute15
399: ,p_attribute16_o
400: => pqh_crd_shd.g_old_rec.attribute16
401: ,p_attribute17_o
402: => pqh_crd_shd.g_old_rec.attribute17
396: => pqh_crd_shd.g_old_rec.attribute14
397: ,p_attribute15_o
398: => pqh_crd_shd.g_old_rec.attribute15
399: ,p_attribute16_o
400: => pqh_crd_shd.g_old_rec.attribute16
401: ,p_attribute17_o
402: => pqh_crd_shd.g_old_rec.attribute17
403: ,p_attribute18_o
404: => pqh_crd_shd.g_old_rec.attribute18
398: => pqh_crd_shd.g_old_rec.attribute15
399: ,p_attribute16_o
400: => pqh_crd_shd.g_old_rec.attribute16
401: ,p_attribute17_o
402: => pqh_crd_shd.g_old_rec.attribute17
403: ,p_attribute18_o
404: => pqh_crd_shd.g_old_rec.attribute18
405: ,p_attribute19_o
406: => pqh_crd_shd.g_old_rec.attribute19
400: => pqh_crd_shd.g_old_rec.attribute16
401: ,p_attribute17_o
402: => pqh_crd_shd.g_old_rec.attribute17
403: ,p_attribute18_o
404: => pqh_crd_shd.g_old_rec.attribute18
405: ,p_attribute19_o
406: => pqh_crd_shd.g_old_rec.attribute19
407: ,p_attribute20_o
408: => pqh_crd_shd.g_old_rec.attribute20
402: => pqh_crd_shd.g_old_rec.attribute17
403: ,p_attribute18_o
404: => pqh_crd_shd.g_old_rec.attribute18
405: ,p_attribute19_o
406: => pqh_crd_shd.g_old_rec.attribute19
407: ,p_attribute20_o
408: => pqh_crd_shd.g_old_rec.attribute20
409: ,p_attribute21_o
410: => pqh_crd_shd.g_old_rec.attribute21
404: => pqh_crd_shd.g_old_rec.attribute18
405: ,p_attribute19_o
406: => pqh_crd_shd.g_old_rec.attribute19
407: ,p_attribute20_o
408: => pqh_crd_shd.g_old_rec.attribute20
409: ,p_attribute21_o
410: => pqh_crd_shd.g_old_rec.attribute21
411: ,p_attribute22_o
412: => pqh_crd_shd.g_old_rec.attribute22
406: => pqh_crd_shd.g_old_rec.attribute19
407: ,p_attribute20_o
408: => pqh_crd_shd.g_old_rec.attribute20
409: ,p_attribute21_o
410: => pqh_crd_shd.g_old_rec.attribute21
411: ,p_attribute22_o
412: => pqh_crd_shd.g_old_rec.attribute22
413: ,p_attribute23_o
414: => pqh_crd_shd.g_old_rec.attribute23
408: => pqh_crd_shd.g_old_rec.attribute20
409: ,p_attribute21_o
410: => pqh_crd_shd.g_old_rec.attribute21
411: ,p_attribute22_o
412: => pqh_crd_shd.g_old_rec.attribute22
413: ,p_attribute23_o
414: => pqh_crd_shd.g_old_rec.attribute23
415: ,p_attribute24_o
416: => pqh_crd_shd.g_old_rec.attribute24
410: => pqh_crd_shd.g_old_rec.attribute21
411: ,p_attribute22_o
412: => pqh_crd_shd.g_old_rec.attribute22
413: ,p_attribute23_o
414: => pqh_crd_shd.g_old_rec.attribute23
415: ,p_attribute24_o
416: => pqh_crd_shd.g_old_rec.attribute24
417: ,p_attribute25_o
418: => pqh_crd_shd.g_old_rec.attribute25
412: => pqh_crd_shd.g_old_rec.attribute22
413: ,p_attribute23_o
414: => pqh_crd_shd.g_old_rec.attribute23
415: ,p_attribute24_o
416: => pqh_crd_shd.g_old_rec.attribute24
417: ,p_attribute25_o
418: => pqh_crd_shd.g_old_rec.attribute25
419: ,p_attribute26_o
420: => pqh_crd_shd.g_old_rec.attribute26
414: => pqh_crd_shd.g_old_rec.attribute23
415: ,p_attribute24_o
416: => pqh_crd_shd.g_old_rec.attribute24
417: ,p_attribute25_o
418: => pqh_crd_shd.g_old_rec.attribute25
419: ,p_attribute26_o
420: => pqh_crd_shd.g_old_rec.attribute26
421: ,p_attribute27_o
422: => pqh_crd_shd.g_old_rec.attribute27
416: => pqh_crd_shd.g_old_rec.attribute24
417: ,p_attribute25_o
418: => pqh_crd_shd.g_old_rec.attribute25
419: ,p_attribute26_o
420: => pqh_crd_shd.g_old_rec.attribute26
421: ,p_attribute27_o
422: => pqh_crd_shd.g_old_rec.attribute27
423: ,p_attribute28_o
424: => pqh_crd_shd.g_old_rec.attribute28
418: => pqh_crd_shd.g_old_rec.attribute25
419: ,p_attribute26_o
420: => pqh_crd_shd.g_old_rec.attribute26
421: ,p_attribute27_o
422: => pqh_crd_shd.g_old_rec.attribute27
423: ,p_attribute28_o
424: => pqh_crd_shd.g_old_rec.attribute28
425: ,p_attribute29_o
426: => pqh_crd_shd.g_old_rec.attribute29
420: => pqh_crd_shd.g_old_rec.attribute26
421: ,p_attribute27_o
422: => pqh_crd_shd.g_old_rec.attribute27
423: ,p_attribute28_o
424: => pqh_crd_shd.g_old_rec.attribute28
425: ,p_attribute29_o
426: => pqh_crd_shd.g_old_rec.attribute29
427: ,p_attribute30_o
428: => pqh_crd_shd.g_old_rec.attribute30
422: => pqh_crd_shd.g_old_rec.attribute27
423: ,p_attribute28_o
424: => pqh_crd_shd.g_old_rec.attribute28
425: ,p_attribute29_o
426: => pqh_crd_shd.g_old_rec.attribute29
427: ,p_attribute30_o
428: => pqh_crd_shd.g_old_rec.attribute30
429: ,p_object_version_number_o
430: => pqh_crd_shd.g_old_rec.object_version_number
424: => pqh_crd_shd.g_old_rec.attribute28
425: ,p_attribute29_o
426: => pqh_crd_shd.g_old_rec.attribute29
427: ,p_attribute30_o
428: => pqh_crd_shd.g_old_rec.attribute30
429: ,p_object_version_number_o
430: => pqh_crd_shd.g_old_rec.object_version_number
431: );
432: --
426: => pqh_crd_shd.g_old_rec.attribute29
427: ,p_attribute30_o
428: => pqh_crd_shd.g_old_rec.attribute30
429: ,p_object_version_number_o
430: => pqh_crd_shd.g_old_rec.object_version_number
431: );
432: --
433: exception
434: --
486: --
487: -- {End Of Comments}
488: -- ----------------------------------------------------------------------------
489: Procedure convert_defs
490: (p_rec in out nocopy pqh_crd_shd.g_rec_type
491: ) is
492: --
493: Begin
494: --
498: -- is being used then we must set to the 'current' argument value.
499: --
500: If (p_rec.short_name = hr_api.g_varchar2) then
501: p_rec.short_name :=
502: pqh_crd_shd.g_old_rec.short_name;
503: End If;
504: If (p_rec.uom = hr_api.g_varchar2) then
505: p_rec.uom :=
506: pqh_crd_shd.g_old_rec.uom;
502: pqh_crd_shd.g_old_rec.short_name;
503: End If;
504: If (p_rec.uom = hr_api.g_varchar2) then
505: p_rec.uom :=
506: pqh_crd_shd.g_old_rec.uom;
507: End If;
508: If (p_rec.currency_code = hr_api.g_varchar2) then
509: p_rec.currency_code :=
510: pqh_crd_shd.g_old_rec.currency_code;
506: pqh_crd_shd.g_old_rec.uom;
507: End If;
508: If (p_rec.currency_code = hr_api.g_varchar2) then
509: p_rec.currency_code :=
510: pqh_crd_shd.g_old_rec.currency_code;
511: End If;
512: If (p_rec.reference_period_cd = hr_api.g_varchar2) then
513: p_rec.reference_period_cd :=
514: pqh_crd_shd.g_old_rec.reference_period_cd;
510: pqh_crd_shd.g_old_rec.currency_code;
511: End If;
512: If (p_rec.reference_period_cd = hr_api.g_varchar2) then
513: p_rec.reference_period_cd :=
514: pqh_crd_shd.g_old_rec.reference_period_cd;
515: End If;
516: If (p_rec.define_max_rate_flag = hr_api.g_varchar2) then
517: p_rec.define_max_rate_flag :=
518: pqh_crd_shd.g_old_rec.define_max_rate_flag;
514: pqh_crd_shd.g_old_rec.reference_period_cd;
515: End If;
516: If (p_rec.define_max_rate_flag = hr_api.g_varchar2) then
517: p_rec.define_max_rate_flag :=
518: pqh_crd_shd.g_old_rec.define_max_rate_flag;
519: End If;
520: If (p_rec.define_min_rate_flag = hr_api.g_varchar2) then
521: p_rec.define_min_rate_flag :=
522: pqh_crd_shd.g_old_rec.define_min_rate_flag;
518: pqh_crd_shd.g_old_rec.define_max_rate_flag;
519: End If;
520: If (p_rec.define_min_rate_flag = hr_api.g_varchar2) then
521: p_rec.define_min_rate_flag :=
522: pqh_crd_shd.g_old_rec.define_min_rate_flag;
523: End If;
524: If (p_rec.define_mid_rate_flag = hr_api.g_varchar2) then
525: p_rec.define_mid_rate_flag :=
526: pqh_crd_shd.g_old_rec.define_mid_rate_flag;
522: pqh_crd_shd.g_old_rec.define_min_rate_flag;
523: End If;
524: If (p_rec.define_mid_rate_flag = hr_api.g_varchar2) then
525: p_rec.define_mid_rate_flag :=
526: pqh_crd_shd.g_old_rec.define_mid_rate_flag;
527: End If;
528: If (p_rec.define_std_rate_flag = hr_api.g_varchar2) then
529: p_rec.define_std_rate_flag :=
530: pqh_crd_shd.g_old_rec.define_std_rate_flag;
526: pqh_crd_shd.g_old_rec.define_mid_rate_flag;
527: End If;
528: If (p_rec.define_std_rate_flag = hr_api.g_varchar2) then
529: p_rec.define_std_rate_flag :=
530: pqh_crd_shd.g_old_rec.define_std_rate_flag;
531: End If;
532: If (p_rec.rate_calc_cd = hr_api.g_varchar2) then
533: p_rec.rate_calc_cd :=
534: pqh_crd_shd.g_old_rec.rate_calc_cd;
530: pqh_crd_shd.g_old_rec.define_std_rate_flag;
531: End If;
532: If (p_rec.rate_calc_cd = hr_api.g_varchar2) then
533: p_rec.rate_calc_cd :=
534: pqh_crd_shd.g_old_rec.rate_calc_cd;
535: End If;
536: If (p_rec.rate_calc_rule = hr_api.g_number) then
537: p_rec.rate_calc_rule :=
538: pqh_crd_shd.g_old_rec.rate_calc_rule;
534: pqh_crd_shd.g_old_rec.rate_calc_cd;
535: End If;
536: If (p_rec.rate_calc_rule = hr_api.g_number) then
537: p_rec.rate_calc_rule :=
538: pqh_crd_shd.g_old_rec.rate_calc_rule;
539: End If;
540: If (p_rec.preferential_rate_cd = hr_api.g_varchar2) then
541: p_rec.preferential_rate_cd :=
542: pqh_crd_shd.g_old_rec.preferential_rate_cd;
538: pqh_crd_shd.g_old_rec.rate_calc_rule;
539: End If;
540: If (p_rec.preferential_rate_cd = hr_api.g_varchar2) then
541: p_rec.preferential_rate_cd :=
542: pqh_crd_shd.g_old_rec.preferential_rate_cd;
543: End If;
544: If (p_rec.preferential_rate_rule = hr_api.g_number) then
545: p_rec.preferential_rate_rule :=
546: pqh_crd_shd.g_old_rec.preferential_rate_rule;
542: pqh_crd_shd.g_old_rec.preferential_rate_cd;
543: End If;
544: If (p_rec.preferential_rate_rule = hr_api.g_number) then
545: p_rec.preferential_rate_rule :=
546: pqh_crd_shd.g_old_rec.preferential_rate_rule;
547: End If;
548: If (p_rec.rounding_cd = hr_api.g_varchar2) then
549: p_rec.rounding_cd :=
550: pqh_crd_shd.g_old_rec.rounding_cd;
546: pqh_crd_shd.g_old_rec.preferential_rate_rule;
547: End If;
548: If (p_rec.rounding_cd = hr_api.g_varchar2) then
549: p_rec.rounding_cd :=
550: pqh_crd_shd.g_old_rec.rounding_cd;
551: End If;
552: If (p_rec.rounding_rule = hr_api.g_number) then
553: p_rec.rounding_rule :=
554: pqh_crd_shd.g_old_rec.rounding_rule;
550: pqh_crd_shd.g_old_rec.rounding_cd;
551: End If;
552: If (p_rec.rounding_rule = hr_api.g_number) then
553: p_rec.rounding_rule :=
554: pqh_crd_shd.g_old_rec.rounding_rule;
555: End If;
556: If (p_rec.business_group_id = hr_api.g_number) then
557: p_rec.business_group_id :=
558: pqh_crd_shd.g_old_rec.business_group_id;
554: pqh_crd_shd.g_old_rec.rounding_rule;
555: End If;
556: If (p_rec.business_group_id = hr_api.g_number) then
557: p_rec.business_group_id :=
558: pqh_crd_shd.g_old_rec.business_group_id;
559: End If;
560: If (p_rec.legislation_code = hr_api.g_varchar2) then
561: p_rec.legislation_code :=
562: pqh_crd_shd.g_old_rec.legislation_code;
558: pqh_crd_shd.g_old_rec.business_group_id;
559: End If;
560: If (p_rec.legislation_code = hr_api.g_varchar2) then
561: p_rec.legislation_code :=
562: pqh_crd_shd.g_old_rec.legislation_code;
563: End If;
564: If (p_rec.attribute_category = hr_api.g_varchar2) then
565: p_rec.attribute_category :=
566: pqh_crd_shd.g_old_rec.attribute_category;
562: pqh_crd_shd.g_old_rec.legislation_code;
563: End If;
564: If (p_rec.attribute_category = hr_api.g_varchar2) then
565: p_rec.attribute_category :=
566: pqh_crd_shd.g_old_rec.attribute_category;
567: End If;
568: If (p_rec.attribute1 = hr_api.g_varchar2) then
569: p_rec.attribute1 :=
570: pqh_crd_shd.g_old_rec.attribute1;
566: pqh_crd_shd.g_old_rec.attribute_category;
567: End If;
568: If (p_rec.attribute1 = hr_api.g_varchar2) then
569: p_rec.attribute1 :=
570: pqh_crd_shd.g_old_rec.attribute1;
571: End If;
572: If (p_rec.attribute2 = hr_api.g_varchar2) then
573: p_rec.attribute2 :=
574: pqh_crd_shd.g_old_rec.attribute2;
570: pqh_crd_shd.g_old_rec.attribute1;
571: End If;
572: If (p_rec.attribute2 = hr_api.g_varchar2) then
573: p_rec.attribute2 :=
574: pqh_crd_shd.g_old_rec.attribute2;
575: End If;
576: If (p_rec.attribute3 = hr_api.g_varchar2) then
577: p_rec.attribute3 :=
578: pqh_crd_shd.g_old_rec.attribute3;
574: pqh_crd_shd.g_old_rec.attribute2;
575: End If;
576: If (p_rec.attribute3 = hr_api.g_varchar2) then
577: p_rec.attribute3 :=
578: pqh_crd_shd.g_old_rec.attribute3;
579: End If;
580: If (p_rec.attribute4 = hr_api.g_varchar2) then
581: p_rec.attribute4 :=
582: pqh_crd_shd.g_old_rec.attribute4;
578: pqh_crd_shd.g_old_rec.attribute3;
579: End If;
580: If (p_rec.attribute4 = hr_api.g_varchar2) then
581: p_rec.attribute4 :=
582: pqh_crd_shd.g_old_rec.attribute4;
583: End If;
584: If (p_rec.attribute5 = hr_api.g_varchar2) then
585: p_rec.attribute5 :=
586: pqh_crd_shd.g_old_rec.attribute5;
582: pqh_crd_shd.g_old_rec.attribute4;
583: End If;
584: If (p_rec.attribute5 = hr_api.g_varchar2) then
585: p_rec.attribute5 :=
586: pqh_crd_shd.g_old_rec.attribute5;
587: End If;
588: If (p_rec.attribute6 = hr_api.g_varchar2) then
589: p_rec.attribute6 :=
590: pqh_crd_shd.g_old_rec.attribute6;
586: pqh_crd_shd.g_old_rec.attribute5;
587: End If;
588: If (p_rec.attribute6 = hr_api.g_varchar2) then
589: p_rec.attribute6 :=
590: pqh_crd_shd.g_old_rec.attribute6;
591: End If;
592: If (p_rec.attribute7 = hr_api.g_varchar2) then
593: p_rec.attribute7 :=
594: pqh_crd_shd.g_old_rec.attribute7;
590: pqh_crd_shd.g_old_rec.attribute6;
591: End If;
592: If (p_rec.attribute7 = hr_api.g_varchar2) then
593: p_rec.attribute7 :=
594: pqh_crd_shd.g_old_rec.attribute7;
595: End If;
596: If (p_rec.attribute8 = hr_api.g_varchar2) then
597: p_rec.attribute8 :=
598: pqh_crd_shd.g_old_rec.attribute8;
594: pqh_crd_shd.g_old_rec.attribute7;
595: End If;
596: If (p_rec.attribute8 = hr_api.g_varchar2) then
597: p_rec.attribute8 :=
598: pqh_crd_shd.g_old_rec.attribute8;
599: End If;
600: If (p_rec.attribute9 = hr_api.g_varchar2) then
601: p_rec.attribute9 :=
602: pqh_crd_shd.g_old_rec.attribute9;
598: pqh_crd_shd.g_old_rec.attribute8;
599: End If;
600: If (p_rec.attribute9 = hr_api.g_varchar2) then
601: p_rec.attribute9 :=
602: pqh_crd_shd.g_old_rec.attribute9;
603: End If;
604: If (p_rec.attribute10 = hr_api.g_varchar2) then
605: p_rec.attribute10 :=
606: pqh_crd_shd.g_old_rec.attribute10;
602: pqh_crd_shd.g_old_rec.attribute9;
603: End If;
604: If (p_rec.attribute10 = hr_api.g_varchar2) then
605: p_rec.attribute10 :=
606: pqh_crd_shd.g_old_rec.attribute10;
607: End If;
608: If (p_rec.attribute11 = hr_api.g_varchar2) then
609: p_rec.attribute11 :=
610: pqh_crd_shd.g_old_rec.attribute11;
606: pqh_crd_shd.g_old_rec.attribute10;
607: End If;
608: If (p_rec.attribute11 = hr_api.g_varchar2) then
609: p_rec.attribute11 :=
610: pqh_crd_shd.g_old_rec.attribute11;
611: End If;
612: If (p_rec.attribute12 = hr_api.g_varchar2) then
613: p_rec.attribute12 :=
614: pqh_crd_shd.g_old_rec.attribute12;
610: pqh_crd_shd.g_old_rec.attribute11;
611: End If;
612: If (p_rec.attribute12 = hr_api.g_varchar2) then
613: p_rec.attribute12 :=
614: pqh_crd_shd.g_old_rec.attribute12;
615: End If;
616: If (p_rec.attribute13 = hr_api.g_varchar2) then
617: p_rec.attribute13 :=
618: pqh_crd_shd.g_old_rec.attribute13;
614: pqh_crd_shd.g_old_rec.attribute12;
615: End If;
616: If (p_rec.attribute13 = hr_api.g_varchar2) then
617: p_rec.attribute13 :=
618: pqh_crd_shd.g_old_rec.attribute13;
619: End If;
620: If (p_rec.attribute14 = hr_api.g_varchar2) then
621: p_rec.attribute14 :=
622: pqh_crd_shd.g_old_rec.attribute14;
618: pqh_crd_shd.g_old_rec.attribute13;
619: End If;
620: If (p_rec.attribute14 = hr_api.g_varchar2) then
621: p_rec.attribute14 :=
622: pqh_crd_shd.g_old_rec.attribute14;
623: End If;
624: If (p_rec.attribute15 = hr_api.g_varchar2) then
625: p_rec.attribute15 :=
626: pqh_crd_shd.g_old_rec.attribute15;
622: pqh_crd_shd.g_old_rec.attribute14;
623: End If;
624: If (p_rec.attribute15 = hr_api.g_varchar2) then
625: p_rec.attribute15 :=
626: pqh_crd_shd.g_old_rec.attribute15;
627: End If;
628: If (p_rec.attribute16 = hr_api.g_varchar2) then
629: p_rec.attribute16 :=
630: pqh_crd_shd.g_old_rec.attribute16;
626: pqh_crd_shd.g_old_rec.attribute15;
627: End If;
628: If (p_rec.attribute16 = hr_api.g_varchar2) then
629: p_rec.attribute16 :=
630: pqh_crd_shd.g_old_rec.attribute16;
631: End If;
632: If (p_rec.attribute17 = hr_api.g_varchar2) then
633: p_rec.attribute17 :=
634: pqh_crd_shd.g_old_rec.attribute17;
630: pqh_crd_shd.g_old_rec.attribute16;
631: End If;
632: If (p_rec.attribute17 = hr_api.g_varchar2) then
633: p_rec.attribute17 :=
634: pqh_crd_shd.g_old_rec.attribute17;
635: End If;
636: If (p_rec.attribute18 = hr_api.g_varchar2) then
637: p_rec.attribute18 :=
638: pqh_crd_shd.g_old_rec.attribute18;
634: pqh_crd_shd.g_old_rec.attribute17;
635: End If;
636: If (p_rec.attribute18 = hr_api.g_varchar2) then
637: p_rec.attribute18 :=
638: pqh_crd_shd.g_old_rec.attribute18;
639: End If;
640: If (p_rec.attribute19 = hr_api.g_varchar2) then
641: p_rec.attribute19 :=
642: pqh_crd_shd.g_old_rec.attribute19;
638: pqh_crd_shd.g_old_rec.attribute18;
639: End If;
640: If (p_rec.attribute19 = hr_api.g_varchar2) then
641: p_rec.attribute19 :=
642: pqh_crd_shd.g_old_rec.attribute19;
643: End If;
644: If (p_rec.attribute20 = hr_api.g_varchar2) then
645: p_rec.attribute20 :=
646: pqh_crd_shd.g_old_rec.attribute20;
642: pqh_crd_shd.g_old_rec.attribute19;
643: End If;
644: If (p_rec.attribute20 = hr_api.g_varchar2) then
645: p_rec.attribute20 :=
646: pqh_crd_shd.g_old_rec.attribute20;
647: End If;
648: If (p_rec.attribute21 = hr_api.g_varchar2) then
649: p_rec.attribute21 :=
650: pqh_crd_shd.g_old_rec.attribute21;
646: pqh_crd_shd.g_old_rec.attribute20;
647: End If;
648: If (p_rec.attribute21 = hr_api.g_varchar2) then
649: p_rec.attribute21 :=
650: pqh_crd_shd.g_old_rec.attribute21;
651: End If;
652: If (p_rec.attribute22 = hr_api.g_varchar2) then
653: p_rec.attribute22 :=
654: pqh_crd_shd.g_old_rec.attribute22;
650: pqh_crd_shd.g_old_rec.attribute21;
651: End If;
652: If (p_rec.attribute22 = hr_api.g_varchar2) then
653: p_rec.attribute22 :=
654: pqh_crd_shd.g_old_rec.attribute22;
655: End If;
656: If (p_rec.attribute23 = hr_api.g_varchar2) then
657: p_rec.attribute23 :=
658: pqh_crd_shd.g_old_rec.attribute23;
654: pqh_crd_shd.g_old_rec.attribute22;
655: End If;
656: If (p_rec.attribute23 = hr_api.g_varchar2) then
657: p_rec.attribute23 :=
658: pqh_crd_shd.g_old_rec.attribute23;
659: End If;
660: If (p_rec.attribute24 = hr_api.g_varchar2) then
661: p_rec.attribute24 :=
662: pqh_crd_shd.g_old_rec.attribute24;
658: pqh_crd_shd.g_old_rec.attribute23;
659: End If;
660: If (p_rec.attribute24 = hr_api.g_varchar2) then
661: p_rec.attribute24 :=
662: pqh_crd_shd.g_old_rec.attribute24;
663: End If;
664: If (p_rec.attribute25 = hr_api.g_varchar2) then
665: p_rec.attribute25 :=
666: pqh_crd_shd.g_old_rec.attribute25;
662: pqh_crd_shd.g_old_rec.attribute24;
663: End If;
664: If (p_rec.attribute25 = hr_api.g_varchar2) then
665: p_rec.attribute25 :=
666: pqh_crd_shd.g_old_rec.attribute25;
667: End If;
668: If (p_rec.attribute26 = hr_api.g_varchar2) then
669: p_rec.attribute26 :=
670: pqh_crd_shd.g_old_rec.attribute26;
666: pqh_crd_shd.g_old_rec.attribute25;
667: End If;
668: If (p_rec.attribute26 = hr_api.g_varchar2) then
669: p_rec.attribute26 :=
670: pqh_crd_shd.g_old_rec.attribute26;
671: End If;
672: If (p_rec.attribute27 = hr_api.g_varchar2) then
673: p_rec.attribute27 :=
674: pqh_crd_shd.g_old_rec.attribute27;
670: pqh_crd_shd.g_old_rec.attribute26;
671: End If;
672: If (p_rec.attribute27 = hr_api.g_varchar2) then
673: p_rec.attribute27 :=
674: pqh_crd_shd.g_old_rec.attribute27;
675: End If;
676: If (p_rec.attribute28 = hr_api.g_varchar2) then
677: p_rec.attribute28 :=
678: pqh_crd_shd.g_old_rec.attribute28;
674: pqh_crd_shd.g_old_rec.attribute27;
675: End If;
676: If (p_rec.attribute28 = hr_api.g_varchar2) then
677: p_rec.attribute28 :=
678: pqh_crd_shd.g_old_rec.attribute28;
679: End If;
680: If (p_rec.attribute29 = hr_api.g_varchar2) then
681: p_rec.attribute29 :=
682: pqh_crd_shd.g_old_rec.attribute29;
678: pqh_crd_shd.g_old_rec.attribute28;
679: End If;
680: If (p_rec.attribute29 = hr_api.g_varchar2) then
681: p_rec.attribute29 :=
682: pqh_crd_shd.g_old_rec.attribute29;
683: End If;
684: If (p_rec.attribute30 = hr_api.g_varchar2) then
685: p_rec.attribute30 :=
686: pqh_crd_shd.g_old_rec.attribute30;
682: pqh_crd_shd.g_old_rec.attribute29;
683: End If;
684: If (p_rec.attribute30 = hr_api.g_varchar2) then
685: p_rec.attribute30 :=
686: pqh_crd_shd.g_old_rec.attribute30;
687: End If;
688: --
689: End convert_defs;
690: --
692: -- |---------------------------------< upd >----------------------------------|
693: -- ----------------------------------------------------------------------------
694: Procedure upd
695: (p_effective_date in date
696: ,p_rec in out nocopy pqh_crd_shd.g_rec_type
697: ) is
698: --
699: l_proc varchar2(72) := g_package||'upd';
700: --
702: hr_utility.set_location('Entering:'||l_proc, 5);
703: --
704: -- We must lock the row which we need to update.
705: --
706: pqh_crd_shd.lck
707: (p_rec.criteria_rate_defn_id
708: ,p_rec.object_version_number
709: );
710: --
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ) is
800: --
801: l_rec pqh_crd_shd.g_rec_type;
802: l_proc varchar2(72) := g_package||'upd';
803: --
804: Begin
805: hr_utility.set_location('Entering:'||l_proc, 5);
807: -- Call conversion function to turn arguments into the
808: -- l_rec structure.
809: --
810: l_rec :=
811: pqh_crd_shd.convert_args
812: (p_criteria_rate_defn_id
813: ,p_short_name
814: ,p_uom
815: ,p_currency_code