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_ECQ_UPD dependencies on BEN_ECQ_SHD

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

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

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

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

128: where elig_cbr_quald_bnf_id = p_rec.elig_cbr_quald_bnf_id
129: and effective_start_date = p_validation_start_date
130: and effective_end_date = p_validation_end_date;
131: --
132: ben_ecq_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_ecq_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_ecq_shd.g_api_dml := false; -- Unset the api dml status
145: ben_ecq_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_ecq_shd.constraint_error

141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_ecq_shd.g_api_dml := false; -- Unset the api dml status
145: ben_ecq_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_ecq_shd.g_api_dml := false; -- Unset the api dml status

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

145: ben_ecq_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_ecq_shd.g_api_dml := false; -- Unset the api dml status
150: ben_ecq_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_ecq_shd.g_api_dml := false; -- Unset the api dml status

Line 150: ben_ecq_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_ecq_shd.g_api_dml := false; -- Unset the api dml status
150: ben_ecq_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_ecq_shd.g_api_dml := false; -- Unset the api dml status
154: Raise;

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

149: ben_ecq_shd.g_api_dml := false; -- Unset the api dml status
150: ben_ecq_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_ecq_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_ecq_shd.g_rec_type,

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure update_dml
189: (p_rec in out nocopy ben_ecq_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_ecq_shd.g_rec_type,

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_pre_update
253: (p_rec in out nocopy ben_ecq_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_ecq_shd.upd_effective_end_date

265: hr_utility.set_location(l_proc, 10);
266: --
267: -- Update the current effective end date
268: --
269: ben_ecq_shd.upd_effective_end_date
270: (p_effective_date => p_effective_date,
271: p_base_key_value => p_rec.elig_cbr_quald_bnf_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_ecq_shd.g_rec_type,

334: --
335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure pre_update
338: (p_rec in out nocopy ben_ecq_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_ecq_shd.g_rec_type,

390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure post_update
394: (p_rec in ben_ecq_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 457: ,p_effective_start_date_o =>ben_ecq_shd.g_old_rec.effective_start_date

453: ,p_effective_date =>p_effective_date
454: ,p_datetrack_mode =>p_datetrack_mode
455: ,p_validation_start_date =>p_validation_start_date
456: ,p_validation_end_date =>p_validation_end_date
457: ,p_effective_start_date_o =>ben_ecq_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_ecq_shd.g_old_rec.effective_end_date
459: ,p_quald_bnf_flag_o =>ben_ecq_shd.g_old_rec.quald_bnf_flag
460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num
461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id

Line 458: ,p_effective_end_date_o =>ben_ecq_shd.g_old_rec.effective_end_date

454: ,p_datetrack_mode =>p_datetrack_mode
455: ,p_validation_start_date =>p_validation_start_date
456: ,p_validation_end_date =>p_validation_end_date
457: ,p_effective_start_date_o =>ben_ecq_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_ecq_shd.g_old_rec.effective_end_date
459: ,p_quald_bnf_flag_o =>ben_ecq_shd.g_old_rec.quald_bnf_flag
460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num
461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id
462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id

Line 459: ,p_quald_bnf_flag_o =>ben_ecq_shd.g_old_rec.quald_bnf_flag

455: ,p_validation_start_date =>p_validation_start_date
456: ,p_validation_end_date =>p_validation_end_date
457: ,p_effective_start_date_o =>ben_ecq_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_ecq_shd.g_old_rec.effective_end_date
459: ,p_quald_bnf_flag_o =>ben_ecq_shd.g_old_rec.quald_bnf_flag
460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num
461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id
462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id
463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id

Line 460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num

456: ,p_validation_end_date =>p_validation_end_date
457: ,p_effective_start_date_o =>ben_ecq_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_ecq_shd.g_old_rec.effective_end_date
459: ,p_quald_bnf_flag_o =>ben_ecq_shd.g_old_rec.quald_bnf_flag
460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num
461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id
462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id
463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id
464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id

Line 461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id

457: ,p_effective_start_date_o =>ben_ecq_shd.g_old_rec.effective_start_date
458: ,p_effective_end_date_o =>ben_ecq_shd.g_old_rec.effective_end_date
459: ,p_quald_bnf_flag_o =>ben_ecq_shd.g_old_rec.quald_bnf_flag
460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num
461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id
462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id
463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id
464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id
465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category

Line 462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id

458: ,p_effective_end_date_o =>ben_ecq_shd.g_old_rec.effective_end_date
459: ,p_quald_bnf_flag_o =>ben_ecq_shd.g_old_rec.quald_bnf_flag
460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num
461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id
462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id
463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id
464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id
465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category
466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1

Line 463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id

459: ,p_quald_bnf_flag_o =>ben_ecq_shd.g_old_rec.quald_bnf_flag
460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num
461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id
462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id
463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id
464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id
465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category
466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1
467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2

Line 464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id

460: ,p_ordr_num_o =>ben_ecq_shd.g_old_rec.ordr_num
461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id
462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id
463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id
464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id
465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category
466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1
467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2
468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3

Line 465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category

461: ,p_eligy_prfl_id_o =>ben_ecq_shd.g_old_rec.eligy_prfl_id
462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id
463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id
464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id
465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category
466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1
467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2
468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3
469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4

Line 466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1

462: ,p_pgm_id_o =>ben_ecq_shd.g_old_rec.pgm_id
463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id
464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id
465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category
466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1
467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2
468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3
469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4
470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5

Line 467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2

463: ,p_ptip_id_o =>ben_ecq_shd.g_old_rec.ptip_id
464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id
465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category
466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1
467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2
468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3
469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4
470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5
471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6

Line 468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3

464: ,p_business_group_id_o =>ben_ecq_shd.g_old_rec.business_group_id
465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category
466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1
467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2
468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3
469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4
470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5
471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6
472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7

Line 469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4

465: ,p_ecq_attribute_category_o =>ben_ecq_shd.g_old_rec.ecq_attribute_category
466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1
467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2
468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3
469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4
470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5
471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6
472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7
473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8

Line 470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5

466: ,p_ecq_attribute1_o =>ben_ecq_shd.g_old_rec.ecq_attribute1
467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2
468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3
469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4
470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5
471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6
472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7
473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8
474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9

Line 471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6

467: ,p_ecq_attribute2_o =>ben_ecq_shd.g_old_rec.ecq_attribute2
468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3
469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4
470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5
471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6
472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7
473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8
474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9
475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10

Line 472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7

468: ,p_ecq_attribute3_o =>ben_ecq_shd.g_old_rec.ecq_attribute3
469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4
470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5
471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6
472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7
473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8
474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9
475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10
476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11

Line 473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8

469: ,p_ecq_attribute4_o =>ben_ecq_shd.g_old_rec.ecq_attribute4
470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5
471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6
472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7
473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8
474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9
475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10
476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11
477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12

Line 474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9

470: ,p_ecq_attribute5_o =>ben_ecq_shd.g_old_rec.ecq_attribute5
471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6
472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7
473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8
474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9
475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10
476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11
477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12
478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13

Line 475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10

471: ,p_ecq_attribute6_o =>ben_ecq_shd.g_old_rec.ecq_attribute6
472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7
473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8
474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9
475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10
476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11
477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12
478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13
479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14

Line 476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11

472: ,p_ecq_attribute7_o =>ben_ecq_shd.g_old_rec.ecq_attribute7
473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8
474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9
475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10
476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11
477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12
478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13
479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14
480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15

Line 477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12

473: ,p_ecq_attribute8_o =>ben_ecq_shd.g_old_rec.ecq_attribute8
474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9
475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10
476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11
477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12
478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13
479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14
480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15
481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16

Line 478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13

474: ,p_ecq_attribute9_o =>ben_ecq_shd.g_old_rec.ecq_attribute9
475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10
476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11
477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12
478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13
479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14
480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15
481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16
482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17

Line 479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14

475: ,p_ecq_attribute10_o =>ben_ecq_shd.g_old_rec.ecq_attribute10
476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11
477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12
478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13
479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14
480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15
481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16
482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17
483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18

Line 480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15

476: ,p_ecq_attribute11_o =>ben_ecq_shd.g_old_rec.ecq_attribute11
477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12
478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13
479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14
480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15
481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16
482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17
483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18
484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19

Line 481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16

477: ,p_ecq_attribute12_o =>ben_ecq_shd.g_old_rec.ecq_attribute12
478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13
479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14
480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15
481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16
482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17
483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18
484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19
485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20

Line 482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17

478: ,p_ecq_attribute13_o =>ben_ecq_shd.g_old_rec.ecq_attribute13
479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14
480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15
481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16
482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17
483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18
484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19
485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20
486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21

Line 483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18

479: ,p_ecq_attribute14_o =>ben_ecq_shd.g_old_rec.ecq_attribute14
480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15
481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16
482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17
483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18
484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19
485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20
486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21
487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22

Line 484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19

480: ,p_ecq_attribute15_o =>ben_ecq_shd.g_old_rec.ecq_attribute15
481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16
482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17
483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18
484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19
485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20
486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21
487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22
488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23

Line 485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20

481: ,p_ecq_attribute16_o =>ben_ecq_shd.g_old_rec.ecq_attribute16
482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17
483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18
484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19
485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20
486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21
487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22
488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23
489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24

Line 486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21

482: ,p_ecq_attribute17_o =>ben_ecq_shd.g_old_rec.ecq_attribute17
483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18
484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19
485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20
486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21
487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22
488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23
489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24
490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25

Line 487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22

483: ,p_ecq_attribute18_o =>ben_ecq_shd.g_old_rec.ecq_attribute18
484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19
485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20
486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21
487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22
488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23
489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24
490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25
491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26

Line 488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23

484: ,p_ecq_attribute19_o =>ben_ecq_shd.g_old_rec.ecq_attribute19
485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20
486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21
487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22
488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23
489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24
490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25
491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26
492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27

Line 489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24

485: ,p_ecq_attribute20_o =>ben_ecq_shd.g_old_rec.ecq_attribute20
486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21
487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22
488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23
489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24
490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25
491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26
492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27
493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28

Line 490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25

486: ,p_ecq_attribute21_o =>ben_ecq_shd.g_old_rec.ecq_attribute21
487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22
488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23
489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24
490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25
491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26
492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27
493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28
494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29

Line 491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26

487: ,p_ecq_attribute22_o =>ben_ecq_shd.g_old_rec.ecq_attribute22
488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23
489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24
490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25
491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26
492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27
493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28
494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29
495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30

Line 492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27

488: ,p_ecq_attribute23_o =>ben_ecq_shd.g_old_rec.ecq_attribute23
489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24
490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25
491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26
492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27
493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28
494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29
495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30
496: ,p_object_version_number_o =>ben_ecq_shd.g_old_rec.object_version_number

Line 493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28

489: ,p_ecq_attribute24_o =>ben_ecq_shd.g_old_rec.ecq_attribute24
490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25
491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26
492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27
493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28
494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29
495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30
496: ,p_object_version_number_o =>ben_ecq_shd.g_old_rec.object_version_number
497: ,p_criteria_score_o => ben_ecq_shd.g_old_rec.criteria_score

Line 494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29

490: ,p_ecq_attribute25_o =>ben_ecq_shd.g_old_rec.ecq_attribute25
491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26
492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27
493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28
494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29
495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30
496: ,p_object_version_number_o =>ben_ecq_shd.g_old_rec.object_version_number
497: ,p_criteria_score_o => ben_ecq_shd.g_old_rec.criteria_score
498: ,p_criteria_weight_o => ben_ecq_shd.g_old_rec.criteria_weight

Line 495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30

491: ,p_ecq_attribute26_o =>ben_ecq_shd.g_old_rec.ecq_attribute26
492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27
493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28
494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29
495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30
496: ,p_object_version_number_o =>ben_ecq_shd.g_old_rec.object_version_number
497: ,p_criteria_score_o => ben_ecq_shd.g_old_rec.criteria_score
498: ,p_criteria_weight_o => ben_ecq_shd.g_old_rec.criteria_weight
499: ,p_criteria_score => p_rec.criteria_score

Line 496: ,p_object_version_number_o =>ben_ecq_shd.g_old_rec.object_version_number

492: ,p_ecq_attribute27_o =>ben_ecq_shd.g_old_rec.ecq_attribute27
493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28
494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29
495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30
496: ,p_object_version_number_o =>ben_ecq_shd.g_old_rec.object_version_number
497: ,p_criteria_score_o => ben_ecq_shd.g_old_rec.criteria_score
498: ,p_criteria_weight_o => ben_ecq_shd.g_old_rec.criteria_weight
499: ,p_criteria_score => p_rec.criteria_score
500: ,p_criteria_weight => p_rec.criteria_weight

Line 497: ,p_criteria_score_o => ben_ecq_shd.g_old_rec.criteria_score

493: ,p_ecq_attribute28_o =>ben_ecq_shd.g_old_rec.ecq_attribute28
494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29
495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30
496: ,p_object_version_number_o =>ben_ecq_shd.g_old_rec.object_version_number
497: ,p_criteria_score_o => ben_ecq_shd.g_old_rec.criteria_score
498: ,p_criteria_weight_o => ben_ecq_shd.g_old_rec.criteria_weight
499: ,p_criteria_score => p_rec.criteria_score
500: ,p_criteria_weight => p_rec.criteria_weight
501:

Line 498: ,p_criteria_weight_o => ben_ecq_shd.g_old_rec.criteria_weight

494: ,p_ecq_attribute29_o =>ben_ecq_shd.g_old_rec.ecq_attribute29
495: ,p_ecq_attribute30_o =>ben_ecq_shd.g_old_rec.ecq_attribute30
496: ,p_object_version_number_o =>ben_ecq_shd.g_old_rec.object_version_number
497: ,p_criteria_score_o => ben_ecq_shd.g_old_rec.criteria_score
498: ,p_criteria_weight_o => ben_ecq_shd.g_old_rec.criteria_weight
499: ,p_criteria_score => p_rec.criteria_score
500: ,p_criteria_weight => p_rec.criteria_weight
501:
502: );

Line 563: Procedure convert_defs(p_rec in out nocopy ben_ecq_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_ecq_shd.g_rec_type) is
564: --
565: l_proc varchar2(72) := g_package||'convert_defs';
566: --
567: Begin

Line 578: ben_ecq_shd.g_old_rec.quald_bnf_flag;

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

Line 582: ben_ecq_shd.g_old_rec.ordr_num;

578: ben_ecq_shd.g_old_rec.quald_bnf_flag;
579: End If;
580: If (p_rec.ordr_num = hr_api.g_number) then
581: p_rec.ordr_num :=
582: ben_ecq_shd.g_old_rec.ordr_num;
583: End If;
584: If (p_rec.eligy_prfl_id = hr_api.g_number) then
585: p_rec.eligy_prfl_id :=
586: ben_ecq_shd.g_old_rec.eligy_prfl_id;

Line 586: ben_ecq_shd.g_old_rec.eligy_prfl_id;

582: ben_ecq_shd.g_old_rec.ordr_num;
583: End If;
584: If (p_rec.eligy_prfl_id = hr_api.g_number) then
585: p_rec.eligy_prfl_id :=
586: ben_ecq_shd.g_old_rec.eligy_prfl_id;
587: End If;
588: If (p_rec.pgm_id = hr_api.g_number) then
589: p_rec.pgm_id :=
590: ben_ecq_shd.g_old_rec.pgm_id;

Line 590: ben_ecq_shd.g_old_rec.pgm_id;

586: ben_ecq_shd.g_old_rec.eligy_prfl_id;
587: End If;
588: If (p_rec.pgm_id = hr_api.g_number) then
589: p_rec.pgm_id :=
590: ben_ecq_shd.g_old_rec.pgm_id;
591: End If;
592: If (p_rec.ptip_id = hr_api.g_number) then
593: p_rec.ptip_id :=
594: ben_ecq_shd.g_old_rec.ptip_id;

Line 594: ben_ecq_shd.g_old_rec.ptip_id;

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

Line 598: ben_ecq_shd.g_old_rec.business_group_id;

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

Line 602: ben_ecq_shd.g_old_rec.ecq_attribute_category;

598: ben_ecq_shd.g_old_rec.business_group_id;
599: End If;
600: If (p_rec.ecq_attribute_category = hr_api.g_varchar2) then
601: p_rec.ecq_attribute_category :=
602: ben_ecq_shd.g_old_rec.ecq_attribute_category;
603: End If;
604: If (p_rec.ecq_attribute1 = hr_api.g_varchar2) then
605: p_rec.ecq_attribute1 :=
606: ben_ecq_shd.g_old_rec.ecq_attribute1;

Line 606: ben_ecq_shd.g_old_rec.ecq_attribute1;

602: ben_ecq_shd.g_old_rec.ecq_attribute_category;
603: End If;
604: If (p_rec.ecq_attribute1 = hr_api.g_varchar2) then
605: p_rec.ecq_attribute1 :=
606: ben_ecq_shd.g_old_rec.ecq_attribute1;
607: End If;
608: If (p_rec.ecq_attribute2 = hr_api.g_varchar2) then
609: p_rec.ecq_attribute2 :=
610: ben_ecq_shd.g_old_rec.ecq_attribute2;

Line 610: ben_ecq_shd.g_old_rec.ecq_attribute2;

606: ben_ecq_shd.g_old_rec.ecq_attribute1;
607: End If;
608: If (p_rec.ecq_attribute2 = hr_api.g_varchar2) then
609: p_rec.ecq_attribute2 :=
610: ben_ecq_shd.g_old_rec.ecq_attribute2;
611: End If;
612: If (p_rec.ecq_attribute3 = hr_api.g_varchar2) then
613: p_rec.ecq_attribute3 :=
614: ben_ecq_shd.g_old_rec.ecq_attribute3;

Line 614: ben_ecq_shd.g_old_rec.ecq_attribute3;

610: ben_ecq_shd.g_old_rec.ecq_attribute2;
611: End If;
612: If (p_rec.ecq_attribute3 = hr_api.g_varchar2) then
613: p_rec.ecq_attribute3 :=
614: ben_ecq_shd.g_old_rec.ecq_attribute3;
615: End If;
616: If (p_rec.ecq_attribute4 = hr_api.g_varchar2) then
617: p_rec.ecq_attribute4 :=
618: ben_ecq_shd.g_old_rec.ecq_attribute4;

Line 618: ben_ecq_shd.g_old_rec.ecq_attribute4;

614: ben_ecq_shd.g_old_rec.ecq_attribute3;
615: End If;
616: If (p_rec.ecq_attribute4 = hr_api.g_varchar2) then
617: p_rec.ecq_attribute4 :=
618: ben_ecq_shd.g_old_rec.ecq_attribute4;
619: End If;
620: If (p_rec.ecq_attribute5 = hr_api.g_varchar2) then
621: p_rec.ecq_attribute5 :=
622: ben_ecq_shd.g_old_rec.ecq_attribute5;

Line 622: ben_ecq_shd.g_old_rec.ecq_attribute5;

618: ben_ecq_shd.g_old_rec.ecq_attribute4;
619: End If;
620: If (p_rec.ecq_attribute5 = hr_api.g_varchar2) then
621: p_rec.ecq_attribute5 :=
622: ben_ecq_shd.g_old_rec.ecq_attribute5;
623: End If;
624: If (p_rec.ecq_attribute6 = hr_api.g_varchar2) then
625: p_rec.ecq_attribute6 :=
626: ben_ecq_shd.g_old_rec.ecq_attribute6;

Line 626: ben_ecq_shd.g_old_rec.ecq_attribute6;

622: ben_ecq_shd.g_old_rec.ecq_attribute5;
623: End If;
624: If (p_rec.ecq_attribute6 = hr_api.g_varchar2) then
625: p_rec.ecq_attribute6 :=
626: ben_ecq_shd.g_old_rec.ecq_attribute6;
627: End If;
628: If (p_rec.ecq_attribute7 = hr_api.g_varchar2) then
629: p_rec.ecq_attribute7 :=
630: ben_ecq_shd.g_old_rec.ecq_attribute7;

Line 630: ben_ecq_shd.g_old_rec.ecq_attribute7;

626: ben_ecq_shd.g_old_rec.ecq_attribute6;
627: End If;
628: If (p_rec.ecq_attribute7 = hr_api.g_varchar2) then
629: p_rec.ecq_attribute7 :=
630: ben_ecq_shd.g_old_rec.ecq_attribute7;
631: End If;
632: If (p_rec.ecq_attribute8 = hr_api.g_varchar2) then
633: p_rec.ecq_attribute8 :=
634: ben_ecq_shd.g_old_rec.ecq_attribute8;

Line 634: ben_ecq_shd.g_old_rec.ecq_attribute8;

630: ben_ecq_shd.g_old_rec.ecq_attribute7;
631: End If;
632: If (p_rec.ecq_attribute8 = hr_api.g_varchar2) then
633: p_rec.ecq_attribute8 :=
634: ben_ecq_shd.g_old_rec.ecq_attribute8;
635: End If;
636: If (p_rec.ecq_attribute9 = hr_api.g_varchar2) then
637: p_rec.ecq_attribute9 :=
638: ben_ecq_shd.g_old_rec.ecq_attribute9;

Line 638: ben_ecq_shd.g_old_rec.ecq_attribute9;

634: ben_ecq_shd.g_old_rec.ecq_attribute8;
635: End If;
636: If (p_rec.ecq_attribute9 = hr_api.g_varchar2) then
637: p_rec.ecq_attribute9 :=
638: ben_ecq_shd.g_old_rec.ecq_attribute9;
639: End If;
640: If (p_rec.ecq_attribute10 = hr_api.g_varchar2) then
641: p_rec.ecq_attribute10 :=
642: ben_ecq_shd.g_old_rec.ecq_attribute10;

Line 642: ben_ecq_shd.g_old_rec.ecq_attribute10;

638: ben_ecq_shd.g_old_rec.ecq_attribute9;
639: End If;
640: If (p_rec.ecq_attribute10 = hr_api.g_varchar2) then
641: p_rec.ecq_attribute10 :=
642: ben_ecq_shd.g_old_rec.ecq_attribute10;
643: End If;
644: If (p_rec.ecq_attribute11 = hr_api.g_varchar2) then
645: p_rec.ecq_attribute11 :=
646: ben_ecq_shd.g_old_rec.ecq_attribute11;

Line 646: ben_ecq_shd.g_old_rec.ecq_attribute11;

642: ben_ecq_shd.g_old_rec.ecq_attribute10;
643: End If;
644: If (p_rec.ecq_attribute11 = hr_api.g_varchar2) then
645: p_rec.ecq_attribute11 :=
646: ben_ecq_shd.g_old_rec.ecq_attribute11;
647: End If;
648: If (p_rec.ecq_attribute12 = hr_api.g_varchar2) then
649: p_rec.ecq_attribute12 :=
650: ben_ecq_shd.g_old_rec.ecq_attribute12;

Line 650: ben_ecq_shd.g_old_rec.ecq_attribute12;

646: ben_ecq_shd.g_old_rec.ecq_attribute11;
647: End If;
648: If (p_rec.ecq_attribute12 = hr_api.g_varchar2) then
649: p_rec.ecq_attribute12 :=
650: ben_ecq_shd.g_old_rec.ecq_attribute12;
651: End If;
652: If (p_rec.ecq_attribute13 = hr_api.g_varchar2) then
653: p_rec.ecq_attribute13 :=
654: ben_ecq_shd.g_old_rec.ecq_attribute13;

Line 654: ben_ecq_shd.g_old_rec.ecq_attribute13;

650: ben_ecq_shd.g_old_rec.ecq_attribute12;
651: End If;
652: If (p_rec.ecq_attribute13 = hr_api.g_varchar2) then
653: p_rec.ecq_attribute13 :=
654: ben_ecq_shd.g_old_rec.ecq_attribute13;
655: End If;
656: If (p_rec.ecq_attribute14 = hr_api.g_varchar2) then
657: p_rec.ecq_attribute14 :=
658: ben_ecq_shd.g_old_rec.ecq_attribute14;

Line 658: ben_ecq_shd.g_old_rec.ecq_attribute14;

654: ben_ecq_shd.g_old_rec.ecq_attribute13;
655: End If;
656: If (p_rec.ecq_attribute14 = hr_api.g_varchar2) then
657: p_rec.ecq_attribute14 :=
658: ben_ecq_shd.g_old_rec.ecq_attribute14;
659: End If;
660: If (p_rec.ecq_attribute15 = hr_api.g_varchar2) then
661: p_rec.ecq_attribute15 :=
662: ben_ecq_shd.g_old_rec.ecq_attribute15;

Line 662: ben_ecq_shd.g_old_rec.ecq_attribute15;

658: ben_ecq_shd.g_old_rec.ecq_attribute14;
659: End If;
660: If (p_rec.ecq_attribute15 = hr_api.g_varchar2) then
661: p_rec.ecq_attribute15 :=
662: ben_ecq_shd.g_old_rec.ecq_attribute15;
663: End If;
664: If (p_rec.ecq_attribute16 = hr_api.g_varchar2) then
665: p_rec.ecq_attribute16 :=
666: ben_ecq_shd.g_old_rec.ecq_attribute16;

Line 666: ben_ecq_shd.g_old_rec.ecq_attribute16;

662: ben_ecq_shd.g_old_rec.ecq_attribute15;
663: End If;
664: If (p_rec.ecq_attribute16 = hr_api.g_varchar2) then
665: p_rec.ecq_attribute16 :=
666: ben_ecq_shd.g_old_rec.ecq_attribute16;
667: End If;
668: If (p_rec.ecq_attribute17 = hr_api.g_varchar2) then
669: p_rec.ecq_attribute17 :=
670: ben_ecq_shd.g_old_rec.ecq_attribute17;

Line 670: ben_ecq_shd.g_old_rec.ecq_attribute17;

666: ben_ecq_shd.g_old_rec.ecq_attribute16;
667: End If;
668: If (p_rec.ecq_attribute17 = hr_api.g_varchar2) then
669: p_rec.ecq_attribute17 :=
670: ben_ecq_shd.g_old_rec.ecq_attribute17;
671: End If;
672: If (p_rec.ecq_attribute18 = hr_api.g_varchar2) then
673: p_rec.ecq_attribute18 :=
674: ben_ecq_shd.g_old_rec.ecq_attribute18;

Line 674: ben_ecq_shd.g_old_rec.ecq_attribute18;

670: ben_ecq_shd.g_old_rec.ecq_attribute17;
671: End If;
672: If (p_rec.ecq_attribute18 = hr_api.g_varchar2) then
673: p_rec.ecq_attribute18 :=
674: ben_ecq_shd.g_old_rec.ecq_attribute18;
675: End If;
676: If (p_rec.ecq_attribute19 = hr_api.g_varchar2) then
677: p_rec.ecq_attribute19 :=
678: ben_ecq_shd.g_old_rec.ecq_attribute19;

Line 678: ben_ecq_shd.g_old_rec.ecq_attribute19;

674: ben_ecq_shd.g_old_rec.ecq_attribute18;
675: End If;
676: If (p_rec.ecq_attribute19 = hr_api.g_varchar2) then
677: p_rec.ecq_attribute19 :=
678: ben_ecq_shd.g_old_rec.ecq_attribute19;
679: End If;
680: If (p_rec.ecq_attribute20 = hr_api.g_varchar2) then
681: p_rec.ecq_attribute20 :=
682: ben_ecq_shd.g_old_rec.ecq_attribute20;

Line 682: ben_ecq_shd.g_old_rec.ecq_attribute20;

678: ben_ecq_shd.g_old_rec.ecq_attribute19;
679: End If;
680: If (p_rec.ecq_attribute20 = hr_api.g_varchar2) then
681: p_rec.ecq_attribute20 :=
682: ben_ecq_shd.g_old_rec.ecq_attribute20;
683: End If;
684: If (p_rec.ecq_attribute21 = hr_api.g_varchar2) then
685: p_rec.ecq_attribute21 :=
686: ben_ecq_shd.g_old_rec.ecq_attribute21;

Line 686: ben_ecq_shd.g_old_rec.ecq_attribute21;

682: ben_ecq_shd.g_old_rec.ecq_attribute20;
683: End If;
684: If (p_rec.ecq_attribute21 = hr_api.g_varchar2) then
685: p_rec.ecq_attribute21 :=
686: ben_ecq_shd.g_old_rec.ecq_attribute21;
687: End If;
688: If (p_rec.ecq_attribute22 = hr_api.g_varchar2) then
689: p_rec.ecq_attribute22 :=
690: ben_ecq_shd.g_old_rec.ecq_attribute22;

Line 690: ben_ecq_shd.g_old_rec.ecq_attribute22;

686: ben_ecq_shd.g_old_rec.ecq_attribute21;
687: End If;
688: If (p_rec.ecq_attribute22 = hr_api.g_varchar2) then
689: p_rec.ecq_attribute22 :=
690: ben_ecq_shd.g_old_rec.ecq_attribute22;
691: End If;
692: If (p_rec.ecq_attribute23 = hr_api.g_varchar2) then
693: p_rec.ecq_attribute23 :=
694: ben_ecq_shd.g_old_rec.ecq_attribute23;

Line 694: ben_ecq_shd.g_old_rec.ecq_attribute23;

690: ben_ecq_shd.g_old_rec.ecq_attribute22;
691: End If;
692: If (p_rec.ecq_attribute23 = hr_api.g_varchar2) then
693: p_rec.ecq_attribute23 :=
694: ben_ecq_shd.g_old_rec.ecq_attribute23;
695: End If;
696: If (p_rec.ecq_attribute24 = hr_api.g_varchar2) then
697: p_rec.ecq_attribute24 :=
698: ben_ecq_shd.g_old_rec.ecq_attribute24;

Line 698: ben_ecq_shd.g_old_rec.ecq_attribute24;

694: ben_ecq_shd.g_old_rec.ecq_attribute23;
695: End If;
696: If (p_rec.ecq_attribute24 = hr_api.g_varchar2) then
697: p_rec.ecq_attribute24 :=
698: ben_ecq_shd.g_old_rec.ecq_attribute24;
699: End If;
700: If (p_rec.ecq_attribute25 = hr_api.g_varchar2) then
701: p_rec.ecq_attribute25 :=
702: ben_ecq_shd.g_old_rec.ecq_attribute25;

Line 702: ben_ecq_shd.g_old_rec.ecq_attribute25;

698: ben_ecq_shd.g_old_rec.ecq_attribute24;
699: End If;
700: If (p_rec.ecq_attribute25 = hr_api.g_varchar2) then
701: p_rec.ecq_attribute25 :=
702: ben_ecq_shd.g_old_rec.ecq_attribute25;
703: End If;
704: If (p_rec.ecq_attribute26 = hr_api.g_varchar2) then
705: p_rec.ecq_attribute26 :=
706: ben_ecq_shd.g_old_rec.ecq_attribute26;

Line 706: ben_ecq_shd.g_old_rec.ecq_attribute26;

702: ben_ecq_shd.g_old_rec.ecq_attribute25;
703: End If;
704: If (p_rec.ecq_attribute26 = hr_api.g_varchar2) then
705: p_rec.ecq_attribute26 :=
706: ben_ecq_shd.g_old_rec.ecq_attribute26;
707: End If;
708: If (p_rec.ecq_attribute27 = hr_api.g_varchar2) then
709: p_rec.ecq_attribute27 :=
710: ben_ecq_shd.g_old_rec.ecq_attribute27;

Line 710: ben_ecq_shd.g_old_rec.ecq_attribute27;

706: ben_ecq_shd.g_old_rec.ecq_attribute26;
707: End If;
708: If (p_rec.ecq_attribute27 = hr_api.g_varchar2) then
709: p_rec.ecq_attribute27 :=
710: ben_ecq_shd.g_old_rec.ecq_attribute27;
711: End If;
712: If (p_rec.ecq_attribute28 = hr_api.g_varchar2) then
713: p_rec.ecq_attribute28 :=
714: ben_ecq_shd.g_old_rec.ecq_attribute28;

Line 714: ben_ecq_shd.g_old_rec.ecq_attribute28;

710: ben_ecq_shd.g_old_rec.ecq_attribute27;
711: End If;
712: If (p_rec.ecq_attribute28 = hr_api.g_varchar2) then
713: p_rec.ecq_attribute28 :=
714: ben_ecq_shd.g_old_rec.ecq_attribute28;
715: End If;
716: If (p_rec.ecq_attribute29 = hr_api.g_varchar2) then
717: p_rec.ecq_attribute29 :=
718: ben_ecq_shd.g_old_rec.ecq_attribute29;

Line 718: ben_ecq_shd.g_old_rec.ecq_attribute29;

714: ben_ecq_shd.g_old_rec.ecq_attribute28;
715: End If;
716: If (p_rec.ecq_attribute29 = hr_api.g_varchar2) then
717: p_rec.ecq_attribute29 :=
718: ben_ecq_shd.g_old_rec.ecq_attribute29;
719: End If;
720: If (p_rec.ecq_attribute30 = hr_api.g_varchar2) then
721: p_rec.ecq_attribute30 :=
722: ben_ecq_shd.g_old_rec.ecq_attribute30;

Line 722: ben_ecq_shd.g_old_rec.ecq_attribute30;

718: ben_ecq_shd.g_old_rec.ecq_attribute29;
719: End If;
720: If (p_rec.ecq_attribute30 = hr_api.g_varchar2) then
721: p_rec.ecq_attribute30 :=
722: ben_ecq_shd.g_old_rec.ecq_attribute30;
723: End If;
724:
725: If (p_rec.criteria_score = hr_api.g_number) then
726: p_rec.criteria_score :=

Line 727: ben_ecq_shd.g_old_rec.criteria_score;

723: End If;
724:
725: If (p_rec.criteria_score = hr_api.g_number) then
726: p_rec.criteria_score :=
727: ben_ecq_shd.g_old_rec.criteria_score;
728: End If;
729:
730:
731: If (p_rec.criteria_weight = hr_api.g_number) then

Line 733: ben_ecq_shd.g_old_rec.criteria_weight;

729:
730:
731: If (p_rec.criteria_weight = hr_api.g_number) then
732: p_rec.criteria_weight :=
733: ben_ecq_shd.g_old_rec.criteria_weight;
734: End If;
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 10);
737: --

Line 745: p_rec in out nocopy ben_ecq_shd.g_rec_type,

741: -- |---------------------------------< upd >----------------------------------|
742: -- ----------------------------------------------------------------------------
743: Procedure upd
744: (
745: p_rec in out nocopy ben_ecq_shd.g_rec_type,
746: p_effective_date in date,
747: p_datetrack_mode in varchar2
748: ) is
749: --

Line 763: ben_ecq_shd.lck

759: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
760: --
761: -- We must lock the row which we need to update.
762: --
763: ben_ecq_shd.lck
764: (p_effective_date => p_effective_date,
765: p_datetrack_mode => p_datetrack_mode,
766: p_elig_cbr_quald_bnf_id => p_rec.elig_cbr_quald_bnf_id,
767: p_object_version_number => p_rec.object_version_number,

Line 865: l_rec ben_ecq_shd.g_rec_type;

861: p_criteria_score in number default hr_api.g_number,
862: p_criteria_weight in number default hr_api.g_number
863: ) is
864: --
865: l_rec ben_ecq_shd.g_rec_type;
866: l_proc varchar2(72) := g_package||'upd';
867: --
868: Begin
869: hr_utility.set_location('Entering:'||l_proc, 5);

Line 875: ben_ecq_shd.convert_args

871: -- Call conversion function to turn arguments into the
872: -- l_rec structure.
873: --
874: l_rec :=
875: ben_ecq_shd.convert_args
876: (
877: p_elig_cbr_quald_bnf_id,
878: null,
879: null,