2011: WHERE invoice_id = p_invoice_id
2012: AND match_status_flag IN ('T','A'))
2013: UNION -- Bug 6866672
2014: SELECT 'N'
2015: FROM ap_invoice_lines_all ail, ap_invoices_all ai
2016: WHERE ai.invoice_id = p_invoice_id
2017: AND ai.invoice_id = ail.invoice_id
2018: AND ai.cancelled_date is NULL
2019: AND NOT EXISTS
2182: l_net_inv_amount NUMBER := 0;
2183: BEGIN
2184: SELECT nvl((0 - sum(AIL.amount)),0)
2185: INTO l_prepay_amount
2186: FROM ap_invoice_lines_all AIL
2187: WHERE AIL.invoice_id = p_invoice_id
2188: AND nvl(AIL.invoice_includes_prepay_flag,'N') = 'N'
2189: AND (AIL.line_type_lookup_code = 'PREPAY'
2190: OR (AIL.line_type_lookup_code = 'TAX'
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2892: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2892: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2893: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2892: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2893: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2894: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2892: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2893: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2894: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2895:
2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2892: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2893: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2894: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2895:
2896: BEGIN
2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2892: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2893: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2894: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2895:
2896: BEGIN
2897:
2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2892: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2893: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2894: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2895:
2896: BEGIN
2897:
2898: -- Update the calling sequence