1
Download Oracle® e-Commerce Gateway
Transcript
These source code files are usually found in the directory: • $APPL_TOP/ec/admin/sql and may be modified with any text editor. Only the package body requires modification; the package specification file should not be altered. For example, the Purchase Order Outbound (POO) transaction has the corresponding extension package body "ECEPOOXB.pls" containing the following procedures: • Populate_Ext_Header • Populate_Ext_Line • Populate_Ext_Shipment To populate the new columns added to ECE_PO_INTERFACE_LINES_X in the earlier example, the procedure "Populate_Ext_Line" requires modification. As installed, the entire procedure reads as follows: Procedure follows: PROCEDURE Populate_Ext_Line (l_fkey IN NUMBER, l_plsql_table IN ece_flatfile_pvt.interface_tbl_type) IS BEGIN NULL; END PROCEDURE Populate_Ext_Line; which does absolutely nothing, although the procedure is called each time a record is inserted into ECE_PO_INTERFACE_LINES. The procedure takes two parameters: a 'key' value, and a PL/SQL table. The 'key' value is the TRANSACTION_RECORD_ID value, which is the primary key for both the interface table and the extension table. 'interface_tbl_type' is a PL/SQL table typedef with the following structure: Extensible Architecture 11-13
