1 PACKAGE igp_user_gen_001 AS
2 /* $Header: IGSPUSAS.pls 120.0 2005/06/01 22:11:05 appldev noship $ */
3
4 /***********************************************************************************************
5 Created By : SMVK
6 Date Created By: 12-Feb-2004
7 Purpose : This package provides the facility to create adhoc user with the specified email id.
8 Also add the adhoc user to adhoc role.
9
10 Known limitations,enhancements,remarks:
11 Change History (in reverse chronological order)
12 Who When What
13 ********************************************************************************************** */
14
15
16 PROCEDURE create_role( p_adhoc_role IN OUT NOCOPY VARCHAR2,
17 p_role_dsp IN OUT NOCOPY VARCHAR2,
18 p_adhoc_user IN OUT NOCOPY VARCHAR2,
19 p_user_dsp IN OUT NOCOPY VARCHAR2,
20 p_mail_address IN VARCHAR2);
21
22 PROCEDURE check_action(itemtype IN VARCHAR2,
23 itemkey IN VARCHAR2,
24 actid IN NUMBER,
25 funcmode IN VARCHAR2,
26 resultout OUT NOCOPY VARCHAR2);
27
28 END igp_user_gen_001;