269: X_progress varchar2(3) := '000';
270:
271: cursor c1 is
272: SELECT 'release exist prior to the effective date'
273: FROM po_releases
274: WHERE release_date < X_start_date
275: AND po_header_id = X_po_header_id;
276: Recinfo c1%rowtype;
277:
319: X_progress VARCHAR2(3) := '';
320:
321: cursor c1 is
322: SELECT 'release exist after the expiration date'
323: FROM po_releases
324: --
325: WHERE TRUNC(release_date) > X_end_date
326: AND po_header_id = X_po_header_id;
327: