1 PACKAGE AP_WEB_DB_COUNTRY_PKG AS
2 /* $Header: apwdbcts.pls 120.5 2005/10/02 20:11:45 albowicz ship $ */
3
4 ---------------------------------------------------------------------------------------------------
5 SUBTYPE curr_name IS FND_CURRENCIES_VL.name%TYPE;
6 SUBTYPE curr_currCode IS FND_CURRENCIES_VL.currency_code%TYPE;
7 SUBTYPE curr_currFlag IS FND_CURRENCIES_VL.currency_flag%TYPE;
8 SUBTYPE curr_precision IS FND_CURRENCIES_VL.precision%TYPE;
9 SUBTYPE curr_minAcctUnit IS FND_CURRENCIES_VL.minimum_accountable_unit%TYPE;
10 SUBTYPE curr_deriveEffective IS FND_CURRENCIES_VL.derive_effective%TYPE;
11 SUBTYPE curr_deriveType IS FND_CURRENCIES_VL.derive_type%TYPE;
12 SUBTYPE curr_deriveFactor IS FND_CURRENCIES_VL.derive_factor%TYPE;
13
14 SUBTYPE terr_shortName IS FND_TERRITORIES_VL.territory_short_name%TYPE;
15 SUBTYPE terr_code IS FND_TERRITORIES_VL.territory_code%TYPE;
16 ---------------------------------------------------------------------------------------------------
17
18
19 TYPE CurrencyCodeCursor IS REF CURSOR;
20 TYPE CountryListCursor IS REF CURSOR;
21 TYPE CurrencyInfoCursor IS REF CURSOR;
22 TYPE CurrencyPrecisionCursor IS REF CURSOR;
23
24 TYPE country IS RECORD (
25 code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE,
26 name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE);
27
28 TYPE countries IS TABLE OF country
29 INDEX BY BINARY_INTEGER;
30
31 --------------------------------------------------------------------------------
32 FUNCTION GetCountryListCursor(
33 p_country_list_cursor OUT NOCOPY CountryListCursor
34 ) RETURN BOOLEAN;
35
36 --------------------------------------------------------------------------------
37 FUNCTION GetCurrencyPrecision(
38 p_reimb_curr_code IN curr_currCode
39 ) RETURN curr_precision;
40
41 -------------------------------------------------------------------
42 FUNCTION GetCurrencyInfoCursor(
43 p_currency_info_cursor OUT NOCOPY CurrencyInfoCursor
44 ) RETURN BOOLEAN;
45
46 -------------------------------------------------------------------
47 FUNCTION GetCurrCodeProperties(
48 p_curr_code IN curr_currCode,
49 p_curr_name OUT NOCOPY curr_name,
50 p_precision OUT NOCOPY curr_precision,
51 p_minimum_acct_unit OUT NOCOPY curr_minAcctUnit
52 ) RETURN BOOLEAN;
53
54 -------------------------------------------------------------------
55 FUNCTION GetCurrencyProperties(
56 p_curr_code IN curr_currCode,
57 p_curr_name OUT NOCOPY curr_name,
58 p_precision OUT NOCOPY curr_precision,
59 p_minimum_acct_unit OUT NOCOPY curr_minAcctUnit
60 ) RETURN BOOLEAN;
61
62 --------------------------------------------------------------------------------
63 FUNCTION GetCurrCodeCursor(
64 p_curr_code_cursor OUT NOCOPY CurrencyCodeCursor
65 ) RETURN BOOLEAN;
66
67 END AP_WEB_DB_COUNTRY_PKG;