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_PCT_UPD dependencies on BEN_PCT_SHD

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

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_pct_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_pct_shd.g_api_dml := true; -- Set the api dml status

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

Line 132: ben_pct_shd.g_api_dml := false; -- Unset the api dml status

128: where pl_gd_r_svc_ctfn_id = p_rec.pl_gd_r_svc_ctfn_id
129: and effective_start_date = p_validation_start_date
130: and effective_end_date = p_validation_end_date;
131: --
132: ben_pct_shd.g_api_dml := false; -- Unset the api dml status
133: --
134: -- Set the effective start and end dates
135: --
136: p_rec.effective_start_date := p_validation_start_date;

Line 144: ben_pct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 145: ben_pct_shd.constraint_error

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

Line 149: ben_pct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 150: ben_pct_shd.constraint_error

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

Line 153: ben_pct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 189: (p_rec in out nocopy ben_pct_shd.g_rec_type,

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

Line 253: (p_rec in out nocopy ben_pct_shd.g_rec_type,

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

Line 269: ben_pct_shd.upd_effective_end_date

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

Line 338: (p_rec in out nocopy ben_pct_shd.g_rec_type,

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

Line 394: (p_rec in ben_pct_shd.g_rec_type,

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

Line 458: ,p_effective_start_date_o =>ben_pct_shd.g_old_rec.effective_start_date

454: ,p_validation_start_date =>p_validation_start_date
455: ,p_validation_end_date =>p_validation_end_date
456: ,p_ctfn_rqd_when_rl =>p_rec.ctfn_rqd_when_rl
457: ,p_rqd_flag =>p_rec.rqd_flag
458: ,p_effective_start_date_o =>ben_pct_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_pct_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_pct_shd.g_old_rec.business_group_id
461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id
462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag

Line 459: ,p_effective_end_date_o =>ben_pct_shd.g_old_rec.effective_end_date

455: ,p_validation_end_date =>p_validation_end_date
456: ,p_ctfn_rqd_when_rl =>p_rec.ctfn_rqd_when_rl
457: ,p_rqd_flag =>p_rec.rqd_flag
458: ,p_effective_start_date_o =>ben_pct_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_pct_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_pct_shd.g_old_rec.business_group_id
461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id
462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag
463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag

Line 460: ,p_business_group_id_o =>ben_pct_shd.g_old_rec.business_group_id

456: ,p_ctfn_rqd_when_rl =>p_rec.ctfn_rqd_when_rl
457: ,p_rqd_flag =>p_rec.rqd_flag
458: ,p_effective_start_date_o =>ben_pct_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_pct_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_pct_shd.g_old_rec.business_group_id
461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id
462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag
463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag
464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd

Line 461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id

457: ,p_rqd_flag =>p_rec.rqd_flag
458: ,p_effective_start_date_o =>ben_pct_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_pct_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_pct_shd.g_old_rec.business_group_id
461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id
462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag
463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag
464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd
465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl

Line 462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag

458: ,p_effective_start_date_o =>ben_pct_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_pct_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_pct_shd.g_old_rec.business_group_id
461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id
462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag
463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag
464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd
465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl
466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category

Line 463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag

459: ,p_effective_end_date_o =>ben_pct_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_pct_shd.g_old_rec.business_group_id
461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id
462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag
463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag
464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd
465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl
466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category
467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1

Line 464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd

460: ,p_business_group_id_o =>ben_pct_shd.g_old_rec.business_group_id
461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id
462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag
463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag
464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd
465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl
466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category
467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1
468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2

Line 465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl

461: ,p_pl_gd_or_svc_id_o =>ben_pct_shd.g_old_rec.pl_gd_or_svc_id
462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag
463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag
464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd
465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl
466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category
467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1
468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2
469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3

Line 466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category

462: ,p_pfd_flag_o =>ben_pct_shd.g_old_rec.pfd_flag
463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag
464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd
465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl
466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category
467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1
468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2
469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3
470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4

Line 467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1

463: ,p_lack_ctfn_deny_rmbmt_flag_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag
464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd
465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl
466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category
467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1
468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2
469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3
470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4
471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5

Line 468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2

464: ,p_rmbmt_ctfn_typ_cd_o =>ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd
465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl
466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category
467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1
468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2
469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3
470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4
471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5
472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6

Line 469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3

465: ,p_lack_ctfn_deny_rmbmt_rl_o =>ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl
466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category
467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1
468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2
469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3
470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4
471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5
472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6
473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7

Line 470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4

466: ,p_pct_attribute_category_o =>ben_pct_shd.g_old_rec.pct_attribute_category
467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1
468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2
469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3
470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4
471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5
472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6
473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7
474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8

Line 471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5

467: ,p_pct_attribute1_o =>ben_pct_shd.g_old_rec.pct_attribute1
468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2
469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3
470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4
471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5
472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6
473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7
474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8
475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9

Line 472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6

468: ,p_pct_attribute2_o =>ben_pct_shd.g_old_rec.pct_attribute2
469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3
470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4
471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5
472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6
473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7
474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8
475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9
476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10

Line 473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7

469: ,p_pct_attribute3_o =>ben_pct_shd.g_old_rec.pct_attribute3
470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4
471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5
472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6
473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7
474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8
475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9
476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10
477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11

Line 474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8

470: ,p_pct_attribute4_o =>ben_pct_shd.g_old_rec.pct_attribute4
471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5
472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6
473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7
474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8
475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9
476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10
477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11
478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12

Line 475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9

471: ,p_pct_attribute5_o =>ben_pct_shd.g_old_rec.pct_attribute5
472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6
473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7
474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8
475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9
476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10
477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11
478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12
479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13

Line 476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10

472: ,p_pct_attribute6_o =>ben_pct_shd.g_old_rec.pct_attribute6
473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7
474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8
475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9
476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10
477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11
478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12
479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13
480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14

Line 477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11

473: ,p_pct_attribute7_o =>ben_pct_shd.g_old_rec.pct_attribute7
474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8
475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9
476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10
477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11
478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12
479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13
480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14
481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15

Line 478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12

474: ,p_pct_attribute8_o =>ben_pct_shd.g_old_rec.pct_attribute8
475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9
476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10
477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11
478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12
479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13
480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14
481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15
482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16

Line 479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13

475: ,p_pct_attribute9_o =>ben_pct_shd.g_old_rec.pct_attribute9
476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10
477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11
478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12
479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13
480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14
481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15
482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16
483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17

Line 480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14

476: ,p_pct_attribute10_o =>ben_pct_shd.g_old_rec.pct_attribute10
477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11
478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12
479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13
480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14
481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15
482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16
483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17
484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18

Line 481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15

477: ,p_pct_attribute11_o =>ben_pct_shd.g_old_rec.pct_attribute11
478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12
479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13
480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14
481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15
482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16
483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17
484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18
485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19

Line 482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16

478: ,p_pct_attribute12_o =>ben_pct_shd.g_old_rec.pct_attribute12
479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13
480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14
481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15
482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16
483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17
484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18
485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19
486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20

Line 483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17

479: ,p_pct_attribute13_o =>ben_pct_shd.g_old_rec.pct_attribute13
480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14
481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15
482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16
483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17
484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18
485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19
486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20
487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21

Line 484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18

480: ,p_pct_attribute14_o =>ben_pct_shd.g_old_rec.pct_attribute14
481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15
482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16
483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17
484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18
485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19
486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20
487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21
488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22

Line 485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19

481: ,p_pct_attribute15_o =>ben_pct_shd.g_old_rec.pct_attribute15
482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16
483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17
484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18
485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19
486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20
487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21
488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22
489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23

Line 486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20

482: ,p_pct_attribute16_o =>ben_pct_shd.g_old_rec.pct_attribute16
483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17
484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18
485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19
486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20
487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21
488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22
489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23
490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24

Line 487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21

483: ,p_pct_attribute17_o =>ben_pct_shd.g_old_rec.pct_attribute17
484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18
485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19
486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20
487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21
488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22
489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23
490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24
491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25

Line 488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22

484: ,p_pct_attribute18_o =>ben_pct_shd.g_old_rec.pct_attribute18
485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19
486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20
487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21
488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22
489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23
490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24
491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25
492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26

Line 489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23

485: ,p_pct_attribute19_o =>ben_pct_shd.g_old_rec.pct_attribute19
486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20
487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21
488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22
489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23
490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24
491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25
492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26
493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27

Line 490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24

486: ,p_pct_attribute20_o =>ben_pct_shd.g_old_rec.pct_attribute20
487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21
488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22
489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23
490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24
491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25
492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26
493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27
494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28

Line 491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25

487: ,p_pct_attribute21_o =>ben_pct_shd.g_old_rec.pct_attribute21
488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22
489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23
490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24
491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25
492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26
493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27
494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28
495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29

Line 492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26

488: ,p_pct_attribute22_o =>ben_pct_shd.g_old_rec.pct_attribute22
489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23
490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24
491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25
492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26
493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27
494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28
495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29
496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30

Line 493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27

489: ,p_pct_attribute23_o =>ben_pct_shd.g_old_rec.pct_attribute23
490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24
491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25
492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26
493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27
494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28
495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29
496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30
497: ,p_object_version_number_o =>ben_pct_shd.g_old_rec.object_version_number

Line 494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28

490: ,p_pct_attribute24_o =>ben_pct_shd.g_old_rec.pct_attribute24
491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25
492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26
493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27
494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28
495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29
496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30
497: ,p_object_version_number_o =>ben_pct_shd.g_old_rec.object_version_number
498: ,p_ctfn_rqd_when_rl_o =>ben_pct_shd.g_old_rec.ctfn_rqd_when_rl

Line 495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29

491: ,p_pct_attribute25_o =>ben_pct_shd.g_old_rec.pct_attribute25
492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26
493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27
494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28
495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29
496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30
497: ,p_object_version_number_o =>ben_pct_shd.g_old_rec.object_version_number
498: ,p_ctfn_rqd_when_rl_o =>ben_pct_shd.g_old_rec.ctfn_rqd_when_rl
499: ,p_rqd_flag_o =>ben_pct_shd.g_old_rec.rqd_flag

Line 496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30

492: ,p_pct_attribute26_o =>ben_pct_shd.g_old_rec.pct_attribute26
493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27
494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28
495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29
496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30
497: ,p_object_version_number_o =>ben_pct_shd.g_old_rec.object_version_number
498: ,p_ctfn_rqd_when_rl_o =>ben_pct_shd.g_old_rec.ctfn_rqd_when_rl
499: ,p_rqd_flag_o =>ben_pct_shd.g_old_rec.rqd_flag
500: );

Line 497: ,p_object_version_number_o =>ben_pct_shd.g_old_rec.object_version_number

493: ,p_pct_attribute27_o =>ben_pct_shd.g_old_rec.pct_attribute27
494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28
495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29
496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30
497: ,p_object_version_number_o =>ben_pct_shd.g_old_rec.object_version_number
498: ,p_ctfn_rqd_when_rl_o =>ben_pct_shd.g_old_rec.ctfn_rqd_when_rl
499: ,p_rqd_flag_o =>ben_pct_shd.g_old_rec.rqd_flag
500: );
501: --

Line 498: ,p_ctfn_rqd_when_rl_o =>ben_pct_shd.g_old_rec.ctfn_rqd_when_rl

494: ,p_pct_attribute28_o =>ben_pct_shd.g_old_rec.pct_attribute28
495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29
496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30
497: ,p_object_version_number_o =>ben_pct_shd.g_old_rec.object_version_number
498: ,p_ctfn_rqd_when_rl_o =>ben_pct_shd.g_old_rec.ctfn_rqd_when_rl
499: ,p_rqd_flag_o =>ben_pct_shd.g_old_rec.rqd_flag
500: );
501: --
502: exception

Line 499: ,p_rqd_flag_o =>ben_pct_shd.g_old_rec.rqd_flag

495: ,p_pct_attribute29_o =>ben_pct_shd.g_old_rec.pct_attribute29
496: ,p_pct_attribute30_o =>ben_pct_shd.g_old_rec.pct_attribute30
497: ,p_object_version_number_o =>ben_pct_shd.g_old_rec.object_version_number
498: ,p_ctfn_rqd_when_rl_o =>ben_pct_shd.g_old_rec.ctfn_rqd_when_rl
499: ,p_rqd_flag_o =>ben_pct_shd.g_old_rec.rqd_flag
500: );
501: --
502: exception
503: --

Line 561: Procedure convert_defs(p_rec in out nocopy ben_pct_shd.g_rec_type) is

557: -- Internal Row Handler Use Only.
558: --
559: -- {End Of Comments}
560: -- ----------------------------------------------------------------------------
561: Procedure convert_defs(p_rec in out nocopy ben_pct_shd.g_rec_type) is
562: --
563: l_proc varchar2(72) := g_package||'convert_defs';
564: --
565: Begin

Line 576: ben_pct_shd.g_old_rec.business_group_id;

572: -- is being used then we must set to the 'current' argument value.
573: --
574: If (p_rec.business_group_id = hr_api.g_number) then
575: p_rec.business_group_id :=
576: ben_pct_shd.g_old_rec.business_group_id;
577: End If;
578: --If (p_rec.pl_id = hr_api.g_number) then
579: -- p_rec.pl_id :=
580: --ben_pct_shd.g_old_rec.pl_id;

Line 580: --ben_pct_shd.g_old_rec.pl_id;

576: ben_pct_shd.g_old_rec.business_group_id;
577: End If;
578: --If (p_rec.pl_id = hr_api.g_number) then
579: -- p_rec.pl_id :=
580: --ben_pct_shd.g_old_rec.pl_id;
581: --End If;
582: If (p_rec.pl_gd_or_svc_id = hr_api.g_number) then
583: p_rec.pl_gd_or_svc_id :=
584: ben_pct_shd.g_old_rec.pl_gd_or_svc_id;

Line 584: ben_pct_shd.g_old_rec.pl_gd_or_svc_id;

580: --ben_pct_shd.g_old_rec.pl_id;
581: --End If;
582: If (p_rec.pl_gd_or_svc_id = hr_api.g_number) then
583: p_rec.pl_gd_or_svc_id :=
584: ben_pct_shd.g_old_rec.pl_gd_or_svc_id;
585: End If;
586: If (p_rec.pfd_flag = hr_api.g_varchar2) then
587: p_rec.pfd_flag :=
588: ben_pct_shd.g_old_rec.pfd_flag;

Line 588: ben_pct_shd.g_old_rec.pfd_flag;

584: ben_pct_shd.g_old_rec.pl_gd_or_svc_id;
585: End If;
586: If (p_rec.pfd_flag = hr_api.g_varchar2) then
587: p_rec.pfd_flag :=
588: ben_pct_shd.g_old_rec.pfd_flag;
589: End If;
590: If (p_rec.lack_ctfn_deny_rmbmt_flag = hr_api.g_varchar2) then
591: p_rec.lack_ctfn_deny_rmbmt_flag :=
592: ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag;

Line 592: ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag;

588: ben_pct_shd.g_old_rec.pfd_flag;
589: End If;
590: If (p_rec.lack_ctfn_deny_rmbmt_flag = hr_api.g_varchar2) then
591: p_rec.lack_ctfn_deny_rmbmt_flag :=
592: ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag;
593: End If;
594: If (p_rec.rmbmt_ctfn_typ_cd = hr_api.g_varchar2) then
595: p_rec.rmbmt_ctfn_typ_cd :=
596: ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd;

Line 596: ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd;

592: ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_flag;
593: End If;
594: If (p_rec.rmbmt_ctfn_typ_cd = hr_api.g_varchar2) then
595: p_rec.rmbmt_ctfn_typ_cd :=
596: ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd;
597: End If;
598: If (p_rec.lack_ctfn_deny_rmbmt_rl = hr_api.g_number) then
599: p_rec.lack_ctfn_deny_rmbmt_rl :=
600: ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl;

Line 600: ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl;

596: ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd;
597: End If;
598: If (p_rec.lack_ctfn_deny_rmbmt_rl = hr_api.g_number) then
599: p_rec.lack_ctfn_deny_rmbmt_rl :=
600: ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl;
601: End If;
602: If (p_rec.pct_attribute_category = hr_api.g_varchar2) then
603: p_rec.pct_attribute_category :=
604: ben_pct_shd.g_old_rec.pct_attribute_category;

Line 604: ben_pct_shd.g_old_rec.pct_attribute_category;

600: ben_pct_shd.g_old_rec.lack_ctfn_deny_rmbmt_rl;
601: End If;
602: If (p_rec.pct_attribute_category = hr_api.g_varchar2) then
603: p_rec.pct_attribute_category :=
604: ben_pct_shd.g_old_rec.pct_attribute_category;
605: End If;
606: If (p_rec.pct_attribute1 = hr_api.g_varchar2) then
607: p_rec.pct_attribute1 :=
608: ben_pct_shd.g_old_rec.pct_attribute1;

Line 608: ben_pct_shd.g_old_rec.pct_attribute1;

604: ben_pct_shd.g_old_rec.pct_attribute_category;
605: End If;
606: If (p_rec.pct_attribute1 = hr_api.g_varchar2) then
607: p_rec.pct_attribute1 :=
608: ben_pct_shd.g_old_rec.pct_attribute1;
609: End If;
610: If (p_rec.pct_attribute2 = hr_api.g_varchar2) then
611: p_rec.pct_attribute2 :=
612: ben_pct_shd.g_old_rec.pct_attribute2;

Line 612: ben_pct_shd.g_old_rec.pct_attribute2;

608: ben_pct_shd.g_old_rec.pct_attribute1;
609: End If;
610: If (p_rec.pct_attribute2 = hr_api.g_varchar2) then
611: p_rec.pct_attribute2 :=
612: ben_pct_shd.g_old_rec.pct_attribute2;
613: End If;
614: If (p_rec.pct_attribute3 = hr_api.g_varchar2) then
615: p_rec.pct_attribute3 :=
616: ben_pct_shd.g_old_rec.pct_attribute3;

Line 616: ben_pct_shd.g_old_rec.pct_attribute3;

612: ben_pct_shd.g_old_rec.pct_attribute2;
613: End If;
614: If (p_rec.pct_attribute3 = hr_api.g_varchar2) then
615: p_rec.pct_attribute3 :=
616: ben_pct_shd.g_old_rec.pct_attribute3;
617: End If;
618: If (p_rec.pct_attribute4 = hr_api.g_varchar2) then
619: p_rec.pct_attribute4 :=
620: ben_pct_shd.g_old_rec.pct_attribute4;

Line 620: ben_pct_shd.g_old_rec.pct_attribute4;

616: ben_pct_shd.g_old_rec.pct_attribute3;
617: End If;
618: If (p_rec.pct_attribute4 = hr_api.g_varchar2) then
619: p_rec.pct_attribute4 :=
620: ben_pct_shd.g_old_rec.pct_attribute4;
621: End If;
622: If (p_rec.pct_attribute5 = hr_api.g_varchar2) then
623: p_rec.pct_attribute5 :=
624: ben_pct_shd.g_old_rec.pct_attribute5;

Line 624: ben_pct_shd.g_old_rec.pct_attribute5;

620: ben_pct_shd.g_old_rec.pct_attribute4;
621: End If;
622: If (p_rec.pct_attribute5 = hr_api.g_varchar2) then
623: p_rec.pct_attribute5 :=
624: ben_pct_shd.g_old_rec.pct_attribute5;
625: End If;
626: If (p_rec.pct_attribute6 = hr_api.g_varchar2) then
627: p_rec.pct_attribute6 :=
628: ben_pct_shd.g_old_rec.pct_attribute6;

Line 628: ben_pct_shd.g_old_rec.pct_attribute6;

624: ben_pct_shd.g_old_rec.pct_attribute5;
625: End If;
626: If (p_rec.pct_attribute6 = hr_api.g_varchar2) then
627: p_rec.pct_attribute6 :=
628: ben_pct_shd.g_old_rec.pct_attribute6;
629: End If;
630: If (p_rec.pct_attribute7 = hr_api.g_varchar2) then
631: p_rec.pct_attribute7 :=
632: ben_pct_shd.g_old_rec.pct_attribute7;

Line 632: ben_pct_shd.g_old_rec.pct_attribute7;

628: ben_pct_shd.g_old_rec.pct_attribute6;
629: End If;
630: If (p_rec.pct_attribute7 = hr_api.g_varchar2) then
631: p_rec.pct_attribute7 :=
632: ben_pct_shd.g_old_rec.pct_attribute7;
633: End If;
634: If (p_rec.pct_attribute8 = hr_api.g_varchar2) then
635: p_rec.pct_attribute8 :=
636: ben_pct_shd.g_old_rec.pct_attribute8;

Line 636: ben_pct_shd.g_old_rec.pct_attribute8;

632: ben_pct_shd.g_old_rec.pct_attribute7;
633: End If;
634: If (p_rec.pct_attribute8 = hr_api.g_varchar2) then
635: p_rec.pct_attribute8 :=
636: ben_pct_shd.g_old_rec.pct_attribute8;
637: End If;
638: If (p_rec.pct_attribute9 = hr_api.g_varchar2) then
639: p_rec.pct_attribute9 :=
640: ben_pct_shd.g_old_rec.pct_attribute9;

Line 640: ben_pct_shd.g_old_rec.pct_attribute9;

636: ben_pct_shd.g_old_rec.pct_attribute8;
637: End If;
638: If (p_rec.pct_attribute9 = hr_api.g_varchar2) then
639: p_rec.pct_attribute9 :=
640: ben_pct_shd.g_old_rec.pct_attribute9;
641: End If;
642: If (p_rec.pct_attribute10 = hr_api.g_varchar2) then
643: p_rec.pct_attribute10 :=
644: ben_pct_shd.g_old_rec.pct_attribute10;

Line 644: ben_pct_shd.g_old_rec.pct_attribute10;

640: ben_pct_shd.g_old_rec.pct_attribute9;
641: End If;
642: If (p_rec.pct_attribute10 = hr_api.g_varchar2) then
643: p_rec.pct_attribute10 :=
644: ben_pct_shd.g_old_rec.pct_attribute10;
645: End If;
646: If (p_rec.pct_attribute11 = hr_api.g_varchar2) then
647: p_rec.pct_attribute11 :=
648: ben_pct_shd.g_old_rec.pct_attribute11;

Line 648: ben_pct_shd.g_old_rec.pct_attribute11;

644: ben_pct_shd.g_old_rec.pct_attribute10;
645: End If;
646: If (p_rec.pct_attribute11 = hr_api.g_varchar2) then
647: p_rec.pct_attribute11 :=
648: ben_pct_shd.g_old_rec.pct_attribute11;
649: End If;
650: If (p_rec.pct_attribute12 = hr_api.g_varchar2) then
651: p_rec.pct_attribute12 :=
652: ben_pct_shd.g_old_rec.pct_attribute12;

Line 652: ben_pct_shd.g_old_rec.pct_attribute12;

648: ben_pct_shd.g_old_rec.pct_attribute11;
649: End If;
650: If (p_rec.pct_attribute12 = hr_api.g_varchar2) then
651: p_rec.pct_attribute12 :=
652: ben_pct_shd.g_old_rec.pct_attribute12;
653: End If;
654: If (p_rec.pct_attribute13 = hr_api.g_varchar2) then
655: p_rec.pct_attribute13 :=
656: ben_pct_shd.g_old_rec.pct_attribute13;

Line 656: ben_pct_shd.g_old_rec.pct_attribute13;

652: ben_pct_shd.g_old_rec.pct_attribute12;
653: End If;
654: If (p_rec.pct_attribute13 = hr_api.g_varchar2) then
655: p_rec.pct_attribute13 :=
656: ben_pct_shd.g_old_rec.pct_attribute13;
657: End If;
658: If (p_rec.pct_attribute14 = hr_api.g_varchar2) then
659: p_rec.pct_attribute14 :=
660: ben_pct_shd.g_old_rec.pct_attribute14;

Line 660: ben_pct_shd.g_old_rec.pct_attribute14;

656: ben_pct_shd.g_old_rec.pct_attribute13;
657: End If;
658: If (p_rec.pct_attribute14 = hr_api.g_varchar2) then
659: p_rec.pct_attribute14 :=
660: ben_pct_shd.g_old_rec.pct_attribute14;
661: End If;
662: If (p_rec.pct_attribute15 = hr_api.g_varchar2) then
663: p_rec.pct_attribute15 :=
664: ben_pct_shd.g_old_rec.pct_attribute15;

Line 664: ben_pct_shd.g_old_rec.pct_attribute15;

660: ben_pct_shd.g_old_rec.pct_attribute14;
661: End If;
662: If (p_rec.pct_attribute15 = hr_api.g_varchar2) then
663: p_rec.pct_attribute15 :=
664: ben_pct_shd.g_old_rec.pct_attribute15;
665: End If;
666: If (p_rec.pct_attribute16 = hr_api.g_varchar2) then
667: p_rec.pct_attribute16 :=
668: ben_pct_shd.g_old_rec.pct_attribute16;

Line 668: ben_pct_shd.g_old_rec.pct_attribute16;

664: ben_pct_shd.g_old_rec.pct_attribute15;
665: End If;
666: If (p_rec.pct_attribute16 = hr_api.g_varchar2) then
667: p_rec.pct_attribute16 :=
668: ben_pct_shd.g_old_rec.pct_attribute16;
669: End If;
670: If (p_rec.pct_attribute17 = hr_api.g_varchar2) then
671: p_rec.pct_attribute17 :=
672: ben_pct_shd.g_old_rec.pct_attribute17;

Line 672: ben_pct_shd.g_old_rec.pct_attribute17;

668: ben_pct_shd.g_old_rec.pct_attribute16;
669: End If;
670: If (p_rec.pct_attribute17 = hr_api.g_varchar2) then
671: p_rec.pct_attribute17 :=
672: ben_pct_shd.g_old_rec.pct_attribute17;
673: End If;
674: If (p_rec.pct_attribute18 = hr_api.g_varchar2) then
675: p_rec.pct_attribute18 :=
676: ben_pct_shd.g_old_rec.pct_attribute18;

Line 676: ben_pct_shd.g_old_rec.pct_attribute18;

672: ben_pct_shd.g_old_rec.pct_attribute17;
673: End If;
674: If (p_rec.pct_attribute18 = hr_api.g_varchar2) then
675: p_rec.pct_attribute18 :=
676: ben_pct_shd.g_old_rec.pct_attribute18;
677: End If;
678: If (p_rec.pct_attribute19 = hr_api.g_varchar2) then
679: p_rec.pct_attribute19 :=
680: ben_pct_shd.g_old_rec.pct_attribute19;

Line 680: ben_pct_shd.g_old_rec.pct_attribute19;

676: ben_pct_shd.g_old_rec.pct_attribute18;
677: End If;
678: If (p_rec.pct_attribute19 = hr_api.g_varchar2) then
679: p_rec.pct_attribute19 :=
680: ben_pct_shd.g_old_rec.pct_attribute19;
681: End If;
682: If (p_rec.pct_attribute20 = hr_api.g_varchar2) then
683: p_rec.pct_attribute20 :=
684: ben_pct_shd.g_old_rec.pct_attribute20;

Line 684: ben_pct_shd.g_old_rec.pct_attribute20;

680: ben_pct_shd.g_old_rec.pct_attribute19;
681: End If;
682: If (p_rec.pct_attribute20 = hr_api.g_varchar2) then
683: p_rec.pct_attribute20 :=
684: ben_pct_shd.g_old_rec.pct_attribute20;
685: End If;
686: If (p_rec.pct_attribute21 = hr_api.g_varchar2) then
687: p_rec.pct_attribute21 :=
688: ben_pct_shd.g_old_rec.pct_attribute21;

Line 688: ben_pct_shd.g_old_rec.pct_attribute21;

684: ben_pct_shd.g_old_rec.pct_attribute20;
685: End If;
686: If (p_rec.pct_attribute21 = hr_api.g_varchar2) then
687: p_rec.pct_attribute21 :=
688: ben_pct_shd.g_old_rec.pct_attribute21;
689: End If;
690: If (p_rec.pct_attribute22 = hr_api.g_varchar2) then
691: p_rec.pct_attribute22 :=
692: ben_pct_shd.g_old_rec.pct_attribute22;

Line 692: ben_pct_shd.g_old_rec.pct_attribute22;

688: ben_pct_shd.g_old_rec.pct_attribute21;
689: End If;
690: If (p_rec.pct_attribute22 = hr_api.g_varchar2) then
691: p_rec.pct_attribute22 :=
692: ben_pct_shd.g_old_rec.pct_attribute22;
693: End If;
694: If (p_rec.pct_attribute23 = hr_api.g_varchar2) then
695: p_rec.pct_attribute23 :=
696: ben_pct_shd.g_old_rec.pct_attribute23;

Line 696: ben_pct_shd.g_old_rec.pct_attribute23;

692: ben_pct_shd.g_old_rec.pct_attribute22;
693: End If;
694: If (p_rec.pct_attribute23 = hr_api.g_varchar2) then
695: p_rec.pct_attribute23 :=
696: ben_pct_shd.g_old_rec.pct_attribute23;
697: End If;
698: If (p_rec.pct_attribute24 = hr_api.g_varchar2) then
699: p_rec.pct_attribute24 :=
700: ben_pct_shd.g_old_rec.pct_attribute24;

Line 700: ben_pct_shd.g_old_rec.pct_attribute24;

696: ben_pct_shd.g_old_rec.pct_attribute23;
697: End If;
698: If (p_rec.pct_attribute24 = hr_api.g_varchar2) then
699: p_rec.pct_attribute24 :=
700: ben_pct_shd.g_old_rec.pct_attribute24;
701: End If;
702: If (p_rec.pct_attribute25 = hr_api.g_varchar2) then
703: p_rec.pct_attribute25 :=
704: ben_pct_shd.g_old_rec.pct_attribute25;

Line 704: ben_pct_shd.g_old_rec.pct_attribute25;

700: ben_pct_shd.g_old_rec.pct_attribute24;
701: End If;
702: If (p_rec.pct_attribute25 = hr_api.g_varchar2) then
703: p_rec.pct_attribute25 :=
704: ben_pct_shd.g_old_rec.pct_attribute25;
705: End If;
706: If (p_rec.pct_attribute26 = hr_api.g_varchar2) then
707: p_rec.pct_attribute26 :=
708: ben_pct_shd.g_old_rec.pct_attribute26;

Line 708: ben_pct_shd.g_old_rec.pct_attribute26;

704: ben_pct_shd.g_old_rec.pct_attribute25;
705: End If;
706: If (p_rec.pct_attribute26 = hr_api.g_varchar2) then
707: p_rec.pct_attribute26 :=
708: ben_pct_shd.g_old_rec.pct_attribute26;
709: End If;
710: If (p_rec.pct_attribute27 = hr_api.g_varchar2) then
711: p_rec.pct_attribute27 :=
712: ben_pct_shd.g_old_rec.pct_attribute27;

Line 712: ben_pct_shd.g_old_rec.pct_attribute27;

708: ben_pct_shd.g_old_rec.pct_attribute26;
709: End If;
710: If (p_rec.pct_attribute27 = hr_api.g_varchar2) then
711: p_rec.pct_attribute27 :=
712: ben_pct_shd.g_old_rec.pct_attribute27;
713: End If;
714: If (p_rec.pct_attribute28 = hr_api.g_varchar2) then
715: p_rec.pct_attribute28 :=
716: ben_pct_shd.g_old_rec.pct_attribute28;

Line 716: ben_pct_shd.g_old_rec.pct_attribute28;

712: ben_pct_shd.g_old_rec.pct_attribute27;
713: End If;
714: If (p_rec.pct_attribute28 = hr_api.g_varchar2) then
715: p_rec.pct_attribute28 :=
716: ben_pct_shd.g_old_rec.pct_attribute28;
717: End If;
718: If (p_rec.pct_attribute29 = hr_api.g_varchar2) then
719: p_rec.pct_attribute29 :=
720: ben_pct_shd.g_old_rec.pct_attribute29;

Line 720: ben_pct_shd.g_old_rec.pct_attribute29;

716: ben_pct_shd.g_old_rec.pct_attribute28;
717: End If;
718: If (p_rec.pct_attribute29 = hr_api.g_varchar2) then
719: p_rec.pct_attribute29 :=
720: ben_pct_shd.g_old_rec.pct_attribute29;
721: End If;
722: If (p_rec.pct_attribute30 = hr_api.g_varchar2) then
723: p_rec.pct_attribute30 :=
724: ben_pct_shd.g_old_rec.pct_attribute30;

Line 724: ben_pct_shd.g_old_rec.pct_attribute30;

720: ben_pct_shd.g_old_rec.pct_attribute29;
721: End If;
722: If (p_rec.pct_attribute30 = hr_api.g_varchar2) then
723: p_rec.pct_attribute30 :=
724: ben_pct_shd.g_old_rec.pct_attribute30;
725: End If;
726:
727: If (p_rec.ctfn_rqd_when_rl = hr_api.g_number) then
728: p_rec.ctfn_rqd_when_rl :=

Line 729: ben_pct_shd.g_old_rec.ctfn_rqd_when_rl;

725: End If;
726:
727: If (p_rec.ctfn_rqd_when_rl = hr_api.g_number) then
728: p_rec.ctfn_rqd_when_rl :=
729: ben_pct_shd.g_old_rec.ctfn_rqd_when_rl;
730: End If;
731:
732: If (p_rec.rqd_flag = hr_api.g_varchar2) then
733: p_rec.rqd_flag :=

Line 734: ben_pct_shd.g_old_rec.rqd_flag ;

730: End If;
731:
732: If (p_rec.rqd_flag = hr_api.g_varchar2) then
733: p_rec.rqd_flag :=
734: ben_pct_shd.g_old_rec.rqd_flag ;
735: End If;
736:
737: --
738: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 747: p_rec in out nocopy ben_pct_shd.g_rec_type,

743: -- |---------------------------------< upd >----------------------------------|
744: -- ----------------------------------------------------------------------------
745: Procedure upd
746: (
747: p_rec in out nocopy ben_pct_shd.g_rec_type,
748: p_effective_date in date,
749: p_datetrack_mode in varchar2
750: ) is
751: --

Line 765: ben_pct_shd.lck

761: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
762: --
763: -- We must lock the row which we need to update.
764: --
765: ben_pct_shd.lck
766: (p_effective_date => p_effective_date,
767: p_datetrack_mode => p_datetrack_mode,
768: p_pl_gd_r_svc_ctfn_id => p_rec.pl_gd_r_svc_ctfn_id,
769: p_object_version_number => p_rec.object_version_number,

Line 867: l_rec ben_pct_shd.g_rec_type;

863: p_ctfn_rqd_when_rl in number default hr_api.g_number,
864: p_rqd_flag in varchar2 default hr_api.g_varchar2
865: ) is
866: --
867: l_rec ben_pct_shd.g_rec_type;
868: l_proc varchar2(72) := g_package||'upd';
869: --
870: Begin
871: hr_utility.set_location('Entering:'||l_proc, 5);

Line 877: ben_pct_shd.convert_args

873: -- Call conversion function to turn arguments into the
874: -- l_rec structure.
875: --
876: l_rec :=
877: ben_pct_shd.convert_args
878: (
879: p_pl_gd_r_svc_ctfn_id,
880: null,
881: null,