[Home] [Help]
PACKAGE: APPS.IGS_SC_GRANTS_PVT
Source
1 PACKAGE IGS_SC_GRANTS_PVT AS
2 /* $Header: IGSSC01S.pls 120.1 2005/07/22 07:03:24 appldev ship $ */
3
4 /******************************************************************
5
6 Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
7 All rights reserved.
8
9 Created By : Arkadi Tereshenkov
10
11 Date Created By : Oct-01-2002
12
13 Purpose : Grant processing package
14
15 remarks : None
16
17 Change History
18
19 Who When What
20 -----------------------------------------------------------
21 Arkadi Tereshenkov Apr-10-2002 New Package created.
22
23 ******************************************************************/
24
25
26
27 -- ------------------------------------------------------------------
28 -- Main procedure
29 -- ------------------------------------------------------------------
30 PROCEDURE generate_grant(
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35 p_object_name IN VARCHAR2,
36 p_function_type IN VARCHAR2,
37 x_where_clause OUT NOCOPY VARCHAR2,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE construct_grant(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46 p_commit IN VARCHAR2 := FND_API.G_FALSE,
47 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
48 p_grant_id IN NUMBER,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54
55 FUNCTION generate_grant(
56 p_object_name IN VARCHAR2,
57 p_function_type IN VARCHAR2
58 ) RETURN VARCHAR2;
59
60
61 -- PRAGMA RESTRICT_REFERENCES(generate_grant,WNDS);
62
63 PROCEDURE set_ctx(
64 p_name VARCHAR2,
65 p_val VARCHAR2
66 );
67
68
69 PROCEDURE populate_user_attrib(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72 p_commit IN VARCHAR2 := FND_API.G_FALSE,
73 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
74 p_attrib_id IN NUMBER := NULL,
75 p_user_id IN NUMBER := NULL,
76 p_all_attribs IN VARCHAR2 :='N',
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82
83 PROCEDURE unlock_all_grants(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
88 p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
89 p_disable_security IN VARCHAR2 := FND_API.G_FALSE,
90 p_obj_group_id IN NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2
94 );
95
96 PROCEDURE lock_all_grants(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99 p_commit IN VARCHAR2 := FND_API.G_FALSE,
100 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
101 p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
102 p_obj_group_id IN NUMBER,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108
109
110 -- Returns current user id for attribute generation function
111 FUNCTION get_current_user
112 RETURN NUMBER;
113
114 -- Returns current party id for attribute generation function
115 FUNCTION get_current_party
116 RETURN NUMBER;
117
118 --Check if admin mode enabled for the curretn installation
119 FUNCTION admin_mode
120 RETURN VARCHAR2;
121
122 PROCEDURE Generate_Message;
123
124 FUNCTION check_grant_text (
125 p_table_name VARCHAR2,
126 p_select_text VARCHAR2)
127 RETURN BOOLEAN;
128
129 PROCEDURE run_diagnostic(
130 p_dirpath IN VARCHAR2,
131 p_file_name IN VARCHAR2,
132 p_log_level IN VARCHAR2,
133 p_user_id IN NUMBER := -1,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139
140 FUNCTION check_attrib_text (
141 p_table_name VARCHAR2,
142 p_select_text VARCHAR2,
143 p_obj_attrib_type VARCHAR2 )
144
145 RETURN BOOLEAN ;
146
147 FUNCTION getBodmasCondition(p_cond VARCHAR2) RETURN VARCHAR2;
148
149
150 END IGS_SC_GRANTS_PVT;