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_PRD_DEL dependencies on BEN_PRD_SHD

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

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

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

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

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

83: delete from ben_paird_rt_f
84: where paird_rt_id = p_rec.paird_rt_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_prd_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_prd_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_prd_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_prd_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_prd_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_prd_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_prd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prd_shd.g_old_rec.effective_end_date
311: ,p_use_parnt_ded_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag
312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag
313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag

Line 310: ,p_effective_end_date_o =>ben_prd_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_prd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prd_shd.g_old_rec.effective_end_date
311: ,p_use_parnt_ded_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag
312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag
313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag
314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag

Line 311: ,p_use_parnt_ded_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag

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_prd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prd_shd.g_old_rec.effective_end_date
311: ,p_use_parnt_ded_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag
312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag
313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag
314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag
315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag

Line 312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_prd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prd_shd.g_old_rec.effective_end_date
311: ,p_use_parnt_ded_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag
312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag
313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag
314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag
315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag
316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag

Line 313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag

309: ,p_effective_start_date_o =>ben_prd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prd_shd.g_old_rec.effective_end_date
311: ,p_use_parnt_ded_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag
312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag
313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag
314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag
315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag
316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag
317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt

Line 314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag

310: ,p_effective_end_date_o =>ben_prd_shd.g_old_rec.effective_end_date
311: ,p_use_parnt_ded_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag
312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag
313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag
314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag
315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag
316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag
317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt
318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt

Line 315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag

311: ,p_use_parnt_ded_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_ded_sched_flag
312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag
313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag
314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag
315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag
316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag
317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt
318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt
319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num

Line 316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag

312: ,p_asn_on_chc_of_parnt_flag_o =>ben_prd_shd.g_old_rec.asn_on_chc_of_parnt_flag
313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag
314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag
315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag
316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag
317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt
318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt
319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num
320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num

Line 317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt

313: ,p_use_parnt_prtl_mo_cd_flag_o =>ben_prd_shd.g_old_rec.use_parnt_prtl_mo_cd_flag
314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag
315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag
316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag
317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt
318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt
319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num
320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num
321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag

Line 318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt

314: ,p_alloc_sme_as_parnt_flag_o =>ben_prd_shd.g_old_rec.alloc_sme_as_parnt_flag
315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag
316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag
317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt
318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt
319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num
320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num
321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag
322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag

Line 319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num

315: ,p_use_parnt_pymt_sched_flag_o =>ben_prd_shd.g_old_rec.use_parnt_pymt_sched_flag
316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag
317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt
318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt
319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num
320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num
321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag
322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag
323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag

Line 320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num

316: ,p_no_cmbnd_mx_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_amt_dfnd_flag
317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt
318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt
319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num
320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num
321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag
322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag
323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag
324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id

Line 321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag

317: ,p_cmbnd_mx_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mx_amt
318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt
319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num
320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num
321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag
322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag
323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag
324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id
325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id

Line 322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag

318: ,p_cmbnd_mn_amt_o =>ben_prd_shd.g_old_rec.cmbnd_mn_amt
319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num
320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num
321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag
322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag
323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag
324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id
325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id
326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id

Line 323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag

319: ,p_cmbnd_mx_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mx_pct_num
320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num
321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag
322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag
323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag
324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id
325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id
326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id
327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category

Line 324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id

320: ,p_cmbnd_mn_pct_num_o =>ben_prd_shd.g_old_rec.cmbnd_mn_pct_num
321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag
322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag
323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag
324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id
325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id
326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id
327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category
328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1

Line 325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id

321: ,p_no_cmbnd_mn_amt_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_amt_dfnd_flag
322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag
323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag
324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id
325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id
326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id
327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category
328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1
329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2

Line 326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id

322: ,p_no_cmbnd_mn_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mn_pct_dfnd_flag
323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag
324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id
325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id
326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id
327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category
328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1
329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2
330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3

Line 327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category

323: ,p_no_cmbnd_mx_pct_dfnd_flag_o =>ben_prd_shd.g_old_rec.no_cmbnd_mx_pct_dfnd_flag
324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id
325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id
326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id
327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category
328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1
329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2
330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3
331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4

Line 328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1

324: ,p_parnt_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.parnt_acty_base_rt_id
325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id
326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id
327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category
328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1
329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2
330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3
331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4
332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5

Line 329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2

325: ,p_chld_acty_base_rt_id_o =>ben_prd_shd.g_old_rec.chld_acty_base_rt_id
326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id
327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category
328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1
329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2
330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3
331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4
332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5
333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6

Line 330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3

326: ,p_business_group_id_o =>ben_prd_shd.g_old_rec.business_group_id
327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category
328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1
329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2
330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3
331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4
332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5
333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6
334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7

Line 331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4

327: ,p_prd_attribute_category_o =>ben_prd_shd.g_old_rec.prd_attribute_category
328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1
329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2
330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3
331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4
332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5
333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6
334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7
335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8

Line 332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5

328: ,p_prd_attribute1_o =>ben_prd_shd.g_old_rec.prd_attribute1
329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2
330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3
331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4
332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5
333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6
334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7
335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8
336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9

Line 333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6

329: ,p_prd_attribute2_o =>ben_prd_shd.g_old_rec.prd_attribute2
330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3
331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4
332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5
333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6
334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7
335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8
336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9
337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10

Line 334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7

330: ,p_prd_attribute3_o =>ben_prd_shd.g_old_rec.prd_attribute3
331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4
332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5
333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6
334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7
335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8
336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9
337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10
338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11

Line 335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8

331: ,p_prd_attribute4_o =>ben_prd_shd.g_old_rec.prd_attribute4
332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5
333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6
334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7
335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8
336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9
337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10
338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11
339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12

Line 336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9

332: ,p_prd_attribute5_o =>ben_prd_shd.g_old_rec.prd_attribute5
333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6
334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7
335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8
336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9
337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10
338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11
339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12
340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13

Line 337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10

333: ,p_prd_attribute6_o =>ben_prd_shd.g_old_rec.prd_attribute6
334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7
335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8
336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9
337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10
338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11
339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12
340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13
341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14

Line 338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11

334: ,p_prd_attribute7_o =>ben_prd_shd.g_old_rec.prd_attribute7
335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8
336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9
337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10
338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11
339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12
340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13
341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14
342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15

Line 339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12

335: ,p_prd_attribute8_o =>ben_prd_shd.g_old_rec.prd_attribute8
336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9
337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10
338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11
339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12
340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13
341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14
342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15
343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16

Line 340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13

336: ,p_prd_attribute9_o =>ben_prd_shd.g_old_rec.prd_attribute9
337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10
338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11
339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12
340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13
341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14
342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15
343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16
344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17

Line 341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14

337: ,p_prd_attribute10_o =>ben_prd_shd.g_old_rec.prd_attribute10
338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11
339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12
340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13
341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14
342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15
343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16
344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17
345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18

Line 342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15

338: ,p_prd_attribute11_o =>ben_prd_shd.g_old_rec.prd_attribute11
339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12
340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13
341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14
342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15
343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16
344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17
345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18
346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19

Line 343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16

339: ,p_prd_attribute12_o =>ben_prd_shd.g_old_rec.prd_attribute12
340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13
341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14
342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15
343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16
344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17
345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18
346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19
347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20

Line 344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17

340: ,p_prd_attribute13_o =>ben_prd_shd.g_old_rec.prd_attribute13
341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14
342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15
343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16
344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17
345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18
346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19
347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20
348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21

Line 345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18

341: ,p_prd_attribute14_o =>ben_prd_shd.g_old_rec.prd_attribute14
342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15
343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16
344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17
345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18
346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19
347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20
348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21
349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22

Line 346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19

342: ,p_prd_attribute15_o =>ben_prd_shd.g_old_rec.prd_attribute15
343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16
344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17
345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18
346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19
347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20
348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21
349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22
350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23

Line 347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20

343: ,p_prd_attribute16_o =>ben_prd_shd.g_old_rec.prd_attribute16
344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17
345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18
346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19
347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20
348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21
349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22
350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23
351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24

Line 348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21

344: ,p_prd_attribute17_o =>ben_prd_shd.g_old_rec.prd_attribute17
345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18
346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19
347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20
348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21
349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22
350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23
351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24
352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25

Line 349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22

345: ,p_prd_attribute18_o =>ben_prd_shd.g_old_rec.prd_attribute18
346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19
347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20
348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21
349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22
350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23
351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24
352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25
353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26

Line 350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23

346: ,p_prd_attribute19_o =>ben_prd_shd.g_old_rec.prd_attribute19
347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20
348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21
349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22
350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23
351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24
352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25
353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26
354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27

Line 351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24

347: ,p_prd_attribute20_o =>ben_prd_shd.g_old_rec.prd_attribute20
348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21
349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22
350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23
351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24
352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25
353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26
354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27
355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28

Line 352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25

348: ,p_prd_attribute21_o =>ben_prd_shd.g_old_rec.prd_attribute21
349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22
350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23
351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24
352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25
353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26
354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27
355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28
356: ,p_prd_attribute29_o =>ben_prd_shd.g_old_rec.prd_attribute29

Line 353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26

349: ,p_prd_attribute22_o =>ben_prd_shd.g_old_rec.prd_attribute22
350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23
351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24
352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25
353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26
354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27
355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28
356: ,p_prd_attribute29_o =>ben_prd_shd.g_old_rec.prd_attribute29
357: ,p_prd_attribute30_o =>ben_prd_shd.g_old_rec.prd_attribute30

Line 354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27

350: ,p_prd_attribute23_o =>ben_prd_shd.g_old_rec.prd_attribute23
351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24
352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25
353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26
354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27
355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28
356: ,p_prd_attribute29_o =>ben_prd_shd.g_old_rec.prd_attribute29
357: ,p_prd_attribute30_o =>ben_prd_shd.g_old_rec.prd_attribute30
358: ,p_object_version_number_o =>ben_prd_shd.g_old_rec.object_version_number

Line 355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28

351: ,p_prd_attribute24_o =>ben_prd_shd.g_old_rec.prd_attribute24
352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25
353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26
354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27
355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28
356: ,p_prd_attribute29_o =>ben_prd_shd.g_old_rec.prd_attribute29
357: ,p_prd_attribute30_o =>ben_prd_shd.g_old_rec.prd_attribute30
358: ,p_object_version_number_o =>ben_prd_shd.g_old_rec.object_version_number
359: );

Line 356: ,p_prd_attribute29_o =>ben_prd_shd.g_old_rec.prd_attribute29

352: ,p_prd_attribute25_o =>ben_prd_shd.g_old_rec.prd_attribute25
353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26
354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27
355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28
356: ,p_prd_attribute29_o =>ben_prd_shd.g_old_rec.prd_attribute29
357: ,p_prd_attribute30_o =>ben_prd_shd.g_old_rec.prd_attribute30
358: ,p_object_version_number_o =>ben_prd_shd.g_old_rec.object_version_number
359: );
360: --

Line 357: ,p_prd_attribute30_o =>ben_prd_shd.g_old_rec.prd_attribute30

353: ,p_prd_attribute26_o =>ben_prd_shd.g_old_rec.prd_attribute26
354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27
355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28
356: ,p_prd_attribute29_o =>ben_prd_shd.g_old_rec.prd_attribute29
357: ,p_prd_attribute30_o =>ben_prd_shd.g_old_rec.prd_attribute30
358: ,p_object_version_number_o =>ben_prd_shd.g_old_rec.object_version_number
359: );
360: --
361: exception

Line 358: ,p_object_version_number_o =>ben_prd_shd.g_old_rec.object_version_number

354: ,p_prd_attribute27_o =>ben_prd_shd.g_old_rec.prd_attribute27
355: ,p_prd_attribute28_o =>ben_prd_shd.g_old_rec.prd_attribute28
356: ,p_prd_attribute29_o =>ben_prd_shd.g_old_rec.prd_attribute29
357: ,p_prd_attribute30_o =>ben_prd_shd.g_old_rec.prd_attribute30
358: ,p_object_version_number_o =>ben_prd_shd.g_old_rec.object_version_number
359: );
360: --
361: exception
362: --

Line 382: p_rec in out nocopy ben_prd_shd.g_rec_type,

378: -- |---------------------------------< del >----------------------------------|
379: -- ----------------------------------------------------------------------------
380: Procedure del
381: (
382: p_rec in out nocopy ben_prd_shd.g_rec_type,
383: p_effective_date in date,
384: p_datetrack_mode in varchar2
385: ) is
386: --

Line 400: ben_prd_shd.lck

396: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
397: --
398: -- We must lock the row which we need to delete.
399: --
400: ben_prd_shd.lck
401: (p_effective_date => p_effective_date,
402: p_datetrack_mode => p_datetrack_mode,
403: p_paird_rt_id => p_rec.paird_rt_id,
404: p_object_version_number => p_rec.object_version_number,

Line 458: l_rec ben_prd_shd.g_rec_type;

454: p_effective_date in date,
455: p_datetrack_mode in varchar2
456: ) is
457: --
458: l_rec ben_prd_shd.g_rec_type;
459: l_proc varchar2(72) := g_package||'del';
460: --
461: Begin
462: hr_utility.set_location('Entering:'||l_proc, 5);