create or replace package odwachck
is

-- this function returns the Workarea in which p_ivid is checked out
function get_co_wa
( p_ivid in number
) return number
;

procedure doCheckOut
( p_session_id in number
, p_ivid       in number
, p_lock       in varchar2 default ''
, checkNotes   in varchar2
, p_download    in varchar2  default 'N'
);



procedure coFormFrame
( p_session_id  in number
, p_ivid        in number
, p_lock        in varchar2  default ''
, checkNotes    in varchar2  default ''
, p_error_stack in varchar2  default ''
);

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


/*
|------------------------------------|=> odwachck.checkOut
|  --------------------------------  |
|  | coFormFrame                   | |
|  |                               | |
|  |                               | |
|  |-------------------------------- |
|  --------------------------------  |
|  | coButtonFrame                 | |
|  |-------------------------------| |
|------------------------------------|
*/
-- this procedure defines an HTML document with two frames
procedure checkout 
( p_session_id in number
, p_ivid       in number
);

procedure doUndoCheckOut
( p_session_id in number
, p_ivid       in number
, p_download   in varchar2 default 'N'
);

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




function url_checkout
( p_ivid          in number
) return varchar2
;

-- this function returns the URL that is appropriate for undo the check out of the indicated object
function url_undoCheckout
( 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 checkout request for object with IVID 
procedure js_undocheckout_request
;
-- 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 checkout request for object with IVID 
procedure js_checkout_request;



end; -- odwachck
/