Search Results delete_linkage

Overview

APPS.BIS_RSG_PUB_API_PKG is a public PL/SQL API package in Oracle E-Business Suite that exposes the metadata maintenance operations underpinning the BIS (Business Intelligence System) reporting and self-service components. Its header indicates a historical origin dating to 2005 (BISRSGPS.pls 120.1), and it is classified as an "OTHER" API under the APPS schema. The package provides a programmatic interface for creating, updating, and deleting the relationships that describe how reporting objects depend on one another, how objects are linked to programs, and how object-level properties such as dimensional behavior and custom API hooks are configured. Because these relationships drive the runtime behavior of the reporting layer, the package is effectively the metadata management surface used to keep the object dependency graph, program linkages, and object property registry consistent. It is referenced by five other packages, indicating it is a shared utility consumed across the BIS subsystem rather than a leaf-level component.

Key Procedures and Functions

The documented procedures fall into several functional families.

• Dependency management: Create_Dependency, Update_Dependency, Delete_Dependency, and a ROWID-based Delete_Dependency overload (added for bug 4606455) maintain records describing which object depends on which other object, including an enabled flag. Delete_Page_Dependencies removes dependency rows associated with a given page object name.
• Property management: Update_Property is the central entry point for modifying an object's configuration, accepting a dimension flag and a custom API specification. The focused procedures Update_Property_Dim_Flag and Update_Property_Custom_API modify those attributes independently. Delete_Property removes property records.
• Linkage management: Create_Linkage, Update_Linkage, Delete_Linkage, and Delete_Obj_Linkages manage object-to-program associations, while Update_Linkage_Enabled_Flag and Update_Linkage_Refresh_Mode control their activation state and refresh behavior.
• Supporting utilities: Get_Page_Name_By_Func resolves a page name from a function, GetParentObjects retrieves parent objects, and Enable_Index_Mgmt / Disable_Index_Mgmt toggle index management behavior.

Tables Accessed

The package operates against three documented tables through APPS synonyms. BIS_OBJ_DEPENDENCY stores the object dependency graph manipulated by the Create/Update/Delete_Dependency and Delete_Page_Dependencies procedures. BIS_OBJ_PROG_LINKAGES holds the object-to-program linkages maintained by the linkage procedures and their refresh and enabled-flag variants. BIS_OBJ_PROPERTIES stores per-object property records, including the dimension flag and custom API values written by Update_Property and its focused counterparts.

Usage Notes

This package is typically invoked programmatically rather than directly by end users. It is most likely called by the BIS administrative and setup forms, by concurrent programs that rebuild or validate reporting metadata, and by the five dependent PL/SQL packages identified in the ETRM metadata. Custom code should invoke these procedures through the standard APPS synonym convention and inspect the x_return_status and x_msg_data output parameters after every call to detect errors. Because the object identifiers and property flags feed directly into the reporting runtime, changes should be made only when the affected reporting objects are not actively in use, and in coordination with any index management toggles that may be required to keep the underlying tables efficient.