APPS.BEN_PRY_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'prtt_rmt_aprvd_fr_pymt_id'
47: ,p_argument_value => p_prtt_rmt_aprvd_fr_pymt_id
48: );

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'prtt_rmt_aprvd_fr_pymt_id'
107: ,p_argument_value => p_prtt_rmt_aprvd_fr_pymt_id
108: );

Line 110: if ( nvl(ben_pry_bus.g_prtt_rmt_aprvd_fr_pymt_id, hr_api.g_number)

106: ,p_argument => 'prtt_rmt_aprvd_fr_pymt_id'
107: ,p_argument_value => p_prtt_rmt_aprvd_fr_pymt_id
108: );
109: --
110: if ( nvl(ben_pry_bus.g_prtt_rmt_aprvd_fr_pymt_id, hr_api.g_number)
111: = p_prtt_rmt_aprvd_fr_pymt_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 168: where pry.effective_end_date = hr_api.g_eot --future created entry to be taken for calc

164:
165: cursor c_pry is
166: select sum(nvl(pry.aprvd_fr_pymt_amt,0))
167: from ben_prtt_rmt_aprvd_fr_pymt_f pry
168: where pry.effective_end_date = hr_api.g_eot --future created entry to be taken for calc
169: and p_rec.prtt_reimbmt_rqst_id = pry.prtt_reimbmt_rqst_id
170: and (p_rec.prtt_rmt_aprvd_fr_pymt_id is null
171: or (p_rec.prtt_rmt_aprvd_fr_pymt_id <> pry.prtt_rmt_aprvd_fr_pymt_id ) )
172: and pry.business_group_id = p_rec.business_group_id ;

Line 221: and prc.effective_end_date = hr_api.g_eot --future created entry to be taken for calc

217: and ((prc.popl_yr_perd_id_1 = p_popl_yr_perd and
218: prc.amt_year2 is null) or
219: (prc.popl_yr_perd_id_2 = p_popl_yr_perd
220: and prc.amt_year1 is null))
221: and prc.effective_end_date = hr_api.g_eot --future created entry to be taken for calc
222: and prc.prtt_reimbmt_rqst_id = pry.prtt_reimbmt_rqst_id
223: ;
224: cursor c_prc_overlap(p_pl_id number ,
225: p_person_id number,

Line 544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>

540: begin
541: hr_utility.set_location('Entering:'||l_proc,10);
542: --
543: if ((p_rec.prtt_rmt_aprvd_fr_pymt_id is not null) and (
544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>

Line 545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or

541: hr_utility.set_location('Entering:'||l_proc,10);
542: --
543: if ((p_rec.prtt_rmt_aprvd_fr_pymt_id is not null) and (
544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or

Line 546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>

542: --
543: if ((p_rec.prtt_rmt_aprvd_fr_pymt_id is not null) and (
544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>

Line 547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or

543: if ((p_rec.prtt_rmt_aprvd_fr_pymt_id is not null) and (
544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or

Line 548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>

544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>

Line 549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or

545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or

Line 550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>

546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>

Line 551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or

547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or

Line 552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>

548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>

Line 553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or

549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or

Line 554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>

550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>

Line 555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or

551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or

Line 556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>

552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>

Line 557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or

553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or

Line 558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>

554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>

Line 559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or

555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or

Line 560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>

556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>

Line 561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or

557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or

Line 562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>

558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>

Line 563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or

559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or

Line 564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>

560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>

Line 565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or

561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or

Line 566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>

562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>

Line 567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or

563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or

Line 568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>

564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>

Line 569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or

565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or

Line 570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>

566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>

Line 571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or

567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or

Line 572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>

568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>

Line 573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or

569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or

Line 574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>

570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>

Line 575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or

571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or

Line 576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>

572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>

Line 577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or

573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or

Line 578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>

574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>

Line 579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or

575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or

Line 580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>

576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>

Line 581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or

577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or

Line 582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>

578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>

Line 583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or

579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or

Line 584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>

580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>

Line 585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or

581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or

Line 586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>

582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>

Line 587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or

583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or

Line 588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>

584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>

Line 589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or

585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or

Line 590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>

586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>

Line 591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or

587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or

Line 592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>

588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>

Line 593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or

589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or

Line 594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>

590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>

Line 595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or

591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or

Line 596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>

592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>

Line 597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or

593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or

Line 598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>

594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>

Line 599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or

595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or

Line 600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>

596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>

Line 601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or

597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>
605: nvl(p_rec.pry_attribute30, hr_api.g_varchar2) ))

Line 602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>

598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>
605: nvl(p_rec.pry_attribute30, hr_api.g_varchar2) ))
606: or (p_rec.prtt_rmt_aprvd_fr_pymt_id is null) then

Line 603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or

599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>
605: nvl(p_rec.pry_attribute30, hr_api.g_varchar2) ))
606: or (p_rec.prtt_rmt_aprvd_fr_pymt_id is null) then
607: --

Line 604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>

600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>
605: nvl(p_rec.pry_attribute30, hr_api.g_varchar2) ))
606: or (p_rec.prtt_rmt_aprvd_fr_pymt_id is null) then
607: --
608: -- Only execute the validation if absolutely necessary:

Line 605: nvl(p_rec.pry_attribute30, hr_api.g_varchar2) ))

601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>
605: nvl(p_rec.pry_attribute30, hr_api.g_varchar2) ))
606: or (p_rec.prtt_rmt_aprvd_fr_pymt_id is null) then
607: --
608: -- Only execute the validation if absolutely necessary:
609: -- a) During update, the structure column value or any

Line 740: hr_api.argument_changed_error

736: -- not been updated.
737: --
738: EXCEPTION
739: WHEN l_error THEN
740: hr_api.argument_changed_error
741: (p_api_name => l_proc
742: ,p_argument => l_argument);
743: WHEN OTHERS THEN
744: RAISE;

Line 777: (p_prtt_reimbmt_rqst_id in number default hr_api.g_number

773: --
774: -- {End Of Comments}
775: -- ----------------------------------------------------------------------------
776: Procedure dt_update_validate
777: (p_prtt_reimbmt_rqst_id in number default hr_api.g_number
778: ,p_datetrack_mode in varchar2
779: ,p_validation_start_date in date
780: ,p_validation_end_date in date
781: ) Is

Line 791: hr_api.mandatory_arg_error

787: Begin
788: --
789: -- Ensure that the p_datetrack_mode argument is not null
790: --
791: hr_api.mandatory_arg_error
792: (p_api_name => l_proc
793: ,p_argument => 'datetrack_mode'
794: ,p_argument_value => p_datetrack_mode
795: );

Line 801: hr_api.mandatory_arg_error

797: -- Mode will be valid, as this is checked at the start of the upd.
798: --
799: -- Ensure the arguments are not null
800: --
801: hr_api.mandatory_arg_error
802: (p_api_name => l_proc
803: ,p_argument => 'validation_start_date'
804: ,p_argument_value => p_validation_start_date
805: );

Line 807: hr_api.mandatory_arg_error

803: ,p_argument => 'validation_start_date'
804: ,p_argument_value => p_validation_start_date
805: );
806: --
807: hr_api.mandatory_arg_error
808: (p_api_name => l_proc
809: ,p_argument => 'validation_end_date'
810: ,p_argument_value => p_validation_end_date
811: );

Line 813: If ((nvl(p_prtt_reimbmt_rqst_id, hr_api.g_number) <> hr_api.g_number) and

809: ,p_argument => 'validation_end_date'
810: ,p_argument_value => p_validation_end_date
811: );
812: --
813: If ((nvl(p_prtt_reimbmt_rqst_id, hr_api.g_number) <> hr_api.g_number) and
814: NOT (dt_api.check_min_max_dates
815: (p_base_table_name => 'ben_prtt_reimbmt_rqst_f'
816: ,p_base_key_column => 'prtt_reimbmt_rqst_id'
817: ,p_base_key_value => p_prtt_reimbmt_rqst_id

Line 894: hr_api.mandatory_arg_error

890: Begin
891: --
892: -- Ensure that the p_datetrack_mode argument is not null
893: --
894: hr_api.mandatory_arg_error
895: (p_api_name => l_proc
896: ,p_argument => 'datetrack_mode'
897: ,p_argument_value => p_datetrack_mode
898: );

Line 903: If (p_datetrack_mode = hr_api.g_delete or

899: --
900: -- Only perform the validation if the datetrack mode is either
901: -- DELETE or ZAP
902: --
903: If (p_datetrack_mode = hr_api.g_delete or
904: p_datetrack_mode = hr_api.g_zap) then
905: --
906: --
907: -- Ensure the arguments are not null

Line 904: p_datetrack_mode = hr_api.g_zap) then

900: -- Only perform the validation if the datetrack mode is either
901: -- DELETE or ZAP
902: --
903: If (p_datetrack_mode = hr_api.g_delete or
904: p_datetrack_mode = hr_api.g_zap) then
905: --
906: --
907: -- Ensure the arguments are not null
908: --

Line 909: hr_api.mandatory_arg_error

905: --
906: --
907: -- Ensure the arguments are not null
908: --
909: hr_api.mandatory_arg_error
910: (p_api_name => l_proc
911: ,p_argument => 'validation_start_date'
912: ,p_argument_value => p_validation_start_date
913: );

Line 915: hr_api.mandatory_arg_error

911: ,p_argument => 'validation_start_date'
912: ,p_argument_value => p_validation_start_date
913: );
914: --
915: hr_api.mandatory_arg_error
916: (p_api_name => l_proc
917: ,p_argument => 'validation_end_date'
918: ,p_argument_value => p_validation_end_date
919: );

Line 921: hr_api.mandatory_arg_error

917: ,p_argument => 'validation_end_date'
918: ,p_argument_value => p_validation_end_date
919: );
920: --
921: hr_api.mandatory_arg_error
922: (p_api_name => l_proc
923: ,p_argument => 'prtt_rmt_aprvd_fr_pymt_id'
924: ,p_argument_value => p_prtt_rmt_aprvd_fr_pymt_id
925: );

Line 970: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

966: hr_utility.set_location('Entering:'||l_proc, 5);
967: --
968: -- Call all supporting business operations
969: --
970: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id
971: -- will only be valid when the business_group_id is not null.
972: -- As this column is defined as optional on the table then
973: -- different logic will be required to handle the null case.
974: -- If this is a start-up data entity then:

Line 984: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

980: -- validation against the HR_STANDARD_LOOKUPS view.
981: -- or c) (less likely) ensure the correct security_group_id
982: -- value is set in client_info.
983: -- Remove this comment when the edit has been completed.
984: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
985: --
986: chk_pymt_amt
987: (p_rec =>p_rec
988: ,p_effective_date => p_effective_date

Line 1016: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

1012: hr_utility.set_location('Entering:'||l_proc, 5);
1013: --
1014: -- Call all supporting business operations
1015: --
1016: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id
1017: -- will only be valid when the business_group_id is not null.
1018: -- As this column is defined as optional on the table then
1019: -- different logic will be required to handle the null case.
1020: -- If this is a start-up data entity then:

Line 1030: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1026: -- validation against the HR_STANDARD_LOOKUPS view.
1027: -- or c) (less likely) ensure the correct security_group_id
1028: -- value is set in client_info.
1029: -- Remove this comment when the edit has been completed.
1030: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1031: --
1032: -- Call the datetrack update integrity operation
1033: --
1034: dt_update_validate