eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BVR_UPD dependencies on BEN_BVR_SHD

Line 58: (p_rec in out nocopy ben_bvr_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_bvr_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is

Line 81: ben_bvr_shd.g_api_dml := true; -- Set the api dml status

77: (p_base_table_name => 'ben_bnft_vrbl_rt_f',
78: p_base_key_column => 'bnft_vrbl_rt_id',
79: p_base_key_value => p_rec.bnft_vrbl_rt_id);
80: --
81: ben_bvr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_bnft_vrbl_rt_f Row
84: --
85: update ben_bnft_vrbl_rt_f

Line 128: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status

124: where bnft_vrbl_rt_id = p_rec.bnft_vrbl_rt_id
125: and effective_start_date = p_validation_start_date
126: and effective_end_date = p_validation_end_date;
127: --
128: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: -- Set the effective start and end dates
131: --
132: p_rec.effective_start_date := p_validation_start_date;

Line 140: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status

136: hr_utility.set_location(' Leaving:'||l_proc, 15);
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status
141: ben_bvr_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated

Line 141: ben_bvr_shd.constraint_error

137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status
141: ben_bvr_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status

Line 145: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status

141: ben_bvr_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status
146: ben_bvr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status

Line 146: ben_bvr_shd.constraint_error

142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status
146: ben_bvr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;

Line 149: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status

145: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status
146: ben_bvr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_bvr_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
151: End dt_update_dml;
152: --
153: -- ----------------------------------------------------------------------------

Line 185: (p_rec in out nocopy ben_bvr_shd.g_rec_type,

181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure update_dml
185: (p_rec in out nocopy ben_bvr_shd.g_rec_type,
186: p_effective_date in date,
187: p_datetrack_mode in varchar2,
188: p_validation_start_date in date,
189: p_validation_end_date in date) is

Line 249: (p_rec in out nocopy ben_bvr_shd.g_rec_type,

245: --
246: -- {End Of Comments}
247: -- ----------------------------------------------------------------------------
248: Procedure dt_pre_update
249: (p_rec in out nocopy ben_bvr_shd.g_rec_type,
250: p_effective_date in date,
251: p_datetrack_mode in varchar2,
252: p_validation_start_date in date,
253: p_validation_end_date in date) is

Line 265: ben_bvr_shd.upd_effective_end_date

261: hr_utility.set_location(l_proc, 10);
262: --
263: -- Update the current effective end date
264: --
265: ben_bvr_shd.upd_effective_end_date
266: (p_effective_date => p_effective_date,
267: p_base_key_value => p_rec.bnft_vrbl_rt_id,
268: p_new_effective_end_date => (p_validation_start_date - 1),
269: p_validation_start_date => p_validation_start_date,

Line 334: (p_rec in out nocopy ben_bvr_shd.g_rec_type,

330: --
331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure pre_update
334: (p_rec in out nocopy ben_bvr_shd.g_rec_type,
335: p_effective_date in date,
336: p_datetrack_mode in varchar2,
337: p_validation_start_date in date,
338: p_validation_end_date in date) is

Line 390: (p_rec in ben_bvr_shd.g_rec_type,

386: --
387: -- {End Of Comments}
388: -- ----------------------------------------------------------------------------
389: Procedure post_update
390: (p_rec in ben_bvr_shd.g_rec_type,
391: p_effective_date in date,
392: p_datetrack_mode in varchar2,
393: p_validation_start_date in date,
394: p_validation_end_date in date) is

Line 451: ,p_effective_start_date_o =>ben_bvr_shd.g_old_rec.effective_start_date

447: ,p_effective_date =>p_effective_date
448: ,p_datetrack_mode =>p_datetrack_mode
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_bvr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_bvr_shd.g_old_rec.effective_end_date
453: ,p_cvg_amt_calc_mthd_id_o =>ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id
454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id
455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id

Line 452: ,p_effective_end_date_o =>ben_bvr_shd.g_old_rec.effective_end_date

448: ,p_datetrack_mode =>p_datetrack_mode
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_bvr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_bvr_shd.g_old_rec.effective_end_date
453: ,p_cvg_amt_calc_mthd_id_o =>ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id
454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id
455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id
456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category

Line 453: ,p_cvg_amt_calc_mthd_id_o =>ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id

449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_bvr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_bvr_shd.g_old_rec.effective_end_date
453: ,p_cvg_amt_calc_mthd_id_o =>ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id
454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id
455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id
456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category
457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1

Line 454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id

450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_bvr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_bvr_shd.g_old_rec.effective_end_date
453: ,p_cvg_amt_calc_mthd_id_o =>ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id
454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id
455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id
456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category
457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1
458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2

Line 455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id

451: ,p_effective_start_date_o =>ben_bvr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_bvr_shd.g_old_rec.effective_end_date
453: ,p_cvg_amt_calc_mthd_id_o =>ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id
454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id
455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id
456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category
457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1
458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2
459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3

Line 456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category

452: ,p_effective_end_date_o =>ben_bvr_shd.g_old_rec.effective_end_date
453: ,p_cvg_amt_calc_mthd_id_o =>ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id
454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id
455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id
456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category
457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1
458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2
459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3
460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4

Line 457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1

453: ,p_cvg_amt_calc_mthd_id_o =>ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id
454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id
455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id
456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category
457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1
458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2
459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3
460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4
461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5

Line 458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2

454: ,p_vrbl_rt_prfl_id_o =>ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id
455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id
456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category
457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1
458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2
459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3
460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4
461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5
462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6

Line 459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3

455: ,p_business_group_id_o =>ben_bvr_shd.g_old_rec.business_group_id
456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category
457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1
458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2
459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3
460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4
461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5
462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6
463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7

Line 460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4

456: ,p_bvr_attribute_category_o =>ben_bvr_shd.g_old_rec.bvr_attribute_category
457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1
458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2
459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3
460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4
461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5
462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6
463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7
464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8

Line 461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5

457: ,p_bvr_attribute1_o =>ben_bvr_shd.g_old_rec.bvr_attribute1
458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2
459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3
460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4
461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5
462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6
463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7
464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8
465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9

Line 462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6

458: ,p_bvr_attribute2_o =>ben_bvr_shd.g_old_rec.bvr_attribute2
459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3
460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4
461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5
462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6
463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7
464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8
465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9
466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10

Line 463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7

459: ,p_bvr_attribute3_o =>ben_bvr_shd.g_old_rec.bvr_attribute3
460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4
461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5
462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6
463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7
464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8
465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9
466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10
467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11

Line 464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8

460: ,p_bvr_attribute4_o =>ben_bvr_shd.g_old_rec.bvr_attribute4
461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5
462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6
463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7
464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8
465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9
466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10
467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11
468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12

Line 465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9

461: ,p_bvr_attribute5_o =>ben_bvr_shd.g_old_rec.bvr_attribute5
462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6
463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7
464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8
465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9
466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10
467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11
468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12
469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13

Line 466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10

462: ,p_bvr_attribute6_o =>ben_bvr_shd.g_old_rec.bvr_attribute6
463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7
464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8
465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9
466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10
467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11
468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12
469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13
470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14

Line 467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11

463: ,p_bvr_attribute7_o =>ben_bvr_shd.g_old_rec.bvr_attribute7
464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8
465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9
466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10
467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11
468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12
469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13
470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14
471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15

Line 468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12

464: ,p_bvr_attribute8_o =>ben_bvr_shd.g_old_rec.bvr_attribute8
465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9
466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10
467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11
468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12
469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13
470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14
471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15
472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16

Line 469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13

465: ,p_bvr_attribute9_o =>ben_bvr_shd.g_old_rec.bvr_attribute9
466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10
467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11
468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12
469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13
470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14
471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15
472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16
473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17

Line 470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14

466: ,p_bvr_attribute10_o =>ben_bvr_shd.g_old_rec.bvr_attribute10
467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11
468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12
469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13
470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14
471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15
472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16
473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17
474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18

Line 471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15

467: ,p_bvr_attribute11_o =>ben_bvr_shd.g_old_rec.bvr_attribute11
468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12
469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13
470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14
471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15
472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16
473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17
474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18
475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19

Line 472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16

468: ,p_bvr_attribute12_o =>ben_bvr_shd.g_old_rec.bvr_attribute12
469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13
470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14
471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15
472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16
473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17
474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18
475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19
476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20

Line 473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17

469: ,p_bvr_attribute13_o =>ben_bvr_shd.g_old_rec.bvr_attribute13
470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14
471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15
472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16
473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17
474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18
475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19
476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20
477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21

Line 474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18

470: ,p_bvr_attribute14_o =>ben_bvr_shd.g_old_rec.bvr_attribute14
471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15
472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16
473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17
474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18
475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19
476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20
477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21
478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22

Line 475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19

471: ,p_bvr_attribute15_o =>ben_bvr_shd.g_old_rec.bvr_attribute15
472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16
473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17
474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18
475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19
476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20
477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21
478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22
479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23

Line 476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20

472: ,p_bvr_attribute16_o =>ben_bvr_shd.g_old_rec.bvr_attribute16
473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17
474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18
475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19
476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20
477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21
478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22
479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23
480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24

Line 477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21

473: ,p_bvr_attribute17_o =>ben_bvr_shd.g_old_rec.bvr_attribute17
474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18
475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19
476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20
477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21
478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22
479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23
480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24
481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25

Line 478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22

474: ,p_bvr_attribute18_o =>ben_bvr_shd.g_old_rec.bvr_attribute18
475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19
476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20
477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21
478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22
479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23
480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24
481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25
482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26

Line 479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23

475: ,p_bvr_attribute19_o =>ben_bvr_shd.g_old_rec.bvr_attribute19
476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20
477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21
478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22
479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23
480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24
481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25
482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26
483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27

Line 480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24

476: ,p_bvr_attribute20_o =>ben_bvr_shd.g_old_rec.bvr_attribute20
477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21
478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22
479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23
480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24
481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25
482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26
483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27
484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28

Line 481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25

477: ,p_bvr_attribute21_o =>ben_bvr_shd.g_old_rec.bvr_attribute21
478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22
479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23
480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24
481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25
482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26
483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27
484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28
485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29

Line 482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26

478: ,p_bvr_attribute22_o =>ben_bvr_shd.g_old_rec.bvr_attribute22
479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23
480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24
481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25
482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26
483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27
484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28
485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29
486: ,p_bvr_attribute30_o =>ben_bvr_shd.g_old_rec.bvr_attribute30

Line 483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27

479: ,p_bvr_attribute23_o =>ben_bvr_shd.g_old_rec.bvr_attribute23
480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24
481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25
482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26
483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27
484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28
485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29
486: ,p_bvr_attribute30_o =>ben_bvr_shd.g_old_rec.bvr_attribute30
487: ,p_object_version_number_o =>ben_bvr_shd.g_old_rec.object_version_number

Line 484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28

480: ,p_bvr_attribute24_o =>ben_bvr_shd.g_old_rec.bvr_attribute24
481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25
482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26
483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27
484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28
485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29
486: ,p_bvr_attribute30_o =>ben_bvr_shd.g_old_rec.bvr_attribute30
487: ,p_object_version_number_o =>ben_bvr_shd.g_old_rec.object_version_number
488: ,p_ordr_num_o =>ben_bvr_shd.g_old_rec.ordr_num

Line 485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29

481: ,p_bvr_attribute25_o =>ben_bvr_shd.g_old_rec.bvr_attribute25
482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26
483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27
484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28
485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29
486: ,p_bvr_attribute30_o =>ben_bvr_shd.g_old_rec.bvr_attribute30
487: ,p_object_version_number_o =>ben_bvr_shd.g_old_rec.object_version_number
488: ,p_ordr_num_o =>ben_bvr_shd.g_old_rec.ordr_num
489: );

Line 486: ,p_bvr_attribute30_o =>ben_bvr_shd.g_old_rec.bvr_attribute30

482: ,p_bvr_attribute26_o =>ben_bvr_shd.g_old_rec.bvr_attribute26
483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27
484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28
485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29
486: ,p_bvr_attribute30_o =>ben_bvr_shd.g_old_rec.bvr_attribute30
487: ,p_object_version_number_o =>ben_bvr_shd.g_old_rec.object_version_number
488: ,p_ordr_num_o =>ben_bvr_shd.g_old_rec.ordr_num
489: );
490: --

Line 487: ,p_object_version_number_o =>ben_bvr_shd.g_old_rec.object_version_number

483: ,p_bvr_attribute27_o =>ben_bvr_shd.g_old_rec.bvr_attribute27
484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28
485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29
486: ,p_bvr_attribute30_o =>ben_bvr_shd.g_old_rec.bvr_attribute30
487: ,p_object_version_number_o =>ben_bvr_shd.g_old_rec.object_version_number
488: ,p_ordr_num_o =>ben_bvr_shd.g_old_rec.ordr_num
489: );
490: --
491: exception

Line 488: ,p_ordr_num_o =>ben_bvr_shd.g_old_rec.ordr_num

484: ,p_bvr_attribute28_o =>ben_bvr_shd.g_old_rec.bvr_attribute28
485: ,p_bvr_attribute29_o =>ben_bvr_shd.g_old_rec.bvr_attribute29
486: ,p_bvr_attribute30_o =>ben_bvr_shd.g_old_rec.bvr_attribute30
487: ,p_object_version_number_o =>ben_bvr_shd.g_old_rec.object_version_number
488: ,p_ordr_num_o =>ben_bvr_shd.g_old_rec.ordr_num
489: );
490: --
491: exception
492: --

Line 550: Procedure convert_defs(p_rec in out nocopy ben_bvr_shd.g_rec_type) is

546: -- Internal Row Handler Use Only.
547: --
548: -- {End Of Comments}
549: -- ----------------------------------------------------------------------------
550: Procedure convert_defs(p_rec in out nocopy ben_bvr_shd.g_rec_type) is
551: --
552: l_proc varchar2(72) := g_package||'convert_defs';
553: --
554: Begin

Line 565: ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id;

561: -- is being used then we must set to the 'current' argument value.
562: --
563: If (p_rec.cvg_amt_calc_mthd_id = hr_api.g_number) then
564: p_rec.cvg_amt_calc_mthd_id :=
565: ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id;
566: End If;
567: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
568: p_rec.vrbl_rt_prfl_id :=
569: ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id;

Line 569: ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id;

565: ben_bvr_shd.g_old_rec.cvg_amt_calc_mthd_id;
566: End If;
567: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
568: p_rec.vrbl_rt_prfl_id :=
569: ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id;
570: End If;
571: If (p_rec.business_group_id = hr_api.g_number) then
572: p_rec.business_group_id :=
573: ben_bvr_shd.g_old_rec.business_group_id;

Line 573: ben_bvr_shd.g_old_rec.business_group_id;

569: ben_bvr_shd.g_old_rec.vrbl_rt_prfl_id;
570: End If;
571: If (p_rec.business_group_id = hr_api.g_number) then
572: p_rec.business_group_id :=
573: ben_bvr_shd.g_old_rec.business_group_id;
574: End If;
575: If (p_rec.bvr_attribute_category = hr_api.g_varchar2) then
576: p_rec.bvr_attribute_category :=
577: ben_bvr_shd.g_old_rec.bvr_attribute_category;

Line 577: ben_bvr_shd.g_old_rec.bvr_attribute_category;

573: ben_bvr_shd.g_old_rec.business_group_id;
574: End If;
575: If (p_rec.bvr_attribute_category = hr_api.g_varchar2) then
576: p_rec.bvr_attribute_category :=
577: ben_bvr_shd.g_old_rec.bvr_attribute_category;
578: End If;
579: If (p_rec.bvr_attribute1 = hr_api.g_varchar2) then
580: p_rec.bvr_attribute1 :=
581: ben_bvr_shd.g_old_rec.bvr_attribute1;

Line 581: ben_bvr_shd.g_old_rec.bvr_attribute1;

577: ben_bvr_shd.g_old_rec.bvr_attribute_category;
578: End If;
579: If (p_rec.bvr_attribute1 = hr_api.g_varchar2) then
580: p_rec.bvr_attribute1 :=
581: ben_bvr_shd.g_old_rec.bvr_attribute1;
582: End If;
583: If (p_rec.bvr_attribute2 = hr_api.g_varchar2) then
584: p_rec.bvr_attribute2 :=
585: ben_bvr_shd.g_old_rec.bvr_attribute2;

Line 585: ben_bvr_shd.g_old_rec.bvr_attribute2;

581: ben_bvr_shd.g_old_rec.bvr_attribute1;
582: End If;
583: If (p_rec.bvr_attribute2 = hr_api.g_varchar2) then
584: p_rec.bvr_attribute2 :=
585: ben_bvr_shd.g_old_rec.bvr_attribute2;
586: End If;
587: If (p_rec.bvr_attribute3 = hr_api.g_varchar2) then
588: p_rec.bvr_attribute3 :=
589: ben_bvr_shd.g_old_rec.bvr_attribute3;

Line 589: ben_bvr_shd.g_old_rec.bvr_attribute3;

585: ben_bvr_shd.g_old_rec.bvr_attribute2;
586: End If;
587: If (p_rec.bvr_attribute3 = hr_api.g_varchar2) then
588: p_rec.bvr_attribute3 :=
589: ben_bvr_shd.g_old_rec.bvr_attribute3;
590: End If;
591: If (p_rec.bvr_attribute4 = hr_api.g_varchar2) then
592: p_rec.bvr_attribute4 :=
593: ben_bvr_shd.g_old_rec.bvr_attribute4;

Line 593: ben_bvr_shd.g_old_rec.bvr_attribute4;

589: ben_bvr_shd.g_old_rec.bvr_attribute3;
590: End If;
591: If (p_rec.bvr_attribute4 = hr_api.g_varchar2) then
592: p_rec.bvr_attribute4 :=
593: ben_bvr_shd.g_old_rec.bvr_attribute4;
594: End If;
595: If (p_rec.bvr_attribute5 = hr_api.g_varchar2) then
596: p_rec.bvr_attribute5 :=
597: ben_bvr_shd.g_old_rec.bvr_attribute5;

Line 597: ben_bvr_shd.g_old_rec.bvr_attribute5;

593: ben_bvr_shd.g_old_rec.bvr_attribute4;
594: End If;
595: If (p_rec.bvr_attribute5 = hr_api.g_varchar2) then
596: p_rec.bvr_attribute5 :=
597: ben_bvr_shd.g_old_rec.bvr_attribute5;
598: End If;
599: If (p_rec.bvr_attribute6 = hr_api.g_varchar2) then
600: p_rec.bvr_attribute6 :=
601: ben_bvr_shd.g_old_rec.bvr_attribute6;

Line 601: ben_bvr_shd.g_old_rec.bvr_attribute6;

597: ben_bvr_shd.g_old_rec.bvr_attribute5;
598: End If;
599: If (p_rec.bvr_attribute6 = hr_api.g_varchar2) then
600: p_rec.bvr_attribute6 :=
601: ben_bvr_shd.g_old_rec.bvr_attribute6;
602: End If;
603: If (p_rec.bvr_attribute7 = hr_api.g_varchar2) then
604: p_rec.bvr_attribute7 :=
605: ben_bvr_shd.g_old_rec.bvr_attribute7;

Line 605: ben_bvr_shd.g_old_rec.bvr_attribute7;

601: ben_bvr_shd.g_old_rec.bvr_attribute6;
602: End If;
603: If (p_rec.bvr_attribute7 = hr_api.g_varchar2) then
604: p_rec.bvr_attribute7 :=
605: ben_bvr_shd.g_old_rec.bvr_attribute7;
606: End If;
607: If (p_rec.bvr_attribute8 = hr_api.g_varchar2) then
608: p_rec.bvr_attribute8 :=
609: ben_bvr_shd.g_old_rec.bvr_attribute8;

Line 609: ben_bvr_shd.g_old_rec.bvr_attribute8;

605: ben_bvr_shd.g_old_rec.bvr_attribute7;
606: End If;
607: If (p_rec.bvr_attribute8 = hr_api.g_varchar2) then
608: p_rec.bvr_attribute8 :=
609: ben_bvr_shd.g_old_rec.bvr_attribute8;
610: End If;
611: If (p_rec.bvr_attribute9 = hr_api.g_varchar2) then
612: p_rec.bvr_attribute9 :=
613: ben_bvr_shd.g_old_rec.bvr_attribute9;

Line 613: ben_bvr_shd.g_old_rec.bvr_attribute9;

609: ben_bvr_shd.g_old_rec.bvr_attribute8;
610: End If;
611: If (p_rec.bvr_attribute9 = hr_api.g_varchar2) then
612: p_rec.bvr_attribute9 :=
613: ben_bvr_shd.g_old_rec.bvr_attribute9;
614: End If;
615: If (p_rec.bvr_attribute10 = hr_api.g_varchar2) then
616: p_rec.bvr_attribute10 :=
617: ben_bvr_shd.g_old_rec.bvr_attribute10;

Line 617: ben_bvr_shd.g_old_rec.bvr_attribute10;

613: ben_bvr_shd.g_old_rec.bvr_attribute9;
614: End If;
615: If (p_rec.bvr_attribute10 = hr_api.g_varchar2) then
616: p_rec.bvr_attribute10 :=
617: ben_bvr_shd.g_old_rec.bvr_attribute10;
618: End If;
619: If (p_rec.bvr_attribute11 = hr_api.g_varchar2) then
620: p_rec.bvr_attribute11 :=
621: ben_bvr_shd.g_old_rec.bvr_attribute11;

Line 621: ben_bvr_shd.g_old_rec.bvr_attribute11;

617: ben_bvr_shd.g_old_rec.bvr_attribute10;
618: End If;
619: If (p_rec.bvr_attribute11 = hr_api.g_varchar2) then
620: p_rec.bvr_attribute11 :=
621: ben_bvr_shd.g_old_rec.bvr_attribute11;
622: End If;
623: If (p_rec.bvr_attribute12 = hr_api.g_varchar2) then
624: p_rec.bvr_attribute12 :=
625: ben_bvr_shd.g_old_rec.bvr_attribute12;

Line 625: ben_bvr_shd.g_old_rec.bvr_attribute12;

621: ben_bvr_shd.g_old_rec.bvr_attribute11;
622: End If;
623: If (p_rec.bvr_attribute12 = hr_api.g_varchar2) then
624: p_rec.bvr_attribute12 :=
625: ben_bvr_shd.g_old_rec.bvr_attribute12;
626: End If;
627: If (p_rec.bvr_attribute13 = hr_api.g_varchar2) then
628: p_rec.bvr_attribute13 :=
629: ben_bvr_shd.g_old_rec.bvr_attribute13;

Line 629: ben_bvr_shd.g_old_rec.bvr_attribute13;

625: ben_bvr_shd.g_old_rec.bvr_attribute12;
626: End If;
627: If (p_rec.bvr_attribute13 = hr_api.g_varchar2) then
628: p_rec.bvr_attribute13 :=
629: ben_bvr_shd.g_old_rec.bvr_attribute13;
630: End If;
631: If (p_rec.bvr_attribute14 = hr_api.g_varchar2) then
632: p_rec.bvr_attribute14 :=
633: ben_bvr_shd.g_old_rec.bvr_attribute14;

Line 633: ben_bvr_shd.g_old_rec.bvr_attribute14;

629: ben_bvr_shd.g_old_rec.bvr_attribute13;
630: End If;
631: If (p_rec.bvr_attribute14 = hr_api.g_varchar2) then
632: p_rec.bvr_attribute14 :=
633: ben_bvr_shd.g_old_rec.bvr_attribute14;
634: End If;
635: If (p_rec.bvr_attribute15 = hr_api.g_varchar2) then
636: p_rec.bvr_attribute15 :=
637: ben_bvr_shd.g_old_rec.bvr_attribute15;

Line 637: ben_bvr_shd.g_old_rec.bvr_attribute15;

633: ben_bvr_shd.g_old_rec.bvr_attribute14;
634: End If;
635: If (p_rec.bvr_attribute15 = hr_api.g_varchar2) then
636: p_rec.bvr_attribute15 :=
637: ben_bvr_shd.g_old_rec.bvr_attribute15;
638: End If;
639: If (p_rec.bvr_attribute16 = hr_api.g_varchar2) then
640: p_rec.bvr_attribute16 :=
641: ben_bvr_shd.g_old_rec.bvr_attribute16;

Line 641: ben_bvr_shd.g_old_rec.bvr_attribute16;

637: ben_bvr_shd.g_old_rec.bvr_attribute15;
638: End If;
639: If (p_rec.bvr_attribute16 = hr_api.g_varchar2) then
640: p_rec.bvr_attribute16 :=
641: ben_bvr_shd.g_old_rec.bvr_attribute16;
642: End If;
643: If (p_rec.bvr_attribute17 = hr_api.g_varchar2) then
644: p_rec.bvr_attribute17 :=
645: ben_bvr_shd.g_old_rec.bvr_attribute17;

Line 645: ben_bvr_shd.g_old_rec.bvr_attribute17;

641: ben_bvr_shd.g_old_rec.bvr_attribute16;
642: End If;
643: If (p_rec.bvr_attribute17 = hr_api.g_varchar2) then
644: p_rec.bvr_attribute17 :=
645: ben_bvr_shd.g_old_rec.bvr_attribute17;
646: End If;
647: If (p_rec.bvr_attribute18 = hr_api.g_varchar2) then
648: p_rec.bvr_attribute18 :=
649: ben_bvr_shd.g_old_rec.bvr_attribute18;

Line 649: ben_bvr_shd.g_old_rec.bvr_attribute18;

645: ben_bvr_shd.g_old_rec.bvr_attribute17;
646: End If;
647: If (p_rec.bvr_attribute18 = hr_api.g_varchar2) then
648: p_rec.bvr_attribute18 :=
649: ben_bvr_shd.g_old_rec.bvr_attribute18;
650: End If;
651: If (p_rec.bvr_attribute19 = hr_api.g_varchar2) then
652: p_rec.bvr_attribute19 :=
653: ben_bvr_shd.g_old_rec.bvr_attribute19;

Line 653: ben_bvr_shd.g_old_rec.bvr_attribute19;

649: ben_bvr_shd.g_old_rec.bvr_attribute18;
650: End If;
651: If (p_rec.bvr_attribute19 = hr_api.g_varchar2) then
652: p_rec.bvr_attribute19 :=
653: ben_bvr_shd.g_old_rec.bvr_attribute19;
654: End If;
655: If (p_rec.bvr_attribute20 = hr_api.g_varchar2) then
656: p_rec.bvr_attribute20 :=
657: ben_bvr_shd.g_old_rec.bvr_attribute20;

Line 657: ben_bvr_shd.g_old_rec.bvr_attribute20;

653: ben_bvr_shd.g_old_rec.bvr_attribute19;
654: End If;
655: If (p_rec.bvr_attribute20 = hr_api.g_varchar2) then
656: p_rec.bvr_attribute20 :=
657: ben_bvr_shd.g_old_rec.bvr_attribute20;
658: End If;
659: If (p_rec.bvr_attribute21 = hr_api.g_varchar2) then
660: p_rec.bvr_attribute21 :=
661: ben_bvr_shd.g_old_rec.bvr_attribute21;

Line 661: ben_bvr_shd.g_old_rec.bvr_attribute21;

657: ben_bvr_shd.g_old_rec.bvr_attribute20;
658: End If;
659: If (p_rec.bvr_attribute21 = hr_api.g_varchar2) then
660: p_rec.bvr_attribute21 :=
661: ben_bvr_shd.g_old_rec.bvr_attribute21;
662: End If;
663: If (p_rec.bvr_attribute22 = hr_api.g_varchar2) then
664: p_rec.bvr_attribute22 :=
665: ben_bvr_shd.g_old_rec.bvr_attribute22;

Line 665: ben_bvr_shd.g_old_rec.bvr_attribute22;

661: ben_bvr_shd.g_old_rec.bvr_attribute21;
662: End If;
663: If (p_rec.bvr_attribute22 = hr_api.g_varchar2) then
664: p_rec.bvr_attribute22 :=
665: ben_bvr_shd.g_old_rec.bvr_attribute22;
666: End If;
667: If (p_rec.bvr_attribute23 = hr_api.g_varchar2) then
668: p_rec.bvr_attribute23 :=
669: ben_bvr_shd.g_old_rec.bvr_attribute23;

Line 669: ben_bvr_shd.g_old_rec.bvr_attribute23;

665: ben_bvr_shd.g_old_rec.bvr_attribute22;
666: End If;
667: If (p_rec.bvr_attribute23 = hr_api.g_varchar2) then
668: p_rec.bvr_attribute23 :=
669: ben_bvr_shd.g_old_rec.bvr_attribute23;
670: End If;
671: If (p_rec.bvr_attribute24 = hr_api.g_varchar2) then
672: p_rec.bvr_attribute24 :=
673: ben_bvr_shd.g_old_rec.bvr_attribute24;

Line 673: ben_bvr_shd.g_old_rec.bvr_attribute24;

669: ben_bvr_shd.g_old_rec.bvr_attribute23;
670: End If;
671: If (p_rec.bvr_attribute24 = hr_api.g_varchar2) then
672: p_rec.bvr_attribute24 :=
673: ben_bvr_shd.g_old_rec.bvr_attribute24;
674: End If;
675: If (p_rec.bvr_attribute25 = hr_api.g_varchar2) then
676: p_rec.bvr_attribute25 :=
677: ben_bvr_shd.g_old_rec.bvr_attribute25;

Line 677: ben_bvr_shd.g_old_rec.bvr_attribute25;

673: ben_bvr_shd.g_old_rec.bvr_attribute24;
674: End If;
675: If (p_rec.bvr_attribute25 = hr_api.g_varchar2) then
676: p_rec.bvr_attribute25 :=
677: ben_bvr_shd.g_old_rec.bvr_attribute25;
678: End If;
679: If (p_rec.bvr_attribute26 = hr_api.g_varchar2) then
680: p_rec.bvr_attribute26 :=
681: ben_bvr_shd.g_old_rec.bvr_attribute26;

Line 681: ben_bvr_shd.g_old_rec.bvr_attribute26;

677: ben_bvr_shd.g_old_rec.bvr_attribute25;
678: End If;
679: If (p_rec.bvr_attribute26 = hr_api.g_varchar2) then
680: p_rec.bvr_attribute26 :=
681: ben_bvr_shd.g_old_rec.bvr_attribute26;
682: End If;
683: If (p_rec.bvr_attribute27 = hr_api.g_varchar2) then
684: p_rec.bvr_attribute27 :=
685: ben_bvr_shd.g_old_rec.bvr_attribute27;

Line 685: ben_bvr_shd.g_old_rec.bvr_attribute27;

681: ben_bvr_shd.g_old_rec.bvr_attribute26;
682: End If;
683: If (p_rec.bvr_attribute27 = hr_api.g_varchar2) then
684: p_rec.bvr_attribute27 :=
685: ben_bvr_shd.g_old_rec.bvr_attribute27;
686: End If;
687: If (p_rec.bvr_attribute28 = hr_api.g_varchar2) then
688: p_rec.bvr_attribute28 :=
689: ben_bvr_shd.g_old_rec.bvr_attribute28;

Line 689: ben_bvr_shd.g_old_rec.bvr_attribute28;

685: ben_bvr_shd.g_old_rec.bvr_attribute27;
686: End If;
687: If (p_rec.bvr_attribute28 = hr_api.g_varchar2) then
688: p_rec.bvr_attribute28 :=
689: ben_bvr_shd.g_old_rec.bvr_attribute28;
690: End If;
691: If (p_rec.bvr_attribute29 = hr_api.g_varchar2) then
692: p_rec.bvr_attribute29 :=
693: ben_bvr_shd.g_old_rec.bvr_attribute29;

Line 693: ben_bvr_shd.g_old_rec.bvr_attribute29;

689: ben_bvr_shd.g_old_rec.bvr_attribute28;
690: End If;
691: If (p_rec.bvr_attribute29 = hr_api.g_varchar2) then
692: p_rec.bvr_attribute29 :=
693: ben_bvr_shd.g_old_rec.bvr_attribute29;
694: End If;
695: If (p_rec.bvr_attribute30 = hr_api.g_varchar2) then
696: p_rec.bvr_attribute30 :=
697: ben_bvr_shd.g_old_rec.bvr_attribute30;

Line 697: ben_bvr_shd.g_old_rec.bvr_attribute30;

693: ben_bvr_shd.g_old_rec.bvr_attribute29;
694: End If;
695: If (p_rec.bvr_attribute30 = hr_api.g_varchar2) then
696: p_rec.bvr_attribute30 :=
697: ben_bvr_shd.g_old_rec.bvr_attribute30;
698: End If;
699: If (p_rec.ordr_num = hr_api.g_number) then
700: p_rec.ordr_num :=
701: ben_bvr_shd.g_old_rec.ordr_num;

Line 701: ben_bvr_shd.g_old_rec.ordr_num;

697: ben_bvr_shd.g_old_rec.bvr_attribute30;
698: End If;
699: If (p_rec.ordr_num = hr_api.g_number) then
700: p_rec.ordr_num :=
701: ben_bvr_shd.g_old_rec.ordr_num;
702: End If;
703: --
704: hr_utility.set_location(' Leaving:'||l_proc, 10);
705: --

Line 713: p_rec in out nocopy ben_bvr_shd.g_rec_type,

709: -- |---------------------------------< upd >----------------------------------|
710: -- ----------------------------------------------------------------------------
711: Procedure upd
712: (
713: p_rec in out nocopy ben_bvr_shd.g_rec_type,
714: p_effective_date in date,
715: p_datetrack_mode in varchar2
716: ) is
717: --

Line 731: ben_bvr_shd.lck

727: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
728: --
729: -- We must lock the row which we need to update.
730: --
731: ben_bvr_shd.lck
732: (p_effective_date => p_effective_date,
733: p_datetrack_mode => p_datetrack_mode,
734: p_bnft_vrbl_rt_id => p_rec.bnft_vrbl_rt_id,
735: p_object_version_number => p_rec.object_version_number,

Line 829: l_rec ben_bvr_shd.g_rec_type;

825: p_effective_date in date,
826: p_datetrack_mode in varchar2
827: ) is
828: --
829: l_rec ben_bvr_shd.g_rec_type;
830: l_proc varchar2(72) := g_package||'upd';
831: --
832: Begin
833: hr_utility.set_location('Entering:'||l_proc, 5);

Line 839: ben_bvr_shd.convert_args

835: -- Call conversion function to turn arguments into the
836: -- l_rec structure.
837: --
838: l_rec :=
839: ben_bvr_shd.convert_args
840: (
841: p_bnft_vrbl_rt_id,
842: null,
843: null,