Search Results jtf_varchar2_table
Overview
CSD_REPAIR_MANAGER_UTIL is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite, classified as a UTIL API within ETRM. It supports the Repair Manager portal, a component of the Depot Repair (CSD) module, by centralizing helper logic that would otherwise be duplicated across the portal's presentation and processing layers. The package header carries the revision marker $Header: csdurpms.pls 120.2.12020000.2 2013/03/26 06:27:33 subhat ship $ and was originally created on 15-Jul-2009 by Sudheer Bhat. The utility scope covers three broad areas: threshold resolution for repair quality and aging rules, mass processing of repair orders and their attachments, and the creation of service requests linked to repair orders. A private record type, sr_rec_type, together with its associated sr_tbl_type collection, is declared in the package to model service request attributes — account, party, incident, bill-to and ship-to site use, type, status, severity, urgency, owner, and a creation flag — indicating that the package constructs and processes service requests in bulk.
Key Procedures and Functions
The package exposes nine documented program units. Two functions resolve threshold configuration: GET_ITEM_QUALITY_THRESHOLD returns the applicable quality threshold configured for an inventory item and organization, and GET_AGING_THRESHOLD returns the applicable aging threshold based on organization, item, repair type, flow status, and revision. These functions encapsulate the lookup rules so callers do not query the threshold tables directly.
Several procedures perform bulk, portal-driven operations. MASS_UPDATE_REPAIR_ORDERS applies updates across a set of repair orders. MASS_CREATE_REPAIR_ORDERS creates multiple repair orders in a single invocation, and MASS_CREATE_REPAIR_ORDERS_CP provides the concurrent-program entry variant of that same operation. MASS_CREATE_ATTACHMENTS creates attachments across multiple repair orders in bulk. CREATE_SR_REPAIR_ORDER creates a service request associated with a repair order, working with the service request record and collection types declared in the specification. UPDATE_EXTERNAL_REFERENCE maintains the external reference value held against repair records. Finally, STRING_AGGREGATE is a string utility used to concatenate values, typically to assemble delimited lists of identifiers for downstream processing.
Tables Accessed
The package reads and writes through APPS synonyms. Threshold resolution depends on CSD_QUALITY_THRESHOLDS_B and CSD_AGING_THRESHOLDS_B, with flow status context from CSD_FLOW_STATUSES_B and repair classification from CSD_REPAIR_TYPES_B. Repair order maintenance centers on CSD_REPAIRS, with transactional history in CSD_REPAIR_HISTORY and product transaction detail in CSD_PRODUCT_TRANSACTIONS and its index CSD_PRODUCT_TRANSACTIONS_S1. Bulk creation from external or staged data uses CSD_REPAIRS_INTERFACE and CSD_REPAIRS_INTERFACE_S2. Installed base context is drawn from CSI_ITEM_INSTANCES and CSI_I_PARTIES. Service request creation references CS_INCIDENTS_ALL_B. Attachment processing uses FND_ATTACHED_DOCUMENTS, including FND_ATTACHED_DOCUMENTS_S. Two other packages reference these procedures, confirming the utility role.
Usage Notes
CSD_REPAIR_MANAGER_UTIL is invoked from the Repair Manager portal for interactive mass actions, from concurrent programs for batch repair order creation (via MASS_CREATE_REPAIR_ORDERS_CP), and from custom code that requires the same threshold or service request logic. Because it is a utility API rather than a public business API, callers should treat signatures as subject to change across patches and should not bypass it when performing mass repair operations that depend on configured thresholds. Regarding the search term "adobe pdf repair kernelapps," this package is unrelated to Adobe PDF or kernel-level applications; it belongs strictly to Oracle Depot Repair.