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_CPT_UPD dependencies on BEN_CPT_SHD

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

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

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

Line 129: ben_cpt_shd.g_api_dml := false; -- Unset the api dml status

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

Line 141: ben_cpt_shd.g_api_dml := false; -- Unset the api dml status

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

Line 142: ben_cpt_shd.constraint_error

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

Line 146: ben_cpt_shd.g_api_dml := false; -- Unset the api dml status

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

Line 147: ben_cpt_shd.constraint_error

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

Line 150: ben_cpt_shd.g_api_dml := false; -- Unset the api dml status

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

Line 186: (p_rec in out nocopy ben_cpt_shd.g_rec_type,

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

Line 250: (p_rec in out nocopy ben_cpt_shd.g_rec_type,

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

Line 266: ben_cpt_shd.upd_effective_end_date

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

Line 335: (p_rec in out nocopy ben_cpt_shd.g_rec_type,

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

Line 391: (p_rec in ben_cpt_shd.g_rec_type,

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

Line 453: ,p_effective_start_date_o =>ben_cpt_shd.g_old_rec.effective_start_date

449: ,p_effective_date =>p_effective_date
450: ,p_datetrack_mode =>p_datetrack_mode
451: ,p_validation_start_date =>p_validation_start_date
452: ,p_validation_end_date =>p_validation_end_date
453: ,p_effective_start_date_o =>ben_cpt_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
455: ,p_name_o =>ben_cpt_shd.g_old_rec.name
456: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category

Line 454: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date

450: ,p_datetrack_mode =>p_datetrack_mode
451: ,p_validation_start_date =>p_validation_start_date
452: ,p_validation_end_date =>p_validation_end_date
453: ,p_effective_start_date_o =>ben_cpt_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
455: ,p_name_o =>ben_cpt_shd.g_old_rec.name
456: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1

Line 455: ,p_name_o =>ben_cpt_shd.g_old_rec.name

451: ,p_validation_start_date =>p_validation_start_date
452: ,p_validation_end_date =>p_validation_end_date
453: ,p_effective_start_date_o =>ben_cpt_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
455: ,p_name_o =>ben_cpt_shd.g_old_rec.name
456: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2

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

452: ,p_validation_end_date =>p_validation_end_date
453: ,p_effective_start_date_o =>ben_cpt_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
455: ,p_name_o =>ben_cpt_shd.g_old_rec.name
456: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3

Line 457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category

453: ,p_effective_start_date_o =>ben_cpt_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
455: ,p_name_o =>ben_cpt_shd.g_old_rec.name
456: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4

Line 458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1

454: ,p_effective_end_date_o =>ben_cpt_shd.g_old_rec.effective_end_date
455: ,p_name_o =>ben_cpt_shd.g_old_rec.name
456: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5

Line 459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2

455: ,p_name_o =>ben_cpt_shd.g_old_rec.name
456: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6

Line 460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3

456: ,p_business_group_id_o =>ben_cpt_shd.g_old_rec.business_group_id
457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7

Line 461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4

457: ,p_cpt_attribute_category_o =>ben_cpt_shd.g_old_rec.cpt_attribute_category
458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8

Line 462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5

458: ,p_cpt_attribute1_o =>ben_cpt_shd.g_old_rec.cpt_attribute1
459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9

Line 463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6

459: ,p_cpt_attribute2_o =>ben_cpt_shd.g_old_rec.cpt_attribute2
460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10

Line 464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7

460: ,p_cpt_attribute3_o =>ben_cpt_shd.g_old_rec.cpt_attribute3
461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11

Line 465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8

461: ,p_cpt_attribute4_o =>ben_cpt_shd.g_old_rec.cpt_attribute4
462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12

Line 466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9

462: ,p_cpt_attribute5_o =>ben_cpt_shd.g_old_rec.cpt_attribute5
463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13

Line 467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10

463: ,p_cpt_attribute6_o =>ben_cpt_shd.g_old_rec.cpt_attribute6
464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14

Line 468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11

464: ,p_cpt_attribute7_o =>ben_cpt_shd.g_old_rec.cpt_attribute7
465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15

Line 469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12

465: ,p_cpt_attribute8_o =>ben_cpt_shd.g_old_rec.cpt_attribute8
466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16

Line 470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13

466: ,p_cpt_attribute9_o =>ben_cpt_shd.g_old_rec.cpt_attribute9
467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17

Line 471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14

467: ,p_cpt_attribute10_o =>ben_cpt_shd.g_old_rec.cpt_attribute10
468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18

Line 472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15

468: ,p_cpt_attribute11_o =>ben_cpt_shd.g_old_rec.cpt_attribute11
469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19

Line 473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16

469: ,p_cpt_attribute12_o =>ben_cpt_shd.g_old_rec.cpt_attribute12
470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20

Line 474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17

470: ,p_cpt_attribute13_o =>ben_cpt_shd.g_old_rec.cpt_attribute13
471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21

Line 475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18

471: ,p_cpt_attribute14_o =>ben_cpt_shd.g_old_rec.cpt_attribute14
472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22

Line 476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19

472: ,p_cpt_attribute15_o =>ben_cpt_shd.g_old_rec.cpt_attribute15
473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23

Line 477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20

473: ,p_cpt_attribute16_o =>ben_cpt_shd.g_old_rec.cpt_attribute16
474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24

Line 478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21

474: ,p_cpt_attribute17_o =>ben_cpt_shd.g_old_rec.cpt_attribute17
475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25

Line 479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22

475: ,p_cpt_attribute18_o =>ben_cpt_shd.g_old_rec.cpt_attribute18
476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26

Line 480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23

476: ,p_cpt_attribute19_o =>ben_cpt_shd.g_old_rec.cpt_attribute19
477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27

Line 481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24

477: ,p_cpt_attribute20_o =>ben_cpt_shd.g_old_rec.cpt_attribute20
478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28

Line 482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25

478: ,p_cpt_attribute21_o =>ben_cpt_shd.g_old_rec.cpt_attribute21
479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29

Line 483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26

479: ,p_cpt_attribute22_o =>ben_cpt_shd.g_old_rec.cpt_attribute22
480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30

Line 484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27

480: ,p_cpt_attribute23_o =>ben_cpt_shd.g_old_rec.cpt_attribute23
481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
488: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number

Line 485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28

481: ,p_cpt_attribute24_o =>ben_cpt_shd.g_old_rec.cpt_attribute24
482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
488: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
489: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id

Line 486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29

482: ,p_cpt_attribute25_o =>ben_cpt_shd.g_old_rec.cpt_attribute25
483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
488: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
489: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
490: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id

Line 487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30

483: ,p_cpt_attribute26_o =>ben_cpt_shd.g_old_rec.cpt_attribute26
484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
488: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
489: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
490: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
491: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id

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

484: ,p_cpt_attribute27_o =>ben_cpt_shd.g_old_rec.cpt_attribute27
485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
488: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
489: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
490: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
491: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id
492: );

Line 489: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id

485: ,p_cpt_attribute28_o =>ben_cpt_shd.g_old_rec.cpt_attribute28
486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
488: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
489: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
490: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
491: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id
492: );
493: --

Line 490: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id

486: ,p_cpt_attribute29_o =>ben_cpt_shd.g_old_rec.cpt_attribute29
487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
488: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
489: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
490: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
491: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id
492: );
493: --
494: exception

Line 491: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id

487: ,p_cpt_attribute30_o =>ben_cpt_shd.g_old_rec.cpt_attribute30
488: ,p_object_version_number_o =>ben_cpt_shd.g_old_rec.object_version_number
489: ,p_ptip_id_o =>ben_cpt_shd.g_old_rec.ptip_id
490: ,p_pgm_id_o =>ben_cpt_shd.g_old_rec.pgm_id
491: ,p_opt_id_o =>ben_cpt_shd.g_old_rec.opt_id
492: );
493: --
494: exception
495: --

Line 553: Procedure convert_defs(p_rec in out nocopy ben_cpt_shd.g_rec_type) is

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

Line 568: ben_cpt_shd.g_old_rec.name;

564: -- is being used then we must set to the 'current' argument value.
565: --
566: If (p_rec.name = hr_api.g_varchar2) then
567: p_rec.name :=
568: ben_cpt_shd.g_old_rec.name;
569: End If;
570: If (p_rec.business_group_id = hr_api.g_number) then
571: p_rec.business_group_id :=
572: ben_cpt_shd.g_old_rec.business_group_id;

Line 572: ben_cpt_shd.g_old_rec.business_group_id;

568: ben_cpt_shd.g_old_rec.name;
569: End If;
570: If (p_rec.business_group_id = hr_api.g_number) then
571: p_rec.business_group_id :=
572: ben_cpt_shd.g_old_rec.business_group_id;
573: End If;
574: If (p_rec.cpt_attribute_category = hr_api.g_varchar2) then
575: p_rec.cpt_attribute_category :=
576: ben_cpt_shd.g_old_rec.cpt_attribute_category;

Line 576: ben_cpt_shd.g_old_rec.cpt_attribute_category;

572: ben_cpt_shd.g_old_rec.business_group_id;
573: End If;
574: If (p_rec.cpt_attribute_category = hr_api.g_varchar2) then
575: p_rec.cpt_attribute_category :=
576: ben_cpt_shd.g_old_rec.cpt_attribute_category;
577: End If;
578: If (p_rec.cpt_attribute1 = hr_api.g_varchar2) then
579: p_rec.cpt_attribute1 :=
580: ben_cpt_shd.g_old_rec.cpt_attribute1;

Line 580: ben_cpt_shd.g_old_rec.cpt_attribute1;

576: ben_cpt_shd.g_old_rec.cpt_attribute_category;
577: End If;
578: If (p_rec.cpt_attribute1 = hr_api.g_varchar2) then
579: p_rec.cpt_attribute1 :=
580: ben_cpt_shd.g_old_rec.cpt_attribute1;
581: End If;
582: If (p_rec.cpt_attribute2 = hr_api.g_varchar2) then
583: p_rec.cpt_attribute2 :=
584: ben_cpt_shd.g_old_rec.cpt_attribute2;

Line 584: ben_cpt_shd.g_old_rec.cpt_attribute2;

580: ben_cpt_shd.g_old_rec.cpt_attribute1;
581: End If;
582: If (p_rec.cpt_attribute2 = hr_api.g_varchar2) then
583: p_rec.cpt_attribute2 :=
584: ben_cpt_shd.g_old_rec.cpt_attribute2;
585: End If;
586: If (p_rec.cpt_attribute3 = hr_api.g_varchar2) then
587: p_rec.cpt_attribute3 :=
588: ben_cpt_shd.g_old_rec.cpt_attribute3;

Line 588: ben_cpt_shd.g_old_rec.cpt_attribute3;

584: ben_cpt_shd.g_old_rec.cpt_attribute2;
585: End If;
586: If (p_rec.cpt_attribute3 = hr_api.g_varchar2) then
587: p_rec.cpt_attribute3 :=
588: ben_cpt_shd.g_old_rec.cpt_attribute3;
589: End If;
590: If (p_rec.cpt_attribute4 = hr_api.g_varchar2) then
591: p_rec.cpt_attribute4 :=
592: ben_cpt_shd.g_old_rec.cpt_attribute4;

Line 592: ben_cpt_shd.g_old_rec.cpt_attribute4;

588: ben_cpt_shd.g_old_rec.cpt_attribute3;
589: End If;
590: If (p_rec.cpt_attribute4 = hr_api.g_varchar2) then
591: p_rec.cpt_attribute4 :=
592: ben_cpt_shd.g_old_rec.cpt_attribute4;
593: End If;
594: If (p_rec.cpt_attribute5 = hr_api.g_varchar2) then
595: p_rec.cpt_attribute5 :=
596: ben_cpt_shd.g_old_rec.cpt_attribute5;

Line 596: ben_cpt_shd.g_old_rec.cpt_attribute5;

592: ben_cpt_shd.g_old_rec.cpt_attribute4;
593: End If;
594: If (p_rec.cpt_attribute5 = hr_api.g_varchar2) then
595: p_rec.cpt_attribute5 :=
596: ben_cpt_shd.g_old_rec.cpt_attribute5;
597: End If;
598: If (p_rec.cpt_attribute6 = hr_api.g_varchar2) then
599: p_rec.cpt_attribute6 :=
600: ben_cpt_shd.g_old_rec.cpt_attribute6;

Line 600: ben_cpt_shd.g_old_rec.cpt_attribute6;

596: ben_cpt_shd.g_old_rec.cpt_attribute5;
597: End If;
598: If (p_rec.cpt_attribute6 = hr_api.g_varchar2) then
599: p_rec.cpt_attribute6 :=
600: ben_cpt_shd.g_old_rec.cpt_attribute6;
601: End If;
602: If (p_rec.cpt_attribute7 = hr_api.g_varchar2) then
603: p_rec.cpt_attribute7 :=
604: ben_cpt_shd.g_old_rec.cpt_attribute7;

Line 604: ben_cpt_shd.g_old_rec.cpt_attribute7;

600: ben_cpt_shd.g_old_rec.cpt_attribute6;
601: End If;
602: If (p_rec.cpt_attribute7 = hr_api.g_varchar2) then
603: p_rec.cpt_attribute7 :=
604: ben_cpt_shd.g_old_rec.cpt_attribute7;
605: End If;
606: If (p_rec.cpt_attribute8 = hr_api.g_varchar2) then
607: p_rec.cpt_attribute8 :=
608: ben_cpt_shd.g_old_rec.cpt_attribute8;

Line 608: ben_cpt_shd.g_old_rec.cpt_attribute8;

604: ben_cpt_shd.g_old_rec.cpt_attribute7;
605: End If;
606: If (p_rec.cpt_attribute8 = hr_api.g_varchar2) then
607: p_rec.cpt_attribute8 :=
608: ben_cpt_shd.g_old_rec.cpt_attribute8;
609: End If;
610: If (p_rec.cpt_attribute9 = hr_api.g_varchar2) then
611: p_rec.cpt_attribute9 :=
612: ben_cpt_shd.g_old_rec.cpt_attribute9;

Line 612: ben_cpt_shd.g_old_rec.cpt_attribute9;

608: ben_cpt_shd.g_old_rec.cpt_attribute8;
609: End If;
610: If (p_rec.cpt_attribute9 = hr_api.g_varchar2) then
611: p_rec.cpt_attribute9 :=
612: ben_cpt_shd.g_old_rec.cpt_attribute9;
613: End If;
614: If (p_rec.cpt_attribute10 = hr_api.g_varchar2) then
615: p_rec.cpt_attribute10 :=
616: ben_cpt_shd.g_old_rec.cpt_attribute10;

Line 616: ben_cpt_shd.g_old_rec.cpt_attribute10;

612: ben_cpt_shd.g_old_rec.cpt_attribute9;
613: End If;
614: If (p_rec.cpt_attribute10 = hr_api.g_varchar2) then
615: p_rec.cpt_attribute10 :=
616: ben_cpt_shd.g_old_rec.cpt_attribute10;
617: End If;
618: If (p_rec.cpt_attribute11 = hr_api.g_varchar2) then
619: p_rec.cpt_attribute11 :=
620: ben_cpt_shd.g_old_rec.cpt_attribute11;

Line 620: ben_cpt_shd.g_old_rec.cpt_attribute11;

616: ben_cpt_shd.g_old_rec.cpt_attribute10;
617: End If;
618: If (p_rec.cpt_attribute11 = hr_api.g_varchar2) then
619: p_rec.cpt_attribute11 :=
620: ben_cpt_shd.g_old_rec.cpt_attribute11;
621: End If;
622: If (p_rec.cpt_attribute12 = hr_api.g_varchar2) then
623: p_rec.cpt_attribute12 :=
624: ben_cpt_shd.g_old_rec.cpt_attribute12;

Line 624: ben_cpt_shd.g_old_rec.cpt_attribute12;

620: ben_cpt_shd.g_old_rec.cpt_attribute11;
621: End If;
622: If (p_rec.cpt_attribute12 = hr_api.g_varchar2) then
623: p_rec.cpt_attribute12 :=
624: ben_cpt_shd.g_old_rec.cpt_attribute12;
625: End If;
626: If (p_rec.cpt_attribute13 = hr_api.g_varchar2) then
627: p_rec.cpt_attribute13 :=
628: ben_cpt_shd.g_old_rec.cpt_attribute13;

Line 628: ben_cpt_shd.g_old_rec.cpt_attribute13;

624: ben_cpt_shd.g_old_rec.cpt_attribute12;
625: End If;
626: If (p_rec.cpt_attribute13 = hr_api.g_varchar2) then
627: p_rec.cpt_attribute13 :=
628: ben_cpt_shd.g_old_rec.cpt_attribute13;
629: End If;
630: If (p_rec.cpt_attribute14 = hr_api.g_varchar2) then
631: p_rec.cpt_attribute14 :=
632: ben_cpt_shd.g_old_rec.cpt_attribute14;

Line 632: ben_cpt_shd.g_old_rec.cpt_attribute14;

628: ben_cpt_shd.g_old_rec.cpt_attribute13;
629: End If;
630: If (p_rec.cpt_attribute14 = hr_api.g_varchar2) then
631: p_rec.cpt_attribute14 :=
632: ben_cpt_shd.g_old_rec.cpt_attribute14;
633: End If;
634: If (p_rec.cpt_attribute15 = hr_api.g_varchar2) then
635: p_rec.cpt_attribute15 :=
636: ben_cpt_shd.g_old_rec.cpt_attribute15;

Line 636: ben_cpt_shd.g_old_rec.cpt_attribute15;

632: ben_cpt_shd.g_old_rec.cpt_attribute14;
633: End If;
634: If (p_rec.cpt_attribute15 = hr_api.g_varchar2) then
635: p_rec.cpt_attribute15 :=
636: ben_cpt_shd.g_old_rec.cpt_attribute15;
637: End If;
638: If (p_rec.cpt_attribute16 = hr_api.g_varchar2) then
639: p_rec.cpt_attribute16 :=
640: ben_cpt_shd.g_old_rec.cpt_attribute16;

Line 640: ben_cpt_shd.g_old_rec.cpt_attribute16;

636: ben_cpt_shd.g_old_rec.cpt_attribute15;
637: End If;
638: If (p_rec.cpt_attribute16 = hr_api.g_varchar2) then
639: p_rec.cpt_attribute16 :=
640: ben_cpt_shd.g_old_rec.cpt_attribute16;
641: End If;
642: If (p_rec.cpt_attribute17 = hr_api.g_varchar2) then
643: p_rec.cpt_attribute17 :=
644: ben_cpt_shd.g_old_rec.cpt_attribute17;

Line 644: ben_cpt_shd.g_old_rec.cpt_attribute17;

640: ben_cpt_shd.g_old_rec.cpt_attribute16;
641: End If;
642: If (p_rec.cpt_attribute17 = hr_api.g_varchar2) then
643: p_rec.cpt_attribute17 :=
644: ben_cpt_shd.g_old_rec.cpt_attribute17;
645: End If;
646: If (p_rec.cpt_attribute18 = hr_api.g_varchar2) then
647: p_rec.cpt_attribute18 :=
648: ben_cpt_shd.g_old_rec.cpt_attribute18;

Line 648: ben_cpt_shd.g_old_rec.cpt_attribute18;

644: ben_cpt_shd.g_old_rec.cpt_attribute17;
645: End If;
646: If (p_rec.cpt_attribute18 = hr_api.g_varchar2) then
647: p_rec.cpt_attribute18 :=
648: ben_cpt_shd.g_old_rec.cpt_attribute18;
649: End If;
650: If (p_rec.cpt_attribute19 = hr_api.g_varchar2) then
651: p_rec.cpt_attribute19 :=
652: ben_cpt_shd.g_old_rec.cpt_attribute19;

Line 652: ben_cpt_shd.g_old_rec.cpt_attribute19;

648: ben_cpt_shd.g_old_rec.cpt_attribute18;
649: End If;
650: If (p_rec.cpt_attribute19 = hr_api.g_varchar2) then
651: p_rec.cpt_attribute19 :=
652: ben_cpt_shd.g_old_rec.cpt_attribute19;
653: End If;
654: If (p_rec.cpt_attribute20 = hr_api.g_varchar2) then
655: p_rec.cpt_attribute20 :=
656: ben_cpt_shd.g_old_rec.cpt_attribute20;

Line 656: ben_cpt_shd.g_old_rec.cpt_attribute20;

652: ben_cpt_shd.g_old_rec.cpt_attribute19;
653: End If;
654: If (p_rec.cpt_attribute20 = hr_api.g_varchar2) then
655: p_rec.cpt_attribute20 :=
656: ben_cpt_shd.g_old_rec.cpt_attribute20;
657: End If;
658: If (p_rec.cpt_attribute21 = hr_api.g_varchar2) then
659: p_rec.cpt_attribute21 :=
660: ben_cpt_shd.g_old_rec.cpt_attribute21;

Line 660: ben_cpt_shd.g_old_rec.cpt_attribute21;

656: ben_cpt_shd.g_old_rec.cpt_attribute20;
657: End If;
658: If (p_rec.cpt_attribute21 = hr_api.g_varchar2) then
659: p_rec.cpt_attribute21 :=
660: ben_cpt_shd.g_old_rec.cpt_attribute21;
661: End If;
662: If (p_rec.cpt_attribute22 = hr_api.g_varchar2) then
663: p_rec.cpt_attribute22 :=
664: ben_cpt_shd.g_old_rec.cpt_attribute22;

Line 664: ben_cpt_shd.g_old_rec.cpt_attribute22;

660: ben_cpt_shd.g_old_rec.cpt_attribute21;
661: End If;
662: If (p_rec.cpt_attribute22 = hr_api.g_varchar2) then
663: p_rec.cpt_attribute22 :=
664: ben_cpt_shd.g_old_rec.cpt_attribute22;
665: End If;
666: If (p_rec.cpt_attribute23 = hr_api.g_varchar2) then
667: p_rec.cpt_attribute23 :=
668: ben_cpt_shd.g_old_rec.cpt_attribute23;

Line 668: ben_cpt_shd.g_old_rec.cpt_attribute23;

664: ben_cpt_shd.g_old_rec.cpt_attribute22;
665: End If;
666: If (p_rec.cpt_attribute23 = hr_api.g_varchar2) then
667: p_rec.cpt_attribute23 :=
668: ben_cpt_shd.g_old_rec.cpt_attribute23;
669: End If;
670: If (p_rec.cpt_attribute24 = hr_api.g_varchar2) then
671: p_rec.cpt_attribute24 :=
672: ben_cpt_shd.g_old_rec.cpt_attribute24;

Line 672: ben_cpt_shd.g_old_rec.cpt_attribute24;

668: ben_cpt_shd.g_old_rec.cpt_attribute23;
669: End If;
670: If (p_rec.cpt_attribute24 = hr_api.g_varchar2) then
671: p_rec.cpt_attribute24 :=
672: ben_cpt_shd.g_old_rec.cpt_attribute24;
673: End If;
674: If (p_rec.cpt_attribute25 = hr_api.g_varchar2) then
675: p_rec.cpt_attribute25 :=
676: ben_cpt_shd.g_old_rec.cpt_attribute25;

Line 676: ben_cpt_shd.g_old_rec.cpt_attribute25;

672: ben_cpt_shd.g_old_rec.cpt_attribute24;
673: End If;
674: If (p_rec.cpt_attribute25 = hr_api.g_varchar2) then
675: p_rec.cpt_attribute25 :=
676: ben_cpt_shd.g_old_rec.cpt_attribute25;
677: End If;
678: If (p_rec.cpt_attribute26 = hr_api.g_varchar2) then
679: p_rec.cpt_attribute26 :=
680: ben_cpt_shd.g_old_rec.cpt_attribute26;

Line 680: ben_cpt_shd.g_old_rec.cpt_attribute26;

676: ben_cpt_shd.g_old_rec.cpt_attribute25;
677: End If;
678: If (p_rec.cpt_attribute26 = hr_api.g_varchar2) then
679: p_rec.cpt_attribute26 :=
680: ben_cpt_shd.g_old_rec.cpt_attribute26;
681: End If;
682: If (p_rec.cpt_attribute27 = hr_api.g_varchar2) then
683: p_rec.cpt_attribute27 :=
684: ben_cpt_shd.g_old_rec.cpt_attribute27;

Line 684: ben_cpt_shd.g_old_rec.cpt_attribute27;

680: ben_cpt_shd.g_old_rec.cpt_attribute26;
681: End If;
682: If (p_rec.cpt_attribute27 = hr_api.g_varchar2) then
683: p_rec.cpt_attribute27 :=
684: ben_cpt_shd.g_old_rec.cpt_attribute27;
685: End If;
686: If (p_rec.cpt_attribute28 = hr_api.g_varchar2) then
687: p_rec.cpt_attribute28 :=
688: ben_cpt_shd.g_old_rec.cpt_attribute28;

Line 688: ben_cpt_shd.g_old_rec.cpt_attribute28;

684: ben_cpt_shd.g_old_rec.cpt_attribute27;
685: End If;
686: If (p_rec.cpt_attribute28 = hr_api.g_varchar2) then
687: p_rec.cpt_attribute28 :=
688: ben_cpt_shd.g_old_rec.cpt_attribute28;
689: End If;
690: If (p_rec.cpt_attribute29 = hr_api.g_varchar2) then
691: p_rec.cpt_attribute29 :=
692: ben_cpt_shd.g_old_rec.cpt_attribute29;

Line 692: ben_cpt_shd.g_old_rec.cpt_attribute29;

688: ben_cpt_shd.g_old_rec.cpt_attribute28;
689: End If;
690: If (p_rec.cpt_attribute29 = hr_api.g_varchar2) then
691: p_rec.cpt_attribute29 :=
692: ben_cpt_shd.g_old_rec.cpt_attribute29;
693: End If;
694: If (p_rec.cpt_attribute30 = hr_api.g_varchar2) then
695: p_rec.cpt_attribute30 :=
696: ben_cpt_shd.g_old_rec.cpt_attribute30;

Line 696: ben_cpt_shd.g_old_rec.cpt_attribute30;

692: ben_cpt_shd.g_old_rec.cpt_attribute29;
693: End If;
694: If (p_rec.cpt_attribute30 = hr_api.g_varchar2) then
695: p_rec.cpt_attribute30 :=
696: ben_cpt_shd.g_old_rec.cpt_attribute30;
697: End If;
698: If (p_rec.ptip_id = hr_api.g_number) then
699: p_rec.ptip_id :=
700: ben_cpt_shd.g_old_rec.ptip_id;

Line 700: ben_cpt_shd.g_old_rec.ptip_id;

696: ben_cpt_shd.g_old_rec.cpt_attribute30;
697: End If;
698: If (p_rec.ptip_id = hr_api.g_number) then
699: p_rec.ptip_id :=
700: ben_cpt_shd.g_old_rec.ptip_id;
701: End If;
702: If (p_rec.pgm_id = hr_api.g_number) then
703: p_rec.pgm_id :=
704: ben_cpt_shd.g_old_rec.pgm_id;

Line 704: ben_cpt_shd.g_old_rec.pgm_id;

700: ben_cpt_shd.g_old_rec.ptip_id;
701: End If;
702: If (p_rec.pgm_id = hr_api.g_number) then
703: p_rec.pgm_id :=
704: ben_cpt_shd.g_old_rec.pgm_id;
705: End If;
706: If (p_rec.opt_id = hr_api.g_number) then
707: p_rec.opt_id :=
708: ben_cpt_shd.g_old_rec.opt_id;

Line 708: ben_cpt_shd.g_old_rec.opt_id;

704: ben_cpt_shd.g_old_rec.pgm_id;
705: End If;
706: If (p_rec.opt_id = hr_api.g_number) then
707: p_rec.opt_id :=
708: ben_cpt_shd.g_old_rec.opt_id;
709: End If;
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 10);
712: --

Line 720: p_rec in out nocopy ben_cpt_shd.g_rec_type,

716: -- |---------------------------------< upd >----------------------------------|
717: -- ----------------------------------------------------------------------------
718: Procedure upd
719: (
720: p_rec in out nocopy ben_cpt_shd.g_rec_type,
721: p_effective_date in date,
722: p_datetrack_mode in varchar2
723: ) is
724: --

Line 738: ben_cpt_shd.lck

734: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
735: --
736: -- We must lock the row which we need to update.
737: --
738: ben_cpt_shd.lck
739: (p_effective_date => p_effective_date,
740: p_datetrack_mode => p_datetrack_mode,
741: p_cmbn_ptip_opt_id => p_rec.cmbn_ptip_opt_id,
742: p_object_version_number => p_rec.object_version_number,

Line 837: l_rec ben_cpt_shd.g_rec_type;

833: p_effective_date in date,
834: p_datetrack_mode in varchar2
835: ) is
836: --
837: l_rec ben_cpt_shd.g_rec_type;
838: l_proc varchar2(72) := g_package||'upd';
839: --
840: Begin
841: hr_utility.set_location('Entering:'||l_proc, 5);

Line 847: ben_cpt_shd.convert_args

843: -- Call conversion function to turn arguments into the
844: -- l_rec structure.
845: --
846: l_rec :=
847: ben_cpt_shd.convert_args
848: (
849: p_cmbn_ptip_opt_id,
850: null,
851: null,