486: RETURN NUMBER IS
487:
488: l_progress VARCHAR2(3) := NULL;
489: l_value_basis PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
490: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
491:
492: BEGIN
493:
494: l_progress := '010';
502:
503: Select plt.order_type_lookup_code
504: Into l_value_basis
505: From po_line_types_b plt,
506: po_requisition_lines_all prl --
508: And prl.requisition_line_id = p_req_entity_id;
509:
510:
517:
518: Select plt.order_type_lookup_code
519: Into l_value_basis
520: From po_line_types_b plt,
521: po_requisition_lines_all prl, --
523: Where plt.line_type_id = prl.line_type_id
524: And prl.requisition_line_id = prd.requisition_line_id
525: And prd.distribution_id = p_req_entity_id;
536: l_progress := '040';
537:
538: Select prl.amount
539: Into l_req_amount
540: From po_requisition_lines_all prl --
542:
543: ELSE
544: -- Sql What : Gets the amount on the req distribution