13: BEGIN
14:
15: SELECT COUNT(*)
16: INTO invoice_count
17: --bug 7606664 changed ap_invoices to ap_invoices_all
18: FROM ap_invoices_all
19: WHERE batch_id = l_batch_id;
20:
21: RETURN(invoice_count);
14:
15: SELECT COUNT(*)
16: INTO invoice_count
17: --bug 7606664 changed ap_invoices to ap_invoices_all
18: FROM ap_invoices_all
19: WHERE batch_id = l_batch_id;
20:
21: RETURN(invoice_count);
22:
34: BEGIN
35:
36: SELECT SUM(nvl(invoice_amount,0))
37: INTO invoice_amount
38: --bug 7606664 changed ap_invoices to ap_invoices_all
39: FROM ap_invoices_all
40: WHERE batch_id = l_batch_id;
41:
42: RETURN(invoice_amount);
35:
36: SELECT SUM(nvl(invoice_amount,0))
37: INTO invoice_amount
38: --bug 7606664 changed ap_invoices to ap_invoices_all
39: FROM ap_invoices_all
40: WHERE batch_id = l_batch_id;
41:
42: RETURN(invoice_amount);
43: