create or replace package odwaupld
is


-- this procedure write a JavaScript function that can be invoked to execute a SQL statement on 
-- the server
procedure js_do_sql
;
-- indicates whether for this instance of ODWA6i the upload of files has been enabled
function uploadEnabled
return boolean
;

procedure prepareNewFile
( p_session_id  in number
, p_ivid        in number
, p_filename    in varchar2
, p_description in varchar2 default null
);


procedure uplFormFrame
( p_session_id  in number
, p_ivid        in number
);

procedure uplNewFormFrame
( p_session_id  in number
, p_ivid        in number    default null
, p_error_stack in varchar2  default ''
);


procedure uplButtonFrame
( p_session_id in number
, p_ivid       in number
);

-- this procedure is used to provide an HTML document displayed in an invisible frame
-- it contains a form commandForm with an item p_command. If this item is given a value
-- and the form is submitted, the value of p_command is sent to the database and executed
-- as Dynamic SQL. The document is refreshed and contains in the header a comment as to
-- which command was most recently executed and what its result was
procedure uplCommandFrame
( p_session_id in number 
, p_ivid       in number default null
, p_command    in varchar2 default null
);

-- this procedure writes a JavaScript function that will compare p_filename to the value
-- of a the Forms item document.fileSubmitForm.file.value; if the two are different, a
-- warning is displayed and the user is asked to either Confirm or Cancel the upload operation
procedure js_validate_filename
( p_filename in varchar2
);


/*
|------------------------------------|=> odwaupld.checkIn
|  --------------------------------  |
|  | uplFormFrame                   | |
|  |                               | |
|  |                               | |
|  |-------------------------------- |
|  --------------------------------  |
|  | uplButtonFrame                 | |
|  |-------------------------------| |
|------------------------------------|
*/
procedure upload
( p_session_id in number
, p_ivid       in number  -- when null this is a first upload
);


-- this function returns the URL that is appropriate for uploading the indicated object
function url_upload
( p_ivid          in number
) return varchar2
;

-- this function will write the Javascript function to be included in the HEAD section of the HTML
-- page; this function will be called to do a upload request for object with IVID 
procedure js_upload_request
;


-- this function returns the URL that is appropriate for creating a folder
function url_create_folder
( p_parent_folder_ivid   in number
) return varchar2
;

-- this function will write the Javascript function to be included in the HEAD section of the HTML
-- page; this function will be called to do a Create Folder request 
procedure js_crefol_request
;

procedure createNewFolder
( p_session_id  in number
, p_parent_folder_ivid  in number default null
, p_workarea_irid  in number
, p_name        in varchar2
, p_description in varchar2 default null
)
;

procedure createFolderFrame
( p_session_id         in number
, p_workarea_irid         in number
, p_parent_folder_ivid in number    default null
, p_error_stack        in varchar2  default ''
);


procedure createFolder
( p_session_id         in number
, p_workarea_irid         in number
, p_parent_folder_ivid in number    default null
) 
;

end; -- odwachck
/