APPS.PO_HEADERS_SV1 dependencies on PO_RELEASES

Line 493: FROM PO_RELEASES prl

489: SELECT prl.po_release_id,
490: prl.rowid
491: INTO X_release_id,
492: X_rowid
493: FROM PO_RELEASES prl
494: WHERE prl.po_header_id = x_po_header_id;
495:
496:
497: X_progress := '015';

Line 502: po_releases_sv.lock_row_for_status_update (X_release_id);

498:
499: IF X_release_id is not NUll THEN
500:
501: -- Attempt to lock the release for delete
502: po_releases_sv.lock_row_for_status_update (X_release_id);
503:
504: -- Call the release server to delete the release document
505: po_releases_sv.delete_release (X_release_id, X_rowid);
506:

Line 505: po_releases_sv.delete_release (X_release_id, X_rowid);

501: -- Attempt to lock the release for delete
502: po_releases_sv.lock_row_for_status_update (X_release_id);
503:
504: -- Call the release server to delete the release document
505: po_releases_sv.delete_release (X_release_id, X_rowid);
506:
507: END IF;
508:
509:

Line 830: SELECT org_id INTO l_org_id FROM po_releases_all WHERE po_release_id = p_doc_id;

826:
827:
828:
829: IF ( p_doc_entity = 'RELEASE' ) THEN
830: SELECT org_id INTO l_org_id FROM po_releases_all WHERE po_release_id = p_doc_id;
831: l_doc_type := g_doc_type_RELEASE;
832: ELSIF(p_doc_entity ='PURCHASE_ORDER' ) THEN
833: SELECT org_id INTO l_org_id FROM po_headers_all WHERE po_header_id = p_doc_id;
834: l_doc_type := g_doc_type_PO;