[Home] [Help]
PACKAGE: APPS.ENG_CHANGE_ROLES_PUB
Source
1 PACKAGE ENG_CHANGE_ROLES_PUB AUTHID CURRENT_USER AS
2 /* $Header: ENGCMRLS.pls 120.0 2005/09/15 03:35:09 sdarbha noship $ */
3
4
5 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ENG_CHANGE_ROLES_PUB';
6
7 TYPE grantee_rec IS RECORD
8 (
9 role_name VARCHAR2(30),
10 role_display_name VARCHAR2(120),
11 grantee_type VARCHAR2(30),
12 grantee_name VARCHAR2(120),
13 default_access VARCHAR2(50)
14 );
15
16 TYPE grantees_tbl_type IS TABLE OF grantee_rec INDEX BY BINARY_INTEGER;
17
18 --------------------------------------------------------------
19 PROCEDURE Get_Change_Users
20 (
21 p_api_version IN NUMBER,
22 p_entity_name IN VARCHAR2,
23 p_pk1_value IN VARCHAR2,
24 p_pk2_value IN VARCHAR2,
25 p_pk3_value IN VARCHAR2,
26 p_pk4_value IN VARCHAR2,
27 p_pk5_value IN VARCHAR2,
28 p_role_name IN VARCHAR2 DEFAULT NULL,
29 x_grantee_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
30 x_grantee_types OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
31 x_role_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
32 x_role_display_names OUT NOCOPY FND_TABLE_OF_VARCHAR2_120,
33 x_default_access OUT NOCOPY FND_TABLE_OF_VARCHAR2_30,
34 x_return_status OUT NOCOPY VARCHAR2
35 );
36 -----------------------------------------------------------------
37 PROCEDURE Get_Valid_Instance_Set_Ids
38 (
39 p_obj_name IN VARCHAR2,
40 p_grantee_type IN VARCHAR2,
41 p_parent_obj_sql IN VARCHAR2,
42 p_bind1 IN VARCHAR2,
43 p_bind2 IN VARCHAR2,
44 p_bind3 IN VARCHAR2,
45 p_bind4 IN VARCHAR2,
46 p_bind5 IN VARCHAR2,
47 p_obj_ids IN VARCHAR2,
48 x_inst_set_ids OUT NOCOPY VARCHAR2
49 );
50
51 -----------------------------------------------------------------
52 --PROCEDURE p( p_string in varchar2 );
53
54 ------------------------------------------------------------------
55 --PROCEDURE Get_Default_Access(p_menu_id IN NUMBER, p_default_access OUT VARCHAR2);
56
57 ------------------------------------------------------------------
58
59 END ENG_CHANGE_ROLES_PUB;
60