APPS.HR_ENTRY dependencies on BEN_COVERED_DEPENDENTS_PKG

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

4368: if dependant.effective_start_date >= p_validation_start_date then
4369: --
4370: -- If the dependant starts after the entry deletion date then delete it
4371: --
4372: ben_covered_dependents_pkg.delete_row (dependant.rowid);
4373: --
4374: else
4375: --
4376: -- The dependant must overlap the entry deletion date so update it to

Line 4385: ben_covered_dependents_pkg.update_row (

4381:
4382: v_start_date := NVL(p_start_date,dependant.effective_start_date);
4383: v_end_date := NVL(p_end_date,dependant.effective_end_date);
4384:
4385: ben_covered_dependents_pkg.update_row (
4386: --
4387: p_covered_dependent_id => dependant.covered_dependent_id,
4388: p_rowid => dependant.rowid,
4389: p_contact_relationship_id => dependant.contact_relationship_id,

Line 4582: ben_covered_dependents_pkg.update_row (

4578: -- which end on the same date as the entry.
4579: --
4580: for dependant in csr_dependants LOOP
4581: --
4582: ben_covered_dependents_pkg.update_row (
4583: --
4584: p_covered_dependent_id => dependant.covered_dependent_id,
4585: p_rowid => dependant.rowid,
4586: p_contact_relationship_id=> dependant.contact_relationship_id,

Line 6421: ben_covered_dependents_pkg.update_row (

6417: v_start_date := dependant.effective_start_date;
6418: v_end_date := p_element_entry_EED;
6419:
6420:
6421: ben_covered_dependents_pkg.update_row (
6422: --
6423: p_covered_dependent_id => dependant.covered_dependent_id,
6424: p_rowid => dependant.rowid,
6425: p_contact_relationship_id => dependant.contact_relationship_id,

Line 6443: ben_covered_dependents_pkg.insert_row (

6439:
6440: if ( (p_new_element_entry_id is NOT NULL) and (p_new_element_entry_ESD is NOT NULL)
6441: and (p_new_element_entry_EED is NOT NULL) ) then
6442:
6443: ben_covered_dependents_pkg.insert_row (
6444: --
6445: p_covered_dependent_id => l_covered_dependent_id,
6446: p_rowid => l_rowid,
6447: p_contact_relationship_id => dependant.contact_relationship_id,