DBA Data[Home] [Help]

APPS.PO_RESCHEDULE_PKG dependencies on PO_RELEASES_ALL

Line 145: l_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;

141: l_need_by_date_tbl PO_TBL_DATE;
142: l_nbd_validate_tbl PO_TBL_VARCHAR2000:=NULL;
143: l_return_status VARCHAR2(1);
144: l_api_errors PO_API_ERRORS_REC_TYPE;
145: l_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;
146: l_session_gt_key NUMBER;
147: l_api_name CONSTANT VARCHAR2(30) := 'RESCHEDULE';
148: l_log_head CONSTANT VARCHAR2(100):= g_module_prefix||l_api_name;
149: l_progress VARCHAR2(3):='000';

Line 207: from po_releases_all

203: begin
204: -- Get the po_release_id out of supply_number
205: select po_release_id,release_type
206: into l_po_release_id,l_release_type
207: from po_releases_all
208: where po_header_id = x_po_header_id
209: and release_num = x_release_num;
210:
211: l_progress:= '030';

Line 242: FROM po_releases_all

238: -- Retrieve the document's operating unit.
239: IF (x_po_type = 'RELEASE') THEN
240: SELECT org_id
241: INTO l_document_org_id
242: FROM po_releases_all
243: WHERE po_release_id = l_po_release_id;/*Bug 5255550*/
244: ELSE -- PO
245: SELECT org_id
246: INTO l_document_org_id