DBA Data[Home] [Help]

APPS.BEN_XCR_UPD dependencies on BEN_XCR_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_xcr_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_xcr_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

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

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_xcr_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_ext_crit_prfl Row
68: --
69: update ben_ext_crit_prfl

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

109: last_update_login = p_rec.last_update_login,
110: object_version_number = p_rec.object_version_number
111: where ext_crit_prfl_id = p_rec.ext_crit_prfl_id;
112: --
113: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: --
117: Exception

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

116: --
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
121: ben_xcr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated

Line 121: ben_xcr_shd.constraint_error

117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
121: ben_xcr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status

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

121: ben_xcr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
126: ben_xcr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated

Line 126: ben_xcr_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
126: ben_xcr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status

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

126: ben_xcr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
131: ben_xcr_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status

Line 131: ben_xcr_shd.constraint_error

127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
131: ben_xcr_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;

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

130: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
131: ben_xcr_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;
136: End update_dml;
137: --
138: -- ----------------------------------------------------------------------------

Line 170: Procedure pre_update(p_rec in ben_xcr_shd.g_rec_type) is

166: -- Internal Row Handler Use Only.
167: --
168: -- {End Of Comments}
169: -- ----------------------------------------------------------------------------
170: Procedure pre_update(p_rec in ben_xcr_shd.g_rec_type) is
171: --
172: l_proc varchar2(72) := g_package||'pre_update';
173: --
174: Begin

Line 212: Procedure post_update(p_rec in ben_xcr_shd.g_rec_type) is

208: -- Internal Row Handler Use Only.
209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: Procedure post_update(p_rec in ben_xcr_shd.g_rec_type) is
213: --
214: l_proc varchar2(72) := g_package||'post_update';
215: --
216: Begin

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

259: ,p_xcr_attribute29 =>p_rec.xcr_attribute29
260: ,p_xcr_attribute30 =>p_rec.xcr_attribute30
261: ,p_ext_global_flag =>p_rec.ext_global_flag
262: ,p_object_version_number =>p_rec.object_version_number
263: ,p_name_o =>ben_xcr_shd.g_old_rec.name
264: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
265: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
266: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1

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

260: ,p_xcr_attribute30 =>p_rec.xcr_attribute30
261: ,p_ext_global_flag =>p_rec.ext_global_flag
262: ,p_object_version_number =>p_rec.object_version_number
263: ,p_name_o =>ben_xcr_shd.g_old_rec.name
264: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
265: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
266: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2

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

261: ,p_ext_global_flag =>p_rec.ext_global_flag
262: ,p_object_version_number =>p_rec.object_version_number
263: ,p_name_o =>ben_xcr_shd.g_old_rec.name
264: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
265: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
266: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3

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

262: ,p_object_version_number =>p_rec.object_version_number
263: ,p_name_o =>ben_xcr_shd.g_old_rec.name
264: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
265: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
266: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4

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

263: ,p_name_o =>ben_xcr_shd.g_old_rec.name
264: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
265: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
266: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5

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

264: ,p_business_group_id_o =>ben_xcr_shd.g_old_rec.business_group_id
265: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
266: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6

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

265: ,p_legislation_code_o =>ben_xcr_shd.g_old_rec.legislation_code
266: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7

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

266: ,p_xcr_attribute_category_o =>ben_xcr_shd.g_old_rec.xcr_attribute_category
267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8

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

267: ,p_xcr_attribute1_o =>ben_xcr_shd.g_old_rec.xcr_attribute1
268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9

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

268: ,p_xcr_attribute2_o =>ben_xcr_shd.g_old_rec.xcr_attribute2
269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10

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

269: ,p_xcr_attribute3_o =>ben_xcr_shd.g_old_rec.xcr_attribute3
270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11

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

270: ,p_xcr_attribute4_o =>ben_xcr_shd.g_old_rec.xcr_attribute4
271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12

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

271: ,p_xcr_attribute5_o =>ben_xcr_shd.g_old_rec.xcr_attribute5
272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13

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

272: ,p_xcr_attribute6_o =>ben_xcr_shd.g_old_rec.xcr_attribute6
273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14

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

273: ,p_xcr_attribute7_o =>ben_xcr_shd.g_old_rec.xcr_attribute7
274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15

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

274: ,p_xcr_attribute8_o =>ben_xcr_shd.g_old_rec.xcr_attribute8
275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16

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

275: ,p_xcr_attribute9_o =>ben_xcr_shd.g_old_rec.xcr_attribute9
276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17

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

276: ,p_xcr_attribute10_o =>ben_xcr_shd.g_old_rec.xcr_attribute10
277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18

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

277: ,p_xcr_attribute11_o =>ben_xcr_shd.g_old_rec.xcr_attribute11
278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19

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

278: ,p_xcr_attribute12_o =>ben_xcr_shd.g_old_rec.xcr_attribute12
279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20

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

279: ,p_xcr_attribute13_o =>ben_xcr_shd.g_old_rec.xcr_attribute13
280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21

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

280: ,p_xcr_attribute14_o =>ben_xcr_shd.g_old_rec.xcr_attribute14
281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22

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

281: ,p_xcr_attribute15_o =>ben_xcr_shd.g_old_rec.xcr_attribute15
282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23

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

282: ,p_xcr_attribute16_o =>ben_xcr_shd.g_old_rec.xcr_attribute16
283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24

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

283: ,p_xcr_attribute17_o =>ben_xcr_shd.g_old_rec.xcr_attribute17
284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25

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

284: ,p_xcr_attribute18_o =>ben_xcr_shd.g_old_rec.xcr_attribute18
285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26

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

285: ,p_xcr_attribute19_o =>ben_xcr_shd.g_old_rec.xcr_attribute19
286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27

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

286: ,p_xcr_attribute20_o =>ben_xcr_shd.g_old_rec.xcr_attribute20
287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28

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

287: ,p_xcr_attribute21_o =>ben_xcr_shd.g_old_rec.xcr_attribute21
288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
295: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29

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

288: ,p_xcr_attribute22_o =>ben_xcr_shd.g_old_rec.xcr_attribute22
289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
295: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
296: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30

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

289: ,p_xcr_attribute23_o =>ben_xcr_shd.g_old_rec.xcr_attribute23
290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
295: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
296: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
297: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag

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

290: ,p_xcr_attribute24_o =>ben_xcr_shd.g_old_rec.xcr_attribute24
291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
295: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
296: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
297: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
298: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number

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

291: ,p_xcr_attribute25_o =>ben_xcr_shd.g_old_rec.xcr_attribute25
292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
295: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
296: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
297: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
298: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number
299: );

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

292: ,p_xcr_attribute26_o =>ben_xcr_shd.g_old_rec.xcr_attribute26
293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
295: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
296: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
297: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
298: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number
299: );
300: --

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

293: ,p_xcr_attribute27_o =>ben_xcr_shd.g_old_rec.xcr_attribute27
294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
295: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
296: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
297: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
298: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number
299: );
300: --
301: exception

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

294: ,p_xcr_attribute28_o =>ben_xcr_shd.g_old_rec.xcr_attribute28
295: ,p_xcr_attribute29_o =>ben_xcr_shd.g_old_rec.xcr_attribute29
296: ,p_xcr_attribute30_o =>ben_xcr_shd.g_old_rec.xcr_attribute30
297: ,p_ext_global_flag_o =>ben_xcr_shd.g_old_rec.ext_global_flag
298: ,p_object_version_number_o =>ben_xcr_shd.g_old_rec.object_version_number
299: );
300: --
301: exception
302: --

Line 360: Procedure convert_defs(p_rec in out nocopy ben_xcr_shd.g_rec_type) is

356: -- Internal Row Handler Use Only.
357: --
358: -- {End Of Comments}
359: -- ----------------------------------------------------------------------------
360: Procedure convert_defs(p_rec in out nocopy ben_xcr_shd.g_rec_type) is
361: --
362: l_proc varchar2(72) := g_package||'convert_defs';
363: --
364: Begin

Line 375: ben_xcr_shd.g_old_rec.name;

371: -- is being used then we must set to the 'current' argument value.
372: --
373: If (p_rec.name = hr_api.g_varchar2) then
374: p_rec.name :=
375: ben_xcr_shd.g_old_rec.name;
376: End If;
377: If (p_rec.business_group_id = hr_api.g_number) then
378: p_rec.business_group_id :=
379: ben_xcr_shd.g_old_rec.business_group_id;

Line 379: ben_xcr_shd.g_old_rec.business_group_id;

375: ben_xcr_shd.g_old_rec.name;
376: End If;
377: If (p_rec.business_group_id = hr_api.g_number) then
378: p_rec.business_group_id :=
379: ben_xcr_shd.g_old_rec.business_group_id;
380: End If;
381: If (p_rec.legislation_code = hr_api.g_varchar2) then
382: p_rec.legislation_code :=
383: ben_xcr_shd.g_old_rec.legislation_code;

Line 383: ben_xcr_shd.g_old_rec.legislation_code;

379: ben_xcr_shd.g_old_rec.business_group_id;
380: End If;
381: If (p_rec.legislation_code = hr_api.g_varchar2) then
382: p_rec.legislation_code :=
383: ben_xcr_shd.g_old_rec.legislation_code;
384: End If;
385: If (p_rec.xcr_attribute_category = hr_api.g_varchar2) then
386: p_rec.xcr_attribute_category :=
387: ben_xcr_shd.g_old_rec.xcr_attribute_category;

Line 387: ben_xcr_shd.g_old_rec.xcr_attribute_category;

383: ben_xcr_shd.g_old_rec.legislation_code;
384: End If;
385: If (p_rec.xcr_attribute_category = hr_api.g_varchar2) then
386: p_rec.xcr_attribute_category :=
387: ben_xcr_shd.g_old_rec.xcr_attribute_category;
388: End If;
389: If (p_rec.xcr_attribute1 = hr_api.g_varchar2) then
390: p_rec.xcr_attribute1 :=
391: ben_xcr_shd.g_old_rec.xcr_attribute1;

Line 391: ben_xcr_shd.g_old_rec.xcr_attribute1;

387: ben_xcr_shd.g_old_rec.xcr_attribute_category;
388: End If;
389: If (p_rec.xcr_attribute1 = hr_api.g_varchar2) then
390: p_rec.xcr_attribute1 :=
391: ben_xcr_shd.g_old_rec.xcr_attribute1;
392: End If;
393: If (p_rec.xcr_attribute2 = hr_api.g_varchar2) then
394: p_rec.xcr_attribute2 :=
395: ben_xcr_shd.g_old_rec.xcr_attribute2;

Line 395: ben_xcr_shd.g_old_rec.xcr_attribute2;

391: ben_xcr_shd.g_old_rec.xcr_attribute1;
392: End If;
393: If (p_rec.xcr_attribute2 = hr_api.g_varchar2) then
394: p_rec.xcr_attribute2 :=
395: ben_xcr_shd.g_old_rec.xcr_attribute2;
396: End If;
397: If (p_rec.xcr_attribute3 = hr_api.g_varchar2) then
398: p_rec.xcr_attribute3 :=
399: ben_xcr_shd.g_old_rec.xcr_attribute3;

Line 399: ben_xcr_shd.g_old_rec.xcr_attribute3;

395: ben_xcr_shd.g_old_rec.xcr_attribute2;
396: End If;
397: If (p_rec.xcr_attribute3 = hr_api.g_varchar2) then
398: p_rec.xcr_attribute3 :=
399: ben_xcr_shd.g_old_rec.xcr_attribute3;
400: End If;
401: If (p_rec.xcr_attribute4 = hr_api.g_varchar2) then
402: p_rec.xcr_attribute4 :=
403: ben_xcr_shd.g_old_rec.xcr_attribute4;

Line 403: ben_xcr_shd.g_old_rec.xcr_attribute4;

399: ben_xcr_shd.g_old_rec.xcr_attribute3;
400: End If;
401: If (p_rec.xcr_attribute4 = hr_api.g_varchar2) then
402: p_rec.xcr_attribute4 :=
403: ben_xcr_shd.g_old_rec.xcr_attribute4;
404: End If;
405: If (p_rec.xcr_attribute5 = hr_api.g_varchar2) then
406: p_rec.xcr_attribute5 :=
407: ben_xcr_shd.g_old_rec.xcr_attribute5;

Line 407: ben_xcr_shd.g_old_rec.xcr_attribute5;

403: ben_xcr_shd.g_old_rec.xcr_attribute4;
404: End If;
405: If (p_rec.xcr_attribute5 = hr_api.g_varchar2) then
406: p_rec.xcr_attribute5 :=
407: ben_xcr_shd.g_old_rec.xcr_attribute5;
408: End If;
409: If (p_rec.xcr_attribute6 = hr_api.g_varchar2) then
410: p_rec.xcr_attribute6 :=
411: ben_xcr_shd.g_old_rec.xcr_attribute6;

Line 411: ben_xcr_shd.g_old_rec.xcr_attribute6;

407: ben_xcr_shd.g_old_rec.xcr_attribute5;
408: End If;
409: If (p_rec.xcr_attribute6 = hr_api.g_varchar2) then
410: p_rec.xcr_attribute6 :=
411: ben_xcr_shd.g_old_rec.xcr_attribute6;
412: End If;
413: If (p_rec.xcr_attribute7 = hr_api.g_varchar2) then
414: p_rec.xcr_attribute7 :=
415: ben_xcr_shd.g_old_rec.xcr_attribute7;

Line 415: ben_xcr_shd.g_old_rec.xcr_attribute7;

411: ben_xcr_shd.g_old_rec.xcr_attribute6;
412: End If;
413: If (p_rec.xcr_attribute7 = hr_api.g_varchar2) then
414: p_rec.xcr_attribute7 :=
415: ben_xcr_shd.g_old_rec.xcr_attribute7;
416: End If;
417: If (p_rec.xcr_attribute8 = hr_api.g_varchar2) then
418: p_rec.xcr_attribute8 :=
419: ben_xcr_shd.g_old_rec.xcr_attribute8;

Line 419: ben_xcr_shd.g_old_rec.xcr_attribute8;

415: ben_xcr_shd.g_old_rec.xcr_attribute7;
416: End If;
417: If (p_rec.xcr_attribute8 = hr_api.g_varchar2) then
418: p_rec.xcr_attribute8 :=
419: ben_xcr_shd.g_old_rec.xcr_attribute8;
420: End If;
421: If (p_rec.xcr_attribute9 = hr_api.g_varchar2) then
422: p_rec.xcr_attribute9 :=
423: ben_xcr_shd.g_old_rec.xcr_attribute9;

Line 423: ben_xcr_shd.g_old_rec.xcr_attribute9;

419: ben_xcr_shd.g_old_rec.xcr_attribute8;
420: End If;
421: If (p_rec.xcr_attribute9 = hr_api.g_varchar2) then
422: p_rec.xcr_attribute9 :=
423: ben_xcr_shd.g_old_rec.xcr_attribute9;
424: End If;
425: If (p_rec.xcr_attribute10 = hr_api.g_varchar2) then
426: p_rec.xcr_attribute10 :=
427: ben_xcr_shd.g_old_rec.xcr_attribute10;

Line 427: ben_xcr_shd.g_old_rec.xcr_attribute10;

423: ben_xcr_shd.g_old_rec.xcr_attribute9;
424: End If;
425: If (p_rec.xcr_attribute10 = hr_api.g_varchar2) then
426: p_rec.xcr_attribute10 :=
427: ben_xcr_shd.g_old_rec.xcr_attribute10;
428: End If;
429: If (p_rec.xcr_attribute11 = hr_api.g_varchar2) then
430: p_rec.xcr_attribute11 :=
431: ben_xcr_shd.g_old_rec.xcr_attribute11;

Line 431: ben_xcr_shd.g_old_rec.xcr_attribute11;

427: ben_xcr_shd.g_old_rec.xcr_attribute10;
428: End If;
429: If (p_rec.xcr_attribute11 = hr_api.g_varchar2) then
430: p_rec.xcr_attribute11 :=
431: ben_xcr_shd.g_old_rec.xcr_attribute11;
432: End If;
433: If (p_rec.xcr_attribute12 = hr_api.g_varchar2) then
434: p_rec.xcr_attribute12 :=
435: ben_xcr_shd.g_old_rec.xcr_attribute12;

Line 435: ben_xcr_shd.g_old_rec.xcr_attribute12;

431: ben_xcr_shd.g_old_rec.xcr_attribute11;
432: End If;
433: If (p_rec.xcr_attribute12 = hr_api.g_varchar2) then
434: p_rec.xcr_attribute12 :=
435: ben_xcr_shd.g_old_rec.xcr_attribute12;
436: End If;
437: If (p_rec.xcr_attribute13 = hr_api.g_varchar2) then
438: p_rec.xcr_attribute13 :=
439: ben_xcr_shd.g_old_rec.xcr_attribute13;

Line 439: ben_xcr_shd.g_old_rec.xcr_attribute13;

435: ben_xcr_shd.g_old_rec.xcr_attribute12;
436: End If;
437: If (p_rec.xcr_attribute13 = hr_api.g_varchar2) then
438: p_rec.xcr_attribute13 :=
439: ben_xcr_shd.g_old_rec.xcr_attribute13;
440: End If;
441: If (p_rec.xcr_attribute14 = hr_api.g_varchar2) then
442: p_rec.xcr_attribute14 :=
443: ben_xcr_shd.g_old_rec.xcr_attribute14;

Line 443: ben_xcr_shd.g_old_rec.xcr_attribute14;

439: ben_xcr_shd.g_old_rec.xcr_attribute13;
440: End If;
441: If (p_rec.xcr_attribute14 = hr_api.g_varchar2) then
442: p_rec.xcr_attribute14 :=
443: ben_xcr_shd.g_old_rec.xcr_attribute14;
444: End If;
445: If (p_rec.xcr_attribute15 = hr_api.g_varchar2) then
446: p_rec.xcr_attribute15 :=
447: ben_xcr_shd.g_old_rec.xcr_attribute15;

Line 447: ben_xcr_shd.g_old_rec.xcr_attribute15;

443: ben_xcr_shd.g_old_rec.xcr_attribute14;
444: End If;
445: If (p_rec.xcr_attribute15 = hr_api.g_varchar2) then
446: p_rec.xcr_attribute15 :=
447: ben_xcr_shd.g_old_rec.xcr_attribute15;
448: End If;
449: If (p_rec.xcr_attribute16 = hr_api.g_varchar2) then
450: p_rec.xcr_attribute16 :=
451: ben_xcr_shd.g_old_rec.xcr_attribute16;

Line 451: ben_xcr_shd.g_old_rec.xcr_attribute16;

447: ben_xcr_shd.g_old_rec.xcr_attribute15;
448: End If;
449: If (p_rec.xcr_attribute16 = hr_api.g_varchar2) then
450: p_rec.xcr_attribute16 :=
451: ben_xcr_shd.g_old_rec.xcr_attribute16;
452: End If;
453: If (p_rec.xcr_attribute17 = hr_api.g_varchar2) then
454: p_rec.xcr_attribute17 :=
455: ben_xcr_shd.g_old_rec.xcr_attribute17;

Line 455: ben_xcr_shd.g_old_rec.xcr_attribute17;

451: ben_xcr_shd.g_old_rec.xcr_attribute16;
452: End If;
453: If (p_rec.xcr_attribute17 = hr_api.g_varchar2) then
454: p_rec.xcr_attribute17 :=
455: ben_xcr_shd.g_old_rec.xcr_attribute17;
456: End If;
457: If (p_rec.xcr_attribute18 = hr_api.g_varchar2) then
458: p_rec.xcr_attribute18 :=
459: ben_xcr_shd.g_old_rec.xcr_attribute18;

Line 459: ben_xcr_shd.g_old_rec.xcr_attribute18;

455: ben_xcr_shd.g_old_rec.xcr_attribute17;
456: End If;
457: If (p_rec.xcr_attribute18 = hr_api.g_varchar2) then
458: p_rec.xcr_attribute18 :=
459: ben_xcr_shd.g_old_rec.xcr_attribute18;
460: End If;
461: If (p_rec.xcr_attribute19 = hr_api.g_varchar2) then
462: p_rec.xcr_attribute19 :=
463: ben_xcr_shd.g_old_rec.xcr_attribute19;

Line 463: ben_xcr_shd.g_old_rec.xcr_attribute19;

459: ben_xcr_shd.g_old_rec.xcr_attribute18;
460: End If;
461: If (p_rec.xcr_attribute19 = hr_api.g_varchar2) then
462: p_rec.xcr_attribute19 :=
463: ben_xcr_shd.g_old_rec.xcr_attribute19;
464: End If;
465: If (p_rec.xcr_attribute20 = hr_api.g_varchar2) then
466: p_rec.xcr_attribute20 :=
467: ben_xcr_shd.g_old_rec.xcr_attribute20;

Line 467: ben_xcr_shd.g_old_rec.xcr_attribute20;

463: ben_xcr_shd.g_old_rec.xcr_attribute19;
464: End If;
465: If (p_rec.xcr_attribute20 = hr_api.g_varchar2) then
466: p_rec.xcr_attribute20 :=
467: ben_xcr_shd.g_old_rec.xcr_attribute20;
468: End If;
469: If (p_rec.xcr_attribute21 = hr_api.g_varchar2) then
470: p_rec.xcr_attribute21 :=
471: ben_xcr_shd.g_old_rec.xcr_attribute21;

Line 471: ben_xcr_shd.g_old_rec.xcr_attribute21;

467: ben_xcr_shd.g_old_rec.xcr_attribute20;
468: End If;
469: If (p_rec.xcr_attribute21 = hr_api.g_varchar2) then
470: p_rec.xcr_attribute21 :=
471: ben_xcr_shd.g_old_rec.xcr_attribute21;
472: End If;
473: If (p_rec.xcr_attribute22 = hr_api.g_varchar2) then
474: p_rec.xcr_attribute22 :=
475: ben_xcr_shd.g_old_rec.xcr_attribute22;

Line 475: ben_xcr_shd.g_old_rec.xcr_attribute22;

471: ben_xcr_shd.g_old_rec.xcr_attribute21;
472: End If;
473: If (p_rec.xcr_attribute22 = hr_api.g_varchar2) then
474: p_rec.xcr_attribute22 :=
475: ben_xcr_shd.g_old_rec.xcr_attribute22;
476: End If;
477: If (p_rec.xcr_attribute23 = hr_api.g_varchar2) then
478: p_rec.xcr_attribute23 :=
479: ben_xcr_shd.g_old_rec.xcr_attribute23;

Line 479: ben_xcr_shd.g_old_rec.xcr_attribute23;

475: ben_xcr_shd.g_old_rec.xcr_attribute22;
476: End If;
477: If (p_rec.xcr_attribute23 = hr_api.g_varchar2) then
478: p_rec.xcr_attribute23 :=
479: ben_xcr_shd.g_old_rec.xcr_attribute23;
480: End If;
481: If (p_rec.xcr_attribute24 = hr_api.g_varchar2) then
482: p_rec.xcr_attribute24 :=
483: ben_xcr_shd.g_old_rec.xcr_attribute24;

Line 483: ben_xcr_shd.g_old_rec.xcr_attribute24;

479: ben_xcr_shd.g_old_rec.xcr_attribute23;
480: End If;
481: If (p_rec.xcr_attribute24 = hr_api.g_varchar2) then
482: p_rec.xcr_attribute24 :=
483: ben_xcr_shd.g_old_rec.xcr_attribute24;
484: End If;
485: If (p_rec.xcr_attribute25 = hr_api.g_varchar2) then
486: p_rec.xcr_attribute25 :=
487: ben_xcr_shd.g_old_rec.xcr_attribute25;

Line 487: ben_xcr_shd.g_old_rec.xcr_attribute25;

483: ben_xcr_shd.g_old_rec.xcr_attribute24;
484: End If;
485: If (p_rec.xcr_attribute25 = hr_api.g_varchar2) then
486: p_rec.xcr_attribute25 :=
487: ben_xcr_shd.g_old_rec.xcr_attribute25;
488: End If;
489: If (p_rec.xcr_attribute26 = hr_api.g_varchar2) then
490: p_rec.xcr_attribute26 :=
491: ben_xcr_shd.g_old_rec.xcr_attribute26;

Line 491: ben_xcr_shd.g_old_rec.xcr_attribute26;

487: ben_xcr_shd.g_old_rec.xcr_attribute25;
488: End If;
489: If (p_rec.xcr_attribute26 = hr_api.g_varchar2) then
490: p_rec.xcr_attribute26 :=
491: ben_xcr_shd.g_old_rec.xcr_attribute26;
492: End If;
493: If (p_rec.xcr_attribute27 = hr_api.g_varchar2) then
494: p_rec.xcr_attribute27 :=
495: ben_xcr_shd.g_old_rec.xcr_attribute27;

Line 495: ben_xcr_shd.g_old_rec.xcr_attribute27;

491: ben_xcr_shd.g_old_rec.xcr_attribute26;
492: End If;
493: If (p_rec.xcr_attribute27 = hr_api.g_varchar2) then
494: p_rec.xcr_attribute27 :=
495: ben_xcr_shd.g_old_rec.xcr_attribute27;
496: End If;
497: If (p_rec.xcr_attribute28 = hr_api.g_varchar2) then
498: p_rec.xcr_attribute28 :=
499: ben_xcr_shd.g_old_rec.xcr_attribute28;

Line 499: ben_xcr_shd.g_old_rec.xcr_attribute28;

495: ben_xcr_shd.g_old_rec.xcr_attribute27;
496: End If;
497: If (p_rec.xcr_attribute28 = hr_api.g_varchar2) then
498: p_rec.xcr_attribute28 :=
499: ben_xcr_shd.g_old_rec.xcr_attribute28;
500: End If;
501: If (p_rec.xcr_attribute29 = hr_api.g_varchar2) then
502: p_rec.xcr_attribute29 :=
503: ben_xcr_shd.g_old_rec.xcr_attribute29;

Line 503: ben_xcr_shd.g_old_rec.xcr_attribute29;

499: ben_xcr_shd.g_old_rec.xcr_attribute28;
500: End If;
501: If (p_rec.xcr_attribute29 = hr_api.g_varchar2) then
502: p_rec.xcr_attribute29 :=
503: ben_xcr_shd.g_old_rec.xcr_attribute29;
504: End If;
505: If (p_rec.xcr_attribute30 = hr_api.g_varchar2) then
506: p_rec.xcr_attribute30 :=
507: ben_xcr_shd.g_old_rec.xcr_attribute30;

Line 507: ben_xcr_shd.g_old_rec.xcr_attribute30;

503: ben_xcr_shd.g_old_rec.xcr_attribute29;
504: End If;
505: If (p_rec.xcr_attribute30 = hr_api.g_varchar2) then
506: p_rec.xcr_attribute30 :=
507: ben_xcr_shd.g_old_rec.xcr_attribute30;
508: End If;
509:
510: If (p_rec.ext_global_flag = hr_api.g_varchar2) then
511: p_rec.ext_global_flag :=

Line 512: ben_xcr_shd.g_old_rec.ext_global_flag;

508: End If;
509:
510: If (p_rec.ext_global_flag = hr_api.g_varchar2) then
511: p_rec.ext_global_flag :=
512: ben_xcr_shd.g_old_rec.ext_global_flag;
513: End If;
514:
515: --
516: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 525: p_rec in out nocopy ben_xcr_shd.g_rec_type

521: -- |---------------------------------< upd >----------------------------------|
522: -- ----------------------------------------------------------------------------
523: Procedure upd
524: (
525: p_rec in out nocopy ben_xcr_shd.g_rec_type
526: ) is
527: --
528: l_proc varchar2(72) := g_package||'upd';
529: --

Line 535: ben_xcr_shd.lck

531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- We must lock the row which we need to update.
534: --
535: ben_xcr_shd.lck
536: (
537: p_rec.ext_crit_prfl_id,
538: p_rec.object_version_number
539: );

Line 612: l_rec ben_xcr_shd.g_rec_type;

608: p_created_by in number default hr_api.g_number,
609: p_object_version_number in out nocopy number
610: ) is
611: --
612: l_rec ben_xcr_shd.g_rec_type;
613: l_proc varchar2(72) := g_package||'upd';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);

Line 622: ben_xcr_shd.convert_args

618: -- Call conversion function to turn arguments into the
619: -- l_rec structure.
620: --
621: l_rec :=
622: ben_xcr_shd.convert_args
623: (
624: p_ext_crit_prfl_id,
625: p_name,
626: p_business_group_id,