eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CQB_DEL dependencies on BEN_CQB_SHD

Line 51: Procedure delete_dml(p_rec in ben_cqb_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_cqb_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ben_cqb_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_cqb_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_cbr_quald_bnf row.
61: --
62: delete from ben_cbr_quald_bnf

Line 65: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status

61: --
62: delete from ben_cbr_quald_bnf
63: where cbr_quald_bnf_id = p_rec.cbr_quald_bnf_id;
64: --
65: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

Line 72: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cqb_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_cqb_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cqb_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

Line 76: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status

72: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cqb_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ben_cqb_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_cqb_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 155: p_effective_date in date,p_rec in ben_cqb_shd.g_rec_type) is

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_cqb_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: ,p_quald_bnf_flag_o =>ben_cqb_shd.g_old_rec.quald_bnf_flag

166: --
167: ben_cqb_rkd.after_delete
168: (
169: p_cbr_quald_bnf_id =>p_rec.cbr_quald_bnf_id
170: ,p_quald_bnf_flag_o =>ben_cqb_shd.g_old_rec.quald_bnf_flag
171: ,p_cbr_elig_perd_strt_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt
172: ,p_cbr_elig_perd_end_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt
173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id
174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id

Line 171: ,p_cbr_elig_perd_strt_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt

167: ben_cqb_rkd.after_delete
168: (
169: p_cbr_quald_bnf_id =>p_rec.cbr_quald_bnf_id
170: ,p_quald_bnf_flag_o =>ben_cqb_shd.g_old_rec.quald_bnf_flag
171: ,p_cbr_elig_perd_strt_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt
172: ,p_cbr_elig_perd_end_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt
173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id
174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id
175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id

Line 172: ,p_cbr_elig_perd_end_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt

168: (
169: p_cbr_quald_bnf_id =>p_rec.cbr_quald_bnf_id
170: ,p_quald_bnf_flag_o =>ben_cqb_shd.g_old_rec.quald_bnf_flag
171: ,p_cbr_elig_perd_strt_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt
172: ,p_cbr_elig_perd_end_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt
173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id
174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id
175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id
176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id

Line 173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id

169: p_cbr_quald_bnf_id =>p_rec.cbr_quald_bnf_id
170: ,p_quald_bnf_flag_o =>ben_cqb_shd.g_old_rec.quald_bnf_flag
171: ,p_cbr_elig_perd_strt_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt
172: ,p_cbr_elig_perd_end_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt
173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id
174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id
175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id
176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id
177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id

Line 174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id

170: ,p_quald_bnf_flag_o =>ben_cqb_shd.g_old_rec.quald_bnf_flag
171: ,p_cbr_elig_perd_strt_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt
172: ,p_cbr_elig_perd_end_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt
173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id
174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id
175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id
176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id
177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id
178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd

Line 175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id

171: ,p_cbr_elig_perd_strt_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt
172: ,p_cbr_elig_perd_end_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt
173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id
174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id
175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id
176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id
177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id
178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd
179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id

Line 176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id

172: ,p_cbr_elig_perd_end_dt_o =>ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt
173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id
174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id
175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id
176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id
177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id
178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd
179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id
180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category

Line 177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id

173: ,p_quald_bnf_person_id_o =>ben_cqb_shd.g_old_rec.quald_bnf_person_id
174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id
175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id
176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id
177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id
178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd
179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id
180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category
181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1

Line 178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd

174: ,p_pgm_id_o =>ben_cqb_shd.g_old_rec.pgm_id
175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id
176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id
177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id
178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd
179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id
180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category
181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1
182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2

Line 179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id

175: ,p_ptip_id_o =>ben_cqb_shd.g_old_rec.ptip_id
176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id
177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id
178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd
179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id
180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category
181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1
182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2
183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3

Line 180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category

176: ,p_pl_typ_id_o =>ben_cqb_shd.g_old_rec.pl_typ_id
177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id
178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd
179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id
180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category
181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1
182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2
183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3
184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4

Line 181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1

177: ,p_cvrd_emp_person_id_o =>ben_cqb_shd.g_old_rec.cvrd_emp_person_id
178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd
179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id
180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category
181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1
182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2
183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3
184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4
185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5

Line 182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2

178: ,p_cbr_inelg_rsn_cd_o =>ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd
179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id
180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category
181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1
182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2
183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3
184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4
185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5
186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6

Line 183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3

179: ,p_business_group_id_o =>ben_cqb_shd.g_old_rec.business_group_id
180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category
181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1
182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2
183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3
184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4
185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5
186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6
187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7

Line 184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4

180: ,p_cqb_attribute_category_o =>ben_cqb_shd.g_old_rec.cqb_attribute_category
181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1
182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2
183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3
184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4
185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5
186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6
187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7
188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8

Line 185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5

181: ,p_cqb_attribute1_o =>ben_cqb_shd.g_old_rec.cqb_attribute1
182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2
183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3
184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4
185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5
186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6
187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7
188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8
189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9

Line 186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6

182: ,p_cqb_attribute2_o =>ben_cqb_shd.g_old_rec.cqb_attribute2
183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3
184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4
185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5
186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6
187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7
188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8
189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9
190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10

Line 187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7

183: ,p_cqb_attribute3_o =>ben_cqb_shd.g_old_rec.cqb_attribute3
184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4
185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5
186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6
187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7
188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8
189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9
190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10
191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11

Line 188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8

184: ,p_cqb_attribute4_o =>ben_cqb_shd.g_old_rec.cqb_attribute4
185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5
186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6
187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7
188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8
189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9
190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10
191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11
192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12

Line 189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9

185: ,p_cqb_attribute5_o =>ben_cqb_shd.g_old_rec.cqb_attribute5
186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6
187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7
188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8
189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9
190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10
191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11
192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12
193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13

Line 190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10

186: ,p_cqb_attribute6_o =>ben_cqb_shd.g_old_rec.cqb_attribute6
187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7
188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8
189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9
190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10
191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11
192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12
193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13
194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14

Line 191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11

187: ,p_cqb_attribute7_o =>ben_cqb_shd.g_old_rec.cqb_attribute7
188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8
189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9
190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10
191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11
192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12
193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13
194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14
195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15

Line 192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12

188: ,p_cqb_attribute8_o =>ben_cqb_shd.g_old_rec.cqb_attribute8
189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9
190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10
191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11
192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12
193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13
194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14
195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15
196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16

Line 193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13

189: ,p_cqb_attribute9_o =>ben_cqb_shd.g_old_rec.cqb_attribute9
190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10
191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11
192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12
193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13
194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14
195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15
196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16
197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17

Line 194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14

190: ,p_cqb_attribute10_o =>ben_cqb_shd.g_old_rec.cqb_attribute10
191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11
192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12
193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13
194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14
195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15
196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16
197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17
198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18

Line 195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15

191: ,p_cqb_attribute11_o =>ben_cqb_shd.g_old_rec.cqb_attribute11
192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12
193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13
194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14
195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15
196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16
197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17
198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18
199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19

Line 196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16

192: ,p_cqb_attribute12_o =>ben_cqb_shd.g_old_rec.cqb_attribute12
193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13
194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14
195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15
196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16
197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17
198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18
199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19
200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20

Line 197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17

193: ,p_cqb_attribute13_o =>ben_cqb_shd.g_old_rec.cqb_attribute13
194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14
195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15
196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16
197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17
198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18
199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19
200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20
201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21

Line 198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18

194: ,p_cqb_attribute14_o =>ben_cqb_shd.g_old_rec.cqb_attribute14
195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15
196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16
197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17
198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18
199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19
200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20
201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21
202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22

Line 199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19

195: ,p_cqb_attribute15_o =>ben_cqb_shd.g_old_rec.cqb_attribute15
196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16
197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17
198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18
199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19
200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20
201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21
202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22
203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23

Line 200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20

196: ,p_cqb_attribute16_o =>ben_cqb_shd.g_old_rec.cqb_attribute16
197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17
198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18
199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19
200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20
201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21
202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22
203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23
204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24

Line 201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21

197: ,p_cqb_attribute17_o =>ben_cqb_shd.g_old_rec.cqb_attribute17
198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18
199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19
200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20
201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21
202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22
203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23
204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24
205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25

Line 202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22

198: ,p_cqb_attribute18_o =>ben_cqb_shd.g_old_rec.cqb_attribute18
199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19
200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20
201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21
202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22
203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23
204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24
205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25
206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26

Line 203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23

199: ,p_cqb_attribute19_o =>ben_cqb_shd.g_old_rec.cqb_attribute19
200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20
201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21
202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22
203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23
204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24
205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25
206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26
207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27

Line 204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24

200: ,p_cqb_attribute20_o =>ben_cqb_shd.g_old_rec.cqb_attribute20
201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21
202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22
203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23
204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24
205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25
206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26
207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27
208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28

Line 205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25

201: ,p_cqb_attribute21_o =>ben_cqb_shd.g_old_rec.cqb_attribute21
202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22
203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23
204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24
205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25
206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26
207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27
208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28
209: ,p_cqb_attribute29_o =>ben_cqb_shd.g_old_rec.cqb_attribute29

Line 206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26

202: ,p_cqb_attribute22_o =>ben_cqb_shd.g_old_rec.cqb_attribute22
203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23
204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24
205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25
206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26
207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27
208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28
209: ,p_cqb_attribute29_o =>ben_cqb_shd.g_old_rec.cqb_attribute29
210: ,p_cqb_attribute30_o =>ben_cqb_shd.g_old_rec.cqb_attribute30

Line 207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27

203: ,p_cqb_attribute23_o =>ben_cqb_shd.g_old_rec.cqb_attribute23
204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24
205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25
206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26
207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27
208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28
209: ,p_cqb_attribute29_o =>ben_cqb_shd.g_old_rec.cqb_attribute29
210: ,p_cqb_attribute30_o =>ben_cqb_shd.g_old_rec.cqb_attribute30
211: ,p_object_version_number_o =>ben_cqb_shd.g_old_rec.object_version_number

Line 208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28

204: ,p_cqb_attribute24_o =>ben_cqb_shd.g_old_rec.cqb_attribute24
205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25
206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26
207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27
208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28
209: ,p_cqb_attribute29_o =>ben_cqb_shd.g_old_rec.cqb_attribute29
210: ,p_cqb_attribute30_o =>ben_cqb_shd.g_old_rec.cqb_attribute30
211: ,p_object_version_number_o =>ben_cqb_shd.g_old_rec.object_version_number
212: );

Line 209: ,p_cqb_attribute29_o =>ben_cqb_shd.g_old_rec.cqb_attribute29

205: ,p_cqb_attribute25_o =>ben_cqb_shd.g_old_rec.cqb_attribute25
206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26
207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27
208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28
209: ,p_cqb_attribute29_o =>ben_cqb_shd.g_old_rec.cqb_attribute29
210: ,p_cqb_attribute30_o =>ben_cqb_shd.g_old_rec.cqb_attribute30
211: ,p_object_version_number_o =>ben_cqb_shd.g_old_rec.object_version_number
212: );
213: --

Line 210: ,p_cqb_attribute30_o =>ben_cqb_shd.g_old_rec.cqb_attribute30

206: ,p_cqb_attribute26_o =>ben_cqb_shd.g_old_rec.cqb_attribute26
207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27
208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28
209: ,p_cqb_attribute29_o =>ben_cqb_shd.g_old_rec.cqb_attribute29
210: ,p_cqb_attribute30_o =>ben_cqb_shd.g_old_rec.cqb_attribute30
211: ,p_object_version_number_o =>ben_cqb_shd.g_old_rec.object_version_number
212: );
213: --
214: exception

Line 211: ,p_object_version_number_o =>ben_cqb_shd.g_old_rec.object_version_number

207: ,p_cqb_attribute27_o =>ben_cqb_shd.g_old_rec.cqb_attribute27
208: ,p_cqb_attribute28_o =>ben_cqb_shd.g_old_rec.cqb_attribute28
209: ,p_cqb_attribute29_o =>ben_cqb_shd.g_old_rec.cqb_attribute29
210: ,p_cqb_attribute30_o =>ben_cqb_shd.g_old_rec.cqb_attribute30
211: ,p_object_version_number_o =>ben_cqb_shd.g_old_rec.object_version_number
212: );
213: --
214: exception
215: --

Line 236: p_rec in ben_cqb_shd.g_rec_type

232: -- ----------------------------------------------------------------------------
233: Procedure del
234: (
235: p_effective_date in date,
236: p_rec in ben_cqb_shd.g_rec_type
237: ) is
238: --
239: l_proc varchar2(72) := g_package||'del';
240: --

Line 246: ben_cqb_shd.lck

242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: -- We must lock the row which we need to delete.
245: --
246: ben_cqb_shd.lck
247: (
248: p_rec.cbr_quald_bnf_id,
249: p_rec.object_version_number
250: );

Line 281: l_rec ben_cqb_shd.g_rec_type;

277: p_cbr_quald_bnf_id in number,
278: p_object_version_number in number
279: ) is
280: --
281: l_rec ben_cqb_shd.g_rec_type;
282: l_proc varchar2(72) := g_package||'del';
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);