eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FF_FFP_BUS dependencies on FF_FUNCTION_PARAMETERS

Line 31: -- ff_function_parameters and PER_BUSINESS_GROUPS_PERF

27: --
28: -- Declare cursor
29: --
30: -- EDIT_HERE In the following cursor statement add join(s) between
31: -- ff_function_parameters and PER_BUSINESS_GROUPS_PERF
32: -- so that the security_group_id for
33: -- the current business group context can be derived.
34: -- Remove this comment when the edit has been completed.
35: cursor csr_sec_grp is

Line 39: , ff_function_parameters ffp

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_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

Line 118: -- ff_function_parameters and PER_BUSINESS_GROUPS_PERF

114: --
115: -- Declare cursor
116: --
117: -- EDIT_HERE In the following cursor statement add join(s) between
118: -- ff_function_parameters and PER_BUSINESS_GROUPS_PERF
119: -- so that the legislation_code for
120: -- the current business group context can be derived.
121: -- Remove this comment when the edit has been completed.
122: cursor csr_leg_code is

Line 125: , ff_function_parameters ffp

121: -- Remove this comment when the edit has been completed.
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

Line 282: ff_ffp_shd.constraint_error('FF_FUNCTION_PARAMETERS_FK1');

278: open csr_function_id;
279: fetch csr_function_id into l_exists;
280: if csr_function_id%notfound then
281: close csr_function_id;
282: ff_ffp_shd.constraint_error('FF_FUNCTION_PARAMETERS_FK1');
283: end if;
284: close csr_function_id;
285: --
286: hr_utility.set_location('Entering:'|| l_proc, 20);

Line 291: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'

287: --
288: exception
289: when app_exception.application_exception then
290: if hr_multi_message.exception_add
291: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
292: ) then
293: raise;
294: end if;
295: when others then

Line 337: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.CLASS'

333: --
334: exception
335: when app_exception.application_exception then
336: if hr_multi_message.exception_add
337: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.CLASS'
338: ) then
339: raise;
340: end if;
341: end chk_class;

Line 378: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.DATA_TYPE'

374: --
375: exception
376: when app_exception.application_exception then
377: if hr_multi_message.exception_add
378: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.DATA_TYPE'
379: ) then
380: raise;
381: end if;
382: end chk_data_type;

Line 424: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.NAME'

420: --
421: exception
422: when app_exception.application_exception then
423: if hr_multi_message.exception_add
424: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.NAME'
425: ) then
426: raise;
427: end if;
428: end chk_name;

Line 455: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.CLASS'

451: );
452:
453: --
454: if hr_multi_message.no_exclusive_error
455: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.CLASS'
456: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.OPTIONAL'
457: ) then
458:
459: if hr_api.not_exists_in_hrstanlookups

Line 456: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.OPTIONAL'

452:
453: --
454: if hr_multi_message.no_exclusive_error
455: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.CLASS'
456: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.OPTIONAL'
457: ) then
458:
459: if hr_api.not_exists_in_hrstanlookups
460: (p_effective_date => p_effective_date

Line 478: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.OPTIONAL'

474: --
475: exception
476: when app_exception.application_exception then
477: if hr_multi_message.exception_add
478: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.OPTIONAL'
479: ) then
480: raise;
481: end if;
482: end chk_optional;

Line 510: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.CLASS'

506: );
507:
508: --
509: if hr_multi_message.no_exclusive_error
510: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.CLASS'
511: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.CONTINUING_PARAMETER'
512: ) then
513:
514: if hr_api.not_exists_in_hrstanlookups

Line 511: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.CONTINUING_PARAMETER'

507:
508: --
509: if hr_multi_message.no_exclusive_error
510: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.CLASS'
511: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.CONTINUING_PARAMETER'
512: ) then
513:
514: if hr_api.not_exists_in_hrstanlookups
515: (p_effective_date => p_effective_date

Line 533: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.CONTINUING_PARAMETER'

529: --
530: exception
531: when app_exception.application_exception then
532: if hr_multi_message.exception_add
533: (p_associated_column1 => 'FF_FUNCTION_PARAMETERS.CONTINUING_PARAMETER'
534: ) then
535: raise;
536: end if;
537: end chk_continuing_parameter;

Line 551: from ff_function_parameters ffp

547: --
548: cursor csr_unique_parameter
549: is
550: select NULL
551: from ff_function_parameters ffp
552: where ffp.function_id = p_function_id
553: and ffp.name like p_name
554: and sequence_number <> nvl(p_sequence_number,-1);
555: --

Line 563: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'

559: begin
560: --
561: --
562: if hr_multi_message.no_exclusive_error
563: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
564: ,p_check_column2 => 'FF_FUNCTION_PARAMETERS.NAME'
565: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
566: ,p_associated_column2 => 'FF_FUNCTION_PARAMETERS.NAME'
567: ) then

Line 564: ,p_check_column2 => 'FF_FUNCTION_PARAMETERS.NAME'

560: --
561: --
562: if hr_multi_message.no_exclusive_error
563: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
564: ,p_check_column2 => 'FF_FUNCTION_PARAMETERS.NAME'
565: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
566: ,p_associated_column2 => 'FF_FUNCTION_PARAMETERS.NAME'
567: ) then
568:

Line 565: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'

561: --
562: if hr_multi_message.no_exclusive_error
563: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
564: ,p_check_column2 => 'FF_FUNCTION_PARAMETERS.NAME'
565: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
566: ,p_associated_column2 => 'FF_FUNCTION_PARAMETERS.NAME'
567: ) then
568:
569: open csr_unique_parameter;

Line 566: ,p_associated_column2 => 'FF_FUNCTION_PARAMETERS.NAME'

562: if hr_multi_message.no_exclusive_error
563: (p_check_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
564: ,p_check_column2 => 'FF_FUNCTION_PARAMETERS.NAME'
565: ,p_associated_column1 => 'FF_FUNCTION_PARAMETERS.FUNCTION_ID'
566: ,p_associated_column2 => 'FF_FUNCTION_PARAMETERS.NAME'
567: ) then
568:
569: open csr_unique_parameter;
570: fetch csr_unique_parameter into l_exists;

Line 573: ff_ffp_shd.constraint_error('FF_FUNCTION_PARAMETERS_UK2');

569: open csr_unique_parameter;
570: fetch csr_unique_parameter into l_exists;
571: if csr_unique_parameter%found then
572: close csr_unique_parameter;
573: ff_ffp_shd.constraint_error('FF_FUNCTION_PARAMETERS_UK2');
574: end if;
575: close csr_unique_parameter;
576: end if;
577: