My Oracle Support Banner

Using Depot Repair Global Variables for Advanced Pricing (Doc ID 1409827.1)

Last updated on FEBRUARY 15, 2018

Applies to:

Oracle Depot Repair - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:CSDREPLN.FMB - Repairs


Purpose

'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

ContextAttributeDescription in Depot
Customer Customer Name Customer Account Id
Customer Party ID Party ID
Customer Customer Class Customer Class
Order Order Type Order Type
Order Line Type Line Type
Order Line Category Code Line Category Code
Party Information Sales Organization Operating Unit


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

Variable NameDescription
incident_id   (Service Request ID) Incident Id
repair_line_id Repair Line Id
inventory_item_id Inventory Item Id
unit_of_measure_code Unit of Measure
quantity Quantity
currency_code Currency Code
account_id Account Id
party_id Party Id
bill_to_site_use_id Bill to Site Use Id
ship_to_site_use_id Ship to Site Use Id
customer_class Customer Class
org_id Operating Unit
order_type_id Order Type Id
line_type_id Line Type Id
line_category_code Line Category Code
txn_billing_type_id Transaction Billing Type Id
price_list_header_id Price List Header Id
pricing_context Pricing Context
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)

.

Scope

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.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Apply Patch
 Create a custom Pricing package
 Set up Pricing Modifier against ship to site
 Attribute Linking and Mapping
 Run Build Attribute Mapping Rules
 Create Pricing Modifier
 Assign Modifier Qualifier
 Create new profile option
 Set the profile option 'CSD: Use Global Variables for Advanced Pricing'
 Set profile option 'CSD: Enable Dynamic Formula for Pricing Attributes'
 Modify the Depot Repair Package that Retrieves the Price
 Test
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.