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_CQR_UPD dependencies on BEN_CQR_SHD

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

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

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

Line 130: ben_cqr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 142: ben_cqr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 143: ben_cqr_shd.constraint_error

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

Line 147: ben_cqr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 148: ben_cqr_shd.constraint_error

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

Line 151: ben_cqr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 187: (p_rec in out nocopy ben_cqr_shd.g_rec_type,

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

Line 251: (p_rec in out nocopy ben_cqr_shd.g_rec_type,

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

Line 267: ben_cqr_shd.upd_effective_end_date

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

Line 336: (p_rec in out nocopy ben_cqr_shd.g_rec_type,

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

Line 392: (p_rec in ben_cqr_shd.g_rec_type,

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

Line 455: ,p_effective_start_date_o =>ben_cqr_shd.g_old_rec.effective_start_date

451: ,p_effective_date =>p_effective_date
452: ,p_datetrack_mode =>p_datetrack_mode
453: ,p_validation_start_date =>p_validation_start_date
454: ,p_validation_end_date =>p_validation_end_date
455: ,p_effective_start_date_o =>ben_cqr_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_cqr_shd.g_old_rec.effective_end_date
457: ,p_quald_bnf_flag_o =>ben_cqr_shd.g_old_rec.quald_bnf_flag
458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num
459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id

Line 456: ,p_effective_end_date_o =>ben_cqr_shd.g_old_rec.effective_end_date

452: ,p_datetrack_mode =>p_datetrack_mode
453: ,p_validation_start_date =>p_validation_start_date
454: ,p_validation_end_date =>p_validation_end_date
455: ,p_effective_start_date_o =>ben_cqr_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_cqr_shd.g_old_rec.effective_end_date
457: ,p_quald_bnf_flag_o =>ben_cqr_shd.g_old_rec.quald_bnf_flag
458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num
459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id
460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id

Line 457: ,p_quald_bnf_flag_o =>ben_cqr_shd.g_old_rec.quald_bnf_flag

453: ,p_validation_start_date =>p_validation_start_date
454: ,p_validation_end_date =>p_validation_end_date
455: ,p_effective_start_date_o =>ben_cqr_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_cqr_shd.g_old_rec.effective_end_date
457: ,p_quald_bnf_flag_o =>ben_cqr_shd.g_old_rec.quald_bnf_flag
458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num
459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id
460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id
461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id

Line 458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num

454: ,p_validation_end_date =>p_validation_end_date
455: ,p_effective_start_date_o =>ben_cqr_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_cqr_shd.g_old_rec.effective_end_date
457: ,p_quald_bnf_flag_o =>ben_cqr_shd.g_old_rec.quald_bnf_flag
458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num
459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id
460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id
461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id
462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id

Line 459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id

455: ,p_effective_start_date_o =>ben_cqr_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_cqr_shd.g_old_rec.effective_end_date
457: ,p_quald_bnf_flag_o =>ben_cqr_shd.g_old_rec.quald_bnf_flag
458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num
459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id
460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id
461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id
462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id
463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category

Line 460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id

456: ,p_effective_end_date_o =>ben_cqr_shd.g_old_rec.effective_end_date
457: ,p_quald_bnf_flag_o =>ben_cqr_shd.g_old_rec.quald_bnf_flag
458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num
459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id
460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id
461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id
462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id
463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category
464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1

Line 461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id

457: ,p_quald_bnf_flag_o =>ben_cqr_shd.g_old_rec.quald_bnf_flag
458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num
459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id
460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id
461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id
462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id
463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category
464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1
465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2

Line 462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id

458: ,p_ordr_num_o =>ben_cqr_shd.g_old_rec.ordr_num
459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id
460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id
461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id
462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id
463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category
464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1
465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2
466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3

Line 463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category

459: ,p_vrbl_rt_prfl_id_o =>ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id
460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id
461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id
462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id
463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category
464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1
465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2
466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3
467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4

Line 464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1

460: ,p_pgm_id_o =>ben_cqr_shd.g_old_rec.pgm_id
461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id
462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id
463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category
464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1
465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2
466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3
467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4
468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5

Line 465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2

461: ,p_ptip_id_o =>ben_cqr_shd.g_old_rec.ptip_id
462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id
463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category
464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1
465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2
466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3
467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4
468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5
469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6

Line 466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3

462: ,p_business_group_id_o =>ben_cqr_shd.g_old_rec.business_group_id
463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category
464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1
465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2
466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3
467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4
468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5
469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6
470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7

Line 467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4

463: ,p_cqr_attribute_category_o =>ben_cqr_shd.g_old_rec.cqr_attribute_category
464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1
465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2
466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3
467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4
468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5
469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6
470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7
471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8

Line 468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5

464: ,p_cqr_attribute1_o =>ben_cqr_shd.g_old_rec.cqr_attribute1
465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2
466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3
467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4
468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5
469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6
470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7
471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8
472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9

Line 469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6

465: ,p_cqr_attribute2_o =>ben_cqr_shd.g_old_rec.cqr_attribute2
466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3
467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4
468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5
469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6
470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7
471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8
472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9
473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10

Line 470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7

466: ,p_cqr_attribute3_o =>ben_cqr_shd.g_old_rec.cqr_attribute3
467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4
468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5
469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6
470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7
471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8
472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9
473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10
474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11

Line 471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8

467: ,p_cqr_attribute4_o =>ben_cqr_shd.g_old_rec.cqr_attribute4
468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5
469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6
470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7
471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8
472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9
473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10
474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11
475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12

Line 472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9

468: ,p_cqr_attribute5_o =>ben_cqr_shd.g_old_rec.cqr_attribute5
469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6
470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7
471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8
472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9
473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10
474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11
475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12
476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13

Line 473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10

469: ,p_cqr_attribute6_o =>ben_cqr_shd.g_old_rec.cqr_attribute6
470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7
471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8
472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9
473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10
474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11
475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12
476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13
477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14

Line 474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11

470: ,p_cqr_attribute7_o =>ben_cqr_shd.g_old_rec.cqr_attribute7
471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8
472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9
473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10
474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11
475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12
476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13
477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14
478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15

Line 475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12

471: ,p_cqr_attribute8_o =>ben_cqr_shd.g_old_rec.cqr_attribute8
472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9
473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10
474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11
475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12
476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13
477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14
478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15
479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16

Line 476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13

472: ,p_cqr_attribute9_o =>ben_cqr_shd.g_old_rec.cqr_attribute9
473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10
474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11
475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12
476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13
477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14
478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15
479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16
480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17

Line 477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14

473: ,p_cqr_attribute10_o =>ben_cqr_shd.g_old_rec.cqr_attribute10
474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11
475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12
476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13
477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14
478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15
479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16
480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17
481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18

Line 478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15

474: ,p_cqr_attribute11_o =>ben_cqr_shd.g_old_rec.cqr_attribute11
475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12
476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13
477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14
478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15
479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16
480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17
481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18
482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19

Line 479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16

475: ,p_cqr_attribute12_o =>ben_cqr_shd.g_old_rec.cqr_attribute12
476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13
477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14
478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15
479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16
480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17
481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18
482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19
483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20

Line 480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17

476: ,p_cqr_attribute13_o =>ben_cqr_shd.g_old_rec.cqr_attribute13
477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14
478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15
479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16
480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17
481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18
482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19
483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20
484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21

Line 481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18

477: ,p_cqr_attribute14_o =>ben_cqr_shd.g_old_rec.cqr_attribute14
478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15
479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16
480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17
481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18
482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19
483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20
484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21
485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22

Line 482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19

478: ,p_cqr_attribute15_o =>ben_cqr_shd.g_old_rec.cqr_attribute15
479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16
480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17
481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18
482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19
483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20
484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21
485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22
486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23

Line 483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20

479: ,p_cqr_attribute16_o =>ben_cqr_shd.g_old_rec.cqr_attribute16
480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17
481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18
482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19
483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20
484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21
485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22
486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23
487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24

Line 484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21

480: ,p_cqr_attribute17_o =>ben_cqr_shd.g_old_rec.cqr_attribute17
481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18
482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19
483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20
484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21
485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22
486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23
487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24
488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25

Line 485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22

481: ,p_cqr_attribute18_o =>ben_cqr_shd.g_old_rec.cqr_attribute18
482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19
483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20
484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21
485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22
486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23
487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24
488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25
489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26

Line 486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23

482: ,p_cqr_attribute19_o =>ben_cqr_shd.g_old_rec.cqr_attribute19
483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20
484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21
485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22
486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23
487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24
488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25
489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26
490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27

Line 487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24

483: ,p_cqr_attribute20_o =>ben_cqr_shd.g_old_rec.cqr_attribute20
484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21
485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22
486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23
487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24
488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25
489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26
490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27
491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28

Line 488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25

484: ,p_cqr_attribute21_o =>ben_cqr_shd.g_old_rec.cqr_attribute21
485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22
486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23
487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24
488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25
489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26
490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27
491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28
492: ,p_cqr_attribute29_o =>ben_cqr_shd.g_old_rec.cqr_attribute29

Line 489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26

485: ,p_cqr_attribute22_o =>ben_cqr_shd.g_old_rec.cqr_attribute22
486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23
487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24
488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25
489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26
490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27
491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28
492: ,p_cqr_attribute29_o =>ben_cqr_shd.g_old_rec.cqr_attribute29
493: ,p_cqr_attribute30_o =>ben_cqr_shd.g_old_rec.cqr_attribute30

Line 490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27

486: ,p_cqr_attribute23_o =>ben_cqr_shd.g_old_rec.cqr_attribute23
487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24
488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25
489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26
490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27
491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28
492: ,p_cqr_attribute29_o =>ben_cqr_shd.g_old_rec.cqr_attribute29
493: ,p_cqr_attribute30_o =>ben_cqr_shd.g_old_rec.cqr_attribute30
494: ,p_object_version_number_o =>ben_cqr_shd.g_old_rec.object_version_number

Line 491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28

487: ,p_cqr_attribute24_o =>ben_cqr_shd.g_old_rec.cqr_attribute24
488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25
489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26
490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27
491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28
492: ,p_cqr_attribute29_o =>ben_cqr_shd.g_old_rec.cqr_attribute29
493: ,p_cqr_attribute30_o =>ben_cqr_shd.g_old_rec.cqr_attribute30
494: ,p_object_version_number_o =>ben_cqr_shd.g_old_rec.object_version_number
495: );

Line 492: ,p_cqr_attribute29_o =>ben_cqr_shd.g_old_rec.cqr_attribute29

488: ,p_cqr_attribute25_o =>ben_cqr_shd.g_old_rec.cqr_attribute25
489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26
490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27
491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28
492: ,p_cqr_attribute29_o =>ben_cqr_shd.g_old_rec.cqr_attribute29
493: ,p_cqr_attribute30_o =>ben_cqr_shd.g_old_rec.cqr_attribute30
494: ,p_object_version_number_o =>ben_cqr_shd.g_old_rec.object_version_number
495: );
496: --

Line 493: ,p_cqr_attribute30_o =>ben_cqr_shd.g_old_rec.cqr_attribute30

489: ,p_cqr_attribute26_o =>ben_cqr_shd.g_old_rec.cqr_attribute26
490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27
491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28
492: ,p_cqr_attribute29_o =>ben_cqr_shd.g_old_rec.cqr_attribute29
493: ,p_cqr_attribute30_o =>ben_cqr_shd.g_old_rec.cqr_attribute30
494: ,p_object_version_number_o =>ben_cqr_shd.g_old_rec.object_version_number
495: );
496: --
497: exception

Line 494: ,p_object_version_number_o =>ben_cqr_shd.g_old_rec.object_version_number

490: ,p_cqr_attribute27_o =>ben_cqr_shd.g_old_rec.cqr_attribute27
491: ,p_cqr_attribute28_o =>ben_cqr_shd.g_old_rec.cqr_attribute28
492: ,p_cqr_attribute29_o =>ben_cqr_shd.g_old_rec.cqr_attribute29
493: ,p_cqr_attribute30_o =>ben_cqr_shd.g_old_rec.cqr_attribute30
494: ,p_object_version_number_o =>ben_cqr_shd.g_old_rec.object_version_number
495: );
496: --
497: exception
498: --

Line 556: Procedure convert_defs(p_rec in out nocopy ben_cqr_shd.g_rec_type) is

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

Line 571: ben_cqr_shd.g_old_rec.quald_bnf_flag;

567: -- is being used then we must set to the 'current' argument value.
568: --
569: If (p_rec.quald_bnf_flag = hr_api.g_varchar2) then
570: p_rec.quald_bnf_flag :=
571: ben_cqr_shd.g_old_rec.quald_bnf_flag;
572: End If;
573: If (p_rec.ordr_num = hr_api.g_number) then
574: p_rec.ordr_num :=
575: ben_cqr_shd.g_old_rec.ordr_num;

Line 575: ben_cqr_shd.g_old_rec.ordr_num;

571: ben_cqr_shd.g_old_rec.quald_bnf_flag;
572: End If;
573: If (p_rec.ordr_num = hr_api.g_number) then
574: p_rec.ordr_num :=
575: ben_cqr_shd.g_old_rec.ordr_num;
576: End If;
577: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
578: p_rec.vrbl_rt_prfl_id :=
579: ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id;

Line 579: ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id;

575: ben_cqr_shd.g_old_rec.ordr_num;
576: End If;
577: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
578: p_rec.vrbl_rt_prfl_id :=
579: ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id;
580: End If;
581: If (p_rec.pgm_id = hr_api.g_number) then
582: p_rec.pgm_id :=
583: ben_cqr_shd.g_old_rec.pgm_id;

Line 583: ben_cqr_shd.g_old_rec.pgm_id;

579: ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id;
580: End If;
581: If (p_rec.pgm_id = hr_api.g_number) then
582: p_rec.pgm_id :=
583: ben_cqr_shd.g_old_rec.pgm_id;
584: End If;
585: If (p_rec.ptip_id = hr_api.g_number) then
586: p_rec.ptip_id :=
587: ben_cqr_shd.g_old_rec.ptip_id;

Line 587: ben_cqr_shd.g_old_rec.ptip_id;

583: ben_cqr_shd.g_old_rec.pgm_id;
584: End If;
585: If (p_rec.ptip_id = hr_api.g_number) then
586: p_rec.ptip_id :=
587: ben_cqr_shd.g_old_rec.ptip_id;
588: End If;
589: If (p_rec.business_group_id = hr_api.g_number) then
590: p_rec.business_group_id :=
591: ben_cqr_shd.g_old_rec.business_group_id;

Line 591: ben_cqr_shd.g_old_rec.business_group_id;

587: ben_cqr_shd.g_old_rec.ptip_id;
588: End If;
589: If (p_rec.business_group_id = hr_api.g_number) then
590: p_rec.business_group_id :=
591: ben_cqr_shd.g_old_rec.business_group_id;
592: End If;
593: If (p_rec.cqr_attribute_category = hr_api.g_varchar2) then
594: p_rec.cqr_attribute_category :=
595: ben_cqr_shd.g_old_rec.cqr_attribute_category;

Line 595: ben_cqr_shd.g_old_rec.cqr_attribute_category;

591: ben_cqr_shd.g_old_rec.business_group_id;
592: End If;
593: If (p_rec.cqr_attribute_category = hr_api.g_varchar2) then
594: p_rec.cqr_attribute_category :=
595: ben_cqr_shd.g_old_rec.cqr_attribute_category;
596: End If;
597: If (p_rec.cqr_attribute1 = hr_api.g_varchar2) then
598: p_rec.cqr_attribute1 :=
599: ben_cqr_shd.g_old_rec.cqr_attribute1;

Line 599: ben_cqr_shd.g_old_rec.cqr_attribute1;

595: ben_cqr_shd.g_old_rec.cqr_attribute_category;
596: End If;
597: If (p_rec.cqr_attribute1 = hr_api.g_varchar2) then
598: p_rec.cqr_attribute1 :=
599: ben_cqr_shd.g_old_rec.cqr_attribute1;
600: End If;
601: If (p_rec.cqr_attribute2 = hr_api.g_varchar2) then
602: p_rec.cqr_attribute2 :=
603: ben_cqr_shd.g_old_rec.cqr_attribute2;

Line 603: ben_cqr_shd.g_old_rec.cqr_attribute2;

599: ben_cqr_shd.g_old_rec.cqr_attribute1;
600: End If;
601: If (p_rec.cqr_attribute2 = hr_api.g_varchar2) then
602: p_rec.cqr_attribute2 :=
603: ben_cqr_shd.g_old_rec.cqr_attribute2;
604: End If;
605: If (p_rec.cqr_attribute3 = hr_api.g_varchar2) then
606: p_rec.cqr_attribute3 :=
607: ben_cqr_shd.g_old_rec.cqr_attribute3;

Line 607: ben_cqr_shd.g_old_rec.cqr_attribute3;

603: ben_cqr_shd.g_old_rec.cqr_attribute2;
604: End If;
605: If (p_rec.cqr_attribute3 = hr_api.g_varchar2) then
606: p_rec.cqr_attribute3 :=
607: ben_cqr_shd.g_old_rec.cqr_attribute3;
608: End If;
609: If (p_rec.cqr_attribute4 = hr_api.g_varchar2) then
610: p_rec.cqr_attribute4 :=
611: ben_cqr_shd.g_old_rec.cqr_attribute4;

Line 611: ben_cqr_shd.g_old_rec.cqr_attribute4;

607: ben_cqr_shd.g_old_rec.cqr_attribute3;
608: End If;
609: If (p_rec.cqr_attribute4 = hr_api.g_varchar2) then
610: p_rec.cqr_attribute4 :=
611: ben_cqr_shd.g_old_rec.cqr_attribute4;
612: End If;
613: If (p_rec.cqr_attribute5 = hr_api.g_varchar2) then
614: p_rec.cqr_attribute5 :=
615: ben_cqr_shd.g_old_rec.cqr_attribute5;

Line 615: ben_cqr_shd.g_old_rec.cqr_attribute5;

611: ben_cqr_shd.g_old_rec.cqr_attribute4;
612: End If;
613: If (p_rec.cqr_attribute5 = hr_api.g_varchar2) then
614: p_rec.cqr_attribute5 :=
615: ben_cqr_shd.g_old_rec.cqr_attribute5;
616: End If;
617: If (p_rec.cqr_attribute6 = hr_api.g_varchar2) then
618: p_rec.cqr_attribute6 :=
619: ben_cqr_shd.g_old_rec.cqr_attribute6;

Line 619: ben_cqr_shd.g_old_rec.cqr_attribute6;

615: ben_cqr_shd.g_old_rec.cqr_attribute5;
616: End If;
617: If (p_rec.cqr_attribute6 = hr_api.g_varchar2) then
618: p_rec.cqr_attribute6 :=
619: ben_cqr_shd.g_old_rec.cqr_attribute6;
620: End If;
621: If (p_rec.cqr_attribute7 = hr_api.g_varchar2) then
622: p_rec.cqr_attribute7 :=
623: ben_cqr_shd.g_old_rec.cqr_attribute7;

Line 623: ben_cqr_shd.g_old_rec.cqr_attribute7;

619: ben_cqr_shd.g_old_rec.cqr_attribute6;
620: End If;
621: If (p_rec.cqr_attribute7 = hr_api.g_varchar2) then
622: p_rec.cqr_attribute7 :=
623: ben_cqr_shd.g_old_rec.cqr_attribute7;
624: End If;
625: If (p_rec.cqr_attribute8 = hr_api.g_varchar2) then
626: p_rec.cqr_attribute8 :=
627: ben_cqr_shd.g_old_rec.cqr_attribute8;

Line 627: ben_cqr_shd.g_old_rec.cqr_attribute8;

623: ben_cqr_shd.g_old_rec.cqr_attribute7;
624: End If;
625: If (p_rec.cqr_attribute8 = hr_api.g_varchar2) then
626: p_rec.cqr_attribute8 :=
627: ben_cqr_shd.g_old_rec.cqr_attribute8;
628: End If;
629: If (p_rec.cqr_attribute9 = hr_api.g_varchar2) then
630: p_rec.cqr_attribute9 :=
631: ben_cqr_shd.g_old_rec.cqr_attribute9;

Line 631: ben_cqr_shd.g_old_rec.cqr_attribute9;

627: ben_cqr_shd.g_old_rec.cqr_attribute8;
628: End If;
629: If (p_rec.cqr_attribute9 = hr_api.g_varchar2) then
630: p_rec.cqr_attribute9 :=
631: ben_cqr_shd.g_old_rec.cqr_attribute9;
632: End If;
633: If (p_rec.cqr_attribute10 = hr_api.g_varchar2) then
634: p_rec.cqr_attribute10 :=
635: ben_cqr_shd.g_old_rec.cqr_attribute10;

Line 635: ben_cqr_shd.g_old_rec.cqr_attribute10;

631: ben_cqr_shd.g_old_rec.cqr_attribute9;
632: End If;
633: If (p_rec.cqr_attribute10 = hr_api.g_varchar2) then
634: p_rec.cqr_attribute10 :=
635: ben_cqr_shd.g_old_rec.cqr_attribute10;
636: End If;
637: If (p_rec.cqr_attribute11 = hr_api.g_varchar2) then
638: p_rec.cqr_attribute11 :=
639: ben_cqr_shd.g_old_rec.cqr_attribute11;

Line 639: ben_cqr_shd.g_old_rec.cqr_attribute11;

635: ben_cqr_shd.g_old_rec.cqr_attribute10;
636: End If;
637: If (p_rec.cqr_attribute11 = hr_api.g_varchar2) then
638: p_rec.cqr_attribute11 :=
639: ben_cqr_shd.g_old_rec.cqr_attribute11;
640: End If;
641: If (p_rec.cqr_attribute12 = hr_api.g_varchar2) then
642: p_rec.cqr_attribute12 :=
643: ben_cqr_shd.g_old_rec.cqr_attribute12;

Line 643: ben_cqr_shd.g_old_rec.cqr_attribute12;

639: ben_cqr_shd.g_old_rec.cqr_attribute11;
640: End If;
641: If (p_rec.cqr_attribute12 = hr_api.g_varchar2) then
642: p_rec.cqr_attribute12 :=
643: ben_cqr_shd.g_old_rec.cqr_attribute12;
644: End If;
645: If (p_rec.cqr_attribute13 = hr_api.g_varchar2) then
646: p_rec.cqr_attribute13 :=
647: ben_cqr_shd.g_old_rec.cqr_attribute13;

Line 647: ben_cqr_shd.g_old_rec.cqr_attribute13;

643: ben_cqr_shd.g_old_rec.cqr_attribute12;
644: End If;
645: If (p_rec.cqr_attribute13 = hr_api.g_varchar2) then
646: p_rec.cqr_attribute13 :=
647: ben_cqr_shd.g_old_rec.cqr_attribute13;
648: End If;
649: If (p_rec.cqr_attribute14 = hr_api.g_varchar2) then
650: p_rec.cqr_attribute14 :=
651: ben_cqr_shd.g_old_rec.cqr_attribute14;

Line 651: ben_cqr_shd.g_old_rec.cqr_attribute14;

647: ben_cqr_shd.g_old_rec.cqr_attribute13;
648: End If;
649: If (p_rec.cqr_attribute14 = hr_api.g_varchar2) then
650: p_rec.cqr_attribute14 :=
651: ben_cqr_shd.g_old_rec.cqr_attribute14;
652: End If;
653: If (p_rec.cqr_attribute15 = hr_api.g_varchar2) then
654: p_rec.cqr_attribute15 :=
655: ben_cqr_shd.g_old_rec.cqr_attribute15;

Line 655: ben_cqr_shd.g_old_rec.cqr_attribute15;

651: ben_cqr_shd.g_old_rec.cqr_attribute14;
652: End If;
653: If (p_rec.cqr_attribute15 = hr_api.g_varchar2) then
654: p_rec.cqr_attribute15 :=
655: ben_cqr_shd.g_old_rec.cqr_attribute15;
656: End If;
657: If (p_rec.cqr_attribute16 = hr_api.g_varchar2) then
658: p_rec.cqr_attribute16 :=
659: ben_cqr_shd.g_old_rec.cqr_attribute16;

Line 659: ben_cqr_shd.g_old_rec.cqr_attribute16;

655: ben_cqr_shd.g_old_rec.cqr_attribute15;
656: End If;
657: If (p_rec.cqr_attribute16 = hr_api.g_varchar2) then
658: p_rec.cqr_attribute16 :=
659: ben_cqr_shd.g_old_rec.cqr_attribute16;
660: End If;
661: If (p_rec.cqr_attribute17 = hr_api.g_varchar2) then
662: p_rec.cqr_attribute17 :=
663: ben_cqr_shd.g_old_rec.cqr_attribute17;

Line 663: ben_cqr_shd.g_old_rec.cqr_attribute17;

659: ben_cqr_shd.g_old_rec.cqr_attribute16;
660: End If;
661: If (p_rec.cqr_attribute17 = hr_api.g_varchar2) then
662: p_rec.cqr_attribute17 :=
663: ben_cqr_shd.g_old_rec.cqr_attribute17;
664: End If;
665: If (p_rec.cqr_attribute18 = hr_api.g_varchar2) then
666: p_rec.cqr_attribute18 :=
667: ben_cqr_shd.g_old_rec.cqr_attribute18;

Line 667: ben_cqr_shd.g_old_rec.cqr_attribute18;

663: ben_cqr_shd.g_old_rec.cqr_attribute17;
664: End If;
665: If (p_rec.cqr_attribute18 = hr_api.g_varchar2) then
666: p_rec.cqr_attribute18 :=
667: ben_cqr_shd.g_old_rec.cqr_attribute18;
668: End If;
669: If (p_rec.cqr_attribute19 = hr_api.g_varchar2) then
670: p_rec.cqr_attribute19 :=
671: ben_cqr_shd.g_old_rec.cqr_attribute19;

Line 671: ben_cqr_shd.g_old_rec.cqr_attribute19;

667: ben_cqr_shd.g_old_rec.cqr_attribute18;
668: End If;
669: If (p_rec.cqr_attribute19 = hr_api.g_varchar2) then
670: p_rec.cqr_attribute19 :=
671: ben_cqr_shd.g_old_rec.cqr_attribute19;
672: End If;
673: If (p_rec.cqr_attribute20 = hr_api.g_varchar2) then
674: p_rec.cqr_attribute20 :=
675: ben_cqr_shd.g_old_rec.cqr_attribute20;

Line 675: ben_cqr_shd.g_old_rec.cqr_attribute20;

671: ben_cqr_shd.g_old_rec.cqr_attribute19;
672: End If;
673: If (p_rec.cqr_attribute20 = hr_api.g_varchar2) then
674: p_rec.cqr_attribute20 :=
675: ben_cqr_shd.g_old_rec.cqr_attribute20;
676: End If;
677: If (p_rec.cqr_attribute21 = hr_api.g_varchar2) then
678: p_rec.cqr_attribute21 :=
679: ben_cqr_shd.g_old_rec.cqr_attribute21;

Line 679: ben_cqr_shd.g_old_rec.cqr_attribute21;

675: ben_cqr_shd.g_old_rec.cqr_attribute20;
676: End If;
677: If (p_rec.cqr_attribute21 = hr_api.g_varchar2) then
678: p_rec.cqr_attribute21 :=
679: ben_cqr_shd.g_old_rec.cqr_attribute21;
680: End If;
681: If (p_rec.cqr_attribute22 = hr_api.g_varchar2) then
682: p_rec.cqr_attribute22 :=
683: ben_cqr_shd.g_old_rec.cqr_attribute22;

Line 683: ben_cqr_shd.g_old_rec.cqr_attribute22;

679: ben_cqr_shd.g_old_rec.cqr_attribute21;
680: End If;
681: If (p_rec.cqr_attribute22 = hr_api.g_varchar2) then
682: p_rec.cqr_attribute22 :=
683: ben_cqr_shd.g_old_rec.cqr_attribute22;
684: End If;
685: If (p_rec.cqr_attribute23 = hr_api.g_varchar2) then
686: p_rec.cqr_attribute23 :=
687: ben_cqr_shd.g_old_rec.cqr_attribute23;

Line 687: ben_cqr_shd.g_old_rec.cqr_attribute23;

683: ben_cqr_shd.g_old_rec.cqr_attribute22;
684: End If;
685: If (p_rec.cqr_attribute23 = hr_api.g_varchar2) then
686: p_rec.cqr_attribute23 :=
687: ben_cqr_shd.g_old_rec.cqr_attribute23;
688: End If;
689: If (p_rec.cqr_attribute24 = hr_api.g_varchar2) then
690: p_rec.cqr_attribute24 :=
691: ben_cqr_shd.g_old_rec.cqr_attribute24;

Line 691: ben_cqr_shd.g_old_rec.cqr_attribute24;

687: ben_cqr_shd.g_old_rec.cqr_attribute23;
688: End If;
689: If (p_rec.cqr_attribute24 = hr_api.g_varchar2) then
690: p_rec.cqr_attribute24 :=
691: ben_cqr_shd.g_old_rec.cqr_attribute24;
692: End If;
693: If (p_rec.cqr_attribute25 = hr_api.g_varchar2) then
694: p_rec.cqr_attribute25 :=
695: ben_cqr_shd.g_old_rec.cqr_attribute25;

Line 695: ben_cqr_shd.g_old_rec.cqr_attribute25;

691: ben_cqr_shd.g_old_rec.cqr_attribute24;
692: End If;
693: If (p_rec.cqr_attribute25 = hr_api.g_varchar2) then
694: p_rec.cqr_attribute25 :=
695: ben_cqr_shd.g_old_rec.cqr_attribute25;
696: End If;
697: If (p_rec.cqr_attribute26 = hr_api.g_varchar2) then
698: p_rec.cqr_attribute26 :=
699: ben_cqr_shd.g_old_rec.cqr_attribute26;

Line 699: ben_cqr_shd.g_old_rec.cqr_attribute26;

695: ben_cqr_shd.g_old_rec.cqr_attribute25;
696: End If;
697: If (p_rec.cqr_attribute26 = hr_api.g_varchar2) then
698: p_rec.cqr_attribute26 :=
699: ben_cqr_shd.g_old_rec.cqr_attribute26;
700: End If;
701: If (p_rec.cqr_attribute27 = hr_api.g_varchar2) then
702: p_rec.cqr_attribute27 :=
703: ben_cqr_shd.g_old_rec.cqr_attribute27;

Line 703: ben_cqr_shd.g_old_rec.cqr_attribute27;

699: ben_cqr_shd.g_old_rec.cqr_attribute26;
700: End If;
701: If (p_rec.cqr_attribute27 = hr_api.g_varchar2) then
702: p_rec.cqr_attribute27 :=
703: ben_cqr_shd.g_old_rec.cqr_attribute27;
704: End If;
705: If (p_rec.cqr_attribute28 = hr_api.g_varchar2) then
706: p_rec.cqr_attribute28 :=
707: ben_cqr_shd.g_old_rec.cqr_attribute28;

Line 707: ben_cqr_shd.g_old_rec.cqr_attribute28;

703: ben_cqr_shd.g_old_rec.cqr_attribute27;
704: End If;
705: If (p_rec.cqr_attribute28 = hr_api.g_varchar2) then
706: p_rec.cqr_attribute28 :=
707: ben_cqr_shd.g_old_rec.cqr_attribute28;
708: End If;
709: If (p_rec.cqr_attribute29 = hr_api.g_varchar2) then
710: p_rec.cqr_attribute29 :=
711: ben_cqr_shd.g_old_rec.cqr_attribute29;

Line 711: ben_cqr_shd.g_old_rec.cqr_attribute29;

707: ben_cqr_shd.g_old_rec.cqr_attribute28;
708: End If;
709: If (p_rec.cqr_attribute29 = hr_api.g_varchar2) then
710: p_rec.cqr_attribute29 :=
711: ben_cqr_shd.g_old_rec.cqr_attribute29;
712: End If;
713: If (p_rec.cqr_attribute30 = hr_api.g_varchar2) then
714: p_rec.cqr_attribute30 :=
715: ben_cqr_shd.g_old_rec.cqr_attribute30;

Line 715: ben_cqr_shd.g_old_rec.cqr_attribute30;

711: ben_cqr_shd.g_old_rec.cqr_attribute29;
712: End If;
713: If (p_rec.cqr_attribute30 = hr_api.g_varchar2) then
714: p_rec.cqr_attribute30 :=
715: ben_cqr_shd.g_old_rec.cqr_attribute30;
716: End If;
717:
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 728: p_rec in out nocopy ben_cqr_shd.g_rec_type,

724: -- |---------------------------------< upd >----------------------------------|
725: -- ----------------------------------------------------------------------------
726: Procedure upd
727: (
728: p_rec in out nocopy ben_cqr_shd.g_rec_type,
729: p_effective_date in date,
730: p_datetrack_mode in varchar2
731: ) is
732: --

Line 746: ben_cqr_shd.lck

742: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
743: --
744: -- We must lock the row which we need to update.
745: --
746: ben_cqr_shd.lck
747: (p_effective_date => p_effective_date,
748: p_datetrack_mode => p_datetrack_mode,
749: p_cbr_quald_bnf_rt_id => p_rec.cbr_quald_bnf_rt_id,
750: p_object_version_number => p_rec.object_version_number,

Line 846: l_rec ben_cqr_shd.g_rec_type;

842: p_effective_date in date,
843: p_datetrack_mode in varchar2
844: ) is
845: --
846: l_rec ben_cqr_shd.g_rec_type;
847: l_proc varchar2(72) := g_package||'upd';
848: --
849: Begin
850: hr_utility.set_location('Entering:'||l_proc, 5);

Line 856: ben_cqr_shd.convert_args

852: -- Call conversion function to turn arguments into the
853: -- l_rec structure.
854: --
855: l_rec :=
856: ben_cqr_shd.convert_args
857: (
858: p_cbr_quald_bnf_rt_id,
859: null,
860: null,