[Home] [Help]
168: l_dbi_description,
169: l_dbi_data_type,
170: l_dbi_user_name
171: FROM ff_database_items dbi,
172: ff_user_entities ue
173: WHERE dbi.user_name = SUBSTR(p_item_name, 3, LENGTH(p_item_name) - 2)
174: AND dbi.user_entity_id = ue.user_entity_id
175: AND ue.legislation_code = 'MX'
176: AND ue.business_group_id IS NULL;
194: l_dbi_description,
195: l_dbi_data_type,
196: l_dbi_user_name
197: FROM ff_database_items dbi,
198: ff_user_entities ue
199: WHERE dbi.user_name = SUBSTR(p_item_name, 3, LENGTH(p_item_name) - 2)
200: AND dbi.user_entity_id = ue.user_entity_id
201: AND ue.legislation_code IS NULL
202: AND ue.business_group_id IS NULL;
242:
243: -- Check to see if the archive database item already exist
244: SELECT user_entity_id
245: INTO l_user_entity_seq
246: FROM ff_user_entities
247: WHERE user_entity_name = p_item_name
248: AND legislation_code = 'MX'
249: AND business_group_id IS NULL;
250:
247: WHERE user_entity_name = p_item_name
248: AND legislation_code = 'MX'
249: AND business_group_id IS NULL;
250:
251: -- Commented because FF_USER_ENTITIES_BRU doesn't allow update
252: --
253: -- UPDATE ff_user_entities
254: -- SET route_id = l_route_id,
255: -- notfound_allowed_flag = 'Y', -- l_ue_notfound_allowed_flag,
249: AND business_group_id IS NULL;
250:
251: -- Commented because FF_USER_ENTITIES_BRU doesn't allow update
252: --
253: -- UPDATE ff_user_entities
254: -- SET route_id = l_route_id,
255: -- notfound_allowed_flag = 'Y', -- l_ue_notfound_allowed_flag,
256: -- entity_description = SUBSTR('Archive of ' ||
257: -- l_ue_entity_description, 1, 240)
310:
311: EXCEPTION WHEN NO_DATA_FOUND THEN
312:
313: -- Create the archive database item
314: SELECT ff_user_entities_s.NEXTVAL
315: INTO l_user_entity_seq
316: FROM dual;
317:
318: INSERT INTO ff_user_entities
314: SELECT ff_user_entities_s.NEXTVAL
315: INTO l_user_entity_seq
316: FROM dual;
317:
318: INSERT INTO ff_user_entities
319: (
320: user_entity_id,
321: business_group_id,
322: legislation_code,