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;
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;
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;
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;
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:
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;
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;
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: ---------------------------------------------------------------------------------------------------