APPS.PO_REQ_DOCUMENT_CHECKS_PVT dependencies on PO_REQUISITION_LINES

Line 102: OR EXISTS (SELECT null from po_requisition_lines l

98: OR h.authorization_status NOT IN ('PRE-APPROVED', 'IN PROCESS'))
99: AND (h.cancel_flag is null or h.cancel_flag <> 'Y')
100: AND (h.closed_code is NULL or h.closed_code NOT IN ('FINALLY CLOSED')))
101: AND (p_req_line_id(i) IS NULL
102: OR EXISTS (SELECT null from po_requisition_lines l
103: WHERE l.requisition_header_id = p_req_header_id(i)
104: and l.requisition_line_id = p_req_line_id(i)
105: AND (l.cancel_flag is null or l.cancel_flag <> 'Y')
106: AND (l.closed_code is NULL or l.closed_code NOT IN ('FINALLY CLOSED'))

Line 251: OR EXISTS (SELECT null from po_requisition_lines l

247: AND (h.authorization_status is NULL
248: OR h.authorization_status NOT IN ('APPROVED'))
249: AND (h.closed_code is NULL or h.closed_code IN ('OPEN', 'CLOSED')))
250: AND (p_req_line_id(i) IS NULL
251: OR EXISTS (SELECT null from po_requisition_lines l
252: WHERE l.requisition_header_id = p_req_header_id(i)
253: and l.requisition_line_id = p_req_line_id(i)
254: AND (l.closed_code is NULL or l.closed_code IN ('OPEN', 'CLOSED'))))
255: ;

Line 381: OR EXISTS (SELECT null from po_requisition_lines l

377: EXISTS (select null from po_requisition_headers h
378: WHERE h.requisition_header_id = p_req_header_id(i)
379: AND (h.closed_code is NULL or h.closed_code IN ('OPEN', 'CLOSED')))
380: AND (p_req_line_id(i) IS NULL
381: OR EXISTS (SELECT null from po_requisition_lines l
382: WHERE l.requisition_header_id = p_req_header_id(i)
383: AND l.requisition_line_id = p_req_line_id(i)
384: AND (l.closed_code is NULL or l.closed_code IN ('OPEN', 'CLOSED'))))
385: ;

Line 526: FROM po_requisition_lines s

522: UPDATE po_headers_gt gt
523: SET (closed_code, cancel_flag)
524: =
525: (SELECT nvl(closed_code, 'OPEN'), NVL(cancel_flag, 'N')
526: FROM po_requisition_lines s
527: WHERE s.requisition_line_id = p_req_line_id(i))
528: WHERE p_req_line_id(i) is not null and gt.po_header_id = l_sequence(i)
529: ;
530: