eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CPY_UPD dependencies on BEN_CPY_SHD

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

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

Line 113: ben_cpy_shd.g_api_dml := false; -- Unset the api dml status

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

Line 120: ben_cpy_shd.g_api_dml := false; -- Unset the api dml status

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

Line 121: ben_cpy_shd.constraint_error

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

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

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

Line 126: ben_cpy_shd.constraint_error

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

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

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

Line 131: ben_cpy_shd.constraint_error

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

Line 134: ben_cpy_shd.g_api_dml := false; -- Unset the api dml status

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

Line 170: Procedure pre_update(p_rec in ben_cpy_shd.g_rec_type) is

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

Line 212: Procedure post_update(p_rec in ben_cpy_shd.g_rec_type) is

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

Line 266: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id

262: ,p_cpy_attribute28 =>p_rec.cpy_attribute28
263: ,p_cpy_attribute29 =>p_rec.cpy_attribute29
264: ,p_cpy_attribute30 =>p_rec.cpy_attribute30
265: ,p_object_version_number =>p_rec.object_version_number
266: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
267: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
268: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num

Line 267: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id

263: ,p_cpy_attribute29 =>p_rec.cpy_attribute29
264: ,p_cpy_attribute30 =>p_rec.cpy_attribute30
265: ,p_object_version_number =>p_rec.object_version_number
266: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
267: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
268: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt

Line 268: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id

264: ,p_cpy_attribute30 =>p_rec.cpy_attribute30
265: ,p_object_version_number =>p_rec.object_version_number
266: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
267: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
268: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt

Line 269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id

265: ,p_object_version_number =>p_rec.object_version_number
266: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
267: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
268: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category

Line 270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num

266: ,p_yr_perd_id_o =>ben_cpy_shd.g_old_rec.yr_perd_id
267: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
268: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1

Line 271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt

267: ,p_business_group_id_o =>ben_cpy_shd.g_old_rec.business_group_id
268: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2

Line 272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt

268: ,p_pl_id_o =>ben_cpy_shd.g_old_rec.pl_id
269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3

Line 273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category

269: ,p_pgm_id_o =>ben_cpy_shd.g_old_rec.pgm_id
270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4

Line 274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1

270: ,p_ordr_num_o =>ben_cpy_shd.g_old_rec.ordr_num
271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5

Line 275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2

271: ,p_acpt_clm_rqsts_thru_dt_o =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6

Line 276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3

272: ,p_py_clms_thru_dt_o =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7

Line 277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4

273: ,p_cpy_attribute_category_o =>ben_cpy_shd.g_old_rec.cpy_attribute_category
274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8

Line 278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5

274: ,p_cpy_attribute1_o =>ben_cpy_shd.g_old_rec.cpy_attribute1
275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9

Line 279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6

275: ,p_cpy_attribute2_o =>ben_cpy_shd.g_old_rec.cpy_attribute2
276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10

Line 280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7

276: ,p_cpy_attribute3_o =>ben_cpy_shd.g_old_rec.cpy_attribute3
277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11

Line 281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8

277: ,p_cpy_attribute4_o =>ben_cpy_shd.g_old_rec.cpy_attribute4
278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12

Line 282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9

278: ,p_cpy_attribute5_o =>ben_cpy_shd.g_old_rec.cpy_attribute5
279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13

Line 283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10

279: ,p_cpy_attribute6_o =>ben_cpy_shd.g_old_rec.cpy_attribute6
280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14

Line 284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11

280: ,p_cpy_attribute7_o =>ben_cpy_shd.g_old_rec.cpy_attribute7
281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15

Line 285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12

281: ,p_cpy_attribute8_o =>ben_cpy_shd.g_old_rec.cpy_attribute8
282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16

Line 286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13

282: ,p_cpy_attribute9_o =>ben_cpy_shd.g_old_rec.cpy_attribute9
283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17

Line 287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14

283: ,p_cpy_attribute10_o =>ben_cpy_shd.g_old_rec.cpy_attribute10
284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18

Line 288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15

284: ,p_cpy_attribute11_o =>ben_cpy_shd.g_old_rec.cpy_attribute11
285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19

Line 289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16

285: ,p_cpy_attribute12_o =>ben_cpy_shd.g_old_rec.cpy_attribute12
286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20

Line 290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17

286: ,p_cpy_attribute13_o =>ben_cpy_shd.g_old_rec.cpy_attribute13
287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21

Line 291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18

287: ,p_cpy_attribute14_o =>ben_cpy_shd.g_old_rec.cpy_attribute14
288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22

Line 292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19

288: ,p_cpy_attribute15_o =>ben_cpy_shd.g_old_rec.cpy_attribute15
289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23

Line 293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20

289: ,p_cpy_attribute16_o =>ben_cpy_shd.g_old_rec.cpy_attribute16
290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24

Line 294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21

290: ,p_cpy_attribute17_o =>ben_cpy_shd.g_old_rec.cpy_attribute17
291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25

Line 295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22

291: ,p_cpy_attribute18_o =>ben_cpy_shd.g_old_rec.cpy_attribute18
292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26

Line 296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23

292: ,p_cpy_attribute19_o =>ben_cpy_shd.g_old_rec.cpy_attribute19
293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27

Line 297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24

293: ,p_cpy_attribute20_o =>ben_cpy_shd.g_old_rec.cpy_attribute20
294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28

Line 298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25

294: ,p_cpy_attribute21_o =>ben_cpy_shd.g_old_rec.cpy_attribute21
295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
302: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29

Line 299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26

295: ,p_cpy_attribute22_o =>ben_cpy_shd.g_old_rec.cpy_attribute22
296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
302: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
303: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30

Line 300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27

296: ,p_cpy_attribute23_o =>ben_cpy_shd.g_old_rec.cpy_attribute23
297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
302: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
303: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
304: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number

Line 301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28

297: ,p_cpy_attribute24_o =>ben_cpy_shd.g_old_rec.cpy_attribute24
298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
302: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
303: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
304: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number
305: );

Line 302: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29

298: ,p_cpy_attribute25_o =>ben_cpy_shd.g_old_rec.cpy_attribute25
299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
302: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
303: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
304: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number
305: );
306: --

Line 303: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30

299: ,p_cpy_attribute26_o =>ben_cpy_shd.g_old_rec.cpy_attribute26
300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
302: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
303: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
304: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number
305: );
306: --
307: exception

Line 304: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number

300: ,p_cpy_attribute27_o =>ben_cpy_shd.g_old_rec.cpy_attribute27
301: ,p_cpy_attribute28_o =>ben_cpy_shd.g_old_rec.cpy_attribute28
302: ,p_cpy_attribute29_o =>ben_cpy_shd.g_old_rec.cpy_attribute29
303: ,p_cpy_attribute30_o =>ben_cpy_shd.g_old_rec.cpy_attribute30
304: ,p_object_version_number_o =>ben_cpy_shd.g_old_rec.object_version_number
305: );
306: --
307: exception
308: --

Line 366: Procedure convert_defs(p_rec in out nocopy ben_cpy_shd.g_rec_type) is

362: -- Internal Row Handler Use Only.
363: --
364: -- {End Of Comments}
365: -- ----------------------------------------------------------------------------
366: Procedure convert_defs(p_rec in out nocopy ben_cpy_shd.g_rec_type) is
367: --
368: l_proc varchar2(72) := g_package||'convert_defs';
369: --
370: Begin

Line 381: ben_cpy_shd.g_old_rec.yr_perd_id;

377: -- is being used then we must set to the 'current' argument value.
378: --
379: If (p_rec.yr_perd_id = hr_api.g_number) then
380: p_rec.yr_perd_id :=
381: ben_cpy_shd.g_old_rec.yr_perd_id;
382: End If;
383: If (p_rec.business_group_id = hr_api.g_number) then
384: p_rec.business_group_id :=
385: ben_cpy_shd.g_old_rec.business_group_id;

Line 385: ben_cpy_shd.g_old_rec.business_group_id;

381: ben_cpy_shd.g_old_rec.yr_perd_id;
382: End If;
383: If (p_rec.business_group_id = hr_api.g_number) then
384: p_rec.business_group_id :=
385: ben_cpy_shd.g_old_rec.business_group_id;
386: End If;
387: If (p_rec.pl_id = hr_api.g_number) then
388: p_rec.pl_id :=
389: ben_cpy_shd.g_old_rec.pl_id;

Line 389: ben_cpy_shd.g_old_rec.pl_id;

385: ben_cpy_shd.g_old_rec.business_group_id;
386: End If;
387: If (p_rec.pl_id = hr_api.g_number) then
388: p_rec.pl_id :=
389: ben_cpy_shd.g_old_rec.pl_id;
390: End If;
391: If (p_rec.pgm_id = hr_api.g_number) then
392: p_rec.pgm_id :=
393: ben_cpy_shd.g_old_rec.pgm_id;

Line 393: ben_cpy_shd.g_old_rec.pgm_id;

389: ben_cpy_shd.g_old_rec.pl_id;
390: End If;
391: If (p_rec.pgm_id = hr_api.g_number) then
392: p_rec.pgm_id :=
393: ben_cpy_shd.g_old_rec.pgm_id;
394: End If;
395: If (p_rec.ordr_num = hr_api.g_number) then
396: p_rec.ordr_num :=
397: ben_cpy_shd.g_old_rec.ordr_num;

Line 397: ben_cpy_shd.g_old_rec.ordr_num;

393: ben_cpy_shd.g_old_rec.pgm_id;
394: End If;
395: If (p_rec.ordr_num = hr_api.g_number) then
396: p_rec.ordr_num :=
397: ben_cpy_shd.g_old_rec.ordr_num;
398: End If;
399: If (p_rec.acpt_clm_rqsts_thru_dt = hr_api.g_date) then
400: p_rec.acpt_clm_rqsts_thru_dt :=
401: ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt;

Line 401: ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt;

397: ben_cpy_shd.g_old_rec.ordr_num;
398: End If;
399: If (p_rec.acpt_clm_rqsts_thru_dt = hr_api.g_date) then
400: p_rec.acpt_clm_rqsts_thru_dt :=
401: ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt;
402: End If;
403: If (p_rec.py_clms_thru_dt = hr_api.g_date) then
404: p_rec.py_clms_thru_dt :=
405: ben_cpy_shd.g_old_rec.py_clms_thru_dt;

Line 405: ben_cpy_shd.g_old_rec.py_clms_thru_dt;

401: ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt;
402: End If;
403: If (p_rec.py_clms_thru_dt = hr_api.g_date) then
404: p_rec.py_clms_thru_dt :=
405: ben_cpy_shd.g_old_rec.py_clms_thru_dt;
406: End If;
407: If (p_rec.cpy_attribute_category = hr_api.g_varchar2) then
408: p_rec.cpy_attribute_category :=
409: ben_cpy_shd.g_old_rec.cpy_attribute_category;

Line 409: ben_cpy_shd.g_old_rec.cpy_attribute_category;

405: ben_cpy_shd.g_old_rec.py_clms_thru_dt;
406: End If;
407: If (p_rec.cpy_attribute_category = hr_api.g_varchar2) then
408: p_rec.cpy_attribute_category :=
409: ben_cpy_shd.g_old_rec.cpy_attribute_category;
410: End If;
411: If (p_rec.cpy_attribute1 = hr_api.g_varchar2) then
412: p_rec.cpy_attribute1 :=
413: ben_cpy_shd.g_old_rec.cpy_attribute1;

Line 413: ben_cpy_shd.g_old_rec.cpy_attribute1;

409: ben_cpy_shd.g_old_rec.cpy_attribute_category;
410: End If;
411: If (p_rec.cpy_attribute1 = hr_api.g_varchar2) then
412: p_rec.cpy_attribute1 :=
413: ben_cpy_shd.g_old_rec.cpy_attribute1;
414: End If;
415: If (p_rec.cpy_attribute2 = hr_api.g_varchar2) then
416: p_rec.cpy_attribute2 :=
417: ben_cpy_shd.g_old_rec.cpy_attribute2;

Line 417: ben_cpy_shd.g_old_rec.cpy_attribute2;

413: ben_cpy_shd.g_old_rec.cpy_attribute1;
414: End If;
415: If (p_rec.cpy_attribute2 = hr_api.g_varchar2) then
416: p_rec.cpy_attribute2 :=
417: ben_cpy_shd.g_old_rec.cpy_attribute2;
418: End If;
419: If (p_rec.cpy_attribute3 = hr_api.g_varchar2) then
420: p_rec.cpy_attribute3 :=
421: ben_cpy_shd.g_old_rec.cpy_attribute3;

Line 421: ben_cpy_shd.g_old_rec.cpy_attribute3;

417: ben_cpy_shd.g_old_rec.cpy_attribute2;
418: End If;
419: If (p_rec.cpy_attribute3 = hr_api.g_varchar2) then
420: p_rec.cpy_attribute3 :=
421: ben_cpy_shd.g_old_rec.cpy_attribute3;
422: End If;
423: If (p_rec.cpy_attribute4 = hr_api.g_varchar2) then
424: p_rec.cpy_attribute4 :=
425: ben_cpy_shd.g_old_rec.cpy_attribute4;

Line 425: ben_cpy_shd.g_old_rec.cpy_attribute4;

421: ben_cpy_shd.g_old_rec.cpy_attribute3;
422: End If;
423: If (p_rec.cpy_attribute4 = hr_api.g_varchar2) then
424: p_rec.cpy_attribute4 :=
425: ben_cpy_shd.g_old_rec.cpy_attribute4;
426: End If;
427: If (p_rec.cpy_attribute5 = hr_api.g_varchar2) then
428: p_rec.cpy_attribute5 :=
429: ben_cpy_shd.g_old_rec.cpy_attribute5;

Line 429: ben_cpy_shd.g_old_rec.cpy_attribute5;

425: ben_cpy_shd.g_old_rec.cpy_attribute4;
426: End If;
427: If (p_rec.cpy_attribute5 = hr_api.g_varchar2) then
428: p_rec.cpy_attribute5 :=
429: ben_cpy_shd.g_old_rec.cpy_attribute5;
430: End If;
431: If (p_rec.cpy_attribute6 = hr_api.g_varchar2) then
432: p_rec.cpy_attribute6 :=
433: ben_cpy_shd.g_old_rec.cpy_attribute6;

Line 433: ben_cpy_shd.g_old_rec.cpy_attribute6;

429: ben_cpy_shd.g_old_rec.cpy_attribute5;
430: End If;
431: If (p_rec.cpy_attribute6 = hr_api.g_varchar2) then
432: p_rec.cpy_attribute6 :=
433: ben_cpy_shd.g_old_rec.cpy_attribute6;
434: End If;
435: If (p_rec.cpy_attribute7 = hr_api.g_varchar2) then
436: p_rec.cpy_attribute7 :=
437: ben_cpy_shd.g_old_rec.cpy_attribute7;

Line 437: ben_cpy_shd.g_old_rec.cpy_attribute7;

433: ben_cpy_shd.g_old_rec.cpy_attribute6;
434: End If;
435: If (p_rec.cpy_attribute7 = hr_api.g_varchar2) then
436: p_rec.cpy_attribute7 :=
437: ben_cpy_shd.g_old_rec.cpy_attribute7;
438: End If;
439: If (p_rec.cpy_attribute8 = hr_api.g_varchar2) then
440: p_rec.cpy_attribute8 :=
441: ben_cpy_shd.g_old_rec.cpy_attribute8;

Line 441: ben_cpy_shd.g_old_rec.cpy_attribute8;

437: ben_cpy_shd.g_old_rec.cpy_attribute7;
438: End If;
439: If (p_rec.cpy_attribute8 = hr_api.g_varchar2) then
440: p_rec.cpy_attribute8 :=
441: ben_cpy_shd.g_old_rec.cpy_attribute8;
442: End If;
443: If (p_rec.cpy_attribute9 = hr_api.g_varchar2) then
444: p_rec.cpy_attribute9 :=
445: ben_cpy_shd.g_old_rec.cpy_attribute9;

Line 445: ben_cpy_shd.g_old_rec.cpy_attribute9;

441: ben_cpy_shd.g_old_rec.cpy_attribute8;
442: End If;
443: If (p_rec.cpy_attribute9 = hr_api.g_varchar2) then
444: p_rec.cpy_attribute9 :=
445: ben_cpy_shd.g_old_rec.cpy_attribute9;
446: End If;
447: If (p_rec.cpy_attribute10 = hr_api.g_varchar2) then
448: p_rec.cpy_attribute10 :=
449: ben_cpy_shd.g_old_rec.cpy_attribute10;

Line 449: ben_cpy_shd.g_old_rec.cpy_attribute10;

445: ben_cpy_shd.g_old_rec.cpy_attribute9;
446: End If;
447: If (p_rec.cpy_attribute10 = hr_api.g_varchar2) then
448: p_rec.cpy_attribute10 :=
449: ben_cpy_shd.g_old_rec.cpy_attribute10;
450: End If;
451: If (p_rec.cpy_attribute11 = hr_api.g_varchar2) then
452: p_rec.cpy_attribute11 :=
453: ben_cpy_shd.g_old_rec.cpy_attribute11;

Line 453: ben_cpy_shd.g_old_rec.cpy_attribute11;

449: ben_cpy_shd.g_old_rec.cpy_attribute10;
450: End If;
451: If (p_rec.cpy_attribute11 = hr_api.g_varchar2) then
452: p_rec.cpy_attribute11 :=
453: ben_cpy_shd.g_old_rec.cpy_attribute11;
454: End If;
455: If (p_rec.cpy_attribute12 = hr_api.g_varchar2) then
456: p_rec.cpy_attribute12 :=
457: ben_cpy_shd.g_old_rec.cpy_attribute12;

Line 457: ben_cpy_shd.g_old_rec.cpy_attribute12;

453: ben_cpy_shd.g_old_rec.cpy_attribute11;
454: End If;
455: If (p_rec.cpy_attribute12 = hr_api.g_varchar2) then
456: p_rec.cpy_attribute12 :=
457: ben_cpy_shd.g_old_rec.cpy_attribute12;
458: End If;
459: If (p_rec.cpy_attribute13 = hr_api.g_varchar2) then
460: p_rec.cpy_attribute13 :=
461: ben_cpy_shd.g_old_rec.cpy_attribute13;

Line 461: ben_cpy_shd.g_old_rec.cpy_attribute13;

457: ben_cpy_shd.g_old_rec.cpy_attribute12;
458: End If;
459: If (p_rec.cpy_attribute13 = hr_api.g_varchar2) then
460: p_rec.cpy_attribute13 :=
461: ben_cpy_shd.g_old_rec.cpy_attribute13;
462: End If;
463: If (p_rec.cpy_attribute14 = hr_api.g_varchar2) then
464: p_rec.cpy_attribute14 :=
465: ben_cpy_shd.g_old_rec.cpy_attribute14;

Line 465: ben_cpy_shd.g_old_rec.cpy_attribute14;

461: ben_cpy_shd.g_old_rec.cpy_attribute13;
462: End If;
463: If (p_rec.cpy_attribute14 = hr_api.g_varchar2) then
464: p_rec.cpy_attribute14 :=
465: ben_cpy_shd.g_old_rec.cpy_attribute14;
466: End If;
467: If (p_rec.cpy_attribute15 = hr_api.g_varchar2) then
468: p_rec.cpy_attribute15 :=
469: ben_cpy_shd.g_old_rec.cpy_attribute15;

Line 469: ben_cpy_shd.g_old_rec.cpy_attribute15;

465: ben_cpy_shd.g_old_rec.cpy_attribute14;
466: End If;
467: If (p_rec.cpy_attribute15 = hr_api.g_varchar2) then
468: p_rec.cpy_attribute15 :=
469: ben_cpy_shd.g_old_rec.cpy_attribute15;
470: End If;
471: If (p_rec.cpy_attribute16 = hr_api.g_varchar2) then
472: p_rec.cpy_attribute16 :=
473: ben_cpy_shd.g_old_rec.cpy_attribute16;

Line 473: ben_cpy_shd.g_old_rec.cpy_attribute16;

469: ben_cpy_shd.g_old_rec.cpy_attribute15;
470: End If;
471: If (p_rec.cpy_attribute16 = hr_api.g_varchar2) then
472: p_rec.cpy_attribute16 :=
473: ben_cpy_shd.g_old_rec.cpy_attribute16;
474: End If;
475: If (p_rec.cpy_attribute17 = hr_api.g_varchar2) then
476: p_rec.cpy_attribute17 :=
477: ben_cpy_shd.g_old_rec.cpy_attribute17;

Line 477: ben_cpy_shd.g_old_rec.cpy_attribute17;

473: ben_cpy_shd.g_old_rec.cpy_attribute16;
474: End If;
475: If (p_rec.cpy_attribute17 = hr_api.g_varchar2) then
476: p_rec.cpy_attribute17 :=
477: ben_cpy_shd.g_old_rec.cpy_attribute17;
478: End If;
479: If (p_rec.cpy_attribute18 = hr_api.g_varchar2) then
480: p_rec.cpy_attribute18 :=
481: ben_cpy_shd.g_old_rec.cpy_attribute18;

Line 481: ben_cpy_shd.g_old_rec.cpy_attribute18;

477: ben_cpy_shd.g_old_rec.cpy_attribute17;
478: End If;
479: If (p_rec.cpy_attribute18 = hr_api.g_varchar2) then
480: p_rec.cpy_attribute18 :=
481: ben_cpy_shd.g_old_rec.cpy_attribute18;
482: End If;
483: If (p_rec.cpy_attribute19 = hr_api.g_varchar2) then
484: p_rec.cpy_attribute19 :=
485: ben_cpy_shd.g_old_rec.cpy_attribute19;

Line 485: ben_cpy_shd.g_old_rec.cpy_attribute19;

481: ben_cpy_shd.g_old_rec.cpy_attribute18;
482: End If;
483: If (p_rec.cpy_attribute19 = hr_api.g_varchar2) then
484: p_rec.cpy_attribute19 :=
485: ben_cpy_shd.g_old_rec.cpy_attribute19;
486: End If;
487: If (p_rec.cpy_attribute20 = hr_api.g_varchar2) then
488: p_rec.cpy_attribute20 :=
489: ben_cpy_shd.g_old_rec.cpy_attribute20;

Line 489: ben_cpy_shd.g_old_rec.cpy_attribute20;

485: ben_cpy_shd.g_old_rec.cpy_attribute19;
486: End If;
487: If (p_rec.cpy_attribute20 = hr_api.g_varchar2) then
488: p_rec.cpy_attribute20 :=
489: ben_cpy_shd.g_old_rec.cpy_attribute20;
490: End If;
491: If (p_rec.cpy_attribute21 = hr_api.g_varchar2) then
492: p_rec.cpy_attribute21 :=
493: ben_cpy_shd.g_old_rec.cpy_attribute21;

Line 493: ben_cpy_shd.g_old_rec.cpy_attribute21;

489: ben_cpy_shd.g_old_rec.cpy_attribute20;
490: End If;
491: If (p_rec.cpy_attribute21 = hr_api.g_varchar2) then
492: p_rec.cpy_attribute21 :=
493: ben_cpy_shd.g_old_rec.cpy_attribute21;
494: End If;
495: If (p_rec.cpy_attribute22 = hr_api.g_varchar2) then
496: p_rec.cpy_attribute22 :=
497: ben_cpy_shd.g_old_rec.cpy_attribute22;

Line 497: ben_cpy_shd.g_old_rec.cpy_attribute22;

493: ben_cpy_shd.g_old_rec.cpy_attribute21;
494: End If;
495: If (p_rec.cpy_attribute22 = hr_api.g_varchar2) then
496: p_rec.cpy_attribute22 :=
497: ben_cpy_shd.g_old_rec.cpy_attribute22;
498: End If;
499: If (p_rec.cpy_attribute23 = hr_api.g_varchar2) then
500: p_rec.cpy_attribute23 :=
501: ben_cpy_shd.g_old_rec.cpy_attribute23;

Line 501: ben_cpy_shd.g_old_rec.cpy_attribute23;

497: ben_cpy_shd.g_old_rec.cpy_attribute22;
498: End If;
499: If (p_rec.cpy_attribute23 = hr_api.g_varchar2) then
500: p_rec.cpy_attribute23 :=
501: ben_cpy_shd.g_old_rec.cpy_attribute23;
502: End If;
503: If (p_rec.cpy_attribute24 = hr_api.g_varchar2) then
504: p_rec.cpy_attribute24 :=
505: ben_cpy_shd.g_old_rec.cpy_attribute24;

Line 505: ben_cpy_shd.g_old_rec.cpy_attribute24;

501: ben_cpy_shd.g_old_rec.cpy_attribute23;
502: End If;
503: If (p_rec.cpy_attribute24 = hr_api.g_varchar2) then
504: p_rec.cpy_attribute24 :=
505: ben_cpy_shd.g_old_rec.cpy_attribute24;
506: End If;
507: If (p_rec.cpy_attribute25 = hr_api.g_varchar2) then
508: p_rec.cpy_attribute25 :=
509: ben_cpy_shd.g_old_rec.cpy_attribute25;

Line 509: ben_cpy_shd.g_old_rec.cpy_attribute25;

505: ben_cpy_shd.g_old_rec.cpy_attribute24;
506: End If;
507: If (p_rec.cpy_attribute25 = hr_api.g_varchar2) then
508: p_rec.cpy_attribute25 :=
509: ben_cpy_shd.g_old_rec.cpy_attribute25;
510: End If;
511: If (p_rec.cpy_attribute26 = hr_api.g_varchar2) then
512: p_rec.cpy_attribute26 :=
513: ben_cpy_shd.g_old_rec.cpy_attribute26;

Line 513: ben_cpy_shd.g_old_rec.cpy_attribute26;

509: ben_cpy_shd.g_old_rec.cpy_attribute25;
510: End If;
511: If (p_rec.cpy_attribute26 = hr_api.g_varchar2) then
512: p_rec.cpy_attribute26 :=
513: ben_cpy_shd.g_old_rec.cpy_attribute26;
514: End If;
515: If (p_rec.cpy_attribute27 = hr_api.g_varchar2) then
516: p_rec.cpy_attribute27 :=
517: ben_cpy_shd.g_old_rec.cpy_attribute27;

Line 517: ben_cpy_shd.g_old_rec.cpy_attribute27;

513: ben_cpy_shd.g_old_rec.cpy_attribute26;
514: End If;
515: If (p_rec.cpy_attribute27 = hr_api.g_varchar2) then
516: p_rec.cpy_attribute27 :=
517: ben_cpy_shd.g_old_rec.cpy_attribute27;
518: End If;
519: If (p_rec.cpy_attribute28 = hr_api.g_varchar2) then
520: p_rec.cpy_attribute28 :=
521: ben_cpy_shd.g_old_rec.cpy_attribute28;

Line 521: ben_cpy_shd.g_old_rec.cpy_attribute28;

517: ben_cpy_shd.g_old_rec.cpy_attribute27;
518: End If;
519: If (p_rec.cpy_attribute28 = hr_api.g_varchar2) then
520: p_rec.cpy_attribute28 :=
521: ben_cpy_shd.g_old_rec.cpy_attribute28;
522: End If;
523: If (p_rec.cpy_attribute29 = hr_api.g_varchar2) then
524: p_rec.cpy_attribute29 :=
525: ben_cpy_shd.g_old_rec.cpy_attribute29;

Line 525: ben_cpy_shd.g_old_rec.cpy_attribute29;

521: ben_cpy_shd.g_old_rec.cpy_attribute28;
522: End If;
523: If (p_rec.cpy_attribute29 = hr_api.g_varchar2) then
524: p_rec.cpy_attribute29 :=
525: ben_cpy_shd.g_old_rec.cpy_attribute29;
526: End If;
527: If (p_rec.cpy_attribute30 = hr_api.g_varchar2) then
528: p_rec.cpy_attribute30 :=
529: ben_cpy_shd.g_old_rec.cpy_attribute30;

Line 529: ben_cpy_shd.g_old_rec.cpy_attribute30;

525: ben_cpy_shd.g_old_rec.cpy_attribute29;
526: End If;
527: If (p_rec.cpy_attribute30 = hr_api.g_varchar2) then
528: p_rec.cpy_attribute30 :=
529: ben_cpy_shd.g_old_rec.cpy_attribute30;
530: End If;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
533: --

Line 541: p_rec in out nocopy ben_cpy_shd.g_rec_type

537: -- |---------------------------------< upd >----------------------------------|
538: -- ----------------------------------------------------------------------------
539: Procedure upd
540: (
541: p_rec in out nocopy ben_cpy_shd.g_rec_type
542: ) is
543: --
544: l_proc varchar2(72) := g_package||'upd';
545: --

Line 551: ben_cpy_shd.lck

547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- We must lock the row which we need to update.
550: --
551: ben_cpy_shd.lck
552: (
553: p_rec.popl_yr_perd_id,
554: p_rec.object_version_number
555: );

Line 626: l_rec ben_cpy_shd.g_rec_type;

622: p_cpy_attribute30 in varchar2 default hr_api.g_varchar2,
623: p_object_version_number in out nocopy number
624: ) is
625: --
626: l_rec ben_cpy_shd.g_rec_type;
627: l_proc varchar2(72) := g_package||'upd';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);

Line 636: ben_cpy_shd.convert_args

632: -- Call conversion function to turn arguments into the
633: -- l_rec structure.
634: --
635: l_rec :=
636: ben_cpy_shd.convert_args
637: (
638: p_popl_yr_perd_id,
639: p_yr_perd_id,
640: p_business_group_id,