DBA Data[Home] [Help]

APPS.BEN_PCG_UPD dependencies on BEN_PCG_SHD

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

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

Line 110: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status

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

Line 117: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status

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

Line 118: ben_pcg_shd.constraint_error

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

Line 122: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status

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

Line 123: ben_pcg_shd.constraint_error

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

Line 127: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status

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

Line 128: ben_pcg_shd.constraint_error

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

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

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

Line 167: Procedure pre_update(p_rec in ben_pcg_shd.g_rec_type) is

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

Line 209: Procedure post_update(p_rec in ben_pcg_shd.g_rec_type) is

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

Line 260: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id

256: ,p_pcg_attribute29 =>p_rec.pcg_attribute29
257: ,p_pcg_attribute30 =>p_rec.pcg_attribute30
258: ,p_object_version_number =>p_rec.object_version_number
259: ,p_pl_gd_or_svc_id =>p_rec.pl_gd_or_svc_id
260: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
261: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
262: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1

Line 261: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id

257: ,p_pcg_attribute30 =>p_rec.pcg_attribute30
258: ,p_object_version_number =>p_rec.object_version_number
259: ,p_pl_gd_or_svc_id =>p_rec.pl_gd_or_svc_id
260: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
261: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
262: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2

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

258: ,p_object_version_number =>p_rec.object_version_number
259: ,p_pl_gd_or_svc_id =>p_rec.pl_gd_or_svc_id
260: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
261: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
262: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3

Line 263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category

259: ,p_pl_gd_or_svc_id =>p_rec.pl_gd_or_svc_id
260: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
261: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
262: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4

Line 264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1

260: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
261: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
262: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5

Line 265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2

261: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
262: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6

Line 266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3

262: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7

Line 267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4

263: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8

Line 268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5

264: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9

Line 269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6

265: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10

Line 270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7

266: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11

Line 271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8

267: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12

Line 272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9

268: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13

Line 273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10

269: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14

Line 274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11

270: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15

Line 275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12

271: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16

Line 276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13

272: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17

Line 277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14

273: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18

Line 278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15

274: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19

Line 279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16

275: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20

Line 280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17

276: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21

Line 281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18

277: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22

Line 282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19

278: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23

Line 283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20

279: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24

Line 284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21

280: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25

Line 285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22

281: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26

Line 286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23

282: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27

Line 287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24

283: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28

Line 288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25

284: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29

Line 289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26

285: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
293: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30

Line 290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27

286: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
293: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
294: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number

Line 291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28

287: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
293: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
294: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
295: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id

Line 292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29

288: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
293: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
294: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
295: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id
296: );

Line 293: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30

289: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
293: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
294: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
295: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id
296: );
297: --

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

290: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
293: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
294: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
295: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id
296: );
297: --
298: exception

Line 295: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id

291: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
292: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
293: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
294: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
295: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id
296: );
297: --
298: exception
299: --

Line 357: Procedure convert_defs(p_rec in out nocopy ben_pcg_shd.g_rec_type) is

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

Line 372: ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id;

368: -- is being used then we must set to the 'current' argument value.
369: --
370: If (p_rec.prtt_reimbmt_rqst_id = hr_api.g_number) then
371: p_rec.prtt_reimbmt_rqst_id :=
372: ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id;
373: End If;
374: If (p_rec.gd_or_svc_typ_id = hr_api.g_number) then
375: p_rec.gd_or_svc_typ_id :=
376: ben_pcg_shd.g_old_rec.gd_or_svc_typ_id;

Line 376: ben_pcg_shd.g_old_rec.gd_or_svc_typ_id;

372: ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id;
373: End If;
374: If (p_rec.gd_or_svc_typ_id = hr_api.g_number) then
375: p_rec.gd_or_svc_typ_id :=
376: ben_pcg_shd.g_old_rec.gd_or_svc_typ_id;
377: End If;
378: If (p_rec.business_group_id = hr_api.g_number) then
379: p_rec.business_group_id :=
380: ben_pcg_shd.g_old_rec.business_group_id;

Line 380: ben_pcg_shd.g_old_rec.business_group_id;

376: ben_pcg_shd.g_old_rec.gd_or_svc_typ_id;
377: End If;
378: If (p_rec.business_group_id = hr_api.g_number) then
379: p_rec.business_group_id :=
380: ben_pcg_shd.g_old_rec.business_group_id;
381: End If;
382: If (p_rec.pcg_attribute_category = hr_api.g_varchar2) then
383: p_rec.pcg_attribute_category :=
384: ben_pcg_shd.g_old_rec.pcg_attribute_category;

Line 384: ben_pcg_shd.g_old_rec.pcg_attribute_category;

380: ben_pcg_shd.g_old_rec.business_group_id;
381: End If;
382: If (p_rec.pcg_attribute_category = hr_api.g_varchar2) then
383: p_rec.pcg_attribute_category :=
384: ben_pcg_shd.g_old_rec.pcg_attribute_category;
385: End If;
386: If (p_rec.pcg_attribute1 = hr_api.g_varchar2) then
387: p_rec.pcg_attribute1 :=
388: ben_pcg_shd.g_old_rec.pcg_attribute1;

Line 388: ben_pcg_shd.g_old_rec.pcg_attribute1;

384: ben_pcg_shd.g_old_rec.pcg_attribute_category;
385: End If;
386: If (p_rec.pcg_attribute1 = hr_api.g_varchar2) then
387: p_rec.pcg_attribute1 :=
388: ben_pcg_shd.g_old_rec.pcg_attribute1;
389: End If;
390: If (p_rec.pcg_attribute2 = hr_api.g_varchar2) then
391: p_rec.pcg_attribute2 :=
392: ben_pcg_shd.g_old_rec.pcg_attribute2;

Line 392: ben_pcg_shd.g_old_rec.pcg_attribute2;

388: ben_pcg_shd.g_old_rec.pcg_attribute1;
389: End If;
390: If (p_rec.pcg_attribute2 = hr_api.g_varchar2) then
391: p_rec.pcg_attribute2 :=
392: ben_pcg_shd.g_old_rec.pcg_attribute2;
393: End If;
394: If (p_rec.pcg_attribute3 = hr_api.g_varchar2) then
395: p_rec.pcg_attribute3 :=
396: ben_pcg_shd.g_old_rec.pcg_attribute3;

Line 396: ben_pcg_shd.g_old_rec.pcg_attribute3;

392: ben_pcg_shd.g_old_rec.pcg_attribute2;
393: End If;
394: If (p_rec.pcg_attribute3 = hr_api.g_varchar2) then
395: p_rec.pcg_attribute3 :=
396: ben_pcg_shd.g_old_rec.pcg_attribute3;
397: End If;
398: If (p_rec.pcg_attribute4 = hr_api.g_varchar2) then
399: p_rec.pcg_attribute4 :=
400: ben_pcg_shd.g_old_rec.pcg_attribute4;

Line 400: ben_pcg_shd.g_old_rec.pcg_attribute4;

396: ben_pcg_shd.g_old_rec.pcg_attribute3;
397: End If;
398: If (p_rec.pcg_attribute4 = hr_api.g_varchar2) then
399: p_rec.pcg_attribute4 :=
400: ben_pcg_shd.g_old_rec.pcg_attribute4;
401: End If;
402: If (p_rec.pcg_attribute5 = hr_api.g_varchar2) then
403: p_rec.pcg_attribute5 :=
404: ben_pcg_shd.g_old_rec.pcg_attribute5;

Line 404: ben_pcg_shd.g_old_rec.pcg_attribute5;

400: ben_pcg_shd.g_old_rec.pcg_attribute4;
401: End If;
402: If (p_rec.pcg_attribute5 = hr_api.g_varchar2) then
403: p_rec.pcg_attribute5 :=
404: ben_pcg_shd.g_old_rec.pcg_attribute5;
405: End If;
406: If (p_rec.pcg_attribute6 = hr_api.g_varchar2) then
407: p_rec.pcg_attribute6 :=
408: ben_pcg_shd.g_old_rec.pcg_attribute6;

Line 408: ben_pcg_shd.g_old_rec.pcg_attribute6;

404: ben_pcg_shd.g_old_rec.pcg_attribute5;
405: End If;
406: If (p_rec.pcg_attribute6 = hr_api.g_varchar2) then
407: p_rec.pcg_attribute6 :=
408: ben_pcg_shd.g_old_rec.pcg_attribute6;
409: End If;
410: If (p_rec.pcg_attribute7 = hr_api.g_varchar2) then
411: p_rec.pcg_attribute7 :=
412: ben_pcg_shd.g_old_rec.pcg_attribute7;

Line 412: ben_pcg_shd.g_old_rec.pcg_attribute7;

408: ben_pcg_shd.g_old_rec.pcg_attribute6;
409: End If;
410: If (p_rec.pcg_attribute7 = hr_api.g_varchar2) then
411: p_rec.pcg_attribute7 :=
412: ben_pcg_shd.g_old_rec.pcg_attribute7;
413: End If;
414: If (p_rec.pcg_attribute8 = hr_api.g_varchar2) then
415: p_rec.pcg_attribute8 :=
416: ben_pcg_shd.g_old_rec.pcg_attribute8;

Line 416: ben_pcg_shd.g_old_rec.pcg_attribute8;

412: ben_pcg_shd.g_old_rec.pcg_attribute7;
413: End If;
414: If (p_rec.pcg_attribute8 = hr_api.g_varchar2) then
415: p_rec.pcg_attribute8 :=
416: ben_pcg_shd.g_old_rec.pcg_attribute8;
417: End If;
418: If (p_rec.pcg_attribute9 = hr_api.g_varchar2) then
419: p_rec.pcg_attribute9 :=
420: ben_pcg_shd.g_old_rec.pcg_attribute9;

Line 420: ben_pcg_shd.g_old_rec.pcg_attribute9;

416: ben_pcg_shd.g_old_rec.pcg_attribute8;
417: End If;
418: If (p_rec.pcg_attribute9 = hr_api.g_varchar2) then
419: p_rec.pcg_attribute9 :=
420: ben_pcg_shd.g_old_rec.pcg_attribute9;
421: End If;
422: If (p_rec.pcg_attribute10 = hr_api.g_varchar2) then
423: p_rec.pcg_attribute10 :=
424: ben_pcg_shd.g_old_rec.pcg_attribute10;

Line 424: ben_pcg_shd.g_old_rec.pcg_attribute10;

420: ben_pcg_shd.g_old_rec.pcg_attribute9;
421: End If;
422: If (p_rec.pcg_attribute10 = hr_api.g_varchar2) then
423: p_rec.pcg_attribute10 :=
424: ben_pcg_shd.g_old_rec.pcg_attribute10;
425: End If;
426: If (p_rec.pcg_attribute11 = hr_api.g_varchar2) then
427: p_rec.pcg_attribute11 :=
428: ben_pcg_shd.g_old_rec.pcg_attribute11;

Line 428: ben_pcg_shd.g_old_rec.pcg_attribute11;

424: ben_pcg_shd.g_old_rec.pcg_attribute10;
425: End If;
426: If (p_rec.pcg_attribute11 = hr_api.g_varchar2) then
427: p_rec.pcg_attribute11 :=
428: ben_pcg_shd.g_old_rec.pcg_attribute11;
429: End If;
430: If (p_rec.pcg_attribute12 = hr_api.g_varchar2) then
431: p_rec.pcg_attribute12 :=
432: ben_pcg_shd.g_old_rec.pcg_attribute12;

Line 432: ben_pcg_shd.g_old_rec.pcg_attribute12;

428: ben_pcg_shd.g_old_rec.pcg_attribute11;
429: End If;
430: If (p_rec.pcg_attribute12 = hr_api.g_varchar2) then
431: p_rec.pcg_attribute12 :=
432: ben_pcg_shd.g_old_rec.pcg_attribute12;
433: End If;
434: If (p_rec.pcg_attribute13 = hr_api.g_varchar2) then
435: p_rec.pcg_attribute13 :=
436: ben_pcg_shd.g_old_rec.pcg_attribute13;

Line 436: ben_pcg_shd.g_old_rec.pcg_attribute13;

432: ben_pcg_shd.g_old_rec.pcg_attribute12;
433: End If;
434: If (p_rec.pcg_attribute13 = hr_api.g_varchar2) then
435: p_rec.pcg_attribute13 :=
436: ben_pcg_shd.g_old_rec.pcg_attribute13;
437: End If;
438: If (p_rec.pcg_attribute14 = hr_api.g_varchar2) then
439: p_rec.pcg_attribute14 :=
440: ben_pcg_shd.g_old_rec.pcg_attribute14;

Line 440: ben_pcg_shd.g_old_rec.pcg_attribute14;

436: ben_pcg_shd.g_old_rec.pcg_attribute13;
437: End If;
438: If (p_rec.pcg_attribute14 = hr_api.g_varchar2) then
439: p_rec.pcg_attribute14 :=
440: ben_pcg_shd.g_old_rec.pcg_attribute14;
441: End If;
442: If (p_rec.pcg_attribute15 = hr_api.g_varchar2) then
443: p_rec.pcg_attribute15 :=
444: ben_pcg_shd.g_old_rec.pcg_attribute15;

Line 444: ben_pcg_shd.g_old_rec.pcg_attribute15;

440: ben_pcg_shd.g_old_rec.pcg_attribute14;
441: End If;
442: If (p_rec.pcg_attribute15 = hr_api.g_varchar2) then
443: p_rec.pcg_attribute15 :=
444: ben_pcg_shd.g_old_rec.pcg_attribute15;
445: End If;
446: If (p_rec.pcg_attribute16 = hr_api.g_varchar2) then
447: p_rec.pcg_attribute16 :=
448: ben_pcg_shd.g_old_rec.pcg_attribute16;

Line 448: ben_pcg_shd.g_old_rec.pcg_attribute16;

444: ben_pcg_shd.g_old_rec.pcg_attribute15;
445: End If;
446: If (p_rec.pcg_attribute16 = hr_api.g_varchar2) then
447: p_rec.pcg_attribute16 :=
448: ben_pcg_shd.g_old_rec.pcg_attribute16;
449: End If;
450: If (p_rec.pcg_attribute17 = hr_api.g_varchar2) then
451: p_rec.pcg_attribute17 :=
452: ben_pcg_shd.g_old_rec.pcg_attribute17;

Line 452: ben_pcg_shd.g_old_rec.pcg_attribute17;

448: ben_pcg_shd.g_old_rec.pcg_attribute16;
449: End If;
450: If (p_rec.pcg_attribute17 = hr_api.g_varchar2) then
451: p_rec.pcg_attribute17 :=
452: ben_pcg_shd.g_old_rec.pcg_attribute17;
453: End If;
454: If (p_rec.pcg_attribute18 = hr_api.g_varchar2) then
455: p_rec.pcg_attribute18 :=
456: ben_pcg_shd.g_old_rec.pcg_attribute18;

Line 456: ben_pcg_shd.g_old_rec.pcg_attribute18;

452: ben_pcg_shd.g_old_rec.pcg_attribute17;
453: End If;
454: If (p_rec.pcg_attribute18 = hr_api.g_varchar2) then
455: p_rec.pcg_attribute18 :=
456: ben_pcg_shd.g_old_rec.pcg_attribute18;
457: End If;
458: If (p_rec.pcg_attribute19 = hr_api.g_varchar2) then
459: p_rec.pcg_attribute19 :=
460: ben_pcg_shd.g_old_rec.pcg_attribute19;

Line 460: ben_pcg_shd.g_old_rec.pcg_attribute19;

456: ben_pcg_shd.g_old_rec.pcg_attribute18;
457: End If;
458: If (p_rec.pcg_attribute19 = hr_api.g_varchar2) then
459: p_rec.pcg_attribute19 :=
460: ben_pcg_shd.g_old_rec.pcg_attribute19;
461: End If;
462: If (p_rec.pcg_attribute20 = hr_api.g_varchar2) then
463: p_rec.pcg_attribute20 :=
464: ben_pcg_shd.g_old_rec.pcg_attribute20;

Line 464: ben_pcg_shd.g_old_rec.pcg_attribute20;

460: ben_pcg_shd.g_old_rec.pcg_attribute19;
461: End If;
462: If (p_rec.pcg_attribute20 = hr_api.g_varchar2) then
463: p_rec.pcg_attribute20 :=
464: ben_pcg_shd.g_old_rec.pcg_attribute20;
465: End If;
466: If (p_rec.pcg_attribute21 = hr_api.g_varchar2) then
467: p_rec.pcg_attribute21 :=
468: ben_pcg_shd.g_old_rec.pcg_attribute21;

Line 468: ben_pcg_shd.g_old_rec.pcg_attribute21;

464: ben_pcg_shd.g_old_rec.pcg_attribute20;
465: End If;
466: If (p_rec.pcg_attribute21 = hr_api.g_varchar2) then
467: p_rec.pcg_attribute21 :=
468: ben_pcg_shd.g_old_rec.pcg_attribute21;
469: End If;
470: If (p_rec.pcg_attribute22 = hr_api.g_varchar2) then
471: p_rec.pcg_attribute22 :=
472: ben_pcg_shd.g_old_rec.pcg_attribute22;

Line 472: ben_pcg_shd.g_old_rec.pcg_attribute22;

468: ben_pcg_shd.g_old_rec.pcg_attribute21;
469: End If;
470: If (p_rec.pcg_attribute22 = hr_api.g_varchar2) then
471: p_rec.pcg_attribute22 :=
472: ben_pcg_shd.g_old_rec.pcg_attribute22;
473: End If;
474: If (p_rec.pcg_attribute23 = hr_api.g_varchar2) then
475: p_rec.pcg_attribute23 :=
476: ben_pcg_shd.g_old_rec.pcg_attribute23;

Line 476: ben_pcg_shd.g_old_rec.pcg_attribute23;

472: ben_pcg_shd.g_old_rec.pcg_attribute22;
473: End If;
474: If (p_rec.pcg_attribute23 = hr_api.g_varchar2) then
475: p_rec.pcg_attribute23 :=
476: ben_pcg_shd.g_old_rec.pcg_attribute23;
477: End If;
478: If (p_rec.pcg_attribute24 = hr_api.g_varchar2) then
479: p_rec.pcg_attribute24 :=
480: ben_pcg_shd.g_old_rec.pcg_attribute24;

Line 480: ben_pcg_shd.g_old_rec.pcg_attribute24;

476: ben_pcg_shd.g_old_rec.pcg_attribute23;
477: End If;
478: If (p_rec.pcg_attribute24 = hr_api.g_varchar2) then
479: p_rec.pcg_attribute24 :=
480: ben_pcg_shd.g_old_rec.pcg_attribute24;
481: End If;
482: If (p_rec.pcg_attribute25 = hr_api.g_varchar2) then
483: p_rec.pcg_attribute25 :=
484: ben_pcg_shd.g_old_rec.pcg_attribute25;

Line 484: ben_pcg_shd.g_old_rec.pcg_attribute25;

480: ben_pcg_shd.g_old_rec.pcg_attribute24;
481: End If;
482: If (p_rec.pcg_attribute25 = hr_api.g_varchar2) then
483: p_rec.pcg_attribute25 :=
484: ben_pcg_shd.g_old_rec.pcg_attribute25;
485: End If;
486: If (p_rec.pcg_attribute26 = hr_api.g_varchar2) then
487: p_rec.pcg_attribute26 :=
488: ben_pcg_shd.g_old_rec.pcg_attribute26;

Line 488: ben_pcg_shd.g_old_rec.pcg_attribute26;

484: ben_pcg_shd.g_old_rec.pcg_attribute25;
485: End If;
486: If (p_rec.pcg_attribute26 = hr_api.g_varchar2) then
487: p_rec.pcg_attribute26 :=
488: ben_pcg_shd.g_old_rec.pcg_attribute26;
489: End If;
490: If (p_rec.pcg_attribute27 = hr_api.g_varchar2) then
491: p_rec.pcg_attribute27 :=
492: ben_pcg_shd.g_old_rec.pcg_attribute27;

Line 492: ben_pcg_shd.g_old_rec.pcg_attribute27;

488: ben_pcg_shd.g_old_rec.pcg_attribute26;
489: End If;
490: If (p_rec.pcg_attribute27 = hr_api.g_varchar2) then
491: p_rec.pcg_attribute27 :=
492: ben_pcg_shd.g_old_rec.pcg_attribute27;
493: End If;
494: If (p_rec.pcg_attribute28 = hr_api.g_varchar2) then
495: p_rec.pcg_attribute28 :=
496: ben_pcg_shd.g_old_rec.pcg_attribute28;

Line 496: ben_pcg_shd.g_old_rec.pcg_attribute28;

492: ben_pcg_shd.g_old_rec.pcg_attribute27;
493: End If;
494: If (p_rec.pcg_attribute28 = hr_api.g_varchar2) then
495: p_rec.pcg_attribute28 :=
496: ben_pcg_shd.g_old_rec.pcg_attribute28;
497: End If;
498: If (p_rec.pcg_attribute29 = hr_api.g_varchar2) then
499: p_rec.pcg_attribute29 :=
500: ben_pcg_shd.g_old_rec.pcg_attribute29;

Line 500: ben_pcg_shd.g_old_rec.pcg_attribute29;

496: ben_pcg_shd.g_old_rec.pcg_attribute28;
497: End If;
498: If (p_rec.pcg_attribute29 = hr_api.g_varchar2) then
499: p_rec.pcg_attribute29 :=
500: ben_pcg_shd.g_old_rec.pcg_attribute29;
501: End If;
502: If (p_rec.pcg_attribute30 = hr_api.g_varchar2) then
503: p_rec.pcg_attribute30 :=
504: ben_pcg_shd.g_old_rec.pcg_attribute30;

Line 504: ben_pcg_shd.g_old_rec.pcg_attribute30;

500: ben_pcg_shd.g_old_rec.pcg_attribute29;
501: End If;
502: If (p_rec.pcg_attribute30 = hr_api.g_varchar2) then
503: p_rec.pcg_attribute30 :=
504: ben_pcg_shd.g_old_rec.pcg_attribute30;
505: End If;
506: if (p_rec.pl_gd_or_svc_id = hr_api.g_number) then
507: p_rec.pl_gd_or_svc_id := ben_pcg_shd.g_old_rec.pl_gd_or_svc_id ;
508: end if ;

Line 507: p_rec.pl_gd_or_svc_id := ben_pcg_shd.g_old_rec.pl_gd_or_svc_id ;

503: p_rec.pcg_attribute30 :=
504: ben_pcg_shd.g_old_rec.pcg_attribute30;
505: End If;
506: if (p_rec.pl_gd_or_svc_id = hr_api.g_number) then
507: p_rec.pl_gd_or_svc_id := ben_pcg_shd.g_old_rec.pl_gd_or_svc_id ;
508: end if ;
509: --
510: hr_utility.set_location(' Leaving:'||l_proc, 10);
511: --

Line 519: p_rec in out nocopy ben_pcg_shd.g_rec_type

515: -- |---------------------------------< upd >----------------------------------|
516: -- ----------------------------------------------------------------------------
517: Procedure upd
518: (
519: p_rec in out nocopy ben_pcg_shd.g_rec_type
520: ) is
521: --
522: l_proc varchar2(72) := g_package||'upd';
523: --

Line 529: ben_pcg_shd.lck

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

Line 601: l_rec ben_pcg_shd.g_rec_type;

597: p_object_version_number in out nocopy number ,
598: p_pl_gd_or_svc_id in number default hr_api.g_number
599: ) is
600: --
601: l_rec ben_pcg_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_pcg_shd.convert_args

607: -- Call conversion function to turn arguments into the
608: -- l_rec structure.
609: --
610: l_rec :=
611: ben_pcg_shd.convert_args
612: (
613: p_prtt_clm_gd_or_svc_typ_id,
614: p_prtt_reimbmt_rqst_id,
615: p_gd_or_svc_typ_id,