50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pqh_asa_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
93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy pqh_asa_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date
150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy pqh_asa_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date
165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := pqh_asa_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else
175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: pqh_asa_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.assignment_acco_id
182: ,p_new_effective_end_date => p_rec.effective_end_date
183: ,p_validation_start_date => p_validation_start_date
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy pqh_asa_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date
284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in pqh_asa_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date
313: => p_rec.effective_start_date
314: ,p_effective_end_date
315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => pqh_asa_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => pqh_asa_shd.g_old_rec.effective_end_date
320: ,p_business_group_id_o
321: => pqh_asa_shd.g_old_rec.business_group_id
315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => pqh_asa_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => pqh_asa_shd.g_old_rec.effective_end_date
320: ,p_business_group_id_o
321: => pqh_asa_shd.g_old_rec.business_group_id
322: ,p_assignment_id_o
323: => pqh_asa_shd.g_old_rec.assignment_id
317: => pqh_asa_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => pqh_asa_shd.g_old_rec.effective_end_date
320: ,p_business_group_id_o
321: => pqh_asa_shd.g_old_rec.business_group_id
322: ,p_assignment_id_o
323: => pqh_asa_shd.g_old_rec.assignment_id
324: ,p_accommodation_given_o
325: => pqh_asa_shd.g_old_rec.accommodation_given
319: => pqh_asa_shd.g_old_rec.effective_end_date
320: ,p_business_group_id_o
321: => pqh_asa_shd.g_old_rec.business_group_id
322: ,p_assignment_id_o
323: => pqh_asa_shd.g_old_rec.assignment_id
324: ,p_accommodation_given_o
325: => pqh_asa_shd.g_old_rec.accommodation_given
326: ,p_temporary_assignment_o
327: => pqh_asa_shd.g_old_rec.temporary_assignment
321: => pqh_asa_shd.g_old_rec.business_group_id
322: ,p_assignment_id_o
323: => pqh_asa_shd.g_old_rec.assignment_id
324: ,p_accommodation_given_o
325: => pqh_asa_shd.g_old_rec.accommodation_given
326: ,p_temporary_assignment_o
327: => pqh_asa_shd.g_old_rec.temporary_assignment
328: ,p_accommodation_id_o
329: => pqh_asa_shd.g_old_rec.accommodation_id
323: => pqh_asa_shd.g_old_rec.assignment_id
324: ,p_accommodation_given_o
325: => pqh_asa_shd.g_old_rec.accommodation_given
326: ,p_temporary_assignment_o
327: => pqh_asa_shd.g_old_rec.temporary_assignment
328: ,p_accommodation_id_o
329: => pqh_asa_shd.g_old_rec.accommodation_id
330: ,p_acceptance_date_o
331: => pqh_asa_shd.g_old_rec.acceptance_date
325: => pqh_asa_shd.g_old_rec.accommodation_given
326: ,p_temporary_assignment_o
327: => pqh_asa_shd.g_old_rec.temporary_assignment
328: ,p_accommodation_id_o
329: => pqh_asa_shd.g_old_rec.accommodation_id
330: ,p_acceptance_date_o
331: => pqh_asa_shd.g_old_rec.acceptance_date
332: ,p_moving_date_o
333: => pqh_asa_shd.g_old_rec.moving_date
327: => pqh_asa_shd.g_old_rec.temporary_assignment
328: ,p_accommodation_id_o
329: => pqh_asa_shd.g_old_rec.accommodation_id
330: ,p_acceptance_date_o
331: => pqh_asa_shd.g_old_rec.acceptance_date
332: ,p_moving_date_o
333: => pqh_asa_shd.g_old_rec.moving_date
334: ,p_refusal_date_o
335: => pqh_asa_shd.g_old_rec.refusal_date
329: => pqh_asa_shd.g_old_rec.accommodation_id
330: ,p_acceptance_date_o
331: => pqh_asa_shd.g_old_rec.acceptance_date
332: ,p_moving_date_o
333: => pqh_asa_shd.g_old_rec.moving_date
334: ,p_refusal_date_o
335: => pqh_asa_shd.g_old_rec.refusal_date
336: ,p_comments_o
337: => pqh_asa_shd.g_old_rec.comments
331: => pqh_asa_shd.g_old_rec.acceptance_date
332: ,p_moving_date_o
333: => pqh_asa_shd.g_old_rec.moving_date
334: ,p_refusal_date_o
335: => pqh_asa_shd.g_old_rec.refusal_date
336: ,p_comments_o
337: => pqh_asa_shd.g_old_rec.comments
338: ,p_indemnity_entitlement_o
339: => pqh_asa_shd.g_old_rec.indemnity_entitlement
333: => pqh_asa_shd.g_old_rec.moving_date
334: ,p_refusal_date_o
335: => pqh_asa_shd.g_old_rec.refusal_date
336: ,p_comments_o
337: => pqh_asa_shd.g_old_rec.comments
338: ,p_indemnity_entitlement_o
339: => pqh_asa_shd.g_old_rec.indemnity_entitlement
340: ,p_indemnity_amount_o
341: => pqh_asa_shd.g_old_rec.indemnity_amount
335: => pqh_asa_shd.g_old_rec.refusal_date
336: ,p_comments_o
337: => pqh_asa_shd.g_old_rec.comments
338: ,p_indemnity_entitlement_o
339: => pqh_asa_shd.g_old_rec.indemnity_entitlement
340: ,p_indemnity_amount_o
341: => pqh_asa_shd.g_old_rec.indemnity_amount
342: ,p_type_of_payment_o
343: => pqh_asa_shd.g_old_rec.type_of_payment
337: => pqh_asa_shd.g_old_rec.comments
338: ,p_indemnity_entitlement_o
339: => pqh_asa_shd.g_old_rec.indemnity_entitlement
340: ,p_indemnity_amount_o
341: => pqh_asa_shd.g_old_rec.indemnity_amount
342: ,p_type_of_payment_o
343: => pqh_asa_shd.g_old_rec.type_of_payment
344: ,p_information_category_o
345: => pqh_asa_shd.g_old_rec.information_category
339: => pqh_asa_shd.g_old_rec.indemnity_entitlement
340: ,p_indemnity_amount_o
341: => pqh_asa_shd.g_old_rec.indemnity_amount
342: ,p_type_of_payment_o
343: => pqh_asa_shd.g_old_rec.type_of_payment
344: ,p_information_category_o
345: => pqh_asa_shd.g_old_rec.information_category
346: ,p_information1_o
347: => pqh_asa_shd.g_old_rec.information1
341: => pqh_asa_shd.g_old_rec.indemnity_amount
342: ,p_type_of_payment_o
343: => pqh_asa_shd.g_old_rec.type_of_payment
344: ,p_information_category_o
345: => pqh_asa_shd.g_old_rec.information_category
346: ,p_information1_o
347: => pqh_asa_shd.g_old_rec.information1
348: ,p_information2_o
349: => pqh_asa_shd.g_old_rec.information2
343: => pqh_asa_shd.g_old_rec.type_of_payment
344: ,p_information_category_o
345: => pqh_asa_shd.g_old_rec.information_category
346: ,p_information1_o
347: => pqh_asa_shd.g_old_rec.information1
348: ,p_information2_o
349: => pqh_asa_shd.g_old_rec.information2
350: ,p_information3_o
351: => pqh_asa_shd.g_old_rec.information3
345: => pqh_asa_shd.g_old_rec.information_category
346: ,p_information1_o
347: => pqh_asa_shd.g_old_rec.information1
348: ,p_information2_o
349: => pqh_asa_shd.g_old_rec.information2
350: ,p_information3_o
351: => pqh_asa_shd.g_old_rec.information3
352: ,p_information4_o
353: => pqh_asa_shd.g_old_rec.information4
347: => pqh_asa_shd.g_old_rec.information1
348: ,p_information2_o
349: => pqh_asa_shd.g_old_rec.information2
350: ,p_information3_o
351: => pqh_asa_shd.g_old_rec.information3
352: ,p_information4_o
353: => pqh_asa_shd.g_old_rec.information4
354: ,p_information5_o
355: => pqh_asa_shd.g_old_rec.information5
349: => pqh_asa_shd.g_old_rec.information2
350: ,p_information3_o
351: => pqh_asa_shd.g_old_rec.information3
352: ,p_information4_o
353: => pqh_asa_shd.g_old_rec.information4
354: ,p_information5_o
355: => pqh_asa_shd.g_old_rec.information5
356: ,p_information6_o
357: => pqh_asa_shd.g_old_rec.information6
351: => pqh_asa_shd.g_old_rec.information3
352: ,p_information4_o
353: => pqh_asa_shd.g_old_rec.information4
354: ,p_information5_o
355: => pqh_asa_shd.g_old_rec.information5
356: ,p_information6_o
357: => pqh_asa_shd.g_old_rec.information6
358: ,p_information7_o
359: => pqh_asa_shd.g_old_rec.information7
353: => pqh_asa_shd.g_old_rec.information4
354: ,p_information5_o
355: => pqh_asa_shd.g_old_rec.information5
356: ,p_information6_o
357: => pqh_asa_shd.g_old_rec.information6
358: ,p_information7_o
359: => pqh_asa_shd.g_old_rec.information7
360: ,p_information8_o
361: => pqh_asa_shd.g_old_rec.information8
355: => pqh_asa_shd.g_old_rec.information5
356: ,p_information6_o
357: => pqh_asa_shd.g_old_rec.information6
358: ,p_information7_o
359: => pqh_asa_shd.g_old_rec.information7
360: ,p_information8_o
361: => pqh_asa_shd.g_old_rec.information8
362: ,p_information9_o
363: => pqh_asa_shd.g_old_rec.information9
357: => pqh_asa_shd.g_old_rec.information6
358: ,p_information7_o
359: => pqh_asa_shd.g_old_rec.information7
360: ,p_information8_o
361: => pqh_asa_shd.g_old_rec.information8
362: ,p_information9_o
363: => pqh_asa_shd.g_old_rec.information9
364: ,p_information10_o
365: => pqh_asa_shd.g_old_rec.information10
359: => pqh_asa_shd.g_old_rec.information7
360: ,p_information8_o
361: => pqh_asa_shd.g_old_rec.information8
362: ,p_information9_o
363: => pqh_asa_shd.g_old_rec.information9
364: ,p_information10_o
365: => pqh_asa_shd.g_old_rec.information10
366: ,p_information11_o
367: => pqh_asa_shd.g_old_rec.information11
361: => pqh_asa_shd.g_old_rec.information8
362: ,p_information9_o
363: => pqh_asa_shd.g_old_rec.information9
364: ,p_information10_o
365: => pqh_asa_shd.g_old_rec.information10
366: ,p_information11_o
367: => pqh_asa_shd.g_old_rec.information11
368: ,p_information12_o
369: => pqh_asa_shd.g_old_rec.information12
363: => pqh_asa_shd.g_old_rec.information9
364: ,p_information10_o
365: => pqh_asa_shd.g_old_rec.information10
366: ,p_information11_o
367: => pqh_asa_shd.g_old_rec.information11
368: ,p_information12_o
369: => pqh_asa_shd.g_old_rec.information12
370: ,p_information13_o
371: => pqh_asa_shd.g_old_rec.information13
365: => pqh_asa_shd.g_old_rec.information10
366: ,p_information11_o
367: => pqh_asa_shd.g_old_rec.information11
368: ,p_information12_o
369: => pqh_asa_shd.g_old_rec.information12
370: ,p_information13_o
371: => pqh_asa_shd.g_old_rec.information13
372: ,p_information14_o
373: => pqh_asa_shd.g_old_rec.information14
367: => pqh_asa_shd.g_old_rec.information11
368: ,p_information12_o
369: => pqh_asa_shd.g_old_rec.information12
370: ,p_information13_o
371: => pqh_asa_shd.g_old_rec.information13
372: ,p_information14_o
373: => pqh_asa_shd.g_old_rec.information14
374: ,p_information15_o
375: => pqh_asa_shd.g_old_rec.information15
369: => pqh_asa_shd.g_old_rec.information12
370: ,p_information13_o
371: => pqh_asa_shd.g_old_rec.information13
372: ,p_information14_o
373: => pqh_asa_shd.g_old_rec.information14
374: ,p_information15_o
375: => pqh_asa_shd.g_old_rec.information15
376: ,p_information16_o
377: => pqh_asa_shd.g_old_rec.information16
371: => pqh_asa_shd.g_old_rec.information13
372: ,p_information14_o
373: => pqh_asa_shd.g_old_rec.information14
374: ,p_information15_o
375: => pqh_asa_shd.g_old_rec.information15
376: ,p_information16_o
377: => pqh_asa_shd.g_old_rec.information16
378: ,p_information17_o
379: => pqh_asa_shd.g_old_rec.information17
373: => pqh_asa_shd.g_old_rec.information14
374: ,p_information15_o
375: => pqh_asa_shd.g_old_rec.information15
376: ,p_information16_o
377: => pqh_asa_shd.g_old_rec.information16
378: ,p_information17_o
379: => pqh_asa_shd.g_old_rec.information17
380: ,p_information18_o
381: => pqh_asa_shd.g_old_rec.information18
375: => pqh_asa_shd.g_old_rec.information15
376: ,p_information16_o
377: => pqh_asa_shd.g_old_rec.information16
378: ,p_information17_o
379: => pqh_asa_shd.g_old_rec.information17
380: ,p_information18_o
381: => pqh_asa_shd.g_old_rec.information18
382: ,p_information19_o
383: => pqh_asa_shd.g_old_rec.information19
377: => pqh_asa_shd.g_old_rec.information16
378: ,p_information17_o
379: => pqh_asa_shd.g_old_rec.information17
380: ,p_information18_o
381: => pqh_asa_shd.g_old_rec.information18
382: ,p_information19_o
383: => pqh_asa_shd.g_old_rec.information19
384: ,p_information20_o
385: => pqh_asa_shd.g_old_rec.information20
379: => pqh_asa_shd.g_old_rec.information17
380: ,p_information18_o
381: => pqh_asa_shd.g_old_rec.information18
382: ,p_information19_o
383: => pqh_asa_shd.g_old_rec.information19
384: ,p_information20_o
385: => pqh_asa_shd.g_old_rec.information20
386: ,p_information21_o
387: => pqh_asa_shd.g_old_rec.information21
381: => pqh_asa_shd.g_old_rec.information18
382: ,p_information19_o
383: => pqh_asa_shd.g_old_rec.information19
384: ,p_information20_o
385: => pqh_asa_shd.g_old_rec.information20
386: ,p_information21_o
387: => pqh_asa_shd.g_old_rec.information21
388: ,p_information22_o
389: => pqh_asa_shd.g_old_rec.information22
383: => pqh_asa_shd.g_old_rec.information19
384: ,p_information20_o
385: => pqh_asa_shd.g_old_rec.information20
386: ,p_information21_o
387: => pqh_asa_shd.g_old_rec.information21
388: ,p_information22_o
389: => pqh_asa_shd.g_old_rec.information22
390: ,p_information23_o
391: => pqh_asa_shd.g_old_rec.information23
385: => pqh_asa_shd.g_old_rec.information20
386: ,p_information21_o
387: => pqh_asa_shd.g_old_rec.information21
388: ,p_information22_o
389: => pqh_asa_shd.g_old_rec.information22
390: ,p_information23_o
391: => pqh_asa_shd.g_old_rec.information23
392: ,p_information24_o
393: => pqh_asa_shd.g_old_rec.information24
387: => pqh_asa_shd.g_old_rec.information21
388: ,p_information22_o
389: => pqh_asa_shd.g_old_rec.information22
390: ,p_information23_o
391: => pqh_asa_shd.g_old_rec.information23
392: ,p_information24_o
393: => pqh_asa_shd.g_old_rec.information24
394: ,p_information25_o
395: => pqh_asa_shd.g_old_rec.information25
389: => pqh_asa_shd.g_old_rec.information22
390: ,p_information23_o
391: => pqh_asa_shd.g_old_rec.information23
392: ,p_information24_o
393: => pqh_asa_shd.g_old_rec.information24
394: ,p_information25_o
395: => pqh_asa_shd.g_old_rec.information25
396: ,p_information26_o
397: => pqh_asa_shd.g_old_rec.information26
391: => pqh_asa_shd.g_old_rec.information23
392: ,p_information24_o
393: => pqh_asa_shd.g_old_rec.information24
394: ,p_information25_o
395: => pqh_asa_shd.g_old_rec.information25
396: ,p_information26_o
397: => pqh_asa_shd.g_old_rec.information26
398: ,p_information27_o
399: => pqh_asa_shd.g_old_rec.information27
393: => pqh_asa_shd.g_old_rec.information24
394: ,p_information25_o
395: => pqh_asa_shd.g_old_rec.information25
396: ,p_information26_o
397: => pqh_asa_shd.g_old_rec.information26
398: ,p_information27_o
399: => pqh_asa_shd.g_old_rec.information27
400: ,p_information28_o
401: => pqh_asa_shd.g_old_rec.information28
395: => pqh_asa_shd.g_old_rec.information25
396: ,p_information26_o
397: => pqh_asa_shd.g_old_rec.information26
398: ,p_information27_o
399: => pqh_asa_shd.g_old_rec.information27
400: ,p_information28_o
401: => pqh_asa_shd.g_old_rec.information28
402: ,p_information29_o
403: => pqh_asa_shd.g_old_rec.information29
397: => pqh_asa_shd.g_old_rec.information26
398: ,p_information27_o
399: => pqh_asa_shd.g_old_rec.information27
400: ,p_information28_o
401: => pqh_asa_shd.g_old_rec.information28
402: ,p_information29_o
403: => pqh_asa_shd.g_old_rec.information29
404: ,p_information30_o
405: => pqh_asa_shd.g_old_rec.information30
399: => pqh_asa_shd.g_old_rec.information27
400: ,p_information28_o
401: => pqh_asa_shd.g_old_rec.information28
402: ,p_information29_o
403: => pqh_asa_shd.g_old_rec.information29
404: ,p_information30_o
405: => pqh_asa_shd.g_old_rec.information30
406: ,p_attribute_category_o
407: => pqh_asa_shd.g_old_rec.attribute_category
401: => pqh_asa_shd.g_old_rec.information28
402: ,p_information29_o
403: => pqh_asa_shd.g_old_rec.information29
404: ,p_information30_o
405: => pqh_asa_shd.g_old_rec.information30
406: ,p_attribute_category_o
407: => pqh_asa_shd.g_old_rec.attribute_category
408: ,p_attribute1_o
409: => pqh_asa_shd.g_old_rec.attribute1
403: => pqh_asa_shd.g_old_rec.information29
404: ,p_information30_o
405: => pqh_asa_shd.g_old_rec.information30
406: ,p_attribute_category_o
407: => pqh_asa_shd.g_old_rec.attribute_category
408: ,p_attribute1_o
409: => pqh_asa_shd.g_old_rec.attribute1
410: ,p_attribute2_o
411: => pqh_asa_shd.g_old_rec.attribute2
405: => pqh_asa_shd.g_old_rec.information30
406: ,p_attribute_category_o
407: => pqh_asa_shd.g_old_rec.attribute_category
408: ,p_attribute1_o
409: => pqh_asa_shd.g_old_rec.attribute1
410: ,p_attribute2_o
411: => pqh_asa_shd.g_old_rec.attribute2
412: ,p_attribute3_o
413: => pqh_asa_shd.g_old_rec.attribute3
407: => pqh_asa_shd.g_old_rec.attribute_category
408: ,p_attribute1_o
409: => pqh_asa_shd.g_old_rec.attribute1
410: ,p_attribute2_o
411: => pqh_asa_shd.g_old_rec.attribute2
412: ,p_attribute3_o
413: => pqh_asa_shd.g_old_rec.attribute3
414: ,p_attribute4_o
415: => pqh_asa_shd.g_old_rec.attribute4
409: => pqh_asa_shd.g_old_rec.attribute1
410: ,p_attribute2_o
411: => pqh_asa_shd.g_old_rec.attribute2
412: ,p_attribute3_o
413: => pqh_asa_shd.g_old_rec.attribute3
414: ,p_attribute4_o
415: => pqh_asa_shd.g_old_rec.attribute4
416: ,p_attribute5_o
417: => pqh_asa_shd.g_old_rec.attribute5
411: => pqh_asa_shd.g_old_rec.attribute2
412: ,p_attribute3_o
413: => pqh_asa_shd.g_old_rec.attribute3
414: ,p_attribute4_o
415: => pqh_asa_shd.g_old_rec.attribute4
416: ,p_attribute5_o
417: => pqh_asa_shd.g_old_rec.attribute5
418: ,p_attribute6_o
419: => pqh_asa_shd.g_old_rec.attribute6
413: => pqh_asa_shd.g_old_rec.attribute3
414: ,p_attribute4_o
415: => pqh_asa_shd.g_old_rec.attribute4
416: ,p_attribute5_o
417: => pqh_asa_shd.g_old_rec.attribute5
418: ,p_attribute6_o
419: => pqh_asa_shd.g_old_rec.attribute6
420: ,p_attribute7_o
421: => pqh_asa_shd.g_old_rec.attribute7
415: => pqh_asa_shd.g_old_rec.attribute4
416: ,p_attribute5_o
417: => pqh_asa_shd.g_old_rec.attribute5
418: ,p_attribute6_o
419: => pqh_asa_shd.g_old_rec.attribute6
420: ,p_attribute7_o
421: => pqh_asa_shd.g_old_rec.attribute7
422: ,p_attribute8_o
423: => pqh_asa_shd.g_old_rec.attribute8
417: => pqh_asa_shd.g_old_rec.attribute5
418: ,p_attribute6_o
419: => pqh_asa_shd.g_old_rec.attribute6
420: ,p_attribute7_o
421: => pqh_asa_shd.g_old_rec.attribute7
422: ,p_attribute8_o
423: => pqh_asa_shd.g_old_rec.attribute8
424: ,p_attribute9_o
425: => pqh_asa_shd.g_old_rec.attribute9
419: => pqh_asa_shd.g_old_rec.attribute6
420: ,p_attribute7_o
421: => pqh_asa_shd.g_old_rec.attribute7
422: ,p_attribute8_o
423: => pqh_asa_shd.g_old_rec.attribute8
424: ,p_attribute9_o
425: => pqh_asa_shd.g_old_rec.attribute9
426: ,p_attribute10_o
427: => pqh_asa_shd.g_old_rec.attribute10
421: => pqh_asa_shd.g_old_rec.attribute7
422: ,p_attribute8_o
423: => pqh_asa_shd.g_old_rec.attribute8
424: ,p_attribute9_o
425: => pqh_asa_shd.g_old_rec.attribute9
426: ,p_attribute10_o
427: => pqh_asa_shd.g_old_rec.attribute10
428: ,p_attribute11_o
429: => pqh_asa_shd.g_old_rec.attribute11
423: => pqh_asa_shd.g_old_rec.attribute8
424: ,p_attribute9_o
425: => pqh_asa_shd.g_old_rec.attribute9
426: ,p_attribute10_o
427: => pqh_asa_shd.g_old_rec.attribute10
428: ,p_attribute11_o
429: => pqh_asa_shd.g_old_rec.attribute11
430: ,p_attribute12_o
431: => pqh_asa_shd.g_old_rec.attribute12
425: => pqh_asa_shd.g_old_rec.attribute9
426: ,p_attribute10_o
427: => pqh_asa_shd.g_old_rec.attribute10
428: ,p_attribute11_o
429: => pqh_asa_shd.g_old_rec.attribute11
430: ,p_attribute12_o
431: => pqh_asa_shd.g_old_rec.attribute12
432: ,p_attribute13_o
433: => pqh_asa_shd.g_old_rec.attribute13
427: => pqh_asa_shd.g_old_rec.attribute10
428: ,p_attribute11_o
429: => pqh_asa_shd.g_old_rec.attribute11
430: ,p_attribute12_o
431: => pqh_asa_shd.g_old_rec.attribute12
432: ,p_attribute13_o
433: => pqh_asa_shd.g_old_rec.attribute13
434: ,p_attribute14_o
435: => pqh_asa_shd.g_old_rec.attribute14
429: => pqh_asa_shd.g_old_rec.attribute11
430: ,p_attribute12_o
431: => pqh_asa_shd.g_old_rec.attribute12
432: ,p_attribute13_o
433: => pqh_asa_shd.g_old_rec.attribute13
434: ,p_attribute14_o
435: => pqh_asa_shd.g_old_rec.attribute14
436: ,p_attribute15_o
437: => pqh_asa_shd.g_old_rec.attribute15
431: => pqh_asa_shd.g_old_rec.attribute12
432: ,p_attribute13_o
433: => pqh_asa_shd.g_old_rec.attribute13
434: ,p_attribute14_o
435: => pqh_asa_shd.g_old_rec.attribute14
436: ,p_attribute15_o
437: => pqh_asa_shd.g_old_rec.attribute15
438: ,p_attribute16_o
439: => pqh_asa_shd.g_old_rec.attribute16
433: => pqh_asa_shd.g_old_rec.attribute13
434: ,p_attribute14_o
435: => pqh_asa_shd.g_old_rec.attribute14
436: ,p_attribute15_o
437: => pqh_asa_shd.g_old_rec.attribute15
438: ,p_attribute16_o
439: => pqh_asa_shd.g_old_rec.attribute16
440: ,p_attribute17_o
441: => pqh_asa_shd.g_old_rec.attribute17
435: => pqh_asa_shd.g_old_rec.attribute14
436: ,p_attribute15_o
437: => pqh_asa_shd.g_old_rec.attribute15
438: ,p_attribute16_o
439: => pqh_asa_shd.g_old_rec.attribute16
440: ,p_attribute17_o
441: => pqh_asa_shd.g_old_rec.attribute17
442: ,p_attribute18_o
443: => pqh_asa_shd.g_old_rec.attribute18
437: => pqh_asa_shd.g_old_rec.attribute15
438: ,p_attribute16_o
439: => pqh_asa_shd.g_old_rec.attribute16
440: ,p_attribute17_o
441: => pqh_asa_shd.g_old_rec.attribute17
442: ,p_attribute18_o
443: => pqh_asa_shd.g_old_rec.attribute18
444: ,p_attribute19_o
445: => pqh_asa_shd.g_old_rec.attribute19
439: => pqh_asa_shd.g_old_rec.attribute16
440: ,p_attribute17_o
441: => pqh_asa_shd.g_old_rec.attribute17
442: ,p_attribute18_o
443: => pqh_asa_shd.g_old_rec.attribute18
444: ,p_attribute19_o
445: => pqh_asa_shd.g_old_rec.attribute19
446: ,p_attribute20_o
447: => pqh_asa_shd.g_old_rec.attribute20
441: => pqh_asa_shd.g_old_rec.attribute17
442: ,p_attribute18_o
443: => pqh_asa_shd.g_old_rec.attribute18
444: ,p_attribute19_o
445: => pqh_asa_shd.g_old_rec.attribute19
446: ,p_attribute20_o
447: => pqh_asa_shd.g_old_rec.attribute20
448: ,p_attribute21_o
449: => pqh_asa_shd.g_old_rec.attribute21
443: => pqh_asa_shd.g_old_rec.attribute18
444: ,p_attribute19_o
445: => pqh_asa_shd.g_old_rec.attribute19
446: ,p_attribute20_o
447: => pqh_asa_shd.g_old_rec.attribute20
448: ,p_attribute21_o
449: => pqh_asa_shd.g_old_rec.attribute21
450: ,p_attribute22_o
451: => pqh_asa_shd.g_old_rec.attribute22
445: => pqh_asa_shd.g_old_rec.attribute19
446: ,p_attribute20_o
447: => pqh_asa_shd.g_old_rec.attribute20
448: ,p_attribute21_o
449: => pqh_asa_shd.g_old_rec.attribute21
450: ,p_attribute22_o
451: => pqh_asa_shd.g_old_rec.attribute22
452: ,p_attribute23_o
453: => pqh_asa_shd.g_old_rec.attribute23
447: => pqh_asa_shd.g_old_rec.attribute20
448: ,p_attribute21_o
449: => pqh_asa_shd.g_old_rec.attribute21
450: ,p_attribute22_o
451: => pqh_asa_shd.g_old_rec.attribute22
452: ,p_attribute23_o
453: => pqh_asa_shd.g_old_rec.attribute23
454: ,p_attribute24_o
455: => pqh_asa_shd.g_old_rec.attribute24
449: => pqh_asa_shd.g_old_rec.attribute21
450: ,p_attribute22_o
451: => pqh_asa_shd.g_old_rec.attribute22
452: ,p_attribute23_o
453: => pqh_asa_shd.g_old_rec.attribute23
454: ,p_attribute24_o
455: => pqh_asa_shd.g_old_rec.attribute24
456: ,p_attribute25_o
457: => pqh_asa_shd.g_old_rec.attribute25
451: => pqh_asa_shd.g_old_rec.attribute22
452: ,p_attribute23_o
453: => pqh_asa_shd.g_old_rec.attribute23
454: ,p_attribute24_o
455: => pqh_asa_shd.g_old_rec.attribute24
456: ,p_attribute25_o
457: => pqh_asa_shd.g_old_rec.attribute25
458: ,p_attribute26_o
459: => pqh_asa_shd.g_old_rec.attribute26
453: => pqh_asa_shd.g_old_rec.attribute23
454: ,p_attribute24_o
455: => pqh_asa_shd.g_old_rec.attribute24
456: ,p_attribute25_o
457: => pqh_asa_shd.g_old_rec.attribute25
458: ,p_attribute26_o
459: => pqh_asa_shd.g_old_rec.attribute26
460: ,p_attribute27_o
461: => pqh_asa_shd.g_old_rec.attribute27
455: => pqh_asa_shd.g_old_rec.attribute24
456: ,p_attribute25_o
457: => pqh_asa_shd.g_old_rec.attribute25
458: ,p_attribute26_o
459: => pqh_asa_shd.g_old_rec.attribute26
460: ,p_attribute27_o
461: => pqh_asa_shd.g_old_rec.attribute27
462: ,p_attribute28_o
463: => pqh_asa_shd.g_old_rec.attribute28
457: => pqh_asa_shd.g_old_rec.attribute25
458: ,p_attribute26_o
459: => pqh_asa_shd.g_old_rec.attribute26
460: ,p_attribute27_o
461: => pqh_asa_shd.g_old_rec.attribute27
462: ,p_attribute28_o
463: => pqh_asa_shd.g_old_rec.attribute28
464: ,p_attribute29_o
465: => pqh_asa_shd.g_old_rec.attribute29
459: => pqh_asa_shd.g_old_rec.attribute26
460: ,p_attribute27_o
461: => pqh_asa_shd.g_old_rec.attribute27
462: ,p_attribute28_o
463: => pqh_asa_shd.g_old_rec.attribute28
464: ,p_attribute29_o
465: => pqh_asa_shd.g_old_rec.attribute29
466: ,p_attribute30_o
467: => pqh_asa_shd.g_old_rec.attribute30
461: => pqh_asa_shd.g_old_rec.attribute27
462: ,p_attribute28_o
463: => pqh_asa_shd.g_old_rec.attribute28
464: ,p_attribute29_o
465: => pqh_asa_shd.g_old_rec.attribute29
466: ,p_attribute30_o
467: => pqh_asa_shd.g_old_rec.attribute30
468: ,p_object_version_number_o
469: => pqh_asa_shd.g_old_rec.object_version_number
463: => pqh_asa_shd.g_old_rec.attribute28
464: ,p_attribute29_o
465: => pqh_asa_shd.g_old_rec.attribute29
466: ,p_attribute30_o
467: => pqh_asa_shd.g_old_rec.attribute30
468: ,p_object_version_number_o
469: => pqh_asa_shd.g_old_rec.object_version_number
470: ,p_reason_for_no_acco_o
471: => pqh_asa_shd.g_old_rec.reason_for_no_acco
465: => pqh_asa_shd.g_old_rec.attribute29
466: ,p_attribute30_o
467: => pqh_asa_shd.g_old_rec.attribute30
468: ,p_object_version_number_o
469: => pqh_asa_shd.g_old_rec.object_version_number
470: ,p_reason_for_no_acco_o
471: => pqh_asa_shd.g_old_rec.reason_for_no_acco
472: ,p_indemnity_currency_o
473: => pqh_asa_shd.g_old_rec.indemnity_currency
467: => pqh_asa_shd.g_old_rec.attribute30
468: ,p_object_version_number_o
469: => pqh_asa_shd.g_old_rec.object_version_number
470: ,p_reason_for_no_acco_o
471: => pqh_asa_shd.g_old_rec.reason_for_no_acco
472: ,p_indemnity_currency_o
473: => pqh_asa_shd.g_old_rec.indemnity_currency
474: );
475: --
469: => pqh_asa_shd.g_old_rec.object_version_number
470: ,p_reason_for_no_acco_o
471: => pqh_asa_shd.g_old_rec.reason_for_no_acco
472: ,p_indemnity_currency_o
473: => pqh_asa_shd.g_old_rec.indemnity_currency
474: );
475: --
476: exception
477: --
491: -- ----------------------------------------------------------------------------
492: Procedure del
493: (p_effective_date in date
494: ,p_datetrack_mode in varchar2
495: ,p_rec in out nocopy pqh_asa_shd.g_rec_type
496: ) is
497: --
498: l_proc varchar2(72) := g_package||'del';
499: l_validation_start_date date;
507: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
508: --
509: -- We must lock the row which we need to delete.
510: --
511: pqh_asa_shd.lck
512: (p_effective_date => p_effective_date
513: ,p_datetrack_mode => p_datetrack_mode
514: ,p_assignment_acco_id => p_rec.assignment_acco_id
515: ,p_object_version_number => p_rec.object_version_number
576: ,p_effective_start_date out nocopy date
577: ,p_effective_end_date out nocopy date
578: ) is
579: --
580: l_rec pqh_asa_shd.g_rec_type;
581: l_proc varchar2(72) := g_package||'del';
582: --
583: Begin
584: hr_utility.set_location('Entering:'||l_proc, 5);