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_OMR_UPD dependencies on BEN_OMR_SHD

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

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

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

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

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

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

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

Line 141: ben_omr_shd.constraint_error

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

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

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

Line 146: ben_omr_shd.constraint_error

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

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

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

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

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

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

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

Line 265: ben_omr_shd.upd_effective_end_date

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

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

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

Line 390: (p_rec in ben_omr_shd.g_rec_type,

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

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

447: ,p_effective_date =>p_effective_date
448: ,p_datetrack_mode =>p_datetrack_mode
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
453: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id

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

448: ,p_datetrack_mode =>p_datetrack_mode
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
453: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id

Line 453: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag

449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
453: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category

Line 454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag

450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
453: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1

Line 455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id

451: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
453: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2

Line 456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id

452: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
453: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3

Line 457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category

453: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4

Line 458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1

454: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5

Line 459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2

455: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6

Line 460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3

456: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7

Line 461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4

457: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8

Line 462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5

458: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9

Line 463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6

459: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10

Line 464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7

460: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11

Line 465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8

461: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12

Line 466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9

462: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13

Line 467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10

463: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14

Line 468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11

464: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15

Line 469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12

465: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16

Line 470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13

466: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17

Line 471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14

467: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18

Line 472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15

468: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19

Line 473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16

469: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20

Line 474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17

470: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21

Line 475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18

471: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22

Line 476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19

472: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23

Line 477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20

473: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24

Line 478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21

474: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25

Line 479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22

475: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26

Line 480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23

476: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27

Line 481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24

477: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28

Line 482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25

478: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
486: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29

Line 483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26

479: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
486: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
487: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30

Line 484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27

480: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
486: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
487: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
488: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number

Line 485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28

481: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
486: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
487: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
488: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number
489: );

Line 486: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29

482: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
486: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
487: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
488: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number
489: );
490: --

Line 487: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30

483: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
486: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
487: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
488: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number
489: );
490: --
491: exception

Line 488: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number

484: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
485: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
486: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
487: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
488: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number
489: );
490: --
491: exception
492: --

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

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

Line 565: ben_omr_shd.g_old_rec.optd_mdcr_flag;

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

Line 569: ben_omr_shd.g_old_rec.exlcd_flag;

565: ben_omr_shd.g_old_rec.optd_mdcr_flag;
566: End If;
567: If (p_rec.exlcd_flag = hr_api.g_varchar2) then
568: p_rec.exlcd_flag :=
569: ben_omr_shd.g_old_rec.exlcd_flag;
570: End If;
571: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
572: p_rec.vrbl_rt_prfl_id :=
573: ben_omr_shd.g_old_rec.vrbl_rt_prfl_id;

Line 573: ben_omr_shd.g_old_rec.vrbl_rt_prfl_id;

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

Line 577: ben_omr_shd.g_old_rec.business_group_id;

573: ben_omr_shd.g_old_rec.vrbl_rt_prfl_id;
574: End If;
575: If (p_rec.business_group_id = hr_api.g_number) then
576: p_rec.business_group_id :=
577: ben_omr_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.omr_attribute_category = hr_api.g_varchar2) then
580: p_rec.omr_attribute_category :=
581: ben_omr_shd.g_old_rec.omr_attribute_category;

Line 581: ben_omr_shd.g_old_rec.omr_attribute_category;

577: ben_omr_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.omr_attribute_category = hr_api.g_varchar2) then
580: p_rec.omr_attribute_category :=
581: ben_omr_shd.g_old_rec.omr_attribute_category;
582: End If;
583: If (p_rec.omr_attribute1 = hr_api.g_varchar2) then
584: p_rec.omr_attribute1 :=
585: ben_omr_shd.g_old_rec.omr_attribute1;

Line 585: ben_omr_shd.g_old_rec.omr_attribute1;

581: ben_omr_shd.g_old_rec.omr_attribute_category;
582: End If;
583: If (p_rec.omr_attribute1 = hr_api.g_varchar2) then
584: p_rec.omr_attribute1 :=
585: ben_omr_shd.g_old_rec.omr_attribute1;
586: End If;
587: If (p_rec.omr_attribute2 = hr_api.g_varchar2) then
588: p_rec.omr_attribute2 :=
589: ben_omr_shd.g_old_rec.omr_attribute2;

Line 589: ben_omr_shd.g_old_rec.omr_attribute2;

585: ben_omr_shd.g_old_rec.omr_attribute1;
586: End If;
587: If (p_rec.omr_attribute2 = hr_api.g_varchar2) then
588: p_rec.omr_attribute2 :=
589: ben_omr_shd.g_old_rec.omr_attribute2;
590: End If;
591: If (p_rec.omr_attribute3 = hr_api.g_varchar2) then
592: p_rec.omr_attribute3 :=
593: ben_omr_shd.g_old_rec.omr_attribute3;

Line 593: ben_omr_shd.g_old_rec.omr_attribute3;

589: ben_omr_shd.g_old_rec.omr_attribute2;
590: End If;
591: If (p_rec.omr_attribute3 = hr_api.g_varchar2) then
592: p_rec.omr_attribute3 :=
593: ben_omr_shd.g_old_rec.omr_attribute3;
594: End If;
595: If (p_rec.omr_attribute4 = hr_api.g_varchar2) then
596: p_rec.omr_attribute4 :=
597: ben_omr_shd.g_old_rec.omr_attribute4;

Line 597: ben_omr_shd.g_old_rec.omr_attribute4;

593: ben_omr_shd.g_old_rec.omr_attribute3;
594: End If;
595: If (p_rec.omr_attribute4 = hr_api.g_varchar2) then
596: p_rec.omr_attribute4 :=
597: ben_omr_shd.g_old_rec.omr_attribute4;
598: End If;
599: If (p_rec.omr_attribute5 = hr_api.g_varchar2) then
600: p_rec.omr_attribute5 :=
601: ben_omr_shd.g_old_rec.omr_attribute5;

Line 601: ben_omr_shd.g_old_rec.omr_attribute5;

597: ben_omr_shd.g_old_rec.omr_attribute4;
598: End If;
599: If (p_rec.omr_attribute5 = hr_api.g_varchar2) then
600: p_rec.omr_attribute5 :=
601: ben_omr_shd.g_old_rec.omr_attribute5;
602: End If;
603: If (p_rec.omr_attribute6 = hr_api.g_varchar2) then
604: p_rec.omr_attribute6 :=
605: ben_omr_shd.g_old_rec.omr_attribute6;

Line 605: ben_omr_shd.g_old_rec.omr_attribute6;

601: ben_omr_shd.g_old_rec.omr_attribute5;
602: End If;
603: If (p_rec.omr_attribute6 = hr_api.g_varchar2) then
604: p_rec.omr_attribute6 :=
605: ben_omr_shd.g_old_rec.omr_attribute6;
606: End If;
607: If (p_rec.omr_attribute7 = hr_api.g_varchar2) then
608: p_rec.omr_attribute7 :=
609: ben_omr_shd.g_old_rec.omr_attribute7;

Line 609: ben_omr_shd.g_old_rec.omr_attribute7;

605: ben_omr_shd.g_old_rec.omr_attribute6;
606: End If;
607: If (p_rec.omr_attribute7 = hr_api.g_varchar2) then
608: p_rec.omr_attribute7 :=
609: ben_omr_shd.g_old_rec.omr_attribute7;
610: End If;
611: If (p_rec.omr_attribute8 = hr_api.g_varchar2) then
612: p_rec.omr_attribute8 :=
613: ben_omr_shd.g_old_rec.omr_attribute8;

Line 613: ben_omr_shd.g_old_rec.omr_attribute8;

609: ben_omr_shd.g_old_rec.omr_attribute7;
610: End If;
611: If (p_rec.omr_attribute8 = hr_api.g_varchar2) then
612: p_rec.omr_attribute8 :=
613: ben_omr_shd.g_old_rec.omr_attribute8;
614: End If;
615: If (p_rec.omr_attribute9 = hr_api.g_varchar2) then
616: p_rec.omr_attribute9 :=
617: ben_omr_shd.g_old_rec.omr_attribute9;

Line 617: ben_omr_shd.g_old_rec.omr_attribute9;

613: ben_omr_shd.g_old_rec.omr_attribute8;
614: End If;
615: If (p_rec.omr_attribute9 = hr_api.g_varchar2) then
616: p_rec.omr_attribute9 :=
617: ben_omr_shd.g_old_rec.omr_attribute9;
618: End If;
619: If (p_rec.omr_attribute10 = hr_api.g_varchar2) then
620: p_rec.omr_attribute10 :=
621: ben_omr_shd.g_old_rec.omr_attribute10;

Line 621: ben_omr_shd.g_old_rec.omr_attribute10;

617: ben_omr_shd.g_old_rec.omr_attribute9;
618: End If;
619: If (p_rec.omr_attribute10 = hr_api.g_varchar2) then
620: p_rec.omr_attribute10 :=
621: ben_omr_shd.g_old_rec.omr_attribute10;
622: End If;
623: If (p_rec.omr_attribute11 = hr_api.g_varchar2) then
624: p_rec.omr_attribute11 :=
625: ben_omr_shd.g_old_rec.omr_attribute11;

Line 625: ben_omr_shd.g_old_rec.omr_attribute11;

621: ben_omr_shd.g_old_rec.omr_attribute10;
622: End If;
623: If (p_rec.omr_attribute11 = hr_api.g_varchar2) then
624: p_rec.omr_attribute11 :=
625: ben_omr_shd.g_old_rec.omr_attribute11;
626: End If;
627: If (p_rec.omr_attribute12 = hr_api.g_varchar2) then
628: p_rec.omr_attribute12 :=
629: ben_omr_shd.g_old_rec.omr_attribute12;

Line 629: ben_omr_shd.g_old_rec.omr_attribute12;

625: ben_omr_shd.g_old_rec.omr_attribute11;
626: End If;
627: If (p_rec.omr_attribute12 = hr_api.g_varchar2) then
628: p_rec.omr_attribute12 :=
629: ben_omr_shd.g_old_rec.omr_attribute12;
630: End If;
631: If (p_rec.omr_attribute13 = hr_api.g_varchar2) then
632: p_rec.omr_attribute13 :=
633: ben_omr_shd.g_old_rec.omr_attribute13;

Line 633: ben_omr_shd.g_old_rec.omr_attribute13;

629: ben_omr_shd.g_old_rec.omr_attribute12;
630: End If;
631: If (p_rec.omr_attribute13 = hr_api.g_varchar2) then
632: p_rec.omr_attribute13 :=
633: ben_omr_shd.g_old_rec.omr_attribute13;
634: End If;
635: If (p_rec.omr_attribute14 = hr_api.g_varchar2) then
636: p_rec.omr_attribute14 :=
637: ben_omr_shd.g_old_rec.omr_attribute14;

Line 637: ben_omr_shd.g_old_rec.omr_attribute14;

633: ben_omr_shd.g_old_rec.omr_attribute13;
634: End If;
635: If (p_rec.omr_attribute14 = hr_api.g_varchar2) then
636: p_rec.omr_attribute14 :=
637: ben_omr_shd.g_old_rec.omr_attribute14;
638: End If;
639: If (p_rec.omr_attribute15 = hr_api.g_varchar2) then
640: p_rec.omr_attribute15 :=
641: ben_omr_shd.g_old_rec.omr_attribute15;

Line 641: ben_omr_shd.g_old_rec.omr_attribute15;

637: ben_omr_shd.g_old_rec.omr_attribute14;
638: End If;
639: If (p_rec.omr_attribute15 = hr_api.g_varchar2) then
640: p_rec.omr_attribute15 :=
641: ben_omr_shd.g_old_rec.omr_attribute15;
642: End If;
643: If (p_rec.omr_attribute16 = hr_api.g_varchar2) then
644: p_rec.omr_attribute16 :=
645: ben_omr_shd.g_old_rec.omr_attribute16;

Line 645: ben_omr_shd.g_old_rec.omr_attribute16;

641: ben_omr_shd.g_old_rec.omr_attribute15;
642: End If;
643: If (p_rec.omr_attribute16 = hr_api.g_varchar2) then
644: p_rec.omr_attribute16 :=
645: ben_omr_shd.g_old_rec.omr_attribute16;
646: End If;
647: If (p_rec.omr_attribute17 = hr_api.g_varchar2) then
648: p_rec.omr_attribute17 :=
649: ben_omr_shd.g_old_rec.omr_attribute17;

Line 649: ben_omr_shd.g_old_rec.omr_attribute17;

645: ben_omr_shd.g_old_rec.omr_attribute16;
646: End If;
647: If (p_rec.omr_attribute17 = hr_api.g_varchar2) then
648: p_rec.omr_attribute17 :=
649: ben_omr_shd.g_old_rec.omr_attribute17;
650: End If;
651: If (p_rec.omr_attribute18 = hr_api.g_varchar2) then
652: p_rec.omr_attribute18 :=
653: ben_omr_shd.g_old_rec.omr_attribute18;

Line 653: ben_omr_shd.g_old_rec.omr_attribute18;

649: ben_omr_shd.g_old_rec.omr_attribute17;
650: End If;
651: If (p_rec.omr_attribute18 = hr_api.g_varchar2) then
652: p_rec.omr_attribute18 :=
653: ben_omr_shd.g_old_rec.omr_attribute18;
654: End If;
655: If (p_rec.omr_attribute19 = hr_api.g_varchar2) then
656: p_rec.omr_attribute19 :=
657: ben_omr_shd.g_old_rec.omr_attribute19;

Line 657: ben_omr_shd.g_old_rec.omr_attribute19;

653: ben_omr_shd.g_old_rec.omr_attribute18;
654: End If;
655: If (p_rec.omr_attribute19 = hr_api.g_varchar2) then
656: p_rec.omr_attribute19 :=
657: ben_omr_shd.g_old_rec.omr_attribute19;
658: End If;
659: If (p_rec.omr_attribute20 = hr_api.g_varchar2) then
660: p_rec.omr_attribute20 :=
661: ben_omr_shd.g_old_rec.omr_attribute20;

Line 661: ben_omr_shd.g_old_rec.omr_attribute20;

657: ben_omr_shd.g_old_rec.omr_attribute19;
658: End If;
659: If (p_rec.omr_attribute20 = hr_api.g_varchar2) then
660: p_rec.omr_attribute20 :=
661: ben_omr_shd.g_old_rec.omr_attribute20;
662: End If;
663: If (p_rec.omr_attribute21 = hr_api.g_varchar2) then
664: p_rec.omr_attribute21 :=
665: ben_omr_shd.g_old_rec.omr_attribute21;

Line 665: ben_omr_shd.g_old_rec.omr_attribute21;

661: ben_omr_shd.g_old_rec.omr_attribute20;
662: End If;
663: If (p_rec.omr_attribute21 = hr_api.g_varchar2) then
664: p_rec.omr_attribute21 :=
665: ben_omr_shd.g_old_rec.omr_attribute21;
666: End If;
667: If (p_rec.omr_attribute22 = hr_api.g_varchar2) then
668: p_rec.omr_attribute22 :=
669: ben_omr_shd.g_old_rec.omr_attribute22;

Line 669: ben_omr_shd.g_old_rec.omr_attribute22;

665: ben_omr_shd.g_old_rec.omr_attribute21;
666: End If;
667: If (p_rec.omr_attribute22 = hr_api.g_varchar2) then
668: p_rec.omr_attribute22 :=
669: ben_omr_shd.g_old_rec.omr_attribute22;
670: End If;
671: If (p_rec.omr_attribute23 = hr_api.g_varchar2) then
672: p_rec.omr_attribute23 :=
673: ben_omr_shd.g_old_rec.omr_attribute23;

Line 673: ben_omr_shd.g_old_rec.omr_attribute23;

669: ben_omr_shd.g_old_rec.omr_attribute22;
670: End If;
671: If (p_rec.omr_attribute23 = hr_api.g_varchar2) then
672: p_rec.omr_attribute23 :=
673: ben_omr_shd.g_old_rec.omr_attribute23;
674: End If;
675: If (p_rec.omr_attribute24 = hr_api.g_varchar2) then
676: p_rec.omr_attribute24 :=
677: ben_omr_shd.g_old_rec.omr_attribute24;

Line 677: ben_omr_shd.g_old_rec.omr_attribute24;

673: ben_omr_shd.g_old_rec.omr_attribute23;
674: End If;
675: If (p_rec.omr_attribute24 = hr_api.g_varchar2) then
676: p_rec.omr_attribute24 :=
677: ben_omr_shd.g_old_rec.omr_attribute24;
678: End If;
679: If (p_rec.omr_attribute25 = hr_api.g_varchar2) then
680: p_rec.omr_attribute25 :=
681: ben_omr_shd.g_old_rec.omr_attribute25;

Line 681: ben_omr_shd.g_old_rec.omr_attribute25;

677: ben_omr_shd.g_old_rec.omr_attribute24;
678: End If;
679: If (p_rec.omr_attribute25 = hr_api.g_varchar2) then
680: p_rec.omr_attribute25 :=
681: ben_omr_shd.g_old_rec.omr_attribute25;
682: End If;
683: If (p_rec.omr_attribute26 = hr_api.g_varchar2) then
684: p_rec.omr_attribute26 :=
685: ben_omr_shd.g_old_rec.omr_attribute26;

Line 685: ben_omr_shd.g_old_rec.omr_attribute26;

681: ben_omr_shd.g_old_rec.omr_attribute25;
682: End If;
683: If (p_rec.omr_attribute26 = hr_api.g_varchar2) then
684: p_rec.omr_attribute26 :=
685: ben_omr_shd.g_old_rec.omr_attribute26;
686: End If;
687: If (p_rec.omr_attribute27 = hr_api.g_varchar2) then
688: p_rec.omr_attribute27 :=
689: ben_omr_shd.g_old_rec.omr_attribute27;

Line 689: ben_omr_shd.g_old_rec.omr_attribute27;

685: ben_omr_shd.g_old_rec.omr_attribute26;
686: End If;
687: If (p_rec.omr_attribute27 = hr_api.g_varchar2) then
688: p_rec.omr_attribute27 :=
689: ben_omr_shd.g_old_rec.omr_attribute27;
690: End If;
691: If (p_rec.omr_attribute28 = hr_api.g_varchar2) then
692: p_rec.omr_attribute28 :=
693: ben_omr_shd.g_old_rec.omr_attribute28;

Line 693: ben_omr_shd.g_old_rec.omr_attribute28;

689: ben_omr_shd.g_old_rec.omr_attribute27;
690: End If;
691: If (p_rec.omr_attribute28 = hr_api.g_varchar2) then
692: p_rec.omr_attribute28 :=
693: ben_omr_shd.g_old_rec.omr_attribute28;
694: End If;
695: If (p_rec.omr_attribute29 = hr_api.g_varchar2) then
696: p_rec.omr_attribute29 :=
697: ben_omr_shd.g_old_rec.omr_attribute29;

Line 697: ben_omr_shd.g_old_rec.omr_attribute29;

693: ben_omr_shd.g_old_rec.omr_attribute28;
694: End If;
695: If (p_rec.omr_attribute29 = hr_api.g_varchar2) then
696: p_rec.omr_attribute29 :=
697: ben_omr_shd.g_old_rec.omr_attribute29;
698: End If;
699: If (p_rec.omr_attribute30 = hr_api.g_varchar2) then
700: p_rec.omr_attribute30 :=
701: ben_omr_shd.g_old_rec.omr_attribute30;

Line 701: ben_omr_shd.g_old_rec.omr_attribute30;

697: ben_omr_shd.g_old_rec.omr_attribute29;
698: End If;
699: If (p_rec.omr_attribute30 = hr_api.g_varchar2) then
700: p_rec.omr_attribute30 :=
701: ben_omr_shd.g_old_rec.omr_attribute30;
702: End If;
703:
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 714: p_rec in out nocopy ben_omr_shd.g_rec_type,

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

Line 732: ben_omr_shd.lck

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

Line 830: l_rec ben_omr_shd.g_rec_type;

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

Line 840: ben_omr_shd.convert_args

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