438: l_dbi_description,
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;
582: );
583:
584: end;
585:
586: update ff_database_items
587: set user_entity_id = l_user_entity_seq,
588: data_type = l_dbi_data_type,
589: definition_text = l_definition_text,
590: null_allowed_flag = 'Y', -- l_dbi_null_allowed_flag,
657: 0,
658: sysdate
659: );
660:
661: insert into ff_database_items
662: (
663: user_name,
664: user_entity_id,
665: data_type,
829: 0,
830: sysdate
831: );
832: --
833: insert into ff_database_items
834: (
835: user_name,
836: user_entity_id,
837: data_type,