[Home] [Help]
12052: from ben_copy_entity_results cpe,
12053: pqh_table_route tr
12054: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12055: and cpe.table_route_id = tr.table_route_id
12056: -- and tr.where_clause = l_BEN_BENFTS_GRP
12057: and tr.table_alias = l_table_alias
12058: and cpe.number_of_copies = 1 --ADDITION
12059: group by cpe.information1,cpe.information2,cpe.information3,
12060: cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12089: c_business_group_id number,
12090: c_new_pk_id number) is
12091: select
12092: BNG.benfts_grp_id new_value
12093: from BEN_BENFTS_GRP BNG
12094: where BNG.name = c_BNG_name
12095: and BNG.business_group_id = c_business_group_id
12096: and BNG.benfts_grp_id <> c_new_pk_id
12097: ;
12225: l_first_rec := true ;
12226: --
12227: end if ;
12228: --
12229: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_BENFTS_GRP',l_prefix || r_BNG.INFORMATION170 || l_suffix);
12230: --
12231: if l_first_rec and not l_update then
12232: -- Call Create routine.
12233: hr_utility.set_location(' BEN_BENFTS_GRP CREATE_BENEFITS_GROUP ',20);
12229: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_BENFTS_GRP',l_prefix || r_BNG.INFORMATION170 || l_suffix);
12230: --
12231: if l_first_rec and not l_update then
12232: -- Call Create routine.
12233: hr_utility.set_location(' BEN_BENFTS_GRP CREATE_BENEFITS_GROUP ',20);
12234: BEN_BENEFITS_GROUP_API.CREATE_BENEFITS_GROUP(
12235: --
12236: P_VALIDATE => false
12237: -- ,P_EFFECTIVE_DATE => p_effective_date
12292: log_data('BNG',l_new_value,l_prefix || r_BNG.INFORMATION170 || l_suffix,'COPIED');
12293: --
12294: elsif l_update then
12295:
12296: hr_utility.set_location(' BEN_BENFTS_GRP UPDATE_BENEFITS_GROUP ',20);
12297: BEN_BENEFITS_GROUP_API.UPDATE_BENEFITS_GROUP(
12298: --
12299: P_VALIDATE => false
12300: -- ,P_EFFECTIVE_DATE => p_effective_date