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_REG_DEL dependencies on BEN_REG_SHD

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

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_reg_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_reg_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_reg_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 81: ben_reg_shd.g_api_dml := false; -- Unset the api dml status

77: delete from ben_regn_f_tl
78: where regn_id = p_rec.regn_id
79: and effective_start_date = p_validation_start_date;
80: --
81: ben_reg_shd.g_api_dml := false; -- Unset the api dml status
82: Else
83: hr_utility.set_location(l_proc, 15);
84: ben_reg_shd.g_api_dml := true; -- Set the api dml status
85: --

Line 84: ben_reg_shd.g_api_dml := true; -- Set the api dml status

80: --
81: ben_reg_shd.g_api_dml := false; -- Unset the api dml status
82: Else
83: hr_utility.set_location(l_proc, 15);
84: ben_reg_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Delete the row(s) where the effective start date is greater than
87: -- or equal to the validation start date.
88: --

Line 99: ben_reg_shd.g_api_dml := false; -- Unset the api dml status

95: delete from ben_regn_f_tl
96: where regn_id = p_rec.regn_id
97: and effective_start_date >= p_validation_start_date;
98: --
99: ben_reg_shd.g_api_dml := false; -- Unset the api dml status
100: End If;
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 20);
103: --

Line 106: ben_reg_shd.g_api_dml := false; -- Unset the api dml status

102: hr_utility.set_location(' Leaving:'||l_proc, 20);
103: --
104: Exception
105: When Others Then
106: ben_reg_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: End dt_delete_dml;
109: --
110: -- ----------------------------------------------------------------------------

Line 114: (p_rec in out nocopy ben_reg_shd.g_rec_type,

110: -- ----------------------------------------------------------------------------
111: -- |------------------------------< delete_dml >------------------------------|
112: -- ----------------------------------------------------------------------------
113: Procedure delete_dml
114: (p_rec in out nocopy ben_reg_shd.g_rec_type,
115: p_effective_date in date,
116: p_datetrack_mode in varchar2,
117: p_validation_start_date in date,
118: p_validation_end_date in date) is

Line 168: (p_rec in out nocopy ben_reg_shd.g_rec_type,

164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure dt_pre_delete
168: (p_rec in out nocopy ben_reg_shd.g_rec_type,
169: p_effective_date in date,
170: p_datetrack_mode in varchar2,
171: p_validation_start_date in date,
172: p_validation_end_date in date) is

Line 181: p_rec.effective_start_date := ben_reg_shd.g_old_rec.effective_start_date;

177: hr_utility.set_location('Entering:'||l_proc, 5);
178: --
179: If (p_datetrack_mode <> 'ZAP') then
180: --
181: p_rec.effective_start_date := ben_reg_shd.g_old_rec.effective_start_date;
182: --
183: If (p_datetrack_mode = 'DELETE') then
184: p_rec.effective_end_date := p_validation_start_date - 1;
185: Else

Line 191: ben_reg_shd.upd_effective_end_date

187: End If;
188: --
189: -- Update the current effective end date record
190: --
191: ben_reg_shd.upd_effective_end_date
192: (p_effective_date => p_effective_date,
193: p_base_key_value => p_rec.regn_id,
194: p_new_effective_end_date => p_rec.effective_end_date,
195: p_validation_start_date => p_validation_start_date,

Line 239: (p_rec in out nocopy ben_reg_shd.g_rec_type,

235: --
236: -- {End Of Comments}
237: -- ----------------------------------------------------------------------------
238: Procedure pre_delete
239: (p_rec in out nocopy ben_reg_shd.g_rec_type,
240: p_effective_date in date,
241: p_datetrack_mode in varchar2,
242: p_validation_start_date in date,
243: p_validation_end_date in date) is

Line 297: (p_rec in ben_reg_shd.g_rec_type,

293: --
294: -- {End Of Comments}
295: -- ----------------------------------------------------------------------------
296: Procedure post_delete
297: (p_rec in ben_reg_shd.g_rec_type,
298: p_effective_date in date,
299: p_datetrack_mode in varchar2,
300: p_validation_start_date in date,
301: p_validation_end_date in date) is

Line 321: ,p_effective_start_date_o =>ben_reg_shd.g_old_rec.effective_start_date

317: ,p_validation_start_date =>p_validation_start_date
318: ,p_validation_end_date =>p_validation_end_date
319: ,p_effective_start_date =>p_rec.effective_start_date
320: ,p_effective_end_date =>p_rec.effective_end_date
321: ,p_effective_start_date_o =>ben_reg_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o =>ben_reg_shd.g_old_rec.effective_end_date
323: ,p_name_o =>ben_reg_shd.g_old_rec.name
324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id
325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id

Line 322: ,p_effective_end_date_o =>ben_reg_shd.g_old_rec.effective_end_date

318: ,p_validation_end_date =>p_validation_end_date
319: ,p_effective_start_date =>p_rec.effective_start_date
320: ,p_effective_end_date =>p_rec.effective_end_date
321: ,p_effective_start_date_o =>ben_reg_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o =>ben_reg_shd.g_old_rec.effective_end_date
323: ,p_name_o =>ben_reg_shd.g_old_rec.name
324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id
325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id
326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name

Line 323: ,p_name_o =>ben_reg_shd.g_old_rec.name

319: ,p_effective_start_date =>p_rec.effective_start_date
320: ,p_effective_end_date =>p_rec.effective_end_date
321: ,p_effective_start_date_o =>ben_reg_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o =>ben_reg_shd.g_old_rec.effective_end_date
323: ,p_name_o =>ben_reg_shd.g_old_rec.name
324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id
325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id
326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name
327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category

Line 324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id

320: ,p_effective_end_date =>p_rec.effective_end_date
321: ,p_effective_start_date_o =>ben_reg_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o =>ben_reg_shd.g_old_rec.effective_end_date
323: ,p_name_o =>ben_reg_shd.g_old_rec.name
324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id
325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id
326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name
327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category
328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1

Line 325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id

321: ,p_effective_start_date_o =>ben_reg_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o =>ben_reg_shd.g_old_rec.effective_end_date
323: ,p_name_o =>ben_reg_shd.g_old_rec.name
324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id
325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id
326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name
327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category
328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1
329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2

Line 326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name

322: ,p_effective_end_date_o =>ben_reg_shd.g_old_rec.effective_end_date
323: ,p_name_o =>ben_reg_shd.g_old_rec.name
324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id
325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id
326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name
327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category
328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1
329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2
330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3

Line 327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category

323: ,p_name_o =>ben_reg_shd.g_old_rec.name
324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id
325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id
326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name
327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category
328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1
329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2
330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3
331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4

Line 328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1

324: ,p_organization_id_o =>ben_reg_shd.g_old_rec.organization_id
325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id
326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name
327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category
328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1
329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2
330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3
331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4
332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5

Line 329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2

325: ,p_business_group_id_o =>ben_reg_shd.g_old_rec.business_group_id
326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name
327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category
328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1
329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2
330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3
331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4
332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5
333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6

Line 330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3

326: ,p_sttry_citn_name_o =>ben_reg_shd.g_old_rec.sttry_citn_name
327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category
328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1
329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2
330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3
331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4
332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5
333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6
334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7

Line 331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4

327: ,p_reg_attribute_category_o =>ben_reg_shd.g_old_rec.reg_attribute_category
328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1
329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2
330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3
331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4
332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5
333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6
334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7
335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8

Line 332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5

328: ,p_reg_attribute1_o =>ben_reg_shd.g_old_rec.reg_attribute1
329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2
330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3
331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4
332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5
333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6
334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7
335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8
336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9

Line 333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6

329: ,p_reg_attribute2_o =>ben_reg_shd.g_old_rec.reg_attribute2
330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3
331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4
332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5
333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6
334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7
335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8
336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9
337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10

Line 334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7

330: ,p_reg_attribute3_o =>ben_reg_shd.g_old_rec.reg_attribute3
331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4
332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5
333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6
334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7
335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8
336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9
337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10
338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11

Line 335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8

331: ,p_reg_attribute4_o =>ben_reg_shd.g_old_rec.reg_attribute4
332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5
333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6
334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7
335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8
336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9
337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10
338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11
339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12

Line 336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9

332: ,p_reg_attribute5_o =>ben_reg_shd.g_old_rec.reg_attribute5
333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6
334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7
335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8
336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9
337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10
338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11
339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12
340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13

Line 337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10

333: ,p_reg_attribute6_o =>ben_reg_shd.g_old_rec.reg_attribute6
334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7
335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8
336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9
337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10
338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11
339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12
340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13
341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14

Line 338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11

334: ,p_reg_attribute7_o =>ben_reg_shd.g_old_rec.reg_attribute7
335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8
336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9
337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10
338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11
339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12
340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13
341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14
342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15

Line 339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12

335: ,p_reg_attribute8_o =>ben_reg_shd.g_old_rec.reg_attribute8
336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9
337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10
338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11
339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12
340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13
341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14
342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15
343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16

Line 340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13

336: ,p_reg_attribute9_o =>ben_reg_shd.g_old_rec.reg_attribute9
337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10
338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11
339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12
340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13
341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14
342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15
343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16
344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17

Line 341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14

337: ,p_reg_attribute10_o =>ben_reg_shd.g_old_rec.reg_attribute10
338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11
339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12
340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13
341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14
342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15
343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16
344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17
345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18

Line 342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15

338: ,p_reg_attribute11_o =>ben_reg_shd.g_old_rec.reg_attribute11
339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12
340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13
341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14
342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15
343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16
344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17
345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18
346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19

Line 343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16

339: ,p_reg_attribute12_o =>ben_reg_shd.g_old_rec.reg_attribute12
340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13
341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14
342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15
343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16
344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17
345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18
346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19
347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20

Line 344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17

340: ,p_reg_attribute13_o =>ben_reg_shd.g_old_rec.reg_attribute13
341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14
342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15
343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16
344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17
345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18
346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19
347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20
348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21

Line 345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18

341: ,p_reg_attribute14_o =>ben_reg_shd.g_old_rec.reg_attribute14
342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15
343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16
344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17
345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18
346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19
347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20
348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21
349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22

Line 346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19

342: ,p_reg_attribute15_o =>ben_reg_shd.g_old_rec.reg_attribute15
343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16
344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17
345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18
346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19
347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20
348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21
349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22
350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23

Line 347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20

343: ,p_reg_attribute16_o =>ben_reg_shd.g_old_rec.reg_attribute16
344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17
345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18
346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19
347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20
348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21
349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22
350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23
351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24

Line 348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21

344: ,p_reg_attribute17_o =>ben_reg_shd.g_old_rec.reg_attribute17
345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18
346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19
347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20
348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21
349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22
350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23
351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24
352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25

Line 349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22

345: ,p_reg_attribute18_o =>ben_reg_shd.g_old_rec.reg_attribute18
346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19
347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20
348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21
349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22
350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23
351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24
352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25
353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26

Line 350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23

346: ,p_reg_attribute19_o =>ben_reg_shd.g_old_rec.reg_attribute19
347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20
348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21
349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22
350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23
351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24
352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25
353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26
354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27

Line 351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24

347: ,p_reg_attribute20_o =>ben_reg_shd.g_old_rec.reg_attribute20
348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21
349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22
350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23
351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24
352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25
353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26
354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27
355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28

Line 352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25

348: ,p_reg_attribute21_o =>ben_reg_shd.g_old_rec.reg_attribute21
349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22
350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23
351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24
352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25
353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26
354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27
355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28
356: ,p_reg_attribute29_o =>ben_reg_shd.g_old_rec.reg_attribute29

Line 353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26

349: ,p_reg_attribute22_o =>ben_reg_shd.g_old_rec.reg_attribute22
350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23
351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24
352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25
353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26
354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27
355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28
356: ,p_reg_attribute29_o =>ben_reg_shd.g_old_rec.reg_attribute29
357: ,p_reg_attribute30_o =>ben_reg_shd.g_old_rec.reg_attribute30

Line 354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27

350: ,p_reg_attribute23_o =>ben_reg_shd.g_old_rec.reg_attribute23
351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24
352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25
353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26
354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27
355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28
356: ,p_reg_attribute29_o =>ben_reg_shd.g_old_rec.reg_attribute29
357: ,p_reg_attribute30_o =>ben_reg_shd.g_old_rec.reg_attribute30
358: ,p_object_version_number_o =>ben_reg_shd.g_old_rec.object_version_number

Line 355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28

351: ,p_reg_attribute24_o =>ben_reg_shd.g_old_rec.reg_attribute24
352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25
353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26
354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27
355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28
356: ,p_reg_attribute29_o =>ben_reg_shd.g_old_rec.reg_attribute29
357: ,p_reg_attribute30_o =>ben_reg_shd.g_old_rec.reg_attribute30
358: ,p_object_version_number_o =>ben_reg_shd.g_old_rec.object_version_number
359: );

Line 356: ,p_reg_attribute29_o =>ben_reg_shd.g_old_rec.reg_attribute29

352: ,p_reg_attribute25_o =>ben_reg_shd.g_old_rec.reg_attribute25
353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26
354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27
355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28
356: ,p_reg_attribute29_o =>ben_reg_shd.g_old_rec.reg_attribute29
357: ,p_reg_attribute30_o =>ben_reg_shd.g_old_rec.reg_attribute30
358: ,p_object_version_number_o =>ben_reg_shd.g_old_rec.object_version_number
359: );
360: --

Line 357: ,p_reg_attribute30_o =>ben_reg_shd.g_old_rec.reg_attribute30

353: ,p_reg_attribute26_o =>ben_reg_shd.g_old_rec.reg_attribute26
354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27
355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28
356: ,p_reg_attribute29_o =>ben_reg_shd.g_old_rec.reg_attribute29
357: ,p_reg_attribute30_o =>ben_reg_shd.g_old_rec.reg_attribute30
358: ,p_object_version_number_o =>ben_reg_shd.g_old_rec.object_version_number
359: );
360: --
361: exception

Line 358: ,p_object_version_number_o =>ben_reg_shd.g_old_rec.object_version_number

354: ,p_reg_attribute27_o =>ben_reg_shd.g_old_rec.reg_attribute27
355: ,p_reg_attribute28_o =>ben_reg_shd.g_old_rec.reg_attribute28
356: ,p_reg_attribute29_o =>ben_reg_shd.g_old_rec.reg_attribute29
357: ,p_reg_attribute30_o =>ben_reg_shd.g_old_rec.reg_attribute30
358: ,p_object_version_number_o =>ben_reg_shd.g_old_rec.object_version_number
359: );
360: --
361: exception
362: --

Line 382: p_rec in out nocopy ben_reg_shd.g_rec_type,

378: -- |---------------------------------< del >----------------------------------|
379: -- ----------------------------------------------------------------------------
380: Procedure del
381: (
382: p_rec in out nocopy ben_reg_shd.g_rec_type,
383: p_effective_date in date,
384: p_datetrack_mode in varchar2
385: ) is
386: --

Line 400: ben_reg_shd.lck

396: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
397: --
398: -- We must lock the row which we need to delete.
399: --
400: ben_reg_shd.lck
401: (p_effective_date => p_effective_date,
402: p_datetrack_mode => p_datetrack_mode,
403: p_regn_id => p_rec.regn_id,
404: p_object_version_number => p_rec.object_version_number,

Line 458: l_rec ben_reg_shd.g_rec_type;

454: p_effective_date in date,
455: p_datetrack_mode in varchar2
456: ) is
457: --
458: l_rec ben_reg_shd.g_rec_type;
459: l_proc varchar2(72) := g_package||'del';
460: --
461: Begin
462: hr_utility.set_location('Entering:'||l_proc, 5);