APPS.PO_RCO_VALIDATION_GRP SQL Statements

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

Line: 18

  SELECT requisition_line_id,
         line_location_id
    FROM po_requisition_lines_all
   WHERE requisition_header_id = hdr_id;

Line: 88

  SELECT requisition_line_id,
         line_location_id
    FROM po_requisition_lines_all
   WHERE requisition_header_id = hdr_id;

Line: 493

 	            SELECT Count(*)
 	            INTO l_line_to_withdraw_count
 	            FROM po_requisition_lines_all
 	            WHERE  REQUISITION_HEADER_ID  = p_req_hdr_id
 	            AND    LINE_LOCATION_ID IS NULL
 	            AND   nvl(CANCEL_FLAG,'N') = 'N'
 	            AND   nvl(CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED');

Line: 598

  PROCEDURE update_reqcancel_from_so(
                                     p_api_version                 IN             NUMBER
                                     ,  x_return_status               OUT NOCOPY     VARCHAR2
                                     ,  p_req_hdr_id                  IN             NUMBER
                                     ,  p_req_line_id                  IN             NUMBER
                                     )
  IS

  l_api_name              CONSTANT VARCHAR2(30) := 'update_ReqCancel_from_SO';

Line: 625

    SAVEPOINT update_reqcancel_from_so_sp;

Line: 653

      po_debug.debug_stmt(l_log_head, l_progress,'Calling Private Procedure update_ReqCancel_from_SO');

Line: 659

      po_rco_validation_pvt.update_reqcancel_from_so(p_req_hdr_id     => p_req_hdr_id
                                                     , p_req_line_id     => p_req_line_id
                                                     ,  x_return_status    =>  x_return_status);

Line: 668

      po_debug.debug_stmt(l_log_head, l_progress,'After Private Procedure update_ReqCancel_from_SO');

Line: 674

    ROLLBACK TO update_reqcancel_from_so_sp;

Line: 678

    ROLLBACK TO update_reqcancel_from_so_sp;

Line: 681

    ROLLBACK TO update_reqcancel_from_so_sp;

Line: 686

  END update_reqcancel_from_so;

Line: 690

  PROCEDURE update_reqchange_from_so(
                                     p_api_version                 IN             NUMBER
                                     ,  x_return_status               OUT NOCOPY     VARCHAR2
                                     ,  p_req_line_id                  IN             NUMBER
                                     ,  p_delta_quantity               IN             NUMBER
                                     ,  p_new_need_by_date             IN             DATE
                                     )
  IS

  l_api_name              CONSTANT VARCHAR2(30) := 'update_ReqChange_from_SO';

Line: 721

    SAVEPOINT update_reqchange_from_so_sp;

Line: 749

      po_debug.debug_stmt(l_log_head, l_progress,'Calling Private Procedure update_ReqCancel_from_SO');

Line: 758

      po_rco_validation_pvt.update_reqchange_from_so(
                                                     p_req_line_id     => p_req_line_id
                                                     , p_delta_quantity  => p_delta_quantity
                                                     , p_new_need_by_date =>  p_new_need_by_date
                                                     , x_return_status    =>  x_return_status);

Line: 770

      po_debug.debug_stmt(l_log_head, l_progress,'After Private Procedure update_ReqChange_from_SO');

Line: 776

    ROLLBACK TO update_reqcancel_from_so_sp;

Line: 780

    ROLLBACK TO update_reqcancel_from_so_sp;

Line: 783

    ROLLBACK TO update_reqcancel_from_so_sp;

Line: 788

  END update_reqchange_from_so;