Search Results pay_us_pto_co_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_US_PTO_CO_PKG is a United States–specific payroll package used to manage paid time off (PTO) carry-over processing within Oracle E-Business Suite. The package encapsulates the business logic required to move accrued PTO balances from one accrual period or plan year into the next, applying plan categories, accrual terms, and calculation dates supplied by the caller. It supports multiple carry-over modes and optional plan-level or assignment-level scoping, allowing the payroll administrator to carry over balances for an entire plan or for a single assignment.

The package also exposes a lightweight logging facility. Rather than writing diagnostics inline, it centralizes logging through two dedicated utility procedures so that carry-over routines can emit progress and error information in a consistent manner. In the context of the user's search for "initialize_logging," this package is the owner of the INITIALIZE_LOGGING procedure, which sets up the logging context prior to a carry-over run.

Key Procedures and Functions

  • INITIALIZE_LOGGING — Initializes the package's logging context before a carry-over process begins. It accepts an optional action parameter group identifier, allowing logging to be associated with a specific set of run-time parameters. This is the procedure most directly relevant to the user's search term.
  • WRITE_LOG — Emits a logging message. It takes the message text and a message type (defaulting to NORMAL) and records the entry within the initialized logging context. The package defines constants for DEBUG, NORMAL, and the SUCCESS, WARNING, and ERROR severity levels that WRITE_LOG and its callers can reference.
  • CARRY_OVER — The main entry point for PTO carry-over. It returns standard concurrent-program OUT parameters (ERRBUF and RETCODE) alongside inputs for calculation date, business group, plan, plan category, mode, accrual term, and the optional action parameter group identifier.
  • PTO_CARRY_OVER_FOR_PLAN — Performs carry-over at the plan level, operating on element types, input values, formulas, and date inputs required to compute and store the carried balances. It also accepts a legislation code for regional variation.
  • PTO_CARRY_OVER_FOR_ASG — Performs carry-over for a single assignment, using the same plan and element-type inputs as the plan-level procedure but scoped to one assignment identifier.

Tables Accessed

The package reads and writes payroll accrual and element data. Accrual plan definitions and their translated names are read from PAY_ACCRUAL_PLANS and PAY_ACCRUAL_PLANS_TL. Balance and entry information is drawn from or written to PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, and PAY_INPUT_VALUES_F. Assignment and service context come from PER_ALL_ASSIGNMENTS_F and PER_PERIODS_OF_SERVICE, while PER_TIME_PERIODS supplies period boundaries used to determine the carry-over window. Organization details are retrieved from HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION. FND_SESSIONS and DUAL are used for session context and simple scalar queries.

Usage Notes

PAY_US_PTO_CO_PKG is typically invoked from concurrent programs that process PTO carry-over for U.S. legislation, though it may also be called from custom PL/SQL that requires the same logic. Callers should invoke INITIALIZE_LOGGING first, optionally passing an action parameter group identifier, then execute CARRY_OVER, and rely on WRITE_LOG for diagnostics. Because the package is owned by APPS and classified as OTHER rather than a public API, direct calls should be made with caution and validated against the target release (12.1.1 or 12.2.2). The package references no other documented packages, so it functions as a self-contained unit for PTO carry-over processing.