1 package ARI_SELF_SERVICE_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARISSPGS.pls 120.1.12020000.2 2012/11/22 20:45:25 melapaku ship $ */
3
4 FUNCTION CheckResponsibilityExist(p_user_id in number,
5 p_responsibility_id in number,
6 p_resp_appl_id in number,
7 p_security_group_id in number default null) return varchar2;
8 PROCEDURE AssignResponsibility(p_user_id in number,
9 p_responsibility_id in number,
10 p_resp_appl_id in number,
11 p_security_group_id in number default null);
12
13 PROCEDURE LogAccessRequest(p_reg_request_id IN OUT NOCOPY NUMBER,
14 p_reg_service_code IN VARCHAR2 ) ;
15
16 FUNCTION ValidateLogin(
17 p_user IN VARCHAR2,
18 p_pwd IN VARCHAR2,
19 p_disable in varchar2) return VARCHAR2;
20
21 END ARI_SELF_SERVICE_PKG;