[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_ppm_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) is
77: (p_base_table_name => 'pay_personal_payment_methods_f',
78: p_base_key_column => 'personal_payment_method_id',
79: p_base_key_value => p_rec.personal_payment_method_id);
80: --
81: pay_ppm_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the pay_personal_payment_methods_f Row
84: --
85: update pay_personal_payment_methods_f
149: where personal_payment_method_id = p_rec.personal_payment_method_id
150: and effective_start_date = p_validation_start_date
151: and effective_end_date = p_validation_end_date;
152: --
153: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
154: --
155: -- Set the effective start and end dates
156: --
157: p_rec.effective_start_date := p_validation_start_date;
161: hr_utility.set_location(' Leaving:'||l_proc, 15);
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
166: pay_ppm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
166: pay_ppm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
166: pay_ppm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
171: pay_ppm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
171: pay_ppm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
170: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
171: pay_ppm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End dt_update_dml;
177: --
178: -- ----------------------------------------------------------------------------
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure update_dml
210: (p_rec in out nocopy pay_ppm_shd.g_rec_type,
211: p_effective_date in date,
212: p_datetrack_mode in varchar2,
213: p_validation_start_date in date,
214: p_validation_end_date in date) is
270: --
271: -- {End Of Comments}
272: -- ----------------------------------------------------------------------------
273: Procedure dt_pre_update
274: (p_rec in out nocopy pay_ppm_shd.g_rec_type,
275: p_effective_date in date,
276: p_datetrack_mode in varchar2,
277: p_validation_start_date in date,
278: p_validation_end_date in date) is
286: hr_utility.set_location(l_proc, 10);
287: --
288: -- Update the current effective end date
289: --
290: pay_ppm_shd.upd_effective_end_date
291: (p_effective_date => p_effective_date,
292: p_base_key_value => p_rec.personal_payment_method_id,
293: p_new_effective_end_date => (p_validation_start_date - 1),
294: p_validation_start_date => p_validation_start_date,
355: --
356: -- {End Of Comments}
357: -- ----------------------------------------------------------------------------
358: Procedure pre_update
359: (p_rec in out nocopy pay_ppm_shd.g_rec_type,
360: p_effective_date in date,
361: p_datetrack_mode in varchar2,
362: p_validation_start_date in date,
363: p_validation_end_date in date) is
375: p_source_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
376: p_comment_text => p_rec.comments);
377: -- Update the comments if they have changed
378: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
379: pay_ppm_shd.g_old_rec.comments) then
380: hr_comm_api.upd(p_comment_id => p_rec.comment_id,
381: p_source_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
382: p_comment_text => p_rec.comments);
383: End If;
424: --
425: -- {End Of Comments}
426: -- ----------------------------------------------------------------------------
427: Procedure post_update
428: (p_rec in pay_ppm_shd.g_rec_type,
429: p_effective_date in date,
430: p_datetrack_mode in varchar2,
431: p_validation_start_date in date,
432: p_validation_end_date in date) is
507: ,p_ppm_information28 => p_rec.ppm_information28
508: ,p_ppm_information29 => p_rec.ppm_information29
509: ,p_ppm_information30 => p_rec.ppm_information30
510: ,p_effective_start_date_o
511: => pay_ppm_shd.g_old_rec.effective_start_date
512: ,p_effective_end_date_o
513: => pay_ppm_shd.g_old_rec.effective_end_date
514: ,p_business_group_id_o
515: => pay_ppm_shd.g_old_rec.business_group_id
509: ,p_ppm_information30 => p_rec.ppm_information30
510: ,p_effective_start_date_o
511: => pay_ppm_shd.g_old_rec.effective_start_date
512: ,p_effective_end_date_o
513: => pay_ppm_shd.g_old_rec.effective_end_date
514: ,p_business_group_id_o
515: => pay_ppm_shd.g_old_rec.business_group_id
516: ,p_external_account_id_o
517: => pay_ppm_shd.g_old_rec.external_account_id
511: => pay_ppm_shd.g_old_rec.effective_start_date
512: ,p_effective_end_date_o
513: => pay_ppm_shd.g_old_rec.effective_end_date
514: ,p_business_group_id_o
515: => pay_ppm_shd.g_old_rec.business_group_id
516: ,p_external_account_id_o
517: => pay_ppm_shd.g_old_rec.external_account_id
518: ,p_assignment_id_o
519: => pay_ppm_shd.g_old_rec.assignment_id
513: => pay_ppm_shd.g_old_rec.effective_end_date
514: ,p_business_group_id_o
515: => pay_ppm_shd.g_old_rec.business_group_id
516: ,p_external_account_id_o
517: => pay_ppm_shd.g_old_rec.external_account_id
518: ,p_assignment_id_o
519: => pay_ppm_shd.g_old_rec.assignment_id
520: ,p_org_payment_method_id_o
521: => pay_ppm_shd.g_old_rec.org_payment_method_id
515: => pay_ppm_shd.g_old_rec.business_group_id
516: ,p_external_account_id_o
517: => pay_ppm_shd.g_old_rec.external_account_id
518: ,p_assignment_id_o
519: => pay_ppm_shd.g_old_rec.assignment_id
520: ,p_org_payment_method_id_o
521: => pay_ppm_shd.g_old_rec.org_payment_method_id
522: ,p_amount_o
523: => pay_ppm_shd.g_old_rec.amount
517: => pay_ppm_shd.g_old_rec.external_account_id
518: ,p_assignment_id_o
519: => pay_ppm_shd.g_old_rec.assignment_id
520: ,p_org_payment_method_id_o
521: => pay_ppm_shd.g_old_rec.org_payment_method_id
522: ,p_amount_o
523: => pay_ppm_shd.g_old_rec.amount
524: ,p_comment_id_o
525: => pay_ppm_shd.g_old_rec.comment_id
519: => pay_ppm_shd.g_old_rec.assignment_id
520: ,p_org_payment_method_id_o
521: => pay_ppm_shd.g_old_rec.org_payment_method_id
522: ,p_amount_o
523: => pay_ppm_shd.g_old_rec.amount
524: ,p_comment_id_o
525: => pay_ppm_shd.g_old_rec.comment_id
526: ,p_percentage_o
527: => pay_ppm_shd.g_old_rec.percentage
521: => pay_ppm_shd.g_old_rec.org_payment_method_id
522: ,p_amount_o
523: => pay_ppm_shd.g_old_rec.amount
524: ,p_comment_id_o
525: => pay_ppm_shd.g_old_rec.comment_id
526: ,p_percentage_o
527: => pay_ppm_shd.g_old_rec.percentage
528: ,p_priority_o
529: => pay_ppm_shd.g_old_rec.priority
523: => pay_ppm_shd.g_old_rec.amount
524: ,p_comment_id_o
525: => pay_ppm_shd.g_old_rec.comment_id
526: ,p_percentage_o
527: => pay_ppm_shd.g_old_rec.percentage
528: ,p_priority_o
529: => pay_ppm_shd.g_old_rec.priority
530: ,p_attribute_category_o
531: => pay_ppm_shd.g_old_rec.attribute_category
525: => pay_ppm_shd.g_old_rec.comment_id
526: ,p_percentage_o
527: => pay_ppm_shd.g_old_rec.percentage
528: ,p_priority_o
529: => pay_ppm_shd.g_old_rec.priority
530: ,p_attribute_category_o
531: => pay_ppm_shd.g_old_rec.attribute_category
532: ,p_attribute1_o
533: => pay_ppm_shd.g_old_rec.attribute1
527: => pay_ppm_shd.g_old_rec.percentage
528: ,p_priority_o
529: => pay_ppm_shd.g_old_rec.priority
530: ,p_attribute_category_o
531: => pay_ppm_shd.g_old_rec.attribute_category
532: ,p_attribute1_o
533: => pay_ppm_shd.g_old_rec.attribute1
534: ,p_attribute2_o
535: => pay_ppm_shd.g_old_rec.attribute2
529: => pay_ppm_shd.g_old_rec.priority
530: ,p_attribute_category_o
531: => pay_ppm_shd.g_old_rec.attribute_category
532: ,p_attribute1_o
533: => pay_ppm_shd.g_old_rec.attribute1
534: ,p_attribute2_o
535: => pay_ppm_shd.g_old_rec.attribute2
536: ,p_attribute3_o
537: => pay_ppm_shd.g_old_rec.attribute3
531: => pay_ppm_shd.g_old_rec.attribute_category
532: ,p_attribute1_o
533: => pay_ppm_shd.g_old_rec.attribute1
534: ,p_attribute2_o
535: => pay_ppm_shd.g_old_rec.attribute2
536: ,p_attribute3_o
537: => pay_ppm_shd.g_old_rec.attribute3
538: ,p_attribute4_o
539: => pay_ppm_shd.g_old_rec.attribute4
533: => pay_ppm_shd.g_old_rec.attribute1
534: ,p_attribute2_o
535: => pay_ppm_shd.g_old_rec.attribute2
536: ,p_attribute3_o
537: => pay_ppm_shd.g_old_rec.attribute3
538: ,p_attribute4_o
539: => pay_ppm_shd.g_old_rec.attribute4
540: ,p_attribute5_o
541: => pay_ppm_shd.g_old_rec.attribute5
535: => pay_ppm_shd.g_old_rec.attribute2
536: ,p_attribute3_o
537: => pay_ppm_shd.g_old_rec.attribute3
538: ,p_attribute4_o
539: => pay_ppm_shd.g_old_rec.attribute4
540: ,p_attribute5_o
541: => pay_ppm_shd.g_old_rec.attribute5
542: ,p_attribute6_o
543: => pay_ppm_shd.g_old_rec.attribute6
537: => pay_ppm_shd.g_old_rec.attribute3
538: ,p_attribute4_o
539: => pay_ppm_shd.g_old_rec.attribute4
540: ,p_attribute5_o
541: => pay_ppm_shd.g_old_rec.attribute5
542: ,p_attribute6_o
543: => pay_ppm_shd.g_old_rec.attribute6
544: ,p_attribute7_o
545: => pay_ppm_shd.g_old_rec.attribute7
539: => pay_ppm_shd.g_old_rec.attribute4
540: ,p_attribute5_o
541: => pay_ppm_shd.g_old_rec.attribute5
542: ,p_attribute6_o
543: => pay_ppm_shd.g_old_rec.attribute6
544: ,p_attribute7_o
545: => pay_ppm_shd.g_old_rec.attribute7
546: ,p_attribute8_o
547: => pay_ppm_shd.g_old_rec.attribute8
541: => pay_ppm_shd.g_old_rec.attribute5
542: ,p_attribute6_o
543: => pay_ppm_shd.g_old_rec.attribute6
544: ,p_attribute7_o
545: => pay_ppm_shd.g_old_rec.attribute7
546: ,p_attribute8_o
547: => pay_ppm_shd.g_old_rec.attribute8
548: ,p_attribute9_o
549: => pay_ppm_shd.g_old_rec.attribute9
543: => pay_ppm_shd.g_old_rec.attribute6
544: ,p_attribute7_o
545: => pay_ppm_shd.g_old_rec.attribute7
546: ,p_attribute8_o
547: => pay_ppm_shd.g_old_rec.attribute8
548: ,p_attribute9_o
549: => pay_ppm_shd.g_old_rec.attribute9
550: ,p_attribute10_o
551: => pay_ppm_shd.g_old_rec.attribute10
545: => pay_ppm_shd.g_old_rec.attribute7
546: ,p_attribute8_o
547: => pay_ppm_shd.g_old_rec.attribute8
548: ,p_attribute9_o
549: => pay_ppm_shd.g_old_rec.attribute9
550: ,p_attribute10_o
551: => pay_ppm_shd.g_old_rec.attribute10
552: ,p_attribute11_o
553: => pay_ppm_shd.g_old_rec.attribute11
547: => pay_ppm_shd.g_old_rec.attribute8
548: ,p_attribute9_o
549: => pay_ppm_shd.g_old_rec.attribute9
550: ,p_attribute10_o
551: => pay_ppm_shd.g_old_rec.attribute10
552: ,p_attribute11_o
553: => pay_ppm_shd.g_old_rec.attribute11
554: ,p_attribute12_o
555: => pay_ppm_shd.g_old_rec.attribute12
549: => pay_ppm_shd.g_old_rec.attribute9
550: ,p_attribute10_o
551: => pay_ppm_shd.g_old_rec.attribute10
552: ,p_attribute11_o
553: => pay_ppm_shd.g_old_rec.attribute11
554: ,p_attribute12_o
555: => pay_ppm_shd.g_old_rec.attribute12
556: ,p_attribute13_o
557: => pay_ppm_shd.g_old_rec.attribute13
551: => pay_ppm_shd.g_old_rec.attribute10
552: ,p_attribute11_o
553: => pay_ppm_shd.g_old_rec.attribute11
554: ,p_attribute12_o
555: => pay_ppm_shd.g_old_rec.attribute12
556: ,p_attribute13_o
557: => pay_ppm_shd.g_old_rec.attribute13
558: ,p_attribute14_o
559: => pay_ppm_shd.g_old_rec.attribute14
553: => pay_ppm_shd.g_old_rec.attribute11
554: ,p_attribute12_o
555: => pay_ppm_shd.g_old_rec.attribute12
556: ,p_attribute13_o
557: => pay_ppm_shd.g_old_rec.attribute13
558: ,p_attribute14_o
559: => pay_ppm_shd.g_old_rec.attribute14
560: ,p_attribute15_o
561: => pay_ppm_shd.g_old_rec.attribute15
555: => pay_ppm_shd.g_old_rec.attribute12
556: ,p_attribute13_o
557: => pay_ppm_shd.g_old_rec.attribute13
558: ,p_attribute14_o
559: => pay_ppm_shd.g_old_rec.attribute14
560: ,p_attribute15_o
561: => pay_ppm_shd.g_old_rec.attribute15
562: ,p_attribute16_o
563: => pay_ppm_shd.g_old_rec.attribute16
557: => pay_ppm_shd.g_old_rec.attribute13
558: ,p_attribute14_o
559: => pay_ppm_shd.g_old_rec.attribute14
560: ,p_attribute15_o
561: => pay_ppm_shd.g_old_rec.attribute15
562: ,p_attribute16_o
563: => pay_ppm_shd.g_old_rec.attribute16
564: ,p_attribute17_o
565: => pay_ppm_shd.g_old_rec.attribute17
559: => pay_ppm_shd.g_old_rec.attribute14
560: ,p_attribute15_o
561: => pay_ppm_shd.g_old_rec.attribute15
562: ,p_attribute16_o
563: => pay_ppm_shd.g_old_rec.attribute16
564: ,p_attribute17_o
565: => pay_ppm_shd.g_old_rec.attribute17
566: ,p_attribute18_o
567: => pay_ppm_shd.g_old_rec.attribute18
561: => pay_ppm_shd.g_old_rec.attribute15
562: ,p_attribute16_o
563: => pay_ppm_shd.g_old_rec.attribute16
564: ,p_attribute17_o
565: => pay_ppm_shd.g_old_rec.attribute17
566: ,p_attribute18_o
567: => pay_ppm_shd.g_old_rec.attribute18
568: ,p_attribute19_o
569: => pay_ppm_shd.g_old_rec.attribute19
563: => pay_ppm_shd.g_old_rec.attribute16
564: ,p_attribute17_o
565: => pay_ppm_shd.g_old_rec.attribute17
566: ,p_attribute18_o
567: => pay_ppm_shd.g_old_rec.attribute18
568: ,p_attribute19_o
569: => pay_ppm_shd.g_old_rec.attribute19
570: ,p_attribute20_o
571: => pay_ppm_shd.g_old_rec.attribute20
565: => pay_ppm_shd.g_old_rec.attribute17
566: ,p_attribute18_o
567: => pay_ppm_shd.g_old_rec.attribute18
568: ,p_attribute19_o
569: => pay_ppm_shd.g_old_rec.attribute19
570: ,p_attribute20_o
571: => pay_ppm_shd.g_old_rec.attribute20
572: ,p_object_version_number_o
573: => pay_ppm_shd.g_old_rec.object_version_number
567: => pay_ppm_shd.g_old_rec.attribute18
568: ,p_attribute19_o
569: => pay_ppm_shd.g_old_rec.attribute19
570: ,p_attribute20_o
571: => pay_ppm_shd.g_old_rec.attribute20
572: ,p_object_version_number_o
573: => pay_ppm_shd.g_old_rec.object_version_number
574: ,p_payee_type_o
575: => pay_ppm_shd.g_old_rec.payee_type
569: => pay_ppm_shd.g_old_rec.attribute19
570: ,p_attribute20_o
571: => pay_ppm_shd.g_old_rec.attribute20
572: ,p_object_version_number_o
573: => pay_ppm_shd.g_old_rec.object_version_number
574: ,p_payee_type_o
575: => pay_ppm_shd.g_old_rec.payee_type
576: ,p_payee_id_o
577: => pay_ppm_shd.g_old_rec.payee_id
571: => pay_ppm_shd.g_old_rec.attribute20
572: ,p_object_version_number_o
573: => pay_ppm_shd.g_old_rec.object_version_number
574: ,p_payee_type_o
575: => pay_ppm_shd.g_old_rec.payee_type
576: ,p_payee_id_o
577: => pay_ppm_shd.g_old_rec.payee_id
578: ,p_ppm_information_category_o
579: => pay_ppm_shd.g_old_rec.ppm_information_category
573: => pay_ppm_shd.g_old_rec.object_version_number
574: ,p_payee_type_o
575: => pay_ppm_shd.g_old_rec.payee_type
576: ,p_payee_id_o
577: => pay_ppm_shd.g_old_rec.payee_id
578: ,p_ppm_information_category_o
579: => pay_ppm_shd.g_old_rec.ppm_information_category
580: ,p_ppm_information1_o
581: => pay_ppm_shd.g_old_rec.ppm_information1
575: => pay_ppm_shd.g_old_rec.payee_type
576: ,p_payee_id_o
577: => pay_ppm_shd.g_old_rec.payee_id
578: ,p_ppm_information_category_o
579: => pay_ppm_shd.g_old_rec.ppm_information_category
580: ,p_ppm_information1_o
581: => pay_ppm_shd.g_old_rec.ppm_information1
582: ,p_ppm_information2_o
583: => pay_ppm_shd.g_old_rec.ppm_information2
577: => pay_ppm_shd.g_old_rec.payee_id
578: ,p_ppm_information_category_o
579: => pay_ppm_shd.g_old_rec.ppm_information_category
580: ,p_ppm_information1_o
581: => pay_ppm_shd.g_old_rec.ppm_information1
582: ,p_ppm_information2_o
583: => pay_ppm_shd.g_old_rec.ppm_information2
584: ,p_ppm_information3_o
585: => pay_ppm_shd.g_old_rec.ppm_information3
579: => pay_ppm_shd.g_old_rec.ppm_information_category
580: ,p_ppm_information1_o
581: => pay_ppm_shd.g_old_rec.ppm_information1
582: ,p_ppm_information2_o
583: => pay_ppm_shd.g_old_rec.ppm_information2
584: ,p_ppm_information3_o
585: => pay_ppm_shd.g_old_rec.ppm_information3
586: ,p_ppm_information4_o
587: => pay_ppm_shd.g_old_rec.ppm_information4
581: => pay_ppm_shd.g_old_rec.ppm_information1
582: ,p_ppm_information2_o
583: => pay_ppm_shd.g_old_rec.ppm_information2
584: ,p_ppm_information3_o
585: => pay_ppm_shd.g_old_rec.ppm_information3
586: ,p_ppm_information4_o
587: => pay_ppm_shd.g_old_rec.ppm_information4
588: ,p_ppm_information5_o
589: => pay_ppm_shd.g_old_rec.ppm_information5
583: => pay_ppm_shd.g_old_rec.ppm_information2
584: ,p_ppm_information3_o
585: => pay_ppm_shd.g_old_rec.ppm_information3
586: ,p_ppm_information4_o
587: => pay_ppm_shd.g_old_rec.ppm_information4
588: ,p_ppm_information5_o
589: => pay_ppm_shd.g_old_rec.ppm_information5
590: ,p_ppm_information6_o
591: => pay_ppm_shd.g_old_rec.ppm_information6
585: => pay_ppm_shd.g_old_rec.ppm_information3
586: ,p_ppm_information4_o
587: => pay_ppm_shd.g_old_rec.ppm_information4
588: ,p_ppm_information5_o
589: => pay_ppm_shd.g_old_rec.ppm_information5
590: ,p_ppm_information6_o
591: => pay_ppm_shd.g_old_rec.ppm_information6
592: ,p_ppm_information7_o
593: => pay_ppm_shd.g_old_rec.ppm_information7
587: => pay_ppm_shd.g_old_rec.ppm_information4
588: ,p_ppm_information5_o
589: => pay_ppm_shd.g_old_rec.ppm_information5
590: ,p_ppm_information6_o
591: => pay_ppm_shd.g_old_rec.ppm_information6
592: ,p_ppm_information7_o
593: => pay_ppm_shd.g_old_rec.ppm_information7
594: ,p_ppm_information8_o
595: => pay_ppm_shd.g_old_rec.ppm_information8
589: => pay_ppm_shd.g_old_rec.ppm_information5
590: ,p_ppm_information6_o
591: => pay_ppm_shd.g_old_rec.ppm_information6
592: ,p_ppm_information7_o
593: => pay_ppm_shd.g_old_rec.ppm_information7
594: ,p_ppm_information8_o
595: => pay_ppm_shd.g_old_rec.ppm_information8
596: ,p_ppm_information9_o
597: => pay_ppm_shd.g_old_rec.ppm_information9
591: => pay_ppm_shd.g_old_rec.ppm_information6
592: ,p_ppm_information7_o
593: => pay_ppm_shd.g_old_rec.ppm_information7
594: ,p_ppm_information8_o
595: => pay_ppm_shd.g_old_rec.ppm_information8
596: ,p_ppm_information9_o
597: => pay_ppm_shd.g_old_rec.ppm_information9
598: ,p_ppm_information10_o
599: => pay_ppm_shd.g_old_rec.ppm_information10
593: => pay_ppm_shd.g_old_rec.ppm_information7
594: ,p_ppm_information8_o
595: => pay_ppm_shd.g_old_rec.ppm_information8
596: ,p_ppm_information9_o
597: => pay_ppm_shd.g_old_rec.ppm_information9
598: ,p_ppm_information10_o
599: => pay_ppm_shd.g_old_rec.ppm_information10
600: ,p_ppm_information11_o
601: => pay_ppm_shd.g_old_rec.ppm_information11
595: => pay_ppm_shd.g_old_rec.ppm_information8
596: ,p_ppm_information9_o
597: => pay_ppm_shd.g_old_rec.ppm_information9
598: ,p_ppm_information10_o
599: => pay_ppm_shd.g_old_rec.ppm_information10
600: ,p_ppm_information11_o
601: => pay_ppm_shd.g_old_rec.ppm_information11
602: ,p_ppm_information12_o
603: => pay_ppm_shd.g_old_rec.ppm_information12
597: => pay_ppm_shd.g_old_rec.ppm_information9
598: ,p_ppm_information10_o
599: => pay_ppm_shd.g_old_rec.ppm_information10
600: ,p_ppm_information11_o
601: => pay_ppm_shd.g_old_rec.ppm_information11
602: ,p_ppm_information12_o
603: => pay_ppm_shd.g_old_rec.ppm_information12
604: ,p_ppm_information13_o
605: => pay_ppm_shd.g_old_rec.ppm_information13
599: => pay_ppm_shd.g_old_rec.ppm_information10
600: ,p_ppm_information11_o
601: => pay_ppm_shd.g_old_rec.ppm_information11
602: ,p_ppm_information12_o
603: => pay_ppm_shd.g_old_rec.ppm_information12
604: ,p_ppm_information13_o
605: => pay_ppm_shd.g_old_rec.ppm_information13
606: ,p_ppm_information14_o
607: => pay_ppm_shd.g_old_rec.ppm_information14
601: => pay_ppm_shd.g_old_rec.ppm_information11
602: ,p_ppm_information12_o
603: => pay_ppm_shd.g_old_rec.ppm_information12
604: ,p_ppm_information13_o
605: => pay_ppm_shd.g_old_rec.ppm_information13
606: ,p_ppm_information14_o
607: => pay_ppm_shd.g_old_rec.ppm_information14
608: ,p_ppm_information15_o
609: => pay_ppm_shd.g_old_rec.ppm_information15
603: => pay_ppm_shd.g_old_rec.ppm_information12
604: ,p_ppm_information13_o
605: => pay_ppm_shd.g_old_rec.ppm_information13
606: ,p_ppm_information14_o
607: => pay_ppm_shd.g_old_rec.ppm_information14
608: ,p_ppm_information15_o
609: => pay_ppm_shd.g_old_rec.ppm_information15
610: ,p_ppm_information16_o
611: => pay_ppm_shd.g_old_rec.ppm_information16
605: => pay_ppm_shd.g_old_rec.ppm_information13
606: ,p_ppm_information14_o
607: => pay_ppm_shd.g_old_rec.ppm_information14
608: ,p_ppm_information15_o
609: => pay_ppm_shd.g_old_rec.ppm_information15
610: ,p_ppm_information16_o
611: => pay_ppm_shd.g_old_rec.ppm_information16
612: ,p_ppm_information17_o
613: => pay_ppm_shd.g_old_rec.ppm_information17
607: => pay_ppm_shd.g_old_rec.ppm_information14
608: ,p_ppm_information15_o
609: => pay_ppm_shd.g_old_rec.ppm_information15
610: ,p_ppm_information16_o
611: => pay_ppm_shd.g_old_rec.ppm_information16
612: ,p_ppm_information17_o
613: => pay_ppm_shd.g_old_rec.ppm_information17
614: ,p_ppm_information18_o
615: => pay_ppm_shd.g_old_rec.ppm_information18
609: => pay_ppm_shd.g_old_rec.ppm_information15
610: ,p_ppm_information16_o
611: => pay_ppm_shd.g_old_rec.ppm_information16
612: ,p_ppm_information17_o
613: => pay_ppm_shd.g_old_rec.ppm_information17
614: ,p_ppm_information18_o
615: => pay_ppm_shd.g_old_rec.ppm_information18
616: ,p_ppm_information19_o
617: => pay_ppm_shd.g_old_rec.ppm_information19
611: => pay_ppm_shd.g_old_rec.ppm_information16
612: ,p_ppm_information17_o
613: => pay_ppm_shd.g_old_rec.ppm_information17
614: ,p_ppm_information18_o
615: => pay_ppm_shd.g_old_rec.ppm_information18
616: ,p_ppm_information19_o
617: => pay_ppm_shd.g_old_rec.ppm_information19
618: ,p_ppm_information20_o
619: => pay_ppm_shd.g_old_rec.ppm_information20
613: => pay_ppm_shd.g_old_rec.ppm_information17
614: ,p_ppm_information18_o
615: => pay_ppm_shd.g_old_rec.ppm_information18
616: ,p_ppm_information19_o
617: => pay_ppm_shd.g_old_rec.ppm_information19
618: ,p_ppm_information20_o
619: => pay_ppm_shd.g_old_rec.ppm_information20
620: ,p_ppm_information21_o
621: => pay_ppm_shd.g_old_rec.ppm_information21
615: => pay_ppm_shd.g_old_rec.ppm_information18
616: ,p_ppm_information19_o
617: => pay_ppm_shd.g_old_rec.ppm_information19
618: ,p_ppm_information20_o
619: => pay_ppm_shd.g_old_rec.ppm_information20
620: ,p_ppm_information21_o
621: => pay_ppm_shd.g_old_rec.ppm_information21
622: ,p_ppm_information22_o
623: => pay_ppm_shd.g_old_rec.ppm_information22
617: => pay_ppm_shd.g_old_rec.ppm_information19
618: ,p_ppm_information20_o
619: => pay_ppm_shd.g_old_rec.ppm_information20
620: ,p_ppm_information21_o
621: => pay_ppm_shd.g_old_rec.ppm_information21
622: ,p_ppm_information22_o
623: => pay_ppm_shd.g_old_rec.ppm_information22
624: ,p_ppm_information23_o
625: => pay_ppm_shd.g_old_rec.ppm_information23
619: => pay_ppm_shd.g_old_rec.ppm_information20
620: ,p_ppm_information21_o
621: => pay_ppm_shd.g_old_rec.ppm_information21
622: ,p_ppm_information22_o
623: => pay_ppm_shd.g_old_rec.ppm_information22
624: ,p_ppm_information23_o
625: => pay_ppm_shd.g_old_rec.ppm_information23
626: ,p_ppm_information24_o
627: => pay_ppm_shd.g_old_rec.ppm_information24
621: => pay_ppm_shd.g_old_rec.ppm_information21
622: ,p_ppm_information22_o
623: => pay_ppm_shd.g_old_rec.ppm_information22
624: ,p_ppm_information23_o
625: => pay_ppm_shd.g_old_rec.ppm_information23
626: ,p_ppm_information24_o
627: => pay_ppm_shd.g_old_rec.ppm_information24
628: ,p_ppm_information25_o
629: => pay_ppm_shd.g_old_rec.ppm_information25
623: => pay_ppm_shd.g_old_rec.ppm_information22
624: ,p_ppm_information23_o
625: => pay_ppm_shd.g_old_rec.ppm_information23
626: ,p_ppm_information24_o
627: => pay_ppm_shd.g_old_rec.ppm_information24
628: ,p_ppm_information25_o
629: => pay_ppm_shd.g_old_rec.ppm_information25
630: ,p_ppm_information26_o
631: => pay_ppm_shd.g_old_rec.ppm_information26
625: => pay_ppm_shd.g_old_rec.ppm_information23
626: ,p_ppm_information24_o
627: => pay_ppm_shd.g_old_rec.ppm_information24
628: ,p_ppm_information25_o
629: => pay_ppm_shd.g_old_rec.ppm_information25
630: ,p_ppm_information26_o
631: => pay_ppm_shd.g_old_rec.ppm_information26
632: ,p_ppm_information27_o
633: => pay_ppm_shd.g_old_rec.ppm_information27
627: => pay_ppm_shd.g_old_rec.ppm_information24
628: ,p_ppm_information25_o
629: => pay_ppm_shd.g_old_rec.ppm_information25
630: ,p_ppm_information26_o
631: => pay_ppm_shd.g_old_rec.ppm_information26
632: ,p_ppm_information27_o
633: => pay_ppm_shd.g_old_rec.ppm_information27
634: ,p_ppm_information28_o
635: => pay_ppm_shd.g_old_rec.ppm_information28
629: => pay_ppm_shd.g_old_rec.ppm_information25
630: ,p_ppm_information26_o
631: => pay_ppm_shd.g_old_rec.ppm_information26
632: ,p_ppm_information27_o
633: => pay_ppm_shd.g_old_rec.ppm_information27
634: ,p_ppm_information28_o
635: => pay_ppm_shd.g_old_rec.ppm_information28
636: ,p_ppm_information29_o
637: => pay_ppm_shd.g_old_rec.ppm_information29
631: => pay_ppm_shd.g_old_rec.ppm_information26
632: ,p_ppm_information27_o
633: => pay_ppm_shd.g_old_rec.ppm_information27
634: ,p_ppm_information28_o
635: => pay_ppm_shd.g_old_rec.ppm_information28
636: ,p_ppm_information29_o
637: => pay_ppm_shd.g_old_rec.ppm_information29
638: ,p_ppm_information30_o
639: => pay_ppm_shd.g_old_rec.ppm_information30
633: => pay_ppm_shd.g_old_rec.ppm_information27
634: ,p_ppm_information28_o
635: => pay_ppm_shd.g_old_rec.ppm_information28
636: ,p_ppm_information29_o
637: => pay_ppm_shd.g_old_rec.ppm_information29
638: ,p_ppm_information30_o
639: => pay_ppm_shd.g_old_rec.ppm_information30
640: );
641: exception
635: => pay_ppm_shd.g_old_rec.ppm_information28
636: ,p_ppm_information29_o
637: => pay_ppm_shd.g_old_rec.ppm_information29
638: ,p_ppm_information30_o
639: => pay_ppm_shd.g_old_rec.ppm_information30
640: );
641: exception
642: when hr_api.cannot_find_prog_unit then
643: hr_api.cannot_find_prog_unit_error
653: -- ----------------------------------------------------------------------------
654: -- |-----------------------------< convert_defs >-----------------------------|
655: -- ----------------------------------------------------------------------------
656: --
657: procedure convert_defs(p_rec in out nocopy pay_ppm_shd.g_rec_type) is
658: --
659: l_proc varchar2(72) := g_package||'convert_defs';
660: --
661: Begin
668: -- is being used then we must set to the 'current' argument value.
669: --
670: If (p_rec.business_group_id = hr_api.g_number) then
671: p_rec.business_group_id :=
672: pay_ppm_shd.g_old_rec.business_group_id;
673: End If;
674: If (p_rec.external_account_id = hr_api.g_number) then
675: p_rec.external_account_id :=
676: pay_ppm_shd.g_old_rec.external_account_id;
672: pay_ppm_shd.g_old_rec.business_group_id;
673: End If;
674: If (p_rec.external_account_id = hr_api.g_number) then
675: p_rec.external_account_id :=
676: pay_ppm_shd.g_old_rec.external_account_id;
677: End If;
678: If (p_rec.assignment_id = hr_api.g_number) then
679: p_rec.assignment_id :=
680: pay_ppm_shd.g_old_rec.assignment_id;
676: pay_ppm_shd.g_old_rec.external_account_id;
677: End If;
678: If (p_rec.assignment_id = hr_api.g_number) then
679: p_rec.assignment_id :=
680: pay_ppm_shd.g_old_rec.assignment_id;
681: End If;
682: If (p_rec.run_Type_id = hr_api.g_number) then
683: p_rec.run_Type_id :=
684: pay_ppm_shd.g_old_rec.run_Type_id;
680: pay_ppm_shd.g_old_rec.assignment_id;
681: End If;
682: If (p_rec.run_Type_id = hr_api.g_number) then
683: p_rec.run_Type_id :=
684: pay_ppm_shd.g_old_rec.run_Type_id;
685: End If;
686: If (p_rec.org_payment_method_id = hr_api.g_number) then
687: p_rec.org_payment_method_id :=
688: pay_ppm_shd.g_old_rec.org_payment_method_id;
684: pay_ppm_shd.g_old_rec.run_Type_id;
685: End If;
686: If (p_rec.org_payment_method_id = hr_api.g_number) then
687: p_rec.org_payment_method_id :=
688: pay_ppm_shd.g_old_rec.org_payment_method_id;
689: End If;
690: If (p_rec.amount = hr_api.g_number) then
691: p_rec.amount :=
692: pay_ppm_shd.g_old_rec.amount;
688: pay_ppm_shd.g_old_rec.org_payment_method_id;
689: End If;
690: If (p_rec.amount = hr_api.g_number) then
691: p_rec.amount :=
692: pay_ppm_shd.g_old_rec.amount;
693: End If;
694: If (p_rec.comment_id = hr_api.g_number) then
695: p_rec.comment_id :=
696: pay_ppm_shd.g_old_rec.comment_id;
692: pay_ppm_shd.g_old_rec.amount;
693: End If;
694: If (p_rec.comment_id = hr_api.g_number) then
695: p_rec.comment_id :=
696: pay_ppm_shd.g_old_rec.comment_id;
697: End If;
698: If (p_rec.comments = hr_api.g_varchar2) then
699: p_rec.comments :=
700: pay_ppm_shd.g_old_rec.comments;
696: pay_ppm_shd.g_old_rec.comment_id;
697: End If;
698: If (p_rec.comments = hr_api.g_varchar2) then
699: p_rec.comments :=
700: pay_ppm_shd.g_old_rec.comments;
701: End If;
702: If (p_rec.percentage = hr_api.g_number) then
703: p_rec.percentage :=
704: pay_ppm_shd.g_old_rec.percentage;
700: pay_ppm_shd.g_old_rec.comments;
701: End If;
702: If (p_rec.percentage = hr_api.g_number) then
703: p_rec.percentage :=
704: pay_ppm_shd.g_old_rec.percentage;
705: End If;
706: If (p_rec.priority = hr_api.g_number) then
707: p_rec.priority :=
708: pay_ppm_shd.g_old_rec.priority;
704: pay_ppm_shd.g_old_rec.percentage;
705: End If;
706: If (p_rec.priority = hr_api.g_number) then
707: p_rec.priority :=
708: pay_ppm_shd.g_old_rec.priority;
709: End If;
710: If (p_rec.attribute_category = hr_api.g_varchar2) then
711: p_rec.attribute_category :=
712: pay_ppm_shd.g_old_rec.attribute_category;
708: pay_ppm_shd.g_old_rec.priority;
709: End If;
710: If (p_rec.attribute_category = hr_api.g_varchar2) then
711: p_rec.attribute_category :=
712: pay_ppm_shd.g_old_rec.attribute_category;
713: End If;
714: If (p_rec.attribute1 = hr_api.g_varchar2) then
715: p_rec.attribute1 :=
716: pay_ppm_shd.g_old_rec.attribute1;
712: pay_ppm_shd.g_old_rec.attribute_category;
713: End If;
714: If (p_rec.attribute1 = hr_api.g_varchar2) then
715: p_rec.attribute1 :=
716: pay_ppm_shd.g_old_rec.attribute1;
717: End If;
718: If (p_rec.attribute2 = hr_api.g_varchar2) then
719: p_rec.attribute2 :=
720: pay_ppm_shd.g_old_rec.attribute2;
716: pay_ppm_shd.g_old_rec.attribute1;
717: End If;
718: If (p_rec.attribute2 = hr_api.g_varchar2) then
719: p_rec.attribute2 :=
720: pay_ppm_shd.g_old_rec.attribute2;
721: End If;
722: If (p_rec.attribute3 = hr_api.g_varchar2) then
723: p_rec.attribute3 :=
724: pay_ppm_shd.g_old_rec.attribute3;
720: pay_ppm_shd.g_old_rec.attribute2;
721: End If;
722: If (p_rec.attribute3 = hr_api.g_varchar2) then
723: p_rec.attribute3 :=
724: pay_ppm_shd.g_old_rec.attribute3;
725: End If;
726: If (p_rec.attribute4 = hr_api.g_varchar2) then
727: p_rec.attribute4 :=
728: pay_ppm_shd.g_old_rec.attribute4;
724: pay_ppm_shd.g_old_rec.attribute3;
725: End If;
726: If (p_rec.attribute4 = hr_api.g_varchar2) then
727: p_rec.attribute4 :=
728: pay_ppm_shd.g_old_rec.attribute4;
729: End If;
730: If (p_rec.attribute5 = hr_api.g_varchar2) then
731: p_rec.attribute5 :=
732: pay_ppm_shd.g_old_rec.attribute5;
728: pay_ppm_shd.g_old_rec.attribute4;
729: End If;
730: If (p_rec.attribute5 = hr_api.g_varchar2) then
731: p_rec.attribute5 :=
732: pay_ppm_shd.g_old_rec.attribute5;
733: End If;
734: If (p_rec.attribute6 = hr_api.g_varchar2) then
735: p_rec.attribute6 :=
736: pay_ppm_shd.g_old_rec.attribute6;
732: pay_ppm_shd.g_old_rec.attribute5;
733: End If;
734: If (p_rec.attribute6 = hr_api.g_varchar2) then
735: p_rec.attribute6 :=
736: pay_ppm_shd.g_old_rec.attribute6;
737: End If;
738: If (p_rec.attribute7 = hr_api.g_varchar2) then
739: p_rec.attribute7 :=
740: pay_ppm_shd.g_old_rec.attribute7;
736: pay_ppm_shd.g_old_rec.attribute6;
737: End If;
738: If (p_rec.attribute7 = hr_api.g_varchar2) then
739: p_rec.attribute7 :=
740: pay_ppm_shd.g_old_rec.attribute7;
741: End If;
742: If (p_rec.attribute8 = hr_api.g_varchar2) then
743: p_rec.attribute8 :=
744: pay_ppm_shd.g_old_rec.attribute8;
740: pay_ppm_shd.g_old_rec.attribute7;
741: End If;
742: If (p_rec.attribute8 = hr_api.g_varchar2) then
743: p_rec.attribute8 :=
744: pay_ppm_shd.g_old_rec.attribute8;
745: End If;
746: If (p_rec.attribute9 = hr_api.g_varchar2) then
747: p_rec.attribute9 :=
748: pay_ppm_shd.g_old_rec.attribute9;
744: pay_ppm_shd.g_old_rec.attribute8;
745: End If;
746: If (p_rec.attribute9 = hr_api.g_varchar2) then
747: p_rec.attribute9 :=
748: pay_ppm_shd.g_old_rec.attribute9;
749: End If;
750: If (p_rec.attribute10 = hr_api.g_varchar2) then
751: p_rec.attribute10 :=
752: pay_ppm_shd.g_old_rec.attribute10;
748: pay_ppm_shd.g_old_rec.attribute9;
749: End If;
750: If (p_rec.attribute10 = hr_api.g_varchar2) then
751: p_rec.attribute10 :=
752: pay_ppm_shd.g_old_rec.attribute10;
753: End If;
754: If (p_rec.attribute11 = hr_api.g_varchar2) then
755: p_rec.attribute11 :=
756: pay_ppm_shd.g_old_rec.attribute11;
752: pay_ppm_shd.g_old_rec.attribute10;
753: End If;
754: If (p_rec.attribute11 = hr_api.g_varchar2) then
755: p_rec.attribute11 :=
756: pay_ppm_shd.g_old_rec.attribute11;
757: End If;
758: If (p_rec.attribute12 = hr_api.g_varchar2) then
759: p_rec.attribute12 :=
760: pay_ppm_shd.g_old_rec.attribute12;
756: pay_ppm_shd.g_old_rec.attribute11;
757: End If;
758: If (p_rec.attribute12 = hr_api.g_varchar2) then
759: p_rec.attribute12 :=
760: pay_ppm_shd.g_old_rec.attribute12;
761: End If;
762: If (p_rec.attribute13 = hr_api.g_varchar2) then
763: p_rec.attribute13 :=
764: pay_ppm_shd.g_old_rec.attribute13;
760: pay_ppm_shd.g_old_rec.attribute12;
761: End If;
762: If (p_rec.attribute13 = hr_api.g_varchar2) then
763: p_rec.attribute13 :=
764: pay_ppm_shd.g_old_rec.attribute13;
765: End If;
766: If (p_rec.attribute14 = hr_api.g_varchar2) then
767: p_rec.attribute14 :=
768: pay_ppm_shd.g_old_rec.attribute14;
764: pay_ppm_shd.g_old_rec.attribute13;
765: End If;
766: If (p_rec.attribute14 = hr_api.g_varchar2) then
767: p_rec.attribute14 :=
768: pay_ppm_shd.g_old_rec.attribute14;
769: End If;
770: If (p_rec.attribute15 = hr_api.g_varchar2) then
771: p_rec.attribute15 :=
772: pay_ppm_shd.g_old_rec.attribute15;
768: pay_ppm_shd.g_old_rec.attribute14;
769: End If;
770: If (p_rec.attribute15 = hr_api.g_varchar2) then
771: p_rec.attribute15 :=
772: pay_ppm_shd.g_old_rec.attribute15;
773: End If;
774: If (p_rec.attribute16 = hr_api.g_varchar2) then
775: p_rec.attribute16 :=
776: pay_ppm_shd.g_old_rec.attribute16;
772: pay_ppm_shd.g_old_rec.attribute15;
773: End If;
774: If (p_rec.attribute16 = hr_api.g_varchar2) then
775: p_rec.attribute16 :=
776: pay_ppm_shd.g_old_rec.attribute16;
777: End If;
778: If (p_rec.attribute17 = hr_api.g_varchar2) then
779: p_rec.attribute17 :=
780: pay_ppm_shd.g_old_rec.attribute17;
776: pay_ppm_shd.g_old_rec.attribute16;
777: End If;
778: If (p_rec.attribute17 = hr_api.g_varchar2) then
779: p_rec.attribute17 :=
780: pay_ppm_shd.g_old_rec.attribute17;
781: End If;
782: If (p_rec.attribute18 = hr_api.g_varchar2) then
783: p_rec.attribute18 :=
784: pay_ppm_shd.g_old_rec.attribute18;
780: pay_ppm_shd.g_old_rec.attribute17;
781: End If;
782: If (p_rec.attribute18 = hr_api.g_varchar2) then
783: p_rec.attribute18 :=
784: pay_ppm_shd.g_old_rec.attribute18;
785: End If;
786: If (p_rec.attribute19 = hr_api.g_varchar2) then
787: p_rec.attribute19 :=
788: pay_ppm_shd.g_old_rec.attribute19;
784: pay_ppm_shd.g_old_rec.attribute18;
785: End If;
786: If (p_rec.attribute19 = hr_api.g_varchar2) then
787: p_rec.attribute19 :=
788: pay_ppm_shd.g_old_rec.attribute19;
789: End If;
790: If (p_rec.attribute20 = hr_api.g_varchar2) then
791: p_rec.attribute20 :=
792: pay_ppm_shd.g_old_rec.attribute20;
788: pay_ppm_shd.g_old_rec.attribute19;
789: End If;
790: If (p_rec.attribute20 = hr_api.g_varchar2) then
791: p_rec.attribute20 :=
792: pay_ppm_shd.g_old_rec.attribute20;
793: End If;
794: If (p_rec.payee_type = hr_api.g_varchar2) then
795: p_rec.payee_type :=
796: pay_ppm_shd.g_old_rec.payee_type;
792: pay_ppm_shd.g_old_rec.attribute20;
793: End If;
794: If (p_rec.payee_type = hr_api.g_varchar2) then
795: p_rec.payee_type :=
796: pay_ppm_shd.g_old_rec.payee_type;
797: End If;
798: If (p_rec.payee_id = hr_api.g_number) then
799: p_rec.payee_id :=
800: pay_ppm_shd.g_old_rec.payee_id;
796: pay_ppm_shd.g_old_rec.payee_type;
797: End If;
798: If (p_rec.payee_id = hr_api.g_number) then
799: p_rec.payee_id :=
800: pay_ppm_shd.g_old_rec.payee_id;
801: End If;
802: If (p_rec.ppm_information_category = hr_api.g_varchar2) then
803: p_rec.ppm_information_category :=
804: pay_ppm_shd.g_old_rec.ppm_information_category;
800: pay_ppm_shd.g_old_rec.payee_id;
801: End If;
802: If (p_rec.ppm_information_category = hr_api.g_varchar2) then
803: p_rec.ppm_information_category :=
804: pay_ppm_shd.g_old_rec.ppm_information_category;
805: End If;
806: If (p_rec.ppm_information1 = hr_api.g_varchar2) then
807: p_rec.ppm_information1 :=
808: pay_ppm_shd.g_old_rec.ppm_information1;
804: pay_ppm_shd.g_old_rec.ppm_information_category;
805: End If;
806: If (p_rec.ppm_information1 = hr_api.g_varchar2) then
807: p_rec.ppm_information1 :=
808: pay_ppm_shd.g_old_rec.ppm_information1;
809: End If;
810: If (p_rec.ppm_information2 = hr_api.g_varchar2) then
811: p_rec.ppm_information2 :=
812: pay_ppm_shd.g_old_rec.ppm_information2;
808: pay_ppm_shd.g_old_rec.ppm_information1;
809: End If;
810: If (p_rec.ppm_information2 = hr_api.g_varchar2) then
811: p_rec.ppm_information2 :=
812: pay_ppm_shd.g_old_rec.ppm_information2;
813: End If;
814: If (p_rec.ppm_information3 = hr_api.g_varchar2) then
815: p_rec.ppm_information3 :=
816: pay_ppm_shd.g_old_rec.ppm_information3;
812: pay_ppm_shd.g_old_rec.ppm_information2;
813: End If;
814: If (p_rec.ppm_information3 = hr_api.g_varchar2) then
815: p_rec.ppm_information3 :=
816: pay_ppm_shd.g_old_rec.ppm_information3;
817: End If;
818: If (p_rec.ppm_information4 = hr_api.g_varchar2) then
819: p_rec.ppm_information4 :=
820: pay_ppm_shd.g_old_rec.ppm_information4;
816: pay_ppm_shd.g_old_rec.ppm_information3;
817: End If;
818: If (p_rec.ppm_information4 = hr_api.g_varchar2) then
819: p_rec.ppm_information4 :=
820: pay_ppm_shd.g_old_rec.ppm_information4;
821: End If;
822: If (p_rec.ppm_information5 = hr_api.g_varchar2) then
823: p_rec.ppm_information5 :=
824: pay_ppm_shd.g_old_rec.ppm_information5;
820: pay_ppm_shd.g_old_rec.ppm_information4;
821: End If;
822: If (p_rec.ppm_information5 = hr_api.g_varchar2) then
823: p_rec.ppm_information5 :=
824: pay_ppm_shd.g_old_rec.ppm_information5;
825: End If;
826: If (p_rec.ppm_information6 = hr_api.g_varchar2) then
827: p_rec.ppm_information6 :=
828: pay_ppm_shd.g_old_rec.ppm_information6;
824: pay_ppm_shd.g_old_rec.ppm_information5;
825: End If;
826: If (p_rec.ppm_information6 = hr_api.g_varchar2) then
827: p_rec.ppm_information6 :=
828: pay_ppm_shd.g_old_rec.ppm_information6;
829: End If;
830: If (p_rec.ppm_information7 = hr_api.g_varchar2) then
831: p_rec.ppm_information7 :=
832: pay_ppm_shd.g_old_rec.ppm_information7;
828: pay_ppm_shd.g_old_rec.ppm_information6;
829: End If;
830: If (p_rec.ppm_information7 = hr_api.g_varchar2) then
831: p_rec.ppm_information7 :=
832: pay_ppm_shd.g_old_rec.ppm_information7;
833: End If;
834: If (p_rec.ppm_information8 = hr_api.g_varchar2) then
835: p_rec.ppm_information8 :=
836: pay_ppm_shd.g_old_rec.ppm_information8;
832: pay_ppm_shd.g_old_rec.ppm_information7;
833: End If;
834: If (p_rec.ppm_information8 = hr_api.g_varchar2) then
835: p_rec.ppm_information8 :=
836: pay_ppm_shd.g_old_rec.ppm_information8;
837: End If;
838: If (p_rec.ppm_information9 = hr_api.g_varchar2) then
839: p_rec.ppm_information9 :=
840: pay_ppm_shd.g_old_rec.ppm_information9;
836: pay_ppm_shd.g_old_rec.ppm_information8;
837: End If;
838: If (p_rec.ppm_information9 = hr_api.g_varchar2) then
839: p_rec.ppm_information9 :=
840: pay_ppm_shd.g_old_rec.ppm_information9;
841: End If;
842: If (p_rec.ppm_information10 = hr_api.g_varchar2) then
843: p_rec.ppm_information10 :=
844: pay_ppm_shd.g_old_rec.ppm_information10;
840: pay_ppm_shd.g_old_rec.ppm_information9;
841: End If;
842: If (p_rec.ppm_information10 = hr_api.g_varchar2) then
843: p_rec.ppm_information10 :=
844: pay_ppm_shd.g_old_rec.ppm_information10;
845: End If;
846: If (p_rec.ppm_information11 = hr_api.g_varchar2) then
847: p_rec.ppm_information11 :=
848: pay_ppm_shd.g_old_rec.ppm_information11;
844: pay_ppm_shd.g_old_rec.ppm_information10;
845: End If;
846: If (p_rec.ppm_information11 = hr_api.g_varchar2) then
847: p_rec.ppm_information11 :=
848: pay_ppm_shd.g_old_rec.ppm_information11;
849: End If;
850: If (p_rec.ppm_information12 = hr_api.g_varchar2) then
851: p_rec.ppm_information12 :=
852: pay_ppm_shd.g_old_rec.ppm_information12;
848: pay_ppm_shd.g_old_rec.ppm_information11;
849: End If;
850: If (p_rec.ppm_information12 = hr_api.g_varchar2) then
851: p_rec.ppm_information12 :=
852: pay_ppm_shd.g_old_rec.ppm_information12;
853: End If;
854: If (p_rec.ppm_information13 = hr_api.g_varchar2) then
855: p_rec.ppm_information13 :=
856: pay_ppm_shd.g_old_rec.ppm_information13;
852: pay_ppm_shd.g_old_rec.ppm_information12;
853: End If;
854: If (p_rec.ppm_information13 = hr_api.g_varchar2) then
855: p_rec.ppm_information13 :=
856: pay_ppm_shd.g_old_rec.ppm_information13;
857: End If;
858: If (p_rec.ppm_information14 = hr_api.g_varchar2) then
859: p_rec.ppm_information14 :=
860: pay_ppm_shd.g_old_rec.ppm_information14;
856: pay_ppm_shd.g_old_rec.ppm_information13;
857: End If;
858: If (p_rec.ppm_information14 = hr_api.g_varchar2) then
859: p_rec.ppm_information14 :=
860: pay_ppm_shd.g_old_rec.ppm_information14;
861: End If;
862: If (p_rec.ppm_information15 = hr_api.g_varchar2) then
863: p_rec.ppm_information15 :=
864: pay_ppm_shd.g_old_rec.ppm_information15;
860: pay_ppm_shd.g_old_rec.ppm_information14;
861: End If;
862: If (p_rec.ppm_information15 = hr_api.g_varchar2) then
863: p_rec.ppm_information15 :=
864: pay_ppm_shd.g_old_rec.ppm_information15;
865: End If;
866: If (p_rec.ppm_information16 = hr_api.g_varchar2) then
867: p_rec.ppm_information16 :=
868: pay_ppm_shd.g_old_rec.ppm_information16;
864: pay_ppm_shd.g_old_rec.ppm_information15;
865: End If;
866: If (p_rec.ppm_information16 = hr_api.g_varchar2) then
867: p_rec.ppm_information16 :=
868: pay_ppm_shd.g_old_rec.ppm_information16;
869: End If;
870: If (p_rec.ppm_information17 = hr_api.g_varchar2) then
871: p_rec.ppm_information17 :=
872: pay_ppm_shd.g_old_rec.ppm_information17;
868: pay_ppm_shd.g_old_rec.ppm_information16;
869: End If;
870: If (p_rec.ppm_information17 = hr_api.g_varchar2) then
871: p_rec.ppm_information17 :=
872: pay_ppm_shd.g_old_rec.ppm_information17;
873: End If;
874: If (p_rec.ppm_information18 = hr_api.g_varchar2) then
875: p_rec.ppm_information18 :=
876: pay_ppm_shd.g_old_rec.ppm_information18;
872: pay_ppm_shd.g_old_rec.ppm_information17;
873: End If;
874: If (p_rec.ppm_information18 = hr_api.g_varchar2) then
875: p_rec.ppm_information18 :=
876: pay_ppm_shd.g_old_rec.ppm_information18;
877: End If;
878: If (p_rec.ppm_information19 = hr_api.g_varchar2) then
879: p_rec.ppm_information19 :=
880: pay_ppm_shd.g_old_rec.ppm_information19;
876: pay_ppm_shd.g_old_rec.ppm_information18;
877: End If;
878: If (p_rec.ppm_information19 = hr_api.g_varchar2) then
879: p_rec.ppm_information19 :=
880: pay_ppm_shd.g_old_rec.ppm_information19;
881: End If;
882: If (p_rec.ppm_information20 = hr_api.g_varchar2) then
883: p_rec.ppm_information20 :=
884: pay_ppm_shd.g_old_rec.ppm_information20;
880: pay_ppm_shd.g_old_rec.ppm_information19;
881: End If;
882: If (p_rec.ppm_information20 = hr_api.g_varchar2) then
883: p_rec.ppm_information20 :=
884: pay_ppm_shd.g_old_rec.ppm_information20;
885: End If;
886: If (p_rec.ppm_information21 = hr_api.g_varchar2) then
887: p_rec.ppm_information21 :=
888: pay_ppm_shd.g_old_rec.ppm_information21;
884: pay_ppm_shd.g_old_rec.ppm_information20;
885: End If;
886: If (p_rec.ppm_information21 = hr_api.g_varchar2) then
887: p_rec.ppm_information21 :=
888: pay_ppm_shd.g_old_rec.ppm_information21;
889: End If;
890: If (p_rec.ppm_information22 = hr_api.g_varchar2) then
891: p_rec.ppm_information22 :=
892: pay_ppm_shd.g_old_rec.ppm_information22;
888: pay_ppm_shd.g_old_rec.ppm_information21;
889: End If;
890: If (p_rec.ppm_information22 = hr_api.g_varchar2) then
891: p_rec.ppm_information22 :=
892: pay_ppm_shd.g_old_rec.ppm_information22;
893: End If;
894: If (p_rec.ppm_information23 = hr_api.g_varchar2) then
895: p_rec.ppm_information23 :=
896: pay_ppm_shd.g_old_rec.ppm_information23;
892: pay_ppm_shd.g_old_rec.ppm_information22;
893: End If;
894: If (p_rec.ppm_information23 = hr_api.g_varchar2) then
895: p_rec.ppm_information23 :=
896: pay_ppm_shd.g_old_rec.ppm_information23;
897: End If;
898: If (p_rec.ppm_information24 = hr_api.g_varchar2) then
899: p_rec.ppm_information24 :=
900: pay_ppm_shd.g_old_rec.ppm_information24;
896: pay_ppm_shd.g_old_rec.ppm_information23;
897: End If;
898: If (p_rec.ppm_information24 = hr_api.g_varchar2) then
899: p_rec.ppm_information24 :=
900: pay_ppm_shd.g_old_rec.ppm_information24;
901: End If;
902: If (p_rec.ppm_information25 = hr_api.g_varchar2) then
903: p_rec.ppm_information25 :=
904: pay_ppm_shd.g_old_rec.ppm_information25;
900: pay_ppm_shd.g_old_rec.ppm_information24;
901: End If;
902: If (p_rec.ppm_information25 = hr_api.g_varchar2) then
903: p_rec.ppm_information25 :=
904: pay_ppm_shd.g_old_rec.ppm_information25;
905: End If;
906: If (p_rec.ppm_information26 = hr_api.g_varchar2) then
907: p_rec.ppm_information26 :=
908: pay_ppm_shd.g_old_rec.ppm_information26;
904: pay_ppm_shd.g_old_rec.ppm_information25;
905: End If;
906: If (p_rec.ppm_information26 = hr_api.g_varchar2) then
907: p_rec.ppm_information26 :=
908: pay_ppm_shd.g_old_rec.ppm_information26;
909: End If;
910: If (p_rec.ppm_information27 = hr_api.g_varchar2) then
911: p_rec.ppm_information27 :=
912: pay_ppm_shd.g_old_rec.ppm_information27;
908: pay_ppm_shd.g_old_rec.ppm_information26;
909: End If;
910: If (p_rec.ppm_information27 = hr_api.g_varchar2) then
911: p_rec.ppm_information27 :=
912: pay_ppm_shd.g_old_rec.ppm_information27;
913: End If;
914: If (p_rec.ppm_information28 = hr_api.g_varchar2) then
915: p_rec.ppm_information28 :=
916: pay_ppm_shd.g_old_rec.ppm_information28;
912: pay_ppm_shd.g_old_rec.ppm_information27;
913: End If;
914: If (p_rec.ppm_information28 = hr_api.g_varchar2) then
915: p_rec.ppm_information28 :=
916: pay_ppm_shd.g_old_rec.ppm_information28;
917: End If;
918: If (p_rec.ppm_information29 = hr_api.g_varchar2) then
919: p_rec.ppm_information29 :=
920: pay_ppm_shd.g_old_rec.ppm_information29;
916: pay_ppm_shd.g_old_rec.ppm_information28;
917: End If;
918: If (p_rec.ppm_information29 = hr_api.g_varchar2) then
919: p_rec.ppm_information29 :=
920: pay_ppm_shd.g_old_rec.ppm_information29;
921: End If;
922: If (p_rec.ppm_information30 = hr_api.g_varchar2) then
923: p_rec.ppm_information30 :=
924: pay_ppm_shd.g_old_rec.ppm_information30;
920: pay_ppm_shd.g_old_rec.ppm_information29;
921: End If;
922: If (p_rec.ppm_information30 = hr_api.g_varchar2) then
923: p_rec.ppm_information30 :=
924: pay_ppm_shd.g_old_rec.ppm_information30;
925: End If;
926: --
927: -- Return the plsql record structure.
928: --
934: -- |---------------------------------< upd >----------------------------------|
935: -- ----------------------------------------------------------------------------
936: Procedure upd
937: (
938: p_rec in out nocopy pay_ppm_shd.g_rec_type,
939: p_effective_date in date,
940: p_datetrack_mode in varchar2,
941: p_validate in boolean default false
942: ) is
969: End If;
970: --
971: -- We must lock the row which we need to update.
972: --
973: pay_ppm_shd.lck
974: (p_effective_date => p_effective_date,
975: p_datetrack_mode => p_datetrack_mode,
976: p_personal_payment_method_id => p_rec.personal_payment_method_id,
977: p_object_version_number => p_rec.object_version_number,
1113: p_ppm_information29 in varchar2 default hr_api.g_varchar2,
1114: p_ppm_information30 in varchar2 default hr_api.g_varchar2
1115: ) is
1116: --
1117: l_rec pay_ppm_shd.g_rec_type;
1118: l_proc varchar2(72) := g_package||'upd';
1119: --
1120: Begin
1121: hr_utility.set_location('Entering:'||l_proc, 5);
1123: -- Call conversion function to turn arguments into the
1124: -- l_rec structure.
1125: --
1126: l_rec :=
1127: pay_ppm_shd.convert_args
1128: (
1129: p_personal_payment_method_id,
1130: null,
1131: null,