[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_pbc_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
140: Exception
141: When hr_api.check_integrity_violated Then
142: -- A check constraint has been violated
143: --
144: pay_pbc_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: pay_pbc_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: --
153: Raise;
184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure update_dml
188: (p_rec in out nocopy pay_pbc_shd.g_rec_type
189: ,p_effective_date in date
190: ,p_datetrack_mode in varchar2
191: ,p_validation_start_date in date
192: ,p_validation_end_date in date
251: --
252: -- {End Of Comments}
253: -- ----------------------------------------------------------------------------
254: Procedure dt_pre_update
255: (p_rec in out nocopy pay_pbc_shd.g_rec_type
256: ,p_effective_date in date
257: ,p_datetrack_mode in varchar2
258: ,p_validation_start_date in date
259: ,p_validation_end_date in date
267: If (p_datetrack_mode <> hr_api.g_correction) then
268: --
269: -- Update the current effective end date
270: --
271: pay_pbc_shd.upd_effective_end_date
272: (p_effective_date => p_effective_date
273: ,p_base_key_value => p_rec.balance_category_id
274: ,p_new_effective_end_date => (p_validation_start_date - 1)
275: ,p_validation_start_date => p_validation_start_date
336: --
337: -- {End Of Comments}
338: -- ----------------------------------------------------------------------------
339: Procedure pre_update
340: (p_rec in out nocopy pay_pbc_shd.g_rec_type
341: ,p_effective_date in date
342: ,p_datetrack_mode in varchar2
343: ,p_validation_start_date in date
344: ,p_validation_end_date in date
394: --
395: -- {End Of Comments}
396: -- ----------------------------------------------------------------------------
397: Procedure post_update
398: (p_rec in pay_pbc_shd.g_rec_type
399: ,p_effective_date in date
400: ,p_datetrack_mode in varchar2
401: ,p_validation_start_date in date
402: ,p_validation_end_date in date
449: ,p_pbc_information28 => p_rec.pbc_information28
450: ,p_pbc_information29 => p_rec.pbc_information29
451: ,p_pbc_information30 => p_rec.pbc_information30
452: ,p_object_version_number => p_rec.object_version_number
453: ,p_category_name_o => pay_pbc_shd.g_old_rec.category_name
454: ,p_effective_start_date_o => pay_pbc_shd.g_old_rec.effective_start_date
455: ,p_effective_end_date_o => pay_pbc_shd.g_old_rec.effective_end_date
456: ,p_legislation_code_o => pay_pbc_shd.g_old_rec.legislation_code
457: ,p_business_group_id_o => pay_pbc_shd.g_old_rec.business_group_id
450: ,p_pbc_information29 => p_rec.pbc_information29
451: ,p_pbc_information30 => p_rec.pbc_information30
452: ,p_object_version_number => p_rec.object_version_number
453: ,p_category_name_o => pay_pbc_shd.g_old_rec.category_name
454: ,p_effective_start_date_o => pay_pbc_shd.g_old_rec.effective_start_date
455: ,p_effective_end_date_o => pay_pbc_shd.g_old_rec.effective_end_date
456: ,p_legislation_code_o => pay_pbc_shd.g_old_rec.legislation_code
457: ,p_business_group_id_o => pay_pbc_shd.g_old_rec.business_group_id
458: ,p_save_run_balance_enabled_o
451: ,p_pbc_information30 => p_rec.pbc_information30
452: ,p_object_version_number => p_rec.object_version_number
453: ,p_category_name_o => pay_pbc_shd.g_old_rec.category_name
454: ,p_effective_start_date_o => pay_pbc_shd.g_old_rec.effective_start_date
455: ,p_effective_end_date_o => pay_pbc_shd.g_old_rec.effective_end_date
456: ,p_legislation_code_o => pay_pbc_shd.g_old_rec.legislation_code
457: ,p_business_group_id_o => pay_pbc_shd.g_old_rec.business_group_id
458: ,p_save_run_balance_enabled_o
459: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
452: ,p_object_version_number => p_rec.object_version_number
453: ,p_category_name_o => pay_pbc_shd.g_old_rec.category_name
454: ,p_effective_start_date_o => pay_pbc_shd.g_old_rec.effective_start_date
455: ,p_effective_end_date_o => pay_pbc_shd.g_old_rec.effective_end_date
456: ,p_legislation_code_o => pay_pbc_shd.g_old_rec.legislation_code
457: ,p_business_group_id_o => pay_pbc_shd.g_old_rec.business_group_id
458: ,p_save_run_balance_enabled_o
459: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
460: ,p_user_category_name_o => pay_pbc_shd.g_old_rec.user_category_name
453: ,p_category_name_o => pay_pbc_shd.g_old_rec.category_name
454: ,p_effective_start_date_o => pay_pbc_shd.g_old_rec.effective_start_date
455: ,p_effective_end_date_o => pay_pbc_shd.g_old_rec.effective_end_date
456: ,p_legislation_code_o => pay_pbc_shd.g_old_rec.legislation_code
457: ,p_business_group_id_o => pay_pbc_shd.g_old_rec.business_group_id
458: ,p_save_run_balance_enabled_o
459: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
460: ,p_user_category_name_o => pay_pbc_shd.g_old_rec.user_category_name
461: ,p_pbc_information_category_o
455: ,p_effective_end_date_o => pay_pbc_shd.g_old_rec.effective_end_date
456: ,p_legislation_code_o => pay_pbc_shd.g_old_rec.legislation_code
457: ,p_business_group_id_o => pay_pbc_shd.g_old_rec.business_group_id
458: ,p_save_run_balance_enabled_o
459: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
460: ,p_user_category_name_o => pay_pbc_shd.g_old_rec.user_category_name
461: ,p_pbc_information_category_o
462: => pay_pbc_shd.g_old_rec.pbc_information_category
463: ,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
456: ,p_legislation_code_o => pay_pbc_shd.g_old_rec.legislation_code
457: ,p_business_group_id_o => pay_pbc_shd.g_old_rec.business_group_id
458: ,p_save_run_balance_enabled_o
459: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
460: ,p_user_category_name_o => pay_pbc_shd.g_old_rec.user_category_name
461: ,p_pbc_information_category_o
462: => pay_pbc_shd.g_old_rec.pbc_information_category
463: ,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
464: ,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
458: ,p_save_run_balance_enabled_o
459: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
460: ,p_user_category_name_o => pay_pbc_shd.g_old_rec.user_category_name
461: ,p_pbc_information_category_o
462: => pay_pbc_shd.g_old_rec.pbc_information_category
463: ,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
464: ,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
465: ,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
459: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
460: ,p_user_category_name_o => pay_pbc_shd.g_old_rec.user_category_name
461: ,p_pbc_information_category_o
462: => pay_pbc_shd.g_old_rec.pbc_information_category
463: ,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
464: ,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
465: ,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
460: ,p_user_category_name_o => pay_pbc_shd.g_old_rec.user_category_name
461: ,p_pbc_information_category_o
462: => pay_pbc_shd.g_old_rec.pbc_information_category
463: ,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
464: ,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
465: ,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
461: ,p_pbc_information_category_o
462: => pay_pbc_shd.g_old_rec.pbc_information_category
463: ,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
464: ,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
465: ,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
462: => pay_pbc_shd.g_old_rec.pbc_information_category
463: ,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
464: ,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
465: ,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
463: ,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
464: ,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
465: ,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
464: ,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
465: ,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
465: ,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
466: ,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
467: ,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
468: ,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
469: ,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
470: ,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
471: ,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
472: ,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
473: ,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
474: ,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
475: ,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
476: ,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
477: ,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
478: ,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
479: ,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
480: ,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
481: ,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
482: ,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
490: ,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
483: ,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
490: ,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
491: ,p_pbc_information29_o => pay_pbc_shd.g_old_rec.pbc_information29
484: ,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
490: ,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
491: ,p_pbc_information29_o => pay_pbc_shd.g_old_rec.pbc_information29
492: ,p_pbc_information30_o => pay_pbc_shd.g_old_rec.pbc_information30
485: ,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
490: ,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
491: ,p_pbc_information29_o => pay_pbc_shd.g_old_rec.pbc_information29
492: ,p_pbc_information30_o => pay_pbc_shd.g_old_rec.pbc_information30
493: ,p_object_version_number_o => pay_pbc_shd.g_old_rec.object_version_number
486: ,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
490: ,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
491: ,p_pbc_information29_o => pay_pbc_shd.g_old_rec.pbc_information29
492: ,p_pbc_information30_o => pay_pbc_shd.g_old_rec.pbc_information30
493: ,p_object_version_number_o => pay_pbc_shd.g_old_rec.object_version_number
494: );
487: ,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
490: ,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
491: ,p_pbc_information29_o => pay_pbc_shd.g_old_rec.pbc_information29
492: ,p_pbc_information30_o => pay_pbc_shd.g_old_rec.pbc_information30
493: ,p_object_version_number_o => pay_pbc_shd.g_old_rec.object_version_number
494: );
495: --
488: ,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
490: ,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
491: ,p_pbc_information29_o => pay_pbc_shd.g_old_rec.pbc_information29
492: ,p_pbc_information30_o => pay_pbc_shd.g_old_rec.pbc_information30
493: ,p_object_version_number_o => pay_pbc_shd.g_old_rec.object_version_number
494: );
495: --
496: exception
489: ,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
490: ,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
491: ,p_pbc_information29_o => pay_pbc_shd.g_old_rec.pbc_information29
492: ,p_pbc_information30_o => pay_pbc_shd.g_old_rec.pbc_information30
493: ,p_object_version_number_o => pay_pbc_shd.g_old_rec.object_version_number
494: );
495: --
496: exception
497: --
549: --
550: -- {End Of Comments}
551: -- ----------------------------------------------------------------------------
552: Procedure convert_defs
553: (p_rec in out nocopy pay_pbc_shd.g_rec_type
554: ) is
555: --
556: Begin
557: --
561: -- is being used then we must set to the 'current' argument value.
562: --
563: If (p_rec.category_name = hr_api.g_varchar2) then
564: p_rec.category_name :=
565: pay_pbc_shd.g_old_rec.category_name;
566: End If;
567: If (p_rec.legislation_code = hr_api.g_varchar2) then
568: p_rec.legislation_code :=
569: pay_pbc_shd.g_old_rec.legislation_code;
565: pay_pbc_shd.g_old_rec.category_name;
566: End If;
567: If (p_rec.legislation_code = hr_api.g_varchar2) then
568: p_rec.legislation_code :=
569: pay_pbc_shd.g_old_rec.legislation_code;
570: End If;
571: If (p_rec.business_group_id = hr_api.g_number) then
572: p_rec.business_group_id :=
573: pay_pbc_shd.g_old_rec.business_group_id;
569: pay_pbc_shd.g_old_rec.legislation_code;
570: End If;
571: If (p_rec.business_group_id = hr_api.g_number) then
572: p_rec.business_group_id :=
573: pay_pbc_shd.g_old_rec.business_group_id;
574: End If;
575: If (p_rec.save_run_balance_enabled = hr_api.g_varchar2) then
576: p_rec.save_run_balance_enabled :=
577: pay_pbc_shd.g_old_rec.save_run_balance_enabled;
573: pay_pbc_shd.g_old_rec.business_group_id;
574: End If;
575: If (p_rec.save_run_balance_enabled = hr_api.g_varchar2) then
576: p_rec.save_run_balance_enabled :=
577: pay_pbc_shd.g_old_rec.save_run_balance_enabled;
578: End If;
579: If (p_rec.user_category_name = hr_api.g_varchar2) then
580: p_rec.user_category_name :=
581: pay_pbc_shd.g_old_rec.user_category_name;
577: pay_pbc_shd.g_old_rec.save_run_balance_enabled;
578: End If;
579: If (p_rec.user_category_name = hr_api.g_varchar2) then
580: p_rec.user_category_name :=
581: pay_pbc_shd.g_old_rec.user_category_name;
582: End If;
583: If (p_rec.pbc_information_category = hr_api.g_varchar2) then
584: p_rec.pbc_information_category :=
585: pay_pbc_shd.g_old_rec.pbc_information_category;
581: pay_pbc_shd.g_old_rec.user_category_name;
582: End If;
583: If (p_rec.pbc_information_category = hr_api.g_varchar2) then
584: p_rec.pbc_information_category :=
585: pay_pbc_shd.g_old_rec.pbc_information_category;
586: End If;
587: If (p_rec.pbc_information1 = hr_api.g_varchar2) then
588: p_rec.pbc_information1 :=
589: pay_pbc_shd.g_old_rec.pbc_information1;
585: pay_pbc_shd.g_old_rec.pbc_information_category;
586: End If;
587: If (p_rec.pbc_information1 = hr_api.g_varchar2) then
588: p_rec.pbc_information1 :=
589: pay_pbc_shd.g_old_rec.pbc_information1;
590: End If;
591: If (p_rec.pbc_information2 = hr_api.g_varchar2) then
592: p_rec.pbc_information2 :=
593: pay_pbc_shd.g_old_rec.pbc_information2;
589: pay_pbc_shd.g_old_rec.pbc_information1;
590: End If;
591: If (p_rec.pbc_information2 = hr_api.g_varchar2) then
592: p_rec.pbc_information2 :=
593: pay_pbc_shd.g_old_rec.pbc_information2;
594: End If;
595: If (p_rec.pbc_information3 = hr_api.g_varchar2) then
596: p_rec.pbc_information3 :=
597: pay_pbc_shd.g_old_rec.pbc_information3;
593: pay_pbc_shd.g_old_rec.pbc_information2;
594: End If;
595: If (p_rec.pbc_information3 = hr_api.g_varchar2) then
596: p_rec.pbc_information3 :=
597: pay_pbc_shd.g_old_rec.pbc_information3;
598: End If;
599: If (p_rec.pbc_information4 = hr_api.g_varchar2) then
600: p_rec.pbc_information4 :=
601: pay_pbc_shd.g_old_rec.pbc_information4;
597: pay_pbc_shd.g_old_rec.pbc_information3;
598: End If;
599: If (p_rec.pbc_information4 = hr_api.g_varchar2) then
600: p_rec.pbc_information4 :=
601: pay_pbc_shd.g_old_rec.pbc_information4;
602: End If;
603: If (p_rec.pbc_information5 = hr_api.g_varchar2) then
604: p_rec.pbc_information5 :=
605: pay_pbc_shd.g_old_rec.pbc_information5;
601: pay_pbc_shd.g_old_rec.pbc_information4;
602: End If;
603: If (p_rec.pbc_information5 = hr_api.g_varchar2) then
604: p_rec.pbc_information5 :=
605: pay_pbc_shd.g_old_rec.pbc_information5;
606: End If;
607: If (p_rec.pbc_information6 = hr_api.g_varchar2) then
608: p_rec.pbc_information6 :=
609: pay_pbc_shd.g_old_rec.pbc_information6;
605: pay_pbc_shd.g_old_rec.pbc_information5;
606: End If;
607: If (p_rec.pbc_information6 = hr_api.g_varchar2) then
608: p_rec.pbc_information6 :=
609: pay_pbc_shd.g_old_rec.pbc_information6;
610: End If;
611: If (p_rec.pbc_information7 = hr_api.g_varchar2) then
612: p_rec.pbc_information7 :=
613: pay_pbc_shd.g_old_rec.pbc_information7;
609: pay_pbc_shd.g_old_rec.pbc_information6;
610: End If;
611: If (p_rec.pbc_information7 = hr_api.g_varchar2) then
612: p_rec.pbc_information7 :=
613: pay_pbc_shd.g_old_rec.pbc_information7;
614: End If;
615: If (p_rec.pbc_information8 = hr_api.g_varchar2) then
616: p_rec.pbc_information8 :=
617: pay_pbc_shd.g_old_rec.pbc_information8;
613: pay_pbc_shd.g_old_rec.pbc_information7;
614: End If;
615: If (p_rec.pbc_information8 = hr_api.g_varchar2) then
616: p_rec.pbc_information8 :=
617: pay_pbc_shd.g_old_rec.pbc_information8;
618: End If;
619: If (p_rec.pbc_information9 = hr_api.g_varchar2) then
620: p_rec.pbc_information9 :=
621: pay_pbc_shd.g_old_rec.pbc_information9;
617: pay_pbc_shd.g_old_rec.pbc_information8;
618: End If;
619: If (p_rec.pbc_information9 = hr_api.g_varchar2) then
620: p_rec.pbc_information9 :=
621: pay_pbc_shd.g_old_rec.pbc_information9;
622: End If;
623: If (p_rec.pbc_information10 = hr_api.g_varchar2) then
624: p_rec.pbc_information10 :=
625: pay_pbc_shd.g_old_rec.pbc_information10;
621: pay_pbc_shd.g_old_rec.pbc_information9;
622: End If;
623: If (p_rec.pbc_information10 = hr_api.g_varchar2) then
624: p_rec.pbc_information10 :=
625: pay_pbc_shd.g_old_rec.pbc_information10;
626: End If;
627: If (p_rec.pbc_information11 = hr_api.g_varchar2) then
628: p_rec.pbc_information11 :=
629: pay_pbc_shd.g_old_rec.pbc_information11;
625: pay_pbc_shd.g_old_rec.pbc_information10;
626: End If;
627: If (p_rec.pbc_information11 = hr_api.g_varchar2) then
628: p_rec.pbc_information11 :=
629: pay_pbc_shd.g_old_rec.pbc_information11;
630: End If;
631: If (p_rec.pbc_information12 = hr_api.g_varchar2) then
632: p_rec.pbc_information12 :=
633: pay_pbc_shd.g_old_rec.pbc_information12;
629: pay_pbc_shd.g_old_rec.pbc_information11;
630: End If;
631: If (p_rec.pbc_information12 = hr_api.g_varchar2) then
632: p_rec.pbc_information12 :=
633: pay_pbc_shd.g_old_rec.pbc_information12;
634: End If;
635: If (p_rec.pbc_information13 = hr_api.g_varchar2) then
636: p_rec.pbc_information13 :=
637: pay_pbc_shd.g_old_rec.pbc_information13;
633: pay_pbc_shd.g_old_rec.pbc_information12;
634: End If;
635: If (p_rec.pbc_information13 = hr_api.g_varchar2) then
636: p_rec.pbc_information13 :=
637: pay_pbc_shd.g_old_rec.pbc_information13;
638: End If;
639: If (p_rec.pbc_information14 = hr_api.g_varchar2) then
640: p_rec.pbc_information14 :=
641: pay_pbc_shd.g_old_rec.pbc_information14;
637: pay_pbc_shd.g_old_rec.pbc_information13;
638: End If;
639: If (p_rec.pbc_information14 = hr_api.g_varchar2) then
640: p_rec.pbc_information14 :=
641: pay_pbc_shd.g_old_rec.pbc_information14;
642: End If;
643: If (p_rec.pbc_information15 = hr_api.g_varchar2) then
644: p_rec.pbc_information15 :=
645: pay_pbc_shd.g_old_rec.pbc_information15;
641: pay_pbc_shd.g_old_rec.pbc_information14;
642: End If;
643: If (p_rec.pbc_information15 = hr_api.g_varchar2) then
644: p_rec.pbc_information15 :=
645: pay_pbc_shd.g_old_rec.pbc_information15;
646: End If;
647: If (p_rec.pbc_information16 = hr_api.g_varchar2) then
648: p_rec.pbc_information16 :=
649: pay_pbc_shd.g_old_rec.pbc_information16;
645: pay_pbc_shd.g_old_rec.pbc_information15;
646: End If;
647: If (p_rec.pbc_information16 = hr_api.g_varchar2) then
648: p_rec.pbc_information16 :=
649: pay_pbc_shd.g_old_rec.pbc_information16;
650: End If;
651: If (p_rec.pbc_information17 = hr_api.g_varchar2) then
652: p_rec.pbc_information17 :=
653: pay_pbc_shd.g_old_rec.pbc_information17;
649: pay_pbc_shd.g_old_rec.pbc_information16;
650: End If;
651: If (p_rec.pbc_information17 = hr_api.g_varchar2) then
652: p_rec.pbc_information17 :=
653: pay_pbc_shd.g_old_rec.pbc_information17;
654: End If;
655: If (p_rec.pbc_information18 = hr_api.g_varchar2) then
656: p_rec.pbc_information18 :=
657: pay_pbc_shd.g_old_rec.pbc_information18;
653: pay_pbc_shd.g_old_rec.pbc_information17;
654: End If;
655: If (p_rec.pbc_information18 = hr_api.g_varchar2) then
656: p_rec.pbc_information18 :=
657: pay_pbc_shd.g_old_rec.pbc_information18;
658: End If;
659: If (p_rec.pbc_information19 = hr_api.g_varchar2) then
660: p_rec.pbc_information19 :=
661: pay_pbc_shd.g_old_rec.pbc_information19;
657: pay_pbc_shd.g_old_rec.pbc_information18;
658: End If;
659: If (p_rec.pbc_information19 = hr_api.g_varchar2) then
660: p_rec.pbc_information19 :=
661: pay_pbc_shd.g_old_rec.pbc_information19;
662: End If;
663: If (p_rec.pbc_information20 = hr_api.g_varchar2) then
664: p_rec.pbc_information20 :=
665: pay_pbc_shd.g_old_rec.pbc_information20;
661: pay_pbc_shd.g_old_rec.pbc_information19;
662: End If;
663: If (p_rec.pbc_information20 = hr_api.g_varchar2) then
664: p_rec.pbc_information20 :=
665: pay_pbc_shd.g_old_rec.pbc_information20;
666: End If;
667: If (p_rec.pbc_information21 = hr_api.g_varchar2) then
668: p_rec.pbc_information21 :=
669: pay_pbc_shd.g_old_rec.pbc_information21;
665: pay_pbc_shd.g_old_rec.pbc_information20;
666: End If;
667: If (p_rec.pbc_information21 = hr_api.g_varchar2) then
668: p_rec.pbc_information21 :=
669: pay_pbc_shd.g_old_rec.pbc_information21;
670: End If;
671: If (p_rec.pbc_information22 = hr_api.g_varchar2) then
672: p_rec.pbc_information22 :=
673: pay_pbc_shd.g_old_rec.pbc_information22;
669: pay_pbc_shd.g_old_rec.pbc_information21;
670: End If;
671: If (p_rec.pbc_information22 = hr_api.g_varchar2) then
672: p_rec.pbc_information22 :=
673: pay_pbc_shd.g_old_rec.pbc_information22;
674: End If;
675: If (p_rec.pbc_information23 = hr_api.g_varchar2) then
676: p_rec.pbc_information23 :=
677: pay_pbc_shd.g_old_rec.pbc_information23;
673: pay_pbc_shd.g_old_rec.pbc_information22;
674: End If;
675: If (p_rec.pbc_information23 = hr_api.g_varchar2) then
676: p_rec.pbc_information23 :=
677: pay_pbc_shd.g_old_rec.pbc_information23;
678: End If;
679: If (p_rec.pbc_information24 = hr_api.g_varchar2) then
680: p_rec.pbc_information24 :=
681: pay_pbc_shd.g_old_rec.pbc_information24;
677: pay_pbc_shd.g_old_rec.pbc_information23;
678: End If;
679: If (p_rec.pbc_information24 = hr_api.g_varchar2) then
680: p_rec.pbc_information24 :=
681: pay_pbc_shd.g_old_rec.pbc_information24;
682: End If;
683: If (p_rec.pbc_information25 = hr_api.g_varchar2) then
684: p_rec.pbc_information25 :=
685: pay_pbc_shd.g_old_rec.pbc_information25;
681: pay_pbc_shd.g_old_rec.pbc_information24;
682: End If;
683: If (p_rec.pbc_information25 = hr_api.g_varchar2) then
684: p_rec.pbc_information25 :=
685: pay_pbc_shd.g_old_rec.pbc_information25;
686: End If;
687: If (p_rec.pbc_information26 = hr_api.g_varchar2) then
688: p_rec.pbc_information26 :=
689: pay_pbc_shd.g_old_rec.pbc_information26;
685: pay_pbc_shd.g_old_rec.pbc_information25;
686: End If;
687: If (p_rec.pbc_information26 = hr_api.g_varchar2) then
688: p_rec.pbc_information26 :=
689: pay_pbc_shd.g_old_rec.pbc_information26;
690: End If;
691: If (p_rec.pbc_information27 = hr_api.g_varchar2) then
692: p_rec.pbc_information27 :=
693: pay_pbc_shd.g_old_rec.pbc_information27;
689: pay_pbc_shd.g_old_rec.pbc_information26;
690: End If;
691: If (p_rec.pbc_information27 = hr_api.g_varchar2) then
692: p_rec.pbc_information27 :=
693: pay_pbc_shd.g_old_rec.pbc_information27;
694: End If;
695: If (p_rec.pbc_information28 = hr_api.g_varchar2) then
696: p_rec.pbc_information28 :=
697: pay_pbc_shd.g_old_rec.pbc_information28;
693: pay_pbc_shd.g_old_rec.pbc_information27;
694: End If;
695: If (p_rec.pbc_information28 = hr_api.g_varchar2) then
696: p_rec.pbc_information28 :=
697: pay_pbc_shd.g_old_rec.pbc_information28;
698: End If;
699: If (p_rec.pbc_information29 = hr_api.g_varchar2) then
700: p_rec.pbc_information29 :=
701: pay_pbc_shd.g_old_rec.pbc_information29;
697: pay_pbc_shd.g_old_rec.pbc_information28;
698: End If;
699: If (p_rec.pbc_information29 = hr_api.g_varchar2) then
700: p_rec.pbc_information29 :=
701: pay_pbc_shd.g_old_rec.pbc_information29;
702: End If;
703: If (p_rec.pbc_information30 = hr_api.g_varchar2) then
704: p_rec.pbc_information30 :=
705: pay_pbc_shd.g_old_rec.pbc_information30;
701: pay_pbc_shd.g_old_rec.pbc_information29;
702: End If;
703: If (p_rec.pbc_information30 = hr_api.g_varchar2) then
704: p_rec.pbc_information30 :=
705: pay_pbc_shd.g_old_rec.pbc_information30;
706: End If;
707: --
708: End convert_defs;
709: --
712: -- ----------------------------------------------------------------------------
713: Procedure upd
714: (p_effective_date in date
715: ,p_datetrack_mode in varchar2
716: ,p_rec in out nocopy pay_pbc_shd.g_rec_type
717: ) is
718: --
719: l_proc varchar2(72) := g_package||'upd';
720: l_validation_start_date date;
728: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
729: --
730: -- We must lock the row which we need to update.
731: --
732: pay_pbc_shd.lck
733: (p_effective_date => p_effective_date
734: ,p_datetrack_mode => p_datetrack_mode
735: ,p_balance_category_id => p_rec.balance_category_id
736: ,p_object_version_number => p_rec.object_version_number
835: ,p_effective_start_date out nocopy date
836: ,p_effective_end_date out nocopy date
837: ) is
838: --
839: l_rec pay_pbc_shd.g_rec_type;
840: l_proc varchar2(72) := g_package||'upd';
841: --
842: Begin
843: hr_utility.set_location('Entering:'||l_proc, 5);
845: -- Call conversion function to turn arguments into the
846: -- l_rec structure.
847: --
848: l_rec :=
849: pay_pbc_shd.convert_args
850: (p_balance_category_id
851: ,hr_api.g_varchar2
852: ,null
853: ,null