prompt --application/pages/page_00202 begin -- Manifest -- PAGE: 00202 -- Manifest End wwv_flow_api.component_begin ( p_version_yyyy_mm_dd=>'2020.10.01' ,p_release=>'20.2.0.00.20' ,p_default_workspace_id=>1824564969550087 ,p_default_application_id=>100 ,p_default_id_offset=>0 ,p_default_owner=>'DEV_CMN' ); wwv_flow_api.create_page( p_id=>202 ,p_user_interface_id=>wwv_flow_api.id(4170609785096443) ,p_name=>unistr('Felhaszn\00E1l\00F3k') ,p_step_title=>unistr('Felhaszn\00E1l\00F3k') ,p_autocomplete_on_off=>'OFF' ,p_page_template_options=>'#DEFAULT#' ,p_last_updated_by=>'USER11' ,p_last_upd_yyyymmddhh24miss=>'20201026121240' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7956980115114795) ,p_plug_name=>unistr('Felhaszn\00E1l\00F3k') ,p_region_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(5136721056108688) ,p_plug_display_sequence=>10 ,p_plug_display_point=>'BODY' ,p_query_type=>'SQL' ,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2( 'select "FELHASZNALO_ID", ', '"BELEPESINEV",', '"JELSZO",', '"CRU",', '"CRD",', '"LMU",', '"LMD",', '"NEV",', '"BEOSZTAS",', '"TELEFON",', '"UTOLSO_BEJELENTKEZES",', '"UTOLSO_JELSZOVALTOZTATAS",', '"EMAIL"', 'from "#OWNER#"."FELHASZNALO" ', ' ', '')) ,p_plug_source_type=>'NATIVE_IR' ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS' ,p_plug_display_condition_type=>'EXPRESSION' ,p_plug_display_when_condition=>':ADMIN_user = ''I'' or :HD_ADMIN =''I''' ,p_plug_display_when_cond2=>'PLSQL' ); wwv_flow_api.create_worksheet( p_id=>wwv_flow_api.id(7957386657114795) ,p_name=>'Report 1' ,p_max_row_count=>'1000000' ,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_show_nulls_as=>'-' ,p_pagination_type=>'ROWS_X_TO_Y' ,p_pagination_display_pos=>'BOTTOM_RIGHT' ,p_report_list_mode=>'TABS' ,p_show_detail_link=>'C' ,p_download_formats=>'CSV:HTML:EMAIL:XLSX:PDF:RTF' ,p_detail_link=>'f?p=&APP_ID.:203:&SESSION.::&DEBUG.::P203_FELHASZNALO_ID,P203_VISSZA:#FELHASZNALO_ID#,202' ,p_detail_link_text=>'Edit' ,p_owner=>'ADMIN' ,p_internal_uid=>7957386657114795 ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3840206224943937) ,p_db_column_name=>'FELHASZNALO_ID' ,p_display_order=>1 ,p_column_identifier=>'A' ,p_column_label=>'Felhasznalo Id' ,p_column_type=>'NUMBER' ,p_display_text_as=>'HIDDEN' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3840684613943940) ,p_db_column_name=>'BELEPESINEV' ,p_display_order=>2 ,p_column_identifier=>'B' ,p_column_label=>unistr('Bel\00E9p\00E9si n\00E9v') ,p_column_type=>'STRING' ,p_heading_alignment=>'LEFT' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3841087666943940) ,p_db_column_name=>'JELSZO' ,p_display_order=>3 ,p_column_identifier=>'C' ,p_column_label=>unistr('Jelsz\00F3') ,p_column_type=>'STRING' ,p_heading_alignment=>'LEFT' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3841463586943940) ,p_db_column_name=>'CRU' ,p_display_order=>4 ,p_column_identifier=>'D' ,p_column_label=>'Cru' ,p_column_type=>'STRING' ,p_display_text_as=>'HIDDEN' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3841874765943941) ,p_db_column_name=>'CRD' ,p_display_order=>5 ,p_column_identifier=>'E' ,p_column_label=>'Crd' ,p_column_type=>'DATE' ,p_display_text_as=>'HIDDEN' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3842236223943941) ,p_db_column_name=>'LMU' ,p_display_order=>6 ,p_column_identifier=>'F' ,p_column_label=>'Lmu' ,p_column_type=>'STRING' ,p_display_text_as=>'HIDDEN' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3842616425943941) ,p_db_column_name=>'LMD' ,p_display_order=>7 ,p_column_identifier=>'G' ,p_column_label=>'Lmd' ,p_column_type=>'DATE' ,p_display_text_as=>'HIDDEN' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3843029592943941) ,p_db_column_name=>'NEV' ,p_display_order=>8 ,p_column_identifier=>'H' ,p_column_label=>'Nev' ,p_column_type=>'STRING' ,p_heading_alignment=>'LEFT' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3843425365943942) ,p_db_column_name=>'BEOSZTAS' ,p_display_order=>9 ,p_column_identifier=>'I' ,p_column_label=>unistr('Beoszt\00E1s') ,p_column_type=>'STRING' ,p_heading_alignment=>'LEFT' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3843824991943942) ,p_db_column_name=>'TELEFON' ,p_display_order=>10 ,p_column_identifier=>'J' ,p_column_label=>'Telefon' ,p_column_type=>'STRING' ,p_heading_alignment=>'LEFT' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3844228797943942) ,p_db_column_name=>'UTOLSO_BEJELENTKEZES' ,p_display_order=>11 ,p_column_identifier=>'K' ,p_column_label=>unistr('Utols\00F3 bejelentkez\00E9s') ,p_column_type=>'DATE' ,p_heading_alignment=>'LEFT' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3844692241943943) ,p_db_column_name=>'UTOLSO_JELSZOVALTOZTATAS' ,p_display_order=>12 ,p_column_identifier=>'L' ,p_column_label=>unistr('Utols\00F3 jelsz\00F3v\00E1ltoztat\00E1s') ,p_column_type=>'DATE' ,p_heading_alignment=>'LEFT' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(3845097967943943) ,p_db_column_name=>'EMAIL' ,p_display_order=>13 ,p_column_identifier=>'M' ,p_column_label=>'Email' ,p_column_type=>'STRING' ,p_display_text_as=>'HIDDEN' ); wwv_flow_api.create_worksheet_rpt( p_id=>wwv_flow_api.id(7963232273115255) ,p_application_user=>'APXWS_DEFAULT' ,p_report_seq=>10 ,p_report_alias=>'38454' ,p_status=>'PUBLIC' ,p_is_default=>'Y' ,p_display_rows=>10 ,p_report_columns=>'FELHASZNALO_ID:BELEPESINEV:JELSZO:CRU:CRD:LMU:LMD:NEV:BEOSZTAS:TELEFON:UTOLSO_BEJELENTKEZES:UTOLSO_JELSZOVALTOZTATAS:EMAIL' ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(3845863792943946) ,p_button_sequence=>30 ,p_button_plug_id=>wwv_flow_api.id(7956980115114795) ,p_button_name=>'CREATE' ,p_button_action=>'REDIRECT_PAGE' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_api.id(4159849636096415) ,p_button_is_hot=>'Y' ,p_button_image_alt=>unistr('\00DAj') ,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR' ,p_button_redirect_url=>'f?p=&APP_ID.:203:&SESSION.::&DEBUG.:203:P203_VISSZA:202' ); wwv_flow_api.component_end; end; /