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_PSL_UPD dependencies on BEN_PSL_SHD

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

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

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

Line 133: ben_psl_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 146: ben_psl_shd.constraint_error

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

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

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

Line 151: ben_psl_shd.constraint_error

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

Line 154: ben_psl_shd.g_api_dml := false; -- Unset the api dml status

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

Line 190: (p_rec in out nocopy ben_psl_shd.g_rec_type,

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

Line 254: (p_rec in out nocopy ben_psl_shd.g_rec_type,

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

Line 270: ben_psl_shd.upd_effective_end_date

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

Line 339: (p_rec in out nocopy ben_psl_shd.g_rec_type,

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

Line 395: (p_rec in ben_psl_shd.g_rec_type,

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

Line 461: ,p_effective_start_date_o =>ben_psl_shd.g_old_rec.effective_start_date

457: ,p_effective_date =>p_effective_date
458: ,p_datetrack_mode =>p_datetrack_mode
459: ,p_validation_start_date =>p_validation_start_date
460: ,p_validation_end_date =>p_validation_end_date
461: ,p_effective_start_date_o =>ben_psl_shd.g_old_rec.effective_start_date
462: ,p_effective_end_date_o =>ben_psl_shd.g_old_rec.effective_end_date
463: ,p_per_info_chg_cs_ler_rl_o =>ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl
464: ,p_name_o =>ben_psl_shd.g_old_rec.name
465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val

Line 462: ,p_effective_end_date_o =>ben_psl_shd.g_old_rec.effective_end_date

458: ,p_datetrack_mode =>p_datetrack_mode
459: ,p_validation_start_date =>p_validation_start_date
460: ,p_validation_end_date =>p_validation_end_date
461: ,p_effective_start_date_o =>ben_psl_shd.g_old_rec.effective_start_date
462: ,p_effective_end_date_o =>ben_psl_shd.g_old_rec.effective_end_date
463: ,p_per_info_chg_cs_ler_rl_o =>ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl
464: ,p_name_o =>ben_psl_shd.g_old_rec.name
465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val
466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val

Line 463: ,p_per_info_chg_cs_ler_rl_o =>ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl

459: ,p_validation_start_date =>p_validation_start_date
460: ,p_validation_end_date =>p_validation_end_date
461: ,p_effective_start_date_o =>ben_psl_shd.g_old_rec.effective_start_date
462: ,p_effective_end_date_o =>ben_psl_shd.g_old_rec.effective_end_date
463: ,p_per_info_chg_cs_ler_rl_o =>ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl
464: ,p_name_o =>ben_psl_shd.g_old_rec.name
465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val
466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val
467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt

Line 464: ,p_name_o =>ben_psl_shd.g_old_rec.name

460: ,p_validation_end_date =>p_validation_end_date
461: ,p_effective_start_date_o =>ben_psl_shd.g_old_rec.effective_start_date
462: ,p_effective_end_date_o =>ben_psl_shd.g_old_rec.effective_end_date
463: ,p_per_info_chg_cs_ler_rl_o =>ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl
464: ,p_name_o =>ben_psl_shd.g_old_rec.name
465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val
466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val
467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt
468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag

Line 465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val

461: ,p_effective_start_date_o =>ben_psl_shd.g_old_rec.effective_start_date
462: ,p_effective_end_date_o =>ben_psl_shd.g_old_rec.effective_end_date
463: ,p_per_info_chg_cs_ler_rl_o =>ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl
464: ,p_name_o =>ben_psl_shd.g_old_rec.name
465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val
466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val
467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt
468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag
469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column

Line 466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val

462: ,p_effective_end_date_o =>ben_psl_shd.g_old_rec.effective_end_date
463: ,p_per_info_chg_cs_ler_rl_o =>ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl
464: ,p_name_o =>ben_psl_shd.g_old_rec.name
465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val
466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val
467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt
468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag
469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column
470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table

Line 467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt

463: ,p_per_info_chg_cs_ler_rl_o =>ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl
464: ,p_name_o =>ben_psl_shd.g_old_rec.name
465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val
466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val
467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt
468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag
469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column
470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table
471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id

Line 468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag

464: ,p_name_o =>ben_psl_shd.g_old_rec.name
465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val
466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val
467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt
468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag
469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column
470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table
471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id
472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category

Line 469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column

465: ,p_old_val_o =>ben_psl_shd.g_old_rec.old_val
466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val
467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt
468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag
469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column
470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table
471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id
472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category
473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1

Line 470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table

466: ,p_new_val_o =>ben_psl_shd.g_old_rec.new_val
467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt
468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag
469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column
470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table
471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id
472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category
473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1
474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2

Line 471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id

467: ,p_whatif_lbl_txt_o =>ben_psl_shd.g_old_rec.whatif_lbl_txt
468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag
469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column
470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table
471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id
472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category
473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1
474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2
475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3

Line 472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category

468: ,p_rule_overrides_flag_o =>ben_psl_shd.g_old_rec.rule_overrides_flag
469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column
470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table
471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id
472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category
473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1
474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2
475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3
476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4

Line 473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1

469: ,p_source_column_o =>ben_psl_shd.g_old_rec.source_column
470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table
471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id
472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category
473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1
474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2
475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3
476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4
477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5

Line 474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2

470: ,p_source_table_o =>ben_psl_shd.g_old_rec.source_table
471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id
472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category
473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1
474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2
475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3
476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4
477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5
478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6

Line 475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3

471: ,p_business_group_id_o =>ben_psl_shd.g_old_rec.business_group_id
472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category
473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1
474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2
475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3
476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4
477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5
478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6
479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7

Line 476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4

472: ,p_psl_attribute_category_o =>ben_psl_shd.g_old_rec.psl_attribute_category
473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1
474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2
475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3
476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4
477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5
478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6
479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7
480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8

Line 477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5

473: ,p_psl_attribute1_o =>ben_psl_shd.g_old_rec.psl_attribute1
474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2
475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3
476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4
477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5
478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6
479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7
480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8
481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9

Line 478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6

474: ,p_psl_attribute2_o =>ben_psl_shd.g_old_rec.psl_attribute2
475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3
476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4
477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5
478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6
479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7
480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8
481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9
482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10

Line 479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7

475: ,p_psl_attribute3_o =>ben_psl_shd.g_old_rec.psl_attribute3
476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4
477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5
478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6
479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7
480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8
481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9
482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10
483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11

Line 480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8

476: ,p_psl_attribute4_o =>ben_psl_shd.g_old_rec.psl_attribute4
477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5
478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6
479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7
480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8
481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9
482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10
483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11
484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12

Line 481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9

477: ,p_psl_attribute5_o =>ben_psl_shd.g_old_rec.psl_attribute5
478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6
479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7
480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8
481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9
482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10
483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11
484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12
485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13

Line 482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10

478: ,p_psl_attribute6_o =>ben_psl_shd.g_old_rec.psl_attribute6
479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7
480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8
481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9
482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10
483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11
484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12
485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13
486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14

Line 483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11

479: ,p_psl_attribute7_o =>ben_psl_shd.g_old_rec.psl_attribute7
480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8
481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9
482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10
483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11
484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12
485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13
486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14
487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15

Line 484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12

480: ,p_psl_attribute8_o =>ben_psl_shd.g_old_rec.psl_attribute8
481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9
482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10
483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11
484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12
485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13
486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14
487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15
488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16

Line 485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13

481: ,p_psl_attribute9_o =>ben_psl_shd.g_old_rec.psl_attribute9
482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10
483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11
484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12
485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13
486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14
487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15
488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16
489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17

Line 486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14

482: ,p_psl_attribute10_o =>ben_psl_shd.g_old_rec.psl_attribute10
483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11
484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12
485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13
486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14
487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15
488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16
489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17
490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18

Line 487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15

483: ,p_psl_attribute11_o =>ben_psl_shd.g_old_rec.psl_attribute11
484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12
485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13
486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14
487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15
488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16
489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17
490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18
491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19

Line 488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16

484: ,p_psl_attribute12_o =>ben_psl_shd.g_old_rec.psl_attribute12
485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13
486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14
487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15
488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16
489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17
490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18
491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19
492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20

Line 489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17

485: ,p_psl_attribute13_o =>ben_psl_shd.g_old_rec.psl_attribute13
486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14
487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15
488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16
489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17
490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18
491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19
492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20
493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21

Line 490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18

486: ,p_psl_attribute14_o =>ben_psl_shd.g_old_rec.psl_attribute14
487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15
488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16
489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17
490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18
491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19
492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20
493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21
494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22

Line 491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19

487: ,p_psl_attribute15_o =>ben_psl_shd.g_old_rec.psl_attribute15
488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16
489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17
490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18
491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19
492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20
493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21
494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22
495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23

Line 492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20

488: ,p_psl_attribute16_o =>ben_psl_shd.g_old_rec.psl_attribute16
489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17
490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18
491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19
492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20
493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21
494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22
495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23
496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24

Line 493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21

489: ,p_psl_attribute17_o =>ben_psl_shd.g_old_rec.psl_attribute17
490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18
491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19
492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20
493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21
494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22
495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23
496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24
497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25

Line 494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22

490: ,p_psl_attribute18_o =>ben_psl_shd.g_old_rec.psl_attribute18
491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19
492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20
493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21
494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22
495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23
496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24
497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25
498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26

Line 495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23

491: ,p_psl_attribute19_o =>ben_psl_shd.g_old_rec.psl_attribute19
492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20
493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21
494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22
495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23
496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24
497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25
498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26
499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27

Line 496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24

492: ,p_psl_attribute20_o =>ben_psl_shd.g_old_rec.psl_attribute20
493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21
494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22
495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23
496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24
497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25
498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26
499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27
500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28

Line 497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25

493: ,p_psl_attribute21_o =>ben_psl_shd.g_old_rec.psl_attribute21
494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22
495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23
496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24
497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25
498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26
499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27
500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28
501: ,p_psl_attribute29_o =>ben_psl_shd.g_old_rec.psl_attribute29

Line 498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26

494: ,p_psl_attribute22_o =>ben_psl_shd.g_old_rec.psl_attribute22
495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23
496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24
497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25
498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26
499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27
500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28
501: ,p_psl_attribute29_o =>ben_psl_shd.g_old_rec.psl_attribute29
502: ,p_psl_attribute30_o =>ben_psl_shd.g_old_rec.psl_attribute30

Line 499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27

495: ,p_psl_attribute23_o =>ben_psl_shd.g_old_rec.psl_attribute23
496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24
497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25
498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26
499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27
500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28
501: ,p_psl_attribute29_o =>ben_psl_shd.g_old_rec.psl_attribute29
502: ,p_psl_attribute30_o =>ben_psl_shd.g_old_rec.psl_attribute30
503: ,p_object_version_number_o =>ben_psl_shd.g_old_rec.object_version_number

Line 500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28

496: ,p_psl_attribute24_o =>ben_psl_shd.g_old_rec.psl_attribute24
497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25
498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26
499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27
500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28
501: ,p_psl_attribute29_o =>ben_psl_shd.g_old_rec.psl_attribute29
502: ,p_psl_attribute30_o =>ben_psl_shd.g_old_rec.psl_attribute30
503: ,p_object_version_number_o =>ben_psl_shd.g_old_rec.object_version_number
504: );

Line 501: ,p_psl_attribute29_o =>ben_psl_shd.g_old_rec.psl_attribute29

497: ,p_psl_attribute25_o =>ben_psl_shd.g_old_rec.psl_attribute25
498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26
499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27
500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28
501: ,p_psl_attribute29_o =>ben_psl_shd.g_old_rec.psl_attribute29
502: ,p_psl_attribute30_o =>ben_psl_shd.g_old_rec.psl_attribute30
503: ,p_object_version_number_o =>ben_psl_shd.g_old_rec.object_version_number
504: );
505: --

Line 502: ,p_psl_attribute30_o =>ben_psl_shd.g_old_rec.psl_attribute30

498: ,p_psl_attribute26_o =>ben_psl_shd.g_old_rec.psl_attribute26
499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27
500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28
501: ,p_psl_attribute29_o =>ben_psl_shd.g_old_rec.psl_attribute29
502: ,p_psl_attribute30_o =>ben_psl_shd.g_old_rec.psl_attribute30
503: ,p_object_version_number_o =>ben_psl_shd.g_old_rec.object_version_number
504: );
505: --
506: exception

Line 503: ,p_object_version_number_o =>ben_psl_shd.g_old_rec.object_version_number

499: ,p_psl_attribute27_o =>ben_psl_shd.g_old_rec.psl_attribute27
500: ,p_psl_attribute28_o =>ben_psl_shd.g_old_rec.psl_attribute28
501: ,p_psl_attribute29_o =>ben_psl_shd.g_old_rec.psl_attribute29
502: ,p_psl_attribute30_o =>ben_psl_shd.g_old_rec.psl_attribute30
503: ,p_object_version_number_o =>ben_psl_shd.g_old_rec.object_version_number
504: );
505: --
506: exception
507: --

Line 565: Procedure convert_defs(p_rec in out nocopy ben_psl_shd.g_rec_type) is

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

Line 580: ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl;

576: -- is being used then we must set to the 'current' argument value.
577: --
578: If (p_rec.per_info_chg_cs_ler_rl = hr_api.g_number) then
579: p_rec.per_info_chg_cs_ler_rl :=
580: ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl;
581: End If;
582: If (p_rec.name = hr_api.g_varchar2) then
583: p_rec.name :=
584: ben_psl_shd.g_old_rec.name;

Line 584: ben_psl_shd.g_old_rec.name;

580: ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl;
581: End If;
582: If (p_rec.name = hr_api.g_varchar2) then
583: p_rec.name :=
584: ben_psl_shd.g_old_rec.name;
585: End If;
586: If (p_rec.old_val = hr_api.g_varchar2) then
587: p_rec.old_val :=
588: ben_psl_shd.g_old_rec.old_val;

Line 588: ben_psl_shd.g_old_rec.old_val;

584: ben_psl_shd.g_old_rec.name;
585: End If;
586: If (p_rec.old_val = hr_api.g_varchar2) then
587: p_rec.old_val :=
588: ben_psl_shd.g_old_rec.old_val;
589: End If;
590: If (p_rec.new_val = hr_api.g_varchar2) then
591: p_rec.new_val :=
592: ben_psl_shd.g_old_rec.new_val;

Line 592: ben_psl_shd.g_old_rec.new_val;

588: ben_psl_shd.g_old_rec.old_val;
589: End If;
590: If (p_rec.new_val = hr_api.g_varchar2) then
591: p_rec.new_val :=
592: ben_psl_shd.g_old_rec.new_val;
593: End If;
594: If (p_rec.whatif_lbl_txt = hr_api.g_varchar2) then
595: p_rec.whatif_lbl_txt :=
596: ben_psl_shd.g_old_rec.whatif_lbl_txt;

Line 596: ben_psl_shd.g_old_rec.whatif_lbl_txt;

592: ben_psl_shd.g_old_rec.new_val;
593: End If;
594: If (p_rec.whatif_lbl_txt = hr_api.g_varchar2) then
595: p_rec.whatif_lbl_txt :=
596: ben_psl_shd.g_old_rec.whatif_lbl_txt;
597: End If;
598: If (p_rec.rule_overrides_flag = hr_api.g_varchar2) then
599: p_rec.rule_overrides_flag :=
600: ben_psl_shd.g_old_rec.rule_overrides_flag;

Line 600: ben_psl_shd.g_old_rec.rule_overrides_flag;

596: ben_psl_shd.g_old_rec.whatif_lbl_txt;
597: End If;
598: If (p_rec.rule_overrides_flag = hr_api.g_varchar2) then
599: p_rec.rule_overrides_flag :=
600: ben_psl_shd.g_old_rec.rule_overrides_flag;
601: End If;
602: If (p_rec.source_column = hr_api.g_varchar2) then
603: p_rec.source_column :=
604: ben_psl_shd.g_old_rec.source_column;

Line 604: ben_psl_shd.g_old_rec.source_column;

600: ben_psl_shd.g_old_rec.rule_overrides_flag;
601: End If;
602: If (p_rec.source_column = hr_api.g_varchar2) then
603: p_rec.source_column :=
604: ben_psl_shd.g_old_rec.source_column;
605: End If;
606: If (p_rec.source_table = hr_api.g_varchar2) then
607: p_rec.source_table :=
608: ben_psl_shd.g_old_rec.source_table;

Line 608: ben_psl_shd.g_old_rec.source_table;

604: ben_psl_shd.g_old_rec.source_column;
605: End If;
606: If (p_rec.source_table = hr_api.g_varchar2) then
607: p_rec.source_table :=
608: ben_psl_shd.g_old_rec.source_table;
609: End If;
610: If (p_rec.business_group_id = hr_api.g_number) then
611: p_rec.business_group_id :=
612: ben_psl_shd.g_old_rec.business_group_id;

Line 612: ben_psl_shd.g_old_rec.business_group_id;

608: ben_psl_shd.g_old_rec.source_table;
609: End If;
610: If (p_rec.business_group_id = hr_api.g_number) then
611: p_rec.business_group_id :=
612: ben_psl_shd.g_old_rec.business_group_id;
613: End If;
614: If (p_rec.psl_attribute_category = hr_api.g_varchar2) then
615: p_rec.psl_attribute_category :=
616: ben_psl_shd.g_old_rec.psl_attribute_category;

Line 616: ben_psl_shd.g_old_rec.psl_attribute_category;

612: ben_psl_shd.g_old_rec.business_group_id;
613: End If;
614: If (p_rec.psl_attribute_category = hr_api.g_varchar2) then
615: p_rec.psl_attribute_category :=
616: ben_psl_shd.g_old_rec.psl_attribute_category;
617: End If;
618: If (p_rec.psl_attribute1 = hr_api.g_varchar2) then
619: p_rec.psl_attribute1 :=
620: ben_psl_shd.g_old_rec.psl_attribute1;

Line 620: ben_psl_shd.g_old_rec.psl_attribute1;

616: ben_psl_shd.g_old_rec.psl_attribute_category;
617: End If;
618: If (p_rec.psl_attribute1 = hr_api.g_varchar2) then
619: p_rec.psl_attribute1 :=
620: ben_psl_shd.g_old_rec.psl_attribute1;
621: End If;
622: If (p_rec.psl_attribute2 = hr_api.g_varchar2) then
623: p_rec.psl_attribute2 :=
624: ben_psl_shd.g_old_rec.psl_attribute2;

Line 624: ben_psl_shd.g_old_rec.psl_attribute2;

620: ben_psl_shd.g_old_rec.psl_attribute1;
621: End If;
622: If (p_rec.psl_attribute2 = hr_api.g_varchar2) then
623: p_rec.psl_attribute2 :=
624: ben_psl_shd.g_old_rec.psl_attribute2;
625: End If;
626: If (p_rec.psl_attribute3 = hr_api.g_varchar2) then
627: p_rec.psl_attribute3 :=
628: ben_psl_shd.g_old_rec.psl_attribute3;

Line 628: ben_psl_shd.g_old_rec.psl_attribute3;

624: ben_psl_shd.g_old_rec.psl_attribute2;
625: End If;
626: If (p_rec.psl_attribute3 = hr_api.g_varchar2) then
627: p_rec.psl_attribute3 :=
628: ben_psl_shd.g_old_rec.psl_attribute3;
629: End If;
630: If (p_rec.psl_attribute4 = hr_api.g_varchar2) then
631: p_rec.psl_attribute4 :=
632: ben_psl_shd.g_old_rec.psl_attribute4;

Line 632: ben_psl_shd.g_old_rec.psl_attribute4;

628: ben_psl_shd.g_old_rec.psl_attribute3;
629: End If;
630: If (p_rec.psl_attribute4 = hr_api.g_varchar2) then
631: p_rec.psl_attribute4 :=
632: ben_psl_shd.g_old_rec.psl_attribute4;
633: End If;
634: If (p_rec.psl_attribute5 = hr_api.g_varchar2) then
635: p_rec.psl_attribute5 :=
636: ben_psl_shd.g_old_rec.psl_attribute5;

Line 636: ben_psl_shd.g_old_rec.psl_attribute5;

632: ben_psl_shd.g_old_rec.psl_attribute4;
633: End If;
634: If (p_rec.psl_attribute5 = hr_api.g_varchar2) then
635: p_rec.psl_attribute5 :=
636: ben_psl_shd.g_old_rec.psl_attribute5;
637: End If;
638: If (p_rec.psl_attribute6 = hr_api.g_varchar2) then
639: p_rec.psl_attribute6 :=
640: ben_psl_shd.g_old_rec.psl_attribute6;

Line 640: ben_psl_shd.g_old_rec.psl_attribute6;

636: ben_psl_shd.g_old_rec.psl_attribute5;
637: End If;
638: If (p_rec.psl_attribute6 = hr_api.g_varchar2) then
639: p_rec.psl_attribute6 :=
640: ben_psl_shd.g_old_rec.psl_attribute6;
641: End If;
642: If (p_rec.psl_attribute7 = hr_api.g_varchar2) then
643: p_rec.psl_attribute7 :=
644: ben_psl_shd.g_old_rec.psl_attribute7;

Line 644: ben_psl_shd.g_old_rec.psl_attribute7;

640: ben_psl_shd.g_old_rec.psl_attribute6;
641: End If;
642: If (p_rec.psl_attribute7 = hr_api.g_varchar2) then
643: p_rec.psl_attribute7 :=
644: ben_psl_shd.g_old_rec.psl_attribute7;
645: End If;
646: If (p_rec.psl_attribute8 = hr_api.g_varchar2) then
647: p_rec.psl_attribute8 :=
648: ben_psl_shd.g_old_rec.psl_attribute8;

Line 648: ben_psl_shd.g_old_rec.psl_attribute8;

644: ben_psl_shd.g_old_rec.psl_attribute7;
645: End If;
646: If (p_rec.psl_attribute8 = hr_api.g_varchar2) then
647: p_rec.psl_attribute8 :=
648: ben_psl_shd.g_old_rec.psl_attribute8;
649: End If;
650: If (p_rec.psl_attribute9 = hr_api.g_varchar2) then
651: p_rec.psl_attribute9 :=
652: ben_psl_shd.g_old_rec.psl_attribute9;

Line 652: ben_psl_shd.g_old_rec.psl_attribute9;

648: ben_psl_shd.g_old_rec.psl_attribute8;
649: End If;
650: If (p_rec.psl_attribute9 = hr_api.g_varchar2) then
651: p_rec.psl_attribute9 :=
652: ben_psl_shd.g_old_rec.psl_attribute9;
653: End If;
654: If (p_rec.psl_attribute10 = hr_api.g_varchar2) then
655: p_rec.psl_attribute10 :=
656: ben_psl_shd.g_old_rec.psl_attribute10;

Line 656: ben_psl_shd.g_old_rec.psl_attribute10;

652: ben_psl_shd.g_old_rec.psl_attribute9;
653: End If;
654: If (p_rec.psl_attribute10 = hr_api.g_varchar2) then
655: p_rec.psl_attribute10 :=
656: ben_psl_shd.g_old_rec.psl_attribute10;
657: End If;
658: If (p_rec.psl_attribute11 = hr_api.g_varchar2) then
659: p_rec.psl_attribute11 :=
660: ben_psl_shd.g_old_rec.psl_attribute11;

Line 660: ben_psl_shd.g_old_rec.psl_attribute11;

656: ben_psl_shd.g_old_rec.psl_attribute10;
657: End If;
658: If (p_rec.psl_attribute11 = hr_api.g_varchar2) then
659: p_rec.psl_attribute11 :=
660: ben_psl_shd.g_old_rec.psl_attribute11;
661: End If;
662: If (p_rec.psl_attribute12 = hr_api.g_varchar2) then
663: p_rec.psl_attribute12 :=
664: ben_psl_shd.g_old_rec.psl_attribute12;

Line 664: ben_psl_shd.g_old_rec.psl_attribute12;

660: ben_psl_shd.g_old_rec.psl_attribute11;
661: End If;
662: If (p_rec.psl_attribute12 = hr_api.g_varchar2) then
663: p_rec.psl_attribute12 :=
664: ben_psl_shd.g_old_rec.psl_attribute12;
665: End If;
666: If (p_rec.psl_attribute13 = hr_api.g_varchar2) then
667: p_rec.psl_attribute13 :=
668: ben_psl_shd.g_old_rec.psl_attribute13;

Line 668: ben_psl_shd.g_old_rec.psl_attribute13;

664: ben_psl_shd.g_old_rec.psl_attribute12;
665: End If;
666: If (p_rec.psl_attribute13 = hr_api.g_varchar2) then
667: p_rec.psl_attribute13 :=
668: ben_psl_shd.g_old_rec.psl_attribute13;
669: End If;
670: If (p_rec.psl_attribute14 = hr_api.g_varchar2) then
671: p_rec.psl_attribute14 :=
672: ben_psl_shd.g_old_rec.psl_attribute14;

Line 672: ben_psl_shd.g_old_rec.psl_attribute14;

668: ben_psl_shd.g_old_rec.psl_attribute13;
669: End If;
670: If (p_rec.psl_attribute14 = hr_api.g_varchar2) then
671: p_rec.psl_attribute14 :=
672: ben_psl_shd.g_old_rec.psl_attribute14;
673: End If;
674: If (p_rec.psl_attribute15 = hr_api.g_varchar2) then
675: p_rec.psl_attribute15 :=
676: ben_psl_shd.g_old_rec.psl_attribute15;

Line 676: ben_psl_shd.g_old_rec.psl_attribute15;

672: ben_psl_shd.g_old_rec.psl_attribute14;
673: End If;
674: If (p_rec.psl_attribute15 = hr_api.g_varchar2) then
675: p_rec.psl_attribute15 :=
676: ben_psl_shd.g_old_rec.psl_attribute15;
677: End If;
678: If (p_rec.psl_attribute16 = hr_api.g_varchar2) then
679: p_rec.psl_attribute16 :=
680: ben_psl_shd.g_old_rec.psl_attribute16;

Line 680: ben_psl_shd.g_old_rec.psl_attribute16;

676: ben_psl_shd.g_old_rec.psl_attribute15;
677: End If;
678: If (p_rec.psl_attribute16 = hr_api.g_varchar2) then
679: p_rec.psl_attribute16 :=
680: ben_psl_shd.g_old_rec.psl_attribute16;
681: End If;
682: If (p_rec.psl_attribute17 = hr_api.g_varchar2) then
683: p_rec.psl_attribute17 :=
684: ben_psl_shd.g_old_rec.psl_attribute17;

Line 684: ben_psl_shd.g_old_rec.psl_attribute17;

680: ben_psl_shd.g_old_rec.psl_attribute16;
681: End If;
682: If (p_rec.psl_attribute17 = hr_api.g_varchar2) then
683: p_rec.psl_attribute17 :=
684: ben_psl_shd.g_old_rec.psl_attribute17;
685: End If;
686: If (p_rec.psl_attribute18 = hr_api.g_varchar2) then
687: p_rec.psl_attribute18 :=
688: ben_psl_shd.g_old_rec.psl_attribute18;

Line 688: ben_psl_shd.g_old_rec.psl_attribute18;

684: ben_psl_shd.g_old_rec.psl_attribute17;
685: End If;
686: If (p_rec.psl_attribute18 = hr_api.g_varchar2) then
687: p_rec.psl_attribute18 :=
688: ben_psl_shd.g_old_rec.psl_attribute18;
689: End If;
690: If (p_rec.psl_attribute19 = hr_api.g_varchar2) then
691: p_rec.psl_attribute19 :=
692: ben_psl_shd.g_old_rec.psl_attribute19;

Line 692: ben_psl_shd.g_old_rec.psl_attribute19;

688: ben_psl_shd.g_old_rec.psl_attribute18;
689: End If;
690: If (p_rec.psl_attribute19 = hr_api.g_varchar2) then
691: p_rec.psl_attribute19 :=
692: ben_psl_shd.g_old_rec.psl_attribute19;
693: End If;
694: If (p_rec.psl_attribute20 = hr_api.g_varchar2) then
695: p_rec.psl_attribute20 :=
696: ben_psl_shd.g_old_rec.psl_attribute20;

Line 696: ben_psl_shd.g_old_rec.psl_attribute20;

692: ben_psl_shd.g_old_rec.psl_attribute19;
693: End If;
694: If (p_rec.psl_attribute20 = hr_api.g_varchar2) then
695: p_rec.psl_attribute20 :=
696: ben_psl_shd.g_old_rec.psl_attribute20;
697: End If;
698: If (p_rec.psl_attribute21 = hr_api.g_varchar2) then
699: p_rec.psl_attribute21 :=
700: ben_psl_shd.g_old_rec.psl_attribute21;

Line 700: ben_psl_shd.g_old_rec.psl_attribute21;

696: ben_psl_shd.g_old_rec.psl_attribute20;
697: End If;
698: If (p_rec.psl_attribute21 = hr_api.g_varchar2) then
699: p_rec.psl_attribute21 :=
700: ben_psl_shd.g_old_rec.psl_attribute21;
701: End If;
702: If (p_rec.psl_attribute22 = hr_api.g_varchar2) then
703: p_rec.psl_attribute22 :=
704: ben_psl_shd.g_old_rec.psl_attribute22;

Line 704: ben_psl_shd.g_old_rec.psl_attribute22;

700: ben_psl_shd.g_old_rec.psl_attribute21;
701: End If;
702: If (p_rec.psl_attribute22 = hr_api.g_varchar2) then
703: p_rec.psl_attribute22 :=
704: ben_psl_shd.g_old_rec.psl_attribute22;
705: End If;
706: If (p_rec.psl_attribute23 = hr_api.g_varchar2) then
707: p_rec.psl_attribute23 :=
708: ben_psl_shd.g_old_rec.psl_attribute23;

Line 708: ben_psl_shd.g_old_rec.psl_attribute23;

704: ben_psl_shd.g_old_rec.psl_attribute22;
705: End If;
706: If (p_rec.psl_attribute23 = hr_api.g_varchar2) then
707: p_rec.psl_attribute23 :=
708: ben_psl_shd.g_old_rec.psl_attribute23;
709: End If;
710: If (p_rec.psl_attribute24 = hr_api.g_varchar2) then
711: p_rec.psl_attribute24 :=
712: ben_psl_shd.g_old_rec.psl_attribute24;

Line 712: ben_psl_shd.g_old_rec.psl_attribute24;

708: ben_psl_shd.g_old_rec.psl_attribute23;
709: End If;
710: If (p_rec.psl_attribute24 = hr_api.g_varchar2) then
711: p_rec.psl_attribute24 :=
712: ben_psl_shd.g_old_rec.psl_attribute24;
713: End If;
714: If (p_rec.psl_attribute25 = hr_api.g_varchar2) then
715: p_rec.psl_attribute25 :=
716: ben_psl_shd.g_old_rec.psl_attribute25;

Line 716: ben_psl_shd.g_old_rec.psl_attribute25;

712: ben_psl_shd.g_old_rec.psl_attribute24;
713: End If;
714: If (p_rec.psl_attribute25 = hr_api.g_varchar2) then
715: p_rec.psl_attribute25 :=
716: ben_psl_shd.g_old_rec.psl_attribute25;
717: End If;
718: If (p_rec.psl_attribute26 = hr_api.g_varchar2) then
719: p_rec.psl_attribute26 :=
720: ben_psl_shd.g_old_rec.psl_attribute26;

Line 720: ben_psl_shd.g_old_rec.psl_attribute26;

716: ben_psl_shd.g_old_rec.psl_attribute25;
717: End If;
718: If (p_rec.psl_attribute26 = hr_api.g_varchar2) then
719: p_rec.psl_attribute26 :=
720: ben_psl_shd.g_old_rec.psl_attribute26;
721: End If;
722: If (p_rec.psl_attribute27 = hr_api.g_varchar2) then
723: p_rec.psl_attribute27 :=
724: ben_psl_shd.g_old_rec.psl_attribute27;

Line 724: ben_psl_shd.g_old_rec.psl_attribute27;

720: ben_psl_shd.g_old_rec.psl_attribute26;
721: End If;
722: If (p_rec.psl_attribute27 = hr_api.g_varchar2) then
723: p_rec.psl_attribute27 :=
724: ben_psl_shd.g_old_rec.psl_attribute27;
725: End If;
726: If (p_rec.psl_attribute28 = hr_api.g_varchar2) then
727: p_rec.psl_attribute28 :=
728: ben_psl_shd.g_old_rec.psl_attribute28;

Line 728: ben_psl_shd.g_old_rec.psl_attribute28;

724: ben_psl_shd.g_old_rec.psl_attribute27;
725: End If;
726: If (p_rec.psl_attribute28 = hr_api.g_varchar2) then
727: p_rec.psl_attribute28 :=
728: ben_psl_shd.g_old_rec.psl_attribute28;
729: End If;
730: If (p_rec.psl_attribute29 = hr_api.g_varchar2) then
731: p_rec.psl_attribute29 :=
732: ben_psl_shd.g_old_rec.psl_attribute29;

Line 732: ben_psl_shd.g_old_rec.psl_attribute29;

728: ben_psl_shd.g_old_rec.psl_attribute28;
729: End If;
730: If (p_rec.psl_attribute29 = hr_api.g_varchar2) then
731: p_rec.psl_attribute29 :=
732: ben_psl_shd.g_old_rec.psl_attribute29;
733: End If;
734: If (p_rec.psl_attribute30 = hr_api.g_varchar2) then
735: p_rec.psl_attribute30 :=
736: ben_psl_shd.g_old_rec.psl_attribute30;

Line 736: ben_psl_shd.g_old_rec.psl_attribute30;

732: ben_psl_shd.g_old_rec.psl_attribute29;
733: End If;
734: If (p_rec.psl_attribute30 = hr_api.g_varchar2) then
735: p_rec.psl_attribute30 :=
736: ben_psl_shd.g_old_rec.psl_attribute30;
737: End If;
738:
739: --
740: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 749: p_rec in out nocopy ben_psl_shd.g_rec_type,

745: -- |---------------------------------< upd >----------------------------------|
746: -- ----------------------------------------------------------------------------
747: Procedure upd
748: (
749: p_rec in out nocopy ben_psl_shd.g_rec_type,
750: p_effective_date in date,
751: p_datetrack_mode in varchar2
752: ) is
753: --

Line 767: ben_psl_shd.lck

763: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
764: --
765: -- We must lock the row which we need to update.
766: --
767: ben_psl_shd.lck
768: (p_effective_date => p_effective_date,
769: p_datetrack_mode => p_datetrack_mode,
770: p_per_info_chg_cs_ler_id => p_rec.per_info_chg_cs_ler_id,
771: p_object_version_number => p_rec.object_version_number,

Line 870: l_rec ben_psl_shd.g_rec_type;

866: p_effective_date in date,
867: p_datetrack_mode in varchar2
868: ) is
869: --
870: l_rec ben_psl_shd.g_rec_type;
871: l_proc varchar2(72) := g_package||'upd';
872: --
873: Begin
874: hr_utility.set_location('Entering:'||l_proc, 5);

Line 880: ben_psl_shd.convert_args

876: -- Call conversion function to turn arguments into the
877: -- l_rec structure.
878: --
879: l_rec :=
880: ben_psl_shd.convert_args
881: (
882: p_per_info_chg_cs_ler_id,
883: p_name,
884: null,