eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_UTILITIES_PKG dependencies on AP_INVOICE_LINES

Line 2015: FROM ap_invoice_lines_all ail, ap_invoices_all ai

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

Line 2186: FROM ap_invoice_lines_all AIL

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'

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

2600: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2601: delete from ap_invoices_interface where invoice_id = p_invoice_id_table(i);
2602: /* Delete invoice lines from interface */
2603: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2604: delete from ap_invoice_lines_interface where invoice_id = p_invoice_id_table(i);
2605:
2606: /* Delete invoice rejections from the rejections table */
2607: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2608: delete from ap_interface_rejections

Line 2616: parent_table = 'AP_INVOICE_LINES_INTERFACE';

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

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

2845: p_pa_concatenated_segments OUT NOCOPY VARCHAR2,
2846: p_debug_Info OUT NOCOPY VARCHAR2,
2847: p_debug_Context OUT NOCOPY VARCHAR2,
2848: p_calling_sequence IN VARCHAR2,
2849: p_default_dist_ccid IN AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE --bug 5386396
2850: ) RETURN BOOLEAN
2851: IS
2852: procedure_billable_flag VARCHAR2(60) := '';
2853: l_concat_ids VARCHAR2(200);

Line 2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;

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;

Line 2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%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;

Line 2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%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;

Line 2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%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;

Line 2884: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%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;

Line 2885: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%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;

Line 2886: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%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;

Line 2887: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%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;

Line 2888: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%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;

Line 2889: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%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;

Line 2890: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%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;

Line 2891: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%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:

Line 2892: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%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:
2896: BEGIN

Line 2893: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%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
2897:

Line 2894: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%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:
2898: -- Update the calling sequence