1 package pay_ca_amt_in_words AUTHID CURRENT_USER as
2 /* $Header: pycaamtw.pkh 115.3 2003/06/03 08:14:26 sfmorris noship $*/
3 /*
4
5 ******************************************************************
6 * *
7 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
8 * Chertsey, England. *
9 * *
10 * All rights reserved. *
11 * *
12 * This material has been provided pursuant to an agreement *
13 * containing restrictions on its use. The material is also *
14 * protected by copyright law. No part of this material may *
15 * be copied or distributed, transmitted or transcribed, in *
16 * any form or by any means, electronic, mechanical, magnetic, *
17 * manual, or otherwise, or disclosed to third parties without *
18 * the express written permission of Oracle Corporation UK Ltd, *
19 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
20 * England. *
21 * *
22 ******************************************************************
23
24 Name : pay_ca_amt_in_words
25
26 Description : Package for converting amount in words.
27
28 Change List
29 -----------
30 Date Name Vers Bug No Description
31 ----------- ---------- ----- ------- -----------------------------------
32 04-Jan-2002 vpandya 115.0 Created
33 03-Jun-2003 sfmorris 115.3 2888822 Added parameters p_denomination and
34 p_sub_denomination to support
35 output in Euros for French
36 Localisation
37 --
38 */
39
40 FUNCTION pay_amount_in_words(in_numeral IN NUMBER,
41 p_language IN VARCHAR2,
42 p_denomination IN VARCHAR2 default 'DOLLARS',
43 p_sub_denomination IN VARCHAR2 default 'CENTS') RETURN VARCHAR2;
44 end pay_ca_amt_in_words;