set define '^'
set verify off
prompt ...wwv_flow_sample_app

Rem  Copyright (c) Oracle Corporation 2003. All Rights Reserved.
Rem
Rem    NAME
Rem      wwv_flow_sample_app.sql
Rem
Rem    DESCRIPTION
Rem
Rem    NOTES
Rem
Rem    INTERNATIONALIZATION
Rem      unknown
Rem
Rem    MULTI-CUSTOMER
Rem      unknown
Rem
Rem    SCRIPT ARGUMENTS
Rem      NONE
Rem
Rem
Rem    RUNTIME DEPLOYMENT: YES
Rem
Rem    MODIFIED  (MM/DD/YYYY)
Rem    sspendol   08/01/2003 - Created
Rem    jstraub    09/08/2004 - Added load_images to enable new sample app
Rem    jstraub    09/21/2004 - Added v_security_group_id to populate_tables to support lower of workspace name for psswd's
Rem    cbcho      11/22/2005 - Changed load_images to accept v_flow_id
Rem    cbcho      01/24/2008 - Renamed load_images to load_product_info, Changed populate_tables to accept v_flow_id


CREATE OR REPLACE PACKAGE wwv_flow_sample_app
IS

PROCEDURE remove_and_create_sample_app 
  (v_owner IN VARCHAR2, v_security_group_id IN NUMBER, v_offset NUMBER, v_flow_id IN NUMBER);

PROCEDURE create_sample_app
  (v_flow_id IN NUMBER, v_security_group_id IN NUMBER, v_offset_id IN NUMBER, v_owner IN VARCHAR2);

PROCEDURE remove_sample_app (v_security_group_id IN NUMBER);

PROCEDURE create_tables (v_owner IN VARCHAR2);

PROCEDURE remove_tables (v_owner IN VARCHAR2);

PROCEDURE populate_tables (v_owner IN VARCHAR2, v_security_group_id IN NUMBER, v_flow_id IN NUMBER);

procedure load_product_info (v_owner IN VARCHAR2, v_flow_id NUMBER);

END wwv_flow_sample_app;
/
show errors