APPS.AP_WEB_EXPORT_ER dependencies on AP_EXP_REPORT_DISTS

Line 821: FROM ap_exp_report_dists_all

817: END IF;
818:
819: SELECT count(*)
820: INTO l_dist_count
821: FROM ap_exp_report_dists_all
822: WHERE report_header_id = p_report_header_id
823: AND amount IS NULL;
824:
825: IF g_debug_switch = 'Y' THEN

Line 847: select nvl(sum(amount),0) into l_dist_total from ap_exp_report_dists_all where report_header_id = p_report_header_id

843: and (itemization_parent_id is null or itemization_parent_id <> -1)
844: and web_parameter_id <> l_parameter_id;
845:
846: l_debug_info := 'Fetching Dist Total';
847: select nvl(sum(amount),0) into l_dist_total from ap_exp_report_dists_all where report_header_id = p_report_header_id
848: and (web_parameter_id is null or web_parameter_id <> l_parameter_id);
849:
850: l_debug_info := 'Header Total: ' || l_header_total || ', Line Total: ' || l_line_total || ', Dist Total: ' || l_dist_total;
851: IF g_debug_switch = 'Y' THEN

Line 1252: ap_exp_report_dists xd

1248: xl.receipt_conversion_rate,
1249: xl.receipt_currency_amount,xd.amount ,
1250: xd.report_distribution_id
1251: FROM ap_expense_report_lines xl,
1252: ap_exp_report_dists xd
1253: WHERE xd.report_line_id = xl.report_line_id
1254: and xl.report_header_id = l_report_header_id
1255: and xd.report_header_id = l_report_header_id
1256: and xd.receipt_currency_amount is null

Line 1293: update ap_exp_report_dists set

1289: IF (l_prev_line_id <> 0 AND l_prev_line_id <> l_report_line_id) THEN
1290: IF ( l_prev_ln_receipt_curr_amt - l_total_dist_rec_curr_amt <> 0 ) THEN
1291: l_dist_rec_curr_amt := l_dist_rec_curr_amt + (l_prev_ln_receipt_curr_amt - l_total_dist_rec_curr_amt);
1292: -- Bug: 8408909, Donot update currency code and rate on line change
1293: update ap_exp_report_dists set
1294: receipt_currency_amount = l_dist_rec_curr_amt
1295: where report_distribution_id = l_prev_dist_id;
1296: END IF;
1297: l_total_dist_rec_curr_amt := 0;

Line 1311: update ap_exp_report_dists set

1307: l_dist_rec_curr_amt := ap_utilities_pkg.ap_round_currency(l_dist_rec_curr_amt,l_receipt_currency_code);
1308: l_total_dist_rec_curr_amt := l_total_dist_rec_curr_amt + l_dist_rec_curr_amt;
1309: l_prev_dist_id := l_report_distribution_id;
1310:
1311: update ap_exp_report_dists set
1312: receipt_currency_amount = l_dist_rec_curr_amt,
1313: receipt_currency_code = l_receipt_currency_code,
1314: receipt_conversion_rate = l_receipt_conversion_rate
1315: where report_distribution_id = l_report_distribution_id;

Line 1326: update ap_exp_report_dists set

1322: -------------------------------------------------------------------
1323: IF ( l_ln_receipt_curr_amt - l_total_dist_rec_curr_amt <> 0 ) THEN
1324: l_dist_rec_curr_amt := l_dist_rec_curr_amt + (l_ln_receipt_curr_amt - l_total_dist_rec_curr_amt);
1325: -- Bug: 8408909
1326: update ap_exp_report_dists set
1327: receipt_currency_amount = l_dist_rec_curr_amt
1328: where report_distribution_id = l_prev_dist_id;
1329: END IF;
1330: