[Home] [Help]
4793: from ben_copy_entity_results cpe,
4794: pqh_table_route tr
4795: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4796: and cpe.table_route_id = tr.table_route_id
4797: -- and tr.where_clause = l_BEN_AGE_FCTR
4798: and tr.table_alias = l_table_alias
4799: and cpe.number_of_copies = 1 --ADDITION
4800: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
4801: order by information1, information2; --added for bug: 5151945
4829: c_business_group_id number,
4830: c_new_pk_id number) is
4831: select
4832: AGF.age_fctr_id new_value
4833: from BEN_AGE_FCTR AGF
4834: where AGF.name = c_AGF_name
4835: and AGF.business_group_id = c_business_group_id
4836: and AGF.age_fctr_id <> c_new_pk_id
4837: ;
4988: l_AGE_CALC_RL := get_fk('FORMULA_ID', r_AGF.INFORMATION262,l_dml_operation);
4989: l_AGE_DET_RL := get_fk('FORMULA_ID', r_AGF.INFORMATION261,l_dml_operation);
4990: l_RNDG_RL := get_fk('FORMULA_ID', r_AGF.INFORMATION257,l_dml_operation);
4991: --
4992: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_AGE_FCTR' ,l_prefix || r_AGF.INFORMATION170 || l_suffix);
4993: --
4994: if l_first_rec and not l_update then
4995: -- Call Create routine.
4996: hr_utility.set_location(' BEN_AGE_FCTR CREATE_AGE_FACTOR ',20);
4992: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_AGE_FCTR' ,l_prefix || r_AGF.INFORMATION170 || l_suffix);
4993: --
4994: if l_first_rec and not l_update then
4995: -- Call Create routine.
4996: hr_utility.set_location(' BEN_AGE_FCTR CREATE_AGE_FACTOR ',20);
4997: BEN_AGE_FACTOR_API.CREATE_AGE_FACTOR(
4998: --
4999: P_VALIDATE => false
5000: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)
5065: log_data('AGF',l_new_value,l_prefix || r_AGF.INFORMATION170 || l_suffix,'COPIED');
5066: --
5067: elsif l_update then
5068:
5069: hr_utility.set_location(' BEN_AGE_FCTR UPDATE_AGE_FACTOR ',20);
5070: BEN_AGE_FACTOR_API.UPDATE_AGE_FACTOR(
5071: --
5072: P_VALIDATE => false
5073: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)