1 PACKAGE EGO_CUSTOM_SECURITY_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGOCSECS.pls 120.0.12010000.1 2009/07/23 00:28:25 ksuleman noship $ */
3
4 TYPE in_params_rec_type IS RECORD
5 (
6 object_name VARCHAR2(500)
7 ,function_name VARCHAR2(150)
8 ,instance_pk1_value VARCHAR2(150)
9 ,instance_pk2_value VARCHAR2(150)
10 ,instance_pk3_value VARCHAR2(150)
11 ,instance_pk4_value VARCHAR2(150)
12 ,instance_pk5_value VARCHAR2(150)
13 ,user_name VARCHAR2(100)
14 );
15
16
17 TYPE out_params_rec_type IS RECORD
18 (
19 user_has_function VARCHAR2(1)
20 );
21
22 -- Start of comments
23 -- API name : check_custom_security
24 -- Type : Public
25 -- Pre-reqs : None.
26 -- Function : Customized security check procudure based on information
27 -- related to user, entity, and object etc.
28 -- Parameters :
29 -- IN : p_in_params_rec IN EGO_CUSTOM_SECURITY_PUB.in_params_rec_type
30 -- Required
31 -- OUT : x_out_params_rec OUT NOCOPY EGO_CUSTOM_SECURITY_PUB.out_params_rec_type
32 -- x_out_params_rec.user_has_function = 'T' if user has proper previlege
33 -- 'F' if user has no previlege
34 -- 'U' if there are unexpected errors
35 -- Oracle API Standard Parameters :
36 -- IN : p_api_version IN NUMBER Required
37 -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
38 -- Optional
39 -- p_commit IN VARCHAR2 default FND_API.G_FALSE
40 -- Optional
41 -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
42 -- Optional
43 -- OUT : x_return_status OUT VARCHAR2(1)
44 -- x_msg_count OUT NUMBER
45 -- x_msg_data OUT VARCHAR2(2000)
46 --
47 -- Version : Current version 1.0
48 -- Previous version N/A
49 -- Initial version 1.0
50 --
51 -- End of comments
52 PROCEDURE check_custom_security
53 (
54 --program parameters
55 p_in_params_rec IN EGO_CUSTOM_SECURITY_PUB.in_params_rec_type
56 ,x_out_params_rec OUT NOCOPY EGO_CUSTOM_SECURITY_PUB.out_params_rec_type
57
58 --standard parameters
59 ,p_api_version IN NUMBER
60 ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
61 ,p_commit IN VARCHAR2 default FND_API.G_FALSE
62 ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68 END EGO_CUSTOM_SECURITY_PUB;