APPS.PO_RESCHEDULE_PKG dependencies on PO_RELEASES_ALL

Line 179: l_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;

175: l_need_by_date_tbl PO_TBL_DATE;
176: l_nbd_validate_tbl PO_TBL_VARCHAR2000:=NULL;
177: l_return_status VARCHAR2(1);
178: l_api_errors PO_API_ERRORS_REC_TYPE;
179: l_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;
180: l_session_gt_key NUMBER;
181: l_api_name CONSTANT VARCHAR2(30) := 'RESCHEDULE-3';
182: l_log_head CONSTANT VARCHAR2(100):= g_module_prefix||l_api_name;
183: l_progress VARCHAR2(3):='000';

Line 250: from po_releases_all

246: begin
247: -- Get the po_release_id out of supply_number
248: select po_release_id,release_type
249: into l_po_release_id,l_release_type
250: from po_releases_all
251: where po_header_id = x_po_header_id
252: and release_num = x_release_num;
253:
254: l_progress:= '030';

Line 285: FROM po_releases_all

281: -- Retrieve the document's operating unit.
282: IF (x_po_type = 'RELEASE') THEN
283: SELECT org_id
284: INTO l_document_org_id
285: FROM po_releases_all
286: WHERE po_release_id = l_po_release_id;/*Bug 5255550*/
287: ELSE -- PO
288: SELECT org_id
289: INTO l_document_org_id