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_PRP_DEL dependencies on BEN_PRP_SHD

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

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

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

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

74: --
75: ben_prp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_prp_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_prp_shd.g_api_dml := false; -- Unset the api dml status

83: delete from ben_pl_regy_prp_f
84: where pl_regy_prps_id = p_rec.pl_regy_prps_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_prp_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_prp_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_prp_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_prp_shd.g_rec_type,

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_prp_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_prp_shd.g_rec_type,

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_prp_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_prp_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_prp_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_prp_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_prp_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.pl_regy_prps_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_prp_shd.g_rec_type,

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy ben_prp_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_prp_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_prp_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_prp_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_prp_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
311: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id

Line 310: ,p_effective_end_date_o =>ben_prp_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_prp_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
311: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category

Line 311: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd

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_prp_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
311: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1

Line 312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_prp_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
311: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2

Line 313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id

309: ,p_effective_start_date_o =>ben_prp_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
311: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3

Line 314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category

310: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
311: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4

Line 315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1

311: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5

Line 316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2

312: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6

Line 317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3

313: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7

Line 318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4

314: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8

Line 319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5

315: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9

Line 320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6

316: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10

Line 321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7

317: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11

Line 322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8

318: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12

Line 323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9

319: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13

Line 324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10

320: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14

Line 325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11

321: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15

Line 326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12

322: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16

Line 327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13

323: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17

Line 328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14

324: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18

Line 329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15

325: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19

Line 330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16

326: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20

Line 331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17

327: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21

Line 332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18

328: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22

Line 333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19

329: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23

Line 334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20

330: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24

Line 335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21

331: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25

Line 336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22

332: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26

Line 337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23

333: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27

Line 338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24

334: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28

Line 339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25

335: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
343: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29

Line 340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26

336: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
343: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
344: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30

Line 341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27

337: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
343: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
344: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
345: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number

Line 342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28

338: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
343: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
344: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
345: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number
346: );

Line 343: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29

339: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
343: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
344: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
345: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number
346: );
347: --

Line 344: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30

340: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
343: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
344: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
345: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number
346: );
347: --
348: exception

Line 345: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number

341: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
342: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
343: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
344: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
345: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number
346: );
347: --
348: exception
349: --

Line 369: p_rec in out nocopy ben_prp_shd.g_rec_type,

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

Line 387: ben_prp_shd.lck

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

Line 445: l_rec ben_prp_shd.g_rec_type;

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