Search Results insert_concurrent_row




Overview
Explore in AI Chat

Overview

APPS.FND_PORTLET_DEPENDENCY_PKG is a PL/SQL package that manages dependency relationships between Oracle EBS portlets (or functions) and the concurrent programs upon which they rely. Portlets and their underlying functions may need to refresh concurrently-executed data before they render, and this package provides the API surface for maintaining those refresh dependencies in the FND_PORTLET_DEPENDENCY table. It serves as the programmatic maintenance layer behind the Oracle Applications administrative and personalization UI that governs portlet refresh behavior.

The package is classified under the ETRM API classification OTHER, indicating it is a supporting internal API rather than a public, supported extension interface. It contains five documented procedures and references the FND_APPLICATION, FND_CONCURRENT_PROGRAMS, FND_PORTLET_DEPENDENCY, and DUAL objects through APPS synonyms. The source header ($Header: FNDPRTRS.pls 120.2 ... noship $) confirms a long-standing, stable implementation shared across 12.1.1 and 12.2.2.

Key Procedures and Functions

  • INSERT_CONCURRENT_ROW — Creates a dependency record linking a concurrent program, identified by its program name and application code, to a target function. It accepts the concurrent program name, the concurrent application code, and the function name as inputs.
  • DELETE_CONCURRENT_ROW — Removes a previously created concurrent-program-to-function dependency. It takes the same three identifying arguments (concurrent program name, concurrent application code, function name) to isolate the row to delete.
  • INSERT_ROW — Inserts a general portlet dependency row, capturing refresh dependency metadata (refresh dependency, refresh dependency context, and function name) along with the standard EBS WHO audit columns (rowid, creation date, created by, last update date, last updated by, last update login).
  • DELETE_ROW — Deletes a general portlet dependency row, keyed by refresh dependency, refresh dependency context, and function name.
  • PP_ACTION — A standard concurrent-request entry point that exposes the package logic to the concurrent manager, returning an error buffer and return code and accepting a step number.

Tables Accessed

  • FND_PORTLET_DEPENDENCY — The primary table this package inserts into and deletes from; it stores the refresh dependency, refresh dependency context, and function name relationships.
  • FND_CONCURRENT_PROGRAMS — Resolves concurrent program names and application codes when the concurrent-row procedures create or remove program-specific dependencies.
  • FND_APPLICATION — Supplies the application context used to validate or resolve the application code passed to the concurrent-row procedures.
  • DUAL — Used for singleton SELECT expressions and validation within the package body.

Usage Notes

Because the package is classified as OTHER and is not referenced by any other documented package, it is invoked directly by Oracle EBS forms, administrative setup screens, or internal concurrent processing rather than through a supported public API chain. The PP_ACTION procedure follows the EBS concurrent program PL/SQL calling convention (error buffer, return code, step), indicating that portions of the logic can be scheduled as a concurrent request.

The X_CONCURRENT_APPLICATION_CODE parameter, which the user searched for, appears on INSERT_CONCURRENT_ROW and DELETE_CONCURRENT_ROW and identifies the application owning the concurrent program whose execution the portlet function depends upon. Custom or third-party portlet integrations that need to seed refresh dependencies programmatically should call these procedures with the fully qualified concurrent program identity. Given the OTHER classification and the absence of other referencing packages, direct calls should be treated cautiously, and any use should be validated against the target EBS release, as behavior is stable but unsupported for external extension.