54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy per_ctc_shd.g_rec_type,
59: p_effective_date in date,
60:
61: p_datetrack_mode in varchar2,
62: p_validation_start_date in date,
160: hr_utility.set_location(' Leaving:'||l_proc, 15);
161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: per_ctc_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: per_ctc_shd.constraint_error
164: per_ctc_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: per_ctc_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: Raise;
172: End dt_update_dml;
203: --
204: -- {End Of Comments}
205: -- ----------------------------------------------------------------------------
206: Procedure update_dml
207: (p_rec in out nocopy per_ctc_shd.g_rec_type,
208: p_effective_date in date,
209: p_datetrack_mode in varchar2,
210: p_validation_start_date in date,
211: p_validation_end_date in date) is
268: --
269: -- {End Of Comments}
270: -- ----------------------------------------------------------------------------
271: Procedure dt_pre_update
272: (p_rec in out nocopy per_ctc_shd.g_rec_type,
273: p_effective_date in date,
274: p_datetrack_mode in varchar2,
275: p_validation_start_date in date,
276: p_validation_end_date in date) is
284: hr_utility.set_location(l_proc, 10);
285: --
286: -- Update the current effective end date
287: --
288: per_ctc_shd.upd_effective_end_date
289: (p_effective_date => p_effective_date,
290: p_base_key_value => p_rec.contract_id,
291: p_new_effective_end_date => (p_validation_start_date - 1),
292: p_validation_start_date => p_validation_start_date,
353: --
354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure pre_update
357: (p_rec in out nocopy per_ctc_shd.g_rec_type,
358:
359: p_effective_date in date,
360: p_datetrack_mode in varchar2,
361: p_validation_start_date in date,
411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure post_update
415: (p_rec in per_ctc_shd.g_rec_type,
416: p_effective_date in date,
417: p_datetrack_mode in varchar2,
418: p_validation_start_date in date,
419: p_validation_end_date in date) is
494: p_effective_date => p_effective_date,
495: p_datetrack_mode => p_datetrack_mode,
496: p_validation_start_date => p_validation_start_date,
497: p_validation_end_date => p_validation_end_date,
498: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
499: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
500: p_reference_o => per_ctc_shd.g_old_rec.reference,
501: p_type_o => per_ctc_shd.g_old_rec.type,
502: p_status_o => per_ctc_shd.g_old_rec.status,
495: p_datetrack_mode => p_datetrack_mode,
496: p_validation_start_date => p_validation_start_date,
497: p_validation_end_date => p_validation_end_date,
498: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
499: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
500: p_reference_o => per_ctc_shd.g_old_rec.reference,
501: p_type_o => per_ctc_shd.g_old_rec.type,
502: p_status_o => per_ctc_shd.g_old_rec.status,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
496: p_validation_start_date => p_validation_start_date,
497: p_validation_end_date => p_validation_end_date,
498: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
499: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
500: p_reference_o => per_ctc_shd.g_old_rec.reference,
501: p_type_o => per_ctc_shd.g_old_rec.type,
502: p_status_o => per_ctc_shd.g_old_rec.status,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
497: p_validation_end_date => p_validation_end_date,
498: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
499: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
500: p_reference_o => per_ctc_shd.g_old_rec.reference,
501: p_type_o => per_ctc_shd.g_old_rec.type,
502: p_status_o => per_ctc_shd.g_old_rec.status,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
498: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
499: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
500: p_reference_o => per_ctc_shd.g_old_rec.reference,
501: p_type_o => per_ctc_shd.g_old_rec.type,
502: p_status_o => per_ctc_shd.g_old_rec.status,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
506: p_description_o => per_ctc_shd.g_old_rec.description,
499: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
500: p_reference_o => per_ctc_shd.g_old_rec.reference,
501: p_type_o => per_ctc_shd.g_old_rec.type,
502: p_status_o => per_ctc_shd.g_old_rec.status,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
506: p_description_o => per_ctc_shd.g_old_rec.description,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
500: p_reference_o => per_ctc_shd.g_old_rec.reference,
501: p_type_o => per_ctc_shd.g_old_rec.type,
502: p_status_o => per_ctc_shd.g_old_rec.status,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
506: p_description_o => per_ctc_shd.g_old_rec.description,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
501: p_type_o => per_ctc_shd.g_old_rec.type,
502: p_status_o => per_ctc_shd.g_old_rec.status,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
506: p_description_o => per_ctc_shd.g_old_rec.description,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
502: p_status_o => per_ctc_shd.g_old_rec.status,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
506: p_description_o => per_ctc_shd.g_old_rec.description,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
503: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
506: p_description_o => per_ctc_shd.g_old_rec.description,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
504: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
506: p_description_o => per_ctc_shd.g_old_rec.description,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
505: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
506: p_description_o => per_ctc_shd.g_old_rec.description,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
506: p_description_o => per_ctc_shd.g_old_rec.description,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
507: p_duration_o => per_ctc_shd.g_old_rec.duration,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
508: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
509: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
510: p_parties_o => per_ctc_shd.g_old_rec.parties,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
511: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
512: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
513: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
514: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
515: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
516: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
517: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
518: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
519: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
520: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
521: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
522: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
523: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
524: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
525: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
526: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
527: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
528: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
529: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
530: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
531: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
532: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
533: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
534: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
535: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
536: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
537: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
538: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
539: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
540: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
541: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
542: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
543: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
544: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
545: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
546: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
547: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
548: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
549: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
550: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
558: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
551: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
558: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
559: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number,
552: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
558: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
559: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number,
560: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
553: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
558: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
559: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number,
560: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
561: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date
554: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
558: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
559: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number,
560: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
561: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date
562: );
555: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
558: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
559: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number,
560: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
561: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date
562: );
563: --
556: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
558: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
559: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number,
560: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
561: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date
562: );
563: --
564: exception
557: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
558: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
559: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number,
560: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
561: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date
562: );
563: --
564: exception
565: --
619: -- Internal Row Handler Use Only.
620: --
621: -- {End Of Comments}
622: -- ----------------------------------------------------------------------------
623: Procedure convert_defs(p_rec in out nocopy per_ctc_shd.g_rec_type) is
624: --
625: l_proc varchar2(72) := g_package||'convert_defs';
626: --
627: Begin
634: -- is being used then we must set to the 'current' argument value.
635: --
636: If (p_rec.business_group_id = hr_api.g_number) then
637: p_rec.business_group_id :=
638: per_ctc_shd.g_old_rec.business_group_id;
639: End If;
640: If (p_rec.person_id = hr_api.g_number) then
641: p_rec.person_id :=
642: per_ctc_shd.g_old_rec.person_id;
638: per_ctc_shd.g_old_rec.business_group_id;
639: End If;
640: If (p_rec.person_id = hr_api.g_number) then
641: p_rec.person_id :=
642: per_ctc_shd.g_old_rec.person_id;
643: End If;
644: If (p_rec.reference = hr_api.g_varchar2) then
645: p_rec.reference :=
646: per_ctc_shd.g_old_rec.reference;
642: per_ctc_shd.g_old_rec.person_id;
643: End If;
644: If (p_rec.reference = hr_api.g_varchar2) then
645: p_rec.reference :=
646: per_ctc_shd.g_old_rec.reference;
647: End If;
648: If (p_rec.type = hr_api.g_varchar2) then
649: p_rec.type :=
650: per_ctc_shd.g_old_rec.type;
646: per_ctc_shd.g_old_rec.reference;
647: End If;
648: If (p_rec.type = hr_api.g_varchar2) then
649: p_rec.type :=
650: per_ctc_shd.g_old_rec.type;
651: End If;
652: If (p_rec.status = hr_api.g_varchar2) then
653: p_rec.status :=
654: per_ctc_shd.g_old_rec.status;
650: per_ctc_shd.g_old_rec.type;
651: End If;
652: If (p_rec.status = hr_api.g_varchar2) then
653: p_rec.status :=
654: per_ctc_shd.g_old_rec.status;
655: End If;
656: If (p_rec.status_reason = hr_api.g_varchar2) then
657: p_rec.status_reason :=
658: per_ctc_shd.g_old_rec.status_reason;
654: per_ctc_shd.g_old_rec.status;
655: End If;
656: If (p_rec.status_reason = hr_api.g_varchar2) then
657: p_rec.status_reason :=
658: per_ctc_shd.g_old_rec.status_reason;
659: End if;
660: If (p_rec.doc_status = hr_api.g_varchar2) then
661: p_rec.doc_status :=
662: per_ctc_shd.g_old_rec.doc_status;
658: per_ctc_shd.g_old_rec.status_reason;
659: End if;
660: If (p_rec.doc_status = hr_api.g_varchar2) then
661: p_rec.doc_status :=
662: per_ctc_shd.g_old_rec.doc_status;
663: End If;
664: If (p_rec.doc_status_change_date = hr_api.g_date) then
665: p_rec.doc_status_change_date :=
666: per_ctc_shd.g_old_rec.doc_status_change_date;
662: per_ctc_shd.g_old_rec.doc_status;
663: End If;
664: If (p_rec.doc_status_change_date = hr_api.g_date) then
665: p_rec.doc_status_change_date :=
666: per_ctc_shd.g_old_rec.doc_status_change_date;
667: End If;
668: If (p_rec.description = hr_api.g_varchar2) then
669: p_rec.description :=
670: per_ctc_shd.g_old_rec.description;
666: per_ctc_shd.g_old_rec.doc_status_change_date;
667: End If;
668: If (p_rec.description = hr_api.g_varchar2) then
669: p_rec.description :=
670: per_ctc_shd.g_old_rec.description;
671: End If;
672: If (p_rec.duration = hr_api.g_number) then
673: p_rec.duration :=
674: per_ctc_shd.g_old_rec.duration;
670: per_ctc_shd.g_old_rec.description;
671: End If;
672: If (p_rec.duration = hr_api.g_number) then
673: p_rec.duration :=
674: per_ctc_shd.g_old_rec.duration;
675: End If;
676: If (p_rec.duration_units = hr_api.g_varchar2) then
677: p_rec.duration_units :=
678: per_ctc_shd.g_old_rec.duration_units;
674: per_ctc_shd.g_old_rec.duration;
675: End If;
676: If (p_rec.duration_units = hr_api.g_varchar2) then
677: p_rec.duration_units :=
678: per_ctc_shd.g_old_rec.duration_units;
679: End If;
680: If (p_rec.contractual_job_title = hr_api.g_varchar2) then
681: p_rec.contractual_job_title :=
682: per_ctc_shd.g_old_rec.contractual_job_title;
678: per_ctc_shd.g_old_rec.duration_units;
679: End If;
680: If (p_rec.contractual_job_title = hr_api.g_varchar2) then
681: p_rec.contractual_job_title :=
682: per_ctc_shd.g_old_rec.contractual_job_title;
683: End If;
684: If (p_rec.parties = hr_api.g_varchar2) then
685: p_rec.parties :=
686: per_ctc_shd.g_old_rec.parties;
682: per_ctc_shd.g_old_rec.contractual_job_title;
683: End If;
684: If (p_rec.parties = hr_api.g_varchar2) then
685: p_rec.parties :=
686: per_ctc_shd.g_old_rec.parties;
687: End If;
688: If (p_rec.start_reason = hr_api.g_varchar2) then
689: p_rec.start_reason :=
690: per_ctc_shd.g_old_rec.start_reason;
686: per_ctc_shd.g_old_rec.parties;
687: End If;
688: If (p_rec.start_reason = hr_api.g_varchar2) then
689: p_rec.start_reason :=
690: per_ctc_shd.g_old_rec.start_reason;
691: End If;
692: If (p_rec.end_reason = hr_api.g_varchar2) then
693: p_rec.end_reason :=
694: per_ctc_shd.g_old_rec.end_reason;
690: per_ctc_shd.g_old_rec.start_reason;
691: End If;
692: If (p_rec.end_reason = hr_api.g_varchar2) then
693: p_rec.end_reason :=
694: per_ctc_shd.g_old_rec.end_reason;
695: End If;
696: If (p_rec.number_of_extensions = hr_api.g_number) then
697: p_rec.number_of_extensions :=
698: per_ctc_shd.g_old_rec.number_of_extensions;
694: per_ctc_shd.g_old_rec.end_reason;
695: End If;
696: If (p_rec.number_of_extensions = hr_api.g_number) then
697: p_rec.number_of_extensions :=
698: per_ctc_shd.g_old_rec.number_of_extensions;
699: End If;
700: If (p_rec.extension_reason = hr_api.g_varchar2) then
701: p_rec.extension_reason :=
702: per_ctc_shd.g_old_rec.extension_reason;
698: per_ctc_shd.g_old_rec.number_of_extensions;
699: End If;
700: If (p_rec.extension_reason = hr_api.g_varchar2) then
701: p_rec.extension_reason :=
702: per_ctc_shd.g_old_rec.extension_reason;
703: End If;
704: If (p_rec.extension_period = hr_api.g_number) then
705: p_rec.extension_period :=
706: per_ctc_shd.g_old_rec.extension_period;
702: per_ctc_shd.g_old_rec.extension_reason;
703: End If;
704: If (p_rec.extension_period = hr_api.g_number) then
705: p_rec.extension_period :=
706: per_ctc_shd.g_old_rec.extension_period;
707: End If;
708: If (p_rec.extension_period_units = hr_api.g_varchar2) then
709: p_rec.extension_period_units :=
710: per_ctc_shd.g_old_rec.extension_period_units;
706: per_ctc_shd.g_old_rec.extension_period;
707: End If;
708: If (p_rec.extension_period_units = hr_api.g_varchar2) then
709: p_rec.extension_period_units :=
710: per_ctc_shd.g_old_rec.extension_period_units;
711: End If;
712: If (p_rec.ctr_information_category = hr_api.g_varchar2) then
713: p_rec.ctr_information_category :=
714: per_ctc_shd.g_old_rec.ctr_information_category;
710: per_ctc_shd.g_old_rec.extension_period_units;
711: End If;
712: If (p_rec.ctr_information_category = hr_api.g_varchar2) then
713: p_rec.ctr_information_category :=
714: per_ctc_shd.g_old_rec.ctr_information_category;
715: End If;
716: If (p_rec.ctr_information1 = hr_api.g_varchar2) then
717: p_rec.ctr_information1 :=
718: per_ctc_shd.g_old_rec.ctr_information1;
714: per_ctc_shd.g_old_rec.ctr_information_category;
715: End If;
716: If (p_rec.ctr_information1 = hr_api.g_varchar2) then
717: p_rec.ctr_information1 :=
718: per_ctc_shd.g_old_rec.ctr_information1;
719: End If;
720: If (p_rec.ctr_information2 = hr_api.g_varchar2) then
721: p_rec.ctr_information2 :=
722: per_ctc_shd.g_old_rec.ctr_information2;
718: per_ctc_shd.g_old_rec.ctr_information1;
719: End If;
720: If (p_rec.ctr_information2 = hr_api.g_varchar2) then
721: p_rec.ctr_information2 :=
722: per_ctc_shd.g_old_rec.ctr_information2;
723: End If;
724: If (p_rec.ctr_information3 = hr_api.g_varchar2) then
725: p_rec.ctr_information3 :=
726: per_ctc_shd.g_old_rec.ctr_information3;
722: per_ctc_shd.g_old_rec.ctr_information2;
723: End If;
724: If (p_rec.ctr_information3 = hr_api.g_varchar2) then
725: p_rec.ctr_information3 :=
726: per_ctc_shd.g_old_rec.ctr_information3;
727: End If;
728: If (p_rec.ctr_information4 = hr_api.g_varchar2) then
729: p_rec.ctr_information4 :=
730: per_ctc_shd.g_old_rec.ctr_information4;
726: per_ctc_shd.g_old_rec.ctr_information3;
727: End If;
728: If (p_rec.ctr_information4 = hr_api.g_varchar2) then
729: p_rec.ctr_information4 :=
730: per_ctc_shd.g_old_rec.ctr_information4;
731: End If;
732: If (p_rec.ctr_information5 = hr_api.g_varchar2) then
733: p_rec.ctr_information5 :=
734: per_ctc_shd.g_old_rec.ctr_information5;
730: per_ctc_shd.g_old_rec.ctr_information4;
731: End If;
732: If (p_rec.ctr_information5 = hr_api.g_varchar2) then
733: p_rec.ctr_information5 :=
734: per_ctc_shd.g_old_rec.ctr_information5;
735: End If;
736: If (p_rec.ctr_information6 = hr_api.g_varchar2) then
737: p_rec.ctr_information6 :=
738: per_ctc_shd.g_old_rec.ctr_information6;
734: per_ctc_shd.g_old_rec.ctr_information5;
735: End If;
736: If (p_rec.ctr_information6 = hr_api.g_varchar2) then
737: p_rec.ctr_information6 :=
738: per_ctc_shd.g_old_rec.ctr_information6;
739: End If;
740: If (p_rec.ctr_information7 = hr_api.g_varchar2) then
741: p_rec.ctr_information7 :=
742: per_ctc_shd.g_old_rec.ctr_information7;
738: per_ctc_shd.g_old_rec.ctr_information6;
739: End If;
740: If (p_rec.ctr_information7 = hr_api.g_varchar2) then
741: p_rec.ctr_information7 :=
742: per_ctc_shd.g_old_rec.ctr_information7;
743: End If;
744: If (p_rec.ctr_information8 = hr_api.g_varchar2) then
745: p_rec.ctr_information8 :=
746: per_ctc_shd.g_old_rec.ctr_information8;
742: per_ctc_shd.g_old_rec.ctr_information7;
743: End If;
744: If (p_rec.ctr_information8 = hr_api.g_varchar2) then
745: p_rec.ctr_information8 :=
746: per_ctc_shd.g_old_rec.ctr_information8;
747: End If;
748: If (p_rec.ctr_information9 = hr_api.g_varchar2) then
749: p_rec.ctr_information9 :=
750: per_ctc_shd.g_old_rec.ctr_information9;
746: per_ctc_shd.g_old_rec.ctr_information8;
747: End If;
748: If (p_rec.ctr_information9 = hr_api.g_varchar2) then
749: p_rec.ctr_information9 :=
750: per_ctc_shd.g_old_rec.ctr_information9;
751: End If;
752: If (p_rec.ctr_information10 = hr_api.g_varchar2) then
753: p_rec.ctr_information10 :=
754: per_ctc_shd.g_old_rec.ctr_information10;
750: per_ctc_shd.g_old_rec.ctr_information9;
751: End If;
752: If (p_rec.ctr_information10 = hr_api.g_varchar2) then
753: p_rec.ctr_information10 :=
754: per_ctc_shd.g_old_rec.ctr_information10;
755: End If;
756: If (p_rec.ctr_information11 = hr_api.g_varchar2) then
757: p_rec.ctr_information11 :=
758: per_ctc_shd.g_old_rec.ctr_information11;
754: per_ctc_shd.g_old_rec.ctr_information10;
755: End If;
756: If (p_rec.ctr_information11 = hr_api.g_varchar2) then
757: p_rec.ctr_information11 :=
758: per_ctc_shd.g_old_rec.ctr_information11;
759: End If;
760: If (p_rec.ctr_information12 = hr_api.g_varchar2) then
761: p_rec.ctr_information12 :=
762: per_ctc_shd.g_old_rec.ctr_information12;
758: per_ctc_shd.g_old_rec.ctr_information11;
759: End If;
760: If (p_rec.ctr_information12 = hr_api.g_varchar2) then
761: p_rec.ctr_information12 :=
762: per_ctc_shd.g_old_rec.ctr_information12;
763: End If;
764: If (p_rec.ctr_information13 = hr_api.g_varchar2) then
765: p_rec.ctr_information13 :=
766: per_ctc_shd.g_old_rec.ctr_information13;
762: per_ctc_shd.g_old_rec.ctr_information12;
763: End If;
764: If (p_rec.ctr_information13 = hr_api.g_varchar2) then
765: p_rec.ctr_information13 :=
766: per_ctc_shd.g_old_rec.ctr_information13;
767: End If;
768: If (p_rec.ctr_information14 = hr_api.g_varchar2) then
769: p_rec.ctr_information14 :=
770: per_ctc_shd.g_old_rec.ctr_information14;
766: per_ctc_shd.g_old_rec.ctr_information13;
767: End If;
768: If (p_rec.ctr_information14 = hr_api.g_varchar2) then
769: p_rec.ctr_information14 :=
770: per_ctc_shd.g_old_rec.ctr_information14;
771: End If;
772: If (p_rec.ctr_information15 = hr_api.g_varchar2) then
773: p_rec.ctr_information15 :=
774: per_ctc_shd.g_old_rec.ctr_information15;
770: per_ctc_shd.g_old_rec.ctr_information14;
771: End If;
772: If (p_rec.ctr_information15 = hr_api.g_varchar2) then
773: p_rec.ctr_information15 :=
774: per_ctc_shd.g_old_rec.ctr_information15;
775: End If;
776: If (p_rec.ctr_information16 = hr_api.g_varchar2) then
777: p_rec.ctr_information16 :=
778: per_ctc_shd.g_old_rec.ctr_information16;
774: per_ctc_shd.g_old_rec.ctr_information15;
775: End If;
776: If (p_rec.ctr_information16 = hr_api.g_varchar2) then
777: p_rec.ctr_information16 :=
778: per_ctc_shd.g_old_rec.ctr_information16;
779: End If;
780: If (p_rec.ctr_information17 = hr_api.g_varchar2) then
781: p_rec.ctr_information17 :=
782: per_ctc_shd.g_old_rec.ctr_information17;
778: per_ctc_shd.g_old_rec.ctr_information16;
779: End If;
780: If (p_rec.ctr_information17 = hr_api.g_varchar2) then
781: p_rec.ctr_information17 :=
782: per_ctc_shd.g_old_rec.ctr_information17;
783: End If;
784: If (p_rec.ctr_information18 = hr_api.g_varchar2) then
785: p_rec.ctr_information18 :=
786: per_ctc_shd.g_old_rec.ctr_information18;
782: per_ctc_shd.g_old_rec.ctr_information17;
783: End If;
784: If (p_rec.ctr_information18 = hr_api.g_varchar2) then
785: p_rec.ctr_information18 :=
786: per_ctc_shd.g_old_rec.ctr_information18;
787: End If;
788: If (p_rec.ctr_information19 = hr_api.g_varchar2) then
789: p_rec.ctr_information19 :=
790: per_ctc_shd.g_old_rec.ctr_information19;
786: per_ctc_shd.g_old_rec.ctr_information18;
787: End If;
788: If (p_rec.ctr_information19 = hr_api.g_varchar2) then
789: p_rec.ctr_information19 :=
790: per_ctc_shd.g_old_rec.ctr_information19;
791: End If;
792: If (p_rec.ctr_information20 = hr_api.g_varchar2) then
793: p_rec.ctr_information20 :=
794: per_ctc_shd.g_old_rec.ctr_information20;
790: per_ctc_shd.g_old_rec.ctr_information19;
791: End If;
792: If (p_rec.ctr_information20 = hr_api.g_varchar2) then
793: p_rec.ctr_information20 :=
794: per_ctc_shd.g_old_rec.ctr_information20;
795: End If;
796: If (p_rec.attribute_category = hr_api.g_varchar2) then
797: p_rec.attribute_category :=
798: per_ctc_shd.g_old_rec.attribute_category;
794: per_ctc_shd.g_old_rec.ctr_information20;
795: End If;
796: If (p_rec.attribute_category = hr_api.g_varchar2) then
797: p_rec.attribute_category :=
798: per_ctc_shd.g_old_rec.attribute_category;
799: End If;
800: If (p_rec.attribute1 = hr_api.g_varchar2) then
801: p_rec.attribute1 :=
802: per_ctc_shd.g_old_rec.attribute1;
798: per_ctc_shd.g_old_rec.attribute_category;
799: End If;
800: If (p_rec.attribute1 = hr_api.g_varchar2) then
801: p_rec.attribute1 :=
802: per_ctc_shd.g_old_rec.attribute1;
803: End If;
804: If (p_rec.attribute2 = hr_api.g_varchar2) then
805: p_rec.attribute2 :=
806: per_ctc_shd.g_old_rec.attribute2;
802: per_ctc_shd.g_old_rec.attribute1;
803: End If;
804: If (p_rec.attribute2 = hr_api.g_varchar2) then
805: p_rec.attribute2 :=
806: per_ctc_shd.g_old_rec.attribute2;
807: End If;
808: If (p_rec.attribute3 = hr_api.g_varchar2) then
809: p_rec.attribute3 :=
810: per_ctc_shd.g_old_rec.attribute3;
806: per_ctc_shd.g_old_rec.attribute2;
807: End If;
808: If (p_rec.attribute3 = hr_api.g_varchar2) then
809: p_rec.attribute3 :=
810: per_ctc_shd.g_old_rec.attribute3;
811: End If;
812: If (p_rec.attribute4 = hr_api.g_varchar2) then
813: p_rec.attribute4 :=
814: per_ctc_shd.g_old_rec.attribute4;
810: per_ctc_shd.g_old_rec.attribute3;
811: End If;
812: If (p_rec.attribute4 = hr_api.g_varchar2) then
813: p_rec.attribute4 :=
814: per_ctc_shd.g_old_rec.attribute4;
815: End If;
816: If (p_rec.attribute5 = hr_api.g_varchar2) then
817: p_rec.attribute5 :=
818: per_ctc_shd.g_old_rec.attribute5;
814: per_ctc_shd.g_old_rec.attribute4;
815: End If;
816: If (p_rec.attribute5 = hr_api.g_varchar2) then
817: p_rec.attribute5 :=
818: per_ctc_shd.g_old_rec.attribute5;
819: End If;
820: If (p_rec.attribute6 = hr_api.g_varchar2) then
821: p_rec.attribute6 :=
822: per_ctc_shd.g_old_rec.attribute6;
818: per_ctc_shd.g_old_rec.attribute5;
819: End If;
820: If (p_rec.attribute6 = hr_api.g_varchar2) then
821: p_rec.attribute6 :=
822: per_ctc_shd.g_old_rec.attribute6;
823: End If;
824: If (p_rec.attribute7 = hr_api.g_varchar2) then
825: p_rec.attribute7 :=
826: per_ctc_shd.g_old_rec.attribute7;
822: per_ctc_shd.g_old_rec.attribute6;
823: End If;
824: If (p_rec.attribute7 = hr_api.g_varchar2) then
825: p_rec.attribute7 :=
826: per_ctc_shd.g_old_rec.attribute7;
827: End If;
828: If (p_rec.attribute8 = hr_api.g_varchar2) then
829: p_rec.attribute8 :=
830: per_ctc_shd.g_old_rec.attribute8;
826: per_ctc_shd.g_old_rec.attribute7;
827: End If;
828: If (p_rec.attribute8 = hr_api.g_varchar2) then
829: p_rec.attribute8 :=
830: per_ctc_shd.g_old_rec.attribute8;
831: End If;
832: If (p_rec.attribute9 = hr_api.g_varchar2) then
833: p_rec.attribute9 :=
834: per_ctc_shd.g_old_rec.attribute9;
830: per_ctc_shd.g_old_rec.attribute8;
831: End If;
832: If (p_rec.attribute9 = hr_api.g_varchar2) then
833: p_rec.attribute9 :=
834: per_ctc_shd.g_old_rec.attribute9;
835: End If;
836: If (p_rec.attribute10 = hr_api.g_varchar2) then
837: p_rec.attribute10 :=
838: per_ctc_shd.g_old_rec.attribute10;
834: per_ctc_shd.g_old_rec.attribute9;
835: End If;
836: If (p_rec.attribute10 = hr_api.g_varchar2) then
837: p_rec.attribute10 :=
838: per_ctc_shd.g_old_rec.attribute10;
839: End If;
840: If (p_rec.attribute11 = hr_api.g_varchar2) then
841: p_rec.attribute11 :=
842: per_ctc_shd.g_old_rec.attribute11;
838: per_ctc_shd.g_old_rec.attribute10;
839: End If;
840: If (p_rec.attribute11 = hr_api.g_varchar2) then
841: p_rec.attribute11 :=
842: per_ctc_shd.g_old_rec.attribute11;
843: End If;
844: If (p_rec.attribute12 = hr_api.g_varchar2) then
845: p_rec.attribute12 :=
846: per_ctc_shd.g_old_rec.attribute12;
842: per_ctc_shd.g_old_rec.attribute11;
843: End If;
844: If (p_rec.attribute12 = hr_api.g_varchar2) then
845: p_rec.attribute12 :=
846: per_ctc_shd.g_old_rec.attribute12;
847: End If;
848: If (p_rec.attribute13 = hr_api.g_varchar2) then
849: p_rec.attribute13 :=
850: per_ctc_shd.g_old_rec.attribute13;
846: per_ctc_shd.g_old_rec.attribute12;
847: End If;
848: If (p_rec.attribute13 = hr_api.g_varchar2) then
849: p_rec.attribute13 :=
850: per_ctc_shd.g_old_rec.attribute13;
851: End If;
852: If (p_rec.attribute14 = hr_api.g_varchar2) then
853: p_rec.attribute14 :=
854: per_ctc_shd.g_old_rec.attribute14;
850: per_ctc_shd.g_old_rec.attribute13;
851: End If;
852: If (p_rec.attribute14 = hr_api.g_varchar2) then
853: p_rec.attribute14 :=
854: per_ctc_shd.g_old_rec.attribute14;
855: End If;
856: If (p_rec.attribute15 = hr_api.g_varchar2) then
857:
858: p_rec.attribute15 :=
855: End If;
856: If (p_rec.attribute15 = hr_api.g_varchar2) then
857:
858: p_rec.attribute15 :=
859: per_ctc_shd.g_old_rec.attribute15;
860: End If;
861: If (p_rec.attribute16 = hr_api.g_varchar2) then
862: p_rec.attribute16 :=
863: per_ctc_shd.g_old_rec.attribute16;
859: per_ctc_shd.g_old_rec.attribute15;
860: End If;
861: If (p_rec.attribute16 = hr_api.g_varchar2) then
862: p_rec.attribute16 :=
863: per_ctc_shd.g_old_rec.attribute16;
864: End If;
865: If (p_rec.attribute17 = hr_api.g_varchar2) then
866: p_rec.attribute17 :=
867: per_ctc_shd.g_old_rec.attribute17;
863: per_ctc_shd.g_old_rec.attribute16;
864: End If;
865: If (p_rec.attribute17 = hr_api.g_varchar2) then
866: p_rec.attribute17 :=
867: per_ctc_shd.g_old_rec.attribute17;
868: End If;
869: If (p_rec.attribute18 = hr_api.g_varchar2) then
870: p_rec.attribute18 :=
871: per_ctc_shd.g_old_rec.attribute18;
867: per_ctc_shd.g_old_rec.attribute17;
868: End If;
869: If (p_rec.attribute18 = hr_api.g_varchar2) then
870: p_rec.attribute18 :=
871: per_ctc_shd.g_old_rec.attribute18;
872: End If;
873: If (p_rec.attribute19 = hr_api.g_varchar2) then
874: p_rec.attribute19 :=
875: per_ctc_shd.g_old_rec.attribute19;
871: per_ctc_shd.g_old_rec.attribute18;
872: End If;
873: If (p_rec.attribute19 = hr_api.g_varchar2) then
874: p_rec.attribute19 :=
875: per_ctc_shd.g_old_rec.attribute19;
876: End If;
877: If (p_rec.attribute20 = hr_api.g_varchar2) then
878: p_rec.attribute20 :=
879: per_ctc_shd.g_old_rec.attribute20;
875: per_ctc_shd.g_old_rec.attribute19;
876: End If;
877: If (p_rec.attribute20 = hr_api.g_varchar2) then
878: p_rec.attribute20 :=
879: per_ctc_shd.g_old_rec.attribute20;
880: End If;
881: --
882: hr_utility.set_location(' Leaving:'||l_proc, 10);
883: --
887: -- |---------------------------------< upd >----------------------------------|
888: -- ----------------------------------------------------------------------------
889: Procedure upd
890: (
891: p_rec in out nocopy per_ctc_shd.g_rec_type,
892: p_effective_date in date,
893: p_datetrack_mode in varchar2
894: ) is
895: --
905: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
906: --
907: -- We must lock the row which we need to update.
908: --
909: per_ctc_shd.lck
910:
911: (p_effective_date => p_effective_date,
912: p_datetrack_mode => p_datetrack_mode,
913: p_contract_id => p_rec.contract_id,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2
1030: ) is
1031: --
1032: l_rec per_ctc_shd.g_rec_type;
1033: l_proc varchar2(72) := g_package||'upd';
1034: --
1035: Begin
1036: hr_utility.set_location('Entering:'||l_proc, 5);
1038: -- Call conversion function to turn arguments into the
1039: -- l_rec structure.
1040: --
1041: l_rec :=
1042: per_ctc_shd.convert_args
1043: (
1044: p_contract_id,
1045: null,
1046: null,
1163: p_argument_value => p_object_version_number);
1164: --
1165: -- We must lock the row which we need to update.
1166: --
1167: per_ctc_shd.lock_record
1168: (p_contract_id,
1169: p_effective_date,
1170: p_object_version_number
1171: );