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_PREPAY_UTILS_PKG dependencies on AP_INVOICES_ALL

Line 206: FROM ap_invoices_all ai,

202: l_prepay_number VARCHAR2(50);
203:
204: CURSOR c_prepay_number IS
205: SELECT invoice_num
206: FROM ap_invoices_all ai,
207: ap_invoice_distributions_all aid
208: WHERE ai.invoice_id = aid.invoice_id
209: AND aid.invoice_distribution_id = l_prepay_dist_id;
210:

Line 531: FROM ap_invoices_all ai

527: l_prepayment_type VARCHAR2(9);
528:
529: CURSOR c_prepayment_type IS
530: SELECT decode(AI.EARLIEST_SETTLEMENT_DATE,null,'PERMANENT','TEMPORARY')
531: FROM ap_invoices_all ai
532: WHERE ai.invoice_id = P_invoice_id;
533: BEGIN
534:
535: -- Returns whether prepayment is of type "PERMANENT' which cannot be

Line 766: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;

762: FUNCTION Get_Invoice_Unpaid_Amount(
763: X_Invoice_Id IN NUMBER) RETURN NUMBER
764: IS
765: l_invoice_unpaid_amount NUMBER := 0;
766: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
767: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
768: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
769: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
770: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

Line 767: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;

763: X_Invoice_Id IN NUMBER) RETURN NUMBER
764: IS
765: l_invoice_unpaid_amount NUMBER := 0;
766: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
767: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
768: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
769: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
770: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
771: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

Line 768: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

764: IS
765: l_invoice_unpaid_amount NUMBER := 0;
766: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
767: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
768: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
769: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
770: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
771: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
772: l_lines_total_no_exc_tax NUMBER := 0;

Line 769: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

765: l_invoice_unpaid_amount NUMBER := 0;
766: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
767: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
768: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
769: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
770: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
771: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
772: l_lines_total_no_exc_tax NUMBER := 0;
773: l_unpaid_amount NUMBER := 0;

Line 770: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

766: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
767: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
768: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
769: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
770: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
771: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
772: l_lines_total_no_exc_tax NUMBER := 0;
773: l_unpaid_amount NUMBER := 0;
774:

Line 771: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

767: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
768: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
769: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
770: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
771: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
772: l_lines_total_no_exc_tax NUMBER := 0;
773: l_unpaid_amount NUMBER := 0;
774:
775: CURSOR c_invoice_info IS

Line 782: FROM ap_invoices_all ai

778: ai.payment_currency_code,
779: ai.payment_cross_rate_date,
780: ai.payment_cross_rate_type,
781: NVL(ai.invoice_amount, 0)
782: FROM ap_invoices_all ai
783: WHERE ai.invoice_id = X_Invoice_Id;
784:
785: /* Commented for bug 7506584
786: CURSOR c_invoice_lines_info IS

Line 1039: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;

1035: FUNCTION Get_Inv_Tot_Unpaid_Amt(
1036: X_Invoice_Id IN NUMBER) RETURN NUMBER
1037: IS
1038: l_invoice_unpaid_amount NUMBER := 0;
1039: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1040: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1041: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1042: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1043: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

Line 1040: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;

1036: X_Invoice_Id IN NUMBER) RETURN NUMBER
1037: IS
1038: l_invoice_unpaid_amount NUMBER := 0;
1039: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1040: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1041: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1042: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1043: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1044: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

Line 1041: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

1037: IS
1038: l_invoice_unpaid_amount NUMBER := 0;
1039: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1040: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1041: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1042: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1043: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1044: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1045: l_lines_total_with_exc_tax NUMBER := 0;

Line 1042: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

1038: l_invoice_unpaid_amount NUMBER := 0;
1039: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1040: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1041: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1042: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1043: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1044: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1045: l_lines_total_with_exc_tax NUMBER := 0;
1046: l_unpaid_amount NUMBER := 0;

Line 1043: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

1039: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1040: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1041: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1042: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1043: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1044: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1045: l_lines_total_with_exc_tax NUMBER := 0;
1046: l_unpaid_amount NUMBER := 0;
1047:

Line 1044: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

1040: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1041: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1042: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1043: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1044: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1045: l_lines_total_with_exc_tax NUMBER := 0;
1046: l_unpaid_amount NUMBER := 0;
1047:
1048: CURSOR c_invoice_info IS

Line 1055: FROM ap_invoices_all ai

1051: ai.payment_currency_code,
1052: ai.payment_cross_rate_date,
1053: ai.payment_cross_rate_type,
1054: NVL(ai.invoice_amount, 0)
1055: FROM ap_invoices_all ai
1056: WHERE ai.invoice_id = X_Invoice_Id;
1057:
1058: /* Commented for bug 7506584
1059: CURSOR c_invoice_lines_info IS

Line 1161: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;

1157: FUNCTION Get_Inclusive_Tax_Unpaid_Amt (
1158: X_Invoice_Id IN NUMBER) RETURN NUMBER
1159: IS
1160: l_inclusive_unpaid_amount NUMBER := 0;
1161: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1162: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1163: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1164: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1165: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

Line 1162: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;

1158: X_Invoice_Id IN NUMBER) RETURN NUMBER
1159: IS
1160: l_inclusive_unpaid_amount NUMBER := 0;
1161: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1162: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1163: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1164: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1165: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1166: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

Line 1163: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

1159: IS
1160: l_inclusive_unpaid_amount NUMBER := 0;
1161: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1162: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1163: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1164: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1165: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1166: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1167: l_inclusive_tax_total_lines NUMBER := 0;

Line 1164: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

1160: l_inclusive_unpaid_amount NUMBER := 0;
1161: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1162: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1163: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1164: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1165: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1166: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1167: l_inclusive_tax_total_lines NUMBER := 0;
1168:

Line 1165: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

1161: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1162: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1163: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1164: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1165: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1166: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1167: l_inclusive_tax_total_lines NUMBER := 0;
1168:
1169: l_unpaid_amount NUMBER := 0;

Line 1166: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

1162: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1163: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1164: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1165: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1166: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1167: l_inclusive_tax_total_lines NUMBER := 0;
1168:
1169: l_unpaid_amount NUMBER := 0;
1170:

Line 1178: FROM ap_invoices_all ai

1174: ai.payment_currency_code,
1175: ai.payment_cross_rate_date,
1176: ai.payment_cross_rate_type,
1177: NVL(ai.invoice_amount, 0)
1178: FROM ap_invoices_all ai
1179: WHERE ai.invoice_id = X_Invoice_Id;
1180:
1181: CURSOR c_invoice_lines_info IS
1182: SELECT NVL(SUM(NVL(ail.included_tax_amount,0)), 0)