Search Results ent_gssm_export

Overview

JA_CN_GSSM_EXP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Chinese localization ("JA" product prefix) for Government Standard Social Security Management (GSSM) export processing. The package header identifies its purpose as exporting GSSM data for both Enterprise and Public Sector organizations within the CNAO Project. Its primary documentation signature is the historically cited interface name pub_gssm_export, which corresponds to the Pub_GSSM_Export procedure referenced in the package's internal procedure list.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling user rather than the package owner. This is a common pattern for localized utility packages that must respect the invoker's security context when resolving synonyms and accessing application data. The documented API classification is OTHER, indicating that this is a standalone utility or report driver rather than a registered business API.

Key Procedures and Functions

ETRM documents one procedure for this package:

• GSSM_EXPORT — The documented procedure that drives the GSSM export routine. Per the embedded source comments, the package exposes both an Enterprise variant (Ent_GSSM_Export) and a Public Sector variant (Pub_GSSM_Export); these operate through a shared entry point accepting a GSSM type parameter that distinguishes ENT from PUB processing. The procedure follows the standard concurrent-program signature convention, returning the conventional errbuf and retcode status outputs alongside the type indicator.

The source header confirms the procedure list contains Ent_GSSM_Export and Pub_GSSM_Export. No other functions or procedures are documented by ETRM for this object.

Tables Accessed

The package is documented as referencing two tables through APPS synonyms:

• FND_FLEX_VALUES_TL — The key flexfield values translation table. This is read to resolve the translated display values of flexfield segments, which the GSSM export requires when formatting code combinations for statutory reporting output.
• FND_LOOKUP_VALUES — The lookup values table, read to resolve lookup codes and their meanings used within the export layout and to drive lookup-based control logic.

These references indicate that the package is primarily a read-only reporting extractor: it selects configuration and reference data rather than writing transactional records.

Usage Notes

JA_CN_GSSM_EXP_PKG is typically invoked from a concurrent program registered in Oracle EBS, consistent with its errbuf/retcode parameter convention. Users submit the GSSM export from the Standard Request Submission (SRS) window after selecting the appropriate GSSM type (Enterprise or Public Sector).

ETRM records that the package is referenced by one other package, so it may also be called programmatically by a wrapper or orchestration routine. When extending or debugging the export, developers should note the AUTHID CURRENT_USER directive, which means synonym resolution depends on the executing user's privileges, and the historical object name pub_gssm_export is frequently used when searching the data dictionary or support archives.