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_PQC_UPD dependencies on BEN_PQC_SHD

Line 58: (p_rec in out nocopy ben_pqc_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_pqc_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

Line 83: ben_pqc_shd.g_api_dml := true; -- Set the api dml status

79: ,p_base_key_column => 'prtt_rmt_rqst_ctfn_prvdd_id'
80: ,p_base_key_value => p_rec.prtt_rmt_rqst_ctfn_prvdd_id
81: );
82: --
83: ben_pqc_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the ben_prtt_rmt_rqst_ctfn_prvdd_f Row
86: --
87: update ben_prtt_rmt_rqst_ctfn_prvdd_f

Line 134: ben_pqc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 146: ben_pqc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 147: ben_pqc_shd.constraint_error

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

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

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

Line 152: ben_pqc_shd.constraint_error

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

Line 155: ben_pqc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 191: (p_rec in out nocopy ben_pqc_shd.g_rec_type

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

Line 258: (p_rec in out nocopy ben_pqc_shd.g_rec_type

254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure dt_pre_update
258: (p_rec in out nocopy ben_pqc_shd.g_rec_type
259: ,p_effective_date in date
260: ,p_datetrack_mode in varchar2
261: ,p_validation_start_date in date
262: ,p_validation_end_date in date

Line 274: ben_pqc_shd.upd_effective_end_date

270: If (p_datetrack_mode <> hr_api.g_correction) then
271: --
272: -- Update the current effective end date
273: --
274: ben_pqc_shd.upd_effective_end_date
275: (p_effective_date => p_effective_date
276: ,p_base_key_value => p_rec.prtt_rmt_rqst_ctfn_prvdd_id
277: ,p_new_effective_end_date => (p_validation_start_date - 1)
278: ,p_validation_start_date => p_validation_start_date

Line 343: (p_rec in out nocopy ben_pqc_shd.g_rec_type

339: --
340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure pre_update
343: (p_rec in out nocopy ben_pqc_shd.g_rec_type
344: ,p_effective_date in date
345: ,p_datetrack_mode in varchar2
346: ,p_validation_start_date in date
347: ,p_validation_end_date in date

Line 401: (p_rec in ben_pqc_shd.g_rec_type

397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure post_update
401: (p_rec in ben_pqc_shd.g_rec_type
402: ,p_effective_date in date
403: ,p_datetrack_mode in varchar2
404: ,p_validation_start_date in date
405: ,p_validation_end_date in date

Line 510: => ben_pqc_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id

506: => p_rec.pqc_attribute30
507: ,p_object_version_number
508: => p_rec.object_version_number
509: ,p_prtt_clm_gd_or_svc_typ_id_o
510: => ben_pqc_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id
511: ,p_pl_gd_r_svc_ctfn_id_o
512: => ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id
513: ,p_effective_start_date_o
514: => ben_pqc_shd.g_old_rec.effective_start_date

Line 512: => ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id

508: => p_rec.object_version_number
509: ,p_prtt_clm_gd_or_svc_typ_id_o
510: => ben_pqc_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id
511: ,p_pl_gd_r_svc_ctfn_id_o
512: => ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id
513: ,p_effective_start_date_o
514: => ben_pqc_shd.g_old_rec.effective_start_date
515: ,p_effective_end_date_o
516: => ben_pqc_shd.g_old_rec.effective_end_date

Line 514: => ben_pqc_shd.g_old_rec.effective_start_date

510: => ben_pqc_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id
511: ,p_pl_gd_r_svc_ctfn_id_o
512: => ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id
513: ,p_effective_start_date_o
514: => ben_pqc_shd.g_old_rec.effective_start_date
515: ,p_effective_end_date_o
516: => ben_pqc_shd.g_old_rec.effective_end_date
517: ,p_reimbmt_ctfn_rqd_flag_o
518: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag

Line 516: => ben_pqc_shd.g_old_rec.effective_end_date

512: => ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id
513: ,p_effective_start_date_o
514: => ben_pqc_shd.g_old_rec.effective_start_date
515: ,p_effective_end_date_o
516: => ben_pqc_shd.g_old_rec.effective_end_date
517: ,p_reimbmt_ctfn_rqd_flag_o
518: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag
519: ,p_business_group_id_o
520: => ben_pqc_shd.g_old_rec.business_group_id

Line 518: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag

514: => ben_pqc_shd.g_old_rec.effective_start_date
515: ,p_effective_end_date_o
516: => ben_pqc_shd.g_old_rec.effective_end_date
517: ,p_reimbmt_ctfn_rqd_flag_o
518: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag
519: ,p_business_group_id_o
520: => ben_pqc_shd.g_old_rec.business_group_id
521: ,p_prtt_enrt_actn_id_o
522: => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id

Line 520: => ben_pqc_shd.g_old_rec.business_group_id

516: => ben_pqc_shd.g_old_rec.effective_end_date
517: ,p_reimbmt_ctfn_rqd_flag_o
518: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag
519: ,p_business_group_id_o
520: => ben_pqc_shd.g_old_rec.business_group_id
521: ,p_prtt_enrt_actn_id_o
522: => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id
523: ,p_reimbmt_ctfn_recd_dt_o
524: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt

Line 522: => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id

518: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag
519: ,p_business_group_id_o
520: => ben_pqc_shd.g_old_rec.business_group_id
521: ,p_prtt_enrt_actn_id_o
522: => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id
523: ,p_reimbmt_ctfn_recd_dt_o
524: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt
525: ,p_reimbmt_ctfn_dnd_dt_o
526: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt

Line 524: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt

520: => ben_pqc_shd.g_old_rec.business_group_id
521: ,p_prtt_enrt_actn_id_o
522: => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id
523: ,p_reimbmt_ctfn_recd_dt_o
524: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt
525: ,p_reimbmt_ctfn_dnd_dt_o
526: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt
527: ,p_reimbmt_ctfn_typ_cd_o
528: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd

Line 526: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt

522: => ben_pqc_shd.g_old_rec.prtt_enrt_actn_id
523: ,p_reimbmt_ctfn_recd_dt_o
524: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt
525: ,p_reimbmt_ctfn_dnd_dt_o
526: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt
527: ,p_reimbmt_ctfn_typ_cd_o
528: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd
529: ,p_pqc_attribute_category_o
530: => ben_pqc_shd.g_old_rec.pqc_attribute_category

Line 528: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd

524: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt
525: ,p_reimbmt_ctfn_dnd_dt_o
526: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt
527: ,p_reimbmt_ctfn_typ_cd_o
528: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd
529: ,p_pqc_attribute_category_o
530: => ben_pqc_shd.g_old_rec.pqc_attribute_category
531: ,p_pqc_attribute1_o
532: => ben_pqc_shd.g_old_rec.pqc_attribute1

Line 530: => ben_pqc_shd.g_old_rec.pqc_attribute_category

526: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt
527: ,p_reimbmt_ctfn_typ_cd_o
528: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd
529: ,p_pqc_attribute_category_o
530: => ben_pqc_shd.g_old_rec.pqc_attribute_category
531: ,p_pqc_attribute1_o
532: => ben_pqc_shd.g_old_rec.pqc_attribute1
533: ,p_pqc_attribute2_o
534: => ben_pqc_shd.g_old_rec.pqc_attribute2

Line 532: => ben_pqc_shd.g_old_rec.pqc_attribute1

528: => ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd
529: ,p_pqc_attribute_category_o
530: => ben_pqc_shd.g_old_rec.pqc_attribute_category
531: ,p_pqc_attribute1_o
532: => ben_pqc_shd.g_old_rec.pqc_attribute1
533: ,p_pqc_attribute2_o
534: => ben_pqc_shd.g_old_rec.pqc_attribute2
535: ,p_pqc_attribute3_o
536: => ben_pqc_shd.g_old_rec.pqc_attribute3

Line 534: => ben_pqc_shd.g_old_rec.pqc_attribute2

530: => ben_pqc_shd.g_old_rec.pqc_attribute_category
531: ,p_pqc_attribute1_o
532: => ben_pqc_shd.g_old_rec.pqc_attribute1
533: ,p_pqc_attribute2_o
534: => ben_pqc_shd.g_old_rec.pqc_attribute2
535: ,p_pqc_attribute3_o
536: => ben_pqc_shd.g_old_rec.pqc_attribute3
537: ,p_pqc_attribute4_o
538: => ben_pqc_shd.g_old_rec.pqc_attribute4

Line 536: => ben_pqc_shd.g_old_rec.pqc_attribute3

532: => ben_pqc_shd.g_old_rec.pqc_attribute1
533: ,p_pqc_attribute2_o
534: => ben_pqc_shd.g_old_rec.pqc_attribute2
535: ,p_pqc_attribute3_o
536: => ben_pqc_shd.g_old_rec.pqc_attribute3
537: ,p_pqc_attribute4_o
538: => ben_pqc_shd.g_old_rec.pqc_attribute4
539: ,p_pqc_attribute5_o
540: => ben_pqc_shd.g_old_rec.pqc_attribute5

Line 538: => ben_pqc_shd.g_old_rec.pqc_attribute4

534: => ben_pqc_shd.g_old_rec.pqc_attribute2
535: ,p_pqc_attribute3_o
536: => ben_pqc_shd.g_old_rec.pqc_attribute3
537: ,p_pqc_attribute4_o
538: => ben_pqc_shd.g_old_rec.pqc_attribute4
539: ,p_pqc_attribute5_o
540: => ben_pqc_shd.g_old_rec.pqc_attribute5
541: ,p_pqc_attribute6_o
542: => ben_pqc_shd.g_old_rec.pqc_attribute6

Line 540: => ben_pqc_shd.g_old_rec.pqc_attribute5

536: => ben_pqc_shd.g_old_rec.pqc_attribute3
537: ,p_pqc_attribute4_o
538: => ben_pqc_shd.g_old_rec.pqc_attribute4
539: ,p_pqc_attribute5_o
540: => ben_pqc_shd.g_old_rec.pqc_attribute5
541: ,p_pqc_attribute6_o
542: => ben_pqc_shd.g_old_rec.pqc_attribute6
543: ,p_pqc_attribute7_o
544: => ben_pqc_shd.g_old_rec.pqc_attribute7

Line 542: => ben_pqc_shd.g_old_rec.pqc_attribute6

538: => ben_pqc_shd.g_old_rec.pqc_attribute4
539: ,p_pqc_attribute5_o
540: => ben_pqc_shd.g_old_rec.pqc_attribute5
541: ,p_pqc_attribute6_o
542: => ben_pqc_shd.g_old_rec.pqc_attribute6
543: ,p_pqc_attribute7_o
544: => ben_pqc_shd.g_old_rec.pqc_attribute7
545: ,p_pqc_attribute8_o
546: => ben_pqc_shd.g_old_rec.pqc_attribute8

Line 544: => ben_pqc_shd.g_old_rec.pqc_attribute7

540: => ben_pqc_shd.g_old_rec.pqc_attribute5
541: ,p_pqc_attribute6_o
542: => ben_pqc_shd.g_old_rec.pqc_attribute6
543: ,p_pqc_attribute7_o
544: => ben_pqc_shd.g_old_rec.pqc_attribute7
545: ,p_pqc_attribute8_o
546: => ben_pqc_shd.g_old_rec.pqc_attribute8
547: ,p_pqc_attribute9_o
548: => ben_pqc_shd.g_old_rec.pqc_attribute9

Line 546: => ben_pqc_shd.g_old_rec.pqc_attribute8

542: => ben_pqc_shd.g_old_rec.pqc_attribute6
543: ,p_pqc_attribute7_o
544: => ben_pqc_shd.g_old_rec.pqc_attribute7
545: ,p_pqc_attribute8_o
546: => ben_pqc_shd.g_old_rec.pqc_attribute8
547: ,p_pqc_attribute9_o
548: => ben_pqc_shd.g_old_rec.pqc_attribute9
549: ,p_pqc_attribute10_o
550: => ben_pqc_shd.g_old_rec.pqc_attribute10

Line 548: => ben_pqc_shd.g_old_rec.pqc_attribute9

544: => ben_pqc_shd.g_old_rec.pqc_attribute7
545: ,p_pqc_attribute8_o
546: => ben_pqc_shd.g_old_rec.pqc_attribute8
547: ,p_pqc_attribute9_o
548: => ben_pqc_shd.g_old_rec.pqc_attribute9
549: ,p_pqc_attribute10_o
550: => ben_pqc_shd.g_old_rec.pqc_attribute10
551: ,p_pqc_attribute11_o
552: => ben_pqc_shd.g_old_rec.pqc_attribute11

Line 550: => ben_pqc_shd.g_old_rec.pqc_attribute10

546: => ben_pqc_shd.g_old_rec.pqc_attribute8
547: ,p_pqc_attribute9_o
548: => ben_pqc_shd.g_old_rec.pqc_attribute9
549: ,p_pqc_attribute10_o
550: => ben_pqc_shd.g_old_rec.pqc_attribute10
551: ,p_pqc_attribute11_o
552: => ben_pqc_shd.g_old_rec.pqc_attribute11
553: ,p_pqc_attribute12_o
554: => ben_pqc_shd.g_old_rec.pqc_attribute12

Line 552: => ben_pqc_shd.g_old_rec.pqc_attribute11

548: => ben_pqc_shd.g_old_rec.pqc_attribute9
549: ,p_pqc_attribute10_o
550: => ben_pqc_shd.g_old_rec.pqc_attribute10
551: ,p_pqc_attribute11_o
552: => ben_pqc_shd.g_old_rec.pqc_attribute11
553: ,p_pqc_attribute12_o
554: => ben_pqc_shd.g_old_rec.pqc_attribute12
555: ,p_pqc_attribute13_o
556: => ben_pqc_shd.g_old_rec.pqc_attribute13

Line 554: => ben_pqc_shd.g_old_rec.pqc_attribute12

550: => ben_pqc_shd.g_old_rec.pqc_attribute10
551: ,p_pqc_attribute11_o
552: => ben_pqc_shd.g_old_rec.pqc_attribute11
553: ,p_pqc_attribute12_o
554: => ben_pqc_shd.g_old_rec.pqc_attribute12
555: ,p_pqc_attribute13_o
556: => ben_pqc_shd.g_old_rec.pqc_attribute13
557: ,p_pqc_attribute14_o
558: => ben_pqc_shd.g_old_rec.pqc_attribute14

Line 556: => ben_pqc_shd.g_old_rec.pqc_attribute13

552: => ben_pqc_shd.g_old_rec.pqc_attribute11
553: ,p_pqc_attribute12_o
554: => ben_pqc_shd.g_old_rec.pqc_attribute12
555: ,p_pqc_attribute13_o
556: => ben_pqc_shd.g_old_rec.pqc_attribute13
557: ,p_pqc_attribute14_o
558: => ben_pqc_shd.g_old_rec.pqc_attribute14
559: ,p_pqc_attribute15_o
560: => ben_pqc_shd.g_old_rec.pqc_attribute15

Line 558: => ben_pqc_shd.g_old_rec.pqc_attribute14

554: => ben_pqc_shd.g_old_rec.pqc_attribute12
555: ,p_pqc_attribute13_o
556: => ben_pqc_shd.g_old_rec.pqc_attribute13
557: ,p_pqc_attribute14_o
558: => ben_pqc_shd.g_old_rec.pqc_attribute14
559: ,p_pqc_attribute15_o
560: => ben_pqc_shd.g_old_rec.pqc_attribute15
561: ,p_pqc_attribute16_o
562: => ben_pqc_shd.g_old_rec.pqc_attribute16

Line 560: => ben_pqc_shd.g_old_rec.pqc_attribute15

556: => ben_pqc_shd.g_old_rec.pqc_attribute13
557: ,p_pqc_attribute14_o
558: => ben_pqc_shd.g_old_rec.pqc_attribute14
559: ,p_pqc_attribute15_o
560: => ben_pqc_shd.g_old_rec.pqc_attribute15
561: ,p_pqc_attribute16_o
562: => ben_pqc_shd.g_old_rec.pqc_attribute16
563: ,p_pqc_attribute17_o
564: => ben_pqc_shd.g_old_rec.pqc_attribute17

Line 562: => ben_pqc_shd.g_old_rec.pqc_attribute16

558: => ben_pqc_shd.g_old_rec.pqc_attribute14
559: ,p_pqc_attribute15_o
560: => ben_pqc_shd.g_old_rec.pqc_attribute15
561: ,p_pqc_attribute16_o
562: => ben_pqc_shd.g_old_rec.pqc_attribute16
563: ,p_pqc_attribute17_o
564: => ben_pqc_shd.g_old_rec.pqc_attribute17
565: ,p_pqc_attribute18_o
566: => ben_pqc_shd.g_old_rec.pqc_attribute18

Line 564: => ben_pqc_shd.g_old_rec.pqc_attribute17

560: => ben_pqc_shd.g_old_rec.pqc_attribute15
561: ,p_pqc_attribute16_o
562: => ben_pqc_shd.g_old_rec.pqc_attribute16
563: ,p_pqc_attribute17_o
564: => ben_pqc_shd.g_old_rec.pqc_attribute17
565: ,p_pqc_attribute18_o
566: => ben_pqc_shd.g_old_rec.pqc_attribute18
567: ,p_pqc_attribute19_o
568: => ben_pqc_shd.g_old_rec.pqc_attribute19

Line 566: => ben_pqc_shd.g_old_rec.pqc_attribute18

562: => ben_pqc_shd.g_old_rec.pqc_attribute16
563: ,p_pqc_attribute17_o
564: => ben_pqc_shd.g_old_rec.pqc_attribute17
565: ,p_pqc_attribute18_o
566: => ben_pqc_shd.g_old_rec.pqc_attribute18
567: ,p_pqc_attribute19_o
568: => ben_pqc_shd.g_old_rec.pqc_attribute19
569: ,p_pqc_attribute20_o
570: => ben_pqc_shd.g_old_rec.pqc_attribute20

Line 568: => ben_pqc_shd.g_old_rec.pqc_attribute19

564: => ben_pqc_shd.g_old_rec.pqc_attribute17
565: ,p_pqc_attribute18_o
566: => ben_pqc_shd.g_old_rec.pqc_attribute18
567: ,p_pqc_attribute19_o
568: => ben_pqc_shd.g_old_rec.pqc_attribute19
569: ,p_pqc_attribute20_o
570: => ben_pqc_shd.g_old_rec.pqc_attribute20
571: ,p_pqc_attribute21_o
572: => ben_pqc_shd.g_old_rec.pqc_attribute21

Line 570: => ben_pqc_shd.g_old_rec.pqc_attribute20

566: => ben_pqc_shd.g_old_rec.pqc_attribute18
567: ,p_pqc_attribute19_o
568: => ben_pqc_shd.g_old_rec.pqc_attribute19
569: ,p_pqc_attribute20_o
570: => ben_pqc_shd.g_old_rec.pqc_attribute20
571: ,p_pqc_attribute21_o
572: => ben_pqc_shd.g_old_rec.pqc_attribute21
573: ,p_pqc_attribute22_o
574: => ben_pqc_shd.g_old_rec.pqc_attribute22

Line 572: => ben_pqc_shd.g_old_rec.pqc_attribute21

568: => ben_pqc_shd.g_old_rec.pqc_attribute19
569: ,p_pqc_attribute20_o
570: => ben_pqc_shd.g_old_rec.pqc_attribute20
571: ,p_pqc_attribute21_o
572: => ben_pqc_shd.g_old_rec.pqc_attribute21
573: ,p_pqc_attribute22_o
574: => ben_pqc_shd.g_old_rec.pqc_attribute22
575: ,p_pqc_attribute23_o
576: => ben_pqc_shd.g_old_rec.pqc_attribute23

Line 574: => ben_pqc_shd.g_old_rec.pqc_attribute22

570: => ben_pqc_shd.g_old_rec.pqc_attribute20
571: ,p_pqc_attribute21_o
572: => ben_pqc_shd.g_old_rec.pqc_attribute21
573: ,p_pqc_attribute22_o
574: => ben_pqc_shd.g_old_rec.pqc_attribute22
575: ,p_pqc_attribute23_o
576: => ben_pqc_shd.g_old_rec.pqc_attribute23
577: ,p_pqc_attribute24_o
578: => ben_pqc_shd.g_old_rec.pqc_attribute24

Line 576: => ben_pqc_shd.g_old_rec.pqc_attribute23

572: => ben_pqc_shd.g_old_rec.pqc_attribute21
573: ,p_pqc_attribute22_o
574: => ben_pqc_shd.g_old_rec.pqc_attribute22
575: ,p_pqc_attribute23_o
576: => ben_pqc_shd.g_old_rec.pqc_attribute23
577: ,p_pqc_attribute24_o
578: => ben_pqc_shd.g_old_rec.pqc_attribute24
579: ,p_pqc_attribute25_o
580: => ben_pqc_shd.g_old_rec.pqc_attribute25

Line 578: => ben_pqc_shd.g_old_rec.pqc_attribute24

574: => ben_pqc_shd.g_old_rec.pqc_attribute22
575: ,p_pqc_attribute23_o
576: => ben_pqc_shd.g_old_rec.pqc_attribute23
577: ,p_pqc_attribute24_o
578: => ben_pqc_shd.g_old_rec.pqc_attribute24
579: ,p_pqc_attribute25_o
580: => ben_pqc_shd.g_old_rec.pqc_attribute25
581: ,p_pqc_attribute26_o
582: => ben_pqc_shd.g_old_rec.pqc_attribute26

Line 580: => ben_pqc_shd.g_old_rec.pqc_attribute25

576: => ben_pqc_shd.g_old_rec.pqc_attribute23
577: ,p_pqc_attribute24_o
578: => ben_pqc_shd.g_old_rec.pqc_attribute24
579: ,p_pqc_attribute25_o
580: => ben_pqc_shd.g_old_rec.pqc_attribute25
581: ,p_pqc_attribute26_o
582: => ben_pqc_shd.g_old_rec.pqc_attribute26
583: ,p_pqc_attribute27_o
584: => ben_pqc_shd.g_old_rec.pqc_attribute27

Line 582: => ben_pqc_shd.g_old_rec.pqc_attribute26

578: => ben_pqc_shd.g_old_rec.pqc_attribute24
579: ,p_pqc_attribute25_o
580: => ben_pqc_shd.g_old_rec.pqc_attribute25
581: ,p_pqc_attribute26_o
582: => ben_pqc_shd.g_old_rec.pqc_attribute26
583: ,p_pqc_attribute27_o
584: => ben_pqc_shd.g_old_rec.pqc_attribute27
585: ,p_pqc_attribute28_o
586: => ben_pqc_shd.g_old_rec.pqc_attribute28

Line 584: => ben_pqc_shd.g_old_rec.pqc_attribute27

580: => ben_pqc_shd.g_old_rec.pqc_attribute25
581: ,p_pqc_attribute26_o
582: => ben_pqc_shd.g_old_rec.pqc_attribute26
583: ,p_pqc_attribute27_o
584: => ben_pqc_shd.g_old_rec.pqc_attribute27
585: ,p_pqc_attribute28_o
586: => ben_pqc_shd.g_old_rec.pqc_attribute28
587: ,p_pqc_attribute29_o
588: => ben_pqc_shd.g_old_rec.pqc_attribute29

Line 586: => ben_pqc_shd.g_old_rec.pqc_attribute28

582: => ben_pqc_shd.g_old_rec.pqc_attribute26
583: ,p_pqc_attribute27_o
584: => ben_pqc_shd.g_old_rec.pqc_attribute27
585: ,p_pqc_attribute28_o
586: => ben_pqc_shd.g_old_rec.pqc_attribute28
587: ,p_pqc_attribute29_o
588: => ben_pqc_shd.g_old_rec.pqc_attribute29
589: ,p_pqc_attribute30_o
590: => ben_pqc_shd.g_old_rec.pqc_attribute30

Line 588: => ben_pqc_shd.g_old_rec.pqc_attribute29

584: => ben_pqc_shd.g_old_rec.pqc_attribute27
585: ,p_pqc_attribute28_o
586: => ben_pqc_shd.g_old_rec.pqc_attribute28
587: ,p_pqc_attribute29_o
588: => ben_pqc_shd.g_old_rec.pqc_attribute29
589: ,p_pqc_attribute30_o
590: => ben_pqc_shd.g_old_rec.pqc_attribute30
591: ,p_object_version_number_o
592: => ben_pqc_shd.g_old_rec.object_version_number

Line 590: => ben_pqc_shd.g_old_rec.pqc_attribute30

586: => ben_pqc_shd.g_old_rec.pqc_attribute28
587: ,p_pqc_attribute29_o
588: => ben_pqc_shd.g_old_rec.pqc_attribute29
589: ,p_pqc_attribute30_o
590: => ben_pqc_shd.g_old_rec.pqc_attribute30
591: ,p_object_version_number_o
592: => ben_pqc_shd.g_old_rec.object_version_number
593: );
594: --

Line 592: => ben_pqc_shd.g_old_rec.object_version_number

588: => ben_pqc_shd.g_old_rec.pqc_attribute29
589: ,p_pqc_attribute30_o
590: => ben_pqc_shd.g_old_rec.pqc_attribute30
591: ,p_object_version_number_o
592: => ben_pqc_shd.g_old_rec.object_version_number
593: );
594: --
595: exception
596: --

Line 652: (p_rec in out nocopy ben_pqc_shd.g_rec_type

648: --
649: -- {End Of Comments}
650: -- ----------------------------------------------------------------------------
651: Procedure convert_defs
652: (p_rec in out nocopy ben_pqc_shd.g_rec_type
653: ) is
654: --
655: Begin
656: --

Line 664: ben_pqc_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id;

660: -- is being used then we must set to the 'current' argument value.
661: --
662: If (p_rec.prtt_clm_gd_or_svc_typ_id = hr_api.g_number) then
663: p_rec.prtt_clm_gd_or_svc_typ_id :=
664: ben_pqc_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id;
665: End If;
666: If (p_rec.pl_gd_r_svc_ctfn_id = hr_api.g_number) then
667: p_rec.pl_gd_r_svc_ctfn_id :=
668: ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id;

Line 668: ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id;

664: ben_pqc_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id;
665: End If;
666: If (p_rec.pl_gd_r_svc_ctfn_id = hr_api.g_number) then
667: p_rec.pl_gd_r_svc_ctfn_id :=
668: ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id;
669: End If;
670: If (p_rec.reimbmt_ctfn_rqd_flag = hr_api.g_varchar2) then
671: p_rec.reimbmt_ctfn_rqd_flag :=
672: ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag;

Line 672: ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag;

668: ben_pqc_shd.g_old_rec.pl_gd_r_svc_ctfn_id;
669: End If;
670: If (p_rec.reimbmt_ctfn_rqd_flag = hr_api.g_varchar2) then
671: p_rec.reimbmt_ctfn_rqd_flag :=
672: ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag;
673: End If;
674: If (p_rec.business_group_id = hr_api.g_number) then
675: p_rec.business_group_id :=
676: ben_pqc_shd.g_old_rec.business_group_id;

Line 676: ben_pqc_shd.g_old_rec.business_group_id;

672: ben_pqc_shd.g_old_rec.reimbmt_ctfn_rqd_flag;
673: End If;
674: If (p_rec.business_group_id = hr_api.g_number) then
675: p_rec.business_group_id :=
676: ben_pqc_shd.g_old_rec.business_group_id;
677: End If;
678: If (p_rec.prtt_enrt_actn_id = hr_api.g_number) then
679: p_rec.prtt_enrt_actn_id :=
680: ben_pqc_shd.g_old_rec.prtt_enrt_actn_id;

Line 680: ben_pqc_shd.g_old_rec.prtt_enrt_actn_id;

676: ben_pqc_shd.g_old_rec.business_group_id;
677: End If;
678: If (p_rec.prtt_enrt_actn_id = hr_api.g_number) then
679: p_rec.prtt_enrt_actn_id :=
680: ben_pqc_shd.g_old_rec.prtt_enrt_actn_id;
681: End If;
682: If (p_rec.reimbmt_ctfn_recd_dt = hr_api.g_date) then
683: p_rec.reimbmt_ctfn_recd_dt :=
684: ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt;

Line 684: ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt;

680: ben_pqc_shd.g_old_rec.prtt_enrt_actn_id;
681: End If;
682: If (p_rec.reimbmt_ctfn_recd_dt = hr_api.g_date) then
683: p_rec.reimbmt_ctfn_recd_dt :=
684: ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt;
685: End If;
686: If (p_rec.reimbmt_ctfn_dnd_dt = hr_api.g_date) then
687: p_rec.reimbmt_ctfn_dnd_dt :=
688: ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt;

Line 688: ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt;

684: ben_pqc_shd.g_old_rec.reimbmt_ctfn_recd_dt;
685: End If;
686: If (p_rec.reimbmt_ctfn_dnd_dt = hr_api.g_date) then
687: p_rec.reimbmt_ctfn_dnd_dt :=
688: ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt;
689: End If;
690: If (p_rec.reimbmt_ctfn_typ_cd = hr_api.g_varchar2) then
691: p_rec.reimbmt_ctfn_typ_cd :=
692: ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd;

Line 692: ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd;

688: ben_pqc_shd.g_old_rec.reimbmt_ctfn_dnd_dt;
689: End If;
690: If (p_rec.reimbmt_ctfn_typ_cd = hr_api.g_varchar2) then
691: p_rec.reimbmt_ctfn_typ_cd :=
692: ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd;
693: End If;
694: If (p_rec.pqc_attribute_category = hr_api.g_varchar2) then
695: p_rec.pqc_attribute_category :=
696: ben_pqc_shd.g_old_rec.pqc_attribute_category;

Line 696: ben_pqc_shd.g_old_rec.pqc_attribute_category;

692: ben_pqc_shd.g_old_rec.reimbmt_ctfn_typ_cd;
693: End If;
694: If (p_rec.pqc_attribute_category = hr_api.g_varchar2) then
695: p_rec.pqc_attribute_category :=
696: ben_pqc_shd.g_old_rec.pqc_attribute_category;
697: End If;
698: If (p_rec.pqc_attribute1 = hr_api.g_varchar2) then
699: p_rec.pqc_attribute1 :=
700: ben_pqc_shd.g_old_rec.pqc_attribute1;

Line 700: ben_pqc_shd.g_old_rec.pqc_attribute1;

696: ben_pqc_shd.g_old_rec.pqc_attribute_category;
697: End If;
698: If (p_rec.pqc_attribute1 = hr_api.g_varchar2) then
699: p_rec.pqc_attribute1 :=
700: ben_pqc_shd.g_old_rec.pqc_attribute1;
701: End If;
702: If (p_rec.pqc_attribute2 = hr_api.g_varchar2) then
703: p_rec.pqc_attribute2 :=
704: ben_pqc_shd.g_old_rec.pqc_attribute2;

Line 704: ben_pqc_shd.g_old_rec.pqc_attribute2;

700: ben_pqc_shd.g_old_rec.pqc_attribute1;
701: End If;
702: If (p_rec.pqc_attribute2 = hr_api.g_varchar2) then
703: p_rec.pqc_attribute2 :=
704: ben_pqc_shd.g_old_rec.pqc_attribute2;
705: End If;
706: If (p_rec.pqc_attribute3 = hr_api.g_varchar2) then
707: p_rec.pqc_attribute3 :=
708: ben_pqc_shd.g_old_rec.pqc_attribute3;

Line 708: ben_pqc_shd.g_old_rec.pqc_attribute3;

704: ben_pqc_shd.g_old_rec.pqc_attribute2;
705: End If;
706: If (p_rec.pqc_attribute3 = hr_api.g_varchar2) then
707: p_rec.pqc_attribute3 :=
708: ben_pqc_shd.g_old_rec.pqc_attribute3;
709: End If;
710: If (p_rec.pqc_attribute4 = hr_api.g_varchar2) then
711: p_rec.pqc_attribute4 :=
712: ben_pqc_shd.g_old_rec.pqc_attribute4;

Line 712: ben_pqc_shd.g_old_rec.pqc_attribute4;

708: ben_pqc_shd.g_old_rec.pqc_attribute3;
709: End If;
710: If (p_rec.pqc_attribute4 = hr_api.g_varchar2) then
711: p_rec.pqc_attribute4 :=
712: ben_pqc_shd.g_old_rec.pqc_attribute4;
713: End If;
714: If (p_rec.pqc_attribute5 = hr_api.g_varchar2) then
715: p_rec.pqc_attribute5 :=
716: ben_pqc_shd.g_old_rec.pqc_attribute5;

Line 716: ben_pqc_shd.g_old_rec.pqc_attribute5;

712: ben_pqc_shd.g_old_rec.pqc_attribute4;
713: End If;
714: If (p_rec.pqc_attribute5 = hr_api.g_varchar2) then
715: p_rec.pqc_attribute5 :=
716: ben_pqc_shd.g_old_rec.pqc_attribute5;
717: End If;
718: If (p_rec.pqc_attribute6 = hr_api.g_varchar2) then
719: p_rec.pqc_attribute6 :=
720: ben_pqc_shd.g_old_rec.pqc_attribute6;

Line 720: ben_pqc_shd.g_old_rec.pqc_attribute6;

716: ben_pqc_shd.g_old_rec.pqc_attribute5;
717: End If;
718: If (p_rec.pqc_attribute6 = hr_api.g_varchar2) then
719: p_rec.pqc_attribute6 :=
720: ben_pqc_shd.g_old_rec.pqc_attribute6;
721: End If;
722: If (p_rec.pqc_attribute7 = hr_api.g_varchar2) then
723: p_rec.pqc_attribute7 :=
724: ben_pqc_shd.g_old_rec.pqc_attribute7;

Line 724: ben_pqc_shd.g_old_rec.pqc_attribute7;

720: ben_pqc_shd.g_old_rec.pqc_attribute6;
721: End If;
722: If (p_rec.pqc_attribute7 = hr_api.g_varchar2) then
723: p_rec.pqc_attribute7 :=
724: ben_pqc_shd.g_old_rec.pqc_attribute7;
725: End If;
726: If (p_rec.pqc_attribute8 = hr_api.g_varchar2) then
727: p_rec.pqc_attribute8 :=
728: ben_pqc_shd.g_old_rec.pqc_attribute8;

Line 728: ben_pqc_shd.g_old_rec.pqc_attribute8;

724: ben_pqc_shd.g_old_rec.pqc_attribute7;
725: End If;
726: If (p_rec.pqc_attribute8 = hr_api.g_varchar2) then
727: p_rec.pqc_attribute8 :=
728: ben_pqc_shd.g_old_rec.pqc_attribute8;
729: End If;
730: If (p_rec.pqc_attribute9 = hr_api.g_varchar2) then
731: p_rec.pqc_attribute9 :=
732: ben_pqc_shd.g_old_rec.pqc_attribute9;

Line 732: ben_pqc_shd.g_old_rec.pqc_attribute9;

728: ben_pqc_shd.g_old_rec.pqc_attribute8;
729: End If;
730: If (p_rec.pqc_attribute9 = hr_api.g_varchar2) then
731: p_rec.pqc_attribute9 :=
732: ben_pqc_shd.g_old_rec.pqc_attribute9;
733: End If;
734: If (p_rec.pqc_attribute10 = hr_api.g_varchar2) then
735: p_rec.pqc_attribute10 :=
736: ben_pqc_shd.g_old_rec.pqc_attribute10;

Line 736: ben_pqc_shd.g_old_rec.pqc_attribute10;

732: ben_pqc_shd.g_old_rec.pqc_attribute9;
733: End If;
734: If (p_rec.pqc_attribute10 = hr_api.g_varchar2) then
735: p_rec.pqc_attribute10 :=
736: ben_pqc_shd.g_old_rec.pqc_attribute10;
737: End If;
738: If (p_rec.pqc_attribute11 = hr_api.g_varchar2) then
739: p_rec.pqc_attribute11 :=
740: ben_pqc_shd.g_old_rec.pqc_attribute11;

Line 740: ben_pqc_shd.g_old_rec.pqc_attribute11;

736: ben_pqc_shd.g_old_rec.pqc_attribute10;
737: End If;
738: If (p_rec.pqc_attribute11 = hr_api.g_varchar2) then
739: p_rec.pqc_attribute11 :=
740: ben_pqc_shd.g_old_rec.pqc_attribute11;
741: End If;
742: If (p_rec.pqc_attribute12 = hr_api.g_varchar2) then
743: p_rec.pqc_attribute12 :=
744: ben_pqc_shd.g_old_rec.pqc_attribute12;

Line 744: ben_pqc_shd.g_old_rec.pqc_attribute12;

740: ben_pqc_shd.g_old_rec.pqc_attribute11;
741: End If;
742: If (p_rec.pqc_attribute12 = hr_api.g_varchar2) then
743: p_rec.pqc_attribute12 :=
744: ben_pqc_shd.g_old_rec.pqc_attribute12;
745: End If;
746: If (p_rec.pqc_attribute13 = hr_api.g_varchar2) then
747: p_rec.pqc_attribute13 :=
748: ben_pqc_shd.g_old_rec.pqc_attribute13;

Line 748: ben_pqc_shd.g_old_rec.pqc_attribute13;

744: ben_pqc_shd.g_old_rec.pqc_attribute12;
745: End If;
746: If (p_rec.pqc_attribute13 = hr_api.g_varchar2) then
747: p_rec.pqc_attribute13 :=
748: ben_pqc_shd.g_old_rec.pqc_attribute13;
749: End If;
750: If (p_rec.pqc_attribute14 = hr_api.g_varchar2) then
751: p_rec.pqc_attribute14 :=
752: ben_pqc_shd.g_old_rec.pqc_attribute14;

Line 752: ben_pqc_shd.g_old_rec.pqc_attribute14;

748: ben_pqc_shd.g_old_rec.pqc_attribute13;
749: End If;
750: If (p_rec.pqc_attribute14 = hr_api.g_varchar2) then
751: p_rec.pqc_attribute14 :=
752: ben_pqc_shd.g_old_rec.pqc_attribute14;
753: End If;
754: If (p_rec.pqc_attribute15 = hr_api.g_varchar2) then
755: p_rec.pqc_attribute15 :=
756: ben_pqc_shd.g_old_rec.pqc_attribute15;

Line 756: ben_pqc_shd.g_old_rec.pqc_attribute15;

752: ben_pqc_shd.g_old_rec.pqc_attribute14;
753: End If;
754: If (p_rec.pqc_attribute15 = hr_api.g_varchar2) then
755: p_rec.pqc_attribute15 :=
756: ben_pqc_shd.g_old_rec.pqc_attribute15;
757: End If;
758: If (p_rec.pqc_attribute16 = hr_api.g_varchar2) then
759: p_rec.pqc_attribute16 :=
760: ben_pqc_shd.g_old_rec.pqc_attribute16;

Line 760: ben_pqc_shd.g_old_rec.pqc_attribute16;

756: ben_pqc_shd.g_old_rec.pqc_attribute15;
757: End If;
758: If (p_rec.pqc_attribute16 = hr_api.g_varchar2) then
759: p_rec.pqc_attribute16 :=
760: ben_pqc_shd.g_old_rec.pqc_attribute16;
761: End If;
762: If (p_rec.pqc_attribute17 = hr_api.g_varchar2) then
763: p_rec.pqc_attribute17 :=
764: ben_pqc_shd.g_old_rec.pqc_attribute17;

Line 764: ben_pqc_shd.g_old_rec.pqc_attribute17;

760: ben_pqc_shd.g_old_rec.pqc_attribute16;
761: End If;
762: If (p_rec.pqc_attribute17 = hr_api.g_varchar2) then
763: p_rec.pqc_attribute17 :=
764: ben_pqc_shd.g_old_rec.pqc_attribute17;
765: End If;
766: If (p_rec.pqc_attribute18 = hr_api.g_varchar2) then
767: p_rec.pqc_attribute18 :=
768: ben_pqc_shd.g_old_rec.pqc_attribute18;

Line 768: ben_pqc_shd.g_old_rec.pqc_attribute18;

764: ben_pqc_shd.g_old_rec.pqc_attribute17;
765: End If;
766: If (p_rec.pqc_attribute18 = hr_api.g_varchar2) then
767: p_rec.pqc_attribute18 :=
768: ben_pqc_shd.g_old_rec.pqc_attribute18;
769: End If;
770: If (p_rec.pqc_attribute19 = hr_api.g_varchar2) then
771: p_rec.pqc_attribute19 :=
772: ben_pqc_shd.g_old_rec.pqc_attribute19;

Line 772: ben_pqc_shd.g_old_rec.pqc_attribute19;

768: ben_pqc_shd.g_old_rec.pqc_attribute18;
769: End If;
770: If (p_rec.pqc_attribute19 = hr_api.g_varchar2) then
771: p_rec.pqc_attribute19 :=
772: ben_pqc_shd.g_old_rec.pqc_attribute19;
773: End If;
774: If (p_rec.pqc_attribute20 = hr_api.g_varchar2) then
775: p_rec.pqc_attribute20 :=
776: ben_pqc_shd.g_old_rec.pqc_attribute20;

Line 776: ben_pqc_shd.g_old_rec.pqc_attribute20;

772: ben_pqc_shd.g_old_rec.pqc_attribute19;
773: End If;
774: If (p_rec.pqc_attribute20 = hr_api.g_varchar2) then
775: p_rec.pqc_attribute20 :=
776: ben_pqc_shd.g_old_rec.pqc_attribute20;
777: End If;
778: If (p_rec.pqc_attribute21 = hr_api.g_varchar2) then
779: p_rec.pqc_attribute21 :=
780: ben_pqc_shd.g_old_rec.pqc_attribute21;

Line 780: ben_pqc_shd.g_old_rec.pqc_attribute21;

776: ben_pqc_shd.g_old_rec.pqc_attribute20;
777: End If;
778: If (p_rec.pqc_attribute21 = hr_api.g_varchar2) then
779: p_rec.pqc_attribute21 :=
780: ben_pqc_shd.g_old_rec.pqc_attribute21;
781: End If;
782: If (p_rec.pqc_attribute22 = hr_api.g_varchar2) then
783: p_rec.pqc_attribute22 :=
784: ben_pqc_shd.g_old_rec.pqc_attribute22;

Line 784: ben_pqc_shd.g_old_rec.pqc_attribute22;

780: ben_pqc_shd.g_old_rec.pqc_attribute21;
781: End If;
782: If (p_rec.pqc_attribute22 = hr_api.g_varchar2) then
783: p_rec.pqc_attribute22 :=
784: ben_pqc_shd.g_old_rec.pqc_attribute22;
785: End If;
786: If (p_rec.pqc_attribute23 = hr_api.g_varchar2) then
787: p_rec.pqc_attribute23 :=
788: ben_pqc_shd.g_old_rec.pqc_attribute23;

Line 788: ben_pqc_shd.g_old_rec.pqc_attribute23;

784: ben_pqc_shd.g_old_rec.pqc_attribute22;
785: End If;
786: If (p_rec.pqc_attribute23 = hr_api.g_varchar2) then
787: p_rec.pqc_attribute23 :=
788: ben_pqc_shd.g_old_rec.pqc_attribute23;
789: End If;
790: If (p_rec.pqc_attribute24 = hr_api.g_varchar2) then
791: p_rec.pqc_attribute24 :=
792: ben_pqc_shd.g_old_rec.pqc_attribute24;

Line 792: ben_pqc_shd.g_old_rec.pqc_attribute24;

788: ben_pqc_shd.g_old_rec.pqc_attribute23;
789: End If;
790: If (p_rec.pqc_attribute24 = hr_api.g_varchar2) then
791: p_rec.pqc_attribute24 :=
792: ben_pqc_shd.g_old_rec.pqc_attribute24;
793: End If;
794: If (p_rec.pqc_attribute25 = hr_api.g_varchar2) then
795: p_rec.pqc_attribute25 :=
796: ben_pqc_shd.g_old_rec.pqc_attribute25;

Line 796: ben_pqc_shd.g_old_rec.pqc_attribute25;

792: ben_pqc_shd.g_old_rec.pqc_attribute24;
793: End If;
794: If (p_rec.pqc_attribute25 = hr_api.g_varchar2) then
795: p_rec.pqc_attribute25 :=
796: ben_pqc_shd.g_old_rec.pqc_attribute25;
797: End If;
798: If (p_rec.pqc_attribute26 = hr_api.g_varchar2) then
799: p_rec.pqc_attribute26 :=
800: ben_pqc_shd.g_old_rec.pqc_attribute26;

Line 800: ben_pqc_shd.g_old_rec.pqc_attribute26;

796: ben_pqc_shd.g_old_rec.pqc_attribute25;
797: End If;
798: If (p_rec.pqc_attribute26 = hr_api.g_varchar2) then
799: p_rec.pqc_attribute26 :=
800: ben_pqc_shd.g_old_rec.pqc_attribute26;
801: End If;
802: If (p_rec.pqc_attribute27 = hr_api.g_varchar2) then
803: p_rec.pqc_attribute27 :=
804: ben_pqc_shd.g_old_rec.pqc_attribute27;

Line 804: ben_pqc_shd.g_old_rec.pqc_attribute27;

800: ben_pqc_shd.g_old_rec.pqc_attribute26;
801: End If;
802: If (p_rec.pqc_attribute27 = hr_api.g_varchar2) then
803: p_rec.pqc_attribute27 :=
804: ben_pqc_shd.g_old_rec.pqc_attribute27;
805: End If;
806: If (p_rec.pqc_attribute28 = hr_api.g_varchar2) then
807: p_rec.pqc_attribute28 :=
808: ben_pqc_shd.g_old_rec.pqc_attribute28;

Line 808: ben_pqc_shd.g_old_rec.pqc_attribute28;

804: ben_pqc_shd.g_old_rec.pqc_attribute27;
805: End If;
806: If (p_rec.pqc_attribute28 = hr_api.g_varchar2) then
807: p_rec.pqc_attribute28 :=
808: ben_pqc_shd.g_old_rec.pqc_attribute28;
809: End If;
810: If (p_rec.pqc_attribute29 = hr_api.g_varchar2) then
811: p_rec.pqc_attribute29 :=
812: ben_pqc_shd.g_old_rec.pqc_attribute29;

Line 812: ben_pqc_shd.g_old_rec.pqc_attribute29;

808: ben_pqc_shd.g_old_rec.pqc_attribute28;
809: End If;
810: If (p_rec.pqc_attribute29 = hr_api.g_varchar2) then
811: p_rec.pqc_attribute29 :=
812: ben_pqc_shd.g_old_rec.pqc_attribute29;
813: End If;
814: If (p_rec.pqc_attribute30 = hr_api.g_varchar2) then
815: p_rec.pqc_attribute30 :=
816: ben_pqc_shd.g_old_rec.pqc_attribute30;

Line 816: ben_pqc_shd.g_old_rec.pqc_attribute30;

812: ben_pqc_shd.g_old_rec.pqc_attribute29;
813: End If;
814: If (p_rec.pqc_attribute30 = hr_api.g_varchar2) then
815: p_rec.pqc_attribute30 :=
816: ben_pqc_shd.g_old_rec.pqc_attribute30;
817: End If;
818: --
819: End convert_defs;
820: --

Line 827: ,p_rec in out nocopy ben_pqc_shd.g_rec_type

823: -- ----------------------------------------------------------------------------
824: Procedure upd
825: (p_effective_date in date
826: ,p_datetrack_mode in varchar2
827: ,p_rec in out nocopy ben_pqc_shd.g_rec_type
828: ) is
829: --
830: l_proc varchar2(72) := g_package||'upd';
831: l_validation_start_date date;

Line 843: ben_pqc_shd.lck

839: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
840: --
841: -- We must lock the row which we need to update.
842: --
843: ben_pqc_shd.lck
844: (p_effective_date => p_effective_date
845: ,p_datetrack_mode => p_datetrack_mode
846: ,p_prtt_rmt_rqst_ctfn_prvdd_id => p_rec.prtt_rmt_rqst_ctfn_prvdd_id
847: ,p_object_version_number => p_rec.object_version_number

Line 950: l_rec ben_pqc_shd.g_rec_type;

946: ,p_effective_start_date out nocopy date
947: ,p_effective_end_date out nocopy date
948: ) is
949: --
950: l_rec ben_pqc_shd.g_rec_type;
951: l_proc varchar2(72) := g_package||'upd';
952: --
953: Begin
954: hr_utility.set_location('Entering:'||l_proc, 5);

Line 960: ben_pqc_shd.convert_args

956: -- Call conversion function to turn arguments into the
957: -- l_rec structure.
958: --
959: l_rec :=
960: ben_pqc_shd.convert_args
961: (p_prtt_rmt_rqst_ctfn_prvdd_id
962: ,p_prtt_clm_gd_or_svc_typ_id
963: ,p_pl_gd_r_svc_ctfn_id
964: ,null