Results for “reevaluate_adv_action_set”

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

Overview

APPS.PA_ADVERTISEMENTS_PUB is a public PL/SQL package in Oracle E-Business Suite that implements the advertisement action set framework within Oracle Projects. An advertisement is a structured sequence of actions (action lines) that must be created, ordered, validated, and executed against a requirement or against an action set template. The package provides the public API surface through which other Oracle Projects components — most notably the generic action set utility layer and the advertisement-related forms and concurrent processes — drive the lifecycle of advertisement action sets.

The package header exposes global state used by the action set framework, including g_action_line_audit_tbl, which accumulates audit lines returned to the generic action set API when an action line is performed, and g_start_adv_action_set_flag, which tracks whether a start-advertisement action set operation is in progress. Together with a small set of wrapper procedures, these globals allow the generic action set engine in PA_ACTION_SET_UTILS to delegate advertisement-specific behavior back into this package.

The package is classified as PUB, indicating that its procedures form a supported integration point for Oracle Projects extensions and for internal callers, rather than a purely private implementation detail.

Key Procedures and Functions

The documented API comprises five procedures and functions:

• VALIDATE_ACTION_SET_LINE — Validates a single action line belonging either to an advertisement action set template or to an advertisement action set defined on a requirement. The procedure is invoked by the action set framework when a line is entered or modified. The header comments note that the current implementation is effectively empty, so the procedure exists primarily as a placeholder and as an extension point in the advertisement action set contract.
• PROCESS_ACTION_SET — Re-orders the action lines and validates the advertisement action set, or the advertisement action lines defined on a requirement. It is invoked when a new action set is created, when an existing action set or its action lines are updated, and when an action set is started on a requirement. This is the primary orchestration entry point for the advertisement action set lifecycle.
• PERFORM_ACTION_SET_LINE — Executes a single action line of an advertisement action set, returning audit information through the package global g_action_line_audit_tbl. This procedure is what the generic action set API calls when an individual action line is actually performed.
• REEVALUATE_ADV_ACTION_SET — Re-evaluates an advertisement action set, recomputing the conditions under which action lines should be considered applicable. This procedure is the entry point most commonly associated with the search term reevaluate_adv_action_set; it is used when the underlying business data changes and the action set must be refreshed without being recreated.
• IS_ACTION_SET_STARTED_ON_APPLY — A function that determines whether an action set is started automatically on apply, allowing callers to branch on the configuration of the advertisement action set without querying the base tables directly.

Tables Accessed

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

• PA_ACTION_SETS and PA_ACTION_SET_LINES — the core definition and line-level storage for advertisement action sets and templates. These are read and updated during processing, validation, and re-evaluation.
• PA_ACTION_SET_LINE_COND — stores the conditions attached to individual action set lines; consulted when evaluating applicability and when re-evaluating an advertisement action set.
• FND_NEW_MESSAGES — the Oracle Application Object Library message repository, used to derive user-facing error and status messages returned through x_return_status.
• PA_PROJECTS_ALL and PA_PROJECT_ASSIGNMENTS — project and project-assignment data used to resolve the requirement context against which an advertisement action set is applied.
• PLITBLM — the standard Oracle Projects PL/SQL table used for message and error accumulation.

Usage Notes

PA_ADVERTISEMENTS_PUB is not typically called directly from end-user screens. Instead, it is invoked indirectly through the generic action set framework: Oracle Projects forms that maintain advertisements, requirements, and action set templates call into PA_ACTION_SET_UTILS, which in turn dispatches advertisement-specific work to the procedures in this package. The four packages documented as referencing PA_ADVERTISEMENTS_PUB follow the same pattern.

The most common concrete invocation paths are the creation and update of an advertisement action set (triggering PROCESS_ACTION_SET), the performance of an individual action line (triggering PERFORM_ACTION_SET_LINE), and the refresh of an existing action set after business data changes (triggering REEVALUATE_ADV_ACTION_SET). Custom integrations and extensions that need to re-evaluate advertisement action sets should call REEVALUATE_ADV_ACTION_SET rather than manipulating PA_ACTION_SETS and PA_ACTION_SET_LINES directly, so that re-ordering, condition evaluation, and audit capture remain consistent with the supported framework.

Because the package maintains session-level global state, callers should treat it as part of a single logical action set operation and should inspect x_return_status after each call to confirm success before proceeding to the next step in the advertisement workflow.