DBA Data[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on RCV_TRANSACTIONS

Line 1963: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%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,
1967: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

Line 1987: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;

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;
1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;

Line 2148: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(

2144: IF (x_dist_tab(i).rcv_transaction_id IS NOT NULL) THEN
2145:
2146: IF (l_matching_basis = 'QUANTITY') THEN
2147:
2148: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
2149: X_rcv_transaction_id => x_dist_tab(i).rcv_transaction_id,
2150: X_quantity_billed => (-1)*x_dist_tab(i).update_quantity,
2151: X_uom_lookup_code => p_ap_uom,
2152: X_amount_billed => (-1)*x_dist_tab(i).update_amount,

Line 2157: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(

2153: X_matching_basis => 'QUANTITY');
2154:
2155: ELSE
2156:
2157: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
2158: X_rcv_transaction_id => x_dist_tab(i).rcv_transaction_id,
2159: X_quantity_billed => NULL,
2160: X_uom_lookup_code => p_ap_uom,
2161: X_amount_billed => (-1)*x_dist_tab(i).update_amount,