APPS.PQH_BRE_BUS dependencies on PQH_BRE_SHD

Line 238: ,p_rec in pqh_bre_shd.g_rec_type

234: -- {End Of Comments}
235: -- ----------------------------------------------------------------------------
236: Procedure chk_non_updateable_args
237: (p_effective_date in date
238: ,p_rec in pqh_bre_shd.g_rec_type
239: ) IS
240: --
241: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
242: --

Line 248: IF NOT pqh_bre_shd.api_updating

244: --
245: -- Only proceed with the validation if a row exists for the current
246: -- record in the HR Schema.
247: --
248: IF NOT pqh_bre_shd.api_updating
249: (p_reallocation_id => p_rec.reallocation_id
250: ,p_object_version_number => p_rec.object_version_number
251: ) THEN
252: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 300: l_api_updating := pqh_bre_shd.api_updating

296: Begin
297: --
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: l_api_updating := pqh_bre_shd.api_updating
301: (p_reallocation_id => p_reallocation_id,
302: p_object_version_number => p_object_version_number);
303: --
304: if (l_api_updating

Line 306: <> pqh_bre_shd.g_old_rec.reallocation_id) then

302: p_object_version_number => p_object_version_number);
303: --
304: if (l_api_updating
305: and nvl(p_reallocation_id,hr_api.g_number)
306: <> pqh_bre_shd.g_old_rec.reallocation_id) then
307: --
308: -- raise error as PK has changed
309: --
310: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');

Line 310: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');

306: <> pqh_bre_shd.g_old_rec.reallocation_id) then
307: --
308: -- raise error as PK has changed
309: --
310: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');
311: --
312: elsif not l_api_updating then
313: --
314: -- check if PK is null

Line 320: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');

316: if p_reallocation_id is not null then
317: --
318: -- raise error as PK is not null
319: --
320: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');
321: --
322: end if;
323: --
324: end if;

Line 380: l_api_updating := pqh_bre_shd.api_updating

376: hr_utility.set_location('Entering:'||l_proc,5);
377: --
378: IF p_transaction_type IN ('D', 'R') THEN
379: IF p_pool_id IS NOT NULL THEN
380: l_api_updating := pqh_bre_shd.api_updating
381: (p_reallocation_id => p_reallocation_id,
382: p_object_version_number => p_object_version_number);
383: --
384: if (l_api_updating

Line 386: <> nvl(pqh_bre_shd.g_old_rec.pool_id,hr_api.g_number)

382: p_object_version_number => p_object_version_number);
383: --
384: if (l_api_updating
385: and nvl(p_pool_id,hr_api.g_number)
386: <> nvl(pqh_bre_shd.g_old_rec.pool_id,hr_api.g_number)
387: or not l_api_updating) then
388: --
389: -- check if pool_id value exists in pqh_budget_pools table
390: --

Line 401: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');

397: --
398: -- raise error as FK does not relate to PK in pqh_budget_pools
399: -- table.
400: --
401: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');
402: --
403: end if;
404: --
405: close c1;

Line 414: l_api_updating := pqh_bre_shd.api_updating

410: END IF;
411: --
412: IF p_transaction_type IN ('DD', 'RD') THEN
413: IF p_txn_detail_id IS NOT NULL THEN
414: l_api_updating := pqh_bre_shd.api_updating
415: (p_reallocation_id => p_reallocation_id,
416: p_object_version_number => p_object_version_number);
417: --
418: if (l_api_updating

Line 420: <> nvl(pqh_bre_shd.g_old_rec.txn_detail_id,hr_api.g_number)

416: p_object_version_number => p_object_version_number);
417: --
418: if (l_api_updating
419: and nvl(p_txn_detail_id,hr_api.g_number)
420: <> nvl(pqh_bre_shd.g_old_rec.txn_detail_id,hr_api.g_number)
421: or not l_api_updating) then
422: --
423: -- check if txn_detail_id value exists in pqh_bdgt_pool_realloctions table
424: --

Line 435: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');

431: --
432: -- raise error as FK does not relate to PK in pqh_bdgt_pool_realloctions
433: -- table.
434: --
435: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');
436: --
437: end if;
438: --
439: close c2;

Line 463: l_api_updating := pqh_bre_shd.api_updating

459: l_api_updating boolean;
460: --
461: BEGIN
462: hr_utility.set_location('Entering:'||l_proc, 5);
463: l_api_updating := pqh_bre_shd.api_updating
464: (p_reallocation_id => p_reallocation_id,
465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating

Line 469: <> nvl(pqh_bre_shd.g_old_rec.reserved_amt,hr_api.g_number)

465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating
468: and nvl(p_reserved_amt,hr_api.g_number)
469: <> nvl(pqh_bre_shd.g_old_rec.reserved_amt,hr_api.g_number)
470: or not l_api_updating) then
471: --
472: -- check if reserved_amt is greater than 0.
473: --

Line 498: ,p_rec in pqh_bre_shd.g_rec_type

494: -- |---------------------------< insert_validate >----------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure insert_validate
497: (p_effective_date in date
498: ,p_rec in pqh_bre_shd.g_rec_type
499: ) is
500: --
501: l_proc varchar2(72) := g_package||'insert_validate';
502: --

Line 546: ,p_rec in pqh_bre_shd.g_rec_type

542: -- |---------------------------< update_validate >----------------------------|
543: -- ----------------------------------------------------------------------------
544: Procedure update_validate
545: (p_effective_date in date
546: ,p_rec in pqh_bre_shd.g_rec_type
547: ) is
548: --
549: l_proc varchar2(72) := g_package||'update_validate';
550: --

Line 595: (p_rec in pqh_bre_shd.g_rec_type

591: -- ----------------------------------------------------------------------------
592: -- |---------------------------< delete_validate >----------------------------|
593: -- ----------------------------------------------------------------------------
594: Procedure delete_validate
595: (p_rec in pqh_bre_shd.g_rec_type
596: ) is
597: --
598: l_proc varchar2(72) := g_package||'delete_validate';
599: --