50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy per_ctc_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is
93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy per_ctc_shd.g_rec_type,
98: p_effective_date in date,
99: p_datetrack_mode in varchar2,
100: p_validation_start_date in date,
101:
148: --
149: -- {End Of Comments}
150: -- ----------------------------------------------------------------------------
151: Procedure dt_pre_delete
152: (p_rec in out nocopy per_ctc_shd.g_rec_type,
153: p_effective_date in date,
154:
155: p_datetrack_mode in varchar2,
156: p_validation_start_date in date,
162: hr_utility.set_location('Entering:'||l_proc, 5);
163: --
164: If (p_datetrack_mode <> 'ZAP') then
165: --
166: p_rec.effective_start_date := per_ctc_shd.g_old_rec.effective_start_date;
167: --
168: If (p_datetrack_mode = 'DELETE') then
169: p_rec.effective_end_date := p_validation_start_date - 1;
170: Else
172: End If;
173: --
174: -- Update the current effective end date record
175: --
176: per_ctc_shd.upd_effective_end_date
177: (p_effective_date => p_effective_date,
178: p_base_key_value => p_rec.contract_id,
179: p_new_effective_end_date => p_rec.effective_end_date,
180: p_validation_start_date => p_validation_start_date,
221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure pre_delete
225: (p_rec in out nocopy per_ctc_shd.g_rec_type,
226: p_effective_date in date,
227: p_datetrack_mode in varchar2,
228: p_validation_start_date in date,
229: p_validation_end_date in date) is
278: --
279: -- {End Of Comments}
280: -- ----------------------------------------------------------------------------
281: Procedure post_delete
282: (p_rec in per_ctc_shd.g_rec_type,
283: p_effective_date in date,
284: p_datetrack_mode in varchar2,
285: p_validation_start_date in date,
286: p_validation_end_date in date) is
303: p_contract_id => p_rec.contract_id,
304: p_effective_start_date => p_rec.effective_start_date,
305: p_effective_end_date => p_rec.effective_end_date,
306: p_object_version_number => p_rec.object_version_number,
307: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
308: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date,
309: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
310: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
304: p_effective_start_date => p_rec.effective_start_date,
305: p_effective_end_date => p_rec.effective_end_date,
306: p_object_version_number => p_rec.object_version_number,
307: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
308: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date,
309: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
310: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
312: p_type_o => per_ctc_shd.g_old_rec.type,
305: p_effective_end_date => p_rec.effective_end_date,
306: p_object_version_number => p_rec.object_version_number,
307: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
308: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date,
309: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
310: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
312: p_type_o => per_ctc_shd.g_old_rec.type,
313: p_status_o => per_ctc_shd.g_old_rec.status,
306: p_object_version_number => p_rec.object_version_number,
307: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
308: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date,
309: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
310: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
312: p_type_o => per_ctc_shd.g_old_rec.type,
313: p_status_o => per_ctc_shd.g_old_rec.status,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
307: p_effective_start_date_o => per_ctc_shd.g_old_rec.effective_start_date,
308: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date,
309: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
310: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
312: p_type_o => per_ctc_shd.g_old_rec.type,
313: p_status_o => per_ctc_shd.g_old_rec.status,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
308: p_effective_end_date_o => per_ctc_shd.g_old_rec.effective_end_date,
309: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
310: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
312: p_type_o => per_ctc_shd.g_old_rec.type,
313: p_status_o => per_ctc_shd.g_old_rec.status,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
309: p_business_group_id_o => per_ctc_shd.g_old_rec.business_group_id,
310: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
312: p_type_o => per_ctc_shd.g_old_rec.type,
313: p_status_o => per_ctc_shd.g_old_rec.status,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
317: p_description_o => per_ctc_shd.g_old_rec.description,
310: p_person_id_o => per_ctc_shd.g_old_rec.person_id,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
312: p_type_o => per_ctc_shd.g_old_rec.type,
313: p_status_o => per_ctc_shd.g_old_rec.status,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
317: p_description_o => per_ctc_shd.g_old_rec.description,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
311: p_reference_o => per_ctc_shd.g_old_rec.reference,
312: p_type_o => per_ctc_shd.g_old_rec.type,
313: p_status_o => per_ctc_shd.g_old_rec.status,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
317: p_description_o => per_ctc_shd.g_old_rec.description,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
312: p_type_o => per_ctc_shd.g_old_rec.type,
313: p_status_o => per_ctc_shd.g_old_rec.status,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
317: p_description_o => per_ctc_shd.g_old_rec.description,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
313: p_status_o => per_ctc_shd.g_old_rec.status,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
317: p_description_o => per_ctc_shd.g_old_rec.description,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
314: p_status_reason_o => per_ctc_shd.g_old_rec.status_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
317: p_description_o => per_ctc_shd.g_old_rec.description,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
315: p_doc_status_o => per_ctc_shd.g_old_rec.doc_status,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
317: p_description_o => per_ctc_shd.g_old_rec.description,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
316: p_doc_status_change_date_o => per_ctc_shd.g_old_rec.doc_status_change_date,
317: p_description_o => per_ctc_shd.g_old_rec.description,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
317: p_description_o => per_ctc_shd.g_old_rec.description,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
318: p_duration_o => per_ctc_shd.g_old_rec.duration,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
319: p_duration_units_o => per_ctc_shd.g_old_rec.duration_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
320: p_contractual_job_title_o => per_ctc_shd.g_old_rec.contractual_job_title,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
321: p_parties_o => per_ctc_shd.g_old_rec.parties,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
322: p_start_reason_o => per_ctc_shd.g_old_rec.start_reason,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
323: p_end_reason_o => per_ctc_shd.g_old_rec.end_reason ,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
324: p_number_of_extensions_o => per_ctc_shd.g_old_rec.number_of_extensions,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
325: p_extension_reason_o => per_ctc_shd.g_old_rec.extension_reason,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
326: p_extension_period_o => per_ctc_shd.g_old_rec.extension_period,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
327: p_extension_period_units_o => per_ctc_shd.g_old_rec.extension_period_units,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
328: p_ctr_information_category_o => per_ctc_shd.g_old_rec.ctr_information_category,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
329: p_ctr_information1_o => per_ctc_shd.g_old_rec.ctr_information1,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
330: p_ctr_information2_o => per_ctc_shd.g_old_rec.ctr_information2,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
331: p_ctr_information3_o => per_ctc_shd.g_old_rec.ctr_information3,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
332: p_ctr_information4_o => per_ctc_shd.g_old_rec.ctr_information4,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
333: p_ctr_information5_o => per_ctc_shd.g_old_rec.ctr_information5,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
334: p_ctr_information6_o => per_ctc_shd.g_old_rec.ctr_information6,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
335: p_ctr_information7_o => per_ctc_shd.g_old_rec.ctr_information7,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
336: p_ctr_information8_o => per_ctc_shd.g_old_rec.ctr_information8,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
337: p_ctr_information9_o => per_ctc_shd.g_old_rec.ctr_information9,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
338: p_ctr_information10_o => per_ctc_shd.g_old_rec.ctr_information10,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
339: p_ctr_information11_o => per_ctc_shd.g_old_rec.ctr_information11,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
340: p_ctr_information12_o => per_ctc_shd.g_old_rec.ctr_information12,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
341: p_ctr_information13_o => per_ctc_shd.g_old_rec.ctr_information13,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
342: p_ctr_information14_o => per_ctc_shd.g_old_rec.ctr_information14,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
343: p_ctr_information15_o => per_ctc_shd.g_old_rec.ctr_information15,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
344: p_ctr_information16_o => per_ctc_shd.g_old_rec.ctr_information16,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
345: p_ctr_information17_o => per_ctc_shd.g_old_rec.ctr_information17,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
346: p_ctr_information18_o => per_ctc_shd.g_old_rec.ctr_information18,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
347: p_ctr_information19_o => per_ctc_shd.g_old_rec.ctr_information19,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
348: p_ctr_information20_o => per_ctc_shd.g_old_rec.ctr_information20,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
349: p_attribute_category_o => per_ctc_shd.g_old_rec.attribute_category,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
350: p_attribute1_o => per_ctc_shd.g_old_rec.attribute1,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
351: p_attribute2_o => per_ctc_shd.g_old_rec.attribute2,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
352: p_attribute3_o => per_ctc_shd.g_old_rec.attribute3,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
353: p_attribute4_o => per_ctc_shd.g_old_rec.attribute4,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
354: p_attribute5_o => per_ctc_shd.g_old_rec.attribute5,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
355: p_attribute6_o => per_ctc_shd.g_old_rec.attribute6,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
356: p_attribute7_o => per_ctc_shd.g_old_rec.attribute7,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
357: p_attribute8_o => per_ctc_shd.g_old_rec.attribute8,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
358: p_attribute9_o => per_ctc_shd.g_old_rec.attribute9,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
359: p_attribute10_o => per_ctc_shd.g_old_rec.attribute10,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
367: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
360: p_attribute11_o => per_ctc_shd.g_old_rec.attribute11,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
367: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
368: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
361: p_attribute12_o => per_ctc_shd.g_old_rec.attribute12,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
367: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
368: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
369: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
362: p_attribute13_o => per_ctc_shd.g_old_rec.attribute13,
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
367: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
368: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
369: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
370: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number
363: p_attribute14_o => per_ctc_shd.g_old_rec.attribute14,
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
367: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
368: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
369: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
370: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number
371: );
364: p_attribute15_o => per_ctc_shd.g_old_rec.attribute15,
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
367: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
368: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
369: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
370: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number
371: );
372: --
365: p_attribute16_o => per_ctc_shd.g_old_rec.attribute16,
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
367: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
368: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
369: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
370: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number
371: );
372: --
373: exception
366: p_attribute17_o => per_ctc_shd.g_old_rec.attribute17,
367: p_attribute18_o => per_ctc_shd.g_old_rec.attribute18,
368: p_attribute19_o => per_ctc_shd.g_old_rec.attribute19,
369: p_attribute20_o => per_ctc_shd.g_old_rec.attribute20,
370: p_object_version_number_o => per_ctc_shd.g_old_rec.object_version_number
371: );
372: --
373: exception
374: --
390:
391: -- ----------------------------------------------------------------------------
392: Procedure del
393: (
394: p_rec in out nocopy per_ctc_shd.g_rec_type,
395: p_effective_date in date,
396: p_datetrack_mode in varchar2
397: ) is
398: --
408: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
409: --
410: -- We must lock the row which we need to delete.
411: --
412: per_ctc_shd.lck
413: (p_effective_date => p_effective_date,
414: p_datetrack_mode => p_datetrack_mode,
415: p_contract_id => p_rec.contract_id,
416: p_object_version_number => p_rec.object_version_number,
467: p_effective_date in date,
468: p_datetrack_mode in varchar2
469: ) is
470: --
471: l_rec per_ctc_shd.g_rec_type;
472: l_proc varchar2(72) := g_package||'del';
473: --
474: Begin
475: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: --
538: -- We must lock the row which we need to delete.
539: --
540: per_ctc_shd.lock_record
541: (p_contract_id,
542: p_effective_date,
543: p_object_version_number
544: );