1 PACKAGE BODY PO_MGD_EURO_UTILS AS
2 -- $Header: POXUEURB.pls 115.7 2002/03/29 11:46:31 pkm ship $
3 /*+=======================================================================+
4 --| Copyright (c) 1999 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| POXUEURB.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Utility Package Body |
13 --| |
14 --| HISTORY |
15 --| 30-Dec-1999 rajkrish Updated |
16 --| 05-Jan-2000 tsimmond Updated |
17 --| 24-Jan-2000 tsimmond Updated |
18 --| 11/28/2001 tsimmond updated, added dbrv and set verify off |
19 --| 03/25/2002 tsimmond updated, code removed for patch 'H' remove |
20 --+======================================================================*/
21
22
23 --========================================================================
24 -- FUNCTION : EURO_Conversion_Api PUBLIC
25 -- PARAMETERS: p_from_currency
26 --- p_to_currency
27 --- p_conversion_type
28 --- p_conversion_date
29 --- p_amount
30 --
31 -- COMMENT : This procedure is used for the EURO conversion of amounts
32 -- The GL_API is invoked for the purpose
33 --
34 --========================================================================
35 FUNCTION EURO_Conversion_api
36 ( p_from_currency IN VARCHAR2
37 , p_to_currency IN VARCHAR2
38 , p_conversion_type IN VARCHAR2
39 , p_conversion_date IN DATE
40 , p_amount IN NUMBER := NULL
41 )
42 RETURN NUMBER
43 IS
44 BEGIN
45
46 RETURN(0);
47
48 END EURO_Conversion_api;
49
50
51
52 --========================================================================
53 -- FUNCTION : Encumbrance_Check PUBLIC
54 -- PARAMETERS: p_org_id
55 --
56 -- COMMENTS: This function is checking if Encumbrance Flag is ON.
57 -- It returns Y, if Encumbrance is ON and N if it's OFF
58 --
59 --========================================================================
60 FUNCTION Encumbrance_check
61 ( p_org_id IN NUMBER
62 )
63 RETURN VARCHAR2
64 IS
65 BEGIN
66
67 RETURN('Y');
68
69 END Encumbrance_check;
70
71
72 END PO_MGD_EURO_UTILS;