DBA Data[Home] [Help]

APPS.BEN_ERC_UPD dependencies on BEN_ERC_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_erc_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_erc_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_erc_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_erc_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_enrt_rt_ctfn Row
68: --
69: update ben_enrt_rt_ctfn

Line 114: ben_erc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 121: ben_erc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 122: ben_erc_shd.constraint_error

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

Line 126: ben_erc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 127: ben_erc_shd.constraint_error

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

Line 131: ben_erc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 132: ben_erc_shd.constraint_error

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

Line 135: ben_erc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 171: Procedure pre_update(p_rec in ben_erc_shd.g_rec_type) is

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

Line 214: p_effective_date in date,p_rec in ben_erc_shd.g_rec_type) is

210: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update(
214: p_effective_date in date,p_rec in ben_erc_shd.g_rec_type) is
215: --
216: l_proc varchar2(72) := g_package||'post_update';
217: --
218: Begin

Line 270: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd

266: ,p_program_id =>p_rec.program_id
267: ,p_program_update_date =>p_rec.program_update_date
268: ,p_object_version_number =>p_rec.object_version_number
269: ,p_effective_date =>p_effective_date
270: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
271: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
272: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category

Line 271: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag

267: ,p_program_update_date =>p_rec.program_update_date
268: ,p_object_version_number =>p_rec.object_version_number
269: ,p_effective_date =>p_effective_date
270: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
271: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
272: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1

Line 272: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id

268: ,p_object_version_number =>p_rec.object_version_number
269: ,p_effective_date =>p_effective_date
270: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
271: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
272: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2

Line 273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id

269: ,p_effective_date =>p_effective_date
270: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
271: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
272: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3

Line 274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category

270: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
271: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
272: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4

Line 275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1

271: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
272: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5

Line 276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2

272: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6

Line 277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3

273: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7

Line 278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4

274: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8

Line 279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5

275: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9

Line 280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6

276: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10

Line 281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7

277: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11

Line 282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8

278: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12

Line 283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9

279: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13

Line 284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10

280: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14

Line 285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11

281: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15

Line 286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12

282: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16

Line 287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13

283: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17

Line 288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14

284: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18

Line 289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15

285: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19

Line 290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16

286: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20

Line 291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17

287: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21

Line 292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18

288: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22

Line 293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19

289: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23

Line 294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20

290: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24

Line 295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21

291: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25

Line 296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22

292: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26

Line 297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23

293: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27

Line 298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24

294: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28

Line 299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25

295: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29

Line 300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26

296: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30

Line 301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27

297: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id

Line 302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28

298: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id

Line 303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29

299: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
307: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id

Line 304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30

300: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
307: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
308: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date

Line 305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id

301: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
307: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
308: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
309: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number

Line 306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id

302: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
307: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
308: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
309: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number
310: );

Line 307: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id

303: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
307: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
308: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
309: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number
310: );
311: --

Line 308: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date

304: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
307: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
308: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
309: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number
310: );
311: --
312: exception

Line 309: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number

305: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
306: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
307: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
308: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
309: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number
310: );
311: --
312: exception
313: --

Line 371: Procedure convert_defs(p_rec in out nocopy ben_erc_shd.g_rec_type) is

367: -- Internal Row Handler Use Only.
368: --
369: -- {End Of Comments}
370: -- ----------------------------------------------------------------------------
371: Procedure convert_defs(p_rec in out nocopy ben_erc_shd.g_rec_type) is
372: --
373: l_proc varchar2(72) := g_package||'convert_defs';
374: --
375: Begin

Line 386: ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd;

382: -- is being used then we must set to the 'current' argument value.
383: --
384: If (p_rec.enrt_ctfn_typ_cd = hr_api.g_varchar2) then
385: p_rec.enrt_ctfn_typ_cd :=
386: ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd;
387: End If;
388: If (p_rec.rqd_flag = hr_api.g_varchar2) then
389: p_rec.rqd_flag :=
390: ben_erc_shd.g_old_rec.rqd_flag;

Line 390: ben_erc_shd.g_old_rec.rqd_flag;

386: ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd;
387: End If;
388: If (p_rec.rqd_flag = hr_api.g_varchar2) then
389: p_rec.rqd_flag :=
390: ben_erc_shd.g_old_rec.rqd_flag;
391: End If;
392: If (p_rec.enrt_rt_id = hr_api.g_number) then
393: p_rec.enrt_rt_id :=
394: ben_erc_shd.g_old_rec.enrt_rt_id;

Line 394: ben_erc_shd.g_old_rec.enrt_rt_id;

390: ben_erc_shd.g_old_rec.rqd_flag;
391: End If;
392: If (p_rec.enrt_rt_id = hr_api.g_number) then
393: p_rec.enrt_rt_id :=
394: ben_erc_shd.g_old_rec.enrt_rt_id;
395: End If;
396: If (p_rec.business_group_id = hr_api.g_number) then
397: p_rec.business_group_id :=
398: ben_erc_shd.g_old_rec.business_group_id;

Line 398: ben_erc_shd.g_old_rec.business_group_id;

394: ben_erc_shd.g_old_rec.enrt_rt_id;
395: End If;
396: If (p_rec.business_group_id = hr_api.g_number) then
397: p_rec.business_group_id :=
398: ben_erc_shd.g_old_rec.business_group_id;
399: End If;
400: If (p_rec.erc_attribute_category = hr_api.g_varchar2) then
401: p_rec.erc_attribute_category :=
402: ben_erc_shd.g_old_rec.erc_attribute_category;

Line 402: ben_erc_shd.g_old_rec.erc_attribute_category;

398: ben_erc_shd.g_old_rec.business_group_id;
399: End If;
400: If (p_rec.erc_attribute_category = hr_api.g_varchar2) then
401: p_rec.erc_attribute_category :=
402: ben_erc_shd.g_old_rec.erc_attribute_category;
403: End If;
404: If (p_rec.erc_attribute1 = hr_api.g_varchar2) then
405: p_rec.erc_attribute1 :=
406: ben_erc_shd.g_old_rec.erc_attribute1;

Line 406: ben_erc_shd.g_old_rec.erc_attribute1;

402: ben_erc_shd.g_old_rec.erc_attribute_category;
403: End If;
404: If (p_rec.erc_attribute1 = hr_api.g_varchar2) then
405: p_rec.erc_attribute1 :=
406: ben_erc_shd.g_old_rec.erc_attribute1;
407: End If;
408: If (p_rec.erc_attribute2 = hr_api.g_varchar2) then
409: p_rec.erc_attribute2 :=
410: ben_erc_shd.g_old_rec.erc_attribute2;

Line 410: ben_erc_shd.g_old_rec.erc_attribute2;

406: ben_erc_shd.g_old_rec.erc_attribute1;
407: End If;
408: If (p_rec.erc_attribute2 = hr_api.g_varchar2) then
409: p_rec.erc_attribute2 :=
410: ben_erc_shd.g_old_rec.erc_attribute2;
411: End If;
412: If (p_rec.erc_attribute3 = hr_api.g_varchar2) then
413: p_rec.erc_attribute3 :=
414: ben_erc_shd.g_old_rec.erc_attribute3;

Line 414: ben_erc_shd.g_old_rec.erc_attribute3;

410: ben_erc_shd.g_old_rec.erc_attribute2;
411: End If;
412: If (p_rec.erc_attribute3 = hr_api.g_varchar2) then
413: p_rec.erc_attribute3 :=
414: ben_erc_shd.g_old_rec.erc_attribute3;
415: End If;
416: If (p_rec.erc_attribute4 = hr_api.g_varchar2) then
417: p_rec.erc_attribute4 :=
418: ben_erc_shd.g_old_rec.erc_attribute4;

Line 418: ben_erc_shd.g_old_rec.erc_attribute4;

414: ben_erc_shd.g_old_rec.erc_attribute3;
415: End If;
416: If (p_rec.erc_attribute4 = hr_api.g_varchar2) then
417: p_rec.erc_attribute4 :=
418: ben_erc_shd.g_old_rec.erc_attribute4;
419: End If;
420: If (p_rec.erc_attribute5 = hr_api.g_varchar2) then
421: p_rec.erc_attribute5 :=
422: ben_erc_shd.g_old_rec.erc_attribute5;

Line 422: ben_erc_shd.g_old_rec.erc_attribute5;

418: ben_erc_shd.g_old_rec.erc_attribute4;
419: End If;
420: If (p_rec.erc_attribute5 = hr_api.g_varchar2) then
421: p_rec.erc_attribute5 :=
422: ben_erc_shd.g_old_rec.erc_attribute5;
423: End If;
424: If (p_rec.erc_attribute6 = hr_api.g_varchar2) then
425: p_rec.erc_attribute6 :=
426: ben_erc_shd.g_old_rec.erc_attribute6;

Line 426: ben_erc_shd.g_old_rec.erc_attribute6;

422: ben_erc_shd.g_old_rec.erc_attribute5;
423: End If;
424: If (p_rec.erc_attribute6 = hr_api.g_varchar2) then
425: p_rec.erc_attribute6 :=
426: ben_erc_shd.g_old_rec.erc_attribute6;
427: End If;
428: If (p_rec.erc_attribute7 = hr_api.g_varchar2) then
429: p_rec.erc_attribute7 :=
430: ben_erc_shd.g_old_rec.erc_attribute7;

Line 430: ben_erc_shd.g_old_rec.erc_attribute7;

426: ben_erc_shd.g_old_rec.erc_attribute6;
427: End If;
428: If (p_rec.erc_attribute7 = hr_api.g_varchar2) then
429: p_rec.erc_attribute7 :=
430: ben_erc_shd.g_old_rec.erc_attribute7;
431: End If;
432: If (p_rec.erc_attribute8 = hr_api.g_varchar2) then
433: p_rec.erc_attribute8 :=
434: ben_erc_shd.g_old_rec.erc_attribute8;

Line 434: ben_erc_shd.g_old_rec.erc_attribute8;

430: ben_erc_shd.g_old_rec.erc_attribute7;
431: End If;
432: If (p_rec.erc_attribute8 = hr_api.g_varchar2) then
433: p_rec.erc_attribute8 :=
434: ben_erc_shd.g_old_rec.erc_attribute8;
435: End If;
436: If (p_rec.erc_attribute9 = hr_api.g_varchar2) then
437: p_rec.erc_attribute9 :=
438: ben_erc_shd.g_old_rec.erc_attribute9;

Line 438: ben_erc_shd.g_old_rec.erc_attribute9;

434: ben_erc_shd.g_old_rec.erc_attribute8;
435: End If;
436: If (p_rec.erc_attribute9 = hr_api.g_varchar2) then
437: p_rec.erc_attribute9 :=
438: ben_erc_shd.g_old_rec.erc_attribute9;
439: End If;
440: If (p_rec.erc_attribute10 = hr_api.g_varchar2) then
441: p_rec.erc_attribute10 :=
442: ben_erc_shd.g_old_rec.erc_attribute10;

Line 442: ben_erc_shd.g_old_rec.erc_attribute10;

438: ben_erc_shd.g_old_rec.erc_attribute9;
439: End If;
440: If (p_rec.erc_attribute10 = hr_api.g_varchar2) then
441: p_rec.erc_attribute10 :=
442: ben_erc_shd.g_old_rec.erc_attribute10;
443: End If;
444: If (p_rec.erc_attribute11 = hr_api.g_varchar2) then
445: p_rec.erc_attribute11 :=
446: ben_erc_shd.g_old_rec.erc_attribute11;

Line 446: ben_erc_shd.g_old_rec.erc_attribute11;

442: ben_erc_shd.g_old_rec.erc_attribute10;
443: End If;
444: If (p_rec.erc_attribute11 = hr_api.g_varchar2) then
445: p_rec.erc_attribute11 :=
446: ben_erc_shd.g_old_rec.erc_attribute11;
447: End If;
448: If (p_rec.erc_attribute12 = hr_api.g_varchar2) then
449: p_rec.erc_attribute12 :=
450: ben_erc_shd.g_old_rec.erc_attribute12;

Line 450: ben_erc_shd.g_old_rec.erc_attribute12;

446: ben_erc_shd.g_old_rec.erc_attribute11;
447: End If;
448: If (p_rec.erc_attribute12 = hr_api.g_varchar2) then
449: p_rec.erc_attribute12 :=
450: ben_erc_shd.g_old_rec.erc_attribute12;
451: End If;
452: If (p_rec.erc_attribute13 = hr_api.g_varchar2) then
453: p_rec.erc_attribute13 :=
454: ben_erc_shd.g_old_rec.erc_attribute13;

Line 454: ben_erc_shd.g_old_rec.erc_attribute13;

450: ben_erc_shd.g_old_rec.erc_attribute12;
451: End If;
452: If (p_rec.erc_attribute13 = hr_api.g_varchar2) then
453: p_rec.erc_attribute13 :=
454: ben_erc_shd.g_old_rec.erc_attribute13;
455: End If;
456: If (p_rec.erc_attribute14 = hr_api.g_varchar2) then
457: p_rec.erc_attribute14 :=
458: ben_erc_shd.g_old_rec.erc_attribute14;

Line 458: ben_erc_shd.g_old_rec.erc_attribute14;

454: ben_erc_shd.g_old_rec.erc_attribute13;
455: End If;
456: If (p_rec.erc_attribute14 = hr_api.g_varchar2) then
457: p_rec.erc_attribute14 :=
458: ben_erc_shd.g_old_rec.erc_attribute14;
459: End If;
460: If (p_rec.erc_attribute15 = hr_api.g_varchar2) then
461: p_rec.erc_attribute15 :=
462: ben_erc_shd.g_old_rec.erc_attribute15;

Line 462: ben_erc_shd.g_old_rec.erc_attribute15;

458: ben_erc_shd.g_old_rec.erc_attribute14;
459: End If;
460: If (p_rec.erc_attribute15 = hr_api.g_varchar2) then
461: p_rec.erc_attribute15 :=
462: ben_erc_shd.g_old_rec.erc_attribute15;
463: End If;
464: If (p_rec.erc_attribute16 = hr_api.g_varchar2) then
465: p_rec.erc_attribute16 :=
466: ben_erc_shd.g_old_rec.erc_attribute16;

Line 466: ben_erc_shd.g_old_rec.erc_attribute16;

462: ben_erc_shd.g_old_rec.erc_attribute15;
463: End If;
464: If (p_rec.erc_attribute16 = hr_api.g_varchar2) then
465: p_rec.erc_attribute16 :=
466: ben_erc_shd.g_old_rec.erc_attribute16;
467: End If;
468: If (p_rec.erc_attribute17 = hr_api.g_varchar2) then
469: p_rec.erc_attribute17 :=
470: ben_erc_shd.g_old_rec.erc_attribute17;

Line 470: ben_erc_shd.g_old_rec.erc_attribute17;

466: ben_erc_shd.g_old_rec.erc_attribute16;
467: End If;
468: If (p_rec.erc_attribute17 = hr_api.g_varchar2) then
469: p_rec.erc_attribute17 :=
470: ben_erc_shd.g_old_rec.erc_attribute17;
471: End If;
472: If (p_rec.erc_attribute18 = hr_api.g_varchar2) then
473: p_rec.erc_attribute18 :=
474: ben_erc_shd.g_old_rec.erc_attribute18;

Line 474: ben_erc_shd.g_old_rec.erc_attribute18;

470: ben_erc_shd.g_old_rec.erc_attribute17;
471: End If;
472: If (p_rec.erc_attribute18 = hr_api.g_varchar2) then
473: p_rec.erc_attribute18 :=
474: ben_erc_shd.g_old_rec.erc_attribute18;
475: End If;
476: If (p_rec.erc_attribute19 = hr_api.g_varchar2) then
477: p_rec.erc_attribute19 :=
478: ben_erc_shd.g_old_rec.erc_attribute19;

Line 478: ben_erc_shd.g_old_rec.erc_attribute19;

474: ben_erc_shd.g_old_rec.erc_attribute18;
475: End If;
476: If (p_rec.erc_attribute19 = hr_api.g_varchar2) then
477: p_rec.erc_attribute19 :=
478: ben_erc_shd.g_old_rec.erc_attribute19;
479: End If;
480: If (p_rec.erc_attribute20 = hr_api.g_varchar2) then
481: p_rec.erc_attribute20 :=
482: ben_erc_shd.g_old_rec.erc_attribute20;

Line 482: ben_erc_shd.g_old_rec.erc_attribute20;

478: ben_erc_shd.g_old_rec.erc_attribute19;
479: End If;
480: If (p_rec.erc_attribute20 = hr_api.g_varchar2) then
481: p_rec.erc_attribute20 :=
482: ben_erc_shd.g_old_rec.erc_attribute20;
483: End If;
484: If (p_rec.erc_attribute21 = hr_api.g_varchar2) then
485: p_rec.erc_attribute21 :=
486: ben_erc_shd.g_old_rec.erc_attribute21;

Line 486: ben_erc_shd.g_old_rec.erc_attribute21;

482: ben_erc_shd.g_old_rec.erc_attribute20;
483: End If;
484: If (p_rec.erc_attribute21 = hr_api.g_varchar2) then
485: p_rec.erc_attribute21 :=
486: ben_erc_shd.g_old_rec.erc_attribute21;
487: End If;
488: If (p_rec.erc_attribute22 = hr_api.g_varchar2) then
489: p_rec.erc_attribute22 :=
490: ben_erc_shd.g_old_rec.erc_attribute22;

Line 490: ben_erc_shd.g_old_rec.erc_attribute22;

486: ben_erc_shd.g_old_rec.erc_attribute21;
487: End If;
488: If (p_rec.erc_attribute22 = hr_api.g_varchar2) then
489: p_rec.erc_attribute22 :=
490: ben_erc_shd.g_old_rec.erc_attribute22;
491: End If;
492: If (p_rec.erc_attribute23 = hr_api.g_varchar2) then
493: p_rec.erc_attribute23 :=
494: ben_erc_shd.g_old_rec.erc_attribute23;

Line 494: ben_erc_shd.g_old_rec.erc_attribute23;

490: ben_erc_shd.g_old_rec.erc_attribute22;
491: End If;
492: If (p_rec.erc_attribute23 = hr_api.g_varchar2) then
493: p_rec.erc_attribute23 :=
494: ben_erc_shd.g_old_rec.erc_attribute23;
495: End If;
496: If (p_rec.erc_attribute24 = hr_api.g_varchar2) then
497: p_rec.erc_attribute24 :=
498: ben_erc_shd.g_old_rec.erc_attribute24;

Line 498: ben_erc_shd.g_old_rec.erc_attribute24;

494: ben_erc_shd.g_old_rec.erc_attribute23;
495: End If;
496: If (p_rec.erc_attribute24 = hr_api.g_varchar2) then
497: p_rec.erc_attribute24 :=
498: ben_erc_shd.g_old_rec.erc_attribute24;
499: End If;
500: If (p_rec.erc_attribute25 = hr_api.g_varchar2) then
501: p_rec.erc_attribute25 :=
502: ben_erc_shd.g_old_rec.erc_attribute25;

Line 502: ben_erc_shd.g_old_rec.erc_attribute25;

498: ben_erc_shd.g_old_rec.erc_attribute24;
499: End If;
500: If (p_rec.erc_attribute25 = hr_api.g_varchar2) then
501: p_rec.erc_attribute25 :=
502: ben_erc_shd.g_old_rec.erc_attribute25;
503: End If;
504: If (p_rec.erc_attribute26 = hr_api.g_varchar2) then
505: p_rec.erc_attribute26 :=
506: ben_erc_shd.g_old_rec.erc_attribute26;

Line 506: ben_erc_shd.g_old_rec.erc_attribute26;

502: ben_erc_shd.g_old_rec.erc_attribute25;
503: End If;
504: If (p_rec.erc_attribute26 = hr_api.g_varchar2) then
505: p_rec.erc_attribute26 :=
506: ben_erc_shd.g_old_rec.erc_attribute26;
507: End If;
508: If (p_rec.erc_attribute27 = hr_api.g_varchar2) then
509: p_rec.erc_attribute27 :=
510: ben_erc_shd.g_old_rec.erc_attribute27;

Line 510: ben_erc_shd.g_old_rec.erc_attribute27;

506: ben_erc_shd.g_old_rec.erc_attribute26;
507: End If;
508: If (p_rec.erc_attribute27 = hr_api.g_varchar2) then
509: p_rec.erc_attribute27 :=
510: ben_erc_shd.g_old_rec.erc_attribute27;
511: End If;
512: If (p_rec.erc_attribute28 = hr_api.g_varchar2) then
513: p_rec.erc_attribute28 :=
514: ben_erc_shd.g_old_rec.erc_attribute28;

Line 514: ben_erc_shd.g_old_rec.erc_attribute28;

510: ben_erc_shd.g_old_rec.erc_attribute27;
511: End If;
512: If (p_rec.erc_attribute28 = hr_api.g_varchar2) then
513: p_rec.erc_attribute28 :=
514: ben_erc_shd.g_old_rec.erc_attribute28;
515: End If;
516: If (p_rec.erc_attribute29 = hr_api.g_varchar2) then
517: p_rec.erc_attribute29 :=
518: ben_erc_shd.g_old_rec.erc_attribute29;

Line 518: ben_erc_shd.g_old_rec.erc_attribute29;

514: ben_erc_shd.g_old_rec.erc_attribute28;
515: End If;
516: If (p_rec.erc_attribute29 = hr_api.g_varchar2) then
517: p_rec.erc_attribute29 :=
518: ben_erc_shd.g_old_rec.erc_attribute29;
519: End If;
520: If (p_rec.erc_attribute30 = hr_api.g_varchar2) then
521: p_rec.erc_attribute30 :=
522: ben_erc_shd.g_old_rec.erc_attribute30;

Line 522: ben_erc_shd.g_old_rec.erc_attribute30;

518: ben_erc_shd.g_old_rec.erc_attribute29;
519: End If;
520: If (p_rec.erc_attribute30 = hr_api.g_varchar2) then
521: p_rec.erc_attribute30 :=
522: ben_erc_shd.g_old_rec.erc_attribute30;
523: End If;
524: If (p_rec.request_id = hr_api.g_number) then
525: p_rec.request_id :=
526: ben_erc_shd.g_old_rec.request_id;

Line 526: ben_erc_shd.g_old_rec.request_id;

522: ben_erc_shd.g_old_rec.erc_attribute30;
523: End If;
524: If (p_rec.request_id = hr_api.g_number) then
525: p_rec.request_id :=
526: ben_erc_shd.g_old_rec.request_id;
527: End If;
528: If (p_rec.program_application_id = hr_api.g_number) then
529: p_rec.program_application_id :=
530: ben_erc_shd.g_old_rec.program_application_id;

Line 530: ben_erc_shd.g_old_rec.program_application_id;

526: ben_erc_shd.g_old_rec.request_id;
527: End If;
528: If (p_rec.program_application_id = hr_api.g_number) then
529: p_rec.program_application_id :=
530: ben_erc_shd.g_old_rec.program_application_id;
531: End If;
532: If (p_rec.program_id = hr_api.g_number) then
533: p_rec.program_id :=
534: ben_erc_shd.g_old_rec.program_id;

Line 534: ben_erc_shd.g_old_rec.program_id;

530: ben_erc_shd.g_old_rec.program_application_id;
531: End If;
532: If (p_rec.program_id = hr_api.g_number) then
533: p_rec.program_id :=
534: ben_erc_shd.g_old_rec.program_id;
535: End If;
536: If (p_rec.program_update_date = hr_api.g_date) then
537: p_rec.program_update_date :=
538: ben_erc_shd.g_old_rec.program_update_date;

Line 538: ben_erc_shd.g_old_rec.program_update_date;

534: ben_erc_shd.g_old_rec.program_id;
535: End If;
536: If (p_rec.program_update_date = hr_api.g_date) then
537: p_rec.program_update_date :=
538: ben_erc_shd.g_old_rec.program_update_date;
539: End If;
540:
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 552: p_rec in out nocopy ben_erc_shd.g_rec_type

548: -- ----------------------------------------------------------------------------
549: Procedure upd
550: (
551: p_effective_date in date,
552: p_rec in out nocopy ben_erc_shd.g_rec_type
553: ) is
554: --
555: l_proc varchar2(72) := g_package||'upd';
556: --

Line 562: ben_erc_shd.lck

558: hr_utility.set_location('Entering:'||l_proc, 5);
559: --
560: -- We must lock the row which we need to update.
561: --
562: ben_erc_shd.lck
563: (
564: p_rec.enrt_rt_ctfn_id,
565: p_rec.object_version_number
566: );

Line 641: l_rec ben_erc_shd.g_rec_type;

637: p_program_update_date in date default hr_api.g_date,
638: p_object_version_number in out nocopy number
639: ) is
640: --
641: l_rec ben_erc_shd.g_rec_type;
642: l_proc varchar2(72) := g_package||'upd';
643: --
644: Begin
645: hr_utility.set_location('Entering:'||l_proc, 5);

Line 651: ben_erc_shd.convert_args

647: -- Call conversion function to turn arguments into the
648: -- l_rec structure.
649: --
650: l_rec :=
651: ben_erc_shd.convert_args
652: (
653: p_enrt_rt_ctfn_id,
654: p_enrt_ctfn_typ_cd,
655: p_rqd_flag,