[Home] [Help]
PACKAGE: APPS.EGO_DOM_SECURITY_PVT
Source
1 PACKAGE ego_dom_security_pvt AS
2 /* $Header: EGODMSCS.pls 120.5 2006/09/20 13:20:38 sabatra noship $ */
3 /*---------------------------------------------------------------------------+
4 | This package contains APIs to resolve docuemnt security |
5 | based on data security |
6 +---------------------------------------------------------------------------*/
7 G_PKG_NAME CONSTANT VARCHAR2(30):= 'EGO_DOM_SECURITY_PVT';
8
9 TYPE grantee_rec IS RECORD
10 (
11 grantee_name VARCHAR2(80),
12 grantee_type VARCHAR2(30),
13 role_name VARCHAR2(30),
14 role_display_name VARCHAR2(80),
15 default_access VARCHAR2(50)
16 );
17 TYPE grantees_tbl_type IS TABLE OF grantee_rec INDEX BY BINARY_INTEGER;
18
19 --------------------------------------------------------------
20 PROCEDURE Get_Users
21 (
22 p_api_version IN NUMBER,
23 p_entity_name IN VARCHAR2,
24 p_pk1_value IN VARCHAR2,
25 p_pk2_value IN VARCHAR2,
26 p_pk3_value IN VARCHAR2,
27 p_pk4_value IN VARCHAR2,
28 p_pk5_value IN VARCHAR2,
29 p_role_name IN VARCHAR2 DEFAULT NULL,
30 x_grantee_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
31 x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
32 x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
33 x_role_display_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
34 x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
35 x_return_status OUT NOCOPY VARCHAR2
36 );
37 -----------------------------------------------------------------
38
39 PROCEDURE GET_VALID_INSTANCE_SET_IDS
40 (
41 p_obj_name IN VARCHAR2,
42 p_grantee_type IN VARCHAR2,
43 p_parent_obj_sql IN VARCHAR2,
44 p_bind1 IN VARCHAR2,
45 p_bind2 IN VARCHAR2,
46 p_bind3 IN VARCHAR2,
47 p_bind4 IN VARCHAR2,
48 p_bind5 IN VARCHAR2,
49 p_obj_ids IN VARCHAR2,
50 x_inst_set_ids OUT NOCOPY VARCHAR2
51 );
52 -----------------------------------------------------------------
53
54 FUNCTION Get_Default_Access
55 (
56 p_menu_id IN NUMBER
57 ) RETURN VARCHAR2;
58 -----------------------------------------------------------------
59
60 FUNCTION GET_ATTACHMENT_PRIVILAGES
61 (
62 p_entity_name IN VARCHAR2,
63 p_pk1_value IN VARCHAR2,
64 p_pk2_value IN VARCHAR2,
65 p_pk3_value IN VARCHAR2,
66 p_pk4_value IN VARCHAR2,
67 p_pk5_value IN VARCHAR2,
68 p_user_name IN VARCHAR2,
69 p_attachment_id IN NUMBER DEFAULT NULL
70 ) RETURN VARCHAR2;
71
72 -----------------------------------------------------------------
73
74
75 END EGO_DOM_SECURITY_PVT;