Search Results frm_delivery_ftp_servers_pkg




Overview
Explore in AI Chat

Overview

The APPS.FRM_DELIVERY_FTP_SERVERS_PKG package is a server-side PL/SQL API that manages the repository of FTP delivery server definitions used by Oracle E-Business Suite's delivery and file transfer infrastructure. In Oracle EBS 12.1.1 and 12.2.2, the Oracle Forms-based reporting and delivery layer relies on a set of registered FTP endpoints to which completed output files, reports, and delivery artifacts can be transmitted. The package provides the canonical Data Manipulation Language (DML) interface over the underlying delivery FTP server tables, allowing a server record — identified by its host, port, authentication type, username, server type, and file permission mask — to be created, modified, locked for concurrent update, and removed in a controlled and auditable manner.

The package is declared with AUTHID CURRENT_USER, meaning that its procedures execute with the privileges of the invoking user rather than the defining owner, which is significant in the APPS schema context where synonym resolution and grants determine effective access. The header carries the CVS revision string $Header: frmdelftps.pls 120.0 2012/01/24 11:47:45 dhvenkat noship $, indicating it was authored and maintained under the Oracle Applications naming and versioning conventions. Within the ETRM documentation the API is classified as OTHER.

Key Procedures and Functions

The package exposes five documented procedures, none of which return values directly:

  • INSERT_ROW — Inserts a new delivery FTP server record. It accepts the full set of entity attributes (server identifier, host, port, authentication type, username, type, file permission, object version number, server name) together with the standard Oracle EBS WHO columns (creation date, created by, last update date, last updated by, last update login) and returns the affected row identifier.
  • LOCK_ROW — Acquires a row-level lock on an existing server record, validating the supplied attribute values against the current persisted state. This supports optimistic and pessimistic concurrency control in the Oracle Forms environment.
  • UPDATE_ROW — Modifies an existing server record, accepting the identifying attributes together with the changed values and the WHO audit columns. It is the designated path for maintaining server configuration.
  • DELETE_ROW — Removes a server record identified by its server identifier.
  • ADD_LANGUAGE — Populates translated (TL) rows for the entity's translatable columns, consistent with the Oracle EBS multi-language architecture.

Tables Accessed

The package operates against three tables, resolved through APPS synonyms:

  • FRM_DELIVERY_FTP_SERVERS_B — the base table storing the non-translatable columns of each FTP server definition. This is the primary target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
  • FRM_DELIVERY_FTP_SERVERS_TL — the translation table holding language-specific attributes such as the server name. It is maintained by ADD_LANGUAGE and supports the multilingual display of server definitions.
  • FND_LANGUAGES — the Oracle Common Applications language registry, queried by ADD_LANGUAGE to determine the installed and active languages for which translated rows must be generated.

Usage Notes

This package is not referenced by any other documented package in the ETRM metadata (referenced by 0 packages), indicating it is intended to be invoked directly rather than consumed by higher-level PL/SQL APIs. It is most commonly called from the Oracle Forms interface that administrators use to define and maintain FTP delivery servers, and it may also be invoked from custom concurrent programs or bespoke PL/SQL scripts performing bulk provisioning or migration of server definitions. Callers must supply a valid X_SERVER_ID, maintain the X_OBJECT_VERSION_NUMBER for concurrency control, and provide consistent WHO audit values. As with all EBS APIs, direct DML against the underlying tables is discouraged; this package should be used to preserve data integrity and translation consistency. Because the package runs with AUTHID CURRENT_USER, the invoking user requires the appropriate object privileges on the referenced APPS synonyms.