[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_btl_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: pay_btl_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the pay_batch_lines Row
69: --
70: update pay_batch_lines
185: ,effective_end_date = p_rec.effective_end_date
186: ,object_version_number = p_rec.object_version_number
187: where batch_line_id = p_rec.batch_line_id;
188: --
189: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: --
193: Exception
192: --
193: Exception
194: When hr_api.check_integrity_violated Then
195: -- A check constraint has been violated
196: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
197: pay_btl_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.parent_integrity_violated Then
200: -- Parent integrity has been violated
193: Exception
194: When hr_api.check_integrity_violated Then
195: -- A check constraint has been violated
196: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
197: pay_btl_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.parent_integrity_violated Then
200: -- Parent integrity has been violated
201: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
197: pay_btl_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.parent_integrity_violated Then
200: -- Parent integrity has been violated
201: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
202: pay_btl_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.parent_integrity_violated Then
200: -- Parent integrity has been violated
201: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
202: pay_btl_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
202: pay_btl_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
207: pay_btl_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When Others Then
210: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
207: pay_btl_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When Others Then
210: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
211: Raise;
206: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
207: pay_btl_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When Others Then
210: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
211: Raise;
212: End update_dml;
213: --
214: -- ----------------------------------------------------------------------------
243: --
244: -- {End Of Comments}
245: -- ----------------------------------------------------------------------------
246: Procedure pre_update
247: (p_rec in pay_btl_shd.g_rec_type
248: ) is
249: --
250: l_proc varchar2(72) := g_package||'pre_update';
251: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure post_update
291: (p_session_date in date
292: ,p_rec in pay_btl_shd.g_rec_type
293: ) is
294: --
295: l_proc varchar2(72) := g_package||'post_update';
296: --
531: => p_rec.effective_end_date
532: ,p_object_version_number
533: => p_rec.object_version_number
534: ,p_cost_allocation_keyflex_id_o
535: => pay_btl_shd.g_old_rec.cost_allocation_keyflex_id
536: ,p_element_type_id_o
537: => pay_btl_shd.g_old_rec.element_type_id
538: ,p_assignment_id_o
539: => pay_btl_shd.g_old_rec.assignment_id
533: => p_rec.object_version_number
534: ,p_cost_allocation_keyflex_id_o
535: => pay_btl_shd.g_old_rec.cost_allocation_keyflex_id
536: ,p_element_type_id_o
537: => pay_btl_shd.g_old_rec.element_type_id
538: ,p_assignment_id_o
539: => pay_btl_shd.g_old_rec.assignment_id
540: ,p_batch_id_o
541: => pay_btl_shd.g_old_rec.batch_id
535: => pay_btl_shd.g_old_rec.cost_allocation_keyflex_id
536: ,p_element_type_id_o
537: => pay_btl_shd.g_old_rec.element_type_id
538: ,p_assignment_id_o
539: => pay_btl_shd.g_old_rec.assignment_id
540: ,p_batch_id_o
541: => pay_btl_shd.g_old_rec.batch_id
542: ,p_batch_line_status_o
543: => pay_btl_shd.g_old_rec.batch_line_status
537: => pay_btl_shd.g_old_rec.element_type_id
538: ,p_assignment_id_o
539: => pay_btl_shd.g_old_rec.assignment_id
540: ,p_batch_id_o
541: => pay_btl_shd.g_old_rec.batch_id
542: ,p_batch_line_status_o
543: => pay_btl_shd.g_old_rec.batch_line_status
544: ,p_assignment_number_o
545: => pay_btl_shd.g_old_rec.assignment_number
539: => pay_btl_shd.g_old_rec.assignment_id
540: ,p_batch_id_o
541: => pay_btl_shd.g_old_rec.batch_id
542: ,p_batch_line_status_o
543: => pay_btl_shd.g_old_rec.batch_line_status
544: ,p_assignment_number_o
545: => pay_btl_shd.g_old_rec.assignment_number
546: ,p_batch_sequence_o
547: => pay_btl_shd.g_old_rec.batch_sequence
541: => pay_btl_shd.g_old_rec.batch_id
542: ,p_batch_line_status_o
543: => pay_btl_shd.g_old_rec.batch_line_status
544: ,p_assignment_number_o
545: => pay_btl_shd.g_old_rec.assignment_number
546: ,p_batch_sequence_o
547: => pay_btl_shd.g_old_rec.batch_sequence
548: ,p_concatenated_segments_o
549: => pay_btl_shd.g_old_rec.concatenated_segments
543: => pay_btl_shd.g_old_rec.batch_line_status
544: ,p_assignment_number_o
545: => pay_btl_shd.g_old_rec.assignment_number
546: ,p_batch_sequence_o
547: => pay_btl_shd.g_old_rec.batch_sequence
548: ,p_concatenated_segments_o
549: => pay_btl_shd.g_old_rec.concatenated_segments
550: ,p_effective_date_o
551: => pay_btl_shd.g_old_rec.effective_date
545: => pay_btl_shd.g_old_rec.assignment_number
546: ,p_batch_sequence_o
547: => pay_btl_shd.g_old_rec.batch_sequence
548: ,p_concatenated_segments_o
549: => pay_btl_shd.g_old_rec.concatenated_segments
550: ,p_effective_date_o
551: => pay_btl_shd.g_old_rec.effective_date
552: ,p_element_name_o
553: => pay_btl_shd.g_old_rec.element_name
547: => pay_btl_shd.g_old_rec.batch_sequence
548: ,p_concatenated_segments_o
549: => pay_btl_shd.g_old_rec.concatenated_segments
550: ,p_effective_date_o
551: => pay_btl_shd.g_old_rec.effective_date
552: ,p_element_name_o
553: => pay_btl_shd.g_old_rec.element_name
554: ,p_entry_type_o
555: => pay_btl_shd.g_old_rec.entry_type
549: => pay_btl_shd.g_old_rec.concatenated_segments
550: ,p_effective_date_o
551: => pay_btl_shd.g_old_rec.effective_date
552: ,p_element_name_o
553: => pay_btl_shd.g_old_rec.element_name
554: ,p_entry_type_o
555: => pay_btl_shd.g_old_rec.entry_type
556: ,p_reason_o
557: => pay_btl_shd.g_old_rec.reason
551: => pay_btl_shd.g_old_rec.effective_date
552: ,p_element_name_o
553: => pay_btl_shd.g_old_rec.element_name
554: ,p_entry_type_o
555: => pay_btl_shd.g_old_rec.entry_type
556: ,p_reason_o
557: => pay_btl_shd.g_old_rec.reason
558: ,p_segment1_o
559: => pay_btl_shd.g_old_rec.segment1
553: => pay_btl_shd.g_old_rec.element_name
554: ,p_entry_type_o
555: => pay_btl_shd.g_old_rec.entry_type
556: ,p_reason_o
557: => pay_btl_shd.g_old_rec.reason
558: ,p_segment1_o
559: => pay_btl_shd.g_old_rec.segment1
560: ,p_segment2_o
561: => pay_btl_shd.g_old_rec.segment2
555: => pay_btl_shd.g_old_rec.entry_type
556: ,p_reason_o
557: => pay_btl_shd.g_old_rec.reason
558: ,p_segment1_o
559: => pay_btl_shd.g_old_rec.segment1
560: ,p_segment2_o
561: => pay_btl_shd.g_old_rec.segment2
562: ,p_segment3_o
563: => pay_btl_shd.g_old_rec.segment3
557: => pay_btl_shd.g_old_rec.reason
558: ,p_segment1_o
559: => pay_btl_shd.g_old_rec.segment1
560: ,p_segment2_o
561: => pay_btl_shd.g_old_rec.segment2
562: ,p_segment3_o
563: => pay_btl_shd.g_old_rec.segment3
564: ,p_segment4_o
565: => pay_btl_shd.g_old_rec.segment4
559: => pay_btl_shd.g_old_rec.segment1
560: ,p_segment2_o
561: => pay_btl_shd.g_old_rec.segment2
562: ,p_segment3_o
563: => pay_btl_shd.g_old_rec.segment3
564: ,p_segment4_o
565: => pay_btl_shd.g_old_rec.segment4
566: ,p_segment5_o
567: => pay_btl_shd.g_old_rec.segment5
561: => pay_btl_shd.g_old_rec.segment2
562: ,p_segment3_o
563: => pay_btl_shd.g_old_rec.segment3
564: ,p_segment4_o
565: => pay_btl_shd.g_old_rec.segment4
566: ,p_segment5_o
567: => pay_btl_shd.g_old_rec.segment5
568: ,p_segment6_o
569: => pay_btl_shd.g_old_rec.segment6
563: => pay_btl_shd.g_old_rec.segment3
564: ,p_segment4_o
565: => pay_btl_shd.g_old_rec.segment4
566: ,p_segment5_o
567: => pay_btl_shd.g_old_rec.segment5
568: ,p_segment6_o
569: => pay_btl_shd.g_old_rec.segment6
570: ,p_segment7_o
571: => pay_btl_shd.g_old_rec.segment7
565: => pay_btl_shd.g_old_rec.segment4
566: ,p_segment5_o
567: => pay_btl_shd.g_old_rec.segment5
568: ,p_segment6_o
569: => pay_btl_shd.g_old_rec.segment6
570: ,p_segment7_o
571: => pay_btl_shd.g_old_rec.segment7
572: ,p_segment8_o
573: => pay_btl_shd.g_old_rec.segment8
567: => pay_btl_shd.g_old_rec.segment5
568: ,p_segment6_o
569: => pay_btl_shd.g_old_rec.segment6
570: ,p_segment7_o
571: => pay_btl_shd.g_old_rec.segment7
572: ,p_segment8_o
573: => pay_btl_shd.g_old_rec.segment8
574: ,p_segment9_o
575: => pay_btl_shd.g_old_rec.segment9
569: => pay_btl_shd.g_old_rec.segment6
570: ,p_segment7_o
571: => pay_btl_shd.g_old_rec.segment7
572: ,p_segment8_o
573: => pay_btl_shd.g_old_rec.segment8
574: ,p_segment9_o
575: => pay_btl_shd.g_old_rec.segment9
576: ,p_segment10_o
577: => pay_btl_shd.g_old_rec.segment10
571: => pay_btl_shd.g_old_rec.segment7
572: ,p_segment8_o
573: => pay_btl_shd.g_old_rec.segment8
574: ,p_segment9_o
575: => pay_btl_shd.g_old_rec.segment9
576: ,p_segment10_o
577: => pay_btl_shd.g_old_rec.segment10
578: ,p_segment11_o
579: => pay_btl_shd.g_old_rec.segment11
573: => pay_btl_shd.g_old_rec.segment8
574: ,p_segment9_o
575: => pay_btl_shd.g_old_rec.segment9
576: ,p_segment10_o
577: => pay_btl_shd.g_old_rec.segment10
578: ,p_segment11_o
579: => pay_btl_shd.g_old_rec.segment11
580: ,p_segment12_o
581: => pay_btl_shd.g_old_rec.segment12
575: => pay_btl_shd.g_old_rec.segment9
576: ,p_segment10_o
577: => pay_btl_shd.g_old_rec.segment10
578: ,p_segment11_o
579: => pay_btl_shd.g_old_rec.segment11
580: ,p_segment12_o
581: => pay_btl_shd.g_old_rec.segment12
582: ,p_segment13_o
583: => pay_btl_shd.g_old_rec.segment13
577: => pay_btl_shd.g_old_rec.segment10
578: ,p_segment11_o
579: => pay_btl_shd.g_old_rec.segment11
580: ,p_segment12_o
581: => pay_btl_shd.g_old_rec.segment12
582: ,p_segment13_o
583: => pay_btl_shd.g_old_rec.segment13
584: ,p_segment14_o
585: => pay_btl_shd.g_old_rec.segment14
579: => pay_btl_shd.g_old_rec.segment11
580: ,p_segment12_o
581: => pay_btl_shd.g_old_rec.segment12
582: ,p_segment13_o
583: => pay_btl_shd.g_old_rec.segment13
584: ,p_segment14_o
585: => pay_btl_shd.g_old_rec.segment14
586: ,p_segment15_o
587: => pay_btl_shd.g_old_rec.segment15
581: => pay_btl_shd.g_old_rec.segment12
582: ,p_segment13_o
583: => pay_btl_shd.g_old_rec.segment13
584: ,p_segment14_o
585: => pay_btl_shd.g_old_rec.segment14
586: ,p_segment15_o
587: => pay_btl_shd.g_old_rec.segment15
588: ,p_segment16_o
589: => pay_btl_shd.g_old_rec.segment16
583: => pay_btl_shd.g_old_rec.segment13
584: ,p_segment14_o
585: => pay_btl_shd.g_old_rec.segment14
586: ,p_segment15_o
587: => pay_btl_shd.g_old_rec.segment15
588: ,p_segment16_o
589: => pay_btl_shd.g_old_rec.segment16
590: ,p_segment17_o
591: => pay_btl_shd.g_old_rec.segment17
585: => pay_btl_shd.g_old_rec.segment14
586: ,p_segment15_o
587: => pay_btl_shd.g_old_rec.segment15
588: ,p_segment16_o
589: => pay_btl_shd.g_old_rec.segment16
590: ,p_segment17_o
591: => pay_btl_shd.g_old_rec.segment17
592: ,p_segment18_o
593: => pay_btl_shd.g_old_rec.segment18
587: => pay_btl_shd.g_old_rec.segment15
588: ,p_segment16_o
589: => pay_btl_shd.g_old_rec.segment16
590: ,p_segment17_o
591: => pay_btl_shd.g_old_rec.segment17
592: ,p_segment18_o
593: => pay_btl_shd.g_old_rec.segment18
594: ,p_segment19_o
595: => pay_btl_shd.g_old_rec.segment19
589: => pay_btl_shd.g_old_rec.segment16
590: ,p_segment17_o
591: => pay_btl_shd.g_old_rec.segment17
592: ,p_segment18_o
593: => pay_btl_shd.g_old_rec.segment18
594: ,p_segment19_o
595: => pay_btl_shd.g_old_rec.segment19
596: ,p_segment20_o
597: => pay_btl_shd.g_old_rec.segment20
591: => pay_btl_shd.g_old_rec.segment17
592: ,p_segment18_o
593: => pay_btl_shd.g_old_rec.segment18
594: ,p_segment19_o
595: => pay_btl_shd.g_old_rec.segment19
596: ,p_segment20_o
597: => pay_btl_shd.g_old_rec.segment20
598: ,p_segment21_o
599: => pay_btl_shd.g_old_rec.segment21
593: => pay_btl_shd.g_old_rec.segment18
594: ,p_segment19_o
595: => pay_btl_shd.g_old_rec.segment19
596: ,p_segment20_o
597: => pay_btl_shd.g_old_rec.segment20
598: ,p_segment21_o
599: => pay_btl_shd.g_old_rec.segment21
600: ,p_segment22_o
601: => pay_btl_shd.g_old_rec.segment22
595: => pay_btl_shd.g_old_rec.segment19
596: ,p_segment20_o
597: => pay_btl_shd.g_old_rec.segment20
598: ,p_segment21_o
599: => pay_btl_shd.g_old_rec.segment21
600: ,p_segment22_o
601: => pay_btl_shd.g_old_rec.segment22
602: ,p_segment23_o
603: => pay_btl_shd.g_old_rec.segment23
597: => pay_btl_shd.g_old_rec.segment20
598: ,p_segment21_o
599: => pay_btl_shd.g_old_rec.segment21
600: ,p_segment22_o
601: => pay_btl_shd.g_old_rec.segment22
602: ,p_segment23_o
603: => pay_btl_shd.g_old_rec.segment23
604: ,p_segment24_o
605: => pay_btl_shd.g_old_rec.segment24
599: => pay_btl_shd.g_old_rec.segment21
600: ,p_segment22_o
601: => pay_btl_shd.g_old_rec.segment22
602: ,p_segment23_o
603: => pay_btl_shd.g_old_rec.segment23
604: ,p_segment24_o
605: => pay_btl_shd.g_old_rec.segment24
606: ,p_segment25_o
607: => pay_btl_shd.g_old_rec.segment25
601: => pay_btl_shd.g_old_rec.segment22
602: ,p_segment23_o
603: => pay_btl_shd.g_old_rec.segment23
604: ,p_segment24_o
605: => pay_btl_shd.g_old_rec.segment24
606: ,p_segment25_o
607: => pay_btl_shd.g_old_rec.segment25
608: ,p_segment26_o
609: => pay_btl_shd.g_old_rec.segment26
603: => pay_btl_shd.g_old_rec.segment23
604: ,p_segment24_o
605: => pay_btl_shd.g_old_rec.segment24
606: ,p_segment25_o
607: => pay_btl_shd.g_old_rec.segment25
608: ,p_segment26_o
609: => pay_btl_shd.g_old_rec.segment26
610: ,p_segment27_o
611: => pay_btl_shd.g_old_rec.segment27
605: => pay_btl_shd.g_old_rec.segment24
606: ,p_segment25_o
607: => pay_btl_shd.g_old_rec.segment25
608: ,p_segment26_o
609: => pay_btl_shd.g_old_rec.segment26
610: ,p_segment27_o
611: => pay_btl_shd.g_old_rec.segment27
612: ,p_segment28_o
613: => pay_btl_shd.g_old_rec.segment28
607: => pay_btl_shd.g_old_rec.segment25
608: ,p_segment26_o
609: => pay_btl_shd.g_old_rec.segment26
610: ,p_segment27_o
611: => pay_btl_shd.g_old_rec.segment27
612: ,p_segment28_o
613: => pay_btl_shd.g_old_rec.segment28
614: ,p_segment29_o
615: => pay_btl_shd.g_old_rec.segment29
609: => pay_btl_shd.g_old_rec.segment26
610: ,p_segment27_o
611: => pay_btl_shd.g_old_rec.segment27
612: ,p_segment28_o
613: => pay_btl_shd.g_old_rec.segment28
614: ,p_segment29_o
615: => pay_btl_shd.g_old_rec.segment29
616: ,p_segment30_o
617: => pay_btl_shd.g_old_rec.segment30
611: => pay_btl_shd.g_old_rec.segment27
612: ,p_segment28_o
613: => pay_btl_shd.g_old_rec.segment28
614: ,p_segment29_o
615: => pay_btl_shd.g_old_rec.segment29
616: ,p_segment30_o
617: => pay_btl_shd.g_old_rec.segment30
618: ,p_value_1_o
619: => pay_btl_shd.g_old_rec.value_1
613: => pay_btl_shd.g_old_rec.segment28
614: ,p_segment29_o
615: => pay_btl_shd.g_old_rec.segment29
616: ,p_segment30_o
617: => pay_btl_shd.g_old_rec.segment30
618: ,p_value_1_o
619: => pay_btl_shd.g_old_rec.value_1
620: ,p_value_2_o
621: => pay_btl_shd.g_old_rec.value_2
615: => pay_btl_shd.g_old_rec.segment29
616: ,p_segment30_o
617: => pay_btl_shd.g_old_rec.segment30
618: ,p_value_1_o
619: => pay_btl_shd.g_old_rec.value_1
620: ,p_value_2_o
621: => pay_btl_shd.g_old_rec.value_2
622: ,p_value_3_o
623: => pay_btl_shd.g_old_rec.value_3
617: => pay_btl_shd.g_old_rec.segment30
618: ,p_value_1_o
619: => pay_btl_shd.g_old_rec.value_1
620: ,p_value_2_o
621: => pay_btl_shd.g_old_rec.value_2
622: ,p_value_3_o
623: => pay_btl_shd.g_old_rec.value_3
624: ,p_value_4_o
625: => pay_btl_shd.g_old_rec.value_4
619: => pay_btl_shd.g_old_rec.value_1
620: ,p_value_2_o
621: => pay_btl_shd.g_old_rec.value_2
622: ,p_value_3_o
623: => pay_btl_shd.g_old_rec.value_3
624: ,p_value_4_o
625: => pay_btl_shd.g_old_rec.value_4
626: ,p_value_5_o
627: => pay_btl_shd.g_old_rec.value_5
621: => pay_btl_shd.g_old_rec.value_2
622: ,p_value_3_o
623: => pay_btl_shd.g_old_rec.value_3
624: ,p_value_4_o
625: => pay_btl_shd.g_old_rec.value_4
626: ,p_value_5_o
627: => pay_btl_shd.g_old_rec.value_5
628: ,p_value_6_o
629: => pay_btl_shd.g_old_rec.value_6
623: => pay_btl_shd.g_old_rec.value_3
624: ,p_value_4_o
625: => pay_btl_shd.g_old_rec.value_4
626: ,p_value_5_o
627: => pay_btl_shd.g_old_rec.value_5
628: ,p_value_6_o
629: => pay_btl_shd.g_old_rec.value_6
630: ,p_value_7_o
631: => pay_btl_shd.g_old_rec.value_7
625: => pay_btl_shd.g_old_rec.value_4
626: ,p_value_5_o
627: => pay_btl_shd.g_old_rec.value_5
628: ,p_value_6_o
629: => pay_btl_shd.g_old_rec.value_6
630: ,p_value_7_o
631: => pay_btl_shd.g_old_rec.value_7
632: ,p_value_8_o
633: => pay_btl_shd.g_old_rec.value_8
627: => pay_btl_shd.g_old_rec.value_5
628: ,p_value_6_o
629: => pay_btl_shd.g_old_rec.value_6
630: ,p_value_7_o
631: => pay_btl_shd.g_old_rec.value_7
632: ,p_value_8_o
633: => pay_btl_shd.g_old_rec.value_8
634: ,p_value_9_o
635: => pay_btl_shd.g_old_rec.value_9
629: => pay_btl_shd.g_old_rec.value_6
630: ,p_value_7_o
631: => pay_btl_shd.g_old_rec.value_7
632: ,p_value_8_o
633: => pay_btl_shd.g_old_rec.value_8
634: ,p_value_9_o
635: => pay_btl_shd.g_old_rec.value_9
636: ,p_value_10_o
637: => pay_btl_shd.g_old_rec.value_10
631: => pay_btl_shd.g_old_rec.value_7
632: ,p_value_8_o
633: => pay_btl_shd.g_old_rec.value_8
634: ,p_value_9_o
635: => pay_btl_shd.g_old_rec.value_9
636: ,p_value_10_o
637: => pay_btl_shd.g_old_rec.value_10
638: ,p_value_11_o
639: => pay_btl_shd.g_old_rec.value_11
633: => pay_btl_shd.g_old_rec.value_8
634: ,p_value_9_o
635: => pay_btl_shd.g_old_rec.value_9
636: ,p_value_10_o
637: => pay_btl_shd.g_old_rec.value_10
638: ,p_value_11_o
639: => pay_btl_shd.g_old_rec.value_11
640: ,p_value_12_o
641: => pay_btl_shd.g_old_rec.value_12
635: => pay_btl_shd.g_old_rec.value_9
636: ,p_value_10_o
637: => pay_btl_shd.g_old_rec.value_10
638: ,p_value_11_o
639: => pay_btl_shd.g_old_rec.value_11
640: ,p_value_12_o
641: => pay_btl_shd.g_old_rec.value_12
642: ,p_value_13_o
643: => pay_btl_shd.g_old_rec.value_13
637: => pay_btl_shd.g_old_rec.value_10
638: ,p_value_11_o
639: => pay_btl_shd.g_old_rec.value_11
640: ,p_value_12_o
641: => pay_btl_shd.g_old_rec.value_12
642: ,p_value_13_o
643: => pay_btl_shd.g_old_rec.value_13
644: ,p_value_14_o
645: => pay_btl_shd.g_old_rec.value_14
639: => pay_btl_shd.g_old_rec.value_11
640: ,p_value_12_o
641: => pay_btl_shd.g_old_rec.value_12
642: ,p_value_13_o
643: => pay_btl_shd.g_old_rec.value_13
644: ,p_value_14_o
645: => pay_btl_shd.g_old_rec.value_14
646: ,p_value_15_o
647: => pay_btl_shd.g_old_rec.value_15
641: => pay_btl_shd.g_old_rec.value_12
642: ,p_value_13_o
643: => pay_btl_shd.g_old_rec.value_13
644: ,p_value_14_o
645: => pay_btl_shd.g_old_rec.value_14
646: ,p_value_15_o
647: => pay_btl_shd.g_old_rec.value_15
648: ,p_attribute_category_o
649: => pay_btl_shd.g_old_rec.attribute_category
643: => pay_btl_shd.g_old_rec.value_13
644: ,p_value_14_o
645: => pay_btl_shd.g_old_rec.value_14
646: ,p_value_15_o
647: => pay_btl_shd.g_old_rec.value_15
648: ,p_attribute_category_o
649: => pay_btl_shd.g_old_rec.attribute_category
650: ,p_attribute1_o
651: => pay_btl_shd.g_old_rec.attribute1
645: => pay_btl_shd.g_old_rec.value_14
646: ,p_value_15_o
647: => pay_btl_shd.g_old_rec.value_15
648: ,p_attribute_category_o
649: => pay_btl_shd.g_old_rec.attribute_category
650: ,p_attribute1_o
651: => pay_btl_shd.g_old_rec.attribute1
652: ,p_attribute2_o
653: => pay_btl_shd.g_old_rec.attribute2
647: => pay_btl_shd.g_old_rec.value_15
648: ,p_attribute_category_o
649: => pay_btl_shd.g_old_rec.attribute_category
650: ,p_attribute1_o
651: => pay_btl_shd.g_old_rec.attribute1
652: ,p_attribute2_o
653: => pay_btl_shd.g_old_rec.attribute2
654: ,p_attribute3_o
655: => pay_btl_shd.g_old_rec.attribute3
649: => pay_btl_shd.g_old_rec.attribute_category
650: ,p_attribute1_o
651: => pay_btl_shd.g_old_rec.attribute1
652: ,p_attribute2_o
653: => pay_btl_shd.g_old_rec.attribute2
654: ,p_attribute3_o
655: => pay_btl_shd.g_old_rec.attribute3
656: ,p_attribute4_o
657: => pay_btl_shd.g_old_rec.attribute4
651: => pay_btl_shd.g_old_rec.attribute1
652: ,p_attribute2_o
653: => pay_btl_shd.g_old_rec.attribute2
654: ,p_attribute3_o
655: => pay_btl_shd.g_old_rec.attribute3
656: ,p_attribute4_o
657: => pay_btl_shd.g_old_rec.attribute4
658: ,p_attribute5_o
659: => pay_btl_shd.g_old_rec.attribute5
653: => pay_btl_shd.g_old_rec.attribute2
654: ,p_attribute3_o
655: => pay_btl_shd.g_old_rec.attribute3
656: ,p_attribute4_o
657: => pay_btl_shd.g_old_rec.attribute4
658: ,p_attribute5_o
659: => pay_btl_shd.g_old_rec.attribute5
660: ,p_attribute6_o
661: => pay_btl_shd.g_old_rec.attribute6
655: => pay_btl_shd.g_old_rec.attribute3
656: ,p_attribute4_o
657: => pay_btl_shd.g_old_rec.attribute4
658: ,p_attribute5_o
659: => pay_btl_shd.g_old_rec.attribute5
660: ,p_attribute6_o
661: => pay_btl_shd.g_old_rec.attribute6
662: ,p_attribute7_o
663: => pay_btl_shd.g_old_rec.attribute7
657: => pay_btl_shd.g_old_rec.attribute4
658: ,p_attribute5_o
659: => pay_btl_shd.g_old_rec.attribute5
660: ,p_attribute6_o
661: => pay_btl_shd.g_old_rec.attribute6
662: ,p_attribute7_o
663: => pay_btl_shd.g_old_rec.attribute7
664: ,p_attribute8_o
665: => pay_btl_shd.g_old_rec.attribute8
659: => pay_btl_shd.g_old_rec.attribute5
660: ,p_attribute6_o
661: => pay_btl_shd.g_old_rec.attribute6
662: ,p_attribute7_o
663: => pay_btl_shd.g_old_rec.attribute7
664: ,p_attribute8_o
665: => pay_btl_shd.g_old_rec.attribute8
666: ,p_attribute9_o
667: => pay_btl_shd.g_old_rec.attribute9
661: => pay_btl_shd.g_old_rec.attribute6
662: ,p_attribute7_o
663: => pay_btl_shd.g_old_rec.attribute7
664: ,p_attribute8_o
665: => pay_btl_shd.g_old_rec.attribute8
666: ,p_attribute9_o
667: => pay_btl_shd.g_old_rec.attribute9
668: ,p_attribute10_o
669: => pay_btl_shd.g_old_rec.attribute10
663: => pay_btl_shd.g_old_rec.attribute7
664: ,p_attribute8_o
665: => pay_btl_shd.g_old_rec.attribute8
666: ,p_attribute9_o
667: => pay_btl_shd.g_old_rec.attribute9
668: ,p_attribute10_o
669: => pay_btl_shd.g_old_rec.attribute10
670: ,p_attribute11_o
671: => pay_btl_shd.g_old_rec.attribute11
665: => pay_btl_shd.g_old_rec.attribute8
666: ,p_attribute9_o
667: => pay_btl_shd.g_old_rec.attribute9
668: ,p_attribute10_o
669: => pay_btl_shd.g_old_rec.attribute10
670: ,p_attribute11_o
671: => pay_btl_shd.g_old_rec.attribute11
672: ,p_attribute12_o
673: => pay_btl_shd.g_old_rec.attribute12
667: => pay_btl_shd.g_old_rec.attribute9
668: ,p_attribute10_o
669: => pay_btl_shd.g_old_rec.attribute10
670: ,p_attribute11_o
671: => pay_btl_shd.g_old_rec.attribute11
672: ,p_attribute12_o
673: => pay_btl_shd.g_old_rec.attribute12
674: ,p_attribute13_o
675: => pay_btl_shd.g_old_rec.attribute13
669: => pay_btl_shd.g_old_rec.attribute10
670: ,p_attribute11_o
671: => pay_btl_shd.g_old_rec.attribute11
672: ,p_attribute12_o
673: => pay_btl_shd.g_old_rec.attribute12
674: ,p_attribute13_o
675: => pay_btl_shd.g_old_rec.attribute13
676: ,p_attribute14_o
677: => pay_btl_shd.g_old_rec.attribute14
671: => pay_btl_shd.g_old_rec.attribute11
672: ,p_attribute12_o
673: => pay_btl_shd.g_old_rec.attribute12
674: ,p_attribute13_o
675: => pay_btl_shd.g_old_rec.attribute13
676: ,p_attribute14_o
677: => pay_btl_shd.g_old_rec.attribute14
678: ,p_attribute15_o
679: => pay_btl_shd.g_old_rec.attribute15
673: => pay_btl_shd.g_old_rec.attribute12
674: ,p_attribute13_o
675: => pay_btl_shd.g_old_rec.attribute13
676: ,p_attribute14_o
677: => pay_btl_shd.g_old_rec.attribute14
678: ,p_attribute15_o
679: => pay_btl_shd.g_old_rec.attribute15
680: ,p_attribute16_o
681: => pay_btl_shd.g_old_rec.attribute16
675: => pay_btl_shd.g_old_rec.attribute13
676: ,p_attribute14_o
677: => pay_btl_shd.g_old_rec.attribute14
678: ,p_attribute15_o
679: => pay_btl_shd.g_old_rec.attribute15
680: ,p_attribute16_o
681: => pay_btl_shd.g_old_rec.attribute16
682: ,p_attribute17_o
683: => pay_btl_shd.g_old_rec.attribute17
677: => pay_btl_shd.g_old_rec.attribute14
678: ,p_attribute15_o
679: => pay_btl_shd.g_old_rec.attribute15
680: ,p_attribute16_o
681: => pay_btl_shd.g_old_rec.attribute16
682: ,p_attribute17_o
683: => pay_btl_shd.g_old_rec.attribute17
684: ,p_attribute18_o
685: => pay_btl_shd.g_old_rec.attribute18
679: => pay_btl_shd.g_old_rec.attribute15
680: ,p_attribute16_o
681: => pay_btl_shd.g_old_rec.attribute16
682: ,p_attribute17_o
683: => pay_btl_shd.g_old_rec.attribute17
684: ,p_attribute18_o
685: => pay_btl_shd.g_old_rec.attribute18
686: ,p_attribute19_o
687: => pay_btl_shd.g_old_rec.attribute19
681: => pay_btl_shd.g_old_rec.attribute16
682: ,p_attribute17_o
683: => pay_btl_shd.g_old_rec.attribute17
684: ,p_attribute18_o
685: => pay_btl_shd.g_old_rec.attribute18
686: ,p_attribute19_o
687: => pay_btl_shd.g_old_rec.attribute19
688: ,p_attribute20_o
689: => pay_btl_shd.g_old_rec.attribute20
683: => pay_btl_shd.g_old_rec.attribute17
684: ,p_attribute18_o
685: => pay_btl_shd.g_old_rec.attribute18
686: ,p_attribute19_o
687: => pay_btl_shd.g_old_rec.attribute19
688: ,p_attribute20_o
689: => pay_btl_shd.g_old_rec.attribute20
690: ,p_entry_information_category_o
691: => pay_btl_shd.g_old_rec.entry_information_category
685: => pay_btl_shd.g_old_rec.attribute18
686: ,p_attribute19_o
687: => pay_btl_shd.g_old_rec.attribute19
688: ,p_attribute20_o
689: => pay_btl_shd.g_old_rec.attribute20
690: ,p_entry_information_category_o
691: => pay_btl_shd.g_old_rec.entry_information_category
692: ,p_entry_information1_o
693: => pay_btl_shd.g_old_rec.entry_information1
687: => pay_btl_shd.g_old_rec.attribute19
688: ,p_attribute20_o
689: => pay_btl_shd.g_old_rec.attribute20
690: ,p_entry_information_category_o
691: => pay_btl_shd.g_old_rec.entry_information_category
692: ,p_entry_information1_o
693: => pay_btl_shd.g_old_rec.entry_information1
694: ,p_entry_information2_o
695: => pay_btl_shd.g_old_rec.entry_information2
689: => pay_btl_shd.g_old_rec.attribute20
690: ,p_entry_information_category_o
691: => pay_btl_shd.g_old_rec.entry_information_category
692: ,p_entry_information1_o
693: => pay_btl_shd.g_old_rec.entry_information1
694: ,p_entry_information2_o
695: => pay_btl_shd.g_old_rec.entry_information2
696: ,p_entry_information3_o
697: => pay_btl_shd.g_old_rec.entry_information3
691: => pay_btl_shd.g_old_rec.entry_information_category
692: ,p_entry_information1_o
693: => pay_btl_shd.g_old_rec.entry_information1
694: ,p_entry_information2_o
695: => pay_btl_shd.g_old_rec.entry_information2
696: ,p_entry_information3_o
697: => pay_btl_shd.g_old_rec.entry_information3
698: ,p_entry_information4_o
699: => pay_btl_shd.g_old_rec.entry_information4
693: => pay_btl_shd.g_old_rec.entry_information1
694: ,p_entry_information2_o
695: => pay_btl_shd.g_old_rec.entry_information2
696: ,p_entry_information3_o
697: => pay_btl_shd.g_old_rec.entry_information3
698: ,p_entry_information4_o
699: => pay_btl_shd.g_old_rec.entry_information4
700: ,p_entry_information5_o
701: => pay_btl_shd.g_old_rec.entry_information5
695: => pay_btl_shd.g_old_rec.entry_information2
696: ,p_entry_information3_o
697: => pay_btl_shd.g_old_rec.entry_information3
698: ,p_entry_information4_o
699: => pay_btl_shd.g_old_rec.entry_information4
700: ,p_entry_information5_o
701: => pay_btl_shd.g_old_rec.entry_information5
702: ,p_entry_information6_o
703: => pay_btl_shd.g_old_rec.entry_information6
697: => pay_btl_shd.g_old_rec.entry_information3
698: ,p_entry_information4_o
699: => pay_btl_shd.g_old_rec.entry_information4
700: ,p_entry_information5_o
701: => pay_btl_shd.g_old_rec.entry_information5
702: ,p_entry_information6_o
703: => pay_btl_shd.g_old_rec.entry_information6
704: ,p_entry_information7_o
705: => pay_btl_shd.g_old_rec.entry_information7
699: => pay_btl_shd.g_old_rec.entry_information4
700: ,p_entry_information5_o
701: => pay_btl_shd.g_old_rec.entry_information5
702: ,p_entry_information6_o
703: => pay_btl_shd.g_old_rec.entry_information6
704: ,p_entry_information7_o
705: => pay_btl_shd.g_old_rec.entry_information7
706: ,p_entry_information8_o
707: => pay_btl_shd.g_old_rec.entry_information8
701: => pay_btl_shd.g_old_rec.entry_information5
702: ,p_entry_information6_o
703: => pay_btl_shd.g_old_rec.entry_information6
704: ,p_entry_information7_o
705: => pay_btl_shd.g_old_rec.entry_information7
706: ,p_entry_information8_o
707: => pay_btl_shd.g_old_rec.entry_information8
708: ,p_entry_information9_o
709: => pay_btl_shd.g_old_rec.entry_information9
703: => pay_btl_shd.g_old_rec.entry_information6
704: ,p_entry_information7_o
705: => pay_btl_shd.g_old_rec.entry_information7
706: ,p_entry_information8_o
707: => pay_btl_shd.g_old_rec.entry_information8
708: ,p_entry_information9_o
709: => pay_btl_shd.g_old_rec.entry_information9
710: ,p_entry_information10_o
711: => pay_btl_shd.g_old_rec.entry_information10
705: => pay_btl_shd.g_old_rec.entry_information7
706: ,p_entry_information8_o
707: => pay_btl_shd.g_old_rec.entry_information8
708: ,p_entry_information9_o
709: => pay_btl_shd.g_old_rec.entry_information9
710: ,p_entry_information10_o
711: => pay_btl_shd.g_old_rec.entry_information10
712: ,p_entry_information11_o
713: => pay_btl_shd.g_old_rec.entry_information11
707: => pay_btl_shd.g_old_rec.entry_information8
708: ,p_entry_information9_o
709: => pay_btl_shd.g_old_rec.entry_information9
710: ,p_entry_information10_o
711: => pay_btl_shd.g_old_rec.entry_information10
712: ,p_entry_information11_o
713: => pay_btl_shd.g_old_rec.entry_information11
714: ,p_entry_information12_o
715: => pay_btl_shd.g_old_rec.entry_information12
709: => pay_btl_shd.g_old_rec.entry_information9
710: ,p_entry_information10_o
711: => pay_btl_shd.g_old_rec.entry_information10
712: ,p_entry_information11_o
713: => pay_btl_shd.g_old_rec.entry_information11
714: ,p_entry_information12_o
715: => pay_btl_shd.g_old_rec.entry_information12
716: ,p_entry_information13_o
717: => pay_btl_shd.g_old_rec.entry_information13
711: => pay_btl_shd.g_old_rec.entry_information10
712: ,p_entry_information11_o
713: => pay_btl_shd.g_old_rec.entry_information11
714: ,p_entry_information12_o
715: => pay_btl_shd.g_old_rec.entry_information12
716: ,p_entry_information13_o
717: => pay_btl_shd.g_old_rec.entry_information13
718: ,p_entry_information14_o
719: => pay_btl_shd.g_old_rec.entry_information14
713: => pay_btl_shd.g_old_rec.entry_information11
714: ,p_entry_information12_o
715: => pay_btl_shd.g_old_rec.entry_information12
716: ,p_entry_information13_o
717: => pay_btl_shd.g_old_rec.entry_information13
718: ,p_entry_information14_o
719: => pay_btl_shd.g_old_rec.entry_information14
720: ,p_entry_information15_o
721: => pay_btl_shd.g_old_rec.entry_information15
715: => pay_btl_shd.g_old_rec.entry_information12
716: ,p_entry_information13_o
717: => pay_btl_shd.g_old_rec.entry_information13
718: ,p_entry_information14_o
719: => pay_btl_shd.g_old_rec.entry_information14
720: ,p_entry_information15_o
721: => pay_btl_shd.g_old_rec.entry_information15
722: ,p_entry_information16_o
723: => pay_btl_shd.g_old_rec.entry_information16
717: => pay_btl_shd.g_old_rec.entry_information13
718: ,p_entry_information14_o
719: => pay_btl_shd.g_old_rec.entry_information14
720: ,p_entry_information15_o
721: => pay_btl_shd.g_old_rec.entry_information15
722: ,p_entry_information16_o
723: => pay_btl_shd.g_old_rec.entry_information16
724: ,p_entry_information17_o
725: => pay_btl_shd.g_old_rec.entry_information17
719: => pay_btl_shd.g_old_rec.entry_information14
720: ,p_entry_information15_o
721: => pay_btl_shd.g_old_rec.entry_information15
722: ,p_entry_information16_o
723: => pay_btl_shd.g_old_rec.entry_information16
724: ,p_entry_information17_o
725: => pay_btl_shd.g_old_rec.entry_information17
726: ,p_entry_information18_o
727: => pay_btl_shd.g_old_rec.entry_information18
721: => pay_btl_shd.g_old_rec.entry_information15
722: ,p_entry_information16_o
723: => pay_btl_shd.g_old_rec.entry_information16
724: ,p_entry_information17_o
725: => pay_btl_shd.g_old_rec.entry_information17
726: ,p_entry_information18_o
727: => pay_btl_shd.g_old_rec.entry_information18
728: ,p_entry_information19_o
729: => pay_btl_shd.g_old_rec.entry_information19
723: => pay_btl_shd.g_old_rec.entry_information16
724: ,p_entry_information17_o
725: => pay_btl_shd.g_old_rec.entry_information17
726: ,p_entry_information18_o
727: => pay_btl_shd.g_old_rec.entry_information18
728: ,p_entry_information19_o
729: => pay_btl_shd.g_old_rec.entry_information19
730: ,p_entry_information20_o
731: => pay_btl_shd.g_old_rec.entry_information20
725: => pay_btl_shd.g_old_rec.entry_information17
726: ,p_entry_information18_o
727: => pay_btl_shd.g_old_rec.entry_information18
728: ,p_entry_information19_o
729: => pay_btl_shd.g_old_rec.entry_information19
730: ,p_entry_information20_o
731: => pay_btl_shd.g_old_rec.entry_information20
732: ,p_entry_information21_o
733: => pay_btl_shd.g_old_rec.entry_information21
727: => pay_btl_shd.g_old_rec.entry_information18
728: ,p_entry_information19_o
729: => pay_btl_shd.g_old_rec.entry_information19
730: ,p_entry_information20_o
731: => pay_btl_shd.g_old_rec.entry_information20
732: ,p_entry_information21_o
733: => pay_btl_shd.g_old_rec.entry_information21
734: ,p_entry_information22_o
735: => pay_btl_shd.g_old_rec.entry_information22
729: => pay_btl_shd.g_old_rec.entry_information19
730: ,p_entry_information20_o
731: => pay_btl_shd.g_old_rec.entry_information20
732: ,p_entry_information21_o
733: => pay_btl_shd.g_old_rec.entry_information21
734: ,p_entry_information22_o
735: => pay_btl_shd.g_old_rec.entry_information22
736: ,p_entry_information23_o
737: => pay_btl_shd.g_old_rec.entry_information23
731: => pay_btl_shd.g_old_rec.entry_information20
732: ,p_entry_information21_o
733: => pay_btl_shd.g_old_rec.entry_information21
734: ,p_entry_information22_o
735: => pay_btl_shd.g_old_rec.entry_information22
736: ,p_entry_information23_o
737: => pay_btl_shd.g_old_rec.entry_information23
738: ,p_entry_information24_o
739: => pay_btl_shd.g_old_rec.entry_information24
733: => pay_btl_shd.g_old_rec.entry_information21
734: ,p_entry_information22_o
735: => pay_btl_shd.g_old_rec.entry_information22
736: ,p_entry_information23_o
737: => pay_btl_shd.g_old_rec.entry_information23
738: ,p_entry_information24_o
739: => pay_btl_shd.g_old_rec.entry_information24
740: ,p_entry_information25_o
741: => pay_btl_shd.g_old_rec.entry_information25
735: => pay_btl_shd.g_old_rec.entry_information22
736: ,p_entry_information23_o
737: => pay_btl_shd.g_old_rec.entry_information23
738: ,p_entry_information24_o
739: => pay_btl_shd.g_old_rec.entry_information24
740: ,p_entry_information25_o
741: => pay_btl_shd.g_old_rec.entry_information25
742: ,p_entry_information26_o
743: => pay_btl_shd.g_old_rec.entry_information26
737: => pay_btl_shd.g_old_rec.entry_information23
738: ,p_entry_information24_o
739: => pay_btl_shd.g_old_rec.entry_information24
740: ,p_entry_information25_o
741: => pay_btl_shd.g_old_rec.entry_information25
742: ,p_entry_information26_o
743: => pay_btl_shd.g_old_rec.entry_information26
744: ,p_entry_information27_o
745: => pay_btl_shd.g_old_rec.entry_information27
739: => pay_btl_shd.g_old_rec.entry_information24
740: ,p_entry_information25_o
741: => pay_btl_shd.g_old_rec.entry_information25
742: ,p_entry_information26_o
743: => pay_btl_shd.g_old_rec.entry_information26
744: ,p_entry_information27_o
745: => pay_btl_shd.g_old_rec.entry_information27
746: ,p_entry_information28_o
747: => pay_btl_shd.g_old_rec.entry_information28
741: => pay_btl_shd.g_old_rec.entry_information25
742: ,p_entry_information26_o
743: => pay_btl_shd.g_old_rec.entry_information26
744: ,p_entry_information27_o
745: => pay_btl_shd.g_old_rec.entry_information27
746: ,p_entry_information28_o
747: => pay_btl_shd.g_old_rec.entry_information28
748: ,p_entry_information29_o
749: => pay_btl_shd.g_old_rec.entry_information29
743: => pay_btl_shd.g_old_rec.entry_information26
744: ,p_entry_information27_o
745: => pay_btl_shd.g_old_rec.entry_information27
746: ,p_entry_information28_o
747: => pay_btl_shd.g_old_rec.entry_information28
748: ,p_entry_information29_o
749: => pay_btl_shd.g_old_rec.entry_information29
750: ,p_entry_information30_o
751: => pay_btl_shd.g_old_rec.entry_information30
745: => pay_btl_shd.g_old_rec.entry_information27
746: ,p_entry_information28_o
747: => pay_btl_shd.g_old_rec.entry_information28
748: ,p_entry_information29_o
749: => pay_btl_shd.g_old_rec.entry_information29
750: ,p_entry_information30_o
751: => pay_btl_shd.g_old_rec.entry_information30
752: ,p_date_earned_o
753: => pay_btl_shd.g_old_rec.date_earned
747: => pay_btl_shd.g_old_rec.entry_information28
748: ,p_entry_information29_o
749: => pay_btl_shd.g_old_rec.entry_information29
750: ,p_entry_information30_o
751: => pay_btl_shd.g_old_rec.entry_information30
752: ,p_date_earned_o
753: => pay_btl_shd.g_old_rec.date_earned
754: ,p_personal_payment_method_id_o
755: => pay_btl_shd.g_old_rec.personal_payment_method_id
749: => pay_btl_shd.g_old_rec.entry_information29
750: ,p_entry_information30_o
751: => pay_btl_shd.g_old_rec.entry_information30
752: ,p_date_earned_o
753: => pay_btl_shd.g_old_rec.date_earned
754: ,p_personal_payment_method_id_o
755: => pay_btl_shd.g_old_rec.personal_payment_method_id
756: ,p_subpriority_o
757: => pay_btl_shd.g_old_rec.subpriority
751: => pay_btl_shd.g_old_rec.entry_information30
752: ,p_date_earned_o
753: => pay_btl_shd.g_old_rec.date_earned
754: ,p_personal_payment_method_id_o
755: => pay_btl_shd.g_old_rec.personal_payment_method_id
756: ,p_subpriority_o
757: => pay_btl_shd.g_old_rec.subpriority
758: ,p_effective_start_date_o
759: => pay_btl_shd.g_old_rec.effective_start_date
753: => pay_btl_shd.g_old_rec.date_earned
754: ,p_personal_payment_method_id_o
755: => pay_btl_shd.g_old_rec.personal_payment_method_id
756: ,p_subpriority_o
757: => pay_btl_shd.g_old_rec.subpriority
758: ,p_effective_start_date_o
759: => pay_btl_shd.g_old_rec.effective_start_date
760: ,p_effective_end_date_o
761: => pay_btl_shd.g_old_rec.effective_end_date
755: => pay_btl_shd.g_old_rec.personal_payment_method_id
756: ,p_subpriority_o
757: => pay_btl_shd.g_old_rec.subpriority
758: ,p_effective_start_date_o
759: => pay_btl_shd.g_old_rec.effective_start_date
760: ,p_effective_end_date_o
761: => pay_btl_shd.g_old_rec.effective_end_date
762: ,p_object_version_number_o
763: => pay_btl_shd.g_old_rec.object_version_number
757: => pay_btl_shd.g_old_rec.subpriority
758: ,p_effective_start_date_o
759: => pay_btl_shd.g_old_rec.effective_start_date
760: ,p_effective_end_date_o
761: => pay_btl_shd.g_old_rec.effective_end_date
762: ,p_object_version_number_o
763: => pay_btl_shd.g_old_rec.object_version_number
764: );
765: --
759: => pay_btl_shd.g_old_rec.effective_start_date
760: ,p_effective_end_date_o
761: => pay_btl_shd.g_old_rec.effective_end_date
762: ,p_object_version_number_o
763: => pay_btl_shd.g_old_rec.object_version_number
764: );
765: --
766: exception
767: --
819: --
820: -- {End Of Comments}
821: -- ----------------------------------------------------------------------------
822: Procedure convert_defs
823: (p_rec in out nocopy pay_btl_shd.g_rec_type
824: ) is
825: --
826: Begin
827: --
831: -- is being used then we must set to the 'current' argument value.
832: --
833: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
834: p_rec.cost_allocation_keyflex_id :=
835: pay_btl_shd.g_old_rec.cost_allocation_keyflex_id;
836: End If;
837: If (p_rec.element_type_id = hr_api.g_number) then
838: p_rec.element_type_id :=
839: pay_btl_shd.g_old_rec.element_type_id;
835: pay_btl_shd.g_old_rec.cost_allocation_keyflex_id;
836: End If;
837: If (p_rec.element_type_id = hr_api.g_number) then
838: p_rec.element_type_id :=
839: pay_btl_shd.g_old_rec.element_type_id;
840: End If;
841: If (p_rec.assignment_id = hr_api.g_number) then
842: p_rec.assignment_id :=
843: pay_btl_shd.g_old_rec.assignment_id;
839: pay_btl_shd.g_old_rec.element_type_id;
840: End If;
841: If (p_rec.assignment_id = hr_api.g_number) then
842: p_rec.assignment_id :=
843: pay_btl_shd.g_old_rec.assignment_id;
844: End If;
845: If (p_rec.batch_id = hr_api.g_number) then
846: p_rec.batch_id :=
847: pay_btl_shd.g_old_rec.batch_id;
843: pay_btl_shd.g_old_rec.assignment_id;
844: End If;
845: If (p_rec.batch_id = hr_api.g_number) then
846: p_rec.batch_id :=
847: pay_btl_shd.g_old_rec.batch_id;
848: End If;
849: If (p_rec.batch_line_status = hr_api.g_varchar2) then
850: p_rec.batch_line_status :=
851: pay_btl_shd.g_old_rec.batch_line_status;
847: pay_btl_shd.g_old_rec.batch_id;
848: End If;
849: If (p_rec.batch_line_status = hr_api.g_varchar2) then
850: p_rec.batch_line_status :=
851: pay_btl_shd.g_old_rec.batch_line_status;
852: End If;
853: If (p_rec.assignment_number = hr_api.g_varchar2) then
854: p_rec.assignment_number :=
855: pay_btl_shd.g_old_rec.assignment_number;
851: pay_btl_shd.g_old_rec.batch_line_status;
852: End If;
853: If (p_rec.assignment_number = hr_api.g_varchar2) then
854: p_rec.assignment_number :=
855: pay_btl_shd.g_old_rec.assignment_number;
856: End If;
857: If (p_rec.batch_sequence = hr_api.g_number) then
858: p_rec.batch_sequence :=
859: pay_btl_shd.g_old_rec.batch_sequence;
855: pay_btl_shd.g_old_rec.assignment_number;
856: End If;
857: If (p_rec.batch_sequence = hr_api.g_number) then
858: p_rec.batch_sequence :=
859: pay_btl_shd.g_old_rec.batch_sequence;
860: End If;
861: If (p_rec.concatenated_segments = hr_api.g_varchar2) then
862: p_rec.concatenated_segments :=
863: pay_btl_shd.g_old_rec.concatenated_segments;
859: pay_btl_shd.g_old_rec.batch_sequence;
860: End If;
861: If (p_rec.concatenated_segments = hr_api.g_varchar2) then
862: p_rec.concatenated_segments :=
863: pay_btl_shd.g_old_rec.concatenated_segments;
864: End If;
865: If (p_rec.effective_date = hr_api.g_date) then
866: p_rec.effective_date :=
867: pay_btl_shd.g_old_rec.effective_date;
863: pay_btl_shd.g_old_rec.concatenated_segments;
864: End If;
865: If (p_rec.effective_date = hr_api.g_date) then
866: p_rec.effective_date :=
867: pay_btl_shd.g_old_rec.effective_date;
868: End If;
869: If (p_rec.element_name = hr_api.g_varchar2) then
870: p_rec.element_name :=
871: pay_btl_shd.g_old_rec.element_name;
867: pay_btl_shd.g_old_rec.effective_date;
868: End If;
869: If (p_rec.element_name = hr_api.g_varchar2) then
870: p_rec.element_name :=
871: pay_btl_shd.g_old_rec.element_name;
872: End If;
873: If (p_rec.entry_type = hr_api.g_varchar2) then
874: p_rec.entry_type :=
875: pay_btl_shd.g_old_rec.entry_type;
871: pay_btl_shd.g_old_rec.element_name;
872: End If;
873: If (p_rec.entry_type = hr_api.g_varchar2) then
874: p_rec.entry_type :=
875: pay_btl_shd.g_old_rec.entry_type;
876: End If;
877: If (p_rec.reason = hr_api.g_varchar2) then
878: p_rec.reason :=
879: pay_btl_shd.g_old_rec.reason;
875: pay_btl_shd.g_old_rec.entry_type;
876: End If;
877: If (p_rec.reason = hr_api.g_varchar2) then
878: p_rec.reason :=
879: pay_btl_shd.g_old_rec.reason;
880: End If;
881: If (p_rec.segment1 = hr_api.g_varchar2) then
882: p_rec.segment1 :=
883: pay_btl_shd.g_old_rec.segment1;
879: pay_btl_shd.g_old_rec.reason;
880: End If;
881: If (p_rec.segment1 = hr_api.g_varchar2) then
882: p_rec.segment1 :=
883: pay_btl_shd.g_old_rec.segment1;
884: End If;
885: If (p_rec.segment2 = hr_api.g_varchar2) then
886: p_rec.segment2 :=
887: pay_btl_shd.g_old_rec.segment2;
883: pay_btl_shd.g_old_rec.segment1;
884: End If;
885: If (p_rec.segment2 = hr_api.g_varchar2) then
886: p_rec.segment2 :=
887: pay_btl_shd.g_old_rec.segment2;
888: End If;
889: If (p_rec.segment3 = hr_api.g_varchar2) then
890: p_rec.segment3 :=
891: pay_btl_shd.g_old_rec.segment3;
887: pay_btl_shd.g_old_rec.segment2;
888: End If;
889: If (p_rec.segment3 = hr_api.g_varchar2) then
890: p_rec.segment3 :=
891: pay_btl_shd.g_old_rec.segment3;
892: End If;
893: If (p_rec.segment4 = hr_api.g_varchar2) then
894: p_rec.segment4 :=
895: pay_btl_shd.g_old_rec.segment4;
891: pay_btl_shd.g_old_rec.segment3;
892: End If;
893: If (p_rec.segment4 = hr_api.g_varchar2) then
894: p_rec.segment4 :=
895: pay_btl_shd.g_old_rec.segment4;
896: End If;
897: If (p_rec.segment5 = hr_api.g_varchar2) then
898: p_rec.segment5 :=
899: pay_btl_shd.g_old_rec.segment5;
895: pay_btl_shd.g_old_rec.segment4;
896: End If;
897: If (p_rec.segment5 = hr_api.g_varchar2) then
898: p_rec.segment5 :=
899: pay_btl_shd.g_old_rec.segment5;
900: End If;
901: If (p_rec.segment6 = hr_api.g_varchar2) then
902: p_rec.segment6 :=
903: pay_btl_shd.g_old_rec.segment6;
899: pay_btl_shd.g_old_rec.segment5;
900: End If;
901: If (p_rec.segment6 = hr_api.g_varchar2) then
902: p_rec.segment6 :=
903: pay_btl_shd.g_old_rec.segment6;
904: End If;
905: If (p_rec.segment7 = hr_api.g_varchar2) then
906: p_rec.segment7 :=
907: pay_btl_shd.g_old_rec.segment7;
903: pay_btl_shd.g_old_rec.segment6;
904: End If;
905: If (p_rec.segment7 = hr_api.g_varchar2) then
906: p_rec.segment7 :=
907: pay_btl_shd.g_old_rec.segment7;
908: End If;
909: If (p_rec.segment8 = hr_api.g_varchar2) then
910: p_rec.segment8 :=
911: pay_btl_shd.g_old_rec.segment8;
907: pay_btl_shd.g_old_rec.segment7;
908: End If;
909: If (p_rec.segment8 = hr_api.g_varchar2) then
910: p_rec.segment8 :=
911: pay_btl_shd.g_old_rec.segment8;
912: End If;
913: If (p_rec.segment9 = hr_api.g_varchar2) then
914: p_rec.segment9 :=
915: pay_btl_shd.g_old_rec.segment9;
911: pay_btl_shd.g_old_rec.segment8;
912: End If;
913: If (p_rec.segment9 = hr_api.g_varchar2) then
914: p_rec.segment9 :=
915: pay_btl_shd.g_old_rec.segment9;
916: End If;
917: If (p_rec.segment10 = hr_api.g_varchar2) then
918: p_rec.segment10 :=
919: pay_btl_shd.g_old_rec.segment10;
915: pay_btl_shd.g_old_rec.segment9;
916: End If;
917: If (p_rec.segment10 = hr_api.g_varchar2) then
918: p_rec.segment10 :=
919: pay_btl_shd.g_old_rec.segment10;
920: End If;
921: If (p_rec.segment11 = hr_api.g_varchar2) then
922: p_rec.segment11 :=
923: pay_btl_shd.g_old_rec.segment11;
919: pay_btl_shd.g_old_rec.segment10;
920: End If;
921: If (p_rec.segment11 = hr_api.g_varchar2) then
922: p_rec.segment11 :=
923: pay_btl_shd.g_old_rec.segment11;
924: End If;
925: If (p_rec.segment12 = hr_api.g_varchar2) then
926: p_rec.segment12 :=
927: pay_btl_shd.g_old_rec.segment12;
923: pay_btl_shd.g_old_rec.segment11;
924: End If;
925: If (p_rec.segment12 = hr_api.g_varchar2) then
926: p_rec.segment12 :=
927: pay_btl_shd.g_old_rec.segment12;
928: End If;
929: If (p_rec.segment13 = hr_api.g_varchar2) then
930: p_rec.segment13 :=
931: pay_btl_shd.g_old_rec.segment13;
927: pay_btl_shd.g_old_rec.segment12;
928: End If;
929: If (p_rec.segment13 = hr_api.g_varchar2) then
930: p_rec.segment13 :=
931: pay_btl_shd.g_old_rec.segment13;
932: End If;
933: If (p_rec.segment14 = hr_api.g_varchar2) then
934: p_rec.segment14 :=
935: pay_btl_shd.g_old_rec.segment14;
931: pay_btl_shd.g_old_rec.segment13;
932: End If;
933: If (p_rec.segment14 = hr_api.g_varchar2) then
934: p_rec.segment14 :=
935: pay_btl_shd.g_old_rec.segment14;
936: End If;
937: If (p_rec.segment15 = hr_api.g_varchar2) then
938: p_rec.segment15 :=
939: pay_btl_shd.g_old_rec.segment15;
935: pay_btl_shd.g_old_rec.segment14;
936: End If;
937: If (p_rec.segment15 = hr_api.g_varchar2) then
938: p_rec.segment15 :=
939: pay_btl_shd.g_old_rec.segment15;
940: End If;
941: If (p_rec.segment16 = hr_api.g_varchar2) then
942: p_rec.segment16 :=
943: pay_btl_shd.g_old_rec.segment16;
939: pay_btl_shd.g_old_rec.segment15;
940: End If;
941: If (p_rec.segment16 = hr_api.g_varchar2) then
942: p_rec.segment16 :=
943: pay_btl_shd.g_old_rec.segment16;
944: End If;
945: If (p_rec.segment17 = hr_api.g_varchar2) then
946: p_rec.segment17 :=
947: pay_btl_shd.g_old_rec.segment17;
943: pay_btl_shd.g_old_rec.segment16;
944: End If;
945: If (p_rec.segment17 = hr_api.g_varchar2) then
946: p_rec.segment17 :=
947: pay_btl_shd.g_old_rec.segment17;
948: End If;
949: If (p_rec.segment18 = hr_api.g_varchar2) then
950: p_rec.segment18 :=
951: pay_btl_shd.g_old_rec.segment18;
947: pay_btl_shd.g_old_rec.segment17;
948: End If;
949: If (p_rec.segment18 = hr_api.g_varchar2) then
950: p_rec.segment18 :=
951: pay_btl_shd.g_old_rec.segment18;
952: End If;
953: If (p_rec.segment19 = hr_api.g_varchar2) then
954: p_rec.segment19 :=
955: pay_btl_shd.g_old_rec.segment19;
951: pay_btl_shd.g_old_rec.segment18;
952: End If;
953: If (p_rec.segment19 = hr_api.g_varchar2) then
954: p_rec.segment19 :=
955: pay_btl_shd.g_old_rec.segment19;
956: End If;
957: If (p_rec.segment20 = hr_api.g_varchar2) then
958: p_rec.segment20 :=
959: pay_btl_shd.g_old_rec.segment20;
955: pay_btl_shd.g_old_rec.segment19;
956: End If;
957: If (p_rec.segment20 = hr_api.g_varchar2) then
958: p_rec.segment20 :=
959: pay_btl_shd.g_old_rec.segment20;
960: End If;
961: If (p_rec.segment21 = hr_api.g_varchar2) then
962: p_rec.segment21 :=
963: pay_btl_shd.g_old_rec.segment21;
959: pay_btl_shd.g_old_rec.segment20;
960: End If;
961: If (p_rec.segment21 = hr_api.g_varchar2) then
962: p_rec.segment21 :=
963: pay_btl_shd.g_old_rec.segment21;
964: End If;
965: If (p_rec.segment22 = hr_api.g_varchar2) then
966: p_rec.segment22 :=
967: pay_btl_shd.g_old_rec.segment22;
963: pay_btl_shd.g_old_rec.segment21;
964: End If;
965: If (p_rec.segment22 = hr_api.g_varchar2) then
966: p_rec.segment22 :=
967: pay_btl_shd.g_old_rec.segment22;
968: End If;
969: If (p_rec.segment23 = hr_api.g_varchar2) then
970: p_rec.segment23 :=
971: pay_btl_shd.g_old_rec.segment23;
967: pay_btl_shd.g_old_rec.segment22;
968: End If;
969: If (p_rec.segment23 = hr_api.g_varchar2) then
970: p_rec.segment23 :=
971: pay_btl_shd.g_old_rec.segment23;
972: End If;
973: If (p_rec.segment24 = hr_api.g_varchar2) then
974: p_rec.segment24 :=
975: pay_btl_shd.g_old_rec.segment24;
971: pay_btl_shd.g_old_rec.segment23;
972: End If;
973: If (p_rec.segment24 = hr_api.g_varchar2) then
974: p_rec.segment24 :=
975: pay_btl_shd.g_old_rec.segment24;
976: End If;
977: If (p_rec.segment25 = hr_api.g_varchar2) then
978: p_rec.segment25 :=
979: pay_btl_shd.g_old_rec.segment25;
975: pay_btl_shd.g_old_rec.segment24;
976: End If;
977: If (p_rec.segment25 = hr_api.g_varchar2) then
978: p_rec.segment25 :=
979: pay_btl_shd.g_old_rec.segment25;
980: End If;
981: If (p_rec.segment26 = hr_api.g_varchar2) then
982: p_rec.segment26 :=
983: pay_btl_shd.g_old_rec.segment26;
979: pay_btl_shd.g_old_rec.segment25;
980: End If;
981: If (p_rec.segment26 = hr_api.g_varchar2) then
982: p_rec.segment26 :=
983: pay_btl_shd.g_old_rec.segment26;
984: End If;
985: If (p_rec.segment27 = hr_api.g_varchar2) then
986: p_rec.segment27 :=
987: pay_btl_shd.g_old_rec.segment27;
983: pay_btl_shd.g_old_rec.segment26;
984: End If;
985: If (p_rec.segment27 = hr_api.g_varchar2) then
986: p_rec.segment27 :=
987: pay_btl_shd.g_old_rec.segment27;
988: End If;
989: If (p_rec.segment28 = hr_api.g_varchar2) then
990: p_rec.segment28 :=
991: pay_btl_shd.g_old_rec.segment28;
987: pay_btl_shd.g_old_rec.segment27;
988: End If;
989: If (p_rec.segment28 = hr_api.g_varchar2) then
990: p_rec.segment28 :=
991: pay_btl_shd.g_old_rec.segment28;
992: End If;
993: If (p_rec.segment29 = hr_api.g_varchar2) then
994: p_rec.segment29 :=
995: pay_btl_shd.g_old_rec.segment29;
991: pay_btl_shd.g_old_rec.segment28;
992: End If;
993: If (p_rec.segment29 = hr_api.g_varchar2) then
994: p_rec.segment29 :=
995: pay_btl_shd.g_old_rec.segment29;
996: End If;
997: If (p_rec.segment30 = hr_api.g_varchar2) then
998: p_rec.segment30 :=
999: pay_btl_shd.g_old_rec.segment30;
995: pay_btl_shd.g_old_rec.segment29;
996: End If;
997: If (p_rec.segment30 = hr_api.g_varchar2) then
998: p_rec.segment30 :=
999: pay_btl_shd.g_old_rec.segment30;
1000: End If;
1001: If (p_rec.value_1 = hr_api.g_varchar2) then
1002: p_rec.value_1 :=
1003: pay_btl_shd.g_old_rec.value_1;
999: pay_btl_shd.g_old_rec.segment30;
1000: End If;
1001: If (p_rec.value_1 = hr_api.g_varchar2) then
1002: p_rec.value_1 :=
1003: pay_btl_shd.g_old_rec.value_1;
1004: End If;
1005: If (p_rec.value_2 = hr_api.g_varchar2) then
1006: p_rec.value_2 :=
1007: pay_btl_shd.g_old_rec.value_2;
1003: pay_btl_shd.g_old_rec.value_1;
1004: End If;
1005: If (p_rec.value_2 = hr_api.g_varchar2) then
1006: p_rec.value_2 :=
1007: pay_btl_shd.g_old_rec.value_2;
1008: End If;
1009: If (p_rec.value_3 = hr_api.g_varchar2) then
1010: p_rec.value_3 :=
1011: pay_btl_shd.g_old_rec.value_3;
1007: pay_btl_shd.g_old_rec.value_2;
1008: End If;
1009: If (p_rec.value_3 = hr_api.g_varchar2) then
1010: p_rec.value_3 :=
1011: pay_btl_shd.g_old_rec.value_3;
1012: End If;
1013: If (p_rec.value_4 = hr_api.g_varchar2) then
1014: p_rec.value_4 :=
1015: pay_btl_shd.g_old_rec.value_4;
1011: pay_btl_shd.g_old_rec.value_3;
1012: End If;
1013: If (p_rec.value_4 = hr_api.g_varchar2) then
1014: p_rec.value_4 :=
1015: pay_btl_shd.g_old_rec.value_4;
1016: End If;
1017: If (p_rec.value_5 = hr_api.g_varchar2) then
1018: p_rec.value_5 :=
1019: pay_btl_shd.g_old_rec.value_5;
1015: pay_btl_shd.g_old_rec.value_4;
1016: End If;
1017: If (p_rec.value_5 = hr_api.g_varchar2) then
1018: p_rec.value_5 :=
1019: pay_btl_shd.g_old_rec.value_5;
1020: End If;
1021: If (p_rec.value_6 = hr_api.g_varchar2) then
1022: p_rec.value_6 :=
1023: pay_btl_shd.g_old_rec.value_6;
1019: pay_btl_shd.g_old_rec.value_5;
1020: End If;
1021: If (p_rec.value_6 = hr_api.g_varchar2) then
1022: p_rec.value_6 :=
1023: pay_btl_shd.g_old_rec.value_6;
1024: End If;
1025: If (p_rec.value_7 = hr_api.g_varchar2) then
1026: p_rec.value_7 :=
1027: pay_btl_shd.g_old_rec.value_7;
1023: pay_btl_shd.g_old_rec.value_6;
1024: End If;
1025: If (p_rec.value_7 = hr_api.g_varchar2) then
1026: p_rec.value_7 :=
1027: pay_btl_shd.g_old_rec.value_7;
1028: End If;
1029: If (p_rec.value_8 = hr_api.g_varchar2) then
1030: p_rec.value_8 :=
1031: pay_btl_shd.g_old_rec.value_8;
1027: pay_btl_shd.g_old_rec.value_7;
1028: End If;
1029: If (p_rec.value_8 = hr_api.g_varchar2) then
1030: p_rec.value_8 :=
1031: pay_btl_shd.g_old_rec.value_8;
1032: End If;
1033: If (p_rec.value_9 = hr_api.g_varchar2) then
1034: p_rec.value_9 :=
1035: pay_btl_shd.g_old_rec.value_9;
1031: pay_btl_shd.g_old_rec.value_8;
1032: End If;
1033: If (p_rec.value_9 = hr_api.g_varchar2) then
1034: p_rec.value_9 :=
1035: pay_btl_shd.g_old_rec.value_9;
1036: End If;
1037: If (p_rec.value_10 = hr_api.g_varchar2) then
1038: p_rec.value_10 :=
1039: pay_btl_shd.g_old_rec.value_10;
1035: pay_btl_shd.g_old_rec.value_9;
1036: End If;
1037: If (p_rec.value_10 = hr_api.g_varchar2) then
1038: p_rec.value_10 :=
1039: pay_btl_shd.g_old_rec.value_10;
1040: End If;
1041: If (p_rec.value_11 = hr_api.g_varchar2) then
1042: p_rec.value_11 :=
1043: pay_btl_shd.g_old_rec.value_11;
1039: pay_btl_shd.g_old_rec.value_10;
1040: End If;
1041: If (p_rec.value_11 = hr_api.g_varchar2) then
1042: p_rec.value_11 :=
1043: pay_btl_shd.g_old_rec.value_11;
1044: End If;
1045: If (p_rec.value_12 = hr_api.g_varchar2) then
1046: p_rec.value_12 :=
1047: pay_btl_shd.g_old_rec.value_12;
1043: pay_btl_shd.g_old_rec.value_11;
1044: End If;
1045: If (p_rec.value_12 = hr_api.g_varchar2) then
1046: p_rec.value_12 :=
1047: pay_btl_shd.g_old_rec.value_12;
1048: End If;
1049: If (p_rec.value_13 = hr_api.g_varchar2) then
1050: p_rec.value_13 :=
1051: pay_btl_shd.g_old_rec.value_13;
1047: pay_btl_shd.g_old_rec.value_12;
1048: End If;
1049: If (p_rec.value_13 = hr_api.g_varchar2) then
1050: p_rec.value_13 :=
1051: pay_btl_shd.g_old_rec.value_13;
1052: End If;
1053: If (p_rec.value_14 = hr_api.g_varchar2) then
1054: p_rec.value_14 :=
1055: pay_btl_shd.g_old_rec.value_14;
1051: pay_btl_shd.g_old_rec.value_13;
1052: End If;
1053: If (p_rec.value_14 = hr_api.g_varchar2) then
1054: p_rec.value_14 :=
1055: pay_btl_shd.g_old_rec.value_14;
1056: End If;
1057: If (p_rec.value_15 = hr_api.g_varchar2) then
1058: p_rec.value_15 :=
1059: pay_btl_shd.g_old_rec.value_15;
1055: pay_btl_shd.g_old_rec.value_14;
1056: End If;
1057: If (p_rec.value_15 = hr_api.g_varchar2) then
1058: p_rec.value_15 :=
1059: pay_btl_shd.g_old_rec.value_15;
1060: End If;
1061: If (p_rec.attribute_category = hr_api.g_varchar2) then
1062: p_rec.attribute_category :=
1063: pay_btl_shd.g_old_rec.attribute_category;
1059: pay_btl_shd.g_old_rec.value_15;
1060: End If;
1061: If (p_rec.attribute_category = hr_api.g_varchar2) then
1062: p_rec.attribute_category :=
1063: pay_btl_shd.g_old_rec.attribute_category;
1064: End If;
1065: If (p_rec.attribute1 = hr_api.g_varchar2) then
1066: p_rec.attribute1 :=
1067: pay_btl_shd.g_old_rec.attribute1;
1063: pay_btl_shd.g_old_rec.attribute_category;
1064: End If;
1065: If (p_rec.attribute1 = hr_api.g_varchar2) then
1066: p_rec.attribute1 :=
1067: pay_btl_shd.g_old_rec.attribute1;
1068: End If;
1069: If (p_rec.attribute2 = hr_api.g_varchar2) then
1070: p_rec.attribute2 :=
1071: pay_btl_shd.g_old_rec.attribute2;
1067: pay_btl_shd.g_old_rec.attribute1;
1068: End If;
1069: If (p_rec.attribute2 = hr_api.g_varchar2) then
1070: p_rec.attribute2 :=
1071: pay_btl_shd.g_old_rec.attribute2;
1072: End If;
1073: If (p_rec.attribute3 = hr_api.g_varchar2) then
1074: p_rec.attribute3 :=
1075: pay_btl_shd.g_old_rec.attribute3;
1071: pay_btl_shd.g_old_rec.attribute2;
1072: End If;
1073: If (p_rec.attribute3 = hr_api.g_varchar2) then
1074: p_rec.attribute3 :=
1075: pay_btl_shd.g_old_rec.attribute3;
1076: End If;
1077: If (p_rec.attribute4 = hr_api.g_varchar2) then
1078: p_rec.attribute4 :=
1079: pay_btl_shd.g_old_rec.attribute4;
1075: pay_btl_shd.g_old_rec.attribute3;
1076: End If;
1077: If (p_rec.attribute4 = hr_api.g_varchar2) then
1078: p_rec.attribute4 :=
1079: pay_btl_shd.g_old_rec.attribute4;
1080: End If;
1081: If (p_rec.attribute5 = hr_api.g_varchar2) then
1082: p_rec.attribute5 :=
1083: pay_btl_shd.g_old_rec.attribute5;
1079: pay_btl_shd.g_old_rec.attribute4;
1080: End If;
1081: If (p_rec.attribute5 = hr_api.g_varchar2) then
1082: p_rec.attribute5 :=
1083: pay_btl_shd.g_old_rec.attribute5;
1084: End If;
1085: If (p_rec.attribute6 = hr_api.g_varchar2) then
1086: p_rec.attribute6 :=
1087: pay_btl_shd.g_old_rec.attribute6;
1083: pay_btl_shd.g_old_rec.attribute5;
1084: End If;
1085: If (p_rec.attribute6 = hr_api.g_varchar2) then
1086: p_rec.attribute6 :=
1087: pay_btl_shd.g_old_rec.attribute6;
1088: End If;
1089: If (p_rec.attribute7 = hr_api.g_varchar2) then
1090: p_rec.attribute7 :=
1091: pay_btl_shd.g_old_rec.attribute7;
1087: pay_btl_shd.g_old_rec.attribute6;
1088: End If;
1089: If (p_rec.attribute7 = hr_api.g_varchar2) then
1090: p_rec.attribute7 :=
1091: pay_btl_shd.g_old_rec.attribute7;
1092: End If;
1093: If (p_rec.attribute8 = hr_api.g_varchar2) then
1094: p_rec.attribute8 :=
1095: pay_btl_shd.g_old_rec.attribute8;
1091: pay_btl_shd.g_old_rec.attribute7;
1092: End If;
1093: If (p_rec.attribute8 = hr_api.g_varchar2) then
1094: p_rec.attribute8 :=
1095: pay_btl_shd.g_old_rec.attribute8;
1096: End If;
1097: If (p_rec.attribute9 = hr_api.g_varchar2) then
1098: p_rec.attribute9 :=
1099: pay_btl_shd.g_old_rec.attribute9;
1095: pay_btl_shd.g_old_rec.attribute8;
1096: End If;
1097: If (p_rec.attribute9 = hr_api.g_varchar2) then
1098: p_rec.attribute9 :=
1099: pay_btl_shd.g_old_rec.attribute9;
1100: End If;
1101: If (p_rec.attribute10 = hr_api.g_varchar2) then
1102: p_rec.attribute10 :=
1103: pay_btl_shd.g_old_rec.attribute10;
1099: pay_btl_shd.g_old_rec.attribute9;
1100: End If;
1101: If (p_rec.attribute10 = hr_api.g_varchar2) then
1102: p_rec.attribute10 :=
1103: pay_btl_shd.g_old_rec.attribute10;
1104: End If;
1105: If (p_rec.attribute11 = hr_api.g_varchar2) then
1106: p_rec.attribute11 :=
1107: pay_btl_shd.g_old_rec.attribute11;
1103: pay_btl_shd.g_old_rec.attribute10;
1104: End If;
1105: If (p_rec.attribute11 = hr_api.g_varchar2) then
1106: p_rec.attribute11 :=
1107: pay_btl_shd.g_old_rec.attribute11;
1108: End If;
1109: If (p_rec.attribute12 = hr_api.g_varchar2) then
1110: p_rec.attribute12 :=
1111: pay_btl_shd.g_old_rec.attribute12;
1107: pay_btl_shd.g_old_rec.attribute11;
1108: End If;
1109: If (p_rec.attribute12 = hr_api.g_varchar2) then
1110: p_rec.attribute12 :=
1111: pay_btl_shd.g_old_rec.attribute12;
1112: End If;
1113: If (p_rec.attribute13 = hr_api.g_varchar2) then
1114: p_rec.attribute13 :=
1115: pay_btl_shd.g_old_rec.attribute13;
1111: pay_btl_shd.g_old_rec.attribute12;
1112: End If;
1113: If (p_rec.attribute13 = hr_api.g_varchar2) then
1114: p_rec.attribute13 :=
1115: pay_btl_shd.g_old_rec.attribute13;
1116: End If;
1117: If (p_rec.attribute14 = hr_api.g_varchar2) then
1118: p_rec.attribute14 :=
1119: pay_btl_shd.g_old_rec.attribute14;
1115: pay_btl_shd.g_old_rec.attribute13;
1116: End If;
1117: If (p_rec.attribute14 = hr_api.g_varchar2) then
1118: p_rec.attribute14 :=
1119: pay_btl_shd.g_old_rec.attribute14;
1120: End If;
1121: If (p_rec.attribute15 = hr_api.g_varchar2) then
1122: p_rec.attribute15 :=
1123: pay_btl_shd.g_old_rec.attribute15;
1119: pay_btl_shd.g_old_rec.attribute14;
1120: End If;
1121: If (p_rec.attribute15 = hr_api.g_varchar2) then
1122: p_rec.attribute15 :=
1123: pay_btl_shd.g_old_rec.attribute15;
1124: End If;
1125: If (p_rec.attribute16 = hr_api.g_varchar2) then
1126: p_rec.attribute16 :=
1127: pay_btl_shd.g_old_rec.attribute16;
1123: pay_btl_shd.g_old_rec.attribute15;
1124: End If;
1125: If (p_rec.attribute16 = hr_api.g_varchar2) then
1126: p_rec.attribute16 :=
1127: pay_btl_shd.g_old_rec.attribute16;
1128: End If;
1129: If (p_rec.attribute17 = hr_api.g_varchar2) then
1130: p_rec.attribute17 :=
1131: pay_btl_shd.g_old_rec.attribute17;
1127: pay_btl_shd.g_old_rec.attribute16;
1128: End If;
1129: If (p_rec.attribute17 = hr_api.g_varchar2) then
1130: p_rec.attribute17 :=
1131: pay_btl_shd.g_old_rec.attribute17;
1132: End If;
1133: If (p_rec.attribute18 = hr_api.g_varchar2) then
1134: p_rec.attribute18 :=
1135: pay_btl_shd.g_old_rec.attribute18;
1131: pay_btl_shd.g_old_rec.attribute17;
1132: End If;
1133: If (p_rec.attribute18 = hr_api.g_varchar2) then
1134: p_rec.attribute18 :=
1135: pay_btl_shd.g_old_rec.attribute18;
1136: End If;
1137: If (p_rec.attribute19 = hr_api.g_varchar2) then
1138: p_rec.attribute19 :=
1139: pay_btl_shd.g_old_rec.attribute19;
1135: pay_btl_shd.g_old_rec.attribute18;
1136: End If;
1137: If (p_rec.attribute19 = hr_api.g_varchar2) then
1138: p_rec.attribute19 :=
1139: pay_btl_shd.g_old_rec.attribute19;
1140: End If;
1141: If (p_rec.attribute20 = hr_api.g_varchar2) then
1142: p_rec.attribute20 :=
1143: pay_btl_shd.g_old_rec.attribute20;
1139: pay_btl_shd.g_old_rec.attribute19;
1140: End If;
1141: If (p_rec.attribute20 = hr_api.g_varchar2) then
1142: p_rec.attribute20 :=
1143: pay_btl_shd.g_old_rec.attribute20;
1144: End If;
1145: If (p_rec.entry_information_category = hr_api.g_varchar2) then
1146: p_rec.entry_information_category :=
1147: pay_btl_shd.g_old_rec.entry_information_category;
1143: pay_btl_shd.g_old_rec.attribute20;
1144: End If;
1145: If (p_rec.entry_information_category = hr_api.g_varchar2) then
1146: p_rec.entry_information_category :=
1147: pay_btl_shd.g_old_rec.entry_information_category;
1148: End If;
1149: If (p_rec.entry_information1 = hr_api.g_varchar2) then
1150: p_rec.entry_information1 :=
1151: pay_btl_shd.g_old_rec.entry_information1;
1147: pay_btl_shd.g_old_rec.entry_information_category;
1148: End If;
1149: If (p_rec.entry_information1 = hr_api.g_varchar2) then
1150: p_rec.entry_information1 :=
1151: pay_btl_shd.g_old_rec.entry_information1;
1152: End If;
1153: If (p_rec.entry_information2 = hr_api.g_varchar2) then
1154: p_rec.entry_information2 :=
1155: pay_btl_shd.g_old_rec.entry_information2;
1151: pay_btl_shd.g_old_rec.entry_information1;
1152: End If;
1153: If (p_rec.entry_information2 = hr_api.g_varchar2) then
1154: p_rec.entry_information2 :=
1155: pay_btl_shd.g_old_rec.entry_information2;
1156: End If;
1157: If (p_rec.entry_information3 = hr_api.g_varchar2) then
1158: p_rec.entry_information3 :=
1159: pay_btl_shd.g_old_rec.entry_information3;
1155: pay_btl_shd.g_old_rec.entry_information2;
1156: End If;
1157: If (p_rec.entry_information3 = hr_api.g_varchar2) then
1158: p_rec.entry_information3 :=
1159: pay_btl_shd.g_old_rec.entry_information3;
1160: End If;
1161: If (p_rec.entry_information4 = hr_api.g_varchar2) then
1162: p_rec.entry_information4 :=
1163: pay_btl_shd.g_old_rec.entry_information4;
1159: pay_btl_shd.g_old_rec.entry_information3;
1160: End If;
1161: If (p_rec.entry_information4 = hr_api.g_varchar2) then
1162: p_rec.entry_information4 :=
1163: pay_btl_shd.g_old_rec.entry_information4;
1164: End If;
1165: If (p_rec.entry_information5 = hr_api.g_varchar2) then
1166: p_rec.entry_information5 :=
1167: pay_btl_shd.g_old_rec.entry_information5;
1163: pay_btl_shd.g_old_rec.entry_information4;
1164: End If;
1165: If (p_rec.entry_information5 = hr_api.g_varchar2) then
1166: p_rec.entry_information5 :=
1167: pay_btl_shd.g_old_rec.entry_information5;
1168: End If;
1169: If (p_rec.entry_information6 = hr_api.g_varchar2) then
1170: p_rec.entry_information6 :=
1171: pay_btl_shd.g_old_rec.entry_information6;
1167: pay_btl_shd.g_old_rec.entry_information5;
1168: End If;
1169: If (p_rec.entry_information6 = hr_api.g_varchar2) then
1170: p_rec.entry_information6 :=
1171: pay_btl_shd.g_old_rec.entry_information6;
1172: End If;
1173: If (p_rec.entry_information7 = hr_api.g_varchar2) then
1174: p_rec.entry_information7 :=
1175: pay_btl_shd.g_old_rec.entry_information7;
1171: pay_btl_shd.g_old_rec.entry_information6;
1172: End If;
1173: If (p_rec.entry_information7 = hr_api.g_varchar2) then
1174: p_rec.entry_information7 :=
1175: pay_btl_shd.g_old_rec.entry_information7;
1176: End If;
1177: If (p_rec.entry_information8 = hr_api.g_varchar2) then
1178: p_rec.entry_information8 :=
1179: pay_btl_shd.g_old_rec.entry_information8;
1175: pay_btl_shd.g_old_rec.entry_information7;
1176: End If;
1177: If (p_rec.entry_information8 = hr_api.g_varchar2) then
1178: p_rec.entry_information8 :=
1179: pay_btl_shd.g_old_rec.entry_information8;
1180: End If;
1181: If (p_rec.entry_information9 = hr_api.g_varchar2) then
1182: p_rec.entry_information9 :=
1183: pay_btl_shd.g_old_rec.entry_information9;
1179: pay_btl_shd.g_old_rec.entry_information8;
1180: End If;
1181: If (p_rec.entry_information9 = hr_api.g_varchar2) then
1182: p_rec.entry_information9 :=
1183: pay_btl_shd.g_old_rec.entry_information9;
1184: End If;
1185: If (p_rec.entry_information10 = hr_api.g_varchar2) then
1186: p_rec.entry_information10 :=
1187: pay_btl_shd.g_old_rec.entry_information10;
1183: pay_btl_shd.g_old_rec.entry_information9;
1184: End If;
1185: If (p_rec.entry_information10 = hr_api.g_varchar2) then
1186: p_rec.entry_information10 :=
1187: pay_btl_shd.g_old_rec.entry_information10;
1188: End If;
1189: If (p_rec.entry_information11 = hr_api.g_varchar2) then
1190: p_rec.entry_information11 :=
1191: pay_btl_shd.g_old_rec.entry_information11;
1187: pay_btl_shd.g_old_rec.entry_information10;
1188: End If;
1189: If (p_rec.entry_information11 = hr_api.g_varchar2) then
1190: p_rec.entry_information11 :=
1191: pay_btl_shd.g_old_rec.entry_information11;
1192: End If;
1193: If (p_rec.entry_information12 = hr_api.g_varchar2) then
1194: p_rec.entry_information12 :=
1195: pay_btl_shd.g_old_rec.entry_information12;
1191: pay_btl_shd.g_old_rec.entry_information11;
1192: End If;
1193: If (p_rec.entry_information12 = hr_api.g_varchar2) then
1194: p_rec.entry_information12 :=
1195: pay_btl_shd.g_old_rec.entry_information12;
1196: End If;
1197: If (p_rec.entry_information13 = hr_api.g_varchar2) then
1198: p_rec.entry_information13 :=
1199: pay_btl_shd.g_old_rec.entry_information13;
1195: pay_btl_shd.g_old_rec.entry_information12;
1196: End If;
1197: If (p_rec.entry_information13 = hr_api.g_varchar2) then
1198: p_rec.entry_information13 :=
1199: pay_btl_shd.g_old_rec.entry_information13;
1200: End If;
1201: If (p_rec.entry_information14 = hr_api.g_varchar2) then
1202: p_rec.entry_information14 :=
1203: pay_btl_shd.g_old_rec.entry_information14;
1199: pay_btl_shd.g_old_rec.entry_information13;
1200: End If;
1201: If (p_rec.entry_information14 = hr_api.g_varchar2) then
1202: p_rec.entry_information14 :=
1203: pay_btl_shd.g_old_rec.entry_information14;
1204: End If;
1205: If (p_rec.entry_information15 = hr_api.g_varchar2) then
1206: p_rec.entry_information15 :=
1207: pay_btl_shd.g_old_rec.entry_information15;
1203: pay_btl_shd.g_old_rec.entry_information14;
1204: End If;
1205: If (p_rec.entry_information15 = hr_api.g_varchar2) then
1206: p_rec.entry_information15 :=
1207: pay_btl_shd.g_old_rec.entry_information15;
1208: End If;
1209: If (p_rec.entry_information16 = hr_api.g_varchar2) then
1210: p_rec.entry_information16 :=
1211: pay_btl_shd.g_old_rec.entry_information16;
1207: pay_btl_shd.g_old_rec.entry_information15;
1208: End If;
1209: If (p_rec.entry_information16 = hr_api.g_varchar2) then
1210: p_rec.entry_information16 :=
1211: pay_btl_shd.g_old_rec.entry_information16;
1212: End If;
1213: If (p_rec.entry_information17 = hr_api.g_varchar2) then
1214: p_rec.entry_information17 :=
1215: pay_btl_shd.g_old_rec.entry_information17;
1211: pay_btl_shd.g_old_rec.entry_information16;
1212: End If;
1213: If (p_rec.entry_information17 = hr_api.g_varchar2) then
1214: p_rec.entry_information17 :=
1215: pay_btl_shd.g_old_rec.entry_information17;
1216: End If;
1217: If (p_rec.entry_information18 = hr_api.g_varchar2) then
1218: p_rec.entry_information18 :=
1219: pay_btl_shd.g_old_rec.entry_information18;
1215: pay_btl_shd.g_old_rec.entry_information17;
1216: End If;
1217: If (p_rec.entry_information18 = hr_api.g_varchar2) then
1218: p_rec.entry_information18 :=
1219: pay_btl_shd.g_old_rec.entry_information18;
1220: End If;
1221: If (p_rec.entry_information19 = hr_api.g_varchar2) then
1222: p_rec.entry_information19 :=
1223: pay_btl_shd.g_old_rec.entry_information19;
1219: pay_btl_shd.g_old_rec.entry_information18;
1220: End If;
1221: If (p_rec.entry_information19 = hr_api.g_varchar2) then
1222: p_rec.entry_information19 :=
1223: pay_btl_shd.g_old_rec.entry_information19;
1224: End If;
1225: If (p_rec.entry_information20 = hr_api.g_varchar2) then
1226: p_rec.entry_information20 :=
1227: pay_btl_shd.g_old_rec.entry_information20;
1223: pay_btl_shd.g_old_rec.entry_information19;
1224: End If;
1225: If (p_rec.entry_information20 = hr_api.g_varchar2) then
1226: p_rec.entry_information20 :=
1227: pay_btl_shd.g_old_rec.entry_information20;
1228: End If;
1229: If (p_rec.entry_information21 = hr_api.g_varchar2) then
1230: p_rec.entry_information21 :=
1231: pay_btl_shd.g_old_rec.entry_information21;
1227: pay_btl_shd.g_old_rec.entry_information20;
1228: End If;
1229: If (p_rec.entry_information21 = hr_api.g_varchar2) then
1230: p_rec.entry_information21 :=
1231: pay_btl_shd.g_old_rec.entry_information21;
1232: End If;
1233: If (p_rec.entry_information22 = hr_api.g_varchar2) then
1234: p_rec.entry_information22 :=
1235: pay_btl_shd.g_old_rec.entry_information22;
1231: pay_btl_shd.g_old_rec.entry_information21;
1232: End If;
1233: If (p_rec.entry_information22 = hr_api.g_varchar2) then
1234: p_rec.entry_information22 :=
1235: pay_btl_shd.g_old_rec.entry_information22;
1236: End If;
1237: If (p_rec.entry_information23 = hr_api.g_varchar2) then
1238: p_rec.entry_information23 :=
1239: pay_btl_shd.g_old_rec.entry_information23;
1235: pay_btl_shd.g_old_rec.entry_information22;
1236: End If;
1237: If (p_rec.entry_information23 = hr_api.g_varchar2) then
1238: p_rec.entry_information23 :=
1239: pay_btl_shd.g_old_rec.entry_information23;
1240: End If;
1241: If (p_rec.entry_information24 = hr_api.g_varchar2) then
1242: p_rec.entry_information24 :=
1243: pay_btl_shd.g_old_rec.entry_information24;
1239: pay_btl_shd.g_old_rec.entry_information23;
1240: End If;
1241: If (p_rec.entry_information24 = hr_api.g_varchar2) then
1242: p_rec.entry_information24 :=
1243: pay_btl_shd.g_old_rec.entry_information24;
1244: End If;
1245: If (p_rec.entry_information25 = hr_api.g_varchar2) then
1246: p_rec.entry_information25 :=
1247: pay_btl_shd.g_old_rec.entry_information25;
1243: pay_btl_shd.g_old_rec.entry_information24;
1244: End If;
1245: If (p_rec.entry_information25 = hr_api.g_varchar2) then
1246: p_rec.entry_information25 :=
1247: pay_btl_shd.g_old_rec.entry_information25;
1248: End If;
1249: If (p_rec.entry_information26 = hr_api.g_varchar2) then
1250: p_rec.entry_information26 :=
1251: pay_btl_shd.g_old_rec.entry_information26;
1247: pay_btl_shd.g_old_rec.entry_information25;
1248: End If;
1249: If (p_rec.entry_information26 = hr_api.g_varchar2) then
1250: p_rec.entry_information26 :=
1251: pay_btl_shd.g_old_rec.entry_information26;
1252: End If;
1253: If (p_rec.entry_information27 = hr_api.g_varchar2) then
1254: p_rec.entry_information27 :=
1255: pay_btl_shd.g_old_rec.entry_information27;
1251: pay_btl_shd.g_old_rec.entry_information26;
1252: End If;
1253: If (p_rec.entry_information27 = hr_api.g_varchar2) then
1254: p_rec.entry_information27 :=
1255: pay_btl_shd.g_old_rec.entry_information27;
1256: End If;
1257: If (p_rec.entry_information28 = hr_api.g_varchar2) then
1258: p_rec.entry_information28 :=
1259: pay_btl_shd.g_old_rec.entry_information28;
1255: pay_btl_shd.g_old_rec.entry_information27;
1256: End If;
1257: If (p_rec.entry_information28 = hr_api.g_varchar2) then
1258: p_rec.entry_information28 :=
1259: pay_btl_shd.g_old_rec.entry_information28;
1260: End If;
1261: If (p_rec.entry_information29 = hr_api.g_varchar2) then
1262: p_rec.entry_information29 :=
1263: pay_btl_shd.g_old_rec.entry_information29;
1259: pay_btl_shd.g_old_rec.entry_information28;
1260: End If;
1261: If (p_rec.entry_information29 = hr_api.g_varchar2) then
1262: p_rec.entry_information29 :=
1263: pay_btl_shd.g_old_rec.entry_information29;
1264: End If;
1265: If (p_rec.entry_information30 = hr_api.g_varchar2) then
1266: p_rec.entry_information30 :=
1267: pay_btl_shd.g_old_rec.entry_information30;
1263: pay_btl_shd.g_old_rec.entry_information29;
1264: End If;
1265: If (p_rec.entry_information30 = hr_api.g_varchar2) then
1266: p_rec.entry_information30 :=
1267: pay_btl_shd.g_old_rec.entry_information30;
1268: End If;
1269: If (p_rec.date_earned = hr_api.g_date) then
1270: p_rec.date_earned :=
1271: pay_btl_shd.g_old_rec.date_earned;
1267: pay_btl_shd.g_old_rec.entry_information30;
1268: End If;
1269: If (p_rec.date_earned = hr_api.g_date) then
1270: p_rec.date_earned :=
1271: pay_btl_shd.g_old_rec.date_earned;
1272: End If;
1273: If (p_rec.personal_payment_method_id = hr_api.g_number) then
1274: p_rec.personal_payment_method_id :=
1275: pay_btl_shd.g_old_rec.personal_payment_method_id;
1271: pay_btl_shd.g_old_rec.date_earned;
1272: End If;
1273: If (p_rec.personal_payment_method_id = hr_api.g_number) then
1274: p_rec.personal_payment_method_id :=
1275: pay_btl_shd.g_old_rec.personal_payment_method_id;
1276: End If;
1277: If (p_rec.subpriority = hr_api.g_number) then
1278: p_rec.subpriority :=
1279: pay_btl_shd.g_old_rec.subpriority;
1275: pay_btl_shd.g_old_rec.personal_payment_method_id;
1276: End If;
1277: If (p_rec.subpriority = hr_api.g_number) then
1278: p_rec.subpriority :=
1279: pay_btl_shd.g_old_rec.subpriority;
1280: End If;
1281: If (p_rec.effective_start_date = hr_api.g_date) then
1282: p_rec.effective_start_date :=
1283: pay_btl_shd.g_old_rec.effective_start_date;
1279: pay_btl_shd.g_old_rec.subpriority;
1280: End If;
1281: If (p_rec.effective_start_date = hr_api.g_date) then
1282: p_rec.effective_start_date :=
1283: pay_btl_shd.g_old_rec.effective_start_date;
1284: End If;
1285: If (p_rec.effective_end_date = hr_api.g_date) then
1286: p_rec.effective_end_date :=
1287: pay_btl_shd.g_old_rec.effective_end_date;
1283: pay_btl_shd.g_old_rec.effective_start_date;
1284: End If;
1285: If (p_rec.effective_end_date = hr_api.g_date) then
1286: p_rec.effective_end_date :=
1287: pay_btl_shd.g_old_rec.effective_end_date;
1288: End If;
1289: --
1290: End convert_defs;
1291: --
1293: -- |---------------------------------< upd >----------------------------------|
1294: -- ----------------------------------------------------------------------------
1295: Procedure upd
1296: (p_session_date in date
1297: ,p_rec in out nocopy pay_btl_shd.g_rec_type
1298: ) is
1299: --
1300: l_proc varchar2(72) := g_package||'upd';
1301: l_cost_allocation_keyflex_id pay_batch_lines.cost_allocation_keyflex_id%type;
1299: --
1300: l_proc varchar2(72) := g_package||'upd';
1301: l_cost_allocation_keyflex_id pay_batch_lines.cost_allocation_keyflex_id%type;
1302: l_concat_segments_out pay_batch_lines.concatenated_segments%type;
1303: l_segments pay_btl_shd.segment_value;
1304: l_segment_passed boolean;
1305: --
1306: Begin
1307: hr_utility.set_location('Entering:'||l_proc, 5);
1307: hr_utility.set_location('Entering:'||l_proc, 5);
1308: --
1309: -- We must lock the row which we need to update.
1310: --
1311: pay_btl_shd.lck
1312: (p_rec.batch_line_id
1313: ,p_rec.object_version_number
1314: );
1315:
1322: --
1323: l_segment_passed := false;
1324:
1325: if ( p_rec.cost_allocation_keyflex_id <> hr_api.g_number ) then
1326: l_segments := pay_btl_shd.segment_value( p_rec.segment1, p_rec.segment2, p_rec.segment3, p_rec.segment4,
1327: p_rec.segment5, p_rec.segment6, p_rec.segment7, p_rec.segment8,
1328: p_rec.segment9, p_rec.segment10,p_rec.segment11,p_rec.segment12,
1329: p_rec.segment13,p_rec.segment14,p_rec.segment15,p_rec.segment16,
1330: p_rec.segment17,p_rec.segment18,p_rec.segment19,p_rec.segment20,
1340: end if;
1341: end loop;
1342:
1343: if ( l_segment_passed = false ) then
1344: pay_btl_shd.get_flex_segs(p_rec);
1345: end if;
1346:
1347: end if;
1348:
1394: p_rec.segment29 is null and
1395: p_rec.segment30 is null) then
1396:
1397: l_cost_allocation_keyflex_id := p_rec.cost_allocation_keyflex_id;
1398: pay_btl_shd.keyflex_comb(
1399: p_dml_mode => 'UPDATE',
1400: p_appl_short_name => 'PAY',
1401: p_flex_code => 'COST',
1402: p_segment1 => p_rec.segment1,
1581: ,p_effective_start_date in date default hr_api.g_date
1582: ,p_effective_end_date in date default hr_api.g_date
1583: ) is
1584: --
1585: l_rec pay_btl_shd.g_rec_type;
1586: l_proc varchar2(72) := g_package||'upd';
1587: -- l_concat_segments_out varchar2(2000);
1588: -- l_cost_allocation_keyflex_id number;
1589: --
1594: -- l_rec structure.
1595: --
1596: -- l_cost_allocation_keyflex_id := p_cost_allocation_keyflex_id;
1597: l_rec :=
1598: pay_btl_shd.convert_args
1599: (p_batch_line_id
1600: ,p_cost_allocation_keyflex_id
1601: ,p_element_type_id
1602: ,p_assignment_id