DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_RPTG_GRP

Line 8208: -- and tr.where_clause = l_BEN_RPTG_GRP

8204: from ben_copy_entity_results cpe,
8205: pqh_table_route tr
8206: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8207: and cpe.table_route_id = tr.table_route_id
8208: -- and tr.where_clause = l_BEN_RPTG_GRP
8209: and tr.table_alias = l_table_alias
8210: and cpe.number_of_copies = 1 --ADDITION
8211: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8212: order by information1, information2; --added for bug: 5151945

Line 8244: from BEN_RPTG_GRP BNR

8240: c_business_group_id number,
8241: c_new_pk_id number) is
8242: select
8243: BNR.rptg_grp_id new_value
8244: from BEN_RPTG_GRP BNR
8245: where BNR.name = c_BNR_name
8246: and (BNR.business_group_id = c_business_group_id
8247: or BNR.business_group_id is null) -- Bug 2907912
8248: and BNR.rptg_grp_id <> c_new_pk_id

Line 8392: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_RPTG_GRP',l_prefix || r_BNR.INFORMATION170 || l_suffix);

8388: else
8389: l_business_group_id := p_target_business_group_id;
8390: end if;
8391: --
8392: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_RPTG_GRP',l_prefix || r_BNR.INFORMATION170 || l_suffix);
8393: --
8394: if l_first_rec and not l_update then
8395: -- Call Create routine.
8396: hr_utility.set_location(' BEN_RPTG_GRP CREATE_REPORTING_GROUP ',20);

Line 8396: hr_utility.set_location(' BEN_RPTG_GRP CREATE_REPORTING_GROUP ',20);

8392: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_RPTG_GRP',l_prefix || r_BNR.INFORMATION170 || l_suffix);
8393: --
8394: if l_first_rec and not l_update then
8395: -- Call Create routine.
8396: hr_utility.set_location(' BEN_RPTG_GRP CREATE_REPORTING_GROUP ',20);
8397: BEN_REPORTING_GROUP_API.CREATE_REPORTING_GROUP(
8398: --
8399: P_VALIDATE => false
8400: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 8461: hr_utility.set_location(' BEN_RPTG_GRP UPDATE_REPORTING_GROUP ',20);

8457: --
8458: log_data('BNR',l_new_value,l_prefix || r_BNR.INFORMATION170 || l_suffix ,'COPIED');
8459: --
8460: elsif l_update then
8461: hr_utility.set_location(' BEN_RPTG_GRP UPDATE_REPORTING_GROUP ',20);
8462: BEN_REPORTING_GROUP_API.UPDATE_REPORTING_GROUP(
8463: --
8464: P_VALIDATE => false
8465: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)