eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on FND_CURRENCIES

Line 74: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,

70: RETURN BINARY_INTEGER ;
71:
72: PROCEDURE get_funcl_curr_info(
73: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
74: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
75: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
76: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
77:
78: p_return_status OUT NOCOPY VARCHAR2,

Line 75: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

71:
72: PROCEDURE get_funcl_curr_info(
73: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
74: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
75: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
76: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
77:
78: p_return_status OUT NOCOPY VARCHAR2,
79: p_error_buffer OUT NOCOPY VARCHAR2);

Line 76: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,

72: PROCEDURE get_funcl_curr_info(
73: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
74: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
75: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
76: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
77:
78: p_return_status OUT NOCOPY VARCHAR2,
79: p_error_buffer OUT NOCOPY VARCHAR2);
80:

Line 821: FROM FND_CURRENCIES

817: derive_type,
818: derive_effective,
819: minimum_accountable_unit,
820: precision
821: FROM FND_CURRENCIES
822: WHERE currency_code = c_currency;
823:
824: BEGIN
825:

Line 836: -- Get currency information from FND_CURRENCIES table

832: END IF;
833:
834: p_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: -- Get currency information from FND_CURRENCIES table
837: --Commented for Bug 7519288
838: /* SELECT decode( derive_type,
839: 'EURO', 'EURO',
840: 'EMU', decode( sign( trunc(p_eff_date) -

Line 858: FROM FND_CURRENCIES

854: p_derive_type,
855: p_derive_effective,
856: p_mau,
857: p_precision
858: FROM FND_CURRENCIES
859: WHERE currency_code = p_currency;*/
860:
861: Open getCurrencyInfo(p_currency);
862: Fetch getCurrencyInfo

Line 900: p_error_buffer := 'Currency type and Currency rate not found in FND_CURRENCIES';

896:
897: EXCEPTION
898: WHEN NO_DATA_FOUND THEN
899: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: p_error_buffer := 'Currency type and Currency rate not found in FND_CURRENCIES';
901: IF (g_level_unexpected >= g_current_runtime_level ) THEN
902: FND_LOG.STRING(g_level_unexpected,
903: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_currency_info',
904: p_error_buffer);

Line 1169: FROM FND_CURRENCIES

1165:
1166: -- Get currency code of the EURO currency
1167: SELECT currency_code
1168: INTO euro_code
1169: FROM FND_CURRENCIES
1170: WHERE derive_type = 'EURO';
1171:
1172:
1173: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1185: p_error_buffer := 'EURO code not found in FND_CURRENCIES';

1181:
1182: EXCEPTION
1183: WHEN NO_DATA_FOUND THEN
1184: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185: p_error_buffer := 'EURO code not found in FND_CURRENCIES';
1186: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1187: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1188: ZX_API_PUB.add_msg(
1189: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 3209: -- a functional currency from fnd_currencies based on the ledger id,

3205: -- round_tax_funcl_curr
3206: --
3207: -- DESCRIPTION
3208: -- This function gets the minimum accountable unit and precision of
3209: -- a functional currency from fnd_currencies based on the ledger id,
3210: -- then rounds the tax amount in functional currency using ROUND function
3211:
3212: FUNCTION round_tax_funcl_curr(
3213: p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,

Line 3220: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

3216: p_error_buffer OUT NOCOPY VARCHAR2
3217: ) RETURN NUMBER
3218: IS
3219: l_round_amt ZX_LINES.TAX_AMT_TAX_CURR%TYPE;
3220: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3221: l_precision FND_CURRENCIES.PRECISION%TYPE;
3222: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3223:
3224: BEGIN

Line 3221: l_precision FND_CURRENCIES.PRECISION%TYPE;

3217: ) RETURN NUMBER
3218: IS
3219: l_round_amt ZX_LINES.TAX_AMT_TAX_CURR%TYPE;
3220: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3221: l_precision FND_CURRENCIES.PRECISION%TYPE;
3222: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3223:
3224: BEGIN
3225:

Line 3222: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

3218: IS
3219: l_round_amt ZX_LINES.TAX_AMT_TAX_CURR%TYPE;
3220: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3221: l_precision FND_CURRENCIES.PRECISION%TYPE;
3222: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3223:
3224: BEGIN
3225:
3226: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3416: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

3412: p_error_buffer OUT NOCOPY VARCHAR2
3413: )
3414: IS
3415: l_amt_funcl_curr NUMBER;
3416: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3417: l_precision FND_CURRENCIES.PRECISION%TYPE;
3418:
3419: BEGIN
3420: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3417: l_precision FND_CURRENCIES.PRECISION%TYPE;

3413: )
3414: IS
3415: l_amt_funcl_curr NUMBER;
3416: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3417: l_precision FND_CURRENCIES.PRECISION%TYPE;
3418:
3419: BEGIN
3420: IF (g_level_statement >= g_current_runtime_level ) THEN
3421: FND_LOG.STRING(g_level_statement,

Line 4798: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

4794: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4797: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4798: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4799: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4800: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4801:
4802: BEGIN

Line 4799: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;

4795: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4797: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4798: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4799: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4800: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4801:
4802: BEGIN
4803:

Line 4800: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

4796: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4797: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4798: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4799: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4800: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4801:
4802: BEGIN
4803:
4804: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 7837: FROM FND_CURRENCIES

7833: (c_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE)
7834: IS
7835: SELECT minimum_accountable_unit,
7836: precision
7837: FROM FND_CURRENCIES
7838: WHERE currency_code = c_trx_currency_code;
7839:
7840:
7841: BEGIN

Line 8592: -- fnd_currencies based on the ledger id

8588: --
8589: -- DESCRIPTION
8590: -- This procedure gets the functional currency code, minimum
8591: -- accountable unit and precision of a functional currency from
8592: -- fnd_currencies based on the ledger id
8593:
8594: PROCEDURE get_funcl_curr_info(
8595: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8596: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,

Line 8596: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,

8592: -- fnd_currencies based on the ledger id
8593:
8594: PROCEDURE get_funcl_curr_info(
8595: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8596: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
8597: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8598: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
8599:
8600: p_return_status OUT NOCOPY VARCHAR2,

Line 8597: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,

8593:
8594: PROCEDURE get_funcl_curr_info(
8595: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8596: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
8597: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8598: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
8599:
8600: p_return_status OUT NOCOPY VARCHAR2,
8601: p_error_buffer OUT NOCOPY VARCHAR2

Line 8598: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,

8594: PROCEDURE get_funcl_curr_info(
8595: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8596: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
8597: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8598: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
8599:
8600: p_return_status OUT NOCOPY VARCHAR2,
8601: p_error_buffer OUT NOCOPY VARCHAR2
8602: )