Search Results okc_qa_check_list_pvt
Overview
The APPS.OKC_QA_CHECK_LIST_PVT package is a private PL/SQL API within the Oracle E-Business Suite Contract Lifecycle Management (OKC) module. It provides the internal implementation layer for managing Quality Assurance (QA) check lists associated with contracts, contract templates, and contract deliverables. In the Oracle EBS architecture, packages classified as "PVT" (private) are not intended for direct invocation by external callers; instead, they are wrapped by a corresponding public package — in this case OKC_QA_CHECK_LIST_PUB — which exposes supported entry points while the _PVT package handles the underlying business logic, validation, concurrency locking, and persistence operations.
The package supports the definition and maintenance of QA check lists and the individual QA processes and QA parameters that comprise a check list. These constructs allow organizations to define structured quality verification steps that must be completed against contract terms, ensuring consistency in contract authoring and compliance workflows.
Key Procedures and Functions
The package exposes sixteen documented procedures, organized into three functional groupings.
- Check List operations:
CREATE_QA_CHECK_LIST,UPDATE_QA_CHECK_LIST,DELETE_QA_CHECK_LIST,LOCK_QA_CHECK_LIST, andVALIDATE_QA_CHECK_LISThandle the lifecycle of a QA check list header record, including insertion, modification, removal, concurrency locking prior to modification, and business-rule validation. - QA Process operations:
CREATE_QA_PROCESS,UPDATE_QA_PROCESS,DELETE_QA_PROCESS,LOCK_QA_PROCESS, andVALIDATE_QA_PROCESSmanage individual QA processes that belong to a check list, following the same create/update/delete/lock/validate pattern. - QA Parameter operations:
CREATE_QA_PARM,UPDATE_QA_PARM,DELETE_QA_PARM,LOCK_QA_PARM, andVALIDATE_QA_PARMmanage the parameters that further qualify a QA process. - Language support:
ADD_LANGUAGEinserts translated (MLS) rows for the check list and related entities, supporting multi-language deployments.
Parameter lists are not documented in the ETRM metadata and should not be assumed; developers must inspect the package specification for current signatures.
Tables Accessed
The ETRM metadata does not enumerate specific base tables for this package. However, the dependency listing confirms that OKC_QA_CHECK_LIST_PVT invokes sibling packages OKC_QCL_PVT, OKC_QLP_PVT, and OKC_QPP_PVT (QA check list, QA process, and QA parameter private packages, respectively), as well as the general OKC_API utility package. The actual DML against OKC QA tables (such as OKC_QA_CHECK_LISTS_B/TL and their process and parameter child tables) is delegated to those helper packages rather than performed directly here. This layered design centralizes table access and preserves consistency across QA-related APIs.
Usage Notes
Because this is a _PVT package, it is not a supported integration point. External callers should use OKC_QA_CHECK_LIST_PUB, which delegates to this package. The dependency metadata confirms that OKC_QA_CHECK_LIST_PUB references this package, and that OKC_QA_CHECK_LIST_PVT is referenced by exactly one other package. Typical invocation paths include the Contract Terms and QA setup forms within the Contracts (OKC) responsibility, concurrent programs that seed or migrate QA check list data, and custom extensions that have been granted explicit access. Direct calls bypass the public API contract and risk breaking with patches. All calls must honor the LOCK/VALIDATE sequencing to avoid concurrency errors and referential integrity violations.
-
PACKAGE: APPS.OKC_QA_CHECK_LIST_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_QA_CHECK_LIST_PVT, status:VALID,
-
PACKAGE: APPS.OKC_QLP_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_QLP_PVT, status:VALID,
-
PACKAGE: APPS.OKC_QLP_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_QLP_PVT, status:VALID,
-
PACKAGE: APPS.OKC_QPP_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_QPP_PVT, status:VALID,
-
PACKAGE: APPS.OKC_QPP_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_QPP_PVT, status:VALID,
-
PACKAGE: APPS.OKC_QA_CHECK_LIST_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_QA_CHECK_LIST_PVT, status:VALID,
-
PACKAGE: APPS.OKC_QCL_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_QCL_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKC_QA_CHECK_LIST_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_QA_CHECK_LIST_PVT, status:VALID,
-
PACKAGE: APPS.OKC_QCL_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_QCL_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKC_QA_CHECK_LIST_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_QA_CHECK_LIST_PVT, status:VALID,
-
PACKAGE: APPS.OKC_QA_CHECK_LIST_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_QA_CHECK_LIST_PUB, status:VALID,
-
PACKAGE BODY: APPS.OKC_QA_CHECK_LIST_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_QA_CHECK_LIST_PUB, status:VALID,
-
PACKAGE: APPS.OKC_QA_CHECK_LIST_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_QA_CHECK_LIST_PUB, status:VALID,
-
PACKAGE BODY: APPS.OKC_QA_CHECK_LIST_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_QA_CHECK_LIST_PUB, status:VALID,
-
PACKAGE: APPS.OKC_QA_CHECK_LIST_PVT
12.1.1
-
PACKAGE: APPS.OKC_QA_CHECK_LIST_PVT
12.2.2
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
PACKAGE BODY: APPS.OKC_QA_CHECK_LIST_PVT
12.2.2
-
PACKAGE BODY: APPS.OKC_QA_CHECK_LIST_PVT
12.1.1
-
APPS.OKC_QA_CHECK_LIST_PUB dependencies on OKC_QA_CHECK_LIST_PVT
12.2.2
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_QA_CHECK_LIST_PVT
12.1.1
-
APPS.OKC_QA_CHECK_LIST_PUB dependencies on OKC_QA_CHECK_LIST_PVT
12.2.2
-
APPS.OKC_QA_CHECK_LIST_PUB dependencies on OKC_QA_CHECK_LIST_PVT
12.1.1
-
APPS.OKC_QA_CHECK_LIST_PUB dependencies on OKC_QA_CHECK_LIST_PVT
12.1.1
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_QA_CHECK_LIST_PVT
12.2.2
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on FND_PROFILE
12.2.2
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on FND_PROFILE
12.1.1
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_QCL_PVT
12.2.2
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_QCL_PVT
12.1.1
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_QCL_PVT
12.1.1
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_QCL_PVT
12.2.2
-
PACKAGE: APPS.OKC_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_API, status:VALID,
-
PACKAGE: APPS.OKC_API
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_API, status:VALID,
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_API
12.1.1
-
APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_API
12.2.2
-
PACKAGE: APPS.FND_PROFILE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE, status:VALID,
-
PACKAGE: APPS.FND_PROFILE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.FND_API
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
-
PACKAGE: APPS.FND_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
-
PACKAGE: SYS.STANDARD
12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,