DBA Data[Home] [Help]

APPS.PO_REQ_LINES_SV dependencies on PO_LINES_DRAFT_ALL

Line 1912: UPDATE po_lines_draft_all

1908: END IF;
1909: END IF;
1910:
1911: FORALL i IN 1..p_reqLine_ids.Count
1912: UPDATE po_lines_draft_all
1913: SET DRAFT_LINE_STATUS = 'COMPLETED'
1914: WHERE (po_line_id, draft_id) IN ( SELECT par_line_id, par_draft_id
1915: FROM po_requisition_lines_all
1916: WHERE requisition_line_id = p_reqLine_ids(i)

Line 1922: UPDATE po_lines_draft_all

1918: AND assignment_number IS NULL
1919: );
1920:
1921: FORALL i IN 1..p_reqLine_ids.Count
1922: UPDATE po_lines_draft_all
1923: SET DRAFT_LINE_STATUS = 'ASSIGNED'
1924: WHERE (po_line_id, draft_id) IN ( SELECT par_line_id, par_draft_id
1925: FROM po_requisition_lines_all
1926: WHERE requisition_line_id = p_reqLine_ids(i)