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 750: INDEX(a FF_DATABASE_ITEMS_PK)

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

Line 752: from ff_database_items a,

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

Line 787: INDEX(a FF_DATABASE_ITEMS_TL_N1)

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

Line 789: from ff_database_items_tl a,

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

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

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

Line 880: INDEX(a FF_DATABASE_ITEMS_PK)

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

Line 882: from ff_database_items a,

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

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

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

Line 925: INDEX(a FF_DATABASE_ITEMS_TL_N1)

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

Line 927: from ff_database_items_tl a,

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

Line 2136: INDEX(B FF_DATABASE_ITEMS_FK1)

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

Line 2140: ff_database_items b,

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

Line 2205: INDEX(C FF_DATABASE_ITEMS_FK1)

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

Line 2208: from ff_database_items c,

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

Line 2418: insert into ff_database_items

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

Line 2463: -- child records in ff_database_items and ff_route_parameter_values

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

Line 2623: ff_database_items_pkg.update_tl_row

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

Line 2666: from ff_database_items dbi

2662: l_proc varchar2(30) := 'pur_asd' ;
2663: cursor c_pur_del ( p_ff_ue_id ff_user_entities.USER_ENTITY_ID%type )
2664: is
2665: select 1
2666: from ff_database_items dbi
2667: where dbi.user_entity_id = p_ff_ue_id
2668: and not exists
2669: ( select 1
2670: from ff_user_entities ue

Line 2685: delete from ff_database_items where user_entity_id= l_pur_del(i).user_entity_id;

2681: if c_pur_del%found then
2682: set_ue_details(l_pur_del(i).user_entity_id,
2683: l_pur_del(i).business_group_id,
2684: l_pur_del(i).legislation_code);
2685: delete from ff_database_items where user_entity_id= l_pur_del(i).user_entity_id;
2686: clear_ue_details;
2687: end if;
2688: close c_pur_del ;
2689: delete from ff_route_parameter_values where user_entity_id= l_pur_del(i).user_entity_id;