APPS.PSP_ERD_BUS dependencies on PSP_ERD_SHD

Line 204: (p_rec in psp_erd_shd.g_rec_type

200: -- Internal Row Handler Use Only.
201: --
202: -- ----------------------------------------------------------------------------
203: procedure chk_df
204: (p_rec in psp_erd_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package || 'chk_df';
208: --

Line 213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

209: begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211: --
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

211: --
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then

Line 231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then
234: --
235: -- Only execute the validation if absolutely necessary:

Line 298: (p_rec in psp_erd_shd.g_rec_type

294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure chk_non_updateable_args
298: (p_rec in psp_erd_shd.g_rec_type
299: ) IS
300: --
301: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
302: --

Line 308: IF NOT psp_erd_shd.api_updating

304: --
305: -- Only proceed with the validation if a row exists for the current
306: -- record in the HR Schema.
307: --
308: IF NOT psp_erd_shd.api_updating
309: (p_effort_report_detail_id => p_rec.effort_report_detail_id
310: ,p_object_version_number => p_rec.object_version_number
311: ) THEN
312: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 327: (p_rec in psp_erd_shd.g_rec_type

323: -- ----------------------------------------------------------------------------
324: -- |---------------------------< insert_validate >----------------------------|
325: -- ----------------------------------------------------------------------------
326: Procedure insert_validate
327: (p_rec in psp_erd_shd.g_rec_type
328: ) is
329: --
330: l_proc varchar2(72) := g_package||'insert_validate';
331: --

Line 357: (p_rec in psp_erd_shd.g_rec_type

353: -- ----------------------------------------------------------------------------
354: -- |---------------------------< update_validate >----------------------------|
355: -- ----------------------------------------------------------------------------
356: Procedure update_validate
357: (p_rec in psp_erd_shd.g_rec_type
358: ) is
359: --
360: l_proc varchar2(72) := g_package||'update_validate';
361: --

Line 391: (p_rec in psp_erd_shd.g_rec_type

387: -- ----------------------------------------------------------------------------
388: -- |---------------------------< delete_validate >----------------------------|
389: -- ----------------------------------------------------------------------------
390: Procedure delete_validate
391: (p_rec in psp_erd_shd.g_rec_type
392: ) is
393: --
394: l_proc varchar2(72) := g_package||'delete_validate';
395: --