Search Results get_site_use_location

Overview

CS_STD is a shared utility package in the Oracle E-Business Suite (EBS) Applications schema (APPS) that supports the Service (Customer Care / Depot Repair) modules. It consolidates commonly needed lookup and formatting logic — retrieving default flexfield values, resolving contact phone numbers, fetching item revision descriptions, and returning address and party information — so that service forms, concurrent programs, and other PL/SQL packages can reuse a single validated source rather than duplicating queries. In the ETRM 12.2.2 registry the package is classified as API classification "OTHER," contains 27 documented procedures and functions, and is referenced by 95 other packages, which indicates it functions as a low-level dependency across a wide portion of the Service application stack. The header in the source (`$Header: csxcstds.pls 120.0 2005/06/01`) shows the package lineage predates Release 12 and has been carried forward with minimal change into 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented entry points cover several functional groups:

• GET_DEFAULT_VALUES — overloaded procedures that return default flexfield values (defaulting to flex code 'MSTK'), the manufacturing organization identifier and/or name, the application short name, and optional ordering attributes (order-by code, lookup type, order type, and day/month UOM codes).
• GET_CONTACT_PHONE and RETURN_PRIMARY_PHONE / RETURN_TRANSPOSE_PHONE — resolve telephone numbers for a given contact, including primary-phone and transposed-format variants.
• GET_ITEM_REV_DESC — returns the revision description for an item. As noted in the source comments, if the error flag is 'FALSE' a NULL is returned for an invalid revision, whereas 'TRUE' raises NO_DATA_FOUND.
• GET_SITE_USE_LOCATION, SITE_USE_ADDRESS, GET_ADDRESS_FROM_ID, GET_PRIMARY_ADDRESS, FORMAT_ADDRESS, and FORMAT_ADDRESS_CONCAT — address and site-use resolution and formatting utilities.
• GET_CUST_NAME, GET_SYSTEM_NAME, GET_WAR_ITEM_IDS, WARRANTY_EXISTS, CS_GET_SERVICED_STATUS — customer, system, warranty, and serviced-status lookups.
• GET_ITEM_VALDN_ORGZN_ID, GETITEMCATEGORY — item validation and category retrieval.
• GETNEXTVALINPERIOD, OUTPUT_MESSAGES — sequence-within-period generation and message output helpers.

Tables Accessed

The package reads (and in limited cases writes) the following tables through APPS synonyms:

• MTL_SYSTEM_ITEMS, MTL_ITEM_REVISIONS, MTL_CATEGORIES, MTL_DEFAULT_CATEGORY_SETS, MTL_ITEM_CATEGORIES, MTL_UNITS_OF_MEASURE — item validation, revision descriptions, category lookups, and UOM defaulting.
• HZ_PARTIES, HZ_PARTY_SITES, HZ_CONTACT_POINTS — party, site, and contact-point data supporting address and phone resolution.
• PER_ALL_PEOPLE_F, PER_PHONES — employee and phone information.
• CS_SYSTEMS, CSC_PROF_CHECK_RESULTS — service system records and profile check results.

Usage Notes

CS_STD is normally invoked indirectly. Service forms (for example, the Service Request and Depot Repair windows) call it for defaulting and display purposes; concurrent programs and other PL/SQL packages call it to share lookup logic. Because it is referenced by 95 other packages, any change to its public signatures carries broad regression risk. When calling GET_ITEM_REV_DESC, developers should be aware of the p_error_flag behavior described in the source, since a 'FALSE' setting suppresses the NO_DATA_FOUND exception and returns NULL. The commented-out GET_COTERMINATED_END_DT function is retained only as a historical note and is not callable in current releases.