eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_ENRT_PERD

Line 16927: -- and tr.where_clause = l_BEN_ENRT_PERD

16923: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16924: pqh_table_route tr
16925: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16926: and cpe.table_route_id = tr.table_route_id
16927: -- and tr.where_clause = l_BEN_ENRT_PERD
16928: and tr.table_alias = l_table_alias
16929: and cpe.number_of_copies = 1 -- ADDITION
16930: group by cpe.information1,cpe.information2,
16931: cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode

Line 16964: from BEN_ENRT_PERD ENP

16960: c_business_group_id number,
16961: c_new_pk_id number) is
16962: select
16963: ENP.enrt_perd_id new_value
16964: from BEN_ENRT_PERD ENP
16965: where
16966: ENP.POPL_ENRT_TYP_CYCL_ID = l_POPL_ENRT_TYP_CYCL_ID and
16967: nvl(ENP.LER_ID,-999) = nvl(l_LER_ID,-999) and
16968: nvl(ENP.YR_PERD_ID,-999) = nvl(l_YR_PERD_ID,-999) and

Line 17149: hr_utility.set_location(' BEN_ENRT_PERD CREATE_ENROLLMENT_PERIOD ',20);

17145: end if;
17146: --
17147: if l_first_rec and not l_update then
17148: -- Call Create routine.
17149: hr_utility.set_location(' BEN_ENRT_PERD CREATE_ENROLLMENT_PERIOD ',20);
17150: BEN_ENROLLMENT_PERIOD_API.CREATE_ENROLLMENT_PERIOD(
17151: --
17152: P_VALIDATE => false
17153: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)

Line 17910: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F

17906: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17907: pqh_table_route tr
17908: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17909: and cpe.table_route_id = tr.table_route_id
17910: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F
17911: and tr.table_alias = l_table_alias
17912: and cpe.number_of_copies = 1 -- ADDITION
17913: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
17914: order by information1, information2; --added for bug: 5151945

Line 17949: from BEN_ENRT_PERD_FOR_PL_F ERP

17945: c_business_group_id number,
17946: c_new_pk_id number) is
17947: select
17948: ERP.enrt_perd_for_pl_id new_value
17949: from BEN_ENRT_PERD_FOR_PL_F ERP
17950: where
17951: nvl(ERP.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID,-999) and
17952: nvl(ERP.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID,-999) and
17953: nvl(ERP.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 17963: from BEN_ENRT_PERD_FOR_PL_F ERP1

17959: --END TEMPIK
17960: /*TEMPIK
17961:
17962: and exists ( select null
17963: from BEN_ENRT_PERD_FOR_PL_F ERP1
17964: where
17965: nvl(ERP1.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID, -999) and
17966: nvl(ERP1.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID, -999) and
17967: nvl(ERP1.PL_ID,-999) = nvl(l_PL_ID, -999) and

Line 17971: from BEN_ENRT_PERD_FOR_PL_F ERP2

17967: nvl(ERP1.PL_ID,-999) = nvl(l_PL_ID, -999) and
17968: ERP1.business_group_id = c_business_group_id
17969: and ERP1.effective_start_date <= c_effective_start_date )
17970: and exists ( select null
17971: from BEN_ENRT_PERD_FOR_PL_F ERP2
17972: where
17973: nvl(ERP2.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID, -999) and
17974: nvl(ERP2.LEE_RSN_ID,-999) = nvl(l_LEE_RSN_ID, -999) and
17975: nvl(ERP2.PL_ID,-999) = nvl(l_PL_ID, -999) and

Line 18124: (p_base_table_name => 'BEN_ENRT_PERD_FOR_PL_F',

18120: if c_find_ERP_in_target%found then
18121: --
18122: --TEMPIK
18123: l_dt_rec_found := dt_api.check_min_max_dates
18124: (p_base_table_name => 'BEN_ENRT_PERD_FOR_PL_F',
18125: p_base_key_column => 'ENRT_PERD_FOR_PL_ID',
18126: p_base_key_value => l_new_value,
18127: p_from_date => l_min_esd,
18128: p_to_date => l_max_eed );

Line 18183: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F CREATE_ENRT_PERD_FOR_PL ',20);

18179: end if;
18180:
18181: if l_first_rec and not l_update then
18182: -- Call Create routine.
18183: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F CREATE_ENRT_PERD_FOR_PL ',20);
18184: BEN_ENRT_PERD_FOR_PL_API.CREATE_ENRT_PERD_FOR_PL(
18185: --
18186: P_VALIDATE => false
18187: ,P_EFFECTIVE_DATE => l_effective_date

Line 18184: BEN_ENRT_PERD_FOR_PL_API.CREATE_ENRT_PERD_FOR_PL(

18180:
18181: if l_first_rec and not l_update then
18182: -- Call Create routine.
18183: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F CREATE_ENRT_PERD_FOR_PL ',20);
18184: BEN_ENRT_PERD_FOR_PL_API.CREATE_ENRT_PERD_FOR_PL(
18185: --
18186: P_VALIDATE => false
18187: ,P_EFFECTIVE_DATE => l_effective_date
18188: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 18257: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F UPDATE_ENRT_PERD_FOR_PL ',30);

18253: else
18254: --
18255: -- Call Update routine for the pk_id created in prev run .
18256: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
18257: hr_utility.set_location(' BEN_ENRT_PERD_FOR_PL_F UPDATE_ENRT_PERD_FOR_PL ',30);
18258: --UPD START
18259: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
18260: --
18261: if l_update then

Line 18283: BEN_ENRT_PERD_FOR_PL_API.UPDATE_ENRT_PERD_FOR_PL(

18279: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
18280: --
18281: IF l_update OR l_dml_operation <> 'UPDATE' THEN
18282: --UPD END
18283: BEN_ENRT_PERD_FOR_PL_API.UPDATE_ENRT_PERD_FOR_PL(
18284: --
18285: P_VALIDATE => false
18286: ,P_EFFECTIVE_DATE => l_effective_date
18287: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 18348: BEN_ENRT_PERD_FOR_PL_API.delete_ENRT_PERD_FOR_PL(

18344: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
18345: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
18346: trunc(l_max_eed) = r_ERP.information3) then
18347: --
18348: BEN_ENRT_PERD_FOR_PL_API.delete_ENRT_PERD_FOR_PL(
18349: --
18350: p_validate => false
18351: ,p_enrt_perd_for_pl_id => l_enrt_perd_for_pl_id
18352: ,p_effective_start_date => l_effective_start_date