Search Results get_account_info

Overview

IEM_EMTA_ADMIN_PVT_W is a public wrapper package in the Oracle E-Business Suite ETRM (Enterprise Transaction Recording and Management) module, owned by the APPS schema and defined with AUTHID CURRENT_USER. The package exposes the account administration interface of IEM_EMTA_ADMIN_PVT to callers that require a stable, published API surface, most notably through the Rosetta/Java integration layer used by ETRM administrative functions. Its documented purpose is to retrieve account-level information held in ETRM and to convert between the internal PL/SQL record type ACCT_INFO_TBL and the JTF_* collection types used across the EBS integration stack. The "_W" suffix and the AUTHID CURRENT_USER clause identify it as a thin, invocation-context wrapper generated for cross-tier calls rather than a package that implements business logic itself.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P1 — Copies an inbound set of JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_300 and related collection parameters into an ACCT_INFO_TBL out parameter. It is the marshalling routine that converts flattened array parameters received from a non-PL/SQL caller into the structured ETRM account-information record.
• ROSETTA_TABLE_COPY_OUT_P1 — Performs the reverse transformation, copying an ACCT_INFO_TBL input into out parameters of JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_300 and the associated JTF_NUMBER_TABLE collection. This provides the flattened representation consumed by downstream callers.
• GET_ACCOUNT_INFO — Retrieves account information and returns the results through parallel JTF_* collection out parameters, together with the standard EBS API completion parameters x_return_status, x_msg_count and x_msg_data. It observes the conventional API entry contract of p_api_version_number, p_init_msg_list and p_commit, making it callable from concurrent processing and Java business components.

Tables Accessed

The documented table reference is the PLITBLM synonym, which is the EBS PL/SQL table temporary storage object used for bulk collection processing. The package relies on it to materialise and stage the account-information rows before they are flattened into the JTF_* collection parameters. No base ETRM account tables are exposed directly through this wrapper; the underlying IEM_EMTA_ADMIN_PVT holds the substantive data access logic, and the wrapper delegates through the copy-in and copy-out routines rather than issuing its own SQL against application tables.

Usage Notes

GET_ACCOUNT_INFO is typically invoked programmatically rather than from an EBS form. Because it accepts p_api_version_number and returns the standard return-status triplet, it conforms to the EBS API conventions and can be called from Java/BC4J business components, concurrent programs, database triggers, or custom PL/SQL wrappers that need to obtain ETRM account information without linking directly to the private package. Callers must pass a valid API version, choose whether to initialise the message list via p_init_msg_list, and decide whether the call should commit via p_commit. In Oracle EBS 12.1.1 and 12.2.2 the package is installed under APPS and compiled as AUTHID CURRENT_USER, so privileges are resolved against the invoker's schema; this affects which callers can reach the referenced objects. Any customisation should call this wrapper rather than IEM_EMTA_ADMIN_PVT, since the private package's signature is not guaranteed across patches or upgrades.