DBA Data[Home] [Help]

PACKAGE: APPS.OPI_DBI_REP_UOM_PKG

Source


1 PACKAGE opi_dbi_rep_uom_pkg AS
2 /* $Header: OPIDUMCNS.pls 120.0 2005/05/24 19:19:21 appldev noship $ */
3 
4 
5 /**************************************
6 * Package Level Constants
7 **************************************/
8 
9 COL_WIDTH  CONSTANT NUMBER         := 25;
10 LINE_WIDTH CONSTANT NUMBER         := 80;
11 LINE       CONSTANT VARCHAR2(30)   := '---------------';
12 NEWLINE    CONSTANT VARCHAR2(30)   := '
13 ';
14 
15 /**************************************
16 * Package Functions and Procedures
17 **************************************/
18 
19 
20 FUNCTION  uom_convert (p_item_id    number,
21                    p_precision      number,
22                    p_from_quantity  number,
23                    p_from_code      varchar2,
24                    p_to_code        varchar2) RETURN number PARALLEL_ENABLE;
25 
26 
27 FUNCTION  get_reporting_uom (p_measure_code varchar2) RETURN varchar2 PARALLEL_ENABLE;
28 
29 FUNCTION  get_w RETURN varchar2 PARALLEL_ENABLE;
30 
31 FUNCTION  get_v RETURN varchar2 PARALLEL_ENABLE;
32 
33 FUNCTION  get_d RETURN varchar2 PARALLEL_ENABLE;
34 
35 PROCEDURE err_msg_header;
36 
37 PROCEDURE err_msg_footer;
38 
39 PROCEDURE err_msg_missing_uoms (p_from_uom_code   varchar2,
40                                 p_to_uom_code     varchar2);
41 
42 PROCEDURE err_msg_header_spec (p_measure_code IN VARCHAR2,
43                                p_entity_type IN VARCHAR2);
44 
45 
46 END opi_dbi_rep_uom_pkg;