Results for “pa_advertisements_pub”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PA_ADVERTISEMENTS_PUB is the public PL/SQL API package associated with the Oracle E-Business Suite Projects (PA) module, specifically the Project Action Sets feature also known as "Advertisements." Action Sets in Oracle Projects are reusable collections of conditional actions applied to projects and project assignments; they support automated processing such as notifications, status changes, and other project lifecycle operations. The "advertisements" naming reflects the original conceptual model in which an action set is "advertised" against matching projects or assignments, and the associated logic is then evaluated and applied.

The package is the public wrapper of the private implementation package PA_ADVERTISEMENTS_PVT. It exposes a small set of documented entry points that validate, process, perform, reevaluate, and interrogate action set activity. Because it is classified as a PUB (public) API, it follows Oracle Applications API conventions: it uses FND_API for the standard return status and message handling, FND_MSG_PUB and FND_NEW_MESSAGES for message stack management, and relies on the standard savepoint and error-handling idioms common to ETRM public APIs. The package is a standalone object in that ETRM records no database object as referencing it, although it is referenced by four other packages internally.

Key Procedures and Functions

The package body implements five documented procedures and functions:

• VALIDATE_ACTION_SET_LINE — Validates a single action set line, checking that the condition and action definitions for that line are internally consistent and permissible before processing. It is typically called during setup or before applying an action set.
• PROCESS_ACTION_SET — Drives the overall processing of an action set against applicable projects or project assignments. Delegate to logic in PA_ADVERTISEMENTS_PVT, it evaluates the conditions and dispatches the corresponding actions.
• PERFORM_ACTION_SET_LINE — Performs the work of an individual action set line after its condition has been satisfied, executing the action defined on that line such as generating a notification or applying a change.
• REEVALUATE_ADV_ACTION_SET — Reevaluates an advertised action set, rechecking conditions and reapplying actions where the underlying project or assignment data has changed. Used when action sets need to be refreshed rather than run from scratch.
• IS_ACTION_SET_STARTED_ON_APPLY — A function that determines whether an action set is configured to begin execution at apply time, allowing callers to branch on this behavior.

No parameter lists are documented in the metadata, and they should not be assumed.

Tables Accessed

The documented table references, accessed through APPS synonyms, include:

• PA_ACTION_SETS and PA_ACTION_SET_LINES — the header and line definitions of action sets; read to obtain the configuration being processed.
• PA_ACTION_SET_LINE_COND — the conditions attached to action set lines; read during validation and evaluation.
• PA_PROJECTS_ALL and PA_PROJECT_ASSIGNMENTS — the projects and project assignments against which action sets are applied.
• FND_NEW_MESSAGES — used for notification or message generation supporting the action set behavior.
• PLITBLM — the standard PL/SQL indexed table type used for message handling.

Usage Notes

PA_ADVERTISEMENTS_PUB is invoked from Oracle Projects forms, from concurrent programs that process action sets in batch, and from custom code that needs to validate, apply, or reevaluate action set definitions. It depends on FND_API, FND_MSG_PUB, FND_PROFILE, PA_DEBUG, PA_UTILS, PA_ACTION_SETS_PUB, PA_ACTION_SETS_PVT, PA_ACTION_SET_UTILS, and PA_ADVERTISEMENTS_PVT. Callers should honor the standard API return status and check the message stack after invocation. Because the referenced tables and dependencies are consistent across EBS 12.1.1 and 12.2.2, the package is supported in both releases.