Search Results get_current_user_quote_access




Overview
Explore in AI Chat

Overview

OKC_REP_SEARCH_UTIL_PVT is an internal PL/SQL utility package in the APPS schema belonging to the Oracle Contracts (OKC) family of modules. It supports the Oracle Contracts Repository and search infrastructure used by the ETRM (Enterprise Contracts) application. The package name carries the "PVT" suffix, which by Oracle EBS naming convention indicates a private package body intended to be called by other API layers rather than directly by end-user customizations or forms constructs. Its purpose is to supply helper logic for determining document access control, resolving party information, evaluating intent profile and MOAC keys, and inspecting contract and quote statuses on behalf of the repository search subsystem. Because it is a utility package rather than a public API, it encapsulates reusable queries and access-control checks that search and lookup routines require, without exposing a stable public contract to external callers.

Key Procedures and Functions

  • GET_REP_DOC_ACL — Retrieves the access control list associated with a repository document, supporting security filtering of search results.
  • GET_CURRENT_USER_ACL_KEYS — Returns the access control list keys that apply to the currently logged-in user, enabling row-level visibility decisions.
  • GET_CURRENT_USER_MOAC_KEYS — Returns the Multi-Org Access Control keys for the current user, used to filter data by accessible operating units.
  • GET_INTENT_PROFILE_KEYS — Resolves intent profile keys, which govern the behavioral context under which contract documents are created and searched.
  • GET_CURRENT_USER_QUOTE_ACCESS — Determines the current user's access rights to quote data used in contract sourcing.
  • GET_LOCAL_LANGUAGE_ATTRIBUTES — Returns language-related attributes for localized display of contract information.
  • GET_REP_PARTIES — Retrieves the parties associated with a repository contract document.
  • GET_TERMS_LAST_UPDATE_DATE — Returns the last update date of contract terms, useful for search ordering and change detection.
  • DRAFT_ATTACHMENT_EXISTS — Checks whether a draft attachment exists for a given contract, guarding attachment-related operations.
  • IS_CONTRACT_STATUS_DRAFT — Determines whether a contract is in draft status.
  • GET_NEG_PARTIES — Returns the parties involved in a negotiation.
  • GET_CONTRACT_ORG — Returns the organization associated with a contract.

Tables Accessed

The package reads from a range of contracts, quoting, and shared reference tables via APPS synonyms. Contract tables include OKC_REP_CONTRACTS_ALL, OKC_REP_CONTRACT_PARTIES, and OKC_REP_CONTRACT_VERS, which supply core repository document, party, and version data. Quoting and order access is drawn from ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_STATUSES_B, OE_BLANKET_HEADERS_ALL, and OE_ORDER_HEADERS_ALL. Party and resource resolution relies on HZ_PARTIES, HR_ALL_ORGANIZATION_UNITS, JTF_RS_GROUP_MEMBERS, and JTF_RS_RESOURCE_EXTNS. Security and configuration data come from FND_GRANTS, FND_OBJECTS, FND_LOOKUP_VALUES, and FND_NEW_MESSAGES.

Usage Notes

Because OKC_REP_SEARCH_UTIL_PVT is a PVT package with no dependent packages referencing it directly, it is invoked internally by the ETRM repository search and access-control layers rather than through standard form or concurrent program entry points. It should be treated as a private implementation detail; customizations should call supported public APIs instead. It exists in both 12.1.1 and 12.2.2, with the documented metadata reflecting 12.2.2.