425: AND POD.distribution_num (+)= PCR.document_distribution_number
426: AND nvl(PCR.new_quantity,-1)<>0
427: AND nvl(PCR.new_amount,-1)<>0;
428:
429: l_po_line_id_tbl PO_TBL_NUMBER;
430: l_quantity_tbl PO_TBL_NUMBER;
431: l_price_tbl PO_TBL_NUMBER;
432: l_amount_tbl PO_TBL_NUMBER;
433: l_po_line_location_id_tbl PO_TBL_NUMBER;
426: AND nvl(PCR.new_quantity,-1)<>0
427: AND nvl(PCR.new_amount,-1)<>0;
428:
429: l_po_line_id_tbl PO_TBL_NUMBER;
430: l_quantity_tbl PO_TBL_NUMBER;
431: l_price_tbl PO_TBL_NUMBER;
432: l_amount_tbl PO_TBL_NUMBER;
433: l_po_line_location_id_tbl PO_TBL_NUMBER;
434: l_parent_line_location_id_tbl PO_TBL_NUMBER;
427: AND nvl(PCR.new_amount,-1)<>0;
428:
429: l_po_line_id_tbl PO_TBL_NUMBER;
430: l_quantity_tbl PO_TBL_NUMBER;
431: l_price_tbl PO_TBL_NUMBER;
432: l_amount_tbl PO_TBL_NUMBER;
433: l_po_line_location_id_tbl PO_TBL_NUMBER;
434: l_parent_line_location_id_tbl PO_TBL_NUMBER;
435: l_promised_date_tbl PO_TBL_DATE;
428:
429: l_po_line_id_tbl PO_TBL_NUMBER;
430: l_quantity_tbl PO_TBL_NUMBER;
431: l_price_tbl PO_TBL_NUMBER;
432: l_amount_tbl PO_TBL_NUMBER;
433: l_po_line_location_id_tbl PO_TBL_NUMBER;
434: l_parent_line_location_id_tbl PO_TBL_NUMBER;
435: l_promised_date_tbl PO_TBL_DATE;
436: l_need_by_date_tbl PO_TBL_DATE;
429: l_po_line_id_tbl PO_TBL_NUMBER;
430: l_quantity_tbl PO_TBL_NUMBER;
431: l_price_tbl PO_TBL_NUMBER;
432: l_amount_tbl PO_TBL_NUMBER;
433: l_po_line_location_id_tbl PO_TBL_NUMBER;
434: l_parent_line_location_id_tbl PO_TBL_NUMBER;
435: l_promised_date_tbl PO_TBL_DATE;
436: l_need_by_date_tbl PO_TBL_DATE;
437: l_start_date_tbl PO_TBL_DATE;
430: l_quantity_tbl PO_TBL_NUMBER;
431: l_price_tbl PO_TBL_NUMBER;
432: l_amount_tbl PO_TBL_NUMBER;
433: l_po_line_location_id_tbl PO_TBL_NUMBER;
434: l_parent_line_location_id_tbl PO_TBL_NUMBER;
435: l_promised_date_tbl PO_TBL_DATE;
436: l_need_by_date_tbl PO_TBL_DATE;
437: l_start_date_tbl PO_TBL_DATE;
438: l_expiration_date_tbl PO_TBL_DATE;
435: l_promised_date_tbl PO_TBL_DATE;
436: l_need_by_date_tbl PO_TBL_DATE;
437: l_start_date_tbl PO_TBL_DATE;
438: l_expiration_date_tbl PO_TBL_DATE;
439: l_split_shipment_num_tbl PO_TBL_NUMBER;
440: l_po_distribution_id_tbl PO_TBL_NUMBER;
441: l_parent_distribution_id_tbl PO_TBL_NUMBER;
442: l_supplier_part_number_tbl PO_TBL_VARCHAR30;
443: l_err_msg_name_tbl po_tbl_varchar30;
436: l_need_by_date_tbl PO_TBL_DATE;
437: l_start_date_tbl PO_TBL_DATE;
438: l_expiration_date_tbl PO_TBL_DATE;
439: l_split_shipment_num_tbl PO_TBL_NUMBER;
440: l_po_distribution_id_tbl PO_TBL_NUMBER;
441: l_parent_distribution_id_tbl PO_TBL_NUMBER;
442: l_supplier_part_number_tbl PO_TBL_VARCHAR30;
443: l_err_msg_name_tbl po_tbl_varchar30;
444: l_err_msg_text_tbl po_tbl_varchar2000;
437: l_start_date_tbl PO_TBL_DATE;
438: l_expiration_date_tbl PO_TBL_DATE;
439: l_split_shipment_num_tbl PO_TBL_NUMBER;
440: l_po_distribution_id_tbl PO_TBL_NUMBER;
441: l_parent_distribution_id_tbl PO_TBL_NUMBER;
442: l_supplier_part_number_tbl PO_TBL_VARCHAR30;
443: l_err_msg_name_tbl po_tbl_varchar30;
444: l_err_msg_text_tbl po_tbl_varchar2000;
445: l_line_changes PO_LINES_REC_TYPE;