Results for “update_line_cache”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.OE_BLANKET_FORM_CONTROL is a forms-support PL/SQL package body that underpins the Oracle Order Management blanket sales agreement (blanket order) maintenance form in Oracle E-Business Suite 12.1.1 and 12.2.2. The package implements the "form control" layer that the Blanket Sales Agreements window calls to translate form field values into the underlying Order Management public API record structures, enforce entity validation, manage partial-row persistence, and apply header- and line-level security. It is classified in ETRM as an OTHER API, indicating it is not intended as a standalone public integration API but rather as an internal engine driving the OA Framework / Forms UI.
The naming and the "blank kit form" association arise because the same form-control mechanism handles the entry and maintenance of blanket agreement headers and their associated lines, including configurations where a blanket line is a kit or model with components. The package relies on the record types exposed by OE_BLANKET_PUB and OE_ORDER_PUB, converting form input into those canonical structures before persisting through the base tables.
Key Procedures and Functions
- HEADER_VALUE_CONVERSION and LINE_VALUE_CONVERSION translate the form's individual field values into the corresponding OE_BLANKET_PUB header and line record types, mapping IDs such as agreement_id, price_list_id, order_type_id, and shipping/payment attributes onto the API structures.
- POPULATE_HEADER_VALUES_ID and POPULATE_LINE_VALUES_ID populate the value-ID record structures used during insert and update processing.
- VALIDATE_ENTITY performs entity-level validation before a save.
- INSERT_ROW, UPDATE_ROW, and DELETE_ROW implement the create, modify, and delete operations for blanket header and line rows as invoked from the form.
- DEFAULT_ATTRIBUTES and PROCESS_OBJECT orchestrate attribute defaulting and the overall form save workflow, sequencing validation, security checks, conversion, and persistence.
- CHECK_SEC_HEADER_ATTR, CHECK_SEC_LINE_ATTR, CHECK_SEC_HEADER_ENTITY, and CHECK_SEC_LINE_ENTITY enforce header- and line-level attribute and entity security, preventing access to records the user is not authorized to view or maintain.
- UPDATE_HEADER_CACHE and UPDATE_LINE_CACHE maintain the package-level header and line caches (G_Header_Cache_Rec, G_Line_Cache_Rec) that hold working copies of the form data.
- LOCK_HEADER_ROW and LOCK_LINE_ROW obtain row-level locks to protect concurrent modification of blanket orders.
- LOAD_BLANKET_LINE_NUMBER and LOAD_BLANKET_HEADER_REC load the blanket line number and reconstruct the cached header record from persistent storage.
Tables Accessed
The package operates against the core blanket agreement and order tables through APPS synonyms. It reads and writes OE_BLANKET_HEADERS and OE_BLANKET_HEADERS_ALL for agreement header data, and OE_BLANKET_LINES for line-level agreement data. It references OE_ORDER_HEADERS and OE_ORDER_LINES, reflecting the shared order capture model used for blanket orders. OE_TRANSACTION_TYPES_ALL supplies order type validation and defaulting, while PLITBLM is the standard multi-language / translation support table used for descriptive attributes. These accesses align with the convert-validate-persist flow driven by OE_BLANKET_PUB.
Usage Notes
OE_BLANKET_FORM_CONTROL is invoked primarily from the Oracle Order Management Blanket Sales Agreements form and is referenced by two other packages. It should not normally be called directly by customers; supported integration should use the documented OE_BLANKET_PUB APIs. Custom extensions that must intervene during blanket order entry typically do so through form personalization or by wrapping OE_BLANKET_PUB rather than calling this form-control package, which assumes an active Forms session, session-level security context, and the package globals being initialized before use.