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_OPT_UPD dependencies on BEN_OPT_SHD

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

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

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

Line 139: ben_opt_shd.g_api_dml := false; -- Unset the api dml status

135: where opt_id = p_rec.opt_id
136: and effective_start_date = p_validation_start_date
137: and effective_end_date = p_validation_end_date;
138: --
139: ben_opt_shd.g_api_dml := false; -- Unset the api dml status
140: --
141: -- Set the effective start and end dates
142: --
143: p_rec.effective_start_date := p_validation_start_date;

Line 151: ben_opt_shd.g_api_dml := false; -- Unset the api dml status

147: hr_utility.set_location(' Leaving:'||l_proc, 15);
148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: ben_opt_shd.g_api_dml := false; -- Unset the api dml status
152: ben_opt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated

Line 152: ben_opt_shd.constraint_error

148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: ben_opt_shd.g_api_dml := false; -- Unset the api dml status
152: ben_opt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_opt_shd.g_api_dml := false; -- Unset the api dml status

Line 156: ben_opt_shd.g_api_dml := false; -- Unset the api dml status

152: ben_opt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_opt_shd.g_api_dml := false; -- Unset the api dml status
157: ben_opt_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_opt_shd.g_api_dml := false; -- Unset the api dml status

Line 157: ben_opt_shd.constraint_error

153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_opt_shd.g_api_dml := false; -- Unset the api dml status
157: ben_opt_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_opt_shd.g_api_dml := false; -- Unset the api dml status
161: Raise;

Line 160: ben_opt_shd.g_api_dml := false; -- Unset the api dml status

156: ben_opt_shd.g_api_dml := false; -- Unset the api dml status
157: ben_opt_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_opt_shd.g_api_dml := false; -- Unset the api dml status
161: Raise;
162: End dt_update_dml;
163: --
164: -- ----------------------------------------------------------------------------

Line 196: (p_rec in out nocopy ben_opt_shd.g_rec_type,

192: --
193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure update_dml
196: (p_rec in out nocopy ben_opt_shd.g_rec_type,
197: p_effective_date in date,
198: p_datetrack_mode in varchar2,
199: p_validation_start_date in date,
200: p_validation_end_date in date) is

Line 260: (p_rec in out nocopy ben_opt_shd.g_rec_type,

256: --
257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure dt_pre_update
260: (p_rec in out nocopy ben_opt_shd.g_rec_type,
261: p_effective_date in date,
262: p_datetrack_mode in varchar2,
263: p_validation_start_date in date,
264: p_validation_end_date in date) is

Line 276: ben_opt_shd.upd_effective_end_date

272: hr_utility.set_location(l_proc, 10);
273: --
274: -- Update the current effective end date
275: --
276: ben_opt_shd.upd_effective_end_date
277: (p_effective_date => p_effective_date,
278: p_base_key_value => p_rec.opt_id,
279: p_new_effective_end_date => (p_validation_start_date - 1),
280: p_validation_start_date => p_validation_start_date,

Line 345: (p_rec in out nocopy ben_opt_shd.g_rec_type,

341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure pre_update
345: (p_rec in out nocopy ben_opt_shd.g_rec_type,
346: p_effective_date in date,
347: p_datetrack_mode in varchar2,
348: p_validation_start_date in date,
349: p_validation_end_date in date) is

Line 401: (p_rec in ben_opt_shd.g_rec_type,

397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure post_update
401: (p_rec in ben_opt_shd.g_rec_type,
402: p_effective_date in date,
403: p_datetrack_mode in varchar2,
404: p_validation_start_date in date,
405: p_validation_end_date in date) is

Line 482: ,p_effective_start_date_o =>ben_opt_shd.g_old_rec.effective_start_date

478: ,p_effective_date =>p_effective_date
479: ,p_datetrack_mode =>p_datetrack_mode
480: ,p_validation_start_date =>p_validation_start_date
481: ,p_validation_end_date =>p_validation_end_date
482: ,p_effective_start_date_o =>ben_opt_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_opt_shd.g_old_rec.effective_end_date
484: ,p_name_o =>ben_opt_shd.g_old_rec.name
485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id
486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id

Line 483: ,p_effective_end_date_o =>ben_opt_shd.g_old_rec.effective_end_date

479: ,p_datetrack_mode =>p_datetrack_mode
480: ,p_validation_start_date =>p_validation_start_date
481: ,p_validation_end_date =>p_validation_end_date
482: ,p_effective_start_date_o =>ben_opt_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_opt_shd.g_old_rec.effective_end_date
484: ,p_name_o =>ben_opt_shd.g_old_rec.name
485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id
486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id
487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category

Line 484: ,p_name_o =>ben_opt_shd.g_old_rec.name

480: ,p_validation_start_date =>p_validation_start_date
481: ,p_validation_end_date =>p_validation_end_date
482: ,p_effective_start_date_o =>ben_opt_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_opt_shd.g_old_rec.effective_end_date
484: ,p_name_o =>ben_opt_shd.g_old_rec.name
485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id
486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id
487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category
488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1

Line 485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id

481: ,p_validation_end_date =>p_validation_end_date
482: ,p_effective_start_date_o =>ben_opt_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_opt_shd.g_old_rec.effective_end_date
484: ,p_name_o =>ben_opt_shd.g_old_rec.name
485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id
486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id
487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category
488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1
489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2

Line 486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id

482: ,p_effective_start_date_o =>ben_opt_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_opt_shd.g_old_rec.effective_end_date
484: ,p_name_o =>ben_opt_shd.g_old_rec.name
485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id
486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id
487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category
488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1
489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2
490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3

Line 487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category

483: ,p_effective_end_date_o =>ben_opt_shd.g_old_rec.effective_end_date
484: ,p_name_o =>ben_opt_shd.g_old_rec.name
485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id
486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id
487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category
488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1
489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2
490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3
491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4

Line 488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1

484: ,p_name_o =>ben_opt_shd.g_old_rec.name
485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id
486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id
487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category
488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1
489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2
490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3
491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4
492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5

Line 489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2

485: ,p_cmbn_ptip_opt_id_o =>ben_opt_shd.g_old_rec.cmbn_ptip_opt_id
486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id
487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category
488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1
489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2
490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3
491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4
492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5
493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6

Line 490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3

486: ,p_business_group_id_o =>ben_opt_shd.g_old_rec.business_group_id
487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category
488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1
489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2
490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3
491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4
492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5
493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6
494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7

Line 491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4

487: ,p_opt_attribute_category_o =>ben_opt_shd.g_old_rec.opt_attribute_category
488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1
489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2
490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3
491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4
492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5
493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6
494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7
495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8

Line 492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5

488: ,p_opt_attribute1_o =>ben_opt_shd.g_old_rec.opt_attribute1
489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2
490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3
491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4
492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5
493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6
494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7
495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8
496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9

Line 493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6

489: ,p_opt_attribute2_o =>ben_opt_shd.g_old_rec.opt_attribute2
490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3
491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4
492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5
493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6
494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7
495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8
496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9
497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10

Line 494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7

490: ,p_opt_attribute3_o =>ben_opt_shd.g_old_rec.opt_attribute3
491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4
492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5
493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6
494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7
495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8
496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9
497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10
498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11

Line 495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8

491: ,p_opt_attribute4_o =>ben_opt_shd.g_old_rec.opt_attribute4
492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5
493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6
494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7
495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8
496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9
497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10
498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11
499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12

Line 496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9

492: ,p_opt_attribute5_o =>ben_opt_shd.g_old_rec.opt_attribute5
493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6
494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7
495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8
496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9
497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10
498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11
499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12
500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13

Line 497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10

493: ,p_opt_attribute6_o =>ben_opt_shd.g_old_rec.opt_attribute6
494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7
495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8
496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9
497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10
498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11
499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12
500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13
501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14

Line 498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11

494: ,p_opt_attribute7_o =>ben_opt_shd.g_old_rec.opt_attribute7
495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8
496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9
497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10
498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11
499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12
500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13
501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14
502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15

Line 499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12

495: ,p_opt_attribute8_o =>ben_opt_shd.g_old_rec.opt_attribute8
496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9
497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10
498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11
499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12
500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13
501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14
502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15
503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16

Line 500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13

496: ,p_opt_attribute9_o =>ben_opt_shd.g_old_rec.opt_attribute9
497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10
498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11
499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12
500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13
501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14
502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15
503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16
504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17

Line 501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14

497: ,p_opt_attribute10_o =>ben_opt_shd.g_old_rec.opt_attribute10
498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11
499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12
500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13
501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14
502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15
503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16
504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17
505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18

Line 502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15

498: ,p_opt_attribute11_o =>ben_opt_shd.g_old_rec.opt_attribute11
499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12
500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13
501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14
502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15
503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16
504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17
505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18
506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19

Line 503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16

499: ,p_opt_attribute12_o =>ben_opt_shd.g_old_rec.opt_attribute12
500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13
501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14
502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15
503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16
504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17
505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18
506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19
507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20

Line 504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17

500: ,p_opt_attribute13_o =>ben_opt_shd.g_old_rec.opt_attribute13
501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14
502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15
503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16
504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17
505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18
506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19
507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20
508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21

Line 505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18

501: ,p_opt_attribute14_o =>ben_opt_shd.g_old_rec.opt_attribute14
502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15
503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16
504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17
505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18
506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19
507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20
508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21
509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22

Line 506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19

502: ,p_opt_attribute15_o =>ben_opt_shd.g_old_rec.opt_attribute15
503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16
504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17
505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18
506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19
507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20
508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21
509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22
510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23

Line 507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20

503: ,p_opt_attribute16_o =>ben_opt_shd.g_old_rec.opt_attribute16
504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17
505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18
506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19
507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20
508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21
509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22
510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23
511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24

Line 508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21

504: ,p_opt_attribute17_o =>ben_opt_shd.g_old_rec.opt_attribute17
505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18
506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19
507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20
508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21
509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22
510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23
511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24
512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25

Line 509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22

505: ,p_opt_attribute18_o =>ben_opt_shd.g_old_rec.opt_attribute18
506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19
507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20
508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21
509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22
510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23
511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24
512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25
513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26

Line 510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23

506: ,p_opt_attribute19_o =>ben_opt_shd.g_old_rec.opt_attribute19
507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20
508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21
509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22
510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23
511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24
512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25
513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26
514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27

Line 511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24

507: ,p_opt_attribute20_o =>ben_opt_shd.g_old_rec.opt_attribute20
508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21
509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22
510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23
511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24
512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25
513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26
514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27
515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28

Line 512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25

508: ,p_opt_attribute21_o =>ben_opt_shd.g_old_rec.opt_attribute21
509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22
510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23
511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24
512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25
513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26
514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27
515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28
516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29

Line 513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26

509: ,p_opt_attribute22_o =>ben_opt_shd.g_old_rec.opt_attribute22
510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23
511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24
512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25
513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26
514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27
515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28
516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29
517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30

Line 514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27

510: ,p_opt_attribute23_o =>ben_opt_shd.g_old_rec.opt_attribute23
511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24
512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25
513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26
514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27
515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28
516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29
517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30
518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number

Line 515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28

511: ,p_opt_attribute24_o =>ben_opt_shd.g_old_rec.opt_attribute24
512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25
513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26
514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27
515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28
516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29
517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30
518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number
519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom

Line 516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29

512: ,p_opt_attribute25_o =>ben_opt_shd.g_old_rec.opt_attribute25
513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26
514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27
515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28
516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29
517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30
518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number
519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val

Line 517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30

513: ,p_opt_attribute26_o =>ben_opt_shd.g_old_rec.opt_attribute26
514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27
515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28
516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29
517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30
518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number
519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val
521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl

Line 518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number

514: ,p_opt_attribute27_o =>ben_opt_shd.g_old_rec.opt_attribute27
515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28
516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29
517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30
518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number
519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val
521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag

Line 519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom

515: ,p_opt_attribute28_o =>ben_opt_shd.g_old_rec.opt_attribute28
516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29
517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30
518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number
519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val
521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag
523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name

Line 520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val

516: ,p_opt_attribute29_o =>ben_opt_shd.g_old_rec.opt_attribute29
517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30
518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number
519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val
521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag
523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name
524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code

Line 521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl

517: ,p_opt_attribute30_o =>ben_opt_shd.g_old_rec.opt_attribute30
518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number
519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val
521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag
523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name
524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code
525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code

Line 522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag

518: ,p_object_version_number_o =>ben_opt_shd.g_old_rec.object_version_number
519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val
521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag
523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name
524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code
525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code
526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup

Line 523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name

519: ,p_rqd_perd_enrt_nenrt_uom_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val
521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag
523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name
524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code
525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code
526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup
527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id

Line 524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code

520: ,p_rqd_perd_enrt_nenrt_val_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val
521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag
523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name
524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code
525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code
526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup
527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id
528: ,p_component_reason_o =>ben_opt_shd.g_old_rec.component_reason

Line 525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code

521: ,p_rqd_perd_enrt_nenrt_rl_o =>ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag
523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name
524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code
525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code
526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup
527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id
528: ,p_component_reason_o =>ben_opt_shd.g_old_rec.component_reason
529: ,p_mapping_table_name_o =>ben_opt_shd.g_old_rec.mapping_table_name

Line 526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup

522: ,p_invk_wv_opt_flag_o =>ben_opt_shd.g_old_rec.invk_wv_opt_flag
523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name
524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code
525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code
526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup
527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id
528: ,p_component_reason_o =>ben_opt_shd.g_old_rec.component_reason
529: ,p_mapping_table_name_o =>ben_opt_shd.g_old_rec.mapping_table_name
530: ,p_mapping_table_pk_id_o =>ben_opt_shd.g_old_rec.mapping_table_pk_id

Line 527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id

523: ,p_short_name_o =>ben_opt_shd.g_old_rec.short_name
524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code
525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code
526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup
527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id
528: ,p_component_reason_o =>ben_opt_shd.g_old_rec.component_reason
529: ,p_mapping_table_name_o =>ben_opt_shd.g_old_rec.mapping_table_name
530: ,p_mapping_table_pk_id_o =>ben_opt_shd.g_old_rec.mapping_table_pk_id
531: );

Line 528: ,p_component_reason_o =>ben_opt_shd.g_old_rec.component_reason

524: ,p_short_code_o =>ben_opt_shd.g_old_rec.short_code
525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code
526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup
527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id
528: ,p_component_reason_o =>ben_opt_shd.g_old_rec.component_reason
529: ,p_mapping_table_name_o =>ben_opt_shd.g_old_rec.mapping_table_name
530: ,p_mapping_table_pk_id_o =>ben_opt_shd.g_old_rec.mapping_table_pk_id
531: );
532: --

Line 529: ,p_mapping_table_name_o =>ben_opt_shd.g_old_rec.mapping_table_name

525: ,p_legislation_code_o =>ben_opt_shd.g_old_rec.legislation_code
526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup
527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id
528: ,p_component_reason_o =>ben_opt_shd.g_old_rec.component_reason
529: ,p_mapping_table_name_o =>ben_opt_shd.g_old_rec.mapping_table_name
530: ,p_mapping_table_pk_id_o =>ben_opt_shd.g_old_rec.mapping_table_pk_id
531: );
532: --
533: exception

Line 530: ,p_mapping_table_pk_id_o =>ben_opt_shd.g_old_rec.mapping_table_pk_id

526: ,p_legislation_subgroup_o =>ben_opt_shd.g_old_rec.legislation_subgroup
527: ,p_group_opt_id_o =>ben_opt_shd.g_old_rec.group_opt_id
528: ,p_component_reason_o =>ben_opt_shd.g_old_rec.component_reason
529: ,p_mapping_table_name_o =>ben_opt_shd.g_old_rec.mapping_table_name
530: ,p_mapping_table_pk_id_o =>ben_opt_shd.g_old_rec.mapping_table_pk_id
531: );
532: --
533: exception
534: --

Line 592: Procedure convert_defs(p_rec in out nocopy ben_opt_shd.g_rec_type) is

588: -- Internal Row Handler Use Only.
589: --
590: -- {End Of Comments}
591: -- ----------------------------------------------------------------------------
592: Procedure convert_defs(p_rec in out nocopy ben_opt_shd.g_rec_type) is
593: --
594: l_proc varchar2(72) := g_package||'convert_defs';
595: --
596: Begin

Line 607: ben_opt_shd.g_old_rec.name;

603: -- is being used then we must set to the 'current' argument value.
604: --
605: If (p_rec.name = hr_api.g_varchar2) then
606: p_rec.name :=
607: ben_opt_shd.g_old_rec.name;
608: End If;
609: If (p_rec.cmbn_ptip_opt_id = hr_api.g_number) then
610: p_rec.cmbn_ptip_opt_id :=
611: ben_opt_shd.g_old_rec.cmbn_ptip_opt_id;

Line 611: ben_opt_shd.g_old_rec.cmbn_ptip_opt_id;

607: ben_opt_shd.g_old_rec.name;
608: End If;
609: If (p_rec.cmbn_ptip_opt_id = hr_api.g_number) then
610: p_rec.cmbn_ptip_opt_id :=
611: ben_opt_shd.g_old_rec.cmbn_ptip_opt_id;
612: End If;
613: If (p_rec.business_group_id = hr_api.g_number) then
614: p_rec.business_group_id :=
615: ben_opt_shd.g_old_rec.business_group_id;

Line 615: ben_opt_shd.g_old_rec.business_group_id;

611: ben_opt_shd.g_old_rec.cmbn_ptip_opt_id;
612: End If;
613: If (p_rec.business_group_id = hr_api.g_number) then
614: p_rec.business_group_id :=
615: ben_opt_shd.g_old_rec.business_group_id;
616: End If;
617: If (p_rec.opt_attribute_category = hr_api.g_varchar2) then
618: p_rec.opt_attribute_category :=
619: ben_opt_shd.g_old_rec.opt_attribute_category;

Line 619: ben_opt_shd.g_old_rec.opt_attribute_category;

615: ben_opt_shd.g_old_rec.business_group_id;
616: End If;
617: If (p_rec.opt_attribute_category = hr_api.g_varchar2) then
618: p_rec.opt_attribute_category :=
619: ben_opt_shd.g_old_rec.opt_attribute_category;
620: End If;
621: If (p_rec.opt_attribute1 = hr_api.g_varchar2) then
622: p_rec.opt_attribute1 :=
623: ben_opt_shd.g_old_rec.opt_attribute1;

Line 623: ben_opt_shd.g_old_rec.opt_attribute1;

619: ben_opt_shd.g_old_rec.opt_attribute_category;
620: End If;
621: If (p_rec.opt_attribute1 = hr_api.g_varchar2) then
622: p_rec.opt_attribute1 :=
623: ben_opt_shd.g_old_rec.opt_attribute1;
624: End If;
625: If (p_rec.opt_attribute2 = hr_api.g_varchar2) then
626: p_rec.opt_attribute2 :=
627: ben_opt_shd.g_old_rec.opt_attribute2;

Line 627: ben_opt_shd.g_old_rec.opt_attribute2;

623: ben_opt_shd.g_old_rec.opt_attribute1;
624: End If;
625: If (p_rec.opt_attribute2 = hr_api.g_varchar2) then
626: p_rec.opt_attribute2 :=
627: ben_opt_shd.g_old_rec.opt_attribute2;
628: End If;
629: If (p_rec.opt_attribute3 = hr_api.g_varchar2) then
630: p_rec.opt_attribute3 :=
631: ben_opt_shd.g_old_rec.opt_attribute3;

Line 631: ben_opt_shd.g_old_rec.opt_attribute3;

627: ben_opt_shd.g_old_rec.opt_attribute2;
628: End If;
629: If (p_rec.opt_attribute3 = hr_api.g_varchar2) then
630: p_rec.opt_attribute3 :=
631: ben_opt_shd.g_old_rec.opt_attribute3;
632: End If;
633: If (p_rec.opt_attribute4 = hr_api.g_varchar2) then
634: p_rec.opt_attribute4 :=
635: ben_opt_shd.g_old_rec.opt_attribute4;

Line 635: ben_opt_shd.g_old_rec.opt_attribute4;

631: ben_opt_shd.g_old_rec.opt_attribute3;
632: End If;
633: If (p_rec.opt_attribute4 = hr_api.g_varchar2) then
634: p_rec.opt_attribute4 :=
635: ben_opt_shd.g_old_rec.opt_attribute4;
636: End If;
637: If (p_rec.opt_attribute5 = hr_api.g_varchar2) then
638: p_rec.opt_attribute5 :=
639: ben_opt_shd.g_old_rec.opt_attribute5;

Line 639: ben_opt_shd.g_old_rec.opt_attribute5;

635: ben_opt_shd.g_old_rec.opt_attribute4;
636: End If;
637: If (p_rec.opt_attribute5 = hr_api.g_varchar2) then
638: p_rec.opt_attribute5 :=
639: ben_opt_shd.g_old_rec.opt_attribute5;
640: End If;
641: If (p_rec.opt_attribute6 = hr_api.g_varchar2) then
642: p_rec.opt_attribute6 :=
643: ben_opt_shd.g_old_rec.opt_attribute6;

Line 643: ben_opt_shd.g_old_rec.opt_attribute6;

639: ben_opt_shd.g_old_rec.opt_attribute5;
640: End If;
641: If (p_rec.opt_attribute6 = hr_api.g_varchar2) then
642: p_rec.opt_attribute6 :=
643: ben_opt_shd.g_old_rec.opt_attribute6;
644: End If;
645: If (p_rec.opt_attribute7 = hr_api.g_varchar2) then
646: p_rec.opt_attribute7 :=
647: ben_opt_shd.g_old_rec.opt_attribute7;

Line 647: ben_opt_shd.g_old_rec.opt_attribute7;

643: ben_opt_shd.g_old_rec.opt_attribute6;
644: End If;
645: If (p_rec.opt_attribute7 = hr_api.g_varchar2) then
646: p_rec.opt_attribute7 :=
647: ben_opt_shd.g_old_rec.opt_attribute7;
648: End If;
649: If (p_rec.opt_attribute8 = hr_api.g_varchar2) then
650: p_rec.opt_attribute8 :=
651: ben_opt_shd.g_old_rec.opt_attribute8;

Line 651: ben_opt_shd.g_old_rec.opt_attribute8;

647: ben_opt_shd.g_old_rec.opt_attribute7;
648: End If;
649: If (p_rec.opt_attribute8 = hr_api.g_varchar2) then
650: p_rec.opt_attribute8 :=
651: ben_opt_shd.g_old_rec.opt_attribute8;
652: End If;
653: If (p_rec.opt_attribute9 = hr_api.g_varchar2) then
654: p_rec.opt_attribute9 :=
655: ben_opt_shd.g_old_rec.opt_attribute9;

Line 655: ben_opt_shd.g_old_rec.opt_attribute9;

651: ben_opt_shd.g_old_rec.opt_attribute8;
652: End If;
653: If (p_rec.opt_attribute9 = hr_api.g_varchar2) then
654: p_rec.opt_attribute9 :=
655: ben_opt_shd.g_old_rec.opt_attribute9;
656: End If;
657: If (p_rec.opt_attribute10 = hr_api.g_varchar2) then
658: p_rec.opt_attribute10 :=
659: ben_opt_shd.g_old_rec.opt_attribute10;

Line 659: ben_opt_shd.g_old_rec.opt_attribute10;

655: ben_opt_shd.g_old_rec.opt_attribute9;
656: End If;
657: If (p_rec.opt_attribute10 = hr_api.g_varchar2) then
658: p_rec.opt_attribute10 :=
659: ben_opt_shd.g_old_rec.opt_attribute10;
660: End If;
661: If (p_rec.opt_attribute11 = hr_api.g_varchar2) then
662: p_rec.opt_attribute11 :=
663: ben_opt_shd.g_old_rec.opt_attribute11;

Line 663: ben_opt_shd.g_old_rec.opt_attribute11;

659: ben_opt_shd.g_old_rec.opt_attribute10;
660: End If;
661: If (p_rec.opt_attribute11 = hr_api.g_varchar2) then
662: p_rec.opt_attribute11 :=
663: ben_opt_shd.g_old_rec.opt_attribute11;
664: End If;
665: If (p_rec.opt_attribute12 = hr_api.g_varchar2) then
666: p_rec.opt_attribute12 :=
667: ben_opt_shd.g_old_rec.opt_attribute12;

Line 667: ben_opt_shd.g_old_rec.opt_attribute12;

663: ben_opt_shd.g_old_rec.opt_attribute11;
664: End If;
665: If (p_rec.opt_attribute12 = hr_api.g_varchar2) then
666: p_rec.opt_attribute12 :=
667: ben_opt_shd.g_old_rec.opt_attribute12;
668: End If;
669: If (p_rec.opt_attribute13 = hr_api.g_varchar2) then
670: p_rec.opt_attribute13 :=
671: ben_opt_shd.g_old_rec.opt_attribute13;

Line 671: ben_opt_shd.g_old_rec.opt_attribute13;

667: ben_opt_shd.g_old_rec.opt_attribute12;
668: End If;
669: If (p_rec.opt_attribute13 = hr_api.g_varchar2) then
670: p_rec.opt_attribute13 :=
671: ben_opt_shd.g_old_rec.opt_attribute13;
672: End If;
673: If (p_rec.opt_attribute14 = hr_api.g_varchar2) then
674: p_rec.opt_attribute14 :=
675: ben_opt_shd.g_old_rec.opt_attribute14;

Line 675: ben_opt_shd.g_old_rec.opt_attribute14;

671: ben_opt_shd.g_old_rec.opt_attribute13;
672: End If;
673: If (p_rec.opt_attribute14 = hr_api.g_varchar2) then
674: p_rec.opt_attribute14 :=
675: ben_opt_shd.g_old_rec.opt_attribute14;
676: End If;
677: If (p_rec.opt_attribute15 = hr_api.g_varchar2) then
678: p_rec.opt_attribute15 :=
679: ben_opt_shd.g_old_rec.opt_attribute15;

Line 679: ben_opt_shd.g_old_rec.opt_attribute15;

675: ben_opt_shd.g_old_rec.opt_attribute14;
676: End If;
677: If (p_rec.opt_attribute15 = hr_api.g_varchar2) then
678: p_rec.opt_attribute15 :=
679: ben_opt_shd.g_old_rec.opt_attribute15;
680: End If;
681: If (p_rec.opt_attribute16 = hr_api.g_varchar2) then
682: p_rec.opt_attribute16 :=
683: ben_opt_shd.g_old_rec.opt_attribute16;

Line 683: ben_opt_shd.g_old_rec.opt_attribute16;

679: ben_opt_shd.g_old_rec.opt_attribute15;
680: End If;
681: If (p_rec.opt_attribute16 = hr_api.g_varchar2) then
682: p_rec.opt_attribute16 :=
683: ben_opt_shd.g_old_rec.opt_attribute16;
684: End If;
685: If (p_rec.opt_attribute17 = hr_api.g_varchar2) then
686: p_rec.opt_attribute17 :=
687: ben_opt_shd.g_old_rec.opt_attribute17;

Line 687: ben_opt_shd.g_old_rec.opt_attribute17;

683: ben_opt_shd.g_old_rec.opt_attribute16;
684: End If;
685: If (p_rec.opt_attribute17 = hr_api.g_varchar2) then
686: p_rec.opt_attribute17 :=
687: ben_opt_shd.g_old_rec.opt_attribute17;
688: End If;
689: If (p_rec.opt_attribute18 = hr_api.g_varchar2) then
690: p_rec.opt_attribute18 :=
691: ben_opt_shd.g_old_rec.opt_attribute18;

Line 691: ben_opt_shd.g_old_rec.opt_attribute18;

687: ben_opt_shd.g_old_rec.opt_attribute17;
688: End If;
689: If (p_rec.opt_attribute18 = hr_api.g_varchar2) then
690: p_rec.opt_attribute18 :=
691: ben_opt_shd.g_old_rec.opt_attribute18;
692: End If;
693: If (p_rec.opt_attribute19 = hr_api.g_varchar2) then
694: p_rec.opt_attribute19 :=
695: ben_opt_shd.g_old_rec.opt_attribute19;

Line 695: ben_opt_shd.g_old_rec.opt_attribute19;

691: ben_opt_shd.g_old_rec.opt_attribute18;
692: End If;
693: If (p_rec.opt_attribute19 = hr_api.g_varchar2) then
694: p_rec.opt_attribute19 :=
695: ben_opt_shd.g_old_rec.opt_attribute19;
696: End If;
697: If (p_rec.opt_attribute20 = hr_api.g_varchar2) then
698: p_rec.opt_attribute20 :=
699: ben_opt_shd.g_old_rec.opt_attribute20;

Line 699: ben_opt_shd.g_old_rec.opt_attribute20;

695: ben_opt_shd.g_old_rec.opt_attribute19;
696: End If;
697: If (p_rec.opt_attribute20 = hr_api.g_varchar2) then
698: p_rec.opt_attribute20 :=
699: ben_opt_shd.g_old_rec.opt_attribute20;
700: End If;
701: If (p_rec.opt_attribute21 = hr_api.g_varchar2) then
702: p_rec.opt_attribute21 :=
703: ben_opt_shd.g_old_rec.opt_attribute21;

Line 703: ben_opt_shd.g_old_rec.opt_attribute21;

699: ben_opt_shd.g_old_rec.opt_attribute20;
700: End If;
701: If (p_rec.opt_attribute21 = hr_api.g_varchar2) then
702: p_rec.opt_attribute21 :=
703: ben_opt_shd.g_old_rec.opt_attribute21;
704: End If;
705: If (p_rec.opt_attribute22 = hr_api.g_varchar2) then
706: p_rec.opt_attribute22 :=
707: ben_opt_shd.g_old_rec.opt_attribute22;

Line 707: ben_opt_shd.g_old_rec.opt_attribute22;

703: ben_opt_shd.g_old_rec.opt_attribute21;
704: End If;
705: If (p_rec.opt_attribute22 = hr_api.g_varchar2) then
706: p_rec.opt_attribute22 :=
707: ben_opt_shd.g_old_rec.opt_attribute22;
708: End If;
709: If (p_rec.opt_attribute23 = hr_api.g_varchar2) then
710: p_rec.opt_attribute23 :=
711: ben_opt_shd.g_old_rec.opt_attribute23;

Line 711: ben_opt_shd.g_old_rec.opt_attribute23;

707: ben_opt_shd.g_old_rec.opt_attribute22;
708: End If;
709: If (p_rec.opt_attribute23 = hr_api.g_varchar2) then
710: p_rec.opt_attribute23 :=
711: ben_opt_shd.g_old_rec.opt_attribute23;
712: End If;
713: If (p_rec.opt_attribute24 = hr_api.g_varchar2) then
714: p_rec.opt_attribute24 :=
715: ben_opt_shd.g_old_rec.opt_attribute24;

Line 715: ben_opt_shd.g_old_rec.opt_attribute24;

711: ben_opt_shd.g_old_rec.opt_attribute23;
712: End If;
713: If (p_rec.opt_attribute24 = hr_api.g_varchar2) then
714: p_rec.opt_attribute24 :=
715: ben_opt_shd.g_old_rec.opt_attribute24;
716: End If;
717: If (p_rec.opt_attribute25 = hr_api.g_varchar2) then
718: p_rec.opt_attribute25 :=
719: ben_opt_shd.g_old_rec.opt_attribute25;

Line 719: ben_opt_shd.g_old_rec.opt_attribute25;

715: ben_opt_shd.g_old_rec.opt_attribute24;
716: End If;
717: If (p_rec.opt_attribute25 = hr_api.g_varchar2) then
718: p_rec.opt_attribute25 :=
719: ben_opt_shd.g_old_rec.opt_attribute25;
720: End If;
721: If (p_rec.opt_attribute26 = hr_api.g_varchar2) then
722: p_rec.opt_attribute26 :=
723: ben_opt_shd.g_old_rec.opt_attribute26;

Line 723: ben_opt_shd.g_old_rec.opt_attribute26;

719: ben_opt_shd.g_old_rec.opt_attribute25;
720: End If;
721: If (p_rec.opt_attribute26 = hr_api.g_varchar2) then
722: p_rec.opt_attribute26 :=
723: ben_opt_shd.g_old_rec.opt_attribute26;
724: End If;
725: If (p_rec.opt_attribute27 = hr_api.g_varchar2) then
726: p_rec.opt_attribute27 :=
727: ben_opt_shd.g_old_rec.opt_attribute27;

Line 727: ben_opt_shd.g_old_rec.opt_attribute27;

723: ben_opt_shd.g_old_rec.opt_attribute26;
724: End If;
725: If (p_rec.opt_attribute27 = hr_api.g_varchar2) then
726: p_rec.opt_attribute27 :=
727: ben_opt_shd.g_old_rec.opt_attribute27;
728: End If;
729: If (p_rec.opt_attribute28 = hr_api.g_varchar2) then
730: p_rec.opt_attribute28 :=
731: ben_opt_shd.g_old_rec.opt_attribute28;

Line 731: ben_opt_shd.g_old_rec.opt_attribute28;

727: ben_opt_shd.g_old_rec.opt_attribute27;
728: End If;
729: If (p_rec.opt_attribute28 = hr_api.g_varchar2) then
730: p_rec.opt_attribute28 :=
731: ben_opt_shd.g_old_rec.opt_attribute28;
732: End If;
733: If (p_rec.opt_attribute29 = hr_api.g_varchar2) then
734: p_rec.opt_attribute29 :=
735: ben_opt_shd.g_old_rec.opt_attribute29;

Line 735: ben_opt_shd.g_old_rec.opt_attribute29;

731: ben_opt_shd.g_old_rec.opt_attribute28;
732: End If;
733: If (p_rec.opt_attribute29 = hr_api.g_varchar2) then
734: p_rec.opt_attribute29 :=
735: ben_opt_shd.g_old_rec.opt_attribute29;
736: End If;
737: If (p_rec.opt_attribute30 = hr_api.g_varchar2) then
738: p_rec.opt_attribute30 :=
739: ben_opt_shd.g_old_rec.opt_attribute30;

Line 739: ben_opt_shd.g_old_rec.opt_attribute30;

735: ben_opt_shd.g_old_rec.opt_attribute29;
736: End If;
737: If (p_rec.opt_attribute30 = hr_api.g_varchar2) then
738: p_rec.opt_attribute30 :=
739: ben_opt_shd.g_old_rec.opt_attribute30;
740: End If;
741: If (p_rec.rqd_perd_enrt_nenrt_uom = hr_api.g_varchar2) then
742: p_rec.rqd_perd_enrt_nenrt_uom :=
743: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom;

Line 743: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom;

739: ben_opt_shd.g_old_rec.opt_attribute30;
740: End If;
741: If (p_rec.rqd_perd_enrt_nenrt_uom = hr_api.g_varchar2) then
742: p_rec.rqd_perd_enrt_nenrt_uom :=
743: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom;
744: End If;
745: If (p_rec.rqd_perd_enrt_nenrt_val = hr_api.g_number) then
746: p_rec.rqd_perd_enrt_nenrt_val :=
747: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val;

Line 747: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val;

743: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_uom;
744: End If;
745: If (p_rec.rqd_perd_enrt_nenrt_val = hr_api.g_number) then
746: p_rec.rqd_perd_enrt_nenrt_val :=
747: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val;
748: End If;
749: If (p_rec.rqd_perd_enrt_nenrt_rl = hr_api.g_number) then
750: p_rec.rqd_perd_enrt_nenrt_rl :=
751: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl;

Line 751: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl;

747: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_val;
748: End If;
749: If (p_rec.rqd_perd_enrt_nenrt_rl = hr_api.g_number) then
750: p_rec.rqd_perd_enrt_nenrt_rl :=
751: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl;
752: End If;
753: If (p_rec.invk_wv_opt_flag = hr_api.g_varchar2) then
754: p_rec.invk_wv_opt_flag :=
755: ben_opt_shd.g_old_rec.invk_wv_opt_flag;

Line 755: ben_opt_shd.g_old_rec.invk_wv_opt_flag;

751: ben_opt_shd.g_old_rec.rqd_perd_enrt_nenrt_rl;
752: End If;
753: If (p_rec.invk_wv_opt_flag = hr_api.g_varchar2) then
754: p_rec.invk_wv_opt_flag :=
755: ben_opt_shd.g_old_rec.invk_wv_opt_flag;
756: End If;
757: If (p_rec.short_name = hr_api.g_varchar2) then
758: p_rec.short_name :=
759: ben_opt_shd.g_old_rec.short_name;

Line 759: ben_opt_shd.g_old_rec.short_name;

755: ben_opt_shd.g_old_rec.invk_wv_opt_flag;
756: End If;
757: If (p_rec.short_name = hr_api.g_varchar2) then
758: p_rec.short_name :=
759: ben_opt_shd.g_old_rec.short_name;
760: End If;
761: If (p_rec.short_code = hr_api.g_varchar2) then
762: p_rec.short_code :=
763: ben_opt_shd.g_old_rec.short_code;

Line 763: ben_opt_shd.g_old_rec.short_code;

759: ben_opt_shd.g_old_rec.short_name;
760: End If;
761: If (p_rec.short_code = hr_api.g_varchar2) then
762: p_rec.short_code :=
763: ben_opt_shd.g_old_rec.short_code;
764: End If;
765:
766: If (p_rec.legislation_code = hr_api.g_varchar2) then
767: p_rec.legislation_code :=

Line 768: ben_opt_shd.g_old_rec.legislation_code;

764: End If;
765:
766: If (p_rec.legislation_code = hr_api.g_varchar2) then
767: p_rec.legislation_code :=
768: ben_opt_shd.g_old_rec.legislation_code;
769: End If;
770: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
771: p_rec.legislation_subgroup :=
772: ben_opt_shd.g_old_rec.legislation_subgroup;

Line 772: ben_opt_shd.g_old_rec.legislation_subgroup;

768: ben_opt_shd.g_old_rec.legislation_code;
769: End If;
770: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
771: p_rec.legislation_subgroup :=
772: ben_opt_shd.g_old_rec.legislation_subgroup;
773: End If;
774:
775: If (p_rec.group_opt_id = hr_api.g_number) then
776: p_rec.group_opt_id :=

Line 777: ben_opt_shd.g_old_rec.group_opt_id;

773: End If;
774:
775: If (p_rec.group_opt_id = hr_api.g_number) then
776: p_rec.group_opt_id :=
777: ben_opt_shd.g_old_rec.group_opt_id;
778: End If;
779:
780: If (p_rec.component_reason = hr_api.g_varchar2) then
781: p_rec.component_reason :=

Line 782: ben_opt_shd.g_old_rec.component_reason;

778: End If;
779:
780: If (p_rec.component_reason = hr_api.g_varchar2) then
781: p_rec.component_reason :=
782: ben_opt_shd.g_old_rec.component_reason;
783: End If;
784: If (p_rec.mapping_table_name = hr_api.g_varchar2) then
785: p_rec.mapping_table_name :=
786: ben_opt_shd.g_old_rec.mapping_table_name;

Line 786: ben_opt_shd.g_old_rec.mapping_table_name;

782: ben_opt_shd.g_old_rec.component_reason;
783: End If;
784: If (p_rec.mapping_table_name = hr_api.g_varchar2) then
785: p_rec.mapping_table_name :=
786: ben_opt_shd.g_old_rec.mapping_table_name;
787: End If;
788: If (p_rec.mapping_table_pk_id = hr_api.g_number) then
789: p_rec.mapping_table_pk_id :=
790: ben_opt_shd.g_old_rec.mapping_table_pk_id;

Line 790: ben_opt_shd.g_old_rec.mapping_table_pk_id;

786: ben_opt_shd.g_old_rec.mapping_table_name;
787: End If;
788: If (p_rec.mapping_table_pk_id = hr_api.g_number) then
789: p_rec.mapping_table_pk_id :=
790: ben_opt_shd.g_old_rec.mapping_table_pk_id;
791: End If;
792:
793: --
794: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 803: p_rec in out nocopy ben_opt_shd.g_rec_type,

799: -- |---------------------------------< upd >----------------------------------|
800: -- ----------------------------------------------------------------------------
801: Procedure upd
802: (
803: p_rec in out nocopy ben_opt_shd.g_rec_type,
804: p_effective_date in date,
805: p_datetrack_mode in varchar2
806: ) is
807: --

Line 821: ben_opt_shd.lck

817: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
818: --
819: -- We must lock the row which we need to update.
820: --
821: ben_opt_shd.lck
822: (p_effective_date => p_effective_date,
823: p_datetrack_mode => p_datetrack_mode,
824: p_opt_id => p_rec.opt_id,
825: p_object_version_number => p_rec.object_version_number,

Line 930: l_rec ben_opt_shd.g_rec_type;

926: p_effective_date in date,
927: p_datetrack_mode in varchar2
928: ) is
929: --
930: l_rec ben_opt_shd.g_rec_type;
931: l_proc varchar2(72) := g_package||'upd';
932: --
933: Begin
934: hr_utility.set_location('Entering:'||l_proc, 5);

Line 940: ben_opt_shd.convert_args

936: -- Call conversion function to turn arguments into the
937: -- l_rec structure.
938: --
939: l_rec :=
940: ben_opt_shd.convert_args
941: (
942: p_opt_id,
943: null,
944: null,