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_CPY_DEL dependencies on BEN_CPY_SHD

Line 51: Procedure delete_dml(p_rec in ben_cpy_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_cpy_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ben_cpy_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_cpy_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_popl_yr_perd row.
61: --
62: delete from ben_popl_yr_perd

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

61: --
62: delete from ben_popl_yr_perd
63: where popl_yr_perd_id = p_rec.popl_yr_perd_id;
64: --
65: ben_cpy_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_cpy_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_cpy_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cpy_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cpy_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_cpy_shd.constraint_error

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

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

72: ben_cpy_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cpy_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cpy_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_cpy_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_cpy_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in ben_cpy_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in ben_cpy_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

Line 169: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id

165: --
166: ben_cpy_rkd.after_delete
167: (
168: p_popl_yr_perd_id =>p_rec.popl_yr_perd_id
169: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
170: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
171: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num

Line 170: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id

166: ben_cpy_rkd.after_delete
167: (
168: p_popl_yr_perd_id =>p_rec.popl_yr_perd_id
169: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
170: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
171: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt

Line 171: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id

167: (
168: p_popl_yr_perd_id =>p_rec.popl_yr_perd_id
169: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
170: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
171: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt

Line 172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id

168: p_popl_yr_perd_id =>p_rec.popl_yr_perd_id
169: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
170: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
171: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category

Line 173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num

169: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
170: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
171: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1

Line 174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt

170: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
171: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2

Line 175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt

171: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3

Line 176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category

172: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4

Line 177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1

173: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5

Line 178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2

174: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6

Line 179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3

175: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7

Line 180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4

176: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8

Line 181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5

177: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9

Line 182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6

178: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10

Line 183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7

179: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11

Line 184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8

180: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12

Line 185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9

181: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13

Line 186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10

182: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14

Line 187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11

183: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15

Line 188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12

184: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16

Line 189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13

185: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17

Line 190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14

186: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18

Line 191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15

187: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19

Line 192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16

188: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20

Line 193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17

189: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21

Line 194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18

190: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22

Line 195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19

191: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23

Line 196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20

192: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24

Line 197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21

193: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25

Line 198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22

194: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26

Line 199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23

195: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27

Line 200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24

196: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28

Line 201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25

197: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
205: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29

Line 202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26

198: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
205: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
206: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30

Line 203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27

199: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
205: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
206: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
207: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number

Line 204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28

200: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
205: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
206: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
207: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number
208: );

Line 205: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29

201: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
205: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
206: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
207: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number
208: );
209: --

Line 206: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30

202: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
205: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
206: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
207: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number
208: );
209: --
210: exception

Line 207: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number

203: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
204: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
205: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
206: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
207: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number
208: );
209: --
210: exception
211: --

Line 231: p_rec in ben_cpy_shd.g_rec_type

227: -- |---------------------------------< del >----------------------------------|
228: -- ----------------------------------------------------------------------------
229: Procedure del
230: (
231: p_rec in ben_cpy_shd.g_rec_type
232: ) is
233: --
234: l_proc varchar2(72) := g_package||'del';
235: --

Line 241: ben_cpy_shd.lck

237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: -- We must lock the row which we need to delete.
240: --
241: ben_cpy_shd.lck
242: (
243: p_rec.popl_yr_perd_id,
244: p_rec.object_version_number
245: );

Line 273: l_rec ben_cpy_shd.g_rec_type;

269: p_popl_yr_perd_id in number,
270: p_object_version_number in number
271: ) is
272: --
273: l_rec ben_cpy_shd.g_rec_type;
274: l_proc varchar2(72) := g_package||'del';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);