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 1401: cn_mass_adjust_util.find_functional_amount(

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

Line 1431: cn_mass_adjust_util.find_functional_amount(

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

Line 1580: cn_mass_adjust_util.search_result(

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

Line 1599: cn_mass_adjust_util.convert_rec_to_gmiss(

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

Line 3114: -- cn_mass_adjust_util.convert_rec_to_gmiss(

3110: );*/
3111:
3112:
3113: -- vensrini Nov 14, 2005
3114: -- cn_mass_adjust_util.convert_rec_to_gmiss(
3115: -- p_rec => p_newtx_rec,
3116: -- x_api_rec => l_newtx_rec);
3117: -- vensrini Nov 14, 2005
3118: