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 504: FROM ap_invoices_all ai

500: l_prepayment_type VARCHAR2(9);
501:
502: CURSOR c_prepayment_type IS
503: SELECT decode(AI.EARLIEST_SETTLEMENT_DATE,null,'PERMANENT','TEMPORARY')
504: FROM ap_invoices_all ai
505: WHERE ai.invoice_id = P_invoice_id;
506: BEGIN
507:
508: -- Returns whether prepayment is of type "PERMANENT' which cannot be

Line 739: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;

735: FUNCTION Get_Invoice_Unpaid_Amount(
736: X_Invoice_Id IN NUMBER) RETURN NUMBER
737: IS
738: l_invoice_unpaid_amount NUMBER := 0;
739: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
740: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
741: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
742: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
743: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

Line 740: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;

736: X_Invoice_Id IN NUMBER) RETURN NUMBER
737: IS
738: l_invoice_unpaid_amount NUMBER := 0;
739: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
740: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
741: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
742: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
743: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
744: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

Line 741: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

737: IS
738: l_invoice_unpaid_amount NUMBER := 0;
739: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
740: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
741: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
742: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
743: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
744: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
745: l_lines_total_no_exc_tax NUMBER := 0;

Line 742: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

738: l_invoice_unpaid_amount NUMBER := 0;
739: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
740: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
741: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
742: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
743: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
744: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
745: l_lines_total_no_exc_tax NUMBER := 0;
746: l_unpaid_amount NUMBER := 0;

Line 743: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

739: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
740: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
741: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
742: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
743: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
744: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
745: l_lines_total_no_exc_tax NUMBER := 0;
746: l_unpaid_amount NUMBER := 0;
747:

Line 744: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

740: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
741: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
742: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
743: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
744: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
745: l_lines_total_no_exc_tax NUMBER := 0;
746: l_unpaid_amount NUMBER := 0;
747:
748: CURSOR c_invoice_info IS

Line 755: FROM ap_invoices_all ai

751: ai.payment_currency_code,
752: ai.payment_cross_rate_date,
753: ai.payment_cross_rate_type,
754: NVL(ai.invoice_amount, 0)
755: FROM ap_invoices_all ai
756: WHERE ai.invoice_id = X_Invoice_Id;
757:
758: /* Commented for bug 7506584
759: CURSOR c_invoice_lines_info IS

Line 935: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;

931: FUNCTION Get_Inv_Tot_Unpaid_Amt(
932: X_Invoice_Id IN NUMBER) RETURN NUMBER
933: IS
934: l_invoice_unpaid_amount NUMBER := 0;
935: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
936: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
937: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
938: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
939: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

Line 936: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;

932: X_Invoice_Id IN NUMBER) RETURN NUMBER
933: IS
934: l_invoice_unpaid_amount NUMBER := 0;
935: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
936: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
937: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
938: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
939: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
940: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

Line 937: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

933: IS
934: l_invoice_unpaid_amount NUMBER := 0;
935: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
936: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
937: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
938: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
939: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
940: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
941: l_lines_total_with_exc_tax NUMBER := 0;

Line 938: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

934: l_invoice_unpaid_amount NUMBER := 0;
935: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
936: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
937: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
938: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
939: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
940: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
941: l_lines_total_with_exc_tax NUMBER := 0;
942: l_unpaid_amount NUMBER := 0;

Line 939: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

935: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
936: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
937: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
938: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
939: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
940: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
941: l_lines_total_with_exc_tax NUMBER := 0;
942: l_unpaid_amount NUMBER := 0;
943:

Line 940: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

936: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
937: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
938: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
939: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
940: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
941: l_lines_total_with_exc_tax NUMBER := 0;
942: l_unpaid_amount NUMBER := 0;
943:
944: CURSOR c_invoice_info IS

Line 951: FROM ap_invoices_all ai

947: ai.payment_currency_code,
948: ai.payment_cross_rate_date,
949: ai.payment_cross_rate_type,
950: NVL(ai.invoice_amount, 0)
951: FROM ap_invoices_all ai
952: WHERE ai.invoice_id = X_Invoice_Id;
953:
954: /* Commented for bug 7506584
955: CURSOR c_invoice_lines_info IS

Line 1057: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;

1053: FUNCTION Get_Inclusive_Tax_Unpaid_Amt (
1054: X_Invoice_Id IN NUMBER) RETURN NUMBER
1055: IS
1056: l_inclusive_unpaid_amount NUMBER := 0;
1057: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1058: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1059: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1060: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1061: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

Line 1058: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;

1054: X_Invoice_Id IN NUMBER) RETURN NUMBER
1055: IS
1056: l_inclusive_unpaid_amount NUMBER := 0;
1057: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1058: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1059: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1060: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1061: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1062: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

Line 1059: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

1055: IS
1056: l_inclusive_unpaid_amount NUMBER := 0;
1057: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1058: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1059: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1060: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1061: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1062: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1063: l_inclusive_tax_total_lines NUMBER := 0;

Line 1060: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

1056: l_inclusive_unpaid_amount NUMBER := 0;
1057: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1058: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1059: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1060: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1061: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1062: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1063: l_inclusive_tax_total_lines NUMBER := 0;
1064:

Line 1061: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;

1057: l_inv_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
1058: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1059: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1060: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1061: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1062: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1063: l_inclusive_tax_total_lines NUMBER := 0;
1064:
1065: l_unpaid_amount NUMBER := 0;

Line 1062: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;

1058: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
1059: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
1060: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
1061: l_payment_cross_rate_type AP_INVOICES_ALL.payment_cross_rate_type%TYPE;
1062: l_invoice_total AP_INVOICES_ALL.invoice_amount%TYPE;
1063: l_inclusive_tax_total_lines NUMBER := 0;
1064:
1065: l_unpaid_amount NUMBER := 0;
1066:

Line 1074: FROM ap_invoices_all ai

1070: ai.payment_currency_code,
1071: ai.payment_cross_rate_date,
1072: ai.payment_cross_rate_type,
1073: NVL(ai.invoice_amount, 0)
1074: FROM ap_invoices_all ai
1075: WHERE ai.invoice_id = X_Invoice_Id;
1076:
1077: CURSOR c_invoice_lines_info IS
1078: SELECT NVL(SUM(NVL(ail.included_tax_amount,0)), 0)