',
''))
,p_report_placeholder_count=>3
,p_substitute_attributes=>true
,p_reference_id=>1564386865908414285
,p_subscribe_plugin_settings=>true
,p_is_quick_pick=>true
,p_help_text=>'Display user comments and status updates. Supports avatars. Available for a single row or as a report with multiple rows.'
);
wwv_flow_imp_shared.create_plugin_attr_group(
p_id=>wwv_flow_imp.id(22583034566758221359)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_title=>'Avatar'
,p_display_sequence=>20
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783149628377189644)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>1
,p_display_sequence=>10
,p_static_id=>'COMMENT_TEXT'
,p_prompt=>'Comment Text'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_demo_value=>'Praesent vel felis rutrum erat elementum viverra sit amet non odio. Cras vel auctor eros, in malesuada dolor. Nulla tellus magna, ornare consectetur purus id, volutpat egestas felis. Proin lobortis risus massa, nec faucibus arcu malesuada a. Nunc sed'
||' gravida urna. Fusce at ligula sed erat consequat pharetra.'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_help_text=>'Select a source column containing text for user comments.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783149851790189644)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>2
,p_display_sequence=>20
,p_static_id=>'USER_NAME'
,p_prompt=>'User Name'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_demo_value=>'Joel'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_help_text=>'Select a source column to be displayed as the user name associated with a comment.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783150237628189644)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>3
,p_display_sequence=>30
,p_static_id=>'COMMENT_DATE'
,p_prompt=>'Date'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>false
,p_demo_value=>'5 minutes ago'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2:DATE'
,p_is_translatable=>false
,p_help_text=>'Select a source column containing a date, date range, or time.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783150497087189644)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>4
,p_display_sequence=>40
,p_static_id=>'ATTRIBUTES'
,p_prompt=>'Attributes'
,p_attribute_type=>'TEXTAREA'
,p_is_required=>false
,p_escape_mode=>'HTML'
,p_is_translatable=>true
,p_help_text=>'Enter some text and/or column substitution strings to be used as the comment attributes.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783150789422189644)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>5
,p_display_sequence=>50
,p_static_id=>'AVATAR_TYPE'
,p_prompt=>'Type'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'icon'
,p_demo_value=>'initials'
,p_escape_mode=>'HTML'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783155355929189646)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22583034566758221359)
,p_help_text=>'Select the type of content that will be displayed in the avatar.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783151082911189644)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783150789422189644)
,p_display_sequence=>10
,p_display_value=>'Image'
,p_return_value=>'image'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783151528940189645)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783150789422189644)
,p_display_sequence=>20
,p_display_value=>'Initials'
,p_return_value=>'initials'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783151877009189645)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783150789422189644)
,p_display_sequence=>30
,p_display_value=>'Icon'
,p_return_value=>'icon'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783152306950189645)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>6
,p_display_sequence=>60
,p_static_id=>'AVATAR_IMAGE'
,p_prompt=>'Image'
,p_attribute_type=>'MEDIA'
,p_is_required=>true
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783150789422189644)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'image'
,p_attribute_group_id=>wwv_flow_imp.id(22583034566758221359)
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'
Use the Media popup dialog to select a source for the avatar image.
',
'',
'
Available options include:',
'
',
'
URL
',
'
BLOB Column
',
'
URL Column
',
'
',
''))
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783152598147189645)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>7
,p_display_sequence=>70
,p_static_id=>'AVATAR_IMAGE_ALT'
,p_prompt=>'Image Description'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>true
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783152306950189645)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'NOT_NULL'
,p_attribute_group_id=>wwv_flow_imp.id(22583034566758221359)
,p_help_text=>'Enter a short description of the image or select a source column from the quick pick options. This will be used as alt text for the avatar image.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783152881644189645)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>8
,p_display_sequence=>80
,p_static_id=>'AVATAR_INITIALS'
,p_prompt=>'Initials'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_demo_value=>'JK'
,p_escape_mode=>'STRIPHTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783150789422189644)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'initials'
,p_attribute_group_id=>wwv_flow_imp.id(22583034566758221359)
,p_help_text=>'Select the source column to be displayed within each avatar. Only varchar2 data types are supported.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783153157573189645)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>9
,p_display_sequence=>90
,p_static_id=>'AVATAR_ICON'
,p_prompt=>'Icon'
,p_attribute_type=>'ICON'
,p_is_required=>true
,p_default_value=>'fa-user'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783150789422189644)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'icon'
,p_attribute_group_id=>wwv_flow_imp.id(22583034566758221359)
,p_help_text=>'Enter an icon class or use the Pick Icon dialog to select the icon you want to add to display in the avatar.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783153476663189645)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>10
,p_display_sequence=>100
,p_static_id=>'AVATAR_SHAPE'
,p_prompt=>'Shape'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'t-Avatar--rounded'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783155355929189646)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22583034566758221359)
,p_help_text=>'Select the shape of the avatar. Default inherits the shape set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783153851046189646)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783153476663189645)
,p_display_sequence=>10
,p_display_value=>'Rounded'
,p_return_value=>'t-Avatar--rounded'
,p_help_text=>'Displayed within a square with rounded corners.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783154215549189646)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783153476663189645)
,p_display_sequence=>20
,p_display_value=>'Circular'
,p_return_value=>'t-Avatar--circle'
,p_help_text=>'Displayed within a circular shape.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783154638918189646)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783153476663189645)
,p_display_sequence=>30
,p_display_value=>'Square'
,p_return_value=>'t-Avatar--square'
,p_help_text=>'Displayed within a square shape.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783154957022189646)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783153476663189645)
,p_display_sequence=>40
,p_display_value=>'No Shape'
,p_return_value=>'t-Avatar--noShape'
,p_help_text=>'Displayed inline without a containing shape.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783155355929189646)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>11
,p_display_sequence=>110
,p_static_id=>'DISPLAY_AVATAR'
,p_prompt=>'Display Avatar'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'Y'
,p_demo_value=>'Y'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to display or hide the avatar for each row. When set to Yes, an avatar will be displayed with the assigned image, icon, or initials. When set to No, no avatar will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783155652439189646)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'REPORT'
,p_attribute_sequence=>12
,p_display_sequence=>120
,p_static_id=>'STYLE'
,p_prompt=>'Style'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'t-Comments--basic'
,p_demo_value=>'t-Comments--chat'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_lov_type=>'STATIC'
,p_help_text=>'Set the style of the comments.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783156028129189646)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783155652439189646)
,p_display_sequence=>10
,p_display_value=>'Basic'
,p_return_value=>'t-Comments--basic'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783156447146189647)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783155652439189646)
,p_display_sequence=>20
,p_display_value=>'Chat (Speech Bubbles)'
,p_return_value=>'t-Comments--chat'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783156818684189647)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_attribute_scope=>'REPORT'
,p_attribute_sequence=>13
,p_display_sequence=>130
,p_static_id=>'APPLY_THEME_COLORS'
,p_prompt=>'Apply Theme Colors'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'Y'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to use the Universal Theme colors for avatar and badge row items. When set to Yes, the u-colors class will be applied to each row. When set to No, a default color will be used instead.'
);
wwv_flow_imp_shared.create_plugin_act_template(
p_id=>wwv_flow_imp.id(22583167234191322862)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_name=>'Link'
,p_type=>'BUTTON'
,p_template=>'{if !IS_DISABLED/}#LABEL!RAW#{endif/}'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22583166642686315405)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_name=>'Actions'
,p_static_id=>'ACTIONS'
,p_display_sequence=>10
,p_type=>'TEMPLATE'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22583222266356297284)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_name=>'Avatar Link'
,p_static_id=>'AVATAR_LINK'
,p_display_sequence=>20
,p_type=>'LINK'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22583374484069168055)
,p_plugin_id=>wwv_flow_imp.id(20783149133832189643)
,p_name=>'User Name Link'
,p_static_id=>'USER_NAME_LINK'
,p_display_sequence=>30
,p_type=>'LINK'
);
end;
/
prompt --application/shared_components/plugins/template_component/theme_42_content_row
begin
wwv_flow_imp_shared.create_plugin(
p_id=>wwv_flow_imp.id(20783159137806189649)
,p_plugin_type=>'TEMPLATE COMPONENT'
,p_theme_id=>nvl(wwv_flow_application_install.get_theme_id, '42')
,p_name=>'THEME_42$CONTENT_ROW'
,p_display_name=>'Content Row'
,p_supported_component_types=>'PARTIAL:REPORT'
,p_image_prefix => nvl(wwv_flow_application_install.get_static_plugin_file_prefix('TEMPLATE COMPONENT','THEME_42$CONTENT_ROW'),'')
,p_partial_template=>wwv_flow_string.join(wwv_flow_t_varchar2(
'{if APEX$IS_LAZY_LOADING/}',
'
'
,p_report_placeholder_count=>3
,p_substitute_attributes=>true
,p_reference_id=>1568468153344837456
,p_subscribe_plugin_settings=>true
,p_is_quick_pick=>true
,p_help_text=>'Display content in a formatted row with a title, description, and more. Supports avatars and badges. Available for a single row or as a report with multiple rows.'
);
wwv_flow_imp_shared.create_plugin_attr_group(
p_id=>wwv_flow_imp.id(22710396889158261344)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_title=>'Avatar'
,p_display_sequence=>10
);
wwv_flow_imp_shared.create_plugin_attr_group(
p_id=>wwv_flow_imp.id(22710396334146261343)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_title=>'Badge'
,p_display_sequence=>20
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783159820016189649)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>1
,p_display_sequence=>10
,p_static_id=>'OVERLINE'
,p_prompt=>'Overline'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_demo_value=>'Category'
,p_escape_mode=>'RAW'
,p_is_translatable=>true
,p_help_text=>'Enter some text and/or column substitution strings to display at the top of each row above the title and description.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783160119071189649)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>2
,p_display_sequence=>20
,p_static_id=>'TITLE'
,p_prompt=>'Title'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_demo_value=>'Lorem ipsum dolor sit amet'
,p_escape_mode=>'RAW'
,p_is_translatable=>true
,p_help_text=>'Enter some text and/or column substitution strings to be used as the title in each row.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783160409713189649)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>3
,p_display_sequence=>30
,p_static_id=>'DESCRIPTION'
,p_prompt=>'Description'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_demo_value=>'Nunc sit amet nunc quis magna ornare suscipit. Etiam aliquet maximus sapien, at sagittis sem gravida nec.'
,p_escape_mode=>'RAW'
,p_is_translatable=>true
,p_help_text=>'Enter some text and/or column substitution strings to be used as the description in each row.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783160718016189649)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>4
,p_display_sequence=>40
,p_static_id=>'MISC'
,p_prompt=>'Miscellaneous'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_escape_mode=>'RAW'
,p_is_translatable=>true
,p_help_text=>'Enter miscellaneous content such as additional text and/or column substitution strings to display in each row.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783160954830189650)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>5
,p_display_sequence=>50
,p_static_id=>'DISPLAY_AVATAR'
,p_prompt=>'Display Avatar'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to display or hide the avatar for each row. When set to Yes, an avatar will be displayed with the assigned image, icon, or initials. When set to No, no avatar will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783161338162189650)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>6
,p_display_sequence=>60
,p_static_id=>'DISPLAY_BADGE'
,p_prompt=>'Display Badge'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to display or hide the badge for each row. When set to Yes, a badge will be displayed in each row. When set to No, no badge will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783161581414189650)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>7
,p_display_sequence=>70
,p_static_id=>'AVATAR_TYPE'
,p_prompt=>'Type'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'icon'
,p_demo_value=>'icon'
,p_escape_mode=>'HTML'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783160954830189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22710396889158261344)
,p_help_text=>'Select the type of content that will be displayed in the avatar.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783161871674189650)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783161581414189650)
,p_display_sequence=>10
,p_display_value=>'Image'
,p_return_value=>'image'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783162297801189650)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783161581414189650)
,p_display_sequence=>20
,p_display_value=>'Initials'
,p_return_value=>'initials'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783162718291189650)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783161581414189650)
,p_display_sequence=>30
,p_display_value=>'Icon'
,p_return_value=>'icon'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783163071704189650)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>8
,p_display_sequence=>80
,p_static_id=>'AVATAR_IMAGE'
,p_prompt=>'Image'
,p_attribute_type=>'MEDIA'
,p_is_required=>true
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161581414189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'image'
,p_attribute_group_id=>wwv_flow_imp.id(22710396889158261344)
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'
Use the Media popup dialog to select a source for the avatar image.
',
'',
'
Available options include:',
'
',
'
URL
',
'
BLOB Column
',
'
URL Column
',
'
',
''))
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783163371099189651)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>9
,p_display_sequence=>90
,p_static_id=>'AVATAR_IMAGE_ALT'
,p_prompt=>'Image Description'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>true
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783163071704189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'NOT_NULL'
,p_attribute_group_id=>wwv_flow_imp.id(22710396889158261344)
,p_help_text=>'Enter a short description of the image or select a source column from the quick pick options. This will be used as alt text for the avatar image.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783163702662189651)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>10
,p_display_sequence=>100
,p_static_id=>'AVATAR_INITIALS'
,p_prompt=>'Initials'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_escape_mode=>'STRIPHTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161581414189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'initials'
,p_attribute_group_id=>wwv_flow_imp.id(22710396889158261344)
,p_help_text=>'Select the source column to be displayed within each avatar. Only varchar2 data types are supported.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783163960003189651)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>11
,p_display_sequence=>110
,p_static_id=>'AVATAR_ICON'
,p_prompt=>'Icon'
,p_attribute_type=>'ICON'
,p_is_required=>true
,p_default_value=>'fa-user'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161581414189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'icon'
,p_attribute_group_id=>wwv_flow_imp.id(22710396889158261344)
,p_help_text=>'Enter an icon class or use the Pick Icon dialog to select the icon you want to add to display in the avatar.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783164282969189651)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>12
,p_display_sequence=>120
,p_static_id=>'AVATAR_SHAPE'
,p_prompt=>'Shape'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'t-Avatar--rounded'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783160954830189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22710396889158261344)
,p_help_text=>'Select the shape of the avatar. Default inherits the shape set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783164614411189651)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783164282969189651)
,p_display_sequence=>10
,p_display_value=>'Rounded'
,p_return_value=>'t-Avatar--rounded'
,p_help_text=>'Displayed within a square with rounded corners.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783165017970189651)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783164282969189651)
,p_display_sequence=>20
,p_display_value=>'Circular'
,p_return_value=>'t-Avatar--circle'
,p_help_text=>'Displayed within a circular shape.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783165425239189651)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783164282969189651)
,p_display_sequence=>30
,p_display_value=>'Square'
,p_return_value=>'t-Avatar--square'
,p_help_text=>'Displayed within a square shape.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783165839873189652)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783164282969189651)
,p_display_sequence=>40
,p_display_value=>'No Shape'
,p_return_value=>'t-Avatar--noShape'
,p_help_text=>'Displayed inline without a containing shape.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783166193340189652)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>13
,p_display_sequence=>130
,p_static_id=>'BADGE_LABEL'
,p_prompt=>'Label'
,p_attribute_type=>'TEXT'
,p_is_required=>true
,p_escape_mode=>'HTML'
,p_is_translatable=>true
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_help_text=>'Enter a value for the badge label or select a source column from the quick pick options.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783166530519189652)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>14
,p_display_sequence=>140
,p_static_id=>'BADGE_VALUE'
,p_prompt=>'Value'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_escape_mode=>'ATTR'
,p_column_data_types=>'VARCHAR2:NUMBER:DATE:INTERVAL_Y2M:INTERVAL_D2S'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_help_text=>'Select a source column for the badge value.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783166843727189652)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>15
,p_display_sequence=>150
,p_static_id=>'BADGE_STATE'
,p_prompt=>'State'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_help_text=>'Select the source column for the state of the badge. Substitute column value with "danger", "warning", "success" or "info" for default styling.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783167130208189652)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>16
,p_display_sequence=>160
,p_static_id=>'BADGE_ICON'
,p_prompt=>'Icon'
,p_attribute_type=>'ICON'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_help_text=>'Enter an icon class or use the Pick Icon dialog to select the icon you want to add to display in the badge.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783167370842189653)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>17
,p_display_sequence=>170
,p_static_id=>'BADGE_LABEL_DISPLAY'
,p_prompt=>'Display Label'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_help_text=>'Specify whether to display or hide the badge label. When set to Yes, the badge label will be displayed in addition to the badge value. When set to No, only the badge value will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783167680312189653)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>18
,p_display_sequence=>180
,p_static_id=>'BADGE_STYLE'
,p_prompt=>'Style'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_null_text=>'Default'
,p_help_text=>'Select the badge style. Default inherits the style set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783167976994189653)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783167680312189653)
,p_display_sequence=>10
,p_display_value=>'Subtle'
,p_return_value=>'t-Badge--subtle'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783168413637189653)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783167680312189653)
,p_display_sequence=>20
,p_display_value=>'Outline'
,p_return_value=>'t-Badge--outline'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783168768816189653)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>19
,p_display_sequence=>190
,p_static_id=>'BADGE_SHAPE'
,p_prompt=>'Shape'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'HTML'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_null_text=>'Default'
,p_help_text=>'Select the shape of the badge. Default inherits the shape set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783169112471189653)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783168768816189653)
,p_display_sequence=>10
,p_display_value=>'Rounded'
,p_return_value=>'t-Badge--rounded'
,p_help_text=>'Displayed with rounded corners.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783169494338189653)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783168768816189653)
,p_display_sequence=>20
,p_display_value=>'Circular'
,p_return_value=>'t-Badge--circle'
,p_help_text=>'Displayed with circular edges.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783169882136189654)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783168768816189653)
,p_display_sequence=>30
,p_display_value=>'Square'
,p_return_value=>'t-Badge--square'
,p_help_text=>'Displayed with squared edges.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783170317182189654)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>20
,p_display_sequence=>200
,p_static_id=>'AVATAR_SIZE'
,p_prompt=>'Size'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783160954830189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22710396889158261344)
,p_null_text=>'Default'
,p_help_text=>'Set the size of the avatar. The default inherits the sizing set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783170564854189654)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783170317182189654)
,p_display_sequence=>10
,p_display_value=>'Extra Extra Small'
,p_return_value=>'t-Avatar--xxs'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783171006660189654)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783170317182189654)
,p_display_sequence=>20
,p_display_value=>'Extra Small'
,p_return_value=>'t-Avatar--xs'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783171412536189654)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783170317182189654)
,p_display_sequence=>30
,p_display_value=>'Small'
,p_return_value=>'t-Avatar--sm'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783171767329189654)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783170317182189654)
,p_display_sequence=>40
,p_display_value=>'Medium'
,p_return_value=>'t-Avatar--md'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783172230444189654)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783170317182189654)
,p_display_sequence=>50
,p_display_value=>'Large'
,p_return_value=>'t-Avatar--lg'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783172649055189655)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783170317182189654)
,p_display_sequence=>60
,p_display_value=>'Extra Large'
,p_return_value=>'t-Avatar--xl'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783173048016189655)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783170317182189654)
,p_display_sequence=>70
,p_display_value=>'Extra Extra Large'
,p_return_value=>'t-Avatar--xxl'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783173428695189655)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>21
,p_display_sequence=>210
,p_static_id=>'BADGE_SIZE'
,p_prompt=>'Size'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_null_text=>'Default'
,p_help_text=>'Set the size of the badge. The default inherits the sizing set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783173696750189655)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783173428695189655)
,p_display_sequence=>10
,p_display_value=>'Small'
,p_return_value=>'t-Badge--sm'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783174095342189655)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783173428695189655)
,p_display_sequence=>20
,p_display_value=>'Medium'
,p_return_value=>'t-Badge--md'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783174494786189655)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783173428695189655)
,p_display_sequence=>30
,p_display_value=>'Large'
,p_return_value=>'t-Badge--lg'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783174914295189656)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>22
,p_display_sequence=>220
,p_static_id=>'BADGE_COL_WIDTH'
,p_prompt=>'Column Width'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'t-ContentRow-badge--md'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783161338162189650)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22710396334146261343)
,p_null_text=>'Default'
,p_help_text=>'Set the width of the content row columns. Default width is medium.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783175211669189656)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783174914295189656)
,p_display_sequence=>10
,p_display_value=>'Small'
,p_return_value=>'t-ContentRow-badge--sm'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783175621080189656)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783174914295189656)
,p_display_sequence=>20
,p_display_value=>'Medium'
,p_return_value=>'t-ContentRow-badge--md'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783175981180189656)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783174914295189656)
,p_display_sequence=>30
,p_display_value=>'Large'
,p_return_value=>'t-ContentRow-badge--lg'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783176361726189656)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783174914295189656)
,p_display_sequence=>40
,p_display_value=>'Auto'
,p_return_value=>'t-ContentRow-badge--auto'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783176800634189656)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_attribute_scope=>'REPORT'
,p_attribute_sequence=>23
,p_display_sequence=>230
,p_static_id=>'APPLY_THEME_COLORS'
,p_prompt=>'Apply Theme Colors'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'Y'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to use the Universal Theme colors for avatar and badge row items. When set to Yes, the u-colors class will be applied to each row. When set to No, a default color will be used instead.'
);
wwv_flow_imp_shared.create_plugin_act_template(
p_id=>wwv_flow_imp.id(22591610779374082958)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_name=>'Button'
,p_type=>'BUTTON'
,p_template=>wwv_flow_string.join(wwv_flow_t_varchar2(
'{with/}',
'LINK_URL:=#LINK_URL#',
'LINK_ATTR:=#LINK_ATTR!RAW#',
'LABEL:=#LABEL!RAW#',
'ICON_CLASSES:=#ICON_CLASSES#',
'CSS_CLASSES:=#CSS_CLASSES#',
'IS_HOT:=#IS_HOT#',
'IS_ICON_ONLY:=#IS_ICON_ONLY#',
'IS_DISABLED:=#IS_DISABLED#',
'{apply THEME$BUTTON/}'))
);
wwv_flow_imp_shared.create_plugin_act_template(
p_id=>wwv_flow_imp.id(22591612038894087106)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_name=>'Menu'
,p_type=>'MENU'
,p_template=>wwv_flow_string.join(wwv_flow_t_varchar2(
'{with/}',
'MENU_ID:=#MENU_ID#',
'LABEL:=#LABEL!RAW#',
'ICON_CLASSES:=#ICON_CLASSES#',
'CSS_CLASSES:=#CSS_CLASSES#',
'IS_HOT:=#IS_HOT#',
'IS_DISABLED:=#IS_DISABLED#',
'IS_ICON_ONLY:=#IS_ICON_ONLY#',
'{apply THEME$BUTTON/}',
'#MENU#'))
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22578017150699676225)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_name=>'Title Link'
,p_static_id=>'TITLE_LINK'
,p_display_sequence=>30
,p_type=>'LINK'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22578696451429759329)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_name=>'Full Row Link'
,p_static_id=>'FULL_ROW_LINK'
,p_display_sequence=>40
,p_type=>'LINK'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22591608844307037972)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_name=>'Avatar Link'
,p_static_id=>'AVATAR_LINK'
,p_display_sequence=>10
,p_type=>'LINK'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22591610177697051829)
,p_plugin_id=>wwv_flow_imp.id(20783159137806189649)
,p_name=>'Primary Actions'
,p_static_id=>'PRIMARY_ACTIONS'
,p_display_sequence=>20
,p_type=>'TEMPLATE'
);
end;
/
prompt --application/shared_components/plugins/template_component/theme_42_media_list
begin
wwv_flow_imp_shared.create_plugin(
p_id=>wwv_flow_imp.id(20783181639281189659)
,p_plugin_type=>'TEMPLATE COMPONENT'
,p_theme_id=>nvl(wwv_flow_application_install.get_theme_id, '42')
,p_name=>'THEME_42$MEDIA_LIST'
,p_display_name=>'Media List'
,p_supported_component_types=>'PARTIAL:REPORT'
,p_image_prefix => nvl(wwv_flow_application_install.get_static_plugin_file_prefix('TEMPLATE COMPONENT','THEME_42$MEDIA_LIST'),'')
,p_partial_template=>wwv_flow_string.join(wwv_flow_t_varchar2(
'{if APEX$IS_LAZY_LOADING/}',
'
'
,p_report_placeholder_count=>3
,p_substitute_attributes=>true
,p_reference_id=>1564403634518414297
,p_subscribe_plugin_settings=>true
,p_is_quick_pick=>true
,p_help_text=>'Display report content in a formatted media list. Supports avatars and badges. Available for a single row or as a report with multiple rows.'
);
wwv_flow_imp_shared.create_plugin_attr_group(
p_id=>wwv_flow_imp.id(22583199429384073308)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_title=>'Badge'
,p_display_sequence=>20
);
wwv_flow_imp_shared.create_plugin_attr_group(
p_id=>wwv_flow_imp.id(22583199984396073309)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_title=>'Avatar'
,p_display_sequence=>10
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783182299431189660)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>1
,p_display_sequence=>10
,p_static_id=>'TITLE'
,p_prompt=>'Title'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_demo_value=>'Lorem ipsum dolor sit amet'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_help_text=>'Select a source column to be used as the title.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783182586282189660)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>2
,p_display_sequence=>20
,p_static_id=>'DESCRIPTION'
,p_prompt=>'Description'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>false
,p_demo_value=>'Nunc sit amet nunc quis magna ornare suscipit. Etiam aliquet maximus sapien, at sagittis sem gravida nec.'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_help_text=>'Select a source column to be used for the row description.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783182852780189660)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>3
,p_display_sequence=>30
,p_static_id=>'DISPLAY_AVATAR'
,p_prompt=>'Display Avatar'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to display or hide the avatar for each row. When set to Yes, an avatar will be displayed with the assigned image, icon, or initials. When set to No, no avatar will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783183211839189660)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>4
,p_display_sequence=>40
,p_static_id=>'DISPLAY_BADGE'
,p_prompt=>'Display Badge'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to display or hide the badge for each row. When set to Yes, a badge will be displayed in each row. When set to No, no badge will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783183452781189660)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>5
,p_display_sequence=>50
,p_static_id=>'AVATAR_TYPE'
,p_prompt=>'Type'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'icon'
,p_demo_value=>'icon'
,p_escape_mode=>'HTML'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783182852780189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22583199984396073309)
,p_help_text=>'Select the type of content that will be displayed in the avatar.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783183777303189661)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783183452781189660)
,p_display_sequence=>10
,p_display_value=>'Image'
,p_return_value=>'image'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783184230618189661)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783183452781189660)
,p_display_sequence=>20
,p_display_value=>'Initials'
,p_return_value=>'initials'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783184597529189661)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783183452781189660)
,p_display_sequence=>30
,p_display_value=>'Icon'
,p_return_value=>'icon'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783184958739189661)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>6
,p_display_sequence=>60
,p_static_id=>'AVATAR_IMAGE'
,p_prompt=>'Image'
,p_attribute_type=>'MEDIA'
,p_is_required=>true
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183452781189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'image'
,p_attribute_group_id=>wwv_flow_imp.id(22583199984396073309)
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'
Use the Media popup dialog to select a source for the avatar image.
',
'',
'
Available options include:',
'
',
'
URL
',
'
BLOB Column
',
'
URL Column
',
'
',
''))
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783185282735189661)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>7
,p_display_sequence=>70
,p_static_id=>'AVATAR_IMAGE_ALT'
,p_prompt=>'Image Description'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>true
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783184958739189661)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'NOT_NULL'
,p_attribute_group_id=>wwv_flow_imp.id(22583199984396073309)
,p_help_text=>'Enter a short description of the image or select a source column from the quick pick options. This will be used as alt text for the avatar image.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783185628394189662)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>8
,p_display_sequence=>80
,p_static_id=>'AVATAR_INITIALS'
,p_prompt=>'Initials'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_escape_mode=>'STRIPHTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183452781189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'initials'
,p_attribute_group_id=>wwv_flow_imp.id(22583199984396073309)
,p_help_text=>'Select the source column to be displayed within each avatar. Only varchar2 data types are supported.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783185855292189662)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>9
,p_display_sequence=>90
,p_static_id=>'AVATAR_ICON'
,p_prompt=>'Icon'
,p_attribute_type=>'ICON'
,p_is_required=>true
,p_default_value=>'fa-user'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183452781189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'icon'
,p_attribute_group_id=>wwv_flow_imp.id(22583199984396073309)
,p_help_text=>'Enter an icon class or use the Pick Icon dialog to select the icon you want to add to display in the avatar.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783186200133189662)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>10
,p_display_sequence=>100
,p_static_id=>'AVATAR_SHAPE'
,p_prompt=>'Shape'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'t-Avatar--rounded'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783182852780189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22583199984396073309)
,p_help_text=>'Select the shape of the avatar. Default inherits the shape set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783186550436189662)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783186200133189662)
,p_display_sequence=>10
,p_display_value=>'Rounded'
,p_return_value=>'t-Avatar--rounded'
,p_help_text=>'Displayed within a square with rounded corners.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783186862596189662)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783186200133189662)
,p_display_sequence=>20
,p_display_value=>'Circular'
,p_return_value=>'t-Avatar--circle'
,p_help_text=>'Displayed within a circular shape.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783187337418189662)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783186200133189662)
,p_display_sequence=>30
,p_display_value=>'Square'
,p_return_value=>'t-Avatar--square'
,p_help_text=>'Displayed within a square shape.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783187654243189662)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783186200133189662)
,p_display_sequence=>40
,p_display_value=>'No Shape'
,p_return_value=>'t-Avatar--noShape'
,p_help_text=>'Displayed inline without a containing shape.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783188068131189663)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>11
,p_display_sequence=>110
,p_static_id=>'BADGE_LABEL'
,p_prompt=>'Label'
,p_attribute_type=>'TEXT'
,p_is_required=>true
,p_escape_mode=>'HTML'
,p_is_translatable=>true
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183211839189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22583199429384073308)
,p_help_text=>'Enter a value for the badge label or select a source column from the quick pick options.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783188352197189663)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>12
,p_display_sequence=>120
,p_static_id=>'BADGE_VALUE'
,p_prompt=>'Value'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_escape_mode=>'ATTR'
,p_column_data_types=>'VARCHAR2:NUMBER:DATE:INTERVAL_Y2M:INTERVAL_D2S'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183211839189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22583199429384073308)
,p_help_text=>'Select a source column for the badge value.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783188744544189663)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>13
,p_display_sequence=>130
,p_static_id=>'BADGE_STATE'
,p_prompt=>'State'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183211839189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22583199429384073308)
,p_help_text=>'Select the source column for the state of the badge. Substitute column value with "danger", "warning", "success" or "info" for default styling.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783189039742189663)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>14
,p_display_sequence=>140
,p_static_id=>'BADGE_ICON'
,p_prompt=>'Icon'
,p_attribute_type=>'ICON'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183211839189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22583199429384073308)
,p_help_text=>'Enter an icon class or use the Pick Icon dialog to select the icon you want to add to display in the badge.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783189305065189663)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>15
,p_display_sequence=>150
,p_static_id=>'BADGE_LABEL_DISPLAY'
,p_prompt=>'Display Label'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183211839189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22583199429384073308)
,p_help_text=>'Specify whether to display or hide the badge label. When set to Yes, the badge label will be displayed in addition to the badge value. When set to No, only the badge value will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783189624629189663)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>16
,p_display_sequence=>160
,p_static_id=>'BADGE_STYLE'
,p_prompt=>'Style'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183211839189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22583199429384073308)
,p_null_text=>'Default'
,p_help_text=>'Select the badge style. Default inherits the style set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783189889823189663)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783189624629189663)
,p_display_sequence=>10
,p_display_value=>'Subtle'
,p_return_value=>'t-Badge--subtle'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783190278082189664)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783189624629189663)
,p_display_sequence=>20
,p_display_value=>'Outline'
,p_return_value=>'t-Badge--outline'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783190692748189664)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>17
,p_display_sequence=>170
,p_static_id=>'BADGE_SHAPE'
,p_prompt=>'Shape'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'HTML'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783183211839189660)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22583199429384073308)
,p_null_text=>'Default'
,p_help_text=>'Select the shape of the badge. Default inherits the shape set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783190992398189664)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783190692748189664)
,p_display_sequence=>10
,p_display_value=>'Rounded'
,p_return_value=>'t-Badge--rounded'
,p_help_text=>'Displayed with rounded corners.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783191391273189664)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783190692748189664)
,p_display_sequence=>20
,p_display_value=>'Circular'
,p_return_value=>'t-Badge--circle'
,p_help_text=>'Displayed with circular edges.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783191760961189664)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783190692748189664)
,p_display_sequence=>30
,p_display_value=>'Square'
,p_return_value=>'t-Badge--square'
,p_help_text=>'Displayed with squared edges.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783192187414189664)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'REPORT'
,p_attribute_sequence=>18
,p_display_sequence=>180
,p_static_id=>'LAYOUT'
,p_prompt=>'Layout'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_lov_type=>'STATIC'
,p_null_text=>'Default'
,p_help_text=>'Select the number of grid columns the media list content will display in. Horizontal Span will display all columns in a single horizontal row.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783192512777189664)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783192187414189664)
,p_display_sequence=>10
,p_display_value=>'2 Column Grid'
,p_return_value=>'t-MediaList--cols t-MediaList--2cols'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783192937539189665)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783192187414189664)
,p_display_sequence=>20
,p_display_value=>'3 Column Grid'
,p_return_value=>'t-MediaList--cols t-MediaList--3cols'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783193345968189665)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783192187414189664)
,p_display_sequence=>30
,p_display_value=>'4 Column Grid'
,p_return_value=>'t-MediaList--cols t-MediaList--4cols'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783193688182189665)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783192187414189664)
,p_display_sequence=>40
,p_display_value=>'5 Column Grid'
,p_return_value=>'t-MediaList--cols t-MediaList--5cols'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783194138852189665)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783192187414189664)
,p_display_sequence=>50
,p_display_value=>'Horizontal Span'
,p_return_value=>'t-MediaList--horizontal'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783194499721189665)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'REPORT'
,p_attribute_sequence=>19
,p_display_sequence=>190
,p_static_id=>'SIZE'
,p_prompt=>'Size'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'HTML'
,p_is_translatable=>false
,p_lov_type=>'STATIC'
,p_null_text=>'Default'
,p_help_text=>'Set the size of media list items.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783194799905189666)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783194499721189665)
,p_display_sequence=>10
,p_display_value=>'Large'
,p_return_value=>'t-MediaList--large force-fa-lg'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783195167040189666)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_attribute_scope=>'REPORT'
,p_attribute_sequence=>20
,p_display_sequence=>200
,p_static_id=>'APPLY_THEME_COLORS'
,p_prompt=>'Apply Theme Colors'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'Y'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to use the Universal Theme colors for avatar and badge row items. When set to Yes, the u-colors class will be applied to each row. When set to No, a default color will be used instead.'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22583403036553219937)
,p_plugin_id=>wwv_flow_imp.id(20783181639281189659)
,p_name=>'Link'
,p_static_id=>'LINK'
,p_display_sequence=>10
,p_type=>'LINK'
);
end;
/
prompt --application/shared_components/plugins/template_component/theme_42_timeline
begin
wwv_flow_imp_shared.create_plugin(
p_id=>wwv_flow_imp.id(20783198273452189668)
,p_plugin_type=>'TEMPLATE COMPONENT'
,p_theme_id=>nvl(wwv_flow_application_install.get_theme_id, '42')
,p_name=>'THEME_42$TIMELINE'
,p_display_name=>'Timeline'
,p_supported_component_types=>'PARTIAL:REPORT'
,p_image_prefix => nvl(wwv_flow_application_install.get_static_plugin_file_prefix('TEMPLATE COMPONENT','THEME_42$TIMELINE'),'')
,p_partial_template=>wwv_flow_string.join(wwv_flow_t_varchar2(
'
'
,p_report_placeholder_count=>3
,p_substitute_attributes=>true
,p_reference_id=>1601817836543095628
,p_subscribe_plugin_settings=>true
,p_is_quick_pick=>true
,p_help_text=>'Display a series of events. Supports avatars and badges. Available for a single row or as a report with multiple rows.'
);
wwv_flow_imp_shared.create_plugin_attr_group(
p_id=>wwv_flow_imp.id(22930281222221296619)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_title=>'Badge'
,p_display_sequence=>20
);
wwv_flow_imp_shared.create_plugin_attr_group(
p_id=>wwv_flow_imp.id(22930281777233296620)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_title=>'Avatar'
,p_display_sequence=>10
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783198993431189668)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>1
,p_display_sequence=>10
,p_static_id=>'USER_NAME'
,p_prompt=>'User Name'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_demo_value=>'User'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_help_text=>'Select a source column to be displayed as the user name associated with a timeline event.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783199286282189669)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>2
,p_display_sequence=>20
,p_static_id=>'DATE'
,p_prompt=>'Date'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_demo_value=>'1 hour ago'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2:NUMBER:DATE:INTERVAL_Y2M:INTERVAL_D2S'
,p_is_translatable=>false
,p_help_text=>'Select a source column containing a date, date range, or time.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783199644583189669)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>3
,p_display_sequence=>30
,p_static_id=>'TITLE'
,p_prompt=>'Title'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_demo_value=>'Lorem ipsum dolor sit amet'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_help_text=>'Select a source column to be used as the title.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783199907718189669)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>4
,p_display_sequence=>40
,p_static_id=>'DESCRIPTION'
,p_prompt=>'Description'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>false
,p_demo_value=>'Nunc sit amet nunc quis magna ornare suscipit. Etiam aliquet maximus sapien, at sagittis sem gravida nec.'
,p_escape_mode=>'HTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_help_text=>'Select a source column to be used for the row description.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783200245239189669)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>5
,p_display_sequence=>50
,p_static_id=>'DISPLAY_AVATAR'
,p_prompt=>'Display Avatar'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_demo_value=>'Y'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to display or hide the avatar for each row. When set to Yes, an avatar will be displayed with the assigned image, icon, or initials. When set to No, no avatar will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783200489607189669)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>6
,p_display_sequence=>60
,p_static_id=>'DISPLAY_BADGE'
,p_prompt=>'Display Badge'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_demo_value=>'Y'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to display or hide the badge for each row. When set to Yes, a badge will be displayed in each row. When set to No, no badge will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783200759005189669)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>7
,p_display_sequence=>70
,p_static_id=>'AVATAR_TYPE'
,p_prompt=>'Type'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'icon'
,p_demo_value=>'icon'
,p_escape_mode=>'HTML'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200245239189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22930281777233296620)
,p_help_text=>'Select the type of content that will be displayed in the avatar.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783201053108189669)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783200759005189669)
,p_display_sequence=>10
,p_display_value=>'Image'
,p_return_value=>'image'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783201456507189670)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783200759005189669)
,p_display_sequence=>20
,p_display_value=>'Initials'
,p_return_value=>'initials'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783201916091189670)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783200759005189669)
,p_display_sequence=>30
,p_display_value=>'Icon'
,p_return_value=>'icon'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783202261542189670)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>8
,p_display_sequence=>80
,p_static_id=>'AVATAR_IMAGE'
,p_prompt=>'Image'
,p_attribute_type=>'MEDIA'
,p_is_required=>true
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200759005189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'image'
,p_attribute_group_id=>wwv_flow_imp.id(22930281777233296620)
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'
Use the Media popup dialog to select a source for the avatar image.
',
'',
'
Available options include:',
'
',
'
URL
',
'
BLOB Column
',
'
URL Column
',
'
',
''))
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783202631822189670)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>9
,p_display_sequence=>90
,p_static_id=>'AVATAR_IMAGE_ALT'
,p_prompt=>'Image Description'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>true
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783202261542189670)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'NOT_NULL'
,p_attribute_group_id=>wwv_flow_imp.id(22930281777233296620)
,p_help_text=>'Enter a short description of the image or select a source column from the quick pick options. This will be used as alt text for the avatar image.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783202920642189670)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>10
,p_display_sequence=>100
,p_static_id=>'AVATAR_INITIALS'
,p_prompt=>'Initials'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_escape_mode=>'STRIPHTML'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200759005189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'initials'
,p_attribute_group_id=>wwv_flow_imp.id(22930281777233296620)
,p_help_text=>'Select the source column to be displayed within each avatar. Only varchar2 data types are supported.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783203196981189670)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>11
,p_display_sequence=>110
,p_static_id=>'AVATAR_ICON'
,p_prompt=>'Icon'
,p_attribute_type=>'ICON'
,p_is_required=>true
,p_default_value=>'fa-user'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200759005189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'icon'
,p_attribute_group_id=>wwv_flow_imp.id(22930281777233296620)
,p_help_text=>'Enter an icon class or use the Pick Icon dialog to select the icon you want to add to display in the avatar.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783203471609189671)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>12
,p_display_sequence=>120
,p_static_id=>'AVATAR_SHAPE'
,p_prompt=>'Shape'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'t-Avatar--circle'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200245239189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22930281777233296620)
,p_help_text=>'Select the shape of the avatar. Default inherits the shape set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783203838029189671)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783203471609189671)
,p_display_sequence=>10
,p_display_value=>'Rounded'
,p_return_value=>'t-Avatar--rounded'
,p_help_text=>'Displayed within a square with rounded corners.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783204239826189671)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783203471609189671)
,p_display_sequence=>20
,p_display_value=>'Circular'
,p_return_value=>'t-Avatar--circle'
,p_help_text=>'Displayed within a circular shape.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783204627204189671)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783203471609189671)
,p_display_sequence=>30
,p_display_value=>'Square'
,p_return_value=>'t-Avatar--square'
,p_help_text=>'Displayed within a square shape.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783204961324189671)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783203471609189671)
,p_display_sequence=>40
,p_display_value=>'No Shape'
,p_return_value=>'t-Avatar--noShape'
,p_help_text=>'Displayed inline without a containing shape.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783205379096189671)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>13
,p_display_sequence=>130
,p_static_id=>'BADGE_LABEL'
,p_prompt=>'Label'
,p_attribute_type=>'TEXT'
,p_is_required=>true
,p_escape_mode=>'HTML'
,p_is_translatable=>true
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200489607189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22930281222221296619)
,p_help_text=>'Enter a value for the badge label or select a source column from the quick pick options.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783205703180189671)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>14
,p_display_sequence=>140
,p_static_id=>'BADGE_VALUE'
,p_prompt=>'Value'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>true
,p_demo_value=>'Closed'
,p_escape_mode=>'ATTR'
,p_column_data_types=>'VARCHAR2:NUMBER:DATE:INTERVAL_Y2M:INTERVAL_D2S'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200489607189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22930281222221296619)
,p_help_text=>'Select a source column for the badge value.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783206039777189672)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>15
,p_display_sequence=>150
,p_static_id=>'BADGE_STATE'
,p_prompt=>'State'
,p_attribute_type=>'SESSION STATE VALUE'
,p_is_required=>false
,p_demo_value=>'is-removed'
,p_escape_mode=>'ATTR'
,p_column_data_types=>'VARCHAR2'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200489607189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22930281222221296619)
,p_help_text=>'Select the source column for the state of the badge. Substitute column value with "danger", "warning", "success" or "info" for default styling.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783206298702189672)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>16
,p_display_sequence=>160
,p_static_id=>'BADGE_ICON'
,p_prompt=>'Icon'
,p_attribute_type=>'ICON'
,p_is_required=>false
,p_demo_value=>'fa-check-circle-o'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200489607189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22930281222221296619)
,p_help_text=>'Enter an icon class or use the Pick Icon dialog to select the icon you want to add to display in the badge.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783206563133189672)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>17
,p_display_sequence=>170
,p_static_id=>'BADGE_LABEL_DISPLAY'
,p_prompt=>'Display Label'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'N'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200489607189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_attribute_group_id=>wwv_flow_imp.id(22930281222221296619)
,p_help_text=>'Specify whether to display or hide the badge label. When set to Yes, the badge label will be displayed in addition to the badge value. When set to No, only the badge value will be displayed.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783206896743189672)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>18
,p_display_sequence=>180
,p_static_id=>'BADGE_STYLE'
,p_prompt=>'Style'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200489607189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22930281222221296619)
,p_null_text=>'Default'
,p_help_text=>'Select the badge style. Default inherits the style set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783207162688189672)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783206896743189672)
,p_display_sequence=>10
,p_display_value=>'Subtle'
,p_return_value=>'t-Badge--subtle'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783207610848189672)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783206896743189672)
,p_display_sequence=>20
,p_display_value=>'Outline'
,p_return_value=>'t-Badge--outline'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783207988143189672)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>19
,p_display_sequence=>190
,p_static_id=>'BADGE_SHAPE'
,p_prompt=>'Shape'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'HTML'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_imp.id(20783200489607189669)
,p_depending_on_has_to_exist=>true
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'Y'
,p_lov_type=>'STATIC'
,p_attribute_group_id=>wwv_flow_imp.id(22930281222221296619)
,p_null_text=>'Default'
,p_help_text=>'Select the shape of the badge. Default inherits the shape set by the containing template.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783208255306189672)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783207988143189672)
,p_display_sequence=>10
,p_display_value=>'Rounded'
,p_return_value=>'t-Badge--rounded'
,p_help_text=>'Displayed with rounded corners.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783208708564189673)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783207988143189672)
,p_display_sequence=>20
,p_display_value=>'Circular'
,p_return_value=>'t-Badge--circle'
,p_help_text=>'Displayed with circular edges.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783209098050189673)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783207988143189672)
,p_display_sequence=>30
,p_display_value=>'Square'
,p_return_value=>'t-Badge--square'
,p_help_text=>'Displayed with squared edges.'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783209455922189673)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'REPORT'
,p_attribute_sequence=>20
,p_display_sequence=>200
,p_static_id=>'STYLE'
,p_prompt=>'Style'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_lov_type=>'STATIC'
,p_null_text=>'Default'
,p_help_text=>'Set the style of timeline items.'
);
wwv_flow_imp_shared.create_plugin_attr_value(
p_id=>wwv_flow_imp.id(20783209847838189673)
,p_plugin_attribute_id=>wwv_flow_imp.id(20783209455922189673)
,p_display_sequence=>10
,p_display_value=>'Compact'
,p_return_value=>'t-Timeline--compact'
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(20783210239376189673)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_attribute_scope=>'REPORT'
,p_attribute_sequence=>21
,p_display_sequence=>210
,p_static_id=>'APPLY_THEME_COLORS'
,p_prompt=>'Apply Theme Colors'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'Y'
,p_demo_value=>'Y'
,p_escape_mode=>'ATTR'
,p_is_translatable=>false
,p_help_text=>'Specify whether to use the Universal Theme colors for avatar and badge row items. When set to Yes, the u-colors class will be applied to each row. When set to No, a default color will be used instead.'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22578051122419505206)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_name=>'Title Link'
,p_static_id=>'TITLE_LINK'
,p_display_sequence=>25
,p_type=>'LINK'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22692462485407768807)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_name=>'User Name Link'
,p_static_id=>'USER_NAME_LINK'
,p_display_sequence=>15
,p_type=>'LINK'
);
wwv_flow_imp_shared.create_plugin_act_position(
p_id=>wwv_flow_imp.id(22811493732382073248)
,p_plugin_id=>wwv_flow_imp.id(20783198273452189668)
,p_name=>'Avatar Link'
,p_static_id=>'AVATAR_LINK'
,p_display_sequence=>10
,p_type=>'LINK'
);
end;
/
prompt --application/user_interfaces/combined_files
begin
null;
end;
/
prompt --application/pages/page_00000
begin
wwv_flow_imp_page.create_page(
p_id=>0
,p_name=>'Global Page'
,p_step_title=>'Global Page'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'D'
,p_page_component_map=>'14'
,p_last_updated_by=>'DARKOANDR@YAHOO.COM'
,p_last_upd_yyyymmddhh24miss=>'20230509073853'
);
end;
/
prompt --application/pages/page_00001
begin
wwv_flow_imp_page.create_page(
p_id=>1
,p_name=>'Home'
,p_alias=>'HOME'
,p_step_title=>'Ch14v8'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_page_component_map=>'13'
,p_last_updated_by=>'DARKOANDR@YAHOO.COM'
,p_last_upd_yyyymmddhh24miss=>'20230509073858'
);
wwv_flow_imp_page.create_page_plug(
p_id=>wwv_flow_imp.id(20783250724940189701)
,p_plug_name=>'Ch14v8'
,p_region_template_options=>'#DEFAULT#'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_imp.id(20782222929393189585)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_plug_query_num_rows=>15
,p_region_image=>'#APP_FILES#icons/app-icon-512.png'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
,p_attribute_03=>'Y'
);
wwv_flow_imp_page.create_page_plug(
p_id=>wwv_flow_imp.id(20783356406480190195)
,p_plug_name=>'Page Navigation'
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#:u-colors:t-Cards--featured t-Cards--block force-fa-lg:t-Cards--displayIcons:t-Cards--4cols:t-Cards--hideBody:t-Cards--animColorFill'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_imp.id(20782189568456189571)
,p_plug_display_sequence=>30
,p_list_id=>wwv_flow_imp.id(20783355329600190194)
,p_plug_source_type=>'NATIVE_LIST'
,p_list_template_id=>wwv_flow_imp.id(20783105310992189619)
,p_plug_query_num_rows=>15
);
end;
/
prompt --application/pages/page_00002
begin
wwv_flow_imp_page.create_page(
p_id=>2
,p_name=>'Type Of Plant'
,p_alias=>'TYPE-OF-PLANT1'
,p_step_title=>'Type Of Plant'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'
To find data enter a search term into the search dialog, or click on the column headings to limit the records returned.
',
'',
'
You can perform numerous functions by clicking the Actions button. This includes selecting the columns that are displayed / hidden and their display sequence, plus numerous data and format functions. You can also define additiona'
||'l views of the data using the chart, group by, and pivot options.
',
'',
'
If you want to save your customizations select report, or click download to unload the data. Enter you email address and time frame under subscription to be sent the data on a regular basis.
',
'',
'
For additional information click Help at the bottom of the Actions menu.
',
'',
'
Click the Reset button to reset the interactive report back to the default settings.
To find data enter a search term into the search dialog, or click on the column headings to limit the records returned.
',
'',
'
You can perform numerous functions by clicking the Actions button. This includes selecting the columns that are displayed / hidden and their display sequence, plus numerous data and format functions. You can also define additiona'
||'l views of the data using the chart, group by, and pivot options.
',
'',
'
If you want to save your customizations select report, or click download to unload the data. Enter you email address and time frame under subscription to be sent the data on a regular basis.
',
'',
'
For additional information click Help at the bottom of the Actions menu.
',
'',
'
Click the Reset button to reset the interactive report back to the default settings.
'))
,p_page_component_map=>'18'
,p_last_updated_by=>'DARKOANDR@YAHOO.COM'
,p_last_upd_yyyymmddhh24miss=>'20230509073858'
);
wwv_flow_imp_page.create_page_plug(
p_id=>wwv_flow_imp.id(20783324605358190140)
,p_plug_name=>'Plants'
,p_region_template_options=>'#DEFAULT#'
,p_plug_display_sequence=>10
,p_query_type=>'SQL'
,p_plug_source=>'select "ID","CH14_PLANT_TYPE_ID","NAMES_LOCAL","NAMES_ENGLISH","NAME_LATIN","DESCRIPTION","HABITAT","CULTIVATION","USE",sys.dbms_lob.getlength("PHOTO")"PHOTO","HYPERLINKS","STATUS"from "CH14_PLANTS"'
,p_plug_source_type=>'NATIVE_IR'
,p_prn_page_header=>'Plants'
);
wwv_flow_imp_page.create_worksheet(
p_id=>wwv_flow_imp.id(20783324716670190140)
,p_name=>'Plants'
,p_max_row_count_message=>'The maximum row count for this report is #MAX_ROW_COUNT# rows. Please apply a filter to reduce the number of records in your query.'
,p_no_data_found_message=>'No data found.'
,p_base_pk1=>'ID'
,p_pagination_type=>'ROWS_X_TO_Y'
,p_pagination_display_pos=>'BOTTOM_RIGHT'
,p_report_list_mode=>'TABS'
,p_lazy_loading=>false
,p_show_detail_link=>'C'
,p_show_notify=>'Y'
,p_download_formats=>'CSV:HTML:XLSX:PDF'
,p_enable_mail_download=>'Y'
,p_detail_link=>'f?p=&APP_ID.:5:&APP_SESSION.::&DEBUG.:RP:P5_ID:\#ID#\'
,p_detail_link_text=>''
,p_owner=>'DARKOANDR@YAHOO.COM'
,p_internal_uid=>10358236565276761302
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783325202042190141)
,p_db_column_name=>'ID'
,p_display_order=>0
,p_is_primary_key=>'Y'
,p_column_identifier=>'A'
,p_column_label=>'ID'
,p_column_type=>'NUMBER'
,p_display_text_as=>'HIDDEN_ESCAPE_SC'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783325565609190142)
,p_db_column_name=>'CH14_PLANT_TYPE_ID'
,p_display_order=>2
,p_column_identifier=>'B'
,p_column_label=>'Ch14 Plant Type'
,p_column_type=>'STRING'
,p_display_text_as=>'LOV_ESCAPE_SC'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_rpt_named_lov=>wwv_flow_imp.id(20783253389636189788)
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783325987018190142)
,p_db_column_name=>'NAMES_LOCAL'
,p_display_order=>3
,p_column_identifier=>'C'
,p_column_label=>'Names Local'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783326448387190142)
,p_db_column_name=>'NAMES_ENGLISH'
,p_display_order=>4
,p_column_identifier=>'D'
,p_column_label=>'Names English'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783326805262190142)
,p_db_column_name=>'NAME_LATIN'
,p_display_order=>5
,p_column_identifier=>'E'
,p_column_label=>'Name Latin'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783327196038190143)
,p_db_column_name=>'DESCRIPTION'
,p_display_order=>6
,p_column_identifier=>'F'
,p_column_label=>'Description'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783327574853190143)
,p_db_column_name=>'HABITAT'
,p_display_order=>7
,p_column_identifier=>'G'
,p_column_label=>'Habitat'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783327959700190143)
,p_db_column_name=>'CULTIVATION'
,p_display_order=>8
,p_column_identifier=>'H'
,p_column_label=>'Cultivation'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783328387112190143)
,p_db_column_name=>'USE'
,p_display_order=>9
,p_column_identifier=>'I'
,p_column_label=>'Use'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783328757172190144)
,p_db_column_name=>'PHOTO'
,p_display_order=>10
,p_column_identifier=>'J'
,p_column_label=>'Photo'
,p_allow_sorting=>'N'
,p_allow_filtering=>'N'
,p_allow_highlighting=>'N'
,p_allow_ctrl_breaks=>'N'
,p_allow_aggregations=>'N'
,p_allow_computations=>'N'
,p_allow_charting=>'N'
,p_allow_group_by=>'N'
,p_allow_pivot=>'N'
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
,p_format_mask=>'DOWNLOAD:CH14_PLANTS:PHOTO:ID::::::attachment::'
,p_tz_dependent=>'N'
,p_rpt_show_filter_lov=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783329239084190144)
,p_db_column_name=>'HYPERLINKS'
,p_display_order=>11
,p_column_identifier=>'K'
,p_column_label=>'Hyperlinks'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
p_id=>wwv_flow_imp.id(20783329554303190144)
,p_db_column_name=>'STATUS'
,p_display_order=>12
,p_column_identifier=>'L'
,p_column_label=>'Status'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_rpt(
p_id=>wwv_flow_imp.id(20783338951433190181)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'103582509'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'CH14_PLANT_TYPE_ID:NAMES_LOCAL:NAMES_ENGLISH:NAME_LATIN:DESCRIPTION:HABITAT:CULTIVATION:USE:PHOTO:HYPERLINKS:STATUS'
,p_sort_column_1=>'CH14_PLANT_TYPE_ID'
,p_sort_direction_1=>'ASC'
);
wwv_flow_imp_page.create_page_plug(
p_id=>wwv_flow_imp.id(20783331295880190145)
,p_plug_name=>'Breadcrumb'
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(20782268746112189604)
,p_plug_display_sequence=>20
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_imp.id(20782152897013189553)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_imp.id(20783131242481189631)
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(20783330097822190144)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(20783324605358190140)
,p_button_name=>'CREATE'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(20783129579709189631)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Create'
,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR'
,p_button_redirect_url=>'f?p=&APP_ID.:5:&APP_SESSION.::&DEBUG.:5::'
);
wwv_flow_imp_page.create_page_da_event(
p_id=>wwv_flow_imp.id(20783330355335190144)
,p_name=>'Edit Report - Dialog Closed'
,p_event_sequence=>10
,p_triggering_element_type=>'REGION'
,p_triggering_region_id=>wwv_flow_imp.id(20783324605358190140)
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'apexafterclosedialog'
);
wwv_flow_imp_page.create_page_da_action(
p_id=>wwv_flow_imp.id(20783330843497190145)
,p_event_id=>wwv_flow_imp.id(20783330355335190144)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_REFRESH'
,p_affected_elements_type=>'REGION'
,p_affected_region_id=>wwv_flow_imp.id(20783324605358190140)
);
end;
/
prompt --application/pages/page_00005
begin
wwv_flow_imp_page.create_page(
p_id=>5
,p_name=>'Plant'
,p_alias=>'PLANT'
,p_page_mode=>'MODAL'
,p_step_title=>'Plant'
,p_autocomplete_on_off=>'OFF'
,p_step_template=>wwv_flow_imp.id(20782153693275189554)
,p_page_template_options=>'#DEFAULT#:js-dialog-class-t-Drawer--pullOutEnd'
,p_dialog_chained=>'N'
,p_protection_level=>'C'
,p_page_component_map=>'02'
,p_last_updated_by=>'DARKOANDR@YAHOO.COM'
,p_last_upd_yyyymmddhh24miss=>'20230509073858'
);
wwv_flow_imp_page.create_page_plug(
p_id=>wwv_flow_imp.id(20783311368784190130)
,p_plug_name=>'Plant'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(20782189568456189571)
,p_plug_display_sequence=>10
,p_query_type=>'TABLE'
,p_query_table=>'CH14_PLANTS'
,p_include_rowid_column=>false
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
);
wwv_flow_imp_page.create_page_plug(
p_id=>wwv_flow_imp.id(20783320172963190137)
,p_plug_name=>'Buttons'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(20782192432984189572)
,p_plug_display_sequence=>20
,p_plug_display_point=>'REGION_POSITION_03'
,p_attribute_01=>'N'
,p_attribute_02=>'TEXT'
,p_attribute_03=>'Y'
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(20783320644692190137)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(20783320172963190137)
,p_button_name=>'CANCEL'
,p_button_action=>'DEFINED_BY_DA'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(20783129579709189631)
,p_button_image_alt=>'Cancel'
,p_button_position=>'CLOSE'
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(20783322013720190138)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(20783320172963190137)
,p_button_name=>'DELETE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#:t-Button--danger:t-Button--simple'
,p_button_template_id=>wwv_flow_imp.id(20783129579709189631)
,p_button_image_alt=>'Delete'
,p_button_position=>'DELETE'
,p_button_execute_validations=>'N'
,p_confirm_message=>'&APP_TEXT$DELETE_MSG!RAW.'
,p_confirm_style=>'danger'
,p_button_condition=>'P5_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(20783322363457190138)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_imp.id(20783320172963190137)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(20783129579709189631)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Apply Changes'
,p_button_position=>'NEXT'
,p_button_condition=>'P5_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(20783322760585190139)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(20783320172963190137)
,p_button_name=>'CREATE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(20783129579709189631)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Create'
,p_button_position=>'NEXT'
,p_button_condition=>'P5_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783311847380190131)
,p_name=>'P5_ID'
,p_source_data_type=>'NUMBER'
,p_is_required=>true
,p_is_primary_key=>true
,p_is_query_only=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'ID'
,p_source=>'ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783128401927189630)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783312229437190132)
,p_name=>'P5_CH14_PLANT_TYPE_ID'
,p_source_data_type=>'NUMBER'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Ch14 Plant Type'
,p_source=>'CH14_PLANT_TYPE_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'CH14_TYPE_OF_PLANT.NAME_OF_TYPE_OF_PLANT'
,p_lov_display_null=>'YES'
,p_cSize=>32
,p_cMaxlength=>255
,p_cHeight=>1
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'NONE'
,p_attribute_02=>'N'
,p_attribute_03=>'Y'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783312593357190132)
,p_name=>'P5_NAMES_LOCAL'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Names Local'
,p_source=>'NAMES_LOCAL'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>100
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783312966355190133)
,p_name=>'P5_NAMES_ENGLISH'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Names English'
,p_source=>'NAMES_ENGLISH'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>100
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783313391293190133)
,p_name=>'P5_NAME_LATIN'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Name Latin'
,p_source=>'NAME_LATIN'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>40
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783313842653190133)
,p_name=>'P5_DESCRIPTION'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Description'
,p_source=>'DESCRIPTION'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>200
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783314234307190133)
,p_name=>'P5_HABITAT'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Habitat'
,p_source=>'HABITAT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783314639725190134)
,p_name=>'P5_CULTIVATION'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Cultivation'
,p_source=>'CULTIVATION'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>100
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783314973999190134)
,p_name=>'P5_USE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>90
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Use'
,p_source=>'USE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>100
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783315389354190134)
,p_name=>'P5_PHOTO'
,p_source_data_type=>'BLOB'
,p_item_sequence=>100
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Photo'
,p_source=>'PHOTO'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>60
,p_cMaxlength=>255
,p_cHeight=>1
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_06=>'Y'
,p_attribute_08=>'attachment'
,p_attribute_09=>'SESSION'
,p_attribute_10=>'N'
,p_attribute_12=>'INLINE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783315846240190134)
,p_name=>'P5_HYPERLINKS'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>110
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Hyperlinks'
,p_source=>'HYPERLINKS'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>100
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783316185326190135)
,p_name=>'P5_STATUS'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>120
,p_item_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_item_source_plug_id=>wwv_flow_imp.id(20783311368784190130)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Status'
,p_source=>'STATUS'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>20
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783127105553189629)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_da_event(
p_id=>wwv_flow_imp.id(20783320711498190137)
,p_name=>'Cancel Dialog'
,p_event_sequence=>10
,p_triggering_element_type=>'BUTTON'
,p_triggering_button_id=>wwv_flow_imp.id(20783320644692190137)
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'click'
);
wwv_flow_imp_page.create_page_da_action(
p_id=>wwv_flow_imp.id(20783321463010190138)
,p_event_id=>wwv_flow_imp.id(20783320711498190137)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_DIALOG_CANCEL'
);
wwv_flow_imp_page.create_page_process(
p_id=>wwv_flow_imp.id(20783323565430190139)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(20783311368784190130)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>'Process form Plant'
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>10358235414036761301
);
wwv_flow_imp_page.create_page_process(
p_id=>wwv_flow_imp.id(20783323956946190139)
,p_process_sequence=>50
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_CLOSE_WINDOW'
,p_process_name=>'Close Dialog'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when=>'CREATE,SAVE,DELETE'
,p_process_when_type=>'REQUEST_IN_CONDITION'
,p_internal_uid=>10358235805552761301
);
wwv_flow_imp_page.create_page_process(
p_id=>wwv_flow_imp.id(20783323174301190139)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_imp.id(20783311368784190130)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>'Initialize form Plant'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>10358235022907761301
);
end;
/
prompt --application/pages/page_09999
begin
wwv_flow_imp_page.create_page(
p_id=>9999
,p_name=>'Login Page'
,p_alias=>'LOGIN'
,p_step_title=>'Ch14v8 - Log In'
,p_warn_on_unsaved_changes=>'N'
,p_first_item=>'AUTO_FIRST_ITEM'
,p_autocomplete_on_off=>'OFF'
,p_step_template=>wwv_flow_imp.id(20782164287397189560)
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_protection_level=>'C'
,p_page_component_map=>'12'
,p_last_updated_by=>'DARKOANDR@YAHOO.COM'
,p_last_upd_yyyymmddhh24miss=>'20230509073853'
);
wwv_flow_imp_page.create_page_plug(
p_id=>wwv_flow_imp.id(20783243713310189694)
,p_plug_name=>'Ch14v8'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(20782251123067189596)
,p_plug_display_sequence=>10
,p_region_image=>'#APP_FILES#icons/app-icon-512.png'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
,p_attribute_03=>'Y'
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(20783245423514189697)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(20783243713310189694)
,p_button_name=>'LOGIN'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(20783129579709189631)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Sign In'
,p_button_position=>'NEXT'
,p_button_alignment=>'LEFT'
,p_grid_new_row=>'Y'
,p_grid_new_column=>'Y'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783244170403189696)
,p_name=>'P9999_USERNAME'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(20783243713310189694)
,p_prompt=>'Username'
,p_placeholder=>'Username'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>40
,p_cMaxlength=>100
,p_tag_attributes=>'autocomplete="username"'
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783126830280189629)
,p_item_icon_css_classes=>'fa-user'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783244555211189696)
,p_name=>'P9999_PASSWORD'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(20783243713310189694)
,p_prompt=>'Password'
,p_placeholder=>'Password'
,p_display_as=>'NATIVE_PASSWORD'
,p_cSize=>40
,p_cMaxlength=>100
,p_tag_attributes=>'autocomplete="current-password"'
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(20783126830280189629)
,p_item_icon_css_classes=>'fa-key'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
p_id=>wwv_flow_imp.id(20783245036713189696)
,p_name=>'P9999_REMEMBER'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_imp.id(20783243713310189694)
,p_prompt=>'Remember username'
,p_display_as=>'NATIVE_SINGLE_CHECKBOX'
,p_label_alignment=>'RIGHT'
,p_display_when=>'apex_authentication.persistent_cookies_enabled'
,p_display_when2=>'PLSQL'
,p_display_when_type=>'EXPRESSION'
,p_field_template=>wwv_flow_imp.id(20783126830280189629)
,p_item_template_options=>'#DEFAULT#'
,p_escape_on_http_output=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_process(
p_id=>wwv_flow_imp.id(20783247552372189699)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_INVOKE_API'
,p_process_name=>'Set Username Cookie'
,p_attribute_01=>'PLSQL_PACKAGE'
,p_attribute_03=>'APEX_AUTHENTICATION'
,p_attribute_04=>'SEND_LOGIN_USERNAME_COOKIE'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>10358159400978760861
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
p_id=>wwv_flow_imp.id(20783248065092189699)
,p_page_process_id=>wwv_flow_imp.id(20783247552372189699)
,p_page_id=>9999
,p_name=>'p_username'
,p_direction=>'IN'
,p_data_type=>'VARCHAR2'
,p_has_default=>false
,p_display_sequence=>1
,p_value_type=>'EXPRESSION'
,p_value_language=>'PLSQL'
,p_value=>'lower( :P9999_USERNAME )'
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
p_id=>wwv_flow_imp.id(20783248585347189699)
,p_page_process_id=>wwv_flow_imp.id(20783247552372189699)
,p_page_id=>9999
,p_name=>'p_consent'
,p_direction=>'IN'
,p_data_type=>'BOOLEAN'
,p_has_default=>false
,p_display_sequence=>2
,p_value_type=>'ITEM'
,p_value=>'P9999_REMEMBER'
);
wwv_flow_imp_page.create_page_process(
p_id=>wwv_flow_imp.id(20783245741153189697)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_INVOKE_API'
,p_process_name=>'Login'
,p_attribute_01=>'PLSQL_PACKAGE'
,p_attribute_03=>'APEX_AUTHENTICATION'
,p_attribute_04=>'LOGIN'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>10358157589759760859
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
p_id=>wwv_flow_imp.id(20783246178250189697)
,p_page_process_id=>wwv_flow_imp.id(20783245741153189697)
,p_page_id=>9999
,p_name=>'p_username'
,p_direction=>'IN'
,p_data_type=>'VARCHAR2'
,p_has_default=>false
,p_display_sequence=>1
,p_value_type=>'ITEM'
,p_value=>'P9999_USERNAME'
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
p_id=>wwv_flow_imp.id(20783246676380189698)
,p_page_process_id=>wwv_flow_imp.id(20783245741153189697)
,p_page_id=>9999
,p_name=>'p_password'
,p_direction=>'IN'
,p_data_type=>'VARCHAR2'
,p_has_default=>false
,p_display_sequence=>2
,p_value_type=>'ITEM'
,p_value=>'P9999_PASSWORD'
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
p_id=>wwv_flow_imp.id(20783247219802189698)
,p_page_process_id=>wwv_flow_imp.id(20783245741153189697)
,p_page_id=>9999
,p_name=>'p_set_persistent_auth'
,p_direction=>'IN'
,p_data_type=>'BOOLEAN'
,p_has_default=>true
,p_display_sequence=>3
,p_value_type=>'API_DEFAULT'
);
wwv_flow_imp_page.create_page_process(
p_id=>wwv_flow_imp.id(20783249495169189700)
,p_process_sequence=>30
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_SESSION_STATE'
,p_process_name=>'Clear Page(s) Cache'
,p_attribute_01=>'CLEAR_CACHE_CURRENT_PAGE'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>10358161343775760862
);
wwv_flow_imp_page.create_page_process(
p_id=>wwv_flow_imp.id(20783249095653189699)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Get Username Cookie'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
':P9999_USERNAME := apex_authentication.get_login_username_cookie;',
':P9999_REMEMBER := case when :P9999_USERNAME is not null then ''Y'' end;'))
,p_process_clob_language=>'PLSQL'
,p_internal_uid=>10358160944259760861
);
end;
/
prompt --application/deployment/definition
begin
wwv_flow_imp_shared.create_install(
p_id=>wwv_flow_imp.id(10427277184058933884)
,p_deinstall_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'-- drop objects',
'drop table ch14_type_of_plant cascade constraints;',
'drop table ch14_plant cascade constraints;',
''))
,p_required_free_kb=>100
,p_required_sys_privs=>'CREATE PROCEDURE:CREATE TABLE:CREATE TRIGGER:CREATE VIEW'
,p_required_names_available=>'CH14_TYPE_OF_PLANT:CH14_PLANTS'
);
end;
/
prompt --application/deployment/install/install_ch14_create_packaged
begin
wwv_flow_imp_shared.create_install_script(
p_id=>wwv_flow_imp.id(10431775463579993938)
,p_install_id=>wwv_flow_imp.id(10427277184058933884)
,p_name=>'CH14 CREATE PACKAGED'
,p_sequence=>10
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'-- create tables',
'create table ch14_type_of_plant (',
' id number generated by default on null as identity ',
' constraint ch14_type_of_plant_id_pk primary key,',
' name_of_type_of_plant varchar2(30 char),',
' ch14_is_subtype_of number',
' constraint ch14_type_of_ch14_is_subty_fk',
' references ch14_type_of_plant on delete cascade',
')',
';',
'',
'-- table index',
'create index ch14_type_of_plant_i1 on ch14_type_of_plant (ch14_is_subtype_of);',
'',
'create table ch14_plants (',
' id number generated by default on null as identity ',
' constraint ch14_plants_id_pk primary key,',
' ch14_plant_type_id number',
' constraint ch14_plants_ch14_plant_type_fk',
' references ch14_type_of_plant on delete cascade,',
' names_local varchar2(100 char),',
' names_english varchar2(100 char),',
' name_latin varchar2(40 char),',
' description varchar2(200 char),',
' habitat varchar2(50 char),',
' cultivation varchar2(100 char),',
' use varchar2(100 char),',
' photo blob,',
' hyperlinks varchar2(100 char),',
' status varchar2(20 char)',
')',
';',
'',
'-- table index',
'create index ch14_plants_i1 on ch14_plants (ch14_plant_type_id);'))
);
end;
/
prompt --application/deployment/install/install_ch14_insert_packaged
begin
wwv_flow_imp_shared.create_install_script(
p_id=>wwv_flow_imp.id(10433482258394012496)
,p_install_id=>wwv_flow_imp.id(10427277184058933884)
,p_name=>'CH14 INSERT PACKAGED'
,p_sequence=>20
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'-- load data',
' ',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 1,',
' ''Compendium GA'',',
' 1',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 2,',
' ''SOA Upgrade'',',
' 2',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 3,',
' ''Resiliency Monitoring'',',
' 1',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 4,',
' ''SDK Upgraded for Embedded Syst'',',
' 4',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 5,',
' ''U88 Application'',',
' 4',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 6,',
' ''Developer Bug Performance Revi'',',
' 1',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 7,',
' ''FAQ Automated Publishing'',',
' 6',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 8,',
' ''Competitive Tracking'',',
' 2',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 9,',
' ''Inventory Quality Control Upgr'',',
' 8',
');',
'',
'insert into ch14_type_of_plant (',
' id,',
' name_of_type_of_plant,',
' ch14_is_subtype_of',
') values (',
' 10,',
' ''Checklist Management System'',',
' 5',
');',
'',
'commit;',
'',
'alter table ch14_type_of_plant',
'modify id generated by default on null as identity restart start with 11;',
' ',
'-- load data',
'-- load data',
' ',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 1,',
' 5,',
' ''Compendium GA'',',
' ''Nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem si'',',
' ''Lacinia Arcu In'',',
' ''Placerat pellentesque. Proin.'',',
' ''Porttitor Tincidunt Vestibulum Ante'',',
' ''Diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et males'',',
' ''Primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligul'',',
' null,',
' ''Orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra '',',
' ''Vulputate''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 2,',
' 3,',
' ''SOA Upgrade'',',
' ''Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales.'',',
' ''Etiam Cursus Porttitor'',',
' ''Placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem '',',
' ''Ac Volutpat Risusphasellus Vitae'',',
' ''Et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac vol'',',
' ''Amet.'',',
' null,',
' ''Sollicitudin elementum. Nulla facilisi. In.'',',
' ''In''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 3,',
' 5,',
' ''Resiliency Monitoring'',',
' ''Eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum.'',',
' ''Sapien Suscipit Tristique'',',
' ''Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor.'',',
' ''Semper Diam Suscipit Elementum'',',
' ''Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lo'',',
' ''Nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. V'',',
' null,',
' ''Nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere.'',',
' ''Amet''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 4,',
' 7,',
' ''SDK Upgraded for Embedded System'',',
' ''Posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis cons'',',
' ''Ex Etiam Cursus'',',
' ''Sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in.'',',
' ''Vitae Ligula Commodo Dictum'',',
' ''Ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat'',',
' ''Eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu i'',',
' null,',
' ''Id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem'',',
' ''Rhoncus''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 5,',
' 1,',
' ''U88 Application'',',
' ''Eu lorem commodo ullamcorper.Interdum et malesuada fames ac.'',',
' ''Viverra Lacinialectus Quis'',',
' ''Sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus e'',',
' ''Lacinialectus Quis Consectetur Mi'',',
' ''In massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit'',',
' ''Convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus effi'',',
' null,',
' ''Ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrice'',',
' ''Massa''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 6,',
' 1,',
' ''Developer Bug Performance Review'',',
' ''Placerat iaculis aliquam.'',',
' ''Ex Etiam Cursus'',',
' ''Lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet'',',
' ''Fames Ac Ante Ipsum'',',
' ''Arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam sus'',',
' ''Vestibulum lacinia arcu.'',',
' null,',
' ''Lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper '',',
' ''Rhoncus''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 7,',
' 9,',
' ''FAQ Automated Publishing'',',
' ''Sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus or'',',
' ''Nulla Ac Sapien'',',
' ''In faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis.'',',
' ''Placerat Pellentesque Proin Viverra'',',
' ''Sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus or'',',
' ''Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit'',',
' null,',
' ''Porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo '',',
' ''Ullamcorperinterdum''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 8,',
' 1,',
' ''Competitive Tracking'',',
' ''Ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique.'',',
' ''Ac Ante Ipsum'',',
' ''Fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet.'',',
' ''Arcu In Massa Pharetra'',',
' ''Imperdiet ex. Etiam cursus porttitor.'',',
' ''In massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit'',',
' null,',
' ''Vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lore'',',
' ''Amet''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 9,',
' 4,',
' ''Inventory Quality Control Upgrade'',',
' ''Nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem si'',',
' ''Arcu In Massa'',',
' ''Lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin vive'',',
' ''Ac Ante Ipsum Primis'',',
' ''Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem.'',',
' ''Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venen'',',
' null,',
' ''Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum'',',
' ''Ac''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 10,',
' 10,',
' ''Checklist Management System'',',
' ''Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet'',',
' ''Mi Venenatis Nec'',',
' ''Suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultri'',',
' ''Risusphasellus Vitae Ligula Commodo'',',
' ''Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul'',',
' ''Mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget'',',
' null,',
' ''Orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra '',',
' ''Donec''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 11,',
' 6,',
' ''CMS Training'',',
' ''Ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus '',',
' ''Tristique Ac Volutpat'',',
' ''In massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor.'',',
' ''Eget Rhoncus Nonmolestie Sit'',',
' ''Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.C'',',
' ''Donec convallis sollicitudin elementum. Nulla facilisi. In posuere.'',',
' null,',
' ''Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lo'',',
' ''Lectus''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 12,',
' 10,',
' ''Battery Upgrade'',',
' ''Et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac vol'',',
' ''Proin Sit Amet'',',
' ''Nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci'',',
' ''Massa Pharetra Id Mattis'',',
' ''Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus por'',',
' ''Aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor'',',
' null,',
' ''Sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsu'',',
' ''Et''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 13,',
' 6,',
' ''Managed Portal'',',
' ''Lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in fauci'',',
' ''Vestibulum Lacinia Arcu'',',
' ''Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit a'',',
' ''Suscipit Elementum Sodales Proin'',',
' ''Faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin'',',
' ''Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo.'',',
' null,',
' ''Rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in mas'',',
' ''Lacinialectus''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 14,',
' 3,',
' ''XML to JSON API transition'',',
' ''Ligula. Nam semper diam suscipit elementum sodales. Proin sit amet.'',',
' ''Ac Sapien Suscipit'',',
' ''Aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem.'',',
' ''Suscipit Tristique Ac Volutpat'',',
' ''Porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo '',',
' ''Risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor ti'',',
' null,',
' ''Id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem'',',
' ''Sollicitudin''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 15,',
' 5,',
' ''F5 Network Upgrade'',',
' ''Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul'',',
' ''Imperdiet Ex Etiam'',',
' ''Semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla.'',',
' ''Nam Semper Diam Suscipit'',',
' ''Sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsu'',',
' ''Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacin'',',
' null,',
' ''Et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac vol'',',
' ''Proin''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 16,',
' 4,',
' ''Artifact Management System'',',
' ''Sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsu'',',
' ''Convallis Sollicitudin Elementum'',',
' ''Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Viv'',',
' ''Diam Suscipit Elementum Sodales'',',
' ''Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem.'',',
' ''Risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor ti'',',
' null,',
' ''Ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus '',',
' ''Consectetur''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 17,',
' 4,',
' ''Buying Behavior AI Module'',',
' ''Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in.'',',
' ''Porttitor Ligula Nam'',',
' ''Arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fam'',',
' ''Elementum Nulla Facilisi In'',',
' ''Malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutp'',',
' ''Ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorpe'',',
' null,',
' ''Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales.'',',
' ''Nulla''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 18,',
' 4,',
' ''Distribution Subsidiary Integration'',',
' ''Pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementu'',',
' ''Etiam Cursus Porttitor'',',
' ''Aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorp'',',
' ''Elementum Sodales Proin Sit'',',
' ''Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque.'',',
' ''Faucibus. Ut id nulla ac sapien suscipit.'',',
' null,',
' ''Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur.'',',
' ''Ex''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 19,',
' 4,',
' ''CMOS Memory Upgrade'',',
' ''Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacin'',',
' ''Sit Amet Lectus'',',
' ''Pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tell'',',
' ''Elementum Sodales Proin Sit'',',
' ''Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet'',',
' ''Suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdie'',',
' null,',
' ''Eu lorem commodo ullamcorper.Interdum et malesuada fames ac.'',',
' ''Etiam''',
');',
'',
'insert into ch14_plants (',
' id,',
' ch14_plant_type_id,',
' names_local,',
' names_english,',
' name_latin,',
' description,',
' habitat,',
' cultivation,',
' use,',
' photo,',
' hyperlinks,',
' status',
') values (',
' 20,',
' 8,',
' ''Dynamic Optimization Portal'',',
' ''Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in.'',',
' ''Pellentesque Proin Viverra'',',
' ''Porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi vene'',',
' ''Lectus Nulla Placerat Iaculis'',',
' ''Posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis cons'',',
' ''Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul'',',
' null,',
' ''Posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis cons'',',
' ''Amet''',
');',
'',
'commit;',
'',
'alter table ch14_plants',
'modify id generated by default on null as identity restart start with 21;',
' ',
' ',
'-- Generated by Quick SQL Tuesday May 09, 2023 07:36:49',
' ',
'/*',
'ch14_type_of_plant /insert 10',
' name_of_type_of_plant vc30',
' ch14_is_subtype_of num /fk ch14_type_of_plant',
' ',
'ch14_plants /insert 20',
' ch14_plant_type_id num /fk ch14_type_of_plant',
' names_local vc100 ',
' names_english vc100',
' name_latin vc40',
' description vc200',
' habitat vc50',
' cultivation vc100',
' use vc100',
' photo blob',
' hyperlinks vc100',
' status vc20',
'',
'# settings = { semantics: "CHAR", language: "EN", APEX: true }',
'*/'))
);
end;
/
prompt --application/deployment/checks
begin
null;
end;
/
prompt --application/deployment/buildoptions
begin
null;
end;
/
prompt --application/end_environment
begin
wwv_flow_imp.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false));
commit;
end;
/
set verify on feedback on define on
prompt ...done