Search Results get_hr_location

Overview

CSM_MULTI_MOBQRY_PKG is an Oracle EBS APPS schema PL/SQL package classified under the Service (CSM/CSP) module family. It supports the mobile field service ("MOB") query and transactional layer used by Oracle Field Service and Depot Repair flows, providing server-side logic that lets mobile or disconnected clients query available inventory, create and update ship-to and shipping attributes, receive and return parts, and refresh requirement and task statuses. The package acts as the integration bridge between the field service application forms and the underlying requirement, order entry, and receipt tables. Its status is VALID in both 12.1.1 and 12.2.2, and it belongs to the API classification OTHER, indicating it is not a formally published public API but is referenced internally by other service packages and forms.

Key Procedures and Functions

• Q_AVAILABLE_PARTS — Queries and returns the set of parts that are available for the current field service requirement, drawing on the available parts staging table.
• Q_RECEIVABLE_PARTS — Identifies parts eligible to be received back into stock, supporting the return-to-depot process.
• Q_RECEIVE_PARTS — Performs the receipt of parts against a field service requirement, updating inventory and requirement line information.
• Q_RETURN_ITEM — Handles the return of an individual item from the field, reversing its allocation or receipt.
• Q_CREATE_SHIPTO — Creates a ship-to address record for a requirement where one does not already exist.
• Q_UPD_OE_SHIPTO — Updates the ship-to information on the associated Order Entry (OE) order header.
• Q_UPD_OE_LINE_SHIPMETHOD — Updates the shipping method on Order Entry order lines to reflect the field-selected carrier or method.
• Q_UPD_RQMT_SHIP_TO — Updates the ship-to attribute on the requirement header itself.
• Q_UPD_TASK_STATUS — Updates the status of a field service task, synchronizing mobile task progress back to the server.
• Q_SHIP_METHODS — Returns the valid shipping methods available for selection in the mobile interface.
• GET_HR_LOCATION — Retrieves the HR location associated with an organization unit, used to derive valid ship-to and receipt locations.
• Q_GET_ADDRESS_DFF — Returns descriptive flexfield (DFF) values for an address, enabling the mobile client to display context-sensitive address attributes.

Tables Accessed

The package reads and writes through APPS synonyms. Requirement and demand data is held in CSP_REQUIREMENT_HEADERS, CSP_REQUIREMENT_LINES, and CSP_REQ_LINE_DETAILS, with the _ACC variants (CSM_REQ_LINE_DETAILS_ACC) providing the mobile-friendly access views. Available parts staging resides in CSP_AVAILABLE_PARTS_TEMP. Address and site information is sourced from HZ_CUST_ACCT_SITES_ALL and the CSM_HZ_CUST_ACCT_SITES_ALL_ACC and CSM_PO_LOC_ASS_ALL_ACC views. Customer and location context uses CSM_HZ_CUST_ACCT_SITES_ALL_ACC and HR_ALL_ORGANIZATION_UNITS_TL. Incident and debrief context is captured in CS_INCIDENTS_ALL_B and CSF_DEBRIEF_HEADERS. Flexfield and lookup validation draws on FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALUE_SETS, and FND_LOOKUP_VALUES, while ASG_USER supports user identity resolution.

Usage Notes

CSM_MULTI_MOBQRY_PKG is referenced by CSM_REQUIREMENTS_PKG, indicating it is invoked indirectly during requirement processing and mobile synchronization rather than directly by end users. Custom code should not assume a published parameter interface; the documented signature is not exposed here and parameters must be confirmed against the installed package spec. The package is self-referencing, meaning some procedures call other procedures within the same body. Typical invocation paths include mobile field service forms, depot repair flows, and concurrent programs that reconcile offline transactions. Because it spans Order Entry, receipt, and requirement updates, it should be called within a controlled transaction and error-handling block, with attention to the underlying OE and inventory interfaces that fire as a result.