CREATE OR REPLACE procedure copy_subscriber( p_subscriber_id in number, p_seed_subscriber_id in number default 1) authid current_user is begin for x in ( select SUBSCRIBER_ID,BASE_STRING_ID,DOMAIN,ID,LANGUAGE,NAME,SUB_DOMAIN, TEXT,TEXT_START,TEXT_STRING from PORTAL.WWNLS_STRINGS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWNLS_STRINGS$ (SUBSCRIBER_ID,BASE_STRING_ID,DOMAIN,ID,LANGUAGE,NAME,SUB_DOMAIN, TEXT,TEXT_START,TEXT_STRING) values (p_subscriber_id,x.BASE_STRING_ID,x.DOMAIN,x.ID,x.LANGUAGE, x.NAME,x.SUB_DOMAIN,x.TEXT,x.TEXT_START,x.TEXT_STRING); end loop; -- commit; -- insert into PORTAL.WWSBR_SITES$ (SUBSCRIBER_ID,CREATEDATE,CREATOR,DEFAULTLANGUAGE,ID, IS_WORKFLOW_ON,NAME,PRODUCTION,PROVIDER_ID,QUOTA_LIMIT, UPDATEDATE,USED_QUOTA) select p_subscriber_id,CREATEDATE,CREATOR,DEFAULTLANGUAGE,ID, IS_WORKFLOW_ON,NAME,PRODUCTION,PROVIDER_ID,QUOTA_LIMIT, UPDATEDATE,USED_QUOTA from PORTAL.WWSBR_SITES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULES$ (SUBSCRIBER_ID,ABOUT,AFTER_PAGE_HTML,BEFORE_PAGE_HTML,CREATED_BY, CREATED_ON,DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID,ENCTYPE, HELP,ID,LAST_MODIFIED_BY,LAST_MODIFIED_ON,NAME,OWNER, PUBLISH_TO_PORTAL,TEMPLATE,TITLE_ID,TITLE_SUBSCRIBER_ID,VERSION) select p_subscriber_id,ABOUT,AFTER_PAGE_HTML,BEFORE_PAGE_HTML, CREATED_BY,CREATED_ON,DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID, ENCTYPE,HELP,ID,LAST_MODIFIED_BY,LAST_MODIFIED_ON,NAME,OWNER, PUBLISH_TO_PORTAL,TEMPLATE,TITLE_ID,TITLE_SUBSCRIBER_ID,VERSION from PORTAL.WWA_MODULES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWCTX_PROXY$ (SUBSCRIBER_ID,DEFAULT_PROXY,HOST_NAME,ID,PASSWORD,PORT_NUMBER, REALM,USERNAME) select p_subscriber_id,DEFAULT_PROXY,HOST_NAME,ID,PASSWORD,PORT_NUMBER, REALM,USERNAME from PORTAL.WWCTX_PROXY$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_SITE_LANGUAGES$ (SUBSCRIBER_ID,LANGUAGE,PRODUCTION,SITEID,TITLE) select p_subscriber_id,LANGUAGE,PRODUCTION,SITEID,TITLE from PORTAL.WWSBR_SITE_LANGUAGES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_MODULE_GROUPS$ (SUBSCRIBER_ID,DESCRIPTION,HELP,ID,IDENT,IMAGE,NAME) select p_subscriber_id,DESCRIPTION,HELP,ID,IDENT,IMAGE,NAME from PORTAL.WWV_SYS_MODULE_GROUPS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_NODE$ (SUBSCRIBER_ID,DAD_NAME,DB_LINK,HTTP_LISTENER_HOST, HTTP_LISTENER_PORT,ID,LOCAL,NAME) select p_subscriber_id,DAD_NAME,DB_LINK,HTTP_LISTENER_HOST, HTTP_LISTENER_PORT,ID,LOCAL,NAME from PORTAL.WWPRO_NODE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_BLOCKS$ (SUBSCRIBER_ID,ID,INITIAL_INSTANCES,MAX_INSTANCES,MODULE_ID,NAME, VERSION) select p_subscriber_id,ID,INITIAL_INSTANCES,MAX_INSTANCES,MODULE_ID, NAME,VERSION from PORTAL.WWA_MODULE_BLOCKS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_FLOW_GROUP$ (SUBSCRIBER_ID,ID,IS_DEFAULT,NAME,SITE_ID) select p_subscriber_id,ID,IS_DEFAULT,NAME,SITE_ID from PORTAL.WWPOB_FLOW_GROUP$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWTYP_DYNAMIC_TYPE$ (SUBSCRIBER_ID,DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID,ID, IMPLEMENTATION_TYPE,INPUT_FORMAT_1,INPUT_FORMAT_1_SUBSCRIBER_ID, INPUT_FORMAT_2,INPUT_FORMAT_2_SUBSCRIBER_ID,INPUT_FORMAT_3, INPUT_FORMAT_3_SUBSCRIBER_ID,INPUT_FORMAT_4, INPUT_FORMAT_4_SUBSCRIBER_ID,INPUT_FORMAT_PACKAGE,NAME, OUTPUT_FORMAT,OUTPUT_FORMAT_PACKAGE,OUTPUT_FORMAT_SUBSCRIBER_ID) select p_subscriber_id,DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID,ID, IMPLEMENTATION_TYPE,INPUT_FORMAT_1,INPUT_FORMAT_1_SUBSCRIBER_ID, INPUT_FORMAT_2,INPUT_FORMAT_2_SUBSCRIBER_ID,INPUT_FORMAT_3, INPUT_FORMAT_3_SUBSCRIBER_ID,INPUT_FORMAT_4, INPUT_FORMAT_4_SUBSCRIBER_ID,INPUT_FORMAT_PACKAGE,NAME, OUTPUT_FORMAT,OUTPUT_FORMAT_PACKAGE,OUTPUT_FORMAT_SUBSCRIBER_ID from PORTAL.WWTYP_DYNAMIC_TYPE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- -- -- Warning: WWWCP_CLIPPING$ has no VPD policy -- -- insert into PORTAL.WWV_TEXT (SUBSCRIBER_ID,ID,SITEID,TEXT) select p_subscriber_id,ID,SITEID,TEXT from PORTAL.WWV_TEXT where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_MODULE_TYPES$ (SUBSCRIBER_ID,DEMO,DESCRIPTION,FUNCTION,GROUP_ID,HELP,ID,IDENT, IMAGE,NAME) select p_subscriber_id,DEMO,DESCRIPTION,FUNCTION,GROUP_ID,HELP,ID, IDENT,IMAGE,NAME from PORTAL.WWV_SYS_MODULE_TYPES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_OFFLINE_PROVIDER$ (SUBSCRIBER_ID,MAX_VERSION,MIN_VERSION,NAME) select p_subscriber_id,MAX_VERSION,MIN_VERSION,NAME from PORTAL.WWPRO_OFFLINE_PROVIDER$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_PROVIDERS$ (SUBSCRIBER_ID,ADAPTER_PROVIDER,ADAPTER_URL,COMMON_VERSION, CREATED_BY,CREATED_ON,DBTIER_PROXY_ID,DISPLAY_NAME_ID, ENABLE_DISTRIBUTION,ENCRYPTION_KEY,HTTP_APP_ID,HTTP_APP_TYPE, HTTP_URL,ID,IMPLEMENTATION_NAME,IMPLEMENTATION_OWNER, IMPLEMENTATION_STYLE,IS_DELETABLE,IS_OFFLINE,LAST_UPDATED_BY, LAST_UPDATED_ON,LOGIN_FREQUENCY,MAX_VERSION,MIDTIER_PROXY_ID, MIN_VERSION,NAME,NODE_ID,PROVIDER_GROUP_ID,PROVIDER_KEY, REQUIRE_PROXY,REQUIRE_SESSION_DATA,SAME_COOKIE_DOMAIN, SERVICE_ID,TIMEOUT,TIMEOUT_MSG_ID,USE_SESSION_BASED_PMR) select p_subscriber_id,ADAPTER_PROVIDER,ADAPTER_URL,COMMON_VERSION, CREATED_BY,CREATED_ON,DBTIER_PROXY_ID,DISPLAY_NAME_ID, ENABLE_DISTRIBUTION,ENCRYPTION_KEY,HTTP_APP_ID,HTTP_APP_TYPE, HTTP_URL,ID,IMPLEMENTATION_NAME,IMPLEMENTATION_OWNER, IMPLEMENTATION_STYLE,IS_DELETABLE,IS_OFFLINE,LAST_UPDATED_BY, LAST_UPDATED_ON,LOGIN_FREQUENCY,MAX_VERSION,MIDTIER_PROXY_ID, MIN_VERSION,NAME,NODE_ID,PROVIDER_GROUP_ID,PROVIDER_KEY, REQUIRE_PROXY,REQUIRE_SESSION_DATA,SAME_COOKIE_DOMAIN, SERVICE_ID,TIMEOUT,TIMEOUT_MSG_ID,USE_SESSION_BASED_PMR from PORTAL.WWPRO_PROVIDERS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRE_PATH$ (SUBSCRIBER_ID,ID,NAME,PARENT_ID) select p_subscriber_id,ID,NAME,PARENT_ID from PORTAL.WWPRE_PATH$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_PAGE$ (SUBSCRIBER_ID,ACTIVE,ALLOW_PAGE_ACL,ALLOW_PAGE_STYLE, ALPHABETICAL_SORT,BASE_TYPE,CACHE_EXPIRES,CACHE_MODE, CONTAINER_ID,CREATEDATE,CREATOR,CTXTXT,DAV_EXPOSURE,DAV_ID, DAV_LOCK_TOKEN,DEFAULT_ITEM_REGION_ID,DEFAULT_PORTLET_REGION_ID, DESCRIPTION,DISPLAYINPARENT,HAVEITEMSECURITY,ICON,ID,IMAGE, IMAGEFILE_ITEMTYPE,INHERIT_PRIV,INIT_JSPFILE,ISCURRENTVERSION, ISPUBLIC,IS_PORTLET,IS_READY,IS_TEMPLATE,ITEMVERSIONING, KEYWORDS,LANGUAGE,LEADER,MASTERID,NAME,PARENTID,PLSQL_EXECUTOR, PRODUCTION,PUBLISHDATE,QUOTA,REAL_NAME,REGFILE_ITEMTYPE, ROLLOVERIMAGE,SEQ,SETTINGSSETID,SETTINGSSETSITEID,SITECHARID, SITEID,SYSPRIV_NAME,TEMPLATE_ID,TEMPLATE_ISPUBLIC, TEMPLATE_SITEID,TITLE,TITLEIMAGE,TOPICID,TOPIC_SITEID,TYPE, TYPE_SITEID,UI_TEMPLATE,UPDATEDATE,UPDATOR,USE_PPC,VALUE, VERSION,ZIPFILE_ITEMTYPE) select p_subscriber_id,ACTIVE,ALLOW_PAGE_ACL,ALLOW_PAGE_STYLE, ALPHABETICAL_SORT,BASE_TYPE,CACHE_EXPIRES,CACHE_MODE, CONTAINER_ID,CREATEDATE,CREATOR,CTXTXT,DAV_EXPOSURE,DAV_ID, DAV_LOCK_TOKEN,DEFAULT_ITEM_REGION_ID,DEFAULT_PORTLET_REGION_ID, DESCRIPTION,DISPLAYINPARENT,HAVEITEMSECURITY,ICON,ID,IMAGE, IMAGEFILE_ITEMTYPE,INHERIT_PRIV,INIT_JSPFILE,ISCURRENTVERSION, ISPUBLIC,IS_PORTLET,IS_READY,IS_TEMPLATE,ITEMVERSIONING, KEYWORDS,LANGUAGE,LEADER,MASTERID,NAME,PARENTID,PLSQL_EXECUTOR, PRODUCTION,PUBLISHDATE,QUOTA,REAL_NAME,REGFILE_ITEMTYPE, ROLLOVERIMAGE,SEQ,SETTINGSSETID,SETTINGSSETSITEID,SITECHARID, SITEID,SYSPRIV_NAME,TEMPLATE_ID,TEMPLATE_ISPUBLIC, TEMPLATE_SITEID,TITLE,TITLEIMAGE,TOPICID,TOPIC_SITEID,TYPE, TYPE_SITEID,UI_TEMPLATE,UPDATEDATE,UPDATOR,USE_PPC,VALUE, VERSION,ZIPFILE_ITEMTYPE from PORTAL.WWPOB_PAGE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- -- -- Warning: WWCTX_SSO_SESSION$ has no VPD policy -- -- insert into PORTAL.WWAPP_APPLICATION$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,DEFAULT_MODULE_ID, EXPOSE_AS_PROVIDER,ID,LAST_MODIFIED_BY,LAST_MODIFIED_ON,NAME, OWNER,PROVIDER_ID,TITLE,VERSION) select p_subscriber_id,CREATED_BY,CREATED_ON,DEFAULT_MODULE_ID, EXPOSE_AS_PROVIDER,ID,LAST_MODIFIED_BY,LAST_MODIFIED_ON,NAME, OWNER,PROVIDER_ID,TITLE,VERSION from PORTAL.WWAPP_APPLICATION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_EVENT_SCOPE_TYPE$ (SUBSCRIBER_ID,DESCRIPTION_ID,ID,NAME) select p_subscriber_id,DESCRIPTION_ID,ID,NAME from PORTAL.WWA_EVENT_SCOPE_TYPE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_EVENT$ (SUBSCRIBER_ID,DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID, DISPLAY_NAME_ID,DISPLAY_NAME_SUBSCRIBER_ID,ID,NAME, PARENT_CTX_ID,PARENT_ID,PARENT_TYPE,SITE_ID) select p_subscriber_id,DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID, DISPLAY_NAME_ID,DISPLAY_NAME_SUBSCRIBER_ID,ID,NAME, PARENT_CTX_ID,PARENT_ID,PARENT_TYPE,SITE_ID from PORTAL.WWPOB_EVENT$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_APPROVAL$ (SUBSCRIBER_ID,ALL_OR_ANY,ID,PAGE_ID,PARALLEL_OR_SERIAL,SITE_ID, STEP_ID) select p_subscriber_id,ALL_OR_ANY,ID,PAGE_ID,PARALLEL_OR_SERIAL, SITE_ID,STEP_ID from PORTAL.WWSBR_APPROVAL$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTL_FAVORITE_GROUP$ (SUBSCRIBER_ID,CREATE_DATE,DESCRIPTION,FAVORITE_GROUP_ID,ID,NAME, USERROOT,USER_ID) select p_subscriber_id,CREATE_DATE,DESCRIPTION,FAVORITE_GROUP_ID,ID, NAME,USERROOT,USER_ID from PORTAL.WWPTL_FAVORITE_GROUP$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTL_CONTENT_LOGS$ (SUBSCRIBER_ID,CONTENT,DATE_LOGGED,ID,LOG_SEQ,LW_USER,PORTLET_ID, PROVIDER_ID,REQUEST_ARGS) select p_subscriber_id,CONTENT,DATE_LOGGED,ID,LOG_SEQ,LW_USER, PORTLET_ID,PROVIDER_ID,REQUEST_ARGS from PORTAL.WWPTL_CONTENT_LOGS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTH_OBJECT_TYPE$ (SUBSCRIBER_ID,CONTEXT_COLUMN,DOC_SECURITY_PROCEDURE,DOMAIN, ID_COLUMN,LANGUAGE_COLUMN,NAME_COLUMN,OBJECT_TABLE,OBJECT_TYPE, PARENT_ID_COLUMN,PATH_DECODE_FUNCTION,PATH_SECURITY_PROCEDURE, ROOT_EQUALS_CONTEXT,TABLE_OWNER) select p_subscriber_id,CONTEXT_COLUMN,DOC_SECURITY_PROCEDURE,DOMAIN, ID_COLUMN,LANGUAGE_COLUMN,NAME_COLUMN,OBJECT_TABLE,OBJECT_TYPE, PARENT_ID_COLUMN,PATH_DECODE_FUNCTION,PATH_SECURITY_PROCEDURE, ROOT_EQUALS_CONTEXT,TABLE_OWNER from PORTAL.WWPTH_OBJECT_TYPE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_PORTLET_METADATA$ (SUBSCRIBER_ID,ACCEPT_CONTENT_TYPE,API_VERSION,CACHE_LEVEL, CALL_GET_PORTLET,CALL_IS_RUNNABLE,CHECK_ACL,CONTENT_TYPE, CREATED_BY,CREATED_ON,HAS_SHOW_EDIT,HAS_SHOW_EDIT_DEFAULTS, HAS_SHOW_LINK_MODE,HAS_SHOW_PREVIEW,ID,IMPLEMENTATION_NAME, IMPLEMENTATION_OWNER,IMPLEMENTATION_STYLE,IS_ONLINE, LAST_UPDATED_BY,LAST_UPDATED_ON,MOBILE_ONLY,NAME, PASS_ALL_URL_PARAMS,PORTLET_ID,PREFERENCE_STORE_PATH, PRIV_FROM_PROVIDER,PROVIDER_ID,REWRITE_URLS, SHOW_BEHAVIOUR_STYLE,TIMEOUT,USE_SESSION_BASED_PMR) select p_subscriber_id,ACCEPT_CONTENT_TYPE,API_VERSION,CACHE_LEVEL, CALL_GET_PORTLET,CALL_IS_RUNNABLE,CHECK_ACL,CONTENT_TYPE, CREATED_BY,CREATED_ON,HAS_SHOW_EDIT,HAS_SHOW_EDIT_DEFAULTS, HAS_SHOW_LINK_MODE,HAS_SHOW_PREVIEW,ID,IMPLEMENTATION_NAME, IMPLEMENTATION_OWNER,IMPLEMENTATION_STYLE,IS_ONLINE, LAST_UPDATED_BY,LAST_UPDATED_ON,MOBILE_ONLY,NAME, PASS_ALL_URL_PARAMS,PORTLET_ID,PREFERENCE_STORE_PATH, PRIV_FROM_PROVIDER,PROVIDER_ID,REWRITE_URLS, SHOW_BEHAVIOUR_STYLE,TIMEOUT,USE_SESSION_BASED_PMR from PORTAL.WWPRO_PORTLET_METADATA$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_OFFLINE_PRO_PORTLET$ (SUBSCRIBER_ID,ACCEPT_CONTENT_TYPE,CALL_GET_PORTLET, CALL_IS_RUNNABLE,HAS_SHOW_EDIT,HAS_SHOW_EDIT_DEFAULTS, HAS_SHOW_LINK_MODE,HAS_SHOW_PREVIEW,PORTLET_ID,PROVIDER_NAME, TIMEOUT) select p_subscriber_id,ACCEPT_CONTENT_TYPE,CALL_GET_PORTLET, CALL_IS_RUNNABLE,HAS_SHOW_EDIT,HAS_SHOW_EDIT_DEFAULTS, HAS_SHOW_LINK_MODE,HAS_SHOW_PREVIEW,PORTLET_ID,PROVIDER_NAME, TIMEOUT from PORTAL.WWPRO_OFFLINE_PRO_PORTLET$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRE_NAME$ (SUBSCRIBER_ID,DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID,ID,NAME, PATH_ID,TYPE_NAME) select p_subscriber_id,DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID,ID, NAME,PATH_ID,TYPE_NAME from PORTAL.WWPRE_NAME$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_REGION$ (SUBSCRIBER_ID,ALIGNMENT,ALLOW_CUSTOMIZE,DISPLAY_BANNER, DISPLAY_HEADER,DISPLAY_SUBPAGE_DESC,DISPLAY_SUBPAGE_ICON, DISPLAY_SUBPAGE_ROLLOVER,GROUP_BY,HEIGHT,ICON_HEIGHT,ICON_WIDTH, ID,LAST_MAX_SEQ,NAME,NUMBER_OF_COLUMNS,NUMBER_OF_ROWS,PADDING, PAGE_ID,PARENT_ID,SEQ,SHOW_PORTLET_BORDER,SHOW_PORTLET_HEADER, SHOW_PORTLET_LINKS,SHOW_ROLLOVER_IMAGE,SITE_ID,SORT_BY, SORT_ORDER,SPACING,SPLIT_MODE,STYLE_ID,STYLE_SITE_ID, SUBPAGE_DEPTH,SUBPAGE_IMAGE,SUBPAGE_IMAGE_OPTION,TITLE_ID, TITLE_SUBSCRIBER_ID,TYPE,WIDTH) select p_subscriber_id,ALIGNMENT,ALLOW_CUSTOMIZE,DISPLAY_BANNER, DISPLAY_HEADER,DISPLAY_SUBPAGE_DESC,DISPLAY_SUBPAGE_ICON, DISPLAY_SUBPAGE_ROLLOVER,GROUP_BY,HEIGHT,ICON_HEIGHT,ICON_WIDTH, ID,LAST_MAX_SEQ,NAME,NUMBER_OF_COLUMNS,NUMBER_OF_ROWS,PADDING, PAGE_ID,PARENT_ID,SEQ,SHOW_PORTLET_BORDER,SHOW_PORTLET_HEADER, SHOW_PORTLET_LINKS,SHOW_ROLLOVER_IMAGE,SITE_ID,SORT_BY, SORT_ORDER,SPACING,SPLIT_MODE,STYLE_ID,STYLE_SITE_ID, SUBPAGE_DEPTH,SUBPAGE_IMAGE,SUBPAGE_IMAGE_OPTION,TITLE_ID, TITLE_SUBSCRIBER_ID,TYPE,WIDTH from PORTAL.WWPOB_REGION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_PARAM$ (SUBSCRIBER_ID,DEFAULT_STRING_VALUE,DEFAULT_VALUE_TYPE, DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID,DISPLAY_NAME_ID, DISPLAY_NAME_SUBSCRIBER_ID,DISPLAY_ORDER,ID,IS_CUSTOMIZABLE, NAME,PARENT_CTX_ID,PARENT_ID,PARENT_TYPE,SITE_ID,TYPE) select p_subscriber_id,DEFAULT_STRING_VALUE,DEFAULT_VALUE_TYPE, DESCRIPTION_ID,DESCRIPTION_SUBSCRIBER_ID,DISPLAY_NAME_ID, DISPLAY_NAME_SUBSCRIBER_ID,DISPLAY_ORDER,ID,IS_CUSTOMIZABLE, NAME,PARENT_CTX_ID,PARENT_ID,PARENT_TYPE,SITE_ID,TYPE from PORTAL.WWPOB_PARAM$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- -- -- Warning: WWWCP_CUSTOMIZATION_MAP$ has no VPD policy -- -- -- -- Warning: WWWCP_BROWSE_URL$ has no VPD policy -- -- for x in ( select SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,SCHEMA,SCRIPT, SCRIPT_LANGUAGE,SCRIPT_NAME,UPDATED_BY,UPDATED_ON from PORTAL.WWV_USR_JAVA_SCRIPTS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_USR_JAVA_SCRIPTS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,SCHEMA,SCRIPT, SCRIPT_LANGUAGE,SCRIPT_NAME,UPDATED_BY,UPDATED_ON) values (p_subscriber_id,x.CREATED_BY,x.CREATED_ON,x.ID,x.SCHEMA, x.SCRIPT,x.SCRIPT_LANGUAGE,x.SCRIPT_NAME,x.UPDATED_BY, x.UPDATED_ON); end loop; -- commit; -- insert into PORTAL.WWV_USR_IMAGE_TYPES$ (SUBSCRIBER_ID,ID,IMAGE_TYPE) select p_subscriber_id,ID,IMAGE_TYPE from PORTAL.WWV_USR_IMAGE_TYPES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_USR_CAT_LOV$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,DEFAULT_DISPLAY_TYPE,LOV_ID, LOV_NAME,LOV_TYPE,NULL_TEXT,NULL_VALUE,OWNER,SHOW_NULL, UPDATED_BY,UPDATED_ON) select p_subscriber_id,CREATED_BY,CREATED_ON,DEFAULT_DISPLAY_TYPE, LOV_ID,LOV_NAME,LOV_TYPE,NULL_TEXT,NULL_VALUE,OWNER,SHOW_NULL, UPDATED_BY,UPDATED_ON from PORTAL.WWV_USR_CAT_LOV$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_TOPICS (SUBSCRIBER_ID,ACTIVE,CTXTXT,DESCRIPTION,FRONTPAGE,ICON,ID,IMAGE, ISVISUAL,IS_PORTLET,LANGUAGE,LIFETIMEHITS,NAME,OWNER,PAGE_ID, PARENTID,ROLLOVERIMAGE,SITEID,TITLE,TITLEIMAGE,UPDATEDATE) select p_subscriber_id,ACTIVE,CTXTXT,DESCRIPTION,FRONTPAGE,ICON,ID, IMAGE,ISVISUAL,IS_PORTLET,LANGUAGE,LIFETIMEHITS,NAME,OWNER, PAGE_ID,PARENTID,ROLLOVERIMAGE,SITEID,TITLE,TITLEIMAGE, UPDATEDATE from PORTAL.WWV_TOPICS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_THINGSUBTYPE (SUBSCRIBER_ID,ADD_ITEM_HELP_URL,BASETYPEID,CREATOR,DESCRIPTION, EDIT_ITEM_HELP_URL,GUID,ID,IMAGE,ISBASETYPE,IS_HIDDEN,ITEMTYPE, LANGUAGE,NAME,SITEID,TITLE,TITLESUBTYPEATTRIBUTEID,UPDATEDATE) select p_subscriber_id,ADD_ITEM_HELP_URL,BASETYPEID,CREATOR, DESCRIPTION,EDIT_ITEM_HELP_URL,GUID,ID,IMAGE,ISBASETYPE, IS_HIDDEN,ITEMTYPE,LANGUAGE,NAME,SITEID,TITLE, TITLESUBTYPEATTRIBUTEID,UPDATEDATE from PORTAL.WWV_THINGSUBTYPE where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_THINGS (SUBSCRIBER_ID,ACTIVE,ADDPORTLET_LINK,ANIMATION,AUTHOR,CHECKABLE, CHECKEDOUT,CHECKER,CHECKOUTDATE,COMPRESSED,CONTEXT_URL,CORNERID, CORNERLINKID,CORNERLINKSITEID,CREATEDATE,CREATOR,CTXTXT, DEADCOUNT,DESCRIPTION,EXPIREDATE,EXPIREMODE,EXPIRENUMBER, EXPRESSION,FILENAME,FULLSCREEN,GUID,ID,IMAGE,IMAGE_ALIGN, IMAGE_OWNER,INPLACE,ISCURRENTVERSION,ITEMTYPE,KEYWORDS,LANGUAGE, LIFETIMEHITS,MASTERTHINGID,NAME,NEWLINE,PARENTID,PLSQL_EXECUTOR, PORTLET_INST_GUID,PUBLISHDATE,REFMASTERTHINGID,REGIONID, ROLLOVERIMAGE,SECURITY,SITEID,SOURCE,STARTDATE,SUBTYPE, SUBTYPESITEID,TEXTID,TITLE,TITLE_LINK,TOPICID,TOPICSITEID,TYPE, UPDATEDATE,UPDATOR,URL,VALUE,VALUE2,VALUE2_DATE,VALUE2_NUMBER, VALUE3,VALUE3_DATE,VALUE3_NUMBER,VALUE4,VALUE4_NUMBER,VALUE5, VALUE5_NUMBER,VALUE_DATE,VALUE_NUMBER,VERSION,VIDEO,VIDEOEND, VIDEOSTART) select p_subscriber_id,ACTIVE,ADDPORTLET_LINK,ANIMATION,AUTHOR, CHECKABLE,CHECKEDOUT,CHECKER,CHECKOUTDATE,COMPRESSED, CONTEXT_URL,CORNERID,CORNERLINKID,CORNERLINKSITEID,CREATEDATE, CREATOR,CTXTXT,DEADCOUNT,DESCRIPTION,EXPIREDATE,EXPIREMODE, EXPIRENUMBER,EXPRESSION,FILENAME,FULLSCREEN,GUID,ID,IMAGE, IMAGE_ALIGN,IMAGE_OWNER,INPLACE,ISCURRENTVERSION,ITEMTYPE, KEYWORDS,LANGUAGE,LIFETIMEHITS,MASTERTHINGID,NAME,NEWLINE, PARENTID,PLSQL_EXECUTOR,PORTLET_INST_GUID,PUBLISHDATE, REFMASTERTHINGID,REGIONID,ROLLOVERIMAGE,SECURITY,SITEID,SOURCE, STARTDATE,SUBTYPE,SUBTYPESITEID,TEXTID,TITLE,TITLE_LINK,TOPICID, TOPICSITEID,TYPE,UPDATEDATE,UPDATOR,URL,VALUE,VALUE2, VALUE2_DATE,VALUE2_NUMBER,VALUE3,VALUE3_DATE,VALUE3_NUMBER, VALUE4,VALUE4_NUMBER,VALUE5,VALUE5_NUMBER,VALUE_DATE, VALUE_NUMBER,VERSION,VIDEO,VIDEOEND,VIDEOSTART from PORTAL.WWV_THINGS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_IMAGE_TYPES$ (SUBSCRIBER_ID,ID,IMAGE_TYPE) select p_subscriber_id,ID,IMAGE_TYPE from PORTAL.WWV_SYS_IMAGE_TYPES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_CAT_LOV$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,DEFAULT_DISPLAY_TYPE,LOV_ID, LOV_NAME,LOV_TYPE,NULL_TEXT,NULL_VALUE,OWNER,SHOW_NULL, UPDATED_BY,UPDATED_ON) select p_subscriber_id,CREATED_BY,CREATED_ON,DEFAULT_DISPLAY_TYPE, LOV_ID,LOV_NAME,LOV_TYPE,NULL_TEXT,NULL_VALUE,OWNER,SHOW_NULL, UPDATED_BY,UPDATED_ON from PORTAL.WWV_SYS_CAT_LOV$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_BUILDER_DETAILS$ (SUBSCRIBER_ID,ARRAY,ARRAY_GROUP,ATTRIBUTE,COL_SPAN, DEFAULT_VALUE,DEF_ALLOWED,ID,IMPACT,INPUT_HEIGHT,INPUT_TYPE, INPUT_WIDTH,LONG_TYPE,LOVNAME,NAME,POST_FUNCTION,PRE_FUNCTION, PROMPT,PROMPT_ALIGN,REQUIRED,SECTION,SEQ,TYPE_ID,UPPERCASE) select p_subscriber_id,ARRAY,ARRAY_GROUP,ATTRIBUTE,COL_SPAN, DEFAULT_VALUE,DEF_ALLOWED,ID,IMPACT,INPUT_HEIGHT,INPUT_TYPE, INPUT_WIDTH,LONG_TYPE,LOVNAME,NAME,POST_FUNCTION,PRE_FUNCTION, PROMPT,PROMPT_ALIGN,REQUIRED,SECTION,SEQ,TYPE_ID,UPPERCASE from PORTAL.WWV_SYS_BUILDER_DETAILS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_APPLICATION_TEMPLATES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,TEMPLATE_NAME, TEMPLATE_SCHEMA,TEMPLATE_TYPE,UPDATED_BY,UPDATED_ON) select p_subscriber_id,CREATED_BY,CREATED_ON,ID,TEMPLATE_NAME, TEMPLATE_SCHEMA,TEMPLATE_TYPE,UPDATED_BY,UPDATED_ON from PORTAL.WWV_SYS_APPLICATION_TEMPLATES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_PREFERENCES$ (SUBSCRIBER_ID,COMPONENT,CREATED_BY,CREATED_ON,ID,NAME,TYPE, UPDATED_BY,UPDATED_ON) select p_subscriber_id,COMPONENT,CREATED_BY,CREATED_ON,ID,NAME,TYPE, UPDATED_BY,UPDATED_ON from PORTAL.WWV_PREFERENCES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_MODULES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,DESCRIPTION,ID,LOCKED_BY, LOCKED_ON,NAME,OWNER,PORTLET_ID,PRIV_FROM_APP,PROVIDER_ID, PUBLISH_TO_PORTAL,REQUIRED_ROLE,STATUS,STATUS_ID,TITLE,TYPE_ID, VERSION) select p_subscriber_id,CREATED_BY,CREATED_ON,DESCRIPTION,ID,LOCKED_BY, LOCKED_ON,NAME,OWNER,PORTLET_ID,PRIV_FROM_APP,PROVIDER_ID, PUBLISH_TO_PORTAL,REQUIRED_ROLE,STATUS,STATUS_ID,TITLE,TYPE_ID, VERSION from PORTAL.WWV_MODULES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_DATAPTLS$ (SUBSCRIBER_ID,WWV_DP_ID,WWV_DP_PRIV_FROM_DP) select p_subscriber_id,WWV_DP_ID,WWV_DP_PRIV_FROM_DP from PORTAL.WWV_DATAPTLS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,DATE_EXECUTED,EXECUTED_BY,EXPIRES,ID,IS_PUBLIC, JOB_ID,OUTPUT_SIZE,PROGRAM_NAME,RESUBMIT_URL,STMT from PORTAL.WWV_BATCH_SUBMISSIONS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_BATCH_SUBMISSIONS$ (SUBSCRIBER_ID,DATE_EXECUTED,EXECUTED_BY,EXPIRES,ID,IS_PUBLIC, JOB_ID,OUTPUT_SIZE,PROGRAM_NAME,RESUBMIT_URL,STMT) values (p_subscriber_id,x.DATE_EXECUTED,x.EXECUTED_BY,x.EXPIRES,x.ID, x.IS_PUBLIC,x.JOB_ID,x.OUTPUT_SIZE,x.PROGRAM_NAME, x.RESUBMIT_URL,x.STMT); end loop; -- commit; -- -- -- Warning: WWV_AVAILABILITY_TYPES$ has no VPD policy -- -- -- -- Warning: WWUTL_EXPORT_IMPORT$ has no VPD policy -- -- insert into PORTAL.WWTMP_USR_TEMPLATE$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,TEMPLATE_NAME, TEMPLATE_SCHEMA,TEMPLATE_TYPE,UPDATED_BY,UPDATED_ON) select p_subscriber_id,CREATED_BY,CREATED_ON,ID,TEMPLATE_NAME, TEMPLATE_SCHEMA,TEMPLATE_TYPE,UPDATED_BY,UPDATED_ON from PORTAL.WWTMP_USR_TEMPLATE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- -- -- Warning: WWSTO_SESSION$ has no VPD policy -- -- insert into PORTAL.WWSEC_PRIV_OBJECT_TYPE$ (SUBSCRIBER_ID,ID,NAME,OWNER,VALIDATION_PROC) select p_subscriber_id,ID,NAME,OWNER,VALIDATION_PROC from PORTAL.WWSEC_PRIV_OBJECT_TYPE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_PERSON$ (SUBSCRIBER_ID,COOKIE_ID,COOKIE_KEY,COOKIE_MASK_POST, COOKIE_MASK_PRE,CREATED_BY_DBUSER,CREATED_BY_USER,CREATED_ON, DATE_OF_BIRTH,DB_USER,DEFAULT_GROUP,DISPLAY, DISPLAY_PERSONAL_INFO,DN,DN_HASH,EMAIL,EMPNO,FAILED_ATTEMPTS, FAX,FIRST_NAME,GUID,HIREDATE,HOME_ADDR1,HOME_ADDR2,HOME_ADDR3, HOME_CITY,HOME_COUNTRY,HOME_PHONE,HOME_STATE,HOME_ZIP,ID,IMAGE, KNOWN_AS,LAST_INVALIDATION,LAST_LOGIN,LAST_NAME, LAST_PASSWD_CHANGE_TIME,LAST_PASSWD_RESET,MAIDEN_NAME,MANAGER, MIDDLE_NAME,MOBILE_PHONE,NOTIFICATION_PREFERENCE,OFFICE_ADDR1, OFFICE_ADDR2,OFFICE_ADDR3,OFFICE_CITY,OFFICE_COUNTRY, OFFICE_STATE,OFFICE_ZIP,ORGANIZATION,PAGER,PASSWD_HINT_ANSWER, PASSWD_HINT_QUESTION,PASSWORD,PASSWORD_ACTIVATION, PASSWORD_EXPIRATION,PORTAL_USER,SOURCE,SPENDING_LIMIT, SSO_ENABLED,SSO_USER_TYPE,TERMINATION_TIME,TITLE, UPDATED_BY_USER,USER_NAME,WORK_PHONE) select p_subscriber_id,COOKIE_ID,COOKIE_KEY,COOKIE_MASK_POST, COOKIE_MASK_PRE,CREATED_BY_DBUSER,CREATED_BY_USER,CREATED_ON, DATE_OF_BIRTH,DB_USER,DEFAULT_GROUP,DISPLAY, DISPLAY_PERSONAL_INFO,DN,DN_HASH,EMAIL,EMPNO,FAILED_ATTEMPTS, FAX,FIRST_NAME,GUID,HIREDATE,HOME_ADDR1,HOME_ADDR2,HOME_ADDR3, HOME_CITY,HOME_COUNTRY,HOME_PHONE,HOME_STATE,HOME_ZIP,ID,IMAGE, KNOWN_AS,LAST_INVALIDATION,LAST_LOGIN,LAST_NAME, LAST_PASSWD_CHANGE_TIME,LAST_PASSWD_RESET,MAIDEN_NAME,MANAGER, MIDDLE_NAME,MOBILE_PHONE,NOTIFICATION_PREFERENCE,OFFICE_ADDR1, OFFICE_ADDR2,OFFICE_ADDR3,OFFICE_CITY,OFFICE_COUNTRY, OFFICE_STATE,OFFICE_ZIP,ORGANIZATION,PAGER,PASSWD_HINT_ANSWER, PASSWD_HINT_QUESTION,PASSWORD,PASSWORD_ACTIVATION, PASSWORD_EXPIRATION,PORTAL_USER,SOURCE,SPENDING_LIMIT, SSO_ENABLED,SSO_USER_TYPE,TERMINATION_TIME,TITLE, UPDATED_BY_USER,USER_NAME,WORK_PHONE from PORTAL.WWSEC_PERSON$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_GROUP$ (SUBSCRIBER_ID,CHARID,DELETABLE,DESCRIPTION,DN,DN_HASH, GROUP_TYPE,GUID,HIDDEN_GROUP,HIDDEN_MEMBERS,HIERARCHY_NAME,ID, MAKE_OWNER,NAME,OWNER,PUBLISH,SITE_ID,SPECIAL) select p_subscriber_id,CHARID,DELETABLE,DESCRIPTION,DN,DN_HASH, GROUP_TYPE,GUID,HIDDEN_GROUP,HIDDEN_MEMBERS,HIERARCHY_NAME,ID, MAKE_OWNER,NAME,OWNER,PUBLISH,SITE_ID,SPECIAL from PORTAL.WWSEC_GROUP$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_THINGSUBTYPE_FUNCTION$ (SUBSCRIBER_ID,FUNCTIONCALL,FUNCTIONLABEL,FUNCTIONTYPE,ID,IMAGE, INPLACEDISPLAY,ISBASEPROCEDURE,ISHIDDEN,LANGUAGE,SITEID, SUBTYPE_ID,SUBTYPE_SITEID) select p_subscriber_id,FUNCTIONCALL,FUNCTIONLABEL,FUNCTIONTYPE,ID, IMAGE,INPLACEDISPLAY,ISBASEPROCEDURE,ISHIDDEN,LANGUAGE,SITEID, SUBTYPE_ID,SUBTYPE_SITEID from PORTAL.WWSBR_THINGSUBTYPE_FUNCTION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_FLOW_ELEM$ (SUBSCRIBER_ID,COMP_CTX_ID,COMP_ID,COMP_TYPE,FLOW_GROUP_ID,ID, SITE_ID) select p_subscriber_id,COMP_CTX_ID,COMP_ID,COMP_TYPE,FLOW_GROUP_ID,ID, SITE_ID from PORTAL.WWPOB_FLOW_ELEM$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWDOC_DOCUMENT$ (SUBSCRIBER_ID,BLOB_CONTENT,CONTENT_TYPE,CREATOR,DAD_CHARSET, DAV_ID,DAV_LOCK_TOKEN,DAV_OWNER,DOC_SIZE,EXPIRE_SECONDS, FILENAME,LANGUAGE,LAST_UPDATED,MIME_TYPE,NAME,PATHID, REAL_FILENAME,REFCOUNT,SECURITY_OBJECT_NAME, SECURITY_OBJECT_TYPE,SESSION_ID) select p_subscriber_id,BLOB_CONTENT,CONTENT_TYPE,CREATOR,DAD_CHARSET, DAV_ID,DAV_LOCK_TOKEN,DAV_OWNER,DOC_SIZE,EXPIRE_SECONDS, FILENAME,LANGUAGE,LAST_UPDATED,MIME_TYPE,NAME,PATHID, REAL_FILENAME,REFCOUNT,SECURITY_OBJECT_NAME, SECURITY_OBJECT_TYPE,SESSION_ID from PORTAL.WWDOC_DOCUMENT$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWDAV$ASL (SUBSCRIBER_ID,CONTENTLENGTH,CONTENTTYPE,CREATIONDATE,DOC_ID, ELEMENT_NAME,ETAG,EXTENSION,IS_LOCKNULL,LASTMODIFIED,LOCKCOUNT, PATHCOUNT,PATH_ID,PROPCOUNT) select p_subscriber_id,CONTENTLENGTH,CONTENTTYPE,CREATIONDATE,DOC_ID, ELEMENT_NAME,ETAG,EXTENSION,IS_LOCKNULL,LASTMODIFIED,LOCKCOUNT, PATHCOUNT,PATH_ID,PROPCOUNT from PORTAL.WWDAV$ASL where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_SESSIONS$ (SUBSCRIBER_ID,DATA,ID,MODULE_ID,SESSION_ID,SHADOW_DATA,VERSION) select p_subscriber_id,DATA,ID,MODULE_ID,SESSION_ID,SHADOW_DATA,VERSION from PORTAL.WWA_MODULE_SESSIONS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_ATTRIBUTES$ (SUBSCRIBER_ID,ATTRIBUTE_TYPE_ID,BLOCK_ID,DEFAULT_VALUE, DEFAULT_VALUE_TYPE,FORMAT_MASK,ID,NAME,VALIDATION_TEXT) select p_subscriber_id,ATTRIBUTE_TYPE_ID,BLOCK_ID,DEFAULT_VALUE, DEFAULT_VALUE_TYPE,FORMAT_MASK,ID,NAME,VALIDATION_TEXT from PORTAL.WWA_MODULE_ATTRIBUTES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_EVENT_TYPE$ (SUBSCRIBER_ID,DESCRIPTION_ID,ID,NAME) select p_subscriber_id,DESCRIPTION_ID,ID,NAME from PORTAL.WWA_EVENT_TYPE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_FORM$ (SUBSCRIBER_ID,ABOUT,BG_COLOR,BG_IMAGE,BORDER,FONT_COLOR, FONT_SIZE,FONT_TYPE,FOOTER,HEADER,HELP,ID,JS_CODE,JS_LIB, LAYOUT_BODY,LAYOUT_FOOTER,LAYOUT_HEADER,LAYOUT_TYPE, LOG_ACTIVITY,NAME,OWNER,PARENT_ID,PLSQL_AFTER,PLSQL_BEFORE, SHOW_TIMING,TEMPLATE,TITLE,VERSION) select p_subscriber_id,ABOUT,BG_COLOR,BG_IMAGE,BORDER,FONT_COLOR, FONT_SIZE,FONT_TYPE,FOOTER,HEADER,HELP,ID,JS_CODE,JS_LIB, LAYOUT_BODY,LAYOUT_FOOTER,LAYOUT_HEADER,LAYOUT_TYPE, LOG_ACTIVITY,NAME,OWNER,PARENT_ID,PLSQL_AFTER,PLSQL_BEFORE, SHOW_TIMING,TEMPLATE,TITLE,VERSION from PORTAL.WWA_FORM$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.CTX_TEMP_WWSBR_HELP$ (SUBSCRIBER_ID,CONID,SCORE,TEXTKEY) select p_subscriber_id,CONID,SCORE,TEXTKEY from PORTAL.CTX_TEMP_WWSBR_HELP$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.CTX_TEMP_WWV_CS_HELP (SUBSCRIBER_ID,CONID,SCORE,TEXTKEY) select p_subscriber_id,CONID,SCORE,TEXTKEY from PORTAL.CTX_TEMP_WWV_CS_HELP where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.CTX_TEMP_WWV_HELP (SUBSCRIBER_ID,CONID,SCORE,TEXTKEY) select p_subscriber_id,CONID,SCORE,TEXTKEY from PORTAL.CTX_TEMP_WWV_HELP where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.DUAL100 (SUBSCRIBER_ID,C) select p_subscriber_id,C from PORTAL.DUAL100 where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.EXAMPLE_RSS (SUBSCRIBER_ID,CACHE,CACHE_CREATED,CACHE_EXPIRY_MINUTES, DESCRIPTION,URL,XSL) select p_subscriber_id,CACHE,CACHE_CREATED,CACHE_EXPIRY_MINUTES, DESCRIPTION,URL,XSL from PORTAL.EXAMPLE_RSS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SUBSCRIBERS (SUBSCRIBER_ID,ADDRESS1,ADDRESS2,CITY,COMPANY_NAME,COUNTRY, EMAIL_ADDRESS,FAX,FIRST_NAME,ID,JOB_TITLE,LAST_NAME,MAILSTOP, PASSWORD,PHONE,PRIMARY_BUSINESS,RECEIVE_INFO,REG_DATE, REG_STATUS,SECRET_ANSWER,SECRET_QUESTION,SITE_DESC,SITE_LOGO, SITE_TITLE,SITE_URL,SPONSOR_CODE,SPONSOR_EMAIL,STATE,THEME, USER_NAME,ZIP) select p_subscriber_id,ADDRESS1,ADDRESS2,CITY,COMPANY_NAME,COUNTRY, EMAIL_ADDRESS,FAX,FIRST_NAME,ID,JOB_TITLE,LAST_NAME,MAILSTOP, PASSWORD,PHONE,PRIMARY_BUSINESS,RECEIVE_INFO,REG_DATE, REG_STATUS,SECRET_ANSWER,SECRET_QUESTION,SITE_DESC,SITE_LOGO, SITE_TITLE,SITE_URL,SPONSOR_CODE,SPONSOR_EMAIL,STATE,THEME, USER_NAME,ZIP from PORTAL.OPC_SUBSCRIBERS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SURVEY_ADMINISTRATIONS (SUBSCRIBER_ID,ADMINISTRATION,END_DATE,START_DATE,SURVEY_NAME) select p_subscriber_id,ADMINISTRATION,END_DATE,START_DATE,SURVEY_NAME from PORTAL.OPC_SURVEY_ADMINISTRATIONS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SURVEY_ANSWERS (SUBSCRIBER_ID,ANSWER,ANSWER_NUMBER,ANSWER_SEQ,CORRECT, QUESTION_NUMBER,SUB_TRIGGER,SURVEY_NAME) select p_subscriber_id,ANSWER,ANSWER_NUMBER,ANSWER_SEQ,CORRECT, QUESTION_NUMBER,SUB_TRIGGER,SURVEY_NAME from PORTAL.OPC_SURVEY_ANSWERS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SURVEY_HEADER (SUBSCRIBER_ID,ALLOW_EDIT,APP_CODE,APP_FOLDER,APP_NAME, CLOSING_MSG,CONTENT,CREATOR,FINISH_BUTTON,IDENT_COMPANY, IDENT_EMAIL,IDENT_EMPNO,IDENT_LOGIN,IDENT_NAME,MULTI_RESPONSE, PLACE_PORTLET,PORTLET_ID,PORTLET_PAGE,PORTLET_PAGE_ID, PORTLET_PAGE_SITEID,SHOW_CHART,SHOW_REPORT,SURVEY_NAME, SURVEY_TYPE,WELCOME_MSG,WELCOME_ONLY) select p_subscriber_id,ALLOW_EDIT,APP_CODE,APP_FOLDER,APP_NAME, CLOSING_MSG,CONTENT,CREATOR,FINISH_BUTTON,IDENT_COMPANY, IDENT_EMAIL,IDENT_EMPNO,IDENT_LOGIN,IDENT_NAME,MULTI_RESPONSE, PLACE_PORTLET,PORTLET_ID,PORTLET_PAGE,PORTLET_PAGE_ID, PORTLET_PAGE_SITEID,SHOW_CHART,SHOW_REPORT,SURVEY_NAME, SURVEY_TYPE,WELCOME_MSG,WELCOME_ONLY from PORTAL.OPC_SURVEY_HEADER where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SURVEY_QUESTIONS (SUBSCRIBER_ID,ALLOW_MULTIPLE,ANSWERS,DISPLAY_STYLE,IMAGE, OPTIONAL,OTHER_CATEGORY,QUESTION,QUESTION_NUMBER,QUESTION_SEQ, SUB_ID,SUB_TRIGGER,SURVEY_NAME,WEIGHT) select p_subscriber_id,ALLOW_MULTIPLE,ANSWERS,DISPLAY_STYLE,IMAGE, OPTIONAL,OTHER_CATEGORY,QUESTION,QUESTION_NUMBER,QUESTION_SEQ, SUB_ID,SUB_TRIGGER,SURVEY_NAME,WEIGHT from PORTAL.OPC_SURVEY_QUESTIONS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SURVEY_RESPONSES (SUBSCRIBER_ID,ADMINISTRATION,ANSWER_NUMBER,COMPANY,EMAIL,EMPNO, FIRST_NAME,LAST_NAME,LOGIN,MIDDLE_NAME,OTHER_TEXT, QUESTION_NUMBER,RESPONDENT,RESPONSE_DATE,SUB_ID,SURVEY_NAME) select p_subscriber_id,ADMINISTRATION,ANSWER_NUMBER,COMPANY,EMAIL, EMPNO,FIRST_NAME,LAST_NAME,LOGIN,MIDDLE_NAME,OTHER_TEXT, QUESTION_NUMBER,RESPONDENT,RESPONSE_DATE,SUB_ID,SURVEY_NAME from PORTAL.OPC_SURVEY_RESPONSES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SURVEY_SCORES (SUBSCRIBER_ID,ADMINISTRATION,NOTE,QUESTION_NUMBER,RESPONDENT, SCORE,SCORE_DATE,SUB_ID,SURVEY_NAME) select p_subscriber_id,ADMINISTRATION,NOTE,QUESTION_NUMBER,RESPONDENT, SCORE,SCORE_DATE,SUB_ID,SURVEY_NAME from PORTAL.OPC_SURVEY_SCORES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SURVEY_SUB (SUBSCRIBER_ID,SUB_ID,SUB_MESSAGE,SUB_NAME,SUB_ORDER,SURVEY_NAME) select p_subscriber_id,SUB_ID,SUB_MESSAGE,SUB_NAME,SUB_ORDER, SURVEY_NAME from PORTAL.OPC_SURVEY_SUB where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.OPC_SURVEY_TRIGGERS (SUBSCRIBER_ID,ANSWER_NUMBER,DONE,QUESTION_NUMBER,REFERENCE_NAME, REFERENCE_PATH,SUB_ID,SUB_TRIGGER,SURVEY_NAME) select p_subscriber_id,ANSWER_NUMBER,DONE,QUESTION_NUMBER, REFERENCE_NAME,REFERENCE_PATH,SUB_ID,SUB_TRIGGER,SURVEY_NAME from PORTAL.OPC_SURVEY_TRIGGERS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWAPP_APPLICATION_DETAIL$ (SUBSCRIBER_ID,APP_ID,APP_VERSION,ID,OBJECT_NAME,OBJECT_OWNER, OBJECT_TYPE) select p_subscriber_id,APP_ID,APP_VERSION,ID,OBJECT_NAME,OBJECT_OWNER, OBJECT_TYPE from PORTAL.WWAPP_APPLICATION_DETAIL$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_EVENT_SCOPE_MAPPING$ (SUBSCRIBER_ID,EVENT_SCOPE_TYPE_ID,EVENT_TYPE_ID,ID) select p_subscriber_id,EVENT_SCOPE_TYPE_ID,EVENT_TYPE_ID,ID from PORTAL.WWA_EVENT_SCOPE_MAPPING$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_FORM_ITEM$ (SUBSCRIBER_ID,ALIGN,COL_SPAN,ELEMENT_INDEX,FONT_COLOR,FONT_SIZE, FONT_TYPE,FORM_ID,HEIGHT,IMAGE,ITEM_SIZE,LABEL,LINK,LOV, MANDATORY,MASK,MAX_LENGTH,NAME,NEW_LINE,ONBLUR,ONCHANGE,ONCLICK, ONDBLCLICK,ONFOCUS,ONKEYDOWN,ONKEYPRESS,ONKEYUP,ONMOUSEDOWN, ONMOUSEMOVE,ONMOUSEOUT,ONMOUSEOVER,ONMOUSEUP,ONSELECT,ROW_SPAN, TYPE,UPDATABLE,URL,VALIDATE_ON_SUBMIT,VALIGN,VERSION,WIDTH) select p_subscriber_id,ALIGN,COL_SPAN,ELEMENT_INDEX,FONT_COLOR, FONT_SIZE,FONT_TYPE,FORM_ID,HEIGHT,IMAGE,ITEM_SIZE,LABEL,LINK, LOV,MANDATORY,MASK,MAX_LENGTH,NAME,NEW_LINE,ONBLUR,ONCHANGE, ONCLICK,ONDBLCLICK,ONFOCUS,ONKEYDOWN,ONKEYPRESS,ONKEYUP, ONMOUSEDOWN,ONMOUSEMOVE,ONMOUSEOUT,ONMOUSEOVER,ONMOUSEUP, ONSELECT,ROW_SPAN,TYPE,UPDATABLE,URL,VALIDATE_ON_SUBMIT,VALIGN, VERSION,WIDTH from PORTAL.WWA_FORM_ITEM$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_BINDINGS$ (SUBSCRIBER_ID,ID,MODULE_ATTR_ID,MODULE_BLOCK_ID,MODULE_ID, MODULE_VERSION,PORTLET_ID,PORTLET_ITEM_NAME,PORTLET_ITEM_TYPE, PORTLET_REFERENCE,PROVIDER_ID) select p_subscriber_id,ID,MODULE_ATTR_ID,MODULE_BLOCK_ID,MODULE_ID, MODULE_VERSION,PORTLET_ID,PORTLET_ITEM_NAME,PORTLET_ITEM_TYPE, PORTLET_REFERENCE,PROVIDER_ID from PORTAL.WWA_MODULE_BINDINGS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_CALL_STACK$ (SUBSCRIBER_ID,GID,MODULE_ID,SEQ,SESSION_ID,VERSION) select p_subscriber_id,GID,MODULE_ID,SEQ,SESSION_ID,VERSION from PORTAL.WWA_MODULE_CALL_STACK$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_EVENTS$ (SUBSCRIBER_ID,ACTION,ATTRIBUTE_ID,BEFORE_VALIDATION,BLOCK_ID, EVENT_TYPE_ID,EXECUTION_SEQ,ID,IMPLEMENTATION_NAME, IMPLEMENTATION_TYPE,MODULE_ID,NAME,OBJECT_NAME,VERSION) select p_subscriber_id,ACTION,ATTRIBUTE_ID,BEFORE_VALIDATION,BLOCK_ID, EVENT_TYPE_ID,EXECUTION_SEQ,ID,IMPLEMENTATION_NAME, IMPLEMENTATION_TYPE,MODULE_ID,NAME,OBJECT_NAME,VERSION from PORTAL.WWA_MODULE_EVENTS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_LOV_BINDINGS$ (SUBSCRIBER_ID,BIND_NAME,ID,MODULE_ATTR_ID,MODULE_BLOCK_ID, MODULE_ID,MODULE_VERSION,PORTLET_ID,PORTLET_ITEM_NAME, PORTLET_REFERENCE,PROVIDER_ID) select p_subscriber_id,BIND_NAME,ID,MODULE_ATTR_ID,MODULE_BLOCK_ID, MODULE_ID,MODULE_VERSION,PORTLET_ID,PORTLET_ITEM_NAME, PORTLET_REFERENCE,PROVIDER_ID from PORTAL.WWA_MODULE_LOV_BINDINGS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_SCRIPTS$ (SUBSCRIBER_ID,ID,MODULE_ID,SCRIPT_ID,VERSION) select p_subscriber_id,ID,MODULE_ID,SCRIPT_ID,VERSION from PORTAL.WWA_MODULE_SCRIPTS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWA_MODULE_SESSION_LOBS$ (SUBSCRIBER_ID,BLOB_DATA,CLOB_DATA,ID,MODULE_SESSION_ID) select p_subscriber_id,BLOB_DATA,CLOB_DATA,ID,MODULE_SESSION_ID from PORTAL.WWA_MODULE_SESSION_LOBS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWC_VERSION$ (SUBSCRIBER_ID,THE_USERID,VERSION) select p_subscriber_id,THE_USERID,VERSION from PORTAL.WWC_VERSION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWDAV$CONTAIN (SUBSCRIBER_ID,CREATED,DESCRIPTION,DETAILS,MAX_NAMESPACELEN, MAX_PATHLEN,MODIFIED,NAME,OWNER,STORAGE_CHOOSE_FUNCTION,VERSION) select p_subscriber_id,CREATED,DESCRIPTION,DETAILS,MAX_NAMESPACELEN, MAX_PATHLEN,MODIFIED,NAME,OWNER,STORAGE_CHOOSE_FUNCTION,VERSION from PORTAL.WWDAV$CONTAIN where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWDAV$EASL (SUBSCRIBER_ID,CONTENTLENGTH,CONTENTTYPE,DOC_ID,ETAG,IS_NEW, LASTMODIFIED,USERNAME) select p_subscriber_id,CONTENTLENGTH,CONTENTTYPE,DOC_ID,ETAG,IS_NEW, LASTMODIFIED,USERNAME from PORTAL.WWDAV$EASL where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWDAV$LOCKS (SUBSCRIBER_ID,DEPTH,DOC_ID,IS_LOCKNULL,LOCKTOKEN,LOCK_TYPE, OWNER,PARENT_DOC_ID,SCOPE,TIMEOUT,USERNAME) select p_subscriber_id,DEPTH,DOC_ID,IS_LOCKNULL,LOCKTOKEN,LOCK_TYPE, OWNER,PARENT_DOC_ID,SCOPE,TIMEOUT,USERNAME from PORTAL.WWDAV$LOCKS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWDAV$PATH (SUBSCRIBER_ID,DOC_ID,ELEMENT_TYPE,PARENTPATH,PATH) select p_subscriber_id,DOC_ID,ELEMENT_TYPE,PARENTPATH,PATH from PORTAL.WWDAV$PATH where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWDAV$PROP (SUBSCRIBER_ID,DEADORLIVE,DESCRIPTION,DOC_ID,LANGUAGE,NAMESPACE, PROPV_TYPE,READONLY,TAG,VAL_CLOB,VAL_DATE,VAL_NUMBER, VAL_VARCHAR2) select p_subscriber_id,DEADORLIVE,DESCRIPTION,DOC_ID,LANGUAGE, NAMESPACE,PROPV_TYPE,READONLY,TAG,VAL_CLOB,VAL_DATE,VAL_NUMBER, VAL_VARCHAR2 from PORTAL.WWDAV$PROP where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWDOC_MIME_TYPE_IMAGE$ (SUBSCRIBER_ID,FILE_EXTENSION,MIME_IMAGE,MIME_TYPE) select p_subscriber_id,FILE_EXTENSION,MIME_IMAGE,MIME_TYPE from PORTAL.WWDOC_MIME_TYPE_IMAGE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWEX_EXPORT_OBJECT$ (SUBSCRIBER_ID,EXP_FILENAME,NAME,OBJ_TYPE,OWNER,PATHID) select p_subscriber_id,EXP_FILENAME,NAME,OBJ_TYPE,OWNER,PATHID from PORTAL.WWEX_EXPORT_OBJECT$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWLOG_ACTIVITY_LOG1$ (SUBSCRIBER_ID,ACTION,DBMS_START_TIME,DOMAIN,ELAPSED_TIME, HTTP_REMOTE_ADDRESS,HTTP_USER_AGENT,ID,INFORMATION,KEY_1,KEY_2, KEY_3,KEY_4,KEY_5,LANGUAGE,NAME,ROW_COUNT,START_TIME,SUB_DOMAIN, URL,USERID) select p_subscriber_id,ACTION,DBMS_START_TIME,DOMAIN,ELAPSED_TIME, HTTP_REMOTE_ADDRESS,HTTP_USER_AGENT,ID,INFORMATION,KEY_1,KEY_2, KEY_3,KEY_4,KEY_5,LANGUAGE,NAME,ROW_COUNT,START_TIME,SUB_DOMAIN, URL,USERID from PORTAL.WWLOG_ACTIVITY_LOG1$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWLOG_ACTIVITY_LOG2$ (SUBSCRIBER_ID,ACTION,DBMS_START_TIME,DOMAIN,ELAPSED_TIME, HTTP_REMOTE_ADDRESS,HTTP_USER_AGENT,ID,INFORMATION,KEY_1,KEY_2, KEY_3,KEY_4,KEY_5,LANGUAGE,NAME,ROW_COUNT,START_TIME,SUB_DOMAIN, URL,USERID) select p_subscriber_id,ACTION,DBMS_START_TIME,DOMAIN,ELAPSED_TIME, HTTP_REMOTE_ADDRESS,HTTP_USER_AGENT,ID,INFORMATION,KEY_1,KEY_2, KEY_3,KEY_4,KEY_5,LANGUAGE,NAME,ROW_COUNT,START_TIME,SUB_DOMAIN, URL,USERID from PORTAL.WWLOG_ACTIVITY_LOG2$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWLOG_EVENT$ (SUBSCRIBER_ID,ACTION,DOMAIN,ID,SUB_DOMAIN) select p_subscriber_id,ACTION,DOMAIN,ID,SUB_DOMAIN from PORTAL.WWLOG_EVENT$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWLOG_REGISTRY$ (SUBSCRIBER_ID,ACTION,DOMAIN,HTTP_USER_AGENT,ID,LANGUAGE,NAME, SUB_DOMAIN,USERID) select p_subscriber_id,ACTION,DOMAIN,HTTP_USER_AGENT,ID,LANGUAGE,NAME, SUB_DOMAIN,USERID from PORTAL.WWLOG_REGISTRY$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWNLS_LANGUAGE_TERRITORY$ (SUBSCRIBER_ID,ABBREVIATION,ACTIVE_IMAGE,INACTIVE_IMAGE,LANGUAGE, TERRITORY) select p_subscriber_id,ABBREVIATION,ACTIVE_IMAGE,INACTIVE_IMAGE, LANGUAGE,TERRITORY from PORTAL.WWNLS_LANGUAGE_TERRITORY$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWNLS_SYS_LANGUAGE$ (SUBSCRIBER_ID,AVAILABLE,DATABASEABBREVIATION,HTTPABBREVIATION, ID,INSTALLED,TITLE) select p_subscriber_id,AVAILABLE,DATABASEABBREVIATION,HTTPABBREVIATION, ID,INSTALLED,TITLE from PORTAL.WWNLS_SYS_LANGUAGE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_EVENT_MAP$ (SUBSCRIBER_ID,FROM_CTX_ID,FROM_EVENT_ID,FROM_ID,FROM_TYPE,ID, SITE_ID,TO_EVENT_ID) select p_subscriber_id,FROM_CTX_ID,FROM_EVENT_ID,FROM_ID,FROM_TYPE,ID, SITE_ID,TO_EVENT_ID from PORTAL.WWPOB_EVENT_MAP$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_FLOW_LINK$ (SUBSCRIBER_ID,FLOW_GROUP_ID,FROM_ELEM_ID,FROM_EVENT_ID,ID, SITE_ID,TO_ELEM_ID,TYPE) select p_subscriber_id,FLOW_GROUP_ID,FROM_ELEM_ID,FROM_EVENT_ID,ID, SITE_ID,TO_ELEM_ID,TYPE from PORTAL.WWPOB_FLOW_LINK$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_ITEM$ (SUBSCRIBER_ID,AUTHOR_SEQ,CATEGORY_SEQ,CONTAINER_ID, CREATEDATE_SEQ,INCLUDE,IS_REPLICATION,ITEMTYPE_SEQ, MASTER_THING_ID,PAGE_ID,PAGE_SITE_ID,PORTLET_STATE,PORTLET_TYPE, REGION_ID,SEQ,SHOW_INLINE,SITE_ID,USER_ID) select p_subscriber_id,AUTHOR_SEQ,CATEGORY_SEQ,CONTAINER_ID, CREATEDATE_SEQ,INCLUDE,IS_REPLICATION,ITEMTYPE_SEQ, MASTER_THING_ID,PAGE_ID,PAGE_SITE_ID,PORTLET_STATE,PORTLET_TYPE, REGION_ID,SEQ,SHOW_INLINE,SITE_ID,USER_ID from PORTAL.WWPOB_ITEM$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_OBJ_REF$ (SUBSCRIBER_ID,NAME,OBJ_GUID,OBJ_REF_GUID,OBJ_TYPE,SITE_ID) select p_subscriber_id,NAME,OBJ_GUID,OBJ_REF_GUID,OBJ_TYPE,SITE_ID from PORTAL.WWPOB_OBJ_REF$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_PAGEGROUP_SETTINGS$ (SUBSCRIBER_ID,NAME,SITEID,TYPE,VALUE,VALUETYPE) select p_subscriber_id,NAME,SITEID,TYPE,VALUE,VALUETYPE from PORTAL.WWPOB_PAGEGROUP_SETTINGS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_PAGE_CUSTOMIZATION$ (SUBSCRIBER_ID,HAS_CONTENT_CUST,LAST_MODIFIED_ON,PAGE_ID,SITEID, USER_ID) select p_subscriber_id,HAS_CONTENT_CUST,LAST_MODIFIED_ON,PAGE_ID, SITEID,USER_ID from PORTAL.WWPOB_PAGE_CUSTOMIZATION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_PARAM_CUST$ (SUBSCRIBER_ID,ID,PARAM_ID,PARENT_CTX_ID,PARENT_ID,STRING_VALUE, USER_ID) select p_subscriber_id,ID,PARAM_ID,PARENT_CTX_ID,PARENT_ID, STRING_VALUE,USER_ID from PORTAL.WWPOB_PARAM_CUST$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_PARAM_MAP$ (SUBSCRIBER_ID,FROM_PARAM_ID,FROM_STRING_VALUE,FROM_TYPE,ID, PARENT_CTX_ID,PARENT_ID,PARENT_TYPE,SITE_ID,TO_PARAM_ID) select p_subscriber_id,FROM_PARAM_ID,FROM_STRING_VALUE,FROM_TYPE,ID, PARENT_CTX_ID,PARENT_ID,PARENT_TYPE,SITE_ID,TO_PARAM_ID from PORTAL.WWPOB_PARAM_MAP$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_PORTLET_INST$ (SUBSCRIBER_ID,CHECK_ACL,CONTENT_TYPE,IS_SHARED, OLD_PORTLET_INST_ID,PORTLET_ID,PORTLET_INST_GUID,PROVIDER_ID, REF_PATH,SITE_ID) select p_subscriber_id,CHECK_ACL,CONTENT_TYPE,IS_SHARED, OLD_PORTLET_INST_ID,PORTLET_ID,PORTLET_INST_GUID,PROVIDER_ID, REF_PATH,SITE_ID from PORTAL.WWPOB_PORTLET_INST$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_REGION_ATTRIBUTE$ (SUBSCRIBER_ID,ATTRIBUTE_ID,ATTRIBUTE_SITE_ID,REGION_ID,SEQ) select p_subscriber_id,ATTRIBUTE_ID,ATTRIBUTE_SITE_ID,REGION_ID,SEQ from PORTAL.WWPOB_REGION_ATTRIBUTE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPOB_STYLE_INST$ (SUBSCRIBER_ID,PAGE_ID,SETTINGSSETID,SETTINGSSETSITEID,SITE_ID, USER_ID) select p_subscriber_id,PAGE_ID,SETTINGSSETID,SETTINGSSETSITEID,SITE_ID, USER_ID from PORTAL.WWPOB_STYLE_INST$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRE_VALUE$ (SUBSCRIBER_ID,DATE_VALUE,LEVEL_ID,LEVEL_TYPE,NAME_ID, NUMBER_VALUE,VARCHAR2_VALUE) select p_subscriber_id,DATE_VALUE,LEVEL_ID,LEVEL_TYPE,NAME_ID, NUMBER_VALUE,VARCHAR2_VALUE from PORTAL.WWPRE_VALUE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_ADAPTER_KEY$ (SUBSCRIBER_ID,ADAPTER_URL,ID,OPERATION,SHARED_KEY) select p_subscriber_id,ADAPTER_URL,ID,OPERATION,SHARED_KEY from PORTAL.WWPRO_ADAPTER_KEY$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_OFFLINE_PRO_PORTLET_NLS$ (SUBSCRIBER_ID,DEFAULT_LANG,DESCRIPTION,LANGUAGE,NAME,PORTLET_ID, PROVIDER_NAME,TIMEOUT_MSG,TITLE) select p_subscriber_id,DEFAULT_LANG,DESCRIPTION,LANGUAGE,NAME, PORTLET_ID,PROVIDER_NAME,TIMEOUT_MSG,TITLE from PORTAL.WWPRO_OFFLINE_PRO_PORTLET_NLS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_PORTLET_METADATA_NLS$ (SUBSCRIBER_ID,BASE_TRANSLATION_ID,DESCRIPTION,HELP_URL,ID, IMAGE_URL,LANGUAGE,SHORT_TITLE,THUMBNAIL_IMAGE_URL,TIMEOUT_MSG, TITLE,WWPRO_PORTLET_METADATA_ID) select p_subscriber_id,BASE_TRANSLATION_ID,DESCRIPTION,HELP_URL,ID, IMAGE_URL,LANGUAGE,SHORT_TITLE,THUMBNAIL_IMAGE_URL,TIMEOUT_MSG, TITLE,WWPRO_PORTLET_METADATA_ID from PORTAL.WWPRO_PORTLET_METADATA_NLS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_PORTLET_METADATA_USER$ (SUBSCRIBER_ID,ID,PORTLET_ID,PROVIDER_ID,SESSION_ID) select p_subscriber_id,ID,PORTLET_ID,PROVIDER_ID,SESSION_ID from PORTAL.WWPRO_PORTLET_METADATA_USER$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPRO_PROVIDER_GROUP$ (SUBSCRIBER_ID,DISPLAY_NAME_ID,ID,LAST_MODIFIED,LOCAL_NAME, LOCATION,NAME) select p_subscriber_id,DISPLAY_NAME_ID,ID,LAST_MODIFIED,LOCAL_NAME, LOCATION,NAME from PORTAL.WWPRO_PROVIDER_GROUP$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTH_DOMAIN$ (SUBSCRIBER_ID,CONTEXT_ID_COLUMN,CONTEXT_NAME_COLUMN, CONTEXT_TABLE,DOMAIN,LANGUAGE_CONTEXT_FUNCTION, LANGUAGE_CONTEXT_PARAMETER) select p_subscriber_id,CONTEXT_ID_COLUMN,CONTEXT_NAME_COLUMN, CONTEXT_TABLE,DOMAIN,LANGUAGE_CONTEXT_FUNCTION, LANGUAGE_CONTEXT_PARAMETER from PORTAL.WWPTH_DOMAIN$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTH_PATH_ELEMENT$ (SUBSCRIBER_ID,DOMAIN,ID,LANGUAGE,OBJECT_CONTEXT_ID,OBJECT_ID, OBJECT_TYPE,PARENT_ID) select p_subscriber_id,DOMAIN,ID,LANGUAGE,OBJECT_CONTEXT_ID,OBJECT_ID, OBJECT_TYPE,PARENT_ID from PORTAL.WWPTH_PATH_ELEMENT$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTL_CONTENT_LOG_HEADERS$ (SUBSCRIBER_ID,CONTENT_LOG_ID,HEADER_NAME,HEADER_VALUE,ID) select p_subscriber_id,CONTENT_LOG_ID,HEADER_NAME,HEADER_VALUE,ID from PORTAL.WWPTL_CONTENT_LOG_HEADERS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTL_FAVORITE$ (SUBSCRIBER_ID,CREATE_DATE,DESCRIPTION,FAVORITE_GROUP_ID,ID,NAME, URL,USER_ID) select p_subscriber_id,CREATE_DATE,DESCRIPTION,FAVORITE_GROUP_ID,ID, NAME,URL,USER_ID from PORTAL.WWPTL_FAVORITE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTL_OTHER_SERVICES_LINK$ (SUBSCRIBER_ID,CREATE_DATE,DISPLAY_ORDER,ID,NAME,NLS_DESCRIPTION, NLS_TITLE,PASS_PAGE,URL) select p_subscriber_id,CREATE_DATE,DISPLAY_ORDER,ID,NAME, NLS_DESCRIPTION,NLS_TITLE,PASS_PAGE,URL from PORTAL.WWPTL_OTHER_SERVICES_LINK$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWPTL_RECENTOBJECT$ (SUBSCRIBER_ID,CREATE_DATE,ID,MODIFIED_DATE,NAME,TYPE,URL,USER_ID) select p_subscriber_id,CREATE_DATE,ID,MODIFIED_DATE,NAME,TYPE,URL, USER_ID from PORTAL.WWPTL_RECENTOBJECT$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_APPROVER$ (SUBSCRIBER_ID,APPROVER_ID,APPROVER_TYPE,ID,STEP_ID) select p_subscriber_id,APPROVER_ID,APPROVER_TYPE,ID,STEP_ID from PORTAL.WWSBR_APPROVER$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_ATTRIBUTE$ (SUBSCRIBER_ID,BASE_ATTRIBUTE,CREATOR,DATA_TYPE,DISPLAY_TYPE, FOR_ENTRY_AND_UPDATE,FOR_FUNCTIONS,FOR_PAGE_USE, FOR_REGION_DISPLAY,FOR_SEARCH_CRITERIA,FOR_SEARCH_DISPLAY,GUID, HAS_COLORS,ID,LANGUAGE,LENGTH,LOV,MULTI_SELECT_ATTRIBUTE,NAME, PLSQL_EXECUTOR,SITEID,TITLE,TRANSLATABLE,UPDATEDATE) select p_subscriber_id,BASE_ATTRIBUTE,CREATOR,DATA_TYPE,DISPLAY_TYPE, FOR_ENTRY_AND_UPDATE,FOR_FUNCTIONS,FOR_PAGE_USE, FOR_REGION_DISPLAY,FOR_SEARCH_CRITERIA,FOR_SEARCH_DISPLAY,GUID, HAS_COLORS,ID,LANGUAGE,LENGTH,LOV,MULTI_SELECT_ATTRIBUTE,NAME, PLSQL_EXECUTOR,SITEID,TITLE,TRANSLATABLE,UPDATEDATE from PORTAL.WWSBR_ATTRIBUTE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_ATTRIBUTE_DISPLAY$ (SUBSCRIBER_ID,ATTRIBUTE_ID,ATTRIBUTE_SITEID,DISPLAY_SEQUENCE, MESSAGE_DISPLAY_TYPE,MESSAGE_ID,THINGSUBTYPE_ID, THINGSUBTYPE_SITEID,WIZARD_TYPE) select p_subscriber_id,ATTRIBUTE_ID,ATTRIBUTE_SITEID,DISPLAY_SEQUENCE, MESSAGE_DISPLAY_TYPE,MESSAGE_ID,THINGSUBTYPE_ID, THINGSUBTYPE_SITEID,WIZARD_TYPE from PORTAL.WWSBR_ATTRIBUTE_DISPLAY$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_EXPIRY$ (SUBSCRIBER_ID,ID,NOTIFY_TIME,OBJECT_CONTEXT_ID,OBJECT_ID, RECIPIENT_ID,RECIPIENT_TYPE) select p_subscriber_id,ID,NOTIFY_TIME,OBJECT_CONTEXT_ID,OBJECT_ID, RECIPIENT_ID,RECIPIENT_TYPE from PORTAL.WWSBR_EXPIRY$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_FOLDERFUNC_ATTRIBUTE$ (SUBSCRIBER_ID,FOLDERSUBTYPE_ATTRIBUTEID,FOLDERSUBTYPE_ATTSITEID, FOLDERSUBTYPE_FUNCSITEID,FOLDERSUBTYPE_FUNCTIONID,ID,LANGUAGE, PARAMETER_NAME,SITEID) select p_subscriber_id,FOLDERSUBTYPE_ATTRIBUTEID, FOLDERSUBTYPE_ATTSITEID,FOLDERSUBTYPE_FUNCSITEID, FOLDERSUBTYPE_FUNCTIONID,ID,LANGUAGE,PARAMETER_NAME,SITEID from PORTAL.WWSBR_FOLDERFUNC_ATTRIBUTE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_FOLDER_ATTRIBUTE$ (SUBSCRIBER_ID,ATTRIBUTEID,ATTRIBUTE_SITEID,CORNERID,DATEVALUE, ID,LANGUAGE,NUMBERVALUE,SITEID,SUBTYPEATTRIBUTEID,VALUE, VALUETYPE) select p_subscriber_id,ATTRIBUTEID,ATTRIBUTE_SITEID,CORNERID,DATEVALUE, ID,LANGUAGE,NUMBERVALUE,SITEID,SUBTYPEATTRIBUTEID,VALUE, VALUETYPE from PORTAL.WWSBR_FOLDER_ATTRIBUTE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_FOLDER_PERSPECTIVES$ (SUBSCRIBER_ID,FOLDERID,PERSPECTIVEID,PERSPECTIVE_SITEID,SITEID) select p_subscriber_id,FOLDERID,PERSPECTIVEID,PERSPECTIVE_SITEID,SITEID from PORTAL.WWSBR_FOLDER_PERSPECTIVES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_FOLDER_SUBTYPE$ (SUBSCRIBER_ID,BASETYPEID,CREATOR,DESCRIPTION,GUID,ID,IMAGE, ISBASETYPE,IS_HIDDEN,LANGUAGE,NAME,SITEID,TITLE,UPDATEDATE) select p_subscriber_id,BASETYPEID,CREATOR,DESCRIPTION,GUID,ID,IMAGE, ISBASETYPE,IS_HIDDEN,LANGUAGE,NAME,SITEID,TITLE,UPDATEDATE from PORTAL.WWSBR_FOLDER_SUBTYPE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_FOLDER_SUBTYPEATTRIBUTE$ (SUBSCRIBER_ID,ATTRIBUTEID,ATTRIBUTE_SITEID,DEFAULTVALUE, FOLDERSUBTYPEID,FOLDERSUBTYPE_SITEID,ID,LANGUAGE,REQUIRED,SEQ, SITEID) select p_subscriber_id,ATTRIBUTEID,ATTRIBUTE_SITEID,DEFAULTVALUE, FOLDERSUBTYPEID,FOLDERSUBTYPE_SITEID,ID,LANGUAGE,REQUIRED,SEQ, SITEID from PORTAL.WWSBR_FOLDER_SUBTYPEATTRIBUTE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_FOLDER_SUBTYPE_FUNCTION$ (SUBSCRIBER_ID,FUNCTIONCALL,FUNCTIONLABEL,FUNCTIONTYPE,ID,IMAGE, INPLACEDISPLAY,LANGUAGE,SITEID,SUBTYPE_ID,SUBTYPE_SITEID) select p_subscriber_id,FUNCTIONCALL,FUNCTIONLABEL,FUNCTIONTYPE,ID, IMAGE,INPLACEDISPLAY,LANGUAGE,SITEID,SUBTYPE_ID,SUBTYPE_SITEID from PORTAL.WWSBR_FOLDER_SUBTYPE_FUNCTION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,FILENAME,ID,LANGUAGE,PARENTID,REQUIREDROLE,TEXT, TITLE,TOPNODE from PORTAL.WWSBR_HELP$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWSBR_HELP$ (SUBSCRIBER_ID,FILENAME,ID,LANGUAGE,PARENTID,REQUIREDROLE,TEXT, TITLE,TOPNODE) values (p_subscriber_id,x.FILENAME,x.ID,x.LANGUAGE,x.PARENTID, x.REQUIREDROLE,x.TEXT,x.TITLE,x.TOPNODE); end loop; -- commit; -- for x in ( select SUBSCRIBER_ID,FILENAME,ID,LANGUAGE,REQUIREDROLE,TEXT,TITLE from PORTAL.WWSBR_HELP_CONTEXT_SENSITIVE$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWSBR_HELP_CONTEXT_SENSITIVE$ (SUBSCRIBER_ID,FILENAME,ID,LANGUAGE,REQUIREDROLE,TEXT,TITLE) values (p_subscriber_id,x.FILENAME,x.ID,x.LANGUAGE,x.REQUIREDROLE, x.TEXT,x.TITLE); end loop; -- commit; -- insert into PORTAL.WWSBR_HELP_INDEX$ (SUBSCRIBER_ID,FILENAME,ID,PARENTID,TITLE) select p_subscriber_id,FILENAME,ID,PARENTID,TITLE from PORTAL.WWSBR_HELP_INDEX$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,DOCUMENT,ID from PORTAL.WWSBR_HELP_MUTAB$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWSBR_HELP_MUTAB$ (SUBSCRIBER_ID,DOCUMENT,ID) values (p_subscriber_id,x.DOCUMENT,x.ID); end loop; -- commit; -- insert into PORTAL.WWSBR_HELP_RELATED_TOPICS$ (SUBSCRIBER_ID,FILENAME,ID,PARENTID,TITLE) select p_subscriber_id,FILENAME,ID,PARENTID,TITLE from PORTAL.WWSBR_HELP_RELATED_TOPICS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_ITEM_APPROVAL$ (SUBSCRIBER_ID,APPROVAL_DATE,APPROVAL_ID,APPROVAL_INSTANCE_ID, APPROVER_COMMENT,APPROVER_ID,CURRENT_APPROVER_ID, CURRENT_APPROVER_TYPE,ID,ITEM_ID,LANGUAGE,PAGE_ID,SITE_ID, STATUS,STEP_ID,SUBMITTER,VALUE1) select p_subscriber_id,APPROVAL_DATE,APPROVAL_ID,APPROVAL_INSTANCE_ID, APPROVER_COMMENT,APPROVER_ID,CURRENT_APPROVER_ID, CURRENT_APPROVER_TYPE,ID,ITEM_ID,LANGUAGE,PAGE_ID,SITE_ID, STATUS,STEP_ID,SUBMITTER,VALUE1 from PORTAL.WWSBR_ITEM_APPROVAL$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_PORTLET$ (SUBSCRIBER_ID,ID,IS_HIDDEN,OBJECT_CONTEXT_ID,OBJECT_ID, OBJECT_TYPE,PROVIDER_ID,TITLE,USE_PAGE_STYLE) select p_subscriber_id,ID,IS_HIDDEN,OBJECT_CONTEXT_ID,OBJECT_ID, OBJECT_TYPE,PROVIDER_ID,TITLE,USE_PAGE_STYLE from PORTAL.WWSBR_PORTLET$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_SITE_CATEGORY$ (SUBSCRIBER_ID,CATEGORY_ID,CATEGORY_SITEID,ID,LANGUAGE,SITEID) select p_subscriber_id,CATEGORY_ID,CATEGORY_SITEID,ID,LANGUAGE,SITEID from PORTAL.WWSBR_SITE_CATEGORY$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_SITE_FOLDERTYPES$ (SUBSCRIBER_ID,FOLDERTYPEID,FOLDERTYPE_SITEID,ID,SITEID) select p_subscriber_id,FOLDERTYPEID,FOLDERTYPE_SITEID,ID,SITEID from PORTAL.WWSBR_SITE_FOLDERTYPES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_SITE_PERSPECTIVE$ (SUBSCRIBER_ID,ID,LANGUAGE,PERSPECTIVE_ID,PERSPECTIVE_SITEID, SITEID) select p_subscriber_id,ID,LANGUAGE,PERSPECTIVE_ID,PERSPECTIVE_SITEID, SITEID from PORTAL.WWSBR_SITE_PERSPECTIVE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_SITE_SUBTYPES$ (SUBSCRIBER_ID,GROUP_ID,ID,SITEID,SUBTYPEID,SUBTYPE_SITEID) select p_subscriber_id,GROUP_ID,ID,SITEID,SUBTYPEID,SUBTYPE_SITEID from PORTAL.WWSBR_SITE_SUBTYPES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_SUBSCRIPTION$ (SUBSCRIBER_ID,GROUP_ID,ID,OBJECT_CONTEXT_ID,OBJECT_ID,PAGE_ID, RECIPIENT_ID,RECIPIENT_TYPE) select p_subscriber_id,GROUP_ID,ID,OBJECT_CONTEXT_ID,OBJECT_ID,PAGE_ID, RECIPIENT_ID,RECIPIENT_TYPE from PORTAL.WWSBR_SUBSCRIPTION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_THINGFUNCTION_ATTRIBUTE$ (SUBSCRIBER_ID,ID,ISHIDDEN,LANGUAGE,PARAMETER_NAME,SITEID, THINGSUBTYPE_ATTRIBUTEID,THINGSUBTYPE_ATTSITEID, THINGSUBTYPE_FUNCSITEID,THINGSUBTYPE_FUNCTIONID) select p_subscriber_id,ID,ISHIDDEN,LANGUAGE,PARAMETER_NAME,SITEID, THINGSUBTYPE_ATTRIBUTEID,THINGSUBTYPE_ATTSITEID, THINGSUBTYPE_FUNCSITEID,THINGSUBTYPE_FUNCTIONID from PORTAL.WWSBR_THINGFUNCTION_ATTRIBUTE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_TMP_DAV_INFO$ (SUBSCRIBER_ID,DAV_ID,DISPLAY_NAME,DOC_NAME,LANGUAGE, MASTER_THING_ID,PAGE_ID,PRIVILEGE,SITE_ID,USER_NAME) select p_subscriber_id,DAV_ID,DISPLAY_NAME,DOC_NAME,LANGUAGE, MASTER_THING_ID,PAGE_ID,PRIVILEGE,SITE_ID,USER_NAME from PORTAL.WWSBR_TMP_DAV_INFO$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_URL$ (SUBSCRIBER_ID,ABSOLUTE_URL,ID,LANGUAGE,OBJECT_ID,OBJECT_SITEID, OBJECT_TYPE,URL) select p_subscriber_id,ABSOLUTE_URL,ID,LANGUAGE,OBJECT_ID, OBJECT_SITEID,OBJECT_TYPE,URL from PORTAL.WWSBR_URL$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSBR_USER_SEARCHES (SUBSCRIBER_ID,CREATEDATE,ID,NAME,TERMS,USERID) select p_subscriber_id,CREATEDATE,ID,NAME,TERMS,USERID from PORTAL.WWSBR_USER_SEARCHES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_AUTH_FUNCTION$ (SUBSCRIBER_ID,FUNCTION_NAME,ID,NAME,OBJECT_TYPE_NAME,OWNER) select p_subscriber_id,FUNCTION_NAME,ID,NAME,OBJECT_TYPE_NAME,OWNER from PORTAL.WWSEC_AUTH_FUNCTION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_EXT_APP_LKUP$ (SUBSCRIBER_ID,APP_ID,APP_NAME) select p_subscriber_id,APP_ID,APP_NAME from PORTAL.WWSEC_EXT_APP_LKUP$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_FLAT$ (SUBSCRIBER_ID,GROUP_ID,ID,PERSON_ID) select p_subscriber_id,GROUP_ID,ID,PERSON_ID from PORTAL.WWSEC_FLAT$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_MEMBER$ (SUBSCRIBER_ID,GROUP_ID,GROUP_TYPE,ID,MEMBER_GROUP_ID, MEMBER_PERSON_ID,MEMBER_TYPE,PARENT_MEMBER) select p_subscriber_id,GROUP_ID,GROUP_TYPE,ID,MEMBER_GROUP_ID, MEMBER_PERSON_ID,MEMBER_TYPE,PARENT_MEMBER from PORTAL.WWSEC_MEMBER$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_PRIVILEGE$ (SUBSCRIBER_ID,DEFAULT_PRIVILEGE,ID,NAME,OBJECT_TYPE_ID,PRIORITY, PRIVILEGE_CODE) select p_subscriber_id,DEFAULT_PRIVILEGE,ID,NAME,OBJECT_TYPE_ID, PRIORITY,PRIVILEGE_CODE from PORTAL.WWSEC_PRIVILEGE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_SSO_LOG$ (SUBSCRIBER_ID,ID,LOG_DATE,MSG) select p_subscriber_id,ID,LOG_DATE,MSG from PORTAL.WWSEC_SSO_LOG$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSEC_SYS_PRIV$ (SUBSCRIBER_ID,CREATED_BY_DBUSER,CREATED_BY_USER,CREATED_ON, GRANTEE_APP_ID,GRANTEE_GROUP_ID,GRANTEE_TYPE,GRANTEE_USER_ID,ID, NAME,OBJECT_TYPE_NAME,OWNER,PRIVILEGE,PRIVILEGE_CODE) select p_subscriber_id,CREATED_BY_DBUSER,CREATED_BY_USER,CREATED_ON, GRANTEE_APP_ID,GRANTEE_GROUP_ID,GRANTEE_TYPE,GRANTEE_USER_ID,ID, NAME,OBJECT_TYPE_NAME,OWNER,PRIVILEGE,PRIVILEGE_CODE from PORTAL.WWSEC_SYS_PRIV$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWSRC_PREFERENCE$ (SUBSCRIBER_ID,ID,PORTLET_INSTANCE_NAME,PREFERENCE) select p_subscriber_id,ID,PORTLET_INSTANCE_NAME,PREFERENCE from PORTAL.WWSRC_PREFERENCE$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,APP_TEMPLATE_ID,ELEMENT,THE_VALUE,THE_VALUE_ID from PORTAL.WWTMP_USR_TEMPLATE_DETAIL$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWTMP_USR_TEMPLATE_DETAIL$ (SUBSCRIBER_ID,APP_TEMPLATE_ID,ELEMENT,THE_VALUE,THE_VALUE_ID) values (p_subscriber_id,x.APP_TEMPLATE_ID,x.ELEMENT,x.THE_VALUE, x.THE_VALUE_ID); end loop; -- commit; -- for x in ( select SUBSCRIBER_ID,ID,SESSIONID,TEMPLATE_TEXT from PORTAL.WWTMP_USR_TEMPLATE_PREVIEW$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWTMP_USR_TEMPLATE_PREVIEW$ (SUBSCRIBER_ID,ID,SESSIONID,TEMPLATE_TEXT) values (p_subscriber_id,x.ID,x.SESSIONID,x.TEMPLATE_TEXT); end loop; -- commit; -- for x in ( select SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,SCHEMA,SCRIPT, SCRIPT_LANGUAGE,SCRIPT_NAME,UPDATED_BY,UPDATED_ON from PORTAL.WWUTL_SYS_JAVA_SCRIPTS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWUTL_SYS_JAVA_SCRIPTS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,SCHEMA,SCRIPT, SCRIPT_LANGUAGE,SCRIPT_NAME,UPDATED_BY,UPDATED_ON) values (p_subscriber_id,x.CREATED_BY,x.CREATED_ON,x.ID,x.SCHEMA, x.SCRIPT,x.SCRIPT_LANGUAGE,x.SCRIPT_NAME,x.UPDATED_BY, x.UPDATED_ON); end loop; -- commit; -- insert into PORTAL.WWV_ALERTS (SUBSCRIBER_ID,EXPIREDATE,LANGUAGE,MESSAGE,NAME) select p_subscriber_id,EXPIREDATE,LANGUAGE,MESSAGE,NAME from PORTAL.WWV_ALERTS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,NAME,SUBMISSION_ID,VALUE from PORTAL.WWV_BATCH_CGI_VALUE$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_BATCH_CGI_VALUE$ (SUBSCRIBER_ID,NAME,SUBMISSION_ID,VALUE) values (p_subscriber_id,x.NAME,x.SUBMISSION_ID,x.VALUE); end loop; -- commit; -- insert into PORTAL.WWV_BATCH_RESULTS$ (SUBSCRIBER_ID,SEQ_NO,SUBMISSION_ID,THE_VALUE) select p_subscriber_id,SEQ_NO,SUBMISSION_ID,THE_VALUE from PORTAL.WWV_BATCH_RESULTS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_COUNTRIES (SUBSCRIBER_ID,CODE,PERSPECTIVEID) select p_subscriber_id,CODE,PERSPECTIVEID from PORTAL.WWV_COUNTRIES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,DOCUMENT,ID from PORTAL.WWV_CS_HELP_MUTAB where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_CS_HELP_MUTAB (SUBSCRIBER_ID,DOCUMENT,ID) values (p_subscriber_id,x.DOCUMENT,x.ID); end loop; -- commit; -- insert into PORTAL.WWV_CTX_FILT_TABLE (SUBSCRIBER_ID,DOCUMENT,QUERY_ID) select p_subscriber_id,DOCUMENT,QUERY_ID from PORTAL.WWV_CTX_FILT_TABLE where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_CTX_GIST (SUBSCRIBER_ID,GIST,POV,QUERY_ID) select p_subscriber_id,GIST,POV,QUERY_ID from PORTAL.WWV_CTX_GIST where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_CTX_MARK_TABLE (SUBSCRIBER_ID,DOCUMENT,QUERY_ID) select p_subscriber_id,DOCUMENT,QUERY_ID from PORTAL.WWV_CTX_MARK_TABLE where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_CTX_THEMES (SUBSCRIBER_ID,QUERY_ID,THEME,WEIGHT) select p_subscriber_id,QUERY_ID,THEME,WEIGHT from PORTAL.WWV_CTX_THEMES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_DATAPTL_DATA$ (SUBSCRIBER_ID,WWV_DPD_CHAR,WWV_DPD_COL,WWV_DPD_CREATED_BY, WWV_DPD_CREATED_ON,WWV_DPD_DATE,WWV_DPD_DEPS,WWV_DPD_DPID, WWV_DPD_FMTDCACHE,WWV_DPD_FORMAT,WWV_DPD_FORMULA,WWV_DPD_ID, WWV_DPD_NUM,WWV_DPD_PARENTS,WWV_DPD_ROW,WWV_DPD_TYPE, WWV_DPD_UPDATED_BY,WWV_DPD_UPDATED_ON) select p_subscriber_id,WWV_DPD_CHAR,WWV_DPD_COL,WWV_DPD_CREATED_BY, WWV_DPD_CREATED_ON,WWV_DPD_DATE,WWV_DPD_DEPS,WWV_DPD_DPID, WWV_DPD_FMTDCACHE,WWV_DPD_FORMAT,WWV_DPD_FORMULA,WWV_DPD_ID, WWV_DPD_NUM,WWV_DPD_PARENTS,WWV_DPD_ROW,WWV_DPD_TYPE, WWV_DPD_UPDATED_BY,WWV_DPD_UPDATED_ON from PORTAL.WWV_DATAPTL_DATA$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_DOCINFO (SUBSCRIBER_ID,ACTIVE,CORNERID,EXPIREDATE,LANGUAGE,MASTERTHINGID, NAME,PUBLISHDATE,SECURITY,SITEID,THINGID) select p_subscriber_id,ACTIVE,CORNERID,EXPIREDATE,LANGUAGE, MASTERTHINGID,NAME,PUBLISHDATE,SECURITY,SITEID,THINGID from PORTAL.WWV_DOCINFO where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_DROPSITECOMMANDS$ (SUBSCRIBER_ID,COMMANDORDER,COMMANDTYPE,OBJECTNAME) select p_subscriber_id,COMMANDORDER,COMMANDTYPE,OBJECTNAME from PORTAL.WWV_DROPSITECOMMANDS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,FILENAME,ID,LANGUAGE,PARENTID,REQUIREDROLE,TEXT, TITLE,TOPNODE from PORTAL.WWV_HELP$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_HELP$ (SUBSCRIBER_ID,FILENAME,ID,LANGUAGE,PARENTID,REQUIREDROLE,TEXT, TITLE,TOPNODE) values (p_subscriber_id,x.FILENAME,x.ID,x.LANGUAGE,x.PARENTID, x.REQUIREDROLE,x.TEXT,x.TITLE,x.TOPNODE); end loop; -- commit; -- for x in ( select SUBSCRIBER_ID,FILENAME,ID,LANGUAGE,REQUIREDROLE,TEXT,TITLE from PORTAL.WWV_HELP_CONTEXT_SENSITIVE$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_HELP_CONTEXT_SENSITIVE$ (SUBSCRIBER_ID,FILENAME,ID,LANGUAGE,REQUIREDROLE,TEXT,TITLE) values (p_subscriber_id,x.FILENAME,x.ID,x.LANGUAGE,x.REQUIREDROLE, x.TEXT,x.TITLE); end loop; -- commit; -- insert into PORTAL.WWV_HELP_INDEX$ (SUBSCRIBER_ID,FILENAME,ID,PARENTID,TITLE) select p_subscriber_id,FILENAME,ID,PARENTID,TITLE from PORTAL.WWV_HELP_INDEX$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,DOCUMENT,ID from PORTAL.WWV_HELP_MUTAB where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_HELP_MUTAB (SUBSCRIBER_ID,DOCUMENT,ID) values (p_subscriber_id,x.DOCUMENT,x.ID); end loop; -- commit; -- insert into PORTAL.WWV_HELP_RELATED_TOPICS$ (SUBSCRIBER_ID,FILENAME,ID,PARENTID,TITLE) select p_subscriber_id,FILENAME,ID,PARENTID,TITLE from PORTAL.WWV_HELP_RELATED_TOPICS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_HITS1 (SUBSCRIBER_ID,BROWSER,CORNERID,IP,LANGUAGE,OBJECTID,OBJECTTYPE, OS,SITEID,TIME,USERID) select p_subscriber_id,BROWSER,CORNERID,IP,LANGUAGE,OBJECTID, OBJECTTYPE,OS,SITEID,TIME,USERID from PORTAL.WWV_HITS1 where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_HITS2 (SUBSCRIBER_ID,BROWSER,CORNERID,IP,LANGUAGE,OBJECTID,OBJECTTYPE, OS,SITEID,TIME,USERID) select p_subscriber_id,BROWSER,CORNERID,IP,LANGUAGE,OBJECTID, OBJECTTYPE,OS,SITEID,TIME,USERID from PORTAL.WWV_HITS2 where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,EXPLANATION,IMAGE,LANGUAGE,NAME,TEXT,TYPE,URL from PORTAL.WWV_MESSAGES where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_MESSAGES (SUBSCRIBER_ID,EXPLANATION,IMAGE,LANGUAGE,NAME,TEXT,TYPE,URL) values (p_subscriber_id,x.EXPLANATION,x.IMAGE,x.LANGUAGE,x.NAME,x.TEXT, x.TYPE,x.URL); end loop; -- commit; -- for x in ( select SUBSCRIBER_ID,ATTRIBUTE_ID,MODULE_ID,SEQ,VALUE,VERSION from PORTAL.WWV_MODULE_DETAILS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_MODULE_DETAILS$ (SUBSCRIBER_ID,ATTRIBUTE_ID,MODULE_ID,SEQ,VALUE,VERSION) values (p_subscriber_id,x.ATTRIBUTE_ID,x.MODULE_ID,x.SEQ,x.VALUE, x.VERSION); end loop; -- commit; -- for x in ( select SUBSCRIBER_ID,ELEMENT,MODULE_ID,USERNAME,VALUE from PORTAL.WWV_PARM_SAVES$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_PARM_SAVES$ (SUBSCRIBER_ID,ELEMENT,MODULE_ID,USERNAME,VALUE) values (p_subscriber_id,x.ELEMENT,x.MODULE_ID,x.USERNAME,x.VALUE); end loop; -- commit; -- insert into PORTAL.WWV_PERSPECTIVES (SUBSCRIBER_ID,ACTIVE,CTXTXT,DESCRIPTION,FRONTPAGE,ICON,ID,IMAGE, ISVISUAL,IS_PORTLET,LANGUAGE,LIFETIMEHITS,NAME,OWNER,PAGE_ID, PARENTID,ROLLOVERIMAGE,SITEID,TITLE,TITLEIMAGE,UPDATEDATE) select p_subscriber_id,ACTIVE,CTXTXT,DESCRIPTION,FRONTPAGE,ICON,ID, IMAGE,ISVISUAL,IS_PORTLET,LANGUAGE,LIFETIMEHITS,NAME,OWNER, PAGE_ID,PARENTID,ROLLOVERIMAGE,SITEID,TITLE,TITLEIMAGE, UPDATEDATE from PORTAL.WWV_PERSPECTIVES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SETTINGS (SUBSCRIBER_ID,GUID,NAME,SETTINGSSETID,SITEID,TYPE,VALUE, VALUETYPE) select p_subscriber_id,GUID,NAME,SETTINGSSETID,SITEID,TYPE,VALUE, VALUETYPE from PORTAL.WWV_SETTINGS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SETTINGSSETS (SUBSCRIBER_ID,CACHE_EXPIRES,CACHE_MODE,CREATED_ON,CREATOR, DESCRIPTION,GUID,ID,IS_PUBLIC,LANGUAGE,LAST_UPDATED_BY,NAME, SITEID,STYLESHEET,TITLE,UPDATEDATE) select p_subscriber_id,CACHE_EXPIRES,CACHE_MODE,CREATED_ON,CREATOR, DESCRIPTION,GUID,ID,IS_PUBLIC,LANGUAGE,LAST_UPDATED_BY,NAME, SITEID,STYLESHEET,TITLE,UPDATEDATE from PORTAL.WWV_SETTINGSSETS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SUBTYPEATTRIBUTES (SUBSCRIBER_ID,ADD_WIZARD,ATTRIBUTEID,ATTRIBUTE_SITEID, BASE_TYPE_ATTRIBUTE,DEFAULTVALUE,EDIT_WIZARD,ID,ISHIDDEN, LANGUAGE,REQUIRED,SEQ,SITEID,THINGSUBTYPEID,THINGSUBTYPE_SITEID) select p_subscriber_id,ADD_WIZARD,ATTRIBUTEID,ATTRIBUTE_SITEID, BASE_TYPE_ATTRIBUTE,DEFAULTVALUE,EDIT_WIZARD,ID,ISHIDDEN, LANGUAGE,REQUIRED,SEQ,SITEID,THINGSUBTYPEID,THINGSUBTYPE_SITEID from PORTAL.WWV_SUBTYPEATTRIBUTES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,APP_TEMPLATE_ID,ELEMENT,THE_VALUE from PORTAL.WWV_SYS_APP_TEMPLATE_DETAILS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_SYS_APP_TEMPLATE_DETAILS$ (SUBSCRIBER_ID,APP_TEMPLATE_ID,ELEMENT,THE_VALUE) values (p_subscriber_id,x.APP_TEMPLATE_ID,x.ELEMENT,x.THE_VALUE); end loop; -- commit; -- insert into PORTAL.WWV_SYS_COLORS$ (SUBSCRIBER_ID,COLOR_NAME,COLOR_VALUE,CREATED_BY,CREATED_ON,ID, UPDATED_BY,UPDATED_ON) select p_subscriber_id,COLOR_NAME,COLOR_VALUE,CREATED_BY,CREATED_ON,ID, UPDATED_BY,UPDATED_ON from PORTAL.WWV_SYS_COLORS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_COMPONENT_SCHEMAS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,USERNAME) select p_subscriber_id,CREATED_BY,CREATED_ON,USERNAME from PORTAL.WWV_SYS_COMPONENT_SCHEMAS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_DEBUG (SUBSCRIBER_ID,IN_DEBUG,MODULE_ID) select p_subscriber_id,IN_DEBUG,MODULE_ID from PORTAL.WWV_SYS_DEBUG where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_DRIVER_PARAMETERS$ (SUBSCRIBER_ID,ID,NAME,SEQ,TYPE,VALUE) select p_subscriber_id,ID,NAME,SEQ,TYPE,VALUE from PORTAL.WWV_SYS_DRIVER_PARAMETERS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,LOV_ID,LOV_NAME,LOV_OWNER,SQL_STATEMENT from PORTAL.WWV_SYS_DYNAMIC_LOV$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_SYS_DYNAMIC_LOV$ (SUBSCRIBER_ID,LOV_ID,LOV_NAME,LOV_OWNER,SQL_STATEMENT) values (p_subscriber_id,x.LOV_ID,x.LOV_NAME,x.LOV_OWNER,x.SQL_STATEMENT); end loop; -- commit; -- insert into PORTAL.WWV_SYS_FONTS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,FONT_NAME,FONT_VALUE,ID, UPDATED_BY,UPDATED_ON) select p_subscriber_id,CREATED_BY,CREATED_ON,FONT_NAME,FONT_VALUE,ID, UPDATED_BY,UPDATED_ON from PORTAL.WWV_SYS_FONTS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_IMAGES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,FILE_NAME,ID,IMAGE_NAME, IMAGE_TYPE_ID,SCHEMA,UPDATED_BY,UPDATED_ON) select p_subscriber_id,CREATED_BY,CREATED_ON,FILE_NAME,ID,IMAGE_NAME, IMAGE_TYPE_ID,SCHEMA,UPDATED_BY,UPDATED_ON from PORTAL.WWV_SYS_IMAGES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,CREATED_BY,CREATED_ON,DISPLAY_TO_USER,ID,SCHEMA, SCRIPT,SCRIPT_LANGUAGE,SCRIPT_NAME,UPDATED_BY,UPDATED_ON from PORTAL.WWV_SYS_JAVA_SCRIPTS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_SYS_JAVA_SCRIPTS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,DISPLAY_TO_USER,ID,SCHEMA, SCRIPT,SCRIPT_LANGUAGE,SCRIPT_NAME,UPDATED_BY,UPDATED_ON) values (p_subscriber_id,x.CREATED_BY,x.CREATED_ON,x.DISPLAY_TO_USER, x.ID,x.SCHEMA,x.SCRIPT,x.SCRIPT_LANGUAGE,x.SCRIPT_NAME, x.UPDATED_BY,x.UPDATED_ON); end loop; -- commit; -- insert into PORTAL.WWV_SYS_LABELS$ (SUBSCRIBER_ID,CONTEXT,CREATED_BY,CREATED_ON,ID,LANGUAGE,TEXT_ID, TEXT_STRING,TEXT_STRING_SHORT,UPDATED_BY,UPDATED_ON) select p_subscriber_id,CONTEXT,CREATED_BY,CREATED_ON,ID,LANGUAGE, TEXT_ID,TEXT_STRING,TEXT_STRING_SHORT,UPDATED_BY,UPDATED_ON from PORTAL.WWV_SYS_LABELS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_LABEL_USAGES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,OBJECT_NAME,OBJECT_OWNER, OBJECT_TYPE,TABLE_NAME,TABLE_OWNER,TEXT_ID) select p_subscriber_id,CREATED_BY,CREATED_ON,ID,OBJECT_NAME, OBJECT_OWNER,OBJECT_TYPE,TABLE_NAME,TABLE_OWNER,TEXT_ID from PORTAL.WWV_SYS_LABEL_USAGES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ENTRY_DESCRIPTION, FONT_COLOR,FONT_COLOR_PORTLET,FONT_FACE,FONT_FACE_PORTLET, FONT_SIZE,FONT_SIZE_PORTLET,HELP,LINK,LINK_TYPE,MENU_ALIGNMENT, MENU_FOOTER,MENU_ID,MENU_OWNER,NAME,PAGE_STYLE,PREV_MENU_ID, PRIV_FROM_COMP,SEQ,SHOW_LEVELS,SHOW_LEVELS_PORTLET,UI_TEMPLATE, UPDATED_BY,UPDATED_ON,USE_BULLET,VERSION,WELCOME_TEXT, WELCOME_TEXT_TEXT_ID from PORTAL.WWV_SYS_MENUS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_SYS_MENUS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ENTRY_DESCRIPTION, FONT_COLOR,FONT_COLOR_PORTLET,FONT_FACE,FONT_FACE_PORTLET, FONT_SIZE,FONT_SIZE_PORTLET,HELP,LINK,LINK_TYPE,MENU_ALIGNMENT, MENU_FOOTER,MENU_ID,MENU_OWNER,NAME,PAGE_STYLE,PREV_MENU_ID, PRIV_FROM_COMP,SEQ,SHOW_LEVELS,SHOW_LEVELS_PORTLET,UI_TEMPLATE, UPDATED_BY,UPDATED_ON,USE_BULLET,VERSION,WELCOME_TEXT, WELCOME_TEXT_TEXT_ID) values (p_subscriber_id,x.CREATED_BY,x.CREATED_ON,x.ENTRY_DESCRIPTION, x.FONT_COLOR,x.FONT_COLOR_PORTLET,x.FONT_FACE, x.FONT_FACE_PORTLET,x.FONT_SIZE,x.FONT_SIZE_PORTLET,x.HELP, x.LINK,x.LINK_TYPE,x.MENU_ALIGNMENT,x.MENU_FOOTER,x.MENU_ID, x.MENU_OWNER,x.NAME,x.PAGE_STYLE,x.PREV_MENU_ID, x.PRIV_FROM_COMP,x.SEQ,x.SHOW_LEVELS,x.SHOW_LEVELS_PORTLET, x.UI_TEMPLATE,x.UPDATED_BY,x.UPDATED_ON,x.USE_BULLET,x.VERSION, x.WELCOME_TEXT,x.WELCOME_TEXT_TEXT_ID); end loop; -- commit; -- insert into PORTAL.WWV_SYS_MESSAGES$ (SUBSCRIBER_ID,ID,LANG,MSGTEXT,NAME,PCOUNT,TYPE) select p_subscriber_id,ID,LANG,MSGTEXT,NAME,PCOUNT,TYPE from PORTAL.WWV_SYS_MESSAGES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_PADMIN$ (SUBSCRIBER_ID,PORTAL_ID) select p_subscriber_id,PORTAL_ID from PORTAL.WWV_SYS_PADMIN$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_PREFERENCES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,PREFERENCE_ID, PREFERENCE_VALUE,UPDATED_BY,UPDATED_ON,USER_NAME) select p_subscriber_id,CREATED_BY,CREATED_ON,ID,PREFERENCE_ID, PREFERENCE_VALUE,UPDATED_BY,UPDATED_ON,USER_NAME from PORTAL.WWV_SYS_PREFERENCES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_STATIC_LOV$ (SUBSCRIBER_ID,DISPLAY_TEXT,LOV_ID,LOV_NAME,LOV_SEQ,LOV_VALUE) select p_subscriber_id,DISPLAY_TEXT,LOV_ID,LOV_NAME,LOV_SEQ,LOV_VALUE from PORTAL.WWV_SYS_STATIC_LOV$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_SYS_SURVEY_LOC$ (SUBSCRIBER_ID,COUNTRY,TELEPHONE) select p_subscriber_id,COUNTRY,TELEPHONE from PORTAL.WWV_SYS_SURVEY_LOC$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,LANGUAGE,TEXT_ID, TEXT_STRING,UPDATED_BY,UPDATED_ON from PORTAL.WWV_SYS_TEXT_BLOCKS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_SYS_TEXT_BLOCKS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,LANGUAGE,TEXT_ID, TEXT_STRING,UPDATED_BY,UPDATED_ON) values (p_subscriber_id,x.CREATED_BY,x.CREATED_ON,x.ID,x.LANGUAGE, x.TEXT_ID,x.TEXT_STRING,x.UPDATED_BY,x.UPDATED_ON); end loop; -- commit; -- insert into PORTAL.WWV_SYS_TEXT_BLOCK_USAGES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,OBJECT_NAME,OBJECT_OWNER, OBJECT_TYPE,TABLE_NAME,TABLE_OWNER,TEXT_ID) select p_subscriber_id,CREATED_BY,CREATED_ON,OBJECT_NAME,OBJECT_OWNER, OBJECT_TYPE,TABLE_NAME,TABLE_OWNER,TEXT_ID from PORTAL.WWV_SYS_TEXT_BLOCK_USAGES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_THINGATTRIBUTES (SUBSCRIBER_ID,ATTRIBUTEID,ATTRIBUTE_SITEID,DATEVALUE,GUID, LANGUAGE,MASTERTHINGID,NUMBERVALUE,SITEID,SUBTYPEATTRIBUTEID, VALUE,VALUETYPE) select p_subscriber_id,ATTRIBUTEID,ATTRIBUTE_SITEID,DATEVALUE,GUID, LANGUAGE,MASTERTHINGID,NUMBERVALUE,SITEID,SUBTYPEATTRIBUTEID, VALUE,VALUETYPE from PORTAL.WWV_THINGATTRIBUTES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_THINGSPERSPECTIVES (SUBSCRIBER_ID,MASTERTHINGID,PERSPECTIVEID,PERSPECTIVE_SITEID, SITEID,THINGID) select p_subscriber_id,MASTERTHINGID,PERSPECTIVEID,PERSPECTIVE_SITEID, SITEID,THINGID from PORTAL.WWV_THINGSPERSPECTIVES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_UPDATES (SUBSCRIBER_ID,ACTION,CHANGEDATE,CHANGER,IP,SITEID,THINGID) select p_subscriber_id,ACTION,CHANGEDATE,CHANGER,IP,SITEID,THINGID from PORTAL.WWV_UPDATES where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_USER_LABELS$ (SUBSCRIBER_ID,CONTEXT,CREATED_BY,CREATED_ON,ID,LANGUAGE,TEXT_ID, TEXT_STRING,UPDATED_BY,UPDATED_ON) select p_subscriber_id,CONTEXT,CREATED_BY,CREATED_ON,ID,LANGUAGE, TEXT_ID,TEXT_STRING,UPDATED_BY,UPDATED_ON from PORTAL.WWV_USER_LABELS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_USER_LABEL_USAGES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,OBJECT_NAME,OBJECT_OWNER, OBJECT_TYPE,TABLE_NAME,TABLE_OWNER,TEXT_ID) select p_subscriber_id,CREATED_BY,CREATED_ON,ID,OBJECT_NAME, OBJECT_OWNER,OBJECT_TYPE,TABLE_NAME,TABLE_OWNER,TEXT_ID from PORTAL.WWV_USER_LABEL_USAGES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,LANGUAGE,TEXT_ID, TEXT_STRING,UPDATED_BY,UPDATED_ON from PORTAL.WWV_USER_TEXT_BLOCKS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_USER_TEXT_BLOCKS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ID,LANGUAGE,TEXT_ID, TEXT_STRING,UPDATED_BY,UPDATED_ON) values (p_subscriber_id,x.CREATED_BY,x.CREATED_ON,x.ID,x.LANGUAGE, x.TEXT_ID,x.TEXT_STRING,x.UPDATED_BY,x.UPDATED_ON); end loop; -- commit; -- insert into PORTAL.WWV_USER_TEXT_BLOCK_USAGES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,OBJECT_NAME,OBJECT_OWNER, OBJECT_TYPE,TABLE_NAME,TABLE_OWNER,TEXT_ID) select p_subscriber_id,CREATED_BY,CREATED_ON,OBJECT_NAME,OBJECT_OWNER, OBJECT_TYPE,TABLE_NAME,TABLE_OWNER,TEXT_ID from PORTAL.WWV_USER_TEXT_BLOCK_USAGES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_USR_COLORS$ (SUBSCRIBER_ID,COLOR_NAME,COLOR_VALUE,CREATED_BY,CREATED_ON,ID, UPDATED_BY,UPDATED_ON) select p_subscriber_id,COLOR_NAME,COLOR_VALUE,CREATED_BY,CREATED_ON,ID, UPDATED_BY,UPDATED_ON from PORTAL.WWV_USR_COLORS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,LOV_ID,LOV_NAME,LOV_OWNER,SQL_STATEMENT from PORTAL.WWV_USR_DYNAMIC_LOV$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_USR_DYNAMIC_LOV$ (SUBSCRIBER_ID,LOV_ID,LOV_NAME,LOV_OWNER,SQL_STATEMENT) values (p_subscriber_id,x.LOV_ID,x.LOV_NAME,x.LOV_OWNER,x.SQL_STATEMENT); end loop; -- commit; -- insert into PORTAL.WWV_USR_FONTS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,FONT_NAME,FONT_VALUE,ID, UPDATED_BY,UPDATED_ON) select p_subscriber_id,CREATED_BY,CREATED_ON,FONT_NAME,FONT_VALUE,ID, UPDATED_BY,UPDATED_ON from PORTAL.WWV_USR_FONTS$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_USR_IMAGES$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,FILE_NAME,ID,IMAGE_NAME, IMAGE_TYPE_ID,SCHEMA,UPDATED_BY,UPDATED_ON) select p_subscriber_id,CREATED_BY,CREATED_ON,FILE_NAME,ID,IMAGE_NAME, IMAGE_TYPE_ID,SCHEMA,UPDATED_BY,UPDATED_ON from PORTAL.WWV_USR_IMAGES$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- for x in ( select SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ENTRY_DESCRIPTION, FONT_COLOR,FONT_COLOR_PORTLET,FONT_FACE,FONT_FACE_PORTLET, FONT_SIZE,FONT_SIZE_PORTLET,HELP,LINK,LINK_TYPE,MENU_ALIGNMENT, MENU_FOOTER,MENU_ID,MENU_OWNER,NAME,PAGE_STYLE,PREV_MENU_ID, PRIV_FROM_COMP,SEQ,SHOW_LEVELS,SHOW_LEVELS_PORTLET,UI_TEMPLATE, UPDATED_BY,UPDATED_ON,USE_BULLET,VERSION,WELCOME_TEXT, WELCOME_TEXT_TEXT_ID from PORTAL.WWV_USR_MENUS$ where SUBSCRIBER_ID = p_seed_subscriber_id) loop insert into PORTAL.WWV_USR_MENUS$ (SUBSCRIBER_ID,CREATED_BY,CREATED_ON,ENTRY_DESCRIPTION, FONT_COLOR,FONT_COLOR_PORTLET,FONT_FACE,FONT_FACE_PORTLET, FONT_SIZE,FONT_SIZE_PORTLET,HELP,LINK,LINK_TYPE,MENU_ALIGNMENT, MENU_FOOTER,MENU_ID,MENU_OWNER,NAME,PAGE_STYLE,PREV_MENU_ID, PRIV_FROM_COMP,SEQ,SHOW_LEVELS,SHOW_LEVELS_PORTLET,UI_TEMPLATE, UPDATED_BY,UPDATED_ON,USE_BULLET,VERSION,WELCOME_TEXT, WELCOME_TEXT_TEXT_ID) values (p_subscriber_id,x.CREATED_BY,x.CREATED_ON,x.ENTRY_DESCRIPTION, x.FONT_COLOR,x.FONT_COLOR_PORTLET,x.FONT_FACE, x.FONT_FACE_PORTLET,x.FONT_SIZE,x.FONT_SIZE_PORTLET,x.HELP, x.LINK,x.LINK_TYPE,x.MENU_ALIGNMENT,x.MENU_FOOTER,x.MENU_ID, x.MENU_OWNER,x.NAME,x.PAGE_STYLE,x.PREV_MENU_ID, x.PRIV_FROM_COMP,x.SEQ,x.SHOW_LEVELS,x.SHOW_LEVELS_PORTLET, x.UI_TEMPLATE,x.UPDATED_BY,x.UPDATED_ON,x.USE_BULLET,x.VERSION, x.WELCOME_TEXT,x.WELCOME_TEXT_TEXT_ID); end loop; -- commit; -- insert into PORTAL.WWV_USR_SQL$ (SUBSCRIBER_ID,ID,NAME,OWNER) select p_subscriber_id,ID,NAME,OWNER from PORTAL.WWV_USR_SQL$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_USR_STATIC_LOV$ (SUBSCRIBER_ID,DISPLAY_TEXT,LOV_ID,LOV_NAME,LOV_SEQ,LOV_VALUE) select p_subscriber_id,DISPLAY_TEXT,LOV_ID,LOV_NAME,LOV_SEQ,LOV_VALUE from PORTAL.WWV_USR_STATIC_LOV$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_VERSION$ (SUBSCRIBER_ID,INSTALLDATE,STATUS,VERSION,WEBVIEWOWNER) select p_subscriber_id,INSTALLDATE,STATUS,VERSION,WEBVIEWOWNER from PORTAL.WWV_VERSION$ where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- insert into PORTAL.WWV_VIDEOSERVERS (SUBSCRIBER_ID,CONTENT,FORMAT,IP,LOCATION,MASK,PORT,PROTOCOL, SUBNET) select p_subscriber_id,CONTENT,FORMAT,IP,LOCATION,MASK,PORT,PROTOCOL, SUBNET from PORTAL.WWV_VIDEOSERVERS where SUBSCRIBER_ID = p_seed_subscriber_id; -- commit; -- end copy_subscriber; /