DBA Data[Home] [Help]

APPS.BEN_PYD_UPD dependencies on BEN_PYD_SHD

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

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

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

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

128: where ptip_dpnt_cvg_ctfn_id = p_rec.ptip_dpnt_cvg_ctfn_id
129: and effective_start_date = p_validation_start_date
130: and effective_end_date = p_validation_end_date;
131: --
132: ben_pyd_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_pyd_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_pyd_shd.g_api_dml := false; -- Unset the api dml status
145: ben_pyd_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_pyd_shd.constraint_error

141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
145: ben_pyd_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_pyd_shd.g_api_dml := false; -- Unset the api dml status

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

145: ben_pyd_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_pyd_shd.g_api_dml := false; -- Unset the api dml status
150: ben_pyd_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status

Line 150: ben_pyd_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_pyd_shd.g_api_dml := false; -- Unset the api dml status
150: ben_pyd_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
154: Raise;

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

149: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
150: ben_pyd_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_pyd_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_pyd_shd.g_rec_type,

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure update_dml
189: (p_rec in out nocopy ben_pyd_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_pyd_shd.g_rec_type,

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_pre_update
253: (p_rec in out nocopy ben_pyd_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_pyd_shd.upd_effective_end_date

265: hr_utility.set_location(l_proc, 10);
266: --
267: -- Update the current effective end date
268: --
269: ben_pyd_shd.upd_effective_end_date
270: (p_effective_date => p_effective_date,
271: p_base_key_value => p_rec.ptip_dpnt_cvg_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_pyd_shd.g_rec_type,

334: --
335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure pre_update
338: (p_rec in out nocopy ben_pyd_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_pyd_shd.g_rec_type,

390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure post_update
394: (p_rec in ben_pyd_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 459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date

455: ,p_effective_date =>p_effective_date
456: ,p_datetrack_mode =>p_datetrack_mode
457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag

Line 460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date

456: ,p_datetrack_mode =>p_datetrack_mode
457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>

Line 461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id

457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag

Line 462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id

458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl

Line 463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag

459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd

Line 465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag

461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag

Line 466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl

462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category

Line 467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd

463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1

Line 468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd

464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2

Line 469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag

465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3

Line 470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category

466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4

Line 471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1

467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5

Line 472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2

468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6

Line 473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3

469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7

Line 474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4

470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8

Line 475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5

471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9

Line 476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6

472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10

Line 477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7

473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11

Line 478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8

474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12

Line 479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9

475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13

Line 480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10

476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14

Line 481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11

477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15

Line 482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12

478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16

Line 483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13

479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17

Line 484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14

480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18

Line 485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15

481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19

Line 486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16

482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20

Line 487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17

483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21

Line 488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18

484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22

Line 489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19

485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23

Line 490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20

486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24

Line 491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21

487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25

Line 492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22

488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26

Line 493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23

489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27

Line 494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24

490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28

Line 495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25

491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29

Line 496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26

492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30

Line 497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27

493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number

Line 498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28

494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
502: );

Line 499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29

495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
502: );
503: --

Line 500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30

496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
502: );
503: --
504: exception

Line 501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number

497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
502: );
503: --
504: exception
505: --

Line 563: Procedure convert_defs(p_rec in out nocopy ben_pyd_shd.g_rec_type) is

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

Line 578: ben_pyd_shd.g_old_rec.business_group_id;

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

Line 582: ben_pyd_shd.g_old_rec.ptip_id;

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

Line 586: ben_pyd_shd.g_old_rec.pfd_flag;

582: ben_pyd_shd.g_old_rec.ptip_id;
583: End If;
584: If (p_rec.pfd_flag = hr_api.g_varchar2) then
585: p_rec.pfd_flag :=
586: ben_pyd_shd.g_old_rec.pfd_flag;
587: End If;
588: If (p_rec.lack_ctfn_sspnd_enrt_flag = hr_api.g_varchar2) then
589: p_rec.lack_ctfn_sspnd_enrt_flag :=
590: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag;

Line 590: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag;

586: ben_pyd_shd.g_old_rec.pfd_flag;
587: End If;
588: If (p_rec.lack_ctfn_sspnd_enrt_flag = hr_api.g_varchar2) then
589: p_rec.lack_ctfn_sspnd_enrt_flag :=
590: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag;
591: End If;
592: If (p_rec.ctfn_rqd_when_rl = hr_api.g_number) then
593: p_rec.ctfn_rqd_when_rl :=
594: ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl;

Line 594: ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl;

590: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag;
591: End If;
592: If (p_rec.ctfn_rqd_when_rl = hr_api.g_number) then
593: p_rec.ctfn_rqd_when_rl :=
594: ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl;
595: End If;
596: If (p_rec.dpnt_cvg_ctfn_typ_cd = hr_api.g_varchar2) then
597: p_rec.dpnt_cvg_ctfn_typ_cd :=
598: ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;

Line 598: ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;

594: ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl;
595: End If;
596: If (p_rec.dpnt_cvg_ctfn_typ_cd = hr_api.g_varchar2) then
597: p_rec.dpnt_cvg_ctfn_typ_cd :=
598: ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;
599: End If;
600: If (p_rec.rlshp_typ_cd = hr_api.g_varchar2) then
601: p_rec.rlshp_typ_cd :=
602: ben_pyd_shd.g_old_rec.rlshp_typ_cd;

Line 602: ben_pyd_shd.g_old_rec.rlshp_typ_cd;

598: ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;
599: End If;
600: If (p_rec.rlshp_typ_cd = hr_api.g_varchar2) then
601: p_rec.rlshp_typ_cd :=
602: ben_pyd_shd.g_old_rec.rlshp_typ_cd;
603: End If;
604: If (p_rec.rqd_flag = hr_api.g_varchar2) then
605: p_rec.rqd_flag :=
606: ben_pyd_shd.g_old_rec.rqd_flag;

Line 606: ben_pyd_shd.g_old_rec.rqd_flag;

602: ben_pyd_shd.g_old_rec.rlshp_typ_cd;
603: End If;
604: If (p_rec.rqd_flag = hr_api.g_varchar2) then
605: p_rec.rqd_flag :=
606: ben_pyd_shd.g_old_rec.rqd_flag;
607: End If;
608: If (p_rec.pyd_attribute_category = hr_api.g_varchar2) then
609: p_rec.pyd_attribute_category :=
610: ben_pyd_shd.g_old_rec.pyd_attribute_category;

Line 610: ben_pyd_shd.g_old_rec.pyd_attribute_category;

606: ben_pyd_shd.g_old_rec.rqd_flag;
607: End If;
608: If (p_rec.pyd_attribute_category = hr_api.g_varchar2) then
609: p_rec.pyd_attribute_category :=
610: ben_pyd_shd.g_old_rec.pyd_attribute_category;
611: End If;
612: If (p_rec.pyd_attribute1 = hr_api.g_varchar2) then
613: p_rec.pyd_attribute1 :=
614: ben_pyd_shd.g_old_rec.pyd_attribute1;

Line 614: ben_pyd_shd.g_old_rec.pyd_attribute1;

610: ben_pyd_shd.g_old_rec.pyd_attribute_category;
611: End If;
612: If (p_rec.pyd_attribute1 = hr_api.g_varchar2) then
613: p_rec.pyd_attribute1 :=
614: ben_pyd_shd.g_old_rec.pyd_attribute1;
615: End If;
616: If (p_rec.pyd_attribute2 = hr_api.g_varchar2) then
617: p_rec.pyd_attribute2 :=
618: ben_pyd_shd.g_old_rec.pyd_attribute2;

Line 618: ben_pyd_shd.g_old_rec.pyd_attribute2;

614: ben_pyd_shd.g_old_rec.pyd_attribute1;
615: End If;
616: If (p_rec.pyd_attribute2 = hr_api.g_varchar2) then
617: p_rec.pyd_attribute2 :=
618: ben_pyd_shd.g_old_rec.pyd_attribute2;
619: End If;
620: If (p_rec.pyd_attribute3 = hr_api.g_varchar2) then
621: p_rec.pyd_attribute3 :=
622: ben_pyd_shd.g_old_rec.pyd_attribute3;

Line 622: ben_pyd_shd.g_old_rec.pyd_attribute3;

618: ben_pyd_shd.g_old_rec.pyd_attribute2;
619: End If;
620: If (p_rec.pyd_attribute3 = hr_api.g_varchar2) then
621: p_rec.pyd_attribute3 :=
622: ben_pyd_shd.g_old_rec.pyd_attribute3;
623: End If;
624: If (p_rec.pyd_attribute4 = hr_api.g_varchar2) then
625: p_rec.pyd_attribute4 :=
626: ben_pyd_shd.g_old_rec.pyd_attribute4;

Line 626: ben_pyd_shd.g_old_rec.pyd_attribute4;

622: ben_pyd_shd.g_old_rec.pyd_attribute3;
623: End If;
624: If (p_rec.pyd_attribute4 = hr_api.g_varchar2) then
625: p_rec.pyd_attribute4 :=
626: ben_pyd_shd.g_old_rec.pyd_attribute4;
627: End If;
628: If (p_rec.pyd_attribute5 = hr_api.g_varchar2) then
629: p_rec.pyd_attribute5 :=
630: ben_pyd_shd.g_old_rec.pyd_attribute5;

Line 630: ben_pyd_shd.g_old_rec.pyd_attribute5;

626: ben_pyd_shd.g_old_rec.pyd_attribute4;
627: End If;
628: If (p_rec.pyd_attribute5 = hr_api.g_varchar2) then
629: p_rec.pyd_attribute5 :=
630: ben_pyd_shd.g_old_rec.pyd_attribute5;
631: End If;
632: If (p_rec.pyd_attribute6 = hr_api.g_varchar2) then
633: p_rec.pyd_attribute6 :=
634: ben_pyd_shd.g_old_rec.pyd_attribute6;

Line 634: ben_pyd_shd.g_old_rec.pyd_attribute6;

630: ben_pyd_shd.g_old_rec.pyd_attribute5;
631: End If;
632: If (p_rec.pyd_attribute6 = hr_api.g_varchar2) then
633: p_rec.pyd_attribute6 :=
634: ben_pyd_shd.g_old_rec.pyd_attribute6;
635: End If;
636: If (p_rec.pyd_attribute7 = hr_api.g_varchar2) then
637: p_rec.pyd_attribute7 :=
638: ben_pyd_shd.g_old_rec.pyd_attribute7;

Line 638: ben_pyd_shd.g_old_rec.pyd_attribute7;

634: ben_pyd_shd.g_old_rec.pyd_attribute6;
635: End If;
636: If (p_rec.pyd_attribute7 = hr_api.g_varchar2) then
637: p_rec.pyd_attribute7 :=
638: ben_pyd_shd.g_old_rec.pyd_attribute7;
639: End If;
640: If (p_rec.pyd_attribute8 = hr_api.g_varchar2) then
641: p_rec.pyd_attribute8 :=
642: ben_pyd_shd.g_old_rec.pyd_attribute8;

Line 642: ben_pyd_shd.g_old_rec.pyd_attribute8;

638: ben_pyd_shd.g_old_rec.pyd_attribute7;
639: End If;
640: If (p_rec.pyd_attribute8 = hr_api.g_varchar2) then
641: p_rec.pyd_attribute8 :=
642: ben_pyd_shd.g_old_rec.pyd_attribute8;
643: End If;
644: If (p_rec.pyd_attribute9 = hr_api.g_varchar2) then
645: p_rec.pyd_attribute9 :=
646: ben_pyd_shd.g_old_rec.pyd_attribute9;

Line 646: ben_pyd_shd.g_old_rec.pyd_attribute9;

642: ben_pyd_shd.g_old_rec.pyd_attribute8;
643: End If;
644: If (p_rec.pyd_attribute9 = hr_api.g_varchar2) then
645: p_rec.pyd_attribute9 :=
646: ben_pyd_shd.g_old_rec.pyd_attribute9;
647: End If;
648: If (p_rec.pyd_attribute10 = hr_api.g_varchar2) then
649: p_rec.pyd_attribute10 :=
650: ben_pyd_shd.g_old_rec.pyd_attribute10;

Line 650: ben_pyd_shd.g_old_rec.pyd_attribute10;

646: ben_pyd_shd.g_old_rec.pyd_attribute9;
647: End If;
648: If (p_rec.pyd_attribute10 = hr_api.g_varchar2) then
649: p_rec.pyd_attribute10 :=
650: ben_pyd_shd.g_old_rec.pyd_attribute10;
651: End If;
652: If (p_rec.pyd_attribute11 = hr_api.g_varchar2) then
653: p_rec.pyd_attribute11 :=
654: ben_pyd_shd.g_old_rec.pyd_attribute11;

Line 654: ben_pyd_shd.g_old_rec.pyd_attribute11;

650: ben_pyd_shd.g_old_rec.pyd_attribute10;
651: End If;
652: If (p_rec.pyd_attribute11 = hr_api.g_varchar2) then
653: p_rec.pyd_attribute11 :=
654: ben_pyd_shd.g_old_rec.pyd_attribute11;
655: End If;
656: If (p_rec.pyd_attribute12 = hr_api.g_varchar2) then
657: p_rec.pyd_attribute12 :=
658: ben_pyd_shd.g_old_rec.pyd_attribute12;

Line 658: ben_pyd_shd.g_old_rec.pyd_attribute12;

654: ben_pyd_shd.g_old_rec.pyd_attribute11;
655: End If;
656: If (p_rec.pyd_attribute12 = hr_api.g_varchar2) then
657: p_rec.pyd_attribute12 :=
658: ben_pyd_shd.g_old_rec.pyd_attribute12;
659: End If;
660: If (p_rec.pyd_attribute13 = hr_api.g_varchar2) then
661: p_rec.pyd_attribute13 :=
662: ben_pyd_shd.g_old_rec.pyd_attribute13;

Line 662: ben_pyd_shd.g_old_rec.pyd_attribute13;

658: ben_pyd_shd.g_old_rec.pyd_attribute12;
659: End If;
660: If (p_rec.pyd_attribute13 = hr_api.g_varchar2) then
661: p_rec.pyd_attribute13 :=
662: ben_pyd_shd.g_old_rec.pyd_attribute13;
663: End If;
664: If (p_rec.pyd_attribute14 = hr_api.g_varchar2) then
665: p_rec.pyd_attribute14 :=
666: ben_pyd_shd.g_old_rec.pyd_attribute14;

Line 666: ben_pyd_shd.g_old_rec.pyd_attribute14;

662: ben_pyd_shd.g_old_rec.pyd_attribute13;
663: End If;
664: If (p_rec.pyd_attribute14 = hr_api.g_varchar2) then
665: p_rec.pyd_attribute14 :=
666: ben_pyd_shd.g_old_rec.pyd_attribute14;
667: End If;
668: If (p_rec.pyd_attribute15 = hr_api.g_varchar2) then
669: p_rec.pyd_attribute15 :=
670: ben_pyd_shd.g_old_rec.pyd_attribute15;

Line 670: ben_pyd_shd.g_old_rec.pyd_attribute15;

666: ben_pyd_shd.g_old_rec.pyd_attribute14;
667: End If;
668: If (p_rec.pyd_attribute15 = hr_api.g_varchar2) then
669: p_rec.pyd_attribute15 :=
670: ben_pyd_shd.g_old_rec.pyd_attribute15;
671: End If;
672: If (p_rec.pyd_attribute16 = hr_api.g_varchar2) then
673: p_rec.pyd_attribute16 :=
674: ben_pyd_shd.g_old_rec.pyd_attribute16;

Line 674: ben_pyd_shd.g_old_rec.pyd_attribute16;

670: ben_pyd_shd.g_old_rec.pyd_attribute15;
671: End If;
672: If (p_rec.pyd_attribute16 = hr_api.g_varchar2) then
673: p_rec.pyd_attribute16 :=
674: ben_pyd_shd.g_old_rec.pyd_attribute16;
675: End If;
676: If (p_rec.pyd_attribute17 = hr_api.g_varchar2) then
677: p_rec.pyd_attribute17 :=
678: ben_pyd_shd.g_old_rec.pyd_attribute17;

Line 678: ben_pyd_shd.g_old_rec.pyd_attribute17;

674: ben_pyd_shd.g_old_rec.pyd_attribute16;
675: End If;
676: If (p_rec.pyd_attribute17 = hr_api.g_varchar2) then
677: p_rec.pyd_attribute17 :=
678: ben_pyd_shd.g_old_rec.pyd_attribute17;
679: End If;
680: If (p_rec.pyd_attribute18 = hr_api.g_varchar2) then
681: p_rec.pyd_attribute18 :=
682: ben_pyd_shd.g_old_rec.pyd_attribute18;

Line 682: ben_pyd_shd.g_old_rec.pyd_attribute18;

678: ben_pyd_shd.g_old_rec.pyd_attribute17;
679: End If;
680: If (p_rec.pyd_attribute18 = hr_api.g_varchar2) then
681: p_rec.pyd_attribute18 :=
682: ben_pyd_shd.g_old_rec.pyd_attribute18;
683: End If;
684: If (p_rec.pyd_attribute19 = hr_api.g_varchar2) then
685: p_rec.pyd_attribute19 :=
686: ben_pyd_shd.g_old_rec.pyd_attribute19;

Line 686: ben_pyd_shd.g_old_rec.pyd_attribute19;

682: ben_pyd_shd.g_old_rec.pyd_attribute18;
683: End If;
684: If (p_rec.pyd_attribute19 = hr_api.g_varchar2) then
685: p_rec.pyd_attribute19 :=
686: ben_pyd_shd.g_old_rec.pyd_attribute19;
687: End If;
688: If (p_rec.pyd_attribute20 = hr_api.g_varchar2) then
689: p_rec.pyd_attribute20 :=
690: ben_pyd_shd.g_old_rec.pyd_attribute20;

Line 690: ben_pyd_shd.g_old_rec.pyd_attribute20;

686: ben_pyd_shd.g_old_rec.pyd_attribute19;
687: End If;
688: If (p_rec.pyd_attribute20 = hr_api.g_varchar2) then
689: p_rec.pyd_attribute20 :=
690: ben_pyd_shd.g_old_rec.pyd_attribute20;
691: End If;
692: If (p_rec.pyd_attribute21 = hr_api.g_varchar2) then
693: p_rec.pyd_attribute21 :=
694: ben_pyd_shd.g_old_rec.pyd_attribute21;

Line 694: ben_pyd_shd.g_old_rec.pyd_attribute21;

690: ben_pyd_shd.g_old_rec.pyd_attribute20;
691: End If;
692: If (p_rec.pyd_attribute21 = hr_api.g_varchar2) then
693: p_rec.pyd_attribute21 :=
694: ben_pyd_shd.g_old_rec.pyd_attribute21;
695: End If;
696: If (p_rec.pyd_attribute22 = hr_api.g_varchar2) then
697: p_rec.pyd_attribute22 :=
698: ben_pyd_shd.g_old_rec.pyd_attribute22;

Line 698: ben_pyd_shd.g_old_rec.pyd_attribute22;

694: ben_pyd_shd.g_old_rec.pyd_attribute21;
695: End If;
696: If (p_rec.pyd_attribute22 = hr_api.g_varchar2) then
697: p_rec.pyd_attribute22 :=
698: ben_pyd_shd.g_old_rec.pyd_attribute22;
699: End If;
700: If (p_rec.pyd_attribute23 = hr_api.g_varchar2) then
701: p_rec.pyd_attribute23 :=
702: ben_pyd_shd.g_old_rec.pyd_attribute23;

Line 702: ben_pyd_shd.g_old_rec.pyd_attribute23;

698: ben_pyd_shd.g_old_rec.pyd_attribute22;
699: End If;
700: If (p_rec.pyd_attribute23 = hr_api.g_varchar2) then
701: p_rec.pyd_attribute23 :=
702: ben_pyd_shd.g_old_rec.pyd_attribute23;
703: End If;
704: If (p_rec.pyd_attribute24 = hr_api.g_varchar2) then
705: p_rec.pyd_attribute24 :=
706: ben_pyd_shd.g_old_rec.pyd_attribute24;

Line 706: ben_pyd_shd.g_old_rec.pyd_attribute24;

702: ben_pyd_shd.g_old_rec.pyd_attribute23;
703: End If;
704: If (p_rec.pyd_attribute24 = hr_api.g_varchar2) then
705: p_rec.pyd_attribute24 :=
706: ben_pyd_shd.g_old_rec.pyd_attribute24;
707: End If;
708: If (p_rec.pyd_attribute25 = hr_api.g_varchar2) then
709: p_rec.pyd_attribute25 :=
710: ben_pyd_shd.g_old_rec.pyd_attribute25;

Line 710: ben_pyd_shd.g_old_rec.pyd_attribute25;

706: ben_pyd_shd.g_old_rec.pyd_attribute24;
707: End If;
708: If (p_rec.pyd_attribute25 = hr_api.g_varchar2) then
709: p_rec.pyd_attribute25 :=
710: ben_pyd_shd.g_old_rec.pyd_attribute25;
711: End If;
712: If (p_rec.pyd_attribute26 = hr_api.g_varchar2) then
713: p_rec.pyd_attribute26 :=
714: ben_pyd_shd.g_old_rec.pyd_attribute26;

Line 714: ben_pyd_shd.g_old_rec.pyd_attribute26;

710: ben_pyd_shd.g_old_rec.pyd_attribute25;
711: End If;
712: If (p_rec.pyd_attribute26 = hr_api.g_varchar2) then
713: p_rec.pyd_attribute26 :=
714: ben_pyd_shd.g_old_rec.pyd_attribute26;
715: End If;
716: If (p_rec.pyd_attribute27 = hr_api.g_varchar2) then
717: p_rec.pyd_attribute27 :=
718: ben_pyd_shd.g_old_rec.pyd_attribute27;

Line 718: ben_pyd_shd.g_old_rec.pyd_attribute27;

714: ben_pyd_shd.g_old_rec.pyd_attribute26;
715: End If;
716: If (p_rec.pyd_attribute27 = hr_api.g_varchar2) then
717: p_rec.pyd_attribute27 :=
718: ben_pyd_shd.g_old_rec.pyd_attribute27;
719: End If;
720: If (p_rec.pyd_attribute28 = hr_api.g_varchar2) then
721: p_rec.pyd_attribute28 :=
722: ben_pyd_shd.g_old_rec.pyd_attribute28;

Line 722: ben_pyd_shd.g_old_rec.pyd_attribute28;

718: ben_pyd_shd.g_old_rec.pyd_attribute27;
719: End If;
720: If (p_rec.pyd_attribute28 = hr_api.g_varchar2) then
721: p_rec.pyd_attribute28 :=
722: ben_pyd_shd.g_old_rec.pyd_attribute28;
723: End If;
724: If (p_rec.pyd_attribute29 = hr_api.g_varchar2) then
725: p_rec.pyd_attribute29 :=
726: ben_pyd_shd.g_old_rec.pyd_attribute29;

Line 726: ben_pyd_shd.g_old_rec.pyd_attribute29;

722: ben_pyd_shd.g_old_rec.pyd_attribute28;
723: End If;
724: If (p_rec.pyd_attribute29 = hr_api.g_varchar2) then
725: p_rec.pyd_attribute29 :=
726: ben_pyd_shd.g_old_rec.pyd_attribute29;
727: End If;
728: If (p_rec.pyd_attribute30 = hr_api.g_varchar2) then
729: p_rec.pyd_attribute30 :=
730: ben_pyd_shd.g_old_rec.pyd_attribute30;

Line 730: ben_pyd_shd.g_old_rec.pyd_attribute30;

726: ben_pyd_shd.g_old_rec.pyd_attribute29;
727: End If;
728: If (p_rec.pyd_attribute30 = hr_api.g_varchar2) then
729: p_rec.pyd_attribute30 :=
730: ben_pyd_shd.g_old_rec.pyd_attribute30;
731: End If;
732:
733: --
734: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 743: p_rec in out nocopy ben_pyd_shd.g_rec_type,

739: -- |---------------------------------< upd >----------------------------------|
740: -- ----------------------------------------------------------------------------
741: Procedure upd
742: (
743: p_rec in out nocopy ben_pyd_shd.g_rec_type,
744: p_effective_date in date,
745: p_datetrack_mode in varchar2
746: ) is
747: --

Line 761: ben_pyd_shd.lck

757: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
758: --
759: -- We must lock the row which we need to update.
760: --
761: ben_pyd_shd.lck
762: (p_effective_date => p_effective_date,
763: p_datetrack_mode => p_datetrack_mode,
764: p_ptip_dpnt_cvg_ctfn_id => p_rec.ptip_dpnt_cvg_ctfn_id,
765: p_object_version_number => p_rec.object_version_number,

Line 863: l_rec ben_pyd_shd.g_rec_type;

859: p_effective_date in date,
860: p_datetrack_mode in varchar2
861: ) is
862: --
863: l_rec ben_pyd_shd.g_rec_type;
864: l_proc varchar2(72) := g_package||'upd';
865: --
866: Begin
867: hr_utility.set_location('Entering:'||l_proc, 5);

Line 873: ben_pyd_shd.convert_args

869: -- Call conversion function to turn arguments into the
870: -- l_rec structure.
871: --
872: l_rec :=
873: ben_pyd_shd.convert_args
874: (
875: p_ptip_dpnt_cvg_ctfn_id,
876: null,
877: null,