[Home] [Help]
28: mreid 01-OCT-1999 Added explicit column list to insert on
29: ff_archive_items
30: nbristow 09-NOV-1999 Changes to the ff_archive_item table made for
31: the new Archive Item API.
32: alogue 15-FEB-2000 Utf8 support : ff_database_items user_name and
33: ff_user_entities item_name lengthened to 240.
34: Use of varchar_240_tbl.
35: Remove insert of 'AAP' into
36: ff_archive_items.archive_type as column doesn't
136: -- Get the defined_balance_id for the specified balance DB item.
137: --
138: cursor csr_defined_balance is
139: select to_number(UE.creator_id)
140: from ff_database_items DI,
141: ff_user_entities UE
142: where DI.user_name = p_db_item_name
143: and UE.user_entity_id = DI.user_entity_id
144: and UE.creator_type = 'B'
250: con.context_id = rcu.context_id ;
251: --
252: db_items_row db_items_csr%ROWTYPE;
253: contexts_row contexts_csr%ROWTYPE;
254: user_entity_id ff_database_items.user_entity_id%TYPE;
255: route_id ff_routes.route_id%TYPE;
256: a_user_entity_id ff_database_items.user_entity_id%TYPE;
257: a_data_type ff_database_items.data_type%TYPE;
258: creator_type ff_user_entities.creator_type%TYPE;
252: db_items_row db_items_csr%ROWTYPE;
253: contexts_row contexts_csr%ROWTYPE;
254: user_entity_id ff_database_items.user_entity_id%TYPE;
255: route_id ff_routes.route_id%TYPE;
256: a_user_entity_id ff_database_items.user_entity_id%TYPE;
257: a_data_type ff_database_items.data_type%TYPE;
258: creator_type ff_user_entities.creator_type%TYPE;
259: name VARCHAR2(240);
260: flag VARCHAR2(1);
253: contexts_row contexts_csr%ROWTYPE;
254: user_entity_id ff_database_items.user_entity_id%TYPE;
255: route_id ff_routes.route_id%TYPE;
256: a_user_entity_id ff_database_items.user_entity_id%TYPE;
257: a_data_type ff_database_items.data_type%TYPE;
258: creator_type ff_user_entities.creator_type%TYPE;
259: name VARCHAR2(240);
260: flag VARCHAR2(1);
261: --
282: --
283: -- Get archive entity id and data type
284: SELECT dbi.user_entity_id, dbi.data_type
285: INTO a_user_entity_id, a_data_type
286: FROM ff_database_items dbi,
287: ff_user_entities ue
288: WHERE dbi.user_name = db_items_row.item_name AND
289: dbi.user_entity_id = ue.user_entity_id AND
290: ((ue.legislation_code is null
291: and ue.business_group_id is null
292: and not exists
293: (select ''
294: from ff_user_entities fue2,
295: ff_database_items fdi2
296: where fdi2.user_name = db_items_row.item_name
297: and fdi2.user_entity_id = fue2.user_entity_id
298: and (fue2.business_group_id = l_business_group_id
299: or fue2.legislation_code = l_legislation_code)
303: and l_legislation_code = ue.legislation_code
304: and not exists
305: (select ''
306: from ff_user_entities fue2,
307: ff_database_items fdi2
308: where fdi2.user_name = db_items_row.item_name
309: and fdi2.user_entity_id = fue2.user_entity_id
310: and fue2.business_group_id = l_business_group_id
311: )
317: -- Get live entity id to get the contexts
318: --
319: SELECT dbi.user_entity_id,ue.creator_type,ue.route_id
320: INTO user_entity_id,creator_type,route_id
321: FROM ff_database_items dbi,
322: ff_user_entities ue
323: WHERE dbi.user_name = name AND
324: dbi.user_entity_id = ue.user_entity_id
325: and ((ue.legislation_code is null
326: and ue.business_group_id is null
327: and not exists
328: (select ''
329: from ff_user_entities fue2,
330: ff_database_items fdi2
331: where fdi2.user_name = name
332: and fdi2.user_entity_id = fue2.user_entity_id
333: and (fue2.business_group_id = l_business_group_id
334: or fue2.legislation_code = l_legislation_code)
338: and l_legislation_code = ue.legislation_code
339: and not exists
340: (select ''
341: from ff_user_entities fue2,
342: ff_database_items fdi2
343: where fdi2.user_name = name
344: and fdi2.user_entity_id = fue2.user_entity_id
345: and fue2.business_group_id = l_business_group_id
346: )