54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_ptp_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
77: (p_base_table_name => 'ben_pl_typ_f',
78: p_base_key_column => 'pl_typ_id',
79: p_base_key_value => p_rec.pl_typ_id);
80: --
81: ben_ptp_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_pl_typ_f Row
84: --
85: update ben_pl_typ_f
135: where pl_typ_id = p_rec.pl_typ_id
136: and effective_start_date = p_validation_start_date
137: and effective_end_date = p_validation_end_date;
138: --
139: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
140: --
141: -- Set the effective start and end dates
142: --
143: p_rec.effective_start_date := p_validation_start_date;
147: hr_utility.set_location(' Leaving:'||l_proc, 15);
148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_ptp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_ptp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_ptp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
157: ben_ptp_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
157: ben_ptp_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
161: Raise;
156: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
157: ben_ptp_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
161: Raise;
162: End dt_update_dml;
163: --
164: -- ----------------------------------------------------------------------------
192: --
193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure update_dml
196: (p_rec in out nocopy ben_ptp_shd.g_rec_type,
197: p_effective_date in date,
198: p_datetrack_mode in varchar2,
199: p_validation_start_date in date,
200: p_validation_end_date in date) is
256: --
257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure dt_pre_update
260: (p_rec in out nocopy ben_ptp_shd.g_rec_type,
261: p_effective_date in date,
262: p_datetrack_mode in varchar2,
263: p_validation_start_date in date,
264: p_validation_end_date in date) is
272: hr_utility.set_location(l_proc, 10);
273: --
274: -- Update the current effective end date
275: --
276: ben_ptp_shd.upd_effective_end_date
277: (p_effective_date => p_effective_date,
278: p_base_key_value => p_rec.pl_typ_id,
279: p_new_effective_end_date => (p_validation_start_date - 1),
280: p_validation_start_date => p_validation_start_date,
341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure pre_update
345: (p_rec in out nocopy ben_ptp_shd.g_rec_type,
346: p_effective_date in date,
347: p_datetrack_mode in varchar2,
348: p_validation_start_date in date,
349: p_validation_end_date in date) is
397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure post_update
401: (p_rec in ben_ptp_shd.g_rec_type,
402: p_effective_date in date,
403: p_datetrack_mode in varchar2,
404: p_validation_start_date in date,
405: p_validation_end_date in date) is
422: -- Start of API User Hook for post_update.
423: --
424: begin
425: --Bug 3412944
426: if ben_ptp_shd.g_old_rec.opt_typ_cd <> p_rec.opt_typ_cd then
427: for rec_c1 in c1 loop
428: ben_plan_type_option_type_api.update_plan_type_option_type
429: ( p_pl_typ_opt_typ_id => rec_c1.pl_typ_opt_typ_id,
430: p_pl_typ_opt_typ_cd => p_rec.opt_typ_cd,
493: ,p_effective_date =>p_effective_date
494: ,p_datetrack_mode =>p_datetrack_mode
495: ,p_validation_start_date =>p_validation_start_date
496: ,p_validation_end_date =>p_validation_end_date
497: ,p_effective_start_date_o =>ben_ptp_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_ptp_shd.g_old_rec.effective_end_date
499: ,p_name_o =>ben_ptp_shd.g_old_rec.name
500: ,p_mx_enrl_alwd_num_o =>ben_ptp_shd.g_old_rec.mx_enrl_alwd_num
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
494: ,p_datetrack_mode =>p_datetrack_mode
495: ,p_validation_start_date =>p_validation_start_date
496: ,p_validation_end_date =>p_validation_end_date
497: ,p_effective_start_date_o =>ben_ptp_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_ptp_shd.g_old_rec.effective_end_date
499: ,p_name_o =>ben_ptp_shd.g_old_rec.name
500: ,p_mx_enrl_alwd_num_o =>ben_ptp_shd.g_old_rec.mx_enrl_alwd_num
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
495: ,p_validation_start_date =>p_validation_start_date
496: ,p_validation_end_date =>p_validation_end_date
497: ,p_effective_start_date_o =>ben_ptp_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_ptp_shd.g_old_rec.effective_end_date
499: ,p_name_o =>ben_ptp_shd.g_old_rec.name
500: ,p_mx_enrl_alwd_num_o =>ben_ptp_shd.g_old_rec.mx_enrl_alwd_num
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
496: ,p_validation_end_date =>p_validation_end_date
497: ,p_effective_start_date_o =>ben_ptp_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_ptp_shd.g_old_rec.effective_end_date
499: ,p_name_o =>ben_ptp_shd.g_old_rec.name
500: ,p_mx_enrl_alwd_num_o =>ben_ptp_shd.g_old_rec.mx_enrl_alwd_num
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
497: ,p_effective_start_date_o =>ben_ptp_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_ptp_shd.g_old_rec.effective_end_date
499: ,p_name_o =>ben_ptp_shd.g_old_rec.name
500: ,p_mx_enrl_alwd_num_o =>ben_ptp_shd.g_old_rec.mx_enrl_alwd_num
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
498: ,p_effective_end_date_o =>ben_ptp_shd.g_old_rec.effective_end_date
499: ,p_name_o =>ben_ptp_shd.g_old_rec.name
500: ,p_mx_enrl_alwd_num_o =>ben_ptp_shd.g_old_rec.mx_enrl_alwd_num
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
499: ,p_name_o =>ben_ptp_shd.g_old_rec.name
500: ,p_mx_enrl_alwd_num_o =>ben_ptp_shd.g_old_rec.mx_enrl_alwd_num
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
500: ,p_mx_enrl_alwd_num_o =>ben_ptp_shd.g_old_rec.mx_enrl_alwd_num
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
501: ,p_mn_enrl_rqd_num_o =>ben_ptp_shd.g_old_rec.mn_enrl_rqd_num
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
502: ,p_pl_typ_stat_cd_o =>ben_ptp_shd.g_old_rec.pl_typ_stat_cd
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
503: ,p_opt_typ_cd_o =>ben_ptp_shd.g_old_rec.opt_typ_cd
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
504: ,p_opt_dsply_fmt_cd_o =>ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
505: ,p_comp_typ_cd_o =>ben_ptp_shd.g_old_rec.comp_typ_cd
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
506: ,p_ivr_ident_o =>ben_ptp_shd.g_old_rec.ivr_ident
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
507: ,p_no_mx_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
508: ,p_no_mn_enrl_num_dfnd_flag_o =>ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
509: ,p_business_group_id_o =>ben_ptp_shd.g_old_rec.business_group_id
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
510: ,p_ptp_attribute_category_o =>ben_ptp_shd.g_old_rec.ptp_attribute_category
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
511: ,p_ptp_attribute1_o =>ben_ptp_shd.g_old_rec.ptp_attribute1
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
512: ,p_ptp_attribute2_o =>ben_ptp_shd.g_old_rec.ptp_attribute2
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
513: ,p_ptp_attribute3_o =>ben_ptp_shd.g_old_rec.ptp_attribute3
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
514: ,p_ptp_attribute4_o =>ben_ptp_shd.g_old_rec.ptp_attribute4
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
515: ,p_ptp_attribute5_o =>ben_ptp_shd.g_old_rec.ptp_attribute5
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
516: ,p_ptp_attribute6_o =>ben_ptp_shd.g_old_rec.ptp_attribute6
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
517: ,p_ptp_attribute7_o =>ben_ptp_shd.g_old_rec.ptp_attribute7
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
518: ,p_ptp_attribute8_o =>ben_ptp_shd.g_old_rec.ptp_attribute8
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
519: ,p_ptp_attribute9_o =>ben_ptp_shd.g_old_rec.ptp_attribute9
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
520: ,p_ptp_attribute10_o =>ben_ptp_shd.g_old_rec.ptp_attribute10
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
521: ,p_ptp_attribute11_o =>ben_ptp_shd.g_old_rec.ptp_attribute11
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
522: ,p_ptp_attribute12_o =>ben_ptp_shd.g_old_rec.ptp_attribute12
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
523: ,p_ptp_attribute13_o =>ben_ptp_shd.g_old_rec.ptp_attribute13
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
524: ,p_ptp_attribute14_o =>ben_ptp_shd.g_old_rec.ptp_attribute14
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
525: ,p_ptp_attribute15_o =>ben_ptp_shd.g_old_rec.ptp_attribute15
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
526: ,p_ptp_attribute16_o =>ben_ptp_shd.g_old_rec.ptp_attribute16
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
527: ,p_ptp_attribute17_o =>ben_ptp_shd.g_old_rec.ptp_attribute17
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
528: ,p_ptp_attribute18_o =>ben_ptp_shd.g_old_rec.ptp_attribute18
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
529: ,p_ptp_attribute19_o =>ben_ptp_shd.g_old_rec.ptp_attribute19
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
530: ,p_ptp_attribute20_o =>ben_ptp_shd.g_old_rec.ptp_attribute20
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
531: ,p_ptp_attribute21_o =>ben_ptp_shd.g_old_rec.ptp_attribute21
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
532: ,p_ptp_attribute22_o =>ben_ptp_shd.g_old_rec.ptp_attribute22
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
533: ,p_ptp_attribute23_o =>ben_ptp_shd.g_old_rec.ptp_attribute23
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
534: ,p_ptp_attribute24_o =>ben_ptp_shd.g_old_rec.ptp_attribute24
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
542: ,p_short_code_o =>ben_ptp_shd.g_old_rec.short_code --FHR
535: ,p_ptp_attribute25_o =>ben_ptp_shd.g_old_rec.ptp_attribute25
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
542: ,p_short_code_o =>ben_ptp_shd.g_old_rec.short_code --FHR
543: ,p_legislation_code_o =>ben_ptp_shd.g_old_rec.legislation_code
536: ,p_ptp_attribute26_o =>ben_ptp_shd.g_old_rec.ptp_attribute26
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
542: ,p_short_code_o =>ben_ptp_shd.g_old_rec.short_code --FHR
543: ,p_legislation_code_o =>ben_ptp_shd.g_old_rec.legislation_code
544: ,p_legislation_subgroup_o =>ben_ptp_shd.g_old_rec.legislation_subgroup
537: ,p_ptp_attribute27_o =>ben_ptp_shd.g_old_rec.ptp_attribute27
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
542: ,p_short_code_o =>ben_ptp_shd.g_old_rec.short_code --FHR
543: ,p_legislation_code_o =>ben_ptp_shd.g_old_rec.legislation_code
544: ,p_legislation_subgroup_o =>ben_ptp_shd.g_old_rec.legislation_subgroup
545: ,p_object_version_number_o =>ben_ptp_shd.g_old_rec.object_version_number
538: ,p_ptp_attribute28_o =>ben_ptp_shd.g_old_rec.ptp_attribute28
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
542: ,p_short_code_o =>ben_ptp_shd.g_old_rec.short_code --FHR
543: ,p_legislation_code_o =>ben_ptp_shd.g_old_rec.legislation_code
544: ,p_legislation_subgroup_o =>ben_ptp_shd.g_old_rec.legislation_subgroup
545: ,p_object_version_number_o =>ben_ptp_shd.g_old_rec.object_version_number
546: );
539: ,p_ptp_attribute29_o =>ben_ptp_shd.g_old_rec.ptp_attribute29
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
542: ,p_short_code_o =>ben_ptp_shd.g_old_rec.short_code --FHR
543: ,p_legislation_code_o =>ben_ptp_shd.g_old_rec.legislation_code
544: ,p_legislation_subgroup_o =>ben_ptp_shd.g_old_rec.legislation_subgroup
545: ,p_object_version_number_o =>ben_ptp_shd.g_old_rec.object_version_number
546: );
547: --
540: ,p_ptp_attribute30_o =>ben_ptp_shd.g_old_rec.ptp_attribute30
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
542: ,p_short_code_o =>ben_ptp_shd.g_old_rec.short_code --FHR
543: ,p_legislation_code_o =>ben_ptp_shd.g_old_rec.legislation_code
544: ,p_legislation_subgroup_o =>ben_ptp_shd.g_old_rec.legislation_subgroup
545: ,p_object_version_number_o =>ben_ptp_shd.g_old_rec.object_version_number
546: );
547: --
548: exception
541: ,p_short_name_o =>ben_ptp_shd.g_old_rec.short_name --FHR
542: ,p_short_code_o =>ben_ptp_shd.g_old_rec.short_code --FHR
543: ,p_legislation_code_o =>ben_ptp_shd.g_old_rec.legislation_code
544: ,p_legislation_subgroup_o =>ben_ptp_shd.g_old_rec.legislation_subgroup
545: ,p_object_version_number_o =>ben_ptp_shd.g_old_rec.object_version_number
546: );
547: --
548: exception
549: --
603: -- Internal Row Handler Use Only.
604: --
605: -- {End Of Comments}
606: -- ----------------------------------------------------------------------------
607: Procedure convert_defs(p_rec in out nocopy ben_ptp_shd.g_rec_type) is
608: --
609: l_proc varchar2(72) := g_package||'convert_defs';
610: --
611: Begin
618: -- is being used then we must set to the 'current' argument value.
619: --
620: If (p_rec.name = hr_api.g_varchar2) then
621: p_rec.name :=
622: ben_ptp_shd.g_old_rec.name;
623: End If;
624: If (p_rec.mx_enrl_alwd_num = hr_api.g_number) then
625: p_rec.mx_enrl_alwd_num :=
626: ben_ptp_shd.g_old_rec.mx_enrl_alwd_num;
622: ben_ptp_shd.g_old_rec.name;
623: End If;
624: If (p_rec.mx_enrl_alwd_num = hr_api.g_number) then
625: p_rec.mx_enrl_alwd_num :=
626: ben_ptp_shd.g_old_rec.mx_enrl_alwd_num;
627: End If;
628: If (p_rec.mn_enrl_rqd_num = hr_api.g_number) then
629: p_rec.mn_enrl_rqd_num :=
630: ben_ptp_shd.g_old_rec.mn_enrl_rqd_num;
626: ben_ptp_shd.g_old_rec.mx_enrl_alwd_num;
627: End If;
628: If (p_rec.mn_enrl_rqd_num = hr_api.g_number) then
629: p_rec.mn_enrl_rqd_num :=
630: ben_ptp_shd.g_old_rec.mn_enrl_rqd_num;
631: End If;
632: If (p_rec.pl_typ_stat_cd = hr_api.g_varchar2) then
633: p_rec.pl_typ_stat_cd :=
634: ben_ptp_shd.g_old_rec.pl_typ_stat_cd;
630: ben_ptp_shd.g_old_rec.mn_enrl_rqd_num;
631: End If;
632: If (p_rec.pl_typ_stat_cd = hr_api.g_varchar2) then
633: p_rec.pl_typ_stat_cd :=
634: ben_ptp_shd.g_old_rec.pl_typ_stat_cd;
635: End If;
636: If (p_rec.opt_typ_cd = hr_api.g_varchar2) then
637: p_rec.opt_typ_cd :=
638: ben_ptp_shd.g_old_rec.opt_typ_cd;
634: ben_ptp_shd.g_old_rec.pl_typ_stat_cd;
635: End If;
636: If (p_rec.opt_typ_cd = hr_api.g_varchar2) then
637: p_rec.opt_typ_cd :=
638: ben_ptp_shd.g_old_rec.opt_typ_cd;
639: End If;
640: If (p_rec.opt_dsply_fmt_cd = hr_api.g_varchar2) then
641: p_rec.opt_dsply_fmt_cd :=
642: ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd;
638: ben_ptp_shd.g_old_rec.opt_typ_cd;
639: End If;
640: If (p_rec.opt_dsply_fmt_cd = hr_api.g_varchar2) then
641: p_rec.opt_dsply_fmt_cd :=
642: ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd;
643: End If;
644: If (p_rec.comp_typ_cd = hr_api.g_varchar2) then
645: p_rec.comp_typ_cd :=
646: ben_ptp_shd.g_old_rec.comp_typ_cd;
642: ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd;
643: End If;
644: If (p_rec.comp_typ_cd = hr_api.g_varchar2) then
645: p_rec.comp_typ_cd :=
646: ben_ptp_shd.g_old_rec.comp_typ_cd;
647: End If;
648: If (p_rec.ivr_ident = hr_api.g_varchar2) then
649: p_rec.ivr_ident :=
650: ben_ptp_shd.g_old_rec.ivr_ident;
646: ben_ptp_shd.g_old_rec.comp_typ_cd;
647: End If;
648: If (p_rec.ivr_ident = hr_api.g_varchar2) then
649: p_rec.ivr_ident :=
650: ben_ptp_shd.g_old_rec.ivr_ident;
651: End If;
652: If (p_rec.no_mx_enrl_num_dfnd_flag = hr_api.g_varchar2) then
653: p_rec.no_mx_enrl_num_dfnd_flag :=
654: ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag;
650: ben_ptp_shd.g_old_rec.ivr_ident;
651: End If;
652: If (p_rec.no_mx_enrl_num_dfnd_flag = hr_api.g_varchar2) then
653: p_rec.no_mx_enrl_num_dfnd_flag :=
654: ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag;
655: End If;
656: If (p_rec.no_mn_enrl_num_dfnd_flag = hr_api.g_varchar2) then
657: p_rec.no_mn_enrl_num_dfnd_flag :=
658: ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag;
654: ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag;
655: End If;
656: If (p_rec.no_mn_enrl_num_dfnd_flag = hr_api.g_varchar2) then
657: p_rec.no_mn_enrl_num_dfnd_flag :=
658: ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag;
659: End If;
660: If (p_rec.business_group_id = hr_api.g_number) then
661: p_rec.business_group_id :=
662: ben_ptp_shd.g_old_rec.business_group_id;
658: ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag;
659: End If;
660: If (p_rec.business_group_id = hr_api.g_number) then
661: p_rec.business_group_id :=
662: ben_ptp_shd.g_old_rec.business_group_id;
663: End If;
664: If (p_rec.ptp_attribute_category = hr_api.g_varchar2) then
665: p_rec.ptp_attribute_category :=
666: ben_ptp_shd.g_old_rec.ptp_attribute_category;
662: ben_ptp_shd.g_old_rec.business_group_id;
663: End If;
664: If (p_rec.ptp_attribute_category = hr_api.g_varchar2) then
665: p_rec.ptp_attribute_category :=
666: ben_ptp_shd.g_old_rec.ptp_attribute_category;
667: End If;
668: If (p_rec.ptp_attribute1 = hr_api.g_varchar2) then
669: p_rec.ptp_attribute1 :=
670: ben_ptp_shd.g_old_rec.ptp_attribute1;
666: ben_ptp_shd.g_old_rec.ptp_attribute_category;
667: End If;
668: If (p_rec.ptp_attribute1 = hr_api.g_varchar2) then
669: p_rec.ptp_attribute1 :=
670: ben_ptp_shd.g_old_rec.ptp_attribute1;
671: End If;
672: If (p_rec.ptp_attribute2 = hr_api.g_varchar2) then
673: p_rec.ptp_attribute2 :=
674: ben_ptp_shd.g_old_rec.ptp_attribute2;
670: ben_ptp_shd.g_old_rec.ptp_attribute1;
671: End If;
672: If (p_rec.ptp_attribute2 = hr_api.g_varchar2) then
673: p_rec.ptp_attribute2 :=
674: ben_ptp_shd.g_old_rec.ptp_attribute2;
675: End If;
676: If (p_rec.ptp_attribute3 = hr_api.g_varchar2) then
677: p_rec.ptp_attribute3 :=
678: ben_ptp_shd.g_old_rec.ptp_attribute3;
674: ben_ptp_shd.g_old_rec.ptp_attribute2;
675: End If;
676: If (p_rec.ptp_attribute3 = hr_api.g_varchar2) then
677: p_rec.ptp_attribute3 :=
678: ben_ptp_shd.g_old_rec.ptp_attribute3;
679: End If;
680: If (p_rec.ptp_attribute4 = hr_api.g_varchar2) then
681: p_rec.ptp_attribute4 :=
682: ben_ptp_shd.g_old_rec.ptp_attribute4;
678: ben_ptp_shd.g_old_rec.ptp_attribute3;
679: End If;
680: If (p_rec.ptp_attribute4 = hr_api.g_varchar2) then
681: p_rec.ptp_attribute4 :=
682: ben_ptp_shd.g_old_rec.ptp_attribute4;
683: End If;
684: If (p_rec.ptp_attribute5 = hr_api.g_varchar2) then
685: p_rec.ptp_attribute5 :=
686: ben_ptp_shd.g_old_rec.ptp_attribute5;
682: ben_ptp_shd.g_old_rec.ptp_attribute4;
683: End If;
684: If (p_rec.ptp_attribute5 = hr_api.g_varchar2) then
685: p_rec.ptp_attribute5 :=
686: ben_ptp_shd.g_old_rec.ptp_attribute5;
687: End If;
688: If (p_rec.ptp_attribute6 = hr_api.g_varchar2) then
689: p_rec.ptp_attribute6 :=
690: ben_ptp_shd.g_old_rec.ptp_attribute6;
686: ben_ptp_shd.g_old_rec.ptp_attribute5;
687: End If;
688: If (p_rec.ptp_attribute6 = hr_api.g_varchar2) then
689: p_rec.ptp_attribute6 :=
690: ben_ptp_shd.g_old_rec.ptp_attribute6;
691: End If;
692: If (p_rec.ptp_attribute7 = hr_api.g_varchar2) then
693: p_rec.ptp_attribute7 :=
694: ben_ptp_shd.g_old_rec.ptp_attribute7;
690: ben_ptp_shd.g_old_rec.ptp_attribute6;
691: End If;
692: If (p_rec.ptp_attribute7 = hr_api.g_varchar2) then
693: p_rec.ptp_attribute7 :=
694: ben_ptp_shd.g_old_rec.ptp_attribute7;
695: End If;
696: If (p_rec.ptp_attribute8 = hr_api.g_varchar2) then
697: p_rec.ptp_attribute8 :=
698: ben_ptp_shd.g_old_rec.ptp_attribute8;
694: ben_ptp_shd.g_old_rec.ptp_attribute7;
695: End If;
696: If (p_rec.ptp_attribute8 = hr_api.g_varchar2) then
697: p_rec.ptp_attribute8 :=
698: ben_ptp_shd.g_old_rec.ptp_attribute8;
699: End If;
700: If (p_rec.ptp_attribute9 = hr_api.g_varchar2) then
701: p_rec.ptp_attribute9 :=
702: ben_ptp_shd.g_old_rec.ptp_attribute9;
698: ben_ptp_shd.g_old_rec.ptp_attribute8;
699: End If;
700: If (p_rec.ptp_attribute9 = hr_api.g_varchar2) then
701: p_rec.ptp_attribute9 :=
702: ben_ptp_shd.g_old_rec.ptp_attribute9;
703: End If;
704: If (p_rec.ptp_attribute10 = hr_api.g_varchar2) then
705: p_rec.ptp_attribute10 :=
706: ben_ptp_shd.g_old_rec.ptp_attribute10;
702: ben_ptp_shd.g_old_rec.ptp_attribute9;
703: End If;
704: If (p_rec.ptp_attribute10 = hr_api.g_varchar2) then
705: p_rec.ptp_attribute10 :=
706: ben_ptp_shd.g_old_rec.ptp_attribute10;
707: End If;
708: If (p_rec.ptp_attribute11 = hr_api.g_varchar2) then
709: p_rec.ptp_attribute11 :=
710: ben_ptp_shd.g_old_rec.ptp_attribute11;
706: ben_ptp_shd.g_old_rec.ptp_attribute10;
707: End If;
708: If (p_rec.ptp_attribute11 = hr_api.g_varchar2) then
709: p_rec.ptp_attribute11 :=
710: ben_ptp_shd.g_old_rec.ptp_attribute11;
711: End If;
712: If (p_rec.ptp_attribute12 = hr_api.g_varchar2) then
713: p_rec.ptp_attribute12 :=
714: ben_ptp_shd.g_old_rec.ptp_attribute12;
710: ben_ptp_shd.g_old_rec.ptp_attribute11;
711: End If;
712: If (p_rec.ptp_attribute12 = hr_api.g_varchar2) then
713: p_rec.ptp_attribute12 :=
714: ben_ptp_shd.g_old_rec.ptp_attribute12;
715: End If;
716: If (p_rec.ptp_attribute13 = hr_api.g_varchar2) then
717: p_rec.ptp_attribute13 :=
718: ben_ptp_shd.g_old_rec.ptp_attribute13;
714: ben_ptp_shd.g_old_rec.ptp_attribute12;
715: End If;
716: If (p_rec.ptp_attribute13 = hr_api.g_varchar2) then
717: p_rec.ptp_attribute13 :=
718: ben_ptp_shd.g_old_rec.ptp_attribute13;
719: End If;
720: If (p_rec.ptp_attribute14 = hr_api.g_varchar2) then
721: p_rec.ptp_attribute14 :=
722: ben_ptp_shd.g_old_rec.ptp_attribute14;
718: ben_ptp_shd.g_old_rec.ptp_attribute13;
719: End If;
720: If (p_rec.ptp_attribute14 = hr_api.g_varchar2) then
721: p_rec.ptp_attribute14 :=
722: ben_ptp_shd.g_old_rec.ptp_attribute14;
723: End If;
724: If (p_rec.ptp_attribute15 = hr_api.g_varchar2) then
725: p_rec.ptp_attribute15 :=
726: ben_ptp_shd.g_old_rec.ptp_attribute15;
722: ben_ptp_shd.g_old_rec.ptp_attribute14;
723: End If;
724: If (p_rec.ptp_attribute15 = hr_api.g_varchar2) then
725: p_rec.ptp_attribute15 :=
726: ben_ptp_shd.g_old_rec.ptp_attribute15;
727: End If;
728: If (p_rec.ptp_attribute16 = hr_api.g_varchar2) then
729: p_rec.ptp_attribute16 :=
730: ben_ptp_shd.g_old_rec.ptp_attribute16;
726: ben_ptp_shd.g_old_rec.ptp_attribute15;
727: End If;
728: If (p_rec.ptp_attribute16 = hr_api.g_varchar2) then
729: p_rec.ptp_attribute16 :=
730: ben_ptp_shd.g_old_rec.ptp_attribute16;
731: End If;
732: If (p_rec.ptp_attribute17 = hr_api.g_varchar2) then
733: p_rec.ptp_attribute17 :=
734: ben_ptp_shd.g_old_rec.ptp_attribute17;
730: ben_ptp_shd.g_old_rec.ptp_attribute16;
731: End If;
732: If (p_rec.ptp_attribute17 = hr_api.g_varchar2) then
733: p_rec.ptp_attribute17 :=
734: ben_ptp_shd.g_old_rec.ptp_attribute17;
735: End If;
736: If (p_rec.ptp_attribute18 = hr_api.g_varchar2) then
737: p_rec.ptp_attribute18 :=
738: ben_ptp_shd.g_old_rec.ptp_attribute18;
734: ben_ptp_shd.g_old_rec.ptp_attribute17;
735: End If;
736: If (p_rec.ptp_attribute18 = hr_api.g_varchar2) then
737: p_rec.ptp_attribute18 :=
738: ben_ptp_shd.g_old_rec.ptp_attribute18;
739: End If;
740: If (p_rec.ptp_attribute19 = hr_api.g_varchar2) then
741: p_rec.ptp_attribute19 :=
742: ben_ptp_shd.g_old_rec.ptp_attribute19;
738: ben_ptp_shd.g_old_rec.ptp_attribute18;
739: End If;
740: If (p_rec.ptp_attribute19 = hr_api.g_varchar2) then
741: p_rec.ptp_attribute19 :=
742: ben_ptp_shd.g_old_rec.ptp_attribute19;
743: End If;
744: If (p_rec.ptp_attribute20 = hr_api.g_varchar2) then
745: p_rec.ptp_attribute20 :=
746: ben_ptp_shd.g_old_rec.ptp_attribute20;
742: ben_ptp_shd.g_old_rec.ptp_attribute19;
743: End If;
744: If (p_rec.ptp_attribute20 = hr_api.g_varchar2) then
745: p_rec.ptp_attribute20 :=
746: ben_ptp_shd.g_old_rec.ptp_attribute20;
747: End If;
748: If (p_rec.ptp_attribute21 = hr_api.g_varchar2) then
749: p_rec.ptp_attribute21 :=
750: ben_ptp_shd.g_old_rec.ptp_attribute21;
746: ben_ptp_shd.g_old_rec.ptp_attribute20;
747: End If;
748: If (p_rec.ptp_attribute21 = hr_api.g_varchar2) then
749: p_rec.ptp_attribute21 :=
750: ben_ptp_shd.g_old_rec.ptp_attribute21;
751: End If;
752: If (p_rec.ptp_attribute22 = hr_api.g_varchar2) then
753: p_rec.ptp_attribute22 :=
754: ben_ptp_shd.g_old_rec.ptp_attribute22;
750: ben_ptp_shd.g_old_rec.ptp_attribute21;
751: End If;
752: If (p_rec.ptp_attribute22 = hr_api.g_varchar2) then
753: p_rec.ptp_attribute22 :=
754: ben_ptp_shd.g_old_rec.ptp_attribute22;
755: End If;
756: If (p_rec.ptp_attribute23 = hr_api.g_varchar2) then
757: p_rec.ptp_attribute23 :=
758: ben_ptp_shd.g_old_rec.ptp_attribute23;
754: ben_ptp_shd.g_old_rec.ptp_attribute22;
755: End If;
756: If (p_rec.ptp_attribute23 = hr_api.g_varchar2) then
757: p_rec.ptp_attribute23 :=
758: ben_ptp_shd.g_old_rec.ptp_attribute23;
759: End If;
760: If (p_rec.ptp_attribute24 = hr_api.g_varchar2) then
761: p_rec.ptp_attribute24 :=
762: ben_ptp_shd.g_old_rec.ptp_attribute24;
758: ben_ptp_shd.g_old_rec.ptp_attribute23;
759: End If;
760: If (p_rec.ptp_attribute24 = hr_api.g_varchar2) then
761: p_rec.ptp_attribute24 :=
762: ben_ptp_shd.g_old_rec.ptp_attribute24;
763: End If;
764: If (p_rec.ptp_attribute25 = hr_api.g_varchar2) then
765: p_rec.ptp_attribute25 :=
766: ben_ptp_shd.g_old_rec.ptp_attribute25;
762: ben_ptp_shd.g_old_rec.ptp_attribute24;
763: End If;
764: If (p_rec.ptp_attribute25 = hr_api.g_varchar2) then
765: p_rec.ptp_attribute25 :=
766: ben_ptp_shd.g_old_rec.ptp_attribute25;
767: End If;
768: If (p_rec.ptp_attribute26 = hr_api.g_varchar2) then
769: p_rec.ptp_attribute26 :=
770: ben_ptp_shd.g_old_rec.ptp_attribute26;
766: ben_ptp_shd.g_old_rec.ptp_attribute25;
767: End If;
768: If (p_rec.ptp_attribute26 = hr_api.g_varchar2) then
769: p_rec.ptp_attribute26 :=
770: ben_ptp_shd.g_old_rec.ptp_attribute26;
771: End If;
772: If (p_rec.ptp_attribute27 = hr_api.g_varchar2) then
773: p_rec.ptp_attribute27 :=
774: ben_ptp_shd.g_old_rec.ptp_attribute27;
770: ben_ptp_shd.g_old_rec.ptp_attribute26;
771: End If;
772: If (p_rec.ptp_attribute27 = hr_api.g_varchar2) then
773: p_rec.ptp_attribute27 :=
774: ben_ptp_shd.g_old_rec.ptp_attribute27;
775: End If;
776: If (p_rec.ptp_attribute28 = hr_api.g_varchar2) then
777: p_rec.ptp_attribute28 :=
778: ben_ptp_shd.g_old_rec.ptp_attribute28;
774: ben_ptp_shd.g_old_rec.ptp_attribute27;
775: End If;
776: If (p_rec.ptp_attribute28 = hr_api.g_varchar2) then
777: p_rec.ptp_attribute28 :=
778: ben_ptp_shd.g_old_rec.ptp_attribute28;
779: End If;
780: If (p_rec.ptp_attribute29 = hr_api.g_varchar2) then
781: p_rec.ptp_attribute29 :=
782: ben_ptp_shd.g_old_rec.ptp_attribute29;
778: ben_ptp_shd.g_old_rec.ptp_attribute28;
779: End If;
780: If (p_rec.ptp_attribute29 = hr_api.g_varchar2) then
781: p_rec.ptp_attribute29 :=
782: ben_ptp_shd.g_old_rec.ptp_attribute29;
783: End If;
784: If (p_rec.ptp_attribute30 = hr_api.g_varchar2) then
785: p_rec.ptp_attribute30 :=
786: ben_ptp_shd.g_old_rec.ptp_attribute30;
782: ben_ptp_shd.g_old_rec.ptp_attribute29;
783: End If;
784: If (p_rec.ptp_attribute30 = hr_api.g_varchar2) then
785: p_rec.ptp_attribute30 :=
786: ben_ptp_shd.g_old_rec.ptp_attribute30;
787: End If;
788: --FHR
789: If (p_rec.short_name = hr_api.g_varchar2) then
790: p_rec.short_name :=
787: End If;
788: --FHR
789: If (p_rec.short_name = hr_api.g_varchar2) then
790: p_rec.short_name :=
791: ben_ptp_shd.g_old_rec.short_name;
792: End If;
793: If (p_rec.short_code = hr_api.g_varchar2) then
794: p_rec.short_code :=
795: ben_ptp_shd.g_old_rec.short_code;
791: ben_ptp_shd.g_old_rec.short_name;
792: End If;
793: If (p_rec.short_code = hr_api.g_varchar2) then
794: p_rec.short_code :=
795: ben_ptp_shd.g_old_rec.short_code;
796: End If;
797:
798: If (p_rec.legislation_code = hr_api.g_varchar2) then
799: p_rec.legislation_code :=
796: End If;
797:
798: If (p_rec.legislation_code = hr_api.g_varchar2) then
799: p_rec.legislation_code :=
800: ben_ptp_shd.g_old_rec.legislation_code;
801: End If;
802:
803: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
804: p_rec.legislation_subgroup :=
801: End If;
802:
803: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
804: p_rec.legislation_subgroup :=
805: ben_ptp_shd.g_old_rec.legislation_subgroup;
806: End If;
807: --
808: hr_utility.set_location(' Leaving:'||l_proc, 10);
809: --
813: -- |---------------------------------< upd >----------------------------------|
814: -- ----------------------------------------------------------------------------
815: Procedure upd
816: (
817: p_rec in out nocopy ben_ptp_shd.g_rec_type,
818: p_effective_date in date,
819: p_datetrack_mode in varchar2
820: ) is
821: --
831: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
832: --
833: -- We must lock the row which we need to update.
834: --
835: ben_ptp_shd.lck
836: (p_effective_date => p_effective_date,
837: p_datetrack_mode => p_datetrack_mode,
838: p_pl_typ_id => p_rec.pl_typ_id,
839: p_object_version_number => p_rec.object_version_number,
940: p_effective_date in date,
941: p_datetrack_mode in varchar2
942: ) is
943: --
944: l_rec ben_ptp_shd.g_rec_type;
945: l_proc varchar2(72) := g_package||'upd';
946: --
947: Begin
948: hr_utility.set_location('Entering:'||l_proc, 5);
950: -- Call conversion function to turn arguments into the
951: -- l_rec structure.
952: --
953: l_rec :=
954: ben_ptp_shd.convert_args
955: (
956: p_pl_typ_id,
957: null,
958: null,