APPS.PO_UPDATE_DATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

  END update_promised_date;

Line: 22

  /* update_need_by_date
   * -------------------
   */
  PROCEDURE update_need_by_date(p_line_location_id NUMBER,
                             p_new_need_by_date DATE) IS
  BEGIN

    UPDATE PO_LINE_LOCATIONS_ALL
       SET need_by_date = p_new_need_by_date
     WHERE line_location_id = p_line_location_id;

Line: 35

  END update_need_by_date;

Line: 39

  /* update_req_need_by_date
   * -----------------------
   */
  PROCEDURE update_req_need_by_date(p_requisition_line_id NUMBER,
                                    p_new_need_by_date    DATE) IS
  BEGIN

    UPDATE PO_REQUISITION_LINES_ALL
       SET need_by_date = p_new_need_by_date
     WHERE requisition_line_id = p_requisition_line_id;

Line: 52

  END update_req_need_by_date;

Line: 55

END PO_UPDATE_DATE_PKG;