also das ist nur der text von der einen seite soweit ich das sehe :S die ist einfach sehr umfangreich. ich hab auch mal ein aktueles bild angehangen


set define off
set verify off
set serveroutput on size 1000000
set feedback off
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK
begin wwv_flow.g_import_in_progress := true; end;
/


--application/set_environment
prompt
--
-- Application Export:
-- Application: 102
-- Name:
-- Date and Time: 14:32 Donnerstag Juli 28, 2011
-- Exported By:
-- Flashback: 0
-- Export Type: Page Export
-- Version: 4.0.2.00.07

-- Import:
-- Using application builder
-- or
-- Using SQL*Plus as the Oracle user APEX_040000 or as the owner (parsing schema) of the application.


-- AAAA PPPPP EEEEEE XX XX
-- AA AA PP PP EE XX XX
-- AA AA PP PP EE XX XX
-- AAAAAAAAAA PPPPP EEEE XXXX
-- AA AA PP EE XX XX
-- AA AA PP EE XX XX
-- AA AA PP EEEEEE XX XX
prompt Set Credentials...

begin

-- Assumes you are running the script connected to SQL*Plus as the Oracle user APEX_040000 or as the owner (parsing schema) of the application.
wwv_flow_api.set_security_group_id(p_security_group_id=>nvl(wwv_flow_application_install.get_workspace_id,6912314301959141));

end;
/

begin wwv_flow.g_import_in_progress := true; end;
/
begin

select value into wwv_flow_api.g_nls_numeric_chars from nls_session_parameters where parameter='NLS_NUMERIC_CHARACTERS';

end;

/
begin execute immediate 'alter session set nls_numeric_characters=''.,''';

end;

/
begin wwv_flow.g_browser_language := 'de'; end;
/
prompt Check Compatibility...

begin

-- This date identifies the minimum version required to import this file.
wwv_flow_api.set_version(p_version_yyyy_mm_dd=>'2010.05.13');

end;
/

prompt Set Application ID...

begin

-- SET APPLICATION ID
wwv_flow.g_flow_id := nvl(wwv_flow_application_install.get_application_id,102);
wwv_flow_api.g_id_offset := nvl(wwv_flow_application_install.get_offset,0);
null;

end;
/

PROMPT ...Remove page 500

begin

wwv_flow_api.remove_page (p_flow_id=>wwv_flow.g_flow_id, p_page_id=>500);

end;
/


--application/pages/page_00500
prompt ...PAGE 500: Wachstum
--

begin

wwv_flow_api.create_page (
p_flow_id => wwv_flow.g_flow_id
,p_id => 500
,p_tab_set => 'TS1'
,p_name => 'Wachstum'
,p_step_title => 'Wachstum'
,p_allow_duplicate_submissions => 'Y'
,p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS'
,p_first_item => 'AUTO_FIRST_ITEM'
,p_include_apex_css_js_yn => 'Y'
,p_autocomplete_on_off => 'ON'
,p_javascript_code =>
'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'||chr(10)||
'var htmldb_ch_message=''"OK_TO_GET_NEXT_PREV_PK_VALUE"'';'
,p_page_is_public_y_n => 'N'
,p_protection_level => 'N'
,p_cache_page_yn => 'N'
,p_cache_timeout_seconds => 21600
,p_cache_by_user_yn => 'N'
,p_help_text =>
'FĂĽr diese Seite ist keine Hilfe verfĂĽgbar.'
,p_last_updated_by => 'STEFFENROTH31@AOL.COM'
,p_last_upd_yyyymmddhh24miss => '20110726150233'
);
null;

end;
/

declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 14992707273967426 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 500,
p_plug_name=> 'Navigationspfad',
p_region_name=>'',
p_plug_template=> 7709130931006573+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 1,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_01',
p_plug_source=> s,
p_plug_source_type=> 'M'|| to_char(7716730389006579 + wwv_flow_api.g_id_offset),
p_menu_template_id=> 7714310629006577+ wwv_flow_api.g_id_offset,
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'COLON_DELMITED_LIST',
p_plug_query_row_count_max => 500,
p_plug_display_condition_type => '',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 14995918716967579 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 500,
p_plug_name=> 'Baum',
p_region_name=>'',
p_plug_template=> 7710424500006573+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 0,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'COLON_DELMITED_LIST',
p_plug_query_row_count_max => 500,
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'select '||chr(10)||
'"IDGROWTH",'||chr(10)||
'"TREE_IDTREE",'||chr(10)||
'"DATE",'||chr(10)||
'"CIRCUMFERENCE",'||chr(10)||
'"CORONETDIAMETER"'||chr(10)||
'from "#OWNER#"."GROWTH"'||chr(10)||
'where "TREE_IDTREE" = :P500_IDTREE'||chr(10)||
'';

wwv_flow_api.create_report_region (
p_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 500,
p_name=> 'Wachstum',
p_region_name=>'',
p_template=> 7710424500006573+ wwv_flow_api.g_id_offset,
p_display_sequence=> 15,
p_display_column=> 1,
p_display_point=> 'AFTER_SHOW_ITEMS',
p_source=> s,
p_source_type=> 'UPDATABLE_SQL_QUERY',
p_display_error_message=> '#SQLERRM#',
p_display_when_condition=> 'P500_IDTREE',
p_plug_caching=> 'NOT_CACHED',
p_customized=> '0',
p_translate_title=> 'Y',
p_ajax_enabled=> 'N',
p_query_row_template=> 7713207947006575+ wwv_flow_api.g_id_offset,
p_query_headings_type=> 'COLON_DELMITED_LIST',
p_query_num_rows=> '10',
p_query_options=> 'DERIVED_REPORT_COLUMNS',
p_query_show_nulls_as=> '(null)',
p_query_break_cols=> '0',
p_query_no_data_found=> 'Keine Daten gefunden.',
p_query_num_rows_type=> 'ROW_RANGES_IN_SELECT_LIST',
p_query_row_count_max=> '500',
p_pagination_display_position=> 'BOTTOM_RIGHT',
p_csv_output=> 'N',
p_query_asc_image=> 'apex/builder/dup.gif',
p_query_asc_image_attr=> 'width="16" height="16" alt="" ',
p_query_desc_image=> 'apex/builder/ddown.gif',
p_query_desc_image_attr=> 'width="16" height="16" alt="" ',
p_plug_query_strip_html=> 'Y',
p_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15003823289967608 + wwv_flow_api.g_id_offset,
p_region_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 1,
p_form_element_id=> null,
p_column_alias=> 'CHECK$01',
p_column_display_sequence=> 1,
p_column_heading=> ' ',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'CHECKBOX',
p_is_required=> false,
p_pk_col_source=> s,
p_derived_column=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15001431379967602 + wwv_flow_api.g_id_offset,
p_region_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 2,
p_form_element_id=> null,
p_column_alias=> 'IDGROWTH',
p_column_display_sequence=> 2,
p_column_heading=> 'Idgrowth',
p_column_alignment=>'LEFT',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'N',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'HIDDEN',
p_column_width=> '16',
p_is_required=> false,
p_pk_col_source_type=> 'T',
p_ref_schema=> 'ROTH',
p_ref_table_name=> 'GROWTH',
p_ref_column_name=> 'IDGROWTH',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15001531093967602 + wwv_flow_api.g_id_offset,
p_region_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 3,
p_form_element_id=> null,
p_column_alias=> 'TREE_IDTREE',
p_column_display_sequence=> 3,
p_column_heading=> 'Tree Idtree',
p_column_alignment=>'LEFT',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'HIDDEN',
p_column_width=> '16',
p_is_required=> false,
p_column_default=> 'P500_IDTREE',
p_column_default_type=> 'ITEM',
p_ref_schema=> 'ROTH',
p_ref_table_name=> 'GROWTH',
p_ref_column_name=> 'TREE_IDTREE',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15001627337967602 + wwv_flow_api.g_id_offset,
p_region_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 4,
p_form_element_id=> null,
p_column_alias=> 'DATE',
p_column_display_sequence=> 4,
p_column_heading=> 'Datum',
p_column_format=> 'DD.MM.YYYY',
p_column_alignment=>'LEFT',
p_heading_alignment=>'LEFT',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'DATE_PICKER',
p_lov_show_nulls=> 'NO',
p_column_width=> '12',
p_is_required=> false,
p_lov_display_extra=> 'YES',
p_include_in_export=> 'Y',
p_ref_schema=> 'ROTH',
p_ref_table_name=> 'GROWTH',
p_ref_column_name=> 'DATE',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15001718244967603 + wwv_flow_api.g_id_offset,
p_region_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 5,
p_form_element_id=> null,
p_column_alias=> 'CIRCUMFERENCE',
p_column_display_sequence=> 5,
p_column_heading=> 'Stammumfang',
p_column_alignment=>'LEFT',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'TEXT',
p_column_width=> '16',
p_is_required=> false,
p_ref_schema=> 'ROTH',
p_ref_table_name=> 'GROWTH',
p_ref_column_name=> 'CIRCUMFERENCE',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15001822435967603 + wwv_flow_api.g_id_offset,
p_region_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 6,
p_form_element_id=> null,
p_column_alias=> 'CORONETDIAMETER',
p_column_display_sequence=> 6,
p_column_heading=> 'Kronendurchmesser',
p_column_alignment=>'LEFT',
p_heading_alignment=>'LEFT',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'TEXT',
p_lov_show_nulls=> 'NO',
p_column_width=> '16',
p_is_required=> false,
p_lov_display_extra=> 'YES',
p_include_in_export=> 'Y',
p_ref_schema=> 'ROTH',
p_ref_table_name=> 'GROWTH',
p_ref_column_name=> 'CORONETDIAMETER',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'select '||chr(10)||
'"VITALITY_IDVITALITY",'||chr(10)||
'"TREE_IDTREE",'||chr(10)||
'"ENTRYDATE",'||chr(10)||
'"DESCRIPTIONOFDAMAGE"'||chr(10)||
'from "#OWNER#"."INDIVIDUALTREE_HAS_VITALITY"'||chr(10)||
'where "TREE_IDTREE" = :P500_IDTREE'||chr(10)||
'';

wwv_flow_api.create_report_region (
p_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 500,
p_name=> 'Vitalität',
p_region_name=>'',
p_template=> 7710424500006573+ wwv_flow_api.g_id_offset,
p_display_sequence=> 25,
p_display_column=> 1,
p_display_point=> 'AFTER_SHOW_ITEMS',
p_source=> s,
p_source_type=> 'UPDATABLE_SQL_QUERY',
p_display_error_message=> '#SQLERRM#',
p_display_when_condition=> 'P500_IDTREE',
p_plug_caching=> 'NOT_CACHED',
p_customized=> '0',
p_translate_title=> 'Y',
p_ajax_enabled=> 'N',
p_query_row_template=> 7713207947006575+ wwv_flow_api.g_id_offset,
p_query_headings_type=> 'COLON_DELMITED_LIST',
p_query_num_rows=> '10',
p_query_options=> 'DERIVED_REPORT_COLUMNS',
p_query_show_nulls_as=> '(null)',
p_query_break_cols=> '0',
p_query_no_data_found=> 'Keine Daten gefunden.',
p_query_num_rows_type=> 'ROW_RANGES_IN_SELECT_LIST',
p_query_row_count_max=> '500',
p_pagination_display_position=> 'BOTTOM_RIGHT',
p_csv_output=> 'N',
p_query_asc_image=> 'apex/builder/dup.gif',
p_query_asc_image_attr=> 'width="16" height="16" alt="" ',
p_query_desc_image=> 'apex/builder/ddown.gif',
p_query_desc_image_attr=> 'width="16" height="16" alt="" ',
p_plug_query_strip_html=> 'Y',
p_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15010216369039038 + wwv_flow_api.g_id_offset,
p_region_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 1,
p_form_element_id=> null,
p_column_alias=> 'CHECK$01',
p_column_display_sequence=> 1,
p_column_heading=> ' ',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'N',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'CHECKBOX',
p_is_required=> false,
p_pk_col_source=> s,
p_derived_column=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15020014123203315 + wwv_flow_api.g_id_offset,
p_region_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 2,
p_form_element_id=> null,
p_column_alias=> 'VITALITY_IDVITALITY',
p_column_display_sequence=> 3,
p_column_heading=> 'Vitalität',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'SELECT_LIST_FROM_LOV',
p_named_lov=>15033628094488452 + wwv_flow_api.g_id_offset,
p_lov_show_nulls=> 'NO',
p_is_required=> false,
p_pk_col_source=> s,
p_lov_display_extra=> 'YES',
p_include_in_export=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15009825275039038 + wwv_flow_api.g_id_offset,
p_region_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 3,
p_form_element_id=> null,
p_column_alias=> 'TREE_IDTREE',
p_column_display_sequence=> 2,
p_column_heading=> 'Tree Idtree',
p_column_alignment=>'LEFT',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'HIDDEN',
p_column_width=> '16',
p_is_required=> false,
p_pk_col_source=> s,
p_ref_schema=> 'ROTH',
p_ref_table_name=> 'GROWTH',
p_ref_column_name=> 'TREE_IDTREE',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15020100634203315 + wwv_flow_api.g_id_offset,
p_region_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 4,
p_form_element_id=> null,
p_column_alias=> 'ENTRYDATE',
p_column_display_sequence=> 4,
p_column_heading=> 'Datum',
p_column_format=> 'DD.MM.YYYY',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'DATE_PICKER',
p_lov_show_nulls=> 'NO',
p_is_required=> false,
p_pk_col_source=> s,
p_lov_display_extra=> 'YES',
p_include_in_export=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15020206130203315 + wwv_flow_api.g_id_offset,
p_region_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 5,
p_form_element_id=> null,
p_column_alias=> 'DESCRIPTIONOFDAMAGE',
p_column_display_sequence=> 5,
p_column_heading=> 'Beschreibung der Schädigungen',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'TEXT',
p_lov_show_nulls=> 'NO',
p_is_required=> false,
p_pk_col_source=> s,
p_lov_display_extra=> 'YES',
p_include_in_export=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'select '||chr(10)||
'"IDART",'||chr(10)||
'"TRIVIALNAME",'||chr(10)||
'"BINOMIALNAME"'||chr(10)||
'from "#OWNER#"."ART"'||chr(10)||
'where "IDART" = :P500_IDART'||chr(10)||
'';

wwv_flow_api.create_report_region (
p_id=> 15051507839870404 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 500,
p_name=> 'Baumart',
p_region_name=>'',
p_template=> 7710424500006573+ wwv_flow_api.g_id_offset,
p_display_sequence=> 35,
p_display_column=> 1,
p_display_point=> 'AFTER_SHOW_ITEMS',
p_source=> s,
p_source_type=> 'UPDATABLE_SQL_QUERY',
p_display_error_message=> '#SQLERRM#',
p_display_when_condition=> 'P500_IDTREE',
p_plug_caching=> 'NOT_CACHED',
p_customized=> '0',
p_translate_title=> 'Y',
p_ajax_enabled=> 'N',
p_query_row_template=> 7713207947006575+ wwv_flow_api.g_id_offset,
p_query_headings_type=> 'COLON_DELMITED_LIST',
p_query_num_rows=> '10',
p_query_options=> 'DERIVED_REPORT_COLUMNS',
p_query_show_nulls_as=> '(null)',
p_query_break_cols=> '0',
p_query_no_data_found=> 'Keine Daten gefunden.',
p_query_num_rows_type=> 'ROW_RANGES_IN_SELECT_LIST',
p_query_row_count_max=> '500',
p_pagination_display_position=> 'BOTTOM_RIGHT',
p_csv_output=> 'N',
p_query_asc_image=> 'apex/builder/dup.gif',
p_query_asc_image_attr=> 'width="16" height="16" alt="" ',
p_query_desc_image=> 'apex/builder/ddown.gif',
p_query_desc_image_attr=> 'width="16" height="16" alt="" ',
p_plug_query_strip_html=> 'Y',
p_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15051826381870421 + wwv_flow_api.g_id_offset,
p_region_id=> 15051507839870404 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 1,
p_form_element_id=> null,
p_column_alias=> 'CHECK$01',
p_column_display_sequence=> 1,
p_column_heading=> ' ',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'CHECKBOX',
p_is_required=> false,
p_pk_col_source=> s,
p_derived_column=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15055922938956749 + wwv_flow_api.g_id_offset,
p_region_id=> 15051507839870404 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 2,
p_form_element_id=> null,
p_column_alias=> 'IDART',
p_column_display_sequence=> 2,
p_column_heading=> 'Idart',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'N',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15056001226956750 + wwv_flow_api.g_id_offset,
p_region_id=> 15051507839870404 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 3,
p_form_element_id=> null,
p_column_alias=> 'TRIVIALNAME',
p_column_display_sequence=> 3,
p_column_heading=> 'Trivialname',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'SELECT_LIST_FROM_LOV',
p_named_lov=>15059602672096060 + wwv_flow_api.g_id_offset,
p_lov_show_nulls=> 'NO',
p_is_required=> false,
p_pk_col_source=> s,
p_lov_display_extra=> 'YES',
p_include_in_export=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15056108698956750 + wwv_flow_api.g_id_offset,
p_region_id=> 15051507839870404 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 4,
p_form_element_id=> null,
p_column_alias=> 'BINOMIALNAME',
p_column_display_sequence=> 4,
p_column_heading=> 'Binomialname',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'SELECT_LIST_FROM_LOV',
p_named_lov=>15059602672096060 + wwv_flow_api.g_id_offset,
p_lov_show_nulls=> 'NO',
p_is_required=> false,
p_pk_col_source=> s,
p_lov_display_extra=> 'YES',
p_include_in_export=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 15099527464995362 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 500,
p_plug_name=> 'Details',
p_region_name=>'',
p_plug_template=> 7710424500006573+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 55,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'URL',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'select "PLANTING"."IDPLANTING" as "IDPLANTING",'||chr(10)||
' "PLANTING"."TREE_IDTREE" as "TREE_IDTREE",'||chr(10)||
' "PLANTING"."EXTRACTION_IDEXTRACTION" as "EXTRACTION_IDEXTRACTION",'||chr(10)||
' "PLANTING"."PLANTINGDATE" as "PLANTINGDATE",'||chr(10)||
' "PLANTING"."PLANTINGDEPTH" as "PLANTINGDEPTH",'||chr(10)||
' "PLANTING"."PLANTINGWIDE" as "PLANTINGWIDE",'||chr(10)||
' "PLANTING"."NUMEBROFPLANTINGS" as "NUMEBROFPLANTINGS",'||chr(10)||
' "PLANTING"."PREPARATION" as "PREPAR';

s:=s||'ATION" '||chr(10)||
' from "TREE" "TREE",'||chr(10)||
' "PLANTING" "PLANTING" '||chr(10)||
' where "TREE"."IDTREE"="PLANTING"."TREE_IDTREE"';

wwv_flow_api.create_report_region (
p_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 500,
p_name=> 'Pflanzung',
p_region_name=>'',
p_parent_plug_id=>15099527464995362 + wwv_flow_api.g_id_offset,
p_template=> 7709700784006573+ wwv_flow_api.g_id_offset,
p_display_sequence=> 45,
p_display_column=> 1,
p_display_point=> 'AFTER_SHOW_ITEMS',
p_source=> s,
p_source_type=> 'UPDATABLE_SQL_QUERY',
p_display_error_message=> '#SQLERRM#',
p_display_when_condition=> 'P500_IDTREE',
p_plug_caching=> 'NOT_CACHED',
p_customized=> '0',
p_translate_title=> 'Y',
p_ajax_enabled=> 'N',
p_query_row_template=> 7713207947006575+ wwv_flow_api.g_id_offset,
p_query_headings_type=> 'COLON_DELMITED_LIST',
p_query_num_rows=> '10',
p_query_options=> 'DERIVED_REPORT_COLUMNS',
p_query_show_nulls_as=> '(null)',
p_query_break_cols=> '0',
p_query_no_data_found=> 'Keine Daten gefunden.',
p_query_num_rows_type=> 'ROW_RANGES_IN_SELECT_LIST',
p_query_row_count_max=> '500',
p_pagination_display_position=> 'BOTTOM_RIGHT',
p_csv_output=> 'N',
p_query_asc_image=> 'apex/builder/dup.gif',
p_query_asc_image_attr=> 'width="16" height="16" alt="" ',
p_query_desc_image=> 'apex/builder/ddown.gif',
p_query_desc_image_attr=> 'width="16" height="16" alt="" ',
p_plug_query_strip_html=> 'Y',
p_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15081718404444615 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 1,
p_form_element_id=> null,
p_column_alias=> 'CHECK$01',
p_column_display_sequence=> 1,
p_column_heading=> ' ',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'CHECKBOX',
p_is_required=> false,
p_pk_col_source=> s,
p_derived_column=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15088403182677595 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 2,
p_form_element_id=> null,
p_column_alias=> 'IDPLANTING',
p_column_display_sequence=> 2,
p_column_heading=> 'Idplanting',
p_column_link=>'f?p=&APP_ID.:7:&SESSION.::&DEBUG.:::',
p_column_linktext=>'<img src="#IMAGE_PREFIX#menu/pencil2_16x16.gif" alt="">',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_lov_show_nulls=> 'NO',
p_is_required=> false,
p_pk_col_source=> s,
p_lov_display_extra=> 'YES',
p_include_in_export=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15088527238677595 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 3,
p_form_element_id=> null,
p_column_alias=> 'TREE_IDTREE',
p_column_display_sequence=> 3,
p_column_heading=> 'Tree Idtree',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15088631375677595 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 4,
p_form_element_id=> null,
p_column_alias=> 'EXTRACTION_IDEXTRACTION',
p_column_display_sequence=> 4,
p_column_heading=> 'Extraction Idextraction',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15088707419677595 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 5,
p_form_element_id=> null,
p_column_alias=> 'PLANTINGDATE',
p_column_display_sequence=> 5,
p_column_heading=> 'Pflanzdatum',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15088830493677595 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 6,
p_form_element_id=> null,
p_column_alias=> 'PLANTINGDEPTH',
p_column_display_sequence=> 6,
p_column_heading=> 'Pflanztiefe',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15088906448677595 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 7,
p_form_element_id=> null,
p_column_alias=> 'PLANTINGWIDE',
p_column_display_sequence=> 7,
p_column_heading=> 'Pflanzbreite',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15089024586677595 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 8,
p_form_element_id=> null,
p_column_alias=> 'NUMEBROFPLANTINGS',
p_column_display_sequence=> 8,
p_column_heading=> 'Anzahl der Pflanzungen',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15089129777677595 + wwv_flow_api.g_id_offset,
p_region_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 9,
p_form_element_id=> null,
p_column_alias=> 'PREPARATION',
p_column_display_sequence=> 9,
p_column_heading=> 'Vorbereitungen',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'select "TREE_HAS_PEST"."PEST_IDPEST" as "PEST_IDPEST",'||chr(10)||
' "TREE_HAS_PEST"."TREE_IDTREE" as "TREE_IDTREE",'||chr(10)||
' "TREE_HAS_PEST"."FIRSTSIGHTING" as "FIRSTSIGHTING",'||chr(10)||
' "TREE_HAS_PEST"."NUMBER" as "NUMBER",'||chr(10)||
' "TREE_HAS_PEST"."IDTREEPEST" as "IDTREEPEST" '||chr(10)||
' from "TREE" "TREE",'||chr(10)||
' "TREE_HAS_PEST" "TREE_HAS_PEST" '||chr(10)||
' where "TREE"."IDTREE"="TREE_HAS_PEST"."TREE_IDTREE"';

wwv_flow_api.create_report_region (
p_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 500,
p_name=> 'Schädlinge',
p_region_name=>'',
p_parent_plug_id=>15099527464995362 + wwv_flow_api.g_id_offset,
p_template=> 7709700784006573+ wwv_flow_api.g_id_offset,
p_display_sequence=> 65,
p_display_column=> 1,
p_display_point=> 'AFTER_SHOW_ITEMS',
p_source=> s,
p_source_type=> 'UPDATABLE_SQL_QUERY',
p_display_error_message=> '#SQLERRM#',
p_display_when_condition=> 'P500_IDTREE',
p_plug_caching=> 'NOT_CACHED',
p_customized=> '0',
p_translate_title=> 'Y',
p_ajax_enabled=> 'N',
p_query_row_template=> 7713207947006575+ wwv_flow_api.g_id_offset,
p_query_headings_type=> 'COLON_DELMITED_LIST',
p_query_num_rows=> '10',
p_query_options=> 'DERIVED_REPORT_COLUMNS',
p_query_show_nulls_as=> '(null)',
p_query_break_cols=> '0',
p_query_no_data_found=> 'Keine Daten gefunden.',
p_query_num_rows_type=> 'ROW_RANGES_IN_SELECT_LIST',
p_query_row_count_max=> '500',
p_pagination_display_position=> 'BOTTOM_RIGHT',
p_csv_output=> 'N',
p_query_asc_image=> 'apex/builder/dup.gif',
p_query_asc_image_attr=> 'width="16" height="16" alt="" ',
p_query_desc_image=> 'apex/builder/ddown.gif',
p_query_desc_image_attr=> 'width="16" height="16" alt="" ',
p_plug_query_strip_html=> 'Y',
p_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15175526906709358 + wwv_flow_api.g_id_offset,
p_region_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 1,
p_form_element_id=> null,
p_column_alias=> 'CHECK$01',
p_column_display_sequence=> 1,
p_column_heading=> '&nbsp;',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'Y',
p_display_as=>'CHECKBOX',
p_is_required=> false,
p_pk_col_source=> s,
p_derived_column=> 'Y',
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15177232619717527 + wwv_flow_api.g_id_offset,
p_region_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 2,
p_form_element_id=> null,
p_column_alias=> 'PEST_IDPEST',
p_column_display_sequence=> 3,
p_column_heading=> 'Pest Idpest',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15175723634709358 + wwv_flow_api.g_id_offset,
p_region_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 3,
p_form_element_id=> null,
p_column_alias=> 'TREE_IDTREE',
p_column_display_sequence=> 2,
p_column_heading=> 'Tree Idtree',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15177316452717528 + wwv_flow_api.g_id_offset,
p_region_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 4,
p_form_element_id=> null,
p_column_alias=> 'FIRSTSIGHTING',
p_column_display_sequence=> 4,
p_column_heading=> 'Erstsichtung',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15177400188717528 + wwv_flow_api.g_id_offset,
p_region_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 5,
p_form_element_id=> null,
p_column_alias=> 'NUMBER',
p_column_display_sequence=> 5,
p_column_heading=> 'Anzahl der Schädlinge',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 15177522730717528 + wwv_flow_api.g_id_offset,
p_region_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 6,
p_form_element_id=> null,
p_column_alias=> 'IDTREEPEST',
p_column_display_sequence=> 6,
p_column_heading=> 'Idtreepest',
p_column_alignment=>'LEFT',
p_heading_alignment=>'CENTER',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'ESCAPE_SC',
p_is_required=> false,
p_pk_col_source=> s,
p_column_comment=>'');
end;
/

begin

wwv_flow_api.create_page_button(
p_id => 14998608734967592 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_button_sequence=> 50,
p_button_name => 'GET_PREVIOUS_IDTREE',
p_button_image => 'template:'||to_char(7708524823006571+wwv_flow_api.g_id_offset),
p_button_image_alt=> '&lt;',
p_button_position=> 'LEFT_OF_TITLE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_button_execute_validations=>'N',
p_button_condition=> 'P500_IDTREE_PREV',
p_button_comment=>'Diese Schaltfläche wird für den Prozess zum Abrufen des nächsten oder vorherigen Primärschlüsselwertes benötigt.',
p_required_patch => null + wwv_flow_api.g_id_offset);

wwv_flow_api.create_page_button(
p_id => 14996232077967580 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_button_sequence=> 30,
p_button_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_button_name => 'SAVE',
p_button_image => 'template:'||to_char(7708524823006571+wwv_flow_api.g_id_offset),
p_button_image_alt=> 'Ă„nderungen anwenden',
p_button_position=> 'REGION_TEMPLATE_CHANGE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_button_execute_validations=>'Y',
p_button_condition=> 'P500_IDTREE',
p_button_condition_type=> 'ITEM_IS_NOT_NULL',
p_database_action=>'UPDATE',
p_required_patch => null + wwv_flow_api.g_id_offset);

wwv_flow_api.create_page_button(
p_id => 14996505314967580 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_button_sequence=> 10,
p_button_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_button_name => 'CANCEL',
p_button_image => 'template:'||to_char(7708524823006571+wwv_flow_api.g_id_offset),
p_button_image_alt=> 'Abbrechen',
p_button_position=> 'REGION_TEMPLATE_CLOSE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> 'f?p=&APP_ID.:2:&SESSION.::&DEBUG.:::',
p_required_patch => null + wwv_flow_api.g_id_offset);

wwv_flow_api.create_page_button(
p_id => 14996126988967580 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_button_sequence=> 40,
p_button_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_button_name => 'CREATE',
p_button_image => 'template:'||to_char(7708524823006571+wwv_flow_api.g_id_offset),
p_button_image_alt=> 'Erstellen',
p_button_position=> 'REGION_TEMPLATE_CREATE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_button_execute_validations=>'Y',
p_button_condition=> 'P500_IDTREE',
p_button_condition_type=> 'ITEM_IS_NULL',
p_database_action=>'INSERT',
p_required_patch => null + wwv_flow_api.g_id_offset);

wwv_flow_api.create_page_button(
p_id => 14996326021967580 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_button_sequence=> 20,
p_button_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_button_name => 'DELETE',
p_button_image => 'template:'||to_char(7708524823006571+wwv_flow_api.g_id_offset),
p_button_image_alt=> 'Löschen',
p_button_position=> 'REGION_TEMPLATE_DELETE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> 'javascript:apex.confirm(htmldb_delete_message,''DELETE'');',
p_button_execute_validations=>'N',
p_button_condition=> 'P500_IDTREE',
p_button_condition_type=> 'ITEM_IS_NOT_NULL',
p_database_action=>'DELETE',
p_required_patch => null + wwv_flow_api.g_id_offset);

wwv_flow_api.create_page_button(
p_id => 15002127972967606 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_button_sequence=> 20,
p_button_plug_id => 15001100700967600+wwv_flow_api.g_id_offset,
p_button_name => 'APPLY_CHANGES_MRD',
p_button_image => 'template:'||to_char(7708524823006571+wwv_flow_api.g_id_offset),
p_button_image_alt=> 'Markierte Elemente löschen',
p_button_position=> 'REGION_TEMPLATE_DELETE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> 'javascript:apex.confirm(htmldb_delete_message,''APPLY_CHANGES_MRD'');',
p_button_execute_validations=>'N',
p_button_condition=> 'select 1 '||chr(10)||
'from "#OWNER#"."GROWTH"'||chr(10)||
'where "TREE_IDTREE" = :P500_IDTREE',
p_button_condition_type=> 'EXISTS',
p_required_patch => null + wwv_flow_api.g_id_offset);

wwv_flow_api.create_page_button(
p_id => 15010303473039039 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_button_sequence=> 20,
p_button_plug_id => 15009511546039024+wwv_flow_api.g_id_offset,
p_button_name => 'APPLY_CHANGES_MRD',
p_button_image => 'template:'||to_char(7708524823006571+wwv_flow_api.g_id_offset),
p_button_image_alt=> 'Markierte Elemente löschen',
p_button_position=> 'REGION_TEMPLATE_DELETE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> 'javascript:apex.confirm(htmldb_delete_message,''APPLY_CHANGES_MRD'');',
p_button_execute_validations=>'N',
p_button_condition=> 'select 1 '||chr(10)||
'from "#OWNER#"."GROWTH"'||chr(10)||
'where "TREE_IDTREE" = :P500_IDTREE',
p_button_condition_type=> 'EXISTS',
p_required_patch => null + wwv_flow_api.g_id_offset);


end;
/


begin

wwv_flow_api.create_page_branch(
p_id=>15000309967967597 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_branch_action=> 'f?p=&FLOW_ID.:500:&SESSION.::&DEBUG.::P500_IDTREE:&P500_IDTREE_NEXT.&success_msg=#SUCCESS_MSG#',
p_branch_point=> 'AFTER_PROCESSING',
p_branch_type=> 'REDIRECT_URL',
p_branch_when_button_id=>14998500196967592+ wwv_flow_api.g_id_offset,
p_branch_sequence=> 10,
p_save_state_before_branch_yn=>'Y',
p_branch_comment=> 'Diese Schaltfläche wird für den Prozess zum Abrufen des nächsten oder vorherigen Primärschlüsselwertes benötigt.');

wwv_flow_api.create_page_branch(
p_id=>15000516656967598 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_branch_action=> 'f?p=&FLOW_ID.:500:&SESSION.::&DEBUG.::P500_IDTREE:&P500_IDTREE_PREV.&success_msg=#SUCCESS_MSG#',
p_branch_point=> 'AFTER_PROCESSING',
p_branch_type=> 'REDIRECT_URL',
p_branch_when_button_id=>14998608734967592+ wwv_flow_api.g_id_offset,
p_branch_sequence=> 20,
p_save_state_before_branch_yn=>'Y',
p_branch_comment=> 'Diese Schaltfläche wird für den Prozess zum Abrufen des nächsten oder vorherigen Primärschlüsselwertes benötigt.');

wwv_flow_api.create_page_branch(
p_id=>14998322826967591 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_branch_action=> 'f?p=&APP_ID.:2:&SESSION.&success_msg=#SUCCESS_MSG#',
p_branch_point=> 'AFTER_PROCESSING',
p_branch_type=> 'REDIRECT_URL',
p_branch_sequence=> 30,
p_branch_condition_type=> 'REQUEST_IN_CONDITION',
p_branch_condition=> 'SAVE,DELETE,CREATE',
p_save_state_before_branch_yn=>'Y',
p_branch_comment=> '');

wwv_flow_api.create_page_branch(
p_id=>15003905642967609 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_branch_action=> 'f?p=&APP_ID.:500:&SESSION.&success_msg=#SUCCESS_MSG#',
p_branch_point=> 'AFTER_PROCESSING',
p_branch_type=> 'REDIRECT_URL',
p_branch_sequence=> 40,
p_save_state_before_branch_yn=>'Y',
p_branch_comment=> '');


end;
/

declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>14997105577967581 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_name=>'P500_IDTREE',
p_data_type=> 'VARCHAR',
p_is_required=> false,
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 1,
p_item_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'NO',
p_prompt=>'Idtree',
p_source=>'IDTREE',
p_source_type=> 'DB_COLUMN',
p_display_as=> 'NATIVE_HIDDEN',
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> null,
p_cMaxlength=> null,
p_cHeight=> null,
p_begin_on_new_line=> 'YES',
p_begin_on_new_field=> 'YES',
p_colspan=> 1,
p_rowspan=> 1,
p_label_alignment=> 'RIGHT',
p_field_alignment=> 'LEFT',
p_field_template=> 7714009168006577+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_attribute_01 => 'Y',
p_item_comment => '');


end;
/

declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>14997305441967588 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_name=>'P500_POSITION',
p_data_type=> 'VARCHAR',
p_is_required=> false,
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 3,
p_item_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'NO',
p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Lage',
p_source=>'POSITION',
p_source_type=> 'DB_COLUMN',
p_display_as=> 'NATIVE_TEXT_FIELD',
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 60,
p_cMaxlength=> 200,
p_cHeight=> 1,
p_begin_on_new_line=> 'YES',
p_begin_on_new_field=> 'YES',
p_colspan=> 1,
p_rowspan=> 1,
p_label_alignment=> 'RIGHT',
p_field_alignment=> 'LEFT',
p_field_template=> 7713916875006577+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'YES',
p_protection_level => 'N',
p_escape_on_http_output => 'Y',
p_attribute_01 => 'N',
p_attribute_02 => 'N',
p_show_quick_picks=>'N',
p_item_comment => '');


end;
/

declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>14997528856967589 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_name=>'P500_TREE_NUMBER',
p_data_type=> 'VARCHAR',
p_is_required=> false,
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 5,
p_item_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'NO',
p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Baumnummer',
p_source=>'TREE_NUMBER',
p_source_type=> 'DB_COLUMN',
p_display_as=> 'NATIVE_TEXT_FIELD',
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 60,
p_cMaxlength=> 255,
p_cHeight=> 1,
p_begin_on_new_line=> 'YES',
p_begin_on_new_field=> 'YES',
p_colspan=> 1,
p_rowspan=> 1,
p_label_alignment=> 'RIGHT',
p_field_alignment=> 'LEFT',
p_field_template=> 7713916875006577+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'YES',
p_protection_level => 'N',
p_escape_on_http_output => 'Y',
p_attribute_01 => 'N',
p_attribute_02 => 'N',
p_show_quick_picks=>'N',
p_item_comment => '');


end;
/

declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>14999301650967594 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_name=>'P500_IDTREE_NEXT',
p_data_type=> 'VARCHAR',
p_is_required=> false,
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 15,
p_item_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_prompt=>'P500_IDTREE_NEXT',
p_display_as=> 'NATIVE_HIDDEN',
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> null,
p_cMaxlength=> null,
p_cHeight=> null,
p_begin_on_new_line=> 'YES',
p_begin_on_new_field=> 'YES',
p_colspan=> 1,
p_rowspan=> 1,
p_label_alignment=> 'LEFT',
p_field_alignment=> 'LEFT',
p_is_persistent=> 'Y',
p_attribute_01 => 'N',
p_item_comment => 'Dieses Element wird für den Prozess zum Abrufen des nächsten oder vorherigen Primärschlüsselwertes benötigt.');


end;
/

declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>14999512622967594 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_name=>'P500_IDTREE_PREV',
p_data_type=> 'VARCHAR',
p_is_required=> false,
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 25,
p_item_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_prompt=>'P500_IDTREE_PREV',
p_display_as=> 'NATIVE_HIDDEN',
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> null,
p_cMaxlength=> null,
p_cHeight=> null,
p_begin_on_new_line=> 'YES',
p_begin_on_new_field=> 'YES',
p_colspan=> 1,
p_rowspan=> 1,
p_label_alignment=> 'LEFT',
p_field_alignment=> 'LEFT',
p_is_persistent=> 'Y',
p_attribute_01 => 'N',
p_item_comment => 'Dieses Element wird für den Prozess zum Abrufen des nächsten oder vorherigen Primärschlüsselwertes benötigt.');


end;
/

declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>14999723348967595 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 500,
p_name=>'P500_IDTREE_COUNT',
p_data_type=> 'VARCHAR',
p_is_required=> false,
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 35,
p_item_plug_id => 14995918716967579+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_source_type=> 'ALWAYS_NULL',
p_display_as=> 'NATIVE_HIDDEN',
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_tag_attributes => 'class="fielddata"',
p_begin_on_new_line=> 'YES',
p_begin_on_new_field=> 'YES',
p_colspan=> 1,
p_rowspan=> 1,
p_label_alignment=> 'LEFT',
p_field_alignment=> 'LEFT',
p_is_persistent=> 'Y',
p_lov_display_extra=>'YES',
p_protection_level => 'N',
p_escape_on_http_output => 'Y',
p_attribute_01 => 'Y',
p_show_quick_picks=>'N',
p_item_comment => 'Dieses Element wird für den Prozess zum Abrufen des nächsten oder vorherigen Primärschlüsselwertes benötigt.');


end;
/


begin

wwv_flow_api.create_page_validation(
p_id => 15002930516967607 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_tabular_form_region_id => 15001100700967600 + wwv_flow_api.g_id_offset,
p_validation_name => 'DATE must be a valid date',
p_validation_sequence=> 30,
p_validation => 'DATE',
p_validation_type => 'COL_IS_DATE',
p_error_message => '#COLUMN_HEADER# muss ein gĂĽltiges Datum sein.',
p_validation_condition=> ':request like (''SAVE'') or :request like ''GET_NEXT%'' or :request like ''GET_PREV%''',
p_validation_condition_type=> 'PLSQL_EXPRESSION',
p_associated_column=> 'DATE',
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> '');

null;

end;
/


begin

wwv_flow_api.create_page_validation(
p_id => 15003117932967607 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_tabular_form_region_id => 15001100700967600 + wwv_flow_api.g_id_offset,
p_validation_name => 'CIRCUMFERENCE must be numeric',
p_validation_sequence=> 40,
p_validation => 'CIRCUMFERENCE',
p_validation_type => 'COL_IS_NUMERIC',
p_error_message => '#COLUMN_HEADER# muss numerisch sein.',
p_validation_condition=> ':request like (''SAVE'') or :request like ''GET_NEXT%'' or :request like ''GET_PREV%''',
p_validation_condition_type=> 'PLSQL_EXPRESSION',
p_associated_column=> 'CIRCUMFERENCE',
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> '');

null;

end;
/


begin

wwv_flow_api.create_page_validation(
p_id => 15003313953967607 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_tabular_form_region_id => 15001100700967600 + wwv_flow_api.g_id_offset,
p_validation_name => 'CORONETDIAMETER must be numeric',
p_validation_sequence=> 50,
p_validation => 'CORONETDIAMETER',
p_validation_type => 'COL_IS_NUMERIC',
p_error_message => '#COLUMN_HEADER# muss numerisch sein.',
p_validation_condition=> ':request like (''SAVE'') or :request like ''GET_NEXT%'' or :request like ''GET_PREV%''',
p_validation_condition_type=> 'PLSQL_EXPRESSION',
p_associated_column=> 'CORONETDIAMETER',
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> '');

null;

end;
/


begin

declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'F|#OWNER#:TREE:P500_IDTREE:IDTREE';

wwv_flow_api.create_page_process(
p_id => 14997824219967590 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_process_sequence=> 10,
p_process_point=> 'AFTER_HEADER',
p_process_type=> 'DML_FETCH_ROW',
p_process_name=> 'Fetch Row from TREE',
p_process_sql_clob => p,
p_process_error_message=> 'Abrufen von Zeile nicht möglich.',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;

end;
/


begin

declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'#OWNER#:TREE:IDTREE::TREE_NUMBER::P500_IDTREE:P500_IDTREE_NEXT:P500_IDTREE_PREV::::P500_IDTREE_COUNT:';

wwv_flow_api.create_page_process(
p_id => 15000109901967597 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_process_sequence=> 20,
p_process_point=> 'AFTER_HEADER',
p_process_type=> 'GET_NEXT_OR_PREV_PK',
p_process_name=> 'Nächsten oder vorherigen Primärschlüsselwert abrufen',
p_process_sql_clob => p,
p_process_error_message=> 'Ausführen von Prozess zum Abrufen des nächsten oder vorherigen Primärschlüsselwertes nicht möglich.',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;

end;
/


begin

declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'#OWNER#:TREE:P500_IDTREE:IDTREE|IUD';

wwv_flow_api.create_page_process(
p_id => 14998026617967590 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_process_sequence=> 10,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'DML_PROCESS_ROW',
p_process_name=> 'Process Row of TREE',
p_process_sql_clob => p,
p_process_error_message=> 'Verarbeiten von Zeile der Tabelle TREE nicht möglich.',
p_process_success_message=> 'Aktion wurde verarbeitet.',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;

end;
/


begin

declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'#OWNER#:GROWTH:IDGROWTH';

wwv_flow_api.create_page_process(
p_id => 15003407512967607 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_process_sequence=> 20,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'MULTI_ROW_UPDATE',
p_process_name=> 'ApplyMRU',
p_process_sql_clob => p,
p_process_error_message=> 'Verarbeiten von Aktualisierung nicht möglich.',
p_process_when=>':request like (''SAVE'') or :request like ''GET_NEXT%'' or :request like ''GET_PREV%''',
p_process_when_type=>'PLSQL_EXPRESSION',
p_process_success_message=> '#MRU_COUNT#-Zeile(n) wurde(n) aktualisiert, #MRI_COUNT#-Zeile(n) wurde(n) eingefĂĽgt.',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;

end;
/


begin

declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'#OWNER#:GROWTH:IDGROWTH';

wwv_flow_api.create_page_process(
p_id => 15003606791967608 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_process_sequence=> 30,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'MULTI_ROW_DELETE',
p_process_name=> 'ApplyMRD',
p_process_sql_clob => p,
p_process_error_message=> 'Verarbeiten von Löschvorgang nicht möglich.',
p_process_when=>'APPLY_CHANGES_MRD',
p_process_when_type=>'REQUEST_IN_CONDITION',
p_process_success_message=> '#MRD_COUNT#-Zeile(n) gelöscht.',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;

end;
/


begin

declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'500';

wwv_flow_api.create_page_process(
p_id => 14998203510967591 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 500,
p_process_sequence=> 40,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'CLEAR_CACHE_FOR_PAGES',
p_process_name=> 'reset page',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_when_button_id=>14996326021967580 + wwv_flow_api.g_id_offset,
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;

end;
/


begin

---------------------------------------
-- ...updatable report columns for page 500
--

begin

wwv_flow_api.create_region_rpt_cols (
p_id => 15012222329070476 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_column_sequence=> 1,
p_query_column_name=> 'IDGROWTH',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15019623817203311 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_column_sequence=> 1,
p_query_column_name=> 'VITALITY_IDVITALITY',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15055611789956746 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15051507839870404 + wwv_flow_api.g_id_offset,
p_column_sequence=> 1,
p_query_column_name=> 'IDART',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15087608249677591 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_column_sequence=> 1,
p_query_column_name=> 'IDPLANTING',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15176731700717526 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_column_sequence=> 1,
p_query_column_name=> 'PEST_IDPEST',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15011713425066393 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_column_sequence=> 2,
p_query_column_name=> 'TREE_IDTREE',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15012304583070477 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_column_sequence=> 2,
p_query_column_name=> 'TREE_IDTREE',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15055726282956746 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15051507839870404 + wwv_flow_api.g_id_offset,
p_column_sequence=> 2,
p_query_column_name=> 'TRIVIALNAME',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15087707220677591 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_column_sequence=> 2,
p_query_column_name=> 'TREE_IDTREE',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15176809222717526 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_column_sequence=> 2,
p_query_column_name=> 'TREE_IDTREE',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15012402975070477 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_column_sequence=> 3,
p_query_column_name=> 'DATE',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15019807194203311 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_column_sequence=> 3,
p_query_column_name=> 'ENTRYDATE',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15055819899956746 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15051507839870404 + wwv_flow_api.g_id_offset,
p_column_sequence=> 3,
p_query_column_name=> 'BINOMIALNAME',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15087800808677591 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15081520211444599 + wwv_flow_api.g_id_offset,
p_column_sequence=> 3,
p_query_column_name=> 'EXTRACTION_IDEXTRACTION',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15176907363717526 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15175303303709347 + wwv_flow_api.g_id_offset,
p_column_sequence=> 3,
p_query_column_name=> 'FIRSTSIGHTING',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15012516304070477 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15001100700967600 + wwv_flow_api.g_id_offset,
p_column_sequence=> 4,
p_query_column_name=> 'CIRCUMFERENCE',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15019910127203311 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_plug_id=> 15009511546039024 + wwv_flow_api.g_id_offset,
p_column_sequence=> 4,
p_query_column_name=> 'DESCRIPTIONOFDAMAGE',
p_display_as=> 'TEXT',
p_column_comment=> '');

wwv_flow_api.create_region_rpt_cols (
p_id => 15087907024677591 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flo



1 mal bearbeitet. Zuletzt am .