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 256: OR EXISTS (SELECT null from po_requisition_lines l

252: /* <> */
253: )
254: AND (h.closed_code is NULL or h.closed_code IN ('OPEN', 'CLOSED')))
255: AND (p_req_line_id(i) IS NULL
256: OR EXISTS (SELECT null from po_requisition_lines l
257: WHERE l.requisition_header_id = p_req_header_id(i)
258: and l.requisition_line_id = p_req_line_id(i)
259: AND (l.closed_code is NULL or l.closed_code IN ('OPEN', 'CLOSED'))))
260: ;

Line 386: OR EXISTS (SELECT null from po_requisition_lines l

382: EXISTS (select null from po_requisition_headers h
383: WHERE h.requisition_header_id = p_req_header_id(i)
384: AND (h.closed_code is NULL or h.closed_code IN ('OPEN', 'CLOSED')))
385: AND (p_req_line_id(i) IS NULL
386: OR EXISTS (SELECT null from po_requisition_lines l
387: WHERE l.requisition_header_id = p_req_header_id(i)
388: AND l.requisition_line_id = p_req_line_id(i)
389: AND (l.closed_code is NULL or l.closed_code IN ('OPEN', 'CLOSED'))))
390: ;

Line 531: FROM po_requisition_lines s

527: UPDATE po_headers_gt gt
528: SET (closed_code, cancel_flag)
529: =
530: (SELECT nvl(closed_code, 'OPEN'), NVL(cancel_flag, 'N')
531: FROM po_requisition_lines s
532: WHERE s.requisition_line_id = p_req_line_id(i))
533: WHERE p_req_line_id(i) is not null and gt.po_header_id = l_sequence(i)
534: ;
535: