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_PRC_DEL dependencies on BEN_PRC_SHD

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

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

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

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

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

83: delete from ben_prtt_reimbmt_rqst_f
84: where prtt_reimbmt_rqst_id = p_rec.prtt_reimbmt_rqst_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_prc_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_prc_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_prc_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_prc_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_prc_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_prc_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_prc_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
311: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num

Line 310: ,p_effective_end_date_o =>ben_prc_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_prc_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
311: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt

Line 311: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt

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_prc_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
311: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom

Line 312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_prc_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
311: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num

Line 313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num

309: ,p_effective_start_date_o =>ben_prc_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
311: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd

Line 314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt

310: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
311: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd

Line 315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom

311: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd

Line 316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num

312: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id

Line 317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd

313: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id

Line 318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd

314: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id

Line 319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd

315: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id

Line 320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id

316: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id

Line 321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id

317: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id

Line 322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id

318: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id

Line 323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id

319: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id

Line 324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id

320: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id

Line 325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id

321: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1

Line 326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id

322: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2

Line 327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id

323: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1

Line 328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id

324: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2

Line 329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1

325: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category

Line 330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2

326: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1

Line 331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1

327: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2

Line 332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2

328: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3

Line 333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category

329: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4

Line 334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1

330: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5

Line 335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2

331: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6

Line 336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3

332: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7

Line 337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4

333: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8

Line 338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5

334: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9

Line 339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6

335: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10

Line 340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7

336: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11

Line 341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8

337: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12

Line 342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9

338: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13

Line 343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10

339: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14

Line 344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11

340: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15

Line 345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12

341: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16

Line 346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13

342: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17

Line 347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14

343: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18

Line 348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15

344: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19

Line 349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16

345: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20

Line 350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17

346: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21

Line 351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18

347: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22

Line 352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19

348: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23

Line 353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20

349: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24

Line 354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21

350: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25

Line 355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22

351: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26

Line 356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23

352: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27

Line 357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24

353: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28

Line 358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25

354: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
362: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29

Line 359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26

355: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
362: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
363: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30

Line 360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27

356: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
362: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
363: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
364: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number

Line 361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28

357: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
362: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
363: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
364: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
365: );

Line 362: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29

358: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
362: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
363: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
364: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
365: );
366: --

Line 363: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30

359: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
362: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
363: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
364: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
365: );
366: --
367: exception

Line 364: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number

360: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
361: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
362: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
363: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
364: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
365: );
366: --
367: exception
368: --

Line 388: p_rec in out nocopy ben_prc_shd.g_rec_type,

384: -- |---------------------------------< del >----------------------------------|
385: -- ----------------------------------------------------------------------------
386: Procedure del
387: (
388: p_rec in out nocopy ben_prc_shd.g_rec_type,
389: p_effective_date in date,
390: p_datetrack_mode in varchar2
391: ) is
392: --

Line 406: ben_prc_shd.lck

402: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
403: --
404: -- We must lock the row which we need to delete.
405: --
406: ben_prc_shd.lck
407: (p_effective_date => p_effective_date,
408: p_datetrack_mode => p_datetrack_mode,
409: p_prtt_reimbmt_rqst_id => p_rec.prtt_reimbmt_rqst_id,
410: p_object_version_number => p_rec.object_version_number,

Line 464: l_rec ben_prc_shd.g_rec_type;

460: p_effective_date in date,
461: p_datetrack_mode in varchar2
462: ) is
463: --
464: l_rec ben_prc_shd.g_rec_type;
465: l_proc varchar2(72) := g_package||'del';
466: --
467: Begin
468: hr_utility.set_location('Entering:'||l_proc, 5);