[Home] [Help]
12990: ,p_prefix_suffix_cd in varchar2 default null
12991: ) is
12992: --
12993: l_POPL_ORG_ID number;
12994: l_NAME BEN_POPL_ORG_ROLE_F.name%TYPE ;
12995: l_org_role_typ_cd BEN_POPL_ORG_ROLE_F.org_role_typ_cd%TYPE;
12996: --
12997: cursor c_unique_CPR(l_table_alias varchar2) is
12998: select distinct cpe.information1,
12991: ) is
12992: --
12993: l_POPL_ORG_ID number;
12994: l_NAME BEN_POPL_ORG_ROLE_F.name%TYPE ;
12995: l_org_role_typ_cd BEN_POPL_ORG_ROLE_F.org_role_typ_cd%TYPE;
12996: --
12997: cursor c_unique_CPR(l_table_alias varchar2) is
12998: select distinct cpe.information1,
12999: cpe.information2,
13002: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13003: pqh_table_route tr
13004: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13005: and cpe.table_route_id = tr.table_route_id
13006: -- and tr.where_clause = l_BEN_POPL_ORG_ROLE_F
13007: and tr.table_alias = l_table_alias
13008: and cpe.number_of_copies = 1 -- ADDITION
13009: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13010: order by information1, information2; --added for bug: 5151945
13040: c_business_group_id number,
13041: c_new_pk_id number) is
13042: select
13043: CPR.popl_org_role_id new_value
13044: from BEN_POPL_ORG_ROLE_F CPR
13045: where
13046: CPR.POPL_ORG_ID = l_POPL_ORG_ID and
13047: CPR.NAME = l_NAME and
13048: CPR.org_role_typ_cd= l_org_role_typ_cd and
13053: and effective_end_date ;
13054: --END TEMPIK
13055: /*TEMPIK
13056: and exists ( select null
13057: from BEN_POPL_ORG_ROLE_F CPR1
13058: where
13059: CPR1.POPL_ORG_ID = l_POPL_ORG_ID and
13060: CPR1.NAME = l_NAME and
13061: CPR1.org_role_typ_cd= l_org_role_typ_cd and
13061: CPR1.org_role_typ_cd= l_org_role_typ_cd and
13062: CPR1.business_group_id = c_business_group_id
13063: and CPR1.effective_start_date <= c_effective_start_date )
13064: and exists ( select null
13065: from BEN_POPL_ORG_ROLE_F CPR2
13066: where
13067: CPR2.POPL_ORG_ID = l_POPL_ORG_ID and
13068: CPR2.NAME = l_NAME and
13069: CPR2.org_role_typ_cd= l_org_role_typ_cd and
13213: if c_find_CPR_in_target%found then
13214: --
13215: --TEMPIK
13216: l_dt_rec_found := dt_api.check_min_max_dates
13217: (p_base_table_name => 'BEN_POPL_ORG_ROLE_F',
13218: p_base_key_column => 'POPL_ORG_ROLE_ID',
13219: p_base_key_value => l_new_value,
13220: p_from_date => l_min_esd,
13221: p_to_date => l_max_eed );
13263: l_first_rec := true ;
13264: --
13265: end if ;
13266: --
13267: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_POPL_ORG_ROLE_F',l_prefix || r_CPR.information170 || l_suffix);
13268: --
13269:
13270: l_effective_date := r_CPR.information2;
13271: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and
13274: end if;
13275:
13276: if l_first_rec and not l_update then
13277: -- Call Create routine.
13278: hr_utility.set_location(' BEN_POPL_ORG_ROLE_F CREATE_POPL_ORG_ROLE ',20);
13279: BEN_POPL_ORG_ROLE_API.CREATE_POPL_ORG_ROLE(
13280: --
13281: P_VALIDATE => false
13282: ,P_EFFECTIVE_DATE => l_effective_date
13340: else
13341: --
13342: -- Call Update routine for the pk_id created in prev run .
13343: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
13344: hr_utility.set_location(' BEN_POPL_ORG_ROLE_F UPDATE_POPL_ORG_ROLE ',30);
13345: --UPD START
13346: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
13347: --
13348: if l_update then