DBA Data[Home] [Help]

APPS.FF_FCU_BUS dependencies on FF_FCU_SHD

Line 220: (p_rec in ff_fcu_shd.g_rec_type

216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure chk_non_updateable_args
220: (p_rec in ff_fcu_shd.g_rec_type
221: ) IS
222: --
223: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
224: --

Line 230: IF NOT ff_fcu_shd.api_updating

226: --
227: -- Only proceed with the validation if a row exists for the current
228: -- record in the HR Schema.
229: --
230: IF NOT ff_fcu_shd.api_updating
231: (p_function_id => p_rec.function_id
232: ,p_sequence_number => p_rec.sequence_number
233: ,p_object_version_number => p_rec.object_version_number
234: ) THEN

Line 243: ff_fcu_shd.g_old_rec.function_id then

239: END IF;
240: --
241: --
242: if nvl(p_rec.function_id, hr_api.g_number) <>
243: ff_fcu_shd.g_old_rec.function_id then
244: hr_api.argument_changed_error
245: (p_api_name => l_proc
246: ,p_argument => 'FUNCTION_ID'
247: ,p_base_table => ff_fcu_shd.g_tab_nam

Line 247: ,p_base_table => ff_fcu_shd.g_tab_nam

243: ff_fcu_shd.g_old_rec.function_id then
244: hr_api.argument_changed_error
245: (p_api_name => l_proc
246: ,p_argument => 'FUNCTION_ID'
247: ,p_base_table => ff_fcu_shd.g_tab_nam
248: );
249: end if;
250: --
251: if nvl(p_rec.sequence_number, hr_api.g_number) <>

Line 252: ff_fcu_shd.g_old_rec.sequence_number then

248: );
249: end if;
250: --
251: if nvl(p_rec.sequence_number, hr_api.g_number) <>
252: ff_fcu_shd.g_old_rec.sequence_number then
253: hr_api.argument_changed_error
254: (p_api_name => l_proc
255: ,p_argument => 'SEQUENCE_NUMBER'
256: ,p_base_table => ff_fcu_shd.g_tab_nam

Line 256: ,p_base_table => ff_fcu_shd.g_tab_nam

252: ff_fcu_shd.g_old_rec.sequence_number then
253: hr_api.argument_changed_error
254: (p_api_name => l_proc
255: ,p_argument => 'SEQUENCE_NUMBER'
256: ,p_base_table => ff_fcu_shd.g_tab_nam
257: );
258: end if;
259: --
260: End chk_non_updateable_args;

Line 293: ff_fcu_shd.constraint_error('FF_FUNCTION_CONTEXT_USAGES_FK1');

289: open csr_function_id(p_function_id => p_function_id);
290: fetch csr_function_id into l_exists;
291: if csr_function_id%notfound then
292: close csr_function_id;
293: ff_fcu_shd.constraint_error('FF_FUNCTION_CONTEXT_USAGES_FK1');
294: end if;
295: close csr_function_id;
296: exception
297: when app_exception.application_exception then

Line 338: ff_fcu_shd.constraint_error('FF_FUNCTION_CONTEXT_USAGES_FK2');

334: open csr_context;
335: fetch csr_context into l_exists;
336: if csr_context%notfound then
337: close csr_context;
338: ff_fcu_shd.constraint_error('FF_FUNCTION_CONTEXT_USAGES_FK2');
339: end if;
340: close csr_context;
341: exception
342: when app_exception.application_exception then

Line 389: ff_fcu_shd.constraint_error('FF_FUNCTION_CONTEXT_USAGES_UK2');

385: open csr_unique_context;
386: fetch csr_unique_context into l_exists;
387: if csr_unique_context%found then
388: close csr_unique_context;
389: ff_fcu_shd.constraint_error('FF_FUNCTION_CONTEXT_USAGES_UK2');
390: end if;
391: close csr_unique_context;
392: end if;
393: exception

Line 458: (p_rec in ff_fcu_shd.g_rec_type

454: -- ----------------------------------------------------------------------------
455: -- |---------------------------< insert_validate >----------------------------|
456: -- ----------------------------------------------------------------------------
457: Procedure insert_validate
458: (p_rec in ff_fcu_shd.g_rec_type
459: ) is
460: --
461: cursor csr_business_group is
462: select business_group_id

Line 508: (p_rec in ff_fcu_shd.g_rec_type

504: -- ----------------------------------------------------------------------------
505: -- |---------------------------< update_validate >----------------------------|
506: -- ----------------------------------------------------------------------------
507: Procedure update_validate
508: (p_rec in ff_fcu_shd.g_rec_type
509: ) is
510: --
511: cursor csr_business_group is
512: select business_group_id

Line 563: (p_rec in ff_fcu_shd.g_rec_type

559: -- ----------------------------------------------------------------------------
560: -- |---------------------------< delete_validate >----------------------------|
561: -- ----------------------------------------------------------------------------
562: Procedure delete_validate
563: (p_rec in ff_fcu_shd.g_rec_type
564: ) is
565: --
566: cursor csr_business_group is
567: select business_group_id