Search Results queue_int

Overview

SYS.KUPC$QUEUE_INT is an internal Oracle E-Business Suite database package that supports the queue management infrastructure of the Universal Product Catalog (UPC), the schema family underlying Oracle Advanced Product Catalog and the product information management layer shared across Oracle Purchasing, Order Management, Inventory, and related supply chain applications. The KUPC$ prefix identifies the object as a member of the UPC kernel-owned package family, and the $QUEUE_INT suffix indicates its role as an internal queue interface utility rather than a publicly callable business API.

The package is delivered in wrapped (obfuscated) form, with source stored in the SYS schema and typical of Oracle's internal kernel utilities. ETRM classifies the object as API classification OTHER, reflecting the fact that it is not exposed as an end-user integration point and is invoked only by other kernel packages or during product catalog queue processing. In EBS 12.1.1 and 12.2.2 the object resides in the SYS schema and is therefore not directly accessible to APPS without appropriate privileges, reinforcing its strictly internal role.

Key Procedures and Functions

The ETRM metadata for 12.2.2 documents zero standalone procedures or functions for this package. Because the unit is wrapped and presents no published PL/SQL specification, the callable entry points are not exposed to EBS documentation consumers. Practically, the package exists to provide queue-interfacing logic consumed by sibling UPC kernel units, and its internal routines are not intended to be referenced by name in customer-developed code.

The absence of documented procedures should not be read as an absence of behavior; it indicates that Oracle treats the package as a private implementation detail whose interface may change without notice across patch levels.

Tables Accessed

No tables are documented as referenced through APPS synonyms for this package. This is consistent with an internal queue utility: such units typically operate on staging, queue, or interface tables owned by the UPC or related kernel schemas, which are not published as APPS-synonym-accessible objects. Because the ETRM metadata records no APPS-level table access, custom reporting or integration that depends on these underlying tables cannot be validated against documented structures and should be treated as unsupported.

Usage Notes

ETRM records that SYS.KUPC$QUEUE_INT is referenced by eight other packages, confirming that it functions as a shared internal dependency within the UPC kernel rather than as a top-level entry point. It is not invoked from Oracle Forms or from a customer-facing concurrent program; instead it is called at runtime by the packages that manage product catalog queue population, processing, and propagation.

Do not call this package directly from custom PL/SQL, as its specification is undocumented, wrapped, and subject to change between 12.1.1 and 12.2.2 or within patch cycles.
Do not build dependencies on objects it may manipulate; the referenced tables are not documented through APPS synonyms.
When troubleshooting product catalog or queue-related errors, use this object only as a trace target in the call stack, and rely on supported UPC APIs for remediation.
Because the package is owned by SYS and shipped wrapped, any modification is unsupported and may violate Oracle's certification of the EBS environment.

PACKAGE: SYS.KUPC$QUEUE_INT 12.2.2
PACKAGE: SYS.KUPC$QUEUE_INT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:KUPC$QUEUE_INT, status:VALID,
PACKAGE: SYS.KUPC$QUEUE_INT 12.1.1
PACKAGE: SYS.KUPC$QUEUE_INT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:KUPC$QUEUE_INT, status:VALID,
PACKAGE BODY: SYS.KUPC$QUEUE_INT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:KUPC$QUEUE_INT, status:VALID,
SYS.KUPC$QUEUE_INT SQL Statements 12.2.2
PACKAGE BODY: SYS.KUPC$QUEUE_INT 12.2.2
PACKAGE BODY: SYS.KUPC$QUEUE_INT 12.1.1
SYS.KUPC$QUEUE_INT SQL Statements 12.1.1
PACKAGE BODY: SYS.KUPC$QUEUE_INT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:KUPC$QUEUE_INT, status:VALID,
PACKAGE: SYS.KUPC$QUEUE 12.1.1
owner:SYS, object_type:PACKAGE, object_name:KUPC$QUEUE, status:VALID,
PACKAGE: SYS.KUPC$QUEUE 12.2.2
owner:SYS, object_type:PACKAGE, object_name:KUPC$QUEUE, status:VALID,
PACKAGE: SYS.KUPC$QUE_INT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:KUPC$QUE_INT, status:VALID,
PACKAGE BODY: SYS.KUPC$QUEUE 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:KUPC$QUEUE, status:VALID,
TYPE: SYS.KUPC$_MESSAGE 12.1.1
owner:SYS, object_type:TYPE, object_name:KUPC$_MESSAGE, status:VALID,
TYPE: SYS.KUPC$_MESSAGE 12.2.2
owner:SYS, object_type:TYPE, object_name:KUPC$_MESSAGE, status:VALID,
PACKAGE BODY: SYS.KUPC$QUEUE 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:KUPC$QUEUE, status:VALID,
PACKAGE: SYS.KUPC$QUE_INT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:KUPC$QUE_INT, status:VALID,
PACKAGE: SYS.KUPV$FT_INT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:KUPV$FT_INT, status:VALID,
PACKAGE BODY: SYS.KUPV$FT_INT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:KUPV$FT_INT, status:VALID,
PACKAGE: SYS.KUPV$FT_INT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:KUPV$FT_INT, status:VALID,
PACKAGE BODY: SYS.KUPV$FT_INT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:KUPV$FT_INT, status:VALID,
PACKAGE BODY: SYS.KUPP$PROC 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:KUPP$PROC, status:VALID,
PACKAGE BODY: SYS.KUPP$PROC 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:KUPP$PROC, status:VALID,
PACKAGE: SYS.KUPF$FILE 12.2.2
owner:SYS, object_type:PACKAGE, object_name:KUPF$FILE, status:VALID,
PACKAGE: SYS.KUPF$FILE 12.1.1
owner:SYS, object_type:PACKAGE, object_name:KUPF$FILE, status:VALID,
PACKAGE BODY: SYS.KUPC$QUE_INT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:KUPC$QUE_INT, status:VALID,
PACKAGE BODY: SYS.KUPC$QUE_INT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:KUPC$QUE_INT, status:VALID,
PACKAGE BODY: SYS.KUPF$FILE 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:KUPF$FILE, status:VALID,
PACKAGE BODY: SYS.KUPF$FILE 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:KUPF$FILE, status:VALID,
PACKAGE BODY: SYS.DBMS_DATAPUMP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DATAPUMP, status:VALID,
PACKAGE BODY: SYS.DBMS_DATAPUMP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DATAPUMP, status:VALID,
PACKAGE: SYS.KUPCC 12.1.1
owner:SYS, object_type:PACKAGE, object_name:KUPCC, status:VALID,
PACKAGE: SYS.KUPCC 12.2.2
owner:SYS, object_type:PACKAGE, object_name:KUPCC, status:VALID,
PACKAGE BODY: SYS.KUPW$WORKER 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:KUPW$WORKER, status:VALID,
PACKAGE BODY: SYS.KUPW$WORKER 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:KUPW$WORKER, status:VALID,
PACKAGE BODY: SYS.KUPM$MCP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:KUPM$MCP, status:VALID,
PACKAGE BODY: SYS.KUPM$MCP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:KUPM$MCP, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
SYS.KUPC$QUEUE_INT dependencies on KUPC$QUEUE_INT 12.2.2
SYS.KUPC$QUEUE_INT dependencies on KUPC$QUEUE_INT 12.1.1
SYS.KUPC$QUEUE_INT dependencies on STANDARD 12.1.1
SYS.DBMS_DATAPUMP dependencies on KUPC$QUEUE_INT 12.1.1
SYS.KUPC$QUEUE_INT dependencies on KUPCC 12.1.1
SYS.KUPC$QUEUE_INT dependencies on STANDARD 12.1.1
SYS.KUPC$QUEUE_INT dependencies on STANDARD 12.2.2
SYS.KUPC$QUEUE_INT dependencies on KUPCC 12.2.2