Results for “delete_group”

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

Overview

PQH_TXN_CAT_DOCUMENTS_SWI is a self-service wrapper package in the Oracle E-Business Suite HRMS (Public Sector / Human Resources) product family, owned by the APPS schema. It belongs to the PQH module, which supports position management, transaction categories, and related HR self-service functionality. The package provides the self-service programmatic interface for maintaining documents associated with transaction categories. In the context of Oracle EBS 12.1.1 and 12.2.2, its role is to expose an SWI (Self-Service Interface) layer that web-based self-service flows can call, insulating the calling application from the underlying business logic contained in the standard API layer. The documented header indicates the package was authored under the 115.0 version control line (pqtcdswi.pkh), reflecting its long-standing presence in the Applications technology stack. The SWI classification marks it as an internal development object; the source documentation explicitly notes "Internal Development use only" for its procedures, meaning it is not intended as a public integration surface for customer extensions.

Key Procedures and Functions

The package exposes four documented procedures:

• CREATE_TXN_CAT_DOCUMENT — Self-service wrapper for the API procedure pqh_txn_cat_documents_api.create_txn_cat_document. It creates an association between a document and a transaction category records, returning an object version number and a return status (success or failure) to the caller. Parameters visible in the header include a validation flag, effective date, document identifier, transaction category identifier, and type code.
• DELETE_TXN_CAT_DOCUMENT — Self-service wrapper for pqh_txn_cat_documents_api.delete_txn_cat_document, removing an existing transaction category-to-document association and returning a return status.
• DELETE_GROUP — Removes a group of transaction category document associations, supporting bulk deletion within the self-service layer.
• UPDATE_TXN_CAT_DOCUMENT — Self-service wrapper for pqh_txn_cat_documents_api.update_txn_cat_document, modifying an existing transaction category-to-document association.

All procedures follow the standard EBS SWI convention of returning p_return_status to indicate success or failure and are declared AUTHID CURRENT_USER, so database privilege checks are performed against the invoking schema. Parameter lists are not reproduced here beyond what the provided metadata documents.

Tables Accessed

The package operates on the PQH_TXN_CATEGORY_DOCUMENTS table, referenced via an APPS synonym. This table stores the mapping between transaction categories and the documents attached to them within the PQH position/transaction management data model. The create, update, and delete procedures all write to this table; the wrapper layer performs no direct SQL beyond delegating to the underlying API, which owns the DML on this object. No other tables are documented as referenced by this package.

Usage Notes

PQH_TXN_CAT_DOCUMENTS_SWI is invoked from Oracle self-service web flows—typically OA Framework-based pages—where users attach, modify, or remove documents associated with transaction categories in the HRMS self-service application. It is also callable from custom PL/SQL or concurrent programs, provided callers honor the "internal development use only" access status and derive all IN parameters correctly before invocation. The documented metadata shows zero dependent packages referencing it, indicating it sits at the leaf of the dependency chain and is not reused by other EBS packages. Customers implementing extensions should prefer the underlying PQH_TXN_CAT_DOCUMENTS_API package rather than this self-service wrapper, since Oracle does not guarantee the SWI layer as a supported public interface across releases. When troubleshooting, note that failures surface through the p_return_status out parameter rather than exceptions, so callers must explicitly inspect the returned status to detect errors.