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_QIG_UPD dependencies on BEN_QIG_SHD

Line 58: (p_rec in out nocopy ben_qig_shd.g_rec_type

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

140: Exception
141: When hr_api.check_integrity_violated Then
142: -- A check constraint has been violated
143: --
144: ben_qig_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --

Line 149: ben_qig_shd.constraint_error

145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: ben_qig_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: --
153: Raise;

Line 188: (p_rec in out nocopy ben_qig_shd.g_rec_type

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

Line 255: (p_rec in out nocopy ben_qig_shd.g_rec_type

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

Line 271: ben_qig_shd.upd_effective_end_date

267: If (p_datetrack_mode <> hr_api.g_correction) then
268: --
269: -- Update the current effective end date
270: --
271: ben_qig_shd.upd_effective_end_date
272: (p_effective_date => p_effective_date
273: ,p_base_key_value => p_rec.qua_in_gr_rt_id
274: ,p_new_effective_end_date => (p_validation_start_date - 1)
275: ,p_validation_start_date => p_validation_start_date

Line 340: (p_rec in out nocopy ben_qig_shd.g_rec_type

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

Line 398: (p_rec in ben_qig_shd.g_rec_type

394: --
395: -- {End Of Comments}
396: -- ----------------------------------------------------------------------------
397: Procedure post_update
398: (p_rec in ben_qig_shd.g_rec_type
399: ,p_effective_date in date
400: ,p_datetrack_mode in varchar2
401: ,p_validation_start_date in date
402: ,p_validation_end_date in date

Line 501: => ben_qig_shd.g_old_rec.effective_start_date

497: => p_rec.qig_attribute29
498: ,p_qig_attribute30
499: => p_rec.qig_attribute30
500: ,p_effective_start_date_o
501: => ben_qig_shd.g_old_rec.effective_start_date
502: ,p_effective_end_date_o
503: => ben_qig_shd.g_old_rec.effective_end_date
504: ,p_quar_in_grade_cd_o
505: => ben_qig_shd.g_old_rec.quar_in_grade_cd

Line 503: => ben_qig_shd.g_old_rec.effective_end_date

499: => p_rec.qig_attribute30
500: ,p_effective_start_date_o
501: => ben_qig_shd.g_old_rec.effective_start_date
502: ,p_effective_end_date_o
503: => ben_qig_shd.g_old_rec.effective_end_date
504: ,p_quar_in_grade_cd_o
505: => ben_qig_shd.g_old_rec.quar_in_grade_cd
506: ,p_excld_flag_o
507: => ben_qig_shd.g_old_rec.excld_flag

Line 505: => ben_qig_shd.g_old_rec.quar_in_grade_cd

501: => ben_qig_shd.g_old_rec.effective_start_date
502: ,p_effective_end_date_o
503: => ben_qig_shd.g_old_rec.effective_end_date
504: ,p_quar_in_grade_cd_o
505: => ben_qig_shd.g_old_rec.quar_in_grade_cd
506: ,p_excld_flag_o
507: => ben_qig_shd.g_old_rec.excld_flag
508: ,p_business_group_id_o
509: => ben_qig_shd.g_old_rec.business_group_id

Line 507: => ben_qig_shd.g_old_rec.excld_flag

503: => ben_qig_shd.g_old_rec.effective_end_date
504: ,p_quar_in_grade_cd_o
505: => ben_qig_shd.g_old_rec.quar_in_grade_cd
506: ,p_excld_flag_o
507: => ben_qig_shd.g_old_rec.excld_flag
508: ,p_business_group_id_o
509: => ben_qig_shd.g_old_rec.business_group_id
510: ,p_vrbl_rt_prfl_id_o
511: => ben_qig_shd.g_old_rec.vrbl_rt_prfl_id

Line 509: => ben_qig_shd.g_old_rec.business_group_id

505: => ben_qig_shd.g_old_rec.quar_in_grade_cd
506: ,p_excld_flag_o
507: => ben_qig_shd.g_old_rec.excld_flag
508: ,p_business_group_id_o
509: => ben_qig_shd.g_old_rec.business_group_id
510: ,p_vrbl_rt_prfl_id_o
511: => ben_qig_shd.g_old_rec.vrbl_rt_prfl_id
512: ,p_object_version_number_o
513: => ben_qig_shd.g_old_rec.object_version_number

Line 511: => ben_qig_shd.g_old_rec.vrbl_rt_prfl_id

507: => ben_qig_shd.g_old_rec.excld_flag
508: ,p_business_group_id_o
509: => ben_qig_shd.g_old_rec.business_group_id
510: ,p_vrbl_rt_prfl_id_o
511: => ben_qig_shd.g_old_rec.vrbl_rt_prfl_id
512: ,p_object_version_number_o
513: => ben_qig_shd.g_old_rec.object_version_number
514: ,p_ordr_num_o
515: => ben_qig_shd.g_old_rec.ordr_num

Line 513: => ben_qig_shd.g_old_rec.object_version_number

509: => ben_qig_shd.g_old_rec.business_group_id
510: ,p_vrbl_rt_prfl_id_o
511: => ben_qig_shd.g_old_rec.vrbl_rt_prfl_id
512: ,p_object_version_number_o
513: => ben_qig_shd.g_old_rec.object_version_number
514: ,p_ordr_num_o
515: => ben_qig_shd.g_old_rec.ordr_num
516: ,p_qig_attribute_category_o
517: => ben_qig_shd.g_old_rec.qig_attribute_category

Line 515: => ben_qig_shd.g_old_rec.ordr_num

511: => ben_qig_shd.g_old_rec.vrbl_rt_prfl_id
512: ,p_object_version_number_o
513: => ben_qig_shd.g_old_rec.object_version_number
514: ,p_ordr_num_o
515: => ben_qig_shd.g_old_rec.ordr_num
516: ,p_qig_attribute_category_o
517: => ben_qig_shd.g_old_rec.qig_attribute_category
518: ,p_qig_attribute1_o
519: => ben_qig_shd.g_old_rec.qig_attribute1

Line 517: => ben_qig_shd.g_old_rec.qig_attribute_category

513: => ben_qig_shd.g_old_rec.object_version_number
514: ,p_ordr_num_o
515: => ben_qig_shd.g_old_rec.ordr_num
516: ,p_qig_attribute_category_o
517: => ben_qig_shd.g_old_rec.qig_attribute_category
518: ,p_qig_attribute1_o
519: => ben_qig_shd.g_old_rec.qig_attribute1
520: ,p_qig_attribute2_o
521: => ben_qig_shd.g_old_rec.qig_attribute2

Line 519: => ben_qig_shd.g_old_rec.qig_attribute1

515: => ben_qig_shd.g_old_rec.ordr_num
516: ,p_qig_attribute_category_o
517: => ben_qig_shd.g_old_rec.qig_attribute_category
518: ,p_qig_attribute1_o
519: => ben_qig_shd.g_old_rec.qig_attribute1
520: ,p_qig_attribute2_o
521: => ben_qig_shd.g_old_rec.qig_attribute2
522: ,p_qig_attribute3_o
523: => ben_qig_shd.g_old_rec.qig_attribute3

Line 521: => ben_qig_shd.g_old_rec.qig_attribute2

517: => ben_qig_shd.g_old_rec.qig_attribute_category
518: ,p_qig_attribute1_o
519: => ben_qig_shd.g_old_rec.qig_attribute1
520: ,p_qig_attribute2_o
521: => ben_qig_shd.g_old_rec.qig_attribute2
522: ,p_qig_attribute3_o
523: => ben_qig_shd.g_old_rec.qig_attribute3
524: ,p_qig_attribute4_o
525: => ben_qig_shd.g_old_rec.qig_attribute4

Line 523: => ben_qig_shd.g_old_rec.qig_attribute3

519: => ben_qig_shd.g_old_rec.qig_attribute1
520: ,p_qig_attribute2_o
521: => ben_qig_shd.g_old_rec.qig_attribute2
522: ,p_qig_attribute3_o
523: => ben_qig_shd.g_old_rec.qig_attribute3
524: ,p_qig_attribute4_o
525: => ben_qig_shd.g_old_rec.qig_attribute4
526: ,p_qig_attribute5_o
527: => ben_qig_shd.g_old_rec.qig_attribute5

Line 525: => ben_qig_shd.g_old_rec.qig_attribute4

521: => ben_qig_shd.g_old_rec.qig_attribute2
522: ,p_qig_attribute3_o
523: => ben_qig_shd.g_old_rec.qig_attribute3
524: ,p_qig_attribute4_o
525: => ben_qig_shd.g_old_rec.qig_attribute4
526: ,p_qig_attribute5_o
527: => ben_qig_shd.g_old_rec.qig_attribute5
528: ,p_qig_attribute6_o
529: => ben_qig_shd.g_old_rec.qig_attribute6

Line 527: => ben_qig_shd.g_old_rec.qig_attribute5

523: => ben_qig_shd.g_old_rec.qig_attribute3
524: ,p_qig_attribute4_o
525: => ben_qig_shd.g_old_rec.qig_attribute4
526: ,p_qig_attribute5_o
527: => ben_qig_shd.g_old_rec.qig_attribute5
528: ,p_qig_attribute6_o
529: => ben_qig_shd.g_old_rec.qig_attribute6
530: ,p_qig_attribute7_o
531: => ben_qig_shd.g_old_rec.qig_attribute7

Line 529: => ben_qig_shd.g_old_rec.qig_attribute6

525: => ben_qig_shd.g_old_rec.qig_attribute4
526: ,p_qig_attribute5_o
527: => ben_qig_shd.g_old_rec.qig_attribute5
528: ,p_qig_attribute6_o
529: => ben_qig_shd.g_old_rec.qig_attribute6
530: ,p_qig_attribute7_o
531: => ben_qig_shd.g_old_rec.qig_attribute7
532: ,p_qig_attribute8_o
533: => ben_qig_shd.g_old_rec.qig_attribute8

Line 531: => ben_qig_shd.g_old_rec.qig_attribute7

527: => ben_qig_shd.g_old_rec.qig_attribute5
528: ,p_qig_attribute6_o
529: => ben_qig_shd.g_old_rec.qig_attribute6
530: ,p_qig_attribute7_o
531: => ben_qig_shd.g_old_rec.qig_attribute7
532: ,p_qig_attribute8_o
533: => ben_qig_shd.g_old_rec.qig_attribute8
534: ,p_qig_attribute9_o
535: => ben_qig_shd.g_old_rec.qig_attribute9

Line 533: => ben_qig_shd.g_old_rec.qig_attribute8

529: => ben_qig_shd.g_old_rec.qig_attribute6
530: ,p_qig_attribute7_o
531: => ben_qig_shd.g_old_rec.qig_attribute7
532: ,p_qig_attribute8_o
533: => ben_qig_shd.g_old_rec.qig_attribute8
534: ,p_qig_attribute9_o
535: => ben_qig_shd.g_old_rec.qig_attribute9
536: ,p_qig_attribute10_o
537: => ben_qig_shd.g_old_rec.qig_attribute10

Line 535: => ben_qig_shd.g_old_rec.qig_attribute9

531: => ben_qig_shd.g_old_rec.qig_attribute7
532: ,p_qig_attribute8_o
533: => ben_qig_shd.g_old_rec.qig_attribute8
534: ,p_qig_attribute9_o
535: => ben_qig_shd.g_old_rec.qig_attribute9
536: ,p_qig_attribute10_o
537: => ben_qig_shd.g_old_rec.qig_attribute10
538: ,p_qig_attribute11_o
539: => ben_qig_shd.g_old_rec.qig_attribute11

Line 537: => ben_qig_shd.g_old_rec.qig_attribute10

533: => ben_qig_shd.g_old_rec.qig_attribute8
534: ,p_qig_attribute9_o
535: => ben_qig_shd.g_old_rec.qig_attribute9
536: ,p_qig_attribute10_o
537: => ben_qig_shd.g_old_rec.qig_attribute10
538: ,p_qig_attribute11_o
539: => ben_qig_shd.g_old_rec.qig_attribute11
540: ,p_qig_attribute12_o
541: => ben_qig_shd.g_old_rec.qig_attribute12

Line 539: => ben_qig_shd.g_old_rec.qig_attribute11

535: => ben_qig_shd.g_old_rec.qig_attribute9
536: ,p_qig_attribute10_o
537: => ben_qig_shd.g_old_rec.qig_attribute10
538: ,p_qig_attribute11_o
539: => ben_qig_shd.g_old_rec.qig_attribute11
540: ,p_qig_attribute12_o
541: => ben_qig_shd.g_old_rec.qig_attribute12
542: ,p_qig_attribute13_o
543: => ben_qig_shd.g_old_rec.qig_attribute13

Line 541: => ben_qig_shd.g_old_rec.qig_attribute12

537: => ben_qig_shd.g_old_rec.qig_attribute10
538: ,p_qig_attribute11_o
539: => ben_qig_shd.g_old_rec.qig_attribute11
540: ,p_qig_attribute12_o
541: => ben_qig_shd.g_old_rec.qig_attribute12
542: ,p_qig_attribute13_o
543: => ben_qig_shd.g_old_rec.qig_attribute13
544: ,p_qig_attribute14_o
545: => ben_qig_shd.g_old_rec.qig_attribute14

Line 543: => ben_qig_shd.g_old_rec.qig_attribute13

539: => ben_qig_shd.g_old_rec.qig_attribute11
540: ,p_qig_attribute12_o
541: => ben_qig_shd.g_old_rec.qig_attribute12
542: ,p_qig_attribute13_o
543: => ben_qig_shd.g_old_rec.qig_attribute13
544: ,p_qig_attribute14_o
545: => ben_qig_shd.g_old_rec.qig_attribute14
546: ,p_qig_attribute15_o
547: => ben_qig_shd.g_old_rec.qig_attribute15

Line 545: => ben_qig_shd.g_old_rec.qig_attribute14

541: => ben_qig_shd.g_old_rec.qig_attribute12
542: ,p_qig_attribute13_o
543: => ben_qig_shd.g_old_rec.qig_attribute13
544: ,p_qig_attribute14_o
545: => ben_qig_shd.g_old_rec.qig_attribute14
546: ,p_qig_attribute15_o
547: => ben_qig_shd.g_old_rec.qig_attribute15
548: ,p_qig_attribute16_o
549: => ben_qig_shd.g_old_rec.qig_attribute16

Line 547: => ben_qig_shd.g_old_rec.qig_attribute15

543: => ben_qig_shd.g_old_rec.qig_attribute13
544: ,p_qig_attribute14_o
545: => ben_qig_shd.g_old_rec.qig_attribute14
546: ,p_qig_attribute15_o
547: => ben_qig_shd.g_old_rec.qig_attribute15
548: ,p_qig_attribute16_o
549: => ben_qig_shd.g_old_rec.qig_attribute16
550: ,p_qig_attribute17_o
551: => ben_qig_shd.g_old_rec.qig_attribute17

Line 549: => ben_qig_shd.g_old_rec.qig_attribute16

545: => ben_qig_shd.g_old_rec.qig_attribute14
546: ,p_qig_attribute15_o
547: => ben_qig_shd.g_old_rec.qig_attribute15
548: ,p_qig_attribute16_o
549: => ben_qig_shd.g_old_rec.qig_attribute16
550: ,p_qig_attribute17_o
551: => ben_qig_shd.g_old_rec.qig_attribute17
552: ,p_qig_attribute18_o
553: => ben_qig_shd.g_old_rec.qig_attribute18

Line 551: => ben_qig_shd.g_old_rec.qig_attribute17

547: => ben_qig_shd.g_old_rec.qig_attribute15
548: ,p_qig_attribute16_o
549: => ben_qig_shd.g_old_rec.qig_attribute16
550: ,p_qig_attribute17_o
551: => ben_qig_shd.g_old_rec.qig_attribute17
552: ,p_qig_attribute18_o
553: => ben_qig_shd.g_old_rec.qig_attribute18
554: ,p_qig_attribute19_o
555: => ben_qig_shd.g_old_rec.qig_attribute19

Line 553: => ben_qig_shd.g_old_rec.qig_attribute18

549: => ben_qig_shd.g_old_rec.qig_attribute16
550: ,p_qig_attribute17_o
551: => ben_qig_shd.g_old_rec.qig_attribute17
552: ,p_qig_attribute18_o
553: => ben_qig_shd.g_old_rec.qig_attribute18
554: ,p_qig_attribute19_o
555: => ben_qig_shd.g_old_rec.qig_attribute19
556: ,p_qig_attribute20_o
557: => ben_qig_shd.g_old_rec.qig_attribute20

Line 555: => ben_qig_shd.g_old_rec.qig_attribute19

551: => ben_qig_shd.g_old_rec.qig_attribute17
552: ,p_qig_attribute18_o
553: => ben_qig_shd.g_old_rec.qig_attribute18
554: ,p_qig_attribute19_o
555: => ben_qig_shd.g_old_rec.qig_attribute19
556: ,p_qig_attribute20_o
557: => ben_qig_shd.g_old_rec.qig_attribute20
558: ,p_qig_attribute21_o
559: => ben_qig_shd.g_old_rec.qig_attribute21

Line 557: => ben_qig_shd.g_old_rec.qig_attribute20

553: => ben_qig_shd.g_old_rec.qig_attribute18
554: ,p_qig_attribute19_o
555: => ben_qig_shd.g_old_rec.qig_attribute19
556: ,p_qig_attribute20_o
557: => ben_qig_shd.g_old_rec.qig_attribute20
558: ,p_qig_attribute21_o
559: => ben_qig_shd.g_old_rec.qig_attribute21
560: ,p_qig_attribute22_o
561: => ben_qig_shd.g_old_rec.qig_attribute22

Line 559: => ben_qig_shd.g_old_rec.qig_attribute21

555: => ben_qig_shd.g_old_rec.qig_attribute19
556: ,p_qig_attribute20_o
557: => ben_qig_shd.g_old_rec.qig_attribute20
558: ,p_qig_attribute21_o
559: => ben_qig_shd.g_old_rec.qig_attribute21
560: ,p_qig_attribute22_o
561: => ben_qig_shd.g_old_rec.qig_attribute22
562: ,p_qig_attribute23_o
563: => ben_qig_shd.g_old_rec.qig_attribute23

Line 561: => ben_qig_shd.g_old_rec.qig_attribute22

557: => ben_qig_shd.g_old_rec.qig_attribute20
558: ,p_qig_attribute21_o
559: => ben_qig_shd.g_old_rec.qig_attribute21
560: ,p_qig_attribute22_o
561: => ben_qig_shd.g_old_rec.qig_attribute22
562: ,p_qig_attribute23_o
563: => ben_qig_shd.g_old_rec.qig_attribute23
564: ,p_qig_attribute24_o
565: => ben_qig_shd.g_old_rec.qig_attribute24

Line 563: => ben_qig_shd.g_old_rec.qig_attribute23

559: => ben_qig_shd.g_old_rec.qig_attribute21
560: ,p_qig_attribute22_o
561: => ben_qig_shd.g_old_rec.qig_attribute22
562: ,p_qig_attribute23_o
563: => ben_qig_shd.g_old_rec.qig_attribute23
564: ,p_qig_attribute24_o
565: => ben_qig_shd.g_old_rec.qig_attribute24
566: ,p_qig_attribute25_o
567: => ben_qig_shd.g_old_rec.qig_attribute25

Line 565: => ben_qig_shd.g_old_rec.qig_attribute24

561: => ben_qig_shd.g_old_rec.qig_attribute22
562: ,p_qig_attribute23_o
563: => ben_qig_shd.g_old_rec.qig_attribute23
564: ,p_qig_attribute24_o
565: => ben_qig_shd.g_old_rec.qig_attribute24
566: ,p_qig_attribute25_o
567: => ben_qig_shd.g_old_rec.qig_attribute25
568: ,p_qig_attribute26_o
569: => ben_qig_shd.g_old_rec.qig_attribute26

Line 567: => ben_qig_shd.g_old_rec.qig_attribute25

563: => ben_qig_shd.g_old_rec.qig_attribute23
564: ,p_qig_attribute24_o
565: => ben_qig_shd.g_old_rec.qig_attribute24
566: ,p_qig_attribute25_o
567: => ben_qig_shd.g_old_rec.qig_attribute25
568: ,p_qig_attribute26_o
569: => ben_qig_shd.g_old_rec.qig_attribute26
570: ,p_qig_attribute27_o
571: => ben_qig_shd.g_old_rec.qig_attribute27

Line 569: => ben_qig_shd.g_old_rec.qig_attribute26

565: => ben_qig_shd.g_old_rec.qig_attribute24
566: ,p_qig_attribute25_o
567: => ben_qig_shd.g_old_rec.qig_attribute25
568: ,p_qig_attribute26_o
569: => ben_qig_shd.g_old_rec.qig_attribute26
570: ,p_qig_attribute27_o
571: => ben_qig_shd.g_old_rec.qig_attribute27
572: ,p_qig_attribute28_o
573: => ben_qig_shd.g_old_rec.qig_attribute28

Line 571: => ben_qig_shd.g_old_rec.qig_attribute27

567: => ben_qig_shd.g_old_rec.qig_attribute25
568: ,p_qig_attribute26_o
569: => ben_qig_shd.g_old_rec.qig_attribute26
570: ,p_qig_attribute27_o
571: => ben_qig_shd.g_old_rec.qig_attribute27
572: ,p_qig_attribute28_o
573: => ben_qig_shd.g_old_rec.qig_attribute28
574: ,p_qig_attribute29_o
575: => ben_qig_shd.g_old_rec.qig_attribute29

Line 573: => ben_qig_shd.g_old_rec.qig_attribute28

569: => ben_qig_shd.g_old_rec.qig_attribute26
570: ,p_qig_attribute27_o
571: => ben_qig_shd.g_old_rec.qig_attribute27
572: ,p_qig_attribute28_o
573: => ben_qig_shd.g_old_rec.qig_attribute28
574: ,p_qig_attribute29_o
575: => ben_qig_shd.g_old_rec.qig_attribute29
576: ,p_qig_attribute30_o
577: => ben_qig_shd.g_old_rec.qig_attribute30

Line 575: => ben_qig_shd.g_old_rec.qig_attribute29

571: => ben_qig_shd.g_old_rec.qig_attribute27
572: ,p_qig_attribute28_o
573: => ben_qig_shd.g_old_rec.qig_attribute28
574: ,p_qig_attribute29_o
575: => ben_qig_shd.g_old_rec.qig_attribute29
576: ,p_qig_attribute30_o
577: => ben_qig_shd.g_old_rec.qig_attribute30
578: );
579: --

Line 577: => ben_qig_shd.g_old_rec.qig_attribute30

573: => ben_qig_shd.g_old_rec.qig_attribute28
574: ,p_qig_attribute29_o
575: => ben_qig_shd.g_old_rec.qig_attribute29
576: ,p_qig_attribute30_o
577: => ben_qig_shd.g_old_rec.qig_attribute30
578: );
579: --
580: exception
581: --

Line 637: (p_rec in out nocopy ben_qig_shd.g_rec_type

633: --
634: -- {End Of Comments}
635: -- ----------------------------------------------------------------------------
636: Procedure convert_defs
637: (p_rec in out nocopy ben_qig_shd.g_rec_type
638: ) is
639: --
640: Begin
641: --

Line 649: ben_qig_shd.g_old_rec.quar_in_grade_cd;

645: -- is being used then we must set to the 'current' argument value.
646: --
647: If (p_rec.quar_in_grade_cd = hr_api.g_varchar2) then
648: p_rec.quar_in_grade_cd :=
649: ben_qig_shd.g_old_rec.quar_in_grade_cd;
650: End If;
651: If (p_rec.excld_flag = hr_api.g_varchar2) then
652: p_rec.excld_flag :=
653: ben_qig_shd.g_old_rec.excld_flag;

Line 653: ben_qig_shd.g_old_rec.excld_flag;

649: ben_qig_shd.g_old_rec.quar_in_grade_cd;
650: End If;
651: If (p_rec.excld_flag = hr_api.g_varchar2) then
652: p_rec.excld_flag :=
653: ben_qig_shd.g_old_rec.excld_flag;
654: End If;
655: If (p_rec.business_group_id = hr_api.g_number) then
656: p_rec.business_group_id :=
657: ben_qig_shd.g_old_rec.business_group_id;

Line 657: ben_qig_shd.g_old_rec.business_group_id;

653: ben_qig_shd.g_old_rec.excld_flag;
654: End If;
655: If (p_rec.business_group_id = hr_api.g_number) then
656: p_rec.business_group_id :=
657: ben_qig_shd.g_old_rec.business_group_id;
658: End If;
659: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
660: p_rec.vrbl_rt_prfl_id :=
661: ben_qig_shd.g_old_rec.vrbl_rt_prfl_id;

Line 661: ben_qig_shd.g_old_rec.vrbl_rt_prfl_id;

657: ben_qig_shd.g_old_rec.business_group_id;
658: End If;
659: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
660: p_rec.vrbl_rt_prfl_id :=
661: ben_qig_shd.g_old_rec.vrbl_rt_prfl_id;
662: End If;
663: If (p_rec.ordr_num = hr_api.g_number) then
664: p_rec.ordr_num :=
665: ben_qig_shd.g_old_rec.ordr_num;

Line 665: ben_qig_shd.g_old_rec.ordr_num;

661: ben_qig_shd.g_old_rec.vrbl_rt_prfl_id;
662: End If;
663: If (p_rec.ordr_num = hr_api.g_number) then
664: p_rec.ordr_num :=
665: ben_qig_shd.g_old_rec.ordr_num;
666: End If;
667: If (p_rec.qig_attribute_category = hr_api.g_varchar2) then
668: p_rec.qig_attribute_category :=
669: ben_qig_shd.g_old_rec.qig_attribute_category;

Line 669: ben_qig_shd.g_old_rec.qig_attribute_category;

665: ben_qig_shd.g_old_rec.ordr_num;
666: End If;
667: If (p_rec.qig_attribute_category = hr_api.g_varchar2) then
668: p_rec.qig_attribute_category :=
669: ben_qig_shd.g_old_rec.qig_attribute_category;
670: End If;
671: If (p_rec.qig_attribute1 = hr_api.g_varchar2) then
672: p_rec.qig_attribute1 :=
673: ben_qig_shd.g_old_rec.qig_attribute1;

Line 673: ben_qig_shd.g_old_rec.qig_attribute1;

669: ben_qig_shd.g_old_rec.qig_attribute_category;
670: End If;
671: If (p_rec.qig_attribute1 = hr_api.g_varchar2) then
672: p_rec.qig_attribute1 :=
673: ben_qig_shd.g_old_rec.qig_attribute1;
674: End If;
675: If (p_rec.qig_attribute2 = hr_api.g_varchar2) then
676: p_rec.qig_attribute2 :=
677: ben_qig_shd.g_old_rec.qig_attribute2;

Line 677: ben_qig_shd.g_old_rec.qig_attribute2;

673: ben_qig_shd.g_old_rec.qig_attribute1;
674: End If;
675: If (p_rec.qig_attribute2 = hr_api.g_varchar2) then
676: p_rec.qig_attribute2 :=
677: ben_qig_shd.g_old_rec.qig_attribute2;
678: End If;
679: If (p_rec.qig_attribute3 = hr_api.g_varchar2) then
680: p_rec.qig_attribute3 :=
681: ben_qig_shd.g_old_rec.qig_attribute3;

Line 681: ben_qig_shd.g_old_rec.qig_attribute3;

677: ben_qig_shd.g_old_rec.qig_attribute2;
678: End If;
679: If (p_rec.qig_attribute3 = hr_api.g_varchar2) then
680: p_rec.qig_attribute3 :=
681: ben_qig_shd.g_old_rec.qig_attribute3;
682: End If;
683: If (p_rec.qig_attribute4 = hr_api.g_varchar2) then
684: p_rec.qig_attribute4 :=
685: ben_qig_shd.g_old_rec.qig_attribute4;

Line 685: ben_qig_shd.g_old_rec.qig_attribute4;

681: ben_qig_shd.g_old_rec.qig_attribute3;
682: End If;
683: If (p_rec.qig_attribute4 = hr_api.g_varchar2) then
684: p_rec.qig_attribute4 :=
685: ben_qig_shd.g_old_rec.qig_attribute4;
686: End If;
687: If (p_rec.qig_attribute5 = hr_api.g_varchar2) then
688: p_rec.qig_attribute5 :=
689: ben_qig_shd.g_old_rec.qig_attribute5;

Line 689: ben_qig_shd.g_old_rec.qig_attribute5;

685: ben_qig_shd.g_old_rec.qig_attribute4;
686: End If;
687: If (p_rec.qig_attribute5 = hr_api.g_varchar2) then
688: p_rec.qig_attribute5 :=
689: ben_qig_shd.g_old_rec.qig_attribute5;
690: End If;
691: If (p_rec.qig_attribute6 = hr_api.g_varchar2) then
692: p_rec.qig_attribute6 :=
693: ben_qig_shd.g_old_rec.qig_attribute6;

Line 693: ben_qig_shd.g_old_rec.qig_attribute6;

689: ben_qig_shd.g_old_rec.qig_attribute5;
690: End If;
691: If (p_rec.qig_attribute6 = hr_api.g_varchar2) then
692: p_rec.qig_attribute6 :=
693: ben_qig_shd.g_old_rec.qig_attribute6;
694: End If;
695: If (p_rec.qig_attribute7 = hr_api.g_varchar2) then
696: p_rec.qig_attribute7 :=
697: ben_qig_shd.g_old_rec.qig_attribute7;

Line 697: ben_qig_shd.g_old_rec.qig_attribute7;

693: ben_qig_shd.g_old_rec.qig_attribute6;
694: End If;
695: If (p_rec.qig_attribute7 = hr_api.g_varchar2) then
696: p_rec.qig_attribute7 :=
697: ben_qig_shd.g_old_rec.qig_attribute7;
698: End If;
699: If (p_rec.qig_attribute8 = hr_api.g_varchar2) then
700: p_rec.qig_attribute8 :=
701: ben_qig_shd.g_old_rec.qig_attribute8;

Line 701: ben_qig_shd.g_old_rec.qig_attribute8;

697: ben_qig_shd.g_old_rec.qig_attribute7;
698: End If;
699: If (p_rec.qig_attribute8 = hr_api.g_varchar2) then
700: p_rec.qig_attribute8 :=
701: ben_qig_shd.g_old_rec.qig_attribute8;
702: End If;
703: If (p_rec.qig_attribute9 = hr_api.g_varchar2) then
704: p_rec.qig_attribute9 :=
705: ben_qig_shd.g_old_rec.qig_attribute9;

Line 705: ben_qig_shd.g_old_rec.qig_attribute9;

701: ben_qig_shd.g_old_rec.qig_attribute8;
702: End If;
703: If (p_rec.qig_attribute9 = hr_api.g_varchar2) then
704: p_rec.qig_attribute9 :=
705: ben_qig_shd.g_old_rec.qig_attribute9;
706: End If;
707: If (p_rec.qig_attribute10 = hr_api.g_varchar2) then
708: p_rec.qig_attribute10 :=
709: ben_qig_shd.g_old_rec.qig_attribute10;

Line 709: ben_qig_shd.g_old_rec.qig_attribute10;

705: ben_qig_shd.g_old_rec.qig_attribute9;
706: End If;
707: If (p_rec.qig_attribute10 = hr_api.g_varchar2) then
708: p_rec.qig_attribute10 :=
709: ben_qig_shd.g_old_rec.qig_attribute10;
710: End If;
711: If (p_rec.qig_attribute11 = hr_api.g_varchar2) then
712: p_rec.qig_attribute11 :=
713: ben_qig_shd.g_old_rec.qig_attribute11;

Line 713: ben_qig_shd.g_old_rec.qig_attribute11;

709: ben_qig_shd.g_old_rec.qig_attribute10;
710: End If;
711: If (p_rec.qig_attribute11 = hr_api.g_varchar2) then
712: p_rec.qig_attribute11 :=
713: ben_qig_shd.g_old_rec.qig_attribute11;
714: End If;
715: If (p_rec.qig_attribute12 = hr_api.g_varchar2) then
716: p_rec.qig_attribute12 :=
717: ben_qig_shd.g_old_rec.qig_attribute12;

Line 717: ben_qig_shd.g_old_rec.qig_attribute12;

713: ben_qig_shd.g_old_rec.qig_attribute11;
714: End If;
715: If (p_rec.qig_attribute12 = hr_api.g_varchar2) then
716: p_rec.qig_attribute12 :=
717: ben_qig_shd.g_old_rec.qig_attribute12;
718: End If;
719: If (p_rec.qig_attribute13 = hr_api.g_varchar2) then
720: p_rec.qig_attribute13 :=
721: ben_qig_shd.g_old_rec.qig_attribute13;

Line 721: ben_qig_shd.g_old_rec.qig_attribute13;

717: ben_qig_shd.g_old_rec.qig_attribute12;
718: End If;
719: If (p_rec.qig_attribute13 = hr_api.g_varchar2) then
720: p_rec.qig_attribute13 :=
721: ben_qig_shd.g_old_rec.qig_attribute13;
722: End If;
723: If (p_rec.qig_attribute14 = hr_api.g_varchar2) then
724: p_rec.qig_attribute14 :=
725: ben_qig_shd.g_old_rec.qig_attribute14;

Line 725: ben_qig_shd.g_old_rec.qig_attribute14;

721: ben_qig_shd.g_old_rec.qig_attribute13;
722: End If;
723: If (p_rec.qig_attribute14 = hr_api.g_varchar2) then
724: p_rec.qig_attribute14 :=
725: ben_qig_shd.g_old_rec.qig_attribute14;
726: End If;
727: If (p_rec.qig_attribute15 = hr_api.g_varchar2) then
728: p_rec.qig_attribute15 :=
729: ben_qig_shd.g_old_rec.qig_attribute15;

Line 729: ben_qig_shd.g_old_rec.qig_attribute15;

725: ben_qig_shd.g_old_rec.qig_attribute14;
726: End If;
727: If (p_rec.qig_attribute15 = hr_api.g_varchar2) then
728: p_rec.qig_attribute15 :=
729: ben_qig_shd.g_old_rec.qig_attribute15;
730: End If;
731: If (p_rec.qig_attribute16 = hr_api.g_varchar2) then
732: p_rec.qig_attribute16 :=
733: ben_qig_shd.g_old_rec.qig_attribute16;

Line 733: ben_qig_shd.g_old_rec.qig_attribute16;

729: ben_qig_shd.g_old_rec.qig_attribute15;
730: End If;
731: If (p_rec.qig_attribute16 = hr_api.g_varchar2) then
732: p_rec.qig_attribute16 :=
733: ben_qig_shd.g_old_rec.qig_attribute16;
734: End If;
735: If (p_rec.qig_attribute17 = hr_api.g_varchar2) then
736: p_rec.qig_attribute17 :=
737: ben_qig_shd.g_old_rec.qig_attribute17;

Line 737: ben_qig_shd.g_old_rec.qig_attribute17;

733: ben_qig_shd.g_old_rec.qig_attribute16;
734: End If;
735: If (p_rec.qig_attribute17 = hr_api.g_varchar2) then
736: p_rec.qig_attribute17 :=
737: ben_qig_shd.g_old_rec.qig_attribute17;
738: End If;
739: If (p_rec.qig_attribute18 = hr_api.g_varchar2) then
740: p_rec.qig_attribute18 :=
741: ben_qig_shd.g_old_rec.qig_attribute18;

Line 741: ben_qig_shd.g_old_rec.qig_attribute18;

737: ben_qig_shd.g_old_rec.qig_attribute17;
738: End If;
739: If (p_rec.qig_attribute18 = hr_api.g_varchar2) then
740: p_rec.qig_attribute18 :=
741: ben_qig_shd.g_old_rec.qig_attribute18;
742: End If;
743: If (p_rec.qig_attribute19 = hr_api.g_varchar2) then
744: p_rec.qig_attribute19 :=
745: ben_qig_shd.g_old_rec.qig_attribute19;

Line 745: ben_qig_shd.g_old_rec.qig_attribute19;

741: ben_qig_shd.g_old_rec.qig_attribute18;
742: End If;
743: If (p_rec.qig_attribute19 = hr_api.g_varchar2) then
744: p_rec.qig_attribute19 :=
745: ben_qig_shd.g_old_rec.qig_attribute19;
746: End If;
747: If (p_rec.qig_attribute20 = hr_api.g_varchar2) then
748: p_rec.qig_attribute20 :=
749: ben_qig_shd.g_old_rec.qig_attribute20;

Line 749: ben_qig_shd.g_old_rec.qig_attribute20;

745: ben_qig_shd.g_old_rec.qig_attribute19;
746: End If;
747: If (p_rec.qig_attribute20 = hr_api.g_varchar2) then
748: p_rec.qig_attribute20 :=
749: ben_qig_shd.g_old_rec.qig_attribute20;
750: End If;
751: If (p_rec.qig_attribute21 = hr_api.g_varchar2) then
752: p_rec.qig_attribute21 :=
753: ben_qig_shd.g_old_rec.qig_attribute21;

Line 753: ben_qig_shd.g_old_rec.qig_attribute21;

749: ben_qig_shd.g_old_rec.qig_attribute20;
750: End If;
751: If (p_rec.qig_attribute21 = hr_api.g_varchar2) then
752: p_rec.qig_attribute21 :=
753: ben_qig_shd.g_old_rec.qig_attribute21;
754: End If;
755: If (p_rec.qig_attribute22 = hr_api.g_varchar2) then
756: p_rec.qig_attribute22 :=
757: ben_qig_shd.g_old_rec.qig_attribute22;

Line 757: ben_qig_shd.g_old_rec.qig_attribute22;

753: ben_qig_shd.g_old_rec.qig_attribute21;
754: End If;
755: If (p_rec.qig_attribute22 = hr_api.g_varchar2) then
756: p_rec.qig_attribute22 :=
757: ben_qig_shd.g_old_rec.qig_attribute22;
758: End If;
759: If (p_rec.qig_attribute23 = hr_api.g_varchar2) then
760: p_rec.qig_attribute23 :=
761: ben_qig_shd.g_old_rec.qig_attribute23;

Line 761: ben_qig_shd.g_old_rec.qig_attribute23;

757: ben_qig_shd.g_old_rec.qig_attribute22;
758: End If;
759: If (p_rec.qig_attribute23 = hr_api.g_varchar2) then
760: p_rec.qig_attribute23 :=
761: ben_qig_shd.g_old_rec.qig_attribute23;
762: End If;
763: If (p_rec.qig_attribute24 = hr_api.g_varchar2) then
764: p_rec.qig_attribute24 :=
765: ben_qig_shd.g_old_rec.qig_attribute24;

Line 765: ben_qig_shd.g_old_rec.qig_attribute24;

761: ben_qig_shd.g_old_rec.qig_attribute23;
762: End If;
763: If (p_rec.qig_attribute24 = hr_api.g_varchar2) then
764: p_rec.qig_attribute24 :=
765: ben_qig_shd.g_old_rec.qig_attribute24;
766: End If;
767: If (p_rec.qig_attribute25 = hr_api.g_varchar2) then
768: p_rec.qig_attribute25 :=
769: ben_qig_shd.g_old_rec.qig_attribute25;

Line 769: ben_qig_shd.g_old_rec.qig_attribute25;

765: ben_qig_shd.g_old_rec.qig_attribute24;
766: End If;
767: If (p_rec.qig_attribute25 = hr_api.g_varchar2) then
768: p_rec.qig_attribute25 :=
769: ben_qig_shd.g_old_rec.qig_attribute25;
770: End If;
771: If (p_rec.qig_attribute26 = hr_api.g_varchar2) then
772: p_rec.qig_attribute26 :=
773: ben_qig_shd.g_old_rec.qig_attribute26;

Line 773: ben_qig_shd.g_old_rec.qig_attribute26;

769: ben_qig_shd.g_old_rec.qig_attribute25;
770: End If;
771: If (p_rec.qig_attribute26 = hr_api.g_varchar2) then
772: p_rec.qig_attribute26 :=
773: ben_qig_shd.g_old_rec.qig_attribute26;
774: End If;
775: If (p_rec.qig_attribute27 = hr_api.g_varchar2) then
776: p_rec.qig_attribute27 :=
777: ben_qig_shd.g_old_rec.qig_attribute27;

Line 777: ben_qig_shd.g_old_rec.qig_attribute27;

773: ben_qig_shd.g_old_rec.qig_attribute26;
774: End If;
775: If (p_rec.qig_attribute27 = hr_api.g_varchar2) then
776: p_rec.qig_attribute27 :=
777: ben_qig_shd.g_old_rec.qig_attribute27;
778: End If;
779: If (p_rec.qig_attribute28 = hr_api.g_varchar2) then
780: p_rec.qig_attribute28 :=
781: ben_qig_shd.g_old_rec.qig_attribute28;

Line 781: ben_qig_shd.g_old_rec.qig_attribute28;

777: ben_qig_shd.g_old_rec.qig_attribute27;
778: End If;
779: If (p_rec.qig_attribute28 = hr_api.g_varchar2) then
780: p_rec.qig_attribute28 :=
781: ben_qig_shd.g_old_rec.qig_attribute28;
782: End If;
783: If (p_rec.qig_attribute29 = hr_api.g_varchar2) then
784: p_rec.qig_attribute29 :=
785: ben_qig_shd.g_old_rec.qig_attribute29;

Line 785: ben_qig_shd.g_old_rec.qig_attribute29;

781: ben_qig_shd.g_old_rec.qig_attribute28;
782: End If;
783: If (p_rec.qig_attribute29 = hr_api.g_varchar2) then
784: p_rec.qig_attribute29 :=
785: ben_qig_shd.g_old_rec.qig_attribute29;
786: End If;
787: If (p_rec.qig_attribute30 = hr_api.g_varchar2) then
788: p_rec.qig_attribute30 :=
789: ben_qig_shd.g_old_rec.qig_attribute30;

Line 789: ben_qig_shd.g_old_rec.qig_attribute30;

785: ben_qig_shd.g_old_rec.qig_attribute29;
786: End If;
787: If (p_rec.qig_attribute30 = hr_api.g_varchar2) then
788: p_rec.qig_attribute30 :=
789: ben_qig_shd.g_old_rec.qig_attribute30;
790: End If;
791: --
792: End convert_defs;
793: --

Line 800: ,p_rec in out nocopy ben_qig_shd.g_rec_type

796: -- ----------------------------------------------------------------------------
797: Procedure upd
798: (p_effective_date in date
799: ,p_datetrack_mode in varchar2
800: ,p_rec in out nocopy ben_qig_shd.g_rec_type
801: ) is
802: --
803: l_proc varchar2(72) := g_package||'upd';
804: l_validation_start_date date;

Line 816: ben_qig_shd.lck

812: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
813: --
814: -- We must lock the row which we need to update.
815: --
816: ben_qig_shd.lck
817: (p_effective_date => p_effective_date
818: ,p_datetrack_mode => p_datetrack_mode
819: ,p_qua_in_gr_rt_id => p_rec.qua_in_gr_rt_id
820: ,p_object_version_number => p_rec.object_version_number

Line 926: l_rec ben_qig_shd.g_rec_type;

922: ,p_effective_start_date out nocopy date
923: ,p_effective_end_date out nocopy date
924: ) is
925: --
926: l_rec ben_qig_shd.g_rec_type;
927: l_proc varchar2(72) := g_package||'upd';
928: --
929: Begin
930: hr_utility.set_location('Entering:'||l_proc, 5);

Line 936: ben_qig_shd.convert_args

932: -- Call conversion function to turn arguments into the
933: -- l_rec structure.
934: --
935: l_rec :=
936: ben_qig_shd.convert_args
937: (p_qua_in_gr_rt_id
938: ,null
939: ,null
940: ,p_quar_in_grade_cd