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.FFDICT dependencies on FF_DATABASE_ITEMS

Line 15: g_glb_dbi ff_database_items.user_name%TYPE;

11: -- Temporary storage for global database item information.
12: --
13: g_glb_id ff_globals_f.global_id%TYPE;
14: g_glb_ueid ff_user_entities.user_entity_id%TYPE;
15: g_glb_dbi ff_database_items.user_name%TYPE;
16: --
17: g_debug boolean := hr_utility.debug_enabled;
18: ------------------------------ fetch_ue_details -------------------------------
19: --

Line 84: , ff_database_items dbi

80: cursor csr_ueid(p_global_id in number) is
81: select /*+ INDEX(ue FF_USER_ENTITIES_N51) */ dbi.user_entity_id
82: , dbi.user_name
83: from ff_user_entities ue
84: , ff_database_items dbi
85: where ue.creator_type = 'S'
86: and ue.creator_id = p_global_id
87: and dbi.user_entity_id = ue.user_entity_id
88: ;

Line 749: INDEX(a FF_DATABASE_ITEMS_PK)

745: --
746: begin
747: select null into dummy from dual where exists
748: (select /*+ ORDERED
749: INDEX(a FF_DATABASE_ITEMS_PK)
750: INDEX(b FF_USER_ENTITIES_PK) */ null
751: from ff_database_items a,
752: ff_user_entities b
753: where a.user_entity_id = b.user_entity_id

Line 751: from ff_database_items a,

747: select null into dummy from dual where exists
748: (select /*+ ORDERED
749: INDEX(a FF_DATABASE_ITEMS_PK)
750: INDEX(b FF_USER_ENTITIES_PK) */ null
751: from ff_database_items a,
752: ff_user_entities b
753: where a.user_entity_id = b.user_entity_id
754: and a.user_name = p_item_name
755: and

Line 786: INDEX(a FF_DATABASE_ITEMS_TL_N1)

782: exception
783: when no_data_found then
784: select null into dummy from dual where exists
785: (select /*+ ORDERED
786: INDEX(a FF_DATABASE_ITEMS_TL_N1)
787: INDEX(b FF_USER_ENTITIES_PK) */ null
788: from ff_database_items_tl a,
789: ff_user_entities b
790: where a.user_entity_id = b.user_entity_id

Line 788: from ff_database_items_tl a,

784: select null into dummy from dual where exists
785: (select /*+ ORDERED
786: INDEX(a FF_DATABASE_ITEMS_TL_N1)
787: INDEX(b FF_USER_ENTITIES_PK) */ null
788: from ff_database_items_tl a,
789: ff_user_entities b
790: where a.user_entity_id = b.user_entity_id
791: and a.translated_user_name = p_item_name
792: and

Line 875: -- Check for clash with other FF_DATABASE_ITEMS rows.

871: ffstup.get_mode(p_business_group_id, p_legislation_code);
872:
873: begin
874: --
875: -- Check for clash with other FF_DATABASE_ITEMS rows.
876: --
877: select null into dummy from dual where exists
878: (select /*+ ORDERED
879: INDEX(a FF_DATABASE_ITEMS_PK)

Line 879: INDEX(a FF_DATABASE_ITEMS_PK)

875: -- Check for clash with other FF_DATABASE_ITEMS rows.
876: --
877: select null into dummy from dual where exists
878: (select /*+ ORDERED
879: INDEX(a FF_DATABASE_ITEMS_PK)
880: INDEX(b FF_USER_ENTITIES_PK) */ null
881: from ff_database_items a,
882: ff_user_entities b
883: where a.user_name = p_tl_user_name

Line 881: from ff_database_items a,

877: select null into dummy from dual where exists
878: (select /*+ ORDERED
879: INDEX(a FF_DATABASE_ITEMS_PK)
880: INDEX(b FF_USER_ENTITIES_PK) */ null
881: from ff_database_items a,
882: ff_user_entities b
883: where a.user_name = p_tl_user_name
884: and a.user_entity_id <> p_user_entity_id
885: and a.user_entity_id = b.user_entity_id

Line 920: -- No clash against FF_DATABASE_ITEMS so check against FF_DATABASE_ITEMS_TL.

916: hr_utility.set_location('ffdict.tl_dbi_will_clash',3);
917: end if;
918:
919: --
920: -- No clash against FF_DATABASE_ITEMS so check against FF_DATABASE_ITEMS_TL.
921: --
922: select null into dummy from dual where exists
923: (select /*+ ORDERED
924: INDEX(a FF_DATABASE_ITEMS_TL_N1)

Line 924: INDEX(a FF_DATABASE_ITEMS_TL_N1)

920: -- No clash against FF_DATABASE_ITEMS so check against FF_DATABASE_ITEMS_TL.
921: --
922: select null into dummy from dual where exists
923: (select /*+ ORDERED
924: INDEX(a FF_DATABASE_ITEMS_TL_N1)
925: INDEX(b FF_USER_ENTITIES_PK) */ null
926: from ff_database_items_tl a,
927: ff_user_entities b
928: where a.translated_user_name = p_tl_user_name

Line 926: from ff_database_items_tl a,

922: select null into dummy from dual where exists
923: (select /*+ ORDERED
924: INDEX(a FF_DATABASE_ITEMS_TL_N1)
925: INDEX(b FF_USER_ENTITIES_PK) */ null
926: from ff_database_items_tl a,
927: ff_user_entities b
928: where a.translated_user_name = p_tl_user_name
929: and (a.user_name <> p_user_name or a.user_entity_id <> p_user_entity_id)
930: and a.user_entity_id = b.user_entity_id

Line 2133: INDEX(B FF_DATABASE_ITEMS_FK1)

2129: where exists
2130: (
2131: select /*+ ORDERED
2132: INDEX(C FF_USER_ENTITIES_FK1)
2133: INDEX(B FF_DATABASE_ITEMS_FK1)
2134: INDEX(A FF_FDI_USAGES_F_N50) */
2135: null
2136: from ff_user_entities c,
2137: ff_database_items b,

Line 2137: ff_database_items b,

2133: INDEX(B FF_DATABASE_ITEMS_FK1)
2134: INDEX(A FF_FDI_USAGES_F_N50) */
2135: null
2136: from ff_user_entities c,
2137: ff_database_items b,
2138: ff_fdi_usages_f a
2139: where a.item_name = b.user_name
2140: and a.usage = 'D'
2141: and b.user_entity_id = c.user_entity_id

Line 2202: INDEX(C FF_DATABASE_ITEMS_FK1)

2198: select 'X' into dummy from dual
2199: where exists
2200: (
2201: select /*+ ORDERED
2202: INDEX(C FF_DATABASE_ITEMS_FK1)
2203: INDEX(A FF_FDI_USAGES_F_N50)
2204: INDEX(B FF_FORMULAS_F_PK) */ null
2205: from ff_database_items c,
2206: ff_fdi_usages_f a,

Line 2205: from ff_database_items c,

2201: select /*+ ORDERED
2202: INDEX(C FF_DATABASE_ITEMS_FK1)
2203: INDEX(A FF_FDI_USAGES_F_N50)
2204: INDEX(B FF_FORMULAS_F_PK) */ null
2205: from ff_database_items c,
2206: ff_fdi_usages_f a,
2207: ff_formulas_f b
2208: where a.formula_id = b.formula_id
2209: and a.item_name = c.user_name

Line 2415: insert into ff_database_items

2411: );
2412: -- set error tracking information
2413: hr_utility.set_location('ffdict.create_global_dbitem',9);
2414: --
2415: insert into ff_database_items
2416: (user_name,
2417: user_entity_id,
2418: data_type,
2419: definition_text,

Line 2460: -- child records in ff_database_items and ff_route_parameter_values

2456: -- set error tracking information
2457: hr_utility.set_location('ffdict.delete_global_dbitem',1);
2458: --
2459: -- Delete user entity created for this global with a cascade delete of
2460: -- child records in ff_database_items and ff_route_parameter_values
2461: --
2462: delete from ff_user_entities
2463: where creator_id = p_global_id
2464: and creator_type = 'S';

Line 2620: ff_database_items_pkg.update_tl_row

2616:
2617: --
2618: -- Convert the global name to a dbi name.
2619: --
2620: ff_database_items_pkg.update_tl_row
2621: (x_user_name => g_glb_dbi
2622: ,x_user_entity_id => g_glb_ueid
2623: ,x_language => p_language
2624: ,x_source_lang => p_source_lang