DBA Data[Home] [Help]

APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1827: l_lines_total ap_invoice_lines_all.amount%type;

1823: p_error_code OUT NOCOPY VARCHAR2,
1824: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS
1825:
1826:
1827: l_lines_total ap_invoice_lines_all.amount%type;
1828: l_lines_total_base_amount ap_invoice_lines_all.base_amount%type;
1829: l_calling_sequence varchar2(2000);
1830: l_success boolean;
1831:

Line 1828: l_lines_total_base_amount ap_invoice_lines_all.base_amount%type;

1824: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS
1825:
1826:
1827: l_lines_total ap_invoice_lines_all.amount%type;
1828: l_lines_total_base_amount ap_invoice_lines_all.base_amount%type;
1829: l_calling_sequence varchar2(2000);
1830: l_success boolean;
1831:
1832: --Bug#12644273

Line 1852: FROM ap_invoice_lines_all

1848: IF (l_success) THEN
1849:
1850: SELECT nvl(sum(amount),0),nvl(sum(base_amount),0)
1851: INTO l_lines_total,l_lines_total_base_amount
1852: FROM ap_invoice_lines_all
1853: WHERE invoice_id = p_invoice_id;
1854:
1855: --Introduced SELECT for bug#12644273
1856: SELECT exchange_rate