DBA Data[Home] [Help]

APPS.BEN_BNR_UPD dependencies on BEN_BNR_SHD

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

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

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

121: source_lang = userenv('LANG')
122: where rptg_grp_id = p_rec.rptg_grp_id
123: and userenv('LANG') in (language, source_lang);
124:
125: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception

Line 132: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status

128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
133: ben_bnr_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated

Line 133: ben_bnr_shd.constraint_error

129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
133: ben_bnr_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status

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

133: ben_bnr_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
138: ben_bnr_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated

Line 138: ben_bnr_shd.constraint_error

134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
138: ben_bnr_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status

Line 142: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status

138: ben_bnr_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
143: ben_bnr_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status

Line 143: ben_bnr_shd.constraint_error

139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
143: ben_bnr_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;

Line 146: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status

142: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
143: ben_bnr_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: End update_dml;
149: --
150: -- ----------------------------------------------------------------------------

Line 182: Procedure pre_update(p_rec in ben_bnr_shd.g_rec_type) is

178: -- Internal Row Handler Use Only.
179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure pre_update(p_rec in ben_bnr_shd.g_rec_type) is
183: --
184: l_proc varchar2(72) := g_package||'pre_update';
185: --
186: Begin

Line 225: p_effective_date in date,p_rec in ben_bnr_shd.g_rec_type) is

221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure post_update(
225: p_effective_date in date,p_rec in ben_bnr_shd.g_rec_type) is
226: --
227: l_proc varchar2(72) := g_package||'post_update';
228: --
229: Begin

Line 280: ,p_name_o =>ben_bnr_shd.g_old_rec.name

276: ,p_legislation_code =>p_rec.legislation_code
277: ,p_object_version_number =>p_rec.object_version_number
278: ,p_ordr_num =>p_rec.ordr_num --iRec
279: ,p_effective_date =>p_effective_date
280: ,p_name_o =>ben_bnr_shd.g_old_rec.name
281: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
282: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category

Line 281: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id

277: ,p_object_version_number =>p_rec.object_version_number
278: ,p_ordr_num =>p_rec.ordr_num --iRec
279: ,p_effective_date =>p_effective_date
280: ,p_name_o =>ben_bnr_shd.g_old_rec.name
281: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
282: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1

Line 282: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd

278: ,p_ordr_num =>p_rec.ordr_num --iRec
279: ,p_effective_date =>p_effective_date
280: ,p_name_o =>ben_bnr_shd.g_old_rec.name
281: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
282: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2

Line 283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc

279: ,p_effective_date =>p_effective_date
280: ,p_name_o =>ben_bnr_shd.g_old_rec.name
281: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
282: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3

Line 284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category

280: ,p_name_o =>ben_bnr_shd.g_old_rec.name
281: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
282: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4

Line 285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1

281: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
282: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5

Line 286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2

282: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6

Line 287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3

283: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7

Line 288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4

284: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8

Line 289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5

285: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9

Line 290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6

286: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10

Line 291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7

287: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11

Line 292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8

288: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12

Line 293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9

289: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13

Line 294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10

290: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14

Line 295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11

291: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15

Line 296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12

292: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16

Line 297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13

293: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17

Line 298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14

294: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18

Line 299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15

295: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19

Line 300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16

296: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20

Line 301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17

297: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21

Line 302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18

298: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22

Line 303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19

299: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23

Line 304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20

300: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24

Line 305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21

301: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25

Line 306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22

302: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26

Line 307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23

303: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27

Line 308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24

304: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28

Line 309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25

305: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29

Line 310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26

306: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30

Line 311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27

307: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code

Line 312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28

308: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
316: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code

Line 313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29

309: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
316: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
317: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number

Line 314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30

310: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
316: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
317: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
318: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec

Line 315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code

311: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
316: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
317: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
318: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec
319: );

Line 316: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code

312: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
316: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
317: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
318: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec
319: );
320: --

Line 317: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number

313: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
316: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
317: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
318: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec
319: );
320: --
321: exception

Line 318: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec

314: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
315: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
316: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
317: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
318: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec
319: );
320: --
321: exception
322: --

Line 380: Procedure convert_defs(p_rec in out nocopy ben_bnr_shd.g_rec_type) is

376: -- Internal Row Handler Use Only.
377: --
378: -- {End Of Comments}
379: -- ----------------------------------------------------------------------------
380: Procedure convert_defs(p_rec in out nocopy ben_bnr_shd.g_rec_type) is
381: --
382: l_proc varchar2(72) := g_package||'convert_defs';
383: --
384: Begin

Line 395: ben_bnr_shd.g_old_rec.name;

391: -- is being used then we must set to the 'current' argument value.
392: --
393: If (p_rec.name = hr_api.g_varchar2) then
394: p_rec.name :=
395: ben_bnr_shd.g_old_rec.name;
396: End If;
397: If (p_rec.business_group_id = hr_api.g_number) then
398: p_rec.business_group_id :=
399: ben_bnr_shd.g_old_rec.business_group_id;

Line 399: ben_bnr_shd.g_old_rec.business_group_id;

395: ben_bnr_shd.g_old_rec.name;
396: End If;
397: If (p_rec.business_group_id = hr_api.g_number) then
398: p_rec.business_group_id :=
399: ben_bnr_shd.g_old_rec.business_group_id;
400: End If;
401: If (p_rec.rptg_prps_cd = hr_api.g_varchar2) then
402: p_rec.rptg_prps_cd :=
403: ben_bnr_shd.g_old_rec.rptg_prps_cd;

Line 403: ben_bnr_shd.g_old_rec.rptg_prps_cd;

399: ben_bnr_shd.g_old_rec.business_group_id;
400: End If;
401: If (p_rec.rptg_prps_cd = hr_api.g_varchar2) then
402: p_rec.rptg_prps_cd :=
403: ben_bnr_shd.g_old_rec.rptg_prps_cd;
404: End If;
405: If (p_rec.rpg_desc = hr_api.g_varchar2) then
406: p_rec.rpg_desc :=
407: ben_bnr_shd.g_old_rec.rpg_desc;

Line 407: ben_bnr_shd.g_old_rec.rpg_desc;

403: ben_bnr_shd.g_old_rec.rptg_prps_cd;
404: End If;
405: If (p_rec.rpg_desc = hr_api.g_varchar2) then
406: p_rec.rpg_desc :=
407: ben_bnr_shd.g_old_rec.rpg_desc;
408: End If;
409: If (p_rec.bnr_attribute_category = hr_api.g_varchar2) then
410: p_rec.bnr_attribute_category :=
411: ben_bnr_shd.g_old_rec.bnr_attribute_category;

Line 411: ben_bnr_shd.g_old_rec.bnr_attribute_category;

407: ben_bnr_shd.g_old_rec.rpg_desc;
408: End If;
409: If (p_rec.bnr_attribute_category = hr_api.g_varchar2) then
410: p_rec.bnr_attribute_category :=
411: ben_bnr_shd.g_old_rec.bnr_attribute_category;
412: End If;
413: If (p_rec.bnr_attribute1 = hr_api.g_varchar2) then
414: p_rec.bnr_attribute1 :=
415: ben_bnr_shd.g_old_rec.bnr_attribute1;

Line 415: ben_bnr_shd.g_old_rec.bnr_attribute1;

411: ben_bnr_shd.g_old_rec.bnr_attribute_category;
412: End If;
413: If (p_rec.bnr_attribute1 = hr_api.g_varchar2) then
414: p_rec.bnr_attribute1 :=
415: ben_bnr_shd.g_old_rec.bnr_attribute1;
416: End If;
417: If (p_rec.bnr_attribute2 = hr_api.g_varchar2) then
418: p_rec.bnr_attribute2 :=
419: ben_bnr_shd.g_old_rec.bnr_attribute2;

Line 419: ben_bnr_shd.g_old_rec.bnr_attribute2;

415: ben_bnr_shd.g_old_rec.bnr_attribute1;
416: End If;
417: If (p_rec.bnr_attribute2 = hr_api.g_varchar2) then
418: p_rec.bnr_attribute2 :=
419: ben_bnr_shd.g_old_rec.bnr_attribute2;
420: End If;
421: If (p_rec.bnr_attribute3 = hr_api.g_varchar2) then
422: p_rec.bnr_attribute3 :=
423: ben_bnr_shd.g_old_rec.bnr_attribute3;

Line 423: ben_bnr_shd.g_old_rec.bnr_attribute3;

419: ben_bnr_shd.g_old_rec.bnr_attribute2;
420: End If;
421: If (p_rec.bnr_attribute3 = hr_api.g_varchar2) then
422: p_rec.bnr_attribute3 :=
423: ben_bnr_shd.g_old_rec.bnr_attribute3;
424: End If;
425: If (p_rec.bnr_attribute4 = hr_api.g_varchar2) then
426: p_rec.bnr_attribute4 :=
427: ben_bnr_shd.g_old_rec.bnr_attribute4;

Line 427: ben_bnr_shd.g_old_rec.bnr_attribute4;

423: ben_bnr_shd.g_old_rec.bnr_attribute3;
424: End If;
425: If (p_rec.bnr_attribute4 = hr_api.g_varchar2) then
426: p_rec.bnr_attribute4 :=
427: ben_bnr_shd.g_old_rec.bnr_attribute4;
428: End If;
429: If (p_rec.bnr_attribute5 = hr_api.g_varchar2) then
430: p_rec.bnr_attribute5 :=
431: ben_bnr_shd.g_old_rec.bnr_attribute5;

Line 431: ben_bnr_shd.g_old_rec.bnr_attribute5;

427: ben_bnr_shd.g_old_rec.bnr_attribute4;
428: End If;
429: If (p_rec.bnr_attribute5 = hr_api.g_varchar2) then
430: p_rec.bnr_attribute5 :=
431: ben_bnr_shd.g_old_rec.bnr_attribute5;
432: End If;
433: If (p_rec.bnr_attribute6 = hr_api.g_varchar2) then
434: p_rec.bnr_attribute6 :=
435: ben_bnr_shd.g_old_rec.bnr_attribute6;

Line 435: ben_bnr_shd.g_old_rec.bnr_attribute6;

431: ben_bnr_shd.g_old_rec.bnr_attribute5;
432: End If;
433: If (p_rec.bnr_attribute6 = hr_api.g_varchar2) then
434: p_rec.bnr_attribute6 :=
435: ben_bnr_shd.g_old_rec.bnr_attribute6;
436: End If;
437: If (p_rec.bnr_attribute7 = hr_api.g_varchar2) then
438: p_rec.bnr_attribute7 :=
439: ben_bnr_shd.g_old_rec.bnr_attribute7;

Line 439: ben_bnr_shd.g_old_rec.bnr_attribute7;

435: ben_bnr_shd.g_old_rec.bnr_attribute6;
436: End If;
437: If (p_rec.bnr_attribute7 = hr_api.g_varchar2) then
438: p_rec.bnr_attribute7 :=
439: ben_bnr_shd.g_old_rec.bnr_attribute7;
440: End If;
441: If (p_rec.bnr_attribute8 = hr_api.g_varchar2) then
442: p_rec.bnr_attribute8 :=
443: ben_bnr_shd.g_old_rec.bnr_attribute8;

Line 443: ben_bnr_shd.g_old_rec.bnr_attribute8;

439: ben_bnr_shd.g_old_rec.bnr_attribute7;
440: End If;
441: If (p_rec.bnr_attribute8 = hr_api.g_varchar2) then
442: p_rec.bnr_attribute8 :=
443: ben_bnr_shd.g_old_rec.bnr_attribute8;
444: End If;
445: If (p_rec.bnr_attribute9 = hr_api.g_varchar2) then
446: p_rec.bnr_attribute9 :=
447: ben_bnr_shd.g_old_rec.bnr_attribute9;

Line 447: ben_bnr_shd.g_old_rec.bnr_attribute9;

443: ben_bnr_shd.g_old_rec.bnr_attribute8;
444: End If;
445: If (p_rec.bnr_attribute9 = hr_api.g_varchar2) then
446: p_rec.bnr_attribute9 :=
447: ben_bnr_shd.g_old_rec.bnr_attribute9;
448: End If;
449: If (p_rec.bnr_attribute10 = hr_api.g_varchar2) then
450: p_rec.bnr_attribute10 :=
451: ben_bnr_shd.g_old_rec.bnr_attribute10;

Line 451: ben_bnr_shd.g_old_rec.bnr_attribute10;

447: ben_bnr_shd.g_old_rec.bnr_attribute9;
448: End If;
449: If (p_rec.bnr_attribute10 = hr_api.g_varchar2) then
450: p_rec.bnr_attribute10 :=
451: ben_bnr_shd.g_old_rec.bnr_attribute10;
452: End If;
453: If (p_rec.bnr_attribute11 = hr_api.g_varchar2) then
454: p_rec.bnr_attribute11 :=
455: ben_bnr_shd.g_old_rec.bnr_attribute11;

Line 455: ben_bnr_shd.g_old_rec.bnr_attribute11;

451: ben_bnr_shd.g_old_rec.bnr_attribute10;
452: End If;
453: If (p_rec.bnr_attribute11 = hr_api.g_varchar2) then
454: p_rec.bnr_attribute11 :=
455: ben_bnr_shd.g_old_rec.bnr_attribute11;
456: End If;
457: If (p_rec.bnr_attribute12 = hr_api.g_varchar2) then
458: p_rec.bnr_attribute12 :=
459: ben_bnr_shd.g_old_rec.bnr_attribute12;

Line 459: ben_bnr_shd.g_old_rec.bnr_attribute12;

455: ben_bnr_shd.g_old_rec.bnr_attribute11;
456: End If;
457: If (p_rec.bnr_attribute12 = hr_api.g_varchar2) then
458: p_rec.bnr_attribute12 :=
459: ben_bnr_shd.g_old_rec.bnr_attribute12;
460: End If;
461: If (p_rec.bnr_attribute13 = hr_api.g_varchar2) then
462: p_rec.bnr_attribute13 :=
463: ben_bnr_shd.g_old_rec.bnr_attribute13;

Line 463: ben_bnr_shd.g_old_rec.bnr_attribute13;

459: ben_bnr_shd.g_old_rec.bnr_attribute12;
460: End If;
461: If (p_rec.bnr_attribute13 = hr_api.g_varchar2) then
462: p_rec.bnr_attribute13 :=
463: ben_bnr_shd.g_old_rec.bnr_attribute13;
464: End If;
465: If (p_rec.bnr_attribute14 = hr_api.g_varchar2) then
466: p_rec.bnr_attribute14 :=
467: ben_bnr_shd.g_old_rec.bnr_attribute14;

Line 467: ben_bnr_shd.g_old_rec.bnr_attribute14;

463: ben_bnr_shd.g_old_rec.bnr_attribute13;
464: End If;
465: If (p_rec.bnr_attribute14 = hr_api.g_varchar2) then
466: p_rec.bnr_attribute14 :=
467: ben_bnr_shd.g_old_rec.bnr_attribute14;
468: End If;
469: If (p_rec.bnr_attribute15 = hr_api.g_varchar2) then
470: p_rec.bnr_attribute15 :=
471: ben_bnr_shd.g_old_rec.bnr_attribute15;

Line 471: ben_bnr_shd.g_old_rec.bnr_attribute15;

467: ben_bnr_shd.g_old_rec.bnr_attribute14;
468: End If;
469: If (p_rec.bnr_attribute15 = hr_api.g_varchar2) then
470: p_rec.bnr_attribute15 :=
471: ben_bnr_shd.g_old_rec.bnr_attribute15;
472: End If;
473: If (p_rec.bnr_attribute16 = hr_api.g_varchar2) then
474: p_rec.bnr_attribute16 :=
475: ben_bnr_shd.g_old_rec.bnr_attribute16;

Line 475: ben_bnr_shd.g_old_rec.bnr_attribute16;

471: ben_bnr_shd.g_old_rec.bnr_attribute15;
472: End If;
473: If (p_rec.bnr_attribute16 = hr_api.g_varchar2) then
474: p_rec.bnr_attribute16 :=
475: ben_bnr_shd.g_old_rec.bnr_attribute16;
476: End If;
477: If (p_rec.bnr_attribute17 = hr_api.g_varchar2) then
478: p_rec.bnr_attribute17 :=
479: ben_bnr_shd.g_old_rec.bnr_attribute17;

Line 479: ben_bnr_shd.g_old_rec.bnr_attribute17;

475: ben_bnr_shd.g_old_rec.bnr_attribute16;
476: End If;
477: If (p_rec.bnr_attribute17 = hr_api.g_varchar2) then
478: p_rec.bnr_attribute17 :=
479: ben_bnr_shd.g_old_rec.bnr_attribute17;
480: End If;
481: If (p_rec.bnr_attribute18 = hr_api.g_varchar2) then
482: p_rec.bnr_attribute18 :=
483: ben_bnr_shd.g_old_rec.bnr_attribute18;

Line 483: ben_bnr_shd.g_old_rec.bnr_attribute18;

479: ben_bnr_shd.g_old_rec.bnr_attribute17;
480: End If;
481: If (p_rec.bnr_attribute18 = hr_api.g_varchar2) then
482: p_rec.bnr_attribute18 :=
483: ben_bnr_shd.g_old_rec.bnr_attribute18;
484: End If;
485: If (p_rec.bnr_attribute19 = hr_api.g_varchar2) then
486: p_rec.bnr_attribute19 :=
487: ben_bnr_shd.g_old_rec.bnr_attribute19;

Line 487: ben_bnr_shd.g_old_rec.bnr_attribute19;

483: ben_bnr_shd.g_old_rec.bnr_attribute18;
484: End If;
485: If (p_rec.bnr_attribute19 = hr_api.g_varchar2) then
486: p_rec.bnr_attribute19 :=
487: ben_bnr_shd.g_old_rec.bnr_attribute19;
488: End If;
489: If (p_rec.bnr_attribute20 = hr_api.g_varchar2) then
490: p_rec.bnr_attribute20 :=
491: ben_bnr_shd.g_old_rec.bnr_attribute20;

Line 491: ben_bnr_shd.g_old_rec.bnr_attribute20;

487: ben_bnr_shd.g_old_rec.bnr_attribute19;
488: End If;
489: If (p_rec.bnr_attribute20 = hr_api.g_varchar2) then
490: p_rec.bnr_attribute20 :=
491: ben_bnr_shd.g_old_rec.bnr_attribute20;
492: End If;
493: If (p_rec.bnr_attribute21 = hr_api.g_varchar2) then
494: p_rec.bnr_attribute21 :=
495: ben_bnr_shd.g_old_rec.bnr_attribute21;

Line 495: ben_bnr_shd.g_old_rec.bnr_attribute21;

491: ben_bnr_shd.g_old_rec.bnr_attribute20;
492: End If;
493: If (p_rec.bnr_attribute21 = hr_api.g_varchar2) then
494: p_rec.bnr_attribute21 :=
495: ben_bnr_shd.g_old_rec.bnr_attribute21;
496: End If;
497: If (p_rec.bnr_attribute22 = hr_api.g_varchar2) then
498: p_rec.bnr_attribute22 :=
499: ben_bnr_shd.g_old_rec.bnr_attribute22;

Line 499: ben_bnr_shd.g_old_rec.bnr_attribute22;

495: ben_bnr_shd.g_old_rec.bnr_attribute21;
496: End If;
497: If (p_rec.bnr_attribute22 = hr_api.g_varchar2) then
498: p_rec.bnr_attribute22 :=
499: ben_bnr_shd.g_old_rec.bnr_attribute22;
500: End If;
501: If (p_rec.bnr_attribute23 = hr_api.g_varchar2) then
502: p_rec.bnr_attribute23 :=
503: ben_bnr_shd.g_old_rec.bnr_attribute23;

Line 503: ben_bnr_shd.g_old_rec.bnr_attribute23;

499: ben_bnr_shd.g_old_rec.bnr_attribute22;
500: End If;
501: If (p_rec.bnr_attribute23 = hr_api.g_varchar2) then
502: p_rec.bnr_attribute23 :=
503: ben_bnr_shd.g_old_rec.bnr_attribute23;
504: End If;
505: If (p_rec.bnr_attribute24 = hr_api.g_varchar2) then
506: p_rec.bnr_attribute24 :=
507: ben_bnr_shd.g_old_rec.bnr_attribute24;

Line 507: ben_bnr_shd.g_old_rec.bnr_attribute24;

503: ben_bnr_shd.g_old_rec.bnr_attribute23;
504: End If;
505: If (p_rec.bnr_attribute24 = hr_api.g_varchar2) then
506: p_rec.bnr_attribute24 :=
507: ben_bnr_shd.g_old_rec.bnr_attribute24;
508: End If;
509: If (p_rec.bnr_attribute25 = hr_api.g_varchar2) then
510: p_rec.bnr_attribute25 :=
511: ben_bnr_shd.g_old_rec.bnr_attribute25;

Line 511: ben_bnr_shd.g_old_rec.bnr_attribute25;

507: ben_bnr_shd.g_old_rec.bnr_attribute24;
508: End If;
509: If (p_rec.bnr_attribute25 = hr_api.g_varchar2) then
510: p_rec.bnr_attribute25 :=
511: ben_bnr_shd.g_old_rec.bnr_attribute25;
512: End If;
513: If (p_rec.bnr_attribute26 = hr_api.g_varchar2) then
514: p_rec.bnr_attribute26 :=
515: ben_bnr_shd.g_old_rec.bnr_attribute26;

Line 515: ben_bnr_shd.g_old_rec.bnr_attribute26;

511: ben_bnr_shd.g_old_rec.bnr_attribute25;
512: End If;
513: If (p_rec.bnr_attribute26 = hr_api.g_varchar2) then
514: p_rec.bnr_attribute26 :=
515: ben_bnr_shd.g_old_rec.bnr_attribute26;
516: End If;
517: If (p_rec.bnr_attribute27 = hr_api.g_varchar2) then
518: p_rec.bnr_attribute27 :=
519: ben_bnr_shd.g_old_rec.bnr_attribute27;

Line 519: ben_bnr_shd.g_old_rec.bnr_attribute27;

515: ben_bnr_shd.g_old_rec.bnr_attribute26;
516: End If;
517: If (p_rec.bnr_attribute27 = hr_api.g_varchar2) then
518: p_rec.bnr_attribute27 :=
519: ben_bnr_shd.g_old_rec.bnr_attribute27;
520: End If;
521: If (p_rec.bnr_attribute28 = hr_api.g_varchar2) then
522: p_rec.bnr_attribute28 :=
523: ben_bnr_shd.g_old_rec.bnr_attribute28;

Line 523: ben_bnr_shd.g_old_rec.bnr_attribute28;

519: ben_bnr_shd.g_old_rec.bnr_attribute27;
520: End If;
521: If (p_rec.bnr_attribute28 = hr_api.g_varchar2) then
522: p_rec.bnr_attribute28 :=
523: ben_bnr_shd.g_old_rec.bnr_attribute28;
524: End If;
525: If (p_rec.bnr_attribute29 = hr_api.g_varchar2) then
526: p_rec.bnr_attribute29 :=
527: ben_bnr_shd.g_old_rec.bnr_attribute29;

Line 527: ben_bnr_shd.g_old_rec.bnr_attribute29;

523: ben_bnr_shd.g_old_rec.bnr_attribute28;
524: End If;
525: If (p_rec.bnr_attribute29 = hr_api.g_varchar2) then
526: p_rec.bnr_attribute29 :=
527: ben_bnr_shd.g_old_rec.bnr_attribute29;
528: End If;
529: If (p_rec.bnr_attribute30 = hr_api.g_varchar2) then
530: p_rec.bnr_attribute30 :=
531: ben_bnr_shd.g_old_rec.bnr_attribute30;

Line 531: ben_bnr_shd.g_old_rec.bnr_attribute30;

527: ben_bnr_shd.g_old_rec.bnr_attribute29;
528: End If;
529: If (p_rec.bnr_attribute30 = hr_api.g_varchar2) then
530: p_rec.bnr_attribute30 :=
531: ben_bnr_shd.g_old_rec.bnr_attribute30;
532: End If;
533: --iRec
534: If (p_rec.ordr_num = hr_api.g_number) then
535: p_rec.ordr_num :=

Line 536: ben_bnr_shd.g_old_rec.ordr_num;

532: End If;
533: --iRec
534: If (p_rec.ordr_num = hr_api.g_number) then
535: p_rec.ordr_num :=
536: ben_bnr_shd.g_old_rec.ordr_num;
537: End If;
538: --iRec
539: --
540: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 550: p_rec in out nocopy ben_bnr_shd.g_rec_type

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

Line 560: ben_bnr_shd.lck

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

Line 638: l_rec ben_bnr_shd.g_rec_type;

634: p_object_version_number in out nocopy number,
635: p_ordr_num in number default hr_api.g_number --iRec
636: ) is
637: --
638: l_rec ben_bnr_shd.g_rec_type;
639: l_proc varchar2(72) := g_package||'upd';
640: --
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);

Line 648: ben_bnr_shd.convert_args

644: -- Call conversion function to turn arguments into the
645: -- l_rec structure.
646: --
647: l_rec :=
648: ben_bnr_shd.convert_args
649: (
650: p_rptg_grp_id,
651: p_name,
652: p_business_group_id,