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_FCU_BUS dependencies on FF_FUNCTION_CONTEXT_USAGES

Line 31: -- ff_function_context_usages 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_context_usages 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 115: -- ff_function_context_usages and PER_BUSINESS_GROUPS_PERF

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

Line 122: , ff_function_context_usages fcu

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

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 299: (p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'

295: close csr_function_id;
296: exception
297: when app_exception.application_exception then
298: if hr_multi_message.exception_add
299: (p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
300: ) then
301: raise;
302: end if;
303: when others 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 344: (p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'

340: close csr_context;
341: exception
342: when app_exception.application_exception then
343: if hr_multi_message.exception_add
344: (p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
345: ) then
346: raise;
347: end if;
348: when others then

Line 367: from ff_function_context_usages ffcu

363: --
364: cursor csr_unique_context
365: is
366: select NULL
367: from ff_function_context_usages ffcu
368: where ffcu.function_id = p_function_id
369: and ffcu.context_id = p_context_id
370: and ffcu.sequence_number <> nvl(p_sequence_number,-1);
371: --

Line 379: (p_check_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'

375: begin
376: --
377: --
378: if hr_multi_message.no_exclusive_error
379: (p_check_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
380: ,p_check_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
381: ,p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
382: ,p_associated_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
383: ) then

Line 380: ,p_check_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'

376: --
377: --
378: if hr_multi_message.no_exclusive_error
379: (p_check_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
380: ,p_check_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
381: ,p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
382: ,p_associated_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
383: ) then
384:

Line 381: ,p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'

377: --
378: if hr_multi_message.no_exclusive_error
379: (p_check_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
380: ,p_check_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
381: ,p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
382: ,p_associated_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
383: ) then
384:
385: open csr_unique_context;

Line 382: ,p_associated_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'

378: if hr_multi_message.no_exclusive_error
379: (p_check_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
380: ,p_check_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
381: ,p_associated_column1 => 'FF_FUNCTION_CONTEXT_USAGES.FUNCTION_ID'
382: ,p_associated_column2 => 'FF_FUNCTION_CONTEXT_USAGES.CONTEXT_ID'
383: ) then
384:
385: open csr_unique_context;
386: fetch csr_unique_context into l_exists;

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