PACKAGE BODY: APPS.BOM_COMMON_XMLP_PKG

Source

1 package body BOM_COMMON_XMLP_PKG As
2 /* $Header: BOMCOMMONB.pls 120.0 2007/12/24 09:04:31 dwkrishn noship $ */
3   -- Private type declarations
4   -- Function and procedure implementations
5 function get_precision(qty_precision in number) return VARCHAR2 is
6 begin
7 
8 if qty_precision = 0 then return('999G999G999G990');
9 
10 elsif qty_precision = 1 then return('999G999G999G990D0');
11 
12 elsif qty_precision = 3 then return('999G999G999G990D000');
13 
14 elsif qty_precision = 4 then return('999G999G999G990D0000');
15 
16 elsif qty_precision = 5 then return('999G999G999G990D00000');
17 
18 elsif qty_precision = 6 then  return('999G999G999G990D000000');
19 
20 else return('999G999G999G990D00');
21 
22 end if;
23 
24 end;
25 
26 end bom_common_xmlp_pkg;