Search Results get_all_scs_pk




Overview
Explore in AI Chat

Overview

QPR_SR_UTIL is a utility package in the Oracle EBS Advanced Pricing / Oracle Price Protection (QPR) schema. It is declared with AUTHID CURRENT_USER and is classified as a UTIL package, meaning it provides shared helper routines rather than a business transaction API. Its primary purpose is to supply standardized list-of-values building blocks — principally "All" and "Null" pseudo-values — used across the pricing datamart reporting and analysis components (QPR_CUBES, QPR_DIMENSIONS, QPR_MEASURES, and related metadata tables). The package centralizes the generation of surrogate primary keys and descriptive labels for every major analytical dimension, so that forms, concurrent programs, and dependent packages reference a single consistent implementation.

Key Procedures and Functions

The package exposes numerous public functions, the majority following a paired get_all_<dimension>_pk / get_all_<dimension>_desc convention. Each pair returns the reserved primary key value and its matching display description for the "All" member of a given dimension.

  • get_null_pk / get_null_desc — return the sentinel key and label used to represent the absence of a dimension selection.
  • get_all_scs_pk / get_all_scs_desc — return the "All" key and description for the Sales Channel dimension; this is the function referenced in the search term.
  • get_all_cus_pk / get_all_cus_desc — customer dimension "All" key and description.
  • get_all_geo_pk / get_all_geo_desc — geography dimension.
  • get_all_org_pk / get_all_org_desc — organization dimension.
  • get_all_prd_pk / get_all_prd_desc and get_all_rep_pk / get_all_rep_desc — product and reporting/representative dimensions.
  • get_all_ord_pk / get_all_ord_desc, get_all_adj_pk / get_all_adj_desc, get_all_dsb_pk / get_all_dsb_desc, get_all_vlb_pk / get_all_vlb_desc, get_all_mgb_pk / get_all_mgb_desc, get_all_oad_pk / get_all_oad_desc, get_all_cos_pk / get_all_cos_desc, get_all_psg_pk / get_all_psg_desc, and get_all_year_pk / get_all_year_desc — equivalent "All" accessors for order, adjustment, disablement, volume, margin group, order adjustment, cost, pricing segment, and year dimensions.
  • get_cost_type_desc and get_dimension_desc(p_type, p_code) — descriptive lookups keyed by dimension type and code.
  • dm_parameters_ok — validation check on datamart parameters.
  • set_customer_attr(p_profile_name, p_profile_value, p_profile_level) — sets a customer attribute profile context.

Tables Accessed

Via APPS synonyms, the package references configuration and metadata tables including QPR_CUBES, QPR_CUBE_DIMS, QPR_DIMENSIONS, QPR_DIM_ATTRIBUTES, QPR_HIERARCHIES, QPR_HIER_LEVELS, QPR_INSTANCES, QPR_LVL_ATTRIBUTES, QPR_MEASURES, QPR_MEASURE_GROUPS, QPR_CURRENCY_RATES, plus foundation tables FND_CURRENCIES, FND_LOOKUP_VALUES, HZ_CUST_ACCOUNTS, and MTL_SYSTEM_ITEMS. These supply the keys, level attributes, and descriptions returned by the accessor functions.

Usage Notes

QPR_SR_UTIL is consumed by 58 other packages, primarily during list-of-values population on pricing forms and during datamart build/refresh concurrent programs. Custom code should call the paired functions to obtain the correct "All" or null sentinel values rather than hard-coding key constants, ensuring compatibility across EBS 12.1.1 and 12.2.2.