306: and hold_flag = 'Y';
307:
308: select count(*)
309: into X_Line_count
310: from ap_invoice_lines
311: where invoice_id = X_invoice_id;
312:
313: select sum(amount)
314: into X_Line_total
311: where invoice_id = X_invoice_id;
312:
313: select sum(amount)
314: into X_Line_total
315: from ap_invoice_lines
316: where invoice_id = X_invoice_id;
317:
318: EXCEPTION
319: WHEN OTHERS THEN