DBA Data[Home] [Help]

APPS.BEN_CBP_UPD dependencies on BEN_CBP_SHD

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

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

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

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

123: where cmbn_ptip_id = p_rec.cmbn_ptip_id
124: and effective_start_date = p_validation_start_date
125: and effective_end_date = p_validation_end_date;
126: --
127: ben_cbp_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_cbp_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_cbp_shd.g_api_dml := false; -- Unset the api dml status
140: ben_cbp_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_cbp_shd.constraint_error

136: Exception
137: When hr_api.check_integrity_violated Then
138: -- A check constraint has been violated
139: ben_cbp_shd.g_api_dml := false; -- Unset the api dml status
140: ben_cbp_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_cbp_shd.g_api_dml := false; -- Unset the api dml status

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

140: ben_cbp_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_cbp_shd.g_api_dml := false; -- Unset the api dml status
145: ben_cbp_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: ben_cbp_shd.g_api_dml := false; -- Unset the api dml status

Line 145: ben_cbp_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_cbp_shd.g_api_dml := false; -- Unset the api dml status
145: ben_cbp_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: ben_cbp_shd.g_api_dml := false; -- Unset the api dml status
149: Raise;

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

144: ben_cbp_shd.g_api_dml := false; -- Unset the api dml status
145: ben_cbp_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: ben_cbp_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_cbp_shd.g_rec_type,

180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure update_dml
184: (p_rec in out nocopy ben_cbp_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_cbp_shd.g_rec_type,

244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure dt_pre_update
248: (p_rec in out nocopy ben_cbp_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_cbp_shd.upd_effective_end_date

260: hr_utility.set_location(l_proc, 10);
261: --
262: -- Update the current effective end date
263: --
264: ben_cbp_shd.upd_effective_end_date
265: (p_effective_date => p_effective_date,
266: p_base_key_value => p_rec.cmbn_ptip_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_cbp_shd.g_rec_type,

329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure pre_update
333: (p_rec in out nocopy ben_cbp_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_cbp_shd.g_rec_type,

385: --
386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: Procedure post_update
389: (p_rec in ben_cbp_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_cbp_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_cbp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_cbp_shd.g_old_rec.effective_end_date
451: ,p_name_o =>ben_cbp_shd.g_old_rec.name
452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id
453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category

Line 450: ,p_effective_end_date_o =>ben_cbp_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_cbp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_cbp_shd.g_old_rec.effective_end_date
451: ,p_name_o =>ben_cbp_shd.g_old_rec.name
452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id
453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category
454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1

Line 451: ,p_name_o =>ben_cbp_shd.g_old_rec.name

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_cbp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_cbp_shd.g_old_rec.effective_end_date
451: ,p_name_o =>ben_cbp_shd.g_old_rec.name
452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id
453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category
454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1
455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2

Line 452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id

448: ,p_validation_end_date =>p_validation_end_date
449: ,p_effective_start_date_o =>ben_cbp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_cbp_shd.g_old_rec.effective_end_date
451: ,p_name_o =>ben_cbp_shd.g_old_rec.name
452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id
453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category
454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1
455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2
456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3

Line 453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category

449: ,p_effective_start_date_o =>ben_cbp_shd.g_old_rec.effective_start_date
450: ,p_effective_end_date_o =>ben_cbp_shd.g_old_rec.effective_end_date
451: ,p_name_o =>ben_cbp_shd.g_old_rec.name
452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id
453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category
454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1
455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2
456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3
457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4

Line 454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1

450: ,p_effective_end_date_o =>ben_cbp_shd.g_old_rec.effective_end_date
451: ,p_name_o =>ben_cbp_shd.g_old_rec.name
452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id
453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category
454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1
455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2
456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3
457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4
458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5

Line 455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2

451: ,p_name_o =>ben_cbp_shd.g_old_rec.name
452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id
453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category
454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1
455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2
456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3
457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4
458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5
459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6

Line 456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3

452: ,p_business_group_id_o =>ben_cbp_shd.g_old_rec.business_group_id
453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category
454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1
455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2
456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3
457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4
458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5
459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6
460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7

Line 457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4

453: ,p_cbp_attribute_category_o =>ben_cbp_shd.g_old_rec.cbp_attribute_category
454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1
455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2
456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3
457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4
458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5
459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6
460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7
461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8

Line 458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5

454: ,p_cbp_attribute1_o =>ben_cbp_shd.g_old_rec.cbp_attribute1
455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2
456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3
457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4
458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5
459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6
460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7
461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8
462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9

Line 459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6

455: ,p_cbp_attribute2_o =>ben_cbp_shd.g_old_rec.cbp_attribute2
456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3
457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4
458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5
459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6
460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7
461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8
462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9
463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10

Line 460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7

456: ,p_cbp_attribute3_o =>ben_cbp_shd.g_old_rec.cbp_attribute3
457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4
458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5
459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6
460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7
461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8
462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9
463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10
464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11

Line 461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8

457: ,p_cbp_attribute4_o =>ben_cbp_shd.g_old_rec.cbp_attribute4
458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5
459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6
460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7
461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8
462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9
463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10
464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11
465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12

Line 462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9

458: ,p_cbp_attribute5_o =>ben_cbp_shd.g_old_rec.cbp_attribute5
459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6
460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7
461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8
462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9
463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10
464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11
465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12
466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13

Line 463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10

459: ,p_cbp_attribute6_o =>ben_cbp_shd.g_old_rec.cbp_attribute6
460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7
461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8
462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9
463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10
464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11
465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12
466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13
467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14

Line 464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11

460: ,p_cbp_attribute7_o =>ben_cbp_shd.g_old_rec.cbp_attribute7
461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8
462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9
463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10
464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11
465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12
466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13
467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14
468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15

Line 465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12

461: ,p_cbp_attribute8_o =>ben_cbp_shd.g_old_rec.cbp_attribute8
462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9
463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10
464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11
465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12
466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13
467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14
468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15
469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16

Line 466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13

462: ,p_cbp_attribute9_o =>ben_cbp_shd.g_old_rec.cbp_attribute9
463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10
464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11
465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12
466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13
467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14
468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15
469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16
470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17

Line 467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14

463: ,p_cbp_attribute10_o =>ben_cbp_shd.g_old_rec.cbp_attribute10
464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11
465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12
466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13
467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14
468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15
469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16
470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17
471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18

Line 468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15

464: ,p_cbp_attribute11_o =>ben_cbp_shd.g_old_rec.cbp_attribute11
465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12
466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13
467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14
468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15
469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16
470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17
471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18
472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19

Line 469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16

465: ,p_cbp_attribute12_o =>ben_cbp_shd.g_old_rec.cbp_attribute12
466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13
467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14
468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15
469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16
470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17
471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18
472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19
473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20

Line 470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17

466: ,p_cbp_attribute13_o =>ben_cbp_shd.g_old_rec.cbp_attribute13
467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14
468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15
469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16
470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17
471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18
472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19
473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20
474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21

Line 471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18

467: ,p_cbp_attribute14_o =>ben_cbp_shd.g_old_rec.cbp_attribute14
468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15
469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16
470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17
471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18
472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19
473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20
474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21
475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22

Line 472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19

468: ,p_cbp_attribute15_o =>ben_cbp_shd.g_old_rec.cbp_attribute15
469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16
470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17
471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18
472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19
473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20
474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21
475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22
476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23

Line 473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20

469: ,p_cbp_attribute16_o =>ben_cbp_shd.g_old_rec.cbp_attribute16
470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17
471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18
472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19
473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20
474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21
475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22
476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23
477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24

Line 474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21

470: ,p_cbp_attribute17_o =>ben_cbp_shd.g_old_rec.cbp_attribute17
471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18
472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19
473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20
474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21
475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22
476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23
477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24
478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25

Line 475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22

471: ,p_cbp_attribute18_o =>ben_cbp_shd.g_old_rec.cbp_attribute18
472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19
473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20
474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21
475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22
476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23
477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24
478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25
479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26

Line 476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23

472: ,p_cbp_attribute19_o =>ben_cbp_shd.g_old_rec.cbp_attribute19
473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20
474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21
475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22
476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23
477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24
478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25
479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26
480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27

Line 477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24

473: ,p_cbp_attribute20_o =>ben_cbp_shd.g_old_rec.cbp_attribute20
474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21
475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22
476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23
477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24
478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25
479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26
480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27
481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28

Line 478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25

474: ,p_cbp_attribute21_o =>ben_cbp_shd.g_old_rec.cbp_attribute21
475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22
476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23
477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24
478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25
479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26
480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27
481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28
482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29

Line 479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26

475: ,p_cbp_attribute22_o =>ben_cbp_shd.g_old_rec.cbp_attribute22
476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23
477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24
478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25
479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26
480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27
481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28
482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29
483: ,p_cbp_attribute30_o =>ben_cbp_shd.g_old_rec.cbp_attribute30

Line 480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27

476: ,p_cbp_attribute23_o =>ben_cbp_shd.g_old_rec.cbp_attribute23
477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24
478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25
479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26
480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27
481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28
482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29
483: ,p_cbp_attribute30_o =>ben_cbp_shd.g_old_rec.cbp_attribute30
484: ,p_object_version_number_o =>ben_cbp_shd.g_old_rec.object_version_number

Line 481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28

477: ,p_cbp_attribute24_o =>ben_cbp_shd.g_old_rec.cbp_attribute24
478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25
479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26
480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27
481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28
482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29
483: ,p_cbp_attribute30_o =>ben_cbp_shd.g_old_rec.cbp_attribute30
484: ,p_object_version_number_o =>ben_cbp_shd.g_old_rec.object_version_number
485: ,p_pgm_id_o =>ben_cbp_shd.g_old_rec.pgm_id

Line 482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29

478: ,p_cbp_attribute25_o =>ben_cbp_shd.g_old_rec.cbp_attribute25
479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26
480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27
481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28
482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29
483: ,p_cbp_attribute30_o =>ben_cbp_shd.g_old_rec.cbp_attribute30
484: ,p_object_version_number_o =>ben_cbp_shd.g_old_rec.object_version_number
485: ,p_pgm_id_o =>ben_cbp_shd.g_old_rec.pgm_id
486: );

Line 483: ,p_cbp_attribute30_o =>ben_cbp_shd.g_old_rec.cbp_attribute30

479: ,p_cbp_attribute26_o =>ben_cbp_shd.g_old_rec.cbp_attribute26
480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27
481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28
482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29
483: ,p_cbp_attribute30_o =>ben_cbp_shd.g_old_rec.cbp_attribute30
484: ,p_object_version_number_o =>ben_cbp_shd.g_old_rec.object_version_number
485: ,p_pgm_id_o =>ben_cbp_shd.g_old_rec.pgm_id
486: );
487: --

Line 484: ,p_object_version_number_o =>ben_cbp_shd.g_old_rec.object_version_number

480: ,p_cbp_attribute27_o =>ben_cbp_shd.g_old_rec.cbp_attribute27
481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28
482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29
483: ,p_cbp_attribute30_o =>ben_cbp_shd.g_old_rec.cbp_attribute30
484: ,p_object_version_number_o =>ben_cbp_shd.g_old_rec.object_version_number
485: ,p_pgm_id_o =>ben_cbp_shd.g_old_rec.pgm_id
486: );
487: --
488: exception

Line 485: ,p_pgm_id_o =>ben_cbp_shd.g_old_rec.pgm_id

481: ,p_cbp_attribute28_o =>ben_cbp_shd.g_old_rec.cbp_attribute28
482: ,p_cbp_attribute29_o =>ben_cbp_shd.g_old_rec.cbp_attribute29
483: ,p_cbp_attribute30_o =>ben_cbp_shd.g_old_rec.cbp_attribute30
484: ,p_object_version_number_o =>ben_cbp_shd.g_old_rec.object_version_number
485: ,p_pgm_id_o =>ben_cbp_shd.g_old_rec.pgm_id
486: );
487: --
488: exception
489: --

Line 547: Procedure convert_defs(p_rec in out nocopy ben_cbp_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_cbp_shd.g_rec_type) is
548: --
549: l_proc varchar2(72) := g_package||'convert_defs';
550: --
551: Begin

Line 562: ben_cbp_shd.g_old_rec.name;

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

Line 566: ben_cbp_shd.g_old_rec.business_group_id;

562: ben_cbp_shd.g_old_rec.name;
563: End If;
564: If (p_rec.business_group_id = hr_api.g_number) then
565: p_rec.business_group_id :=
566: ben_cbp_shd.g_old_rec.business_group_id;
567: End If;
568: If (p_rec.cbp_attribute_category = hr_api.g_varchar2) then
569: p_rec.cbp_attribute_category :=
570: ben_cbp_shd.g_old_rec.cbp_attribute_category;

Line 570: ben_cbp_shd.g_old_rec.cbp_attribute_category;

566: ben_cbp_shd.g_old_rec.business_group_id;
567: End If;
568: If (p_rec.cbp_attribute_category = hr_api.g_varchar2) then
569: p_rec.cbp_attribute_category :=
570: ben_cbp_shd.g_old_rec.cbp_attribute_category;
571: End If;
572: If (p_rec.cbp_attribute1 = hr_api.g_varchar2) then
573: p_rec.cbp_attribute1 :=
574: ben_cbp_shd.g_old_rec.cbp_attribute1;

Line 574: ben_cbp_shd.g_old_rec.cbp_attribute1;

570: ben_cbp_shd.g_old_rec.cbp_attribute_category;
571: End If;
572: If (p_rec.cbp_attribute1 = hr_api.g_varchar2) then
573: p_rec.cbp_attribute1 :=
574: ben_cbp_shd.g_old_rec.cbp_attribute1;
575: End If;
576: If (p_rec.cbp_attribute2 = hr_api.g_varchar2) then
577: p_rec.cbp_attribute2 :=
578: ben_cbp_shd.g_old_rec.cbp_attribute2;

Line 578: ben_cbp_shd.g_old_rec.cbp_attribute2;

574: ben_cbp_shd.g_old_rec.cbp_attribute1;
575: End If;
576: If (p_rec.cbp_attribute2 = hr_api.g_varchar2) then
577: p_rec.cbp_attribute2 :=
578: ben_cbp_shd.g_old_rec.cbp_attribute2;
579: End If;
580: If (p_rec.cbp_attribute3 = hr_api.g_varchar2) then
581: p_rec.cbp_attribute3 :=
582: ben_cbp_shd.g_old_rec.cbp_attribute3;

Line 582: ben_cbp_shd.g_old_rec.cbp_attribute3;

578: ben_cbp_shd.g_old_rec.cbp_attribute2;
579: End If;
580: If (p_rec.cbp_attribute3 = hr_api.g_varchar2) then
581: p_rec.cbp_attribute3 :=
582: ben_cbp_shd.g_old_rec.cbp_attribute3;
583: End If;
584: If (p_rec.cbp_attribute4 = hr_api.g_varchar2) then
585: p_rec.cbp_attribute4 :=
586: ben_cbp_shd.g_old_rec.cbp_attribute4;

Line 586: ben_cbp_shd.g_old_rec.cbp_attribute4;

582: ben_cbp_shd.g_old_rec.cbp_attribute3;
583: End If;
584: If (p_rec.cbp_attribute4 = hr_api.g_varchar2) then
585: p_rec.cbp_attribute4 :=
586: ben_cbp_shd.g_old_rec.cbp_attribute4;
587: End If;
588: If (p_rec.cbp_attribute5 = hr_api.g_varchar2) then
589: p_rec.cbp_attribute5 :=
590: ben_cbp_shd.g_old_rec.cbp_attribute5;

Line 590: ben_cbp_shd.g_old_rec.cbp_attribute5;

586: ben_cbp_shd.g_old_rec.cbp_attribute4;
587: End If;
588: If (p_rec.cbp_attribute5 = hr_api.g_varchar2) then
589: p_rec.cbp_attribute5 :=
590: ben_cbp_shd.g_old_rec.cbp_attribute5;
591: End If;
592: If (p_rec.cbp_attribute6 = hr_api.g_varchar2) then
593: p_rec.cbp_attribute6 :=
594: ben_cbp_shd.g_old_rec.cbp_attribute6;

Line 594: ben_cbp_shd.g_old_rec.cbp_attribute6;

590: ben_cbp_shd.g_old_rec.cbp_attribute5;
591: End If;
592: If (p_rec.cbp_attribute6 = hr_api.g_varchar2) then
593: p_rec.cbp_attribute6 :=
594: ben_cbp_shd.g_old_rec.cbp_attribute6;
595: End If;
596: If (p_rec.cbp_attribute7 = hr_api.g_varchar2) then
597: p_rec.cbp_attribute7 :=
598: ben_cbp_shd.g_old_rec.cbp_attribute7;

Line 598: ben_cbp_shd.g_old_rec.cbp_attribute7;

594: ben_cbp_shd.g_old_rec.cbp_attribute6;
595: End If;
596: If (p_rec.cbp_attribute7 = hr_api.g_varchar2) then
597: p_rec.cbp_attribute7 :=
598: ben_cbp_shd.g_old_rec.cbp_attribute7;
599: End If;
600: If (p_rec.cbp_attribute8 = hr_api.g_varchar2) then
601: p_rec.cbp_attribute8 :=
602: ben_cbp_shd.g_old_rec.cbp_attribute8;

Line 602: ben_cbp_shd.g_old_rec.cbp_attribute8;

598: ben_cbp_shd.g_old_rec.cbp_attribute7;
599: End If;
600: If (p_rec.cbp_attribute8 = hr_api.g_varchar2) then
601: p_rec.cbp_attribute8 :=
602: ben_cbp_shd.g_old_rec.cbp_attribute8;
603: End If;
604: If (p_rec.cbp_attribute9 = hr_api.g_varchar2) then
605: p_rec.cbp_attribute9 :=
606: ben_cbp_shd.g_old_rec.cbp_attribute9;

Line 606: ben_cbp_shd.g_old_rec.cbp_attribute9;

602: ben_cbp_shd.g_old_rec.cbp_attribute8;
603: End If;
604: If (p_rec.cbp_attribute9 = hr_api.g_varchar2) then
605: p_rec.cbp_attribute9 :=
606: ben_cbp_shd.g_old_rec.cbp_attribute9;
607: End If;
608: If (p_rec.cbp_attribute10 = hr_api.g_varchar2) then
609: p_rec.cbp_attribute10 :=
610: ben_cbp_shd.g_old_rec.cbp_attribute10;

Line 610: ben_cbp_shd.g_old_rec.cbp_attribute10;

606: ben_cbp_shd.g_old_rec.cbp_attribute9;
607: End If;
608: If (p_rec.cbp_attribute10 = hr_api.g_varchar2) then
609: p_rec.cbp_attribute10 :=
610: ben_cbp_shd.g_old_rec.cbp_attribute10;
611: End If;
612: If (p_rec.cbp_attribute11 = hr_api.g_varchar2) then
613: p_rec.cbp_attribute11 :=
614: ben_cbp_shd.g_old_rec.cbp_attribute11;

Line 614: ben_cbp_shd.g_old_rec.cbp_attribute11;

610: ben_cbp_shd.g_old_rec.cbp_attribute10;
611: End If;
612: If (p_rec.cbp_attribute11 = hr_api.g_varchar2) then
613: p_rec.cbp_attribute11 :=
614: ben_cbp_shd.g_old_rec.cbp_attribute11;
615: End If;
616: If (p_rec.cbp_attribute12 = hr_api.g_varchar2) then
617: p_rec.cbp_attribute12 :=
618: ben_cbp_shd.g_old_rec.cbp_attribute12;

Line 618: ben_cbp_shd.g_old_rec.cbp_attribute12;

614: ben_cbp_shd.g_old_rec.cbp_attribute11;
615: End If;
616: If (p_rec.cbp_attribute12 = hr_api.g_varchar2) then
617: p_rec.cbp_attribute12 :=
618: ben_cbp_shd.g_old_rec.cbp_attribute12;
619: End If;
620: If (p_rec.cbp_attribute13 = hr_api.g_varchar2) then
621: p_rec.cbp_attribute13 :=
622: ben_cbp_shd.g_old_rec.cbp_attribute13;

Line 622: ben_cbp_shd.g_old_rec.cbp_attribute13;

618: ben_cbp_shd.g_old_rec.cbp_attribute12;
619: End If;
620: If (p_rec.cbp_attribute13 = hr_api.g_varchar2) then
621: p_rec.cbp_attribute13 :=
622: ben_cbp_shd.g_old_rec.cbp_attribute13;
623: End If;
624: If (p_rec.cbp_attribute14 = hr_api.g_varchar2) then
625: p_rec.cbp_attribute14 :=
626: ben_cbp_shd.g_old_rec.cbp_attribute14;

Line 626: ben_cbp_shd.g_old_rec.cbp_attribute14;

622: ben_cbp_shd.g_old_rec.cbp_attribute13;
623: End If;
624: If (p_rec.cbp_attribute14 = hr_api.g_varchar2) then
625: p_rec.cbp_attribute14 :=
626: ben_cbp_shd.g_old_rec.cbp_attribute14;
627: End If;
628: If (p_rec.cbp_attribute15 = hr_api.g_varchar2) then
629: p_rec.cbp_attribute15 :=
630: ben_cbp_shd.g_old_rec.cbp_attribute15;

Line 630: ben_cbp_shd.g_old_rec.cbp_attribute15;

626: ben_cbp_shd.g_old_rec.cbp_attribute14;
627: End If;
628: If (p_rec.cbp_attribute15 = hr_api.g_varchar2) then
629: p_rec.cbp_attribute15 :=
630: ben_cbp_shd.g_old_rec.cbp_attribute15;
631: End If;
632: If (p_rec.cbp_attribute16 = hr_api.g_varchar2) then
633: p_rec.cbp_attribute16 :=
634: ben_cbp_shd.g_old_rec.cbp_attribute16;

Line 634: ben_cbp_shd.g_old_rec.cbp_attribute16;

630: ben_cbp_shd.g_old_rec.cbp_attribute15;
631: End If;
632: If (p_rec.cbp_attribute16 = hr_api.g_varchar2) then
633: p_rec.cbp_attribute16 :=
634: ben_cbp_shd.g_old_rec.cbp_attribute16;
635: End If;
636: If (p_rec.cbp_attribute17 = hr_api.g_varchar2) then
637: p_rec.cbp_attribute17 :=
638: ben_cbp_shd.g_old_rec.cbp_attribute17;

Line 638: ben_cbp_shd.g_old_rec.cbp_attribute17;

634: ben_cbp_shd.g_old_rec.cbp_attribute16;
635: End If;
636: If (p_rec.cbp_attribute17 = hr_api.g_varchar2) then
637: p_rec.cbp_attribute17 :=
638: ben_cbp_shd.g_old_rec.cbp_attribute17;
639: End If;
640: If (p_rec.cbp_attribute18 = hr_api.g_varchar2) then
641: p_rec.cbp_attribute18 :=
642: ben_cbp_shd.g_old_rec.cbp_attribute18;

Line 642: ben_cbp_shd.g_old_rec.cbp_attribute18;

638: ben_cbp_shd.g_old_rec.cbp_attribute17;
639: End If;
640: If (p_rec.cbp_attribute18 = hr_api.g_varchar2) then
641: p_rec.cbp_attribute18 :=
642: ben_cbp_shd.g_old_rec.cbp_attribute18;
643: End If;
644: If (p_rec.cbp_attribute19 = hr_api.g_varchar2) then
645: p_rec.cbp_attribute19 :=
646: ben_cbp_shd.g_old_rec.cbp_attribute19;

Line 646: ben_cbp_shd.g_old_rec.cbp_attribute19;

642: ben_cbp_shd.g_old_rec.cbp_attribute18;
643: End If;
644: If (p_rec.cbp_attribute19 = hr_api.g_varchar2) then
645: p_rec.cbp_attribute19 :=
646: ben_cbp_shd.g_old_rec.cbp_attribute19;
647: End If;
648: If (p_rec.cbp_attribute20 = hr_api.g_varchar2) then
649: p_rec.cbp_attribute20 :=
650: ben_cbp_shd.g_old_rec.cbp_attribute20;

Line 650: ben_cbp_shd.g_old_rec.cbp_attribute20;

646: ben_cbp_shd.g_old_rec.cbp_attribute19;
647: End If;
648: If (p_rec.cbp_attribute20 = hr_api.g_varchar2) then
649: p_rec.cbp_attribute20 :=
650: ben_cbp_shd.g_old_rec.cbp_attribute20;
651: End If;
652: If (p_rec.cbp_attribute21 = hr_api.g_varchar2) then
653: p_rec.cbp_attribute21 :=
654: ben_cbp_shd.g_old_rec.cbp_attribute21;

Line 654: ben_cbp_shd.g_old_rec.cbp_attribute21;

650: ben_cbp_shd.g_old_rec.cbp_attribute20;
651: End If;
652: If (p_rec.cbp_attribute21 = hr_api.g_varchar2) then
653: p_rec.cbp_attribute21 :=
654: ben_cbp_shd.g_old_rec.cbp_attribute21;
655: End If;
656: If (p_rec.cbp_attribute22 = hr_api.g_varchar2) then
657: p_rec.cbp_attribute22 :=
658: ben_cbp_shd.g_old_rec.cbp_attribute22;

Line 658: ben_cbp_shd.g_old_rec.cbp_attribute22;

654: ben_cbp_shd.g_old_rec.cbp_attribute21;
655: End If;
656: If (p_rec.cbp_attribute22 = hr_api.g_varchar2) then
657: p_rec.cbp_attribute22 :=
658: ben_cbp_shd.g_old_rec.cbp_attribute22;
659: End If;
660: If (p_rec.cbp_attribute23 = hr_api.g_varchar2) then
661: p_rec.cbp_attribute23 :=
662: ben_cbp_shd.g_old_rec.cbp_attribute23;

Line 662: ben_cbp_shd.g_old_rec.cbp_attribute23;

658: ben_cbp_shd.g_old_rec.cbp_attribute22;
659: End If;
660: If (p_rec.cbp_attribute23 = hr_api.g_varchar2) then
661: p_rec.cbp_attribute23 :=
662: ben_cbp_shd.g_old_rec.cbp_attribute23;
663: End If;
664: If (p_rec.cbp_attribute24 = hr_api.g_varchar2) then
665: p_rec.cbp_attribute24 :=
666: ben_cbp_shd.g_old_rec.cbp_attribute24;

Line 666: ben_cbp_shd.g_old_rec.cbp_attribute24;

662: ben_cbp_shd.g_old_rec.cbp_attribute23;
663: End If;
664: If (p_rec.cbp_attribute24 = hr_api.g_varchar2) then
665: p_rec.cbp_attribute24 :=
666: ben_cbp_shd.g_old_rec.cbp_attribute24;
667: End If;
668: If (p_rec.cbp_attribute25 = hr_api.g_varchar2) then
669: p_rec.cbp_attribute25 :=
670: ben_cbp_shd.g_old_rec.cbp_attribute25;

Line 670: ben_cbp_shd.g_old_rec.cbp_attribute25;

666: ben_cbp_shd.g_old_rec.cbp_attribute24;
667: End If;
668: If (p_rec.cbp_attribute25 = hr_api.g_varchar2) then
669: p_rec.cbp_attribute25 :=
670: ben_cbp_shd.g_old_rec.cbp_attribute25;
671: End If;
672: If (p_rec.cbp_attribute26 = hr_api.g_varchar2) then
673: p_rec.cbp_attribute26 :=
674: ben_cbp_shd.g_old_rec.cbp_attribute26;

Line 674: ben_cbp_shd.g_old_rec.cbp_attribute26;

670: ben_cbp_shd.g_old_rec.cbp_attribute25;
671: End If;
672: If (p_rec.cbp_attribute26 = hr_api.g_varchar2) then
673: p_rec.cbp_attribute26 :=
674: ben_cbp_shd.g_old_rec.cbp_attribute26;
675: End If;
676: If (p_rec.cbp_attribute27 = hr_api.g_varchar2) then
677: p_rec.cbp_attribute27 :=
678: ben_cbp_shd.g_old_rec.cbp_attribute27;

Line 678: ben_cbp_shd.g_old_rec.cbp_attribute27;

674: ben_cbp_shd.g_old_rec.cbp_attribute26;
675: End If;
676: If (p_rec.cbp_attribute27 = hr_api.g_varchar2) then
677: p_rec.cbp_attribute27 :=
678: ben_cbp_shd.g_old_rec.cbp_attribute27;
679: End If;
680: If (p_rec.cbp_attribute28 = hr_api.g_varchar2) then
681: p_rec.cbp_attribute28 :=
682: ben_cbp_shd.g_old_rec.cbp_attribute28;

Line 682: ben_cbp_shd.g_old_rec.cbp_attribute28;

678: ben_cbp_shd.g_old_rec.cbp_attribute27;
679: End If;
680: If (p_rec.cbp_attribute28 = hr_api.g_varchar2) then
681: p_rec.cbp_attribute28 :=
682: ben_cbp_shd.g_old_rec.cbp_attribute28;
683: End If;
684: If (p_rec.cbp_attribute29 = hr_api.g_varchar2) then
685: p_rec.cbp_attribute29 :=
686: ben_cbp_shd.g_old_rec.cbp_attribute29;

Line 686: ben_cbp_shd.g_old_rec.cbp_attribute29;

682: ben_cbp_shd.g_old_rec.cbp_attribute28;
683: End If;
684: If (p_rec.cbp_attribute29 = hr_api.g_varchar2) then
685: p_rec.cbp_attribute29 :=
686: ben_cbp_shd.g_old_rec.cbp_attribute29;
687: End If;
688: If (p_rec.cbp_attribute30 = hr_api.g_varchar2) then
689: p_rec.cbp_attribute30 :=
690: ben_cbp_shd.g_old_rec.cbp_attribute30;

Line 690: ben_cbp_shd.g_old_rec.cbp_attribute30;

686: ben_cbp_shd.g_old_rec.cbp_attribute29;
687: End If;
688: If (p_rec.cbp_attribute30 = hr_api.g_varchar2) then
689: p_rec.cbp_attribute30 :=
690: ben_cbp_shd.g_old_rec.cbp_attribute30;
691: End If;
692: If (p_rec.pgm_id = hr_api.g_number) then
693: p_rec.pgm_id :=
694: ben_cbp_shd.g_old_rec.pgm_id;

Line 694: ben_cbp_shd.g_old_rec.pgm_id;

690: ben_cbp_shd.g_old_rec.cbp_attribute30;
691: End If;
692: If (p_rec.pgm_id = hr_api.g_number) then
693: p_rec.pgm_id :=
694: ben_cbp_shd.g_old_rec.pgm_id;
695: End If;
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 10);
698: --

Line 706: p_rec in out nocopy ben_cbp_shd.g_rec_type,

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

Line 724: ben_cbp_shd.lck

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

Line 821: l_rec ben_cbp_shd.g_rec_type;

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

Line 831: ben_cbp_shd.convert_args

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