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_XCR_DEL dependencies on BEN_XCR_SHD

Line 87: Procedure delete_dml(p_rec in ben_xcr_shd.g_rec_type) is

83: -- Internal Row Handler Use Only.
84: --
85: -- {End Of Comments}
86: -- ----------------------------------------------------------------------------
87: Procedure delete_dml(p_rec in ben_xcr_shd.g_rec_type) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --
91: Begin

Line 94: ben_xcr_shd.g_api_dml := true; -- Set the api dml status

90: --
91: Begin
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: --
94: ben_xcr_shd.g_api_dml := true; -- Set the api dml status
95: --
96: -- Delete the ben_ext_crit_prfl row.
97: --
98: delete from ben_ext_crit_prfl

Line 101: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status

97: --
98: delete from ben_ext_crit_prfl
99: where ext_crit_prfl_id = p_rec.ext_crit_prfl_id;
100: --
101: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception

Line 108: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status

104: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
109: ben_xcr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status

Line 109: ben_xcr_shd.constraint_error

105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
109: ben_xcr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;

Line 112: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status

108: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
109: ben_xcr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End delete_dml;
115: --
116: -- ----------------------------------------------------------------------------

Line 148: Procedure pre_delete(p_rec in ben_xcr_shd.g_rec_type) is

144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in ben_xcr_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin

Line 190: Procedure post_delete(p_rec in ben_xcr_shd.g_rec_type) is

186: -- Internal table Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in ben_xcr_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin

Line 206: ,p_name_o =>ben_xcr_shd.g_old_rec.name

202: --
203: ben_xcr_rkd.after_delete
204: (
205: p_ext_crit_prfl_id =>p_rec.ext_crit_prfl_id
206: ,p_name_o =>ben_xcr_shd.g_old_rec.name
207: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1

Line 207: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id

203: ben_xcr_rkd.after_delete
204: (
205: p_ext_crit_prfl_id =>p_rec.ext_crit_prfl_id
206: ,p_name_o =>ben_xcr_shd.g_old_rec.name
207: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2

Line 208: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code

204: (
205: p_ext_crit_prfl_id =>p_rec.ext_crit_prfl_id
206: ,p_name_o =>ben_xcr_shd.g_old_rec.name
207: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3

Line 209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category

205: p_ext_crit_prfl_id =>p_rec.ext_crit_prfl_id
206: ,p_name_o =>ben_xcr_shd.g_old_rec.name
207: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4

Line 210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1

206: ,p_name_o =>ben_xcr_shd.g_old_rec.name
207: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5

Line 211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2

207: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6

Line 212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3

208: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7

Line 213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4

209: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8

Line 214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5

210: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9

Line 215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6

211: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10

Line 216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7

212: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11

Line 217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8

213: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12

Line 218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9

214: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13

Line 219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10

215: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14

Line 220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11

216: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15

Line 221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12

217: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16

Line 222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13

218: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17

Line 223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14

219: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18

Line 224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15

220: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19

Line 225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16

221: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20

Line 226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17

222: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21

Line 227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18

223: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22

Line 228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19

224: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23

Line 229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20

225: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24

Line 230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21

226: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25

Line 231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22

227: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26

Line 232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23

228: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27

Line 233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24

229: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28

Line 234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25

230: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29

Line 235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26

231: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
239: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30

Line 236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27

232: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
239: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
240: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag

Line 237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28

233: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
239: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
240: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
241: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number

Line 238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29

234: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
239: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
240: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
241: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number
242: );

Line 239: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30

235: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
239: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
240: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
241: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number
242: );
243: --

Line 240: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag

236: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
239: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
240: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
241: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number
242: );
243: --
244: exception

Line 241: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number

237: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
238: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
239: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
240: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
241: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number
242: );
243: --
244: exception
245: --

Line 265: p_rec in ben_xcr_shd.g_rec_type

261: -- |---------------------------------< del >----------------------------------|
262: -- ----------------------------------------------------------------------------
263: Procedure del
264: (
265: p_rec in ben_xcr_shd.g_rec_type
266: ) is
267: --
268: l_proc varchar2(72) := g_package||'del';
269: --

Line 275: ben_xcr_shd.lck

271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: -- We must lock the row which we need to delete.
274: --
275: ben_xcr_shd.lck
276: (
277: p_rec.ext_crit_prfl_id,
278: p_rec.object_version_number
279: );

Line 308: l_rec ben_xcr_shd.g_rec_type;

304: p_legislation_code in varchar2 default null,
305: p_object_version_number in number
306: ) is
307: --
308: l_rec ben_xcr_shd.g_rec_type;
309: l_proc varchar2(72) := g_package||'del';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);