[Home] [Help]
4054: from ben_copy_entity_results cpe,
4055: pqh_table_route tr
4056: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4057: and cpe.table_route_id = tr.table_route_id
4058: -- and tr.where_clause = l_BEN_ACTL_PREM_F
4059: and tr.table_alias = l_table_alias
4060: and cpe.number_of_copies = 1 -- ADDITION
4061: group by cpe.information1,cpe.information2,cpe.information3, cpe.information170, cpe.table_route_id ,cpe.dml_operation,cpe.datetrack_mode
4062: order by information1, information2; --added for bug: 5151945
4092: c_business_group_id number,
4093: c_new_pk_id number) is
4094: select
4095: APR.actl_prem_id new_value
4096: from BEN_ACTL_PREM_F APR
4097: where
4098: APR.name = c_APR_name and
4099: nvl(APR.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
4100: nvl(APR.PL_ID,-999) = nvl(l_PL_ID,-999) and
4105: and effective_end_date ;
4106: --END TEMPIK
4107: /*TEMPIK
4108: and exists ( select null
4109: from BEN_ACTL_PREM_F APR1
4110: where
4111: APR1.name = c_APR_name and
4112: nvl(APR1.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
4113: nvl(APR1.PL_ID,-999) = nvl(l_PL_ID,-999) and
4113: nvl(APR1.PL_ID,-999) = nvl(l_PL_ID,-999) and
4114: APR1.business_group_id = c_business_group_id
4115: and APR1.effective_start_date <= c_effective_start_date )
4116: and exists ( select null
4117: from BEN_ACTL_PREM_F APR2
4118: where
4119: APR2.name = c_APR_name and
4120: nvl(APR2.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
4121: nvl(APR2.PL_ID,-999) = nvl(l_PL_ID,-999) and
4133: c_business_group_id number,
4134: c_new_pk_id number) is
4135: select
4136: APR.actl_prem_id new_value
4137: from BEN_ACTL_PREM_F APR
4138: where
4139: APR.name = c_APR_name and
4140: APR.business_group_id = c_business_group_id
4141: and APR.actl_prem_id <> c_new_pk_id
4144: and effective_end_date ;
4145: --END TEMPIK
4146: /*TEMPIK
4147: and exists ( select null
4148: from BEN_ACTL_PREM_F APR1
4149: where
4150: APR1.name = c_APR_name and
4151: APR1.business_group_id = c_business_group_id
4152: and APR1.effective_start_date <= c_effective_start_date )
4150: APR1.name = c_APR_name and
4151: APR1.business_group_id = c_business_group_id
4152: and APR1.effective_start_date <= c_effective_start_date )
4153: and exists ( select null
4154: from BEN_ACTL_PREM_F APR2
4155: where
4156: APR2.name = c_APR_name and
4157: APR2.business_group_id = c_business_group_id
4158: and APR2.effective_end_date >= c_effective_end_date )
4305: fetch c_find_APR_in_target into l_new_value ;
4306: if c_find_APR_in_target%found then
4307: --TEMPIK
4308: l_dt_rec_found := dt_api.check_min_max_dates
4309: (p_base_table_name => 'BEN_ACTL_PREM_F',
4310: p_base_key_column => 'ACTL_PREM_ID',
4311: p_base_key_value => l_new_value,
4312: p_from_date => l_min_esd,
4313: p_to_date => l_max_eed );
4344: if c_find_APR_name_in_target%found then
4345: --
4346: --TEMPIK
4347: l_dt_rec_found := dt_api.check_min_max_dates
4348: (p_base_table_name => 'BEN_ACTL_PREM_F',
4349: p_base_key_column => 'ACTL_PREM_ID',
4350: p_base_key_value => l_new_value,
4351: p_from_date => l_min_esd,
4352: p_to_date => l_max_eed );
4396: l_first_rec := true ;
4397: --
4398: end if ;
4399: --
4400: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_ACTL_PREM_F',l_prefix || r_APR.information170 || l_suffix);
4401: --
4402:
4403: l_effective_date := r_APR.information2;
4404: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and
4409: --if l_first_rec then
4410: if l_first_rec and not l_update then
4411: -- UPD END
4412: -- Call Create routine.
4413: hr_utility.set_location(' BEN_ACTL_PREM_F CREATE_ACTUAL_PREMIUM ',20);
4414: BEN_ACTUAL_PREMIUM_API.CREATE_ACTUAL_PREMIUM(
4415: --
4416: P_VALIDATE => false
4417: ,P_EFFECTIVE_DATE => l_effective_date
4505: else
4506: --
4507: -- Call Update routine for the pk_id created in prev run .
4508: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
4509: hr_utility.set_location(' BEN_ACTL_PREM_F UPDATE_ACTUAL_PREMIUM ',30);
4510:
4511: --UPD START
4512: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
4513: --