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_XFI_DEL dependencies on BEN_XFI_SHD

Line 86: Procedure delete_dml(p_rec in ben_xfi_shd.g_rec_type) is

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

Line 93: ben_xfi_shd.g_api_dml := true; -- Set the api dml status

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

Line 100: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 107: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 108: ben_xfi_shd.constraint_error

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

Line 111: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 147: Procedure pre_delete(p_rec in ben_xfi_shd.g_rec_type) is

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

Line 189: Procedure post_delete(p_rec in ben_xfi_shd.g_rec_type) is

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

Line 209: ,p_name_o =>ben_xfi_shd.g_old_rec.name

205: --
206: ben_xfi_rkd.after_delete
207: (
208: p_ext_file_id =>p_rec.ext_file_id
209: ,p_name_o =>ben_xfi_shd.g_old_rec.name
210: ,p_xml_tag_name_o =>ben_xfi_shd.g_old_rec.xml_tag_name
211: ,p_business_group_id_o =>ben_xfi_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code
213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category

Line 210: ,p_xml_tag_name_o =>ben_xfi_shd.g_old_rec.xml_tag_name

206: ben_xfi_rkd.after_delete
207: (
208: p_ext_file_id =>p_rec.ext_file_id
209: ,p_name_o =>ben_xfi_shd.g_old_rec.name
210: ,p_xml_tag_name_o =>ben_xfi_shd.g_old_rec.xml_tag_name
211: ,p_business_group_id_o =>ben_xfi_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code
213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category
214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1

Line 211: ,p_business_group_id_o =>ben_xfi_shd.g_old_rec.business_group_id

207: (
208: p_ext_file_id =>p_rec.ext_file_id
209: ,p_name_o =>ben_xfi_shd.g_old_rec.name
210: ,p_xml_tag_name_o =>ben_xfi_shd.g_old_rec.xml_tag_name
211: ,p_business_group_id_o =>ben_xfi_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code
213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category
214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1
215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2

Line 212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code

208: p_ext_file_id =>p_rec.ext_file_id
209: ,p_name_o =>ben_xfi_shd.g_old_rec.name
210: ,p_xml_tag_name_o =>ben_xfi_shd.g_old_rec.xml_tag_name
211: ,p_business_group_id_o =>ben_xfi_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code
213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category
214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1
215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2
216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3

Line 213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category

209: ,p_name_o =>ben_xfi_shd.g_old_rec.name
210: ,p_xml_tag_name_o =>ben_xfi_shd.g_old_rec.xml_tag_name
211: ,p_business_group_id_o =>ben_xfi_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code
213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category
214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1
215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2
216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3
217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4

Line 214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1

210: ,p_xml_tag_name_o =>ben_xfi_shd.g_old_rec.xml_tag_name
211: ,p_business_group_id_o =>ben_xfi_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code
213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category
214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1
215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2
216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3
217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4
218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5

Line 215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2

211: ,p_business_group_id_o =>ben_xfi_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code
213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category
214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1
215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2
216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3
217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4
218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5
219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6

Line 216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3

212: ,p_legislation_code_o =>ben_xfi_shd.g_old_rec.legislation_code
213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category
214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1
215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2
216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3
217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4
218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5
219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6
220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7

Line 217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4

213: ,p_xfi_attribute_category_o =>ben_xfi_shd.g_old_rec.xfi_attribute_category
214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1
215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2
216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3
217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4
218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5
219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6
220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7
221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8

Line 218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5

214: ,p_xfi_attribute1_o =>ben_xfi_shd.g_old_rec.xfi_attribute1
215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2
216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3
217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4
218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5
219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6
220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7
221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8
222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9

Line 219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6

215: ,p_xfi_attribute2_o =>ben_xfi_shd.g_old_rec.xfi_attribute2
216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3
217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4
218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5
219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6
220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7
221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8
222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9
223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10

Line 220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7

216: ,p_xfi_attribute3_o =>ben_xfi_shd.g_old_rec.xfi_attribute3
217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4
218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5
219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6
220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7
221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8
222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9
223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10
224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11

Line 221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8

217: ,p_xfi_attribute4_o =>ben_xfi_shd.g_old_rec.xfi_attribute4
218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5
219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6
220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7
221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8
222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9
223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10
224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11
225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12

Line 222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9

218: ,p_xfi_attribute5_o =>ben_xfi_shd.g_old_rec.xfi_attribute5
219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6
220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7
221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8
222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9
223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10
224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11
225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12
226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13

Line 223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10

219: ,p_xfi_attribute6_o =>ben_xfi_shd.g_old_rec.xfi_attribute6
220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7
221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8
222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9
223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10
224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11
225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12
226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13
227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14

Line 224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11

220: ,p_xfi_attribute7_o =>ben_xfi_shd.g_old_rec.xfi_attribute7
221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8
222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9
223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10
224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11
225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12
226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13
227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14
228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15

Line 225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12

221: ,p_xfi_attribute8_o =>ben_xfi_shd.g_old_rec.xfi_attribute8
222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9
223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10
224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11
225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12
226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13
227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14
228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15
229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16

Line 226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13

222: ,p_xfi_attribute9_o =>ben_xfi_shd.g_old_rec.xfi_attribute9
223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10
224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11
225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12
226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13
227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14
228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15
229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16
230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17

Line 227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14

223: ,p_xfi_attribute10_o =>ben_xfi_shd.g_old_rec.xfi_attribute10
224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11
225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12
226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13
227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14
228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15
229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16
230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17
231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18

Line 228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15

224: ,p_xfi_attribute11_o =>ben_xfi_shd.g_old_rec.xfi_attribute11
225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12
226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13
227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14
228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15
229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16
230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17
231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18
232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19

Line 229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16

225: ,p_xfi_attribute12_o =>ben_xfi_shd.g_old_rec.xfi_attribute12
226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13
227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14
228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15
229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16
230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17
231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18
232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19
233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20

Line 230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17

226: ,p_xfi_attribute13_o =>ben_xfi_shd.g_old_rec.xfi_attribute13
227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14
228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15
229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16
230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17
231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18
232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19
233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20
234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21

Line 231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18

227: ,p_xfi_attribute14_o =>ben_xfi_shd.g_old_rec.xfi_attribute14
228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15
229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16
230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17
231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18
232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19
233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20
234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21
235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22

Line 232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19

228: ,p_xfi_attribute15_o =>ben_xfi_shd.g_old_rec.xfi_attribute15
229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16
230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17
231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18
232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19
233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20
234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21
235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22
236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23

Line 233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20

229: ,p_xfi_attribute16_o =>ben_xfi_shd.g_old_rec.xfi_attribute16
230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17
231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18
232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19
233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20
234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21
235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22
236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23
237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24

Line 234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21

230: ,p_xfi_attribute17_o =>ben_xfi_shd.g_old_rec.xfi_attribute17
231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18
232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19
233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20
234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21
235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22
236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23
237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24
238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25

Line 235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22

231: ,p_xfi_attribute18_o =>ben_xfi_shd.g_old_rec.xfi_attribute18
232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19
233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20
234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21
235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22
236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23
237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24
238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25
239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26

Line 236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23

232: ,p_xfi_attribute19_o =>ben_xfi_shd.g_old_rec.xfi_attribute19
233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20
234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21
235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22
236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23
237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24
238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25
239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26
240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27

Line 237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24

233: ,p_xfi_attribute20_o =>ben_xfi_shd.g_old_rec.xfi_attribute20
234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21
235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22
236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23
237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24
238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25
239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26
240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27
241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28

Line 238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25

234: ,p_xfi_attribute21_o =>ben_xfi_shd.g_old_rec.xfi_attribute21
235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22
236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23
237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24
238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25
239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26
240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27
241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28
242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29

Line 239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26

235: ,p_xfi_attribute22_o =>ben_xfi_shd.g_old_rec.xfi_attribute22
236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23
237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24
238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25
239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26
240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27
241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28
242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29
243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30

Line 240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27

236: ,p_xfi_attribute23_o =>ben_xfi_shd.g_old_rec.xfi_attribute23
237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24
238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25
239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26
240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27
241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28
242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29
243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30
244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id

Line 241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28

237: ,p_xfi_attribute24_o =>ben_xfi_shd.g_old_rec.xfi_attribute24
238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25
239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26
240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27
241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28
242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29
243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30
244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id
245: ,p_ext_data_elmt_in_rcd_id1_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1

Line 242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29

238: ,p_xfi_attribute25_o =>ben_xfi_shd.g_old_rec.xfi_attribute25
239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26
240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27
241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28
242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29
243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30
244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id
245: ,p_ext_data_elmt_in_rcd_id1_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1
246: ,p_ext_data_elmt_in_rcd_id2_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id2

Line 243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30

239: ,p_xfi_attribute26_o =>ben_xfi_shd.g_old_rec.xfi_attribute26
240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27
241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28
242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29
243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30
244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id
245: ,p_ext_data_elmt_in_rcd_id1_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1
246: ,p_ext_data_elmt_in_rcd_id2_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id2
247: ,p_object_version_number_o =>ben_xfi_shd.g_old_rec.object_version_number

Line 244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id

240: ,p_xfi_attribute27_o =>ben_xfi_shd.g_old_rec.xfi_attribute27
241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28
242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29
243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30
244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id
245: ,p_ext_data_elmt_in_rcd_id1_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1
246: ,p_ext_data_elmt_in_rcd_id2_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id2
247: ,p_object_version_number_o =>ben_xfi_shd.g_old_rec.object_version_number
248: );

Line 245: ,p_ext_data_elmt_in_rcd_id1_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1

241: ,p_xfi_attribute28_o =>ben_xfi_shd.g_old_rec.xfi_attribute28
242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29
243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30
244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id
245: ,p_ext_data_elmt_in_rcd_id1_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1
246: ,p_ext_data_elmt_in_rcd_id2_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id2
247: ,p_object_version_number_o =>ben_xfi_shd.g_old_rec.object_version_number
248: );
249: --

Line 246: ,p_ext_data_elmt_in_rcd_id2_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id2

242: ,p_xfi_attribute29_o =>ben_xfi_shd.g_old_rec.xfi_attribute29
243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30
244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id
245: ,p_ext_data_elmt_in_rcd_id1_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1
246: ,p_ext_data_elmt_in_rcd_id2_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id2
247: ,p_object_version_number_o =>ben_xfi_shd.g_old_rec.object_version_number
248: );
249: --
250: exception

Line 247: ,p_object_version_number_o =>ben_xfi_shd.g_old_rec.object_version_number

243: ,p_xfi_attribute30_o =>ben_xfi_shd.g_old_rec.xfi_attribute30
244: ,p_ext_rcd_in_file_id_o => ben_xfi_shd.g_old_rec.ext_rcd_in_file_id
245: ,p_ext_data_elmt_in_rcd_id1_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1
246: ,p_ext_data_elmt_in_rcd_id2_o => ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id2
247: ,p_object_version_number_o =>ben_xfi_shd.g_old_rec.object_version_number
248: );
249: --
250: exception
251: --

Line 271: p_rec in ben_xfi_shd.g_rec_type

267: -- |---------------------------------< del >----------------------------------|
268: -- ----------------------------------------------------------------------------
269: Procedure del
270: (
271: p_rec in ben_xfi_shd.g_rec_type
272: ) is
273: --
274: l_proc varchar2(72) := g_package||'del';
275: --

Line 281: ben_xfi_shd.lck

277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- We must lock the row which we need to delete.
280: --
281: ben_xfi_shd.lck
282: (
283: p_rec.ext_file_id,
284: p_rec.object_version_number
285: );

Line 314: l_rec ben_xfi_shd.g_rec_type;

310: p_legislation_code in varchar2 default null,
311: p_object_version_number in number
312: ) is
313: --
314: l_rec ben_xfi_shd.g_rec_type;
315: l_proc varchar2(72) := g_package||'del';
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);