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_ISP_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1962: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,

1958: l_po_ap_line_loc_rec PO_AP_LINE_LOC_REC_TYPE;
1959:
1960: TYPE r_dist_info IS RECORD
1961: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
1962: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
1963: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
1964: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1965: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1966: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,

Line 1964: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

1960: TYPE r_dist_info IS RECORD
1961: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
1962: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
1963: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
1964: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1965: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1966: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
1967: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1968: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

Line 1965: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

1961: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
1962: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
1963: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
1964: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1965: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1966: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
1967: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1968: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1969: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE

Line 1966: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,

1962: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
1963: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
1964: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1965: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1966: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
1967: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1968: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1969: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
1970: );

Line 1967: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

1963: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
1964: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1965: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1966: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
1967: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1968: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1969: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
1970: );
1971: TYPE Dist_Tab_Type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;

Line 1968: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

1964: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1965: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1966: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
1967: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1968: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1969: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
1970: );
1971: TYPE Dist_Tab_Type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;
1972: x_dist_tab DIST_TAB_TYPE;

Line 1969: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE

1965: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1966: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
1967: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1968: update_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1969: update_pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE
1970: );
1971: TYPE Dist_Tab_Type IS TABLE OF r_dist_info INDEX BY BINARY_INTEGER;
1972: x_dist_tab DIST_TAB_TYPE;
1973:

Line 1981: FROM ap_invoice_distributions_all

1977: rcv_transaction_id,
1978: amount,
1979: quantity_invoiced,
1980: pa_quantity
1981: FROM ap_invoice_distributions_all
1982: WHERE invoice_id = p_invoice_id
1983: AND invoice_line_number = p_line_number;
1984:
1985: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;

Line 1986: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;

1982: WHERE invoice_id = p_invoice_id
1983: AND invoice_line_number = p_line_number;
1984:
1985: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1986: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
1987: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
1988: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1989: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1990: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;

Line 1988: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;

1984:
1985: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1986: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
1987: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
1988: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1989: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1990: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
1992: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;

Line 1995: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;

1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
1992: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1993: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;
1994: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1995: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1996: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1997: l_api_name VARCHAR2(32);
1998: l_msg_data VARCHAR2(4000);
1999: l_return_status VARCHAR2(100);

Line 2002: l_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE;

1998: l_msg_data VARCHAR2(4000);
1999: l_return_status VARCHAR2(100);
2000: l_debug_info VARCHAR2(1000);
2001: l_matching_basis VARCHAR2(30);
2002: l_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE;
2003: current_calling_sequence VARCHAR2(1000);
2004: api_call_failed EXCEPTION;
2005:
2006: begin

Line 2023: FROM ap_invoice_distributions_all

2019:
2020:
2021: SELECT sum(quantity_invoiced),sum(amount)
2022: INTO l_total_quantity_billed,l_total_amount_billed
2023: FROM ap_invoice_distributions_all
2024: WHERE invoice_id = p_invoice_id
2025: AND invoice_line_number = p_line_number;
2026:
2027: SELECT matching_basis

Line 2137: UPDATE ap_invoice_distributions_all

2133: p_amount_recouped => NULL,
2134: p_retainage_withheld_amt => NULL,
2135: p_retainage_released_amt => NULL);
2136:
2137: UPDATE ap_invoice_distributions_all
2138: SET amount = amount - nvl(x_dist_tab(i).update_amount,0),
2139: quantity_invoiced = quantity_invoiced - nvl(x_dist_tab(i).update_quantity,0),
2140: pa_quantity = pa_quantity - nvl(x_dist_tab(i).update_pa_quantity,0)
2141: WHERE invoice_distribution_id = x_dist_tab(i).invoice_distribution_id;