DBA Data[Home] [Help]

PACKAGE: APPS.PER_DELETE_UNWANTED_SEC_PROF

Source


1 package per_delete_unwanted_sec_prof AUTHID CURRENT_USER as
2 /* $Header: perdelsp.pkh 120.1.12020000.1 2012/07/04 11:25:40 sclakkar noship $ */
3   PROCEDURE concurrent_process
4     (errbuf                  IN OUT NOCOPY varchar2
5     ,retcode                 IN OUT NOCOPY number
6     ,p_report                IN            varchar2                                         DEFAULT 'Y'
7     ,p_del_all_sec_profile   IN            varchar2                                         DEFAULT NULL
8     ,p_security_profile_name IN            per_security_profiles.security_profile_name%TYPE DEFAULT NULL);
9 
10   PROCEDURE show_unwanted_sec_prof;
11 
12   PROCEDURE del_sec_prof
13     (p_strong_delete       IN varchar2
14     ,p_security_profile_id IN per_security_profiles.security_profile_id%TYPE);
15 
16   PROCEDURE strong_delete_sec_prof
17     (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE);
18 
19   PROCEDURE del_all_unwanted_sec_prof
20     (p_strong_delete IN varchar2 DEFAULT 'N');
21 
22   FUNCTION check_unwanted_sec_prof
23     (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) RETURN varchar2;
24 END per_delete_unwanted_sec_prof;