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_CPR_UPD dependencies on BEN_CPR_SHD

Line 58: (p_rec in out nocopy ben_cpr_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_cpr_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is

Line 81: ben_cpr_shd.g_api_dml := true; -- Set the api dml status

77: (p_base_table_name => 'ben_popl_org_role_f',
78: p_base_key_column => 'popl_org_role_id',
79: p_base_key_value => p_rec.popl_org_role_id);
80: --
81: ben_cpr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_popl_org_role_f Row
84: --
85: update ben_popl_org_role_f

Line 128: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status

124: where popl_org_role_id = p_rec.popl_org_role_id
125: and effective_start_date = p_validation_start_date
126: and effective_end_date = p_validation_end_date;
127: --
128: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: -- Set the effective start and end dates
131: --
132: p_rec.effective_start_date := p_validation_start_date;

Line 140: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status

136: hr_utility.set_location(' Leaving:'||l_proc, 15);
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
141: ben_cpr_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated

Line 141: ben_cpr_shd.constraint_error

137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
141: ben_cpr_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status

Line 145: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 146: ben_cpr_shd.constraint_error

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

Line 149: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status

145: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
146: ben_cpr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
151: End dt_update_dml;
152: --
153: -- ----------------------------------------------------------------------------

Line 185: (p_rec in out nocopy ben_cpr_shd.g_rec_type,

181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure update_dml
185: (p_rec in out nocopy ben_cpr_shd.g_rec_type,
186: p_effective_date in date,
187: p_datetrack_mode in varchar2,
188: p_validation_start_date in date,
189: p_validation_end_date in date) is

Line 249: (p_rec in out nocopy ben_cpr_shd.g_rec_type,

245: --
246: -- {End Of Comments}
247: -- ----------------------------------------------------------------------------
248: Procedure dt_pre_update
249: (p_rec in out nocopy ben_cpr_shd.g_rec_type,
250: p_effective_date in date,
251: p_datetrack_mode in varchar2,
252: p_validation_start_date in date,
253: p_validation_end_date in date) is

Line 265: ben_cpr_shd.upd_effective_end_date

261: hr_utility.set_location(l_proc, 10);
262: --
263: -- Update the current effective end date
264: --
265: ben_cpr_shd.upd_effective_end_date
266: (p_effective_date => p_effective_date,
267: p_base_key_value => p_rec.popl_org_role_id,
268: p_new_effective_end_date => (p_validation_start_date - 1),
269: p_validation_start_date => p_validation_start_date,

Line 334: (p_rec in out nocopy ben_cpr_shd.g_rec_type,

330: --
331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure pre_update
334: (p_rec in out nocopy ben_cpr_shd.g_rec_type,
335: p_effective_date in date,
336: p_datetrack_mode in varchar2,
337: p_validation_start_date in date,
338: p_validation_end_date in date) is

Line 390: (p_rec in ben_cpr_shd.g_rec_type,

386: --
387: -- {End Of Comments}
388: -- ----------------------------------------------------------------------------
389: Procedure post_update
390: (p_rec in ben_cpr_shd.g_rec_type,
391: p_effective_date in date,
392: p_datetrack_mode in varchar2,
393: p_validation_start_date in date,
394: p_validation_end_date in date) is

Line 451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date

447: ,p_effective_date =>p_effective_date
448: ,p_datetrack_mode =>p_datetrack_mode
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id

Line 452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date

448: ,p_datetrack_mode =>p_datetrack_mode
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id

Line 453: ,p_name_o =>ben_cpr_shd.g_old_rec.name

449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category

Line 454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd

450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1

Line 455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id

451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2

Line 456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id

452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3

Line 457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category

453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4

Line 458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1

454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5

Line 459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2

455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6

Line 460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3

456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7

Line 461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4

457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8

Line 462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5

458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9

Line 463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6

459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10

Line 464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7

460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11

Line 465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8

461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12

Line 466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9

462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13

Line 467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10

463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14

Line 468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11

464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15

Line 469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12

465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16

Line 470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13

466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17

Line 471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14

467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18

Line 472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15

468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19

Line 473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16

469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20

Line 474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17

470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21

Line 475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18

471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22

Line 476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19

472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23

Line 477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20

473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24

Line 478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21

474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25

Line 479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22

475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26

Line 480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23

476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27

Line 481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24

477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28

Line 482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25

478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29

Line 483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26

479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30

Line 484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27

480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number

Line 485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28

481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
489: );

Line 486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29

482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
489: );
490: --

Line 487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30

483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
489: );
490: --
491: exception

Line 488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number

484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
489: );
490: --
491: exception
492: --

Line 550: Procedure convert_defs(p_rec in out nocopy ben_cpr_shd.g_rec_type) is

546: -- Internal Row Handler Use Only.
547: --
548: -- {End Of Comments}
549: -- ----------------------------------------------------------------------------
550: Procedure convert_defs(p_rec in out nocopy ben_cpr_shd.g_rec_type) is
551: --
552: l_proc varchar2(72) := g_package||'convert_defs';
553: --
554: Begin

Line 565: ben_cpr_shd.g_old_rec.name;

561: -- is being used then we must set to the 'current' argument value.
562: --
563: If (p_rec.name = hr_api.g_varchar2) then
564: p_rec.name :=
565: ben_cpr_shd.g_old_rec.name;
566: End If;
567: If (p_rec.popl_org_id = hr_api.g_number) then
568: p_rec.popl_org_id :=
569: ben_cpr_shd.g_old_rec.popl_org_id;

Line 569: ben_cpr_shd.g_old_rec.popl_org_id;

565: ben_cpr_shd.g_old_rec.name;
566: End If;
567: If (p_rec.popl_org_id = hr_api.g_number) then
568: p_rec.popl_org_id :=
569: ben_cpr_shd.g_old_rec.popl_org_id;
570: End If;
571: If (p_rec.business_group_id = hr_api.g_number) then
572: p_rec.business_group_id :=
573: ben_cpr_shd.g_old_rec.business_group_id;

Line 573: ben_cpr_shd.g_old_rec.business_group_id;

569: ben_cpr_shd.g_old_rec.popl_org_id;
570: End If;
571: If (p_rec.business_group_id = hr_api.g_number) then
572: p_rec.business_group_id :=
573: ben_cpr_shd.g_old_rec.business_group_id;
574: End If;
575: If (p_rec.cpr_attribute_category = hr_api.g_varchar2) then
576: p_rec.cpr_attribute_category :=
577: ben_cpr_shd.g_old_rec.cpr_attribute_category;

Line 577: ben_cpr_shd.g_old_rec.cpr_attribute_category;

573: ben_cpr_shd.g_old_rec.business_group_id;
574: End If;
575: If (p_rec.cpr_attribute_category = hr_api.g_varchar2) then
576: p_rec.cpr_attribute_category :=
577: ben_cpr_shd.g_old_rec.cpr_attribute_category;
578: End If;
579: If (p_rec.cpr_attribute1 = hr_api.g_varchar2) then
580: p_rec.cpr_attribute1 :=
581: ben_cpr_shd.g_old_rec.cpr_attribute1;

Line 581: ben_cpr_shd.g_old_rec.cpr_attribute1;

577: ben_cpr_shd.g_old_rec.cpr_attribute_category;
578: End If;
579: If (p_rec.cpr_attribute1 = hr_api.g_varchar2) then
580: p_rec.cpr_attribute1 :=
581: ben_cpr_shd.g_old_rec.cpr_attribute1;
582: End If;
583: If (p_rec.cpr_attribute2 = hr_api.g_varchar2) then
584: p_rec.cpr_attribute2 :=
585: ben_cpr_shd.g_old_rec.cpr_attribute2;

Line 585: ben_cpr_shd.g_old_rec.cpr_attribute2;

581: ben_cpr_shd.g_old_rec.cpr_attribute1;
582: End If;
583: If (p_rec.cpr_attribute2 = hr_api.g_varchar2) then
584: p_rec.cpr_attribute2 :=
585: ben_cpr_shd.g_old_rec.cpr_attribute2;
586: End If;
587: If (p_rec.cpr_attribute3 = hr_api.g_varchar2) then
588: p_rec.cpr_attribute3 :=
589: ben_cpr_shd.g_old_rec.cpr_attribute3;

Line 589: ben_cpr_shd.g_old_rec.cpr_attribute3;

585: ben_cpr_shd.g_old_rec.cpr_attribute2;
586: End If;
587: If (p_rec.cpr_attribute3 = hr_api.g_varchar2) then
588: p_rec.cpr_attribute3 :=
589: ben_cpr_shd.g_old_rec.cpr_attribute3;
590: End If;
591: If (p_rec.cpr_attribute4 = hr_api.g_varchar2) then
592: p_rec.cpr_attribute4 :=
593: ben_cpr_shd.g_old_rec.cpr_attribute4;

Line 593: ben_cpr_shd.g_old_rec.cpr_attribute4;

589: ben_cpr_shd.g_old_rec.cpr_attribute3;
590: End If;
591: If (p_rec.cpr_attribute4 = hr_api.g_varchar2) then
592: p_rec.cpr_attribute4 :=
593: ben_cpr_shd.g_old_rec.cpr_attribute4;
594: End If;
595: If (p_rec.cpr_attribute5 = hr_api.g_varchar2) then
596: p_rec.cpr_attribute5 :=
597: ben_cpr_shd.g_old_rec.cpr_attribute5;

Line 597: ben_cpr_shd.g_old_rec.cpr_attribute5;

593: ben_cpr_shd.g_old_rec.cpr_attribute4;
594: End If;
595: If (p_rec.cpr_attribute5 = hr_api.g_varchar2) then
596: p_rec.cpr_attribute5 :=
597: ben_cpr_shd.g_old_rec.cpr_attribute5;
598: End If;
599: If (p_rec.cpr_attribute6 = hr_api.g_varchar2) then
600: p_rec.cpr_attribute6 :=
601: ben_cpr_shd.g_old_rec.cpr_attribute6;

Line 601: ben_cpr_shd.g_old_rec.cpr_attribute6;

597: ben_cpr_shd.g_old_rec.cpr_attribute5;
598: End If;
599: If (p_rec.cpr_attribute6 = hr_api.g_varchar2) then
600: p_rec.cpr_attribute6 :=
601: ben_cpr_shd.g_old_rec.cpr_attribute6;
602: End If;
603: If (p_rec.cpr_attribute7 = hr_api.g_varchar2) then
604: p_rec.cpr_attribute7 :=
605: ben_cpr_shd.g_old_rec.cpr_attribute7;

Line 605: ben_cpr_shd.g_old_rec.cpr_attribute7;

601: ben_cpr_shd.g_old_rec.cpr_attribute6;
602: End If;
603: If (p_rec.cpr_attribute7 = hr_api.g_varchar2) then
604: p_rec.cpr_attribute7 :=
605: ben_cpr_shd.g_old_rec.cpr_attribute7;
606: End If;
607: If (p_rec.cpr_attribute8 = hr_api.g_varchar2) then
608: p_rec.cpr_attribute8 :=
609: ben_cpr_shd.g_old_rec.cpr_attribute8;

Line 609: ben_cpr_shd.g_old_rec.cpr_attribute8;

605: ben_cpr_shd.g_old_rec.cpr_attribute7;
606: End If;
607: If (p_rec.cpr_attribute8 = hr_api.g_varchar2) then
608: p_rec.cpr_attribute8 :=
609: ben_cpr_shd.g_old_rec.cpr_attribute8;
610: End If;
611: If (p_rec.cpr_attribute9 = hr_api.g_varchar2) then
612: p_rec.cpr_attribute9 :=
613: ben_cpr_shd.g_old_rec.cpr_attribute9;

Line 613: ben_cpr_shd.g_old_rec.cpr_attribute9;

609: ben_cpr_shd.g_old_rec.cpr_attribute8;
610: End If;
611: If (p_rec.cpr_attribute9 = hr_api.g_varchar2) then
612: p_rec.cpr_attribute9 :=
613: ben_cpr_shd.g_old_rec.cpr_attribute9;
614: End If;
615: If (p_rec.cpr_attribute10 = hr_api.g_varchar2) then
616: p_rec.cpr_attribute10 :=
617: ben_cpr_shd.g_old_rec.cpr_attribute10;

Line 617: ben_cpr_shd.g_old_rec.cpr_attribute10;

613: ben_cpr_shd.g_old_rec.cpr_attribute9;
614: End If;
615: If (p_rec.cpr_attribute10 = hr_api.g_varchar2) then
616: p_rec.cpr_attribute10 :=
617: ben_cpr_shd.g_old_rec.cpr_attribute10;
618: End If;
619: If (p_rec.cpr_attribute11 = hr_api.g_varchar2) then
620: p_rec.cpr_attribute11 :=
621: ben_cpr_shd.g_old_rec.cpr_attribute11;

Line 621: ben_cpr_shd.g_old_rec.cpr_attribute11;

617: ben_cpr_shd.g_old_rec.cpr_attribute10;
618: End If;
619: If (p_rec.cpr_attribute11 = hr_api.g_varchar2) then
620: p_rec.cpr_attribute11 :=
621: ben_cpr_shd.g_old_rec.cpr_attribute11;
622: End If;
623: If (p_rec.cpr_attribute12 = hr_api.g_varchar2) then
624: p_rec.cpr_attribute12 :=
625: ben_cpr_shd.g_old_rec.cpr_attribute12;

Line 625: ben_cpr_shd.g_old_rec.cpr_attribute12;

621: ben_cpr_shd.g_old_rec.cpr_attribute11;
622: End If;
623: If (p_rec.cpr_attribute12 = hr_api.g_varchar2) then
624: p_rec.cpr_attribute12 :=
625: ben_cpr_shd.g_old_rec.cpr_attribute12;
626: End If;
627: If (p_rec.cpr_attribute13 = hr_api.g_varchar2) then
628: p_rec.cpr_attribute13 :=
629: ben_cpr_shd.g_old_rec.cpr_attribute13;

Line 629: ben_cpr_shd.g_old_rec.cpr_attribute13;

625: ben_cpr_shd.g_old_rec.cpr_attribute12;
626: End If;
627: If (p_rec.cpr_attribute13 = hr_api.g_varchar2) then
628: p_rec.cpr_attribute13 :=
629: ben_cpr_shd.g_old_rec.cpr_attribute13;
630: End If;
631: If (p_rec.cpr_attribute14 = hr_api.g_varchar2) then
632: p_rec.cpr_attribute14 :=
633: ben_cpr_shd.g_old_rec.cpr_attribute14;

Line 633: ben_cpr_shd.g_old_rec.cpr_attribute14;

629: ben_cpr_shd.g_old_rec.cpr_attribute13;
630: End If;
631: If (p_rec.cpr_attribute14 = hr_api.g_varchar2) then
632: p_rec.cpr_attribute14 :=
633: ben_cpr_shd.g_old_rec.cpr_attribute14;
634: End If;
635: If (p_rec.cpr_attribute15 = hr_api.g_varchar2) then
636: p_rec.cpr_attribute15 :=
637: ben_cpr_shd.g_old_rec.cpr_attribute15;

Line 637: ben_cpr_shd.g_old_rec.cpr_attribute15;

633: ben_cpr_shd.g_old_rec.cpr_attribute14;
634: End If;
635: If (p_rec.cpr_attribute15 = hr_api.g_varchar2) then
636: p_rec.cpr_attribute15 :=
637: ben_cpr_shd.g_old_rec.cpr_attribute15;
638: End If;
639: If (p_rec.cpr_attribute16 = hr_api.g_varchar2) then
640: p_rec.cpr_attribute16 :=
641: ben_cpr_shd.g_old_rec.cpr_attribute16;

Line 641: ben_cpr_shd.g_old_rec.cpr_attribute16;

637: ben_cpr_shd.g_old_rec.cpr_attribute15;
638: End If;
639: If (p_rec.cpr_attribute16 = hr_api.g_varchar2) then
640: p_rec.cpr_attribute16 :=
641: ben_cpr_shd.g_old_rec.cpr_attribute16;
642: End If;
643: If (p_rec.cpr_attribute17 = hr_api.g_varchar2) then
644: p_rec.cpr_attribute17 :=
645: ben_cpr_shd.g_old_rec.cpr_attribute17;

Line 645: ben_cpr_shd.g_old_rec.cpr_attribute17;

641: ben_cpr_shd.g_old_rec.cpr_attribute16;
642: End If;
643: If (p_rec.cpr_attribute17 = hr_api.g_varchar2) then
644: p_rec.cpr_attribute17 :=
645: ben_cpr_shd.g_old_rec.cpr_attribute17;
646: End If;
647: If (p_rec.cpr_attribute18 = hr_api.g_varchar2) then
648: p_rec.cpr_attribute18 :=
649: ben_cpr_shd.g_old_rec.cpr_attribute18;

Line 649: ben_cpr_shd.g_old_rec.cpr_attribute18;

645: ben_cpr_shd.g_old_rec.cpr_attribute17;
646: End If;
647: If (p_rec.cpr_attribute18 = hr_api.g_varchar2) then
648: p_rec.cpr_attribute18 :=
649: ben_cpr_shd.g_old_rec.cpr_attribute18;
650: End If;
651: If (p_rec.cpr_attribute19 = hr_api.g_varchar2) then
652: p_rec.cpr_attribute19 :=
653: ben_cpr_shd.g_old_rec.cpr_attribute19;

Line 653: ben_cpr_shd.g_old_rec.cpr_attribute19;

649: ben_cpr_shd.g_old_rec.cpr_attribute18;
650: End If;
651: If (p_rec.cpr_attribute19 = hr_api.g_varchar2) then
652: p_rec.cpr_attribute19 :=
653: ben_cpr_shd.g_old_rec.cpr_attribute19;
654: End If;
655: If (p_rec.cpr_attribute20 = hr_api.g_varchar2) then
656: p_rec.cpr_attribute20 :=
657: ben_cpr_shd.g_old_rec.cpr_attribute20;

Line 657: ben_cpr_shd.g_old_rec.cpr_attribute20;

653: ben_cpr_shd.g_old_rec.cpr_attribute19;
654: End If;
655: If (p_rec.cpr_attribute20 = hr_api.g_varchar2) then
656: p_rec.cpr_attribute20 :=
657: ben_cpr_shd.g_old_rec.cpr_attribute20;
658: End If;
659: If (p_rec.cpr_attribute21 = hr_api.g_varchar2) then
660: p_rec.cpr_attribute21 :=
661: ben_cpr_shd.g_old_rec.cpr_attribute21;

Line 661: ben_cpr_shd.g_old_rec.cpr_attribute21;

657: ben_cpr_shd.g_old_rec.cpr_attribute20;
658: End If;
659: If (p_rec.cpr_attribute21 = hr_api.g_varchar2) then
660: p_rec.cpr_attribute21 :=
661: ben_cpr_shd.g_old_rec.cpr_attribute21;
662: End If;
663: If (p_rec.cpr_attribute22 = hr_api.g_varchar2) then
664: p_rec.cpr_attribute22 :=
665: ben_cpr_shd.g_old_rec.cpr_attribute22;

Line 665: ben_cpr_shd.g_old_rec.cpr_attribute22;

661: ben_cpr_shd.g_old_rec.cpr_attribute21;
662: End If;
663: If (p_rec.cpr_attribute22 = hr_api.g_varchar2) then
664: p_rec.cpr_attribute22 :=
665: ben_cpr_shd.g_old_rec.cpr_attribute22;
666: End If;
667: If (p_rec.cpr_attribute23 = hr_api.g_varchar2) then
668: p_rec.cpr_attribute23 :=
669: ben_cpr_shd.g_old_rec.cpr_attribute23;

Line 669: ben_cpr_shd.g_old_rec.cpr_attribute23;

665: ben_cpr_shd.g_old_rec.cpr_attribute22;
666: End If;
667: If (p_rec.cpr_attribute23 = hr_api.g_varchar2) then
668: p_rec.cpr_attribute23 :=
669: ben_cpr_shd.g_old_rec.cpr_attribute23;
670: End If;
671: If (p_rec.cpr_attribute24 = hr_api.g_varchar2) then
672: p_rec.cpr_attribute24 :=
673: ben_cpr_shd.g_old_rec.cpr_attribute24;

Line 673: ben_cpr_shd.g_old_rec.cpr_attribute24;

669: ben_cpr_shd.g_old_rec.cpr_attribute23;
670: End If;
671: If (p_rec.cpr_attribute24 = hr_api.g_varchar2) then
672: p_rec.cpr_attribute24 :=
673: ben_cpr_shd.g_old_rec.cpr_attribute24;
674: End If;
675: If (p_rec.cpr_attribute25 = hr_api.g_varchar2) then
676: p_rec.cpr_attribute25 :=
677: ben_cpr_shd.g_old_rec.cpr_attribute25;

Line 677: ben_cpr_shd.g_old_rec.cpr_attribute25;

673: ben_cpr_shd.g_old_rec.cpr_attribute24;
674: End If;
675: If (p_rec.cpr_attribute25 = hr_api.g_varchar2) then
676: p_rec.cpr_attribute25 :=
677: ben_cpr_shd.g_old_rec.cpr_attribute25;
678: End If;
679: If (p_rec.cpr_attribute26 = hr_api.g_varchar2) then
680: p_rec.cpr_attribute26 :=
681: ben_cpr_shd.g_old_rec.cpr_attribute26;

Line 681: ben_cpr_shd.g_old_rec.cpr_attribute26;

677: ben_cpr_shd.g_old_rec.cpr_attribute25;
678: End If;
679: If (p_rec.cpr_attribute26 = hr_api.g_varchar2) then
680: p_rec.cpr_attribute26 :=
681: ben_cpr_shd.g_old_rec.cpr_attribute26;
682: End If;
683: If (p_rec.cpr_attribute27 = hr_api.g_varchar2) then
684: p_rec.cpr_attribute27 :=
685: ben_cpr_shd.g_old_rec.cpr_attribute27;

Line 685: ben_cpr_shd.g_old_rec.cpr_attribute27;

681: ben_cpr_shd.g_old_rec.cpr_attribute26;
682: End If;
683: If (p_rec.cpr_attribute27 = hr_api.g_varchar2) then
684: p_rec.cpr_attribute27 :=
685: ben_cpr_shd.g_old_rec.cpr_attribute27;
686: End If;
687: If (p_rec.cpr_attribute28 = hr_api.g_varchar2) then
688: p_rec.cpr_attribute28 :=
689: ben_cpr_shd.g_old_rec.cpr_attribute28;

Line 689: ben_cpr_shd.g_old_rec.cpr_attribute28;

685: ben_cpr_shd.g_old_rec.cpr_attribute27;
686: End If;
687: If (p_rec.cpr_attribute28 = hr_api.g_varchar2) then
688: p_rec.cpr_attribute28 :=
689: ben_cpr_shd.g_old_rec.cpr_attribute28;
690: End If;
691: If (p_rec.cpr_attribute29 = hr_api.g_varchar2) then
692: p_rec.cpr_attribute29 :=
693: ben_cpr_shd.g_old_rec.cpr_attribute29;

Line 693: ben_cpr_shd.g_old_rec.cpr_attribute29;

689: ben_cpr_shd.g_old_rec.cpr_attribute28;
690: End If;
691: If (p_rec.cpr_attribute29 = hr_api.g_varchar2) then
692: p_rec.cpr_attribute29 :=
693: ben_cpr_shd.g_old_rec.cpr_attribute29;
694: End If;
695: If (p_rec.cpr_attribute30 = hr_api.g_varchar2) then
696: p_rec.cpr_attribute30 :=
697: ben_cpr_shd.g_old_rec.cpr_attribute30;

Line 697: ben_cpr_shd.g_old_rec.cpr_attribute30;

693: ben_cpr_shd.g_old_rec.cpr_attribute29;
694: End If;
695: If (p_rec.cpr_attribute30 = hr_api.g_varchar2) then
696: p_rec.cpr_attribute30 :=
697: ben_cpr_shd.g_old_rec.cpr_attribute30;
698: End If;
699:
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 710: p_rec in out nocopy ben_cpr_shd.g_rec_type,

706: -- |---------------------------------< upd >----------------------------------|
707: -- ----------------------------------------------------------------------------
708: Procedure upd
709: (
710: p_rec in out nocopy ben_cpr_shd.g_rec_type,
711: p_effective_date in date,
712: p_datetrack_mode in varchar2
713: ) is
714: --

Line 728: ben_cpr_shd.lck

724: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
725: --
726: -- We must lock the row which we need to update.
727: --
728: ben_cpr_shd.lck
729: (p_effective_date => p_effective_date,
730: p_datetrack_mode => p_datetrack_mode,
731: p_popl_org_role_id => p_rec.popl_org_role_id,
732: p_object_version_number => p_rec.object_version_number,

Line 826: l_rec ben_cpr_shd.g_rec_type;

822: p_effective_date in date,
823: p_datetrack_mode in varchar2
824: ) is
825: --
826: l_rec ben_cpr_shd.g_rec_type;
827: l_proc varchar2(72) := g_package||'upd';
828: --
829: Begin
830: hr_utility.set_location('Entering:'||l_proc, 5);

Line 836: ben_cpr_shd.convert_args

832: -- Call conversion function to turn arguments into the
833: -- l_rec structure.
834: --
835: l_rec :=
836: ben_cpr_shd.convert_args
837: (
838: p_popl_org_role_id,
839: null,
840: null,