APPS.POR_WITHDRAW_REQ_SV dependencies on PO_REQ_DISTRIBUTIONS

Line 68: delete PO_REQ_DISTRIBUTIONS_ALL

64: END IF;
65: end loop;
66: close findEncCursor;
67:
68: delete PO_REQ_DISTRIBUTIONS_ALL
69: where REQUISITION_LINE_ID in
70: ( select requisition_line_id
71: from PO_REQUISITION_LINES_ALL
72: where REQUISITION_HEADER_ID = p_existing_requisition_id);

Line 119: update po_req_distributions

115: if (l_req_encumber = 'Y') then
116:
117: po_periods_sv.get_period_name(l_sob_id, sysdate, l_gl_period);
118:
119: update po_req_distributions
120: set GL_ENCUMBERED_DATE = sysdate,
121: GL_ENCUMBERED_PERIOD_NAME = l_gl_period
122: where nvl(encumbered_flag,'N') = 'N' and
123: REQUISITION_LINE_ID in