[Home] [Help]
2259: l_po_ap_dist_rec PO_AP_DIST_REC_TYPE;
2260: l_po_ap_line_loc_rec PO_AP_LINE_LOC_REC_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,
2283: FROM ap_invoice_distributions_all
2284: WHERE invoice_id = p_invoice_id
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;
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;
2294: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
2295: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;
2296: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
2297: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
2298: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
2471:
2472: END LOOP;
2473:
2474:
2475: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
2476: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2478: END IF;
2479: