Search Results pos_src_approve_rfq_supplier




Overview
Explore in AI Chat

Overview

APPS.POS_REQUEST_UTILS_PKG is a PL/SQL utility package within the Oracle E-Business Suite Sourcing module. It provides the supplier and contact resolution logic used by Oracle Sourcing (POS) to bridge supplier registration records, party identifiers, and supplier site information maintained in Oracle Payables and Oracle Trading Community Architecture. The package is intended for internal consumption by Sourcing components that must convert a supplier or contact reference into the identifiers required by downstream purchasing and negotiation workflows.

The package header (POSRQUTS.pls, version 120.4) exposes four documented procedures. Its primary role is to support the supplier self-registration and RFQ-only supplier flows, in which a prospective supplier registers through Sourcing and is subsequently approved and made available for sourcing events. The package encapsulates the cross-module lookups required to translate a registration or contact request into the corresponding vendor, party, and site identifiers, returning standardized return status, message count, and message data parameters consistent with the EBS PL/SQL error-handling convention.

Key Procedures and Functions

  • POS_SRC_REGISTER_SUPPLIER — Invoked by Sourcing to invite a supplier to register. Accepts a supplier registration identifier and organization identifier, and returns the standard status and message outputs.
  • POS_SRC_APPROVE_RFQ_SUPPLIER — Invoked by Sourcing to create an RFQ-only supplier. Takes a supplier registration identifier and returns the resulting party identifier, vendor identifier, and standard status outputs.
  • POS_SRC_GET_SUPPLIER_DET — Retrieves supplier detail for a given supplier party and organization. This is the procedure matched by the search term "pos_src_get_supplier_det". It returns the vendor identifier, party site identifier, vendor site identifier, contact party identifier, and the standard status outputs.
  • POS_GET_CONTACT_APPROVED_DET — Resolves approved contact detail from a contact request identifier, returning the contact party identifier and standard status outputs.

Tables Accessed

  • POS_SUPPLIER_REGISTRATIONS — Stores supplier self-registration records. Read and updated by the registration and approval procedures to obtain registration context and to persist approval outcomes.
  • POS_CONTACT_REQUESTS — Stores contact request records used by POS_GET_CONTACT_APPROVED_DET to resolve an approved contact to its party identifier.
  • FND_USER — The Oracle Application Object Library user table, referenced to relate registered users, typically the registering contact, to the supplier or contact records being processed.

Usage Notes

POS_REQUEST_UTILS_PKG is an internal Sourcing utility rather than a public, supported API. The ETRM classification is OTHER, and the procedures carry no documented public API contract beyond the header signature. The package is invoked from Sourcing flows—supplier registration, RFQ-only supplier approval, and supplier/contact detail resolution—and is referenced by one other package. It is not designed for direct invocation from custom code, forms, or concurrent programs without Oracle's guidance, and any custom call to these procedures should be treated as an unsupported extension. The organization identifier parameter on the supplier procedures indicates that lookups are operating-unit aware, so callers must supply a valid ORG_ID in a multi-org environment.