APPS.PO_CORE_S3 dependencies on PO_LINES_DRAFT_ALL

Line 711: line_status_code PO_LINES_DRAFT_ALL.DRAFT_LINE_STATUS%TYPE;

707: p_po_header_id IN NUMBER,
708: x_status_disp OUT NOCOPY VARCHAR2)
709: IS
710: l_draft_line_status_tbl PO_TBL_VARCHAR25 := PO_TBL_VARCHAR25();
711: line_status_code PO_LINES_DRAFT_ALL.DRAFT_LINE_STATUS%TYPE;
712:
713: BEGIN
714: -- Logic is to get code to be displayed at header level cumulative of
715: -- draft line status at line level.

Line 732: FROM po_lines_draft_all

728: 'PO_CREATED', 3,
729: 'RETURNED', 4,
730: 'WITHDRAWN', 5,
731: 'COMPLETED', 6) ASC) priority
732: FROM po_lines_draft_all
733: WHERE draft_id = p_draft_id
734: AND po_header_id = p_po_header_id)
735: WHERE priority = 1;
736: EXCEPTION