DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on AP_INVOICE_LINES

Line 2019: FROM ap_invoice_lines_all ail, ap_invoices_all ai

2015: WHERE invoice_id = p_invoice_id
2016: AND match_status_flag IN ('T','A'))
2017: UNION -- Bug 6866672
2018: SELECT 'N'
2019: FROM ap_invoice_lines_all ail, ap_invoices_all ai
2020: WHERE ai.invoice_id = p_invoice_id
2021: AND ai.invoice_id = ail.invoice_id
2022: AND ai.cancelled_date is NULL
2023: AND NOT EXISTS

Line 2190: FROM ap_invoice_lines_all AIL

2186: l_net_inv_amount NUMBER := 0;
2187: BEGIN
2188: SELECT nvl((0 - sum(AIL.amount)),0)
2189: INTO l_prepay_amount
2190: FROM ap_invoice_lines_all AIL
2191: WHERE AIL.invoice_id = p_invoice_id
2192: AND nvl(AIL.invoice_includes_prepay_flag,'N') = 'N'
2193: AND (AIL.line_type_lookup_code = 'PREPAY'
2194: OR (AIL.line_type_lookup_code = 'TAX'

Line 2609: delete from ap_invoice_lines_interface where invoice_id = p_invoice_id_table(i);

2605: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2606: delete from ap_invoices_interface where invoice_id = p_invoice_id_table(i);
2607: /* Delete invoice lines from interface */
2608: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2609: delete from ap_invoice_lines_interface where invoice_id = p_invoice_id_table(i);
2610:
2611: /* Delete invoice rejections from the rejections table */
2612: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2613: delete from ap_interface_rejections

Line 2621: parent_table = 'AP_INVOICE_LINES_INTERFACE';

2617: /* Delete invoice lines rejections from the rejections table */
2618: forall i in nvl(p_invoice_line_id_table.first,0)..nvl(p_invoice_line_id_table.last,0)
2619: delete from ap_interface_rejections
2620: where parent_id = p_invoice_line_id_table(i) and
2621: parent_table = 'AP_INVOICE_LINES_INTERFACE';
2622: return TRUE;
2623: EXCEPTION
2624: WHEN OTHERS THEN
2625: if (SQLCODE <> -20001) then

Line 2856: p_default_dist_ccid IN AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE --bug 5386396

2852: p_pa_concatenated_segments OUT NOCOPY VARCHAR2,
2853: p_debug_Info OUT NOCOPY VARCHAR2,
2854: p_debug_Context OUT NOCOPY VARCHAR2,
2855: p_calling_sequence IN VARCHAR2,
2856: p_default_dist_ccid IN AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE --bug 5386396
2857: ) RETURN BOOLEAN
2858: IS
2859: procedure_billable_flag VARCHAR2(60) := '';
2860: l_concat_ids VARCHAR2(2000); --bug9064023

Line 2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;

2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;

Line 2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;

2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;

Line 2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;

2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;

Line 2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;

2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;

Line 2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;

2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;

Line 2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;

2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;

Line 2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;

2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;

Line 2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;

2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;

Line 2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;

2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;

Line 2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;

2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;

Line 2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;

2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;

Line 2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;

2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2904:

Line 2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;

2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2904:
2905: BEGIN

Line 2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;

2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2904:
2905: BEGIN
2906:

Line 2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;

2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2904:
2905: BEGIN
2906:
2907: -- Update the calling sequence