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_XRC_DEL dependencies on BEN_XRC_SHD

Line 88: Procedure delete_dml(p_rec in ben_xrc_shd.g_rec_type) is

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

Line 95: ben_xrc_shd.g_api_dml := true; -- Set the api dml status

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

Line 102: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 109: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 110: ben_xrc_shd.constraint_error

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

Line 113: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 149: Procedure pre_delete(p_rec in ben_xrc_shd.g_rec_type) is

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

Line 192: p_effective_date in date,p_rec in ben_xrc_shd.g_rec_type) is

188: --
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure post_delete(
192: p_effective_date in date,p_rec in ben_xrc_shd.g_rec_type) is
193: --
194: l_proc varchar2(72) := g_package||'post_delete';
195: --
196: Begin

Line 212: ,p_name_o =>ben_xrc_shd.g_old_rec.name

208: --
209: ben_xrc_rkd.after_delete
210: (
211: p_ext_rcd_id =>p_rec.ext_rcd_id
212: ,p_name_o =>ben_xrc_shd.g_old_rec.name
213: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
214: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id

Line 213: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name

209: ben_xrc_rkd.after_delete
210: (
211: p_ext_rcd_id =>p_rec.ext_rcd_id
212: ,p_name_o =>ben_xrc_shd.g_old_rec.name
213: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
214: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code

Line 214: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd

210: (
211: p_ext_rcd_id =>p_rec.ext_rcd_id
212: ,p_name_o =>ben_xrc_shd.g_old_rec.name
213: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
214: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category

Line 215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd

211: p_ext_rcd_id =>p_rec.ext_rcd_id
212: ,p_name_o =>ben_xrc_shd.g_old_rec.name
213: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
214: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1

Line 216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id

212: ,p_name_o =>ben_xrc_shd.g_old_rec.name
213: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
214: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2

Line 217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code

213: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
214: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3

Line 218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category

214: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4

Line 219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1

215: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5

Line 220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2

216: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6

Line 221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3

217: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7

Line 222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4

218: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8

Line 223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5

219: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9

Line 224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6

220: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10

Line 225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7

221: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11

Line 226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8

222: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12

Line 227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9

223: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13

Line 228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10

224: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14

Line 229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11

225: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15

Line 230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12

226: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16

Line 231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13

227: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17

Line 232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14

228: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18

Line 233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15

229: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19

Line 234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16

230: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20

Line 235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17

231: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21

Line 236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18

232: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22

Line 237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19

233: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23

Line 238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20

234: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24

Line 239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21

235: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25

Line 240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22

236: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26

Line 241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23

237: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27

Line 242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24

238: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28

Line 243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25

239: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
247: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29

Line 244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26

240: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
247: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
248: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30

Line 245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27

241: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
247: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
248: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
249: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number

Line 246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28

242: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
247: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
248: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
249: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
250: );

Line 247: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29

243: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
247: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
248: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
249: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
250: );
251: --

Line 248: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30

244: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
247: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
248: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
249: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
250: );
251: --
252: exception

Line 249: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number

245: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
246: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
247: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
248: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
249: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
250: );
251: --
252: exception
253: --

Line 274: p_rec in ben_xrc_shd.g_rec_type

270: -- ----------------------------------------------------------------------------
271: Procedure del
272: (
273: p_effective_date in date,
274: p_rec in ben_xrc_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'del';
278: --

Line 284: ben_xrc_shd.lck

280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- We must lock the row which we need to delete.
283: --
284: ben_xrc_shd.lck
285: (
286: p_rec.ext_rcd_id,
287: p_rec.object_version_number
288: );

Line 320: l_rec ben_xrc_shd.g_rec_type;

316: p_legislation_code in varchar2 default null,
317: p_object_version_number in number
318: ) is
319: --
320: l_rec ben_xrc_shd.g_rec_type;
321: l_proc varchar2(72) := g_package||'del';
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);