[Home] [Help]
13482: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13483: pqh_table_route tr
13484: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13485: and cpe.table_route_id = tr.table_route_id
13486: -- and tr.where_clause = l_BEN_POPL_ORG_F
13487: and tr.table_alias = l_table_alias
13488: and cpe.number_of_copies = 1 -- ADDITION
13489: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13490: order by information1, information2; --added for bug: 5151945
13520: c_business_group_id number,
13521: c_new_pk_id number) is
13522: select
13523: CPO.popl_org_id new_value
13524: from BEN_POPL_ORG_F CPO
13525: where
13526: CPO.ORGANIZATION_ID = l_ORGANIZATION_ID and
13527: nvl(CPO.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
13528: nvl(CPO.PL_ID,-999) = nvl(l_PL_ID,-999) and
13533: and effective_end_date ;
13534: --END TEMPIK
13535: /*TEMPIK
13536: and exists ( select null
13537: from BEN_POPL_ORG_F CPO1
13538: where
13539: CPO1.ORGANIZATION_ID = l_ORGANIZATION_ID and
13540: nvl(CPO1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
13541: nvl(CPO1.PL_ID,-999) = nvl(l_PL_ID,-999) and
13541: nvl(CPO1.PL_ID,-999) = nvl(l_PL_ID,-999) and
13542: CPO1.business_group_id = c_business_group_id
13543: and CPO1.effective_start_date <= c_effective_start_date )
13544: and exists ( select null
13545: from BEN_POPL_ORG_F CPO2
13546: where
13547: CPO2.ORGANIZATION_ID = l_ORGANIZATION_ID and
13548: nvl(CPO2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
13549: nvl(CPO2.PL_ID,-999) = nvl(l_PL_ID,-999) and
13724: if c_find_CPO_in_target%found then
13725: --
13726: --TEMPIK
13727: l_dt_rec_found := dt_api.check_min_max_dates
13728: (p_base_table_name => 'BEN_POPL_ORG_F',
13729: p_base_key_column => 'POPL_ORG_ID',
13730: p_base_key_value => l_new_value,
13731: p_from_date => l_min_esd,
13732: p_to_date => l_max_eed );
13783: end if;
13784:
13785: if l_first_rec and not l_update then
13786: -- Call Create routine.
13787: hr_utility.set_location(' BEN_POPL_ORG_F CREATE_POPL_ORG ',20);
13788: BEN_POPL_ORG_API.CREATE_POPL_ORG(
13789: --
13790: P_VALIDATE => false
13791: ,P_EFFECTIVE_DATE => l_effective_date
13852: else
13853: --
13854: -- Call Update routine for the pk_id created in prev run .
13855: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
13856: hr_utility.set_location(' BEN_POPL_ORG_F UPDATE_POPL_ORG ',30);
13857: --UPD START
13858: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
13859: --
13860: if l_update then
22888: PCP.business_group_id = c_business_group_id
22889: and PCP.pl_pcp_id <> c_new_pk_id
22890: ;
22891:
22892: --cursor to check the row exist in the ben_popl_org_f table.
22893: cursor c_exists_in_popl_org(c_pl_id in number) is
22894: select 'x'
22895: from ben_popl_org_f
22896: Where pl_id = c_pl_id;
22891:
22892: --cursor to check the row exist in the ben_popl_org_f table.
22893: cursor c_exists_in_popl_org(c_pl_id in number) is
22894: select 'x'
22895: from ben_popl_org_f
22896: Where pl_id = c_pl_id;
22897: --
22898: l_dummy varchar2(1);
22899: --
22968: l_PL_ID := get_fk('PL_ID', r_PCP.INFORMATION261,l_dml_operation);
22969: --
22970:
22971: -- If PCP_RPSTRY_FLAG (From Repository flag ) = 'Y' then
22972: -- Check if a row exists in the ben_popl_org_f table for the Plan
22973: -- If no row found then set PCP_RPSTRY_FLAG to 'N'
22974: -- Also set Radius, Radius Warning and Radius UOM to null as
22975: -- these cannot have a value if the Repository flag is not selected
22976: