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_PAT_UPD dependencies on BEN_PAT_SHD

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

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

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

Line 132: ben_pat_shd.g_api_dml := false; -- Unset the api dml status

128: where popl_actn_typ_id = p_rec.popl_actn_typ_id
129: and effective_start_date = p_validation_start_date
130: and effective_end_date = p_validation_end_date;
131: --
132: ben_pat_shd.g_api_dml := false; -- Unset the api dml status
133: --
134: -- Set the effective start and end dates
135: --
136: p_rec.effective_start_date := p_validation_start_date;

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

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

Line 145: ben_pat_shd.constraint_error

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

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

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

Line 150: ben_pat_shd.constraint_error

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

Line 153: ben_pat_shd.g_api_dml := false; -- Unset the api dml status

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

Line 189: (p_rec in out nocopy ben_pat_shd.g_rec_type,

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure update_dml
189: (p_rec in out nocopy ben_pat_shd.g_rec_type,
190: p_effective_date in date,
191: p_datetrack_mode in varchar2,
192: p_validation_start_date in date,
193: p_validation_end_date in date) is

Line 253: (p_rec in out nocopy ben_pat_shd.g_rec_type,

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_pre_update
253: (p_rec in out nocopy ben_pat_shd.g_rec_type,
254: p_effective_date in date,
255: p_datetrack_mode in varchar2,
256: p_validation_start_date in date,
257: p_validation_end_date in date) is

Line 269: ben_pat_shd.upd_effective_end_date

265: hr_utility.set_location(l_proc, 10);
266: --
267: -- Update the current effective end date
268: --
269: ben_pat_shd.upd_effective_end_date
270: (p_effective_date => p_effective_date,
271: p_base_key_value => p_rec.popl_actn_typ_id,
272: p_new_effective_end_date => (p_validation_start_date - 1),
273: p_validation_start_date => p_validation_start_date,

Line 338: (p_rec in out nocopy ben_pat_shd.g_rec_type,

334: --
335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure pre_update
338: (p_rec in out nocopy ben_pat_shd.g_rec_type,
339: p_effective_date in date,
340: p_datetrack_mode in varchar2,
341: p_validation_start_date in date,
342: p_validation_end_date in date) is

Line 394: (p_rec in ben_pat_shd.g_rec_type,

390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure post_update
394: (p_rec in ben_pat_shd.g_rec_type,
395: p_effective_date in date,
396: p_datetrack_mode in varchar2,
397: p_validation_start_date in date,
398: p_validation_end_date in date) is

Line 459: ,p_effective_start_date_o =>ben_pat_shd.g_old_rec.effective_start_date

455: ,p_effective_date =>p_effective_date
456: ,p_datetrack_mode =>p_datetrack_mode
457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pat_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pat_shd.g_old_rec.effective_end_date
461: ,p_actn_typ_due_dt_cd_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_cd
462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id

Line 460: ,p_effective_end_date_o =>ben_pat_shd.g_old_rec.effective_end_date

456: ,p_datetrack_mode =>p_datetrack_mode
457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pat_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pat_shd.g_old_rec.effective_end_date
461: ,p_actn_typ_due_dt_cd_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_cd
462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id
464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id

Line 461: ,p_actn_typ_due_dt_cd_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_cd

457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pat_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pat_shd.g_old_rec.effective_end_date
461: ,p_actn_typ_due_dt_cd_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_cd
462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id
464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id
465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id

Line 462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl

458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pat_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pat_shd.g_old_rec.effective_end_date
461: ,p_actn_typ_due_dt_cd_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_cd
462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id
464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id
465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id
466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id

Line 463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id

459: ,p_effective_start_date_o =>ben_pat_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pat_shd.g_old_rec.effective_end_date
461: ,p_actn_typ_due_dt_cd_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_cd
462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id
464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id
465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id
466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id
467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category

Line 464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id

460: ,p_effective_end_date_o =>ben_pat_shd.g_old_rec.effective_end_date
461: ,p_actn_typ_due_dt_cd_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_cd
462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id
464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id
465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id
466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id
467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category
468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1

Line 465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id

461: ,p_actn_typ_due_dt_cd_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_cd
462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id
464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id
465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id
466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id
467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category
468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1
469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2

Line 466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id

462: ,p_actn_typ_due_dt_rl_o =>ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id
464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id
465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id
466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id
467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category
468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1
469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2
470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3

Line 467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category

463: ,p_actn_typ_id_o =>ben_pat_shd.g_old_rec.actn_typ_id
464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id
465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id
466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id
467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category
468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1
469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2
470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3
471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4

Line 468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1

464: ,p_pgm_id_o =>ben_pat_shd.g_old_rec.pgm_id
465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id
466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id
467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category
468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1
469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2
470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3
471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4
472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5

Line 469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2

465: ,p_pl_id_o =>ben_pat_shd.g_old_rec.pl_id
466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id
467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category
468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1
469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2
470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3
471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4
472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5
473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6

Line 470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3

466: ,p_business_group_id_o =>ben_pat_shd.g_old_rec.business_group_id
467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category
468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1
469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2
470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3
471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4
472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5
473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6
474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7

Line 471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4

467: ,p_pat_attribute_category_o =>ben_pat_shd.g_old_rec.pat_attribute_category
468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1
469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2
470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3
471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4
472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5
473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6
474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7
475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8

Line 472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5

468: ,p_pat_attribute1_o =>ben_pat_shd.g_old_rec.pat_attribute1
469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2
470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3
471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4
472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5
473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6
474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7
475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8
476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9

Line 473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6

469: ,p_pat_attribute2_o =>ben_pat_shd.g_old_rec.pat_attribute2
470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3
471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4
472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5
473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6
474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7
475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8
476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9
477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10

Line 474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7

470: ,p_pat_attribute3_o =>ben_pat_shd.g_old_rec.pat_attribute3
471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4
472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5
473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6
474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7
475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8
476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9
477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10
478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11

Line 475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8

471: ,p_pat_attribute4_o =>ben_pat_shd.g_old_rec.pat_attribute4
472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5
473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6
474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7
475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8
476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9
477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10
478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11
479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12

Line 476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9

472: ,p_pat_attribute5_o =>ben_pat_shd.g_old_rec.pat_attribute5
473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6
474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7
475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8
476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9
477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10
478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11
479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12
480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13

Line 477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10

473: ,p_pat_attribute6_o =>ben_pat_shd.g_old_rec.pat_attribute6
474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7
475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8
476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9
477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10
478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11
479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12
480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13
481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14

Line 478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11

474: ,p_pat_attribute7_o =>ben_pat_shd.g_old_rec.pat_attribute7
475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8
476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9
477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10
478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11
479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12
480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13
481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14
482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15

Line 479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12

475: ,p_pat_attribute8_o =>ben_pat_shd.g_old_rec.pat_attribute8
476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9
477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10
478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11
479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12
480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13
481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14
482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15
483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16

Line 480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13

476: ,p_pat_attribute9_o =>ben_pat_shd.g_old_rec.pat_attribute9
477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10
478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11
479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12
480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13
481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14
482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15
483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16
484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17

Line 481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14

477: ,p_pat_attribute10_o =>ben_pat_shd.g_old_rec.pat_attribute10
478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11
479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12
480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13
481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14
482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15
483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16
484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17
485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18

Line 482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15

478: ,p_pat_attribute11_o =>ben_pat_shd.g_old_rec.pat_attribute11
479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12
480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13
481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14
482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15
483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16
484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17
485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18
486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19

Line 483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16

479: ,p_pat_attribute12_o =>ben_pat_shd.g_old_rec.pat_attribute12
480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13
481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14
482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15
483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16
484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17
485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18
486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19
487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20

Line 484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17

480: ,p_pat_attribute13_o =>ben_pat_shd.g_old_rec.pat_attribute13
481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14
482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15
483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16
484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17
485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18
486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19
487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20
488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21

Line 485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18

481: ,p_pat_attribute14_o =>ben_pat_shd.g_old_rec.pat_attribute14
482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15
483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16
484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17
485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18
486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19
487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20
488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21
489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22

Line 486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19

482: ,p_pat_attribute15_o =>ben_pat_shd.g_old_rec.pat_attribute15
483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16
484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17
485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18
486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19
487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20
488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21
489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22
490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23

Line 487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20

483: ,p_pat_attribute16_o =>ben_pat_shd.g_old_rec.pat_attribute16
484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17
485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18
486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19
487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20
488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21
489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22
490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23
491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24

Line 488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21

484: ,p_pat_attribute17_o =>ben_pat_shd.g_old_rec.pat_attribute17
485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18
486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19
487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20
488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21
489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22
490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23
491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24
492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25

Line 489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22

485: ,p_pat_attribute18_o =>ben_pat_shd.g_old_rec.pat_attribute18
486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19
487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20
488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21
489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22
490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23
491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24
492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25
493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26

Line 490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23

486: ,p_pat_attribute19_o =>ben_pat_shd.g_old_rec.pat_attribute19
487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20
488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21
489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22
490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23
491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24
492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25
493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26
494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27

Line 491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24

487: ,p_pat_attribute20_o =>ben_pat_shd.g_old_rec.pat_attribute20
488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21
489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22
490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23
491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24
492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25
493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26
494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27
495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28

Line 492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25

488: ,p_pat_attribute21_o =>ben_pat_shd.g_old_rec.pat_attribute21
489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22
490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23
491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24
492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25
493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26
494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27
495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28
496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29

Line 493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26

489: ,p_pat_attribute22_o =>ben_pat_shd.g_old_rec.pat_attribute22
490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23
491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24
492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25
493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26
494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27
495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28
496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29
497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30

Line 494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27

490: ,p_pat_attribute23_o =>ben_pat_shd.g_old_rec.pat_attribute23
491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24
492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25
493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26
494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27
495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28
496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29
497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30
498: ,p_object_version_number_o =>ben_pat_shd.g_old_rec.object_version_number

Line 495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28

491: ,p_pat_attribute24_o =>ben_pat_shd.g_old_rec.pat_attribute24
492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25
493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26
494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27
495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28
496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29
497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30
498: ,p_object_version_number_o =>ben_pat_shd.g_old_rec.object_version_number
499: ,p_mandatory_o =>ben_pat_shd.g_old_rec.mandatory

Line 496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29

492: ,p_pat_attribute25_o =>ben_pat_shd.g_old_rec.pat_attribute25
493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26
494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27
495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28
496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29
497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30
498: ,p_object_version_number_o =>ben_pat_shd.g_old_rec.object_version_number
499: ,p_mandatory_o =>ben_pat_shd.g_old_rec.mandatory
500: ,p_once_or_always_o =>ben_pat_shd.g_old_rec.once_or_always

Line 497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30

493: ,p_pat_attribute26_o =>ben_pat_shd.g_old_rec.pat_attribute26
494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27
495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28
496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29
497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30
498: ,p_object_version_number_o =>ben_pat_shd.g_old_rec.object_version_number
499: ,p_mandatory_o =>ben_pat_shd.g_old_rec.mandatory
500: ,p_once_or_always_o =>ben_pat_shd.g_old_rec.once_or_always
501:

Line 498: ,p_object_version_number_o =>ben_pat_shd.g_old_rec.object_version_number

494: ,p_pat_attribute27_o =>ben_pat_shd.g_old_rec.pat_attribute27
495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28
496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29
497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30
498: ,p_object_version_number_o =>ben_pat_shd.g_old_rec.object_version_number
499: ,p_mandatory_o =>ben_pat_shd.g_old_rec.mandatory
500: ,p_once_or_always_o =>ben_pat_shd.g_old_rec.once_or_always
501:
502: );

Line 499: ,p_mandatory_o =>ben_pat_shd.g_old_rec.mandatory

495: ,p_pat_attribute28_o =>ben_pat_shd.g_old_rec.pat_attribute28
496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29
497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30
498: ,p_object_version_number_o =>ben_pat_shd.g_old_rec.object_version_number
499: ,p_mandatory_o =>ben_pat_shd.g_old_rec.mandatory
500: ,p_once_or_always_o =>ben_pat_shd.g_old_rec.once_or_always
501:
502: );
503: --

Line 500: ,p_once_or_always_o =>ben_pat_shd.g_old_rec.once_or_always

496: ,p_pat_attribute29_o =>ben_pat_shd.g_old_rec.pat_attribute29
497: ,p_pat_attribute30_o =>ben_pat_shd.g_old_rec.pat_attribute30
498: ,p_object_version_number_o =>ben_pat_shd.g_old_rec.object_version_number
499: ,p_mandatory_o =>ben_pat_shd.g_old_rec.mandatory
500: ,p_once_or_always_o =>ben_pat_shd.g_old_rec.once_or_always
501:
502: );
503: --
504: exception

Line 563: Procedure convert_defs(p_rec in out nocopy ben_pat_shd.g_rec_type) is

559: -- Internal Row Handler Use Only.
560: --
561: -- {End Of Comments}
562: -- ----------------------------------------------------------------------------
563: Procedure convert_defs(p_rec in out nocopy ben_pat_shd.g_rec_type) is
564: --
565: l_proc varchar2(72) := g_package||'convert_defs';
566: --
567: Begin

Line 578: ben_pat_shd.g_old_rec.actn_typ_due_dt_cd;

574: -- is being used then we must set to the 'current' argument value.
575: --
576: If (p_rec.actn_typ_due_dt_cd = hr_api.g_varchar2) then
577: p_rec.actn_typ_due_dt_cd :=
578: ben_pat_shd.g_old_rec.actn_typ_due_dt_cd;
579: End If;
580: If (p_rec.actn_typ_due_dt_rl = hr_api.g_number) then
581: p_rec.actn_typ_due_dt_rl :=
582: ben_pat_shd.g_old_rec.actn_typ_due_dt_rl;

Line 582: ben_pat_shd.g_old_rec.actn_typ_due_dt_rl;

578: ben_pat_shd.g_old_rec.actn_typ_due_dt_cd;
579: End If;
580: If (p_rec.actn_typ_due_dt_rl = hr_api.g_number) then
581: p_rec.actn_typ_due_dt_rl :=
582: ben_pat_shd.g_old_rec.actn_typ_due_dt_rl;
583: End If;
584: If (p_rec.actn_typ_id = hr_api.g_number) then
585: p_rec.actn_typ_id :=
586: ben_pat_shd.g_old_rec.actn_typ_id;

Line 586: ben_pat_shd.g_old_rec.actn_typ_id;

582: ben_pat_shd.g_old_rec.actn_typ_due_dt_rl;
583: End If;
584: If (p_rec.actn_typ_id = hr_api.g_number) then
585: p_rec.actn_typ_id :=
586: ben_pat_shd.g_old_rec.actn_typ_id;
587: End If;
588: If (p_rec.pgm_id = hr_api.g_number) then
589: p_rec.pgm_id :=
590: ben_pat_shd.g_old_rec.pgm_id;

Line 590: ben_pat_shd.g_old_rec.pgm_id;

586: ben_pat_shd.g_old_rec.actn_typ_id;
587: End If;
588: If (p_rec.pgm_id = hr_api.g_number) then
589: p_rec.pgm_id :=
590: ben_pat_shd.g_old_rec.pgm_id;
591: End If;
592: If (p_rec.pl_id = hr_api.g_number) then
593: p_rec.pl_id :=
594: ben_pat_shd.g_old_rec.pl_id;

Line 594: ben_pat_shd.g_old_rec.pl_id;

590: ben_pat_shd.g_old_rec.pgm_id;
591: End If;
592: If (p_rec.pl_id = hr_api.g_number) then
593: p_rec.pl_id :=
594: ben_pat_shd.g_old_rec.pl_id;
595: End If;
596: If (p_rec.business_group_id = hr_api.g_number) then
597: p_rec.business_group_id :=
598: ben_pat_shd.g_old_rec.business_group_id;

Line 598: ben_pat_shd.g_old_rec.business_group_id;

594: ben_pat_shd.g_old_rec.pl_id;
595: End If;
596: If (p_rec.business_group_id = hr_api.g_number) then
597: p_rec.business_group_id :=
598: ben_pat_shd.g_old_rec.business_group_id;
599: End If;
600: If (p_rec.pat_attribute_category = hr_api.g_varchar2) then
601: p_rec.pat_attribute_category :=
602: ben_pat_shd.g_old_rec.pat_attribute_category;

Line 602: ben_pat_shd.g_old_rec.pat_attribute_category;

598: ben_pat_shd.g_old_rec.business_group_id;
599: End If;
600: If (p_rec.pat_attribute_category = hr_api.g_varchar2) then
601: p_rec.pat_attribute_category :=
602: ben_pat_shd.g_old_rec.pat_attribute_category;
603: End If;
604: If (p_rec.pat_attribute1 = hr_api.g_varchar2) then
605: p_rec.pat_attribute1 :=
606: ben_pat_shd.g_old_rec.pat_attribute1;

Line 606: ben_pat_shd.g_old_rec.pat_attribute1;

602: ben_pat_shd.g_old_rec.pat_attribute_category;
603: End If;
604: If (p_rec.pat_attribute1 = hr_api.g_varchar2) then
605: p_rec.pat_attribute1 :=
606: ben_pat_shd.g_old_rec.pat_attribute1;
607: End If;
608: If (p_rec.pat_attribute2 = hr_api.g_varchar2) then
609: p_rec.pat_attribute2 :=
610: ben_pat_shd.g_old_rec.pat_attribute2;

Line 610: ben_pat_shd.g_old_rec.pat_attribute2;

606: ben_pat_shd.g_old_rec.pat_attribute1;
607: End If;
608: If (p_rec.pat_attribute2 = hr_api.g_varchar2) then
609: p_rec.pat_attribute2 :=
610: ben_pat_shd.g_old_rec.pat_attribute2;
611: End If;
612: If (p_rec.pat_attribute3 = hr_api.g_varchar2) then
613: p_rec.pat_attribute3 :=
614: ben_pat_shd.g_old_rec.pat_attribute3;

Line 614: ben_pat_shd.g_old_rec.pat_attribute3;

610: ben_pat_shd.g_old_rec.pat_attribute2;
611: End If;
612: If (p_rec.pat_attribute3 = hr_api.g_varchar2) then
613: p_rec.pat_attribute3 :=
614: ben_pat_shd.g_old_rec.pat_attribute3;
615: End If;
616: If (p_rec.pat_attribute4 = hr_api.g_varchar2) then
617: p_rec.pat_attribute4 :=
618: ben_pat_shd.g_old_rec.pat_attribute4;

Line 618: ben_pat_shd.g_old_rec.pat_attribute4;

614: ben_pat_shd.g_old_rec.pat_attribute3;
615: End If;
616: If (p_rec.pat_attribute4 = hr_api.g_varchar2) then
617: p_rec.pat_attribute4 :=
618: ben_pat_shd.g_old_rec.pat_attribute4;
619: End If;
620: If (p_rec.pat_attribute5 = hr_api.g_varchar2) then
621: p_rec.pat_attribute5 :=
622: ben_pat_shd.g_old_rec.pat_attribute5;

Line 622: ben_pat_shd.g_old_rec.pat_attribute5;

618: ben_pat_shd.g_old_rec.pat_attribute4;
619: End If;
620: If (p_rec.pat_attribute5 = hr_api.g_varchar2) then
621: p_rec.pat_attribute5 :=
622: ben_pat_shd.g_old_rec.pat_attribute5;
623: End If;
624: If (p_rec.pat_attribute6 = hr_api.g_varchar2) then
625: p_rec.pat_attribute6 :=
626: ben_pat_shd.g_old_rec.pat_attribute6;

Line 626: ben_pat_shd.g_old_rec.pat_attribute6;

622: ben_pat_shd.g_old_rec.pat_attribute5;
623: End If;
624: If (p_rec.pat_attribute6 = hr_api.g_varchar2) then
625: p_rec.pat_attribute6 :=
626: ben_pat_shd.g_old_rec.pat_attribute6;
627: End If;
628: If (p_rec.pat_attribute7 = hr_api.g_varchar2) then
629: p_rec.pat_attribute7 :=
630: ben_pat_shd.g_old_rec.pat_attribute7;

Line 630: ben_pat_shd.g_old_rec.pat_attribute7;

626: ben_pat_shd.g_old_rec.pat_attribute6;
627: End If;
628: If (p_rec.pat_attribute7 = hr_api.g_varchar2) then
629: p_rec.pat_attribute7 :=
630: ben_pat_shd.g_old_rec.pat_attribute7;
631: End If;
632: If (p_rec.pat_attribute8 = hr_api.g_varchar2) then
633: p_rec.pat_attribute8 :=
634: ben_pat_shd.g_old_rec.pat_attribute8;

Line 634: ben_pat_shd.g_old_rec.pat_attribute8;

630: ben_pat_shd.g_old_rec.pat_attribute7;
631: End If;
632: If (p_rec.pat_attribute8 = hr_api.g_varchar2) then
633: p_rec.pat_attribute8 :=
634: ben_pat_shd.g_old_rec.pat_attribute8;
635: End If;
636: If (p_rec.pat_attribute9 = hr_api.g_varchar2) then
637: p_rec.pat_attribute9 :=
638: ben_pat_shd.g_old_rec.pat_attribute9;

Line 638: ben_pat_shd.g_old_rec.pat_attribute9;

634: ben_pat_shd.g_old_rec.pat_attribute8;
635: End If;
636: If (p_rec.pat_attribute9 = hr_api.g_varchar2) then
637: p_rec.pat_attribute9 :=
638: ben_pat_shd.g_old_rec.pat_attribute9;
639: End If;
640: If (p_rec.pat_attribute10 = hr_api.g_varchar2) then
641: p_rec.pat_attribute10 :=
642: ben_pat_shd.g_old_rec.pat_attribute10;

Line 642: ben_pat_shd.g_old_rec.pat_attribute10;

638: ben_pat_shd.g_old_rec.pat_attribute9;
639: End If;
640: If (p_rec.pat_attribute10 = hr_api.g_varchar2) then
641: p_rec.pat_attribute10 :=
642: ben_pat_shd.g_old_rec.pat_attribute10;
643: End If;
644: If (p_rec.pat_attribute11 = hr_api.g_varchar2) then
645: p_rec.pat_attribute11 :=
646: ben_pat_shd.g_old_rec.pat_attribute11;

Line 646: ben_pat_shd.g_old_rec.pat_attribute11;

642: ben_pat_shd.g_old_rec.pat_attribute10;
643: End If;
644: If (p_rec.pat_attribute11 = hr_api.g_varchar2) then
645: p_rec.pat_attribute11 :=
646: ben_pat_shd.g_old_rec.pat_attribute11;
647: End If;
648: If (p_rec.pat_attribute12 = hr_api.g_varchar2) then
649: p_rec.pat_attribute12 :=
650: ben_pat_shd.g_old_rec.pat_attribute12;

Line 650: ben_pat_shd.g_old_rec.pat_attribute12;

646: ben_pat_shd.g_old_rec.pat_attribute11;
647: End If;
648: If (p_rec.pat_attribute12 = hr_api.g_varchar2) then
649: p_rec.pat_attribute12 :=
650: ben_pat_shd.g_old_rec.pat_attribute12;
651: End If;
652: If (p_rec.pat_attribute13 = hr_api.g_varchar2) then
653: p_rec.pat_attribute13 :=
654: ben_pat_shd.g_old_rec.pat_attribute13;

Line 654: ben_pat_shd.g_old_rec.pat_attribute13;

650: ben_pat_shd.g_old_rec.pat_attribute12;
651: End If;
652: If (p_rec.pat_attribute13 = hr_api.g_varchar2) then
653: p_rec.pat_attribute13 :=
654: ben_pat_shd.g_old_rec.pat_attribute13;
655: End If;
656: If (p_rec.pat_attribute14 = hr_api.g_varchar2) then
657: p_rec.pat_attribute14 :=
658: ben_pat_shd.g_old_rec.pat_attribute14;

Line 658: ben_pat_shd.g_old_rec.pat_attribute14;

654: ben_pat_shd.g_old_rec.pat_attribute13;
655: End If;
656: If (p_rec.pat_attribute14 = hr_api.g_varchar2) then
657: p_rec.pat_attribute14 :=
658: ben_pat_shd.g_old_rec.pat_attribute14;
659: End If;
660: If (p_rec.pat_attribute15 = hr_api.g_varchar2) then
661: p_rec.pat_attribute15 :=
662: ben_pat_shd.g_old_rec.pat_attribute15;

Line 662: ben_pat_shd.g_old_rec.pat_attribute15;

658: ben_pat_shd.g_old_rec.pat_attribute14;
659: End If;
660: If (p_rec.pat_attribute15 = hr_api.g_varchar2) then
661: p_rec.pat_attribute15 :=
662: ben_pat_shd.g_old_rec.pat_attribute15;
663: End If;
664: If (p_rec.pat_attribute16 = hr_api.g_varchar2) then
665: p_rec.pat_attribute16 :=
666: ben_pat_shd.g_old_rec.pat_attribute16;

Line 666: ben_pat_shd.g_old_rec.pat_attribute16;

662: ben_pat_shd.g_old_rec.pat_attribute15;
663: End If;
664: If (p_rec.pat_attribute16 = hr_api.g_varchar2) then
665: p_rec.pat_attribute16 :=
666: ben_pat_shd.g_old_rec.pat_attribute16;
667: End If;
668: If (p_rec.pat_attribute17 = hr_api.g_varchar2) then
669: p_rec.pat_attribute17 :=
670: ben_pat_shd.g_old_rec.pat_attribute17;

Line 670: ben_pat_shd.g_old_rec.pat_attribute17;

666: ben_pat_shd.g_old_rec.pat_attribute16;
667: End If;
668: If (p_rec.pat_attribute17 = hr_api.g_varchar2) then
669: p_rec.pat_attribute17 :=
670: ben_pat_shd.g_old_rec.pat_attribute17;
671: End If;
672: If (p_rec.pat_attribute18 = hr_api.g_varchar2) then
673: p_rec.pat_attribute18 :=
674: ben_pat_shd.g_old_rec.pat_attribute18;

Line 674: ben_pat_shd.g_old_rec.pat_attribute18;

670: ben_pat_shd.g_old_rec.pat_attribute17;
671: End If;
672: If (p_rec.pat_attribute18 = hr_api.g_varchar2) then
673: p_rec.pat_attribute18 :=
674: ben_pat_shd.g_old_rec.pat_attribute18;
675: End If;
676: If (p_rec.pat_attribute19 = hr_api.g_varchar2) then
677: p_rec.pat_attribute19 :=
678: ben_pat_shd.g_old_rec.pat_attribute19;

Line 678: ben_pat_shd.g_old_rec.pat_attribute19;

674: ben_pat_shd.g_old_rec.pat_attribute18;
675: End If;
676: If (p_rec.pat_attribute19 = hr_api.g_varchar2) then
677: p_rec.pat_attribute19 :=
678: ben_pat_shd.g_old_rec.pat_attribute19;
679: End If;
680: If (p_rec.pat_attribute20 = hr_api.g_varchar2) then
681: p_rec.pat_attribute20 :=
682: ben_pat_shd.g_old_rec.pat_attribute20;

Line 682: ben_pat_shd.g_old_rec.pat_attribute20;

678: ben_pat_shd.g_old_rec.pat_attribute19;
679: End If;
680: If (p_rec.pat_attribute20 = hr_api.g_varchar2) then
681: p_rec.pat_attribute20 :=
682: ben_pat_shd.g_old_rec.pat_attribute20;
683: End If;
684: If (p_rec.pat_attribute21 = hr_api.g_varchar2) then
685: p_rec.pat_attribute21 :=
686: ben_pat_shd.g_old_rec.pat_attribute21;

Line 686: ben_pat_shd.g_old_rec.pat_attribute21;

682: ben_pat_shd.g_old_rec.pat_attribute20;
683: End If;
684: If (p_rec.pat_attribute21 = hr_api.g_varchar2) then
685: p_rec.pat_attribute21 :=
686: ben_pat_shd.g_old_rec.pat_attribute21;
687: End If;
688: If (p_rec.pat_attribute22 = hr_api.g_varchar2) then
689: p_rec.pat_attribute22 :=
690: ben_pat_shd.g_old_rec.pat_attribute22;

Line 690: ben_pat_shd.g_old_rec.pat_attribute22;

686: ben_pat_shd.g_old_rec.pat_attribute21;
687: End If;
688: If (p_rec.pat_attribute22 = hr_api.g_varchar2) then
689: p_rec.pat_attribute22 :=
690: ben_pat_shd.g_old_rec.pat_attribute22;
691: End If;
692: If (p_rec.pat_attribute23 = hr_api.g_varchar2) then
693: p_rec.pat_attribute23 :=
694: ben_pat_shd.g_old_rec.pat_attribute23;

Line 694: ben_pat_shd.g_old_rec.pat_attribute23;

690: ben_pat_shd.g_old_rec.pat_attribute22;
691: End If;
692: If (p_rec.pat_attribute23 = hr_api.g_varchar2) then
693: p_rec.pat_attribute23 :=
694: ben_pat_shd.g_old_rec.pat_attribute23;
695: End If;
696: If (p_rec.pat_attribute24 = hr_api.g_varchar2) then
697: p_rec.pat_attribute24 :=
698: ben_pat_shd.g_old_rec.pat_attribute24;

Line 698: ben_pat_shd.g_old_rec.pat_attribute24;

694: ben_pat_shd.g_old_rec.pat_attribute23;
695: End If;
696: If (p_rec.pat_attribute24 = hr_api.g_varchar2) then
697: p_rec.pat_attribute24 :=
698: ben_pat_shd.g_old_rec.pat_attribute24;
699: End If;
700: If (p_rec.pat_attribute25 = hr_api.g_varchar2) then
701: p_rec.pat_attribute25 :=
702: ben_pat_shd.g_old_rec.pat_attribute25;

Line 702: ben_pat_shd.g_old_rec.pat_attribute25;

698: ben_pat_shd.g_old_rec.pat_attribute24;
699: End If;
700: If (p_rec.pat_attribute25 = hr_api.g_varchar2) then
701: p_rec.pat_attribute25 :=
702: ben_pat_shd.g_old_rec.pat_attribute25;
703: End If;
704: If (p_rec.pat_attribute26 = hr_api.g_varchar2) then
705: p_rec.pat_attribute26 :=
706: ben_pat_shd.g_old_rec.pat_attribute26;

Line 706: ben_pat_shd.g_old_rec.pat_attribute26;

702: ben_pat_shd.g_old_rec.pat_attribute25;
703: End If;
704: If (p_rec.pat_attribute26 = hr_api.g_varchar2) then
705: p_rec.pat_attribute26 :=
706: ben_pat_shd.g_old_rec.pat_attribute26;
707: End If;
708: If (p_rec.pat_attribute27 = hr_api.g_varchar2) then
709: p_rec.pat_attribute27 :=
710: ben_pat_shd.g_old_rec.pat_attribute27;

Line 710: ben_pat_shd.g_old_rec.pat_attribute27;

706: ben_pat_shd.g_old_rec.pat_attribute26;
707: End If;
708: If (p_rec.pat_attribute27 = hr_api.g_varchar2) then
709: p_rec.pat_attribute27 :=
710: ben_pat_shd.g_old_rec.pat_attribute27;
711: End If;
712: If (p_rec.pat_attribute28 = hr_api.g_varchar2) then
713: p_rec.pat_attribute28 :=
714: ben_pat_shd.g_old_rec.pat_attribute28;

Line 714: ben_pat_shd.g_old_rec.pat_attribute28;

710: ben_pat_shd.g_old_rec.pat_attribute27;
711: End If;
712: If (p_rec.pat_attribute28 = hr_api.g_varchar2) then
713: p_rec.pat_attribute28 :=
714: ben_pat_shd.g_old_rec.pat_attribute28;
715: End If;
716: If (p_rec.pat_attribute29 = hr_api.g_varchar2) then
717: p_rec.pat_attribute29 :=
718: ben_pat_shd.g_old_rec.pat_attribute29;

Line 718: ben_pat_shd.g_old_rec.pat_attribute29;

714: ben_pat_shd.g_old_rec.pat_attribute28;
715: End If;
716: If (p_rec.pat_attribute29 = hr_api.g_varchar2) then
717: p_rec.pat_attribute29 :=
718: ben_pat_shd.g_old_rec.pat_attribute29;
719: End If;
720: If (p_rec.pat_attribute30 = hr_api.g_varchar2) then
721: p_rec.pat_attribute30 :=
722: ben_pat_shd.g_old_rec.pat_attribute30;

Line 722: ben_pat_shd.g_old_rec.pat_attribute30;

718: ben_pat_shd.g_old_rec.pat_attribute29;
719: End If;
720: If (p_rec.pat_attribute30 = hr_api.g_varchar2) then
721: p_rec.pat_attribute30 :=
722: ben_pat_shd.g_old_rec.pat_attribute30;
723: End If;
724:
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 735: p_rec in out nocopy ben_pat_shd.g_rec_type,

731: -- |---------------------------------< upd >----------------------------------|
732: -- ----------------------------------------------------------------------------
733: Procedure upd
734: (
735: p_rec in out nocopy ben_pat_shd.g_rec_type,
736: p_effective_date in date,
737: p_datetrack_mode in varchar2
738: ) is
739: --

Line 753: ben_pat_shd.lck

749: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
750: --
751: -- We must lock the row which we need to update.
752: --
753: ben_pat_shd.lck
754: (p_effective_date => p_effective_date,
755: p_datetrack_mode => p_datetrack_mode,
756: p_popl_actn_typ_id => p_rec.popl_actn_typ_id,
757: p_object_version_number => p_rec.object_version_number,

Line 855: l_rec ben_pat_shd.g_rec_type;

851: p_effective_date in date,
852: p_datetrack_mode in varchar2
853: ) is
854: --
855: l_rec ben_pat_shd.g_rec_type;
856: l_proc varchar2(72) := g_package||'upd';
857: --
858: Begin
859: hr_utility.set_location('Entering:'||l_proc, 5);

Line 865: ben_pat_shd.convert_args

861: -- Call conversion function to turn arguments into the
862: -- l_rec structure.
863: --
864: l_rec :=
865: ben_pat_shd.convert_args
866: (
867: p_popl_actn_typ_id,
868: null,
869: null,