DBA Data[Home] [Help]

APPS.FF_FFP_BUS dependencies on FF_FUNCTIONS

Line 40: , ff_functions fff

36: select pbg.security_group_id,
37: pbg.legislation_code
38: from per_business_groups_perf pbg
39: , ff_function_parameters ffp
40: , ff_functions fff
41: where ffp.function_id = fff.function_id
42: and ffp.function_id = p_function_id
43: and ffp.sequence_number = p_sequence_number
44: and pbg.business_group_id = fff.business_group_id;

Line 126: , ff_functions fff

122: cursor csr_leg_code is
123: select pbg.legislation_code
124: from per_business_groups_perf pbg
125: , ff_function_parameters ffp
126: , ff_functions fff
127: where ffp.function_id = fff.function_id
128: and ffp.function_id = p_function_id
129: and ffp.sequence_number = p_sequence_number
130: and pbg.business_group_id = fff.business_group_id;

Line 260: from FF_FUNCTIONS ffn

256: ) is
257: --
258: cursor csr_function_id is
259: select NULL
260: from FF_FUNCTIONS ffn
261: where ffn.function_id = p_function_id;
262: --
263: l_proc varchar2(100) := g_package || 'chk_function_id';
264: l_exists varchar2(1);

Line 650: from FF_FUNCTIONS ffn

646: --
647: cursor csr_business_group is
648: select business_group_id
649: , legislation_code
650: from FF_FUNCTIONS ffn
651: where ffn.function_id = p_rec.function_id;
652: --
653: l_proc varchar2(72) := g_package||'insert_validate';
654: l_business_group_id ff_functions.business_group_id%type;

Line 654: l_business_group_id ff_functions.business_group_id%type;

650: from FF_FUNCTIONS ffn
651: where ffn.function_id = p_rec.function_id;
652: --
653: l_proc varchar2(72) := g_package||'insert_validate';
654: l_business_group_id ff_functions.business_group_id%type;
655: l_legislation_code ff_functions.legislation_code%type;
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);

Line 655: l_legislation_code ff_functions.legislation_code%type;

651: where ffn.function_id = p_rec.function_id;
652: --
653: l_proc varchar2(72) := g_package||'insert_validate';
654: l_business_group_id ff_functions.business_group_id%type;
655: l_legislation_code ff_functions.legislation_code%type;
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: --

Line 717: from FF_FUNCTIONS ffn

713: --
714: cursor csr_business_group is
715: select business_group_id
716: , legislation_code
717: from FF_FUNCTIONS ffn
718: where ffn.function_id = p_rec.function_id;
719: --
720: l_business_group_id ff_functions.business_group_id%type;
721: l_legislation_code ff_functions.legislation_code%type;

Line 720: l_business_group_id ff_functions.business_group_id%type;

716: , legislation_code
717: from FF_FUNCTIONS ffn
718: where ffn.function_id = p_rec.function_id;
719: --
720: l_business_group_id ff_functions.business_group_id%type;
721: l_legislation_code ff_functions.legislation_code%type;
722: l_proc varchar2(72) := g_package||'update_validate';
723: --
724: Begin

Line 721: l_legislation_code ff_functions.legislation_code%type;

717: from FF_FUNCTIONS ffn
718: where ffn.function_id = p_rec.function_id;
719: --
720: l_business_group_id ff_functions.business_group_id%type;
721: l_legislation_code ff_functions.legislation_code%type;
722: l_proc varchar2(72) := g_package||'update_validate';
723: --
724: Begin
725: hr_utility.set_location('Entering:'||l_proc, 5);

Line 788: from FF_FUNCTIONS ffn

784: --
785: cursor csr_business_group is
786: select business_group_id
787: , legislation_code
788: from FF_FUNCTIONS ffn
789: where ffn.function_id = p_rec.function_id;
790: --
791: l_business_group_id ff_functions.business_group_id%type;
792: l_legislation_code ff_functions.legislation_code%type;

Line 791: l_business_group_id ff_functions.business_group_id%type;

787: , legislation_code
788: from FF_FUNCTIONS ffn
789: where ffn.function_id = p_rec.function_id;
790: --
791: l_business_group_id ff_functions.business_group_id%type;
792: l_legislation_code ff_functions.legislation_code%type;
793: l_proc varchar2(72) := g_package||'delete_validate';
794: --
795: Begin

Line 792: l_legislation_code ff_functions.legislation_code%type;

788: from FF_FUNCTIONS ffn
789: where ffn.function_id = p_rec.function_id;
790: --
791: l_business_group_id ff_functions.business_group_id%type;
792: l_legislation_code ff_functions.legislation_code%type;
793: l_proc varchar2(72) := g_package||'delete_validate';
794: --
795: Begin
796: hr_utility.set_location('Entering:'||l_proc, 5);