Search Results partially_purged

Overview

APPS.PA_PURGE_PROJECTS_GEN_PKG is a supporting PL/SQL package within the Oracle EBS Projects (PA) module that drives the purge and archive processing of project records. Its central business function is to identify candidate projects that meet a set of user-supplied purge criteria and to stage those projects into the purge infrastructure so that downstream purge programs can archive or delete the associated project data. In Oracle EBS 12.1.1 and 12.2.2, the package underpins the "Purge Projects" concurrent program, allowing administrators to selectively purge closed or inactive projects while optionally archiving summary, budget, capital, and actual transaction information before removal.

The package is classified as OTHER in the ETRM 12.2.2 metadata and does not expose a public API contract, but it is a documented object within the APPS schema.

Key Procedures and Functions

• GEN_PROJECTS — The primary procedure responsible for generating the set of projects eligible for purge. It accepts a purge batch identifier, active/closed selection flag, closed-through date, organization, project type, project status, and a series of purge/archive flags controlling summary, budget, capital, and actuals handling, along with administrative project and transaction-to-date criteria and user context. It returns a count of records processed. Internally it opens a cursor defined over PA_PROJECTS_ALL that filters candidate projects by organization, type, closed date, and status. The status logic is significant to the user term "partially_purged": when the active/closed flag is 'A', the cursor excludes projects whose status is 'PARTIALLY_PURGED', 'PURGED', or 'CLOSED'; when the flag is 'C', the cursor includes projects whose status is 'PARTIALLY_PURGED' or 'CLOSED'. The 'PARTIALLY_PURGED' status therefore signals that a project has undergone purge processing without being fully removed, and it is treated as a closed-state candidate for further purge activity.
• GET_PURGE_OPTIONS — A supporting function that retrieves the configured purge and archive option settings used to drive the generation logic, ensuring the procedure honors the administrative configuration established for the purge run.

Tables Accessed

• PA_PROJECTS_ALL — The core project table read to select candidate projects based on organization, project type, closed date, and status filters.
• PA_PROJECT_TYPES — Read to resolve indirect project types (project_type_class_code = 'INDIRECT') when the active/closed flag is 'A', refining which projects are eligible.
• PA_PURGE_PROJECTS — The purge staging table where candidate project records and their purge parameters are recorded for downstream processing.
• DBMS_SQL and DUAL — Utility references for dynamic SQL construction and single-row selection supporting the generation logic.

Usage Notes

The package is invoked indirectly through the Purge Projects concurrent program rather than being called directly from standard forms. Administrators launch the concurrent request, supply the purge parameters mapped to the GEN_PROJECTS arguments, and the package stages eligible projects into PA_PURGE_PROJECTS. Because projects in 'PARTIALLY_PURGED' status are included when the closed flag is used, a recurring purge run can resume processing of projects that were previously only partially purged. Custom code should avoid calling this package directly, as its interface is internal and subject to change without notice; integration should instead rely on the delivered concurrent program. The package is referenced by no other documented packages, confirming its role as a targeted component of the project purge and archive process.