DBA Data[Home] [Help]

APPS.AP_ETAX_PKG dependencies on AP_INVOICE_LINES_ALL

Line 95: FROM ap_invoice_lines_all

91: WHERE invoice_id = P_Invoice_Id;
92:
93: SELECT SUM(amount)
94: INTO l_invoice_amount
95: FROM ap_invoice_lines_all
96: WHERE invoice_id = P_Invoice_Id
97: AND line_type_lookup_code IN ('ITEM', 'FREIGHT');
98:
99: IF l_invoice_amount > l_assessable_value THEN

Line 101: UPDATE ap_invoice_lines_all

97: AND line_type_lookup_code IN ('ITEM', 'FREIGHT');
98:
99: IF l_invoice_amount > l_assessable_value THEN
100:
101: UPDATE ap_invoice_lines_all
102: SET assessable_value = AP_Utilities_Pkg.AP_Round_Currency(
103: amount*l_assessable_value/
104: decode(l_invoice_amount,0,
105: decode(l_assessable_value,0,1,l_assessable_value),

Line 388: P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE DEFAULT NULL,

384: FUNCTION Calculate_Quote(
385: P_Calling_Mode IN VARCHAR2,
386: P_All_Error_Messages IN VARCHAR2,
387: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE DEFAULT NULL,
388: P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE DEFAULT NULL,
389: P_Tax_Amount OUT NOCOPY NUMBER,
390: P_Tax_Amt_Included OUT NOCOPY VARCHAR2,
391: P_error_code OUT NOCOPY VARCHAR2,
392: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS