Search Results assign_column_value_to_tbl

Overview

APPS.ECE_FLATFILE_PVT is a private PL/SQL package within the Oracle E-Business Suite E-Commerce Gateway (ECE) module. It provides the internal engine that converts Oracle EBS interface table data into EDI flat-file output for outbound transactions. The package name reflects its role: it prepares and writes flat-file records that are subsequently transmitted to trading partners through the ECE communication layer. It is classified as a PVT (private) API, meaning it is not intended as a public integration point; it is invoked by higher-level ECE packages rather than by external application code. The ETRM documentation indicates that 28 other packages reference ECE_FLATFILE_PVT, confirming its position as a shared low-level utility within the ECE outbound processing stack. The package operates against both 12.1.1 and 12.2.2 environments, and its source header dates to 2005, reflecting its long-standing stability across releases.

Key Procedures and Functions

The documented 16 procedures and functions address three concerns: attribute discovery, layout/mapping resolution, and output generation.

• GET_TRAN_ATTRIBUTES and PRINT_ATTRIBUTES populate and display the global transaction attribute table (t_tran_attribute_tbl), which holds key/value pairs driving record construction.
• SELECT_CLAUSE builds the dynamic SQL select clause and returns the extension table name plus an interface table collection based on transaction type, communication method, and interface table.
• INIT_TABLE initializes the interface table collection structure before it is loaded with mapping metadata.
• DEFINE_INTERFACE_COLUMN_TYPE establishes data type and length characteristics for each interface column.
• ASSIGN_COLUMN_VALUE_TO_TBL places a resolved column value into the appropriate position of the interface table collection.
• POS_OF and FIND_POS determine positional offsets for fields within a flat-file record.
• MATCH_XREF_CONV_SEQ, MATCH_DATA_LOC_ID, MATCH_INTERFACE_COLUMN_ID, MATCH_CONVERSION_GROUP_ID, and MATCH_RECORD_NUM resolve mapping and conversion identifiers used to align source columns with ECE layout definitions.
• WRITE_TO_ECE_OUTPUT persists the assembled flat-file records to the ECE output tables.

Tables Accessed

The package reads configuration and mapping metadata from ECE_INTERFACE_COLUMNS, ECE_INTERFACE_TABLES, and ECE_MAPPINGS. These define which interface columns exist, how they relate to base tables, and how values are converted. Resolved output is written to ECE_OUTPUT and ECE_OUTPUT_LINES_S. The package also references DBMS_SQL and DBMS_UTILITY for dynamic SQL execution and PLITBLM for index-by table handling.

Usage Notes

ECE_FLATFILE_PVT is invoked internally when outbound EDI transactions are generated — typically from the ECE outbound concurrent programs or from the higher-level packages that orchestrate transaction extraction. Because INIT_TABLE and its companion procedures rely on package-global state (such as t_tran_attribute_tbl and the G_ constants), callers must respect the intended sequencing: attributes are gathered, tables initialized, mappings resolved, values assigned, and finally output written. Custom code should not call this package directly; extensions should use the supported public ECE APIs. Debugging typically involves enabling the PRINT_ATTRIBUTES diagnostic output to inspect the attribute values driving record layout.