Flex Your ApEx [教程].ppt

Flex Your ApEx Implementing OracleE-Business SuiteDescriptive Flexfieldsin Application Express Descriptive Flexfield Intro Descriptive flexfields provide a flexible way for Oracle Applications to provide customizable spaces within a page or pages of an application. (/technology/tech/blaf/specs/flexfields.html) Generic columns (traditionally called attributes) for: potential future use storing mutually exclusive data to conserve space A dedicated governing column (traditionally named ATTRIBUTE_CATEGORY) is used to define a context-sensitive purpose of these generic columns. Example: Payment Types (Credit Card, Cash, E-Pay, etc.) Descriptive Flexfield Intro Necessary Rules (for this method): Value sets assigned to attributes must have a validation type of “Table”. If an attribute column is to be a free-form text item, there should be no value set assigned to it. General Overview Multiple versions (free text, select list, pop-up list) of ATTRIBUTE items on your Application Express page Two functions in the APPS schema to dynamically build the valid list of options for select and pop-up lists Two On Demand application-level processes and one application-level item Javascript to make everything appear magical show/hide appropriate items AJAX used to retrieve the validation lists changing the label on each attribute field All code is provided in hand-out Page Items Create the following items: a Text Field, Select List, and Pop-Up Key LOV version of each attribute database column a hidden item for each attribute to store the value set ID if the attribute has a table-based value set Page Items Page items needing to be created: Page Items (Pop-Up Key LOV) Pop-Up Key LOV items should have the following characteristics: a Source Type of “Always Null” a List of Values source which calls a packaged function to dynamically build the validation list. Example: begin return ( generate_attribute_lov ( :attribute1_vset_id ) ); end; Stored Functions GENERATE_AT