Search Results ja_cn_sysops_bank_pkg




Overview
Explore in AI Chat

Overview

JA_CN_SYSOPS_BANK_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category in the ETRM repository. It is a China localization component, evidenced by the JA_CN naming prefix and the JACNSBPS.pls source file, and it was originally created in late 2012 by Jar Wang. The package header is declared with AUTHID CURRENT_USER, so execution privileges and unqualified object resolution follow the invoking schema rather than the defining schema.

The stated purpose in the package header is to retrieve balancing segment values (BSVs). In Oracle EBS, balancing segment values correspond to legal entities or balancing entities within the accounting flexfield, and access to those values is governed by security rules and data access sets. The package therefore provides a programmatic way for China-localized functionality to determine which balancing segment values the current responsibility is permitted to use, and to support related banking and reporting operations for Chinese legal entities.

Key Procedures and Functions

Six procedures and functions are documented for this package:

  • GET_BSV_LIST — Returns a comma-delimited list of all balancing segment values to which the caller has access rights, taking responsibility application, responsibility, and access set into account. This is the primary public entry point described in the header comments.
  • GET_SECURITY_BSV — Returns all balancing segment values accessible to the caller, deriving the result from the security configuration rather than from a caller-supplied list.
  • CHECK_LE_BSV — Validates whether a given balancing segment value is associated with a legal entity, supporting legal-entity-aware security checks.
  • CHECK_DAS_BSV — Validates a balancing segment value against data access set assignments, confirming that the value falls within the caller's permitted data access scope.
  • SUBMIT_XML_CHARSET_CONVERSION — Submits a request to convert XML output between character sets. Because the user search term is "submit_xml_charset_conversion," this procedure is the object of interest: it addresses the character-set mismatches commonly encountered when generating XML reports for Chinese-language data, where GBK, UTF-8, and other encodings may conflict.
  • GET_CURRENCY — Retrieves currency information, presumably the functional or reporting currency associated with a legal entity or ledger, for use in China localization reporting.

The package also declares a bsv_record record type (flex value, description, flex value set identifier) and a bsv_type table type built on it, which standardize the return of balancing segment value data.

Tables Accessed

The package reads from a defined set of APPS synonyms, which fall into four functional groups:

Usage Notes

JA_CN_SYSOPS_BANK_PKG is an internal localization API rather than a general-purpose public interface. It is referenced by two other packages, indicating that it is invoked programmatically as a supporting layer rather than directly by end users. Typical invocation paths include China-localized Oracle Forms, concurrent programs that generate statutory or banking reports for Chinese legal entities, and custom code that must enforce balancing segment value security before presenting data. The presence of SUBMIT_XML_CHARSET_CONVERSION suggests use during XML Publisher report generation, where the procedure requests conversion of report output into the required character set. Because the package executes with AUTHID CURRENT_USER, any custom caller must itself hold privileges on the underlying GL, FND, XLE, RG, and JA_CN objects; organizations extending this package should therefore grant access through the responsibility or application context in which the call is made. The same source is delivered in both EBS 12.1.1 and 12.2.2, with the header version string indicating maintenance through the 12.2 release cycle.