APPS.FFDBITEM dependencies on FF_DATABASE_ITEMS

Line 212: l_data_type FF_DATABASE_ITEMS.DATA_TYPE%type;

208: p_bg_id in number,
209: p_leg_code in varchar2,
210: p_item_info out FFITEM_INFO_T) is
211: --
212: l_data_type FF_DATABASE_ITEMS.DATA_TYPE%type;
213: l_user_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%type;
214: l_null_allowed FF_DATABASE_ITEMS.NULL_ALLOWED_FLAG%type;
215: l_notfound_allowed FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG%type;
216: l_route_id FF_ROUTES.ROUTE_ID%type;

Line 214: l_null_allowed FF_DATABASE_ITEMS.NULL_ALLOWED_FLAG%type;

210: p_item_info out FFITEM_INFO_T) is
211: --
212: l_data_type FF_DATABASE_ITEMS.DATA_TYPE%type;
213: l_user_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%type;
214: l_null_allowed FF_DATABASE_ITEMS.NULL_ALLOWED_FLAG%type;
215: l_notfound_allowed FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG%type;
216: l_route_id FF_ROUTES.ROUTE_ID%type;
217: l_definition_text FF_DATABASE_ITEMS.DEFINITION_TEXT%type;
218: l_route_text varchar2(8000);

Line 217: l_definition_text FF_DATABASE_ITEMS.DEFINITION_TEXT%type;

213: l_user_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%type;
214: l_null_allowed FF_DATABASE_ITEMS.NULL_ALLOWED_FLAG%type;
215: l_notfound_allowed FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG%type;
216: l_route_id FF_ROUTES.ROUTE_ID%type;
217: l_definition_text FF_DATABASE_ITEMS.DEFINITION_TEXT%type;
218: l_route_text varchar2(8000);
219: cursor c1 is
220: SELECT DI.DATA_TYPE,
221: UE.USER_ENTITY_ID,

Line 227: FROM FF_DATABASE_ITEMS DI,

223: UPPER(UE.NOTFOUND_ALLOWED_FLAG),
224: FR.ROUTE_ID,
225: DI.DEFINITION_TEXT,
226: FR.TEXT
227: FROM FF_DATABASE_ITEMS DI,
228: FF_USER_ENTITIES UE,
229: FF_ROUTES FR
230: WHERE DI.USER_ENTITY_ID = UE.USER_ENTITY_ID
231: AND UE.ROUTE_ID = FR.ROUTE_ID