DBA Data[Home] [Help]

APPS.BEN_DRR_UPD dependencies on BEN_DRR_SHD

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

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

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

105: drr_attribute30 = p_rec.drr_attribute30,
106: object_version_number = p_rec.object_version_number
107: where dsgn_rqmt_rlshp_typ_id = p_rec.dsgn_rqmt_rlshp_typ_id;
108: --
109: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: --
113: Exception

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

112: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
117: ben_drr_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated

Line 117: ben_drr_shd.constraint_error

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

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

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

Line 122: ben_drr_shd.constraint_error

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

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

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

Line 127: ben_drr_shd.constraint_error

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

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

126: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
127: ben_drr_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
131: Raise;
132: End update_dml;
133: --
134: -- ----------------------------------------------------------------------------

Line 166: Procedure pre_update(p_rec in ben_drr_shd.g_rec_type) is

162: -- Internal Row Handler Use Only.
163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_update(p_rec in ben_drr_shd.g_rec_type) is
167: --
168: l_proc varchar2(72) := g_package||'pre_update';
169: --
170: Begin

Line 209: p_effective_date in date,p_rec in ben_drr_shd.g_rec_type) is

205: --
206: -- {End Of Comments}
207: -- ----------------------------------------------------------------------------
208: Procedure post_update(
209: p_effective_date in date,p_rec in ben_drr_shd.g_rec_type) is
210: --
211: l_proc varchar2(72) := g_package||'post_update';
212: --
213: Begin

Line 260: ,p_rlshp_typ_cd_o =>ben_drr_shd.g_old_rec.rlshp_typ_cd

256: ,p_drr_attribute29 =>p_rec.drr_attribute29
257: ,p_drr_attribute30 =>p_rec.drr_attribute30
258: ,p_object_version_number =>p_rec.object_version_number
259: ,p_effective_date =>p_effective_date
260: ,p_rlshp_typ_cd_o =>ben_drr_shd.g_old_rec.rlshp_typ_cd
261: ,p_dsgn_rqmt_id_o =>ben_drr_shd.g_old_rec.dsgn_rqmt_id
262: ,p_business_group_id_o =>ben_drr_shd.g_old_rec.business_group_id
263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category
264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1

Line 261: ,p_dsgn_rqmt_id_o =>ben_drr_shd.g_old_rec.dsgn_rqmt_id

257: ,p_drr_attribute30 =>p_rec.drr_attribute30
258: ,p_object_version_number =>p_rec.object_version_number
259: ,p_effective_date =>p_effective_date
260: ,p_rlshp_typ_cd_o =>ben_drr_shd.g_old_rec.rlshp_typ_cd
261: ,p_dsgn_rqmt_id_o =>ben_drr_shd.g_old_rec.dsgn_rqmt_id
262: ,p_business_group_id_o =>ben_drr_shd.g_old_rec.business_group_id
263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category
264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1
265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2

Line 262: ,p_business_group_id_o =>ben_drr_shd.g_old_rec.business_group_id

258: ,p_object_version_number =>p_rec.object_version_number
259: ,p_effective_date =>p_effective_date
260: ,p_rlshp_typ_cd_o =>ben_drr_shd.g_old_rec.rlshp_typ_cd
261: ,p_dsgn_rqmt_id_o =>ben_drr_shd.g_old_rec.dsgn_rqmt_id
262: ,p_business_group_id_o =>ben_drr_shd.g_old_rec.business_group_id
263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category
264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1
265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2
266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3

Line 263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category

259: ,p_effective_date =>p_effective_date
260: ,p_rlshp_typ_cd_o =>ben_drr_shd.g_old_rec.rlshp_typ_cd
261: ,p_dsgn_rqmt_id_o =>ben_drr_shd.g_old_rec.dsgn_rqmt_id
262: ,p_business_group_id_o =>ben_drr_shd.g_old_rec.business_group_id
263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category
264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1
265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2
266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3
267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4

Line 264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1

260: ,p_rlshp_typ_cd_o =>ben_drr_shd.g_old_rec.rlshp_typ_cd
261: ,p_dsgn_rqmt_id_o =>ben_drr_shd.g_old_rec.dsgn_rqmt_id
262: ,p_business_group_id_o =>ben_drr_shd.g_old_rec.business_group_id
263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category
264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1
265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2
266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3
267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4
268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5

Line 265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2

261: ,p_dsgn_rqmt_id_o =>ben_drr_shd.g_old_rec.dsgn_rqmt_id
262: ,p_business_group_id_o =>ben_drr_shd.g_old_rec.business_group_id
263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category
264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1
265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2
266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3
267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4
268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5
269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6

Line 266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3

262: ,p_business_group_id_o =>ben_drr_shd.g_old_rec.business_group_id
263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category
264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1
265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2
266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3
267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4
268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5
269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6
270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7

Line 267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4

263: ,p_drr_attribute_category_o =>ben_drr_shd.g_old_rec.drr_attribute_category
264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1
265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2
266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3
267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4
268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5
269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6
270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7
271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8

Line 268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5

264: ,p_drr_attribute1_o =>ben_drr_shd.g_old_rec.drr_attribute1
265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2
266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3
267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4
268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5
269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6
270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7
271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8
272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9

Line 269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6

265: ,p_drr_attribute2_o =>ben_drr_shd.g_old_rec.drr_attribute2
266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3
267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4
268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5
269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6
270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7
271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8
272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9
273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10

Line 270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7

266: ,p_drr_attribute3_o =>ben_drr_shd.g_old_rec.drr_attribute3
267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4
268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5
269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6
270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7
271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8
272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9
273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10
274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11

Line 271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8

267: ,p_drr_attribute4_o =>ben_drr_shd.g_old_rec.drr_attribute4
268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5
269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6
270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7
271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8
272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9
273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10
274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11
275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12

Line 272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9

268: ,p_drr_attribute5_o =>ben_drr_shd.g_old_rec.drr_attribute5
269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6
270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7
271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8
272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9
273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10
274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11
275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12
276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13

Line 273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10

269: ,p_drr_attribute6_o =>ben_drr_shd.g_old_rec.drr_attribute6
270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7
271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8
272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9
273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10
274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11
275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12
276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13
277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14

Line 274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11

270: ,p_drr_attribute7_o =>ben_drr_shd.g_old_rec.drr_attribute7
271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8
272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9
273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10
274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11
275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12
276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13
277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14
278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15

Line 275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12

271: ,p_drr_attribute8_o =>ben_drr_shd.g_old_rec.drr_attribute8
272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9
273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10
274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11
275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12
276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13
277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14
278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15
279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16

Line 276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13

272: ,p_drr_attribute9_o =>ben_drr_shd.g_old_rec.drr_attribute9
273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10
274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11
275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12
276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13
277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14
278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15
279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16
280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17

Line 277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14

273: ,p_drr_attribute10_o =>ben_drr_shd.g_old_rec.drr_attribute10
274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11
275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12
276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13
277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14
278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15
279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16
280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17
281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18

Line 278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15

274: ,p_drr_attribute11_o =>ben_drr_shd.g_old_rec.drr_attribute11
275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12
276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13
277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14
278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15
279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16
280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17
281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18
282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19

Line 279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16

275: ,p_drr_attribute12_o =>ben_drr_shd.g_old_rec.drr_attribute12
276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13
277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14
278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15
279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16
280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17
281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18
282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19
283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20

Line 280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17

276: ,p_drr_attribute13_o =>ben_drr_shd.g_old_rec.drr_attribute13
277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14
278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15
279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16
280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17
281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18
282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19
283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20
284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21

Line 281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18

277: ,p_drr_attribute14_o =>ben_drr_shd.g_old_rec.drr_attribute14
278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15
279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16
280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17
281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18
282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19
283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20
284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21
285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22

Line 282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19

278: ,p_drr_attribute15_o =>ben_drr_shd.g_old_rec.drr_attribute15
279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16
280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17
281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18
282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19
283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20
284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21
285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22
286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23

Line 283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20

279: ,p_drr_attribute16_o =>ben_drr_shd.g_old_rec.drr_attribute16
280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17
281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18
282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19
283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20
284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21
285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22
286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23
287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24

Line 284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21

280: ,p_drr_attribute17_o =>ben_drr_shd.g_old_rec.drr_attribute17
281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18
282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19
283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20
284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21
285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22
286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23
287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24
288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25

Line 285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22

281: ,p_drr_attribute18_o =>ben_drr_shd.g_old_rec.drr_attribute18
282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19
283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20
284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21
285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22
286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23
287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24
288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25
289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26

Line 286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23

282: ,p_drr_attribute19_o =>ben_drr_shd.g_old_rec.drr_attribute19
283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20
284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21
285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22
286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23
287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24
288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25
289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26
290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27

Line 287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24

283: ,p_drr_attribute20_o =>ben_drr_shd.g_old_rec.drr_attribute20
284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21
285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22
286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23
287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24
288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25
289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26
290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27
291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28

Line 288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25

284: ,p_drr_attribute21_o =>ben_drr_shd.g_old_rec.drr_attribute21
285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22
286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23
287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24
288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25
289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26
290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27
291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28
292: ,p_drr_attribute29_o =>ben_drr_shd.g_old_rec.drr_attribute29

Line 289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26

285: ,p_drr_attribute22_o =>ben_drr_shd.g_old_rec.drr_attribute22
286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23
287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24
288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25
289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26
290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27
291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28
292: ,p_drr_attribute29_o =>ben_drr_shd.g_old_rec.drr_attribute29
293: ,p_drr_attribute30_o =>ben_drr_shd.g_old_rec.drr_attribute30

Line 290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27

286: ,p_drr_attribute23_o =>ben_drr_shd.g_old_rec.drr_attribute23
287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24
288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25
289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26
290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27
291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28
292: ,p_drr_attribute29_o =>ben_drr_shd.g_old_rec.drr_attribute29
293: ,p_drr_attribute30_o =>ben_drr_shd.g_old_rec.drr_attribute30
294: ,p_object_version_number_o =>ben_drr_shd.g_old_rec.object_version_number

Line 291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28

287: ,p_drr_attribute24_o =>ben_drr_shd.g_old_rec.drr_attribute24
288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25
289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26
290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27
291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28
292: ,p_drr_attribute29_o =>ben_drr_shd.g_old_rec.drr_attribute29
293: ,p_drr_attribute30_o =>ben_drr_shd.g_old_rec.drr_attribute30
294: ,p_object_version_number_o =>ben_drr_shd.g_old_rec.object_version_number
295: );

Line 292: ,p_drr_attribute29_o =>ben_drr_shd.g_old_rec.drr_attribute29

288: ,p_drr_attribute25_o =>ben_drr_shd.g_old_rec.drr_attribute25
289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26
290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27
291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28
292: ,p_drr_attribute29_o =>ben_drr_shd.g_old_rec.drr_attribute29
293: ,p_drr_attribute30_o =>ben_drr_shd.g_old_rec.drr_attribute30
294: ,p_object_version_number_o =>ben_drr_shd.g_old_rec.object_version_number
295: );
296: --

Line 293: ,p_drr_attribute30_o =>ben_drr_shd.g_old_rec.drr_attribute30

289: ,p_drr_attribute26_o =>ben_drr_shd.g_old_rec.drr_attribute26
290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27
291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28
292: ,p_drr_attribute29_o =>ben_drr_shd.g_old_rec.drr_attribute29
293: ,p_drr_attribute30_o =>ben_drr_shd.g_old_rec.drr_attribute30
294: ,p_object_version_number_o =>ben_drr_shd.g_old_rec.object_version_number
295: );
296: --
297: exception

Line 294: ,p_object_version_number_o =>ben_drr_shd.g_old_rec.object_version_number

290: ,p_drr_attribute27_o =>ben_drr_shd.g_old_rec.drr_attribute27
291: ,p_drr_attribute28_o =>ben_drr_shd.g_old_rec.drr_attribute28
292: ,p_drr_attribute29_o =>ben_drr_shd.g_old_rec.drr_attribute29
293: ,p_drr_attribute30_o =>ben_drr_shd.g_old_rec.drr_attribute30
294: ,p_object_version_number_o =>ben_drr_shd.g_old_rec.object_version_number
295: );
296: --
297: exception
298: --

Line 356: Procedure convert_defs(p_rec in out nocopy ben_drr_shd.g_rec_type) is

352: -- Internal Row Handler Use Only.
353: --
354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure convert_defs(p_rec in out nocopy ben_drr_shd.g_rec_type) is
357: --
358: l_proc varchar2(72) := g_package||'convert_defs';
359: --
360: Begin

Line 371: ben_drr_shd.g_old_rec.rlshp_typ_cd;

367: -- is being used then we must set to the 'current' argument value.
368: --
369: If (p_rec.rlshp_typ_cd = hr_api.g_varchar2) then
370: p_rec.rlshp_typ_cd :=
371: ben_drr_shd.g_old_rec.rlshp_typ_cd;
372: End If;
373: If (p_rec.dsgn_rqmt_id = hr_api.g_number) then
374: p_rec.dsgn_rqmt_id :=
375: ben_drr_shd.g_old_rec.dsgn_rqmt_id;

Line 375: ben_drr_shd.g_old_rec.dsgn_rqmt_id;

371: ben_drr_shd.g_old_rec.rlshp_typ_cd;
372: End If;
373: If (p_rec.dsgn_rqmt_id = hr_api.g_number) then
374: p_rec.dsgn_rqmt_id :=
375: ben_drr_shd.g_old_rec.dsgn_rqmt_id;
376: End If;
377: If (p_rec.business_group_id = hr_api.g_number) then
378: p_rec.business_group_id :=
379: ben_drr_shd.g_old_rec.business_group_id;

Line 379: ben_drr_shd.g_old_rec.business_group_id;

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

Line 383: ben_drr_shd.g_old_rec.drr_attribute_category;

379: ben_drr_shd.g_old_rec.business_group_id;
380: End If;
381: If (p_rec.drr_attribute_category = hr_api.g_varchar2) then
382: p_rec.drr_attribute_category :=
383: ben_drr_shd.g_old_rec.drr_attribute_category;
384: End If;
385: If (p_rec.drr_attribute1 = hr_api.g_varchar2) then
386: p_rec.drr_attribute1 :=
387: ben_drr_shd.g_old_rec.drr_attribute1;

Line 387: ben_drr_shd.g_old_rec.drr_attribute1;

383: ben_drr_shd.g_old_rec.drr_attribute_category;
384: End If;
385: If (p_rec.drr_attribute1 = hr_api.g_varchar2) then
386: p_rec.drr_attribute1 :=
387: ben_drr_shd.g_old_rec.drr_attribute1;
388: End If;
389: If (p_rec.drr_attribute2 = hr_api.g_varchar2) then
390: p_rec.drr_attribute2 :=
391: ben_drr_shd.g_old_rec.drr_attribute2;

Line 391: ben_drr_shd.g_old_rec.drr_attribute2;

387: ben_drr_shd.g_old_rec.drr_attribute1;
388: End If;
389: If (p_rec.drr_attribute2 = hr_api.g_varchar2) then
390: p_rec.drr_attribute2 :=
391: ben_drr_shd.g_old_rec.drr_attribute2;
392: End If;
393: If (p_rec.drr_attribute3 = hr_api.g_varchar2) then
394: p_rec.drr_attribute3 :=
395: ben_drr_shd.g_old_rec.drr_attribute3;

Line 395: ben_drr_shd.g_old_rec.drr_attribute3;

391: ben_drr_shd.g_old_rec.drr_attribute2;
392: End If;
393: If (p_rec.drr_attribute3 = hr_api.g_varchar2) then
394: p_rec.drr_attribute3 :=
395: ben_drr_shd.g_old_rec.drr_attribute3;
396: End If;
397: If (p_rec.drr_attribute4 = hr_api.g_varchar2) then
398: p_rec.drr_attribute4 :=
399: ben_drr_shd.g_old_rec.drr_attribute4;

Line 399: ben_drr_shd.g_old_rec.drr_attribute4;

395: ben_drr_shd.g_old_rec.drr_attribute3;
396: End If;
397: If (p_rec.drr_attribute4 = hr_api.g_varchar2) then
398: p_rec.drr_attribute4 :=
399: ben_drr_shd.g_old_rec.drr_attribute4;
400: End If;
401: If (p_rec.drr_attribute5 = hr_api.g_varchar2) then
402: p_rec.drr_attribute5 :=
403: ben_drr_shd.g_old_rec.drr_attribute5;

Line 403: ben_drr_shd.g_old_rec.drr_attribute5;

399: ben_drr_shd.g_old_rec.drr_attribute4;
400: End If;
401: If (p_rec.drr_attribute5 = hr_api.g_varchar2) then
402: p_rec.drr_attribute5 :=
403: ben_drr_shd.g_old_rec.drr_attribute5;
404: End If;
405: If (p_rec.drr_attribute6 = hr_api.g_varchar2) then
406: p_rec.drr_attribute6 :=
407: ben_drr_shd.g_old_rec.drr_attribute6;

Line 407: ben_drr_shd.g_old_rec.drr_attribute6;

403: ben_drr_shd.g_old_rec.drr_attribute5;
404: End If;
405: If (p_rec.drr_attribute6 = hr_api.g_varchar2) then
406: p_rec.drr_attribute6 :=
407: ben_drr_shd.g_old_rec.drr_attribute6;
408: End If;
409: If (p_rec.drr_attribute7 = hr_api.g_varchar2) then
410: p_rec.drr_attribute7 :=
411: ben_drr_shd.g_old_rec.drr_attribute7;

Line 411: ben_drr_shd.g_old_rec.drr_attribute7;

407: ben_drr_shd.g_old_rec.drr_attribute6;
408: End If;
409: If (p_rec.drr_attribute7 = hr_api.g_varchar2) then
410: p_rec.drr_attribute7 :=
411: ben_drr_shd.g_old_rec.drr_attribute7;
412: End If;
413: If (p_rec.drr_attribute8 = hr_api.g_varchar2) then
414: p_rec.drr_attribute8 :=
415: ben_drr_shd.g_old_rec.drr_attribute8;

Line 415: ben_drr_shd.g_old_rec.drr_attribute8;

411: ben_drr_shd.g_old_rec.drr_attribute7;
412: End If;
413: If (p_rec.drr_attribute8 = hr_api.g_varchar2) then
414: p_rec.drr_attribute8 :=
415: ben_drr_shd.g_old_rec.drr_attribute8;
416: End If;
417: If (p_rec.drr_attribute9 = hr_api.g_varchar2) then
418: p_rec.drr_attribute9 :=
419: ben_drr_shd.g_old_rec.drr_attribute9;

Line 419: ben_drr_shd.g_old_rec.drr_attribute9;

415: ben_drr_shd.g_old_rec.drr_attribute8;
416: End If;
417: If (p_rec.drr_attribute9 = hr_api.g_varchar2) then
418: p_rec.drr_attribute9 :=
419: ben_drr_shd.g_old_rec.drr_attribute9;
420: End If;
421: If (p_rec.drr_attribute10 = hr_api.g_varchar2) then
422: p_rec.drr_attribute10 :=
423: ben_drr_shd.g_old_rec.drr_attribute10;

Line 423: ben_drr_shd.g_old_rec.drr_attribute10;

419: ben_drr_shd.g_old_rec.drr_attribute9;
420: End If;
421: If (p_rec.drr_attribute10 = hr_api.g_varchar2) then
422: p_rec.drr_attribute10 :=
423: ben_drr_shd.g_old_rec.drr_attribute10;
424: End If;
425: If (p_rec.drr_attribute11 = hr_api.g_varchar2) then
426: p_rec.drr_attribute11 :=
427: ben_drr_shd.g_old_rec.drr_attribute11;

Line 427: ben_drr_shd.g_old_rec.drr_attribute11;

423: ben_drr_shd.g_old_rec.drr_attribute10;
424: End If;
425: If (p_rec.drr_attribute11 = hr_api.g_varchar2) then
426: p_rec.drr_attribute11 :=
427: ben_drr_shd.g_old_rec.drr_attribute11;
428: End If;
429: If (p_rec.drr_attribute12 = hr_api.g_varchar2) then
430: p_rec.drr_attribute12 :=
431: ben_drr_shd.g_old_rec.drr_attribute12;

Line 431: ben_drr_shd.g_old_rec.drr_attribute12;

427: ben_drr_shd.g_old_rec.drr_attribute11;
428: End If;
429: If (p_rec.drr_attribute12 = hr_api.g_varchar2) then
430: p_rec.drr_attribute12 :=
431: ben_drr_shd.g_old_rec.drr_attribute12;
432: End If;
433: If (p_rec.drr_attribute13 = hr_api.g_varchar2) then
434: p_rec.drr_attribute13 :=
435: ben_drr_shd.g_old_rec.drr_attribute13;

Line 435: ben_drr_shd.g_old_rec.drr_attribute13;

431: ben_drr_shd.g_old_rec.drr_attribute12;
432: End If;
433: If (p_rec.drr_attribute13 = hr_api.g_varchar2) then
434: p_rec.drr_attribute13 :=
435: ben_drr_shd.g_old_rec.drr_attribute13;
436: End If;
437: If (p_rec.drr_attribute14 = hr_api.g_varchar2) then
438: p_rec.drr_attribute14 :=
439: ben_drr_shd.g_old_rec.drr_attribute14;

Line 439: ben_drr_shd.g_old_rec.drr_attribute14;

435: ben_drr_shd.g_old_rec.drr_attribute13;
436: End If;
437: If (p_rec.drr_attribute14 = hr_api.g_varchar2) then
438: p_rec.drr_attribute14 :=
439: ben_drr_shd.g_old_rec.drr_attribute14;
440: End If;
441: If (p_rec.drr_attribute15 = hr_api.g_varchar2) then
442: p_rec.drr_attribute15 :=
443: ben_drr_shd.g_old_rec.drr_attribute15;

Line 443: ben_drr_shd.g_old_rec.drr_attribute15;

439: ben_drr_shd.g_old_rec.drr_attribute14;
440: End If;
441: If (p_rec.drr_attribute15 = hr_api.g_varchar2) then
442: p_rec.drr_attribute15 :=
443: ben_drr_shd.g_old_rec.drr_attribute15;
444: End If;
445: If (p_rec.drr_attribute16 = hr_api.g_varchar2) then
446: p_rec.drr_attribute16 :=
447: ben_drr_shd.g_old_rec.drr_attribute16;

Line 447: ben_drr_shd.g_old_rec.drr_attribute16;

443: ben_drr_shd.g_old_rec.drr_attribute15;
444: End If;
445: If (p_rec.drr_attribute16 = hr_api.g_varchar2) then
446: p_rec.drr_attribute16 :=
447: ben_drr_shd.g_old_rec.drr_attribute16;
448: End If;
449: If (p_rec.drr_attribute17 = hr_api.g_varchar2) then
450: p_rec.drr_attribute17 :=
451: ben_drr_shd.g_old_rec.drr_attribute17;

Line 451: ben_drr_shd.g_old_rec.drr_attribute17;

447: ben_drr_shd.g_old_rec.drr_attribute16;
448: End If;
449: If (p_rec.drr_attribute17 = hr_api.g_varchar2) then
450: p_rec.drr_attribute17 :=
451: ben_drr_shd.g_old_rec.drr_attribute17;
452: End If;
453: If (p_rec.drr_attribute18 = hr_api.g_varchar2) then
454: p_rec.drr_attribute18 :=
455: ben_drr_shd.g_old_rec.drr_attribute18;

Line 455: ben_drr_shd.g_old_rec.drr_attribute18;

451: ben_drr_shd.g_old_rec.drr_attribute17;
452: End If;
453: If (p_rec.drr_attribute18 = hr_api.g_varchar2) then
454: p_rec.drr_attribute18 :=
455: ben_drr_shd.g_old_rec.drr_attribute18;
456: End If;
457: If (p_rec.drr_attribute19 = hr_api.g_varchar2) then
458: p_rec.drr_attribute19 :=
459: ben_drr_shd.g_old_rec.drr_attribute19;

Line 459: ben_drr_shd.g_old_rec.drr_attribute19;

455: ben_drr_shd.g_old_rec.drr_attribute18;
456: End If;
457: If (p_rec.drr_attribute19 = hr_api.g_varchar2) then
458: p_rec.drr_attribute19 :=
459: ben_drr_shd.g_old_rec.drr_attribute19;
460: End If;
461: If (p_rec.drr_attribute20 = hr_api.g_varchar2) then
462: p_rec.drr_attribute20 :=
463: ben_drr_shd.g_old_rec.drr_attribute20;

Line 463: ben_drr_shd.g_old_rec.drr_attribute20;

459: ben_drr_shd.g_old_rec.drr_attribute19;
460: End If;
461: If (p_rec.drr_attribute20 = hr_api.g_varchar2) then
462: p_rec.drr_attribute20 :=
463: ben_drr_shd.g_old_rec.drr_attribute20;
464: End If;
465: If (p_rec.drr_attribute21 = hr_api.g_varchar2) then
466: p_rec.drr_attribute21 :=
467: ben_drr_shd.g_old_rec.drr_attribute21;

Line 467: ben_drr_shd.g_old_rec.drr_attribute21;

463: ben_drr_shd.g_old_rec.drr_attribute20;
464: End If;
465: If (p_rec.drr_attribute21 = hr_api.g_varchar2) then
466: p_rec.drr_attribute21 :=
467: ben_drr_shd.g_old_rec.drr_attribute21;
468: End If;
469: If (p_rec.drr_attribute22 = hr_api.g_varchar2) then
470: p_rec.drr_attribute22 :=
471: ben_drr_shd.g_old_rec.drr_attribute22;

Line 471: ben_drr_shd.g_old_rec.drr_attribute22;

467: ben_drr_shd.g_old_rec.drr_attribute21;
468: End If;
469: If (p_rec.drr_attribute22 = hr_api.g_varchar2) then
470: p_rec.drr_attribute22 :=
471: ben_drr_shd.g_old_rec.drr_attribute22;
472: End If;
473: If (p_rec.drr_attribute23 = hr_api.g_varchar2) then
474: p_rec.drr_attribute23 :=
475: ben_drr_shd.g_old_rec.drr_attribute23;

Line 475: ben_drr_shd.g_old_rec.drr_attribute23;

471: ben_drr_shd.g_old_rec.drr_attribute22;
472: End If;
473: If (p_rec.drr_attribute23 = hr_api.g_varchar2) then
474: p_rec.drr_attribute23 :=
475: ben_drr_shd.g_old_rec.drr_attribute23;
476: End If;
477: If (p_rec.drr_attribute24 = hr_api.g_varchar2) then
478: p_rec.drr_attribute24 :=
479: ben_drr_shd.g_old_rec.drr_attribute24;

Line 479: ben_drr_shd.g_old_rec.drr_attribute24;

475: ben_drr_shd.g_old_rec.drr_attribute23;
476: End If;
477: If (p_rec.drr_attribute24 = hr_api.g_varchar2) then
478: p_rec.drr_attribute24 :=
479: ben_drr_shd.g_old_rec.drr_attribute24;
480: End If;
481: If (p_rec.drr_attribute25 = hr_api.g_varchar2) then
482: p_rec.drr_attribute25 :=
483: ben_drr_shd.g_old_rec.drr_attribute25;

Line 483: ben_drr_shd.g_old_rec.drr_attribute25;

479: ben_drr_shd.g_old_rec.drr_attribute24;
480: End If;
481: If (p_rec.drr_attribute25 = hr_api.g_varchar2) then
482: p_rec.drr_attribute25 :=
483: ben_drr_shd.g_old_rec.drr_attribute25;
484: End If;
485: If (p_rec.drr_attribute26 = hr_api.g_varchar2) then
486: p_rec.drr_attribute26 :=
487: ben_drr_shd.g_old_rec.drr_attribute26;

Line 487: ben_drr_shd.g_old_rec.drr_attribute26;

483: ben_drr_shd.g_old_rec.drr_attribute25;
484: End If;
485: If (p_rec.drr_attribute26 = hr_api.g_varchar2) then
486: p_rec.drr_attribute26 :=
487: ben_drr_shd.g_old_rec.drr_attribute26;
488: End If;
489: If (p_rec.drr_attribute27 = hr_api.g_varchar2) then
490: p_rec.drr_attribute27 :=
491: ben_drr_shd.g_old_rec.drr_attribute27;

Line 491: ben_drr_shd.g_old_rec.drr_attribute27;

487: ben_drr_shd.g_old_rec.drr_attribute26;
488: End If;
489: If (p_rec.drr_attribute27 = hr_api.g_varchar2) then
490: p_rec.drr_attribute27 :=
491: ben_drr_shd.g_old_rec.drr_attribute27;
492: End If;
493: If (p_rec.drr_attribute28 = hr_api.g_varchar2) then
494: p_rec.drr_attribute28 :=
495: ben_drr_shd.g_old_rec.drr_attribute28;

Line 495: ben_drr_shd.g_old_rec.drr_attribute28;

491: ben_drr_shd.g_old_rec.drr_attribute27;
492: End If;
493: If (p_rec.drr_attribute28 = hr_api.g_varchar2) then
494: p_rec.drr_attribute28 :=
495: ben_drr_shd.g_old_rec.drr_attribute28;
496: End If;
497: If (p_rec.drr_attribute29 = hr_api.g_varchar2) then
498: p_rec.drr_attribute29 :=
499: ben_drr_shd.g_old_rec.drr_attribute29;

Line 499: ben_drr_shd.g_old_rec.drr_attribute29;

495: ben_drr_shd.g_old_rec.drr_attribute28;
496: End If;
497: If (p_rec.drr_attribute29 = hr_api.g_varchar2) then
498: p_rec.drr_attribute29 :=
499: ben_drr_shd.g_old_rec.drr_attribute29;
500: End If;
501: If (p_rec.drr_attribute30 = hr_api.g_varchar2) then
502: p_rec.drr_attribute30 :=
503: ben_drr_shd.g_old_rec.drr_attribute30;

Line 503: ben_drr_shd.g_old_rec.drr_attribute30;

499: ben_drr_shd.g_old_rec.drr_attribute29;
500: End If;
501: If (p_rec.drr_attribute30 = hr_api.g_varchar2) then
502: p_rec.drr_attribute30 :=
503: ben_drr_shd.g_old_rec.drr_attribute30;
504: End If;
505:
506: --
507: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 517: p_rec in out nocopy ben_drr_shd.g_rec_type

513: -- ----------------------------------------------------------------------------
514: Procedure upd
515: (
516: p_effective_date in date,
517: p_rec in out nocopy ben_drr_shd.g_rec_type
518: ) is
519: --
520: l_proc varchar2(72) := g_package||'upd';
521: --

Line 527: ben_drr_shd.lck

523: hr_utility.set_location('Entering:'||l_proc, 5);
524: --
525: -- We must lock the row which we need to update.
526: --
527: ben_drr_shd.lck
528: (
529: p_rec.dsgn_rqmt_rlshp_typ_id,
530: p_rec.object_version_number
531: );

Line 601: l_rec ben_drr_shd.g_rec_type;

597: p_drr_attribute30 in varchar2 default hr_api.g_varchar2,
598: p_object_version_number in out nocopy number
599: ) is
600: --
601: l_rec ben_drr_shd.g_rec_type;
602: l_proc varchar2(72) := g_package||'upd';
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);

Line 611: ben_drr_shd.convert_args

607: -- Call conversion function to turn arguments into the
608: -- l_rec structure.
609: --
610: l_rec :=
611: ben_drr_shd.convert_args
612: (
613: p_dsgn_rqmt_rlshp_typ_id,
614: p_rlshp_typ_cd,
615: p_dsgn_rqmt_id,