Search Results pay_cn_rules




Overview
Explore in AI Chat

Overview

APPS.PAY_CN_RULES is a China-specific Payroll rules package within the Oracle E-Business Suite 12.1.1 / 12.2.2 architecture. Its file header (pycnrule.pkh 120.0.12000000.1, dated 2007) indicates it is a long-standing component of the Oracle Payroll localization layer for the China (CN) legislation. The package encapsulates jurisdiction-determination logic and template-related post-processing used during China tax processing and element configuration.

The package is classified as an OTHER API in the ETRM metadata and has no external package dependencies — it is referenced by zero other packages, indicating it is typically invoked directly by Oracle Payroll forms, template engines, or customer extensions rather than surfaced through a public API chain. It exposes exactly three documented procedures, all declared as PUBLIC within the package specification.

Key Procedures and Functions

  • GET_DEFAULT_JURISDICTION — Returns the default jurisdiction required for China tax processing. The procedure accepts assignment action and employee identifiers as input and returns the resolved jurisdiction through an IN OUT NOCOPY parameter. This is the procedure most commonly targeted by searches for "get_default_jurisdiction," as it is the only public entry point in the package for jurisdiction resolution.
  • GET_RETRO_COMPONENT_ID — Retrieves the default retro component identifier for a particular element entry, sourced from Organization DDF (Descriptive Flexfield) data. It accepts an element entry identifier and element type identifier, returning the resolved retro component ID through an IN OUT NOCOPY parameter.
  • ELEMENT_TEMPLATE_POST_PROCESS — Performs post-processing for template engines, driven by a template identifier. This supports the element template generation workflow used when configuring China payroll elements.

Tables Accessed

The package reads and writes against several core HRMS and Payroll tables, resolved through APPS synonyms:

Usage Notes

Because PAY_CN_RULES is an OTHER-classified package with no downstream package references, it is normally invoked from Oracle Payroll China forms, element template engines, or customer-written PL/SQL that requires jurisdiction or retro component resolution. Typical invocation scenarios include:

  • China payroll element configuration, where GET_DEFAULT_JURISDICTION supplies the jurisdiction to tax processing routines.
  • Retroactive pay setup, where GET_RETRO_COMPONENT_ID populates the default retro component for an element entry.
  • Element template generation, where ELEMENT_TEMPLATE_POST_PROCESS is called after the template engine completes its primary work.

Since the package is a China localization component, it should only be invoked in environments where the China payroll legislation is installed and the relevant DDF and element data are configured. Developers should treat the procedure signatures as fixed, given the package's 2007 vintage and its role as a stable localization building block rather than a versioned public API.