Results for “ece_flatfile_pvt”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.ECE_FLATFILE_PVT is a private PL/SQL package body in the Oracle E-Business Suite E-Commerce Gateway (ECE) module. It provides the internal engine that transforms interface table data into flat-file output records destined for external trading partners. Unlike public ECE APIs, this package is classified as PVT (private), meaning it is not intended to be called directly by customer extensions, forms, or concurrent programs; it is invoked internally by the higher-level ECE flat-file generation logic that drives outbound transactions such as purchase orders, invoices, and ship notices.
The package operates on the metadata-driven mapping architecture of E-Commerce Gateway. It reads interface table and column definitions, mapping rules, and conversion groups from the ECE setup tables, then assembles output lines in the ECE output tables. It relies on dynamic SQL (DBMS_SQL) and dynamic PL/SQL execution to handle the variable, configuration-driven column structures defined by the customer's interface layout.
Key Procedures and Functions
The package exposes sixteen documented subprograms, though as a PVT body these are internal helpers rather than a supported API surface. Representative members include:
- GET_TRAN_ATTRIBUTES — retrieves transaction and interface attributes that govern how a given document type is flattened.
- PRINT_ATTRIBUTES — renders attribute values, typically for debug or diagnostic output.
- SELECT_CLAUSE — constructs the SQL SELECT text used to read source data from interface tables dynamically.
- WRITE_TO_ECE_OUTPUT — inserts assembled records into the ECE output tables that downstream processes consume.
- INIT_TABLE — initializes internal PL/SQL table structures before processing.
- DEFINE_INTERFACE_COLUMN_TYPE — resolves the data type and handling of an interface column based on setup metadata.
- ASSIGN_COLUMN_VALUE_TO_TBL — populates internal table structures with column values during assembly.
- FIND_POS / POS_OF — locate positional offsets within a flat-file record for fixed-position layouts.
- MATCH_XREF_CONV_SEQ, MATCH_DATA_LOC_ID, MATCH_INTERFACE_COLUMN_ID, MATCH_CONVERSION_GROUP_ID, MATCH_RECORD_NUM — a family of lookup helpers that resolve cross-reference, conversion sequence, data location, column, and record identifiers against ECE setup data.
Tables Accessed
The package reads and writes several core ECE tables through APPS synonyms:
- ECE_INTERFACE_TABLES and ECE_INTERFACE_COLUMNS — define the structure of each interface, driving dynamic column handling.
- ECE_MAPPINGS — supplies the mapping and conversion rules applied to each column.
- ECE_OUTPUT and ECE_OUTPUT_LINES_S — receive the generated flat-file records and line sequences.
It also depends on utility and diagnostic packages (EC_UTILS, EC_DEBUG, APP_EXCEPTION, FND_MESSAGE) and on DBMS_SQL, DBMS_UTILITY, and PLITBLM for dynamic parsing and execution.
Usage Notes
ECE_FLATFILE_PVT is invoked indirectly during outbound E-Commerce Gateway processing, typically triggered by the flat-file generation concurrent programs or by higher-level ECE packages. Twenty-eight packages reference it, confirming its role as a shared internal utility. Because it is a PVT object, customizations should not call it directly; instead, extend behavior through ECE mapping and interface setup. DBAs reviewing dependency chains or troubleshooting flat-file output errors will encounter this package when tracing generation failures.