[Home] [Help]
1957: l_po_ap_dist_rec PO_AP_DIST_REC_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,
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;
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;
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;
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;
2169:
2170: END LOOP;
2171:
2172:
2173: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
2174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2175: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2176: END IF;
2177: