[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_crt_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_crt_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_crt_ordr Row
68: --
69: update ben_crt_ordr
121: qdro_per_perd_cd = p_rec.qdro_per_perd_cd,
122: pl_typ_id = p_rec.pl_typ_id
123: where crt_ordr_id = p_rec.crt_ordr_id;
124: --
125: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
133: ben_crt_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
133: ben_crt_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
133: ben_crt_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
138: ben_crt_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
138: ben_crt_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
138: ben_crt_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
143: ben_crt_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
143: ben_crt_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
142: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
143: ben_crt_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: End update_dml;
149: --
150: -- ----------------------------------------------------------------------------
178: -- Internal Row Handler Use Only.
179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure pre_update(p_rec in ben_crt_shd.g_rec_type) is
183: --
184: l_proc varchar2(72) := g_package||'pre_update';
185: --
186: Begin
220: -- Internal Row Handler Use Only.
221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure post_update( p_effective_date in date,p_rec in ben_crt_shd.g_rec_type) is
225: --
226: l_proc varchar2(72) := g_package||'post_update';
227: l_old_rec ben_crt_ler.g_crt_ler_rec ;
228: l_new_rec ben_crt_ler.g_crt_ler_rec ;
233: --
234: -- Start of API User Hook for post_update.
235: --
236: begin
237: l_old_rec.business_group_id := ben_crt_shd.g_old_rec.business_group_id;
238: l_old_rec.person_id := ben_crt_shd.g_old_rec.person_id;
239: l_old_rec.apls_perd_strtg_dt := ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
240: l_old_rec.apls_perd_endg_dt := ben_crt_shd.g_old_rec.apls_perd_endg_dt;
241: l_old_rec.crt_ordr_typ_cd := ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
234: -- Start of API User Hook for post_update.
235: --
236: begin
237: l_old_rec.business_group_id := ben_crt_shd.g_old_rec.business_group_id;
238: l_old_rec.person_id := ben_crt_shd.g_old_rec.person_id;
239: l_old_rec.apls_perd_strtg_dt := ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
240: l_old_rec.apls_perd_endg_dt := ben_crt_shd.g_old_rec.apls_perd_endg_dt;
241: l_old_rec.crt_ordr_typ_cd := ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
242: l_old_rec.rcvd_dt := ben_crt_shd.g_old_rec.rcvd_dt;
235: --
236: begin
237: l_old_rec.business_group_id := ben_crt_shd.g_old_rec.business_group_id;
238: l_old_rec.person_id := ben_crt_shd.g_old_rec.person_id;
239: l_old_rec.apls_perd_strtg_dt := ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
240: l_old_rec.apls_perd_endg_dt := ben_crt_shd.g_old_rec.apls_perd_endg_dt;
241: l_old_rec.crt_ordr_typ_cd := ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
242: l_old_rec.rcvd_dt := ben_crt_shd.g_old_rec.rcvd_dt;
243: l_old_rec.pl_id := ben_crt_shd.g_old_rec.pl_id;
236: begin
237: l_old_rec.business_group_id := ben_crt_shd.g_old_rec.business_group_id;
238: l_old_rec.person_id := ben_crt_shd.g_old_rec.person_id;
239: l_old_rec.apls_perd_strtg_dt := ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
240: l_old_rec.apls_perd_endg_dt := ben_crt_shd.g_old_rec.apls_perd_endg_dt;
241: l_old_rec.crt_ordr_typ_cd := ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
242: l_old_rec.rcvd_dt := ben_crt_shd.g_old_rec.rcvd_dt;
243: l_old_rec.pl_id := ben_crt_shd.g_old_rec.pl_id;
244: l_old_rec.pl_typ_id := ben_crt_shd.g_old_rec.pl_typ_id;
237: l_old_rec.business_group_id := ben_crt_shd.g_old_rec.business_group_id;
238: l_old_rec.person_id := ben_crt_shd.g_old_rec.person_id;
239: l_old_rec.apls_perd_strtg_dt := ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
240: l_old_rec.apls_perd_endg_dt := ben_crt_shd.g_old_rec.apls_perd_endg_dt;
241: l_old_rec.crt_ordr_typ_cd := ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
242: l_old_rec.rcvd_dt := ben_crt_shd.g_old_rec.rcvd_dt;
243: l_old_rec.pl_id := ben_crt_shd.g_old_rec.pl_id;
244: l_old_rec.pl_typ_id := ben_crt_shd.g_old_rec.pl_typ_id;
245: l_new_rec.business_group_id := p_rec.business_group_id;
238: l_old_rec.person_id := ben_crt_shd.g_old_rec.person_id;
239: l_old_rec.apls_perd_strtg_dt := ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
240: l_old_rec.apls_perd_endg_dt := ben_crt_shd.g_old_rec.apls_perd_endg_dt;
241: l_old_rec.crt_ordr_typ_cd := ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
242: l_old_rec.rcvd_dt := ben_crt_shd.g_old_rec.rcvd_dt;
243: l_old_rec.pl_id := ben_crt_shd.g_old_rec.pl_id;
244: l_old_rec.pl_typ_id := ben_crt_shd.g_old_rec.pl_typ_id;
245: l_new_rec.business_group_id := p_rec.business_group_id;
246: l_new_rec.person_id := p_rec.person_id;
239: l_old_rec.apls_perd_strtg_dt := ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
240: l_old_rec.apls_perd_endg_dt := ben_crt_shd.g_old_rec.apls_perd_endg_dt;
241: l_old_rec.crt_ordr_typ_cd := ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
242: l_old_rec.rcvd_dt := ben_crt_shd.g_old_rec.rcvd_dt;
243: l_old_rec.pl_id := ben_crt_shd.g_old_rec.pl_id;
244: l_old_rec.pl_typ_id := ben_crt_shd.g_old_rec.pl_typ_id;
245: l_new_rec.business_group_id := p_rec.business_group_id;
246: l_new_rec.person_id := p_rec.person_id;
247: l_new_rec.apls_perd_strtg_dt:= p_rec.apls_perd_strtg_dt;
240: l_old_rec.apls_perd_endg_dt := ben_crt_shd.g_old_rec.apls_perd_endg_dt;
241: l_old_rec.crt_ordr_typ_cd := ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
242: l_old_rec.rcvd_dt := ben_crt_shd.g_old_rec.rcvd_dt;
243: l_old_rec.pl_id := ben_crt_shd.g_old_rec.pl_id;
244: l_old_rec.pl_typ_id := ben_crt_shd.g_old_rec.pl_typ_id;
245: l_new_rec.business_group_id := p_rec.business_group_id;
246: l_new_rec.person_id := p_rec.person_id;
247: l_new_rec.apls_perd_strtg_dt:= p_rec.apls_perd_strtg_dt;
248: l_new_rec.apls_perd_endg_dt := p_rec.apls_perd_endg_dt;
306: ,p_qdro_num_pymt_val =>p_rec.qdro_num_pymt_val
307: ,p_qdro_per_perd_cd =>p_rec.qdro_per_perd_cd
308: ,p_pl_typ_id =>p_rec.pl_typ_id
309: ,p_effective_date =>p_effective_date
310: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
311: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
312: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
313: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
307: ,p_qdro_per_perd_cd =>p_rec.qdro_per_perd_cd
308: ,p_pl_typ_id =>p_rec.pl_typ_id
309: ,p_effective_date =>p_effective_date
310: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
311: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
312: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
313: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
308: ,p_pl_typ_id =>p_rec.pl_typ_id
309: ,p_effective_date =>p_effective_date
310: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
311: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
312: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
313: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
309: ,p_effective_date =>p_effective_date
310: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
311: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
312: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
313: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
310: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
311: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
312: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
313: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
311: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
312: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
313: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
312: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
313: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
313: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
314: ,p_description_o =>ben_crt_shd.g_old_rec.description
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
315: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
316: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
317: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
318: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
319: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
320: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
321: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
322: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
323: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
324: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
325: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
326: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
327: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
328: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
329: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
330: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
331: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
332: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
333: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
334: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
335: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
336: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
337: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
338: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
339: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
340: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
341: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
342: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
343: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
344: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
345: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
346: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
347: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
348: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
349: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
357: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
350: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
357: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
358: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
351: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
357: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
358: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
359: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
352: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
357: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
358: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
359: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
360: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
353: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
357: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
358: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
359: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
360: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
361: );
354: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
357: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
358: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
359: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
360: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
361: );
362: --
355: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
357: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
358: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
359: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
360: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
361: );
362: --
363: hr_utility.set_location('D M Modie crt ' ||hr_general.g_data_migrator_mode , 378);
356: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
357: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
358: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
359: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
360: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
361: );
362: --
363: hr_utility.set_location('D M Modie crt ' ||hr_general.g_data_migrator_mode , 378);
364: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
426: -- Internal Row Handler Use Only.
427: --
428: -- {End Of Comments}
429: -- ----------------------------------------------------------------------------
430: Procedure convert_defs(p_rec in out nocopy ben_crt_shd.g_rec_type) is
431: --
432: l_proc varchar2(72) := g_package||'convert_defs';
433: --
434: Begin
441: -- is being used then we must set to the 'current' argument value.
442: --
443: If (p_rec.crt_ordr_typ_cd = hr_api.g_varchar2) then
444: p_rec.crt_ordr_typ_cd :=
445: ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
446: End If;
447: If (p_rec.apls_perd_endg_dt = hr_api.g_date) then
448: p_rec.apls_perd_endg_dt :=
449: ben_crt_shd.g_old_rec.apls_perd_endg_dt;
445: ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
446: End If;
447: If (p_rec.apls_perd_endg_dt = hr_api.g_date) then
448: p_rec.apls_perd_endg_dt :=
449: ben_crt_shd.g_old_rec.apls_perd_endg_dt;
450: End If;
451: If (p_rec.apls_perd_strtg_dt = hr_api.g_date) then
452: p_rec.apls_perd_strtg_dt :=
453: ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
449: ben_crt_shd.g_old_rec.apls_perd_endg_dt;
450: End If;
451: If (p_rec.apls_perd_strtg_dt = hr_api.g_date) then
452: p_rec.apls_perd_strtg_dt :=
453: ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
454: End If;
455: If (p_rec.crt_ident = hr_api.g_varchar2) then
456: p_rec.crt_ident :=
457: ben_crt_shd.g_old_rec.crt_ident;
453: ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
454: End If;
455: If (p_rec.crt_ident = hr_api.g_varchar2) then
456: p_rec.crt_ident :=
457: ben_crt_shd.g_old_rec.crt_ident;
458: End If;
459: If (p_rec.description = hr_api.g_varchar2) then
460: p_rec.description :=
461: ben_crt_shd.g_old_rec.description;
457: ben_crt_shd.g_old_rec.crt_ident;
458: End If;
459: If (p_rec.description = hr_api.g_varchar2) then
460: p_rec.description :=
461: ben_crt_shd.g_old_rec.description;
462: End If;
463: If (p_rec.detd_qlfd_ordr_dt = hr_api.g_date) then
464: p_rec.detd_qlfd_ordr_dt :=
465: ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt;
461: ben_crt_shd.g_old_rec.description;
462: End If;
463: If (p_rec.detd_qlfd_ordr_dt = hr_api.g_date) then
464: p_rec.detd_qlfd_ordr_dt :=
465: ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt;
466: End If;
467: If (p_rec.issue_dt = hr_api.g_date) then
468: p_rec.issue_dt :=
469: ben_crt_shd.g_old_rec.issue_dt;
465: ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt;
466: End If;
467: If (p_rec.issue_dt = hr_api.g_date) then
468: p_rec.issue_dt :=
469: ben_crt_shd.g_old_rec.issue_dt;
470: End If;
471: If (p_rec.qdro_amt = hr_api.g_number) then
472: p_rec.qdro_amt :=
473: ben_crt_shd.g_old_rec.qdro_amt;
469: ben_crt_shd.g_old_rec.issue_dt;
470: End If;
471: If (p_rec.qdro_amt = hr_api.g_number) then
472: p_rec.qdro_amt :=
473: ben_crt_shd.g_old_rec.qdro_amt;
474: End If;
475: If (p_rec.qdro_dstr_mthd_cd = hr_api.g_varchar2) then
476: p_rec.qdro_dstr_mthd_cd :=
477: ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd;
473: ben_crt_shd.g_old_rec.qdro_amt;
474: End If;
475: If (p_rec.qdro_dstr_mthd_cd = hr_api.g_varchar2) then
476: p_rec.qdro_dstr_mthd_cd :=
477: ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd;
478: End If;
479: If (p_rec.qdro_pct = hr_api.g_number) then
480: p_rec.qdro_pct :=
481: ben_crt_shd.g_old_rec.qdro_pct;
477: ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd;
478: End If;
479: If (p_rec.qdro_pct = hr_api.g_number) then
480: p_rec.qdro_pct :=
481: ben_crt_shd.g_old_rec.qdro_pct;
482: End If;
483: If (p_rec.rcvd_dt = hr_api.g_date) then
484: p_rec.rcvd_dt :=
485: ben_crt_shd.g_old_rec.rcvd_dt;
481: ben_crt_shd.g_old_rec.qdro_pct;
482: End If;
483: If (p_rec.rcvd_dt = hr_api.g_date) then
484: p_rec.rcvd_dt :=
485: ben_crt_shd.g_old_rec.rcvd_dt;
486: End If;
487: If (p_rec.uom = hr_api.g_varchar2) then
488: p_rec.uom :=
489: ben_crt_shd.g_old_rec.uom;
485: ben_crt_shd.g_old_rec.rcvd_dt;
486: End If;
487: If (p_rec.uom = hr_api.g_varchar2) then
488: p_rec.uom :=
489: ben_crt_shd.g_old_rec.uom;
490: End If;
491: If (p_rec.crt_issng = hr_api.g_varchar2) then
492: p_rec.crt_issng :=
493: ben_crt_shd.g_old_rec.crt_issng;
489: ben_crt_shd.g_old_rec.uom;
490: End If;
491: If (p_rec.crt_issng = hr_api.g_varchar2) then
492: p_rec.crt_issng :=
493: ben_crt_shd.g_old_rec.crt_issng;
494: End If;
495: If (p_rec.pl_id = hr_api.g_number) then
496: p_rec.pl_id :=
497: ben_crt_shd.g_old_rec.pl_id;
493: ben_crt_shd.g_old_rec.crt_issng;
494: End If;
495: If (p_rec.pl_id = hr_api.g_number) then
496: p_rec.pl_id :=
497: ben_crt_shd.g_old_rec.pl_id;
498: End If;
499: If (p_rec.person_id = hr_api.g_number) then
500: p_rec.person_id :=
501: ben_crt_shd.g_old_rec.person_id;
497: ben_crt_shd.g_old_rec.pl_id;
498: End If;
499: If (p_rec.person_id = hr_api.g_number) then
500: p_rec.person_id :=
501: ben_crt_shd.g_old_rec.person_id;
502: End If;
503: If (p_rec.business_group_id = hr_api.g_number) then
504: p_rec.business_group_id :=
505: ben_crt_shd.g_old_rec.business_group_id;
501: ben_crt_shd.g_old_rec.person_id;
502: End If;
503: If (p_rec.business_group_id = hr_api.g_number) then
504: p_rec.business_group_id :=
505: ben_crt_shd.g_old_rec.business_group_id;
506: End If;
507: If (p_rec.crt_attribute_category = hr_api.g_varchar2) then
508: p_rec.crt_attribute_category :=
509: ben_crt_shd.g_old_rec.crt_attribute_category;
505: ben_crt_shd.g_old_rec.business_group_id;
506: End If;
507: If (p_rec.crt_attribute_category = hr_api.g_varchar2) then
508: p_rec.crt_attribute_category :=
509: ben_crt_shd.g_old_rec.crt_attribute_category;
510: End If;
511: If (p_rec.crt_attribute1 = hr_api.g_varchar2) then
512: p_rec.crt_attribute1 :=
513: ben_crt_shd.g_old_rec.crt_attribute1;
509: ben_crt_shd.g_old_rec.crt_attribute_category;
510: End If;
511: If (p_rec.crt_attribute1 = hr_api.g_varchar2) then
512: p_rec.crt_attribute1 :=
513: ben_crt_shd.g_old_rec.crt_attribute1;
514: End If;
515: If (p_rec.crt_attribute2 = hr_api.g_varchar2) then
516: p_rec.crt_attribute2 :=
517: ben_crt_shd.g_old_rec.crt_attribute2;
513: ben_crt_shd.g_old_rec.crt_attribute1;
514: End If;
515: If (p_rec.crt_attribute2 = hr_api.g_varchar2) then
516: p_rec.crt_attribute2 :=
517: ben_crt_shd.g_old_rec.crt_attribute2;
518: End If;
519: If (p_rec.crt_attribute3 = hr_api.g_varchar2) then
520: p_rec.crt_attribute3 :=
521: ben_crt_shd.g_old_rec.crt_attribute3;
517: ben_crt_shd.g_old_rec.crt_attribute2;
518: End If;
519: If (p_rec.crt_attribute3 = hr_api.g_varchar2) then
520: p_rec.crt_attribute3 :=
521: ben_crt_shd.g_old_rec.crt_attribute3;
522: End If;
523: If (p_rec.crt_attribute4 = hr_api.g_varchar2) then
524: p_rec.crt_attribute4 :=
525: ben_crt_shd.g_old_rec.crt_attribute4;
521: ben_crt_shd.g_old_rec.crt_attribute3;
522: End If;
523: If (p_rec.crt_attribute4 = hr_api.g_varchar2) then
524: p_rec.crt_attribute4 :=
525: ben_crt_shd.g_old_rec.crt_attribute4;
526: End If;
527: If (p_rec.crt_attribute5 = hr_api.g_varchar2) then
528: p_rec.crt_attribute5 :=
529: ben_crt_shd.g_old_rec.crt_attribute5;
525: ben_crt_shd.g_old_rec.crt_attribute4;
526: End If;
527: If (p_rec.crt_attribute5 = hr_api.g_varchar2) then
528: p_rec.crt_attribute5 :=
529: ben_crt_shd.g_old_rec.crt_attribute5;
530: End If;
531: If (p_rec.crt_attribute6 = hr_api.g_varchar2) then
532: p_rec.crt_attribute6 :=
533: ben_crt_shd.g_old_rec.crt_attribute6;
529: ben_crt_shd.g_old_rec.crt_attribute5;
530: End If;
531: If (p_rec.crt_attribute6 = hr_api.g_varchar2) then
532: p_rec.crt_attribute6 :=
533: ben_crt_shd.g_old_rec.crt_attribute6;
534: End If;
535: If (p_rec.crt_attribute7 = hr_api.g_varchar2) then
536: p_rec.crt_attribute7 :=
537: ben_crt_shd.g_old_rec.crt_attribute7;
533: ben_crt_shd.g_old_rec.crt_attribute6;
534: End If;
535: If (p_rec.crt_attribute7 = hr_api.g_varchar2) then
536: p_rec.crt_attribute7 :=
537: ben_crt_shd.g_old_rec.crt_attribute7;
538: End If;
539: If (p_rec.crt_attribute8 = hr_api.g_varchar2) then
540: p_rec.crt_attribute8 :=
541: ben_crt_shd.g_old_rec.crt_attribute8;
537: ben_crt_shd.g_old_rec.crt_attribute7;
538: End If;
539: If (p_rec.crt_attribute8 = hr_api.g_varchar2) then
540: p_rec.crt_attribute8 :=
541: ben_crt_shd.g_old_rec.crt_attribute8;
542: End If;
543: If (p_rec.crt_attribute9 = hr_api.g_varchar2) then
544: p_rec.crt_attribute9 :=
545: ben_crt_shd.g_old_rec.crt_attribute9;
541: ben_crt_shd.g_old_rec.crt_attribute8;
542: End If;
543: If (p_rec.crt_attribute9 = hr_api.g_varchar2) then
544: p_rec.crt_attribute9 :=
545: ben_crt_shd.g_old_rec.crt_attribute9;
546: End If;
547: If (p_rec.crt_attribute10 = hr_api.g_varchar2) then
548: p_rec.crt_attribute10 :=
549: ben_crt_shd.g_old_rec.crt_attribute10;
545: ben_crt_shd.g_old_rec.crt_attribute9;
546: End If;
547: If (p_rec.crt_attribute10 = hr_api.g_varchar2) then
548: p_rec.crt_attribute10 :=
549: ben_crt_shd.g_old_rec.crt_attribute10;
550: End If;
551: If (p_rec.crt_attribute11 = hr_api.g_varchar2) then
552: p_rec.crt_attribute11 :=
553: ben_crt_shd.g_old_rec.crt_attribute11;
549: ben_crt_shd.g_old_rec.crt_attribute10;
550: End If;
551: If (p_rec.crt_attribute11 = hr_api.g_varchar2) then
552: p_rec.crt_attribute11 :=
553: ben_crt_shd.g_old_rec.crt_attribute11;
554: End If;
555: If (p_rec.crt_attribute12 = hr_api.g_varchar2) then
556: p_rec.crt_attribute12 :=
557: ben_crt_shd.g_old_rec.crt_attribute12;
553: ben_crt_shd.g_old_rec.crt_attribute11;
554: End If;
555: If (p_rec.crt_attribute12 = hr_api.g_varchar2) then
556: p_rec.crt_attribute12 :=
557: ben_crt_shd.g_old_rec.crt_attribute12;
558: End If;
559: If (p_rec.crt_attribute13 = hr_api.g_varchar2) then
560: p_rec.crt_attribute13 :=
561: ben_crt_shd.g_old_rec.crt_attribute13;
557: ben_crt_shd.g_old_rec.crt_attribute12;
558: End If;
559: If (p_rec.crt_attribute13 = hr_api.g_varchar2) then
560: p_rec.crt_attribute13 :=
561: ben_crt_shd.g_old_rec.crt_attribute13;
562: End If;
563: If (p_rec.crt_attribute14 = hr_api.g_varchar2) then
564: p_rec.crt_attribute14 :=
565: ben_crt_shd.g_old_rec.crt_attribute14;
561: ben_crt_shd.g_old_rec.crt_attribute13;
562: End If;
563: If (p_rec.crt_attribute14 = hr_api.g_varchar2) then
564: p_rec.crt_attribute14 :=
565: ben_crt_shd.g_old_rec.crt_attribute14;
566: End If;
567: If (p_rec.crt_attribute15 = hr_api.g_varchar2) then
568: p_rec.crt_attribute15 :=
569: ben_crt_shd.g_old_rec.crt_attribute15;
565: ben_crt_shd.g_old_rec.crt_attribute14;
566: End If;
567: If (p_rec.crt_attribute15 = hr_api.g_varchar2) then
568: p_rec.crt_attribute15 :=
569: ben_crt_shd.g_old_rec.crt_attribute15;
570: End If;
571: If (p_rec.crt_attribute16 = hr_api.g_varchar2) then
572: p_rec.crt_attribute16 :=
573: ben_crt_shd.g_old_rec.crt_attribute16;
569: ben_crt_shd.g_old_rec.crt_attribute15;
570: End If;
571: If (p_rec.crt_attribute16 = hr_api.g_varchar2) then
572: p_rec.crt_attribute16 :=
573: ben_crt_shd.g_old_rec.crt_attribute16;
574: End If;
575: If (p_rec.crt_attribute17 = hr_api.g_varchar2) then
576: p_rec.crt_attribute17 :=
577: ben_crt_shd.g_old_rec.crt_attribute17;
573: ben_crt_shd.g_old_rec.crt_attribute16;
574: End If;
575: If (p_rec.crt_attribute17 = hr_api.g_varchar2) then
576: p_rec.crt_attribute17 :=
577: ben_crt_shd.g_old_rec.crt_attribute17;
578: End If;
579: If (p_rec.crt_attribute18 = hr_api.g_varchar2) then
580: p_rec.crt_attribute18 :=
581: ben_crt_shd.g_old_rec.crt_attribute18;
577: ben_crt_shd.g_old_rec.crt_attribute17;
578: End If;
579: If (p_rec.crt_attribute18 = hr_api.g_varchar2) then
580: p_rec.crt_attribute18 :=
581: ben_crt_shd.g_old_rec.crt_attribute18;
582: End If;
583: If (p_rec.crt_attribute19 = hr_api.g_varchar2) then
584: p_rec.crt_attribute19 :=
585: ben_crt_shd.g_old_rec.crt_attribute19;
581: ben_crt_shd.g_old_rec.crt_attribute18;
582: End If;
583: If (p_rec.crt_attribute19 = hr_api.g_varchar2) then
584: p_rec.crt_attribute19 :=
585: ben_crt_shd.g_old_rec.crt_attribute19;
586: End If;
587: If (p_rec.crt_attribute20 = hr_api.g_varchar2) then
588: p_rec.crt_attribute20 :=
589: ben_crt_shd.g_old_rec.crt_attribute20;
585: ben_crt_shd.g_old_rec.crt_attribute19;
586: End If;
587: If (p_rec.crt_attribute20 = hr_api.g_varchar2) then
588: p_rec.crt_attribute20 :=
589: ben_crt_shd.g_old_rec.crt_attribute20;
590: End If;
591: If (p_rec.crt_attribute21 = hr_api.g_varchar2) then
592: p_rec.crt_attribute21 :=
593: ben_crt_shd.g_old_rec.crt_attribute21;
589: ben_crt_shd.g_old_rec.crt_attribute20;
590: End If;
591: If (p_rec.crt_attribute21 = hr_api.g_varchar2) then
592: p_rec.crt_attribute21 :=
593: ben_crt_shd.g_old_rec.crt_attribute21;
594: End If;
595: If (p_rec.crt_attribute22 = hr_api.g_varchar2) then
596: p_rec.crt_attribute22 :=
597: ben_crt_shd.g_old_rec.crt_attribute22;
593: ben_crt_shd.g_old_rec.crt_attribute21;
594: End If;
595: If (p_rec.crt_attribute22 = hr_api.g_varchar2) then
596: p_rec.crt_attribute22 :=
597: ben_crt_shd.g_old_rec.crt_attribute22;
598: End If;
599: If (p_rec.crt_attribute23 = hr_api.g_varchar2) then
600: p_rec.crt_attribute23 :=
601: ben_crt_shd.g_old_rec.crt_attribute23;
597: ben_crt_shd.g_old_rec.crt_attribute22;
598: End If;
599: If (p_rec.crt_attribute23 = hr_api.g_varchar2) then
600: p_rec.crt_attribute23 :=
601: ben_crt_shd.g_old_rec.crt_attribute23;
602: End If;
603: If (p_rec.crt_attribute24 = hr_api.g_varchar2) then
604: p_rec.crt_attribute24 :=
605: ben_crt_shd.g_old_rec.crt_attribute24;
601: ben_crt_shd.g_old_rec.crt_attribute23;
602: End If;
603: If (p_rec.crt_attribute24 = hr_api.g_varchar2) then
604: p_rec.crt_attribute24 :=
605: ben_crt_shd.g_old_rec.crt_attribute24;
606: End If;
607: If (p_rec.crt_attribute25 = hr_api.g_varchar2) then
608: p_rec.crt_attribute25 :=
609: ben_crt_shd.g_old_rec.crt_attribute25;
605: ben_crt_shd.g_old_rec.crt_attribute24;
606: End If;
607: If (p_rec.crt_attribute25 = hr_api.g_varchar2) then
608: p_rec.crt_attribute25 :=
609: ben_crt_shd.g_old_rec.crt_attribute25;
610: End If;
611: If (p_rec.crt_attribute26 = hr_api.g_varchar2) then
612: p_rec.crt_attribute26 :=
613: ben_crt_shd.g_old_rec.crt_attribute26;
609: ben_crt_shd.g_old_rec.crt_attribute25;
610: End If;
611: If (p_rec.crt_attribute26 = hr_api.g_varchar2) then
612: p_rec.crt_attribute26 :=
613: ben_crt_shd.g_old_rec.crt_attribute26;
614: End If;
615: If (p_rec.crt_attribute27 = hr_api.g_varchar2) then
616: p_rec.crt_attribute27 :=
617: ben_crt_shd.g_old_rec.crt_attribute27;
613: ben_crt_shd.g_old_rec.crt_attribute26;
614: End If;
615: If (p_rec.crt_attribute27 = hr_api.g_varchar2) then
616: p_rec.crt_attribute27 :=
617: ben_crt_shd.g_old_rec.crt_attribute27;
618: End If;
619: If (p_rec.crt_attribute28 = hr_api.g_varchar2) then
620: p_rec.crt_attribute28 :=
621: ben_crt_shd.g_old_rec.crt_attribute28;
617: ben_crt_shd.g_old_rec.crt_attribute27;
618: End If;
619: If (p_rec.crt_attribute28 = hr_api.g_varchar2) then
620: p_rec.crt_attribute28 :=
621: ben_crt_shd.g_old_rec.crt_attribute28;
622: End If;
623: If (p_rec.crt_attribute29 = hr_api.g_varchar2) then
624: p_rec.crt_attribute29 :=
625: ben_crt_shd.g_old_rec.crt_attribute29;
621: ben_crt_shd.g_old_rec.crt_attribute28;
622: End If;
623: If (p_rec.crt_attribute29 = hr_api.g_varchar2) then
624: p_rec.crt_attribute29 :=
625: ben_crt_shd.g_old_rec.crt_attribute29;
626: End If;
627: If (p_rec.crt_attribute30 = hr_api.g_varchar2) then
628: p_rec.crt_attribute30 :=
629: ben_crt_shd.g_old_rec.crt_attribute30;
625: ben_crt_shd.g_old_rec.crt_attribute29;
626: End If;
627: If (p_rec.crt_attribute30 = hr_api.g_varchar2) then
628: p_rec.crt_attribute30 :=
629: ben_crt_shd.g_old_rec.crt_attribute30;
630: End If;
631: If (p_rec.qdro_num_pymt_val = hr_api.g_number) then
632: p_rec.qdro_num_pymt_val :=
633: ben_crt_shd.g_old_rec.qdro_num_pymt_val;
629: ben_crt_shd.g_old_rec.crt_attribute30;
630: End If;
631: If (p_rec.qdro_num_pymt_val = hr_api.g_number) then
632: p_rec.qdro_num_pymt_val :=
633: ben_crt_shd.g_old_rec.qdro_num_pymt_val;
634: End If;
635: If (p_rec.qdro_per_perd_cd = hr_api.g_varchar2) then
636: p_rec.qdro_per_perd_cd :=
637: ben_crt_shd.g_old_rec.qdro_per_perd_cd;
633: ben_crt_shd.g_old_rec.qdro_num_pymt_val;
634: End If;
635: If (p_rec.qdro_per_perd_cd = hr_api.g_varchar2) then
636: p_rec.qdro_per_perd_cd :=
637: ben_crt_shd.g_old_rec.qdro_per_perd_cd;
638: End If;
639: If (p_rec.pl_typ_id = hr_api.g_number) then
640: p_rec.pl_typ_id :=
641: ben_crt_shd.g_old_rec.pl_typ_id;
637: ben_crt_shd.g_old_rec.qdro_per_perd_cd;
638: End If;
639: If (p_rec.pl_typ_id = hr_api.g_number) then
640: p_rec.pl_typ_id :=
641: ben_crt_shd.g_old_rec.pl_typ_id;
642: End If;
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: --
650: -- ----------------------------------------------------------------------------
651: Procedure upd
652: (
653: p_effective_date in date,
654: p_rec in out nocopy ben_crt_shd.g_rec_type
655: ) is
656: --
657: l_proc varchar2(72) := g_package||'upd';
658: --
660: hr_utility.set_location('Entering:'||l_proc, 5);
661: --
662: -- We must lock the row which we need to update.
663: ---
664: ben_crt_shd.lck
665: (
666: p_rec.crt_ordr_id,
667: p_rec.object_version_number
668: );
753: p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2,
754: p_pl_typ_id in number default hr_api.g_number
755: ) is
756: --
757: l_rec ben_crt_shd.g_rec_type;
758: l_proc varchar2(72) := g_package||'upd';
759: --
760: Begin
761: hr_utility.set_location('Entering:'||l_proc, 5);
763: -- Call conversion function to turn arguments into the
764: -- l_rec structure.
765: --
766: l_rec :=
767: ben_crt_shd.convert_args
768: (
769: p_crt_ordr_id,
770: p_crt_ordr_typ_cd,
771: p_apls_perd_endg_dt,