[Home] [Help]
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from pay_personal_payment_methods_f
72: where personal_payment_method_id = p_rec.personal_payment_method_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --
83: delete from pay_personal_payment_methods_f
84: where personal_payment_method_id = p_rec.personal_payment_method_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
239: -- Cursor C_Sel1 select comments to be deleted
240: --
241: Cursor C_Sel1 is
242: select t1.comment_id
243: from pay_personal_payment_methods_f t1
244: where t1.comment_id is not null
245: and t1.personal_payment_method_id = p_rec.personal_payment_method_id
246: and t1.effective_start_date <= p_validation_end_date
247: and t1.effective_end_date >= p_validation_start_date
246: and t1.effective_start_date <= p_validation_end_date
247: and t1.effective_end_date >= p_validation_start_date
248: and not exists
249: (select 1
250: from pay_personal_payment_methods_f t2
251: where t2.comment_id = t1.comment_id
252: and t2.personal_payment_method_id = t1.personal_payment_method_id
253:
254: and (t2.effective_start_date > p_validation_end_date
463: );
464: exception
465: when hr_api.cannot_find_prog_unit then
466: hr_api.cannot_find_prog_unit_error
467: (p_module_name => 'PAY_PERSONAL_PAYMENT_METHODS_F'
468: ,p_hook_type => 'AD'
469: );
470: end;
471: -- End of API User Hook for post_delete.