Using Depot Repair Global Variables for Advanced Pricing
(Doc ID 1409827.1)
Last updated on JULY 14, 2020
Oracle Depot Repair - Version 220.127.116.11 and later Information in this document applies to any platform.
Form:CSDREPLN.FMB - Repairs
'Out of the box' Depot Repair supports a limited number of pricing qualifiers to calculate the price through Advanced Pricing for items on logistics lines, Estimates and Actuals. These are implemented in the code specifically. These qualifiers can be used in the pricing modifier definition without the need to do any customization.
The seeded qualifiers are
Description in Depot
Customer Account Id
Line Category Code
Line Category Code
Additionally, Depot Repair APIs also populate a number of what are known as Global Variables. These are attribute values that will have a value within the pl/sql session that is trying to retrieve the price (i.e. when the user is entering the record in the form). They are not visible to the user, but they can be used in the advanced pricing setup.
The following attributes can be referenced as CSD_REPAIRS_PUB.G_LINE.<attribute name>. For example, to access incident_id in the PLSQL code use CSD_REPAIRS_PUB.G_LINE.incident_id
incident_id (Service Request ID)
Repair Line Id
Inventory Item Id
Unit of Measure
Bill to Site Use Id
Ship to Site Use Id
Order Type Id
Line Type Id
Line Category Code
Transaction Billing Type Id
Price List Header Id
pricing_attribute1 through pricing_attribute100
Attributes (1 to 100)
Though the APIs do populate these global variables, using them in the application so that they actually have impact on the price in Depot Repair cannot be done without some customizations. This document describes the required setup (through a real business case), including customizations that have to be built.
This functionality using Global Variables is currently available on the latest patch levels as the global variables need to be declared in API CSD_REPAIRS_PUB (csdpdras.pls) and populated in CSD_PROCESS_UTILget_charge_selling_price (csdvutlb.pls)
for 11.5.10: Patch 7553775 ROLLUP PATCH FOR BUG FIXES BETWEEN DATES 07-OCT-2008 TO 15-DEC-2008 (<Patch 7356794> - ROLLUP PATCH FOR BUG FIXES BETWEEN DATES 01-OCT-2008 TO 15-OCT-2008 contained the original fix, but this patch has been superseded) Check to ensure the following (or later) file versions are in use: csdprdras.pls 115.21.11510.6 csdvutlb.pls 115.71.11510.30
for 12.1.3: Patch 19989456:R12.CSD.B ORACLE DEPOT REPAIR RECOMMENDED PATCH COLLECTION (02-DEC-14) (<Patch 19835304:R12.CSD.B> - ORACLE DEPOT REPAIR RECOMMENDED PATCH COLLECTION (07-NOV-14) contained the original fix, but this patch has been superseded) Check to ensure the following (or later) file versions are in use: csdpdras.pls 120.22.12010000.10 csdvutlb.pls 120.33.12010000.36
The information in this document assumes advanced knowledge of setting up e-Business Suite and additionally using tools to implement PL/SQL.
The information, software, products and services contained in this article may be out of date or include omissions, inaccuracies or other errors. The information, software products and services contained on this web site, including the materials, are provided "as is" and without warranty. Oracle does not warrant that the information in the materials is up to date or error free, nor does it provide any other warranties, whether expressed or implied in law, including the implied warranties of merchantability or fitness for a particular purpose. The materials are not a program or documentation under the terms of your license agreement(s) with Oracle.
In no event shall Oracle be liable for any direct, indirect, incidental, special or consequential damages, or damages for loss of profits, revenue, data or use, incurred by you or any third party, whether in an action in contract or tort, arising from your access to, or use of, this web site or any other hyperlinked web site.
Oracle reserves the right to make changes or updates to this article or the products or programs described in this web site at any time without notice.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!