Search Results qp_pte_source_system_s

Overview

QP_LOADER_PVT is a private (PVT-classified) PL/SQL package body in the APPS schema that supports the Oracle Advanced Pricing and Oracle Procurement Transaction Extensions (PTE) data model. Its core business function is to load, validate, and maintain the setup data that governs how external or source systems interact with pricing and sourcing functionality — specifically source systems, source-system functional-area mappings, and procurement request types with their translations. In effect, the package acts as a data-loading utility layer that populates the setup tables consumed by PTE-driven transactions, ensuring that request-type taxonomies and source-system-to-functional-area relationships are available in the required languages and structures. It is a private implementation package, not part of the published public API surface, and is therefore invoked internally by other EBS components rather than by direct customer calls. The object is documented as VALID and carries no downstream package dependencies — it is not referenced by any other database object — which confirms its role as a leaf-level loader rather than a shared utility library.

Key Procedures and Functions

• QP_PTE_SOURCE_SYS_LOAD_ROW — Loads an individual source-system row, interfacing with the QP_PTE_SOURCE_SYSTEMS and QP_PTE_SOURCE_SYSTEM_S tables to persist source-system definitions and their flexible-name/attribute references.
• QP_PTE_SS_FN_AREA_LOAD_ROW — Loads a single source-system-to-functional-area mapping row, using QP_PTE_SS_FNAREA_ID_S and QP_SOURCESYSTEM_FNAREA_MAP to establish the association between a source system and the functional areas it serves.
• QP_PTE_REQ_TYPES_TRANSLATE_ROW — Loads translated request-type records, working against the translation table QP_PTE_REQUEST_TYPES_TL and the FND_LANGUAGES table to populate language-specific descriptions and names.
• QP_PTE_REQ_TYPES_LOAD_ROW — Loads the base request-type record, inserting or updating the QP_PTE_REQUEST_TYPES_B table that anchors the request-type entity.

Each procedure is a row-level loader, designed to be called iteratively by a higher-level orchestration routine. The package also leverages FND_LOAD_UTIL, FND_MESSAGE, and STANDARD for utility, messaging, and error-handling support during the load process.

Tables Accessed

• QP_PTE_SOURCE_SYSTEMS — Base source-system definitions written by QP_PTE_SOURCE_SYS_LOAD_ROW.
• QP_PTE_SOURCE_SYSTEM_S — The "S" (flexfield or reference) companion table for source systems, also written during source-system loading. This is the table associated with the user's search term "qp_pte_source_system_s".
• QP_PTE_SS_FNAREA_ID_S — Stores functional-area identifier references tied to source systems.
• QP_SOURCESYSTEM_FNAREA_MAP — The mapping table linking source systems to functional areas.
• QP_PTE_REQUEST_TYPES_B and QP_PTE_REQUEST_TYPES_TL — The base and translated request-type definition tables.
• FND_LANGUAGES — Read to resolve installed/active languages when inserting translations.
• DUAL — Used for standard single-row PL/SQL and validation constructs.

Usage Notes

QP_LOADER_PVT is a private package and is not referenced by any other database object per the documented dependency metadata, indicating it is invoked directly by Oracle EBS forms, concurrent programs, or internal loading routines that manage PTE setup rather than through a public API. Because its procedures operate at row level, typical invocation occurs within a loop driven by a form's block processing or by a concurrent loader that iterates over a staging set of source systems, functional-area mappings, and request types. When troubleshooting PTE setup issues — particularly missing rows in QP_PTE_SOURCE_SYSTEMS, QP_PTE_SOURCE_SYSTEM_S, or the functional-area mapping tables — this package is the relevant code path. Custom extensions should treat it as a private implementation and avoid direct calls; the supported integration points are the EBS forms and concurrent programs that wrap it. Any modification to this body is discouraged as it falls outside the supported public API boundary.