DBA Data[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on RCV_TRANSACTIONS

Line 2265: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,

2261:
2262: TYPE r_dist_info IS RECORD
2263: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
2264: invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
2265: rcv_transaction_id RCV_TRANSACTIONS.transaction_id%TYPE,
2266: match_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
2267: match_quantity AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
2268: pa_quantity AP_INVOICE_DISTRIBUTIONS.pa_quantity%TYPE,
2269: update_amount AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

Line 2289: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;

2285: AND invoice_line_number = p_line_number;
2286:
2287: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2288: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
2289: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
2290: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
2291: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
2292: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
2293: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;

Line 2450: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(

2446: IF (x_dist_tab(i).rcv_transaction_id IS NOT NULL) THEN
2447:
2448: IF (l_matching_basis = 'QUANTITY') THEN
2449:
2450: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
2451: X_rcv_transaction_id => x_dist_tab(i).rcv_transaction_id,
2452: X_quantity_billed => (-1)*x_dist_tab(i).update_quantity,
2453: X_uom_lookup_code => p_ap_uom,
2454: X_amount_billed => (-1)*x_dist_tab(i).update_amount,

Line 2459: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(

2455: X_matching_basis => 'QUANTITY');
2456:
2457: ELSE
2458:
2459: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
2460: X_rcv_transaction_id => x_dist_tab(i).rcv_transaction_id,
2461: X_quantity_billed => NULL,
2462: X_uom_lookup_code => p_ap_uom,
2463: X_amount_billed => (-1)*x_dist_tab(i).update_amount,