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_PRT_UPD dependencies on BEN_PRT_SHD

Line 58: (p_rec in out nocopy ben_prt_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_prt_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is

Line 81: ben_prt_shd.g_api_dml := true; -- Set the api dml status

77: (p_base_table_name => 'ben_poe_rt_f',
78: p_base_key_column => 'poe_rt_id',
79: p_base_key_value => p_rec.poe_rt_id);
80: --
81: ben_prt_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_poe_rt_f Row
84: --
85: update ben_poe_rt_f

Line 134: ben_prt_shd.g_api_dml := false; -- Unset the api dml status

130: where poe_rt_id = p_rec.poe_rt_id
131: and effective_start_date = p_validation_start_date
132: and effective_end_date = p_validation_end_date;
133: --
134: ben_prt_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: -- Set the effective start and end dates
137: --
138: p_rec.effective_start_date := p_validation_start_date;

Line 146: ben_prt_shd.g_api_dml := false; -- Unset the api dml status

142: hr_utility.set_location(' Leaving:'||l_proc, 15);
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: ben_prt_shd.g_api_dml := false; -- Unset the api dml status
147: ben_prt_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated

Line 147: ben_prt_shd.constraint_error

143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: ben_prt_shd.g_api_dml := false; -- Unset the api dml status
147: ben_prt_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_prt_shd.g_api_dml := false; -- Unset the api dml status

Line 151: ben_prt_shd.g_api_dml := false; -- Unset the api dml status

147: ben_prt_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_prt_shd.g_api_dml := false; -- Unset the api dml status
152: ben_prt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_prt_shd.g_api_dml := false; -- Unset the api dml status

Line 152: ben_prt_shd.constraint_error

148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_prt_shd.g_api_dml := false; -- Unset the api dml status
152: ben_prt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_prt_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;

Line 155: ben_prt_shd.g_api_dml := false; -- Unset the api dml status

151: ben_prt_shd.g_api_dml := false; -- Unset the api dml status
152: ben_prt_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_prt_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End dt_update_dml;
158: --
159: -- ----------------------------------------------------------------------------

Line 191: (p_rec in out nocopy ben_prt_shd.g_rec_type,

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure update_dml
191: (p_rec in out nocopy ben_prt_shd.g_rec_type,
192: p_effective_date in date,
193: p_datetrack_mode in varchar2,
194: p_validation_start_date in date,
195: p_validation_end_date in date) is

Line 255: (p_rec in out nocopy ben_prt_shd.g_rec_type,

251: --
252: -- {End Of Comments}
253: -- ----------------------------------------------------------------------------
254: Procedure dt_pre_update
255: (p_rec in out nocopy ben_prt_shd.g_rec_type,
256: p_effective_date in date,
257: p_datetrack_mode in varchar2,
258: p_validation_start_date in date,
259: p_validation_end_date in date) is

Line 271: ben_prt_shd.upd_effective_end_date

267: hr_utility.set_location(l_proc, 10);
268: --
269: -- Update the current effective end date
270: --
271: ben_prt_shd.upd_effective_end_date
272: (p_effective_date => p_effective_date,
273: p_base_key_value => p_rec.poe_rt_id,
274: p_new_effective_end_date => (p_validation_start_date - 1),
275: p_validation_start_date => p_validation_start_date,

Line 340: (p_rec in out nocopy ben_prt_shd.g_rec_type,

336: --
337: -- {End Of Comments}
338: -- ----------------------------------------------------------------------------
339: Procedure pre_update
340: (p_rec in out nocopy ben_prt_shd.g_rec_type,
341: p_effective_date in date,
342: p_datetrack_mode in varchar2,
343: p_validation_start_date in date,
344: p_validation_end_date in date) is

Line 396: (p_rec in ben_prt_shd.g_rec_type,

392: --
393: -- {End Of Comments}
394: -- ----------------------------------------------------------------------------
395: Procedure post_update
396: (p_rec in ben_prt_shd.g_rec_type,
397: p_effective_date in date,
398: p_datetrack_mode in varchar2,
399: p_validation_start_date in date,
400: p_validation_end_date in date) is

Line 463: ,p_effective_start_date_o =>ben_prt_shd.g_old_rec.effective_start_date

459: ,p_effective_date =>p_effective_date
460: ,p_datetrack_mode =>p_datetrack_mode
461: ,p_validation_start_date =>p_validation_start_date
462: ,p_validation_end_date =>p_validation_end_date
463: ,p_effective_start_date_o =>ben_prt_shd.g_old_rec.effective_start_date
464: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
465: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag

Line 464: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date

460: ,p_datetrack_mode =>p_datetrack_mode
461: ,p_validation_start_date =>p_validation_start_date
462: ,p_validation_end_date =>p_validation_end_date
463: ,p_effective_start_date_o =>ben_prt_shd.g_old_rec.effective_start_date
464: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
465: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag

Line 465: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num

461: ,p_validation_start_date =>p_validation_start_date
462: ,p_validation_end_date =>p_validation_end_date
463: ,p_effective_start_date_o =>ben_prt_shd.g_old_rec.effective_start_date
464: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
465: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd

Line 466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num

462: ,p_validation_end_date =>p_validation_end_date
463: ,p_effective_start_date_o =>ben_prt_shd.g_old_rec.effective_start_date
464: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
465: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl

Line 467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag

463: ,p_effective_start_date_o =>ben_prt_shd.g_old_rec.effective_start_date
464: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
465: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom

Line 468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag

464: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
465: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id

Line 469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd

465: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id

Line 470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl

466: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category

Line 471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom

467: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1

Line 472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id

468: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2

Line 473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id

469: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3

Line 474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category

470: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4

Line 475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1

471: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5

Line 476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2

472: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6

Line 477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3

473: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7

Line 478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4

474: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8

Line 479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5

475: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9

Line 480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6

476: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10

Line 481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7

477: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11

Line 482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8

478: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12

Line 483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9

479: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13

Line 484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10

480: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14

Line 485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11

481: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15

Line 486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12

482: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16

Line 487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13

483: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17

Line 488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14

484: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18

Line 489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15

485: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19

Line 490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16

486: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20

Line 491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17

487: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21

Line 492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18

488: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22

Line 493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19

489: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23

Line 494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20

490: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24

Line 495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21

491: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25

Line 496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22

492: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26

Line 497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23

493: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27

Line 498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24

494: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28

Line 499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25

495: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29

Line 500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26

496: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
504: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30

Line 501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27

497: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
504: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
505: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number

Line 502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28

498: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
504: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
505: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
506: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag

Line 503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29

499: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
504: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
505: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
506: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag
507: );

Line 504: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30

500: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
504: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
505: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
506: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag
507: );
508: --

Line 505: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number

501: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
504: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
505: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
506: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag
507: );
508: --
509: exception

Line 506: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag

502: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
503: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
504: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
505: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
506: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag
507: );
508: --
509: exception
510: --

Line 568: Procedure convert_defs(p_rec in out nocopy ben_prt_shd.g_rec_type) is

564: -- Internal Row Handler Use Only.
565: --
566: -- {End Of Comments}
567: -- ----------------------------------------------------------------------------
568: Procedure convert_defs(p_rec in out nocopy ben_prt_shd.g_rec_type) is
569: --
570: l_proc varchar2(72) := g_package||'convert_defs';
571: --
572: Begin

Line 583: ben_prt_shd.g_old_rec.mn_poe_num;

579: -- is being used then we must set to the 'current' argument value.
580: --
581: If (p_rec.mn_poe_num = hr_api.g_number) then
582: p_rec.mn_poe_num :=
583: ben_prt_shd.g_old_rec.mn_poe_num;
584: End If;
585: If (p_rec.mx_poe_num = hr_api.g_number) then
586: p_rec.mx_poe_num :=
587: ben_prt_shd.g_old_rec.mx_poe_num;

Line 587: ben_prt_shd.g_old_rec.mx_poe_num;

583: ben_prt_shd.g_old_rec.mn_poe_num;
584: End If;
585: If (p_rec.mx_poe_num = hr_api.g_number) then
586: p_rec.mx_poe_num :=
587: ben_prt_shd.g_old_rec.mx_poe_num;
588: End If;
589: If (p_rec.no_mn_poe_flag = hr_api.g_varchar2) then
590: p_rec.no_mn_poe_flag :=
591: ben_prt_shd.g_old_rec.no_mn_poe_flag;

Line 591: ben_prt_shd.g_old_rec.no_mn_poe_flag;

587: ben_prt_shd.g_old_rec.mx_poe_num;
588: End If;
589: If (p_rec.no_mn_poe_flag = hr_api.g_varchar2) then
590: p_rec.no_mn_poe_flag :=
591: ben_prt_shd.g_old_rec.no_mn_poe_flag;
592: End If;
593: If (p_rec.no_mx_poe_flag = hr_api.g_varchar2) then
594: p_rec.no_mx_poe_flag :=
595: ben_prt_shd.g_old_rec.no_mx_poe_flag;

Line 595: ben_prt_shd.g_old_rec.no_mx_poe_flag;

591: ben_prt_shd.g_old_rec.no_mn_poe_flag;
592: End If;
593: If (p_rec.no_mx_poe_flag = hr_api.g_varchar2) then
594: p_rec.no_mx_poe_flag :=
595: ben_prt_shd.g_old_rec.no_mx_poe_flag;
596: End If;
597: If (p_rec.rndg_cd = hr_api.g_varchar2) then
598: p_rec.rndg_cd :=
599: ben_prt_shd.g_old_rec.rndg_cd;

Line 599: ben_prt_shd.g_old_rec.rndg_cd;

595: ben_prt_shd.g_old_rec.no_mx_poe_flag;
596: End If;
597: If (p_rec.rndg_cd = hr_api.g_varchar2) then
598: p_rec.rndg_cd :=
599: ben_prt_shd.g_old_rec.rndg_cd;
600: End If;
601: If (p_rec.rndg_rl = hr_api.g_number) then
602: p_rec.rndg_rl :=
603: ben_prt_shd.g_old_rec.rndg_rl;

Line 603: ben_prt_shd.g_old_rec.rndg_rl;

599: ben_prt_shd.g_old_rec.rndg_cd;
600: End If;
601: If (p_rec.rndg_rl = hr_api.g_number) then
602: p_rec.rndg_rl :=
603: ben_prt_shd.g_old_rec.rndg_rl;
604: End If;
605: If (p_rec.poe_nnmntry_uom = hr_api.g_varchar2) then
606: p_rec.poe_nnmntry_uom :=
607: ben_prt_shd.g_old_rec.poe_nnmntry_uom;

Line 607: ben_prt_shd.g_old_rec.poe_nnmntry_uom;

603: ben_prt_shd.g_old_rec.rndg_rl;
604: End If;
605: If (p_rec.poe_nnmntry_uom = hr_api.g_varchar2) then
606: p_rec.poe_nnmntry_uom :=
607: ben_prt_shd.g_old_rec.poe_nnmntry_uom;
608: End If;
609: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
610: p_rec.vrbl_rt_prfl_id :=
611: ben_prt_shd.g_old_rec.vrbl_rt_prfl_id;

Line 611: ben_prt_shd.g_old_rec.vrbl_rt_prfl_id;

607: ben_prt_shd.g_old_rec.poe_nnmntry_uom;
608: End If;
609: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
610: p_rec.vrbl_rt_prfl_id :=
611: ben_prt_shd.g_old_rec.vrbl_rt_prfl_id;
612: End If;
613: If (p_rec.business_group_id = hr_api.g_number) then
614: p_rec.business_group_id :=
615: ben_prt_shd.g_old_rec.business_group_id;

Line 615: ben_prt_shd.g_old_rec.business_group_id;

611: ben_prt_shd.g_old_rec.vrbl_rt_prfl_id;
612: End If;
613: If (p_rec.business_group_id = hr_api.g_number) then
614: p_rec.business_group_id :=
615: ben_prt_shd.g_old_rec.business_group_id;
616: End If;
617: If (p_rec.prt_attribute_category = hr_api.g_varchar2) then
618: p_rec.prt_attribute_category :=
619: ben_prt_shd.g_old_rec.prt_attribute_category;

Line 619: ben_prt_shd.g_old_rec.prt_attribute_category;

615: ben_prt_shd.g_old_rec.business_group_id;
616: End If;
617: If (p_rec.prt_attribute_category = hr_api.g_varchar2) then
618: p_rec.prt_attribute_category :=
619: ben_prt_shd.g_old_rec.prt_attribute_category;
620: End If;
621: If (p_rec.prt_attribute1 = hr_api.g_varchar2) then
622: p_rec.prt_attribute1 :=
623: ben_prt_shd.g_old_rec.prt_attribute1;

Line 623: ben_prt_shd.g_old_rec.prt_attribute1;

619: ben_prt_shd.g_old_rec.prt_attribute_category;
620: End If;
621: If (p_rec.prt_attribute1 = hr_api.g_varchar2) then
622: p_rec.prt_attribute1 :=
623: ben_prt_shd.g_old_rec.prt_attribute1;
624: End If;
625: If (p_rec.prt_attribute2 = hr_api.g_varchar2) then
626: p_rec.prt_attribute2 :=
627: ben_prt_shd.g_old_rec.prt_attribute2;

Line 627: ben_prt_shd.g_old_rec.prt_attribute2;

623: ben_prt_shd.g_old_rec.prt_attribute1;
624: End If;
625: If (p_rec.prt_attribute2 = hr_api.g_varchar2) then
626: p_rec.prt_attribute2 :=
627: ben_prt_shd.g_old_rec.prt_attribute2;
628: End If;
629: If (p_rec.prt_attribute3 = hr_api.g_varchar2) then
630: p_rec.prt_attribute3 :=
631: ben_prt_shd.g_old_rec.prt_attribute3;

Line 631: ben_prt_shd.g_old_rec.prt_attribute3;

627: ben_prt_shd.g_old_rec.prt_attribute2;
628: End If;
629: If (p_rec.prt_attribute3 = hr_api.g_varchar2) then
630: p_rec.prt_attribute3 :=
631: ben_prt_shd.g_old_rec.prt_attribute3;
632: End If;
633: If (p_rec.prt_attribute4 = hr_api.g_varchar2) then
634: p_rec.prt_attribute4 :=
635: ben_prt_shd.g_old_rec.prt_attribute4;

Line 635: ben_prt_shd.g_old_rec.prt_attribute4;

631: ben_prt_shd.g_old_rec.prt_attribute3;
632: End If;
633: If (p_rec.prt_attribute4 = hr_api.g_varchar2) then
634: p_rec.prt_attribute4 :=
635: ben_prt_shd.g_old_rec.prt_attribute4;
636: End If;
637: If (p_rec.prt_attribute5 = hr_api.g_varchar2) then
638: p_rec.prt_attribute5 :=
639: ben_prt_shd.g_old_rec.prt_attribute5;

Line 639: ben_prt_shd.g_old_rec.prt_attribute5;

635: ben_prt_shd.g_old_rec.prt_attribute4;
636: End If;
637: If (p_rec.prt_attribute5 = hr_api.g_varchar2) then
638: p_rec.prt_attribute5 :=
639: ben_prt_shd.g_old_rec.prt_attribute5;
640: End If;
641: If (p_rec.prt_attribute6 = hr_api.g_varchar2) then
642: p_rec.prt_attribute6 :=
643: ben_prt_shd.g_old_rec.prt_attribute6;

Line 643: ben_prt_shd.g_old_rec.prt_attribute6;

639: ben_prt_shd.g_old_rec.prt_attribute5;
640: End If;
641: If (p_rec.prt_attribute6 = hr_api.g_varchar2) then
642: p_rec.prt_attribute6 :=
643: ben_prt_shd.g_old_rec.prt_attribute6;
644: End If;
645: If (p_rec.prt_attribute7 = hr_api.g_varchar2) then
646: p_rec.prt_attribute7 :=
647: ben_prt_shd.g_old_rec.prt_attribute7;

Line 647: ben_prt_shd.g_old_rec.prt_attribute7;

643: ben_prt_shd.g_old_rec.prt_attribute6;
644: End If;
645: If (p_rec.prt_attribute7 = hr_api.g_varchar2) then
646: p_rec.prt_attribute7 :=
647: ben_prt_shd.g_old_rec.prt_attribute7;
648: End If;
649: If (p_rec.prt_attribute8 = hr_api.g_varchar2) then
650: p_rec.prt_attribute8 :=
651: ben_prt_shd.g_old_rec.prt_attribute8;

Line 651: ben_prt_shd.g_old_rec.prt_attribute8;

647: ben_prt_shd.g_old_rec.prt_attribute7;
648: End If;
649: If (p_rec.prt_attribute8 = hr_api.g_varchar2) then
650: p_rec.prt_attribute8 :=
651: ben_prt_shd.g_old_rec.prt_attribute8;
652: End If;
653: If (p_rec.prt_attribute9 = hr_api.g_varchar2) then
654: p_rec.prt_attribute9 :=
655: ben_prt_shd.g_old_rec.prt_attribute9;

Line 655: ben_prt_shd.g_old_rec.prt_attribute9;

651: ben_prt_shd.g_old_rec.prt_attribute8;
652: End If;
653: If (p_rec.prt_attribute9 = hr_api.g_varchar2) then
654: p_rec.prt_attribute9 :=
655: ben_prt_shd.g_old_rec.prt_attribute9;
656: End If;
657: If (p_rec.prt_attribute10 = hr_api.g_varchar2) then
658: p_rec.prt_attribute10 :=
659: ben_prt_shd.g_old_rec.prt_attribute10;

Line 659: ben_prt_shd.g_old_rec.prt_attribute10;

655: ben_prt_shd.g_old_rec.prt_attribute9;
656: End If;
657: If (p_rec.prt_attribute10 = hr_api.g_varchar2) then
658: p_rec.prt_attribute10 :=
659: ben_prt_shd.g_old_rec.prt_attribute10;
660: End If;
661: If (p_rec.prt_attribute11 = hr_api.g_varchar2) then
662: p_rec.prt_attribute11 :=
663: ben_prt_shd.g_old_rec.prt_attribute11;

Line 663: ben_prt_shd.g_old_rec.prt_attribute11;

659: ben_prt_shd.g_old_rec.prt_attribute10;
660: End If;
661: If (p_rec.prt_attribute11 = hr_api.g_varchar2) then
662: p_rec.prt_attribute11 :=
663: ben_prt_shd.g_old_rec.prt_attribute11;
664: End If;
665: If (p_rec.prt_attribute12 = hr_api.g_varchar2) then
666: p_rec.prt_attribute12 :=
667: ben_prt_shd.g_old_rec.prt_attribute12;

Line 667: ben_prt_shd.g_old_rec.prt_attribute12;

663: ben_prt_shd.g_old_rec.prt_attribute11;
664: End If;
665: If (p_rec.prt_attribute12 = hr_api.g_varchar2) then
666: p_rec.prt_attribute12 :=
667: ben_prt_shd.g_old_rec.prt_attribute12;
668: End If;
669: If (p_rec.prt_attribute13 = hr_api.g_varchar2) then
670: p_rec.prt_attribute13 :=
671: ben_prt_shd.g_old_rec.prt_attribute13;

Line 671: ben_prt_shd.g_old_rec.prt_attribute13;

667: ben_prt_shd.g_old_rec.prt_attribute12;
668: End If;
669: If (p_rec.prt_attribute13 = hr_api.g_varchar2) then
670: p_rec.prt_attribute13 :=
671: ben_prt_shd.g_old_rec.prt_attribute13;
672: End If;
673: If (p_rec.prt_attribute14 = hr_api.g_varchar2) then
674: p_rec.prt_attribute14 :=
675: ben_prt_shd.g_old_rec.prt_attribute14;

Line 675: ben_prt_shd.g_old_rec.prt_attribute14;

671: ben_prt_shd.g_old_rec.prt_attribute13;
672: End If;
673: If (p_rec.prt_attribute14 = hr_api.g_varchar2) then
674: p_rec.prt_attribute14 :=
675: ben_prt_shd.g_old_rec.prt_attribute14;
676: End If;
677: If (p_rec.prt_attribute15 = hr_api.g_varchar2) then
678: p_rec.prt_attribute15 :=
679: ben_prt_shd.g_old_rec.prt_attribute15;

Line 679: ben_prt_shd.g_old_rec.prt_attribute15;

675: ben_prt_shd.g_old_rec.prt_attribute14;
676: End If;
677: If (p_rec.prt_attribute15 = hr_api.g_varchar2) then
678: p_rec.prt_attribute15 :=
679: ben_prt_shd.g_old_rec.prt_attribute15;
680: End If;
681: If (p_rec.prt_attribute16 = hr_api.g_varchar2) then
682: p_rec.prt_attribute16 :=
683: ben_prt_shd.g_old_rec.prt_attribute16;

Line 683: ben_prt_shd.g_old_rec.prt_attribute16;

679: ben_prt_shd.g_old_rec.prt_attribute15;
680: End If;
681: If (p_rec.prt_attribute16 = hr_api.g_varchar2) then
682: p_rec.prt_attribute16 :=
683: ben_prt_shd.g_old_rec.prt_attribute16;
684: End If;
685: If (p_rec.prt_attribute17 = hr_api.g_varchar2) then
686: p_rec.prt_attribute17 :=
687: ben_prt_shd.g_old_rec.prt_attribute17;

Line 687: ben_prt_shd.g_old_rec.prt_attribute17;

683: ben_prt_shd.g_old_rec.prt_attribute16;
684: End If;
685: If (p_rec.prt_attribute17 = hr_api.g_varchar2) then
686: p_rec.prt_attribute17 :=
687: ben_prt_shd.g_old_rec.prt_attribute17;
688: End If;
689: If (p_rec.prt_attribute18 = hr_api.g_varchar2) then
690: p_rec.prt_attribute18 :=
691: ben_prt_shd.g_old_rec.prt_attribute18;

Line 691: ben_prt_shd.g_old_rec.prt_attribute18;

687: ben_prt_shd.g_old_rec.prt_attribute17;
688: End If;
689: If (p_rec.prt_attribute18 = hr_api.g_varchar2) then
690: p_rec.prt_attribute18 :=
691: ben_prt_shd.g_old_rec.prt_attribute18;
692: End If;
693: If (p_rec.prt_attribute19 = hr_api.g_varchar2) then
694: p_rec.prt_attribute19 :=
695: ben_prt_shd.g_old_rec.prt_attribute19;

Line 695: ben_prt_shd.g_old_rec.prt_attribute19;

691: ben_prt_shd.g_old_rec.prt_attribute18;
692: End If;
693: If (p_rec.prt_attribute19 = hr_api.g_varchar2) then
694: p_rec.prt_attribute19 :=
695: ben_prt_shd.g_old_rec.prt_attribute19;
696: End If;
697: If (p_rec.prt_attribute20 = hr_api.g_varchar2) then
698: p_rec.prt_attribute20 :=
699: ben_prt_shd.g_old_rec.prt_attribute20;

Line 699: ben_prt_shd.g_old_rec.prt_attribute20;

695: ben_prt_shd.g_old_rec.prt_attribute19;
696: End If;
697: If (p_rec.prt_attribute20 = hr_api.g_varchar2) then
698: p_rec.prt_attribute20 :=
699: ben_prt_shd.g_old_rec.prt_attribute20;
700: End If;
701: If (p_rec.prt_attribute21 = hr_api.g_varchar2) then
702: p_rec.prt_attribute21 :=
703: ben_prt_shd.g_old_rec.prt_attribute21;

Line 703: ben_prt_shd.g_old_rec.prt_attribute21;

699: ben_prt_shd.g_old_rec.prt_attribute20;
700: End If;
701: If (p_rec.prt_attribute21 = hr_api.g_varchar2) then
702: p_rec.prt_attribute21 :=
703: ben_prt_shd.g_old_rec.prt_attribute21;
704: End If;
705: If (p_rec.prt_attribute22 = hr_api.g_varchar2) then
706: p_rec.prt_attribute22 :=
707: ben_prt_shd.g_old_rec.prt_attribute22;

Line 707: ben_prt_shd.g_old_rec.prt_attribute22;

703: ben_prt_shd.g_old_rec.prt_attribute21;
704: End If;
705: If (p_rec.prt_attribute22 = hr_api.g_varchar2) then
706: p_rec.prt_attribute22 :=
707: ben_prt_shd.g_old_rec.prt_attribute22;
708: End If;
709: If (p_rec.prt_attribute23 = hr_api.g_varchar2) then
710: p_rec.prt_attribute23 :=
711: ben_prt_shd.g_old_rec.prt_attribute23;

Line 711: ben_prt_shd.g_old_rec.prt_attribute23;

707: ben_prt_shd.g_old_rec.prt_attribute22;
708: End If;
709: If (p_rec.prt_attribute23 = hr_api.g_varchar2) then
710: p_rec.prt_attribute23 :=
711: ben_prt_shd.g_old_rec.prt_attribute23;
712: End If;
713: If (p_rec.prt_attribute24 = hr_api.g_varchar2) then
714: p_rec.prt_attribute24 :=
715: ben_prt_shd.g_old_rec.prt_attribute24;

Line 715: ben_prt_shd.g_old_rec.prt_attribute24;

711: ben_prt_shd.g_old_rec.prt_attribute23;
712: End If;
713: If (p_rec.prt_attribute24 = hr_api.g_varchar2) then
714: p_rec.prt_attribute24 :=
715: ben_prt_shd.g_old_rec.prt_attribute24;
716: End If;
717: If (p_rec.prt_attribute25 = hr_api.g_varchar2) then
718: p_rec.prt_attribute25 :=
719: ben_prt_shd.g_old_rec.prt_attribute25;

Line 719: ben_prt_shd.g_old_rec.prt_attribute25;

715: ben_prt_shd.g_old_rec.prt_attribute24;
716: End If;
717: If (p_rec.prt_attribute25 = hr_api.g_varchar2) then
718: p_rec.prt_attribute25 :=
719: ben_prt_shd.g_old_rec.prt_attribute25;
720: End If;
721: If (p_rec.prt_attribute26 = hr_api.g_varchar2) then
722: p_rec.prt_attribute26 :=
723: ben_prt_shd.g_old_rec.prt_attribute26;

Line 723: ben_prt_shd.g_old_rec.prt_attribute26;

719: ben_prt_shd.g_old_rec.prt_attribute25;
720: End If;
721: If (p_rec.prt_attribute26 = hr_api.g_varchar2) then
722: p_rec.prt_attribute26 :=
723: ben_prt_shd.g_old_rec.prt_attribute26;
724: End If;
725: If (p_rec.prt_attribute27 = hr_api.g_varchar2) then
726: p_rec.prt_attribute27 :=
727: ben_prt_shd.g_old_rec.prt_attribute27;

Line 727: ben_prt_shd.g_old_rec.prt_attribute27;

723: ben_prt_shd.g_old_rec.prt_attribute26;
724: End If;
725: If (p_rec.prt_attribute27 = hr_api.g_varchar2) then
726: p_rec.prt_attribute27 :=
727: ben_prt_shd.g_old_rec.prt_attribute27;
728: End If;
729: If (p_rec.prt_attribute28 = hr_api.g_varchar2) then
730: p_rec.prt_attribute28 :=
731: ben_prt_shd.g_old_rec.prt_attribute28;

Line 731: ben_prt_shd.g_old_rec.prt_attribute28;

727: ben_prt_shd.g_old_rec.prt_attribute27;
728: End If;
729: If (p_rec.prt_attribute28 = hr_api.g_varchar2) then
730: p_rec.prt_attribute28 :=
731: ben_prt_shd.g_old_rec.prt_attribute28;
732: End If;
733: If (p_rec.prt_attribute29 = hr_api.g_varchar2) then
734: p_rec.prt_attribute29 :=
735: ben_prt_shd.g_old_rec.prt_attribute29;

Line 735: ben_prt_shd.g_old_rec.prt_attribute29;

731: ben_prt_shd.g_old_rec.prt_attribute28;
732: End If;
733: If (p_rec.prt_attribute29 = hr_api.g_varchar2) then
734: p_rec.prt_attribute29 :=
735: ben_prt_shd.g_old_rec.prt_attribute29;
736: End If;
737: If (p_rec.prt_attribute30 = hr_api.g_varchar2) then
738: p_rec.prt_attribute30 :=
739: ben_prt_shd.g_old_rec.prt_attribute30;

Line 739: ben_prt_shd.g_old_rec.prt_attribute30;

735: ben_prt_shd.g_old_rec.prt_attribute29;
736: End If;
737: If (p_rec.prt_attribute30 = hr_api.g_varchar2) then
738: p_rec.prt_attribute30 :=
739: ben_prt_shd.g_old_rec.prt_attribute30;
740: End If;
741: If (p_rec.cbr_dsblty_apls_flag = hr_api.g_varchar2) then
742: p_rec.cbr_dsblty_apls_flag :=
743: ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag;

Line 743: ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag;

739: ben_prt_shd.g_old_rec.prt_attribute30;
740: End If;
741: If (p_rec.cbr_dsblty_apls_flag = hr_api.g_varchar2) then
742: p_rec.cbr_dsblty_apls_flag :=
743: ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag;
744: End If;
745: --
746: hr_utility.set_location(' Leaving:'||l_proc, 10);
747: --

Line 755: p_rec in out nocopy ben_prt_shd.g_rec_type,

751: -- |---------------------------------< upd >----------------------------------|
752: -- ----------------------------------------------------------------------------
753: Procedure upd
754: (
755: p_rec in out nocopy ben_prt_shd.g_rec_type,
756: p_effective_date in date,
757: p_datetrack_mode in varchar2
758: ) is
759: --

Line 773: ben_prt_shd.lck

769: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
770: --
771: -- We must lock the row which we need to update.
772: --
773: ben_prt_shd.lck
774: (p_effective_date => p_effective_date,
775: p_datetrack_mode => p_datetrack_mode,
776: p_poe_rt_id => p_rec.poe_rt_id,
777: p_object_version_number => p_rec.object_version_number,

Line 877: l_rec ben_prt_shd.g_rec_type;

873: p_effective_date in date,
874: p_datetrack_mode in varchar2
875: ) is
876: --
877: l_rec ben_prt_shd.g_rec_type;
878: l_proc varchar2(72) := g_package||'upd';
879: --
880: Begin
881: hr_utility.set_location('Entering:'||l_proc, 5);

Line 887: ben_prt_shd.convert_args

883: -- Call conversion function to turn arguments into the
884: -- l_rec structure.
885: --
886: l_rec :=
887: ben_prt_shd.convert_args
888: (
889: p_poe_rt_id,
890: null,
891: null,