APPS.AP_IMPORT_INVOICES_PKG dependencies on AP_INVOICES_ALL

Line 3662: FROM ap_invoices_all ai

3658: and ail.INVOICE_INCLUDES_PREPAY_FLAG='Y' ))
3659: --bug 12727643 ends
3660: )
3661: INTO l_inv_hdr_amount, l_exclusive_tax_amount
3662: FROM ap_invoices_all ai
3663: WHERE ai.invoice_id = l_base_invoice_id;
3664:
3665: --Bug 8513242 Added code to add tax amount to the control amount of the batch created.
3666: l_actual_invoice_total := l_actual_invoice_total + l_exclusive_tax_amount;

Line 3694: -- Retreive exchange rate from ap_invoices_all for the invoice

3690: -- Retreive the exchange rate for the invoice from record
3691: IF ( l_invoice_rec.exchange_rate IS NOT NULL) THEN
3692: l_exchange_rate := l_invoice_rec.exchange_rate;
3693: ELSE
3694: -- Retreive exchange rate from ap_invoices_all for the invoice
3695: select exchange_rate into l_exchange_rate
3696: from ap_invoices_all
3697: where invoice_id=l_base_invoice_id;
3698: END IF;

Line 3696: from ap_invoices_all

3692: l_exchange_rate := l_invoice_rec.exchange_rate;
3693: ELSE
3694: -- Retreive exchange rate from ap_invoices_all for the invoice
3695: select exchange_rate into l_exchange_rate
3696: from ap_invoices_all
3697: where invoice_id=l_base_invoice_id;
3698: END IF;
3699:
3700: IF ( l_exchange_rate IS NOT NULL

Line 3708: UPDATE ap_invoices_all ai

3704: AP_IMPORT_INVOICES_PKG.tab_get_info_rec(l_invoice_rec.org_id).p_base_currency_code);
3705: END IF;
3706: END IF;
3707:
3708: UPDATE ap_invoices_all ai
3709: SET ai.invoice_amount = ai.invoice_amount + l_exclusive_tax_amount,
3710: ai.amount_applicable_to_discount = ai.amount_applicable_to_discount + l_exclusive_tax_amount,
3711: ai.base_amount=ai.base_amount+l_base_exclusive_tax_amount
3712: WHERE ai.invoice_id = l_base_invoice_id;

Line 3718: UPDATE ap_invoices_all ai

3714: -- Bug 7282839 end
3715:
3716: IF ( l_invoice_rec.payment_cross_rate is NOT NULL) THEN
3717:
3718: UPDATE ap_invoices_all ai
3719: SET ai.pay_curr_invoice_amount = ai.pay_curr_invoice_amount +
3720: gl_currency_api.convert_amount(
3721: ai.invoice_currency_code,
3722: ai.payment_currency_code,