DBA Data[Home] [Help]

APPS.PAY_BCT_BUS dependencies on PAY_BCT_SHD

Line 190: (p_rec in pay_bct_shd.g_rec_type

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure chk_non_updateable_args
190: (p_rec in pay_bct_shd.g_rec_type
191: ) IS
192: --
193: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
194: l_error EXCEPTION;

Line 202: IF NOT pay_bct_shd.api_updating

198: --
199: -- Only proceed with the validation if a row exists for the current
200: -- record in the HR Schema.
201: --
202: IF NOT pay_bct_shd.api_updating
203: (p_batch_control_id => p_rec.batch_control_id
204: ,p_object_version_number => p_rec.object_version_number
205: ) THEN
206: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 215: pay_bct_shd.g_old_rec.batch_id then

211: --
212: hr_utility.set_location(l_proc, 10);
213: --
214: if nvl(p_rec.batch_id, hr_api.g_number) <>
215: pay_bct_shd.g_old_rec.batch_id then
216: l_argument := 'batch_id';
217: raise l_error;
218: end if;
219: --

Line 353: pay_bct_shd.constraint_error('PAY_BATCH_CONTROL_TOTALS_FK1');

349: open csr_batch_id_exists;
350: fetch csr_batch_id_exists into l_dummy;
351: if csr_batch_id_exists%notfound then
352: close csr_batch_id_exists;
353: pay_bct_shd.constraint_error('PAY_BATCH_CONTROL_TOTALS_FK1');
354: end if;
355: close csr_batch_id_exists;
356: end if;
357: --

Line 426: l_api_updating := pay_bct_shd.api_updating

422: );
423: --
424: hr_utility.set_location(l_proc, 10);
425: --
426: l_api_updating := pay_bct_shd.api_updating
427: (p_batch_control_id => p_batch_control_id,
428: p_object_version_number => p_object_version_number
429: );
430: hr_utility.set_location(l_proc,20);

Line 435: nvl(pay_bct_shd.g_old_rec.control_status,hr_api.g_varchar2) <>

431: --
432: -- Only proceed with SQL validation if absolutely necessary
433: --
434: if ((l_api_updating and
435: nvl(pay_bct_shd.g_old_rec.control_status,hr_api.g_varchar2) <>
436: nvl(p_control_status,hr_api.g_varchar2))
437: or (NOT l_api_updating)) then
438: --
439: hr_utility.set_location(l_proc,30);

Line 447: pay_bct_shd.constraint_error('PAY_BCHTOT_CONTROL_STATUS_CHK');

443: if hr_api.not_exists_in_hr_lookups
444: (p_effective_date => p_session_date,
445: p_lookup_type => 'BATCH_STATUS',
446: p_lookup_code => p_control_status) then
447: pay_bct_shd.constraint_error('PAY_BCHTOT_CONTROL_STATUS_CHK');
448: end if;
449: --
450: end if;
451: --

Line 511: l_api_updating := pay_bct_shd.api_updating

507: );
508: --
509: hr_utility.set_location(l_proc, 10);
510: --
511: l_api_updating := pay_bct_shd.api_updating
512: (p_batch_control_id => p_batch_control_id,
513: p_object_version_number => p_object_version_number
514: );
515: hr_utility.set_location(l_proc,20);

Line 520: nvl(pay_bct_shd.g_old_rec.control_type,hr_api.g_varchar2) <>

516: --
517: -- Only proceed with SQL validation if absolutely necessary
518: --
519: if ((l_api_updating and
520: nvl(pay_bct_shd.g_old_rec.control_type,hr_api.g_varchar2) <>
521: nvl(p_control_type,hr_api.g_varchar2))
522: or (NOT l_api_updating)) then
523: --
524: hr_utility.set_location(l_proc,30);

Line 685: p_rec in pay_bct_shd.g_rec_type

681: -- |---------------------------< insert_validate >----------------------------|
682: -- ----------------------------------------------------------------------------
683: Procedure insert_validate
684: (p_session_date in date,
685: p_rec in pay_bct_shd.g_rec_type
686: ) is
687: --
688: l_proc varchar2(72) := g_package||'insert_validate';
689: --

Line 732: p_rec in pay_bct_shd.g_rec_type

728: -- |---------------------------< update_validate >----------------------------|
729: -- ----------------------------------------------------------------------------
730: Procedure update_validate
731: (p_session_date in date,
732: p_rec in pay_bct_shd.g_rec_type
733: ) is
734: --
735: l_proc varchar2(72) := g_package||'update_validate';
736: --

Line 782: (p_rec in pay_bct_shd.g_rec_type

778: -- ----------------------------------------------------------------------------
779: -- |---------------------------< delete_validate >----------------------------|
780: -- ----------------------------------------------------------------------------
781: Procedure delete_validate
782: (p_rec in pay_bct_shd.g_rec_type
783: ) is
784: --
785: l_proc varchar2(72) := g_package||'delete_validate';
786: --