1 package CTO_PUBLIC_UTILITY_PK AUTHID CURRENT_USER as
2 /* $Header: CTOPUTLS.pls 120.0 2005/05/25 04:28:10 appldev noship $*/
3
4 /*----------------------------------------------------------------------------+
5 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA
6 | All rights reserved.
7 | Oracle Manufacturing
8 |
9 | FILE NAME : CTOPUTLS.pls
10 |
11 | DESCRIPTION : This is a PUBLIC package used primarily for having APIs which are
12 | called from other products. We decided to keep these APIs in
13 | seperate file to reduce dependencies.
14 |
15 | HISTORY : Created on 23-DEC-2002 by Shashi Bhaskaran
16 |
17 +-----------------------------------------------------------------------------*/
18
19
20 /*************************************************************************************
21
22 Bugfix 2695239
23
24 Input Parameters
25 ----------------
26 p_config_line_id : Line Id of the configuration
27 p_model_line_id : Line Id of the ATO model
28 p_quantity : Quantity for which total selling price is to be calculated
29
30
31 Output Parameters
32 -----------------
33 x_unit_selling_price : Unit Selling Price of the model. Calculated.
34 x_qty_selling_price : Total Selling Price of the model for quantity 'p_quantity'. Calculated.
35 x_currency_code : Currencty Code of the order line.
36
37 x_return_status : Return status of the API. Returns FND_API.G_RET_STS_ERROR if others exception is raised.
38 Otherwise G_RET_STS_SUCCESS
39 x_error_code : Return error code. 0 if success. 1 if error.
40
41 Note:
42 In case of hard-error, x_error_code will be set to 1
43 and x_return_status will be set to FND_API.G_RET_STS_ERROR
44 In case of soft-error, x_error_code will be set to 1
45 but x_return_status will be G_RET_STS_SUCCESS
46
47 *************************************************************************************/
48 procedure get_selling_price (
49 p_config_line_id IN NUMBER
50 , p_model_line_id IN NUMBER DEFAULT NULL
51 , p_quantity IN NUMBER DEFAULT 0
52 , x_unit_selling_price OUT NOCOPY NUMBER
53 , x_qty_selling_price OUT NOCOPY NUMBER
54 , x_currency_code OUT NOCOPY VARCHAR2
55 , x_return_status OUT NOCOPY VARCHAR2
56 , x_error_code OUT NOCOPY NUMBER);
57
58 END CTO_PUBLIC_UTILITY_PK;