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_PBN_DEL dependencies on BEN_PBN_SHD

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

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

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

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

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

83: delete from ben_pl_bnf_f
84: where pl_bnf_id = p_rec.pl_bnf_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_pbn_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_pbn_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_pbn_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_pbn_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_pbn_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_pbn_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_pbn_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pbn_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pbn_shd.g_old_rec.business_group_id
312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id
313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id

Line 310: ,p_effective_end_date_o =>ben_pbn_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_pbn_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pbn_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pbn_shd.g_old_rec.business_group_id
312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id
313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id
314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id

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

307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pbn_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pbn_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pbn_shd.g_old_rec.business_group_id
312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id
313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id
314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id
315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id

Line 312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pbn_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pbn_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pbn_shd.g_old_rec.business_group_id
312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id
313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id
314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id
315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id
316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd

Line 313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id

309: ,p_effective_start_date_o =>ben_pbn_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pbn_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pbn_shd.g_old_rec.business_group_id
312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id
313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id
314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id
315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id
316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd
317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num

Line 314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id

310: ,p_effective_end_date_o =>ben_pbn_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pbn_shd.g_old_rec.business_group_id
312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id
313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id
314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id
315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id
316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd
317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num
318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val

Line 315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id

311: ,p_business_group_id_o =>ben_pbn_shd.g_old_rec.business_group_id
312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id
313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id
314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id
315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id
316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd
317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num
318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val
319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom

Line 316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd

312: ,p_prtt_enrt_rslt_id_o =>ben_pbn_shd.g_old_rec.prtt_enrt_rslt_id
313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id
314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id
315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id
316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd
317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num
318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val
319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom
320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt

Line 317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num

313: ,p_bnf_person_id_o =>ben_pbn_shd.g_old_rec.bnf_person_id
314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id
315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id
316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd
317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num
318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val
319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom
320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt
321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt

Line 318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val

314: ,p_organization_id_o =>ben_pbn_shd.g_old_rec.organization_id
315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id
316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd
317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num
318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val
319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom
320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt
321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt
322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt

Line 319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom

315: ,p_ttee_person_id_o =>ben_pbn_shd.g_old_rec.ttee_person_id
316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd
317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num
318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val
319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom
320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt
321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt
322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt
323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category

Line 320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt

316: ,p_prmry_cntngnt_cd_o =>ben_pbn_shd.g_old_rec.prmry_cntngnt_cd
317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num
318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val
319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom
320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt
321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt
322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt
323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category
324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1

Line 321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt

317: ,p_pct_dsgd_num_o =>ben_pbn_shd.g_old_rec.pct_dsgd_num
318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val
319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom
320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt
321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt
322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt
323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category
324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1
325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2

Line 322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt

318: ,p_amt_dsgd_val_o =>ben_pbn_shd.g_old_rec.amt_dsgd_val
319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom
320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt
321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt
322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt
323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category
324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1
325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2
326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3

Line 323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category

319: ,p_amt_dsgd_uom_o =>ben_pbn_shd.g_old_rec.amt_dsgd_uom
320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt
321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt
322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt
323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category
324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1
325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2
326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3
327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4

Line 324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1

320: ,p_dsgn_strt_dt_o =>ben_pbn_shd.g_old_rec.dsgn_strt_dt
321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt
322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt
323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category
324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1
325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2
326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3
327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4
328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5

Line 325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2

321: ,p_dsgn_thru_dt_o =>ben_pbn_shd.g_old_rec.dsgn_thru_dt
322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt
323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category
324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1
325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2
326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3
327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4
328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5
329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6

Line 326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3

322: ,p_addl_instrn_txt_o =>ben_pbn_shd.g_old_rec.addl_instrn_txt
323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category
324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1
325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2
326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3
327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4
328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5
329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6
330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7

Line 327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4

323: ,p_pbn_attribute_category_o =>ben_pbn_shd.g_old_rec.pbn_attribute_category
324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1
325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2
326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3
327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4
328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5
329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6
330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7
331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8

Line 328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5

324: ,p_pbn_attribute1_o =>ben_pbn_shd.g_old_rec.pbn_attribute1
325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2
326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3
327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4
328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5
329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6
330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7
331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8
332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9

Line 329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6

325: ,p_pbn_attribute2_o =>ben_pbn_shd.g_old_rec.pbn_attribute2
326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3
327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4
328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5
329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6
330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7
331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8
332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9
333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10

Line 330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7

326: ,p_pbn_attribute3_o =>ben_pbn_shd.g_old_rec.pbn_attribute3
327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4
328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5
329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6
330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7
331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8
332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9
333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10
334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11

Line 331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8

327: ,p_pbn_attribute4_o =>ben_pbn_shd.g_old_rec.pbn_attribute4
328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5
329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6
330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7
331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8
332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9
333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10
334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11
335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12

Line 332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9

328: ,p_pbn_attribute5_o =>ben_pbn_shd.g_old_rec.pbn_attribute5
329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6
330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7
331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8
332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9
333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10
334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11
335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12
336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13

Line 333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10

329: ,p_pbn_attribute6_o =>ben_pbn_shd.g_old_rec.pbn_attribute6
330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7
331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8
332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9
333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10
334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11
335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12
336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13
337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14

Line 334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11

330: ,p_pbn_attribute7_o =>ben_pbn_shd.g_old_rec.pbn_attribute7
331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8
332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9
333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10
334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11
335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12
336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13
337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14
338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15

Line 335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12

331: ,p_pbn_attribute8_o =>ben_pbn_shd.g_old_rec.pbn_attribute8
332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9
333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10
334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11
335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12
336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13
337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14
338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15
339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16

Line 336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13

332: ,p_pbn_attribute9_o =>ben_pbn_shd.g_old_rec.pbn_attribute9
333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10
334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11
335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12
336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13
337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14
338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15
339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16
340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17

Line 337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14

333: ,p_pbn_attribute10_o =>ben_pbn_shd.g_old_rec.pbn_attribute10
334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11
335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12
336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13
337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14
338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15
339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16
340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17
341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18

Line 338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15

334: ,p_pbn_attribute11_o =>ben_pbn_shd.g_old_rec.pbn_attribute11
335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12
336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13
337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14
338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15
339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16
340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17
341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18
342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19

Line 339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16

335: ,p_pbn_attribute12_o =>ben_pbn_shd.g_old_rec.pbn_attribute12
336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13
337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14
338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15
339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16
340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17
341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18
342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19
343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20

Line 340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17

336: ,p_pbn_attribute13_o =>ben_pbn_shd.g_old_rec.pbn_attribute13
337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14
338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15
339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16
340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17
341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18
342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19
343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20
344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21

Line 341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18

337: ,p_pbn_attribute14_o =>ben_pbn_shd.g_old_rec.pbn_attribute14
338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15
339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16
340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17
341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18
342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19
343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20
344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21
345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22

Line 342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19

338: ,p_pbn_attribute15_o =>ben_pbn_shd.g_old_rec.pbn_attribute15
339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16
340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17
341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18
342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19
343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20
344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21
345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22
346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23

Line 343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20

339: ,p_pbn_attribute16_o =>ben_pbn_shd.g_old_rec.pbn_attribute16
340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17
341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18
342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19
343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20
344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21
345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22
346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23
347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24

Line 344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21

340: ,p_pbn_attribute17_o =>ben_pbn_shd.g_old_rec.pbn_attribute17
341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18
342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19
343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20
344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21
345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22
346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23
347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24
348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25

Line 345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22

341: ,p_pbn_attribute18_o =>ben_pbn_shd.g_old_rec.pbn_attribute18
342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19
343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20
344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21
345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22
346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23
347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24
348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25
349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26

Line 346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23

342: ,p_pbn_attribute19_o =>ben_pbn_shd.g_old_rec.pbn_attribute19
343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20
344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21
345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22
346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23
347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24
348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25
349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26
350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27

Line 347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24

343: ,p_pbn_attribute20_o =>ben_pbn_shd.g_old_rec.pbn_attribute20
344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21
345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22
346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23
347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24
348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25
349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26
350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27
351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28

Line 348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25

344: ,p_pbn_attribute21_o =>ben_pbn_shd.g_old_rec.pbn_attribute21
345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22
346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23
347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24
348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25
349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26
350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27
351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28
352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29

Line 349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26

345: ,p_pbn_attribute22_o =>ben_pbn_shd.g_old_rec.pbn_attribute22
346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23
347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24
348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25
349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26
350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27
351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28
352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29
353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30

Line 350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27

346: ,p_pbn_attribute23_o =>ben_pbn_shd.g_old_rec.pbn_attribute23
347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24
348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25
349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26
350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27
351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28
352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29
353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30
354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id

Line 351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28

347: ,p_pbn_attribute24_o =>ben_pbn_shd.g_old_rec.pbn_attribute24
348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25
349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26
350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27
351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28
352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29
353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30
354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id
355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id

Line 352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29

348: ,p_pbn_attribute25_o =>ben_pbn_shd.g_old_rec.pbn_attribute25
349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26
350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27
351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28
352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29
353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30
354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id
355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id
356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id

Line 353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30

349: ,p_pbn_attribute26_o =>ben_pbn_shd.g_old_rec.pbn_attribute26
350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27
351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28
352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29
353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30
354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id
355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id
356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id
357: ,p_program_update_date_o =>ben_pbn_shd.g_old_rec.program_update_date

Line 354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id

350: ,p_pbn_attribute27_o =>ben_pbn_shd.g_old_rec.pbn_attribute27
351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28
352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29
353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30
354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id
355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id
356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id
357: ,p_program_update_date_o =>ben_pbn_shd.g_old_rec.program_update_date
358: ,p_object_version_number_o =>ben_pbn_shd.g_old_rec.object_version_number

Line 355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id

351: ,p_pbn_attribute28_o =>ben_pbn_shd.g_old_rec.pbn_attribute28
352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29
353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30
354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id
355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id
356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id
357: ,p_program_update_date_o =>ben_pbn_shd.g_old_rec.program_update_date
358: ,p_object_version_number_o =>ben_pbn_shd.g_old_rec.object_version_number
359: ,p_per_in_ler_id_o =>ben_pbn_shd.g_old_rec.per_in_ler_id

Line 356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id

352: ,p_pbn_attribute29_o =>ben_pbn_shd.g_old_rec.pbn_attribute29
353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30
354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id
355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id
356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id
357: ,p_program_update_date_o =>ben_pbn_shd.g_old_rec.program_update_date
358: ,p_object_version_number_o =>ben_pbn_shd.g_old_rec.object_version_number
359: ,p_per_in_ler_id_o =>ben_pbn_shd.g_old_rec.per_in_ler_id
360: );

Line 357: ,p_program_update_date_o =>ben_pbn_shd.g_old_rec.program_update_date

353: ,p_pbn_attribute30_o =>ben_pbn_shd.g_old_rec.pbn_attribute30
354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id
355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id
356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id
357: ,p_program_update_date_o =>ben_pbn_shd.g_old_rec.program_update_date
358: ,p_object_version_number_o =>ben_pbn_shd.g_old_rec.object_version_number
359: ,p_per_in_ler_id_o =>ben_pbn_shd.g_old_rec.per_in_ler_id
360: );
361: --

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

354: ,p_request_id_o =>ben_pbn_shd.g_old_rec.request_id
355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id
356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id
357: ,p_program_update_date_o =>ben_pbn_shd.g_old_rec.program_update_date
358: ,p_object_version_number_o =>ben_pbn_shd.g_old_rec.object_version_number
359: ,p_per_in_ler_id_o =>ben_pbn_shd.g_old_rec.per_in_ler_id
360: );
361: --
362: exception

Line 359: ,p_per_in_ler_id_o =>ben_pbn_shd.g_old_rec.per_in_ler_id

355: ,p_program_application_id_o =>ben_pbn_shd.g_old_rec.program_application_id
356: ,p_program_id_o =>ben_pbn_shd.g_old_rec.program_id
357: ,p_program_update_date_o =>ben_pbn_shd.g_old_rec.program_update_date
358: ,p_object_version_number_o =>ben_pbn_shd.g_old_rec.object_version_number
359: ,p_per_in_ler_id_o =>ben_pbn_shd.g_old_rec.per_in_ler_id
360: );
361: --
362: exception
363: --

Line 383: p_rec in out nocopy ben_pbn_shd.g_rec_type,

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

Line 401: ben_pbn_shd.lck

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

Line 459: l_rec ben_pbn_shd.g_rec_type;

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