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 912: dt_api.find_dt_upd_modes

908: open c_pep(l_rec.BKUP_TBL_ID,l_effective_date);
909: fetch c_pep INTO l_rec.object_version_number;
910: IF c_pep%FOUND THEN
911: --Get the Datetrack Mode
912: dt_api.find_dt_upd_modes
913: (p_effective_date => l_effective_date,
914: p_base_table_name => 'BEN_ELIG_PER_F',
915: p_base_key_column => 'elig_per_id',
916: p_base_key_value => l_rec.BKUP_TBL_ID,

Line 1140: dt_api.find_dt_upd_modes

1136: open c_pcs(l_rec.BKUP_TBL_ID,l_effective_date);
1137: fetch c_pcs INTO l_rec.object_version_number;
1138: IF c_pcs%FOUND THEN
1139: --Get the Datetrack Mode
1140: dt_api.find_dt_upd_modes
1141: (p_effective_date => l_effective_date,
1142: p_base_table_name => 'BEN_PRTT_ENRT_CTFN_PRVDD_F',
1143: p_base_key_column => 'PRTT_ENRT_CTFN_PRVDD_ID',
1144: p_base_key_value => l_rec.BKUP_TBL_ID,

Line 1284: dt_api.find_dt_upd_modes

1280: fetch c_epo INTO l_rec.object_version_number;
1281: IF c_epo%FOUND THEN
1282: --
1283: --Get the Datetrack Mode
1284: dt_api.find_dt_upd_modes
1285: (p_effective_date => l_effective_date,
1286: p_base_table_name => 'BEN_ELIG_PER_OPT_F',
1287: p_base_key_column => 'elig_per_opt_id',
1288: p_base_key_value => l_rec.BKUP_TBL_ID,

Line 5774: dt_api.get_object_version_number

5770: --
5771: -- Get the object version number for the update
5772: --
5773: l_ecr.object_version_number :=
5774: dt_api.get_object_version_number
5775: (p_base_table_name => 'ben_enrt_rt',
5776: p_base_key_column => 'enrt_rt_id',
5777: p_base_key_value => l_ecr.enrt_rt_id)-1;
5778: