DBA Data[Home] [Help]

APPS.FF_FCU_BUS dependencies on FF_FUNCTIONS

Line 39: , ff_functions fnc

35: cursor csr_sec_grp is
36: select pbg.security_group_id,
37: pbg.legislation_code
38: from per_business_groups_perf pbg
39: , ff_functions fnc
40: where fnc.function_id = p_function_id
41: and pbg.business_group_id(+) = fnc.business_group_id;
42: --
43: -- Declare local variables

Line 123: , ff_functions fff

119: cursor csr_leg_code is
120: select pbg.legislation_code
121: from per_business_groups_perf pbg
122: , ff_function_context_usages fcu
123: , ff_functions fff
124: where fcu.function_id = fff.function_id
125: and fcu.function_id = p_function_id
126: and fcu.sequence_number = p_sequence_number
127: and pbg.business_group_id = fff.business_group_id;

Line 272: from FF_FUNCTIONS fnc

268: ) is
269: --
270: cursor csr_function_id(p_function_id in number) is
271: select NULL
272: from FF_FUNCTIONS fnc
273: where fnc.function_id = p_function_id
274: ;
275: --
276: l_proc varchar2(100) := g_package || 'chk_function_id';

Line 464: from FF_FUNCTIONS fnc

460: --
461: cursor csr_business_group is
462: select business_group_id
463: , legislation_code
464: from FF_FUNCTIONS fnc
465: where fnc.function_id = p_rec.function_id;
466: --
467: l_proc varchar2(72) := g_package||'insert_validate';
468: l_business_group_id ff_functions.business_group_id%type;

Line 468: l_business_group_id ff_functions.business_group_id%type;

464: from FF_FUNCTIONS fnc
465: where fnc.function_id = p_rec.function_id;
466: --
467: l_proc varchar2(72) := g_package||'insert_validate';
468: l_business_group_id ff_functions.business_group_id%type;
469: l_legislation_code ff_functions.legislation_code%type;
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);

Line 469: l_legislation_code ff_functions.legislation_code%type;

465: where fnc.function_id = p_rec.function_id;
466: --
467: l_proc varchar2(72) := g_package||'insert_validate';
468: l_business_group_id ff_functions.business_group_id%type;
469: l_legislation_code ff_functions.legislation_code%type;
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --

Line 514: from FF_FUNCTIONS fnc

510: --
511: cursor csr_business_group is
512: select business_group_id
513: , legislation_code
514: from FF_FUNCTIONS fnc
515: where fnc.function_id = p_rec.function_id;
516: --
517: l_business_group_id ff_functions.business_group_id%type;
518: l_legislation_code ff_functions.legislation_code%type;

Line 517: l_business_group_id ff_functions.business_group_id%type;

513: , legislation_code
514: from FF_FUNCTIONS fnc
515: where fnc.function_id = p_rec.function_id;
516: --
517: l_business_group_id ff_functions.business_group_id%type;
518: l_legislation_code ff_functions.legislation_code%type;
519: l_proc varchar2(72) := g_package||'update_validate';
520: --
521: Begin

Line 518: l_legislation_code ff_functions.legislation_code%type;

514: from FF_FUNCTIONS fnc
515: where fnc.function_id = p_rec.function_id;
516: --
517: l_business_group_id ff_functions.business_group_id%type;
518: l_legislation_code ff_functions.legislation_code%type;
519: l_proc varchar2(72) := g_package||'update_validate';
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);

Line 569: from FF_FUNCTIONS fnc

565: --
566: cursor csr_business_group is
567: select business_group_id
568: , legislation_code
569: from FF_FUNCTIONS fnc
570: where fnc.function_id = p_rec.function_id;
571: --
572: l_business_group_id ff_functions.business_group_id%type;
573: l_legislation_code ff_functions.legislation_code%type;

Line 572: l_business_group_id ff_functions.business_group_id%type;

568: , legislation_code
569: from FF_FUNCTIONS fnc
570: where fnc.function_id = p_rec.function_id;
571: --
572: l_business_group_id ff_functions.business_group_id%type;
573: l_legislation_code ff_functions.legislation_code%type;
574: l_proc varchar2(72) := g_package||'delete_validate';
575: --
576: Begin

Line 573: l_legislation_code ff_functions.legislation_code%type;

569: from FF_FUNCTIONS fnc
570: where fnc.function_id = p_rec.function_id;
571: --
572: l_business_group_id ff_functions.business_group_id%type;
573: l_legislation_code ff_functions.legislation_code%type;
574: l_proc varchar2(72) := g_package||'delete_validate';
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);