[Home] [Help]
4896: c_business_group_id number,
4897: c_new_pk_id number) is
4898: select
4899: EDG.elig_dpnt_cvrd_othr_pgm_id new_value
4900: from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F EDG
4901: where
4902: EDG.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
4903: EDG.PGM_ID = l_PGM_ID and
4904: EDG.ORDR_NUM = l_ORDR_NUM and
4908: and effective_end_date ;
4909: --END TEMPIK
4910: /*TEMPIK
4911: and exists ( select null
4912: from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F EDG1
4913: where
4914: EDG1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
4915: EDG1.PGM_ID = l_PGM_ID and
4916: EDG1.ORDR_NUM = l_ORDR_NUM and
4916: EDG1.ORDR_NUM = l_ORDR_NUM and
4917: EDG1.business_group_id = c_business_group_id
4918: and EDG1.effective_start_date <= c_effective_start_date )
4919: and exists ( select null
4920: from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F EDG2
4921: where
4922: EDG2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
4923: EDG2.PGM_ID = l_PGM_ID and
4924: EDG2.ORDR_NUM = l_ORDR_NUM and
5080: if c_find_EDG_in_target%found then
5081: --
5082: --TEMPIK
5083: l_dt_rec_found := dt_api.check_min_max_dates
5084: (p_base_table_name => 'BEN_ELIG_DPNT_CVRD_OTHR_PGM_F',
5085: p_base_key_column => 'ELIG_DPNT_CVRD_OTHR_PGM_ID',
5086: p_base_key_value => l_new_value,
5087: p_from_date => l_min_esd,
5088: p_to_date => l_max_eed );
5140: end if;
5141:
5142: if l_first_rec and not l_update then
5143: -- Call Create routine.
5144: hr_utility.set_location(' BEN_ELIG_DPNT_CVRD_OTHR_PGM_F CREATE_ELIG_DPNT_CVRD_O_PGM ',20);
5145: BEN_ELIG_DPNT_CVRD_O_PGM_API.CREATE_ELIG_DPNT_CVRD_O_PGM(
5146: --
5147: P_VALIDATE => false
5148: ,P_EFFECTIVE_DATE => l_effective_date
5213: else
5214: --
5215: -- Call Update routine for the pk_id created in prev run .
5216: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
5217: hr_utility.set_location(' BEN_ELIG_DPNT_CVRD_OTHR_PGM_F UPDATE_ELIG_DPNT_CVRD_O_PGM ',30);
5218: --UPD START
5219: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
5220: --
5221: if l_update then