prompt Package wsgapt...

create or replace package WSGAPT is

--------------------------------------------------------------------------------
-- Name:        WSGAPT.get_portlet_id
--
-- Description:
--
-- Returns the Id of the Portlet givens it's name.
--
-- The function looks up the Portlet name within the WSG_AVAILABLE_PORTLETS
-- to return the Id, and if the row does not exist, it inserts a row and
-- returns the new Id.
-- 
-- @param p_portlet_name    The name of the that requires the Id.
--
-- @returns                 The portlet Id.
--
--------------------------------------------------------------------------------
function get_portlet_id(p_portlet_name in varchar2)return number;
    

--------------------------------------------------------------------------------
-- Name:        WSGAPT.get_form_link_url
--
-- Description:
--
-- Returns the form URL link of the Portlet givens it's name.
--
-- The function looks up the Portlet name within the WSG_AVAILABLE_PORTLETS
-- to return the form URL link. If no data is found, then an empty varchar2
-- is returned.
-- 
-- @param p_portlet_name    The name of the that requires the form URL link.
--
--
-- @returns                 The form Link URL.
--
--------------------------------------------------------------------------------
function get_form_link_url(p_portlet_name in varchar2
                          )return varchar2;
    

--------------------------------------------------------------------------------
-- Name:        WSGAPT.register_portlet
--
-- Description:
--
-- The Procedure used on generation of a module built as a portlet to register
-- itself as an available portlet (in the WSG_AVAILABLE_PORTLETS table).
--
-- The procedure first looks up the row querying by name (using get_portlet_id())
-- and then updates the row adding the form link URL.
-- 
-- @param p_portlet_name    The name of the that requires registering.
--
-- @param p_portlet_form_link_url
--                          The form URL link associated with the portlet.
--
--
--------------------------------------------------------------------------------                          
procedure register_portlet(p_portlet_name in varchar2,
                                p_portlet_form_link_url in varchar2 default null);
                                
                                                          
end WSGAPT;
/
show errors