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_RVC_DEL dependencies on BEN_RVC_SHD

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

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

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

61: --
62: delete from ben_prtt_rt_val_ctfn_prvdd
63: where prtt_rt_val_ctfn_prvdd_id = p_rec.prtt_rt_val_ctfn_prvdd_id;
64: --
65: ben_rvc_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_rvc_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_rvc_shd.g_api_dml := false; -- Unset the api dml status
73: ben_rvc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_rvc_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_rvc_shd.constraint_error

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

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

72: ben_rvc_shd.g_api_dml := false; -- Unset the api dml status
73: ben_rvc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_rvc_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_rvc_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_rvc_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_rvc_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_rvc_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: ,p_enrt_ctfn_typ_cd_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_typ_cd

166: --
167: ben_rvc_rkd.after_delete
168: (
169: p_prtt_rt_val_ctfn_prvdd_id =>p_rec.prtt_rt_val_ctfn_prvdd_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_enrt_ctfn_rqd_flag_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag
172: ,p_enrt_ctfn_recd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_recd_dt
173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt
174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id

Line 171: ,p_enrt_ctfn_rqd_flag_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag

167: ben_rvc_rkd.after_delete
168: (
169: p_prtt_rt_val_ctfn_prvdd_id =>p_rec.prtt_rt_val_ctfn_prvdd_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_enrt_ctfn_rqd_flag_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag
172: ,p_enrt_ctfn_recd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_recd_dt
173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt
174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id
175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id

Line 172: ,p_enrt_ctfn_recd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_recd_dt

168: (
169: p_prtt_rt_val_ctfn_prvdd_id =>p_rec.prtt_rt_val_ctfn_prvdd_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_enrt_ctfn_rqd_flag_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag
172: ,p_enrt_ctfn_recd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_recd_dt
173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt
174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id
175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id
176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category

Line 173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt

169: p_prtt_rt_val_ctfn_prvdd_id =>p_rec.prtt_rt_val_ctfn_prvdd_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_enrt_ctfn_rqd_flag_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag
172: ,p_enrt_ctfn_recd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_recd_dt
173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt
174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id
175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id
176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category
177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1

Line 174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id

170: ,p_enrt_ctfn_typ_cd_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_enrt_ctfn_rqd_flag_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag
172: ,p_enrt_ctfn_recd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_recd_dt
173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt
174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id
175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id
176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category
177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1
178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2

Line 175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id

171: ,p_enrt_ctfn_rqd_flag_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag
172: ,p_enrt_ctfn_recd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_recd_dt
173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt
174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id
175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id
176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category
177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1
178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2
179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3

Line 176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category

172: ,p_enrt_ctfn_recd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_recd_dt
173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt
174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id
175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id
176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category
177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1
178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2
179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3
180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4

Line 177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1

173: ,p_enrt_ctfn_dnd_dt_o =>ben_rvc_shd.g_old_rec.enrt_ctfn_dnd_dt
174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id
175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id
176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category
177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1
178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2
179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3
180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4
181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5

Line 178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2

174: ,p_prtt_rt_val_id_o =>ben_rvc_shd.g_old_rec.prtt_rt_val_id
175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id
176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category
177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1
178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2
179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3
180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4
181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5
182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6

Line 179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3

175: ,p_business_group_id_o =>ben_rvc_shd.g_old_rec.business_group_id
176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category
177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1
178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2
179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3
180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4
181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5
182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6
183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7

Line 180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4

176: ,p_rvc_attribute_category_o =>ben_rvc_shd.g_old_rec.rvc_attribute_category
177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1
178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2
179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3
180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4
181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5
182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6
183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7
184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8

Line 181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5

177: ,p_rvc_attribute1_o =>ben_rvc_shd.g_old_rec.rvc_attribute1
178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2
179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3
180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4
181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5
182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6
183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7
184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8
185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9

Line 182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6

178: ,p_rvc_attribute2_o =>ben_rvc_shd.g_old_rec.rvc_attribute2
179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3
180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4
181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5
182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6
183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7
184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8
185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9
186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10

Line 183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7

179: ,p_rvc_attribute3_o =>ben_rvc_shd.g_old_rec.rvc_attribute3
180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4
181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5
182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6
183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7
184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8
185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9
186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10
187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11

Line 184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8

180: ,p_rvc_attribute4_o =>ben_rvc_shd.g_old_rec.rvc_attribute4
181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5
182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6
183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7
184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8
185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9
186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10
187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11
188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12

Line 185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9

181: ,p_rvc_attribute5_o =>ben_rvc_shd.g_old_rec.rvc_attribute5
182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6
183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7
184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8
185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9
186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10
187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11
188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12
189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13

Line 186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10

182: ,p_rvc_attribute6_o =>ben_rvc_shd.g_old_rec.rvc_attribute6
183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7
184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8
185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9
186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10
187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11
188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12
189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13
190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14

Line 187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11

183: ,p_rvc_attribute7_o =>ben_rvc_shd.g_old_rec.rvc_attribute7
184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8
185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9
186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10
187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11
188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12
189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13
190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14
191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15

Line 188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12

184: ,p_rvc_attribute8_o =>ben_rvc_shd.g_old_rec.rvc_attribute8
185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9
186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10
187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11
188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12
189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13
190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14
191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15
192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16

Line 189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13

185: ,p_rvc_attribute9_o =>ben_rvc_shd.g_old_rec.rvc_attribute9
186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10
187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11
188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12
189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13
190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14
191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15
192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16
193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17

Line 190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14

186: ,p_rvc_attribute10_o =>ben_rvc_shd.g_old_rec.rvc_attribute10
187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11
188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12
189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13
190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14
191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15
192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16
193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17
194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18

Line 191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15

187: ,p_rvc_attribute11_o =>ben_rvc_shd.g_old_rec.rvc_attribute11
188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12
189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13
190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14
191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15
192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16
193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17
194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18
195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19

Line 192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16

188: ,p_rvc_attribute12_o =>ben_rvc_shd.g_old_rec.rvc_attribute12
189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13
190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14
191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15
192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16
193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17
194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18
195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19
196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20

Line 193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17

189: ,p_rvc_attribute13_o =>ben_rvc_shd.g_old_rec.rvc_attribute13
190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14
191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15
192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16
193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17
194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18
195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19
196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20
197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21

Line 194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18

190: ,p_rvc_attribute14_o =>ben_rvc_shd.g_old_rec.rvc_attribute14
191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15
192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16
193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17
194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18
195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19
196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20
197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21
198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22

Line 195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19

191: ,p_rvc_attribute15_o =>ben_rvc_shd.g_old_rec.rvc_attribute15
192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16
193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17
194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18
195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19
196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20
197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21
198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22
199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23

Line 196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20

192: ,p_rvc_attribute16_o =>ben_rvc_shd.g_old_rec.rvc_attribute16
193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17
194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18
195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19
196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20
197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21
198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22
199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23
200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24

Line 197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21

193: ,p_rvc_attribute17_o =>ben_rvc_shd.g_old_rec.rvc_attribute17
194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18
195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19
196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20
197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21
198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22
199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23
200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24
201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25

Line 198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22

194: ,p_rvc_attribute18_o =>ben_rvc_shd.g_old_rec.rvc_attribute18
195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19
196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20
197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21
198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22
199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23
200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24
201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25
202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26

Line 199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23

195: ,p_rvc_attribute19_o =>ben_rvc_shd.g_old_rec.rvc_attribute19
196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20
197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21
198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22
199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23
200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24
201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25
202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26
203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27

Line 200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24

196: ,p_rvc_attribute20_o =>ben_rvc_shd.g_old_rec.rvc_attribute20
197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21
198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22
199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23
200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24
201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25
202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26
203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27
204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28

Line 201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25

197: ,p_rvc_attribute21_o =>ben_rvc_shd.g_old_rec.rvc_attribute21
198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22
199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23
200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24
201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25
202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26
203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27
204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28
205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29

Line 202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26

198: ,p_rvc_attribute22_o =>ben_rvc_shd.g_old_rec.rvc_attribute22
199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23
200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24
201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25
202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26
203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27
204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28
205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29
206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30

Line 203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27

199: ,p_rvc_attribute23_o =>ben_rvc_shd.g_old_rec.rvc_attribute23
200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24
201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25
202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26
203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27
204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28
205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29
206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30
207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id

Line 204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28

200: ,p_rvc_attribute24_o =>ben_rvc_shd.g_old_rec.rvc_attribute24
201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25
202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26
203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27
204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28
205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29
206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30
207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id

Line 205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29

201: ,p_rvc_attribute25_o =>ben_rvc_shd.g_old_rec.rvc_attribute25
202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26
203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27
204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28
205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29
206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30
207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_rvc_shd.g_old_rec.program_id

Line 206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30

202: ,p_rvc_attribute26_o =>ben_rvc_shd.g_old_rec.rvc_attribute26
203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27
204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28
205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29
206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30
207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_rvc_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_rvc_shd.g_old_rec.program_update_date

Line 207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id

203: ,p_rvc_attribute27_o =>ben_rvc_shd.g_old_rec.rvc_attribute27
204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28
205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29
206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30
207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_rvc_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_rvc_shd.g_old_rec.program_update_date
211: ,p_object_version_number_o =>ben_rvc_shd.g_old_rec.object_version_number

Line 208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id

204: ,p_rvc_attribute28_o =>ben_rvc_shd.g_old_rec.rvc_attribute28
205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29
206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30
207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_rvc_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_rvc_shd.g_old_rec.program_update_date
211: ,p_object_version_number_o =>ben_rvc_shd.g_old_rec.object_version_number
212: );

Line 209: ,p_program_id_o =>ben_rvc_shd.g_old_rec.program_id

205: ,p_rvc_attribute29_o =>ben_rvc_shd.g_old_rec.rvc_attribute29
206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30
207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_rvc_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_rvc_shd.g_old_rec.program_update_date
211: ,p_object_version_number_o =>ben_rvc_shd.g_old_rec.object_version_number
212: );
213: --

Line 210: ,p_program_update_date_o =>ben_rvc_shd.g_old_rec.program_update_date

206: ,p_rvc_attribute30_o =>ben_rvc_shd.g_old_rec.rvc_attribute30
207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_rvc_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_rvc_shd.g_old_rec.program_update_date
211: ,p_object_version_number_o =>ben_rvc_shd.g_old_rec.object_version_number
212: );
213: --
214: exception

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

207: ,p_request_id_o =>ben_rvc_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_rvc_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_rvc_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_rvc_shd.g_old_rec.program_update_date
211: ,p_object_version_number_o =>ben_rvc_shd.g_old_rec.object_version_number
212: );
213: --
214: exception
215: --

Line 236: p_rec in ben_rvc_shd.g_rec_type

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

Line 246: ben_rvc_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_rvc_shd.lck
247: (
248: p_rec.prtt_rt_val_ctfn_prvdd_id,
249: p_rec.object_version_number
250: );

Line 281: l_rec ben_rvc_shd.g_rec_type;

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