DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on CN_GLOBAL_VAR

Line 1379: l_newtx_rec.orig_currency_code := cn_global_var.get_currency_code(p_newtx_rec.org_id);

1375: column and functional amount is stored in
1376: adj_rec_type.transaction_amount
1377: -----------------------------------------------------------------*/
1378: IF (l_newtx_rec.orig_currency_code IS NULL) THEN
1379: l_newtx_rec.orig_currency_code := cn_global_var.get_currency_code(p_newtx_rec.org_id);
1380: l_newtx_rec.exchange_rate := 1;
1381: IF (l_newtx_rec.transaction_amount_orig IS NOT NULL) THEN
1382: l_newtx_rec.transaction_amount := l_newtx_rec.transaction_amount_orig;
1383: ELSE

Line 1390: IF ((l_newtx_rec.orig_currency_code = cn_global_var.get_currency_code(p_newtx_rec.org_id)) OR

1386: END IF;
1387: ELSE
1388: -- Foreign Amount to Functional Amount
1389: IF (l_newtx_rec.transaction_amount_orig IS NOT NULL) THEN
1390: IF ((l_newtx_rec.orig_currency_code = cn_global_var.get_currency_code(p_newtx_rec.org_id)) OR
1391: (l_newtx_rec.orig_currency_code = 'FUNC_CURR')) THEN
1392: l_newtx_rec.transaction_amount
1393: := l_newtx_rec.transaction_amount_orig;
1394: l_newtx_rec.exchange_rate := 1;

Line 1404: p_to_currency => cn_global_var.get_currency_code(p_newtx_rec.org_id),

1400: ELSE
1401:
1402: cn_mass_adjust_util.find_functional_amount(
1403: p_from_currency => l_newtx_rec.orig_currency_code,
1404: p_to_currency => cn_global_var.get_currency_code(p_newtx_rec.org_id),
1405: p_conversion_date => l_newtx_rec.processed_date,
1406: p_from_amount => l_newtx_rec.transaction_amount_orig,
1407: x_to_amount => l_newtx_rec.transaction_amount,
1408: x_return_status => l_return_status,

Line 1425: IF ((l_newtx_rec.orig_currency_code = cn_global_var.get_currency_code(p_newtx_rec.org_id)) OR

1421: END IF;
1422: END IF;
1423: ELSE
1424: -- Functional Amount to Foreign Amount
1425: IF ((l_newtx_rec.orig_currency_code = cn_global_var.get_currency_code(p_newtx_rec.org_id)) OR
1426: (l_newtx_rec.orig_currency_code = 'FUNC_CURR')) THEN
1427: l_newtx_rec.transaction_amount_orig
1428: := l_newtx_rec.transaction_amount;
1429: l_newtx_rec.exchange_rate := 1;

Line 1433: p_from_currency => cn_global_var.get_currency_code(p_newtx_rec.org_id),

1429: l_newtx_rec.exchange_rate := 1;
1430: ELSE
1431: -- In this case some times exchange rate will remain NULL only.
1432: cn_mass_adjust_util.find_functional_amount(
1433: p_from_currency => cn_global_var.get_currency_code(p_newtx_rec.org_id),
1434: p_to_currency => l_newtx_rec.orig_currency_code,
1435: p_conversion_date => l_newtx_rec.processed_date,
1436: p_from_amount => l_newtx_rec.transaction_amount,
1437: x_to_amount => l_newtx_rec.transaction_amount_orig,