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_AVA_UPD dependencies on BEN_AVA_SHD

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

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_ava_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_ava_shd.g_api_dml := true; -- Set the api dml status

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

Line 129: ben_ava_shd.g_api_dml := false; -- Unset the api dml status

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

Line 141: ben_ava_shd.g_api_dml := false; -- Unset the api dml status

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

Line 142: ben_ava_shd.constraint_error

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

Line 146: ben_ava_shd.g_api_dml := false; -- Unset the api dml status

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

Line 147: ben_ava_shd.constraint_error

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

Line 150: ben_ava_shd.g_api_dml := false; -- Unset the api dml status

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

Line 186: (p_rec in out nocopy ben_ava_shd.g_rec_type,

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

Line 250: (p_rec in out nocopy ben_ava_shd.g_rec_type,

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

Line 266: ben_ava_shd.upd_effective_end_date

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

Line 335: (p_rec in out nocopy ben_ava_shd.g_rec_type,

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

Line 391: (p_rec in ben_ava_shd.g_rec_type,

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

Line 453: ,p_effective_start_date_o =>ben_ava_shd.g_old_rec.effective_start_date

449: ,p_effective_date =>p_effective_date
450: ,p_datetrack_mode =>p_datetrack_mode
451: ,p_validation_start_date =>p_validation_start_date
452: ,p_validation_end_date =>p_validation_end_date
453: ,p_effective_start_date_o =>ben_ava_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
455: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num

Line 454: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date

450: ,p_datetrack_mode =>p_datetrack_mode
451: ,p_validation_start_date =>p_validation_start_date
452: ,p_validation_end_date =>p_validation_end_date
453: ,p_effective_start_date_o =>ben_ava_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
455: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd

Line 455: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id

451: ,p_validation_start_date =>p_validation_start_date
452: ,p_validation_end_date =>p_validation_end_date
453: ,p_effective_start_date_o =>ben_ava_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
455: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id

Line 456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id

452: ,p_validation_end_date =>p_validation_end_date
453: ,p_effective_start_date_o =>ben_ava_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
455: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category

Line 457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num

453: ,p_effective_start_date_o =>ben_ava_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
455: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1

Line 458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd

454: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
455: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2

Line 459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id

455: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3

Line 460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category

456: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4

Line 461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1

457: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5

Line 462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2

458: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6

Line 463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3

459: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7

Line 464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4

460: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8

Line 465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5

461: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9

Line 466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6

462: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10

Line 467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7

463: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11

Line 468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8

464: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12

Line 469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9

465: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13

Line 470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10

466: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14

Line 471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11

467: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15

Line 472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12

468: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16

Line 473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13

469: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17

Line 474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14

470: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18

Line 475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15

471: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19

Line 476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16

472: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20

Line 477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17

473: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21

Line 478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18

474: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22

Line 479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19

475: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23

Line 480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20

476: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24

Line 481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21

477: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25

Line 482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22

478: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26

Line 483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23

479: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27

Line 484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24

480: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28

Line 485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25

481: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
489: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29

Line 486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26

482: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
489: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
490: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30

Line 487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27

483: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
489: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
490: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
491: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number

Line 488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28

484: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
489: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
490: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
491: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number
492: );

Line 489: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29

485: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
489: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
490: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
491: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number
492: );
493: --

Line 490: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30

486: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
489: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
490: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
491: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number
492: );
493: --
494: exception

Line 491: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number

487: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
488: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
489: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
490: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
491: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number
492: );
493: --
494: exception
495: --

Line 553: Procedure convert_defs(p_rec in out nocopy ben_ava_shd.g_rec_type) is

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

Line 568: ben_ava_shd.g_old_rec.actl_prem_id;

564: -- is being used then we must set to the 'current' argument value.
565: --
566: If (p_rec.actl_prem_id = hr_api.g_number) then
567: p_rec.actl_prem_id :=
568: ben_ava_shd.g_old_rec.actl_prem_id;
569: End If;
570: If (p_rec.formula_id = hr_api.g_number) then
571: p_rec.formula_id :=
572: ben_ava_shd.g_old_rec.formula_id;

Line 572: ben_ava_shd.g_old_rec.formula_id;

568: ben_ava_shd.g_old_rec.actl_prem_id;
569: End If;
570: If (p_rec.formula_id = hr_api.g_number) then
571: p_rec.formula_id :=
572: ben_ava_shd.g_old_rec.formula_id;
573: End If;
574: If (p_rec.ordr_to_aply_num = hr_api.g_number) then
575: p_rec.ordr_to_aply_num :=
576: ben_ava_shd.g_old_rec.ordr_to_aply_num;

Line 576: ben_ava_shd.g_old_rec.ordr_to_aply_num;

572: ben_ava_shd.g_old_rec.formula_id;
573: End If;
574: If (p_rec.ordr_to_aply_num = hr_api.g_number) then
575: p_rec.ordr_to_aply_num :=
576: ben_ava_shd.g_old_rec.ordr_to_aply_num;
577: End If;
578: If (p_rec.rt_trtmt_cd = hr_api.g_varchar2) then
579: p_rec.rt_trtmt_cd :=
580: ben_ava_shd.g_old_rec.rt_trtmt_cd;

Line 580: ben_ava_shd.g_old_rec.rt_trtmt_cd;

576: ben_ava_shd.g_old_rec.ordr_to_aply_num;
577: End If;
578: If (p_rec.rt_trtmt_cd = hr_api.g_varchar2) then
579: p_rec.rt_trtmt_cd :=
580: ben_ava_shd.g_old_rec.rt_trtmt_cd;
581: End If;
582: If (p_rec.business_group_id = hr_api.g_number) then
583: p_rec.business_group_id :=
584: ben_ava_shd.g_old_rec.business_group_id;

Line 584: ben_ava_shd.g_old_rec.business_group_id;

580: ben_ava_shd.g_old_rec.rt_trtmt_cd;
581: End If;
582: If (p_rec.business_group_id = hr_api.g_number) then
583: p_rec.business_group_id :=
584: ben_ava_shd.g_old_rec.business_group_id;
585: End If;
586: If (p_rec.ava_attribute_category = hr_api.g_varchar2) then
587: p_rec.ava_attribute_category :=
588: ben_ava_shd.g_old_rec.ava_attribute_category;

Line 588: ben_ava_shd.g_old_rec.ava_attribute_category;

584: ben_ava_shd.g_old_rec.business_group_id;
585: End If;
586: If (p_rec.ava_attribute_category = hr_api.g_varchar2) then
587: p_rec.ava_attribute_category :=
588: ben_ava_shd.g_old_rec.ava_attribute_category;
589: End If;
590: If (p_rec.ava_attribute1 = hr_api.g_varchar2) then
591: p_rec.ava_attribute1 :=
592: ben_ava_shd.g_old_rec.ava_attribute1;

Line 592: ben_ava_shd.g_old_rec.ava_attribute1;

588: ben_ava_shd.g_old_rec.ava_attribute_category;
589: End If;
590: If (p_rec.ava_attribute1 = hr_api.g_varchar2) then
591: p_rec.ava_attribute1 :=
592: ben_ava_shd.g_old_rec.ava_attribute1;
593: End If;
594: If (p_rec.ava_attribute2 = hr_api.g_varchar2) then
595: p_rec.ava_attribute2 :=
596: ben_ava_shd.g_old_rec.ava_attribute2;

Line 596: ben_ava_shd.g_old_rec.ava_attribute2;

592: ben_ava_shd.g_old_rec.ava_attribute1;
593: End If;
594: If (p_rec.ava_attribute2 = hr_api.g_varchar2) then
595: p_rec.ava_attribute2 :=
596: ben_ava_shd.g_old_rec.ava_attribute2;
597: End If;
598: If (p_rec.ava_attribute3 = hr_api.g_varchar2) then
599: p_rec.ava_attribute3 :=
600: ben_ava_shd.g_old_rec.ava_attribute3;

Line 600: ben_ava_shd.g_old_rec.ava_attribute3;

596: ben_ava_shd.g_old_rec.ava_attribute2;
597: End If;
598: If (p_rec.ava_attribute3 = hr_api.g_varchar2) then
599: p_rec.ava_attribute3 :=
600: ben_ava_shd.g_old_rec.ava_attribute3;
601: End If;
602: If (p_rec.ava_attribute4 = hr_api.g_varchar2) then
603: p_rec.ava_attribute4 :=
604: ben_ava_shd.g_old_rec.ava_attribute4;

Line 604: ben_ava_shd.g_old_rec.ava_attribute4;

600: ben_ava_shd.g_old_rec.ava_attribute3;
601: End If;
602: If (p_rec.ava_attribute4 = hr_api.g_varchar2) then
603: p_rec.ava_attribute4 :=
604: ben_ava_shd.g_old_rec.ava_attribute4;
605: End If;
606: If (p_rec.ava_attribute5 = hr_api.g_varchar2) then
607: p_rec.ava_attribute5 :=
608: ben_ava_shd.g_old_rec.ava_attribute5;

Line 608: ben_ava_shd.g_old_rec.ava_attribute5;

604: ben_ava_shd.g_old_rec.ava_attribute4;
605: End If;
606: If (p_rec.ava_attribute5 = hr_api.g_varchar2) then
607: p_rec.ava_attribute5 :=
608: ben_ava_shd.g_old_rec.ava_attribute5;
609: End If;
610: If (p_rec.ava_attribute6 = hr_api.g_varchar2) then
611: p_rec.ava_attribute6 :=
612: ben_ava_shd.g_old_rec.ava_attribute6;

Line 612: ben_ava_shd.g_old_rec.ava_attribute6;

608: ben_ava_shd.g_old_rec.ava_attribute5;
609: End If;
610: If (p_rec.ava_attribute6 = hr_api.g_varchar2) then
611: p_rec.ava_attribute6 :=
612: ben_ava_shd.g_old_rec.ava_attribute6;
613: End If;
614: If (p_rec.ava_attribute7 = hr_api.g_varchar2) then
615: p_rec.ava_attribute7 :=
616: ben_ava_shd.g_old_rec.ava_attribute7;

Line 616: ben_ava_shd.g_old_rec.ava_attribute7;

612: ben_ava_shd.g_old_rec.ava_attribute6;
613: End If;
614: If (p_rec.ava_attribute7 = hr_api.g_varchar2) then
615: p_rec.ava_attribute7 :=
616: ben_ava_shd.g_old_rec.ava_attribute7;
617: End If;
618: If (p_rec.ava_attribute8 = hr_api.g_varchar2) then
619: p_rec.ava_attribute8 :=
620: ben_ava_shd.g_old_rec.ava_attribute8;

Line 620: ben_ava_shd.g_old_rec.ava_attribute8;

616: ben_ava_shd.g_old_rec.ava_attribute7;
617: End If;
618: If (p_rec.ava_attribute8 = hr_api.g_varchar2) then
619: p_rec.ava_attribute8 :=
620: ben_ava_shd.g_old_rec.ava_attribute8;
621: End If;
622: If (p_rec.ava_attribute9 = hr_api.g_varchar2) then
623: p_rec.ava_attribute9 :=
624: ben_ava_shd.g_old_rec.ava_attribute9;

Line 624: ben_ava_shd.g_old_rec.ava_attribute9;

620: ben_ava_shd.g_old_rec.ava_attribute8;
621: End If;
622: If (p_rec.ava_attribute9 = hr_api.g_varchar2) then
623: p_rec.ava_attribute9 :=
624: ben_ava_shd.g_old_rec.ava_attribute9;
625: End If;
626: If (p_rec.ava_attribute10 = hr_api.g_varchar2) then
627: p_rec.ava_attribute10 :=
628: ben_ava_shd.g_old_rec.ava_attribute10;

Line 628: ben_ava_shd.g_old_rec.ava_attribute10;

624: ben_ava_shd.g_old_rec.ava_attribute9;
625: End If;
626: If (p_rec.ava_attribute10 = hr_api.g_varchar2) then
627: p_rec.ava_attribute10 :=
628: ben_ava_shd.g_old_rec.ava_attribute10;
629: End If;
630: If (p_rec.ava_attribute11 = hr_api.g_varchar2) then
631: p_rec.ava_attribute11 :=
632: ben_ava_shd.g_old_rec.ava_attribute11;

Line 632: ben_ava_shd.g_old_rec.ava_attribute11;

628: ben_ava_shd.g_old_rec.ava_attribute10;
629: End If;
630: If (p_rec.ava_attribute11 = hr_api.g_varchar2) then
631: p_rec.ava_attribute11 :=
632: ben_ava_shd.g_old_rec.ava_attribute11;
633: End If;
634: If (p_rec.ava_attribute12 = hr_api.g_varchar2) then
635: p_rec.ava_attribute12 :=
636: ben_ava_shd.g_old_rec.ava_attribute12;

Line 636: ben_ava_shd.g_old_rec.ava_attribute12;

632: ben_ava_shd.g_old_rec.ava_attribute11;
633: End If;
634: If (p_rec.ava_attribute12 = hr_api.g_varchar2) then
635: p_rec.ava_attribute12 :=
636: ben_ava_shd.g_old_rec.ava_attribute12;
637: End If;
638: If (p_rec.ava_attribute13 = hr_api.g_varchar2) then
639: p_rec.ava_attribute13 :=
640: ben_ava_shd.g_old_rec.ava_attribute13;

Line 640: ben_ava_shd.g_old_rec.ava_attribute13;

636: ben_ava_shd.g_old_rec.ava_attribute12;
637: End If;
638: If (p_rec.ava_attribute13 = hr_api.g_varchar2) then
639: p_rec.ava_attribute13 :=
640: ben_ava_shd.g_old_rec.ava_attribute13;
641: End If;
642: If (p_rec.ava_attribute14 = hr_api.g_varchar2) then
643: p_rec.ava_attribute14 :=
644: ben_ava_shd.g_old_rec.ava_attribute14;

Line 644: ben_ava_shd.g_old_rec.ava_attribute14;

640: ben_ava_shd.g_old_rec.ava_attribute13;
641: End If;
642: If (p_rec.ava_attribute14 = hr_api.g_varchar2) then
643: p_rec.ava_attribute14 :=
644: ben_ava_shd.g_old_rec.ava_attribute14;
645: End If;
646: If (p_rec.ava_attribute15 = hr_api.g_varchar2) then
647: p_rec.ava_attribute15 :=
648: ben_ava_shd.g_old_rec.ava_attribute15;

Line 648: ben_ava_shd.g_old_rec.ava_attribute15;

644: ben_ava_shd.g_old_rec.ava_attribute14;
645: End If;
646: If (p_rec.ava_attribute15 = hr_api.g_varchar2) then
647: p_rec.ava_attribute15 :=
648: ben_ava_shd.g_old_rec.ava_attribute15;
649: End If;
650: If (p_rec.ava_attribute16 = hr_api.g_varchar2) then
651: p_rec.ava_attribute16 :=
652: ben_ava_shd.g_old_rec.ava_attribute16;

Line 652: ben_ava_shd.g_old_rec.ava_attribute16;

648: ben_ava_shd.g_old_rec.ava_attribute15;
649: End If;
650: If (p_rec.ava_attribute16 = hr_api.g_varchar2) then
651: p_rec.ava_attribute16 :=
652: ben_ava_shd.g_old_rec.ava_attribute16;
653: End If;
654: If (p_rec.ava_attribute17 = hr_api.g_varchar2) then
655: p_rec.ava_attribute17 :=
656: ben_ava_shd.g_old_rec.ava_attribute17;

Line 656: ben_ava_shd.g_old_rec.ava_attribute17;

652: ben_ava_shd.g_old_rec.ava_attribute16;
653: End If;
654: If (p_rec.ava_attribute17 = hr_api.g_varchar2) then
655: p_rec.ava_attribute17 :=
656: ben_ava_shd.g_old_rec.ava_attribute17;
657: End If;
658: If (p_rec.ava_attribute18 = hr_api.g_varchar2) then
659: p_rec.ava_attribute18 :=
660: ben_ava_shd.g_old_rec.ava_attribute18;

Line 660: ben_ava_shd.g_old_rec.ava_attribute18;

656: ben_ava_shd.g_old_rec.ava_attribute17;
657: End If;
658: If (p_rec.ava_attribute18 = hr_api.g_varchar2) then
659: p_rec.ava_attribute18 :=
660: ben_ava_shd.g_old_rec.ava_attribute18;
661: End If;
662: If (p_rec.ava_attribute19 = hr_api.g_varchar2) then
663: p_rec.ava_attribute19 :=
664: ben_ava_shd.g_old_rec.ava_attribute19;

Line 664: ben_ava_shd.g_old_rec.ava_attribute19;

660: ben_ava_shd.g_old_rec.ava_attribute18;
661: End If;
662: If (p_rec.ava_attribute19 = hr_api.g_varchar2) then
663: p_rec.ava_attribute19 :=
664: ben_ava_shd.g_old_rec.ava_attribute19;
665: End If;
666: If (p_rec.ava_attribute20 = hr_api.g_varchar2) then
667: p_rec.ava_attribute20 :=
668: ben_ava_shd.g_old_rec.ava_attribute20;

Line 668: ben_ava_shd.g_old_rec.ava_attribute20;

664: ben_ava_shd.g_old_rec.ava_attribute19;
665: End If;
666: If (p_rec.ava_attribute20 = hr_api.g_varchar2) then
667: p_rec.ava_attribute20 :=
668: ben_ava_shd.g_old_rec.ava_attribute20;
669: End If;
670: If (p_rec.ava_attribute21 = hr_api.g_varchar2) then
671: p_rec.ava_attribute21 :=
672: ben_ava_shd.g_old_rec.ava_attribute21;

Line 672: ben_ava_shd.g_old_rec.ava_attribute21;

668: ben_ava_shd.g_old_rec.ava_attribute20;
669: End If;
670: If (p_rec.ava_attribute21 = hr_api.g_varchar2) then
671: p_rec.ava_attribute21 :=
672: ben_ava_shd.g_old_rec.ava_attribute21;
673: End If;
674: If (p_rec.ava_attribute22 = hr_api.g_varchar2) then
675: p_rec.ava_attribute22 :=
676: ben_ava_shd.g_old_rec.ava_attribute22;

Line 676: ben_ava_shd.g_old_rec.ava_attribute22;

672: ben_ava_shd.g_old_rec.ava_attribute21;
673: End If;
674: If (p_rec.ava_attribute22 = hr_api.g_varchar2) then
675: p_rec.ava_attribute22 :=
676: ben_ava_shd.g_old_rec.ava_attribute22;
677: End If;
678: If (p_rec.ava_attribute23 = hr_api.g_varchar2) then
679: p_rec.ava_attribute23 :=
680: ben_ava_shd.g_old_rec.ava_attribute23;

Line 680: ben_ava_shd.g_old_rec.ava_attribute23;

676: ben_ava_shd.g_old_rec.ava_attribute22;
677: End If;
678: If (p_rec.ava_attribute23 = hr_api.g_varchar2) then
679: p_rec.ava_attribute23 :=
680: ben_ava_shd.g_old_rec.ava_attribute23;
681: End If;
682: If (p_rec.ava_attribute24 = hr_api.g_varchar2) then
683: p_rec.ava_attribute24 :=
684: ben_ava_shd.g_old_rec.ava_attribute24;

Line 684: ben_ava_shd.g_old_rec.ava_attribute24;

680: ben_ava_shd.g_old_rec.ava_attribute23;
681: End If;
682: If (p_rec.ava_attribute24 = hr_api.g_varchar2) then
683: p_rec.ava_attribute24 :=
684: ben_ava_shd.g_old_rec.ava_attribute24;
685: End If;
686: If (p_rec.ava_attribute25 = hr_api.g_varchar2) then
687: p_rec.ava_attribute25 :=
688: ben_ava_shd.g_old_rec.ava_attribute25;

Line 688: ben_ava_shd.g_old_rec.ava_attribute25;

684: ben_ava_shd.g_old_rec.ava_attribute24;
685: End If;
686: If (p_rec.ava_attribute25 = hr_api.g_varchar2) then
687: p_rec.ava_attribute25 :=
688: ben_ava_shd.g_old_rec.ava_attribute25;
689: End If;
690: If (p_rec.ava_attribute26 = hr_api.g_varchar2) then
691: p_rec.ava_attribute26 :=
692: ben_ava_shd.g_old_rec.ava_attribute26;

Line 692: ben_ava_shd.g_old_rec.ava_attribute26;

688: ben_ava_shd.g_old_rec.ava_attribute25;
689: End If;
690: If (p_rec.ava_attribute26 = hr_api.g_varchar2) then
691: p_rec.ava_attribute26 :=
692: ben_ava_shd.g_old_rec.ava_attribute26;
693: End If;
694: If (p_rec.ava_attribute27 = hr_api.g_varchar2) then
695: p_rec.ava_attribute27 :=
696: ben_ava_shd.g_old_rec.ava_attribute27;

Line 696: ben_ava_shd.g_old_rec.ava_attribute27;

692: ben_ava_shd.g_old_rec.ava_attribute26;
693: End If;
694: If (p_rec.ava_attribute27 = hr_api.g_varchar2) then
695: p_rec.ava_attribute27 :=
696: ben_ava_shd.g_old_rec.ava_attribute27;
697: End If;
698: If (p_rec.ava_attribute28 = hr_api.g_varchar2) then
699: p_rec.ava_attribute28 :=
700: ben_ava_shd.g_old_rec.ava_attribute28;

Line 700: ben_ava_shd.g_old_rec.ava_attribute28;

696: ben_ava_shd.g_old_rec.ava_attribute27;
697: End If;
698: If (p_rec.ava_attribute28 = hr_api.g_varchar2) then
699: p_rec.ava_attribute28 :=
700: ben_ava_shd.g_old_rec.ava_attribute28;
701: End If;
702: If (p_rec.ava_attribute29 = hr_api.g_varchar2) then
703: p_rec.ava_attribute29 :=
704: ben_ava_shd.g_old_rec.ava_attribute29;

Line 704: ben_ava_shd.g_old_rec.ava_attribute29;

700: ben_ava_shd.g_old_rec.ava_attribute28;
701: End If;
702: If (p_rec.ava_attribute29 = hr_api.g_varchar2) then
703: p_rec.ava_attribute29 :=
704: ben_ava_shd.g_old_rec.ava_attribute29;
705: End If;
706: If (p_rec.ava_attribute30 = hr_api.g_varchar2) then
707: p_rec.ava_attribute30 :=
708: ben_ava_shd.g_old_rec.ava_attribute30;

Line 708: ben_ava_shd.g_old_rec.ava_attribute30;

704: ben_ava_shd.g_old_rec.ava_attribute29;
705: End If;
706: If (p_rec.ava_attribute30 = hr_api.g_varchar2) then
707: p_rec.ava_attribute30 :=
708: ben_ava_shd.g_old_rec.ava_attribute30;
709: End If;
710:
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 721: p_rec in out nocopy ben_ava_shd.g_rec_type,

717: -- |---------------------------------< upd >----------------------------------|
718: -- ----------------------------------------------------------------------------
719: Procedure upd
720: (
721: p_rec in out nocopy ben_ava_shd.g_rec_type,
722: p_effective_date in date,
723: p_datetrack_mode in varchar2
724: ) is
725: --

Line 739: ben_ava_shd.lck

735: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
736: --
737: -- We must lock the row which we need to update.
738: --
739: ben_ava_shd.lck
740: (p_effective_date => p_effective_date,
741: p_datetrack_mode => p_datetrack_mode,
742: p_actl_prem_vrbl_rt_rl_id => p_rec.actl_prem_vrbl_rt_rl_id,
743: p_object_version_number => p_rec.object_version_number,

Line 838: l_rec ben_ava_shd.g_rec_type;

834: p_effective_date in date,
835: p_datetrack_mode in varchar2
836: ) is
837: --
838: l_rec ben_ava_shd.g_rec_type;
839: l_proc varchar2(72) := g_package||'upd';
840: --
841: Begin
842: hr_utility.set_location('Entering:'||l_proc, 5);

Line 848: ben_ava_shd.convert_args

844: -- Call conversion function to turn arguments into the
845: -- l_rec structure.
846: --
847: l_rec :=
848: ben_ava_shd.convert_args
849: (
850: p_actl_prem_vrbl_rt_rl_id,
851: null,
852: null,