APPS.CN_GET_TX_DATA_PUB dependencies on CN_MASS_ADJUST_UTIL

Line 483: cn_mass_adjust_util.search_result(

479: x_loading_status := 'CN_INSERTED';
480: -- API body
481: /* This API take the parameters and construct the SQL. Based on the SQL
482: get the data from cn_comm_lines_api and cn_commission_headers tables. */
483: cn_mass_adjust_util.search_result(
484: p_salesrep_id => p_salesrep_id,
485: p_pr_date_to => p_pr_date_to,
486: p_pr_date_from => p_pr_date_from,
487: p_calc_status => p_calc_status,

Line 1402: cn_mass_adjust_util.find_functional_amount(

1398: := (l_newtx_rec.transaction_amount_orig)*
1399: (l_newtx_rec.exchange_rate);
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,

Line 1432: cn_mass_adjust_util.find_functional_amount(

1428: := l_newtx_rec.transaction_amount;
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,

Line 1581: cn_mass_adjust_util.search_result(

1577:
1578:
1579: /* This API take the parameters and construct the SQL. Based on the SQL
1580: get the data from cn_comm_lines_api and cn_commission_headers tables. */
1581: cn_mass_adjust_util.search_result(
1582: p_salesrep_id => p_salesrep_id,
1583: p_pr_date_to => p_pr_date_to,
1584: p_pr_date_from => p_pr_date_from,
1585: p_calc_status => p_calc_status,

Line 1600: cn_mass_adjust_util.convert_rec_to_gmiss(

1596:
1597: --CN_mydebug.ADD('Counter value after Search Result : '||l_source_counter);
1598: --CN_mydebug.ADD('Adjusted table length : '||l_adj_tbl.count);
1599:
1600: cn_mass_adjust_util.convert_rec_to_gmiss(
1601: p_rec => p_adj_rec,
1602: x_api_rec => l_adj_rec);
1603:
1604: l_adj_rec.adjusted_by := get_adjusted_by;

Line 3140: -- cn_mass_adjust_util.convert_rec_to_gmiss(

3136: );*/
3137:
3138:
3139: -- vensrini Nov 14, 2005
3140: -- cn_mass_adjust_util.convert_rec_to_gmiss(
3141: -- p_rec => p_newtx_rec,
3142: -- x_api_rec => l_newtx_rec);
3143: -- vensrini Nov 14, 2005
3144: