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_LCC_UPD dependencies on BEN_LCC_SHD

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

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

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

Line 131: ben_lcc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 143: ben_lcc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 144: ben_lcc_shd.constraint_error

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

Line 148: ben_lcc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 149: ben_lcc_shd.constraint_error

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

Line 152: ben_lcc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 188: (p_rec in out nocopy ben_lcc_shd.g_rec_type,

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

Line 252: (p_rec in out nocopy ben_lcc_shd.g_rec_type,

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

Line 268: ben_lcc_shd.upd_effective_end_date

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

Line 337: (p_rec in out nocopy ben_lcc_shd.g_rec_type,

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

Line 393: (p_rec in ben_lcc_shd.g_rec_type,

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

Line 457: ,p_effective_start_date_o =>ben_lcc_shd.g_old_rec.effective_start_date

453: ,p_effective_date =>p_effective_date
454: ,p_datetrack_mode =>p_datetrack_mode
455: ,p_validation_start_date =>p_validation_start_date
456: ,p_validation_end_date =>p_validation_end_date
457: ,p_effective_start_date_o =>ben_lcc_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_lcc_shd.g_old_rec.effective_end_date
459: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd
461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl

Line 458: ,p_effective_end_date_o =>ben_lcc_shd.g_old_rec.effective_end_date

454: ,p_datetrack_mode =>p_datetrack_mode
455: ,p_validation_start_date =>p_validation_start_date
456: ,p_validation_end_date =>p_validation_end_date
457: ,p_effective_start_date_o =>ben_lcc_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_lcc_shd.g_old_rec.effective_end_date
459: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd
461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl
462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag

Line 459: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd

455: ,p_validation_start_date =>p_validation_start_date
456: ,p_validation_end_date =>p_validation_end_date
457: ,p_effective_start_date_o =>ben_lcc_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_lcc_shd.g_old_rec.effective_end_date
459: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd
461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl
462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag

Line 460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd

456: ,p_validation_end_date =>p_validation_end_date
457: ,p_effective_start_date_o =>ben_lcc_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_lcc_shd.g_old_rec.effective_end_date
459: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd
461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl
462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag
464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id

Line 461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl

457: ,p_effective_start_date_o =>ben_lcc_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_lcc_shd.g_old_rec.effective_end_date
459: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd
461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl
462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag
464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id
465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id

Line 462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag

458: ,p_effective_end_date_o =>ben_lcc_shd.g_old_rec.effective_end_date
459: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd
461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl
462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag
464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id
465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id
466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category

Line 463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag

459: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd
461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl
462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag
464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id
465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id
466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category
467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1

Line 464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id

460: ,p_rlshp_typ_cd_o =>ben_lcc_shd.g_old_rec.rlshp_typ_cd
461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl
462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag
464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id
465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id
466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category
467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1
468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2

Line 465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id

461: ,p_ctfn_rqd_when_rl_o =>ben_lcc_shd.g_old_rec.ctfn_rqd_when_rl
462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag
464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id
465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id
466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category
467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1
468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2
469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3

Line 466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category

462: ,p_lack_ctfn_sspnd_enrt_flag_o =>ben_lcc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag
464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id
465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id
466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category
467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1
468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2
469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3
470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4

Line 467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1

463: ,p_rqd_flag_o =>ben_lcc_shd.g_old_rec.rqd_flag
464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id
465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id
466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category
467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1
468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2
469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3
470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4
471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5

Line 468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2

464: ,p_ler_chg_dpnt_cvg_id_o =>ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id
465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id
466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category
467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1
468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2
469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3
470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4
471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5
472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6

Line 469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3

465: ,p_business_group_id_o =>ben_lcc_shd.g_old_rec.business_group_id
466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category
467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1
468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2
469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3
470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4
471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5
472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6
473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7

Line 470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4

466: ,p_lcc_attribute_category_o =>ben_lcc_shd.g_old_rec.lcc_attribute_category
467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1
468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2
469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3
470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4
471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5
472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6
473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7
474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8

Line 471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5

467: ,p_lcc_attribute1_o =>ben_lcc_shd.g_old_rec.lcc_attribute1
468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2
469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3
470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4
471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5
472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6
473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7
474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8
475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9

Line 472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6

468: ,p_lcc_attribute2_o =>ben_lcc_shd.g_old_rec.lcc_attribute2
469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3
470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4
471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5
472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6
473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7
474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8
475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9
476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10

Line 473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7

469: ,p_lcc_attribute3_o =>ben_lcc_shd.g_old_rec.lcc_attribute3
470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4
471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5
472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6
473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7
474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8
475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9
476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10
477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11

Line 474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8

470: ,p_lcc_attribute4_o =>ben_lcc_shd.g_old_rec.lcc_attribute4
471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5
472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6
473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7
474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8
475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9
476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10
477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11
478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12

Line 475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9

471: ,p_lcc_attribute5_o =>ben_lcc_shd.g_old_rec.lcc_attribute5
472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6
473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7
474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8
475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9
476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10
477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11
478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12
479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13

Line 476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10

472: ,p_lcc_attribute6_o =>ben_lcc_shd.g_old_rec.lcc_attribute6
473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7
474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8
475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9
476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10
477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11
478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12
479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13
480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14

Line 477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11

473: ,p_lcc_attribute7_o =>ben_lcc_shd.g_old_rec.lcc_attribute7
474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8
475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9
476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10
477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11
478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12
479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13
480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14
481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15

Line 478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12

474: ,p_lcc_attribute8_o =>ben_lcc_shd.g_old_rec.lcc_attribute8
475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9
476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10
477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11
478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12
479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13
480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14
481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15
482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16

Line 479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13

475: ,p_lcc_attribute9_o =>ben_lcc_shd.g_old_rec.lcc_attribute9
476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10
477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11
478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12
479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13
480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14
481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15
482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16
483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17

Line 480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14

476: ,p_lcc_attribute10_o =>ben_lcc_shd.g_old_rec.lcc_attribute10
477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11
478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12
479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13
480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14
481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15
482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16
483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17
484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18

Line 481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15

477: ,p_lcc_attribute11_o =>ben_lcc_shd.g_old_rec.lcc_attribute11
478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12
479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13
480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14
481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15
482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16
483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17
484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18
485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19

Line 482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16

478: ,p_lcc_attribute12_o =>ben_lcc_shd.g_old_rec.lcc_attribute12
479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13
480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14
481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15
482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16
483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17
484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18
485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19
486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20

Line 483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17

479: ,p_lcc_attribute13_o =>ben_lcc_shd.g_old_rec.lcc_attribute13
480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14
481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15
482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16
483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17
484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18
485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19
486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20
487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21

Line 484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18

480: ,p_lcc_attribute14_o =>ben_lcc_shd.g_old_rec.lcc_attribute14
481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15
482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16
483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17
484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18
485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19
486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20
487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21
488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22

Line 485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19

481: ,p_lcc_attribute15_o =>ben_lcc_shd.g_old_rec.lcc_attribute15
482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16
483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17
484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18
485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19
486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20
487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21
488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22
489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23

Line 486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20

482: ,p_lcc_attribute16_o =>ben_lcc_shd.g_old_rec.lcc_attribute16
483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17
484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18
485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19
486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20
487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21
488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22
489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23
490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24

Line 487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21

483: ,p_lcc_attribute17_o =>ben_lcc_shd.g_old_rec.lcc_attribute17
484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18
485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19
486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20
487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21
488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22
489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23
490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24
491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25

Line 488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22

484: ,p_lcc_attribute18_o =>ben_lcc_shd.g_old_rec.lcc_attribute18
485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19
486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20
487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21
488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22
489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23
490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24
491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25
492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26

Line 489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23

485: ,p_lcc_attribute19_o =>ben_lcc_shd.g_old_rec.lcc_attribute19
486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20
487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21
488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22
489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23
490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24
491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25
492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26
493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27

Line 490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24

486: ,p_lcc_attribute20_o =>ben_lcc_shd.g_old_rec.lcc_attribute20
487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21
488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22
489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23
490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24
491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25
492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26
493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27
494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28

Line 491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25

487: ,p_lcc_attribute21_o =>ben_lcc_shd.g_old_rec.lcc_attribute21
488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22
489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23
490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24
491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25
492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26
493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27
494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28
495: ,p_lcc_attribute29_o =>ben_lcc_shd.g_old_rec.lcc_attribute29

Line 492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26

488: ,p_lcc_attribute22_o =>ben_lcc_shd.g_old_rec.lcc_attribute22
489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23
490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24
491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25
492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26
493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27
494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28
495: ,p_lcc_attribute29_o =>ben_lcc_shd.g_old_rec.lcc_attribute29
496: ,p_lcc_attribute30_o =>ben_lcc_shd.g_old_rec.lcc_attribute30

Line 493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27

489: ,p_lcc_attribute23_o =>ben_lcc_shd.g_old_rec.lcc_attribute23
490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24
491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25
492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26
493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27
494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28
495: ,p_lcc_attribute29_o =>ben_lcc_shd.g_old_rec.lcc_attribute29
496: ,p_lcc_attribute30_o =>ben_lcc_shd.g_old_rec.lcc_attribute30
497: ,p_object_version_number_o =>ben_lcc_shd.g_old_rec.object_version_number

Line 494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28

490: ,p_lcc_attribute24_o =>ben_lcc_shd.g_old_rec.lcc_attribute24
491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25
492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26
493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27
494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28
495: ,p_lcc_attribute29_o =>ben_lcc_shd.g_old_rec.lcc_attribute29
496: ,p_lcc_attribute30_o =>ben_lcc_shd.g_old_rec.lcc_attribute30
497: ,p_object_version_number_o =>ben_lcc_shd.g_old_rec.object_version_number
498: );

Line 495: ,p_lcc_attribute29_o =>ben_lcc_shd.g_old_rec.lcc_attribute29

491: ,p_lcc_attribute25_o =>ben_lcc_shd.g_old_rec.lcc_attribute25
492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26
493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27
494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28
495: ,p_lcc_attribute29_o =>ben_lcc_shd.g_old_rec.lcc_attribute29
496: ,p_lcc_attribute30_o =>ben_lcc_shd.g_old_rec.lcc_attribute30
497: ,p_object_version_number_o =>ben_lcc_shd.g_old_rec.object_version_number
498: );
499: --

Line 496: ,p_lcc_attribute30_o =>ben_lcc_shd.g_old_rec.lcc_attribute30

492: ,p_lcc_attribute26_o =>ben_lcc_shd.g_old_rec.lcc_attribute26
493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27
494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28
495: ,p_lcc_attribute29_o =>ben_lcc_shd.g_old_rec.lcc_attribute29
496: ,p_lcc_attribute30_o =>ben_lcc_shd.g_old_rec.lcc_attribute30
497: ,p_object_version_number_o =>ben_lcc_shd.g_old_rec.object_version_number
498: );
499: --
500: exception

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

493: ,p_lcc_attribute27_o =>ben_lcc_shd.g_old_rec.lcc_attribute27
494: ,p_lcc_attribute28_o =>ben_lcc_shd.g_old_rec.lcc_attribute28
495: ,p_lcc_attribute29_o =>ben_lcc_shd.g_old_rec.lcc_attribute29
496: ,p_lcc_attribute30_o =>ben_lcc_shd.g_old_rec.lcc_attribute30
497: ,p_object_version_number_o =>ben_lcc_shd.g_old_rec.object_version_number
498: );
499: --
500: exception
501: --

Line 559: Procedure convert_defs(p_rec in out nocopy ben_lcc_shd.g_rec_type) is

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

Line 574: ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;

570: -- is being used then we must set to the 'current' argument value.
571: --
572: If (p_rec.dpnt_cvg_ctfn_typ_cd = hr_api.g_varchar2) then
573: p_rec.dpnt_cvg_ctfn_typ_cd :=
574: ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;
575: End If;
576: If (p_rec.ler_chg_dpnt_cvg_id = hr_api.g_number) then
577: p_rec.ler_chg_dpnt_cvg_id :=
578: ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id;

Line 578: ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id;

574: ben_lcc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;
575: End If;
576: If (p_rec.ler_chg_dpnt_cvg_id = hr_api.g_number) then
577: p_rec.ler_chg_dpnt_cvg_id :=
578: ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id;
579: End If;
580: If (p_rec.business_group_id = hr_api.g_number) then
581: p_rec.business_group_id :=
582: ben_lcc_shd.g_old_rec.business_group_id;

Line 582: ben_lcc_shd.g_old_rec.business_group_id;

578: ben_lcc_shd.g_old_rec.ler_chg_dpnt_cvg_id;
579: End If;
580: If (p_rec.business_group_id = hr_api.g_number) then
581: p_rec.business_group_id :=
582: ben_lcc_shd.g_old_rec.business_group_id;
583: End If;
584: If (p_rec.lcc_attribute_category = hr_api.g_varchar2) then
585: p_rec.lcc_attribute_category :=
586: ben_lcc_shd.g_old_rec.lcc_attribute_category;

Line 586: ben_lcc_shd.g_old_rec.lcc_attribute_category;

582: ben_lcc_shd.g_old_rec.business_group_id;
583: End If;
584: If (p_rec.lcc_attribute_category = hr_api.g_varchar2) then
585: p_rec.lcc_attribute_category :=
586: ben_lcc_shd.g_old_rec.lcc_attribute_category;
587: End If;
588: If (p_rec.lcc_attribute1 = hr_api.g_varchar2) then
589: p_rec.lcc_attribute1 :=
590: ben_lcc_shd.g_old_rec.lcc_attribute1;

Line 590: ben_lcc_shd.g_old_rec.lcc_attribute1;

586: ben_lcc_shd.g_old_rec.lcc_attribute_category;
587: End If;
588: If (p_rec.lcc_attribute1 = hr_api.g_varchar2) then
589: p_rec.lcc_attribute1 :=
590: ben_lcc_shd.g_old_rec.lcc_attribute1;
591: End If;
592: If (p_rec.lcc_attribute2 = hr_api.g_varchar2) then
593: p_rec.lcc_attribute2 :=
594: ben_lcc_shd.g_old_rec.lcc_attribute2;

Line 594: ben_lcc_shd.g_old_rec.lcc_attribute2;

590: ben_lcc_shd.g_old_rec.lcc_attribute1;
591: End If;
592: If (p_rec.lcc_attribute2 = hr_api.g_varchar2) then
593: p_rec.lcc_attribute2 :=
594: ben_lcc_shd.g_old_rec.lcc_attribute2;
595: End If;
596: If (p_rec.lcc_attribute3 = hr_api.g_varchar2) then
597: p_rec.lcc_attribute3 :=
598: ben_lcc_shd.g_old_rec.lcc_attribute3;

Line 598: ben_lcc_shd.g_old_rec.lcc_attribute3;

594: ben_lcc_shd.g_old_rec.lcc_attribute2;
595: End If;
596: If (p_rec.lcc_attribute3 = hr_api.g_varchar2) then
597: p_rec.lcc_attribute3 :=
598: ben_lcc_shd.g_old_rec.lcc_attribute3;
599: End If;
600: If (p_rec.lcc_attribute4 = hr_api.g_varchar2) then
601: p_rec.lcc_attribute4 :=
602: ben_lcc_shd.g_old_rec.lcc_attribute4;

Line 602: ben_lcc_shd.g_old_rec.lcc_attribute4;

598: ben_lcc_shd.g_old_rec.lcc_attribute3;
599: End If;
600: If (p_rec.lcc_attribute4 = hr_api.g_varchar2) then
601: p_rec.lcc_attribute4 :=
602: ben_lcc_shd.g_old_rec.lcc_attribute4;
603: End If;
604: If (p_rec.lcc_attribute5 = hr_api.g_varchar2) then
605: p_rec.lcc_attribute5 :=
606: ben_lcc_shd.g_old_rec.lcc_attribute5;

Line 606: ben_lcc_shd.g_old_rec.lcc_attribute5;

602: ben_lcc_shd.g_old_rec.lcc_attribute4;
603: End If;
604: If (p_rec.lcc_attribute5 = hr_api.g_varchar2) then
605: p_rec.lcc_attribute5 :=
606: ben_lcc_shd.g_old_rec.lcc_attribute5;
607: End If;
608: If (p_rec.lcc_attribute6 = hr_api.g_varchar2) then
609: p_rec.lcc_attribute6 :=
610: ben_lcc_shd.g_old_rec.lcc_attribute6;

Line 610: ben_lcc_shd.g_old_rec.lcc_attribute6;

606: ben_lcc_shd.g_old_rec.lcc_attribute5;
607: End If;
608: If (p_rec.lcc_attribute6 = hr_api.g_varchar2) then
609: p_rec.lcc_attribute6 :=
610: ben_lcc_shd.g_old_rec.lcc_attribute6;
611: End If;
612: If (p_rec.lcc_attribute7 = hr_api.g_varchar2) then
613: p_rec.lcc_attribute7 :=
614: ben_lcc_shd.g_old_rec.lcc_attribute7;

Line 614: ben_lcc_shd.g_old_rec.lcc_attribute7;

610: ben_lcc_shd.g_old_rec.lcc_attribute6;
611: End If;
612: If (p_rec.lcc_attribute7 = hr_api.g_varchar2) then
613: p_rec.lcc_attribute7 :=
614: ben_lcc_shd.g_old_rec.lcc_attribute7;
615: End If;
616: If (p_rec.lcc_attribute8 = hr_api.g_varchar2) then
617: p_rec.lcc_attribute8 :=
618: ben_lcc_shd.g_old_rec.lcc_attribute8;

Line 618: ben_lcc_shd.g_old_rec.lcc_attribute8;

614: ben_lcc_shd.g_old_rec.lcc_attribute7;
615: End If;
616: If (p_rec.lcc_attribute8 = hr_api.g_varchar2) then
617: p_rec.lcc_attribute8 :=
618: ben_lcc_shd.g_old_rec.lcc_attribute8;
619: End If;
620: If (p_rec.lcc_attribute9 = hr_api.g_varchar2) then
621: p_rec.lcc_attribute9 :=
622: ben_lcc_shd.g_old_rec.lcc_attribute9;

Line 622: ben_lcc_shd.g_old_rec.lcc_attribute9;

618: ben_lcc_shd.g_old_rec.lcc_attribute8;
619: End If;
620: If (p_rec.lcc_attribute9 = hr_api.g_varchar2) then
621: p_rec.lcc_attribute9 :=
622: ben_lcc_shd.g_old_rec.lcc_attribute9;
623: End If;
624: If (p_rec.lcc_attribute10 = hr_api.g_varchar2) then
625: p_rec.lcc_attribute10 :=
626: ben_lcc_shd.g_old_rec.lcc_attribute10;

Line 626: ben_lcc_shd.g_old_rec.lcc_attribute10;

622: ben_lcc_shd.g_old_rec.lcc_attribute9;
623: End If;
624: If (p_rec.lcc_attribute10 = hr_api.g_varchar2) then
625: p_rec.lcc_attribute10 :=
626: ben_lcc_shd.g_old_rec.lcc_attribute10;
627: End If;
628: If (p_rec.lcc_attribute11 = hr_api.g_varchar2) then
629: p_rec.lcc_attribute11 :=
630: ben_lcc_shd.g_old_rec.lcc_attribute11;

Line 630: ben_lcc_shd.g_old_rec.lcc_attribute11;

626: ben_lcc_shd.g_old_rec.lcc_attribute10;
627: End If;
628: If (p_rec.lcc_attribute11 = hr_api.g_varchar2) then
629: p_rec.lcc_attribute11 :=
630: ben_lcc_shd.g_old_rec.lcc_attribute11;
631: End If;
632: If (p_rec.lcc_attribute12 = hr_api.g_varchar2) then
633: p_rec.lcc_attribute12 :=
634: ben_lcc_shd.g_old_rec.lcc_attribute12;

Line 634: ben_lcc_shd.g_old_rec.lcc_attribute12;

630: ben_lcc_shd.g_old_rec.lcc_attribute11;
631: End If;
632: If (p_rec.lcc_attribute12 = hr_api.g_varchar2) then
633: p_rec.lcc_attribute12 :=
634: ben_lcc_shd.g_old_rec.lcc_attribute12;
635: End If;
636: If (p_rec.lcc_attribute13 = hr_api.g_varchar2) then
637: p_rec.lcc_attribute13 :=
638: ben_lcc_shd.g_old_rec.lcc_attribute13;

Line 638: ben_lcc_shd.g_old_rec.lcc_attribute13;

634: ben_lcc_shd.g_old_rec.lcc_attribute12;
635: End If;
636: If (p_rec.lcc_attribute13 = hr_api.g_varchar2) then
637: p_rec.lcc_attribute13 :=
638: ben_lcc_shd.g_old_rec.lcc_attribute13;
639: End If;
640: If (p_rec.lcc_attribute14 = hr_api.g_varchar2) then
641: p_rec.lcc_attribute14 :=
642: ben_lcc_shd.g_old_rec.lcc_attribute14;

Line 642: ben_lcc_shd.g_old_rec.lcc_attribute14;

638: ben_lcc_shd.g_old_rec.lcc_attribute13;
639: End If;
640: If (p_rec.lcc_attribute14 = hr_api.g_varchar2) then
641: p_rec.lcc_attribute14 :=
642: ben_lcc_shd.g_old_rec.lcc_attribute14;
643: End If;
644: If (p_rec.lcc_attribute15 = hr_api.g_varchar2) then
645: p_rec.lcc_attribute15 :=
646: ben_lcc_shd.g_old_rec.lcc_attribute15;

Line 646: ben_lcc_shd.g_old_rec.lcc_attribute15;

642: ben_lcc_shd.g_old_rec.lcc_attribute14;
643: End If;
644: If (p_rec.lcc_attribute15 = hr_api.g_varchar2) then
645: p_rec.lcc_attribute15 :=
646: ben_lcc_shd.g_old_rec.lcc_attribute15;
647: End If;
648: If (p_rec.lcc_attribute16 = hr_api.g_varchar2) then
649: p_rec.lcc_attribute16 :=
650: ben_lcc_shd.g_old_rec.lcc_attribute16;

Line 650: ben_lcc_shd.g_old_rec.lcc_attribute16;

646: ben_lcc_shd.g_old_rec.lcc_attribute15;
647: End If;
648: If (p_rec.lcc_attribute16 = hr_api.g_varchar2) then
649: p_rec.lcc_attribute16 :=
650: ben_lcc_shd.g_old_rec.lcc_attribute16;
651: End If;
652: If (p_rec.lcc_attribute17 = hr_api.g_varchar2) then
653: p_rec.lcc_attribute17 :=
654: ben_lcc_shd.g_old_rec.lcc_attribute17;

Line 654: ben_lcc_shd.g_old_rec.lcc_attribute17;

650: ben_lcc_shd.g_old_rec.lcc_attribute16;
651: End If;
652: If (p_rec.lcc_attribute17 = hr_api.g_varchar2) then
653: p_rec.lcc_attribute17 :=
654: ben_lcc_shd.g_old_rec.lcc_attribute17;
655: End If;
656: If (p_rec.lcc_attribute18 = hr_api.g_varchar2) then
657: p_rec.lcc_attribute18 :=
658: ben_lcc_shd.g_old_rec.lcc_attribute18;

Line 658: ben_lcc_shd.g_old_rec.lcc_attribute18;

654: ben_lcc_shd.g_old_rec.lcc_attribute17;
655: End If;
656: If (p_rec.lcc_attribute18 = hr_api.g_varchar2) then
657: p_rec.lcc_attribute18 :=
658: ben_lcc_shd.g_old_rec.lcc_attribute18;
659: End If;
660: If (p_rec.lcc_attribute19 = hr_api.g_varchar2) then
661: p_rec.lcc_attribute19 :=
662: ben_lcc_shd.g_old_rec.lcc_attribute19;

Line 662: ben_lcc_shd.g_old_rec.lcc_attribute19;

658: ben_lcc_shd.g_old_rec.lcc_attribute18;
659: End If;
660: If (p_rec.lcc_attribute19 = hr_api.g_varchar2) then
661: p_rec.lcc_attribute19 :=
662: ben_lcc_shd.g_old_rec.lcc_attribute19;
663: End If;
664: If (p_rec.lcc_attribute20 = hr_api.g_varchar2) then
665: p_rec.lcc_attribute20 :=
666: ben_lcc_shd.g_old_rec.lcc_attribute20;

Line 666: ben_lcc_shd.g_old_rec.lcc_attribute20;

662: ben_lcc_shd.g_old_rec.lcc_attribute19;
663: End If;
664: If (p_rec.lcc_attribute20 = hr_api.g_varchar2) then
665: p_rec.lcc_attribute20 :=
666: ben_lcc_shd.g_old_rec.lcc_attribute20;
667: End If;
668: If (p_rec.lcc_attribute21 = hr_api.g_varchar2) then
669: p_rec.lcc_attribute21 :=
670: ben_lcc_shd.g_old_rec.lcc_attribute21;

Line 670: ben_lcc_shd.g_old_rec.lcc_attribute21;

666: ben_lcc_shd.g_old_rec.lcc_attribute20;
667: End If;
668: If (p_rec.lcc_attribute21 = hr_api.g_varchar2) then
669: p_rec.lcc_attribute21 :=
670: ben_lcc_shd.g_old_rec.lcc_attribute21;
671: End If;
672: If (p_rec.lcc_attribute22 = hr_api.g_varchar2) then
673: p_rec.lcc_attribute22 :=
674: ben_lcc_shd.g_old_rec.lcc_attribute22;

Line 674: ben_lcc_shd.g_old_rec.lcc_attribute22;

670: ben_lcc_shd.g_old_rec.lcc_attribute21;
671: End If;
672: If (p_rec.lcc_attribute22 = hr_api.g_varchar2) then
673: p_rec.lcc_attribute22 :=
674: ben_lcc_shd.g_old_rec.lcc_attribute22;
675: End If;
676: If (p_rec.lcc_attribute23 = hr_api.g_varchar2) then
677: p_rec.lcc_attribute23 :=
678: ben_lcc_shd.g_old_rec.lcc_attribute23;

Line 678: ben_lcc_shd.g_old_rec.lcc_attribute23;

674: ben_lcc_shd.g_old_rec.lcc_attribute22;
675: End If;
676: If (p_rec.lcc_attribute23 = hr_api.g_varchar2) then
677: p_rec.lcc_attribute23 :=
678: ben_lcc_shd.g_old_rec.lcc_attribute23;
679: End If;
680: If (p_rec.lcc_attribute24 = hr_api.g_varchar2) then
681: p_rec.lcc_attribute24 :=
682: ben_lcc_shd.g_old_rec.lcc_attribute24;

Line 682: ben_lcc_shd.g_old_rec.lcc_attribute24;

678: ben_lcc_shd.g_old_rec.lcc_attribute23;
679: End If;
680: If (p_rec.lcc_attribute24 = hr_api.g_varchar2) then
681: p_rec.lcc_attribute24 :=
682: ben_lcc_shd.g_old_rec.lcc_attribute24;
683: End If;
684: If (p_rec.lcc_attribute25 = hr_api.g_varchar2) then
685: p_rec.lcc_attribute25 :=
686: ben_lcc_shd.g_old_rec.lcc_attribute25;

Line 686: ben_lcc_shd.g_old_rec.lcc_attribute25;

682: ben_lcc_shd.g_old_rec.lcc_attribute24;
683: End If;
684: If (p_rec.lcc_attribute25 = hr_api.g_varchar2) then
685: p_rec.lcc_attribute25 :=
686: ben_lcc_shd.g_old_rec.lcc_attribute25;
687: End If;
688: If (p_rec.lcc_attribute26 = hr_api.g_varchar2) then
689: p_rec.lcc_attribute26 :=
690: ben_lcc_shd.g_old_rec.lcc_attribute26;

Line 690: ben_lcc_shd.g_old_rec.lcc_attribute26;

686: ben_lcc_shd.g_old_rec.lcc_attribute25;
687: End If;
688: If (p_rec.lcc_attribute26 = hr_api.g_varchar2) then
689: p_rec.lcc_attribute26 :=
690: ben_lcc_shd.g_old_rec.lcc_attribute26;
691: End If;
692: If (p_rec.lcc_attribute27 = hr_api.g_varchar2) then
693: p_rec.lcc_attribute27 :=
694: ben_lcc_shd.g_old_rec.lcc_attribute27;

Line 694: ben_lcc_shd.g_old_rec.lcc_attribute27;

690: ben_lcc_shd.g_old_rec.lcc_attribute26;
691: End If;
692: If (p_rec.lcc_attribute27 = hr_api.g_varchar2) then
693: p_rec.lcc_attribute27 :=
694: ben_lcc_shd.g_old_rec.lcc_attribute27;
695: End If;
696: If (p_rec.lcc_attribute28 = hr_api.g_varchar2) then
697: p_rec.lcc_attribute28 :=
698: ben_lcc_shd.g_old_rec.lcc_attribute28;

Line 698: ben_lcc_shd.g_old_rec.lcc_attribute28;

694: ben_lcc_shd.g_old_rec.lcc_attribute27;
695: End If;
696: If (p_rec.lcc_attribute28 = hr_api.g_varchar2) then
697: p_rec.lcc_attribute28 :=
698: ben_lcc_shd.g_old_rec.lcc_attribute28;
699: End If;
700: If (p_rec.lcc_attribute29 = hr_api.g_varchar2) then
701: p_rec.lcc_attribute29 :=
702: ben_lcc_shd.g_old_rec.lcc_attribute29;

Line 702: ben_lcc_shd.g_old_rec.lcc_attribute29;

698: ben_lcc_shd.g_old_rec.lcc_attribute28;
699: End If;
700: If (p_rec.lcc_attribute29 = hr_api.g_varchar2) then
701: p_rec.lcc_attribute29 :=
702: ben_lcc_shd.g_old_rec.lcc_attribute29;
703: End If;
704: If (p_rec.lcc_attribute30 = hr_api.g_varchar2) then
705: p_rec.lcc_attribute30 :=
706: ben_lcc_shd.g_old_rec.lcc_attribute30;

Line 706: ben_lcc_shd.g_old_rec.lcc_attribute30;

702: ben_lcc_shd.g_old_rec.lcc_attribute29;
703: End If;
704: If (p_rec.lcc_attribute30 = hr_api.g_varchar2) then
705: p_rec.lcc_attribute30 :=
706: ben_lcc_shd.g_old_rec.lcc_attribute30;
707: End If;
708:
709: --
710: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 719: p_rec in out nocopy ben_lcc_shd.g_rec_type,

715: -- |---------------------------------< upd >----------------------------------|
716: -- ----------------------------------------------------------------------------
717: Procedure upd
718: (
719: p_rec in out nocopy ben_lcc_shd.g_rec_type,
720: p_effective_date in date,
721: p_datetrack_mode in varchar2
722: ) is
723: --

Line 737: ben_lcc_shd.lck

733: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
734: --
735: -- We must lock the row which we need to update.
736: --
737: ben_lcc_shd.lck
738: (p_effective_date => p_effective_date,
739: p_datetrack_mode => p_datetrack_mode,
740: p_ler_chg_dpnt_cvg_ctfn_id => p_rec.ler_chg_dpnt_cvg_ctfn_id,
741: p_object_version_number => p_rec.object_version_number,

Line 838: l_rec ben_lcc_shd.g_rec_type;

834: p_effective_date in date,
835: p_datetrack_mode in varchar2
836: ) is
837: --
838: l_rec ben_lcc_shd.g_rec_type;
839: l_proc varchar2(72) := g_package||'upd';
840: --
841: Begin
842: hr_utility.set_location('Entering:'||l_proc, 5);

Line 848: ben_lcc_shd.convert_args

844: -- Call conversion function to turn arguments into the
845: -- l_rec structure.
846: --
847: l_rec :=
848: ben_lcc_shd.convert_args
849: (
850: p_ler_chg_dpnt_cvg_ctfn_id,
851: null,
852: null,