396: RETURN BOOLEAN
397: IS
398: CURSOR l_item_csr IS
399: SELECT item_id, org_id
400: FROM po_lines_all
401: WHERE po_header_id = p_po_header_id;
402:
403: l_item_id PO_LINES_ALL.item_id%TYPE;
404: l_org_id PO_LINES_ALL.org_id%TYPE;
399: SELECT item_id, org_id
400: FROM po_lines_all
401: WHERE po_header_id = p_po_header_id;
402:
403: l_item_id PO_LINES_ALL.item_id%TYPE;
404: l_org_id PO_LINES_ALL.org_id%TYPE;
405:
406: BEGIN
407:
400: FROM po_lines_all
401: WHERE po_header_id = p_po_header_id;
402:
403: l_item_id PO_LINES_ALL.item_id%TYPE;
404: l_org_id PO_LINES_ALL.org_id%TYPE;
405:
406: BEGIN
407:
408: OPEN l_item_csr;
562: From po_requisition_lines_all PRL
563: WHERE PRL.line_type_id = p_line_type_id)
564:
565: OR EXISTS (SELECT 'PO Lines Exist'
566: FROM po_lines_all POL
567: WHERE POL.line_type_id = p_line_type_id)
568:
569: OR EXISTS (SELECT 'Archived PO Lines Exist'
570: FROM po_lines_archive_all POAL