Search Results pay_jp_create_cma_pkg




Overview
Explore in AI Chat

Overview

PAY_JP_CREATE_CMA_PKG is a Japanese localization package owned by the APPS schema. Its name and the single documented routine, TRANSFER_FROM_CMA_INFO_TO_BEE, identify it as a data migration utility that moves information captured in the Japanese CMA (Cost Management Adjustment / 支払調書-related) context into the BEE structures used by Oracle Payroll's element and assignment processing. In Oracle EBS 12.1.1 and 12.2.2, Japanese payroll localization requires that statutory and company-specific element definitions, input values, and batch information be aligned with the assignments being processed. This package exists to bridge a staging source of CMA-derived information and the standard Payroll engine tables, so that downstream payroll runs see the correct element definitions and input values.

The ETRM 12.2.2 record classifies the package as VALID with an API classification of OTHER, indicating that it is an internal localization utility rather than a public, supported extension API. It is not referenced by any other package and only references SYS.STANDARD, confirming a narrow, self-contained role in the Japanese payroll data flow.

Key Procedures and Functions

One documented routine is associated with this package:

  • TRANSFER_FROM_CMA_INFO_TO_BEE — The purpose implied by the name is to transfer CMA-derived information into the BEE (element/assignment) structures. The routine reads the source CMA information, resolves the relevant element types, element type translations, input values, and assignment sets, and writes or reconciles the corresponding records for the payroll engine. It is the sole entry point documented in the ETRM metadata, and no parameter list is published in the reference material, so callers must rely on the shipped package specification for the exact signature.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

  • FF_GLOBALS_F — FastFormula globals; supplies payroll-level configuration values used to interpret the transfer context.
  • FND_SESSIONS — Application session context, providing the runtime environment under which the transfer executes.
  • HR_ASSIGNMENT_SETS — Assignment sets that scope which population of assignments receives the transferred CMA data.
  • PAY_BATCH_HEADERS — Payroll batch headers, used to place the transfer in the correct batch-processing context.
  • PAY_ELEMENT_TYPES_F — The element type definitions into which CMA-derived element information is mapped.
  • PAY_ELEMENT_TYPES_F_TL — The translated (language) side of the element type definitions, required for the Japanese localization to present correct names and descriptions.
  • PAY_INPUT_VALUES_F — Input value definitions for the elements, ensuring the transferred data matches the input structure the element expects.
  • PLITBLM — A PL/SQL index-by table used as an in-memory work area during processing, not a persistent application table.

Usage Notes

Because the package is classified OTHER and is not referenced by any other documented package, it is not part of a public API chain. In practice it is invoked as part of Japanese payroll localization processing—typically from a concurrent program or from custom code that performs CMA-to-BEE conversion—rather than interactively from a standard Oracle Forms screen. Administrators and developers should treat it as an internal implementation detail: invoke it only in the documented localization flow, verify the shipped package specification for the current signature, and avoid calling it directly in customizations where a supported payroll API exists. Any customization should use APPS credentials and respect the session context that FND_SESSIONS and FF_GLOBALS_F provide.