Search Results pycadar_pkg




Overview
Explore in AI Chat

Overview

PYCADAR_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an "OTHER" API. The prefix "PY" and the pattern of dependencies indicate that it belongs to the Oracle Payroll module. The package supports the payroll action processing and archival framework, specifically the creation of actions, the archival of actions, and the qualification of assignments for those actions. It is a helper package that operates alongside the standard Oracle Payroll action and assignment processing routines rather than being a public-facing business API. The package is documented as VALID in ETRM 12.2.2 and is referenced by fifteen other database objects, indicating it is an internal utility that other payroll packages call into. It consists of ten documented procedures and functions.

Key Procedures and Functions

  • TO — A routine within the package used during processing; documented as one of the ten callable units. Its name suggests a direct transformation or transfer operation.
  • CHECK_IF_ASSIGNMENT_PAID — Determines whether a given assignment has been paid, used as a gating check before further payroll action processing.
  • ACTION_CREATION — Creates payroll actions for the assignments being processed.
  • ARCHIVE_ACTION_CREATION — Creates the archival counterpart of a payroll action, supporting audit and history retention.
  • SORT_ACTION — Orders actions into the sequence required for consistent processing.
  • GET_PARAMETER — Retrieves parameters used to drive the package's logic.
  • GET_LABELS — Fetches display labels, likely sourced from lookups, for presentation in forms or reports.
  • QUALIFYING_PROC — Performs qualifying logic to determine which assignments or actions participate in a given run.
  • CHECK_IF_QUALIFIED_FOR_CA — Tests whether an assignment qualifies for a Compensatory/Adjustment-style action, the "CA" condition referenced in the routine name.

Tables Accessed

The package reads and writes across the core Oracle Payroll and HR tables via APPS synonyms. PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S are the primary Payroll action tables and represent the principal write targets. PAY_ACTION_INFORMATION and PAY_ACTION_INTERLOCKS hold action-level parameters and interlock detail. PAY_PRE_PAYMENTS and PAY_ORG_PAYMENT_METHODS_F provide payment data used when checking whether an assignment has been paid. PAY_ALL_PAYROLLS_F supplies payroll definitions. PER_ALL_ASSIGNMENTS_F and PER_PERIODS_OF_SERVICE (through the aliases PER_ASSIGNMENTS_F and HR_ASSIGNMENT_SET) provide assignment and service history, while HR_ASSIGNMENT_SETS and HR_ASSIGNMENT_SET_AMENDMENTS define population groupings. HR_LOOKUPS, FND_LOOKUP_VALUES and HR_UTILITY/HR_GENERAL2/HR_NONRUN_ASACT supply labels and common HR utilities. PAY_REPORT_CATEGORIES and PAY_REPORT_GROUPS provide reporting categorisation. DUAL and STANDARD are used for trivial expressions and PL/SQL support.

Usage Notes

PYCADAR_PKG is an internal package and is not intended to be called directly by end users. It is invoked from the Oracle Payroll action-processing and archival flows, most commonly triggered by the concurrent programs or forms that manage payroll actions, assignment actions, and pretax or deduction adjustments. The procedures qualify assignments, confirm whether an assignment has been paid, create and archive actions, and sort them before submission. Because it is referenced by fifteen other database objects, customisations should not modify the package; instead, customer extensions should reference the package read-only and rely on the standard Oracle Payroll action framework for invocation. Reviewing the object in ETRM or the data dictionary is the recommended way to confirm its signature before use in any custom PL/SQL.