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_ECT_DEL dependencies on BEN_ECT_SHD

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

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

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

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

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

83: delete from ben_elig_dsblty_ctg_prte_f
84: where elig_dsblty_ctg_prte_id = p_rec.elig_dsblty_ctg_prte_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_ect_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_ect_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_ect_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_ect_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_ect_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_ect_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_ect_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ect_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ect_shd.g_old_rec.business_group_id
312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id
313: ,p_category_o =>ben_ect_shd.g_old_rec.category

Line 310: ,p_effective_end_date_o =>ben_ect_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_ect_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ect_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ect_shd.g_old_rec.business_group_id
312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id
313: ,p_category_o =>ben_ect_shd.g_old_rec.category
314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num

Line 311: ,p_business_group_id_o =>ben_ect_shd.g_old_rec.business_group_id

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_ect_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ect_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ect_shd.g_old_rec.business_group_id
312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id
313: ,p_category_o =>ben_ect_shd.g_old_rec.category
314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num
315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag

Line 312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_ect_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ect_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ect_shd.g_old_rec.business_group_id
312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id
313: ,p_category_o =>ben_ect_shd.g_old_rec.category
314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num
315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag
316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category

Line 313: ,p_category_o =>ben_ect_shd.g_old_rec.category

309: ,p_effective_start_date_o =>ben_ect_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ect_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ect_shd.g_old_rec.business_group_id
312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id
313: ,p_category_o =>ben_ect_shd.g_old_rec.category
314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num
315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag
316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category
317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1

Line 314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num

310: ,p_effective_end_date_o =>ben_ect_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ect_shd.g_old_rec.business_group_id
312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id
313: ,p_category_o =>ben_ect_shd.g_old_rec.category
314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num
315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag
316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category
317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1
318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2

Line 315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag

311: ,p_business_group_id_o =>ben_ect_shd.g_old_rec.business_group_id
312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id
313: ,p_category_o =>ben_ect_shd.g_old_rec.category
314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num
315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag
316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category
317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1
318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2
319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3

Line 316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category

312: ,p_eligy_prfl_id_o =>ben_ect_shd.g_old_rec.eligy_prfl_id
313: ,p_category_o =>ben_ect_shd.g_old_rec.category
314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num
315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag
316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category
317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1
318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2
319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3
320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4

Line 317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1

313: ,p_category_o =>ben_ect_shd.g_old_rec.category
314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num
315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag
316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category
317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1
318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2
319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3
320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4
321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5

Line 318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2

314: ,p_ordr_num_o =>ben_ect_shd.g_old_rec.ordr_num
315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag
316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category
317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1
318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2
319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3
320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4
321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5
322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6

Line 319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3

315: ,p_excld_flag_o =>ben_ect_shd.g_old_rec.excld_flag
316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category
317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1
318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2
319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3
320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4
321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5
322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6
323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7

Line 320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4

316: ,p_ect_attribute_category_o =>ben_ect_shd.g_old_rec.ect_attribute_category
317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1
318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2
319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3
320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4
321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5
322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6
323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7
324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8

Line 321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5

317: ,p_ect_attribute1_o =>ben_ect_shd.g_old_rec.ect_attribute1
318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2
319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3
320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4
321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5
322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6
323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7
324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8
325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9

Line 322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6

318: ,p_ect_attribute2_o =>ben_ect_shd.g_old_rec.ect_attribute2
319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3
320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4
321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5
322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6
323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7
324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8
325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9
326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10

Line 323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7

319: ,p_ect_attribute3_o =>ben_ect_shd.g_old_rec.ect_attribute3
320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4
321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5
322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6
323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7
324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8
325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9
326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10
327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11

Line 324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8

320: ,p_ect_attribute4_o =>ben_ect_shd.g_old_rec.ect_attribute4
321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5
322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6
323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7
324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8
325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9
326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10
327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11
328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12

Line 325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9

321: ,p_ect_attribute5_o =>ben_ect_shd.g_old_rec.ect_attribute5
322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6
323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7
324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8
325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9
326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10
327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11
328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12
329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13

Line 326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10

322: ,p_ect_attribute6_o =>ben_ect_shd.g_old_rec.ect_attribute6
323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7
324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8
325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9
326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10
327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11
328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12
329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13
330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14

Line 327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11

323: ,p_ect_attribute7_o =>ben_ect_shd.g_old_rec.ect_attribute7
324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8
325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9
326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10
327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11
328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12
329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13
330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14
331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15

Line 328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12

324: ,p_ect_attribute8_o =>ben_ect_shd.g_old_rec.ect_attribute8
325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9
326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10
327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11
328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12
329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13
330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14
331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15
332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16

Line 329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13

325: ,p_ect_attribute9_o =>ben_ect_shd.g_old_rec.ect_attribute9
326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10
327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11
328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12
329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13
330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14
331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15
332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16
333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17

Line 330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14

326: ,p_ect_attribute10_o =>ben_ect_shd.g_old_rec.ect_attribute10
327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11
328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12
329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13
330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14
331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15
332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16
333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17
334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18

Line 331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15

327: ,p_ect_attribute11_o =>ben_ect_shd.g_old_rec.ect_attribute11
328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12
329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13
330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14
331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15
332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16
333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17
334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18
335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19

Line 332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16

328: ,p_ect_attribute12_o =>ben_ect_shd.g_old_rec.ect_attribute12
329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13
330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14
331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15
332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16
333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17
334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18
335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19
336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20

Line 333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17

329: ,p_ect_attribute13_o =>ben_ect_shd.g_old_rec.ect_attribute13
330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14
331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15
332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16
333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17
334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18
335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19
336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20
337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21

Line 334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18

330: ,p_ect_attribute14_o =>ben_ect_shd.g_old_rec.ect_attribute14
331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15
332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16
333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17
334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18
335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19
336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20
337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21
338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22

Line 335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19

331: ,p_ect_attribute15_o =>ben_ect_shd.g_old_rec.ect_attribute15
332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16
333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17
334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18
335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19
336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20
337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21
338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22
339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23

Line 336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20

332: ,p_ect_attribute16_o =>ben_ect_shd.g_old_rec.ect_attribute16
333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17
334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18
335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19
336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20
337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21
338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22
339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23
340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24

Line 337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21

333: ,p_ect_attribute17_o =>ben_ect_shd.g_old_rec.ect_attribute17
334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18
335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19
336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20
337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21
338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22
339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23
340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24
341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25

Line 338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22

334: ,p_ect_attribute18_o =>ben_ect_shd.g_old_rec.ect_attribute18
335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19
336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20
337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21
338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22
339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23
340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24
341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25
342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26

Line 339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23

335: ,p_ect_attribute19_o =>ben_ect_shd.g_old_rec.ect_attribute19
336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20
337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21
338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22
339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23
340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24
341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25
342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26
343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27

Line 340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24

336: ,p_ect_attribute20_o =>ben_ect_shd.g_old_rec.ect_attribute20
337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21
338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22
339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23
340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24
341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25
342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26
343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27
344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28

Line 341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25

337: ,p_ect_attribute21_o =>ben_ect_shd.g_old_rec.ect_attribute21
338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22
339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23
340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24
341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25
342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26
343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27
344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28
345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29

Line 342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26

338: ,p_ect_attribute22_o =>ben_ect_shd.g_old_rec.ect_attribute22
339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23
340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24
341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25
342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26
343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27
344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28
345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29
346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30

Line 343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27

339: ,p_ect_attribute23_o =>ben_ect_shd.g_old_rec.ect_attribute23
340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24
341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25
342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26
343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27
344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28
345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29
346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30
347: ,p_object_version_number_o =>ben_ect_shd.g_old_rec.object_version_number

Line 344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28

340: ,p_ect_attribute24_o =>ben_ect_shd.g_old_rec.ect_attribute24
341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25
342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26
343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27
344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28
345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29
346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30
347: ,p_object_version_number_o =>ben_ect_shd.g_old_rec.object_version_number
348: ,p_criteria_score_o =>ben_ect_shd.g_old_rec.criteria_score

Line 345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29

341: ,p_ect_attribute25_o =>ben_ect_shd.g_old_rec.ect_attribute25
342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26
343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27
344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28
345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29
346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30
347: ,p_object_version_number_o =>ben_ect_shd.g_old_rec.object_version_number
348: ,p_criteria_score_o =>ben_ect_shd.g_old_rec.criteria_score
349: ,p_criteria_weight_o =>ben_ect_shd.g_old_rec.criteria_weight

Line 346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30

342: ,p_ect_attribute26_o =>ben_ect_shd.g_old_rec.ect_attribute26
343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27
344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28
345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29
346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30
347: ,p_object_version_number_o =>ben_ect_shd.g_old_rec.object_version_number
348: ,p_criteria_score_o =>ben_ect_shd.g_old_rec.criteria_score
349: ,p_criteria_weight_o =>ben_ect_shd.g_old_rec.criteria_weight
350: );

Line 347: ,p_object_version_number_o =>ben_ect_shd.g_old_rec.object_version_number

343: ,p_ect_attribute27_o =>ben_ect_shd.g_old_rec.ect_attribute27
344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28
345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29
346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30
347: ,p_object_version_number_o =>ben_ect_shd.g_old_rec.object_version_number
348: ,p_criteria_score_o =>ben_ect_shd.g_old_rec.criteria_score
349: ,p_criteria_weight_o =>ben_ect_shd.g_old_rec.criteria_weight
350: );
351: --

Line 348: ,p_criteria_score_o =>ben_ect_shd.g_old_rec.criteria_score

344: ,p_ect_attribute28_o =>ben_ect_shd.g_old_rec.ect_attribute28
345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29
346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30
347: ,p_object_version_number_o =>ben_ect_shd.g_old_rec.object_version_number
348: ,p_criteria_score_o =>ben_ect_shd.g_old_rec.criteria_score
349: ,p_criteria_weight_o =>ben_ect_shd.g_old_rec.criteria_weight
350: );
351: --
352: exception

Line 349: ,p_criteria_weight_o =>ben_ect_shd.g_old_rec.criteria_weight

345: ,p_ect_attribute29_o =>ben_ect_shd.g_old_rec.ect_attribute29
346: ,p_ect_attribute30_o =>ben_ect_shd.g_old_rec.ect_attribute30
347: ,p_object_version_number_o =>ben_ect_shd.g_old_rec.object_version_number
348: ,p_criteria_score_o =>ben_ect_shd.g_old_rec.criteria_score
349: ,p_criteria_weight_o =>ben_ect_shd.g_old_rec.criteria_weight
350: );
351: --
352: exception
353: --

Line 373: p_rec in out nocopy ben_ect_shd.g_rec_type,

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

Line 391: ben_ect_shd.lck

387: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
388: --
389: -- We must lock the row which we need to delete.
390: --
391: ben_ect_shd.lck
392: (p_effective_date => p_effective_date,
393: p_datetrack_mode => p_datetrack_mode,
394: p_elig_dsblty_ctg_prte_id => p_rec.elig_dsblty_ctg_prte_id,
395: p_object_version_number => p_rec.object_version_number,

Line 449: l_rec ben_ect_shd.g_rec_type;

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