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.PQH_GSP_STAGE_TO_BEN dependencies on BEN_PD_COPY_TO_BEN_ONE

Line 3916: BEN_PD_COPY_TO_BEN_ONE.g_mapping_done := false ;

3912: and cer.dml_operation = 'DELETE'
3913: and table_alias in ('CPP','CEP','EPA','COP','OPT','ABR');
3914:
3915: -- Set for same Business Group
3916: BEN_PD_COPY_TO_BEN_ONE.g_mapping_done := false ;
3917:
3918: -- Copied the following 4 calls from ben_plan_design_copy_process.process
3919: -- Populate table_route_id in staging table
3920: ben_plan_design_wizard_api.write_route_and_hierarchy(p_copy_entity_txn_id);

Line 3935: ben_pd_copy_to_ben_one.init_table_data_in_cer(p_copy_entity_txn_id);

3931: and nvl(information3,p_effective_date)
3932: and cer.dml_operation = 'DELETE';
3933:
3934: -- Initialise
3935: ben_pd_copy_to_ben_one.init_table_data_in_cer(p_copy_entity_txn_id);
3936:
3937: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl.delete;
3938: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl(0) := null ;
3939: BEN_PD_COPY_TO_BEN_ONE.g_count := 1 ;

Line 3937: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl.delete;

3933:
3934: -- Initialise
3935: ben_pd_copy_to_ben_one.init_table_data_in_cer(p_copy_entity_txn_id);
3936:
3937: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl.delete;
3938: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl(0) := null ;
3939: BEN_PD_COPY_TO_BEN_ONE.g_count := 1 ;
3940:
3941: -- Create all derived factors first

Line 3938: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl(0) := null ;

3934: -- Initialise
3935: ben_pd_copy_to_ben_one.init_table_data_in_cer(p_copy_entity_txn_id);
3936:
3937: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl.delete;
3938: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl(0) := null ;
3939: BEN_PD_COPY_TO_BEN_ONE.g_count := 1 ;
3940:
3941: -- Create all derived factors first
3942:

Line 3939: BEN_PD_COPY_TO_BEN_ONE.g_count := 1 ;

3935: ben_pd_copy_to_ben_one.init_table_data_in_cer(p_copy_entity_txn_id);
3936:
3937: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl.delete;
3938: BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl(0) := null ;
3939: BEN_PD_COPY_TO_BEN_ONE.g_count := 1 ;
3940:
3941: -- Create all derived factors first
3942:
3943: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLF') then

Line 3943: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLF') then

3939: BEN_PD_COPY_TO_BEN_ONE.g_count := 1 ;
3940:
3941: -- Create all derived factors first
3942:
3943: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLF') then
3944: hr_utility.set_location(' Calling create CLF rows ',999);
3945: BEN_PD_COPY_TO_BEN_ONE.create_CLF_rows(
3946: p_copy_entity_txn_id => p_copy_entity_txn_id
3947: ,p_effective_date => p_effective_date

Line 3945: BEN_PD_COPY_TO_BEN_ONE.create_CLF_rows(

3941: -- Create all derived factors first
3942:
3943: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLF') then
3944: hr_utility.set_location(' Calling create CLF rows ',999);
3945: BEN_PD_COPY_TO_BEN_ONE.create_CLF_rows(
3946: p_copy_entity_txn_id => p_copy_entity_txn_id
3947: ,p_effective_date => p_effective_date
3948: ,p_reuse_object_flag => 'Y'
3949: ,p_target_business_group_id => p_business_group_id

Line 3953: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HWF') then

3949: ,p_target_business_group_id => p_business_group_id
3950: );
3951: end if;
3952: --
3953: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HWF') then
3954: hr_utility.set_location(' Calling create HWF rows ',999);
3955: BEN_PD_COPY_TO_BEN_ONE.create_HWF_rows(
3956: p_copy_entity_txn_id => p_copy_entity_txn_id
3957: ,p_effective_date => p_effective_date

Line 3955: BEN_PD_COPY_TO_BEN_ONE.create_HWF_rows(

3951: end if;
3952: --
3953: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HWF') then
3954: hr_utility.set_location(' Calling create HWF rows ',999);
3955: BEN_PD_COPY_TO_BEN_ONE.create_HWF_rows(
3956: p_copy_entity_txn_id => p_copy_entity_txn_id
3957: ,p_effective_date => p_effective_date
3958: ,p_reuse_object_flag => 'Y'
3959: ,p_target_business_group_id => p_business_group_id

Line 3963: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('AGF') then

3959: ,p_target_business_group_id => p_business_group_id
3960: );
3961: end if;
3962: --
3963: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('AGF') then
3964: hr_utility.set_location(' Calling create AGF rows ',999);
3965: BEN_PD_COPY_TO_BEN_ONE.create_AGF_rows(
3966: p_copy_entity_txn_id => p_copy_entity_txn_id
3967: ,p_effective_date => p_effective_date

Line 3965: BEN_PD_COPY_TO_BEN_ONE.create_AGF_rows(

3961: end if;
3962: --
3963: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('AGF') then
3964: hr_utility.set_location(' Calling create AGF rows ',999);
3965: BEN_PD_COPY_TO_BEN_ONE.create_AGF_rows(
3966: p_copy_entity_txn_id => p_copy_entity_txn_id
3967: ,p_effective_date => p_effective_date
3968: ,p_reuse_object_flag => 'Y'
3969: ,p_target_business_group_id => p_business_group_id

Line 3973: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LSF') then

3969: ,p_target_business_group_id => p_business_group_id
3970: );
3971: end if;
3972: --
3973: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LSF') then
3974: hr_utility.set_location(' Calling create LSF rows ',999);
3975: BEN_PD_COPY_TO_BEN_ONE.create_LSF_rows(
3976: p_copy_entity_txn_id => p_copy_entity_txn_id
3977: ,p_effective_date => p_effective_date

Line 3975: BEN_PD_COPY_TO_BEN_ONE.create_LSF_rows(

3971: end if;
3972: --
3973: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LSF') then
3974: hr_utility.set_location(' Calling create LSF rows ',999);
3975: BEN_PD_COPY_TO_BEN_ONE.create_LSF_rows(
3976: p_copy_entity_txn_id => p_copy_entity_txn_id
3977: ,p_effective_date => p_effective_date
3978: ,p_reuse_object_flag => 'Y'
3979: ,p_target_business_group_id => p_business_group_id

Line 3983: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PFF') then

3979: ,p_target_business_group_id => p_business_group_id
3980: );
3981: end if;
3982: --
3983: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PFF') then
3984: hr_utility.set_location(' Calling create PFF rows ',999);
3985: BEN_PD_COPY_TO_BEN_ONE.create_PFF_rows(
3986: p_copy_entity_txn_id => p_copy_entity_txn_id
3987: ,p_effective_date => p_effective_date

Line 3985: BEN_PD_COPY_TO_BEN_ONE.create_PFF_rows(

3981: end if;
3982: --
3983: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PFF') then
3984: hr_utility.set_location(' Calling create PFF rows ',999);
3985: BEN_PD_COPY_TO_BEN_ONE.create_PFF_rows(
3986: p_copy_entity_txn_id => p_copy_entity_txn_id
3987: ,p_effective_date => p_effective_date
3988: ,p_reuse_object_flag => 'Y'
3989: ,p_target_business_group_id => p_business_group_id

Line 3993: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLA') then

3989: ,p_target_business_group_id => p_business_group_id
3990: );
3991: end if;
3992: --
3993: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLA') then
3994: hr_utility.set_location(' Calling create CLA rows ',999);
3995: BEN_PD_COPY_TO_BEN_ONE.create_CLA_rows(
3996: p_copy_entity_txn_id => p_copy_entity_txn_id
3997: ,p_effective_date => p_effective_date

Line 3995: BEN_PD_COPY_TO_BEN_ONE.create_CLA_rows(

3991: end if;
3992: --
3993: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLA') then
3994: hr_utility.set_location(' Calling create CLA rows ',999);
3995: BEN_PD_COPY_TO_BEN_ONE.create_CLA_rows(
3996: p_copy_entity_txn_id => p_copy_entity_txn_id
3997: ,p_effective_date => p_effective_date
3998: ,p_reuse_object_flag => 'Y'
3999: ,p_target_business_group_id => p_business_group_id

Line 4007: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELP') then

4003: --
4004: -- Create ELP Row
4005: --
4006:
4007: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELP') then
4008: hr_utility.set_location(' Calling create ELP rows ',999);
4009: BEN_PD_COPY_TO_BEN_ONE.create_ELP_rows(
4010: p_copy_entity_txn_id => p_copy_entity_txn_id
4011: ,p_effective_date => p_effective_date

Line 4009: BEN_PD_COPY_TO_BEN_ONE.create_ELP_rows(

4005: --
4006:
4007: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELP') then
4008: hr_utility.set_location(' Calling create ELP rows ',999);
4009: BEN_PD_COPY_TO_BEN_ONE.create_ELP_rows(
4010: p_copy_entity_txn_id => p_copy_entity_txn_id
4011: ,p_effective_date => p_effective_date
4012: ,p_reuse_object_flag => 'Y'
4013: ,p_target_business_group_id => p_business_group_id