1 PACKAGE pay_mx_currency_conversion AS
2 /* $Header: paymxcurrconv.pkh 120.0 2005/09/29 13:59:13 vmehta noship $ */
3 --
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1996 Oracle Corporation. *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation, *
17 * 500 Oracle Parkway, Redwood City, CA, 94065. *
18 * *
19 ******************************************************************
20
21 Name : pay_mx_currency_conversion
22
23 Description : Package to change currency code for Mexico
24 ( MXP to MXN )
25
26 Change List
27 -----------
28 Date Name Vers Bug No Description
29 ---- ---- ------ ------- -----------
30 19-Aug-2005 vpandya 115.0 Created
31
32 */
33
34 PROCEDURE currency_mxp_to_mxn
35 (errbuf OUT NOCOPY VARCHAR2
36 ,retcode OUT NOCOPY NUMBER
37 ,p_business_group_id IN NUMBER
38 ,p_conv_curr_code IN VARCHAR2
39 );
40
41 FUNCTION get_converted_curr_code ( p_business_group_id NUMBER )
42 RETURN VARCHAR2;
43
44 end pay_mx_currency_conversion;