DBA Data[Home] [Help]

APPS.PAY_PEL_UPD dependencies on PAY_PEL_SHD

Line 58: (p_rec in out nocopy pay_pel_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_pel_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

Line 83: pay_pel_shd.g_api_dml := true; -- Set the api dml status

79: ,p_base_key_column => 'element_link_id'
80: ,p_base_key_value => p_rec.element_link_id
81: );
82: --
83: pay_pel_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_element_links_f Row
86: --
87: update pay_element_links_f

Line 130: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

126: where element_link_id = p_rec.element_link_id
127: and effective_start_date = p_validation_start_date
128: and effective_end_date = p_validation_end_date;
129: --
130: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
131: --
132: -- Set the effective start and end dates
133: --
134: p_rec.effective_start_date := p_validation_start_date;

Line 142: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

138: hr_utility.set_location(' Leaving:'||l_proc, 15);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
143: pay_pel_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated

Line 143: pay_pel_shd.constraint_error

139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
143: pay_pel_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

Line 147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

143: pay_pel_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
148: pay_pel_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

Line 148: pay_pel_shd.constraint_error

144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
148: pay_pel_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
152: Raise;

Line 151: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
148: pay_pel_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
152: Raise;
153: End dt_update_dml;
154: --
155: -- ----------------------------------------------------------------------------

Line 187: (p_rec in out nocopy pay_pel_shd.g_rec_type

183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure update_dml
187: (p_rec in out nocopy pay_pel_shd.g_rec_type
188: ,p_effective_date in date
189: ,p_datetrack_mode in varchar2
190: ,p_validation_start_date in date
191: ,p_validation_end_date in date

Line 254: (p_rec in out nocopy pay_pel_shd.g_rec_type

250: --
251: -- {End Of Comments}
252: -- ----------------------------------------------------------------------------
253: Procedure dt_pre_update
254: (p_rec in out nocopy pay_pel_shd.g_rec_type
255: ,p_effective_date in date
256: ,p_datetrack_mode in varchar2
257: ,p_validation_start_date in date
258: ,p_validation_end_date in date

Line 271: pay_pel_shd.upd_effective_end_date

267: --
268: -- Update the current effective end date
269: --
270:
271: pay_pel_shd.upd_effective_end_date
272: (p_effective_date => p_effective_date
273: ,p_base_key_value => p_rec.element_link_id
274: ,p_new_effective_end_date => (p_validation_start_date - 1)
275: ,p_validation_start_date => p_validation_start_date

Line 340: (p_rec in out nocopy pay_pel_shd.g_rec_type

336: --
337: -- {End Of Comments}
338: -- ----------------------------------------------------------------------------
339: Procedure pre_update
340: (p_rec in out nocopy pay_pel_shd.g_rec_type
341: ,p_effective_date in date
342: ,p_datetrack_mode in varchar2
343: ,p_validation_start_date in date
344: ,p_validation_end_date in date

Line 362: pay_pel_shd.g_old_rec.comments) then

358: ,p_comment_text => p_rec.comments
359: );
360: -- Update the comments if they have changed
361: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
362: pay_pel_shd.g_old_rec.comments) then
363: hr_comm_api.upd(p_comment_id => p_rec.comment_id
364: ,p_source_table_name => 'PAY_ELEMENT_LINKS_F'
365: ,p_comment_text => p_rec.comments
366: );

Line 413: (p_rec in pay_pel_shd.g_rec_type

409: --
410: -- {End Of Comments}
411: -- ----------------------------------------------------------------------------
412: Procedure post_update
413: (p_rec in pay_pel_shd.g_rec_type
414: ,p_effective_date in date
415: ,p_datetrack_mode in varchar2
416: ,p_validation_start_date in date
417: ,p_validation_end_date in date

Line 534: => pay_pel_shd.g_old_rec.effective_start_date

530: => p_rec.attribute20
531: ,p_object_version_number
532: => p_rec.object_version_number
533: ,p_effective_start_date_o
534: => pay_pel_shd.g_old_rec.effective_start_date
535: ,p_effective_end_date_o
536: => pay_pel_shd.g_old_rec.effective_end_date
537: ,p_payroll_id_o
538: => pay_pel_shd.g_old_rec.payroll_id

Line 536: => pay_pel_shd.g_old_rec.effective_end_date

532: => p_rec.object_version_number
533: ,p_effective_start_date_o
534: => pay_pel_shd.g_old_rec.effective_start_date
535: ,p_effective_end_date_o
536: => pay_pel_shd.g_old_rec.effective_end_date
537: ,p_payroll_id_o
538: => pay_pel_shd.g_old_rec.payroll_id
539: ,p_job_id_o
540: => pay_pel_shd.g_old_rec.job_id

Line 538: => pay_pel_shd.g_old_rec.payroll_id

534: => pay_pel_shd.g_old_rec.effective_start_date
535: ,p_effective_end_date_o
536: => pay_pel_shd.g_old_rec.effective_end_date
537: ,p_payroll_id_o
538: => pay_pel_shd.g_old_rec.payroll_id
539: ,p_job_id_o
540: => pay_pel_shd.g_old_rec.job_id
541: ,p_position_id_o
542: => pay_pel_shd.g_old_rec.position_id

Line 540: => pay_pel_shd.g_old_rec.job_id

536: => pay_pel_shd.g_old_rec.effective_end_date
537: ,p_payroll_id_o
538: => pay_pel_shd.g_old_rec.payroll_id
539: ,p_job_id_o
540: => pay_pel_shd.g_old_rec.job_id
541: ,p_position_id_o
542: => pay_pel_shd.g_old_rec.position_id
543: ,p_people_group_id_o
544: => pay_pel_shd.g_old_rec.people_group_id

Line 542: => pay_pel_shd.g_old_rec.position_id

538: => pay_pel_shd.g_old_rec.payroll_id
539: ,p_job_id_o
540: => pay_pel_shd.g_old_rec.job_id
541: ,p_position_id_o
542: => pay_pel_shd.g_old_rec.position_id
543: ,p_people_group_id_o
544: => pay_pel_shd.g_old_rec.people_group_id
545: ,p_cost_allocation_keyflex_id_o
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id

Line 544: => pay_pel_shd.g_old_rec.people_group_id

540: => pay_pel_shd.g_old_rec.job_id
541: ,p_position_id_o
542: => pay_pel_shd.g_old_rec.position_id
543: ,p_people_group_id_o
544: => pay_pel_shd.g_old_rec.people_group_id
545: ,p_cost_allocation_keyflex_id_o
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
547: ,p_organization_id_o
548: => pay_pel_shd.g_old_rec.organization_id

Line 546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id

542: => pay_pel_shd.g_old_rec.position_id
543: ,p_people_group_id_o
544: => pay_pel_shd.g_old_rec.people_group_id
545: ,p_cost_allocation_keyflex_id_o
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
547: ,p_organization_id_o
548: => pay_pel_shd.g_old_rec.organization_id
549: ,p_element_type_id_o
550: => pay_pel_shd.g_old_rec.element_type_id

Line 548: => pay_pel_shd.g_old_rec.organization_id

544: => pay_pel_shd.g_old_rec.people_group_id
545: ,p_cost_allocation_keyflex_id_o
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
547: ,p_organization_id_o
548: => pay_pel_shd.g_old_rec.organization_id
549: ,p_element_type_id_o
550: => pay_pel_shd.g_old_rec.element_type_id
551: ,p_location_id_o
552: => pay_pel_shd.g_old_rec.location_id

Line 550: => pay_pel_shd.g_old_rec.element_type_id

546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
547: ,p_organization_id_o
548: => pay_pel_shd.g_old_rec.organization_id
549: ,p_element_type_id_o
550: => pay_pel_shd.g_old_rec.element_type_id
551: ,p_location_id_o
552: => pay_pel_shd.g_old_rec.location_id
553: ,p_grade_id_o
554: => pay_pel_shd.g_old_rec.grade_id

Line 552: => pay_pel_shd.g_old_rec.location_id

548: => pay_pel_shd.g_old_rec.organization_id
549: ,p_element_type_id_o
550: => pay_pel_shd.g_old_rec.element_type_id
551: ,p_location_id_o
552: => pay_pel_shd.g_old_rec.location_id
553: ,p_grade_id_o
554: => pay_pel_shd.g_old_rec.grade_id
555: ,p_balancing_keyflex_id_o
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id

Line 554: => pay_pel_shd.g_old_rec.grade_id

550: => pay_pel_shd.g_old_rec.element_type_id
551: ,p_location_id_o
552: => pay_pel_shd.g_old_rec.location_id
553: ,p_grade_id_o
554: => pay_pel_shd.g_old_rec.grade_id
555: ,p_balancing_keyflex_id_o
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
557: ,p_business_group_id_o
558: => pay_pel_shd.g_old_rec.business_group_id

Line 556: => pay_pel_shd.g_old_rec.balancing_keyflex_id

552: => pay_pel_shd.g_old_rec.location_id
553: ,p_grade_id_o
554: => pay_pel_shd.g_old_rec.grade_id
555: ,p_balancing_keyflex_id_o
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
557: ,p_business_group_id_o
558: => pay_pel_shd.g_old_rec.business_group_id
559: ,p_element_set_id_o
560: => pay_pel_shd.g_old_rec.element_set_id

Line 558: => pay_pel_shd.g_old_rec.business_group_id

554: => pay_pel_shd.g_old_rec.grade_id
555: ,p_balancing_keyflex_id_o
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
557: ,p_business_group_id_o
558: => pay_pel_shd.g_old_rec.business_group_id
559: ,p_element_set_id_o
560: => pay_pel_shd.g_old_rec.element_set_id
561: ,p_pay_basis_id_o
562: => pay_pel_shd.g_old_rec.pay_basis_id

Line 560: => pay_pel_shd.g_old_rec.element_set_id

556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
557: ,p_business_group_id_o
558: => pay_pel_shd.g_old_rec.business_group_id
559: ,p_element_set_id_o
560: => pay_pel_shd.g_old_rec.element_set_id
561: ,p_pay_basis_id_o
562: => pay_pel_shd.g_old_rec.pay_basis_id
563: ,p_costable_type_o
564: => pay_pel_shd.g_old_rec.costable_type

Line 562: => pay_pel_shd.g_old_rec.pay_basis_id

558: => pay_pel_shd.g_old_rec.business_group_id
559: ,p_element_set_id_o
560: => pay_pel_shd.g_old_rec.element_set_id
561: ,p_pay_basis_id_o
562: => pay_pel_shd.g_old_rec.pay_basis_id
563: ,p_costable_type_o
564: => pay_pel_shd.g_old_rec.costable_type
565: ,p_link_to_all_payrolls_flag_o
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag

Line 564: => pay_pel_shd.g_old_rec.costable_type

560: => pay_pel_shd.g_old_rec.element_set_id
561: ,p_pay_basis_id_o
562: => pay_pel_shd.g_old_rec.pay_basis_id
563: ,p_costable_type_o
564: => pay_pel_shd.g_old_rec.costable_type
565: ,p_link_to_all_payrolls_flag_o
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
567: ,p_multiply_value_flag_o
568: => pay_pel_shd.g_old_rec.multiply_value_flag

Line 566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag

562: => pay_pel_shd.g_old_rec.pay_basis_id
563: ,p_costable_type_o
564: => pay_pel_shd.g_old_rec.costable_type
565: ,p_link_to_all_payrolls_flag_o
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
567: ,p_multiply_value_flag_o
568: => pay_pel_shd.g_old_rec.multiply_value_flag
569: ,p_standard_link_flag_o
570: => pay_pel_shd.g_old_rec.standard_link_flag

Line 568: => pay_pel_shd.g_old_rec.multiply_value_flag

564: => pay_pel_shd.g_old_rec.costable_type
565: ,p_link_to_all_payrolls_flag_o
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
567: ,p_multiply_value_flag_o
568: => pay_pel_shd.g_old_rec.multiply_value_flag
569: ,p_standard_link_flag_o
570: => pay_pel_shd.g_old_rec.standard_link_flag
571: ,p_transfer_to_gl_flag_o
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag

Line 570: => pay_pel_shd.g_old_rec.standard_link_flag

566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
567: ,p_multiply_value_flag_o
568: => pay_pel_shd.g_old_rec.multiply_value_flag
569: ,p_standard_link_flag_o
570: => pay_pel_shd.g_old_rec.standard_link_flag
571: ,p_transfer_to_gl_flag_o
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
573: ,p_comment_id_o
574: => pay_pel_shd.g_old_rec.comment_id

Line 572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag

568: => pay_pel_shd.g_old_rec.multiply_value_flag
569: ,p_standard_link_flag_o
570: => pay_pel_shd.g_old_rec.standard_link_flag
571: ,p_transfer_to_gl_flag_o
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
573: ,p_comment_id_o
574: => pay_pel_shd.g_old_rec.comment_id
575: ,p_comments_o
576: => pay_pel_shd.g_old_rec.comments

Line 574: => pay_pel_shd.g_old_rec.comment_id

570: => pay_pel_shd.g_old_rec.standard_link_flag
571: ,p_transfer_to_gl_flag_o
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
573: ,p_comment_id_o
574: => pay_pel_shd.g_old_rec.comment_id
575: ,p_comments_o
576: => pay_pel_shd.g_old_rec.comments
577: ,p_employment_category_o
578: => pay_pel_shd.g_old_rec.employment_category

Line 576: => pay_pel_shd.g_old_rec.comments

572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
573: ,p_comment_id_o
574: => pay_pel_shd.g_old_rec.comment_id
575: ,p_comments_o
576: => pay_pel_shd.g_old_rec.comments
577: ,p_employment_category_o
578: => pay_pel_shd.g_old_rec.employment_category
579: ,p_qualifying_age_o
580: => pay_pel_shd.g_old_rec.qualifying_age

Line 578: => pay_pel_shd.g_old_rec.employment_category

574: => pay_pel_shd.g_old_rec.comment_id
575: ,p_comments_o
576: => pay_pel_shd.g_old_rec.comments
577: ,p_employment_category_o
578: => pay_pel_shd.g_old_rec.employment_category
579: ,p_qualifying_age_o
580: => pay_pel_shd.g_old_rec.qualifying_age
581: ,p_qualifying_length_of_servi_o
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service

Line 580: => pay_pel_shd.g_old_rec.qualifying_age

576: => pay_pel_shd.g_old_rec.comments
577: ,p_employment_category_o
578: => pay_pel_shd.g_old_rec.employment_category
579: ,p_qualifying_age_o
580: => pay_pel_shd.g_old_rec.qualifying_age
581: ,p_qualifying_length_of_servi_o
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
583: ,p_qualifying_units_o
584: => pay_pel_shd.g_old_rec.qualifying_units

Line 582: => pay_pel_shd.g_old_rec.qualifying_length_of_service

578: => pay_pel_shd.g_old_rec.employment_category
579: ,p_qualifying_age_o
580: => pay_pel_shd.g_old_rec.qualifying_age
581: ,p_qualifying_length_of_servi_o
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
583: ,p_qualifying_units_o
584: => pay_pel_shd.g_old_rec.qualifying_units
585: ,p_attribute_category_o
586: => pay_pel_shd.g_old_rec.attribute_category

Line 584: => pay_pel_shd.g_old_rec.qualifying_units

580: => pay_pel_shd.g_old_rec.qualifying_age
581: ,p_qualifying_length_of_servi_o
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
583: ,p_qualifying_units_o
584: => pay_pel_shd.g_old_rec.qualifying_units
585: ,p_attribute_category_o
586: => pay_pel_shd.g_old_rec.attribute_category
587: ,p_attribute1_o
588: => pay_pel_shd.g_old_rec.attribute1

Line 586: => pay_pel_shd.g_old_rec.attribute_category

582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
583: ,p_qualifying_units_o
584: => pay_pel_shd.g_old_rec.qualifying_units
585: ,p_attribute_category_o
586: => pay_pel_shd.g_old_rec.attribute_category
587: ,p_attribute1_o
588: => pay_pel_shd.g_old_rec.attribute1
589: ,p_attribute2_o
590: => pay_pel_shd.g_old_rec.attribute2

Line 588: => pay_pel_shd.g_old_rec.attribute1

584: => pay_pel_shd.g_old_rec.qualifying_units
585: ,p_attribute_category_o
586: => pay_pel_shd.g_old_rec.attribute_category
587: ,p_attribute1_o
588: => pay_pel_shd.g_old_rec.attribute1
589: ,p_attribute2_o
590: => pay_pel_shd.g_old_rec.attribute2
591: ,p_attribute3_o
592: => pay_pel_shd.g_old_rec.attribute3

Line 590: => pay_pel_shd.g_old_rec.attribute2

586: => pay_pel_shd.g_old_rec.attribute_category
587: ,p_attribute1_o
588: => pay_pel_shd.g_old_rec.attribute1
589: ,p_attribute2_o
590: => pay_pel_shd.g_old_rec.attribute2
591: ,p_attribute3_o
592: => pay_pel_shd.g_old_rec.attribute3
593: ,p_attribute4_o
594: => pay_pel_shd.g_old_rec.attribute4

Line 592: => pay_pel_shd.g_old_rec.attribute3

588: => pay_pel_shd.g_old_rec.attribute1
589: ,p_attribute2_o
590: => pay_pel_shd.g_old_rec.attribute2
591: ,p_attribute3_o
592: => pay_pel_shd.g_old_rec.attribute3
593: ,p_attribute4_o
594: => pay_pel_shd.g_old_rec.attribute4
595: ,p_attribute5_o
596: => pay_pel_shd.g_old_rec.attribute5

Line 594: => pay_pel_shd.g_old_rec.attribute4

590: => pay_pel_shd.g_old_rec.attribute2
591: ,p_attribute3_o
592: => pay_pel_shd.g_old_rec.attribute3
593: ,p_attribute4_o
594: => pay_pel_shd.g_old_rec.attribute4
595: ,p_attribute5_o
596: => pay_pel_shd.g_old_rec.attribute5
597: ,p_attribute6_o
598: => pay_pel_shd.g_old_rec.attribute6

Line 596: => pay_pel_shd.g_old_rec.attribute5

592: => pay_pel_shd.g_old_rec.attribute3
593: ,p_attribute4_o
594: => pay_pel_shd.g_old_rec.attribute4
595: ,p_attribute5_o
596: => pay_pel_shd.g_old_rec.attribute5
597: ,p_attribute6_o
598: => pay_pel_shd.g_old_rec.attribute6
599: ,p_attribute7_o
600: => pay_pel_shd.g_old_rec.attribute7

Line 598: => pay_pel_shd.g_old_rec.attribute6

594: => pay_pel_shd.g_old_rec.attribute4
595: ,p_attribute5_o
596: => pay_pel_shd.g_old_rec.attribute5
597: ,p_attribute6_o
598: => pay_pel_shd.g_old_rec.attribute6
599: ,p_attribute7_o
600: => pay_pel_shd.g_old_rec.attribute7
601: ,p_attribute8_o
602: => pay_pel_shd.g_old_rec.attribute8

Line 600: => pay_pel_shd.g_old_rec.attribute7

596: => pay_pel_shd.g_old_rec.attribute5
597: ,p_attribute6_o
598: => pay_pel_shd.g_old_rec.attribute6
599: ,p_attribute7_o
600: => pay_pel_shd.g_old_rec.attribute7
601: ,p_attribute8_o
602: => pay_pel_shd.g_old_rec.attribute8
603: ,p_attribute9_o
604: => pay_pel_shd.g_old_rec.attribute9

Line 602: => pay_pel_shd.g_old_rec.attribute8

598: => pay_pel_shd.g_old_rec.attribute6
599: ,p_attribute7_o
600: => pay_pel_shd.g_old_rec.attribute7
601: ,p_attribute8_o
602: => pay_pel_shd.g_old_rec.attribute8
603: ,p_attribute9_o
604: => pay_pel_shd.g_old_rec.attribute9
605: ,p_attribute10_o
606: => pay_pel_shd.g_old_rec.attribute10

Line 604: => pay_pel_shd.g_old_rec.attribute9

600: => pay_pel_shd.g_old_rec.attribute7
601: ,p_attribute8_o
602: => pay_pel_shd.g_old_rec.attribute8
603: ,p_attribute9_o
604: => pay_pel_shd.g_old_rec.attribute9
605: ,p_attribute10_o
606: => pay_pel_shd.g_old_rec.attribute10
607: ,p_attribute11_o
608: => pay_pel_shd.g_old_rec.attribute11

Line 606: => pay_pel_shd.g_old_rec.attribute10

602: => pay_pel_shd.g_old_rec.attribute8
603: ,p_attribute9_o
604: => pay_pel_shd.g_old_rec.attribute9
605: ,p_attribute10_o
606: => pay_pel_shd.g_old_rec.attribute10
607: ,p_attribute11_o
608: => pay_pel_shd.g_old_rec.attribute11
609: ,p_attribute12_o
610: => pay_pel_shd.g_old_rec.attribute12

Line 608: => pay_pel_shd.g_old_rec.attribute11

604: => pay_pel_shd.g_old_rec.attribute9
605: ,p_attribute10_o
606: => pay_pel_shd.g_old_rec.attribute10
607: ,p_attribute11_o
608: => pay_pel_shd.g_old_rec.attribute11
609: ,p_attribute12_o
610: => pay_pel_shd.g_old_rec.attribute12
611: ,p_attribute13_o
612: => pay_pel_shd.g_old_rec.attribute13

Line 610: => pay_pel_shd.g_old_rec.attribute12

606: => pay_pel_shd.g_old_rec.attribute10
607: ,p_attribute11_o
608: => pay_pel_shd.g_old_rec.attribute11
609: ,p_attribute12_o
610: => pay_pel_shd.g_old_rec.attribute12
611: ,p_attribute13_o
612: => pay_pel_shd.g_old_rec.attribute13
613: ,p_attribute14_o
614: => pay_pel_shd.g_old_rec.attribute14

Line 612: => pay_pel_shd.g_old_rec.attribute13

608: => pay_pel_shd.g_old_rec.attribute11
609: ,p_attribute12_o
610: => pay_pel_shd.g_old_rec.attribute12
611: ,p_attribute13_o
612: => pay_pel_shd.g_old_rec.attribute13
613: ,p_attribute14_o
614: => pay_pel_shd.g_old_rec.attribute14
615: ,p_attribute15_o
616: => pay_pel_shd.g_old_rec.attribute15

Line 614: => pay_pel_shd.g_old_rec.attribute14

610: => pay_pel_shd.g_old_rec.attribute12
611: ,p_attribute13_o
612: => pay_pel_shd.g_old_rec.attribute13
613: ,p_attribute14_o
614: => pay_pel_shd.g_old_rec.attribute14
615: ,p_attribute15_o
616: => pay_pel_shd.g_old_rec.attribute15
617: ,p_attribute16_o
618: => pay_pel_shd.g_old_rec.attribute16

Line 616: => pay_pel_shd.g_old_rec.attribute15

612: => pay_pel_shd.g_old_rec.attribute13
613: ,p_attribute14_o
614: => pay_pel_shd.g_old_rec.attribute14
615: ,p_attribute15_o
616: => pay_pel_shd.g_old_rec.attribute15
617: ,p_attribute16_o
618: => pay_pel_shd.g_old_rec.attribute16
619: ,p_attribute17_o
620: => pay_pel_shd.g_old_rec.attribute17

Line 618: => pay_pel_shd.g_old_rec.attribute16

614: => pay_pel_shd.g_old_rec.attribute14
615: ,p_attribute15_o
616: => pay_pel_shd.g_old_rec.attribute15
617: ,p_attribute16_o
618: => pay_pel_shd.g_old_rec.attribute16
619: ,p_attribute17_o
620: => pay_pel_shd.g_old_rec.attribute17
621: ,p_attribute18_o
622: => pay_pel_shd.g_old_rec.attribute18

Line 620: => pay_pel_shd.g_old_rec.attribute17

616: => pay_pel_shd.g_old_rec.attribute15
617: ,p_attribute16_o
618: => pay_pel_shd.g_old_rec.attribute16
619: ,p_attribute17_o
620: => pay_pel_shd.g_old_rec.attribute17
621: ,p_attribute18_o
622: => pay_pel_shd.g_old_rec.attribute18
623: ,p_attribute19_o
624: => pay_pel_shd.g_old_rec.attribute19

Line 622: => pay_pel_shd.g_old_rec.attribute18

618: => pay_pel_shd.g_old_rec.attribute16
619: ,p_attribute17_o
620: => pay_pel_shd.g_old_rec.attribute17
621: ,p_attribute18_o
622: => pay_pel_shd.g_old_rec.attribute18
623: ,p_attribute19_o
624: => pay_pel_shd.g_old_rec.attribute19
625: ,p_attribute20_o
626: => pay_pel_shd.g_old_rec.attribute20

Line 624: => pay_pel_shd.g_old_rec.attribute19

620: => pay_pel_shd.g_old_rec.attribute17
621: ,p_attribute18_o
622: => pay_pel_shd.g_old_rec.attribute18
623: ,p_attribute19_o
624: => pay_pel_shd.g_old_rec.attribute19
625: ,p_attribute20_o
626: => pay_pel_shd.g_old_rec.attribute20
627: ,p_object_version_number_o
628: => pay_pel_shd.g_old_rec.object_version_number

Line 626: => pay_pel_shd.g_old_rec.attribute20

622: => pay_pel_shd.g_old_rec.attribute18
623: ,p_attribute19_o
624: => pay_pel_shd.g_old_rec.attribute19
625: ,p_attribute20_o
626: => pay_pel_shd.g_old_rec.attribute20
627: ,p_object_version_number_o
628: => pay_pel_shd.g_old_rec.object_version_number
629: );
630: --

Line 628: => pay_pel_shd.g_old_rec.object_version_number

624: => pay_pel_shd.g_old_rec.attribute19
625: ,p_attribute20_o
626: => pay_pel_shd.g_old_rec.attribute20
627: ,p_object_version_number_o
628: => pay_pel_shd.g_old_rec.object_version_number
629: );
630: --
631: exception
632: --

Line 688: (p_rec in out nocopy pay_pel_shd.g_rec_type

684: --
685: -- {End Of Comments}
686: -- ----------------------------------------------------------------------------
687: Procedure convert_defs
688: (p_rec in out nocopy pay_pel_shd.g_rec_type
689: ) is
690: --
691: Begin
692: --

Line 700: pay_pel_shd.g_old_rec.payroll_id;

696: -- is being used then we must set to the 'current' argument value.
697: --
698: If (p_rec.payroll_id = hr_api.g_number) then
699: p_rec.payroll_id :=
700: pay_pel_shd.g_old_rec.payroll_id;
701: End If;
702: If (p_rec.job_id = hr_api.g_number) then
703: p_rec.job_id :=
704: pay_pel_shd.g_old_rec.job_id;

Line 704: pay_pel_shd.g_old_rec.job_id;

700: pay_pel_shd.g_old_rec.payroll_id;
701: End If;
702: If (p_rec.job_id = hr_api.g_number) then
703: p_rec.job_id :=
704: pay_pel_shd.g_old_rec.job_id;
705: End If;
706: If (p_rec.position_id = hr_api.g_number) then
707: p_rec.position_id :=
708: pay_pel_shd.g_old_rec.position_id;

Line 708: pay_pel_shd.g_old_rec.position_id;

704: pay_pel_shd.g_old_rec.job_id;
705: End If;
706: If (p_rec.position_id = hr_api.g_number) then
707: p_rec.position_id :=
708: pay_pel_shd.g_old_rec.position_id;
709: End If;
710: If (p_rec.people_group_id = hr_api.g_number) then
711: p_rec.people_group_id :=
712: pay_pel_shd.g_old_rec.people_group_id;

Line 712: pay_pel_shd.g_old_rec.people_group_id;

708: pay_pel_shd.g_old_rec.position_id;
709: End If;
710: If (p_rec.people_group_id = hr_api.g_number) then
711: p_rec.people_group_id :=
712: pay_pel_shd.g_old_rec.people_group_id;
713: End If;
714: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
715: p_rec.cost_allocation_keyflex_id :=
716: pay_pel_shd.g_old_rec.cost_allocation_keyflex_id;

Line 716: pay_pel_shd.g_old_rec.cost_allocation_keyflex_id;

712: pay_pel_shd.g_old_rec.people_group_id;
713: End If;
714: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
715: p_rec.cost_allocation_keyflex_id :=
716: pay_pel_shd.g_old_rec.cost_allocation_keyflex_id;
717: End If;
718: If (p_rec.organization_id = hr_api.g_number) then
719: p_rec.organization_id :=
720: pay_pel_shd.g_old_rec.organization_id;

Line 720: pay_pel_shd.g_old_rec.organization_id;

716: pay_pel_shd.g_old_rec.cost_allocation_keyflex_id;
717: End If;
718: If (p_rec.organization_id = hr_api.g_number) then
719: p_rec.organization_id :=
720: pay_pel_shd.g_old_rec.organization_id;
721: End If;
722: If (p_rec.element_type_id = hr_api.g_number) then
723: p_rec.element_type_id :=
724: pay_pel_shd.g_old_rec.element_type_id;

Line 724: pay_pel_shd.g_old_rec.element_type_id;

720: pay_pel_shd.g_old_rec.organization_id;
721: End If;
722: If (p_rec.element_type_id = hr_api.g_number) then
723: p_rec.element_type_id :=
724: pay_pel_shd.g_old_rec.element_type_id;
725: End If;
726: If (p_rec.location_id = hr_api.g_number) then
727: p_rec.location_id :=
728: pay_pel_shd.g_old_rec.location_id;

Line 728: pay_pel_shd.g_old_rec.location_id;

724: pay_pel_shd.g_old_rec.element_type_id;
725: End If;
726: If (p_rec.location_id = hr_api.g_number) then
727: p_rec.location_id :=
728: pay_pel_shd.g_old_rec.location_id;
729: End If;
730: If (p_rec.grade_id = hr_api.g_number) then
731: p_rec.grade_id :=
732: pay_pel_shd.g_old_rec.grade_id;

Line 732: pay_pel_shd.g_old_rec.grade_id;

728: pay_pel_shd.g_old_rec.location_id;
729: End If;
730: If (p_rec.grade_id = hr_api.g_number) then
731: p_rec.grade_id :=
732: pay_pel_shd.g_old_rec.grade_id;
733: End If;
734: If (p_rec.balancing_keyflex_id = hr_api.g_number) then
735: p_rec.balancing_keyflex_id :=
736: pay_pel_shd.g_old_rec.balancing_keyflex_id;

Line 736: pay_pel_shd.g_old_rec.balancing_keyflex_id;

732: pay_pel_shd.g_old_rec.grade_id;
733: End If;
734: If (p_rec.balancing_keyflex_id = hr_api.g_number) then
735: p_rec.balancing_keyflex_id :=
736: pay_pel_shd.g_old_rec.balancing_keyflex_id;
737: End If;
738: If (p_rec.business_group_id = hr_api.g_number) then
739: p_rec.business_group_id :=
740: pay_pel_shd.g_old_rec.business_group_id;

Line 740: pay_pel_shd.g_old_rec.business_group_id;

736: pay_pel_shd.g_old_rec.balancing_keyflex_id;
737: End If;
738: If (p_rec.business_group_id = hr_api.g_number) then
739: p_rec.business_group_id :=
740: pay_pel_shd.g_old_rec.business_group_id;
741: End If;
742: If (p_rec.element_set_id = hr_api.g_number) then
743: p_rec.element_set_id :=
744: pay_pel_shd.g_old_rec.element_set_id;

Line 744: pay_pel_shd.g_old_rec.element_set_id;

740: pay_pel_shd.g_old_rec.business_group_id;
741: End If;
742: If (p_rec.element_set_id = hr_api.g_number) then
743: p_rec.element_set_id :=
744: pay_pel_shd.g_old_rec.element_set_id;
745: End If;
746: If (p_rec.pay_basis_id = hr_api.g_number) then
747: p_rec.pay_basis_id :=
748: pay_pel_shd.g_old_rec.pay_basis_id;

Line 748: pay_pel_shd.g_old_rec.pay_basis_id;

744: pay_pel_shd.g_old_rec.element_set_id;
745: End If;
746: If (p_rec.pay_basis_id = hr_api.g_number) then
747: p_rec.pay_basis_id :=
748: pay_pel_shd.g_old_rec.pay_basis_id;
749: End If;
750: If (p_rec.costable_type = hr_api.g_varchar2) then
751: p_rec.costable_type :=
752: pay_pel_shd.g_old_rec.costable_type;

Line 752: pay_pel_shd.g_old_rec.costable_type;

748: pay_pel_shd.g_old_rec.pay_basis_id;
749: End If;
750: If (p_rec.costable_type = hr_api.g_varchar2) then
751: p_rec.costable_type :=
752: pay_pel_shd.g_old_rec.costable_type;
753: End If;
754: If (p_rec.link_to_all_payrolls_flag = hr_api.g_varchar2) then
755: p_rec.link_to_all_payrolls_flag :=
756: pay_pel_shd.g_old_rec.link_to_all_payrolls_flag;

Line 756: pay_pel_shd.g_old_rec.link_to_all_payrolls_flag;

752: pay_pel_shd.g_old_rec.costable_type;
753: End If;
754: If (p_rec.link_to_all_payrolls_flag = hr_api.g_varchar2) then
755: p_rec.link_to_all_payrolls_flag :=
756: pay_pel_shd.g_old_rec.link_to_all_payrolls_flag;
757: End If;
758: If (p_rec.multiply_value_flag = hr_api.g_varchar2) then
759: p_rec.multiply_value_flag :=
760: pay_pel_shd.g_old_rec.multiply_value_flag;

Line 760: pay_pel_shd.g_old_rec.multiply_value_flag;

756: pay_pel_shd.g_old_rec.link_to_all_payrolls_flag;
757: End If;
758: If (p_rec.multiply_value_flag = hr_api.g_varchar2) then
759: p_rec.multiply_value_flag :=
760: pay_pel_shd.g_old_rec.multiply_value_flag;
761: End If;
762: If (p_rec.standard_link_flag = hr_api.g_varchar2) then
763: p_rec.standard_link_flag :=
764: pay_pel_shd.g_old_rec.standard_link_flag;

Line 764: pay_pel_shd.g_old_rec.standard_link_flag;

760: pay_pel_shd.g_old_rec.multiply_value_flag;
761: End If;
762: If (p_rec.standard_link_flag = hr_api.g_varchar2) then
763: p_rec.standard_link_flag :=
764: pay_pel_shd.g_old_rec.standard_link_flag;
765: End If;
766: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then
767: p_rec.transfer_to_gl_flag :=
768: pay_pel_shd.g_old_rec.transfer_to_gl_flag;

Line 768: pay_pel_shd.g_old_rec.transfer_to_gl_flag;

764: pay_pel_shd.g_old_rec.standard_link_flag;
765: End If;
766: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then
767: p_rec.transfer_to_gl_flag :=
768: pay_pel_shd.g_old_rec.transfer_to_gl_flag;
769: End If;
770: If (p_rec.comment_id = hr_api.g_number) then
771: p_rec.comment_id :=
772: pay_pel_shd.g_old_rec.comment_id;

Line 772: pay_pel_shd.g_old_rec.comment_id;

768: pay_pel_shd.g_old_rec.transfer_to_gl_flag;
769: End If;
770: If (p_rec.comment_id = hr_api.g_number) then
771: p_rec.comment_id :=
772: pay_pel_shd.g_old_rec.comment_id;
773: End If;
774: If (p_rec.comments = hr_api.g_varchar2) then
775: p_rec.comments :=
776: pay_pel_shd.g_old_rec.comments;

Line 776: pay_pel_shd.g_old_rec.comments;

772: pay_pel_shd.g_old_rec.comment_id;
773: End If;
774: If (p_rec.comments = hr_api.g_varchar2) then
775: p_rec.comments :=
776: pay_pel_shd.g_old_rec.comments;
777: End If;
778: If (p_rec.employment_category = hr_api.g_varchar2) then
779: p_rec.employment_category :=
780: pay_pel_shd.g_old_rec.employment_category;

Line 780: pay_pel_shd.g_old_rec.employment_category;

776: pay_pel_shd.g_old_rec.comments;
777: End If;
778: If (p_rec.employment_category = hr_api.g_varchar2) then
779: p_rec.employment_category :=
780: pay_pel_shd.g_old_rec.employment_category;
781: End If;
782: If (p_rec.qualifying_age = hr_api.g_number) then
783: p_rec.qualifying_age :=
784: pay_pel_shd.g_old_rec.qualifying_age;

Line 784: pay_pel_shd.g_old_rec.qualifying_age;

780: pay_pel_shd.g_old_rec.employment_category;
781: End If;
782: If (p_rec.qualifying_age = hr_api.g_number) then
783: p_rec.qualifying_age :=
784: pay_pel_shd.g_old_rec.qualifying_age;
785: End If;
786: If (p_rec.qualifying_length_of_service = hr_api.g_number) then
787: p_rec.qualifying_length_of_service :=
788: pay_pel_shd.g_old_rec.qualifying_length_of_service;

Line 788: pay_pel_shd.g_old_rec.qualifying_length_of_service;

784: pay_pel_shd.g_old_rec.qualifying_age;
785: End If;
786: If (p_rec.qualifying_length_of_service = hr_api.g_number) then
787: p_rec.qualifying_length_of_service :=
788: pay_pel_shd.g_old_rec.qualifying_length_of_service;
789: End If;
790: If (p_rec.qualifying_units = hr_api.g_varchar2) then
791: p_rec.qualifying_units :=
792: pay_pel_shd.g_old_rec.qualifying_units;

Line 792: pay_pel_shd.g_old_rec.qualifying_units;

788: pay_pel_shd.g_old_rec.qualifying_length_of_service;
789: End If;
790: If (p_rec.qualifying_units = hr_api.g_varchar2) then
791: p_rec.qualifying_units :=
792: pay_pel_shd.g_old_rec.qualifying_units;
793: End If;
794: If (p_rec.attribute_category = hr_api.g_varchar2) then
795: p_rec.attribute_category :=
796: pay_pel_shd.g_old_rec.attribute_category;

Line 796: pay_pel_shd.g_old_rec.attribute_category;

792: pay_pel_shd.g_old_rec.qualifying_units;
793: End If;
794: If (p_rec.attribute_category = hr_api.g_varchar2) then
795: p_rec.attribute_category :=
796: pay_pel_shd.g_old_rec.attribute_category;
797: End If;
798: If (p_rec.attribute1 = hr_api.g_varchar2) then
799: p_rec.attribute1 :=
800: pay_pel_shd.g_old_rec.attribute1;

Line 800: pay_pel_shd.g_old_rec.attribute1;

796: pay_pel_shd.g_old_rec.attribute_category;
797: End If;
798: If (p_rec.attribute1 = hr_api.g_varchar2) then
799: p_rec.attribute1 :=
800: pay_pel_shd.g_old_rec.attribute1;
801: End If;
802: If (p_rec.attribute2 = hr_api.g_varchar2) then
803: p_rec.attribute2 :=
804: pay_pel_shd.g_old_rec.attribute2;

Line 804: pay_pel_shd.g_old_rec.attribute2;

800: pay_pel_shd.g_old_rec.attribute1;
801: End If;
802: If (p_rec.attribute2 = hr_api.g_varchar2) then
803: p_rec.attribute2 :=
804: pay_pel_shd.g_old_rec.attribute2;
805: End If;
806: If (p_rec.attribute3 = hr_api.g_varchar2) then
807: p_rec.attribute3 :=
808: pay_pel_shd.g_old_rec.attribute3;

Line 808: pay_pel_shd.g_old_rec.attribute3;

804: pay_pel_shd.g_old_rec.attribute2;
805: End If;
806: If (p_rec.attribute3 = hr_api.g_varchar2) then
807: p_rec.attribute3 :=
808: pay_pel_shd.g_old_rec.attribute3;
809: End If;
810: If (p_rec.attribute4 = hr_api.g_varchar2) then
811: p_rec.attribute4 :=
812: pay_pel_shd.g_old_rec.attribute4;

Line 812: pay_pel_shd.g_old_rec.attribute4;

808: pay_pel_shd.g_old_rec.attribute3;
809: End If;
810: If (p_rec.attribute4 = hr_api.g_varchar2) then
811: p_rec.attribute4 :=
812: pay_pel_shd.g_old_rec.attribute4;
813: End If;
814: If (p_rec.attribute5 = hr_api.g_varchar2) then
815: p_rec.attribute5 :=
816: pay_pel_shd.g_old_rec.attribute5;

Line 816: pay_pel_shd.g_old_rec.attribute5;

812: pay_pel_shd.g_old_rec.attribute4;
813: End If;
814: If (p_rec.attribute5 = hr_api.g_varchar2) then
815: p_rec.attribute5 :=
816: pay_pel_shd.g_old_rec.attribute5;
817: End If;
818: If (p_rec.attribute6 = hr_api.g_varchar2) then
819: p_rec.attribute6 :=
820: pay_pel_shd.g_old_rec.attribute6;

Line 820: pay_pel_shd.g_old_rec.attribute6;

816: pay_pel_shd.g_old_rec.attribute5;
817: End If;
818: If (p_rec.attribute6 = hr_api.g_varchar2) then
819: p_rec.attribute6 :=
820: pay_pel_shd.g_old_rec.attribute6;
821: End If;
822: If (p_rec.attribute7 = hr_api.g_varchar2) then
823: p_rec.attribute7 :=
824: pay_pel_shd.g_old_rec.attribute7;

Line 824: pay_pel_shd.g_old_rec.attribute7;

820: pay_pel_shd.g_old_rec.attribute6;
821: End If;
822: If (p_rec.attribute7 = hr_api.g_varchar2) then
823: p_rec.attribute7 :=
824: pay_pel_shd.g_old_rec.attribute7;
825: End If;
826: If (p_rec.attribute8 = hr_api.g_varchar2) then
827: p_rec.attribute8 :=
828: pay_pel_shd.g_old_rec.attribute8;

Line 828: pay_pel_shd.g_old_rec.attribute8;

824: pay_pel_shd.g_old_rec.attribute7;
825: End If;
826: If (p_rec.attribute8 = hr_api.g_varchar2) then
827: p_rec.attribute8 :=
828: pay_pel_shd.g_old_rec.attribute8;
829: End If;
830: If (p_rec.attribute9 = hr_api.g_varchar2) then
831: p_rec.attribute9 :=
832: pay_pel_shd.g_old_rec.attribute9;

Line 832: pay_pel_shd.g_old_rec.attribute9;

828: pay_pel_shd.g_old_rec.attribute8;
829: End If;
830: If (p_rec.attribute9 = hr_api.g_varchar2) then
831: p_rec.attribute9 :=
832: pay_pel_shd.g_old_rec.attribute9;
833: End If;
834: If (p_rec.attribute10 = hr_api.g_varchar2) then
835: p_rec.attribute10 :=
836: pay_pel_shd.g_old_rec.attribute10;

Line 836: pay_pel_shd.g_old_rec.attribute10;

832: pay_pel_shd.g_old_rec.attribute9;
833: End If;
834: If (p_rec.attribute10 = hr_api.g_varchar2) then
835: p_rec.attribute10 :=
836: pay_pel_shd.g_old_rec.attribute10;
837: End If;
838: If (p_rec.attribute11 = hr_api.g_varchar2) then
839: p_rec.attribute11 :=
840: pay_pel_shd.g_old_rec.attribute11;

Line 840: pay_pel_shd.g_old_rec.attribute11;

836: pay_pel_shd.g_old_rec.attribute10;
837: End If;
838: If (p_rec.attribute11 = hr_api.g_varchar2) then
839: p_rec.attribute11 :=
840: pay_pel_shd.g_old_rec.attribute11;
841: End If;
842: If (p_rec.attribute12 = hr_api.g_varchar2) then
843: p_rec.attribute12 :=
844: pay_pel_shd.g_old_rec.attribute12;

Line 844: pay_pel_shd.g_old_rec.attribute12;

840: pay_pel_shd.g_old_rec.attribute11;
841: End If;
842: If (p_rec.attribute12 = hr_api.g_varchar2) then
843: p_rec.attribute12 :=
844: pay_pel_shd.g_old_rec.attribute12;
845: End If;
846: If (p_rec.attribute13 = hr_api.g_varchar2) then
847: p_rec.attribute13 :=
848: pay_pel_shd.g_old_rec.attribute13;

Line 848: pay_pel_shd.g_old_rec.attribute13;

844: pay_pel_shd.g_old_rec.attribute12;
845: End If;
846: If (p_rec.attribute13 = hr_api.g_varchar2) then
847: p_rec.attribute13 :=
848: pay_pel_shd.g_old_rec.attribute13;
849: End If;
850: If (p_rec.attribute14 = hr_api.g_varchar2) then
851: p_rec.attribute14 :=
852: pay_pel_shd.g_old_rec.attribute14;

Line 852: pay_pel_shd.g_old_rec.attribute14;

848: pay_pel_shd.g_old_rec.attribute13;
849: End If;
850: If (p_rec.attribute14 = hr_api.g_varchar2) then
851: p_rec.attribute14 :=
852: pay_pel_shd.g_old_rec.attribute14;
853: End If;
854: If (p_rec.attribute15 = hr_api.g_varchar2) then
855: p_rec.attribute15 :=
856: pay_pel_shd.g_old_rec.attribute15;

Line 856: pay_pel_shd.g_old_rec.attribute15;

852: pay_pel_shd.g_old_rec.attribute14;
853: End If;
854: If (p_rec.attribute15 = hr_api.g_varchar2) then
855: p_rec.attribute15 :=
856: pay_pel_shd.g_old_rec.attribute15;
857: End If;
858: If (p_rec.attribute16 = hr_api.g_varchar2) then
859: p_rec.attribute16 :=
860: pay_pel_shd.g_old_rec.attribute16;

Line 860: pay_pel_shd.g_old_rec.attribute16;

856: pay_pel_shd.g_old_rec.attribute15;
857: End If;
858: If (p_rec.attribute16 = hr_api.g_varchar2) then
859: p_rec.attribute16 :=
860: pay_pel_shd.g_old_rec.attribute16;
861: End If;
862: If (p_rec.attribute17 = hr_api.g_varchar2) then
863: p_rec.attribute17 :=
864: pay_pel_shd.g_old_rec.attribute17;

Line 864: pay_pel_shd.g_old_rec.attribute17;

860: pay_pel_shd.g_old_rec.attribute16;
861: End If;
862: If (p_rec.attribute17 = hr_api.g_varchar2) then
863: p_rec.attribute17 :=
864: pay_pel_shd.g_old_rec.attribute17;
865: End If;
866: If (p_rec.attribute18 = hr_api.g_varchar2) then
867: p_rec.attribute18 :=
868: pay_pel_shd.g_old_rec.attribute18;

Line 868: pay_pel_shd.g_old_rec.attribute18;

864: pay_pel_shd.g_old_rec.attribute17;
865: End If;
866: If (p_rec.attribute18 = hr_api.g_varchar2) then
867: p_rec.attribute18 :=
868: pay_pel_shd.g_old_rec.attribute18;
869: End If;
870: If (p_rec.attribute19 = hr_api.g_varchar2) then
871: p_rec.attribute19 :=
872: pay_pel_shd.g_old_rec.attribute19;

Line 872: pay_pel_shd.g_old_rec.attribute19;

868: pay_pel_shd.g_old_rec.attribute18;
869: End If;
870: If (p_rec.attribute19 = hr_api.g_varchar2) then
871: p_rec.attribute19 :=
872: pay_pel_shd.g_old_rec.attribute19;
873: End If;
874: If (p_rec.attribute20 = hr_api.g_varchar2) then
875: p_rec.attribute20 :=
876: pay_pel_shd.g_old_rec.attribute20;

Line 876: pay_pel_shd.g_old_rec.attribute20;

872: pay_pel_shd.g_old_rec.attribute19;
873: End If;
874: If (p_rec.attribute20 = hr_api.g_varchar2) then
875: p_rec.attribute20 :=
876: pay_pel_shd.g_old_rec.attribute20;
877: End If;
878: --
879: End convert_defs;
880: --

Line 887: ,p_rec in out nocopy pay_pel_shd.g_rec_type

883: -- ----------------------------------------------------------------------------
884: Procedure upd
885: (p_effective_date in date
886: ,p_datetrack_mode in varchar2
887: ,p_rec in out nocopy pay_pel_shd.g_rec_type
888: ) is
889: --
890: l_proc varchar2(72) := g_package||'upd';
891: l_validation_start_date date;

Line 913: pay_pel_shd.lck

909: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
910: --
911: -- We must lock the row which we need to update.
912: --
913: pay_pel_shd.lck
914: (p_effective_date => p_effective_date
915: ,p_datetrack_mode => p_datetrack_mode
916: ,p_element_link_id => p_rec.element_link_id
917: ,p_object_version_number => p_rec.object_version_number

Line 1023: l_rec pay_pel_shd.g_rec_type;

1019: ,p_effective_start_date out nocopy date
1020: ,p_effective_end_date out nocopy date
1021: ) is
1022: --
1023: l_rec pay_pel_shd.g_rec_type;
1024: l_proc varchar2(72) := g_package||'upd';
1025: --
1026: Begin
1027: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1033: pay_pel_shd.convert_args

1029: -- Call conversion function to turn arguments into the
1030: -- l_rec structure.
1031: --
1032: l_rec :=
1033: pay_pel_shd.convert_args
1034: (p_element_link_id
1035: ,null
1036: ,null
1037: ,null