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_CTY_UPD dependencies on BEN_CTY_SHD

Line 58: (p_rec in out nocopy ben_cty_shd.g_rec_type

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

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

Line 150: ben_cty_shd.constraint_error

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

Line 189: (p_rec in out nocopy ben_cty_shd.g_rec_type

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

Line 256: (p_rec in out nocopy ben_cty_shd.g_rec_type

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

Line 272: ben_cty_shd.upd_effective_end_date

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

Line 341: (p_rec in out nocopy ben_cty_shd.g_rec_type

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

Line 399: (p_rec in ben_cty_shd.g_rec_type

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

Line 504: => ben_cty_shd.g_old_rec.effective_start_date

500: => p_rec.cty_attribute29
501: ,p_cty_attribute30
502: => p_rec.cty_attribute30
503: ,p_effective_start_date_o
504: => ben_cty_shd.g_old_rec.effective_start_date
505: ,p_effective_end_date_o
506: => ben_cty_shd.g_old_rec.effective_end_date
507: ,p_competence_id_o
508: => ben_cty_shd.g_old_rec.competence_id

Line 506: => ben_cty_shd.g_old_rec.effective_end_date

502: => p_rec.cty_attribute30
503: ,p_effective_start_date_o
504: => ben_cty_shd.g_old_rec.effective_start_date
505: ,p_effective_end_date_o
506: => ben_cty_shd.g_old_rec.effective_end_date
507: ,p_competence_id_o
508: => ben_cty_shd.g_old_rec.competence_id
509: ,p_rating_level_id_o
510: => ben_cty_shd.g_old_rec.rating_level_id

Line 508: => ben_cty_shd.g_old_rec.competence_id

504: => ben_cty_shd.g_old_rec.effective_start_date
505: ,p_effective_end_date_o
506: => ben_cty_shd.g_old_rec.effective_end_date
507: ,p_competence_id_o
508: => ben_cty_shd.g_old_rec.competence_id
509: ,p_rating_level_id_o
510: => ben_cty_shd.g_old_rec.rating_level_id
511: ,p_excld_flag_o
512: => ben_cty_shd.g_old_rec.excld_flag

Line 510: => ben_cty_shd.g_old_rec.rating_level_id

506: => ben_cty_shd.g_old_rec.effective_end_date
507: ,p_competence_id_o
508: => ben_cty_shd.g_old_rec.competence_id
509: ,p_rating_level_id_o
510: => ben_cty_shd.g_old_rec.rating_level_id
511: ,p_excld_flag_o
512: => ben_cty_shd.g_old_rec.excld_flag
513: ,p_business_group_id_o
514: => ben_cty_shd.g_old_rec.business_group_id

Line 512: => ben_cty_shd.g_old_rec.excld_flag

508: => ben_cty_shd.g_old_rec.competence_id
509: ,p_rating_level_id_o
510: => ben_cty_shd.g_old_rec.rating_level_id
511: ,p_excld_flag_o
512: => ben_cty_shd.g_old_rec.excld_flag
513: ,p_business_group_id_o
514: => ben_cty_shd.g_old_rec.business_group_id
515: ,p_vrbl_rt_prfl_id_o
516: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id

Line 514: => ben_cty_shd.g_old_rec.business_group_id

510: => ben_cty_shd.g_old_rec.rating_level_id
511: ,p_excld_flag_o
512: => ben_cty_shd.g_old_rec.excld_flag
513: ,p_business_group_id_o
514: => ben_cty_shd.g_old_rec.business_group_id
515: ,p_vrbl_rt_prfl_id_o
516: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
517: ,p_object_version_number_o
518: => ben_cty_shd.g_old_rec.object_version_number

Line 516: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id

512: => ben_cty_shd.g_old_rec.excld_flag
513: ,p_business_group_id_o
514: => ben_cty_shd.g_old_rec.business_group_id
515: ,p_vrbl_rt_prfl_id_o
516: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
517: ,p_object_version_number_o
518: => ben_cty_shd.g_old_rec.object_version_number
519: ,p_ordr_num_o
520: => ben_cty_shd.g_old_rec.ordr_num

Line 518: => ben_cty_shd.g_old_rec.object_version_number

514: => ben_cty_shd.g_old_rec.business_group_id
515: ,p_vrbl_rt_prfl_id_o
516: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
517: ,p_object_version_number_o
518: => ben_cty_shd.g_old_rec.object_version_number
519: ,p_ordr_num_o
520: => ben_cty_shd.g_old_rec.ordr_num
521: ,p_cty_attribute_category_o
522: => ben_cty_shd.g_old_rec.cty_attribute_category

Line 520: => ben_cty_shd.g_old_rec.ordr_num

516: => ben_cty_shd.g_old_rec.vrbl_rt_prfl_id
517: ,p_object_version_number_o
518: => ben_cty_shd.g_old_rec.object_version_number
519: ,p_ordr_num_o
520: => ben_cty_shd.g_old_rec.ordr_num
521: ,p_cty_attribute_category_o
522: => ben_cty_shd.g_old_rec.cty_attribute_category
523: ,p_cty_attribute1_o
524: => ben_cty_shd.g_old_rec.cty_attribute1

Line 522: => ben_cty_shd.g_old_rec.cty_attribute_category

518: => ben_cty_shd.g_old_rec.object_version_number
519: ,p_ordr_num_o
520: => ben_cty_shd.g_old_rec.ordr_num
521: ,p_cty_attribute_category_o
522: => ben_cty_shd.g_old_rec.cty_attribute_category
523: ,p_cty_attribute1_o
524: => ben_cty_shd.g_old_rec.cty_attribute1
525: ,p_cty_attribute2_o
526: => ben_cty_shd.g_old_rec.cty_attribute2

Line 524: => ben_cty_shd.g_old_rec.cty_attribute1

520: => ben_cty_shd.g_old_rec.ordr_num
521: ,p_cty_attribute_category_o
522: => ben_cty_shd.g_old_rec.cty_attribute_category
523: ,p_cty_attribute1_o
524: => ben_cty_shd.g_old_rec.cty_attribute1
525: ,p_cty_attribute2_o
526: => ben_cty_shd.g_old_rec.cty_attribute2
527: ,p_cty_attribute3_o
528: => ben_cty_shd.g_old_rec.cty_attribute3

Line 526: => ben_cty_shd.g_old_rec.cty_attribute2

522: => ben_cty_shd.g_old_rec.cty_attribute_category
523: ,p_cty_attribute1_o
524: => ben_cty_shd.g_old_rec.cty_attribute1
525: ,p_cty_attribute2_o
526: => ben_cty_shd.g_old_rec.cty_attribute2
527: ,p_cty_attribute3_o
528: => ben_cty_shd.g_old_rec.cty_attribute3
529: ,p_cty_attribute4_o
530: => ben_cty_shd.g_old_rec.cty_attribute4

Line 528: => ben_cty_shd.g_old_rec.cty_attribute3

524: => ben_cty_shd.g_old_rec.cty_attribute1
525: ,p_cty_attribute2_o
526: => ben_cty_shd.g_old_rec.cty_attribute2
527: ,p_cty_attribute3_o
528: => ben_cty_shd.g_old_rec.cty_attribute3
529: ,p_cty_attribute4_o
530: => ben_cty_shd.g_old_rec.cty_attribute4
531: ,p_cty_attribute5_o
532: => ben_cty_shd.g_old_rec.cty_attribute5

Line 530: => ben_cty_shd.g_old_rec.cty_attribute4

526: => ben_cty_shd.g_old_rec.cty_attribute2
527: ,p_cty_attribute3_o
528: => ben_cty_shd.g_old_rec.cty_attribute3
529: ,p_cty_attribute4_o
530: => ben_cty_shd.g_old_rec.cty_attribute4
531: ,p_cty_attribute5_o
532: => ben_cty_shd.g_old_rec.cty_attribute5
533: ,p_cty_attribute6_o
534: => ben_cty_shd.g_old_rec.cty_attribute6

Line 532: => ben_cty_shd.g_old_rec.cty_attribute5

528: => ben_cty_shd.g_old_rec.cty_attribute3
529: ,p_cty_attribute4_o
530: => ben_cty_shd.g_old_rec.cty_attribute4
531: ,p_cty_attribute5_o
532: => ben_cty_shd.g_old_rec.cty_attribute5
533: ,p_cty_attribute6_o
534: => ben_cty_shd.g_old_rec.cty_attribute6
535: ,p_cty_attribute7_o
536: => ben_cty_shd.g_old_rec.cty_attribute7

Line 534: => ben_cty_shd.g_old_rec.cty_attribute6

530: => ben_cty_shd.g_old_rec.cty_attribute4
531: ,p_cty_attribute5_o
532: => ben_cty_shd.g_old_rec.cty_attribute5
533: ,p_cty_attribute6_o
534: => ben_cty_shd.g_old_rec.cty_attribute6
535: ,p_cty_attribute7_o
536: => ben_cty_shd.g_old_rec.cty_attribute7
537: ,p_cty_attribute8_o
538: => ben_cty_shd.g_old_rec.cty_attribute8

Line 536: => ben_cty_shd.g_old_rec.cty_attribute7

532: => ben_cty_shd.g_old_rec.cty_attribute5
533: ,p_cty_attribute6_o
534: => ben_cty_shd.g_old_rec.cty_attribute6
535: ,p_cty_attribute7_o
536: => ben_cty_shd.g_old_rec.cty_attribute7
537: ,p_cty_attribute8_o
538: => ben_cty_shd.g_old_rec.cty_attribute8
539: ,p_cty_attribute9_o
540: => ben_cty_shd.g_old_rec.cty_attribute9

Line 538: => ben_cty_shd.g_old_rec.cty_attribute8

534: => ben_cty_shd.g_old_rec.cty_attribute6
535: ,p_cty_attribute7_o
536: => ben_cty_shd.g_old_rec.cty_attribute7
537: ,p_cty_attribute8_o
538: => ben_cty_shd.g_old_rec.cty_attribute8
539: ,p_cty_attribute9_o
540: => ben_cty_shd.g_old_rec.cty_attribute9
541: ,p_cty_attribute10_o
542: => ben_cty_shd.g_old_rec.cty_attribute10

Line 540: => ben_cty_shd.g_old_rec.cty_attribute9

536: => ben_cty_shd.g_old_rec.cty_attribute7
537: ,p_cty_attribute8_o
538: => ben_cty_shd.g_old_rec.cty_attribute8
539: ,p_cty_attribute9_o
540: => ben_cty_shd.g_old_rec.cty_attribute9
541: ,p_cty_attribute10_o
542: => ben_cty_shd.g_old_rec.cty_attribute10
543: ,p_cty_attribute11_o
544: => ben_cty_shd.g_old_rec.cty_attribute11

Line 542: => ben_cty_shd.g_old_rec.cty_attribute10

538: => ben_cty_shd.g_old_rec.cty_attribute8
539: ,p_cty_attribute9_o
540: => ben_cty_shd.g_old_rec.cty_attribute9
541: ,p_cty_attribute10_o
542: => ben_cty_shd.g_old_rec.cty_attribute10
543: ,p_cty_attribute11_o
544: => ben_cty_shd.g_old_rec.cty_attribute11
545: ,p_cty_attribute12_o
546: => ben_cty_shd.g_old_rec.cty_attribute12

Line 544: => ben_cty_shd.g_old_rec.cty_attribute11

540: => ben_cty_shd.g_old_rec.cty_attribute9
541: ,p_cty_attribute10_o
542: => ben_cty_shd.g_old_rec.cty_attribute10
543: ,p_cty_attribute11_o
544: => ben_cty_shd.g_old_rec.cty_attribute11
545: ,p_cty_attribute12_o
546: => ben_cty_shd.g_old_rec.cty_attribute12
547: ,p_cty_attribute13_o
548: => ben_cty_shd.g_old_rec.cty_attribute13

Line 546: => ben_cty_shd.g_old_rec.cty_attribute12

542: => ben_cty_shd.g_old_rec.cty_attribute10
543: ,p_cty_attribute11_o
544: => ben_cty_shd.g_old_rec.cty_attribute11
545: ,p_cty_attribute12_o
546: => ben_cty_shd.g_old_rec.cty_attribute12
547: ,p_cty_attribute13_o
548: => ben_cty_shd.g_old_rec.cty_attribute13
549: ,p_cty_attribute14_o
550: => ben_cty_shd.g_old_rec.cty_attribute14

Line 548: => ben_cty_shd.g_old_rec.cty_attribute13

544: => ben_cty_shd.g_old_rec.cty_attribute11
545: ,p_cty_attribute12_o
546: => ben_cty_shd.g_old_rec.cty_attribute12
547: ,p_cty_attribute13_o
548: => ben_cty_shd.g_old_rec.cty_attribute13
549: ,p_cty_attribute14_o
550: => ben_cty_shd.g_old_rec.cty_attribute14
551: ,p_cty_attribute15_o
552: => ben_cty_shd.g_old_rec.cty_attribute15

Line 550: => ben_cty_shd.g_old_rec.cty_attribute14

546: => ben_cty_shd.g_old_rec.cty_attribute12
547: ,p_cty_attribute13_o
548: => ben_cty_shd.g_old_rec.cty_attribute13
549: ,p_cty_attribute14_o
550: => ben_cty_shd.g_old_rec.cty_attribute14
551: ,p_cty_attribute15_o
552: => ben_cty_shd.g_old_rec.cty_attribute15
553: ,p_cty_attribute16_o
554: => ben_cty_shd.g_old_rec.cty_attribute16

Line 552: => ben_cty_shd.g_old_rec.cty_attribute15

548: => ben_cty_shd.g_old_rec.cty_attribute13
549: ,p_cty_attribute14_o
550: => ben_cty_shd.g_old_rec.cty_attribute14
551: ,p_cty_attribute15_o
552: => ben_cty_shd.g_old_rec.cty_attribute15
553: ,p_cty_attribute16_o
554: => ben_cty_shd.g_old_rec.cty_attribute16
555: ,p_cty_attribute17_o
556: => ben_cty_shd.g_old_rec.cty_attribute17

Line 554: => ben_cty_shd.g_old_rec.cty_attribute16

550: => ben_cty_shd.g_old_rec.cty_attribute14
551: ,p_cty_attribute15_o
552: => ben_cty_shd.g_old_rec.cty_attribute15
553: ,p_cty_attribute16_o
554: => ben_cty_shd.g_old_rec.cty_attribute16
555: ,p_cty_attribute17_o
556: => ben_cty_shd.g_old_rec.cty_attribute17
557: ,p_cty_attribute18_o
558: => ben_cty_shd.g_old_rec.cty_attribute18

Line 556: => ben_cty_shd.g_old_rec.cty_attribute17

552: => ben_cty_shd.g_old_rec.cty_attribute15
553: ,p_cty_attribute16_o
554: => ben_cty_shd.g_old_rec.cty_attribute16
555: ,p_cty_attribute17_o
556: => ben_cty_shd.g_old_rec.cty_attribute17
557: ,p_cty_attribute18_o
558: => ben_cty_shd.g_old_rec.cty_attribute18
559: ,p_cty_attribute19_o
560: => ben_cty_shd.g_old_rec.cty_attribute19

Line 558: => ben_cty_shd.g_old_rec.cty_attribute18

554: => ben_cty_shd.g_old_rec.cty_attribute16
555: ,p_cty_attribute17_o
556: => ben_cty_shd.g_old_rec.cty_attribute17
557: ,p_cty_attribute18_o
558: => ben_cty_shd.g_old_rec.cty_attribute18
559: ,p_cty_attribute19_o
560: => ben_cty_shd.g_old_rec.cty_attribute19
561: ,p_cty_attribute20_o
562: => ben_cty_shd.g_old_rec.cty_attribute20

Line 560: => ben_cty_shd.g_old_rec.cty_attribute19

556: => ben_cty_shd.g_old_rec.cty_attribute17
557: ,p_cty_attribute18_o
558: => ben_cty_shd.g_old_rec.cty_attribute18
559: ,p_cty_attribute19_o
560: => ben_cty_shd.g_old_rec.cty_attribute19
561: ,p_cty_attribute20_o
562: => ben_cty_shd.g_old_rec.cty_attribute20
563: ,p_cty_attribute21_o
564: => ben_cty_shd.g_old_rec.cty_attribute21

Line 562: => ben_cty_shd.g_old_rec.cty_attribute20

558: => ben_cty_shd.g_old_rec.cty_attribute18
559: ,p_cty_attribute19_o
560: => ben_cty_shd.g_old_rec.cty_attribute19
561: ,p_cty_attribute20_o
562: => ben_cty_shd.g_old_rec.cty_attribute20
563: ,p_cty_attribute21_o
564: => ben_cty_shd.g_old_rec.cty_attribute21
565: ,p_cty_attribute22_o
566: => ben_cty_shd.g_old_rec.cty_attribute22

Line 564: => ben_cty_shd.g_old_rec.cty_attribute21

560: => ben_cty_shd.g_old_rec.cty_attribute19
561: ,p_cty_attribute20_o
562: => ben_cty_shd.g_old_rec.cty_attribute20
563: ,p_cty_attribute21_o
564: => ben_cty_shd.g_old_rec.cty_attribute21
565: ,p_cty_attribute22_o
566: => ben_cty_shd.g_old_rec.cty_attribute22
567: ,p_cty_attribute23_o
568: => ben_cty_shd.g_old_rec.cty_attribute23

Line 566: => ben_cty_shd.g_old_rec.cty_attribute22

562: => ben_cty_shd.g_old_rec.cty_attribute20
563: ,p_cty_attribute21_o
564: => ben_cty_shd.g_old_rec.cty_attribute21
565: ,p_cty_attribute22_o
566: => ben_cty_shd.g_old_rec.cty_attribute22
567: ,p_cty_attribute23_o
568: => ben_cty_shd.g_old_rec.cty_attribute23
569: ,p_cty_attribute24_o
570: => ben_cty_shd.g_old_rec.cty_attribute24

Line 568: => ben_cty_shd.g_old_rec.cty_attribute23

564: => ben_cty_shd.g_old_rec.cty_attribute21
565: ,p_cty_attribute22_o
566: => ben_cty_shd.g_old_rec.cty_attribute22
567: ,p_cty_attribute23_o
568: => ben_cty_shd.g_old_rec.cty_attribute23
569: ,p_cty_attribute24_o
570: => ben_cty_shd.g_old_rec.cty_attribute24
571: ,p_cty_attribute25_o
572: => ben_cty_shd.g_old_rec.cty_attribute25

Line 570: => ben_cty_shd.g_old_rec.cty_attribute24

566: => ben_cty_shd.g_old_rec.cty_attribute22
567: ,p_cty_attribute23_o
568: => ben_cty_shd.g_old_rec.cty_attribute23
569: ,p_cty_attribute24_o
570: => ben_cty_shd.g_old_rec.cty_attribute24
571: ,p_cty_attribute25_o
572: => ben_cty_shd.g_old_rec.cty_attribute25
573: ,p_cty_attribute26_o
574: => ben_cty_shd.g_old_rec.cty_attribute26

Line 572: => ben_cty_shd.g_old_rec.cty_attribute25

568: => ben_cty_shd.g_old_rec.cty_attribute23
569: ,p_cty_attribute24_o
570: => ben_cty_shd.g_old_rec.cty_attribute24
571: ,p_cty_attribute25_o
572: => ben_cty_shd.g_old_rec.cty_attribute25
573: ,p_cty_attribute26_o
574: => ben_cty_shd.g_old_rec.cty_attribute26
575: ,p_cty_attribute27_o
576: => ben_cty_shd.g_old_rec.cty_attribute27

Line 574: => ben_cty_shd.g_old_rec.cty_attribute26

570: => ben_cty_shd.g_old_rec.cty_attribute24
571: ,p_cty_attribute25_o
572: => ben_cty_shd.g_old_rec.cty_attribute25
573: ,p_cty_attribute26_o
574: => ben_cty_shd.g_old_rec.cty_attribute26
575: ,p_cty_attribute27_o
576: => ben_cty_shd.g_old_rec.cty_attribute27
577: ,p_cty_attribute28_o
578: => ben_cty_shd.g_old_rec.cty_attribute28

Line 576: => ben_cty_shd.g_old_rec.cty_attribute27

572: => ben_cty_shd.g_old_rec.cty_attribute25
573: ,p_cty_attribute26_o
574: => ben_cty_shd.g_old_rec.cty_attribute26
575: ,p_cty_attribute27_o
576: => ben_cty_shd.g_old_rec.cty_attribute27
577: ,p_cty_attribute28_o
578: => ben_cty_shd.g_old_rec.cty_attribute28
579: ,p_cty_attribute29_o
580: => ben_cty_shd.g_old_rec.cty_attribute29

Line 578: => ben_cty_shd.g_old_rec.cty_attribute28

574: => ben_cty_shd.g_old_rec.cty_attribute26
575: ,p_cty_attribute27_o
576: => ben_cty_shd.g_old_rec.cty_attribute27
577: ,p_cty_attribute28_o
578: => ben_cty_shd.g_old_rec.cty_attribute28
579: ,p_cty_attribute29_o
580: => ben_cty_shd.g_old_rec.cty_attribute29
581: ,p_cty_attribute30_o
582: => ben_cty_shd.g_old_rec.cty_attribute30

Line 580: => ben_cty_shd.g_old_rec.cty_attribute29

576: => ben_cty_shd.g_old_rec.cty_attribute27
577: ,p_cty_attribute28_o
578: => ben_cty_shd.g_old_rec.cty_attribute28
579: ,p_cty_attribute29_o
580: => ben_cty_shd.g_old_rec.cty_attribute29
581: ,p_cty_attribute30_o
582: => ben_cty_shd.g_old_rec.cty_attribute30
583: );
584: --

Line 582: => ben_cty_shd.g_old_rec.cty_attribute30

578: => ben_cty_shd.g_old_rec.cty_attribute28
579: ,p_cty_attribute29_o
580: => ben_cty_shd.g_old_rec.cty_attribute29
581: ,p_cty_attribute30_o
582: => ben_cty_shd.g_old_rec.cty_attribute30
583: );
584: --
585: exception
586: --

Line 642: (p_rec in out nocopy ben_cty_shd.g_rec_type

638: --
639: -- {End Of Comments}
640: -- ----------------------------------------------------------------------------
641: Procedure convert_defs
642: (p_rec in out nocopy ben_cty_shd.g_rec_type
643: ) is
644: --
645: Begin
646: --

Line 653: p_rec.competence_id := ben_cty_shd.g_old_rec.competence_id;

649: -- to see if a system default is being used. If a system default
650: -- is being used then we must set to the 'current' argument value.
651: --
652: If (p_rec.competence_id = hr_api.g_number) then
653: p_rec.competence_id := ben_cty_shd.g_old_rec.competence_id;
654: End If;
655:
656: If (p_rec.rating_level_id = hr_api.g_number) then
657: p_rec.rating_level_id := ben_cty_shd.g_old_rec.rating_level_id;

Line 657: p_rec.rating_level_id := ben_cty_shd.g_old_rec.rating_level_id;

653: p_rec.competence_id := ben_cty_shd.g_old_rec.competence_id;
654: End If;
655:
656: If (p_rec.rating_level_id = hr_api.g_number) then
657: p_rec.rating_level_id := ben_cty_shd.g_old_rec.rating_level_id;
658: End If;
659:
660: If (p_rec.excld_flag = hr_api.g_varchar2) then
661: p_rec.excld_flag :=

Line 662: ben_cty_shd.g_old_rec.excld_flag;

658: End If;
659:
660: If (p_rec.excld_flag = hr_api.g_varchar2) then
661: p_rec.excld_flag :=
662: ben_cty_shd.g_old_rec.excld_flag;
663: End If;
664: If (p_rec.business_group_id = hr_api.g_number) then
665: p_rec.business_group_id :=
666: ben_cty_shd.g_old_rec.business_group_id;

Line 666: ben_cty_shd.g_old_rec.business_group_id;

662: ben_cty_shd.g_old_rec.excld_flag;
663: End If;
664: If (p_rec.business_group_id = hr_api.g_number) then
665: p_rec.business_group_id :=
666: ben_cty_shd.g_old_rec.business_group_id;
667: End If;
668: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
669: p_rec.vrbl_rt_prfl_id :=
670: ben_cty_shd.g_old_rec.vrbl_rt_prfl_id;

Line 670: ben_cty_shd.g_old_rec.vrbl_rt_prfl_id;

666: ben_cty_shd.g_old_rec.business_group_id;
667: End If;
668: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
669: p_rec.vrbl_rt_prfl_id :=
670: ben_cty_shd.g_old_rec.vrbl_rt_prfl_id;
671: End If;
672: If (p_rec.ordr_num = hr_api.g_number) then
673: p_rec.ordr_num :=
674: ben_cty_shd.g_old_rec.ordr_num;

Line 674: ben_cty_shd.g_old_rec.ordr_num;

670: ben_cty_shd.g_old_rec.vrbl_rt_prfl_id;
671: End If;
672: If (p_rec.ordr_num = hr_api.g_number) then
673: p_rec.ordr_num :=
674: ben_cty_shd.g_old_rec.ordr_num;
675: End If;
676: If (p_rec.cty_attribute_category = hr_api.g_varchar2) then
677: p_rec.cty_attribute_category :=
678: ben_cty_shd.g_old_rec.cty_attribute_category;

Line 678: ben_cty_shd.g_old_rec.cty_attribute_category;

674: ben_cty_shd.g_old_rec.ordr_num;
675: End If;
676: If (p_rec.cty_attribute_category = hr_api.g_varchar2) then
677: p_rec.cty_attribute_category :=
678: ben_cty_shd.g_old_rec.cty_attribute_category;
679: End If;
680: If (p_rec.cty_attribute1 = hr_api.g_varchar2) then
681: p_rec.cty_attribute1 :=
682: ben_cty_shd.g_old_rec.cty_attribute1;

Line 682: ben_cty_shd.g_old_rec.cty_attribute1;

678: ben_cty_shd.g_old_rec.cty_attribute_category;
679: End If;
680: If (p_rec.cty_attribute1 = hr_api.g_varchar2) then
681: p_rec.cty_attribute1 :=
682: ben_cty_shd.g_old_rec.cty_attribute1;
683: End If;
684: If (p_rec.cty_attribute2 = hr_api.g_varchar2) then
685: p_rec.cty_attribute2 :=
686: ben_cty_shd.g_old_rec.cty_attribute2;

Line 686: ben_cty_shd.g_old_rec.cty_attribute2;

682: ben_cty_shd.g_old_rec.cty_attribute1;
683: End If;
684: If (p_rec.cty_attribute2 = hr_api.g_varchar2) then
685: p_rec.cty_attribute2 :=
686: ben_cty_shd.g_old_rec.cty_attribute2;
687: End If;
688: If (p_rec.cty_attribute3 = hr_api.g_varchar2) then
689: p_rec.cty_attribute3 :=
690: ben_cty_shd.g_old_rec.cty_attribute3;

Line 690: ben_cty_shd.g_old_rec.cty_attribute3;

686: ben_cty_shd.g_old_rec.cty_attribute2;
687: End If;
688: If (p_rec.cty_attribute3 = hr_api.g_varchar2) then
689: p_rec.cty_attribute3 :=
690: ben_cty_shd.g_old_rec.cty_attribute3;
691: End If;
692: If (p_rec.cty_attribute4 = hr_api.g_varchar2) then
693: p_rec.cty_attribute4 :=
694: ben_cty_shd.g_old_rec.cty_attribute4;

Line 694: ben_cty_shd.g_old_rec.cty_attribute4;

690: ben_cty_shd.g_old_rec.cty_attribute3;
691: End If;
692: If (p_rec.cty_attribute4 = hr_api.g_varchar2) then
693: p_rec.cty_attribute4 :=
694: ben_cty_shd.g_old_rec.cty_attribute4;
695: End If;
696: If (p_rec.cty_attribute5 = hr_api.g_varchar2) then
697: p_rec.cty_attribute5 :=
698: ben_cty_shd.g_old_rec.cty_attribute5;

Line 698: ben_cty_shd.g_old_rec.cty_attribute5;

694: ben_cty_shd.g_old_rec.cty_attribute4;
695: End If;
696: If (p_rec.cty_attribute5 = hr_api.g_varchar2) then
697: p_rec.cty_attribute5 :=
698: ben_cty_shd.g_old_rec.cty_attribute5;
699: End If;
700: If (p_rec.cty_attribute6 = hr_api.g_varchar2) then
701: p_rec.cty_attribute6 :=
702: ben_cty_shd.g_old_rec.cty_attribute6;

Line 702: ben_cty_shd.g_old_rec.cty_attribute6;

698: ben_cty_shd.g_old_rec.cty_attribute5;
699: End If;
700: If (p_rec.cty_attribute6 = hr_api.g_varchar2) then
701: p_rec.cty_attribute6 :=
702: ben_cty_shd.g_old_rec.cty_attribute6;
703: End If;
704: If (p_rec.cty_attribute7 = hr_api.g_varchar2) then
705: p_rec.cty_attribute7 :=
706: ben_cty_shd.g_old_rec.cty_attribute7;

Line 706: ben_cty_shd.g_old_rec.cty_attribute7;

702: ben_cty_shd.g_old_rec.cty_attribute6;
703: End If;
704: If (p_rec.cty_attribute7 = hr_api.g_varchar2) then
705: p_rec.cty_attribute7 :=
706: ben_cty_shd.g_old_rec.cty_attribute7;
707: End If;
708: If (p_rec.cty_attribute8 = hr_api.g_varchar2) then
709: p_rec.cty_attribute8 :=
710: ben_cty_shd.g_old_rec.cty_attribute8;

Line 710: ben_cty_shd.g_old_rec.cty_attribute8;

706: ben_cty_shd.g_old_rec.cty_attribute7;
707: End If;
708: If (p_rec.cty_attribute8 = hr_api.g_varchar2) then
709: p_rec.cty_attribute8 :=
710: ben_cty_shd.g_old_rec.cty_attribute8;
711: End If;
712: If (p_rec.cty_attribute9 = hr_api.g_varchar2) then
713: p_rec.cty_attribute9 :=
714: ben_cty_shd.g_old_rec.cty_attribute9;

Line 714: ben_cty_shd.g_old_rec.cty_attribute9;

710: ben_cty_shd.g_old_rec.cty_attribute8;
711: End If;
712: If (p_rec.cty_attribute9 = hr_api.g_varchar2) then
713: p_rec.cty_attribute9 :=
714: ben_cty_shd.g_old_rec.cty_attribute9;
715: End If;
716: If (p_rec.cty_attribute10 = hr_api.g_varchar2) then
717: p_rec.cty_attribute10 :=
718: ben_cty_shd.g_old_rec.cty_attribute10;

Line 718: ben_cty_shd.g_old_rec.cty_attribute10;

714: ben_cty_shd.g_old_rec.cty_attribute9;
715: End If;
716: If (p_rec.cty_attribute10 = hr_api.g_varchar2) then
717: p_rec.cty_attribute10 :=
718: ben_cty_shd.g_old_rec.cty_attribute10;
719: End If;
720: If (p_rec.cty_attribute11 = hr_api.g_varchar2) then
721: p_rec.cty_attribute11 :=
722: ben_cty_shd.g_old_rec.cty_attribute11;

Line 722: ben_cty_shd.g_old_rec.cty_attribute11;

718: ben_cty_shd.g_old_rec.cty_attribute10;
719: End If;
720: If (p_rec.cty_attribute11 = hr_api.g_varchar2) then
721: p_rec.cty_attribute11 :=
722: ben_cty_shd.g_old_rec.cty_attribute11;
723: End If;
724: If (p_rec.cty_attribute12 = hr_api.g_varchar2) then
725: p_rec.cty_attribute12 :=
726: ben_cty_shd.g_old_rec.cty_attribute12;

Line 726: ben_cty_shd.g_old_rec.cty_attribute12;

722: ben_cty_shd.g_old_rec.cty_attribute11;
723: End If;
724: If (p_rec.cty_attribute12 = hr_api.g_varchar2) then
725: p_rec.cty_attribute12 :=
726: ben_cty_shd.g_old_rec.cty_attribute12;
727: End If;
728: If (p_rec.cty_attribute13 = hr_api.g_varchar2) then
729: p_rec.cty_attribute13 :=
730: ben_cty_shd.g_old_rec.cty_attribute13;

Line 730: ben_cty_shd.g_old_rec.cty_attribute13;

726: ben_cty_shd.g_old_rec.cty_attribute12;
727: End If;
728: If (p_rec.cty_attribute13 = hr_api.g_varchar2) then
729: p_rec.cty_attribute13 :=
730: ben_cty_shd.g_old_rec.cty_attribute13;
731: End If;
732: If (p_rec.cty_attribute14 = hr_api.g_varchar2) then
733: p_rec.cty_attribute14 :=
734: ben_cty_shd.g_old_rec.cty_attribute14;

Line 734: ben_cty_shd.g_old_rec.cty_attribute14;

730: ben_cty_shd.g_old_rec.cty_attribute13;
731: End If;
732: If (p_rec.cty_attribute14 = hr_api.g_varchar2) then
733: p_rec.cty_attribute14 :=
734: ben_cty_shd.g_old_rec.cty_attribute14;
735: End If;
736: If (p_rec.cty_attribute15 = hr_api.g_varchar2) then
737: p_rec.cty_attribute15 :=
738: ben_cty_shd.g_old_rec.cty_attribute15;

Line 738: ben_cty_shd.g_old_rec.cty_attribute15;

734: ben_cty_shd.g_old_rec.cty_attribute14;
735: End If;
736: If (p_rec.cty_attribute15 = hr_api.g_varchar2) then
737: p_rec.cty_attribute15 :=
738: ben_cty_shd.g_old_rec.cty_attribute15;
739: End If;
740: If (p_rec.cty_attribute16 = hr_api.g_varchar2) then
741: p_rec.cty_attribute16 :=
742: ben_cty_shd.g_old_rec.cty_attribute16;

Line 742: ben_cty_shd.g_old_rec.cty_attribute16;

738: ben_cty_shd.g_old_rec.cty_attribute15;
739: End If;
740: If (p_rec.cty_attribute16 = hr_api.g_varchar2) then
741: p_rec.cty_attribute16 :=
742: ben_cty_shd.g_old_rec.cty_attribute16;
743: End If;
744: If (p_rec.cty_attribute17 = hr_api.g_varchar2) then
745: p_rec.cty_attribute17 :=
746: ben_cty_shd.g_old_rec.cty_attribute17;

Line 746: ben_cty_shd.g_old_rec.cty_attribute17;

742: ben_cty_shd.g_old_rec.cty_attribute16;
743: End If;
744: If (p_rec.cty_attribute17 = hr_api.g_varchar2) then
745: p_rec.cty_attribute17 :=
746: ben_cty_shd.g_old_rec.cty_attribute17;
747: End If;
748: If (p_rec.cty_attribute18 = hr_api.g_varchar2) then
749: p_rec.cty_attribute18 :=
750: ben_cty_shd.g_old_rec.cty_attribute18;

Line 750: ben_cty_shd.g_old_rec.cty_attribute18;

746: ben_cty_shd.g_old_rec.cty_attribute17;
747: End If;
748: If (p_rec.cty_attribute18 = hr_api.g_varchar2) then
749: p_rec.cty_attribute18 :=
750: ben_cty_shd.g_old_rec.cty_attribute18;
751: End If;
752: If (p_rec.cty_attribute19 = hr_api.g_varchar2) then
753: p_rec.cty_attribute19 :=
754: ben_cty_shd.g_old_rec.cty_attribute19;

Line 754: ben_cty_shd.g_old_rec.cty_attribute19;

750: ben_cty_shd.g_old_rec.cty_attribute18;
751: End If;
752: If (p_rec.cty_attribute19 = hr_api.g_varchar2) then
753: p_rec.cty_attribute19 :=
754: ben_cty_shd.g_old_rec.cty_attribute19;
755: End If;
756: If (p_rec.cty_attribute20 = hr_api.g_varchar2) then
757: p_rec.cty_attribute20 :=
758: ben_cty_shd.g_old_rec.cty_attribute20;

Line 758: ben_cty_shd.g_old_rec.cty_attribute20;

754: ben_cty_shd.g_old_rec.cty_attribute19;
755: End If;
756: If (p_rec.cty_attribute20 = hr_api.g_varchar2) then
757: p_rec.cty_attribute20 :=
758: ben_cty_shd.g_old_rec.cty_attribute20;
759: End If;
760: If (p_rec.cty_attribute21 = hr_api.g_varchar2) then
761: p_rec.cty_attribute21 :=
762: ben_cty_shd.g_old_rec.cty_attribute21;

Line 762: ben_cty_shd.g_old_rec.cty_attribute21;

758: ben_cty_shd.g_old_rec.cty_attribute20;
759: End If;
760: If (p_rec.cty_attribute21 = hr_api.g_varchar2) then
761: p_rec.cty_attribute21 :=
762: ben_cty_shd.g_old_rec.cty_attribute21;
763: End If;
764: If (p_rec.cty_attribute22 = hr_api.g_varchar2) then
765: p_rec.cty_attribute22 :=
766: ben_cty_shd.g_old_rec.cty_attribute22;

Line 766: ben_cty_shd.g_old_rec.cty_attribute22;

762: ben_cty_shd.g_old_rec.cty_attribute21;
763: End If;
764: If (p_rec.cty_attribute22 = hr_api.g_varchar2) then
765: p_rec.cty_attribute22 :=
766: ben_cty_shd.g_old_rec.cty_attribute22;
767: End If;
768: If (p_rec.cty_attribute23 = hr_api.g_varchar2) then
769: p_rec.cty_attribute23 :=
770: ben_cty_shd.g_old_rec.cty_attribute23;

Line 770: ben_cty_shd.g_old_rec.cty_attribute23;

766: ben_cty_shd.g_old_rec.cty_attribute22;
767: End If;
768: If (p_rec.cty_attribute23 = hr_api.g_varchar2) then
769: p_rec.cty_attribute23 :=
770: ben_cty_shd.g_old_rec.cty_attribute23;
771: End If;
772: If (p_rec.cty_attribute24 = hr_api.g_varchar2) then
773: p_rec.cty_attribute24 :=
774: ben_cty_shd.g_old_rec.cty_attribute24;

Line 774: ben_cty_shd.g_old_rec.cty_attribute24;

770: ben_cty_shd.g_old_rec.cty_attribute23;
771: End If;
772: If (p_rec.cty_attribute24 = hr_api.g_varchar2) then
773: p_rec.cty_attribute24 :=
774: ben_cty_shd.g_old_rec.cty_attribute24;
775: End If;
776: If (p_rec.cty_attribute25 = hr_api.g_varchar2) then
777: p_rec.cty_attribute25 :=
778: ben_cty_shd.g_old_rec.cty_attribute25;

Line 778: ben_cty_shd.g_old_rec.cty_attribute25;

774: ben_cty_shd.g_old_rec.cty_attribute24;
775: End If;
776: If (p_rec.cty_attribute25 = hr_api.g_varchar2) then
777: p_rec.cty_attribute25 :=
778: ben_cty_shd.g_old_rec.cty_attribute25;
779: End If;
780: If (p_rec.cty_attribute26 = hr_api.g_varchar2) then
781: p_rec.cty_attribute26 :=
782: ben_cty_shd.g_old_rec.cty_attribute26;

Line 782: ben_cty_shd.g_old_rec.cty_attribute26;

778: ben_cty_shd.g_old_rec.cty_attribute25;
779: End If;
780: If (p_rec.cty_attribute26 = hr_api.g_varchar2) then
781: p_rec.cty_attribute26 :=
782: ben_cty_shd.g_old_rec.cty_attribute26;
783: End If;
784: If (p_rec.cty_attribute27 = hr_api.g_varchar2) then
785: p_rec.cty_attribute27 :=
786: ben_cty_shd.g_old_rec.cty_attribute27;

Line 786: ben_cty_shd.g_old_rec.cty_attribute27;

782: ben_cty_shd.g_old_rec.cty_attribute26;
783: End If;
784: If (p_rec.cty_attribute27 = hr_api.g_varchar2) then
785: p_rec.cty_attribute27 :=
786: ben_cty_shd.g_old_rec.cty_attribute27;
787: End If;
788: If (p_rec.cty_attribute28 = hr_api.g_varchar2) then
789: p_rec.cty_attribute28 :=
790: ben_cty_shd.g_old_rec.cty_attribute28;

Line 790: ben_cty_shd.g_old_rec.cty_attribute28;

786: ben_cty_shd.g_old_rec.cty_attribute27;
787: End If;
788: If (p_rec.cty_attribute28 = hr_api.g_varchar2) then
789: p_rec.cty_attribute28 :=
790: ben_cty_shd.g_old_rec.cty_attribute28;
791: End If;
792: If (p_rec.cty_attribute29 = hr_api.g_varchar2) then
793: p_rec.cty_attribute29 :=
794: ben_cty_shd.g_old_rec.cty_attribute29;

Line 794: ben_cty_shd.g_old_rec.cty_attribute29;

790: ben_cty_shd.g_old_rec.cty_attribute28;
791: End If;
792: If (p_rec.cty_attribute29 = hr_api.g_varchar2) then
793: p_rec.cty_attribute29 :=
794: ben_cty_shd.g_old_rec.cty_attribute29;
795: End If;
796: If (p_rec.cty_attribute30 = hr_api.g_varchar2) then
797: p_rec.cty_attribute30 :=
798: ben_cty_shd.g_old_rec.cty_attribute30;

Line 798: ben_cty_shd.g_old_rec.cty_attribute30;

794: ben_cty_shd.g_old_rec.cty_attribute29;
795: End If;
796: If (p_rec.cty_attribute30 = hr_api.g_varchar2) then
797: p_rec.cty_attribute30 :=
798: ben_cty_shd.g_old_rec.cty_attribute30;
799: End If;
800: --
801: End convert_defs;
802: --

Line 809: ,p_rec in out nocopy ben_cty_shd.g_rec_type

805: -- ----------------------------------------------------------------------------
806: Procedure upd
807: (p_effective_date in date
808: ,p_datetrack_mode in varchar2
809: ,p_rec in out nocopy ben_cty_shd.g_rec_type
810: ) is
811: --
812: l_proc varchar2(72) := g_package||'upd';
813: l_validation_start_date date;

Line 825: ben_cty_shd.lck

821: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
822: --
823: -- We must lock the row which we need to update.
824: --
825: ben_cty_shd.lck
826: (p_effective_date => p_effective_date
827: ,p_datetrack_mode => p_datetrack_mode
828: ,p_comptncy_rt_id => p_rec.comptncy_rt_id
829: ,p_object_version_number => p_rec.object_version_number

Line 936: l_rec ben_cty_shd.g_rec_type;

932: ,p_effective_start_date out nocopy date
933: ,p_effective_end_date out nocopy date
934: ) is
935: --
936: l_rec ben_cty_shd.g_rec_type;
937: l_proc varchar2(72) := g_package||'upd';
938: --
939: Begin
940: hr_utility.set_location('Entering:'||l_proc, 5);

Line 946: ben_cty_shd.convert_args

942: -- Call conversion function to turn arguments into the
943: -- l_rec structure.
944: --
945: l_rec :=
946: ben_cty_shd.convert_args
947: (p_comptncy_rt_id
948: ,null
949: ,null
950: ,p_competence_id