Search Results delete_object

Overview

APPS.BISM_EXPORT_READER is a server-side PL/SQL package that forms part of the Oracle E-Business Suite Business Intelligence System Management (BISM) subsystem. Its role is to act as a reader and housekeeping utility against the BISM_EXPORT table, which stores exported business intelligence objects and their associated binary payloads. The package exposes a small, focused API for retrieving a stored export object through a reference cursor and for purging previously exported objects either individually or in bulk. In the EBS 12.1.1 and 12.2.2 environments the package belongs to the APPS schema and is classified as an OTHER API, meaning it is not a public business-document API but an internal support component invoked by other BISM processing logic. The package header carries a version header dated 2006, indicating the interface has been stable across the 11i and 12.x release families.

Key Procedures and Functions

• GET_OBJECT — A function that returns a reference cursor (SchemaCurType) over the requested export object. It accepts an object group name, an object GUID supplied as an IN OUT NOCOPY parameter, and a file name, and uses that combination to locate and project the stored object data. The IN OUT NOCOPY form of the GUID parameter allows the value to be updated in place during retrieval without a copy being made.
• DELETE_OBJECT — A procedure that removes a single export object from the repository, identified by its group name, GUID, and file name. It is intended for targeted cleanup of one object at a time.
• DELETE_OBJECTS — A procedure that performs bulk deletion of export objects. It accepts an age threshold expressed in seconds and purges objects that have exceeded that age, supporting scheduled retention and housekeeping of the BISM_EXPORT table.

The package also declares the public type SchemaCurType as a REF CURSOR, which is the return mechanism for GET_OBJECT and the means by which callers consume the retrieved export data row by row.

Tables Accessed

The package operates against two tables visible through APPS synonyms:

• BISM_EXPORT — The principal data store. It holds the exported business intelligence objects, keyed by group name, GUID, and file name. GET_OBJECT reads from it, DELETE_OBJECT removes a single row, and DELETE_OBJECTS removes rows older than the supplied threshold.
• DUAL — Used for single-row evaluation and utility constructs within the package body.

Usage Notes

BISM_EXPORT_READER is not typically invoked directly from an EBS form. Because it is classified as an OTHER API and is referenced by no other documented packages, it is most likely called from internal BISM export/import processing or from custom code and concurrent programs that manage the lifecycle of exported business intelligence content. The DELETE_OBJECTS procedure is well suited to a scheduled concurrent program that receives a retention interval in seconds and prunes stale export rows; DELETE_OBJECT serves ad hoc or event-driven removal of a specific object identified by its group, GUID, and file name. Custom integrations that need to consume a stored export object should call GET_OBJECT and iterate the returned REF CURSOR. Callers should treat the group name and GUID as RAW values and the file name as NVARCHAR2, and should expect the GUID argument to be passed with NOCOPY semantics. Because the package is an internal support component rather than a published interface, its signature should be treated as stable but not guaranteed, and any dependency should be reviewed when applying EBS patches.