DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on BEN_COVERED_DEPENDENTS_PKG

Line 3996: ben_covered_dependents_pkg.delete_row (dependant.rowid);

3992: if dependant.effective_start_date >= p_validation_start_date then
3993: --
3994: -- If the dependant starts after the entry deletion date then delete it
3995: --
3996: ben_covered_dependents_pkg.delete_row (dependant.rowid);
3997: --
3998: else
3999: --
4000: -- The dependant must overlap the entry deletion date so update it to

Line 4009: ben_covered_dependents_pkg.update_row (

4005:
4006: v_start_date := NVL(p_start_date,dependant.effective_start_date);
4007: v_end_date := NVL(p_end_date,dependant.effective_end_date);
4008:
4009: ben_covered_dependents_pkg.update_row (
4010: --
4011: p_covered_dependent_id => dependant.covered_dependent_id,
4012: p_rowid => dependant.rowid,
4013: p_contact_relationship_id => dependant.contact_relationship_id,

Line 4206: ben_covered_dependents_pkg.update_row (

4202: -- which end on the same date as the entry.
4203: --
4204: for dependant in csr_dependants LOOP
4205: --
4206: ben_covered_dependents_pkg.update_row (
4207: --
4208: p_covered_dependent_id => dependant.covered_dependent_id,
4209: p_rowid => dependant.rowid,
4210: p_contact_relationship_id=> dependant.contact_relationship_id,