Search Results qa_ss_osp
Overview
QA_SS_OSP is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle Quality management module and its Supplier Self-Service (SS) integration layer, which exposes quality inspection and Outside Processing (OSP) functionality to external supplier users through the Oracle iSupplier Portal (ICX) framework. The package name follows the QA_SS_ naming convention, denoting that it is one of the Quality module's Supplier Self-Service support packages rather than a callable Open Interface or public API.
The package's central business purpose is to determine whether Outside Processing plans are applicable to the supplier-facing workbench, and to convert supplier-entered OSP events into Quality collection records. It is tightly coupled to QA_SS_CORE, a sibling support package that handles common supplier self-service quality logic, and to QA_SS_CONST, which supplies the constant values used across the QA_SS_ family. The package status in the Enterprise Technical Reference Model (ETRM) is VALID, and its API classification is OTHER, indicating that it is an internally consumed component rather than a published integration API.
Key Procedures and Functions
- ARE_OSP_PLANS_APPLICABLE — Evaluates whether Outside Processing inspection plans apply to the current supplier context. This function is used to conditionally enable or disable OSP-related quality activity on the supplier workbench.
- OSP_TO_QUALITY — Performs the substantive transformation that maps Outside Processing activity into Quality collection/result data, moving supplier-entered OSP information into the Quality tables so that inspection records are created for received outside-processed items.
- DEFAULT_OSP_VALUES — Populates default values for the Outside Processing fields presented to the supplier, ensuring the collection UI is pre-seeded with standard data before submission.
- OSP_PLANS — Retrieves and returns the set of applicable Outside Processing plans, typically driving the list of plans available on the supplier-facing page.
Tables Accessed
The documented dependency list includes PO_HEADERS_ALL and PO_RELEASES_ALL, which are accessed (via APPS synonyms) to retrieve purchasing document and release information against which outside processing events are validated. PO_HEADERS_ALL supplies header-level data such as supplier, document type, and status, while PO_RELEASES_ALL provides the release-level detail needed to associate quality collections with a specific purchase order release. HTP is also listed as a referenced dependency, reflecting use of the Oracle HTML toolkit for generating supplier-facing output.
In addition, the package reads from the view WIP_ICX_OSP_WORKBENCH_V, the Work in Process supplier workbench view that exposes outside processing jobs and operations to the iSupplier Portal, and it depends on QA_SS_CORE, QA_SS_CONST, and ICX_SEC. The QA_SS_CORE and QA_SS_CONST dependencies supply shared collection logic and shared constants respectively; ICX_SEC provides the security context and session information required for a self-service user.
Usage Notes
QA_SS_OSP is not referenced by any database object according to the dependency metadata, confirming that it sits at the upper edge of the call graph. It is therefore invoked predominantly from the Oracle iSupplier Portal Outside Processing and Quality workbench pages — the flows surfaced through WIP_ICX_OSP_WORKBENCH_V — rather than from concurrent programs or public APIs.
Because the package is classified as OTHER and is not a documented public interface, customizations should not call its procedures directly. Recommended practice is to rely on the supported supplier self-service UI, or on documented Oracle Quality Open Interfaces, when integrating OSP-to-Quality processing in either Release 12.1.1 or 12.2.2. The ETRM notes that QA_SS_OSP is referenced by three other packages, reinforcing its role as a shared internal utility within the QA_SS_ supplier self-service stack.
-
PACKAGE BODY: APPS.QA_SS_OSP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SS_OSP, status:VALID,
-
PACKAGE: APPS.QA_SS_OSP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:QA_SS_OSP, status:VALID,
-
PACKAGE: APPS.QA_SS_OSP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:QA_SS_OSP, status:VALID,
-
PACKAGE BODY: APPS.QA_SS_OSP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SS_OSP, status:VALID,
-
PACKAGE: APPS.QA_SS_CONST
12.1.1
owner:APPS, object_type:PACKAGE, object_name:QA_SS_CONST, status:VALID,
-
PACKAGE: APPS.QA_SS_CONST
12.2.2
owner:APPS, object_type:PACKAGE, object_name:QA_SS_CONST, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.QA_SS_CORE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:QA_SS_CORE, status:VALID,
-
PACKAGE: APPS.QA_SS_CORE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:QA_SS_CORE, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
PACKAGE BODY: APPS.QA_SS_CORE
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SS_CORE, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
PACKAGE BODY: APPS.WIP_OSP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WIP_OSP, status:VALID,
-
PACKAGE BODY: APPS.WIP_OSP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WIP_OSP, status:VALID,
-
PACKAGE BODY: APPS.QA_SS_CORE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SS_CORE, status:VALID,
-
PACKAGE: APPS.QA_SS_OSP
12.2.2
-
PACKAGE: APPS.QA_SS_OSP
12.1.1
-
VIEW: APPS.WIP_ICX_OSP_WORKBENCH_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_ICX_OSP_WORKBENCH_V, object_name:WIP_ICX_OSP_WORKBENCH_V, status:VALID,
-
VIEW: APPS.WIP_ICX_OSP_WORKBENCH_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:WIP.WIP_ICX_OSP_WORKBENCH_V, object_name:WIP_ICX_OSP_WORKBENCH_V, status:VALID,
-
PACKAGE BODY: APPS.QA_SS_OSP
12.1.1
-
PACKAGE BODY: APPS.QA_SS_OSP
12.2.2
-
PACKAGE: APPS.ICX_SEC
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ICX_SEC, status:VALID,
-
SYNONYM: APPS.PO_RELEASES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_RELEASES_ALL, status:VALID,
-
SYNONYM: PUBLIC.HTP
12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:HTP, status:VALID,
-
SYNONYM: APPS.PO_RELEASES_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_RELEASES_ALL, status:VALID,
-
PACKAGE: APPS.ICX_SEC
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ICX_SEC, status:VALID,
-
SYNONYM: PUBLIC.HTP
12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:HTP, status:VALID,
-
APPS.QA_SS_OSP dependencies on QA_SS_OSP
12.2.2
-
APPS.QA_SS_CORE dependencies on QA_SS_OSP
12.1.1
-
APPS.WIP_OSP dependencies on QA_SS_OSP
12.1.1
-
APPS.WIP_ICX_OSP_WORKBENCH_V dependencies on QA_SS_OSP
12.1.1
-
APPS.QA_SS_CORE dependencies on QA_SS_OSP
12.2.2
-
APPS.WIP_ICX_OSP_WORKBENCH_V dependencies on QA_SS_OSP
12.2.2
-
APPS.QA_SS_OSP dependencies on QA_SS_OSP
12.1.1
-
APPS.WIP_OSP dependencies on QA_SS_OSP
12.2.2
-
SYNONYM: APPS.PO_HEADERS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_HEADERS_ALL, status:VALID,
-
SYNONYM: APPS.PO_HEADERS_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_HEADERS_ALL, status:VALID,
-
APPS.QA_SS_CORE dependencies on QA_SS_SHIP
12.1.1
-
APPS.QA_SS_CORE dependencies on QA_SS_SHIP
12.2.2
-
APPS.QA_SS_OSP dependencies on HTP
12.2.2
-
APPS.QA_SS_OSP dependencies on HTP
12.1.1
-
eTRM - WIP Tables and Views
12.1.1
-
APPS.QA_SS_CORE dependencies on ICX_SEC
12.2.2
-
APPS.QA_SS_CORE dependencies on ICX_SEC
12.1.1
-
eTRM - WIP Tables and Views
12.2.2
-
PACKAGE BODY: APPS.QA_SS_CORE
12.2.2
-
PACKAGE BODY: APPS.QA_SS_CORE
12.1.1
-
eTRM - WIP Tables and Views
12.1.1
-
12.2.2 DBA Data
12.2.2