APPS.CN_GET_TX_DATA_PUB dependencies on CN_GLOBAL_VAR

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

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

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

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

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

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

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

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

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

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