1 PACKAGE PO_MGD_EURO_UTILS AUTHID CURRENT_USER AS
2 -- $Header: POXUEURS.pls 115.5 2002/02/18 17:48:07 pkm ship $
3 /*+=======================================================================+
4 --| Copyright (c) 1999 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| POXUEURS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Utility Package |
13 --| |
14 --| HISTORY |
15 --| 30-Dec-1999 rajkrish Updated |
16 --| 05-Jan-2000 tsimmond Updated |
17 --| 11/28/2001 tsimmond updated, added dbrv and set verify off |
18 --+======================================================================*/
19
20
21
22 G_PO_NUMBER NUMBER;
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
44
45
46 --========================================================================
47 -- FUNCTION : Encumbrance_Check PUBLIC
48 -- PARAMETERS: p_org_id
49 --
50 -- COMMENTS: This function is checking if Encumbrance Flag is ON.
51 -- It returns Y, if Encumbrance is ON and N if it's OFF
52 --
53 --========================================================================
54 FUNCTION Encumbrance_check
55 ( p_org_id IN NUMBER
56 )
57 RETURN VARCHAR2;
58
59
60 END PO_MGD_EURO_UTILS;