[Home] [Help]
11723: from ben_copy_entity_results cpe,
11724: pqh_table_route tr
11725: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11726: and cpe.table_route_id = tr.table_route_id
11727: -- and tr.where_clause = l_BEN_GD_OR_SVC_TYP
11728: and tr.table_alias = l_table_alias
11729: and cpe.number_of_copies = 1 --ADDITION
11730: group by cpe.information1,cpe.information2,cpe.information3,
11731: cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11760: c_business_group_id number,
11761: c_new_pk_id number) is
11762: select
11763: GOS.gd_or_svc_typ_id new_value
11764: from BEN_GD_OR_SVC_TYP GOS
11765: where GOS.name = c_GOS_name
11766: and GOS.business_group_id = c_business_group_id
11767: and GOS.gd_or_svc_typ_id <> c_new_pk_id
11768: ;
11900: l_first_rec := true ;
11901: --
11902: end if ;
11903: --
11904: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_GD_OR_SVC_TYP',l_prefix || r_GOS.INFORMATION170 || l_suffix);
11905: --
11906: if l_first_rec and not l_update then
11907: -- Call Create routine.
11908: hr_utility.set_location(' BEN_GD_OR_SVC_TYP CREATE_GOOD_SVC_TYPE ',20);
11904: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_GD_OR_SVC_TYP',l_prefix || r_GOS.INFORMATION170 || l_suffix);
11905: --
11906: if l_first_rec and not l_update then
11907: -- Call Create routine.
11908: hr_utility.set_location(' BEN_GD_OR_SVC_TYP CREATE_GOOD_SVC_TYPE ',20);
11909: BEN_GOOD_SVC_TYPE_API.CREATE_GOOD_SVC_TYPE(
11910: --
11911: P_VALIDATE => false
11912: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)
11968: log_data('GOS',l_new_value,l_prefix || r_GOS.INFORMATION170 || l_suffix,'COPIED');
11969: --
11970: elsif l_update then
11971: --
11972: hr_utility.set_location(' BEN_GD_OR_SVC_TYP UPDATE_GOOD_SVC_TYPE ',20);
11973: BEN_GOOD_SVC_TYPE_API.UPDATE_GOOD_SVC_TYPE(
11974: --
11975: P_VALIDATE => false
11976: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)