[Home] [Help]
744: --
745: l_ELIGY_PRFL_ID number;
746: l_PYMT_MUST_BE_RCVD_RL number;
747: -- IK
748: l_PYMT_MUST_BE_RCVD_NUM BEN_CNTNG_PRTN_ELIG_PRFL_F.PYMT_MUST_BE_RCVD_NUM%type;
749: l_PYMT_MUST_BE_RCVD_UOM BEN_CNTNG_PRTN_ELIG_PRFL_F.PYMT_MUST_BE_RCVD_UOM%type;
750: -- IK
751: cursor c_unique_CGP(l_table_alias varchar2) is
752: select distinct cpe.information1,
745: l_ELIGY_PRFL_ID number;
746: l_PYMT_MUST_BE_RCVD_RL number;
747: -- IK
748: l_PYMT_MUST_BE_RCVD_NUM BEN_CNTNG_PRTN_ELIG_PRFL_F.PYMT_MUST_BE_RCVD_NUM%type;
749: l_PYMT_MUST_BE_RCVD_UOM BEN_CNTNG_PRTN_ELIG_PRFL_F.PYMT_MUST_BE_RCVD_UOM%type;
750: -- IK
751: cursor c_unique_CGP(l_table_alias varchar2) is
752: select distinct cpe.information1,
753: cpe.information2,
757: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
758: pqh_table_route tr
759: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
760: and cpe.table_route_id = tr.table_route_id
761: -- and tr.where_clause = l_BEN_CNTNG_PRTN_ELIG_PRFL_F
762: and tr.table_alias = l_table_alias
763: and cpe.number_of_copies = 1 -- ADDITION
764: group by cpe.information1,cpe.information2,cpe.information3, cpe.information170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
765: order by information1, information2; --added for bug: 5151945
795: c_business_group_id number,
796: c_new_pk_id number) is
797: select
798: CGP.cntng_prtn_elig_prfl_id new_value
799: from BEN_CNTNG_PRTN_ELIG_PRFL_F CGP
800: where
801: CGP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
802: -- IK
803: nvl(CGP.PYMT_MUST_BE_RCVD_RL,-999) = nvl(l_PYMT_MUST_BE_RCVD_RL,-999) and
811: and effective_end_date ;
812: --END TEMPIK
813: /*TEMPIK
814: and exists ( select null
815: from BEN_CNTNG_PRTN_ELIG_PRFL_F CGP1
816: where
817: CGP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
818: -- IK
819: nvl(CGP1.PYMT_MUST_BE_RCVD_RL,-999) = nvl(l_PYMT_MUST_BE_RCVD_RL,-999) and
822: -- IK
823: CGP1.business_group_id = c_business_group_id
824: and CGP1.effective_start_date <= c_effective_start_date )
825: and exists ( select null
826: from BEN_CNTNG_PRTN_ELIG_PRFL_F CGP2
827: where
828: CGP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
829: -- IK
830: nvl(CGP2.PYMT_MUST_BE_RCVD_RL,-999) = nvl(l_PYMT_MUST_BE_RCVD_RL,-999) and
984: if c_find_CGP_in_target%found then
985: --
986: --TEMPIK
987: l_dt_rec_found := dt_api.check_min_max_dates
988: (p_base_table_name => 'BEN_CNTNG_PRTN_ELIG_PRFL_F',
989: p_base_key_column => 'CNTNG_PRTN_ELIG_PRFL_ID',
990: p_base_key_value => l_new_value,
991: p_from_date => l_min_esd,
992: p_to_date => l_max_eed );
1035: l_first_rec := true ;
1036: --
1037: end if ;
1038: --
1039: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CNTNG_PRTN_ELIG_PRFL_F',l_prefix || r_CGP.information170 || l_suffix);
1040: --
1041:
1042: l_effective_date := r_CGP.information2;
1043: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and
1046: end if;
1047:
1048: if l_first_rec and not l_update then
1049: -- Call Create routine.
1050: hr_utility.set_location(' BEN_CNTNG_PRTN_ELIG_PRFL_F CREATE_CNTNG_PRTN_ELIG_PRFL ',20);
1051: BEN_CNTNG_PRTN_ELIG_PRFL_API.CREATE_CNTNG_PRTN_ELIG_PRFL(
1052: --
1053: P_VALIDATE => false
1054: ,P_EFFECTIVE_DATE => l_effective_date
1119: else
1120: --
1121: -- Call Update routine for the pk_id created in prev run .
1122: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
1123: hr_utility.set_location(' BEN_CNTNG_PRTN_ELIG_PRFL_F UPDATE_CNTNG_PRTN_ELIG_PRFL ',30);
1124: --UPD START
1125: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
1126: --
1127: if l_update then