Search Results project_dates_valid

Overview

The APPS.PA_PROJ_STAT_ACTSET package is a VALID PL/SQL package in the Oracle E-Business Suite Projects (PA) schema. It encapsulates the business logic governing Project Status Action Sets — the configurable collections of actions that may be performed against a project or project template as its status changes. Within Oracle Projects, an action set defines which operations (such as submitting, approving, closing, or deleting a project) are permissible for a given project status and lifecycle phase. This package provides the runtime engine that validates, authorizes, and executes those actions, and it also manages the definition and maintenance of action sets themselves.

The package is classified as an OTHER API (rather than a public or private API), reflecting its role as an internal processing utility consumed by Oracle Projects forms, workflows, and other PL/SQL modules. Its central purpose is to keep project status transitions consistent with the configured action-set rules while enforcing date validation, repeating-action checks, and per-line action eligibility.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents thirteen procedures and functions within this package:

• PROCESS_ACTION_SET — Drives the overall processing of an action set, iterating through its constituent action set lines.
• PERFORM_ACTION_SET_LINE — Executes the individual action associated with a single action set line.
• VALIDATE_ACTION_SET_LINE — Confirms that a specific action set line is valid and eligible for execution.
• VALIDATE_ACTION_SET — Validates the action set as a whole before processing.
• VALIDATE_ACTION_TYPE_CODE — Verifies that the supplied action type code is a recognized, supported action type.
• ACTION_ALLOWED_FOR_STATUS — Determines whether a given action is permitted under the current project status.
• PROJECT_DATES_VALID — Checks that project date attributes are valid for the action being performed.
• OK_TO_PERFORM_ACTION — Central authorization gate returning whether an action may safely proceed.
• PERFORM_SELECTED_ACTION — Performs a specific action selected by the caller rather than the full set.
• COPY_ACTION_SETS — Duplicates action set definitions, typically when copying project templates or project structures.
• IS_ACTION_REPEATING — Identifies whether an action is configured to repeat, informing processing decisions.
• DELETE_ACTION_SET — Removes an action set definition and its associated lines.
• UPDATE_ACTION_SET — Maintains or modifies action set definitions.

Tables Accessed

The package operates against the following documented tables via APPS synonyms:

• PA_ACTION_SETS — Header definitions of action sets.
• PA_ACTION_SET_LINES — Individual action lines belonging to each action set.
• PA_ACTION_SET_LINE_COND — Conditions governing when an action set line applies.
• PA_OBJECT_PAGE_LAYOUTS — Page layout metadata that may be adjusted based on the action set.
• PA_PROJECTS_ALL — Project records whose status and dates are evaluated during action validation.
• FND_NEW_MESSAGES — Oracle Application Object Library message repository used for error and information messages.
• PLITBLM — PL/SQL internal table storage used for message display.

Utility dependencies include PA_ACTION_SET_UTILS, PA_OBJECT_PAGE_LAYOUTS, FND_API, and STANDARD.

Usage Notes

PA_PROJ_STAT_ACTSET is referenced by PA_ACTION_SETS_DYN, PA_PROGRESS_REPORT_PVT, and PA_PROJECT_CORE1, indicating that it is invoked primarily from Oracle Projects forms (such as the Project, Template, and Action Sets maintenance forms) and from project status-change processing logic. It is not designed to be called directly from SQL*Plus; callers typically pass action set identifiers or project identifiers and receive validation results or processing outcomes. Custom integrations that programmatically change project status should route through PA_PROJECT_CORE1 or the standard public APIs, which in turn invoke this package, rather than calling it directly, to preserve action-set enforcement, message handling, and repeat-action semantics.