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_YRP_UPD dependencies on BEN_YRP_SHD

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

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

Line 114: ben_yrp_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 122: ben_yrp_shd.constraint_error

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

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

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

Line 127: ben_yrp_shd.constraint_error

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

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

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

Line 132: ben_yrp_shd.constraint_error

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

Line 135: ben_yrp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 171: Procedure pre_update(p_rec in ben_yrp_shd.g_rec_type) is

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

Line 214: p_effective_date in date,p_rec in ben_yrp_shd.g_rec_type) is

210: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update(
214: p_effective_date in date,p_rec in ben_yrp_shd.g_rec_type) is
215: --
216: l_proc varchar2(72) := g_package||'post_update';
217: --
218: Begin

Line 270: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num

266: ,p_yrp_attribute29 =>p_rec.yrp_attribute29
267: ,p_yrp_attribute30 =>p_rec.yrp_attribute30
268: ,p_object_version_number =>p_rec.object_version_number
269: ,p_effective_date =>p_effective_date
270: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
271: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
272: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date

Line 271: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd

267: ,p_yrp_attribute30 =>p_rec.yrp_attribute30
268: ,p_object_version_number =>p_rec.object_version_number
269: ,p_effective_date =>p_effective_date
270: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
271: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
272: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt

Line 272: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd

268: ,p_object_version_number =>p_rec.object_version_number
269: ,p_effective_date =>p_effective_date
270: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
271: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
272: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt

Line 273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date

269: ,p_effective_date =>p_effective_date
270: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
271: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
272: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id

Line 274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date

270: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
271: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
272: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category

Line 275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt

271: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
272: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1

Line 276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt

272: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2

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

273: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3

Line 278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category

274: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4

Line 279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1

275: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5

Line 280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2

276: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6

Line 281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3

277: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7

Line 282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4

278: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8

Line 283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5

279: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9

Line 284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6

280: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10

Line 285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7

281: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11

Line 286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8

282: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12

Line 287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9

283: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13

Line 288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10

284: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14

Line 289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11

285: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15

Line 290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12

286: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16

Line 291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13

287: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17

Line 292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14

288: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18

Line 293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15

289: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19

Line 294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16

290: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20

Line 295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17

291: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21

Line 296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18

292: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22

Line 297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19

293: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23

Line 298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20

294: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24

Line 299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21

295: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25

Line 300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22

296: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26

Line 301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23

297: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27

Line 302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24

298: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28

Line 303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25

299: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
307: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29

Line 304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26

300: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
307: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
308: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30

Line 305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27

301: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
307: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
308: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
309: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number

Line 306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28

302: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
307: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
308: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
309: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number
310: );

Line 307: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29

303: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
307: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
308: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
309: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number
310: );
311: --

Line 308: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30

304: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
307: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
308: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
309: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number
310: );
311: --
312: exception

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

305: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
306: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
307: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
308: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
309: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number
310: );
311: --
312: exception
313: --

Line 371: Procedure convert_defs(p_rec in out nocopy ben_yrp_shd.g_rec_type) is

367: -- Internal Row Handler Use Only.
368: --
369: -- {End Of Comments}
370: -- ----------------------------------------------------------------------------
371: Procedure convert_defs(p_rec in out nocopy ben_yrp_shd.g_rec_type) is
372: --
373: l_proc varchar2(72) := g_package||'convert_defs';
374: --
375: Begin

Line 386: ben_yrp_shd.g_old_rec.perds_in_yr_num;

382: -- is being used then we must set to the 'current' argument value.
383: --
384: If (p_rec.perds_in_yr_num = hr_api.g_number) then
385: p_rec.perds_in_yr_num :=
386: ben_yrp_shd.g_old_rec.perds_in_yr_num;
387: End If;
388: If (p_rec.perd_tm_uom_cd = hr_api.g_varchar2) then
389: p_rec.perd_tm_uom_cd :=
390: ben_yrp_shd.g_old_rec.perd_tm_uom_cd;

Line 390: ben_yrp_shd.g_old_rec.perd_tm_uom_cd;

386: ben_yrp_shd.g_old_rec.perds_in_yr_num;
387: End If;
388: If (p_rec.perd_tm_uom_cd = hr_api.g_varchar2) then
389: p_rec.perd_tm_uom_cd :=
390: ben_yrp_shd.g_old_rec.perd_tm_uom_cd;
391: End If;
392: If (p_rec.perd_typ_cd = hr_api.g_varchar2) then
393: p_rec.perd_typ_cd :=
394: ben_yrp_shd.g_old_rec.perd_typ_cd;

Line 394: ben_yrp_shd.g_old_rec.perd_typ_cd;

390: ben_yrp_shd.g_old_rec.perd_tm_uom_cd;
391: End If;
392: If (p_rec.perd_typ_cd = hr_api.g_varchar2) then
393: p_rec.perd_typ_cd :=
394: ben_yrp_shd.g_old_rec.perd_typ_cd;
395: End If;
396: If (p_rec.end_date = hr_api.g_date) then
397: p_rec.end_date :=
398: ben_yrp_shd.g_old_rec.end_date;

Line 398: ben_yrp_shd.g_old_rec.end_date;

394: ben_yrp_shd.g_old_rec.perd_typ_cd;
395: End If;
396: If (p_rec.end_date = hr_api.g_date) then
397: p_rec.end_date :=
398: ben_yrp_shd.g_old_rec.end_date;
399: End If;
400: If (p_rec.start_date = hr_api.g_date) then
401: p_rec.start_date :=
402: ben_yrp_shd.g_old_rec.start_date;

Line 402: ben_yrp_shd.g_old_rec.start_date;

398: ben_yrp_shd.g_old_rec.end_date;
399: End If;
400: If (p_rec.start_date = hr_api.g_date) then
401: p_rec.start_date :=
402: ben_yrp_shd.g_old_rec.start_date;
403: End If;
404: If (p_rec.lmtn_yr_strt_dt = hr_api.g_date) then
405: p_rec.lmtn_yr_strt_dt :=
406: ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt;

Line 406: ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt;

402: ben_yrp_shd.g_old_rec.start_date;
403: End If;
404: If (p_rec.lmtn_yr_strt_dt = hr_api.g_date) then
405: p_rec.lmtn_yr_strt_dt :=
406: ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt;
407: End If;
408: If (p_rec.lmtn_yr_end_dt = hr_api.g_date) then
409: p_rec.lmtn_yr_end_dt :=
410: ben_yrp_shd.g_old_rec.lmtn_yr_end_dt;

Line 410: ben_yrp_shd.g_old_rec.lmtn_yr_end_dt;

406: ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt;
407: End If;
408: If (p_rec.lmtn_yr_end_dt = hr_api.g_date) then
409: p_rec.lmtn_yr_end_dt :=
410: ben_yrp_shd.g_old_rec.lmtn_yr_end_dt;
411: End If;
412: If (p_rec.business_group_id = hr_api.g_number) then
413: p_rec.business_group_id :=
414: ben_yrp_shd.g_old_rec.business_group_id;

Line 414: ben_yrp_shd.g_old_rec.business_group_id;

410: ben_yrp_shd.g_old_rec.lmtn_yr_end_dt;
411: End If;
412: If (p_rec.business_group_id = hr_api.g_number) then
413: p_rec.business_group_id :=
414: ben_yrp_shd.g_old_rec.business_group_id;
415: End If;
416: If (p_rec.yrp_attribute_category = hr_api.g_varchar2) then
417: p_rec.yrp_attribute_category :=
418: ben_yrp_shd.g_old_rec.yrp_attribute_category;

Line 418: ben_yrp_shd.g_old_rec.yrp_attribute_category;

414: ben_yrp_shd.g_old_rec.business_group_id;
415: End If;
416: If (p_rec.yrp_attribute_category = hr_api.g_varchar2) then
417: p_rec.yrp_attribute_category :=
418: ben_yrp_shd.g_old_rec.yrp_attribute_category;
419: End If;
420: If (p_rec.yrp_attribute1 = hr_api.g_varchar2) then
421: p_rec.yrp_attribute1 :=
422: ben_yrp_shd.g_old_rec.yrp_attribute1;

Line 422: ben_yrp_shd.g_old_rec.yrp_attribute1;

418: ben_yrp_shd.g_old_rec.yrp_attribute_category;
419: End If;
420: If (p_rec.yrp_attribute1 = hr_api.g_varchar2) then
421: p_rec.yrp_attribute1 :=
422: ben_yrp_shd.g_old_rec.yrp_attribute1;
423: End If;
424: If (p_rec.yrp_attribute2 = hr_api.g_varchar2) then
425: p_rec.yrp_attribute2 :=
426: ben_yrp_shd.g_old_rec.yrp_attribute2;

Line 426: ben_yrp_shd.g_old_rec.yrp_attribute2;

422: ben_yrp_shd.g_old_rec.yrp_attribute1;
423: End If;
424: If (p_rec.yrp_attribute2 = hr_api.g_varchar2) then
425: p_rec.yrp_attribute2 :=
426: ben_yrp_shd.g_old_rec.yrp_attribute2;
427: End If;
428: If (p_rec.yrp_attribute3 = hr_api.g_varchar2) then
429: p_rec.yrp_attribute3 :=
430: ben_yrp_shd.g_old_rec.yrp_attribute3;

Line 430: ben_yrp_shd.g_old_rec.yrp_attribute3;

426: ben_yrp_shd.g_old_rec.yrp_attribute2;
427: End If;
428: If (p_rec.yrp_attribute3 = hr_api.g_varchar2) then
429: p_rec.yrp_attribute3 :=
430: ben_yrp_shd.g_old_rec.yrp_attribute3;
431: End If;
432: If (p_rec.yrp_attribute4 = hr_api.g_varchar2) then
433: p_rec.yrp_attribute4 :=
434: ben_yrp_shd.g_old_rec.yrp_attribute4;

Line 434: ben_yrp_shd.g_old_rec.yrp_attribute4;

430: ben_yrp_shd.g_old_rec.yrp_attribute3;
431: End If;
432: If (p_rec.yrp_attribute4 = hr_api.g_varchar2) then
433: p_rec.yrp_attribute4 :=
434: ben_yrp_shd.g_old_rec.yrp_attribute4;
435: End If;
436: If (p_rec.yrp_attribute5 = hr_api.g_varchar2) then
437: p_rec.yrp_attribute5 :=
438: ben_yrp_shd.g_old_rec.yrp_attribute5;

Line 438: ben_yrp_shd.g_old_rec.yrp_attribute5;

434: ben_yrp_shd.g_old_rec.yrp_attribute4;
435: End If;
436: If (p_rec.yrp_attribute5 = hr_api.g_varchar2) then
437: p_rec.yrp_attribute5 :=
438: ben_yrp_shd.g_old_rec.yrp_attribute5;
439: End If;
440: If (p_rec.yrp_attribute6 = hr_api.g_varchar2) then
441: p_rec.yrp_attribute6 :=
442: ben_yrp_shd.g_old_rec.yrp_attribute6;

Line 442: ben_yrp_shd.g_old_rec.yrp_attribute6;

438: ben_yrp_shd.g_old_rec.yrp_attribute5;
439: End If;
440: If (p_rec.yrp_attribute6 = hr_api.g_varchar2) then
441: p_rec.yrp_attribute6 :=
442: ben_yrp_shd.g_old_rec.yrp_attribute6;
443: End If;
444: If (p_rec.yrp_attribute7 = hr_api.g_varchar2) then
445: p_rec.yrp_attribute7 :=
446: ben_yrp_shd.g_old_rec.yrp_attribute7;

Line 446: ben_yrp_shd.g_old_rec.yrp_attribute7;

442: ben_yrp_shd.g_old_rec.yrp_attribute6;
443: End If;
444: If (p_rec.yrp_attribute7 = hr_api.g_varchar2) then
445: p_rec.yrp_attribute7 :=
446: ben_yrp_shd.g_old_rec.yrp_attribute7;
447: End If;
448: If (p_rec.yrp_attribute8 = hr_api.g_varchar2) then
449: p_rec.yrp_attribute8 :=
450: ben_yrp_shd.g_old_rec.yrp_attribute8;

Line 450: ben_yrp_shd.g_old_rec.yrp_attribute8;

446: ben_yrp_shd.g_old_rec.yrp_attribute7;
447: End If;
448: If (p_rec.yrp_attribute8 = hr_api.g_varchar2) then
449: p_rec.yrp_attribute8 :=
450: ben_yrp_shd.g_old_rec.yrp_attribute8;
451: End If;
452: If (p_rec.yrp_attribute9 = hr_api.g_varchar2) then
453: p_rec.yrp_attribute9 :=
454: ben_yrp_shd.g_old_rec.yrp_attribute9;

Line 454: ben_yrp_shd.g_old_rec.yrp_attribute9;

450: ben_yrp_shd.g_old_rec.yrp_attribute8;
451: End If;
452: If (p_rec.yrp_attribute9 = hr_api.g_varchar2) then
453: p_rec.yrp_attribute9 :=
454: ben_yrp_shd.g_old_rec.yrp_attribute9;
455: End If;
456: If (p_rec.yrp_attribute10 = hr_api.g_varchar2) then
457: p_rec.yrp_attribute10 :=
458: ben_yrp_shd.g_old_rec.yrp_attribute10;

Line 458: ben_yrp_shd.g_old_rec.yrp_attribute10;

454: ben_yrp_shd.g_old_rec.yrp_attribute9;
455: End If;
456: If (p_rec.yrp_attribute10 = hr_api.g_varchar2) then
457: p_rec.yrp_attribute10 :=
458: ben_yrp_shd.g_old_rec.yrp_attribute10;
459: End If;
460: If (p_rec.yrp_attribute11 = hr_api.g_varchar2) then
461: p_rec.yrp_attribute11 :=
462: ben_yrp_shd.g_old_rec.yrp_attribute11;

Line 462: ben_yrp_shd.g_old_rec.yrp_attribute11;

458: ben_yrp_shd.g_old_rec.yrp_attribute10;
459: End If;
460: If (p_rec.yrp_attribute11 = hr_api.g_varchar2) then
461: p_rec.yrp_attribute11 :=
462: ben_yrp_shd.g_old_rec.yrp_attribute11;
463: End If;
464: If (p_rec.yrp_attribute12 = hr_api.g_varchar2) then
465: p_rec.yrp_attribute12 :=
466: ben_yrp_shd.g_old_rec.yrp_attribute12;

Line 466: ben_yrp_shd.g_old_rec.yrp_attribute12;

462: ben_yrp_shd.g_old_rec.yrp_attribute11;
463: End If;
464: If (p_rec.yrp_attribute12 = hr_api.g_varchar2) then
465: p_rec.yrp_attribute12 :=
466: ben_yrp_shd.g_old_rec.yrp_attribute12;
467: End If;
468: If (p_rec.yrp_attribute13 = hr_api.g_varchar2) then
469: p_rec.yrp_attribute13 :=
470: ben_yrp_shd.g_old_rec.yrp_attribute13;

Line 470: ben_yrp_shd.g_old_rec.yrp_attribute13;

466: ben_yrp_shd.g_old_rec.yrp_attribute12;
467: End If;
468: If (p_rec.yrp_attribute13 = hr_api.g_varchar2) then
469: p_rec.yrp_attribute13 :=
470: ben_yrp_shd.g_old_rec.yrp_attribute13;
471: End If;
472: If (p_rec.yrp_attribute14 = hr_api.g_varchar2) then
473: p_rec.yrp_attribute14 :=
474: ben_yrp_shd.g_old_rec.yrp_attribute14;

Line 474: ben_yrp_shd.g_old_rec.yrp_attribute14;

470: ben_yrp_shd.g_old_rec.yrp_attribute13;
471: End If;
472: If (p_rec.yrp_attribute14 = hr_api.g_varchar2) then
473: p_rec.yrp_attribute14 :=
474: ben_yrp_shd.g_old_rec.yrp_attribute14;
475: End If;
476: If (p_rec.yrp_attribute15 = hr_api.g_varchar2) then
477: p_rec.yrp_attribute15 :=
478: ben_yrp_shd.g_old_rec.yrp_attribute15;

Line 478: ben_yrp_shd.g_old_rec.yrp_attribute15;

474: ben_yrp_shd.g_old_rec.yrp_attribute14;
475: End If;
476: If (p_rec.yrp_attribute15 = hr_api.g_varchar2) then
477: p_rec.yrp_attribute15 :=
478: ben_yrp_shd.g_old_rec.yrp_attribute15;
479: End If;
480: If (p_rec.yrp_attribute16 = hr_api.g_varchar2) then
481: p_rec.yrp_attribute16 :=
482: ben_yrp_shd.g_old_rec.yrp_attribute16;

Line 482: ben_yrp_shd.g_old_rec.yrp_attribute16;

478: ben_yrp_shd.g_old_rec.yrp_attribute15;
479: End If;
480: If (p_rec.yrp_attribute16 = hr_api.g_varchar2) then
481: p_rec.yrp_attribute16 :=
482: ben_yrp_shd.g_old_rec.yrp_attribute16;
483: End If;
484: If (p_rec.yrp_attribute17 = hr_api.g_varchar2) then
485: p_rec.yrp_attribute17 :=
486: ben_yrp_shd.g_old_rec.yrp_attribute17;

Line 486: ben_yrp_shd.g_old_rec.yrp_attribute17;

482: ben_yrp_shd.g_old_rec.yrp_attribute16;
483: End If;
484: If (p_rec.yrp_attribute17 = hr_api.g_varchar2) then
485: p_rec.yrp_attribute17 :=
486: ben_yrp_shd.g_old_rec.yrp_attribute17;
487: End If;
488: If (p_rec.yrp_attribute18 = hr_api.g_varchar2) then
489: p_rec.yrp_attribute18 :=
490: ben_yrp_shd.g_old_rec.yrp_attribute18;

Line 490: ben_yrp_shd.g_old_rec.yrp_attribute18;

486: ben_yrp_shd.g_old_rec.yrp_attribute17;
487: End If;
488: If (p_rec.yrp_attribute18 = hr_api.g_varchar2) then
489: p_rec.yrp_attribute18 :=
490: ben_yrp_shd.g_old_rec.yrp_attribute18;
491: End If;
492: If (p_rec.yrp_attribute19 = hr_api.g_varchar2) then
493: p_rec.yrp_attribute19 :=
494: ben_yrp_shd.g_old_rec.yrp_attribute19;

Line 494: ben_yrp_shd.g_old_rec.yrp_attribute19;

490: ben_yrp_shd.g_old_rec.yrp_attribute18;
491: End If;
492: If (p_rec.yrp_attribute19 = hr_api.g_varchar2) then
493: p_rec.yrp_attribute19 :=
494: ben_yrp_shd.g_old_rec.yrp_attribute19;
495: End If;
496: If (p_rec.yrp_attribute20 = hr_api.g_varchar2) then
497: p_rec.yrp_attribute20 :=
498: ben_yrp_shd.g_old_rec.yrp_attribute20;

Line 498: ben_yrp_shd.g_old_rec.yrp_attribute20;

494: ben_yrp_shd.g_old_rec.yrp_attribute19;
495: End If;
496: If (p_rec.yrp_attribute20 = hr_api.g_varchar2) then
497: p_rec.yrp_attribute20 :=
498: ben_yrp_shd.g_old_rec.yrp_attribute20;
499: End If;
500: If (p_rec.yrp_attribute21 = hr_api.g_varchar2) then
501: p_rec.yrp_attribute21 :=
502: ben_yrp_shd.g_old_rec.yrp_attribute21;

Line 502: ben_yrp_shd.g_old_rec.yrp_attribute21;

498: ben_yrp_shd.g_old_rec.yrp_attribute20;
499: End If;
500: If (p_rec.yrp_attribute21 = hr_api.g_varchar2) then
501: p_rec.yrp_attribute21 :=
502: ben_yrp_shd.g_old_rec.yrp_attribute21;
503: End If;
504: If (p_rec.yrp_attribute22 = hr_api.g_varchar2) then
505: p_rec.yrp_attribute22 :=
506: ben_yrp_shd.g_old_rec.yrp_attribute22;

Line 506: ben_yrp_shd.g_old_rec.yrp_attribute22;

502: ben_yrp_shd.g_old_rec.yrp_attribute21;
503: End If;
504: If (p_rec.yrp_attribute22 = hr_api.g_varchar2) then
505: p_rec.yrp_attribute22 :=
506: ben_yrp_shd.g_old_rec.yrp_attribute22;
507: End If;
508: If (p_rec.yrp_attribute23 = hr_api.g_varchar2) then
509: p_rec.yrp_attribute23 :=
510: ben_yrp_shd.g_old_rec.yrp_attribute23;

Line 510: ben_yrp_shd.g_old_rec.yrp_attribute23;

506: ben_yrp_shd.g_old_rec.yrp_attribute22;
507: End If;
508: If (p_rec.yrp_attribute23 = hr_api.g_varchar2) then
509: p_rec.yrp_attribute23 :=
510: ben_yrp_shd.g_old_rec.yrp_attribute23;
511: End If;
512: If (p_rec.yrp_attribute24 = hr_api.g_varchar2) then
513: p_rec.yrp_attribute24 :=
514: ben_yrp_shd.g_old_rec.yrp_attribute24;

Line 514: ben_yrp_shd.g_old_rec.yrp_attribute24;

510: ben_yrp_shd.g_old_rec.yrp_attribute23;
511: End If;
512: If (p_rec.yrp_attribute24 = hr_api.g_varchar2) then
513: p_rec.yrp_attribute24 :=
514: ben_yrp_shd.g_old_rec.yrp_attribute24;
515: End If;
516: If (p_rec.yrp_attribute25 = hr_api.g_varchar2) then
517: p_rec.yrp_attribute25 :=
518: ben_yrp_shd.g_old_rec.yrp_attribute25;

Line 518: ben_yrp_shd.g_old_rec.yrp_attribute25;

514: ben_yrp_shd.g_old_rec.yrp_attribute24;
515: End If;
516: If (p_rec.yrp_attribute25 = hr_api.g_varchar2) then
517: p_rec.yrp_attribute25 :=
518: ben_yrp_shd.g_old_rec.yrp_attribute25;
519: End If;
520: If (p_rec.yrp_attribute26 = hr_api.g_varchar2) then
521: p_rec.yrp_attribute26 :=
522: ben_yrp_shd.g_old_rec.yrp_attribute26;

Line 522: ben_yrp_shd.g_old_rec.yrp_attribute26;

518: ben_yrp_shd.g_old_rec.yrp_attribute25;
519: End If;
520: If (p_rec.yrp_attribute26 = hr_api.g_varchar2) then
521: p_rec.yrp_attribute26 :=
522: ben_yrp_shd.g_old_rec.yrp_attribute26;
523: End If;
524: If (p_rec.yrp_attribute27 = hr_api.g_varchar2) then
525: p_rec.yrp_attribute27 :=
526: ben_yrp_shd.g_old_rec.yrp_attribute27;

Line 526: ben_yrp_shd.g_old_rec.yrp_attribute27;

522: ben_yrp_shd.g_old_rec.yrp_attribute26;
523: End If;
524: If (p_rec.yrp_attribute27 = hr_api.g_varchar2) then
525: p_rec.yrp_attribute27 :=
526: ben_yrp_shd.g_old_rec.yrp_attribute27;
527: End If;
528: If (p_rec.yrp_attribute28 = hr_api.g_varchar2) then
529: p_rec.yrp_attribute28 :=
530: ben_yrp_shd.g_old_rec.yrp_attribute28;

Line 530: ben_yrp_shd.g_old_rec.yrp_attribute28;

526: ben_yrp_shd.g_old_rec.yrp_attribute27;
527: End If;
528: If (p_rec.yrp_attribute28 = hr_api.g_varchar2) then
529: p_rec.yrp_attribute28 :=
530: ben_yrp_shd.g_old_rec.yrp_attribute28;
531: End If;
532: If (p_rec.yrp_attribute29 = hr_api.g_varchar2) then
533: p_rec.yrp_attribute29 :=
534: ben_yrp_shd.g_old_rec.yrp_attribute29;

Line 534: ben_yrp_shd.g_old_rec.yrp_attribute29;

530: ben_yrp_shd.g_old_rec.yrp_attribute28;
531: End If;
532: If (p_rec.yrp_attribute29 = hr_api.g_varchar2) then
533: p_rec.yrp_attribute29 :=
534: ben_yrp_shd.g_old_rec.yrp_attribute29;
535: End If;
536: If (p_rec.yrp_attribute30 = hr_api.g_varchar2) then
537: p_rec.yrp_attribute30 :=
538: ben_yrp_shd.g_old_rec.yrp_attribute30;

Line 538: ben_yrp_shd.g_old_rec.yrp_attribute30;

534: ben_yrp_shd.g_old_rec.yrp_attribute29;
535: End If;
536: If (p_rec.yrp_attribute30 = hr_api.g_varchar2) then
537: p_rec.yrp_attribute30 :=
538: ben_yrp_shd.g_old_rec.yrp_attribute30;
539: End If;
540:
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 552: p_rec in out nocopy ben_yrp_shd.g_rec_type

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

Line 562: ben_yrp_shd.lck

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

Line 641: l_rec ben_yrp_shd.g_rec_type;

637: p_yrp_attribute30 in varchar2 default hr_api.g_varchar2,
638: p_object_version_number in out nocopy number
639: ) is
640: --
641: l_rec ben_yrp_shd.g_rec_type;
642: l_proc varchar2(72) := g_package||'upd';
643: --
644: Begin
645: hr_utility.set_location('Entering:'||l_proc, 5);

Line 651: ben_yrp_shd.convert_args

647: -- Call conversion function to turn arguments into the
648: -- l_rec structure.
649: --
650: l_rec :=
651: ben_yrp_shd.convert_args
652: (
653: p_yr_perd_id,
654: p_perds_in_yr_num,
655: p_perd_tm_uom_cd,