Search Results upload_npa

Overview

PAY_KR_BEE_UPLOAD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Korean payroll localization for the Business Expense Entry (BEE) upload process. Its primary business function is to load externally prepared expense or earnings data into the Oracle Payroll batch structure for Korean legislative and reporting requirements. The package creates batch headers and batch lines, resolves assignment and element information, and writes validated records into the payroll batch tables so they can be processed by standard payroll batch element entry (BEE) flows.

The package is classified as OTHER in ETRM and holds a VALID status. It is not a formally published public API, but it is a supported localization utility invoked internally by the Korean payroll processing layer. It is referenced by no other packages, confirming it acts as a top-level entry point rather than a shared library routine.

Key Procedures and Functions

The documented package exposes twelve procedures and functions:

• UPLOAD — the main driving routine that orchestrates the upload of a file or data set into payroll batch entry.
• UPLOAD_HIA — a specialized upload variant, typically associated with a Korean-specific earnings or insurance category.
• UPLOAD_NPA — a second specialized upload variant for a distinct Korean earnings or deduction category.
• CREATE_BATCH_HEADER — creates the payroll batch header record required before any lines can be inserted.
• CREATE_BATCH_LINE — creates an individual batch line linked to the header and to an assignment and element.
• BREAK_UP_LINE — splits or redistributes a batch line, typically to apportion amounts across periods or elements.
• GET_ASSIGNMENT_INFO — retrieves assignment-level details for the employee being processed.
• GET_ELEMENT_INFO — retrieves the payroll element definition and related attributes used to build the batch line.
• GET_FIELD — extracts a specific field value from an input record, used during parsing.
• GET_ROW_VALUE — retrieves a value from a user row or input structure.
• CORRECT_TYPE_ID — normalizes or corrects the type identifier associated with an uploaded record.

Together these routines cover the complete lifecycle: parse input, resolve assignment and element context, create batch structures, and finalize lines.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• PAY_BATCH_LINES — the core target table where uploaded expense or earnings lines are inserted.
• PER_PERIODS_OF_SERVICE — read to validate the assignment's period of service for the effective date.
• PER_ASSIGNMENTS_F and PER_BUSINESS_GROUPS — read to resolve employee assignment and business group context (per dependency listing).
• FND_SESSIONS — used to establish session context for the upload.
• PAY_ELEMENT_TYPES_F — read to identify the payroll element to which the line belongs.
• PAY_USER_COLUMNS, PAY_USER_COLUMN_INSTANCES_F, PAY_USER_ROWS_F, and PAY_USER_TABLES — the user-defined table/column framework used to interpret and map uploaded data into element entry.
• UTL_FILE — the Oracle file I/O utility used to read the source upload file.

Usage Notes

PAY_KR_BEE_UPLOAD is typically invoked from a Korean payroll concurrent program or from custom loader code that supplies an input file. The UPLOAD, UPLOAD_HIA, and UPLOAD_NPA entry points read the file via UTL_FILE, resolve assignments and elements, and populate PAY_BATCH_LINES through the batch header and line creation routines. Because the package is classified as OTHER rather than PUBLIC, it should not be treated as a stable integration API; callers should account for possible changes between patch levels. In Oracle EBS 12.1.1 and 12.2.2 the behavior is consistent, though the 12.2 online patching model means the package may be recompiled during patching cycles. Since no other packages depend on it, it can generally be modified or replaced without cascading compilation impact.