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_DSQ_DEL dependencies on BEN_DSQ_SHD

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

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

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

61: --
62: delete from ben_ded_sched_py_freq
63: where ded_sched_py_freq_id = p_rec.ded_sched_py_freq_id;
64: --
65: ben_dsq_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_dsq_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_dsq_shd.g_api_dml := false; -- Unset the api dml status
73: ben_dsq_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_dsq_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_dsq_shd.constraint_error

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

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

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

Line 170: ,p_py_freq_cd_o =>ben_dsq_shd.g_old_rec.py_freq_cd

166: --
167: ben_dsq_rkd.after_delete
168: (
169: p_ded_sched_py_freq_id =>p_rec.ded_sched_py_freq_id
170: ,p_py_freq_cd_o =>ben_dsq_shd.g_old_rec.py_freq_cd
171: ,p_dflt_flag_o =>ben_dsq_shd.g_old_rec.dflt_flag
172: ,p_acty_rt_ded_sched_id_o =>ben_dsq_shd.g_old_rec.acty_rt_ded_sched_id
173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id
174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category

Line 171: ,p_dflt_flag_o =>ben_dsq_shd.g_old_rec.dflt_flag

167: ben_dsq_rkd.after_delete
168: (
169: p_ded_sched_py_freq_id =>p_rec.ded_sched_py_freq_id
170: ,p_py_freq_cd_o =>ben_dsq_shd.g_old_rec.py_freq_cd
171: ,p_dflt_flag_o =>ben_dsq_shd.g_old_rec.dflt_flag
172: ,p_acty_rt_ded_sched_id_o =>ben_dsq_shd.g_old_rec.acty_rt_ded_sched_id
173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id
174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category
175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1

Line 172: ,p_acty_rt_ded_sched_id_o =>ben_dsq_shd.g_old_rec.acty_rt_ded_sched_id

168: (
169: p_ded_sched_py_freq_id =>p_rec.ded_sched_py_freq_id
170: ,p_py_freq_cd_o =>ben_dsq_shd.g_old_rec.py_freq_cd
171: ,p_dflt_flag_o =>ben_dsq_shd.g_old_rec.dflt_flag
172: ,p_acty_rt_ded_sched_id_o =>ben_dsq_shd.g_old_rec.acty_rt_ded_sched_id
173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id
174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category
175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1
176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2

Line 173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id

169: p_ded_sched_py_freq_id =>p_rec.ded_sched_py_freq_id
170: ,p_py_freq_cd_o =>ben_dsq_shd.g_old_rec.py_freq_cd
171: ,p_dflt_flag_o =>ben_dsq_shd.g_old_rec.dflt_flag
172: ,p_acty_rt_ded_sched_id_o =>ben_dsq_shd.g_old_rec.acty_rt_ded_sched_id
173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id
174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category
175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1
176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2
177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3

Line 174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category

170: ,p_py_freq_cd_o =>ben_dsq_shd.g_old_rec.py_freq_cd
171: ,p_dflt_flag_o =>ben_dsq_shd.g_old_rec.dflt_flag
172: ,p_acty_rt_ded_sched_id_o =>ben_dsq_shd.g_old_rec.acty_rt_ded_sched_id
173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id
174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category
175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1
176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2
177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3
178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4

Line 175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1

171: ,p_dflt_flag_o =>ben_dsq_shd.g_old_rec.dflt_flag
172: ,p_acty_rt_ded_sched_id_o =>ben_dsq_shd.g_old_rec.acty_rt_ded_sched_id
173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id
174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category
175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1
176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2
177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3
178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4
179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5

Line 176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2

172: ,p_acty_rt_ded_sched_id_o =>ben_dsq_shd.g_old_rec.acty_rt_ded_sched_id
173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id
174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category
175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1
176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2
177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3
178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4
179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5
180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6

Line 177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3

173: ,p_business_group_id_o =>ben_dsq_shd.g_old_rec.business_group_id
174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category
175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1
176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2
177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3
178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4
179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5
180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6
181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7

Line 178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4

174: ,p_dsq_attribute_category_o =>ben_dsq_shd.g_old_rec.dsq_attribute_category
175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1
176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2
177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3
178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4
179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5
180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6
181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7
182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8

Line 179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5

175: ,p_dsq_attribute1_o =>ben_dsq_shd.g_old_rec.dsq_attribute1
176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2
177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3
178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4
179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5
180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6
181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7
182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8
183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9

Line 180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6

176: ,p_dsq_attribute2_o =>ben_dsq_shd.g_old_rec.dsq_attribute2
177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3
178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4
179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5
180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6
181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7
182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8
183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9
184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10

Line 181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7

177: ,p_dsq_attribute3_o =>ben_dsq_shd.g_old_rec.dsq_attribute3
178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4
179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5
180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6
181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7
182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8
183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9
184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10
185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11

Line 182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8

178: ,p_dsq_attribute4_o =>ben_dsq_shd.g_old_rec.dsq_attribute4
179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5
180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6
181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7
182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8
183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9
184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10
185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11
186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12

Line 183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9

179: ,p_dsq_attribute5_o =>ben_dsq_shd.g_old_rec.dsq_attribute5
180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6
181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7
182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8
183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9
184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10
185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11
186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12
187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13

Line 184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10

180: ,p_dsq_attribute6_o =>ben_dsq_shd.g_old_rec.dsq_attribute6
181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7
182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8
183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9
184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10
185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11
186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12
187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13
188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14

Line 185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11

181: ,p_dsq_attribute7_o =>ben_dsq_shd.g_old_rec.dsq_attribute7
182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8
183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9
184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10
185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11
186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12
187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13
188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14
189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15

Line 186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12

182: ,p_dsq_attribute8_o =>ben_dsq_shd.g_old_rec.dsq_attribute8
183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9
184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10
185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11
186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12
187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13
188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14
189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15
190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16

Line 187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13

183: ,p_dsq_attribute9_o =>ben_dsq_shd.g_old_rec.dsq_attribute9
184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10
185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11
186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12
187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13
188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14
189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15
190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16
191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17

Line 188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14

184: ,p_dsq_attribute10_o =>ben_dsq_shd.g_old_rec.dsq_attribute10
185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11
186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12
187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13
188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14
189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15
190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16
191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17
192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18

Line 189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15

185: ,p_dsq_attribute11_o =>ben_dsq_shd.g_old_rec.dsq_attribute11
186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12
187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13
188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14
189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15
190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16
191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17
192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18
193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19

Line 190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16

186: ,p_dsq_attribute12_o =>ben_dsq_shd.g_old_rec.dsq_attribute12
187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13
188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14
189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15
190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16
191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17
192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18
193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19
194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20

Line 191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17

187: ,p_dsq_attribute13_o =>ben_dsq_shd.g_old_rec.dsq_attribute13
188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14
189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15
190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16
191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17
192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18
193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19
194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20
195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21

Line 192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18

188: ,p_dsq_attribute14_o =>ben_dsq_shd.g_old_rec.dsq_attribute14
189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15
190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16
191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17
192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18
193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19
194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20
195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21
196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22

Line 193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19

189: ,p_dsq_attribute15_o =>ben_dsq_shd.g_old_rec.dsq_attribute15
190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16
191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17
192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18
193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19
194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20
195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21
196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22
197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23

Line 194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20

190: ,p_dsq_attribute16_o =>ben_dsq_shd.g_old_rec.dsq_attribute16
191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17
192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18
193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19
194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20
195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21
196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22
197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23
198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24

Line 195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21

191: ,p_dsq_attribute17_o =>ben_dsq_shd.g_old_rec.dsq_attribute17
192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18
193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19
194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20
195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21
196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22
197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23
198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24
199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25

Line 196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22

192: ,p_dsq_attribute18_o =>ben_dsq_shd.g_old_rec.dsq_attribute18
193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19
194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20
195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21
196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22
197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23
198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24
199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25
200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26

Line 197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23

193: ,p_dsq_attribute19_o =>ben_dsq_shd.g_old_rec.dsq_attribute19
194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20
195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21
196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22
197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23
198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24
199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25
200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26
201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27

Line 198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24

194: ,p_dsq_attribute20_o =>ben_dsq_shd.g_old_rec.dsq_attribute20
195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21
196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22
197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23
198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24
199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25
200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26
201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27
202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28

Line 199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25

195: ,p_dsq_attribute21_o =>ben_dsq_shd.g_old_rec.dsq_attribute21
196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22
197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23
198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24
199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25
200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26
201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27
202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28
203: ,p_dsq_attribute29_o =>ben_dsq_shd.g_old_rec.dsq_attribute29

Line 200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26

196: ,p_dsq_attribute22_o =>ben_dsq_shd.g_old_rec.dsq_attribute22
197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23
198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24
199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25
200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26
201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27
202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28
203: ,p_dsq_attribute29_o =>ben_dsq_shd.g_old_rec.dsq_attribute29
204: ,p_dsq_attribute30_o =>ben_dsq_shd.g_old_rec.dsq_attribute30

Line 201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27

197: ,p_dsq_attribute23_o =>ben_dsq_shd.g_old_rec.dsq_attribute23
198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24
199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25
200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26
201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27
202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28
203: ,p_dsq_attribute29_o =>ben_dsq_shd.g_old_rec.dsq_attribute29
204: ,p_dsq_attribute30_o =>ben_dsq_shd.g_old_rec.dsq_attribute30
205: ,p_object_version_number_o =>ben_dsq_shd.g_old_rec.object_version_number

Line 202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28

198: ,p_dsq_attribute24_o =>ben_dsq_shd.g_old_rec.dsq_attribute24
199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25
200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26
201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27
202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28
203: ,p_dsq_attribute29_o =>ben_dsq_shd.g_old_rec.dsq_attribute29
204: ,p_dsq_attribute30_o =>ben_dsq_shd.g_old_rec.dsq_attribute30
205: ,p_object_version_number_o =>ben_dsq_shd.g_old_rec.object_version_number
206: );

Line 203: ,p_dsq_attribute29_o =>ben_dsq_shd.g_old_rec.dsq_attribute29

199: ,p_dsq_attribute25_o =>ben_dsq_shd.g_old_rec.dsq_attribute25
200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26
201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27
202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28
203: ,p_dsq_attribute29_o =>ben_dsq_shd.g_old_rec.dsq_attribute29
204: ,p_dsq_attribute30_o =>ben_dsq_shd.g_old_rec.dsq_attribute30
205: ,p_object_version_number_o =>ben_dsq_shd.g_old_rec.object_version_number
206: );
207: --

Line 204: ,p_dsq_attribute30_o =>ben_dsq_shd.g_old_rec.dsq_attribute30

200: ,p_dsq_attribute26_o =>ben_dsq_shd.g_old_rec.dsq_attribute26
201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27
202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28
203: ,p_dsq_attribute29_o =>ben_dsq_shd.g_old_rec.dsq_attribute29
204: ,p_dsq_attribute30_o =>ben_dsq_shd.g_old_rec.dsq_attribute30
205: ,p_object_version_number_o =>ben_dsq_shd.g_old_rec.object_version_number
206: );
207: --
208: exception

Line 205: ,p_object_version_number_o =>ben_dsq_shd.g_old_rec.object_version_number

201: ,p_dsq_attribute27_o =>ben_dsq_shd.g_old_rec.dsq_attribute27
202: ,p_dsq_attribute28_o =>ben_dsq_shd.g_old_rec.dsq_attribute28
203: ,p_dsq_attribute29_o =>ben_dsq_shd.g_old_rec.dsq_attribute29
204: ,p_dsq_attribute30_o =>ben_dsq_shd.g_old_rec.dsq_attribute30
205: ,p_object_version_number_o =>ben_dsq_shd.g_old_rec.object_version_number
206: );
207: --
208: exception
209: --

Line 230: p_rec in ben_dsq_shd.g_rec_type

226: -- ----------------------------------------------------------------------------
227: Procedure del
228: (
229: p_effective_date in date,
230: p_rec in ben_dsq_shd.g_rec_type
231: ) is
232: --
233: l_proc varchar2(72) := g_package||'del';
234: --

Line 240: ben_dsq_shd.lck

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

Line 275: l_rec ben_dsq_shd.g_rec_type;

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