DBA Data[Home] [Help]

APPS.PAY_ELE_BUS dependencies on PAY_ELE_SHD

Line 181: (p_rec in pay_ele_shd.g_rec_type

177: -- Internal Row Handler Use Only.
178: --
179: -- ----------------------------------------------------------------------------
180: procedure chk_df
181: (p_rec in pay_ele_shd.g_rec_type
182: ) is
183: --
184: l_proc varchar2(72) := g_package || 'chk_df';
185: --

Line 190: nvl(pay_ele_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

186: begin
187: hr_utility.set_location('Entering:'||l_proc,10);
188: --
189: if ((p_rec.element_entry_id is not null) and (
190: nvl(pay_ele_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
192: nvl(pay_ele_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute1, hr_api.g_varchar2) or
194: nvl(pay_ele_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 192: nvl(pay_ele_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

188: --
189: if ((p_rec.element_entry_id is not null) and (
190: nvl(pay_ele_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
192: nvl(pay_ele_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute1, hr_api.g_varchar2) or
194: nvl(pay_ele_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute2, hr_api.g_varchar2) or
196: nvl(pay_ele_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 194: nvl(pay_ele_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

190: nvl(pay_ele_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
192: nvl(pay_ele_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute1, hr_api.g_varchar2) or
194: nvl(pay_ele_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute2, hr_api.g_varchar2) or
196: nvl(pay_ele_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute3, hr_api.g_varchar2) or
198: nvl(pay_ele_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 196: nvl(pay_ele_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

192: nvl(pay_ele_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute1, hr_api.g_varchar2) or
194: nvl(pay_ele_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute2, hr_api.g_varchar2) or
196: nvl(pay_ele_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute3, hr_api.g_varchar2) or
198: nvl(pay_ele_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute4, hr_api.g_varchar2) or
200: nvl(pay_ele_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 198: nvl(pay_ele_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

194: nvl(pay_ele_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute2, hr_api.g_varchar2) or
196: nvl(pay_ele_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute3, hr_api.g_varchar2) or
198: nvl(pay_ele_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute4, hr_api.g_varchar2) or
200: nvl(pay_ele_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute5, hr_api.g_varchar2) or
202: nvl(pay_ele_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 200: nvl(pay_ele_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

196: nvl(pay_ele_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute3, hr_api.g_varchar2) or
198: nvl(pay_ele_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute4, hr_api.g_varchar2) or
200: nvl(pay_ele_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute5, hr_api.g_varchar2) or
202: nvl(pay_ele_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute6, hr_api.g_varchar2) or
204: nvl(pay_ele_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 202: nvl(pay_ele_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

198: nvl(pay_ele_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute4, hr_api.g_varchar2) or
200: nvl(pay_ele_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute5, hr_api.g_varchar2) or
202: nvl(pay_ele_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute6, hr_api.g_varchar2) or
204: nvl(pay_ele_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute7, hr_api.g_varchar2) or
206: nvl(pay_ele_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 204: nvl(pay_ele_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

200: nvl(pay_ele_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute5, hr_api.g_varchar2) or
202: nvl(pay_ele_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute6, hr_api.g_varchar2) or
204: nvl(pay_ele_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute7, hr_api.g_varchar2) or
206: nvl(pay_ele_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute8, hr_api.g_varchar2) or
208: nvl(pay_ele_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 206: nvl(pay_ele_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

202: nvl(pay_ele_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute6, hr_api.g_varchar2) or
204: nvl(pay_ele_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute7, hr_api.g_varchar2) or
206: nvl(pay_ele_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute8, hr_api.g_varchar2) or
208: nvl(pay_ele_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute9, hr_api.g_varchar2) or
210: nvl(pay_ele_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 208: nvl(pay_ele_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

204: nvl(pay_ele_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute7, hr_api.g_varchar2) or
206: nvl(pay_ele_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute8, hr_api.g_varchar2) or
208: nvl(pay_ele_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute9, hr_api.g_varchar2) or
210: nvl(pay_ele_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute10, hr_api.g_varchar2) or
212: nvl(pay_ele_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 210: nvl(pay_ele_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

206: nvl(pay_ele_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute8, hr_api.g_varchar2) or
208: nvl(pay_ele_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute9, hr_api.g_varchar2) or
210: nvl(pay_ele_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute10, hr_api.g_varchar2) or
212: nvl(pay_ele_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute11, hr_api.g_varchar2) or
214: nvl(pay_ele_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 212: nvl(pay_ele_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

208: nvl(pay_ele_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute9, hr_api.g_varchar2) or
210: nvl(pay_ele_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute10, hr_api.g_varchar2) or
212: nvl(pay_ele_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute11, hr_api.g_varchar2) or
214: nvl(pay_ele_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute12, hr_api.g_varchar2) or
216: nvl(pay_ele_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 214: nvl(pay_ele_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

210: nvl(pay_ele_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute10, hr_api.g_varchar2) or
212: nvl(pay_ele_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute11, hr_api.g_varchar2) or
214: nvl(pay_ele_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute12, hr_api.g_varchar2) or
216: nvl(pay_ele_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute13, hr_api.g_varchar2) or
218: nvl(pay_ele_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 216: nvl(pay_ele_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

212: nvl(pay_ele_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute11, hr_api.g_varchar2) or
214: nvl(pay_ele_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute12, hr_api.g_varchar2) or
216: nvl(pay_ele_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute13, hr_api.g_varchar2) or
218: nvl(pay_ele_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute14, hr_api.g_varchar2) or
220: nvl(pay_ele_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 218: nvl(pay_ele_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

214: nvl(pay_ele_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute12, hr_api.g_varchar2) or
216: nvl(pay_ele_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute13, hr_api.g_varchar2) or
218: nvl(pay_ele_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute14, hr_api.g_varchar2) or
220: nvl(pay_ele_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute15, hr_api.g_varchar2) or
222: nvl(pay_ele_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 220: nvl(pay_ele_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

216: nvl(pay_ele_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute13, hr_api.g_varchar2) or
218: nvl(pay_ele_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute14, hr_api.g_varchar2) or
220: nvl(pay_ele_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute15, hr_api.g_varchar2) or
222: nvl(pay_ele_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute16, hr_api.g_varchar2) or
224: nvl(pay_ele_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 222: nvl(pay_ele_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

218: nvl(pay_ele_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute14, hr_api.g_varchar2) or
220: nvl(pay_ele_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute15, hr_api.g_varchar2) or
222: nvl(pay_ele_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute16, hr_api.g_varchar2) or
224: nvl(pay_ele_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute17, hr_api.g_varchar2) or
226: nvl(pay_ele_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 224: nvl(pay_ele_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

220: nvl(pay_ele_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute15, hr_api.g_varchar2) or
222: nvl(pay_ele_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute16, hr_api.g_varchar2) or
224: nvl(pay_ele_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute17, hr_api.g_varchar2) or
226: nvl(pay_ele_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute18, hr_api.g_varchar2) or
228: nvl(pay_ele_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 226: nvl(pay_ele_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

222: nvl(pay_ele_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute16, hr_api.g_varchar2) or
224: nvl(pay_ele_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute17, hr_api.g_varchar2) or
226: nvl(pay_ele_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute18, hr_api.g_varchar2) or
228: nvl(pay_ele_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute19, hr_api.g_varchar2) or
230: nvl(pay_ele_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 228: nvl(pay_ele_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

224: nvl(pay_ele_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute17, hr_api.g_varchar2) or
226: nvl(pay_ele_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute18, hr_api.g_varchar2) or
228: nvl(pay_ele_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute19, hr_api.g_varchar2) or
230: nvl(pay_ele_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute20, hr_api.g_varchar2) )
232: or (p_rec.element_entry_id is not null) ) then

Line 230: nvl(pay_ele_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

226: nvl(pay_ele_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute18, hr_api.g_varchar2) or
228: nvl(pay_ele_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute19, hr_api.g_varchar2) or
230: nvl(pay_ele_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute20, hr_api.g_varchar2) )
232: or (p_rec.element_entry_id is not null) ) then
233: --
234: -- Only execute the validation if absolutely necessary:

Line 362: ,p_rec in pay_ele_shd.g_rec_type

358: -- {End Of Comments}
359: -- ----------------------------------------------------------------------------
360: Procedure chk_non_updateable_args
361: (p_effective_date in date
362: ,p_rec in pay_ele_shd.g_rec_type
363: ) IS
364: --
365: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
366: l_error EXCEPTION;

Line 374: IF NOT pay_ele_shd.api_updating

370: --
371: -- Only proceed with the validation if a row exists for the current
372: -- record in the HR Schema.
373: --
374: IF NOT pay_ele_shd.api_updating
375: (p_element_entry_id => p_rec.element_entry_id
376: ,p_effective_date => p_effective_date
377: ,p_object_version_number => p_rec.object_version_number
378: ) THEN

Line 388: nvl(pay_ele_shd.g_old_rec.element_type_id, hr_api.g_number) then

384: --
385: hr_utility.set_location(l_proc, 10);
386: --
387: if nvl(p_rec.element_type_id, hr_api.g_number) <>
388: nvl(pay_ele_shd.g_old_rec.element_type_id, hr_api.g_number) then
389: l_argument := 'element_type_id';
390: raise l_error;
391: end if;
392: hr_utility.set_location(l_proc, 20);

Line 623: (p_rec in pay_ele_shd.g_rec_type

619: -- ----------------------------------------------------------------------------
620: -- |---------------------------< insert_validate >----------------------------|
621: -- ----------------------------------------------------------------------------
622: Procedure insert_validate
623: (p_rec in pay_ele_shd.g_rec_type
624: ,p_effective_date in date
625: ,p_datetrack_mode in varchar2
626: ,p_validation_start_date in date
627: ,p_validation_end_date in date

Line 655: (p_rec in pay_ele_shd.g_rec_type

651: -- ----------------------------------------------------------------------------
652: -- |---------------------------< update_validate >----------------------------|
653: -- ----------------------------------------------------------------------------
654: Procedure update_validate
655: (p_rec in pay_ele_shd.g_rec_type
656: ,p_effective_date in date
657: ,p_datetrack_mode in varchar2
658: ,p_validation_start_date in date
659: ,p_validation_end_date in date

Line 702: (p_rec in pay_ele_shd.g_rec_type

698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< delete_validate >----------------------------|
700: -- ----------------------------------------------------------------------------
701: Procedure delete_validate
702: (p_rec in pay_ele_shd.g_rec_type
703: ,p_effective_date in date
704: ,p_datetrack_mode in varchar2
705: ,p_validation_start_date in date
706: ,p_validation_end_date in date