[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;