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_OTP_UPD dependencies on BEN_OTP_SHD

Line 58: (p_rec in out nocopy ben_otp_shd.g_rec_type

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

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

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

130: where optip_id = p_rec.optip_id
131: and effective_start_date = p_validation_start_date
132: and effective_end_date = p_validation_end_date;
133: --
134: ben_otp_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_otp_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_otp_shd.g_api_dml := false; -- Unset the api dml status
147: ben_otp_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_otp_shd.constraint_error

143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
147: ben_otp_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_otp_shd.g_api_dml := false; -- Unset the api dml status

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

147: ben_otp_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_otp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_otp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_otp_shd.g_api_dml := false; -- Unset the api dml status

Line 152: ben_otp_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_otp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_otp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;

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

151: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_otp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_otp_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_otp_shd.g_rec_type

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure update_dml
191: (p_rec in out nocopy ben_otp_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_otp_shd.g_rec_type

254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure dt_pre_update
258: (p_rec in out nocopy ben_otp_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_otp_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_otp_shd.upd_effective_end_date
275: (p_effective_date => p_effective_date
276: ,p_base_key_value => p_rec.optip_id
277: ,p_new_effective_end_date => (p_validation_start_date - 1)
278: ,p_validation_start_date => p_validation_start_date

Line 344: (p_rec in out nocopy ben_otp_shd.g_rec_type

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

Line 402: (p_rec in ben_otp_shd.g_rec_type

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

Line 511: => ben_otp_shd.g_old_rec.effective_start_date

507: => p_rec.otp_attribute30
508: ,p_object_version_number
509: => p_rec.object_version_number
510: ,p_effective_start_date_o
511: => ben_otp_shd.g_old_rec.effective_start_date
512: ,p_effective_end_date_o
513: => ben_otp_shd.g_old_rec.effective_end_date
514: ,p_business_group_id_o
515: => ben_otp_shd.g_old_rec.business_group_id

Line 513: => ben_otp_shd.g_old_rec.effective_end_date

509: => p_rec.object_version_number
510: ,p_effective_start_date_o
511: => ben_otp_shd.g_old_rec.effective_start_date
512: ,p_effective_end_date_o
513: => ben_otp_shd.g_old_rec.effective_end_date
514: ,p_business_group_id_o
515: => ben_otp_shd.g_old_rec.business_group_id
516: ,p_pgm_id_o
517: => ben_otp_shd.g_old_rec.pgm_id

Line 515: => ben_otp_shd.g_old_rec.business_group_id

511: => ben_otp_shd.g_old_rec.effective_start_date
512: ,p_effective_end_date_o
513: => ben_otp_shd.g_old_rec.effective_end_date
514: ,p_business_group_id_o
515: => ben_otp_shd.g_old_rec.business_group_id
516: ,p_pgm_id_o
517: => ben_otp_shd.g_old_rec.pgm_id
518: ,p_ptip_id_o
519: => ben_otp_shd.g_old_rec.ptip_id

Line 517: => ben_otp_shd.g_old_rec.pgm_id

513: => ben_otp_shd.g_old_rec.effective_end_date
514: ,p_business_group_id_o
515: => ben_otp_shd.g_old_rec.business_group_id
516: ,p_pgm_id_o
517: => ben_otp_shd.g_old_rec.pgm_id
518: ,p_ptip_id_o
519: => ben_otp_shd.g_old_rec.ptip_id
520: ,p_pl_typ_id_o
521: => ben_otp_shd.g_old_rec.pl_typ_id

Line 519: => ben_otp_shd.g_old_rec.ptip_id

515: => ben_otp_shd.g_old_rec.business_group_id
516: ,p_pgm_id_o
517: => ben_otp_shd.g_old_rec.pgm_id
518: ,p_ptip_id_o
519: => ben_otp_shd.g_old_rec.ptip_id
520: ,p_pl_typ_id_o
521: => ben_otp_shd.g_old_rec.pl_typ_id
522: ,p_opt_id_o
523: => ben_otp_shd.g_old_rec.opt_id

Line 521: => ben_otp_shd.g_old_rec.pl_typ_id

517: => ben_otp_shd.g_old_rec.pgm_id
518: ,p_ptip_id_o
519: => ben_otp_shd.g_old_rec.ptip_id
520: ,p_pl_typ_id_o
521: => ben_otp_shd.g_old_rec.pl_typ_id
522: ,p_opt_id_o
523: => ben_otp_shd.g_old_rec.opt_id
524: ,p_cmbn_ptip_opt_id_o
525: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id

Line 523: => ben_otp_shd.g_old_rec.opt_id

519: => ben_otp_shd.g_old_rec.ptip_id
520: ,p_pl_typ_id_o
521: => ben_otp_shd.g_old_rec.pl_typ_id
522: ,p_opt_id_o
523: => ben_otp_shd.g_old_rec.opt_id
524: ,p_cmbn_ptip_opt_id_o
525: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id
526: ,p_legislation_code_o
527: => ben_otp_shd.g_old_rec.legislation_code

Line 525: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id

521: => ben_otp_shd.g_old_rec.pl_typ_id
522: ,p_opt_id_o
523: => ben_otp_shd.g_old_rec.opt_id
524: ,p_cmbn_ptip_opt_id_o
525: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id
526: ,p_legislation_code_o
527: => ben_otp_shd.g_old_rec.legislation_code
528: ,p_legislation_subgroup_o
529: => ben_otp_shd.g_old_rec.legislation_subgroup

Line 527: => ben_otp_shd.g_old_rec.legislation_code

523: => ben_otp_shd.g_old_rec.opt_id
524: ,p_cmbn_ptip_opt_id_o
525: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id
526: ,p_legislation_code_o
527: => ben_otp_shd.g_old_rec.legislation_code
528: ,p_legislation_subgroup_o
529: => ben_otp_shd.g_old_rec.legislation_subgroup
530: ,p_otp_attribute_category_o
531: => ben_otp_shd.g_old_rec.otp_attribute_category

Line 529: => ben_otp_shd.g_old_rec.legislation_subgroup

525: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id
526: ,p_legislation_code_o
527: => ben_otp_shd.g_old_rec.legislation_code
528: ,p_legislation_subgroup_o
529: => ben_otp_shd.g_old_rec.legislation_subgroup
530: ,p_otp_attribute_category_o
531: => ben_otp_shd.g_old_rec.otp_attribute_category
532: ,p_otp_attribute1_o
533: => ben_otp_shd.g_old_rec.otp_attribute1

Line 531: => ben_otp_shd.g_old_rec.otp_attribute_category

527: => ben_otp_shd.g_old_rec.legislation_code
528: ,p_legislation_subgroup_o
529: => ben_otp_shd.g_old_rec.legislation_subgroup
530: ,p_otp_attribute_category_o
531: => ben_otp_shd.g_old_rec.otp_attribute_category
532: ,p_otp_attribute1_o
533: => ben_otp_shd.g_old_rec.otp_attribute1
534: ,p_otp_attribute2_o
535: => ben_otp_shd.g_old_rec.otp_attribute2

Line 533: => ben_otp_shd.g_old_rec.otp_attribute1

529: => ben_otp_shd.g_old_rec.legislation_subgroup
530: ,p_otp_attribute_category_o
531: => ben_otp_shd.g_old_rec.otp_attribute_category
532: ,p_otp_attribute1_o
533: => ben_otp_shd.g_old_rec.otp_attribute1
534: ,p_otp_attribute2_o
535: => ben_otp_shd.g_old_rec.otp_attribute2
536: ,p_otp_attribute3_o
537: => ben_otp_shd.g_old_rec.otp_attribute3

Line 535: => ben_otp_shd.g_old_rec.otp_attribute2

531: => ben_otp_shd.g_old_rec.otp_attribute_category
532: ,p_otp_attribute1_o
533: => ben_otp_shd.g_old_rec.otp_attribute1
534: ,p_otp_attribute2_o
535: => ben_otp_shd.g_old_rec.otp_attribute2
536: ,p_otp_attribute3_o
537: => ben_otp_shd.g_old_rec.otp_attribute3
538: ,p_otp_attribute4_o
539: => ben_otp_shd.g_old_rec.otp_attribute4

Line 537: => ben_otp_shd.g_old_rec.otp_attribute3

533: => ben_otp_shd.g_old_rec.otp_attribute1
534: ,p_otp_attribute2_o
535: => ben_otp_shd.g_old_rec.otp_attribute2
536: ,p_otp_attribute3_o
537: => ben_otp_shd.g_old_rec.otp_attribute3
538: ,p_otp_attribute4_o
539: => ben_otp_shd.g_old_rec.otp_attribute4
540: ,p_otp_attribute5_o
541: => ben_otp_shd.g_old_rec.otp_attribute5

Line 539: => ben_otp_shd.g_old_rec.otp_attribute4

535: => ben_otp_shd.g_old_rec.otp_attribute2
536: ,p_otp_attribute3_o
537: => ben_otp_shd.g_old_rec.otp_attribute3
538: ,p_otp_attribute4_o
539: => ben_otp_shd.g_old_rec.otp_attribute4
540: ,p_otp_attribute5_o
541: => ben_otp_shd.g_old_rec.otp_attribute5
542: ,p_otp_attribute6_o
543: => ben_otp_shd.g_old_rec.otp_attribute6

Line 541: => ben_otp_shd.g_old_rec.otp_attribute5

537: => ben_otp_shd.g_old_rec.otp_attribute3
538: ,p_otp_attribute4_o
539: => ben_otp_shd.g_old_rec.otp_attribute4
540: ,p_otp_attribute5_o
541: => ben_otp_shd.g_old_rec.otp_attribute5
542: ,p_otp_attribute6_o
543: => ben_otp_shd.g_old_rec.otp_attribute6
544: ,p_otp_attribute7_o
545: => ben_otp_shd.g_old_rec.otp_attribute7

Line 543: => ben_otp_shd.g_old_rec.otp_attribute6

539: => ben_otp_shd.g_old_rec.otp_attribute4
540: ,p_otp_attribute5_o
541: => ben_otp_shd.g_old_rec.otp_attribute5
542: ,p_otp_attribute6_o
543: => ben_otp_shd.g_old_rec.otp_attribute6
544: ,p_otp_attribute7_o
545: => ben_otp_shd.g_old_rec.otp_attribute7
546: ,p_otp_attribute8_o
547: => ben_otp_shd.g_old_rec.otp_attribute8

Line 545: => ben_otp_shd.g_old_rec.otp_attribute7

541: => ben_otp_shd.g_old_rec.otp_attribute5
542: ,p_otp_attribute6_o
543: => ben_otp_shd.g_old_rec.otp_attribute6
544: ,p_otp_attribute7_o
545: => ben_otp_shd.g_old_rec.otp_attribute7
546: ,p_otp_attribute8_o
547: => ben_otp_shd.g_old_rec.otp_attribute8
548: ,p_otp_attribute9_o
549: => ben_otp_shd.g_old_rec.otp_attribute9

Line 547: => ben_otp_shd.g_old_rec.otp_attribute8

543: => ben_otp_shd.g_old_rec.otp_attribute6
544: ,p_otp_attribute7_o
545: => ben_otp_shd.g_old_rec.otp_attribute7
546: ,p_otp_attribute8_o
547: => ben_otp_shd.g_old_rec.otp_attribute8
548: ,p_otp_attribute9_o
549: => ben_otp_shd.g_old_rec.otp_attribute9
550: ,p_otp_attribute10_o
551: => ben_otp_shd.g_old_rec.otp_attribute10

Line 549: => ben_otp_shd.g_old_rec.otp_attribute9

545: => ben_otp_shd.g_old_rec.otp_attribute7
546: ,p_otp_attribute8_o
547: => ben_otp_shd.g_old_rec.otp_attribute8
548: ,p_otp_attribute9_o
549: => ben_otp_shd.g_old_rec.otp_attribute9
550: ,p_otp_attribute10_o
551: => ben_otp_shd.g_old_rec.otp_attribute10
552: ,p_otp_attribute11_o
553: => ben_otp_shd.g_old_rec.otp_attribute11

Line 551: => ben_otp_shd.g_old_rec.otp_attribute10

547: => ben_otp_shd.g_old_rec.otp_attribute8
548: ,p_otp_attribute9_o
549: => ben_otp_shd.g_old_rec.otp_attribute9
550: ,p_otp_attribute10_o
551: => ben_otp_shd.g_old_rec.otp_attribute10
552: ,p_otp_attribute11_o
553: => ben_otp_shd.g_old_rec.otp_attribute11
554: ,p_otp_attribute12_o
555: => ben_otp_shd.g_old_rec.otp_attribute12

Line 553: => ben_otp_shd.g_old_rec.otp_attribute11

549: => ben_otp_shd.g_old_rec.otp_attribute9
550: ,p_otp_attribute10_o
551: => ben_otp_shd.g_old_rec.otp_attribute10
552: ,p_otp_attribute11_o
553: => ben_otp_shd.g_old_rec.otp_attribute11
554: ,p_otp_attribute12_o
555: => ben_otp_shd.g_old_rec.otp_attribute12
556: ,p_otp_attribute13_o
557: => ben_otp_shd.g_old_rec.otp_attribute13

Line 555: => ben_otp_shd.g_old_rec.otp_attribute12

551: => ben_otp_shd.g_old_rec.otp_attribute10
552: ,p_otp_attribute11_o
553: => ben_otp_shd.g_old_rec.otp_attribute11
554: ,p_otp_attribute12_o
555: => ben_otp_shd.g_old_rec.otp_attribute12
556: ,p_otp_attribute13_o
557: => ben_otp_shd.g_old_rec.otp_attribute13
558: ,p_otp_attribute14_o
559: => ben_otp_shd.g_old_rec.otp_attribute14

Line 557: => ben_otp_shd.g_old_rec.otp_attribute13

553: => ben_otp_shd.g_old_rec.otp_attribute11
554: ,p_otp_attribute12_o
555: => ben_otp_shd.g_old_rec.otp_attribute12
556: ,p_otp_attribute13_o
557: => ben_otp_shd.g_old_rec.otp_attribute13
558: ,p_otp_attribute14_o
559: => ben_otp_shd.g_old_rec.otp_attribute14
560: ,p_otp_attribute15_o
561: => ben_otp_shd.g_old_rec.otp_attribute15

Line 559: => ben_otp_shd.g_old_rec.otp_attribute14

555: => ben_otp_shd.g_old_rec.otp_attribute12
556: ,p_otp_attribute13_o
557: => ben_otp_shd.g_old_rec.otp_attribute13
558: ,p_otp_attribute14_o
559: => ben_otp_shd.g_old_rec.otp_attribute14
560: ,p_otp_attribute15_o
561: => ben_otp_shd.g_old_rec.otp_attribute15
562: ,p_otp_attribute16_o
563: => ben_otp_shd.g_old_rec.otp_attribute16

Line 561: => ben_otp_shd.g_old_rec.otp_attribute15

557: => ben_otp_shd.g_old_rec.otp_attribute13
558: ,p_otp_attribute14_o
559: => ben_otp_shd.g_old_rec.otp_attribute14
560: ,p_otp_attribute15_o
561: => ben_otp_shd.g_old_rec.otp_attribute15
562: ,p_otp_attribute16_o
563: => ben_otp_shd.g_old_rec.otp_attribute16
564: ,p_otp_attribute17_o
565: => ben_otp_shd.g_old_rec.otp_attribute17

Line 563: => ben_otp_shd.g_old_rec.otp_attribute16

559: => ben_otp_shd.g_old_rec.otp_attribute14
560: ,p_otp_attribute15_o
561: => ben_otp_shd.g_old_rec.otp_attribute15
562: ,p_otp_attribute16_o
563: => ben_otp_shd.g_old_rec.otp_attribute16
564: ,p_otp_attribute17_o
565: => ben_otp_shd.g_old_rec.otp_attribute17
566: ,p_otp_attribute18_o
567: => ben_otp_shd.g_old_rec.otp_attribute18

Line 565: => ben_otp_shd.g_old_rec.otp_attribute17

561: => ben_otp_shd.g_old_rec.otp_attribute15
562: ,p_otp_attribute16_o
563: => ben_otp_shd.g_old_rec.otp_attribute16
564: ,p_otp_attribute17_o
565: => ben_otp_shd.g_old_rec.otp_attribute17
566: ,p_otp_attribute18_o
567: => ben_otp_shd.g_old_rec.otp_attribute18
568: ,p_otp_attribute19_o
569: => ben_otp_shd.g_old_rec.otp_attribute19

Line 567: => ben_otp_shd.g_old_rec.otp_attribute18

563: => ben_otp_shd.g_old_rec.otp_attribute16
564: ,p_otp_attribute17_o
565: => ben_otp_shd.g_old_rec.otp_attribute17
566: ,p_otp_attribute18_o
567: => ben_otp_shd.g_old_rec.otp_attribute18
568: ,p_otp_attribute19_o
569: => ben_otp_shd.g_old_rec.otp_attribute19
570: ,p_otp_attribute20_o
571: => ben_otp_shd.g_old_rec.otp_attribute20

Line 569: => ben_otp_shd.g_old_rec.otp_attribute19

565: => ben_otp_shd.g_old_rec.otp_attribute17
566: ,p_otp_attribute18_o
567: => ben_otp_shd.g_old_rec.otp_attribute18
568: ,p_otp_attribute19_o
569: => ben_otp_shd.g_old_rec.otp_attribute19
570: ,p_otp_attribute20_o
571: => ben_otp_shd.g_old_rec.otp_attribute20
572: ,p_otp_attribute21_o
573: => ben_otp_shd.g_old_rec.otp_attribute21

Line 571: => ben_otp_shd.g_old_rec.otp_attribute20

567: => ben_otp_shd.g_old_rec.otp_attribute18
568: ,p_otp_attribute19_o
569: => ben_otp_shd.g_old_rec.otp_attribute19
570: ,p_otp_attribute20_o
571: => ben_otp_shd.g_old_rec.otp_attribute20
572: ,p_otp_attribute21_o
573: => ben_otp_shd.g_old_rec.otp_attribute21
574: ,p_otp_attribute22_o
575: => ben_otp_shd.g_old_rec.otp_attribute22

Line 573: => ben_otp_shd.g_old_rec.otp_attribute21

569: => ben_otp_shd.g_old_rec.otp_attribute19
570: ,p_otp_attribute20_o
571: => ben_otp_shd.g_old_rec.otp_attribute20
572: ,p_otp_attribute21_o
573: => ben_otp_shd.g_old_rec.otp_attribute21
574: ,p_otp_attribute22_o
575: => ben_otp_shd.g_old_rec.otp_attribute22
576: ,p_otp_attribute23_o
577: => ben_otp_shd.g_old_rec.otp_attribute23

Line 575: => ben_otp_shd.g_old_rec.otp_attribute22

571: => ben_otp_shd.g_old_rec.otp_attribute20
572: ,p_otp_attribute21_o
573: => ben_otp_shd.g_old_rec.otp_attribute21
574: ,p_otp_attribute22_o
575: => ben_otp_shd.g_old_rec.otp_attribute22
576: ,p_otp_attribute23_o
577: => ben_otp_shd.g_old_rec.otp_attribute23
578: ,p_otp_attribute24_o
579: => ben_otp_shd.g_old_rec.otp_attribute24

Line 577: => ben_otp_shd.g_old_rec.otp_attribute23

573: => ben_otp_shd.g_old_rec.otp_attribute21
574: ,p_otp_attribute22_o
575: => ben_otp_shd.g_old_rec.otp_attribute22
576: ,p_otp_attribute23_o
577: => ben_otp_shd.g_old_rec.otp_attribute23
578: ,p_otp_attribute24_o
579: => ben_otp_shd.g_old_rec.otp_attribute24
580: ,p_otp_attribute25_o
581: => ben_otp_shd.g_old_rec.otp_attribute25

Line 579: => ben_otp_shd.g_old_rec.otp_attribute24

575: => ben_otp_shd.g_old_rec.otp_attribute22
576: ,p_otp_attribute23_o
577: => ben_otp_shd.g_old_rec.otp_attribute23
578: ,p_otp_attribute24_o
579: => ben_otp_shd.g_old_rec.otp_attribute24
580: ,p_otp_attribute25_o
581: => ben_otp_shd.g_old_rec.otp_attribute25
582: ,p_otp_attribute26_o
583: => ben_otp_shd.g_old_rec.otp_attribute26

Line 581: => ben_otp_shd.g_old_rec.otp_attribute25

577: => ben_otp_shd.g_old_rec.otp_attribute23
578: ,p_otp_attribute24_o
579: => ben_otp_shd.g_old_rec.otp_attribute24
580: ,p_otp_attribute25_o
581: => ben_otp_shd.g_old_rec.otp_attribute25
582: ,p_otp_attribute26_o
583: => ben_otp_shd.g_old_rec.otp_attribute26
584: ,p_otp_attribute27_o
585: => ben_otp_shd.g_old_rec.otp_attribute27

Line 583: => ben_otp_shd.g_old_rec.otp_attribute26

579: => ben_otp_shd.g_old_rec.otp_attribute24
580: ,p_otp_attribute25_o
581: => ben_otp_shd.g_old_rec.otp_attribute25
582: ,p_otp_attribute26_o
583: => ben_otp_shd.g_old_rec.otp_attribute26
584: ,p_otp_attribute27_o
585: => ben_otp_shd.g_old_rec.otp_attribute27
586: ,p_otp_attribute28_o
587: => ben_otp_shd.g_old_rec.otp_attribute28

Line 585: => ben_otp_shd.g_old_rec.otp_attribute27

581: => ben_otp_shd.g_old_rec.otp_attribute25
582: ,p_otp_attribute26_o
583: => ben_otp_shd.g_old_rec.otp_attribute26
584: ,p_otp_attribute27_o
585: => ben_otp_shd.g_old_rec.otp_attribute27
586: ,p_otp_attribute28_o
587: => ben_otp_shd.g_old_rec.otp_attribute28
588: ,p_otp_attribute29_o
589: => ben_otp_shd.g_old_rec.otp_attribute29

Line 587: => ben_otp_shd.g_old_rec.otp_attribute28

583: => ben_otp_shd.g_old_rec.otp_attribute26
584: ,p_otp_attribute27_o
585: => ben_otp_shd.g_old_rec.otp_attribute27
586: ,p_otp_attribute28_o
587: => ben_otp_shd.g_old_rec.otp_attribute28
588: ,p_otp_attribute29_o
589: => ben_otp_shd.g_old_rec.otp_attribute29
590: ,p_otp_attribute30_o
591: => ben_otp_shd.g_old_rec.otp_attribute30

Line 589: => ben_otp_shd.g_old_rec.otp_attribute29

585: => ben_otp_shd.g_old_rec.otp_attribute27
586: ,p_otp_attribute28_o
587: => ben_otp_shd.g_old_rec.otp_attribute28
588: ,p_otp_attribute29_o
589: => ben_otp_shd.g_old_rec.otp_attribute29
590: ,p_otp_attribute30_o
591: => ben_otp_shd.g_old_rec.otp_attribute30
592: ,p_object_version_number_o
593: => ben_otp_shd.g_old_rec.object_version_number

Line 591: => ben_otp_shd.g_old_rec.otp_attribute30

587: => ben_otp_shd.g_old_rec.otp_attribute28
588: ,p_otp_attribute29_o
589: => ben_otp_shd.g_old_rec.otp_attribute29
590: ,p_otp_attribute30_o
591: => ben_otp_shd.g_old_rec.otp_attribute30
592: ,p_object_version_number_o
593: => ben_otp_shd.g_old_rec.object_version_number
594: );
595: --

Line 593: => ben_otp_shd.g_old_rec.object_version_number

589: => ben_otp_shd.g_old_rec.otp_attribute29
590: ,p_otp_attribute30_o
591: => ben_otp_shd.g_old_rec.otp_attribute30
592: ,p_object_version_number_o
593: => ben_otp_shd.g_old_rec.object_version_number
594: );
595: --
596: exception
597: --

Line 653: (p_rec in out nocopy ben_otp_shd.g_rec_type

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

Line 665: ben_otp_shd.g_old_rec.business_group_id;

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

Line 669: ben_otp_shd.g_old_rec.pgm_id;

665: ben_otp_shd.g_old_rec.business_group_id;
666: End If;
667: If (p_rec.pgm_id = hr_api.g_number) then
668: p_rec.pgm_id :=
669: ben_otp_shd.g_old_rec.pgm_id;
670: End If;
671: If (p_rec.ptip_id = hr_api.g_number) then
672: p_rec.ptip_id :=
673: ben_otp_shd.g_old_rec.ptip_id;

Line 673: ben_otp_shd.g_old_rec.ptip_id;

669: ben_otp_shd.g_old_rec.pgm_id;
670: End If;
671: If (p_rec.ptip_id = hr_api.g_number) then
672: p_rec.ptip_id :=
673: ben_otp_shd.g_old_rec.ptip_id;
674: End If;
675: If (p_rec.pl_typ_id = hr_api.g_number) then
676: p_rec.pl_typ_id :=
677: ben_otp_shd.g_old_rec.pl_typ_id;

Line 677: ben_otp_shd.g_old_rec.pl_typ_id;

673: ben_otp_shd.g_old_rec.ptip_id;
674: End If;
675: If (p_rec.pl_typ_id = hr_api.g_number) then
676: p_rec.pl_typ_id :=
677: ben_otp_shd.g_old_rec.pl_typ_id;
678: End If;
679: If (p_rec.opt_id = hr_api.g_number) then
680: p_rec.opt_id :=
681: ben_otp_shd.g_old_rec.opt_id;

Line 681: ben_otp_shd.g_old_rec.opt_id;

677: ben_otp_shd.g_old_rec.pl_typ_id;
678: End If;
679: If (p_rec.opt_id = hr_api.g_number) then
680: p_rec.opt_id :=
681: ben_otp_shd.g_old_rec.opt_id;
682: End If;
683: If (p_rec.cmbn_ptip_opt_id = hr_api.g_number) then
684: p_rec.cmbn_ptip_opt_id :=
685: ben_otp_shd.g_old_rec.cmbn_ptip_opt_id;

Line 685: ben_otp_shd.g_old_rec.cmbn_ptip_opt_id;

681: ben_otp_shd.g_old_rec.opt_id;
682: End If;
683: If (p_rec.cmbn_ptip_opt_id = hr_api.g_number) then
684: p_rec.cmbn_ptip_opt_id :=
685: ben_otp_shd.g_old_rec.cmbn_ptip_opt_id;
686: End If;
687: If (p_rec.legislation_code = hr_api.g_varchar2) then
688: p_rec.legislation_code :=
689: ben_otp_shd.g_old_rec.legislation_code;

Line 689: ben_otp_shd.g_old_rec.legislation_code;

685: ben_otp_shd.g_old_rec.cmbn_ptip_opt_id;
686: End If;
687: If (p_rec.legislation_code = hr_api.g_varchar2) then
688: p_rec.legislation_code :=
689: ben_otp_shd.g_old_rec.legislation_code;
690: End If;
691: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
692: p_rec.legislation_subgroup :=
693: ben_otp_shd.g_old_rec.legislation_subgroup;

Line 693: ben_otp_shd.g_old_rec.legislation_subgroup;

689: ben_otp_shd.g_old_rec.legislation_code;
690: End If;
691: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
692: p_rec.legislation_subgroup :=
693: ben_otp_shd.g_old_rec.legislation_subgroup;
694: End If;
695: If (p_rec.otp_attribute_category = hr_api.g_varchar2) then
696: p_rec.otp_attribute_category :=
697: ben_otp_shd.g_old_rec.otp_attribute_category;

Line 697: ben_otp_shd.g_old_rec.otp_attribute_category;

693: ben_otp_shd.g_old_rec.legislation_subgroup;
694: End If;
695: If (p_rec.otp_attribute_category = hr_api.g_varchar2) then
696: p_rec.otp_attribute_category :=
697: ben_otp_shd.g_old_rec.otp_attribute_category;
698: End If;
699: If (p_rec.otp_attribute1 = hr_api.g_varchar2) then
700: p_rec.otp_attribute1 :=
701: ben_otp_shd.g_old_rec.otp_attribute1;

Line 701: ben_otp_shd.g_old_rec.otp_attribute1;

697: ben_otp_shd.g_old_rec.otp_attribute_category;
698: End If;
699: If (p_rec.otp_attribute1 = hr_api.g_varchar2) then
700: p_rec.otp_attribute1 :=
701: ben_otp_shd.g_old_rec.otp_attribute1;
702: End If;
703: If (p_rec.otp_attribute2 = hr_api.g_varchar2) then
704: p_rec.otp_attribute2 :=
705: ben_otp_shd.g_old_rec.otp_attribute2;

Line 705: ben_otp_shd.g_old_rec.otp_attribute2;

701: ben_otp_shd.g_old_rec.otp_attribute1;
702: End If;
703: If (p_rec.otp_attribute2 = hr_api.g_varchar2) then
704: p_rec.otp_attribute2 :=
705: ben_otp_shd.g_old_rec.otp_attribute2;
706: End If;
707: If (p_rec.otp_attribute3 = hr_api.g_varchar2) then
708: p_rec.otp_attribute3 :=
709: ben_otp_shd.g_old_rec.otp_attribute3;

Line 709: ben_otp_shd.g_old_rec.otp_attribute3;

705: ben_otp_shd.g_old_rec.otp_attribute2;
706: End If;
707: If (p_rec.otp_attribute3 = hr_api.g_varchar2) then
708: p_rec.otp_attribute3 :=
709: ben_otp_shd.g_old_rec.otp_attribute3;
710: End If;
711: If (p_rec.otp_attribute4 = hr_api.g_varchar2) then
712: p_rec.otp_attribute4 :=
713: ben_otp_shd.g_old_rec.otp_attribute4;

Line 713: ben_otp_shd.g_old_rec.otp_attribute4;

709: ben_otp_shd.g_old_rec.otp_attribute3;
710: End If;
711: If (p_rec.otp_attribute4 = hr_api.g_varchar2) then
712: p_rec.otp_attribute4 :=
713: ben_otp_shd.g_old_rec.otp_attribute4;
714: End If;
715: If (p_rec.otp_attribute5 = hr_api.g_varchar2) then
716: p_rec.otp_attribute5 :=
717: ben_otp_shd.g_old_rec.otp_attribute5;

Line 717: ben_otp_shd.g_old_rec.otp_attribute5;

713: ben_otp_shd.g_old_rec.otp_attribute4;
714: End If;
715: If (p_rec.otp_attribute5 = hr_api.g_varchar2) then
716: p_rec.otp_attribute5 :=
717: ben_otp_shd.g_old_rec.otp_attribute5;
718: End If;
719: If (p_rec.otp_attribute6 = hr_api.g_varchar2) then
720: p_rec.otp_attribute6 :=
721: ben_otp_shd.g_old_rec.otp_attribute6;

Line 721: ben_otp_shd.g_old_rec.otp_attribute6;

717: ben_otp_shd.g_old_rec.otp_attribute5;
718: End If;
719: If (p_rec.otp_attribute6 = hr_api.g_varchar2) then
720: p_rec.otp_attribute6 :=
721: ben_otp_shd.g_old_rec.otp_attribute6;
722: End If;
723: If (p_rec.otp_attribute7 = hr_api.g_varchar2) then
724: p_rec.otp_attribute7 :=
725: ben_otp_shd.g_old_rec.otp_attribute7;

Line 725: ben_otp_shd.g_old_rec.otp_attribute7;

721: ben_otp_shd.g_old_rec.otp_attribute6;
722: End If;
723: If (p_rec.otp_attribute7 = hr_api.g_varchar2) then
724: p_rec.otp_attribute7 :=
725: ben_otp_shd.g_old_rec.otp_attribute7;
726: End If;
727: If (p_rec.otp_attribute8 = hr_api.g_varchar2) then
728: p_rec.otp_attribute8 :=
729: ben_otp_shd.g_old_rec.otp_attribute8;

Line 729: ben_otp_shd.g_old_rec.otp_attribute8;

725: ben_otp_shd.g_old_rec.otp_attribute7;
726: End If;
727: If (p_rec.otp_attribute8 = hr_api.g_varchar2) then
728: p_rec.otp_attribute8 :=
729: ben_otp_shd.g_old_rec.otp_attribute8;
730: End If;
731: If (p_rec.otp_attribute9 = hr_api.g_varchar2) then
732: p_rec.otp_attribute9 :=
733: ben_otp_shd.g_old_rec.otp_attribute9;

Line 733: ben_otp_shd.g_old_rec.otp_attribute9;

729: ben_otp_shd.g_old_rec.otp_attribute8;
730: End If;
731: If (p_rec.otp_attribute9 = hr_api.g_varchar2) then
732: p_rec.otp_attribute9 :=
733: ben_otp_shd.g_old_rec.otp_attribute9;
734: End If;
735: If (p_rec.otp_attribute10 = hr_api.g_varchar2) then
736: p_rec.otp_attribute10 :=
737: ben_otp_shd.g_old_rec.otp_attribute10;

Line 737: ben_otp_shd.g_old_rec.otp_attribute10;

733: ben_otp_shd.g_old_rec.otp_attribute9;
734: End If;
735: If (p_rec.otp_attribute10 = hr_api.g_varchar2) then
736: p_rec.otp_attribute10 :=
737: ben_otp_shd.g_old_rec.otp_attribute10;
738: End If;
739: If (p_rec.otp_attribute11 = hr_api.g_varchar2) then
740: p_rec.otp_attribute11 :=
741: ben_otp_shd.g_old_rec.otp_attribute11;

Line 741: ben_otp_shd.g_old_rec.otp_attribute11;

737: ben_otp_shd.g_old_rec.otp_attribute10;
738: End If;
739: If (p_rec.otp_attribute11 = hr_api.g_varchar2) then
740: p_rec.otp_attribute11 :=
741: ben_otp_shd.g_old_rec.otp_attribute11;
742: End If;
743: If (p_rec.otp_attribute12 = hr_api.g_varchar2) then
744: p_rec.otp_attribute12 :=
745: ben_otp_shd.g_old_rec.otp_attribute12;

Line 745: ben_otp_shd.g_old_rec.otp_attribute12;

741: ben_otp_shd.g_old_rec.otp_attribute11;
742: End If;
743: If (p_rec.otp_attribute12 = hr_api.g_varchar2) then
744: p_rec.otp_attribute12 :=
745: ben_otp_shd.g_old_rec.otp_attribute12;
746: End If;
747: If (p_rec.otp_attribute13 = hr_api.g_varchar2) then
748: p_rec.otp_attribute13 :=
749: ben_otp_shd.g_old_rec.otp_attribute13;

Line 749: ben_otp_shd.g_old_rec.otp_attribute13;

745: ben_otp_shd.g_old_rec.otp_attribute12;
746: End If;
747: If (p_rec.otp_attribute13 = hr_api.g_varchar2) then
748: p_rec.otp_attribute13 :=
749: ben_otp_shd.g_old_rec.otp_attribute13;
750: End If;
751: If (p_rec.otp_attribute14 = hr_api.g_varchar2) then
752: p_rec.otp_attribute14 :=
753: ben_otp_shd.g_old_rec.otp_attribute14;

Line 753: ben_otp_shd.g_old_rec.otp_attribute14;

749: ben_otp_shd.g_old_rec.otp_attribute13;
750: End If;
751: If (p_rec.otp_attribute14 = hr_api.g_varchar2) then
752: p_rec.otp_attribute14 :=
753: ben_otp_shd.g_old_rec.otp_attribute14;
754: End If;
755: If (p_rec.otp_attribute15 = hr_api.g_varchar2) then
756: p_rec.otp_attribute15 :=
757: ben_otp_shd.g_old_rec.otp_attribute15;

Line 757: ben_otp_shd.g_old_rec.otp_attribute15;

753: ben_otp_shd.g_old_rec.otp_attribute14;
754: End If;
755: If (p_rec.otp_attribute15 = hr_api.g_varchar2) then
756: p_rec.otp_attribute15 :=
757: ben_otp_shd.g_old_rec.otp_attribute15;
758: End If;
759: If (p_rec.otp_attribute16 = hr_api.g_varchar2) then
760: p_rec.otp_attribute16 :=
761: ben_otp_shd.g_old_rec.otp_attribute16;

Line 761: ben_otp_shd.g_old_rec.otp_attribute16;

757: ben_otp_shd.g_old_rec.otp_attribute15;
758: End If;
759: If (p_rec.otp_attribute16 = hr_api.g_varchar2) then
760: p_rec.otp_attribute16 :=
761: ben_otp_shd.g_old_rec.otp_attribute16;
762: End If;
763: If (p_rec.otp_attribute17 = hr_api.g_varchar2) then
764: p_rec.otp_attribute17 :=
765: ben_otp_shd.g_old_rec.otp_attribute17;

Line 765: ben_otp_shd.g_old_rec.otp_attribute17;

761: ben_otp_shd.g_old_rec.otp_attribute16;
762: End If;
763: If (p_rec.otp_attribute17 = hr_api.g_varchar2) then
764: p_rec.otp_attribute17 :=
765: ben_otp_shd.g_old_rec.otp_attribute17;
766: End If;
767: If (p_rec.otp_attribute18 = hr_api.g_varchar2) then
768: p_rec.otp_attribute18 :=
769: ben_otp_shd.g_old_rec.otp_attribute18;

Line 769: ben_otp_shd.g_old_rec.otp_attribute18;

765: ben_otp_shd.g_old_rec.otp_attribute17;
766: End If;
767: If (p_rec.otp_attribute18 = hr_api.g_varchar2) then
768: p_rec.otp_attribute18 :=
769: ben_otp_shd.g_old_rec.otp_attribute18;
770: End If;
771: If (p_rec.otp_attribute19 = hr_api.g_varchar2) then
772: p_rec.otp_attribute19 :=
773: ben_otp_shd.g_old_rec.otp_attribute19;

Line 773: ben_otp_shd.g_old_rec.otp_attribute19;

769: ben_otp_shd.g_old_rec.otp_attribute18;
770: End If;
771: If (p_rec.otp_attribute19 = hr_api.g_varchar2) then
772: p_rec.otp_attribute19 :=
773: ben_otp_shd.g_old_rec.otp_attribute19;
774: End If;
775: If (p_rec.otp_attribute20 = hr_api.g_varchar2) then
776: p_rec.otp_attribute20 :=
777: ben_otp_shd.g_old_rec.otp_attribute20;

Line 777: ben_otp_shd.g_old_rec.otp_attribute20;

773: ben_otp_shd.g_old_rec.otp_attribute19;
774: End If;
775: If (p_rec.otp_attribute20 = hr_api.g_varchar2) then
776: p_rec.otp_attribute20 :=
777: ben_otp_shd.g_old_rec.otp_attribute20;
778: End If;
779: If (p_rec.otp_attribute21 = hr_api.g_varchar2) then
780: p_rec.otp_attribute21 :=
781: ben_otp_shd.g_old_rec.otp_attribute21;

Line 781: ben_otp_shd.g_old_rec.otp_attribute21;

777: ben_otp_shd.g_old_rec.otp_attribute20;
778: End If;
779: If (p_rec.otp_attribute21 = hr_api.g_varchar2) then
780: p_rec.otp_attribute21 :=
781: ben_otp_shd.g_old_rec.otp_attribute21;
782: End If;
783: If (p_rec.otp_attribute22 = hr_api.g_varchar2) then
784: p_rec.otp_attribute22 :=
785: ben_otp_shd.g_old_rec.otp_attribute22;

Line 785: ben_otp_shd.g_old_rec.otp_attribute22;

781: ben_otp_shd.g_old_rec.otp_attribute21;
782: End If;
783: If (p_rec.otp_attribute22 = hr_api.g_varchar2) then
784: p_rec.otp_attribute22 :=
785: ben_otp_shd.g_old_rec.otp_attribute22;
786: End If;
787: If (p_rec.otp_attribute23 = hr_api.g_varchar2) then
788: p_rec.otp_attribute23 :=
789: ben_otp_shd.g_old_rec.otp_attribute23;

Line 789: ben_otp_shd.g_old_rec.otp_attribute23;

785: ben_otp_shd.g_old_rec.otp_attribute22;
786: End If;
787: If (p_rec.otp_attribute23 = hr_api.g_varchar2) then
788: p_rec.otp_attribute23 :=
789: ben_otp_shd.g_old_rec.otp_attribute23;
790: End If;
791: If (p_rec.otp_attribute24 = hr_api.g_varchar2) then
792: p_rec.otp_attribute24 :=
793: ben_otp_shd.g_old_rec.otp_attribute24;

Line 793: ben_otp_shd.g_old_rec.otp_attribute24;

789: ben_otp_shd.g_old_rec.otp_attribute23;
790: End If;
791: If (p_rec.otp_attribute24 = hr_api.g_varchar2) then
792: p_rec.otp_attribute24 :=
793: ben_otp_shd.g_old_rec.otp_attribute24;
794: End If;
795: If (p_rec.otp_attribute25 = hr_api.g_varchar2) then
796: p_rec.otp_attribute25 :=
797: ben_otp_shd.g_old_rec.otp_attribute25;

Line 797: ben_otp_shd.g_old_rec.otp_attribute25;

793: ben_otp_shd.g_old_rec.otp_attribute24;
794: End If;
795: If (p_rec.otp_attribute25 = hr_api.g_varchar2) then
796: p_rec.otp_attribute25 :=
797: ben_otp_shd.g_old_rec.otp_attribute25;
798: End If;
799: If (p_rec.otp_attribute26 = hr_api.g_varchar2) then
800: p_rec.otp_attribute26 :=
801: ben_otp_shd.g_old_rec.otp_attribute26;

Line 801: ben_otp_shd.g_old_rec.otp_attribute26;

797: ben_otp_shd.g_old_rec.otp_attribute25;
798: End If;
799: If (p_rec.otp_attribute26 = hr_api.g_varchar2) then
800: p_rec.otp_attribute26 :=
801: ben_otp_shd.g_old_rec.otp_attribute26;
802: End If;
803: If (p_rec.otp_attribute27 = hr_api.g_varchar2) then
804: p_rec.otp_attribute27 :=
805: ben_otp_shd.g_old_rec.otp_attribute27;

Line 805: ben_otp_shd.g_old_rec.otp_attribute27;

801: ben_otp_shd.g_old_rec.otp_attribute26;
802: End If;
803: If (p_rec.otp_attribute27 = hr_api.g_varchar2) then
804: p_rec.otp_attribute27 :=
805: ben_otp_shd.g_old_rec.otp_attribute27;
806: End If;
807: If (p_rec.otp_attribute28 = hr_api.g_varchar2) then
808: p_rec.otp_attribute28 :=
809: ben_otp_shd.g_old_rec.otp_attribute28;

Line 809: ben_otp_shd.g_old_rec.otp_attribute28;

805: ben_otp_shd.g_old_rec.otp_attribute27;
806: End If;
807: If (p_rec.otp_attribute28 = hr_api.g_varchar2) then
808: p_rec.otp_attribute28 :=
809: ben_otp_shd.g_old_rec.otp_attribute28;
810: End If;
811: If (p_rec.otp_attribute29 = hr_api.g_varchar2) then
812: p_rec.otp_attribute29 :=
813: ben_otp_shd.g_old_rec.otp_attribute29;

Line 813: ben_otp_shd.g_old_rec.otp_attribute29;

809: ben_otp_shd.g_old_rec.otp_attribute28;
810: End If;
811: If (p_rec.otp_attribute29 = hr_api.g_varchar2) then
812: p_rec.otp_attribute29 :=
813: ben_otp_shd.g_old_rec.otp_attribute29;
814: End If;
815: If (p_rec.otp_attribute30 = hr_api.g_varchar2) then
816: p_rec.otp_attribute30 :=
817: ben_otp_shd.g_old_rec.otp_attribute30;

Line 817: ben_otp_shd.g_old_rec.otp_attribute30;

813: ben_otp_shd.g_old_rec.otp_attribute29;
814: End If;
815: If (p_rec.otp_attribute30 = hr_api.g_varchar2) then
816: p_rec.otp_attribute30 :=
817: ben_otp_shd.g_old_rec.otp_attribute30;
818: End If;
819: --
820: End convert_defs;
821: --

Line 828: ,p_rec in out nocopy ben_otp_shd.g_rec_type

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

Line 844: ben_otp_shd.lck

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

Line 951: l_rec ben_otp_shd.g_rec_type;

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

Line 961: ben_otp_shd.convert_args

957: -- Call conversion function to turn arguments into the
958: -- l_rec structure.
959: --
960: l_rec :=
961: ben_otp_shd.convert_args
962: (p_optip_id
963: ,null
964: ,null
965: ,p_business_group_id