[Home] [Help]
439: l_dbi_data_type,
440: l_dbi_user_name
441: from
442: ff_database_items dbi,
443: ff_user_entities ue
444: where dbi.user_name = p_live_dbi_name
445: and dbi.user_entity_id = ue.user_entity_id
446: and ue.business_group_id is null;
447: --
526: -- etc.
527: --
528: select user_entity_id
529: into l_user_entity_seq
530: from ff_user_entities
531: where user_entity_name = l_archive_dbi_name
532: and business_group_id is null;
533:
534: -- Removed as you are not allowed to update this table.
531: where user_entity_name = l_archive_dbi_name
532: and business_group_id is null;
533:
534: -- Removed as you are not allowed to update this table.
535: -- update ff_user_entities
536: -- set route_id = l_route_id,
537: -- notfound_allowed_flag = 'Y', -- l_ue_notfound_allowed_flag,
538: -- entity_description = substr('Archive of ' || l_ue_entity_description, 1, 240)
539: -- where user_entity_name = l_archive_dbi_name
595: --
596: -- Archive DBI does not exist, so create the User Entity,
597: -- Route Parameter, and DBI.
598: --
599: select ff_user_entities_s.nextval into l_user_entity_seq from dual;
600:
601: insert into ff_user_entities
602: (
603: user_entity_id,
597: -- Route Parameter, and DBI.
598: --
599: select ff_user_entities_s.nextval into l_user_entity_seq from dual;
600:
601: insert into ff_user_entities
602: (
603: user_entity_id,
604: business_group_id,
605: legislation_code,
713: where route_id = c_route_id;
714: --
715: cursor get_user_entity_id (c_user_entity_name varchar2) is
716: select user_entity_id
717: from ff_user_entities
718: where user_entity_name = c_user_entity_name;
719: --
720: cursor get_route_parameter_id (c_route_id number) is
721: select route_parameter_id
769: -- Create a new User Entity and DBI, and Route Parameter Value.
770: --
771: BEGIN
772: --
773: select ff_user_entities_s.nextval into l_user_entity_id from dual;
774: --
775: insert into ff_user_entities
776: (
777: user_entity_id,
771: BEGIN
772: --
773: select ff_user_entities_s.nextval into l_user_entity_id from dual;
774: --
775: insert into ff_user_entities
776: (
777: user_entity_id,
778: business_group_id,
779: legislation_code,
860: );
861: END;
862: --
863: --
864: -- NB cannot update ff_user_entities.
865: --
866: END IF;
867: --
868: end create_archive_dbi;