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_CTT_UPD dependencies on BEN_CTT_SHD

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

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

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

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

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

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

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

Line 141: ben_ctt_shd.constraint_error

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

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

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

Line 146: ben_ctt_shd.constraint_error

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

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

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

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

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

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

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

Line 265: ben_ctt_shd.upd_effective_end_date

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

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

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

Line 390: (p_rec in ben_ctt_shd.g_rec_type,

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

Line 450: ,p_effective_start_date_o =>ben_ctt_shd.g_old_rec.effective_start_date

446: ,p_effective_date =>p_effective_date
447: ,p_datetrack_mode =>p_datetrack_mode
448: ,p_validation_start_date =>p_validation_start_date
449: ,p_validation_end_date =>p_validation_end_date
450: ,p_effective_start_date_o =>ben_ctt_shd.g_old_rec.effective_start_date
451: ,p_effective_end_date_o =>ben_ctt_shd.g_old_rec.effective_end_date
452: ,p_cm_typ_trgr_rl_o =>ben_ctt_shd.g_old_rec.cm_typ_trgr_rl
453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id
454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id

Line 451: ,p_effective_end_date_o =>ben_ctt_shd.g_old_rec.effective_end_date

447: ,p_datetrack_mode =>p_datetrack_mode
448: ,p_validation_start_date =>p_validation_start_date
449: ,p_validation_end_date =>p_validation_end_date
450: ,p_effective_start_date_o =>ben_ctt_shd.g_old_rec.effective_start_date
451: ,p_effective_end_date_o =>ben_ctt_shd.g_old_rec.effective_end_date
452: ,p_cm_typ_trgr_rl_o =>ben_ctt_shd.g_old_rec.cm_typ_trgr_rl
453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id
454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id
455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id

Line 452: ,p_cm_typ_trgr_rl_o =>ben_ctt_shd.g_old_rec.cm_typ_trgr_rl

448: ,p_validation_start_date =>p_validation_start_date
449: ,p_validation_end_date =>p_validation_end_date
450: ,p_effective_start_date_o =>ben_ctt_shd.g_old_rec.effective_start_date
451: ,p_effective_end_date_o =>ben_ctt_shd.g_old_rec.effective_end_date
452: ,p_cm_typ_trgr_rl_o =>ben_ctt_shd.g_old_rec.cm_typ_trgr_rl
453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id
454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id
455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id
456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category

Line 453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id

449: ,p_validation_end_date =>p_validation_end_date
450: ,p_effective_start_date_o =>ben_ctt_shd.g_old_rec.effective_start_date
451: ,p_effective_end_date_o =>ben_ctt_shd.g_old_rec.effective_end_date
452: ,p_cm_typ_trgr_rl_o =>ben_ctt_shd.g_old_rec.cm_typ_trgr_rl
453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id
454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id
455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id
456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category
457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1

Line 454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id

450: ,p_effective_start_date_o =>ben_ctt_shd.g_old_rec.effective_start_date
451: ,p_effective_end_date_o =>ben_ctt_shd.g_old_rec.effective_end_date
452: ,p_cm_typ_trgr_rl_o =>ben_ctt_shd.g_old_rec.cm_typ_trgr_rl
453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id
454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id
455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id
456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category
457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1
458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2

Line 455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id

451: ,p_effective_end_date_o =>ben_ctt_shd.g_old_rec.effective_end_date
452: ,p_cm_typ_trgr_rl_o =>ben_ctt_shd.g_old_rec.cm_typ_trgr_rl
453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id
454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id
455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id
456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category
457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1
458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2
459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3

Line 456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category

452: ,p_cm_typ_trgr_rl_o =>ben_ctt_shd.g_old_rec.cm_typ_trgr_rl
453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id
454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id
455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id
456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category
457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1
458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2
459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3
460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4

Line 457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1

453: ,p_cm_trgr_id_o =>ben_ctt_shd.g_old_rec.cm_trgr_id
454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id
455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id
456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category
457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1
458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2
459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3
460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4
461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5

Line 458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2

454: ,p_cm_typ_id_o =>ben_ctt_shd.g_old_rec.cm_typ_id
455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id
456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category
457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1
458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2
459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3
460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4
461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5
462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6

Line 459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3

455: ,p_business_group_id_o =>ben_ctt_shd.g_old_rec.business_group_id
456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category
457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1
458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2
459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3
460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4
461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5
462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6
463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7

Line 460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4

456: ,p_ctt_attribute_category_o =>ben_ctt_shd.g_old_rec.ctt_attribute_category
457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1
458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2
459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3
460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4
461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5
462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6
463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7
464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8

Line 461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5

457: ,p_ctt_attribute1_o =>ben_ctt_shd.g_old_rec.ctt_attribute1
458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2
459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3
460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4
461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5
462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6
463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7
464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8
465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9

Line 462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6

458: ,p_ctt_attribute2_o =>ben_ctt_shd.g_old_rec.ctt_attribute2
459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3
460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4
461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5
462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6
463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7
464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8
465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9
466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10

Line 463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7

459: ,p_ctt_attribute3_o =>ben_ctt_shd.g_old_rec.ctt_attribute3
460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4
461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5
462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6
463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7
464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8
465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9
466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10
467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11

Line 464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8

460: ,p_ctt_attribute4_o =>ben_ctt_shd.g_old_rec.ctt_attribute4
461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5
462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6
463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7
464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8
465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9
466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10
467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11
468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12

Line 465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9

461: ,p_ctt_attribute5_o =>ben_ctt_shd.g_old_rec.ctt_attribute5
462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6
463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7
464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8
465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9
466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10
467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11
468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12
469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13

Line 466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10

462: ,p_ctt_attribute6_o =>ben_ctt_shd.g_old_rec.ctt_attribute6
463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7
464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8
465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9
466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10
467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11
468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12
469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13
470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14

Line 467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11

463: ,p_ctt_attribute7_o =>ben_ctt_shd.g_old_rec.ctt_attribute7
464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8
465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9
466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10
467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11
468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12
469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13
470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14
471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15

Line 468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12

464: ,p_ctt_attribute8_o =>ben_ctt_shd.g_old_rec.ctt_attribute8
465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9
466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10
467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11
468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12
469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13
470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14
471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15
472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16

Line 469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13

465: ,p_ctt_attribute9_o =>ben_ctt_shd.g_old_rec.ctt_attribute9
466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10
467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11
468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12
469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13
470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14
471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15
472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16
473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17

Line 470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14

466: ,p_ctt_attribute10_o =>ben_ctt_shd.g_old_rec.ctt_attribute10
467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11
468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12
469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13
470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14
471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15
472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16
473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17
474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18

Line 471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15

467: ,p_ctt_attribute11_o =>ben_ctt_shd.g_old_rec.ctt_attribute11
468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12
469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13
470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14
471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15
472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16
473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17
474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18
475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19

Line 472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16

468: ,p_ctt_attribute12_o =>ben_ctt_shd.g_old_rec.ctt_attribute12
469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13
470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14
471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15
472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16
473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17
474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18
475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19
476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20

Line 473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17

469: ,p_ctt_attribute13_o =>ben_ctt_shd.g_old_rec.ctt_attribute13
470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14
471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15
472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16
473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17
474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18
475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19
476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20
477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21

Line 474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18

470: ,p_ctt_attribute14_o =>ben_ctt_shd.g_old_rec.ctt_attribute14
471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15
472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16
473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17
474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18
475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19
476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20
477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21
478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22

Line 475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19

471: ,p_ctt_attribute15_o =>ben_ctt_shd.g_old_rec.ctt_attribute15
472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16
473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17
474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18
475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19
476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20
477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21
478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22
479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23

Line 476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20

472: ,p_ctt_attribute16_o =>ben_ctt_shd.g_old_rec.ctt_attribute16
473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17
474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18
475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19
476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20
477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21
478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22
479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23
480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24

Line 477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21

473: ,p_ctt_attribute17_o =>ben_ctt_shd.g_old_rec.ctt_attribute17
474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18
475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19
476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20
477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21
478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22
479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23
480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24
481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25

Line 478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22

474: ,p_ctt_attribute18_o =>ben_ctt_shd.g_old_rec.ctt_attribute18
475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19
476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20
477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21
478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22
479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23
480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24
481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25
482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26

Line 479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23

475: ,p_ctt_attribute19_o =>ben_ctt_shd.g_old_rec.ctt_attribute19
476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20
477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21
478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22
479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23
480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24
481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25
482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26
483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27

Line 480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24

476: ,p_ctt_attribute20_o =>ben_ctt_shd.g_old_rec.ctt_attribute20
477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21
478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22
479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23
480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24
481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25
482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26
483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27
484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28

Line 481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25

477: ,p_ctt_attribute21_o =>ben_ctt_shd.g_old_rec.ctt_attribute21
478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22
479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23
480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24
481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25
482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26
483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27
484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28
485: ,p_ctt_attribute29_o =>ben_ctt_shd.g_old_rec.ctt_attribute29

Line 482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26

478: ,p_ctt_attribute22_o =>ben_ctt_shd.g_old_rec.ctt_attribute22
479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23
480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24
481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25
482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26
483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27
484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28
485: ,p_ctt_attribute29_o =>ben_ctt_shd.g_old_rec.ctt_attribute29
486: ,p_ctt_attribute30_o =>ben_ctt_shd.g_old_rec.ctt_attribute30

Line 483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27

479: ,p_ctt_attribute23_o =>ben_ctt_shd.g_old_rec.ctt_attribute23
480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24
481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25
482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26
483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27
484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28
485: ,p_ctt_attribute29_o =>ben_ctt_shd.g_old_rec.ctt_attribute29
486: ,p_ctt_attribute30_o =>ben_ctt_shd.g_old_rec.ctt_attribute30
487: ,p_object_version_number_o =>ben_ctt_shd.g_old_rec.object_version_number);

Line 484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28

480: ,p_ctt_attribute24_o =>ben_ctt_shd.g_old_rec.ctt_attribute24
481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25
482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26
483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27
484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28
485: ,p_ctt_attribute29_o =>ben_ctt_shd.g_old_rec.ctt_attribute29
486: ,p_ctt_attribute30_o =>ben_ctt_shd.g_old_rec.ctt_attribute30
487: ,p_object_version_number_o =>ben_ctt_shd.g_old_rec.object_version_number);
488: --

Line 485: ,p_ctt_attribute29_o =>ben_ctt_shd.g_old_rec.ctt_attribute29

481: ,p_ctt_attribute25_o =>ben_ctt_shd.g_old_rec.ctt_attribute25
482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26
483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27
484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28
485: ,p_ctt_attribute29_o =>ben_ctt_shd.g_old_rec.ctt_attribute29
486: ,p_ctt_attribute30_o =>ben_ctt_shd.g_old_rec.ctt_attribute30
487: ,p_object_version_number_o =>ben_ctt_shd.g_old_rec.object_version_number);
488: --
489: exception

Line 486: ,p_ctt_attribute30_o =>ben_ctt_shd.g_old_rec.ctt_attribute30

482: ,p_ctt_attribute26_o =>ben_ctt_shd.g_old_rec.ctt_attribute26
483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27
484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28
485: ,p_ctt_attribute29_o =>ben_ctt_shd.g_old_rec.ctt_attribute29
486: ,p_ctt_attribute30_o =>ben_ctt_shd.g_old_rec.ctt_attribute30
487: ,p_object_version_number_o =>ben_ctt_shd.g_old_rec.object_version_number);
488: --
489: exception
490: --

Line 487: ,p_object_version_number_o =>ben_ctt_shd.g_old_rec.object_version_number);

483: ,p_ctt_attribute27_o =>ben_ctt_shd.g_old_rec.ctt_attribute27
484: ,p_ctt_attribute28_o =>ben_ctt_shd.g_old_rec.ctt_attribute28
485: ,p_ctt_attribute29_o =>ben_ctt_shd.g_old_rec.ctt_attribute29
486: ,p_ctt_attribute30_o =>ben_ctt_shd.g_old_rec.ctt_attribute30
487: ,p_object_version_number_o =>ben_ctt_shd.g_old_rec.object_version_number);
488: --
489: exception
490: --
491: when hr_api.cannot_find_prog_unit then

Line 548: Procedure convert_defs(p_rec in out nocopy ben_ctt_shd.g_rec_type) is

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

Line 563: ben_ctt_shd.g_old_rec.cm_typ_trgr_rl;

559: -- is being used then we must set to the 'current' argument value.
560: --
561: If (p_rec.cm_typ_trgr_rl = hr_api.g_number) then
562: p_rec.cm_typ_trgr_rl :=
563: ben_ctt_shd.g_old_rec.cm_typ_trgr_rl;
564: End If;
565: If (p_rec.cm_trgr_id = hr_api.g_number) then
566: p_rec.cm_trgr_id :=
567: ben_ctt_shd.g_old_rec.cm_trgr_id;

Line 567: ben_ctt_shd.g_old_rec.cm_trgr_id;

563: ben_ctt_shd.g_old_rec.cm_typ_trgr_rl;
564: End If;
565: If (p_rec.cm_trgr_id = hr_api.g_number) then
566: p_rec.cm_trgr_id :=
567: ben_ctt_shd.g_old_rec.cm_trgr_id;
568: End If;
569: If (p_rec.cm_typ_id = hr_api.g_number) then
570: p_rec.cm_typ_id :=
571: ben_ctt_shd.g_old_rec.cm_typ_id;

Line 571: ben_ctt_shd.g_old_rec.cm_typ_id;

567: ben_ctt_shd.g_old_rec.cm_trgr_id;
568: End If;
569: If (p_rec.cm_typ_id = hr_api.g_number) then
570: p_rec.cm_typ_id :=
571: ben_ctt_shd.g_old_rec.cm_typ_id;
572: End If;
573: If (p_rec.business_group_id = hr_api.g_number) then
574: p_rec.business_group_id :=
575: ben_ctt_shd.g_old_rec.business_group_id;

Line 575: ben_ctt_shd.g_old_rec.business_group_id;

571: ben_ctt_shd.g_old_rec.cm_typ_id;
572: End If;
573: If (p_rec.business_group_id = hr_api.g_number) then
574: p_rec.business_group_id :=
575: ben_ctt_shd.g_old_rec.business_group_id;
576: End If;
577: If (p_rec.ctt_attribute_category = hr_api.g_varchar2) then
578: p_rec.ctt_attribute_category :=
579: ben_ctt_shd.g_old_rec.ctt_attribute_category;

Line 579: ben_ctt_shd.g_old_rec.ctt_attribute_category;

575: ben_ctt_shd.g_old_rec.business_group_id;
576: End If;
577: If (p_rec.ctt_attribute_category = hr_api.g_varchar2) then
578: p_rec.ctt_attribute_category :=
579: ben_ctt_shd.g_old_rec.ctt_attribute_category;
580: End If;
581: If (p_rec.ctt_attribute1 = hr_api.g_varchar2) then
582: p_rec.ctt_attribute1 :=
583: ben_ctt_shd.g_old_rec.ctt_attribute1;

Line 583: ben_ctt_shd.g_old_rec.ctt_attribute1;

579: ben_ctt_shd.g_old_rec.ctt_attribute_category;
580: End If;
581: If (p_rec.ctt_attribute1 = hr_api.g_varchar2) then
582: p_rec.ctt_attribute1 :=
583: ben_ctt_shd.g_old_rec.ctt_attribute1;
584: End If;
585: If (p_rec.ctt_attribute2 = hr_api.g_varchar2) then
586: p_rec.ctt_attribute2 :=
587: ben_ctt_shd.g_old_rec.ctt_attribute2;

Line 587: ben_ctt_shd.g_old_rec.ctt_attribute2;

583: ben_ctt_shd.g_old_rec.ctt_attribute1;
584: End If;
585: If (p_rec.ctt_attribute2 = hr_api.g_varchar2) then
586: p_rec.ctt_attribute2 :=
587: ben_ctt_shd.g_old_rec.ctt_attribute2;
588: End If;
589: If (p_rec.ctt_attribute3 = hr_api.g_varchar2) then
590: p_rec.ctt_attribute3 :=
591: ben_ctt_shd.g_old_rec.ctt_attribute3;

Line 591: ben_ctt_shd.g_old_rec.ctt_attribute3;

587: ben_ctt_shd.g_old_rec.ctt_attribute2;
588: End If;
589: If (p_rec.ctt_attribute3 = hr_api.g_varchar2) then
590: p_rec.ctt_attribute3 :=
591: ben_ctt_shd.g_old_rec.ctt_attribute3;
592: End If;
593: If (p_rec.ctt_attribute4 = hr_api.g_varchar2) then
594: p_rec.ctt_attribute4 :=
595: ben_ctt_shd.g_old_rec.ctt_attribute4;

Line 595: ben_ctt_shd.g_old_rec.ctt_attribute4;

591: ben_ctt_shd.g_old_rec.ctt_attribute3;
592: End If;
593: If (p_rec.ctt_attribute4 = hr_api.g_varchar2) then
594: p_rec.ctt_attribute4 :=
595: ben_ctt_shd.g_old_rec.ctt_attribute4;
596: End If;
597: If (p_rec.ctt_attribute5 = hr_api.g_varchar2) then
598: p_rec.ctt_attribute5 :=
599: ben_ctt_shd.g_old_rec.ctt_attribute5;

Line 599: ben_ctt_shd.g_old_rec.ctt_attribute5;

595: ben_ctt_shd.g_old_rec.ctt_attribute4;
596: End If;
597: If (p_rec.ctt_attribute5 = hr_api.g_varchar2) then
598: p_rec.ctt_attribute5 :=
599: ben_ctt_shd.g_old_rec.ctt_attribute5;
600: End If;
601: If (p_rec.ctt_attribute6 = hr_api.g_varchar2) then
602: p_rec.ctt_attribute6 :=
603: ben_ctt_shd.g_old_rec.ctt_attribute6;

Line 603: ben_ctt_shd.g_old_rec.ctt_attribute6;

599: ben_ctt_shd.g_old_rec.ctt_attribute5;
600: End If;
601: If (p_rec.ctt_attribute6 = hr_api.g_varchar2) then
602: p_rec.ctt_attribute6 :=
603: ben_ctt_shd.g_old_rec.ctt_attribute6;
604: End If;
605: If (p_rec.ctt_attribute7 = hr_api.g_varchar2) then
606: p_rec.ctt_attribute7 :=
607: ben_ctt_shd.g_old_rec.ctt_attribute7;

Line 607: ben_ctt_shd.g_old_rec.ctt_attribute7;

603: ben_ctt_shd.g_old_rec.ctt_attribute6;
604: End If;
605: If (p_rec.ctt_attribute7 = hr_api.g_varchar2) then
606: p_rec.ctt_attribute7 :=
607: ben_ctt_shd.g_old_rec.ctt_attribute7;
608: End If;
609: If (p_rec.ctt_attribute8 = hr_api.g_varchar2) then
610: p_rec.ctt_attribute8 :=
611: ben_ctt_shd.g_old_rec.ctt_attribute8;

Line 611: ben_ctt_shd.g_old_rec.ctt_attribute8;

607: ben_ctt_shd.g_old_rec.ctt_attribute7;
608: End If;
609: If (p_rec.ctt_attribute8 = hr_api.g_varchar2) then
610: p_rec.ctt_attribute8 :=
611: ben_ctt_shd.g_old_rec.ctt_attribute8;
612: End If;
613: If (p_rec.ctt_attribute9 = hr_api.g_varchar2) then
614: p_rec.ctt_attribute9 :=
615: ben_ctt_shd.g_old_rec.ctt_attribute9;

Line 615: ben_ctt_shd.g_old_rec.ctt_attribute9;

611: ben_ctt_shd.g_old_rec.ctt_attribute8;
612: End If;
613: If (p_rec.ctt_attribute9 = hr_api.g_varchar2) then
614: p_rec.ctt_attribute9 :=
615: ben_ctt_shd.g_old_rec.ctt_attribute9;
616: End If;
617: If (p_rec.ctt_attribute10 = hr_api.g_varchar2) then
618: p_rec.ctt_attribute10 :=
619: ben_ctt_shd.g_old_rec.ctt_attribute10;

Line 619: ben_ctt_shd.g_old_rec.ctt_attribute10;

615: ben_ctt_shd.g_old_rec.ctt_attribute9;
616: End If;
617: If (p_rec.ctt_attribute10 = hr_api.g_varchar2) then
618: p_rec.ctt_attribute10 :=
619: ben_ctt_shd.g_old_rec.ctt_attribute10;
620: End If;
621: If (p_rec.ctt_attribute11 = hr_api.g_varchar2) then
622: p_rec.ctt_attribute11 :=
623: ben_ctt_shd.g_old_rec.ctt_attribute11;

Line 623: ben_ctt_shd.g_old_rec.ctt_attribute11;

619: ben_ctt_shd.g_old_rec.ctt_attribute10;
620: End If;
621: If (p_rec.ctt_attribute11 = hr_api.g_varchar2) then
622: p_rec.ctt_attribute11 :=
623: ben_ctt_shd.g_old_rec.ctt_attribute11;
624: End If;
625: If (p_rec.ctt_attribute12 = hr_api.g_varchar2) then
626: p_rec.ctt_attribute12 :=
627: ben_ctt_shd.g_old_rec.ctt_attribute12;

Line 627: ben_ctt_shd.g_old_rec.ctt_attribute12;

623: ben_ctt_shd.g_old_rec.ctt_attribute11;
624: End If;
625: If (p_rec.ctt_attribute12 = hr_api.g_varchar2) then
626: p_rec.ctt_attribute12 :=
627: ben_ctt_shd.g_old_rec.ctt_attribute12;
628: End If;
629: If (p_rec.ctt_attribute13 = hr_api.g_varchar2) then
630: p_rec.ctt_attribute13 :=
631: ben_ctt_shd.g_old_rec.ctt_attribute13;

Line 631: ben_ctt_shd.g_old_rec.ctt_attribute13;

627: ben_ctt_shd.g_old_rec.ctt_attribute12;
628: End If;
629: If (p_rec.ctt_attribute13 = hr_api.g_varchar2) then
630: p_rec.ctt_attribute13 :=
631: ben_ctt_shd.g_old_rec.ctt_attribute13;
632: End If;
633: If (p_rec.ctt_attribute14 = hr_api.g_varchar2) then
634: p_rec.ctt_attribute14 :=
635: ben_ctt_shd.g_old_rec.ctt_attribute14;

Line 635: ben_ctt_shd.g_old_rec.ctt_attribute14;

631: ben_ctt_shd.g_old_rec.ctt_attribute13;
632: End If;
633: If (p_rec.ctt_attribute14 = hr_api.g_varchar2) then
634: p_rec.ctt_attribute14 :=
635: ben_ctt_shd.g_old_rec.ctt_attribute14;
636: End If;
637: If (p_rec.ctt_attribute15 = hr_api.g_varchar2) then
638: p_rec.ctt_attribute15 :=
639: ben_ctt_shd.g_old_rec.ctt_attribute15;

Line 639: ben_ctt_shd.g_old_rec.ctt_attribute15;

635: ben_ctt_shd.g_old_rec.ctt_attribute14;
636: End If;
637: If (p_rec.ctt_attribute15 = hr_api.g_varchar2) then
638: p_rec.ctt_attribute15 :=
639: ben_ctt_shd.g_old_rec.ctt_attribute15;
640: End If;
641: If (p_rec.ctt_attribute16 = hr_api.g_varchar2) then
642: p_rec.ctt_attribute16 :=
643: ben_ctt_shd.g_old_rec.ctt_attribute16;

Line 643: ben_ctt_shd.g_old_rec.ctt_attribute16;

639: ben_ctt_shd.g_old_rec.ctt_attribute15;
640: End If;
641: If (p_rec.ctt_attribute16 = hr_api.g_varchar2) then
642: p_rec.ctt_attribute16 :=
643: ben_ctt_shd.g_old_rec.ctt_attribute16;
644: End If;
645: If (p_rec.ctt_attribute17 = hr_api.g_varchar2) then
646: p_rec.ctt_attribute17 :=
647: ben_ctt_shd.g_old_rec.ctt_attribute17;

Line 647: ben_ctt_shd.g_old_rec.ctt_attribute17;

643: ben_ctt_shd.g_old_rec.ctt_attribute16;
644: End If;
645: If (p_rec.ctt_attribute17 = hr_api.g_varchar2) then
646: p_rec.ctt_attribute17 :=
647: ben_ctt_shd.g_old_rec.ctt_attribute17;
648: End If;
649: If (p_rec.ctt_attribute18 = hr_api.g_varchar2) then
650: p_rec.ctt_attribute18 :=
651: ben_ctt_shd.g_old_rec.ctt_attribute18;

Line 651: ben_ctt_shd.g_old_rec.ctt_attribute18;

647: ben_ctt_shd.g_old_rec.ctt_attribute17;
648: End If;
649: If (p_rec.ctt_attribute18 = hr_api.g_varchar2) then
650: p_rec.ctt_attribute18 :=
651: ben_ctt_shd.g_old_rec.ctt_attribute18;
652: End If;
653: If (p_rec.ctt_attribute19 = hr_api.g_varchar2) then
654: p_rec.ctt_attribute19 :=
655: ben_ctt_shd.g_old_rec.ctt_attribute19;

Line 655: ben_ctt_shd.g_old_rec.ctt_attribute19;

651: ben_ctt_shd.g_old_rec.ctt_attribute18;
652: End If;
653: If (p_rec.ctt_attribute19 = hr_api.g_varchar2) then
654: p_rec.ctt_attribute19 :=
655: ben_ctt_shd.g_old_rec.ctt_attribute19;
656: End If;
657: If (p_rec.ctt_attribute20 = hr_api.g_varchar2) then
658: p_rec.ctt_attribute20 :=
659: ben_ctt_shd.g_old_rec.ctt_attribute20;

Line 659: ben_ctt_shd.g_old_rec.ctt_attribute20;

655: ben_ctt_shd.g_old_rec.ctt_attribute19;
656: End If;
657: If (p_rec.ctt_attribute20 = hr_api.g_varchar2) then
658: p_rec.ctt_attribute20 :=
659: ben_ctt_shd.g_old_rec.ctt_attribute20;
660: End If;
661: If (p_rec.ctt_attribute21 = hr_api.g_varchar2) then
662: p_rec.ctt_attribute21 :=
663: ben_ctt_shd.g_old_rec.ctt_attribute21;

Line 663: ben_ctt_shd.g_old_rec.ctt_attribute21;

659: ben_ctt_shd.g_old_rec.ctt_attribute20;
660: End If;
661: If (p_rec.ctt_attribute21 = hr_api.g_varchar2) then
662: p_rec.ctt_attribute21 :=
663: ben_ctt_shd.g_old_rec.ctt_attribute21;
664: End If;
665: If (p_rec.ctt_attribute22 = hr_api.g_varchar2) then
666: p_rec.ctt_attribute22 :=
667: ben_ctt_shd.g_old_rec.ctt_attribute22;

Line 667: ben_ctt_shd.g_old_rec.ctt_attribute22;

663: ben_ctt_shd.g_old_rec.ctt_attribute21;
664: End If;
665: If (p_rec.ctt_attribute22 = hr_api.g_varchar2) then
666: p_rec.ctt_attribute22 :=
667: ben_ctt_shd.g_old_rec.ctt_attribute22;
668: End If;
669: If (p_rec.ctt_attribute23 = hr_api.g_varchar2) then
670: p_rec.ctt_attribute23 :=
671: ben_ctt_shd.g_old_rec.ctt_attribute23;

Line 671: ben_ctt_shd.g_old_rec.ctt_attribute23;

667: ben_ctt_shd.g_old_rec.ctt_attribute22;
668: End If;
669: If (p_rec.ctt_attribute23 = hr_api.g_varchar2) then
670: p_rec.ctt_attribute23 :=
671: ben_ctt_shd.g_old_rec.ctt_attribute23;
672: End If;
673: If (p_rec.ctt_attribute24 = hr_api.g_varchar2) then
674: p_rec.ctt_attribute24 :=
675: ben_ctt_shd.g_old_rec.ctt_attribute24;

Line 675: ben_ctt_shd.g_old_rec.ctt_attribute24;

671: ben_ctt_shd.g_old_rec.ctt_attribute23;
672: End If;
673: If (p_rec.ctt_attribute24 = hr_api.g_varchar2) then
674: p_rec.ctt_attribute24 :=
675: ben_ctt_shd.g_old_rec.ctt_attribute24;
676: End If;
677: If (p_rec.ctt_attribute25 = hr_api.g_varchar2) then
678: p_rec.ctt_attribute25 :=
679: ben_ctt_shd.g_old_rec.ctt_attribute25;

Line 679: ben_ctt_shd.g_old_rec.ctt_attribute25;

675: ben_ctt_shd.g_old_rec.ctt_attribute24;
676: End If;
677: If (p_rec.ctt_attribute25 = hr_api.g_varchar2) then
678: p_rec.ctt_attribute25 :=
679: ben_ctt_shd.g_old_rec.ctt_attribute25;
680: End If;
681: If (p_rec.ctt_attribute26 = hr_api.g_varchar2) then
682: p_rec.ctt_attribute26 :=
683: ben_ctt_shd.g_old_rec.ctt_attribute26;

Line 683: ben_ctt_shd.g_old_rec.ctt_attribute26;

679: ben_ctt_shd.g_old_rec.ctt_attribute25;
680: End If;
681: If (p_rec.ctt_attribute26 = hr_api.g_varchar2) then
682: p_rec.ctt_attribute26 :=
683: ben_ctt_shd.g_old_rec.ctt_attribute26;
684: End If;
685: If (p_rec.ctt_attribute27 = hr_api.g_varchar2) then
686: p_rec.ctt_attribute27 :=
687: ben_ctt_shd.g_old_rec.ctt_attribute27;

Line 687: ben_ctt_shd.g_old_rec.ctt_attribute27;

683: ben_ctt_shd.g_old_rec.ctt_attribute26;
684: End If;
685: If (p_rec.ctt_attribute27 = hr_api.g_varchar2) then
686: p_rec.ctt_attribute27 :=
687: ben_ctt_shd.g_old_rec.ctt_attribute27;
688: End If;
689: If (p_rec.ctt_attribute28 = hr_api.g_varchar2) then
690: p_rec.ctt_attribute28 :=
691: ben_ctt_shd.g_old_rec.ctt_attribute28;

Line 691: ben_ctt_shd.g_old_rec.ctt_attribute28;

687: ben_ctt_shd.g_old_rec.ctt_attribute27;
688: End If;
689: If (p_rec.ctt_attribute28 = hr_api.g_varchar2) then
690: p_rec.ctt_attribute28 :=
691: ben_ctt_shd.g_old_rec.ctt_attribute28;
692: End If;
693: If (p_rec.ctt_attribute29 = hr_api.g_varchar2) then
694: p_rec.ctt_attribute29 :=
695: ben_ctt_shd.g_old_rec.ctt_attribute29;

Line 695: ben_ctt_shd.g_old_rec.ctt_attribute29;

691: ben_ctt_shd.g_old_rec.ctt_attribute28;
692: End If;
693: If (p_rec.ctt_attribute29 = hr_api.g_varchar2) then
694: p_rec.ctt_attribute29 :=
695: ben_ctt_shd.g_old_rec.ctt_attribute29;
696: End If;
697: If (p_rec.ctt_attribute30 = hr_api.g_varchar2) then
698: p_rec.ctt_attribute30 :=
699: ben_ctt_shd.g_old_rec.ctt_attribute30;

Line 699: ben_ctt_shd.g_old_rec.ctt_attribute30;

695: ben_ctt_shd.g_old_rec.ctt_attribute29;
696: End If;
697: If (p_rec.ctt_attribute30 = hr_api.g_varchar2) then
698: p_rec.ctt_attribute30 :=
699: ben_ctt_shd.g_old_rec.ctt_attribute30;
700: End If;
701:
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 712: p_rec in out nocopy ben_ctt_shd.g_rec_type,

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

Line 730: ben_ctt_shd.lck

726: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
727: --
728: -- We must lock the row which we need to update.
729: --
730: ben_ctt_shd.lck
731: (p_effective_date => p_effective_date,
732: p_datetrack_mode => p_datetrack_mode,
733: p_cm_typ_trgr_id => p_rec.cm_typ_trgr_id,
734: p_object_version_number => p_rec.object_version_number,

Line 828: l_rec ben_ctt_shd.g_rec_type;

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

Line 838: ben_ctt_shd.convert_args

834: -- Call conversion function to turn arguments into the
835: -- l_rec structure.
836: --
837: l_rec :=
838: ben_ctt_shd.convert_args
839: (
840: p_cm_typ_trgr_id,
841: null,
842: null,