APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on DT_API

Line 121: dt_api.object... function used to get

117: passed as bkup_tbl_id
118: 14-Nov-99 pbodla 115.29 When prv data is backed out, write
119: ecr data to backup table to restore
120: the ecr data when bchdt row is reinstated.
121: dt_api.object... function used to get
122: the latest object version number.
123: 29-Nov-99 jcarpent 115.30 - Added person_id to call to update_prv
124: 15-Dec-99 maagrawa 115.31 - Function used to fetch the
125: object version number for prv

Line 751: dt_api.find_dt_upd_modes

747: open c_pep(l_rec.BKUP_TBL_ID,l_effective_date);
748: fetch c_pep INTO l_rec.object_version_number;
749: IF c_pep%FOUND THEN
750: --Get the Datetrack Mode
751: dt_api.find_dt_upd_modes
752: (p_effective_date => l_effective_date,
753: p_base_table_name => 'BEN_ELIG_PER_F',
754: p_base_key_column => 'elig_per_id',
755: p_base_key_value => l_rec.BKUP_TBL_ID,

Line 898: dt_api.find_dt_upd_modes

894: open c_pcs(l_rec.BKUP_TBL_ID,l_effective_date);
895: fetch c_pcs INTO l_rec.object_version_number;
896: IF c_pcs%FOUND THEN
897: --Get the Datetrack Mode
898: dt_api.find_dt_upd_modes
899: (p_effective_date => l_effective_date,
900: p_base_table_name => 'BEN_PRTT_ENRT_CTFN_PRVDD_F',
901: p_base_key_column => 'PRTT_ENRT_CTFN_PRVDD_ID',
902: p_base_key_value => l_rec.BKUP_TBL_ID,

Line 1035: dt_api.find_dt_upd_modes

1031: fetch c_epo INTO l_rec.object_version_number;
1032: IF c_epo%FOUND THEN
1033: --
1034: --Get the Datetrack Mode
1035: dt_api.find_dt_upd_modes
1036: (p_effective_date => l_effective_date,
1037: p_base_table_name => 'BEN_ELIG_PER_OPT_F',
1038: p_base_key_column => 'elig_per_opt_id',
1039: p_base_key_value => l_rec.BKUP_TBL_ID,

Line 5292: dt_api.get_object_version_number

5288: --
5289: -- Get the object version number for the update
5290: --
5291: l_ecr.object_version_number :=
5292: dt_api.get_object_version_number
5293: (p_base_table_name => 'ben_enrt_rt',
5294: p_base_key_column => 'enrt_rt_id',
5295: p_base_key_value => l_ecr.enrt_rt_id)-1;
5296: