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_EPR_UPD dependencies on BEN_EPR_SHD

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

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

Line 116: ben_epr_shd.g_api_dml := false; -- Unset the api dml status

112: program_id = p_rec.program_id,
113: program_update_date = p_rec.program_update_date
114: where enrt_prem_id = p_rec.enrt_prem_id;
115: --
116: ben_epr_shd.g_api_dml := false; -- Unset the api dml status
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: --
120: Exception

Line 123: ben_epr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 124: ben_epr_shd.constraint_error

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

Line 128: ben_epr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 129: ben_epr_shd.constraint_error

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

Line 133: ben_epr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 134: ben_epr_shd.constraint_error

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

Line 137: ben_epr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 173: Procedure pre_update(p_rec in ben_epr_shd.g_rec_type) is

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

Line 215: Procedure post_update(p_rec in ben_epr_shd.g_rec_type) is

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

Line 272: ,p_val_o =>ben_epr_shd.g_old_rec.val

268: ,p_request_id =>p_rec.request_id
269: ,p_program_application_id =>p_rec.program_application_id
270: ,p_program_id =>p_rec.program_id
271: ,p_program_update_date =>p_rec.program_update_date
272: ,p_val_o =>ben_epr_shd.g_old_rec.val
273: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
274: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id

Line 273: ,p_uom_o =>ben_epr_shd.g_old_rec.uom

269: ,p_program_application_id =>p_rec.program_application_id
270: ,p_program_id =>p_rec.program_id
271: ,p_program_update_date =>p_rec.program_update_date
272: ,p_val_o =>ben_epr_shd.g_old_rec.val
273: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
274: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id

Line 274: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id

270: ,p_program_id =>p_rec.program_id
271: ,p_program_update_date =>p_rec.program_update_date
272: ,p_val_o =>ben_epr_shd.g_old_rec.val
273: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
274: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category

Line 275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id

271: ,p_program_update_date =>p_rec.program_update_date
272: ,p_val_o =>ben_epr_shd.g_old_rec.val
273: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
274: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1

Line 276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id

272: ,p_val_o =>ben_epr_shd.g_old_rec.val
273: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
274: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2

Line 277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id

273: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
274: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3

Line 278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category

274: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4

Line 279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1

275: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5

Line 280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2

276: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6

Line 281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3

277: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7

Line 282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4

278: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8

Line 283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5

279: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9

Line 284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6

280: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10

Line 285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7

281: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11

Line 286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8

282: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12

Line 287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9

283: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13

Line 288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10

284: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14

Line 289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11

285: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15

Line 290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12

286: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16

Line 291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13

287: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17

Line 292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14

288: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18

Line 293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15

289: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19

Line 294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16

290: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20

Line 295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17

291: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21

Line 296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18

292: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22

Line 297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19

293: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23

Line 298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20

294: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24

Line 299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21

295: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25

Line 300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22

296: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26

Line 301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23

297: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27

Line 302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24

298: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28

Line 303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25

299: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29

Line 304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26

300: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30

Line 305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27

301: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number

Line 306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28

302: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id

Line 307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29

303: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
311: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id

Line 308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30

304: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
311: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
312: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id

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

305: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
311: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
312: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id
313: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date

Line 310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id

306: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
311: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
312: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id
313: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date
314: );

Line 311: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id

307: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
311: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
312: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id
313: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date
314: );
315: --

Line 312: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id

308: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
311: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
312: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id
313: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date
314: );
315: --
316: exception

Line 313: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date

309: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
310: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
311: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
312: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id
313: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date
314: );
315: --
316: exception
317: --

Line 375: Procedure convert_defs(p_rec in out nocopy ben_epr_shd.g_rec_type) is

371: -- Internal Row Handler Use Only.
372: --
373: -- {End Of Comments}
374: -- ----------------------------------------------------------------------------
375: Procedure convert_defs(p_rec in out nocopy ben_epr_shd.g_rec_type) is
376: --
377: l_proc varchar2(72) := g_package||'convert_defs';
378: --
379: Begin

Line 390: ben_epr_shd.g_old_rec.val;

386: -- is being used then we must set to the 'current' argument value.
387: --
388: If (p_rec.val = hr_api.g_number) then
389: p_rec.val :=
390: ben_epr_shd.g_old_rec.val;
391: End If;
392: If (p_rec.uom = hr_api.g_varchar2) then
393: p_rec.uom :=
394: ben_epr_shd.g_old_rec.uom;

Line 394: ben_epr_shd.g_old_rec.uom;

390: ben_epr_shd.g_old_rec.val;
391: End If;
392: If (p_rec.uom = hr_api.g_varchar2) then
393: p_rec.uom :=
394: ben_epr_shd.g_old_rec.uom;
395: End If;
396: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
397: p_rec.elig_per_elctbl_chc_id :=
398: ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id;

Line 398: ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id;

394: ben_epr_shd.g_old_rec.uom;
395: End If;
396: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
397: p_rec.elig_per_elctbl_chc_id :=
398: ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id;
399: End If;
400: If (p_rec.enrt_bnft_id = hr_api.g_number) then
401: p_rec.enrt_bnft_id :=
402: ben_epr_shd.g_old_rec.enrt_bnft_id;

Line 402: ben_epr_shd.g_old_rec.enrt_bnft_id;

398: ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id;
399: End If;
400: If (p_rec.enrt_bnft_id = hr_api.g_number) then
401: p_rec.enrt_bnft_id :=
402: ben_epr_shd.g_old_rec.enrt_bnft_id;
403: End If;
404: If (p_rec.actl_prem_id = hr_api.g_number) then
405: p_rec.actl_prem_id :=
406: ben_epr_shd.g_old_rec.actl_prem_id;

Line 406: ben_epr_shd.g_old_rec.actl_prem_id;

402: ben_epr_shd.g_old_rec.enrt_bnft_id;
403: End If;
404: If (p_rec.actl_prem_id = hr_api.g_number) then
405: p_rec.actl_prem_id :=
406: ben_epr_shd.g_old_rec.actl_prem_id;
407: End If;
408: If (p_rec.business_group_id = hr_api.g_number) then
409: p_rec.business_group_id :=
410: ben_epr_shd.g_old_rec.business_group_id;

Line 410: ben_epr_shd.g_old_rec.business_group_id;

406: ben_epr_shd.g_old_rec.actl_prem_id;
407: End If;
408: If (p_rec.business_group_id = hr_api.g_number) then
409: p_rec.business_group_id :=
410: ben_epr_shd.g_old_rec.business_group_id;
411: End If;
412: If (p_rec.epr_attribute_category = hr_api.g_varchar2) then
413: p_rec.epr_attribute_category :=
414: ben_epr_shd.g_old_rec.epr_attribute_category;

Line 414: ben_epr_shd.g_old_rec.epr_attribute_category;

410: ben_epr_shd.g_old_rec.business_group_id;
411: End If;
412: If (p_rec.epr_attribute_category = hr_api.g_varchar2) then
413: p_rec.epr_attribute_category :=
414: ben_epr_shd.g_old_rec.epr_attribute_category;
415: End If;
416: If (p_rec.epr_attribute1 = hr_api.g_varchar2) then
417: p_rec.epr_attribute1 :=
418: ben_epr_shd.g_old_rec.epr_attribute1;

Line 418: ben_epr_shd.g_old_rec.epr_attribute1;

414: ben_epr_shd.g_old_rec.epr_attribute_category;
415: End If;
416: If (p_rec.epr_attribute1 = hr_api.g_varchar2) then
417: p_rec.epr_attribute1 :=
418: ben_epr_shd.g_old_rec.epr_attribute1;
419: End If;
420: If (p_rec.epr_attribute2 = hr_api.g_varchar2) then
421: p_rec.epr_attribute2 :=
422: ben_epr_shd.g_old_rec.epr_attribute2;

Line 422: ben_epr_shd.g_old_rec.epr_attribute2;

418: ben_epr_shd.g_old_rec.epr_attribute1;
419: End If;
420: If (p_rec.epr_attribute2 = hr_api.g_varchar2) then
421: p_rec.epr_attribute2 :=
422: ben_epr_shd.g_old_rec.epr_attribute2;
423: End If;
424: If (p_rec.epr_attribute3 = hr_api.g_varchar2) then
425: p_rec.epr_attribute3 :=
426: ben_epr_shd.g_old_rec.epr_attribute3;

Line 426: ben_epr_shd.g_old_rec.epr_attribute3;

422: ben_epr_shd.g_old_rec.epr_attribute2;
423: End If;
424: If (p_rec.epr_attribute3 = hr_api.g_varchar2) then
425: p_rec.epr_attribute3 :=
426: ben_epr_shd.g_old_rec.epr_attribute3;
427: End If;
428: If (p_rec.epr_attribute4 = hr_api.g_varchar2) then
429: p_rec.epr_attribute4 :=
430: ben_epr_shd.g_old_rec.epr_attribute4;

Line 430: ben_epr_shd.g_old_rec.epr_attribute4;

426: ben_epr_shd.g_old_rec.epr_attribute3;
427: End If;
428: If (p_rec.epr_attribute4 = hr_api.g_varchar2) then
429: p_rec.epr_attribute4 :=
430: ben_epr_shd.g_old_rec.epr_attribute4;
431: End If;
432: If (p_rec.epr_attribute5 = hr_api.g_varchar2) then
433: p_rec.epr_attribute5 :=
434: ben_epr_shd.g_old_rec.epr_attribute5;

Line 434: ben_epr_shd.g_old_rec.epr_attribute5;

430: ben_epr_shd.g_old_rec.epr_attribute4;
431: End If;
432: If (p_rec.epr_attribute5 = hr_api.g_varchar2) then
433: p_rec.epr_attribute5 :=
434: ben_epr_shd.g_old_rec.epr_attribute5;
435: End If;
436: If (p_rec.epr_attribute6 = hr_api.g_varchar2) then
437: p_rec.epr_attribute6 :=
438: ben_epr_shd.g_old_rec.epr_attribute6;

Line 438: ben_epr_shd.g_old_rec.epr_attribute6;

434: ben_epr_shd.g_old_rec.epr_attribute5;
435: End If;
436: If (p_rec.epr_attribute6 = hr_api.g_varchar2) then
437: p_rec.epr_attribute6 :=
438: ben_epr_shd.g_old_rec.epr_attribute6;
439: End If;
440: If (p_rec.epr_attribute7 = hr_api.g_varchar2) then
441: p_rec.epr_attribute7 :=
442: ben_epr_shd.g_old_rec.epr_attribute7;

Line 442: ben_epr_shd.g_old_rec.epr_attribute7;

438: ben_epr_shd.g_old_rec.epr_attribute6;
439: End If;
440: If (p_rec.epr_attribute7 = hr_api.g_varchar2) then
441: p_rec.epr_attribute7 :=
442: ben_epr_shd.g_old_rec.epr_attribute7;
443: End If;
444: If (p_rec.epr_attribute8 = hr_api.g_varchar2) then
445: p_rec.epr_attribute8 :=
446: ben_epr_shd.g_old_rec.epr_attribute8;

Line 446: ben_epr_shd.g_old_rec.epr_attribute8;

442: ben_epr_shd.g_old_rec.epr_attribute7;
443: End If;
444: If (p_rec.epr_attribute8 = hr_api.g_varchar2) then
445: p_rec.epr_attribute8 :=
446: ben_epr_shd.g_old_rec.epr_attribute8;
447: End If;
448: If (p_rec.epr_attribute9 = hr_api.g_varchar2) then
449: p_rec.epr_attribute9 :=
450: ben_epr_shd.g_old_rec.epr_attribute9;

Line 450: ben_epr_shd.g_old_rec.epr_attribute9;

446: ben_epr_shd.g_old_rec.epr_attribute8;
447: End If;
448: If (p_rec.epr_attribute9 = hr_api.g_varchar2) then
449: p_rec.epr_attribute9 :=
450: ben_epr_shd.g_old_rec.epr_attribute9;
451: End If;
452: If (p_rec.epr_attribute10 = hr_api.g_varchar2) then
453: p_rec.epr_attribute10 :=
454: ben_epr_shd.g_old_rec.epr_attribute10;

Line 454: ben_epr_shd.g_old_rec.epr_attribute10;

450: ben_epr_shd.g_old_rec.epr_attribute9;
451: End If;
452: If (p_rec.epr_attribute10 = hr_api.g_varchar2) then
453: p_rec.epr_attribute10 :=
454: ben_epr_shd.g_old_rec.epr_attribute10;
455: End If;
456: If (p_rec.epr_attribute11 = hr_api.g_varchar2) then
457: p_rec.epr_attribute11 :=
458: ben_epr_shd.g_old_rec.epr_attribute11;

Line 458: ben_epr_shd.g_old_rec.epr_attribute11;

454: ben_epr_shd.g_old_rec.epr_attribute10;
455: End If;
456: If (p_rec.epr_attribute11 = hr_api.g_varchar2) then
457: p_rec.epr_attribute11 :=
458: ben_epr_shd.g_old_rec.epr_attribute11;
459: End If;
460: If (p_rec.epr_attribute12 = hr_api.g_varchar2) then
461: p_rec.epr_attribute12 :=
462: ben_epr_shd.g_old_rec.epr_attribute12;

Line 462: ben_epr_shd.g_old_rec.epr_attribute12;

458: ben_epr_shd.g_old_rec.epr_attribute11;
459: End If;
460: If (p_rec.epr_attribute12 = hr_api.g_varchar2) then
461: p_rec.epr_attribute12 :=
462: ben_epr_shd.g_old_rec.epr_attribute12;
463: End If;
464: If (p_rec.epr_attribute13 = hr_api.g_varchar2) then
465: p_rec.epr_attribute13 :=
466: ben_epr_shd.g_old_rec.epr_attribute13;

Line 466: ben_epr_shd.g_old_rec.epr_attribute13;

462: ben_epr_shd.g_old_rec.epr_attribute12;
463: End If;
464: If (p_rec.epr_attribute13 = hr_api.g_varchar2) then
465: p_rec.epr_attribute13 :=
466: ben_epr_shd.g_old_rec.epr_attribute13;
467: End If;
468: If (p_rec.epr_attribute14 = hr_api.g_varchar2) then
469: p_rec.epr_attribute14 :=
470: ben_epr_shd.g_old_rec.epr_attribute14;

Line 470: ben_epr_shd.g_old_rec.epr_attribute14;

466: ben_epr_shd.g_old_rec.epr_attribute13;
467: End If;
468: If (p_rec.epr_attribute14 = hr_api.g_varchar2) then
469: p_rec.epr_attribute14 :=
470: ben_epr_shd.g_old_rec.epr_attribute14;
471: End If;
472: If (p_rec.epr_attribute15 = hr_api.g_varchar2) then
473: p_rec.epr_attribute15 :=
474: ben_epr_shd.g_old_rec.epr_attribute15;

Line 474: ben_epr_shd.g_old_rec.epr_attribute15;

470: ben_epr_shd.g_old_rec.epr_attribute14;
471: End If;
472: If (p_rec.epr_attribute15 = hr_api.g_varchar2) then
473: p_rec.epr_attribute15 :=
474: ben_epr_shd.g_old_rec.epr_attribute15;
475: End If;
476: If (p_rec.epr_attribute16 = hr_api.g_varchar2) then
477: p_rec.epr_attribute16 :=
478: ben_epr_shd.g_old_rec.epr_attribute16;

Line 478: ben_epr_shd.g_old_rec.epr_attribute16;

474: ben_epr_shd.g_old_rec.epr_attribute15;
475: End If;
476: If (p_rec.epr_attribute16 = hr_api.g_varchar2) then
477: p_rec.epr_attribute16 :=
478: ben_epr_shd.g_old_rec.epr_attribute16;
479: End If;
480: If (p_rec.epr_attribute17 = hr_api.g_varchar2) then
481: p_rec.epr_attribute17 :=
482: ben_epr_shd.g_old_rec.epr_attribute17;

Line 482: ben_epr_shd.g_old_rec.epr_attribute17;

478: ben_epr_shd.g_old_rec.epr_attribute16;
479: End If;
480: If (p_rec.epr_attribute17 = hr_api.g_varchar2) then
481: p_rec.epr_attribute17 :=
482: ben_epr_shd.g_old_rec.epr_attribute17;
483: End If;
484: If (p_rec.epr_attribute18 = hr_api.g_varchar2) then
485: p_rec.epr_attribute18 :=
486: ben_epr_shd.g_old_rec.epr_attribute18;

Line 486: ben_epr_shd.g_old_rec.epr_attribute18;

482: ben_epr_shd.g_old_rec.epr_attribute17;
483: End If;
484: If (p_rec.epr_attribute18 = hr_api.g_varchar2) then
485: p_rec.epr_attribute18 :=
486: ben_epr_shd.g_old_rec.epr_attribute18;
487: End If;
488: If (p_rec.epr_attribute19 = hr_api.g_varchar2) then
489: p_rec.epr_attribute19 :=
490: ben_epr_shd.g_old_rec.epr_attribute19;

Line 490: ben_epr_shd.g_old_rec.epr_attribute19;

486: ben_epr_shd.g_old_rec.epr_attribute18;
487: End If;
488: If (p_rec.epr_attribute19 = hr_api.g_varchar2) then
489: p_rec.epr_attribute19 :=
490: ben_epr_shd.g_old_rec.epr_attribute19;
491: End If;
492: If (p_rec.epr_attribute20 = hr_api.g_varchar2) then
493: p_rec.epr_attribute20 :=
494: ben_epr_shd.g_old_rec.epr_attribute20;

Line 494: ben_epr_shd.g_old_rec.epr_attribute20;

490: ben_epr_shd.g_old_rec.epr_attribute19;
491: End If;
492: If (p_rec.epr_attribute20 = hr_api.g_varchar2) then
493: p_rec.epr_attribute20 :=
494: ben_epr_shd.g_old_rec.epr_attribute20;
495: End If;
496: If (p_rec.epr_attribute21 = hr_api.g_varchar2) then
497: p_rec.epr_attribute21 :=
498: ben_epr_shd.g_old_rec.epr_attribute21;

Line 498: ben_epr_shd.g_old_rec.epr_attribute21;

494: ben_epr_shd.g_old_rec.epr_attribute20;
495: End If;
496: If (p_rec.epr_attribute21 = hr_api.g_varchar2) then
497: p_rec.epr_attribute21 :=
498: ben_epr_shd.g_old_rec.epr_attribute21;
499: End If;
500: If (p_rec.epr_attribute22 = hr_api.g_varchar2) then
501: p_rec.epr_attribute22 :=
502: ben_epr_shd.g_old_rec.epr_attribute22;

Line 502: ben_epr_shd.g_old_rec.epr_attribute22;

498: ben_epr_shd.g_old_rec.epr_attribute21;
499: End If;
500: If (p_rec.epr_attribute22 = hr_api.g_varchar2) then
501: p_rec.epr_attribute22 :=
502: ben_epr_shd.g_old_rec.epr_attribute22;
503: End If;
504: If (p_rec.epr_attribute23 = hr_api.g_varchar2) then
505: p_rec.epr_attribute23 :=
506: ben_epr_shd.g_old_rec.epr_attribute23;

Line 506: ben_epr_shd.g_old_rec.epr_attribute23;

502: ben_epr_shd.g_old_rec.epr_attribute22;
503: End If;
504: If (p_rec.epr_attribute23 = hr_api.g_varchar2) then
505: p_rec.epr_attribute23 :=
506: ben_epr_shd.g_old_rec.epr_attribute23;
507: End If;
508: If (p_rec.epr_attribute24 = hr_api.g_varchar2) then
509: p_rec.epr_attribute24 :=
510: ben_epr_shd.g_old_rec.epr_attribute24;

Line 510: ben_epr_shd.g_old_rec.epr_attribute24;

506: ben_epr_shd.g_old_rec.epr_attribute23;
507: End If;
508: If (p_rec.epr_attribute24 = hr_api.g_varchar2) then
509: p_rec.epr_attribute24 :=
510: ben_epr_shd.g_old_rec.epr_attribute24;
511: End If;
512: If (p_rec.epr_attribute25 = hr_api.g_varchar2) then
513: p_rec.epr_attribute25 :=
514: ben_epr_shd.g_old_rec.epr_attribute25;

Line 514: ben_epr_shd.g_old_rec.epr_attribute25;

510: ben_epr_shd.g_old_rec.epr_attribute24;
511: End If;
512: If (p_rec.epr_attribute25 = hr_api.g_varchar2) then
513: p_rec.epr_attribute25 :=
514: ben_epr_shd.g_old_rec.epr_attribute25;
515: End If;
516: If (p_rec.epr_attribute26 = hr_api.g_varchar2) then
517: p_rec.epr_attribute26 :=
518: ben_epr_shd.g_old_rec.epr_attribute26;

Line 518: ben_epr_shd.g_old_rec.epr_attribute26;

514: ben_epr_shd.g_old_rec.epr_attribute25;
515: End If;
516: If (p_rec.epr_attribute26 = hr_api.g_varchar2) then
517: p_rec.epr_attribute26 :=
518: ben_epr_shd.g_old_rec.epr_attribute26;
519: End If;
520: If (p_rec.epr_attribute27 = hr_api.g_varchar2) then
521: p_rec.epr_attribute27 :=
522: ben_epr_shd.g_old_rec.epr_attribute27;

Line 522: ben_epr_shd.g_old_rec.epr_attribute27;

518: ben_epr_shd.g_old_rec.epr_attribute26;
519: End If;
520: If (p_rec.epr_attribute27 = hr_api.g_varchar2) then
521: p_rec.epr_attribute27 :=
522: ben_epr_shd.g_old_rec.epr_attribute27;
523: End If;
524: If (p_rec.epr_attribute28 = hr_api.g_varchar2) then
525: p_rec.epr_attribute28 :=
526: ben_epr_shd.g_old_rec.epr_attribute28;

Line 526: ben_epr_shd.g_old_rec.epr_attribute28;

522: ben_epr_shd.g_old_rec.epr_attribute27;
523: End If;
524: If (p_rec.epr_attribute28 = hr_api.g_varchar2) then
525: p_rec.epr_attribute28 :=
526: ben_epr_shd.g_old_rec.epr_attribute28;
527: End If;
528: If (p_rec.epr_attribute29 = hr_api.g_varchar2) then
529: p_rec.epr_attribute29 :=
530: ben_epr_shd.g_old_rec.epr_attribute29;

Line 530: ben_epr_shd.g_old_rec.epr_attribute29;

526: ben_epr_shd.g_old_rec.epr_attribute28;
527: End If;
528: If (p_rec.epr_attribute29 = hr_api.g_varchar2) then
529: p_rec.epr_attribute29 :=
530: ben_epr_shd.g_old_rec.epr_attribute29;
531: End If;
532: If (p_rec.epr_attribute30 = hr_api.g_varchar2) then
533: p_rec.epr_attribute30 :=
534: ben_epr_shd.g_old_rec.epr_attribute30;

Line 534: ben_epr_shd.g_old_rec.epr_attribute30;

530: ben_epr_shd.g_old_rec.epr_attribute29;
531: End If;
532: If (p_rec.epr_attribute30 = hr_api.g_varchar2) then
533: p_rec.epr_attribute30 :=
534: ben_epr_shd.g_old_rec.epr_attribute30;
535: End If;
536: If (p_rec.request_id = hr_api.g_number) then
537: p_rec.request_id :=
538: ben_epr_shd.g_old_rec.request_id;

Line 538: ben_epr_shd.g_old_rec.request_id;

534: ben_epr_shd.g_old_rec.epr_attribute30;
535: End If;
536: If (p_rec.request_id = hr_api.g_number) then
537: p_rec.request_id :=
538: ben_epr_shd.g_old_rec.request_id;
539: End If;
540: If (p_rec.program_application_id = hr_api.g_number) then
541: p_rec.program_application_id :=
542: ben_epr_shd.g_old_rec.program_application_id;

Line 542: ben_epr_shd.g_old_rec.program_application_id;

538: ben_epr_shd.g_old_rec.request_id;
539: End If;
540: If (p_rec.program_application_id = hr_api.g_number) then
541: p_rec.program_application_id :=
542: ben_epr_shd.g_old_rec.program_application_id;
543: End If;
544: If (p_rec.program_id = hr_api.g_number) then
545: p_rec.program_id :=
546: ben_epr_shd.g_old_rec.program_id;

Line 546: ben_epr_shd.g_old_rec.program_id;

542: ben_epr_shd.g_old_rec.program_application_id;
543: End If;
544: If (p_rec.program_id = hr_api.g_number) then
545: p_rec.program_id :=
546: ben_epr_shd.g_old_rec.program_id;
547: End If;
548: If (p_rec.program_update_date = hr_api.g_date) then
549: p_rec.program_update_date :=
550: ben_epr_shd.g_old_rec.program_update_date;

Line 550: ben_epr_shd.g_old_rec.program_update_date;

546: ben_epr_shd.g_old_rec.program_id;
547: End If;
548: If (p_rec.program_update_date = hr_api.g_date) then
549: p_rec.program_update_date :=
550: ben_epr_shd.g_old_rec.program_update_date;
551: End If;
552: --
553: hr_utility.set_location(' Leaving:'||l_proc, 10);
554: --

Line 562: p_rec in out nocopy ben_epr_shd.g_rec_type

558: -- |---------------------------------< upd >----------------------------------|
559: -- ----------------------------------------------------------------------------
560: Procedure upd
561: (
562: p_rec in out nocopy ben_epr_shd.g_rec_type
563: ) is
564: --
565: l_proc varchar2(72) := g_package||'upd';
566: --

Line 572: ben_epr_shd.lck

568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- We must lock the row which we need to update.
571: --
572: ben_epr_shd.lck
573: (
574: p_rec.enrt_prem_id,
575: p_rec.object_version_number
576: );

Line 650: l_rec ben_epr_shd.g_rec_type;

646: p_program_id in number default hr_api.g_number,
647: p_program_update_date in date default hr_api.g_date
648: ) is
649: --
650: l_rec ben_epr_shd.g_rec_type;
651: l_proc varchar2(72) := g_package||'upd';
652: --
653: Begin
654: hr_utility.set_location('Entering:'||l_proc, 5);

Line 660: ben_epr_shd.convert_args

656: -- Call conversion function to turn arguments into the
657: -- l_rec structure.
658: --
659: l_rec :=
660: ben_epr_shd.convert_args
661: (
662: p_enrt_prem_id,
663: p_val,
664: p_uom,