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_DATA_DICT dependencies on FF_USER_ENTITIES

Line 12: statem := 'alter trigger ff_user_entities_bru disable';

8: statem varchar2(256);
9: sql_cur number;
10: ignore number;
11: begin
12: statem := 'alter trigger ff_user_entities_bru disable';
13: sql_cur := dbms_sql.open_cursor;
14: dbms_sql.parse(sql_cur,
15: statem,
16: dbms_sql.v7);

Line 26: statem := 'alter trigger ff_user_entities_bru enable';

22: statem varchar2(256);
23: sql_cur number;
24: ignore number;
25: begin
26: statem := 'alter trigger ff_user_entities_bru enable';
27: sql_cur := dbms_sql.open_cursor;
28: dbms_sql.parse(sql_cur,
29: statem,
30: dbms_sql.v7);

Line 1991: -- 2. ff_user_entities

1987: -- STU tables and the installed tables then a conflict is detected. In
1988: -- This instance all STU surrogate keys, for this table, are updated.
1989: -- Three tables are tested:
1990: -- 1. ff_routes
1991: -- 2. ff_user_entities
1992: -- 3. ff_route_parameters
1993: -- The second is tested for using the sequences.
1994: -- If the next value from the live sequence is within the range of
1995: -- delivered surrogate id's then the live sequence must be incremented.

Line 2000: -- 2. ff_user_entities_s

1996: -- If no action is taken, then duplicates may be introduced into the
1997: -- delivered tables, and child rows may be totally invalidated.
1998: -- This procedure will check three sequences
1999: -- 1. ff_routes_S
2000: -- 2. ff_user_entities_s
2001: -- 3. ff_route_parameters_s
2002:
2003: v_sequence_number number(9);
2004: v_min_delivered number(9);

Line 2025: cursor get_ff_user_entities is

2021: from hr_s_route_parameters b
2022: where b.route_parameter_id = a.route_parameter_id
2023: );
2024:
2025: cursor get_ff_user_entities is
2026: select distinct null
2027: from ff_user_entities a
2028: where exists
2029: (select null

Line 2027: from ff_user_entities a

2023: );
2024:
2025: cursor get_ff_user_entities is
2026: select distinct null
2027: from ff_user_entities a
2028: where exists
2029: (select null
2030: from hr_s_user_entities b
2031: where a.user_entity_id = b.user_entity_id

Line 2110: open get_ff_user_entities;

2106: BEGIN --check that no conflict exists with the id's of the installed
2107: --user entities, compared with the values of delivered UE's
2108:
2109: --
2110: open get_ff_user_entities;
2111: fetch get_ff_user_entities into l_null_return;
2112: IF get_ff_user_entities%NOTFOUND OR get_ff_user_entities%NOTFOUND IS NULL THEN
2113: RAISE NO_DATA_FOUND;
2114: END IF;

Line 2111: fetch get_ff_user_entities into l_null_return;

2107: --user entities, compared with the values of delivered UE's
2108:
2109: --
2110: open get_ff_user_entities;
2111: fetch get_ff_user_entities into l_null_return;
2112: IF get_ff_user_entities%NOTFOUND OR get_ff_user_entities%NOTFOUND IS NULL THEN
2113: RAISE NO_DATA_FOUND;
2114: END IF;
2115: close get_ff_user_entities;

Line 2112: IF get_ff_user_entities%NOTFOUND OR get_ff_user_entities%NOTFOUND IS NULL THEN

2108:
2109: --
2110: open get_ff_user_entities;
2111: fetch get_ff_user_entities into l_null_return;
2112: IF get_ff_user_entities%NOTFOUND OR get_ff_user_entities%NOTFOUND IS NULL THEN
2113: RAISE NO_DATA_FOUND;
2114: END IF;
2115: close get_ff_user_entities;
2116: --

Line 2115: close get_ff_user_entities;

2111: fetch get_ff_user_entities into l_null_return;
2112: IF get_ff_user_entities%NOTFOUND OR get_ff_user_entities%NOTFOUND IS NULL THEN
2113: RAISE NO_DATA_FOUND;
2114: END IF;
2115: close get_ff_user_entities;
2116: --
2117: --conflict exists, so update the stu values of user_entity_id
2118:
2119: update /*+NO_INDEX*/ hr_s_user_entities

Line 2155: -- Now check ff_user_entities

2151: v_max_delivered);
2152:
2153: END IF;
2154:
2155: -- Now check ff_user_entities
2156:
2157:
2158: select min(user_entity_id) - (count(*) *3)
2159: , max(user_entity_id) + (count(*) *3)

Line 2164: select ff_user_entities_s.nextval

2160: into v_min_delivered
2161: , v_max_delivered
2162: from hr_s_user_entities;
2163:
2164: select ff_user_entities_s.nextval
2165: into v_sequence_number
2166: from dual;
2167:
2168: IF v_sequence_number

Line 2171: hr_legislation.munge_sequence('FF_USER_ENTITIES_S',

2167:
2168: IF v_sequence_number
2169: BETWEEN v_min_delivered AND v_max_delivered THEN
2170:
2171: hr_legislation.munge_sequence('FF_USER_ENTITIES_S',
2172: v_sequence_number,
2173: v_max_delivered);
2174:
2175: END IF;

Line 2214: ff_user_entities fue

2210: select distinct ffu.formula_id fid
2211: from ff_fdi_usages_f ffu
2212: where ffu.item_name in (select fdbi.user_name
2213: from ff_database_items fdbi,
2214: ff_user_entities fue
2215: where fdbi.user_entity_id = fue.user_entity_id
2216: and fue.route_id = p_route_id);
2217:
2218: BEGIN

Line 2346: P_TABLE_NAME => 'FF_USER_ENTITIES',

2342: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
2343: -- Check if we have a pseduo seed clash if enabled
2344: -- Error handling is done in the procedure itself
2345: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => delivered_entities.user_entity_name,
2346: P_TABLE_NAME => 'FF_USER_ENTITIES',
2347: P_LEGISLATION_CODE => delivered_entities.legislation_code);
2348: END IF;
2349:
2350: BEGIN

Line 2354: from ff_user_entities

2350: BEGIN
2351:
2352: select user_entity_id
2353: into l_new_entity_id
2354: from ff_user_entities
2355: where user_entity_name = delivered_entities.user_entity_name
2356: and nvl(legislation_code,'X') = nvl(delivered_entities.legislation_code,'X')
2357: and route_id = l_new_surrogate_key;
2358:

Line 2361: select ff_user_entities_s.nextval

2357: and route_id = l_new_surrogate_key;
2358:
2359: EXCEPTION WHEN NO_DATA_FOUND THEN
2360:
2361: select ff_user_entities_s.nextval
2362: into l_new_entity_id
2363: from dual;
2364:
2365: WHEN TOO_MANY_ROWS THEN

Line 2367: hr_utility.trace('sel ff_user_entities TMR');

2363: from dual;
2364:
2365: WHEN TOO_MANY_ROWS THEN
2366: hr_legislation.hrrunprc_trace_on;
2367: hr_utility.trace('sel ff_user_entities TMR');
2368: hr_utility.trace('user_entity_name ' ||
2369: delivered_entities.user_entity_name);
2370: hr_utility.trace('route_id ' ||
2371: to_char(l_new_surrogate_key));

Line 2654: from ff_user_entities

2650: USER_ENTITY_NAME,
2651: CREATOR_ID,
2652: CREATOR_TYPE,
2653: ENTITY_DESCRIPTION
2654: from ff_user_entities
2655: where user_entity_id = v_user_entity_id
2656: )
2657: UNION
2658: (select

Line 2667: from ff_user_entities

2663: USER_ENTITY_NAME,
2664: CREATOR_ID,
2665: CREATOR_TYPE,
2666: ENTITY_DESCRIPTION
2667: from ff_user_entities
2668: where user_entity_id = v_user_entity_id
2669: MINUS
2670: select
2671: BUSINESS_GROUP_ID,

Line 2711: from ff_user_entities

2707: -- Show that this user entity differs from the install one
2708: begin
2709: select user_entity_name
2710: into ue_name1
2711: from ff_user_entities
2712: where user_entity_id = v_user_entity_id;
2713: select user_entity_name
2714: into ue_name2
2715: from hr_s_user_entities

Line 2765: update ff_user_entities

2761: delete ff_fdi_usages_f where formula_id = r_form.fid;
2762: delete ff_compiled_info_f where formula_id = r_form.fid;
2763: end loop;
2764:
2765: update ff_user_entities
2766: set business_group_id = all_user_entities.business_group_id
2767: ,legislation_code = all_user_entities.legislation_code
2768: ,route_id = all_user_entities.route_id
2769: ,notfound_allowed_flag = all_user_entities.notfound_allowed_flag

Line 2784: insert into ff_user_entities

2780:
2781: IF SQL%NOTFOUND THEN
2782:
2783: BEGIN
2784: insert into ff_user_entities
2785: (user_entity_id
2786: ,business_group_id
2787: ,legislation_code
2788: ,route_id

Line 2819: hr_utility.trace('ins ff_user_entities');

2815: );
2816:
2817: EXCEPTION WHEN OTHERS THEN
2818: hr_legislation.hrrunprc_trace_on;
2819: hr_utility.trace('ins ff_user_entities');
2820: hr_utility.trace('user_entity_name ' ||
2821: all_user_entities.user_entity_name);
2822: hr_utility.trace('user_entity_id ' ||
2823: to_char(all_user_entities.user_entity_id));

Line 2999: ff_user_entities fue,

2995: cursor c_form2(p_route_id number) is
2996: select /*+ LEADING (FUE,FDBI) */
2997: distinct formula_id fid
2998: from
2999: ff_user_entities fue,
3000: ff_database_items fdbi,
3001: ff_fdi_usages_f fdi
3002: where fdi.item_name = fdbi.user_name
3003: and fdbi.user_entity_id = fue.user_entity_id

Line 3136: delete from ff_user_entities

3132: -- Ensure we rebuild all balance user entities and associated
3133: -- items in rebuild ele input bal for a changed route
3134: --
3135: IF NOT l_new_route THEN
3136: delete from ff_user_entities
3137: where creator_type in ('B', 'RB')
3138: and route_id = stu_rec.c_surrogate_key;
3139: END IF;
3140: --

Line 4375: ff_user_entities ffue

4371: select distinct ffu.formula_id fid
4372: from ff_fdi_usages_f ffu
4373: where ffu.item_name in (select fdbi.user_name
4374: from ff_database_items fdbi,
4375: ff_user_entities ffue
4376: where fdbi.user_entity_id = ffue.user_entity_id
4377: and ffue.creator_id = p_global_id
4378: and ffue.creator_type = 'S');
4379:

Line 4793: from ff_user_entities u,

4789: from hr_s_globals_f
4790: where global_id = l_new_global_id
4791: ))
4792: and exists (select distinct null
4793: from ff_user_entities u,
4794: ff_database_items d,
4795: ff_route_parameters rp,
4796: ff_route_parameter_values rpv
4797: where u.user_entity_name = global_name || '_GLOBAL_UE'

Line 4819: from ff_user_entities

4815: -- associated with this global bug 3744555
4816: -- and let them get recreated by the global triggers
4817: delete ff_route_parameter_values
4818: where user_entity_id = (select user_entity_id
4819: from ff_user_entities
4820: where user_entity_name = r_distinct.c_true_key || '_GLOBAL_UE');
4821:
4822: delete from ff_globals_f
4823: where global_id = r_distinct.c_surrogate_key;