APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1744: l_lines_total ap_invoice_lines_all.amount%type;

1740: p_error_code OUT NOCOPY VARCHAR2,
1741: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS
1742:
1743:
1744: l_lines_total ap_invoice_lines_all.amount%type;
1745: l_lines_total_base_amount ap_invoice_lines_all.base_amount%type;
1746: l_calling_sequence varchar2(2000);
1747: l_success boolean;
1748:

Line 1745: l_lines_total_base_amount ap_invoice_lines_all.base_amount%type;

1741: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS
1742:
1743:
1744: l_lines_total ap_invoice_lines_all.amount%type;
1745: l_lines_total_base_amount ap_invoice_lines_all.base_amount%type;
1746: l_calling_sequence varchar2(2000);
1747: l_success boolean;
1748:
1749: BEGIN

Line 1766: FROM ap_invoice_lines_all

1762: IF (l_success) THEN
1763:
1764: SELECT nvl(sum(amount),0),nvl(sum(base_amount),0)
1765: INTO l_lines_total,l_lines_total_base_amount
1766: FROM ap_invoice_lines_all
1767: WHERE invoice_id = p_invoice_id;
1768:
1769: IF (l_lines_total <> p_invoice_amount and nvl(l_lines_total,0) <> 0) THEN
1770: