Search Results p_dml_record

Overview

HZ_IMP_LOAD_FINNUMBERS_PKG is a PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that supports the bulk import of customer financial number data into Oracle Receivables and Trading Community Architecture (TCA). Financial numbers represent bank accounts, credit card numbers, and other payment instruments associated with a customer or customer account, and they are stored in HZ_FINANCIAL_NUMBERS. This package forms part of the HZ_IMP_LOAD_* family of loader packages and works in conjunction with the HZ_IMP_LOAD_WRAPPER framework, which drives record-by-record processing of interface data staged in the HZ_IMP_*_INT interface tables.

The package header declares that LOAD_FINNUMBERS carries an IN parameter of type HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE, identified in the ETRM metadata as p_dml_record. This parameter type encapsulates a single staged interface record, its identifier, and the DML action (insert or update) to be applied. The same parameter convention recurs throughout the forward declarations in the package body, including OPEN_UPDATE_CURSOR, PROCESS_INSERT_FINNUMBERS, PROCESS_UPDATE_FINNUMBERS, REPORT_ERRORS, POPULATE_ERROR_TABLE, and LOAD_FINNUMBERS itself.

Key Procedures and Functions

ETRM documents a single public entry point, LOAD_FINNUMBERS, which accepts the p_dml_record parameter of type HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE along with standard return status, message count, and message data output parameters. It orchestrates the loading of one financial number record, determining whether an insert or update is required and delegating work to the appropriate internal routine.

The package body reveals a supporting private structure. OPEN_UPDATE_CURSOR prepares a cursor for retrieving existing financial number rows. PROCESS_INSERT_FINNUMBERS and PROCESS_UPDATE_FINNUMBERS each receive the same p_dml_record parameter and perform the corresponding DML against the target tables while returning standard API status outputs. REPORT_ERRORS and POPULATE_ERROR_TABLE accept p_dml_record plus an exception or duplicate-value indicator and write failure details into the interface error tables. Package-level variables such as l_fin_num, l_fin_num_name, l_fin_num_cur, l_proj_act_flag, and l_action_flag hold the decomposed column values for each processed record.

Tables Accessed

• HZ_IMP_FINNUMBERS_INT — the interface staging table that holds incoming financial number records prior to validation and loading.
• HZ_IMP_FINNUMBERS_SG — the staging/subgroup table used during batch preparation of financial number data.
• HZ_FINANCIAL_NUMBERS — the base TCA table that stores the loaded financial number records.
• HZ_FINANCIAL_REPORTS — referenced to resolve the financial report context associated with a financial number.
• HZ_IMP_ERRORS, HZ_IMP_ERRORS_S, HZ_IMP_TMP_ERRORS — error capture tables where record-level validation and loading failures are recorded for user review and correction.
• DUAL — used for singleton SQL operations.
• PLITBLM — the PL/SQL integer table type used by the error message stack (FND_MSG_PUB).

Usage Notes

This package is not intended to be called directly by end users. It is invoked by the HZ_IMP_LOAD_WRAPPER package, which is referenced by one other package according to ETRM. In practice, loading is initiated through the Customer Interface concurrent program or the TCA import batch framework, which reads HZ_IMP_FINNUMBERS_INT, constructs a DML_RECORD_TYPE for each row, and passes it as p_dml_record to LOAD_FINNUMBERS. Custom code that needs to import financial numbers should call the wrapper rather than this package directly. Errors encountered during processing are written to the HZ_IMP_ERRORS tables and surfaced to the user through the standard concurrent program output, allowing correction and resubmission. The package header references a 2006 revision (120.3), indicating it is a stable component present across both 12.1.1 and 12.2.2 releases.