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_CPT_DEL dependencies on BEN_CPT_SHD

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

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

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

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

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

83: delete from ben_cmbn_ptip_opt_f
84: where cmbn_ptip_opt_id = p_rec.cmbn_ptip_opt_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_cpt_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_cpt_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_cpt_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_cpt_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_cpt_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_cpt_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_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_cpt_shd.g_old_rec.name
312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category

Line 310: ,p_effective_end_date_o =>ben_cpt_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_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_cpt_shd.g_old_rec.name
312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1

Line 311: ,p_name_o =>ben_cpt_shd.g_old_rec.name

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_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_cpt_shd.g_old_rec.name
312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2

Line 312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_cpt_shd.g_old_rec.name
312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3

Line 313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category

309: ,p_effective_start_date_o =>ben_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_cpt_shd.g_old_rec.name
312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4

Line 314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1

310: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_cpt_shd.g_old_rec.name
312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5

Line 315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2

311: ,p_name_o =>ben_cpt_shd.g_old_rec.name
312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6

Line 316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3

312: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7

Line 317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4

313: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8

Line 318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5

314: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9

Line 319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6

315: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10

Line 320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7

316: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11

Line 321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8

317: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12

Line 322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9

318: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13

Line 323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10

319: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14

Line 324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11

320: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15

Line 325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12

321: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16

Line 326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13

322: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17

Line 327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14

323: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18

Line 328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15

324: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19

Line 329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16

325: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20

Line 330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17

326: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21

Line 331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18

327: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22

Line 332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19

328: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23

Line 333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20

329: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24

Line 334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21

330: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25

Line 335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22

331: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26

Line 336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23

332: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27

Line 337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24

333: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28

Line 338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25

334: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29

Line 339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26

335: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30

Line 340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27

336: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number

Line 341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28

337: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
345: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id

Line 342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29

338: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
345: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
346: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id

Line 343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30

339: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
345: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
346: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
347: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id

Line 344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number

340: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
345: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
346: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
347: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id
348: );

Line 345: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id

341: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
345: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
346: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
347: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id
348: );
349: --

Line 346: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id

342: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
345: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
346: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
347: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id
348: );
349: --
350: exception

Line 347: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id

343: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
344: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
345: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
346: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
347: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id
348: );
349: --
350: exception
351: --

Line 371: p_rec in out nocopy ben_cpt_shd.g_rec_type,

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

Line 389: ben_cpt_shd.lck

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

Line 447: l_rec ben_cpt_shd.g_rec_type;

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