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.PSP_POA_BUS dependencies on PSP_POA_SHD

Line 189: (p_rec in psp_poa_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_df
189: (p_rec in psp_poa_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193:

Line 199: nvl(psp_poa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.organization_account_id is not null) and (
199: nvl(psp_poa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(psp_poa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(psp_poa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 201: nvl(psp_poa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

197: --
198: if ((p_rec.organization_account_id is not null) and (
199: nvl(psp_poa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(psp_poa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(psp_poa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(psp_poa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 203: nvl(psp_poa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

199: nvl(psp_poa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(psp_poa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(psp_poa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(psp_poa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(psp_poa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 205: nvl(psp_poa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

201: nvl(psp_poa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(psp_poa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(psp_poa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(psp_poa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(psp_poa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 207: nvl(psp_poa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

203: nvl(psp_poa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(psp_poa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(psp_poa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(psp_poa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(psp_poa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 209: nvl(psp_poa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

205: nvl(psp_poa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(psp_poa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(psp_poa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(psp_poa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(psp_poa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 211: nvl(psp_poa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

207: nvl(psp_poa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(psp_poa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(psp_poa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(psp_poa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(psp_poa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 213: nvl(psp_poa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

209: nvl(psp_poa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(psp_poa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(psp_poa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(psp_poa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(psp_poa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 215: nvl(psp_poa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

211: nvl(psp_poa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(psp_poa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(psp_poa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(psp_poa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(psp_poa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 217: nvl(psp_poa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

213: nvl(psp_poa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(psp_poa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(psp_poa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(psp_poa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(psp_poa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 219: nvl(psp_poa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

215: nvl(psp_poa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(psp_poa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(psp_poa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(psp_poa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(psp_poa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 221: nvl(psp_poa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

217: nvl(psp_poa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(psp_poa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(psp_poa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(psp_poa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(psp_poa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 223: nvl(psp_poa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

219: nvl(psp_poa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(psp_poa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(psp_poa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(psp_poa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(psp_poa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 225: nvl(psp_poa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

221: nvl(psp_poa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(psp_poa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(psp_poa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(psp_poa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(psp_poa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 227: nvl(psp_poa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

223: nvl(psp_poa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(psp_poa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(psp_poa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(psp_poa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) ))
231: or (p_rec.organization_account_id is null) then

Line 229: nvl(psp_poa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

225: nvl(psp_poa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(psp_poa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(psp_poa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) ))
231: or (p_rec.organization_account_id is null) then
232: --
233: -- Only execute the validation if absolutely necessary:

Line 307: (p_rec in psp_poa_shd.g_rec_type

303: --
304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure chk_non_updateable_args
307: (p_rec in psp_poa_shd.g_rec_type
308: ) IS
309: --
310: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
311: --

Line 317: IF NOT psp_poa_shd.api_updating

313: --
314: -- Only proceed with the validation if a row exists for the current
315: -- record in the HR Schema.
316: --
317: IF NOT psp_poa_shd.api_updating
318: (p_organization_account_id => p_rec.organization_account_id
319: ,p_object_version_number => p_rec.object_version_number
320: ) THEN
321: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 604: (p_rec in psp_poa_shd.g_rec_type

600: -- ----------------------------------------------------------------------------
601: -- |---------------------------< insert_validate >----------------------------|
602: -- ----------------------------------------------------------------------------
603: Procedure insert_validate
604: (p_rec in psp_poa_shd.g_rec_type
605: ) is
606: --
607: l_proc varchar2(72) := g_package||'insert_validate';
608: --

Line 616: ,p_associated_column1 => psp_poa_shd.g_tab_nam

612: -- Call all supporting business operations
613: --
614: hr_api.validate_bus_grp_id
615: (p_business_group_id => p_rec.business_group_id
616: ,p_associated_column1 => psp_poa_shd.g_tab_nam
617: || '.BUSINESS_GROUP_ID');
618:
619:
620: validate_dates( p_organization_id => p_rec.organization_id

Line 655: (p_rec in psp_poa_shd.g_rec_type

651: -- ----------------------------------------------------------------------------
652: -- |---------------------------< update_validate >----------------------------|
653: -- ----------------------------------------------------------------------------
654: Procedure update_validate
655: (p_rec in psp_poa_shd.g_rec_type
656: ) is
657: --
658: l_proc varchar2(72) := g_package||'update_validate';
659: --

Line 667: ,p_associated_column1 => psp_poa_shd.g_tab_nam

663: -- Call all supporting business operations
664: --
665: hr_api.validate_bus_grp_id
666: (p_business_group_id => p_rec.business_group_id
667: ,p_associated_column1 => psp_poa_shd.g_tab_nam
668: || '.BUSINESS_GROUP_ID');
669:
670:
671: validate_dates( p_organization_id => p_rec.organization_id

Line 711: (p_rec in psp_poa_shd.g_rec_type

707: -- ----------------------------------------------------------------------------
708: -- |---------------------------< delete_validate >----------------------------|
709: -- ----------------------------------------------------------------------------
710: Procedure delete_validate
711: (p_rec in psp_poa_shd.g_rec_type
712: ) is
713: --
714: l_proc varchar2(72) := g_package||'delete_validate';
715: --