DBA Data[Home] [Help]

APPS.BEN_PRP_UPD dependencies on BEN_PRP_SHD

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

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_prp_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_prp_shd.g_api_dml := true; -- Set the api dml status

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

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

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

Line 139: ben_prp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 140: ben_prp_shd.constraint_error

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

Line 144: ben_prp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 145: ben_prp_shd.constraint_error

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

Line 148: ben_prp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 184: (p_rec in out nocopy ben_prp_shd.g_rec_type,

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

Line 248: (p_rec in out nocopy ben_prp_shd.g_rec_type,

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

Line 264: ben_prp_shd.upd_effective_end_date

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

Line 333: (p_rec in out nocopy ben_prp_shd.g_rec_type,

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

Line 389: (p_rec in ben_prp_shd.g_rec_type,

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

Line 449: ,p_effective_start_date_o =>ben_prp_shd.g_old_rec.effective_start_date

445: ,p_effective_date =>p_effective_date
446: ,p_datetrack_mode =>p_datetrack_mode
447: ,p_validation_start_date =>p_validation_start_date
448: ,p_validation_end_date =>p_validation_end_date
449: ,p_effective_start_date_o =>ben_prp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
451: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id

Line 450: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date

446: ,p_datetrack_mode =>p_datetrack_mode
447: ,p_validation_start_date =>p_validation_start_date
448: ,p_validation_end_date =>p_validation_end_date
449: ,p_effective_start_date_o =>ben_prp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
451: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category

Line 451: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd

447: ,p_validation_start_date =>p_validation_start_date
448: ,p_validation_end_date =>p_validation_end_date
449: ,p_effective_start_date_o =>ben_prp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
451: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1

Line 452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id

448: ,p_validation_end_date =>p_validation_end_date
449: ,p_effective_start_date_o =>ben_prp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
451: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2

Line 453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id

449: ,p_effective_start_date_o =>ben_prp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
451: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3

Line 454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category

450: ,p_effective_end_date_o =>ben_prp_shd.g_old_rec.effective_end_date
451: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4

Line 455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1

451: ,p_pl_regy_prps_cd_o =>ben_prp_shd.g_old_rec.pl_regy_prps_cd
452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5

Line 456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2

452: ,p_pl_regy_bod_id_o =>ben_prp_shd.g_old_rec.pl_regy_bod_id
453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6

Line 457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3

453: ,p_business_group_id_o =>ben_prp_shd.g_old_rec.business_group_id
454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7

Line 458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4

454: ,p_prp_attribute_category_o =>ben_prp_shd.g_old_rec.prp_attribute_category
455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8

Line 459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5

455: ,p_prp_attribute1_o =>ben_prp_shd.g_old_rec.prp_attribute1
456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9

Line 460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6

456: ,p_prp_attribute2_o =>ben_prp_shd.g_old_rec.prp_attribute2
457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10

Line 461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7

457: ,p_prp_attribute3_o =>ben_prp_shd.g_old_rec.prp_attribute3
458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11

Line 462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8

458: ,p_prp_attribute4_o =>ben_prp_shd.g_old_rec.prp_attribute4
459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12

Line 463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9

459: ,p_prp_attribute5_o =>ben_prp_shd.g_old_rec.prp_attribute5
460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13

Line 464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10

460: ,p_prp_attribute6_o =>ben_prp_shd.g_old_rec.prp_attribute6
461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14

Line 465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11

461: ,p_prp_attribute7_o =>ben_prp_shd.g_old_rec.prp_attribute7
462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15

Line 466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12

462: ,p_prp_attribute8_o =>ben_prp_shd.g_old_rec.prp_attribute8
463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16

Line 467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13

463: ,p_prp_attribute9_o =>ben_prp_shd.g_old_rec.prp_attribute9
464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17

Line 468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14

464: ,p_prp_attribute10_o =>ben_prp_shd.g_old_rec.prp_attribute10
465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18

Line 469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15

465: ,p_prp_attribute11_o =>ben_prp_shd.g_old_rec.prp_attribute11
466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19

Line 470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16

466: ,p_prp_attribute12_o =>ben_prp_shd.g_old_rec.prp_attribute12
467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20

Line 471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17

467: ,p_prp_attribute13_o =>ben_prp_shd.g_old_rec.prp_attribute13
468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21

Line 472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18

468: ,p_prp_attribute14_o =>ben_prp_shd.g_old_rec.prp_attribute14
469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22

Line 473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19

469: ,p_prp_attribute15_o =>ben_prp_shd.g_old_rec.prp_attribute15
470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23

Line 474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20

470: ,p_prp_attribute16_o =>ben_prp_shd.g_old_rec.prp_attribute16
471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24

Line 475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21

471: ,p_prp_attribute17_o =>ben_prp_shd.g_old_rec.prp_attribute17
472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25

Line 476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22

472: ,p_prp_attribute18_o =>ben_prp_shd.g_old_rec.prp_attribute18
473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26

Line 477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23

473: ,p_prp_attribute19_o =>ben_prp_shd.g_old_rec.prp_attribute19
474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27

Line 478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24

474: ,p_prp_attribute20_o =>ben_prp_shd.g_old_rec.prp_attribute20
475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28

Line 479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25

475: ,p_prp_attribute21_o =>ben_prp_shd.g_old_rec.prp_attribute21
476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
483: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29

Line 480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26

476: ,p_prp_attribute22_o =>ben_prp_shd.g_old_rec.prp_attribute22
477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
483: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
484: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30

Line 481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27

477: ,p_prp_attribute23_o =>ben_prp_shd.g_old_rec.prp_attribute23
478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
483: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
484: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
485: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number

Line 482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28

478: ,p_prp_attribute24_o =>ben_prp_shd.g_old_rec.prp_attribute24
479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
483: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
484: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
485: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number
486: );

Line 483: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29

479: ,p_prp_attribute25_o =>ben_prp_shd.g_old_rec.prp_attribute25
480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
483: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
484: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
485: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number
486: );
487: --

Line 484: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30

480: ,p_prp_attribute26_o =>ben_prp_shd.g_old_rec.prp_attribute26
481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
483: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
484: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
485: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number
486: );
487: --
488: exception

Line 485: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number

481: ,p_prp_attribute27_o =>ben_prp_shd.g_old_rec.prp_attribute27
482: ,p_prp_attribute28_o =>ben_prp_shd.g_old_rec.prp_attribute28
483: ,p_prp_attribute29_o =>ben_prp_shd.g_old_rec.prp_attribute29
484: ,p_prp_attribute30_o =>ben_prp_shd.g_old_rec.prp_attribute30
485: ,p_object_version_number_o =>ben_prp_shd.g_old_rec.object_version_number
486: );
487: --
488: exception
489: --

Line 547: Procedure convert_defs(p_rec in out nocopy ben_prp_shd.g_rec_type) is

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

Line 562: ben_prp_shd.g_old_rec.pl_regy_prps_cd;

558: -- is being used then we must set to the 'current' argument value.
559: --
560: If (p_rec.pl_regy_prps_cd = hr_api.g_varchar2) then
561: p_rec.pl_regy_prps_cd :=
562: ben_prp_shd.g_old_rec.pl_regy_prps_cd;
563: End If;
564: If (p_rec.pl_regy_bod_id = hr_api.g_number) then
565: p_rec.pl_regy_bod_id :=
566: ben_prp_shd.g_old_rec.pl_regy_bod_id;

Line 566: ben_prp_shd.g_old_rec.pl_regy_bod_id;

562: ben_prp_shd.g_old_rec.pl_regy_prps_cd;
563: End If;
564: If (p_rec.pl_regy_bod_id = hr_api.g_number) then
565: p_rec.pl_regy_bod_id :=
566: ben_prp_shd.g_old_rec.pl_regy_bod_id;
567: End If;
568: If (p_rec.business_group_id = hr_api.g_number) then
569: p_rec.business_group_id :=
570: ben_prp_shd.g_old_rec.business_group_id;

Line 570: ben_prp_shd.g_old_rec.business_group_id;

566: ben_prp_shd.g_old_rec.pl_regy_bod_id;
567: End If;
568: If (p_rec.business_group_id = hr_api.g_number) then
569: p_rec.business_group_id :=
570: ben_prp_shd.g_old_rec.business_group_id;
571: End If;
572: If (p_rec.prp_attribute_category = hr_api.g_varchar2) then
573: p_rec.prp_attribute_category :=
574: ben_prp_shd.g_old_rec.prp_attribute_category;

Line 574: ben_prp_shd.g_old_rec.prp_attribute_category;

570: ben_prp_shd.g_old_rec.business_group_id;
571: End If;
572: If (p_rec.prp_attribute_category = hr_api.g_varchar2) then
573: p_rec.prp_attribute_category :=
574: ben_prp_shd.g_old_rec.prp_attribute_category;
575: End If;
576: If (p_rec.prp_attribute1 = hr_api.g_varchar2) then
577: p_rec.prp_attribute1 :=
578: ben_prp_shd.g_old_rec.prp_attribute1;

Line 578: ben_prp_shd.g_old_rec.prp_attribute1;

574: ben_prp_shd.g_old_rec.prp_attribute_category;
575: End If;
576: If (p_rec.prp_attribute1 = hr_api.g_varchar2) then
577: p_rec.prp_attribute1 :=
578: ben_prp_shd.g_old_rec.prp_attribute1;
579: End If;
580: If (p_rec.prp_attribute2 = hr_api.g_varchar2) then
581: p_rec.prp_attribute2 :=
582: ben_prp_shd.g_old_rec.prp_attribute2;

Line 582: ben_prp_shd.g_old_rec.prp_attribute2;

578: ben_prp_shd.g_old_rec.prp_attribute1;
579: End If;
580: If (p_rec.prp_attribute2 = hr_api.g_varchar2) then
581: p_rec.prp_attribute2 :=
582: ben_prp_shd.g_old_rec.prp_attribute2;
583: End If;
584: If (p_rec.prp_attribute3 = hr_api.g_varchar2) then
585: p_rec.prp_attribute3 :=
586: ben_prp_shd.g_old_rec.prp_attribute3;

Line 586: ben_prp_shd.g_old_rec.prp_attribute3;

582: ben_prp_shd.g_old_rec.prp_attribute2;
583: End If;
584: If (p_rec.prp_attribute3 = hr_api.g_varchar2) then
585: p_rec.prp_attribute3 :=
586: ben_prp_shd.g_old_rec.prp_attribute3;
587: End If;
588: If (p_rec.prp_attribute4 = hr_api.g_varchar2) then
589: p_rec.prp_attribute4 :=
590: ben_prp_shd.g_old_rec.prp_attribute4;

Line 590: ben_prp_shd.g_old_rec.prp_attribute4;

586: ben_prp_shd.g_old_rec.prp_attribute3;
587: End If;
588: If (p_rec.prp_attribute4 = hr_api.g_varchar2) then
589: p_rec.prp_attribute4 :=
590: ben_prp_shd.g_old_rec.prp_attribute4;
591: End If;
592: If (p_rec.prp_attribute5 = hr_api.g_varchar2) then
593: p_rec.prp_attribute5 :=
594: ben_prp_shd.g_old_rec.prp_attribute5;

Line 594: ben_prp_shd.g_old_rec.prp_attribute5;

590: ben_prp_shd.g_old_rec.prp_attribute4;
591: End If;
592: If (p_rec.prp_attribute5 = hr_api.g_varchar2) then
593: p_rec.prp_attribute5 :=
594: ben_prp_shd.g_old_rec.prp_attribute5;
595: End If;
596: If (p_rec.prp_attribute6 = hr_api.g_varchar2) then
597: p_rec.prp_attribute6 :=
598: ben_prp_shd.g_old_rec.prp_attribute6;

Line 598: ben_prp_shd.g_old_rec.prp_attribute6;

594: ben_prp_shd.g_old_rec.prp_attribute5;
595: End If;
596: If (p_rec.prp_attribute6 = hr_api.g_varchar2) then
597: p_rec.prp_attribute6 :=
598: ben_prp_shd.g_old_rec.prp_attribute6;
599: End If;
600: If (p_rec.prp_attribute7 = hr_api.g_varchar2) then
601: p_rec.prp_attribute7 :=
602: ben_prp_shd.g_old_rec.prp_attribute7;

Line 602: ben_prp_shd.g_old_rec.prp_attribute7;

598: ben_prp_shd.g_old_rec.prp_attribute6;
599: End If;
600: If (p_rec.prp_attribute7 = hr_api.g_varchar2) then
601: p_rec.prp_attribute7 :=
602: ben_prp_shd.g_old_rec.prp_attribute7;
603: End If;
604: If (p_rec.prp_attribute8 = hr_api.g_varchar2) then
605: p_rec.prp_attribute8 :=
606: ben_prp_shd.g_old_rec.prp_attribute8;

Line 606: ben_prp_shd.g_old_rec.prp_attribute8;

602: ben_prp_shd.g_old_rec.prp_attribute7;
603: End If;
604: If (p_rec.prp_attribute8 = hr_api.g_varchar2) then
605: p_rec.prp_attribute8 :=
606: ben_prp_shd.g_old_rec.prp_attribute8;
607: End If;
608: If (p_rec.prp_attribute9 = hr_api.g_varchar2) then
609: p_rec.prp_attribute9 :=
610: ben_prp_shd.g_old_rec.prp_attribute9;

Line 610: ben_prp_shd.g_old_rec.prp_attribute9;

606: ben_prp_shd.g_old_rec.prp_attribute8;
607: End If;
608: If (p_rec.prp_attribute9 = hr_api.g_varchar2) then
609: p_rec.prp_attribute9 :=
610: ben_prp_shd.g_old_rec.prp_attribute9;
611: End If;
612: If (p_rec.prp_attribute10 = hr_api.g_varchar2) then
613: p_rec.prp_attribute10 :=
614: ben_prp_shd.g_old_rec.prp_attribute10;

Line 614: ben_prp_shd.g_old_rec.prp_attribute10;

610: ben_prp_shd.g_old_rec.prp_attribute9;
611: End If;
612: If (p_rec.prp_attribute10 = hr_api.g_varchar2) then
613: p_rec.prp_attribute10 :=
614: ben_prp_shd.g_old_rec.prp_attribute10;
615: End If;
616: If (p_rec.prp_attribute11 = hr_api.g_varchar2) then
617: p_rec.prp_attribute11 :=
618: ben_prp_shd.g_old_rec.prp_attribute11;

Line 618: ben_prp_shd.g_old_rec.prp_attribute11;

614: ben_prp_shd.g_old_rec.prp_attribute10;
615: End If;
616: If (p_rec.prp_attribute11 = hr_api.g_varchar2) then
617: p_rec.prp_attribute11 :=
618: ben_prp_shd.g_old_rec.prp_attribute11;
619: End If;
620: If (p_rec.prp_attribute12 = hr_api.g_varchar2) then
621: p_rec.prp_attribute12 :=
622: ben_prp_shd.g_old_rec.prp_attribute12;

Line 622: ben_prp_shd.g_old_rec.prp_attribute12;

618: ben_prp_shd.g_old_rec.prp_attribute11;
619: End If;
620: If (p_rec.prp_attribute12 = hr_api.g_varchar2) then
621: p_rec.prp_attribute12 :=
622: ben_prp_shd.g_old_rec.prp_attribute12;
623: End If;
624: If (p_rec.prp_attribute13 = hr_api.g_varchar2) then
625: p_rec.prp_attribute13 :=
626: ben_prp_shd.g_old_rec.prp_attribute13;

Line 626: ben_prp_shd.g_old_rec.prp_attribute13;

622: ben_prp_shd.g_old_rec.prp_attribute12;
623: End If;
624: If (p_rec.prp_attribute13 = hr_api.g_varchar2) then
625: p_rec.prp_attribute13 :=
626: ben_prp_shd.g_old_rec.prp_attribute13;
627: End If;
628: If (p_rec.prp_attribute14 = hr_api.g_varchar2) then
629: p_rec.prp_attribute14 :=
630: ben_prp_shd.g_old_rec.prp_attribute14;

Line 630: ben_prp_shd.g_old_rec.prp_attribute14;

626: ben_prp_shd.g_old_rec.prp_attribute13;
627: End If;
628: If (p_rec.prp_attribute14 = hr_api.g_varchar2) then
629: p_rec.prp_attribute14 :=
630: ben_prp_shd.g_old_rec.prp_attribute14;
631: End If;
632: If (p_rec.prp_attribute15 = hr_api.g_varchar2) then
633: p_rec.prp_attribute15 :=
634: ben_prp_shd.g_old_rec.prp_attribute15;

Line 634: ben_prp_shd.g_old_rec.prp_attribute15;

630: ben_prp_shd.g_old_rec.prp_attribute14;
631: End If;
632: If (p_rec.prp_attribute15 = hr_api.g_varchar2) then
633: p_rec.prp_attribute15 :=
634: ben_prp_shd.g_old_rec.prp_attribute15;
635: End If;
636: If (p_rec.prp_attribute16 = hr_api.g_varchar2) then
637: p_rec.prp_attribute16 :=
638: ben_prp_shd.g_old_rec.prp_attribute16;

Line 638: ben_prp_shd.g_old_rec.prp_attribute16;

634: ben_prp_shd.g_old_rec.prp_attribute15;
635: End If;
636: If (p_rec.prp_attribute16 = hr_api.g_varchar2) then
637: p_rec.prp_attribute16 :=
638: ben_prp_shd.g_old_rec.prp_attribute16;
639: End If;
640: If (p_rec.prp_attribute17 = hr_api.g_varchar2) then
641: p_rec.prp_attribute17 :=
642: ben_prp_shd.g_old_rec.prp_attribute17;

Line 642: ben_prp_shd.g_old_rec.prp_attribute17;

638: ben_prp_shd.g_old_rec.prp_attribute16;
639: End If;
640: If (p_rec.prp_attribute17 = hr_api.g_varchar2) then
641: p_rec.prp_attribute17 :=
642: ben_prp_shd.g_old_rec.prp_attribute17;
643: End If;
644: If (p_rec.prp_attribute18 = hr_api.g_varchar2) then
645: p_rec.prp_attribute18 :=
646: ben_prp_shd.g_old_rec.prp_attribute18;

Line 646: ben_prp_shd.g_old_rec.prp_attribute18;

642: ben_prp_shd.g_old_rec.prp_attribute17;
643: End If;
644: If (p_rec.prp_attribute18 = hr_api.g_varchar2) then
645: p_rec.prp_attribute18 :=
646: ben_prp_shd.g_old_rec.prp_attribute18;
647: End If;
648: If (p_rec.prp_attribute19 = hr_api.g_varchar2) then
649: p_rec.prp_attribute19 :=
650: ben_prp_shd.g_old_rec.prp_attribute19;

Line 650: ben_prp_shd.g_old_rec.prp_attribute19;

646: ben_prp_shd.g_old_rec.prp_attribute18;
647: End If;
648: If (p_rec.prp_attribute19 = hr_api.g_varchar2) then
649: p_rec.prp_attribute19 :=
650: ben_prp_shd.g_old_rec.prp_attribute19;
651: End If;
652: If (p_rec.prp_attribute20 = hr_api.g_varchar2) then
653: p_rec.prp_attribute20 :=
654: ben_prp_shd.g_old_rec.prp_attribute20;

Line 654: ben_prp_shd.g_old_rec.prp_attribute20;

650: ben_prp_shd.g_old_rec.prp_attribute19;
651: End If;
652: If (p_rec.prp_attribute20 = hr_api.g_varchar2) then
653: p_rec.prp_attribute20 :=
654: ben_prp_shd.g_old_rec.prp_attribute20;
655: End If;
656: If (p_rec.prp_attribute21 = hr_api.g_varchar2) then
657: p_rec.prp_attribute21 :=
658: ben_prp_shd.g_old_rec.prp_attribute21;

Line 658: ben_prp_shd.g_old_rec.prp_attribute21;

654: ben_prp_shd.g_old_rec.prp_attribute20;
655: End If;
656: If (p_rec.prp_attribute21 = hr_api.g_varchar2) then
657: p_rec.prp_attribute21 :=
658: ben_prp_shd.g_old_rec.prp_attribute21;
659: End If;
660: If (p_rec.prp_attribute22 = hr_api.g_varchar2) then
661: p_rec.prp_attribute22 :=
662: ben_prp_shd.g_old_rec.prp_attribute22;

Line 662: ben_prp_shd.g_old_rec.prp_attribute22;

658: ben_prp_shd.g_old_rec.prp_attribute21;
659: End If;
660: If (p_rec.prp_attribute22 = hr_api.g_varchar2) then
661: p_rec.prp_attribute22 :=
662: ben_prp_shd.g_old_rec.prp_attribute22;
663: End If;
664: If (p_rec.prp_attribute23 = hr_api.g_varchar2) then
665: p_rec.prp_attribute23 :=
666: ben_prp_shd.g_old_rec.prp_attribute23;

Line 666: ben_prp_shd.g_old_rec.prp_attribute23;

662: ben_prp_shd.g_old_rec.prp_attribute22;
663: End If;
664: If (p_rec.prp_attribute23 = hr_api.g_varchar2) then
665: p_rec.prp_attribute23 :=
666: ben_prp_shd.g_old_rec.prp_attribute23;
667: End If;
668: If (p_rec.prp_attribute24 = hr_api.g_varchar2) then
669: p_rec.prp_attribute24 :=
670: ben_prp_shd.g_old_rec.prp_attribute24;

Line 670: ben_prp_shd.g_old_rec.prp_attribute24;

666: ben_prp_shd.g_old_rec.prp_attribute23;
667: End If;
668: If (p_rec.prp_attribute24 = hr_api.g_varchar2) then
669: p_rec.prp_attribute24 :=
670: ben_prp_shd.g_old_rec.prp_attribute24;
671: End If;
672: If (p_rec.prp_attribute25 = hr_api.g_varchar2) then
673: p_rec.prp_attribute25 :=
674: ben_prp_shd.g_old_rec.prp_attribute25;

Line 674: ben_prp_shd.g_old_rec.prp_attribute25;

670: ben_prp_shd.g_old_rec.prp_attribute24;
671: End If;
672: If (p_rec.prp_attribute25 = hr_api.g_varchar2) then
673: p_rec.prp_attribute25 :=
674: ben_prp_shd.g_old_rec.prp_attribute25;
675: End If;
676: If (p_rec.prp_attribute26 = hr_api.g_varchar2) then
677: p_rec.prp_attribute26 :=
678: ben_prp_shd.g_old_rec.prp_attribute26;

Line 678: ben_prp_shd.g_old_rec.prp_attribute26;

674: ben_prp_shd.g_old_rec.prp_attribute25;
675: End If;
676: If (p_rec.prp_attribute26 = hr_api.g_varchar2) then
677: p_rec.prp_attribute26 :=
678: ben_prp_shd.g_old_rec.prp_attribute26;
679: End If;
680: If (p_rec.prp_attribute27 = hr_api.g_varchar2) then
681: p_rec.prp_attribute27 :=
682: ben_prp_shd.g_old_rec.prp_attribute27;

Line 682: ben_prp_shd.g_old_rec.prp_attribute27;

678: ben_prp_shd.g_old_rec.prp_attribute26;
679: End If;
680: If (p_rec.prp_attribute27 = hr_api.g_varchar2) then
681: p_rec.prp_attribute27 :=
682: ben_prp_shd.g_old_rec.prp_attribute27;
683: End If;
684: If (p_rec.prp_attribute28 = hr_api.g_varchar2) then
685: p_rec.prp_attribute28 :=
686: ben_prp_shd.g_old_rec.prp_attribute28;

Line 686: ben_prp_shd.g_old_rec.prp_attribute28;

682: ben_prp_shd.g_old_rec.prp_attribute27;
683: End If;
684: If (p_rec.prp_attribute28 = hr_api.g_varchar2) then
685: p_rec.prp_attribute28 :=
686: ben_prp_shd.g_old_rec.prp_attribute28;
687: End If;
688: If (p_rec.prp_attribute29 = hr_api.g_varchar2) then
689: p_rec.prp_attribute29 :=
690: ben_prp_shd.g_old_rec.prp_attribute29;

Line 690: ben_prp_shd.g_old_rec.prp_attribute29;

686: ben_prp_shd.g_old_rec.prp_attribute28;
687: End If;
688: If (p_rec.prp_attribute29 = hr_api.g_varchar2) then
689: p_rec.prp_attribute29 :=
690: ben_prp_shd.g_old_rec.prp_attribute29;
691: End If;
692: If (p_rec.prp_attribute30 = hr_api.g_varchar2) then
693: p_rec.prp_attribute30 :=
694: ben_prp_shd.g_old_rec.prp_attribute30;

Line 694: ben_prp_shd.g_old_rec.prp_attribute30;

690: ben_prp_shd.g_old_rec.prp_attribute29;
691: End If;
692: If (p_rec.prp_attribute30 = hr_api.g_varchar2) then
693: p_rec.prp_attribute30 :=
694: ben_prp_shd.g_old_rec.prp_attribute30;
695: End If;
696:
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 707: p_rec in out nocopy ben_prp_shd.g_rec_type,

703: -- |---------------------------------< upd >----------------------------------|
704: -- ----------------------------------------------------------------------------
705: Procedure upd
706: (
707: p_rec in out nocopy ben_prp_shd.g_rec_type,
708: p_effective_date in date,
709: p_datetrack_mode in varchar2
710: ) is
711: --

Line 725: ben_prp_shd.lck

721: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
722: --
723: -- We must lock the row which we need to update.
724: --
725: ben_prp_shd.lck
726: (p_effective_date => p_effective_date,
727: p_datetrack_mode => p_datetrack_mode,
728: p_pl_regy_prps_id => p_rec.pl_regy_prps_id,
729: p_object_version_number => p_rec.object_version_number,

Line 822: l_rec ben_prp_shd.g_rec_type;

818: p_effective_date in date,
819: p_datetrack_mode in varchar2
820: ) is
821: --
822: l_rec ben_prp_shd.g_rec_type;
823: l_proc varchar2(72) := g_package||'upd';
824: --
825: Begin
826: hr_utility.set_location('Entering:'||l_proc, 5);

Line 832: ben_prp_shd.convert_args

828: -- Call conversion function to turn arguments into the
829: -- l_rec structure.
830: --
831: l_rec :=
832: ben_prp_shd.convert_args
833: (
834: p_pl_regy_prps_id,
835: null,
836: null,