DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on FND_API

Line 102: ---p_commit DEFAULT FND_API.G_FALSE

98:
99:
100:
101: ----Parameters Description for the following APIs
102: ---p_commit DEFAULT FND_API.G_FALSE
103: ---p_debug_mode default 'N'
104: ---p_source_type: 'EMPLOYEE" or 'PARTY'
105: ---p_party_id: employee_id or party_id
106: ---p_role_name: meaning column in pa_project_role_types table

Line 125: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

121: ---p_role_name,p_object_name,,p_object_key_type,p_object_key,p_party_id,p_source_type.
122: ---no matter what the start_date is.
123: PROCEDURE grant_org_authority
124: (
125: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: p_debug_mode in varchar2 default 'N',
127: p_project_role_id IN number,
128: p_menu_name in varchar2,
129: p_object_name IN VARCHAR2,

Line 144: p_commit IN VARCHAR2 := FND_API.G_FALSE,

140: );
141:
142: PROCEDURE grant_role
143: (
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_debug_mode in varchar2 default 'N',
146: p_project_role_id IN number,
147: p_object_name IN VARCHAR2,
148: p_instance_type IN VARCHAR2,

Line 160: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

156: );
157:
158: PROCEDURE revoke_grant
159: (
160: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
161: p_debug_mode in varchar2 default 'N',
162: p_grant_guid in raw,
163: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
164: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 171: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

167:
168:
169: PROCEDURE revoke_role
170: (
171: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
172: p_debug_mode in varchar2 default 'N',
173: p_project_role_id IN number,
174: p_menu_name in varchar2,
175: p_object_name IN VARCHAR2,

Line 187: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

183: );
184:
185: -- obsolete API
186: PROCEDURE update_role
187: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
188: p_debug_mode in varchar2 default 'N',
189: p_grant_guid in raw,
190: p_project_role_id_old IN number default null,
191: p_object_name_old IN VARCHAR2 default null,

Line 206: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

202: );
203:
204: PROCEDURE lock_grant
205: (
206: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
207: p_debug_mode in varchar2 default 'N',
208: p_grant_guid in raw,
209: p_project_role_id_old IN number default null,
210: p_object_name_old IN VARCHAR2 default null,

Line 301: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

297:
298: -- This API is called when the default Menu is changed
299: -- in Roles form for existing roles which are in use.
300: PROCEDURE update_menu
301: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: p_debug_mode in varchar2 default 'N',
303: p_project_role_id IN number,
304: p_menu_id IN number,
305: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 313: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

309:
310: -- This API is called when Enforce Role-based Security checkbox
311: -- is unchecked in Roles form for existing roles which are in use.
312: PROCEDURE revoke_role_based_sec
313: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_debug_mode in varchar2 default 'N',
315: p_project_role_id IN number,
316: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
317: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 324: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

320:
321: -- This API is called when Enforce Role-based Security checkbox
322: -- is checked in Roles form for existing roles which are in use.
323: PROCEDURE grant_role_based_sec
324: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
325: p_debug_mode in varchar2 default 'N',
326: p_project_role_id IN number,
327: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
328: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 335: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

331:
332: -- This API is called when Status Level is changed
333: -- in Roles form for existing roles which are in use.
334: PROCEDURE revoke_status_based_sec
335: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
336: p_debug_mode in varchar2 default 'N',
337: p_project_role_id IN number,
338: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
339: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 346: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

342:
343: -- This API is called when status/menu under Project Status is changed
344: -- in Roles form for existing roles which are in use.
345: PROCEDURE update_status_based_sec
346: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
347: p_debug_mode in varchar2 default 'N',
348: p_project_role_id IN number,
349: p_status_level IN pa_project_role_types_b.status_level%TYPE,
350: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,