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 813: FROM FND_CURRENCIES

809: derive_type,
810: derive_effective,
811: minimum_accountable_unit,
812: precision
813: FROM FND_CURRENCIES
814: WHERE currency_code = c_currency;
815:
816: BEGIN
817:

Line 828: -- Get currency information from FND_CURRENCIES table

824: END IF;
825:
826: p_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: -- Get currency information from FND_CURRENCIES table
829: --Commented for Bug 7519288
830: /* SELECT decode( derive_type,
831: 'EURO', 'EURO',
832: 'EMU', decode( sign( trunc(p_eff_date) -

Line 850: FROM FND_CURRENCIES

846: p_derive_type,
847: p_derive_effective,
848: p_mau,
849: p_precision
850: FROM FND_CURRENCIES
851: WHERE currency_code = p_currency;*/
852:
853: Open getCurrencyInfo(p_currency);
854: Fetch getCurrencyInfo

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

888:
889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN
891: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: p_error_buffer := 'Currency type and Currency rate not found in FND_CURRENCIES';
893: IF (g_level_unexpected >= g_current_runtime_level ) THEN
894: FND_LOG.STRING(g_level_unexpected,
895: 'ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_currency_info',
896: p_error_buffer);

Line 1161: FROM FND_CURRENCIES

1157:
1158: -- Get currency code of the EURO currency
1159: SELECT currency_code
1160: INTO euro_code
1161: FROM FND_CURRENCIES
1162: WHERE derive_type = 'EURO';
1163:
1164:
1165: IF (g_level_statement >= g_current_runtime_level ) THEN

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

1173:
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: p_error_buffer := 'EURO code not found in FND_CURRENCIES';
1178: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1179: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1180: ZX_API_PUB.add_msg(
1181: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

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

3197: -- round_tax_funcl_curr
3198: --
3199: -- DESCRIPTION
3200: -- This function gets the minimum accountable unit and precision of
3201: -- a functional currency from fnd_currencies based on the ledger id,
3202: -- then rounds the tax amount in functional currency using ROUND function
3203:
3204: FUNCTION round_tax_funcl_curr(
3205: p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,

Line 3212: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

3208: p_error_buffer OUT NOCOPY VARCHAR2
3209: ) RETURN NUMBER
3210: IS
3211: l_round_amt ZX_LINES.TAX_AMT_TAX_CURR%TYPE;
3212: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3213: l_precision FND_CURRENCIES.PRECISION%TYPE;
3214: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3215:
3216: BEGIN

Line 3213: l_precision FND_CURRENCIES.PRECISION%TYPE;

3209: ) RETURN NUMBER
3210: IS
3211: l_round_amt ZX_LINES.TAX_AMT_TAX_CURR%TYPE;
3212: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3213: l_precision FND_CURRENCIES.PRECISION%TYPE;
3214: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3215:
3216: BEGIN
3217:

Line 3214: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

3210: IS
3211: l_round_amt ZX_LINES.TAX_AMT_TAX_CURR%TYPE;
3212: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3213: l_precision FND_CURRENCIES.PRECISION%TYPE;
3214: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
3215:
3216: BEGIN
3217:
3218: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3408: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

3404: p_error_buffer OUT NOCOPY VARCHAR2
3405: )
3406: IS
3407: l_amt_funcl_curr NUMBER;
3408: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3409: l_precision FND_CURRENCIES.PRECISION%TYPE;
3410:
3411: BEGIN
3412: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3409: l_precision FND_CURRENCIES.PRECISION%TYPE;

3405: )
3406: IS
3407: l_amt_funcl_curr NUMBER;
3408: l_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
3409: l_precision FND_CURRENCIES.PRECISION%TYPE;
3410:
3411: BEGIN
3412: IF (g_level_statement >= g_current_runtime_level ) THEN
3413: FND_LOG.STRING(g_level_statement,

Line 4725: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

4721: l_prd_total_tax_amt ZX_LINES.prd_total_tax_amt%TYPE;
4722: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4723: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4724: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4725: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4726: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4727: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4728:
4729: BEGIN

Line 4726: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;

4722: l_currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE;
4723: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4724: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4725: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4726: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4727: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4728:
4729: BEGIN
4730:

Line 4727: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

4723: l_tax_currency_conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE; --bug#6526550
4724: l_trx_currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE; --Bug7183884
4725: l_funcl_min_acct_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4726: l_funcl_precision FND_CURRENCIES.PRECISION%TYPE;
4727: l_funcl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
4728:
4729: BEGIN
4730:
4731: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 7578: FROM FND_CURRENCIES

7574: (c_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE)
7575: IS
7576: SELECT minimum_accountable_unit,
7577: precision
7578: FROM FND_CURRENCIES
7579: WHERE currency_code = c_trx_currency_code;
7580:
7581:
7582: BEGIN

Line 8325: -- fnd_currencies based on the ledger id

8321: --
8322: -- DESCRIPTION
8323: -- This procedure gets the functional currency code, minimum
8324: -- accountable unit and precision of a functional currency from
8325: -- fnd_currencies based on the ledger id
8326:
8327: PROCEDURE get_funcl_curr_info(
8328: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8329: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,

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

8325: -- fnd_currencies based on the ledger id
8326:
8327: PROCEDURE get_funcl_curr_info(
8328: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8329: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
8330: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8331: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
8332:
8333: p_return_status OUT NOCOPY VARCHAR2,

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

8326:
8327: PROCEDURE get_funcl_curr_info(
8328: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8329: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
8330: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8331: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
8332:
8333: p_return_status OUT NOCOPY VARCHAR2,
8334: p_error_buffer OUT NOCOPY VARCHAR2

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

8327: PROCEDURE get_funcl_curr_info(
8328: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
8329: p_funcl_currency_code OUT NOCOPY FND_CURRENCIES.CURRENCY_CODE%TYPE,
8330: p_funcl_min_acct_unit OUT NOCOPY FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8331: p_funcl_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE,
8332:
8333: p_return_status OUT NOCOPY VARCHAR2,
8334: p_error_buffer OUT NOCOPY VARCHAR2
8335: )