[Home] [Help]
PACKAGE BODY: APPS.PO_COMMON_XMLP_PKG
Source
1 package body po_common_xmlp_pkg as
2 /* $Header: POCOMMONB.pls 120.2 2008/01/03 11:11:42 dwkrishn noship $ */
3
4 -- Private type declarations
5 -- Function and procedure implementations
6 function get_precision(qty_precision in number) return VARCHAR2 is
7 begin
8
9 if qty_precision = 0 then return('999G999G999G990');
10
11 elsif qty_precision = 1 then return('999G999G999G990D0');
12
13 elsif qty_precision = 3 then return('999G999G999G990D000');
14
15 elsif qty_precision = 4 then return('999G999G999G990D0000');
16
17 elsif qty_precision = 5 then return('999G999G999G990D00000');
18
19 elsif qty_precision = 6 then return('999G999G999G990D000000');
20
21 else return('999G999G999G990D00');
22
23 end if;
24
25 end;
26
27 end po_common_xmlp_pkg;
28