* Name ENT_PIC - Subclass Information - Comments - Help Book Title * Title MODULE1 * Console Window WINDOW1 * Menu Module t:\chah\menu\defmenu.mmx - Initial Menu - Defer Required Enforcement No - Menu Role - Mouse Navigation Limit Form - First Navigation Data Block - Current Record Visual Attribute Group - Validation Unit Default - Interaction Mode Blocking - Maximum Query Time 0 - Maximum Records Fetched 0 - Isolation Mode Read Committed * Coordinate System ---------- * Coordinate System Real * Real Unit Point * Default Font Scaling Yes * Character Cell Height 14 * Character Cell Width 7 ---------- - Use 3D Controls Yes - Form Horizontal Toolbar Canvas - Form Vertical Toolbar Canvas - Direction Default * Triggers ---------- * Name ON-ERROR - Subclass Information - Comments - Trigger Style PL/SQL * Trigger Text declare err_cod Number :=ERROR_CODE; err_typ varchar2(30) :=ERROR_TYPE; err_txt varchar2(80) :=ERROR_TEXT; err_onvan varchar2(80); err_noe varchar2(30); begin select ma_type,ma_onvan into err_noe,err_onvan from DT_MESSAGE where ma_code=err_cod; message(err_noe || ':' || err_onvan); exception when NO_DATA_FOUND then message(err_typ || to_char(err_cod) || ': ' || err_txt); end; - Fire in Enter-Query Mode Yes - Execution Hierarchy Override - Display in 'Keyboard Help' No - 'Keyboard Help' Text - Trigger Steps ---------- * Name ON-MESSAGE - Subclass Information - Comments - Trigger Style PL/SQL * Trigger Text declare err_cod Number :=MESSAGE_CODE; err_typ varchar2(30) :=MESSAGE_TYPE; err_txt varchar2(80) :=MESSAGE_TEXT; err_onvan varchar2(80); err_noe varchar2(30); begin select ma_type,ma_onvan into err_noe,err_onvan from DT_MESSAGE where ma_code=err_cod; message(err_noe || ':' || err_onvan); exception when NO_DATA_FOUND then message(err_typ || to_char(err_cod) || ': ' || err_txt); end; - Fire in Enter-Query Mode Yes - Execution Hierarchy Override - Display in 'Keyboard Help' No - 'Keyboard Help' Text - Trigger Steps ---------- * Name WHEN-NEW-FORM-INSTANCE - Subclass Information - Comments - Trigger Style PL/SQL * Trigger Text declare P_List PARAMLIST; begin --------------- GET FORM NAME :global.form_nam := get_application_property(current_form_name); ----------------------------------------------------------- P_List := create_PARAMETER_LIST('PARAM_LIST'); if not ID_NULL(P_List) then ADD_PARAMETER(P_List,'P_FORM',TEXT_PARAMETER,upper(:global.form_nam)); end if; ------------------------------------------------------- select DT_JADVAL.MA_ONVAN into :global.SysPath from DT_JADVAL where DT_JADVAL.MA_CODE=500; SELECT MA_SAL_MALY INTO :PARAMETER.P_SAL FROM DT_SAL_MALY WHERE MA_USER=USER; ---------------------------------------------------------- set_window_property('window1',window_state,maximize); set_window_property(forms_mdi_window,window_state,maximize); :CONTROL.Tarikh_Rooz := SysDate; exception when NO_DATA_FOUND then NULL; end; - Fire in Enter-Query Mode Yes - Execution Hierarchy Override - Display in 'Keyboard Help' No - 'Keyboard Help' Text - Trigger Steps ---------- - Alerts - Attached PL/SQL Libraries * Blocks ---------- * Name DOCS_COMP_DOCUMENTS - Subclass Information - Comments - Navigation Style Same Record - Previous Navigation Data Block - Next Navigation Data Block - Current Record Visual Attribute Group - Query Array Size 0 - Number of Records Buffered 0 - Number of Records Displayed 1 - Query All Records No - Record Orientation Vertical - Single Record No - Database Data Block Yes - Enforce Primary Key No - Query Allowed Yes - Query Data Source Type Table * Query Data Source Name DT_TASVIR_MAST * Query Data Source Columns ---------- * Column Name MA_ESHT * Column Type NUMBER - Column Type Name - Parent Column * Length 0 * Precision 6 * Scale 0 * Mandatory Yes ---------- * Column Name MA_RADIF * Column Type NUMBER - Column Type Name - Parent Column * Length 0 * Precision 6 * Scale 0 * Mandatory Yes ---------- * Column Name MA_DOC_SCANNED * Column Type LONG RAW - Column Type Name - Parent Column * Length 0 * Precision 0 * Scale 0 * Mandatory No ---------- * Column Name FILE_NAME * Column Type VARCHAR2 - Column Type Name - Parent Column * Length 50 * Precision 0 * Scale 0 * Mandatory No ---------- * Column Name FILE_EXTENSION * Column Type VARCHAR2 - Column Type Name - Parent Column * Length 3 * Precision 0 * Scale 0 * Mandatory No ---------- - Query Data Source Arguments - Alias - Include REF Item No - WHERE Clause - ORDER BY Clause - Optimizer Hint - Insert Allowed Yes - Update Allowed Yes - Locking Mode Automatic - Delete Allowed Yes - Key Mode Automatic - Update Changed Columns Only No - Enforce Column Security No - Maximum Query Time 0 - Maximum Records Fetched 0 - DML Data Target Type Table - DML Data Target Name - Insert Procedure Name - Insert Procedure Result Set Columns - Insert Procedure Arguments - Update Procedure Name - Update Procedure Result Set Columns - Update Procedure Arguments - Delete Procedure Name - Delete Procedure Result Set Columns - Delete Procedure Arguments - Lock Procedure Name - Lock Procedure Result Set Columns - Lock Procedure Arguments - DML Array Size 1 - Precompute Summaries No - DML Returning Value No - Show Scroll Bar No - Scroll Bar Canvas - Scroll Bar Tab Page - Scroll Bar Orientation Vertical - Scroll Bar X Position 0 - Scroll Bar Y Position 0 * Scroll Bar Width 14 * Scroll Bar Length 135 - Scroll Bar Height 0 - Reverse Direction No - Visual Attribute Group DEFAULT - Foreground Color - Background Color - Fill Pattern - Direction Default - Triggers * Items ---------- * Name MA_ESHT * Item Type Text Item - Subclass Information - Comments - Help Book Topic - Enabled Yes - Justification Start - Implementation Class - Multi-Line No - Wrap Style Word - Case Restriction Mixed - Conceal Data No - Keep Cursor Position No - Automatic Skip No - Popup Menu - Keyboard Navigable Yes - Previous Navigation Item - Next Navigation Item * Data Type Number - Data Length Semantics Null * Maximum Length 7 - Initial Value * Required No - Format Mask - Lowest Allowed Value - Highest Allowed Value - Copy Value from Item - Synchronize with Item - Calculation Mode None - Formula - Summary Function None - Summarized Block - Summarized Item - Current Record Visual Attribute Group - Distance Between Records 0 - Number of Items Displayed 0 - Database Item Yes * Column Name MA_ESHT - Primary Key No - Query Only No - Query Allowed Yes - Query Length 0 - Case Insensitive Query No - Insert Allowed Yes - Update Allowed Yes - Update Only if NULL No - Lock Record No - List of Values - List X Position 0 - List Y Position 0 - Validate from List No - Editor - Editor X Position 0 - Editor Y Position 0 - Visible Yes * Canvas CANVAS2 * Tab Page * X Position 69 * Y Position 49 * Width 50 * Height 20 - Bevel Lowered - Rendered Yes - Show Vertical Scroll Bar No - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT - Foreground Color - Background Color - Fill Pattern - Font * Font Name Tahoma * Font Size 8 * Font Weight Bold * Font Style Plain * Font Spacing Normal * Prompt number - Prompt Display Style First Record - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start * Prompt Attachment Offset 3 * Prompt Alignment Offset 3 - Prompt Reading Order Default * Prompt Foreground Color darkred - Prompt Font * Prompt Font Name Tahoma * Prompt Font Size 8 * Prompt Font Weight Bold * Prompt Font Style Plain * Prompt Font Spacing Normal - Hint - Display Hint Automatically No - Tooltip - Tooltip Visual Attribute Group - Initial Keyboard State Default - Reading Order Default - Keyboard State Any - Triggers ---------- * Name MA_RADIF * Item Type Text Item - Subclass Information - Comments - Help Book Topic - Enabled Yes - Justification Start - Implementation Class - Multi-Line No - Wrap Style Word - Case Restriction Mixed - Conceal Data No - Keep Cursor Position No - Automatic Skip No - Popup Menu - Keyboard Navigable Yes - Previous Navigation Item - Next Navigation Item * Data Type Number - Data Length Semantics Null * Maximum Length 7 - Initial Value * Required No - Format Mask - Lowest Allowed Value - Highest Allowed Value - Copy Value from Item - Synchronize with Item - Calculation Mode None - Formula - Summary Function None - Summarized Block - Summarized Item - Current Record Visual Attribute Group - Distance Between Records 0 - Number of Items Displayed 0 - Database Item Yes * Column Name MA_RADIF - Primary Key No - Query Only No - Query Allowed Yes - Query Length 0 - Case Insensitive Query No - Insert Allowed Yes - Update Allowed Yes - Update Only if NULL No - Lock Record No - List of Values - List X Position 0 - List Y Position 0 - Validate from List No - Editor - Editor X Position 0 - Editor Y Position 0 - Visible Yes * Canvas CANVAS2 * Tab Page * X Position 69 * Y Position 73 * Width 35 * Height 17 - Bevel Lowered - Rendered Yes - Show Vertical Scroll Bar No - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT - Foreground Color - Background Color - Fill Pattern - Font * Font Name Tahoma * Font Size 8 * Font Weight Bold * Font Style Plain * Font Spacing Normal * Prompt index - Prompt Display Style First Record - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start * Prompt Attachment Offset 4 * Prompt Alignment Offset 1 - Prompt Reading Order Default * Prompt Foreground Color darkred - Prompt Font * Prompt Font Name Tahoma * Prompt Font Size 8 * Prompt Font Weight Bold * Prompt Font Style Plain * Prompt Font Spacing Normal - Hint - Display Hint Automatically No - Tooltip - Tooltip Visual Attribute Group - Initial Keyboard State Default - Reading Order Default - Keyboard State Any - Triggers ---------- * Name MA_DOC_SCANNED * Item Type Image - Subclass Information - Comments - Help Book Topic - Enabled Yes - Image Format TIFF - Image Depth Original - Display Quality High - Sizing Style Crop - Popup Menu - Keyboard Navigable Yes - Previous Navigation Item - Next Navigation Item - Required No - Synchronize with Item - Current Record Visual Attribute Group - Distance Between Records 0 - Number of Items Displayed 0 - Database Item Yes * Column Name MA_DOC_SCANNED - Query Only No - Insert Allowed Yes - Update Allowed Yes - Update Only if NULL No - Lock Record No - Visible Yes * Canvas CANVAS2 * Tab Page * X Position 161 - Y Position 0 * Width 601 * Height 459 - Bevel Lowered * Show Horizontal Scroll Bar Yes * Show Vertical Scroll Bar Yes - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT - Background Color - Fill Pattern - Font - Font Name - Font Size 0 - Font Weight Medium - Font Style Plain - Font Spacing Normal * Prompt - Prompt Display Style First Record - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start - Prompt Attachment Offset 0 - Prompt Alignment Offset 0 - Prompt Reading Order Default - Prompt Foreground Color - Prompt Font - Prompt Font Name - Prompt Font Size 0 - Prompt Font Weight Medium - Prompt Font Style Plain - Prompt Font Spacing Normal - Hint - Display Hint Automatically No - Tooltip - Tooltip Visual Attribute Group - Triggers ---------- * Name FILE_NAME * Item Type Display Item - Subclass Information - Comments - Help Book Topic - Justification Start - Popup Menu - Previous Navigation Item - Next Navigation Item - Data Type Char - Data Length Semantics Null * Maximum Length 50 - Initial Value - Format Mask - Copy Value from Item - Synchronize with Item - Calculation Mode None - Formula - Summary Function None - Summarized Block - Summarized Item - Current Record Visual Attribute Group * Distance Between Records 108 * Number of Items Displayed 0 - Database Item Yes * Column Name FILE_NAME - Primary Key No - Query Only No - Visible Yes * Canvas CANVAS2 * Tab Page * X Position 67 * Y Position 171 * Width 88 * Height 19 - Bevel Lowered - Rendered Yes - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT - Foreground Color - Background Color - Fill Pattern - Font * Font Name Tahoma * Font Size 9 * Font Weight Bold * Font Style Plain * Font Spacing Normal - Prompt * Prompt Display Style All Records - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start * Prompt Attachment Offset 7 - Prompt Alignment Offset 0 - Prompt Reading Order Default * Prompt Foreground Color darkred - Prompt Font * Prompt Font Name Tahoma * Prompt Font Size 8 * Prompt Font Weight Bold * Prompt Font Style Plain * Prompt Font Spacing Normal - Tooltip - Tooltip Visual Attribute Group - Initial Keyboard State Default - Reading Order Default - Keyboard State Any - Triggers ---------- * Name FILE_EXTENSION * Item Type Display Item - Subclass Information - Comments - Help Book Topic - Justification Start - Popup Menu - Previous Navigation Item - Next Navigation Item - Data Type Char - Data Length Semantics Null * Maximum Length 3 - Initial Value - Format Mask - Copy Value from Item - Synchronize with Item - Calculation Mode None - Formula - Summary Function None - Summarized Block - Summarized Item - Current Record Visual Attribute Group * Distance Between Records 108 * Number of Items Displayed 0 - Database Item Yes * Column Name FILE_EXTENSION - Primary Key No - Query Only No - Visible Yes * Canvas CANVAS2 * Tab Page * X Position 66 * Y Position 192 * Width 20 * Height 19 - Bevel Lowered - Rendered Yes - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT - Foreground Color - Background Color - Fill Pattern - Font * Font Name Tahoma * Font Size 9 * Font Weight Bold * Font Style Plain * Font Spacing Normal - Prompt * Prompt Display Style All Records - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start * Prompt Attachment Offset 7 - Prompt Alignment Offset 0 - Prompt Reading Order Default * Prompt Foreground Color darkred - Prompt Font * Prompt Font Name Tahoma * Prompt Font Size 8 * Prompt Font Weight Bold * Prompt Font Style Plain * Prompt Font Spacing Normal - Tooltip - Tooltip Visual Attribute Group - Initial Keyboard State Default - Reading Order Default - Keyboard State Any - Triggers ---------- - Relations ---------- * Name CONTROL - Subclass Information - Comments - Navigation Style Same Record - Previous Navigation Data Block - Next Navigation Data Block - Current Record Visual Attribute Group - Query Array Size 0 - Number of Records Buffered 0 - Number of Records Displayed 1 - Query All Records No - Record Orientation Vertical - Single Record No * Database Data Block No - Enforce Primary Key No - Query Allowed Yes - Query Data Source Type Table - Query Data Source Name - Query Data Source Columns - Query Data Source Arguments - Alias - Include REF Item No - WHERE Clause - ORDER BY Clause - Optimizer Hint - Insert Allowed Yes - Update Allowed Yes - Locking Mode Automatic - Delete Allowed Yes - Key Mode Automatic - Update Changed Columns Only No - Enforce Column Security No - Maximum Query Time 0 - Maximum Records Fetched 0 - DML Data Target Type Table - DML Data Target Name - Insert Procedure Name - Insert Procedure Result Set Columns - Insert Procedure Arguments - Update Procedure Name - Update Procedure Result Set Columns - Update Procedure Arguments - Delete Procedure Name - Delete Procedure Result Set Columns - Delete Procedure Arguments - Lock Procedure Name - Lock Procedure Result Set Columns - Lock Procedure Arguments - DML Array Size 1 - Precompute Summaries No - DML Returning Value No - Show Scroll Bar No - Scroll Bar Canvas - Scroll Bar Tab Page - Scroll Bar Orientation Vertical - Scroll Bar X Position 0 - Scroll Bar Y Position 0 * Scroll Bar Width 14 * Scroll Bar Length 135 - Scroll Bar Height 0 - Reverse Direction No - Visual Attribute Group DEFAULT - Foreground Color - Background Color - Fill Pattern - Direction Default - Triggers * Items ---------- * Name TARIKH_ROOZ * Item Type Display Item - Subclass Information - Comments - Help Book Topic - Justification Start - Popup Menu - Previous Navigation Item - Next Navigation Item * Data Type Date - Data Length Semantics Null * Maximum Length 10 - Initial Value * Format Mask YYYY/MM/DD - Copy Value from Item - Synchronize with Item - Calculation Mode None - Formula - Summary Function None - Summarized Block - Summarized Item - Current Record Visual Attribute Group - Distance Between Records 0 - Number of Items Displayed 0 - Database Item Yes - Column Name - Primary Key No - Query Only No - Visible Yes * Canvas CANVAS2 * Tab Page * X Position 15 * Y Position 8 * Width 68 * Height 19 - Bevel Lowered - Rendered Yes - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT * Foreground Color r0g0b50 * Background Color r75g88b100 - Fill Pattern - Font * Font Name Tahoma * Font Size 8 * Font Weight Bold * Font Style Plain * Font Spacing Normal * Prompt Date - Prompt Display Style First Record - Prompt Justification Start * Prompt Attachment Edge End * Prompt Alignment Center * Prompt Attachment Offset 6 - Prompt Alignment Offset 0 - Prompt Reading Order Default - Prompt Foreground Color - Prompt Font * Prompt Font Name Tahoma * Prompt Font Size 10 * Prompt Font Weight Bold * Prompt Font Style Plain * Prompt Font Spacing Normal - Tooltip - Tooltip Visual Attribute Group - Initial Keyboard State Default - Reading Order Default - Keyboard State Any - Triggers ---------- * Name FILE_PATH * Item Type Text Item - Subclass Information - Comments - Help Book Topic * Enabled No - Justification Start - Implementation Class - Multi-Line No - Wrap Style Word * Case Restriction Upper - Conceal Data No - Keep Cursor Position No - Automatic Skip No - Popup Menu * Keyboard Navigable No - Previous Navigation Item - Next Navigation Item - Data Type Char - Data Length Semantics Null * Maximum Length 200 - Initial Value - Required No - Format Mask - Lowest Allowed Value - Highest Allowed Value - Copy Value from Item - Synchronize with Item - Calculation Mode None - Formula - Summary Function None - Summarized Block - Summarized Item - Current Record Visual Attribute Group - Distance Between Records 0 - Number of Items Displayed 0 * Database Item No - Column Name - Primary Key No - Query Only No - Query Allowed Yes - Query Length 0 - Case Insensitive Query No - Insert Allowed Yes - Update Allowed Yes - Update Only if NULL No - Lock Record No - List of Values - List X Position 0 - List Y Position 0 - Validate from List No - Editor - Editor X Position 0 - Editor Y Position 0 - Visible Yes * Canvas CANVAS2 * Tab Page * X Position 3 * Y Position 229 * Width 154 * Height 17 - Bevel Lowered - Rendered Yes - Show Vertical Scroll Bar No - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT * Foreground Color black * Background Color white * Fill Pattern none - Font * Font Name Arial * Font Size 8 * Font Weight Bold * Font Style Plain * Font Spacing Normal - Prompt - Prompt Display Style First Record - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start - Prompt Attachment Offset 0 - Prompt Alignment Offset 0 - Prompt Reading Order Default - Prompt Foreground Color - Prompt Font - Prompt Font Name - Prompt Font Size 0 - Prompt Font Weight Medium - Prompt Font Style Plain - Prompt Font Spacing Normal - Hint - Display Hint Automatically No - Tooltip - Tooltip Visual Attribute Group - Initial Keyboard State Default - Reading Order Default - Keyboard State Any - Triggers ---------- * Name BUT_BROWSE * Item Type Push Button - Subclass Information - Comments - Help Book Topic - Enabled Yes * Label brows - Access Key - Implementation Class - Iconic No - Icon Filename - Default Button No - Popup Menu * Keyboard Navigable No * Mouse Navigate No - Previous Navigation Item - Next Navigation Item - Current Record Visual Attribute Group - Distance Between Records 0 - Number of Items Displayed 0 - Visible Yes * Canvas CANVAS2 - Tab Page * X Position 5 * Y Position 256 * Width 47 * Height 19 - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT * Foreground Color black * Background Color white - Fill Pattern - Font * Font Name Tahoma * Font Size 8 * Font Weight Demilight * Font Style Plain * Font Spacing Normal - Prompt - Prompt Display Style First Record - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start - Prompt Attachment Offset 0 - Prompt Alignment Offset 0 - Prompt Reading Order Default - Prompt Foreground Color - Prompt Font - Prompt Font Name - Prompt Font Size 0 - Prompt Font Weight Medium - Prompt Font Style Plain - Prompt Font Spacing Normal - Hint - Display Hint Automatically No - Tooltip - Tooltip Visual Attribute Group - Direction Default * Triggers ---------- * Name WHEN-BUTTON-PRESSED - Subclass Information - Comments - Trigger Style PL/SQL * Trigger Text :CONTROL.file_path := get_file_name('C:\ADMINDOCS', NULL, 'JPEG Image (*.JPG,*.JPEG,*.JPE,*.JFIF)|*.JPG|Bitmap Image (*.bmp)|*.bmp|GIF Image (*.GIF)|*.GIF|TIFF Files (*.tif)|*.tif|All Files (*.*)|*.*|', NULL); - Fire in Enter-Query Mode Yes - Execution Hierarchy Override - Display in 'Keyboard Help' No - 'Keyboard Help' Text - Trigger Steps ---------- ---------- * Name BUT_SAVE * Item Type Push Button - Subclass Information - Comments - Help Book Topic - Enabled Yes * Label Get Picture - Access Key - Implementation Class - Iconic No - Icon Filename - Default Button No - Popup Menu * Keyboard Navigable No * Mouse Navigate No - Previous Navigation Item - Next Navigation Item - Current Record Visual Attribute Group - Distance Between Records 0 - Number of Items Displayed 0 - Visible Yes * Canvas CANVAS2 - Tab Page * X Position 55 * Y Position 256 * Width 55 * Height 18 - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT * Foreground Color black * Background Color white - Fill Pattern - Font * Font Name Tahoma * Font Size 8 * Font Weight Demilight * Font Style Plain * Font Spacing Normal - Prompt - Prompt Display Style First Record - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start - Prompt Attachment Offset 0 - Prompt Alignment Offset 0 - Prompt Reading Order Default - Prompt Foreground Color - Prompt Font - Prompt Font Name - Prompt Font Size 0 - Prompt Font Weight Medium - Prompt Font Style Plain - Prompt Font Spacing Normal - Hint - Display Hint Automatically No - Tooltip - Tooltip Visual Attribute Group - Direction Default * Triggers ---------- * Name WHEN-BUTTON-PRESSED - Subclass Information - Comments - Trigger Style PL/SQL * Trigger Text DECLARE image_path VARCHAR2(200); image_extension VARCHAR2(3); BEGIN image_path := :CONTROL.file_path; image_extension := SUBSTR(:CONTROL.file_path, -3); READ_IMAGE_FILE(:CONTROL.file_path, image_extension, 'DOCS_COMP_DOCUMENTS.MA_DOC_SCANNED'); IF NOT FORM_SUCCESS THEN RAISE FORM_TRIGGER_FAILURE; ELSE -- This is a stored procedure which gets the file name and extension from the given path -- First argument is the IN parameter which gets the path and 2nd and 3rd argument are the -- out parameters which give the returning value of filename and the extension simultaneously. Get_File_Name_Extension(:CONTROL.file_path, :DOCS_COMP_DOCUMENTS.file_name, :DOCS_COMP_DOCUMENTS.file_extension); COMMIT_FORM; END IF; END; - Fire in Enter-Query Mode Yes - Execution Hierarchy Override - Display in 'Keyboard Help' No - 'Keyboard Help' Text - Trigger Steps ---------- ---------- * Name PB_RUN_REPORT * Item Type Push Button - Subclass Information - Comments - Help Book Topic * Enabled No * Label Report - Access Key - Implementation Class - Iconic No - Icon Filename - Default Button No - Popup Menu * Keyboard Navigable No * Mouse Navigate No - Previous Navigation Item - Next Navigation Item - Current Record Visual Attribute Group - Distance Between Records 0 * Number of Items Displayed 1 - Visible Yes * Canvas CANVAS2 - Tab Page * X Position 115 * Y Position 256 * Width 41 * Height 19 - Visual Attribute Group DEFAULT - Prompt Visual Attribute Group DEFAULT * Foreground Color black * Background Color gray24 - Fill Pattern - Font * Font Name Tahoma * Font Size 8 * Font Weight Bold * Font Style Plain * Font Spacing Normal - Prompt - Prompt Display Style First Record - Prompt Justification Start - Prompt Attachment Edge Start - Prompt Alignment Start - Prompt Attachment Offset 0 - Prompt Alignment Offset 0 - Prompt Reading Order Default - Prompt Foreground Color - Prompt Font - Prompt Font Name - Prompt Font Size 0 - Prompt Font Weight Medium - Prompt Font Style Plain - Prompt Font Spacing Normal - Hint - Display Hint Automatically No - Tooltip - Tooltip Visual Attribute Group - Direction Default * Triggers ---------- * Name WHEN-BUTTON-PRESSED - Subclass Information - Comments - Trigger Style PL/SQL * Trigger Text /*This code is to RUN the document report stored in database. If you need this code just createa a report and remove the comments. DECLARE pl_id ParamList; pl_name VARCHAR2(10) := 'tempdata'; BEGIN --**************************************PRINTING ******************************** pl_id := Get_Parameter_List(pl_name); IF NOT Id_Null(pl_id) THEN destroy_Parameter_List(pl_name); END IF; pl_id := Create_Parameter_List(pl_name); IF Id_Null(pl_id) THEN Message('Error creating parameter list '||pl_name); RAISE Form_Trigger_Failure; END IF; add_parameter(pl_id,'paramform',text_parameter,'no'); add_parameter(pl_id,'destype',text_parameter,'PREVIEW'); add_parameter(pl_id,'P_DOC_ID',text_parameter,:DOCS_COMP_DOCUMENTS.doc_id); RUN_PRODUCT(reports,'COMPANY_DOCS',synchronous,runtime,filesystem,pl_id,null); END; */ MESSAGE('Code is Disabled at the moment'); - Fire in Enter-Query Mode Yes - Execution Hierarchy Override - Display in 'Keyboard Help' No - 'Keyboard Help' Text - Trigger Steps ---------- ---------- - Relations ---------- * Canvases ---------- * Name CANVAS2 * Canvas Type Content - Subclass Information - Comments - Help Book Topic - Raise on Entry No - Popup Menu - Visible Yes * Window WINDOW1 - Viewport X Position on Canvas 0 - Viewport Y Position on Canvas 0 * Width 766 * Height 464 - Bevel Lowered - Visual Attribute Group DEFAULT - Foreground Color - Background Color - Fill Pattern - Direction Default * Graphics Objects ---------- * Name TEXT8 * Graphics Type Text - Subclass Information * X Position 5 * Y Position 216 * Width 91 * Height 10 - Line Width 0 - Dash Style Solid - Cap Style Butt - Join Style Mitre - Rotation Angle 0 - Custom Spacing 0 - Line Spacing Single - Fixed Bounding Box No - Wrap Text Yes - Bounding Box Scaleable Yes - Font Scaleable No * Horizontal Justification Start - Vertical Justification Top - Horizontal Origin Left - Vertical Origin Top * Bevel None - Visual Attribute Group DEFAULT * Foreground Color darkred * Background Color gray36 * Fill Pattern none - Edge Foreground Color - Edge Background Color * Edge Pattern none - Direction Default * Compound Text Objects ---------- * Name CMPTXT9 * Simple Text Objects ---------- * Name TEXTSTR10 - Help Book Topic * List Item Value path * Foreground Color darkred - Font * Font Name Tahoma * Font Size 8 * Font Weight Bold * Font Style Plain * Font Spacing Normal ---------- ---------- ---------- ---------- - Editors * Form Parameters ---------- * Name P_SAL - Subclass Information - Comments * Parameter Data Type Number - Parameter Initial Value ---------- - Lists of Values - Menus - Object Groups - Program Units - Property Classes - Record Groups - Reports - Visual Attributes * Windows ---------- * Name WINDOW1 - Subclass Information - Comments - Help Book Topic - Title - Primary Canvas - Horizontal Toolbar Canvas - Vertical Toolbar Canvas - Window Style Document - Modal No - Hide on Exit No - Close Allowed Yes - Move Allowed Yes - Resize Allowed Yes - Maximize Allowed Yes - Minimize Allowed Yes - Minimized Title - Icon Filename - Inherit Menu Yes - X Position 0 - Y Position 0 * Width 767 * Height 464 - Bevel Lowered - Show Horizontal Scroll Bar No - Show Vertical Scroll Bar No - Visual Attribute Group DEFAULT - Foreground Color - Background Color - Fill Pattern - Font - Font Name - Font Size 0 - Font Weight Medium - Font Style Plain - Font Spacing Normal - Direction Default ----------