Search Results get_bp_count




Overview
Explore in AI Chat

Overview

APPS.PAY_KR_NONSTAT_SPAY_EFILE is a Korean localization package body within Oracle E-Business Suite Payroll that supports the generation and electronic filing of non-statutory separation pay (retirement or severance payments that fall outside statutory reporting requirements) for South Korean business places. The package provides the programmatic layer through which a user or concurrent process can submit an e-file request for the KR Non-Statutory Separation Pay E-File (MAGTAPE) report. Rather than writing the magnetic media file directly, the package acts as a submission wrapper: it validates and transmits the caller's parameters to the concurrent manager via FND_REQUEST.SUBMIT_REQUEST, launching the underlying report program PAYKRSEF_NS_B. The header comment ("pykrnspef.pkb 120.3") and the argument comments referencing bug identifiers confirm this is a long-standing seeded object shipped under the APPS schema in both 12.1.1 and 12.2.2. Its API classification is OTHER, meaning it is not part of Oracle's public, supported integration API set and is intended primarily for internal localization use.

Key Procedures and Functions

The ETRM metadata documents three program units in this package:

  • SUBMIT_EFILE — The primary public entry point. It receives the e-file request context (effective date, business place, target year, reporting and tax-reporter attributes, magnetic and report file names, payroll action and assignment set identifiers, home tax identifier, and organization structure version) and submits the MAGTAPE report request to the concurrent manager, returning the standard errbuf/retcode completion pair.
  • GET_BP_COUNT — A helper function that returns a count of business places relevant to the e-file run. It is used to determine how many business places must be reported and to support validation or loop control during submission. Because the user searched on this name, note that it is a supporting utility rather than a user-facing API.
  • GET_RECORD_D_CONTEXT — A helper that resolves the descriptive flexfield context associated with the "Record D" layout of the magnetic file, ensuring the correct context and segment values are applied when the report data is assembled.

Tables Accessed

The package reads and, where applicable, writes through APPS synonyms, including: FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, FF_CONTEXTS, FF_ROUTE_CONTEXT_USAGES, and FF_USER_ENTITIES (flexfield archive and context metadata used to build Record D context values); HR_LOCATIONS_ALL and HR_ORGANIZATION_INFORMATION (business place and organization attribute lookup); PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS (payroll action and assignment action scope for the requested run); PER_ORG_STRUCTURE_ELEMENTS (organization structure version resolution for the reporting hierarchy); and DUAL for scalar lookups such as the business place count.

Usage Notes

PAY_KR_NONSTAT_SPAY_EFILE is normally invoked indirectly. The concurrent program KR Non-Statutory Separation Pay E-File (MAGTAPE) and its associated Korean localization submission forms call SUBMIT_EFILE to launch the PAYKRSEF_NS_B request, passing the effective date, business place, target year, reporting period details, file names, payroll action, assignment set, and tax reporter information. The helper functions GET_BP_COUNT and GET_RECORD_D_CONTEXT are called internally during that flow. The package is referenced by zero other packages according to the ETRM metadata, which confirms it sits at the top of its own call chain rather than being a shared dependency. Custom code may call SUBMIT_EFILE directly to trigger an e-file submission, but because the API is classified as OTHER and is a localization object, customers should treat the signature as subject to patch-level change and avoid hard-coding dependencies on it.