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_PPR_DEL dependencies on BEN_PPR_SHD

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

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

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

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

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

83: delete from ben_prmry_care_prvdr_f
84: where prmry_care_prvdr_id = p_rec.prmry_care_prvdr_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_ppr_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_ppr_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_ppr_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_ppr_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_ppr_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_ppr_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_ppr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ppr_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_ppr_shd.g_old_rec.name
312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident
313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd

Line 310: ,p_effective_end_date_o =>ben_ppr_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_ppr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ppr_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_ppr_shd.g_old_rec.name
312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident
313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id

Line 311: ,p_name_o =>ben_ppr_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_ppr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ppr_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_ppr_shd.g_old_rec.name
312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident
313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id
315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id

Line 312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_ppr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ppr_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_ppr_shd.g_old_rec.name
312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident
313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id
315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id
316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id

Line 313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd

309: ,p_effective_start_date_o =>ben_ppr_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ppr_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_ppr_shd.g_old_rec.name
312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident
313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id
315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id
316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id
317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category

Line 314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id

310: ,p_effective_end_date_o =>ben_ppr_shd.g_old_rec.effective_end_date
311: ,p_name_o =>ben_ppr_shd.g_old_rec.name
312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident
313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id
315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id
316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id
317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category
318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1

Line 315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id

311: ,p_name_o =>ben_ppr_shd.g_old_rec.name
312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident
313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id
315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id
316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id
317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category
318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1
319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2

Line 316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id

312: ,p_ext_ident_o =>ben_ppr_shd.g_old_rec.ext_ident
313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id
315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id
316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id
317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category
318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1
319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2
320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3

Line 317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category

313: ,p_prmry_care_prvdr_typ_cd_o =>ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id
315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id
316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id
317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category
318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1
319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2
320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3
321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4

Line 318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1

314: ,p_prtt_enrt_rslt_id_o =>ben_ppr_shd.g_old_rec.prtt_enrt_rslt_id
315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id
316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id
317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category
318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1
319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2
320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3
321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4
322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5

Line 319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2

315: ,p_elig_cvrd_dpnt_id_o =>ben_ppr_shd.g_old_rec.elig_cvrd_dpnt_id
316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id
317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category
318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1
319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2
320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3
321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4
322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5
323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6

Line 320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3

316: ,p_business_group_id_o =>ben_ppr_shd.g_old_rec.business_group_id
317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category
318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1
319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2
320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3
321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4
322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5
323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6
324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7

Line 321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4

317: ,p_ppr_attribute_category_o =>ben_ppr_shd.g_old_rec.ppr_attribute_category
318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1
319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2
320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3
321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4
322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5
323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6
324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7
325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8

Line 322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5

318: ,p_ppr_attribute1_o =>ben_ppr_shd.g_old_rec.ppr_attribute1
319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2
320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3
321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4
322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5
323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6
324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7
325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8
326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9

Line 323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6

319: ,p_ppr_attribute2_o =>ben_ppr_shd.g_old_rec.ppr_attribute2
320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3
321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4
322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5
323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6
324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7
325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8
326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9
327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10

Line 324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7

320: ,p_ppr_attribute3_o =>ben_ppr_shd.g_old_rec.ppr_attribute3
321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4
322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5
323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6
324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7
325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8
326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9
327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10
328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11

Line 325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8

321: ,p_ppr_attribute4_o =>ben_ppr_shd.g_old_rec.ppr_attribute4
322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5
323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6
324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7
325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8
326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9
327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10
328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11
329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12

Line 326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9

322: ,p_ppr_attribute5_o =>ben_ppr_shd.g_old_rec.ppr_attribute5
323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6
324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7
325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8
326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9
327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10
328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11
329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12
330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13

Line 327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10

323: ,p_ppr_attribute6_o =>ben_ppr_shd.g_old_rec.ppr_attribute6
324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7
325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8
326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9
327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10
328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11
329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12
330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13
331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14

Line 328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11

324: ,p_ppr_attribute7_o =>ben_ppr_shd.g_old_rec.ppr_attribute7
325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8
326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9
327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10
328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11
329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12
330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13
331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14
332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15

Line 329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12

325: ,p_ppr_attribute8_o =>ben_ppr_shd.g_old_rec.ppr_attribute8
326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9
327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10
328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11
329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12
330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13
331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14
332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15
333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16

Line 330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13

326: ,p_ppr_attribute9_o =>ben_ppr_shd.g_old_rec.ppr_attribute9
327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10
328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11
329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12
330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13
331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14
332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15
333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16
334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17

Line 331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14

327: ,p_ppr_attribute10_o =>ben_ppr_shd.g_old_rec.ppr_attribute10
328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11
329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12
330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13
331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14
332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15
333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16
334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17
335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18

Line 332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15

328: ,p_ppr_attribute11_o =>ben_ppr_shd.g_old_rec.ppr_attribute11
329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12
330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13
331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14
332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15
333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16
334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17
335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18
336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19

Line 333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16

329: ,p_ppr_attribute12_o =>ben_ppr_shd.g_old_rec.ppr_attribute12
330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13
331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14
332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15
333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16
334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17
335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18
336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19
337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20

Line 334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17

330: ,p_ppr_attribute13_o =>ben_ppr_shd.g_old_rec.ppr_attribute13
331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14
332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15
333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16
334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17
335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18
336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19
337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20
338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21

Line 335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18

331: ,p_ppr_attribute14_o =>ben_ppr_shd.g_old_rec.ppr_attribute14
332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15
333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16
334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17
335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18
336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19
337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20
338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21
339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22

Line 336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19

332: ,p_ppr_attribute15_o =>ben_ppr_shd.g_old_rec.ppr_attribute15
333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16
334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17
335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18
336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19
337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20
338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21
339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22
340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23

Line 337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20

333: ,p_ppr_attribute16_o =>ben_ppr_shd.g_old_rec.ppr_attribute16
334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17
335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18
336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19
337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20
338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21
339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22
340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23
341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24

Line 338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21

334: ,p_ppr_attribute17_o =>ben_ppr_shd.g_old_rec.ppr_attribute17
335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18
336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19
337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20
338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21
339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22
340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23
341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24
342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25

Line 339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22

335: ,p_ppr_attribute18_o =>ben_ppr_shd.g_old_rec.ppr_attribute18
336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19
337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20
338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21
339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22
340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23
341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24
342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25
343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26

Line 340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23

336: ,p_ppr_attribute19_o =>ben_ppr_shd.g_old_rec.ppr_attribute19
337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20
338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21
339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22
340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23
341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24
342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25
343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26
344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27

Line 341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24

337: ,p_ppr_attribute20_o =>ben_ppr_shd.g_old_rec.ppr_attribute20
338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21
339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22
340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23
341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24
342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25
343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26
344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27
345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28

Line 342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25

338: ,p_ppr_attribute21_o =>ben_ppr_shd.g_old_rec.ppr_attribute21
339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22
340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23
341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24
342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25
343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26
344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27
345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28
346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29

Line 343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26

339: ,p_ppr_attribute22_o =>ben_ppr_shd.g_old_rec.ppr_attribute22
340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23
341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24
342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25
343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26
344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27
345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28
346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29
347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30

Line 344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27

340: ,p_ppr_attribute23_o =>ben_ppr_shd.g_old_rec.ppr_attribute23
341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24
342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25
343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26
344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27
345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28
346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29
347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30
348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id

Line 345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28

341: ,p_ppr_attribute24_o =>ben_ppr_shd.g_old_rec.ppr_attribute24
342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25
343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26
344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27
345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28
346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29
347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30
348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id
349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id

Line 346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29

342: ,p_ppr_attribute25_o =>ben_ppr_shd.g_old_rec.ppr_attribute25
343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26
344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27
345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28
346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29
347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30
348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id
349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id
350: ,p_program_id_o =>ben_ppr_shd.g_old_rec.program_id

Line 347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30

343: ,p_ppr_attribute26_o =>ben_ppr_shd.g_old_rec.ppr_attribute26
344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27
345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28
346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29
347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30
348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id
349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id
350: ,p_program_id_o =>ben_ppr_shd.g_old_rec.program_id
351: ,p_program_update_date_o =>ben_ppr_shd.g_old_rec.program_update_date

Line 348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id

344: ,p_ppr_attribute27_o =>ben_ppr_shd.g_old_rec.ppr_attribute27
345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28
346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29
347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30
348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id
349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id
350: ,p_program_id_o =>ben_ppr_shd.g_old_rec.program_id
351: ,p_program_update_date_o =>ben_ppr_shd.g_old_rec.program_update_date
352: ,p_object_version_number_o =>ben_ppr_shd.g_old_rec.object_version_number

Line 349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id

345: ,p_ppr_attribute28_o =>ben_ppr_shd.g_old_rec.ppr_attribute28
346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29
347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30
348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id
349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id
350: ,p_program_id_o =>ben_ppr_shd.g_old_rec.program_id
351: ,p_program_update_date_o =>ben_ppr_shd.g_old_rec.program_update_date
352: ,p_object_version_number_o =>ben_ppr_shd.g_old_rec.object_version_number
353: );

Line 350: ,p_program_id_o =>ben_ppr_shd.g_old_rec.program_id

346: ,p_ppr_attribute29_o =>ben_ppr_shd.g_old_rec.ppr_attribute29
347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30
348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id
349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id
350: ,p_program_id_o =>ben_ppr_shd.g_old_rec.program_id
351: ,p_program_update_date_o =>ben_ppr_shd.g_old_rec.program_update_date
352: ,p_object_version_number_o =>ben_ppr_shd.g_old_rec.object_version_number
353: );
354: --

Line 351: ,p_program_update_date_o =>ben_ppr_shd.g_old_rec.program_update_date

347: ,p_ppr_attribute30_o =>ben_ppr_shd.g_old_rec.ppr_attribute30
348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id
349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id
350: ,p_program_id_o =>ben_ppr_shd.g_old_rec.program_id
351: ,p_program_update_date_o =>ben_ppr_shd.g_old_rec.program_update_date
352: ,p_object_version_number_o =>ben_ppr_shd.g_old_rec.object_version_number
353: );
354: --
355: exception

Line 352: ,p_object_version_number_o =>ben_ppr_shd.g_old_rec.object_version_number

348: ,p_request_id_o =>ben_ppr_shd.g_old_rec.request_id
349: ,p_program_application_id_o =>ben_ppr_shd.g_old_rec.program_application_id
350: ,p_program_id_o =>ben_ppr_shd.g_old_rec.program_id
351: ,p_program_update_date_o =>ben_ppr_shd.g_old_rec.program_update_date
352: ,p_object_version_number_o =>ben_ppr_shd.g_old_rec.object_version_number
353: );
354: --
355: exception
356: --

Line 376: p_rec in out nocopy ben_ppr_shd.g_rec_type,

372: -- |---------------------------------< del >----------------------------------|
373: -- ----------------------------------------------------------------------------
374: Procedure del
375: (
376: p_rec in out nocopy ben_ppr_shd.g_rec_type,
377: p_effective_date in date,
378: p_datetrack_mode in varchar2
379: ) is
380: --

Line 394: ben_ppr_shd.lck

390: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
391: --
392: -- We must lock the row which we need to delete.
393: --
394: ben_ppr_shd.lck
395: (p_effective_date => p_effective_date,
396: p_datetrack_mode => p_datetrack_mode,
397: p_prmry_care_prvdr_id => p_rec.prmry_care_prvdr_id,
398: p_object_version_number => p_rec.object_version_number,

Line 452: l_rec ben_ppr_shd.g_rec_type;

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