1 Package CSD_RETURNS_BI_UTIL AUTHID CURRENT_USER AS
2 /* $Header: csdurbis.pls 120.0.12010000.1 2010/04/14 23:21:29 swai noship $ */
3
4 /*--------------------------------------------------------*/
5 /* function name: CONVERT_INV_UOM */
6 /* description : function used to convert quantities from */
7 /* one inventory UOM to another */
8 /* Called from : Depot Repair Returns BI dashboard */
9 /* Input Parm : */
10 /* p_qty NUMBER qty to convert */
11 /* p_from_uom VARCHAR2 From UOM code */
12 /* p_to_uom VARCHAR2 To UOM code */
13 /* p_error_val NUMBER Value to return if qty */
14 /* is null or conversion */
15 /* errored out */
16 /* Output: */
17 /* NUMBER Converted currency amount */
18 /* Returns null if there is an error */
19 /* Change Hist : */
20 /*--------------------------------------------------------*/
21 FUNCTION CONVERT_INV_UOM (p_qty IN NUMBER,
22 p_from_uom IN VARCHAR2,
23 p_to_uom IN VARCHAR2,
24 p_error_val IN NUMBER) RETURN NUMBER;
25
26
27 /*--------------------------------------------------------*/
28 /* function name: CONVERT_CURRENCY */
29 /* description : function used to convert currency - */
30 /* Called from : Depot Repair Returns BI dashboard */
31 /* Input Parm : */
32 /* p_amount NUMBER Amount to convert */
33 /* p_from_currency VARCHAR2 From currency code */
34 /* p_to_currency VARCHAR2 To Currency code */
35 /* p_error_val NUMBER Value to return if amt */
36 /* is null or conversion */
37 /* errored out */
38 /* Output: */
39 /* NUMBER Converted currency amount */
40 /* Returns null if there is an error */
41 /* Change Hist : */
42 /*--------------------------------------------------------*/
43 FUNCTION CONVERT_CURRENCY( p_amount IN NUMBER,
44 p_from_currency IN VARCHAR2,
45 p_to_currency IN VARCHAR2,
46 p_conversion_date IN DATE,
47 p_error_val IN NUMBER) RETURN NUMBER;
48
49 END CSD_RETURNS_BI_UTIL;