DBA Data[Home] [Help]

APPS.PO_CHANGE_RESPONSE_PVT dependencies on PO_TBL_NUMBER

Line 429: l_po_line_id_tbl PO_TBL_NUMBER;

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;

Line 430: l_quantity_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;

Line 431: l_price_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;

Line 432: l_amount_tbl PO_TBL_NUMBER;

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;

Line 433: l_po_line_location_id_tbl PO_TBL_NUMBER;

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;

Line 434: l_parent_line_location_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;
438: l_expiration_date_tbl PO_TBL_DATE;

Line 439: l_split_shipment_num_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;
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;

Line 440: l_po_distribution_id_tbl PO_TBL_NUMBER;

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;

Line 441: l_parent_distribution_id_tbl PO_TBL_NUMBER;

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;