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_PDP_DEL dependencies on BEN_PDP_SHD

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

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

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

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

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

83: delete from ben_elig_cvrd_dpnt_f
84: where elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_pdp_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_pdp_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_pdp_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_pdp_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_pdp_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 298: (p_prtt_enrt_rslt_id => ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id,

294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Bug 3756863 : Moved here from DELETE_VALIDATE
297: ben_pdp_bus.crt_ordr_warning
298: (p_prtt_enrt_rslt_id => ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id,
299: p_effective_date => p_effective_date,
300: p_business_group_id => ben_pdp_shd.g_old_rec.business_group_id);
301: --
302:

Line 300: p_business_group_id => ben_pdp_shd.g_old_rec.business_group_id);

296: -- Bug 3756863 : Moved here from DELETE_VALIDATE
297: ben_pdp_bus.crt_ordr_warning
298: (p_prtt_enrt_rslt_id => ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id,
299: p_effective_date => p_effective_date,
300: p_business_group_id => ben_pdp_shd.g_old_rec.business_group_id);
301: --
302:
303:
304: if p_datetrack_mode <> hr_api.g_future_change then

Line 309: and dpnt_person_id = ben_pdp_shd.g_old_rec.dpnt_person_id

305: hr_utility.set_location('update the elig dpnt - cvrd_dpnt_id ', 5);
306: update ben_elig_dpnt
307: set elig_cvrd_dpnt_id = null
308: where elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id
309: and dpnt_person_id = ben_pdp_shd.g_old_rec.dpnt_person_id
310: and per_in_ler_id = ben_pdp_shd.g_old_rec.per_in_ler_id;
311: hr_utility.set_location('Rows updated :'||sql%rowcount , 5);
312: end if;
313:

Line 310: and per_in_ler_id = ben_pdp_shd.g_old_rec.per_in_ler_id;

306: update ben_elig_dpnt
307: set elig_cvrd_dpnt_id = null
308: where elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id
309: and dpnt_person_id = ben_pdp_shd.g_old_rec.dpnt_person_id
310: and per_in_ler_id = ben_pdp_shd.g_old_rec.per_in_ler_id;
311: hr_utility.set_location('Rows updated :'||sql%rowcount , 5);
312: end if;
313:
314:

Line 327: ,p_effective_start_date_o =>ben_pdp_shd.g_old_rec.effective_start_date

323: ,p_validation_start_date =>p_validation_start_date
324: ,p_validation_end_date =>p_validation_end_date
325: ,p_effective_start_date =>p_rec.effective_start_date
326: ,p_effective_end_date =>p_rec.effective_end_date
327: ,p_effective_start_date_o =>ben_pdp_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o =>ben_pdp_shd.g_old_rec.effective_end_date
329: ,p_business_group_id_o =>ben_pdp_shd.g_old_rec.business_group_id
330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id
331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id

Line 328: ,p_effective_end_date_o =>ben_pdp_shd.g_old_rec.effective_end_date

324: ,p_validation_end_date =>p_validation_end_date
325: ,p_effective_start_date =>p_rec.effective_start_date
326: ,p_effective_end_date =>p_rec.effective_end_date
327: ,p_effective_start_date_o =>ben_pdp_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o =>ben_pdp_shd.g_old_rec.effective_end_date
329: ,p_business_group_id_o =>ben_pdp_shd.g_old_rec.business_group_id
330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id
331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id
332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt

Line 329: ,p_business_group_id_o =>ben_pdp_shd.g_old_rec.business_group_id

325: ,p_effective_start_date =>p_rec.effective_start_date
326: ,p_effective_end_date =>p_rec.effective_end_date
327: ,p_effective_start_date_o =>ben_pdp_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o =>ben_pdp_shd.g_old_rec.effective_end_date
329: ,p_business_group_id_o =>ben_pdp_shd.g_old_rec.business_group_id
330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id
331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id
332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt
333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt

Line 330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id

326: ,p_effective_end_date =>p_rec.effective_end_date
327: ,p_effective_start_date_o =>ben_pdp_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o =>ben_pdp_shd.g_old_rec.effective_end_date
329: ,p_business_group_id_o =>ben_pdp_shd.g_old_rec.business_group_id
330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id
331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id
332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt
333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt
334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag

Line 331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id

327: ,p_effective_start_date_o =>ben_pdp_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o =>ben_pdp_shd.g_old_rec.effective_end_date
329: ,p_business_group_id_o =>ben_pdp_shd.g_old_rec.business_group_id
330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id
331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id
332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt
333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt
334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag
335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category

Line 332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt

328: ,p_effective_end_date_o =>ben_pdp_shd.g_old_rec.effective_end_date
329: ,p_business_group_id_o =>ben_pdp_shd.g_old_rec.business_group_id
330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id
331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id
332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt
333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt
334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag
335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category
336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1

Line 333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt

329: ,p_business_group_id_o =>ben_pdp_shd.g_old_rec.business_group_id
330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id
331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id
332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt
333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt
334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag
335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category
336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1
337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2

Line 334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag

330: ,p_prtt_enrt_rslt_id_o =>ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id
331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id
332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt
333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt
334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag
335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category
336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1
337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2
338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3

Line 335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category

331: ,p_dpnt_person_id_o =>ben_pdp_shd.g_old_rec.dpnt_person_id
332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt
333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt
334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag
335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category
336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1
337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2
338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3
339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4

Line 336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1

332: ,p_cvg_strt_dt_o =>ben_pdp_shd.g_old_rec.cvg_strt_dt
333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt
334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag
335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category
336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1
337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2
338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3
339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4
340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5

Line 337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2

333: ,p_cvg_thru_dt_o =>ben_pdp_shd.g_old_rec.cvg_thru_dt
334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag
335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category
336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1
337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2
338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3
339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4
340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5
341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6

Line 338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3

334: ,p_cvg_pndg_flag_o =>ben_pdp_shd.g_old_rec.cvg_pndg_flag
335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category
336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1
337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2
338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3
339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4
340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5
341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6
342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7

Line 339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4

335: ,p_pdp_attribute_category_o =>ben_pdp_shd.g_old_rec.pdp_attribute_category
336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1
337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2
338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3
339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4
340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5
341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6
342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7
343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8

Line 340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5

336: ,p_pdp_attribute1_o =>ben_pdp_shd.g_old_rec.pdp_attribute1
337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2
338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3
339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4
340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5
341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6
342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7
343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8
344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9

Line 341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6

337: ,p_pdp_attribute2_o =>ben_pdp_shd.g_old_rec.pdp_attribute2
338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3
339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4
340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5
341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6
342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7
343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8
344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9
345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10

Line 342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7

338: ,p_pdp_attribute3_o =>ben_pdp_shd.g_old_rec.pdp_attribute3
339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4
340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5
341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6
342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7
343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8
344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9
345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10
346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11

Line 343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8

339: ,p_pdp_attribute4_o =>ben_pdp_shd.g_old_rec.pdp_attribute4
340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5
341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6
342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7
343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8
344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9
345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10
346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11
347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12

Line 344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9

340: ,p_pdp_attribute5_o =>ben_pdp_shd.g_old_rec.pdp_attribute5
341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6
342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7
343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8
344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9
345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10
346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11
347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12
348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13

Line 345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10

341: ,p_pdp_attribute6_o =>ben_pdp_shd.g_old_rec.pdp_attribute6
342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7
343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8
344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9
345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10
346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11
347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12
348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13
349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14

Line 346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11

342: ,p_pdp_attribute7_o =>ben_pdp_shd.g_old_rec.pdp_attribute7
343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8
344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9
345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10
346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11
347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12
348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13
349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14
350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15

Line 347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12

343: ,p_pdp_attribute8_o =>ben_pdp_shd.g_old_rec.pdp_attribute8
344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9
345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10
346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11
347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12
348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13
349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14
350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15
351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16

Line 348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13

344: ,p_pdp_attribute9_o =>ben_pdp_shd.g_old_rec.pdp_attribute9
345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10
346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11
347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12
348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13
349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14
350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15
351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16
352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17

Line 349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14

345: ,p_pdp_attribute10_o =>ben_pdp_shd.g_old_rec.pdp_attribute10
346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11
347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12
348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13
349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14
350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15
351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16
352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17
353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18

Line 350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15

346: ,p_pdp_attribute11_o =>ben_pdp_shd.g_old_rec.pdp_attribute11
347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12
348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13
349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14
350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15
351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16
352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17
353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18
354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19

Line 351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16

347: ,p_pdp_attribute12_o =>ben_pdp_shd.g_old_rec.pdp_attribute12
348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13
349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14
350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15
351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16
352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17
353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18
354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19
355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20

Line 352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17

348: ,p_pdp_attribute13_o =>ben_pdp_shd.g_old_rec.pdp_attribute13
349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14
350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15
351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16
352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17
353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18
354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19
355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20
356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21

Line 353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18

349: ,p_pdp_attribute14_o =>ben_pdp_shd.g_old_rec.pdp_attribute14
350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15
351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16
352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17
353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18
354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19
355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20
356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21
357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22

Line 354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19

350: ,p_pdp_attribute15_o =>ben_pdp_shd.g_old_rec.pdp_attribute15
351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16
352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17
353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18
354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19
355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20
356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21
357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22
358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23

Line 355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20

351: ,p_pdp_attribute16_o =>ben_pdp_shd.g_old_rec.pdp_attribute16
352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17
353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18
354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19
355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20
356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21
357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22
358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23
359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24

Line 356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21

352: ,p_pdp_attribute17_o =>ben_pdp_shd.g_old_rec.pdp_attribute17
353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18
354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19
355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20
356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21
357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22
358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23
359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24
360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25

Line 357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22

353: ,p_pdp_attribute18_o =>ben_pdp_shd.g_old_rec.pdp_attribute18
354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19
355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20
356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21
357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22
358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23
359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24
360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25
361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26

Line 358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23

354: ,p_pdp_attribute19_o =>ben_pdp_shd.g_old_rec.pdp_attribute19
355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20
356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21
357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22
358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23
359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24
360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25
361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26
362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27

Line 359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24

355: ,p_pdp_attribute20_o =>ben_pdp_shd.g_old_rec.pdp_attribute20
356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21
357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22
358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23
359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24
360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25
361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26
362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27
363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28

Line 360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25

356: ,p_pdp_attribute21_o =>ben_pdp_shd.g_old_rec.pdp_attribute21
357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22
358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23
359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24
360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25
361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26
362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27
363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28
364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29

Line 361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26

357: ,p_pdp_attribute22_o =>ben_pdp_shd.g_old_rec.pdp_attribute22
358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23
359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24
360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25
361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26
362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27
363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28
364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29
365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30

Line 362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27

358: ,p_pdp_attribute23_o =>ben_pdp_shd.g_old_rec.pdp_attribute23
359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24
360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25
361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26
362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27
363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28
364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29
365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30
366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id

Line 363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28

359: ,p_pdp_attribute24_o =>ben_pdp_shd.g_old_rec.pdp_attribute24
360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25
361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26
362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27
363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28
364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29
365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30
366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id
367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id

Line 364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29

360: ,p_pdp_attribute25_o =>ben_pdp_shd.g_old_rec.pdp_attribute25
361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26
362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27
363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28
364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29
365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30
366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id
367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id
368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id

Line 365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30

361: ,p_pdp_attribute26_o =>ben_pdp_shd.g_old_rec.pdp_attribute26
362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27
363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28
364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29
365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30
366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id
367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id
368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id
369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date

Line 366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id

362: ,p_pdp_attribute27_o =>ben_pdp_shd.g_old_rec.pdp_attribute27
363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28
364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29
365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30
366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id
367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id
368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id
369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date
370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number

Line 367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id

363: ,p_pdp_attribute28_o =>ben_pdp_shd.g_old_rec.pdp_attribute28
364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29
365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30
366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id
367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id
368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id
369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date
370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number
371: ,p_ovrdn_flag_o =>ben_pdp_shd.g_old_rec.ovrdn_flag

Line 368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id

364: ,p_pdp_attribute29_o =>ben_pdp_shd.g_old_rec.pdp_attribute29
365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30
366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id
367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id
368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id
369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date
370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number
371: ,p_ovrdn_flag_o =>ben_pdp_shd.g_old_rec.ovrdn_flag
372: ,p_per_in_ler_id_o =>ben_pdp_shd.g_old_rec.per_in_ler_id

Line 369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date

365: ,p_pdp_attribute30_o =>ben_pdp_shd.g_old_rec.pdp_attribute30
366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id
367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id
368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id
369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date
370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number
371: ,p_ovrdn_flag_o =>ben_pdp_shd.g_old_rec.ovrdn_flag
372: ,p_per_in_ler_id_o =>ben_pdp_shd.g_old_rec.per_in_ler_id
373: ,p_ovrdn_thru_dt_o =>ben_pdp_shd.g_old_rec.ovrdn_thru_dt

Line 370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number

366: ,p_request_id_o =>ben_pdp_shd.g_old_rec.request_id
367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id
368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id
369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date
370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number
371: ,p_ovrdn_flag_o =>ben_pdp_shd.g_old_rec.ovrdn_flag
372: ,p_per_in_ler_id_o =>ben_pdp_shd.g_old_rec.per_in_ler_id
373: ,p_ovrdn_thru_dt_o =>ben_pdp_shd.g_old_rec.ovrdn_thru_dt
374: );

Line 371: ,p_ovrdn_flag_o =>ben_pdp_shd.g_old_rec.ovrdn_flag

367: ,p_program_application_id_o =>ben_pdp_shd.g_old_rec.program_application_id
368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id
369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date
370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number
371: ,p_ovrdn_flag_o =>ben_pdp_shd.g_old_rec.ovrdn_flag
372: ,p_per_in_ler_id_o =>ben_pdp_shd.g_old_rec.per_in_ler_id
373: ,p_ovrdn_thru_dt_o =>ben_pdp_shd.g_old_rec.ovrdn_thru_dt
374: );
375: --

Line 372: ,p_per_in_ler_id_o =>ben_pdp_shd.g_old_rec.per_in_ler_id

368: ,p_program_id_o =>ben_pdp_shd.g_old_rec.program_id
369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date
370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number
371: ,p_ovrdn_flag_o =>ben_pdp_shd.g_old_rec.ovrdn_flag
372: ,p_per_in_ler_id_o =>ben_pdp_shd.g_old_rec.per_in_ler_id
373: ,p_ovrdn_thru_dt_o =>ben_pdp_shd.g_old_rec.ovrdn_thru_dt
374: );
375: --
376: exception

Line 373: ,p_ovrdn_thru_dt_o =>ben_pdp_shd.g_old_rec.ovrdn_thru_dt

369: ,p_program_update_date_o =>ben_pdp_shd.g_old_rec.program_update_date
370: ,p_object_version_number_o =>ben_pdp_shd.g_old_rec.object_version_number
371: ,p_ovrdn_flag_o =>ben_pdp_shd.g_old_rec.ovrdn_flag
372: ,p_per_in_ler_id_o =>ben_pdp_shd.g_old_rec.per_in_ler_id
373: ,p_ovrdn_thru_dt_o =>ben_pdp_shd.g_old_rec.ovrdn_thru_dt
374: );
375: --
376: exception
377: --

Line 397: p_rec in out nocopy ben_pdp_shd.g_rec_type,

393: -- |---------------------------------< del >----------------------------------|
394: -- ----------------------------------------------------------------------------
395: Procedure del
396: (
397: p_rec in out nocopy ben_pdp_shd.g_rec_type,
398: p_effective_date in date,
399: p_datetrack_mode in varchar2
400: ) is
401: --

Line 415: ben_pdp_shd.lck

411: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
412: --
413: -- We must lock the row which we need to delete.
414: --
415: ben_pdp_shd.lck
416: (p_effective_date => p_effective_date,
417: p_datetrack_mode => p_datetrack_mode,
418: p_elig_cvrd_dpnt_id => p_rec.elig_cvrd_dpnt_id,
419: p_object_version_number => p_rec.object_version_number,

Line 473: l_rec ben_pdp_shd.g_rec_type;

469: p_effective_date in date,
470: p_datetrack_mode in varchar2
471: ) is
472: --
473: l_rec ben_pdp_shd.g_rec_type;
474: l_proc varchar2(72) := g_package||'del';
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);