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

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

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_omr_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is

Line 66: ben_omr_shd.g_api_dml := true; -- Set the api dml status

62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_omr_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

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

71: delete from ben_OPTD_MDCR_RT_f
72: where optd_mdcr_rt_id = p_rec.optd_mdcr_rt_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_omr_shd.g_api_dml := true; -- Set the api dml status
79: --

Line 78: ben_omr_shd.g_api_dml := true; -- Set the api dml status

74: --
75: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_omr_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --

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

83: delete from ben_OPTD_MDCR_RT_f
84: where optd_mdcr_rt_id = p_rec.optd_mdcr_rt_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --

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

90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End dt_delete_dml;
97: --
98: -- ----------------------------------------------------------------------------

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

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_omr_shd.g_rec_type,
103: p_effective_date in date,
104: p_datetrack_mode in varchar2,
105: p_validation_start_date in date,
106: p_validation_end_date in date) is

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

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_omr_shd.g_rec_type,
157: p_effective_date in date,
158: p_datetrack_mode in varchar2,
159: p_validation_start_date in date,
160: p_validation_end_date in date) is

Line 169: p_rec.effective_start_date := ben_omr_shd.g_old_rec.effective_start_date;

165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := ben_omr_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: ben_omr_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_omr_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.optd_mdcr_rt_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,

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

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy ben_omr_shd.g_rec_type,
228: p_effective_date in date,
229: p_datetrack_mode in varchar2,
230: p_validation_start_date in date,
231: p_validation_end_date in date) is

Line 285: (p_rec in ben_omr_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_omr_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is

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

305: ,p_validation_start_date =>p_validation_start_date
306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
311: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
312: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id

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

306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
311: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
312: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id

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

307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
311: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
312: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category

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

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
311: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
312: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1

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

309: ,p_effective_start_date_o =>ben_omr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
311: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
312: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2

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

310: ,p_effective_end_date_o =>ben_omr_shd.g_old_rec.effective_end_date
311: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
312: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3

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

311: ,p_optd_mdcr_flag_o =>ben_omr_shd.g_old_rec.optd_mdcr_flag
312: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4

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

312: ,p_exlcd_flag_o =>ben_omr_shd.g_old_rec.exlcd_flag
313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5

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

313: ,p_vrbl_rt_prfl_id_o =>ben_omr_shd.g_old_rec.vrbl_rt_prfl_id
314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6

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

314: ,p_business_group_id_o =>ben_omr_shd.g_old_rec.business_group_id
315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7

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

315: ,p_omr_attribute_category_o =>ben_omr_shd.g_old_rec.omr_attribute_category
316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8

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

316: ,p_omr_attribute1_o =>ben_omr_shd.g_old_rec.omr_attribute1
317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9

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

317: ,p_omr_attribute2_o =>ben_omr_shd.g_old_rec.omr_attribute2
318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10

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

318: ,p_omr_attribute3_o =>ben_omr_shd.g_old_rec.omr_attribute3
319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11

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

319: ,p_omr_attribute4_o =>ben_omr_shd.g_old_rec.omr_attribute4
320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12

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

320: ,p_omr_attribute5_o =>ben_omr_shd.g_old_rec.omr_attribute5
321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13

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

321: ,p_omr_attribute6_o =>ben_omr_shd.g_old_rec.omr_attribute6
322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14

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

322: ,p_omr_attribute7_o =>ben_omr_shd.g_old_rec.omr_attribute7
323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15

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

323: ,p_omr_attribute8_o =>ben_omr_shd.g_old_rec.omr_attribute8
324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16

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

324: ,p_omr_attribute9_o =>ben_omr_shd.g_old_rec.omr_attribute9
325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17

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

325: ,p_omr_attribute10_o =>ben_omr_shd.g_old_rec.omr_attribute10
326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18

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

326: ,p_omr_attribute11_o =>ben_omr_shd.g_old_rec.omr_attribute11
327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19

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

327: ,p_omr_attribute12_o =>ben_omr_shd.g_old_rec.omr_attribute12
328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20

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

328: ,p_omr_attribute13_o =>ben_omr_shd.g_old_rec.omr_attribute13
329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21

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

329: ,p_omr_attribute14_o =>ben_omr_shd.g_old_rec.omr_attribute14
330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22

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

330: ,p_omr_attribute15_o =>ben_omr_shd.g_old_rec.omr_attribute15
331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23

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

331: ,p_omr_attribute16_o =>ben_omr_shd.g_old_rec.omr_attribute16
332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24

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

332: ,p_omr_attribute17_o =>ben_omr_shd.g_old_rec.omr_attribute17
333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25

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

333: ,p_omr_attribute18_o =>ben_omr_shd.g_old_rec.omr_attribute18
334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26

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

334: ,p_omr_attribute19_o =>ben_omr_shd.g_old_rec.omr_attribute19
335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27

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

335: ,p_omr_attribute20_o =>ben_omr_shd.g_old_rec.omr_attribute20
336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
343: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28

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

336: ,p_omr_attribute21_o =>ben_omr_shd.g_old_rec.omr_attribute21
337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
343: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
344: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29

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

337: ,p_omr_attribute22_o =>ben_omr_shd.g_old_rec.omr_attribute22
338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
343: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
344: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
345: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30

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

338: ,p_omr_attribute23_o =>ben_omr_shd.g_old_rec.omr_attribute23
339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
343: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
344: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
345: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
346: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number

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

339: ,p_omr_attribute24_o =>ben_omr_shd.g_old_rec.omr_attribute24
340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
343: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
344: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
345: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
346: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number
347: );

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

340: ,p_omr_attribute25_o =>ben_omr_shd.g_old_rec.omr_attribute25
341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
343: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
344: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
345: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
346: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number
347: );
348: --

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

341: ,p_omr_attribute26_o =>ben_omr_shd.g_old_rec.omr_attribute26
342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
343: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
344: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
345: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
346: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number
347: );
348: --
349: exception

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

342: ,p_omr_attribute27_o =>ben_omr_shd.g_old_rec.omr_attribute27
343: ,p_omr_attribute28_o =>ben_omr_shd.g_old_rec.omr_attribute28
344: ,p_omr_attribute29_o =>ben_omr_shd.g_old_rec.omr_attribute29
345: ,p_omr_attribute30_o =>ben_omr_shd.g_old_rec.omr_attribute30
346: ,p_object_version_number_o =>ben_omr_shd.g_old_rec.object_version_number
347: );
348: --
349: exception
350: --

Line 370: p_rec in out nocopy ben_omr_shd.g_rec_type,

366: -- |---------------------------------< del >----------------------------------|
367: -- ----------------------------------------------------------------------------
368: Procedure del
369: (
370: p_rec in out nocopy ben_omr_shd.g_rec_type,
371: p_effective_date in date,
372: p_datetrack_mode in varchar2
373: ) is
374: --

Line 388: ben_omr_shd.lck

384: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
385: --
386: -- We must lock the row which we need to delete.
387: --
388: ben_omr_shd.lck
389: (p_effective_date => p_effective_date,
390: p_datetrack_mode => p_datetrack_mode,
391: p_optd_mdcr_rt_id => p_rec.optd_mdcr_rt_id,
392: p_object_version_number => p_rec.object_version_number,

Line 446: l_rec ben_omr_shd.g_rec_type;

442: p_effective_date in date,
443: p_datetrack_mode in varchar2
444: ) is
445: --
446: l_rec ben_omr_shd.g_rec_type;
447: l_proc varchar2(72) := g_package||'del';
448: --
449: Begin
450: hr_utility.set_location('Entering:'||l_proc, 5);