eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_USER_PVT dependencies on FND_API

Line 106: G_ADMINISTRTOR_ID NUMBER := FND_API.G_MISS_NUM;

102: G_RESOURCE_CATEGORY CONSTANT VARCHAR2(30) := 'EMPLOYEE';
103:
104: G_ADMINISTRTOR_NAME CONSTANT VARCHAR2(30) := 'MES Administrator';
105: G_ADMINISTRTOR_CODE CONSTANT VARCHAR2(30) := 'MES_ADMIN';
106: G_ADMINISTRTOR_ID NUMBER := FND_API.G_MISS_NUM;
107:
108: G_CAN_PUBLISH_NAME CONSTANT VARCHAR2(30) := 'MES publish content';
109: G_CAN_PUBLISH_CODE CONSTANT VARCHAR2(30) := 'MES_PUBLISH';
110: G_CAN_PUBLISH_ID NUMBER := FND_API.G_MISS_NUM;

Line 110: G_CAN_PUBLISH_ID NUMBER := FND_API.G_MISS_NUM;

106: G_ADMINISTRTOR_ID NUMBER := FND_API.G_MISS_NUM;
107:
108: G_CAN_PUBLISH_NAME CONSTANT VARCHAR2(30) := 'MES publish content';
109: G_CAN_PUBLISH_CODE CONSTANT VARCHAR2(30) := 'MES_PUBLISH';
110: G_CAN_PUBLISH_ID NUMBER := FND_API.G_MISS_NUM;
111:
112: G_CAN_APPROVE_NAME CONSTANT VARCHAR2(30) := 'MES approve content';
113: G_CAN_APPROVE_CODE CONSTANT VARCHAR2(30) := 'MES_APPROVE';
114: G_CAN_APPROVE_ID NUMBER := FND_API.G_MISS_NUM;

Line 114: G_CAN_APPROVE_ID NUMBER := FND_API.G_MISS_NUM;

110: G_CAN_PUBLISH_ID NUMBER := FND_API.G_MISS_NUM;
111:
112: G_CAN_APPROVE_NAME CONSTANT VARCHAR2(30) := 'MES approve content';
113: G_CAN_APPROVE_CODE CONSTANT VARCHAR2(30) := 'MES_APPROVE';
114: G_CAN_APPROVE_ID NUMBER := FND_API.G_MISS_NUM;
115:
116: G_CAN_SETUP_CHANNEL_NAME CONSTANT VARCHAR2(30) := 'MES setup channel';
117: G_CAN_SETUP_CHANNEL_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_CHANNEL';
118: G_CAN_SETUP_CHANNEL_ID NUMBER := FND_API.G_MISS_NUM;

Line 118: G_CAN_SETUP_CHANNEL_ID NUMBER := FND_API.G_MISS_NUM;

114: G_CAN_APPROVE_ID NUMBER := FND_API.G_MISS_NUM;
115:
116: G_CAN_SETUP_CHANNEL_NAME CONSTANT VARCHAR2(30) := 'MES setup channel';
117: G_CAN_SETUP_CHANNEL_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_CHANNEL';
118: G_CAN_SETUP_CHANNEL_ID NUMBER := FND_API.G_MISS_NUM;
119:
120: G_CAN_SETUP_CATEGORY_NAME CONSTANT VARCHAR2(30) := 'MES setup category';
121: G_CAN_SETUP_CATEGORY_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_CATEGORY';
122: G_CAN_SETUP_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM;

Line 122: G_CAN_SETUP_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM;

118: G_CAN_SETUP_CHANNEL_ID NUMBER := FND_API.G_MISS_NUM;
119:
120: G_CAN_SETUP_CATEGORY_NAME CONSTANT VARCHAR2(30) := 'MES setup category';
121: G_CAN_SETUP_CATEGORY_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_CATEGORY';
122: G_CAN_SETUP_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM;
123:
124: G_CAN_SETUP_DIST_NAME CONSTANT VARCHAR2(30) := 'MES setup distribution rule';
125: G_CAN_SETUP_DIST_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_DIST_RULE';
126: G_CAN_SETUP_DIST_ID NUMBER := FND_API.G_MISS_NUM;

Line 126: G_CAN_SETUP_DIST_ID NUMBER := FND_API.G_MISS_NUM;

122: G_CAN_SETUP_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM;
123:
124: G_CAN_SETUP_DIST_NAME CONSTANT VARCHAR2(30) := 'MES setup distribution rule';
125: G_CAN_SETUP_DIST_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_DIST_RULE';
126: G_CAN_SETUP_DIST_ID NUMBER := FND_API.G_MISS_NUM;
127:
128: -- Begin : Territory Integration
129: -- 06/30/2000 svatsa
130: G_CAN_SETUP_TERRITORY_NAME CONSTANT VARCHAR2(30) := 'MES publish territory';

Line 132: G_CAN_SETUP_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM;

128: -- Begin : Territory Integration
129: -- 06/30/2000 svatsa
130: G_CAN_SETUP_TERRITORY_NAME CONSTANT VARCHAR2(30) := 'MES publish territory';
131: G_CAN_SETUP_TERRITORY_CODE CONSTANT VARCHAR2(30) := 'MES_PUBLISH_TERRITORY';
132: G_CAN_SETUP_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM;
133: -- End : Territory Integration
134: --
135: G_GROUP_ARC_TYPE CONSTANT VARCHAR2(30) := 'GROUP';
136: G_USER_ARC_TYPE CONSTANT VARCHAR2(30) := 'USER';

Line 228: -- Default = FND_API.G_FALSE

224: -- Function : Get the resource id based on the passed user id.
225: -- Parameters :
226: -- IN p_api_version NUMBER Required
227: -- p_init_msg_list VARCHAR2 Optional
228: -- Default = FND_API.G_FALSE
229: -- p_validation_level NUMBER Optional
230: -- Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_check_login_user VARCHAR2 Optional
232: -- Default = FND_API.G_TRUE

Line 230: -- Default = FND_API.G_VALID_LEVEL_FULL

226: -- IN p_api_version NUMBER Required
227: -- p_init_msg_list VARCHAR2 Optional
228: -- Default = FND_API.G_FALSE
229: -- p_validation_level NUMBER Optional
230: -- Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_check_login_user VARCHAR2 Optional
232: -- Default = FND_API.G_TRUE
233: -- Flag for checking user privilege and if user is login.
234: -- p_user_id NUMBER Optional

Line 232: -- Default = FND_API.G_TRUE

228: -- Default = FND_API.G_FALSE
229: -- p_validation_level NUMBER Optional
230: -- Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_check_login_user VARCHAR2 Optional
232: -- Default = FND_API.G_TRUE
233: -- Flag for checking user privilege and if user is login.
234: -- p_user_id NUMBER Optional
235: -- Default = FND_API.G_MISS_NUM
236: -- If default, use the current(login) user id

Line 235: -- Default = FND_API.G_MISS_NUM

231: -- p_check_login_user VARCHAR2 Optional
232: -- Default = FND_API.G_TRUE
233: -- Flag for checking user privilege and if user is login.
234: -- p_user_id NUMBER Optional
235: -- Default = FND_API.G_MISS_NUM
236: -- If default, use the current(login) user id
237: -- OUT : x_return_status VARCHAR2
238: -- x_msg_count NUMBER
239: -- x_msg_data VARCHAR2

Line 251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

247: --------------------------------------------------------------------------------
248: PROCEDURE Get_ResourceId
249: (
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,

Line 252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

248: PROCEDURE Get_ResourceId
249: (
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
256: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 256: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
256: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
257: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
258: x_resource_id OUT NOCOPY NUMBER
259: );
260: --------------------------------------------------------------------------------

Line 257: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
256: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
257: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
258: x_resource_id OUT NOCOPY NUMBER
259: );
260: --------------------------------------------------------------------------------
261: -- Start of comments

Line 269: -- Default = FND_API.G_FALSE

265: -- Function : Find resource given the search criteria.
266: -- Parameters :
267: -- IN p_api_version NUMBER Required
268: -- p_init_msg_list VARCHAR2 Optional
269: -- Default = FND_API.G_FALSE
270: -- p_validation_level NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_FULL
272: -- p_check_login_user VARCHAR2 Optional
273: -- Default = FND_API.G_TRUE

Line 271: -- Default = FND_API.G_VALID_LEVEL_FULL

267: -- IN p_api_version NUMBER Required
268: -- p_init_msg_list VARCHAR2 Optional
269: -- Default = FND_API.G_FALSE
270: -- p_validation_level NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_FULL
272: -- p_check_login_user VARCHAR2 Optional
273: -- Default = FND_API.G_TRUE
274: -- Flag for checking user privilege and if user is login.
275: -- p_group_id NUMBER Optional

Line 273: -- Default = FND_API.G_TRUE

269: -- Default = FND_API.G_FALSE
270: -- p_validation_level NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_FULL
272: -- p_check_login_user VARCHAR2 Optional
273: -- Default = FND_API.G_TRUE
274: -- Flag for checking user privilege and if user is login.
275: -- p_group_id NUMBER Optional
276: -- default FND_API.G_MISS_NUM
277: -- p_check_effective_date VARCHAR2 Optional

Line 276: -- default FND_API.G_MISS_NUM

272: -- p_check_login_user VARCHAR2 Optional
273: -- Default = FND_API.G_TRUE
274: -- Flag for checking user privilege and if user is login.
275: -- p_group_id NUMBER Optional
276: -- default FND_API.G_MISS_NUM
277: -- p_check_effective_date VARCHAR2 Optional
278: -- default FND_API.G_TRUE
279: -- p_user_name VARCHAR2 Optional
280: -- default = FND_API.G_MISS_CHAR

Line 278: -- default FND_API.G_TRUE

274: -- Flag for checking user privilege and if user is login.
275: -- p_group_id NUMBER Optional
276: -- default FND_API.G_MISS_NUM
277: -- p_check_effective_date VARCHAR2 Optional
278: -- default FND_API.G_TRUE
279: -- p_user_name VARCHAR2 Optional
280: -- default = FND_API.G_MISS_CHAR
281: -- p_last_name VARCHAR2 Optional
282: -- default = FND_API.G_MISS_CHAR

Line 280: -- default = FND_API.G_MISS_CHAR

276: -- default FND_API.G_MISS_NUM
277: -- p_check_effective_date VARCHAR2 Optional
278: -- default FND_API.G_TRUE
279: -- p_user_name VARCHAR2 Optional
280: -- default = FND_API.G_MISS_CHAR
281: -- p_last_name VARCHAR2 Optional
282: -- default = FND_API.G_MISS_CHAR
283: -- p_first_name VARCHAR2 Optional
284: -- default = FND_API.G_MISS_CHAR

Line 282: -- default = FND_API.G_MISS_CHAR

278: -- default FND_API.G_TRUE
279: -- p_user_name VARCHAR2 Optional
280: -- default = FND_API.G_MISS_CHAR
281: -- p_last_name VARCHAR2 Optional
282: -- default = FND_API.G_MISS_CHAR
283: -- p_first_name VARCHAR2 Optional
284: -- default = FND_API.G_MISS_CHAR
285: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
286: -- Required.

Line 284: -- default = FND_API.G_MISS_CHAR

280: -- default = FND_API.G_MISS_CHAR
281: -- p_last_name VARCHAR2 Optional
282: -- default = FND_API.G_MISS_CHAR
283: -- p_first_name VARCHAR2 Optional
284: -- default = FND_API.G_MISS_CHAR
285: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
286: -- Required.
287: -- OUT : x_return_status VARCHAR2
288: -- x_msg_count NUMBER

Line 301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

297: --
298: PROCEDURE Find_Resource
299: (
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,

Line 302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

298: PROCEDURE Find_Resource
299: (
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 306: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
307: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
308: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
309: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 307: p_group_id IN NUMBER := FND_API.G_MISS_NUM,

303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
307: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
308: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
309: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 308: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,

304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
307: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
308: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
309: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,

Line 309: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
307: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
308: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
309: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
313: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 310: p_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

306: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
307: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
308: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
309: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
313: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
314: x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY

Line 311: p_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

307: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
308: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
309: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
313: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
314: x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY
315: );

Line 326: -- Default = FND_API.G_FALSE

322: -- Function : Find resource given the search criteria.
323: -- Parameters :
324: -- IN p_api_version NUMBER Required
325: -- p_init_msg_list VARCHAR2 Optional
326: -- Default = FND_API.G_FALSE
327: -- p_validation_level NUMBER Optional
328: -- Default = FND_API.G_VALID_LEVEL_FULL
329: -- p_check_login_user VARCHAR2 Optional
330: -- Default = FND_API.G_TRUE

Line 328: -- Default = FND_API.G_VALID_LEVEL_FULL

324: -- IN p_api_version NUMBER Required
325: -- p_init_msg_list VARCHAR2 Optional
326: -- Default = FND_API.G_FALSE
327: -- p_validation_level NUMBER Optional
328: -- Default = FND_API.G_VALID_LEVEL_FULL
329: -- p_check_login_user VARCHAR2 Optional
330: -- Default = FND_API.G_TRUE
331: -- Flag for checking user privilege and if user is login.
332: -- p_group_id NUMBER Optional

Line 330: -- Default = FND_API.G_TRUE

326: -- Default = FND_API.G_FALSE
327: -- p_validation_level NUMBER Optional
328: -- Default = FND_API.G_VALID_LEVEL_FULL
329: -- p_check_login_user VARCHAR2 Optional
330: -- Default = FND_API.G_TRUE
331: -- Flag for checking user privilege and if user is login.
332: -- p_group_id NUMBER Optional
333: -- default FND_API.G_MISS_NUM
334: -- p_check_effective_date VARCHAR2 Optional

Line 333: -- default FND_API.G_MISS_NUM

329: -- p_check_login_user VARCHAR2 Optional
330: -- Default = FND_API.G_TRUE
331: -- Flag for checking user privilege and if user is login.
332: -- p_group_id NUMBER Optional
333: -- default FND_API.G_MISS_NUM
334: -- p_check_effective_date VARCHAR2 Optional
335: -- default FND_API.G_TRUE
336: -- p_user_name VARCHAR2 Optional
337: -- default = FND_API.G_MISS_CHAR

Line 335: -- default FND_API.G_TRUE

331: -- Flag for checking user privilege and if user is login.
332: -- p_group_id NUMBER Optional
333: -- default FND_API.G_MISS_NUM
334: -- p_check_effective_date VARCHAR2 Optional
335: -- default FND_API.G_TRUE
336: -- p_user_name VARCHAR2 Optional
337: -- default = FND_API.G_MISS_CHAR
338: -- p_last_name VARCHAR2 Optional
339: -- default = FND_API.G_MISS_CHAR

Line 337: -- default = FND_API.G_MISS_CHAR

333: -- default FND_API.G_MISS_NUM
334: -- p_check_effective_date VARCHAR2 Optional
335: -- default FND_API.G_TRUE
336: -- p_user_name VARCHAR2 Optional
337: -- default = FND_API.G_MISS_CHAR
338: -- p_last_name VARCHAR2 Optional
339: -- default = FND_API.G_MISS_CHAR
340: -- p_first_name VARCHAR2 Optional
341: -- default = FND_API.G_MISS_CHAR

Line 339: -- default = FND_API.G_MISS_CHAR

335: -- default FND_API.G_TRUE
336: -- p_user_name VARCHAR2 Optional
337: -- default = FND_API.G_MISS_CHAR
338: -- p_last_name VARCHAR2 Optional
339: -- default = FND_API.G_MISS_CHAR
340: -- p_first_name VARCHAR2 Optional
341: -- default = FND_API.G_MISS_CHAR
342: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
343: -- Required.

Line 341: -- default = FND_API.G_MISS_CHAR

337: -- default = FND_API.G_MISS_CHAR
338: -- p_last_name VARCHAR2 Optional
339: -- default = FND_API.G_MISS_CHAR
340: -- p_first_name VARCHAR2 Optional
341: -- default = FND_API.G_MISS_CHAR
342: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
343: -- Required.
344: -- OUT : x_return_status VARCHAR2
345: -- x_msg_count NUMBER

Line 358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

354: --
355: PROCEDURE Find_Resource
356: (
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,

Line 359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

355: PROCEDURE Find_Resource
356: (
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 363: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
364: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
365: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
367: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 364: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
364: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
365: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
367: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
368: x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY,

Line 365: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
364: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
365: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
367: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
368: x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY,
369: x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE

Line 380: -- Default = FND_API.G_FALSE

376: -- Function : Add a role to resource.
377: -- Parameters :
378: -- IN p_api_version NUMBER Required
379: -- p_init_msg_list VARCHAR2 Optional
380: -- Default = FND_API.G_FALSE
381: -- p_commit VARCHAR2 Optional
382: -- Default = FND_API.G_FALSE
383: -- p_validation_level NUMBER Optional
384: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 382: -- Default = FND_API.G_FALSE

378: -- IN p_api_version NUMBER Required
379: -- p_init_msg_list VARCHAR2 Optional
380: -- Default = FND_API.G_FALSE
381: -- p_commit VARCHAR2 Optional
382: -- Default = FND_API.G_FALSE
383: -- p_validation_level NUMBER Optional
384: -- Default = FND_API.G_VALID_LEVEL_FULL
385: -- p_check_login_user VARCHAR2 Optional
386: -- Default = FND_API.G_TRUE

Line 384: -- Default = FND_API.G_VALID_LEVEL_FULL

380: -- Default = FND_API.G_FALSE
381: -- p_commit VARCHAR2 Optional
382: -- Default = FND_API.G_FALSE
383: -- p_validation_level NUMBER Optional
384: -- Default = FND_API.G_VALID_LEVEL_FULL
385: -- p_check_login_user VARCHAR2 Optional
386: -- Default = FND_API.G_TRUE
387: -- Flag for checking user privilege and if user is login.
388: -- p_resource_id NUMBER Required

Line 386: -- Default = FND_API.G_TRUE

382: -- Default = FND_API.G_FALSE
383: -- p_validation_level NUMBER Optional
384: -- Default = FND_API.G_VALID_LEVEL_FULL
385: -- p_check_login_user VARCHAR2 Optional
386: -- Default = FND_API.G_TRUE
387: -- Flag for checking user privilege and if user is login.
388: -- p_resource_id NUMBER Required
389: -- the id of the resource
390: -- p_role_id NUMBER Optional

Line 391: -- Default FND_API.G_MISS_NUM

387: -- Flag for checking user privilege and if user is login.
388: -- p_resource_id NUMBER Required
389: -- the id of the resource
390: -- p_role_id NUMBER Optional
391: -- Default FND_API.G_MISS_NUM
392: -- p_role_code VARCHAR2 Optional
393: -- Default FND_API.G_MISS_CHAR
394: -- OUT : x_return_status VARCHAR2
395: -- x_msg_count NUMBER

Line 393: -- Default FND_API.G_MISS_CHAR

389: -- the id of the resource
390: -- p_role_id NUMBER Optional
391: -- Default FND_API.G_MISS_NUM
392: -- p_role_code VARCHAR2 Optional
393: -- Default FND_API.G_MISS_CHAR
394: -- OUT : x_return_status VARCHAR2
395: -- x_msg_count NUMBER
396: -- x_msg_data VARCHAR2
397: -- Version : Current version 1.0

Line 406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

402: --
403: PROCEDURE Add_ResourceRole
404: (
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_commit IN VARCHAR2 := FND_API.G_FALSE,
408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,

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

403: PROCEDURE Add_ResourceRole
404: (
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_commit IN VARCHAR2 := FND_API.G_FALSE,
408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,

Line 408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

404: (
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_commit IN VARCHAR2 := FND_API.G_FALSE,
408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,
412: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 412: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,
412: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
413: p_resource_id IN NUMBER,
414: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
415: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
416: );

Line 414: p_role_id IN NUMBER := FND_API.G_MISS_NUM,

410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,
412: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
413: p_resource_id IN NUMBER,
414: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
415: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
416: );
417: --
418: --------------------------------------------------------------------------------

Line 415: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR

411: x_msg_data OUT NOCOPY VARCHAR2,
412: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
413: p_resource_id IN NUMBER,
414: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
415: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
416: );
417: --
418: --------------------------------------------------------------------------------
419: -- Start of comments

Line 427: -- Default = FND_API.G_FALSE

423: -- Function : Add several roles to a resource.
424: -- Parameters :
425: -- IN p_api_version NUMBER Required
426: -- p_init_msg_list VARCHAR2 Optional
427: -- Default = FND_API.G_FALSE
428: -- p_commit VARCHAR2 Optional
429: -- Default = FND_API.G_FALSE
430: -- p_validation_level NUMBER Optional
431: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 429: -- Default = FND_API.G_FALSE

425: -- IN p_api_version NUMBER Required
426: -- p_init_msg_list VARCHAR2 Optional
427: -- Default = FND_API.G_FALSE
428: -- p_commit VARCHAR2 Optional
429: -- Default = FND_API.G_FALSE
430: -- p_validation_level NUMBER Optional
431: -- Default = FND_API.G_VALID_LEVEL_FULL
432: -- p_check_login_user VARCHAR2 Optional
433: -- Default = FND_API.G_TRUE

Line 431: -- Default = FND_API.G_VALID_LEVEL_FULL

427: -- Default = FND_API.G_FALSE
428: -- p_commit VARCHAR2 Optional
429: -- Default = FND_API.G_FALSE
430: -- p_validation_level NUMBER Optional
431: -- Default = FND_API.G_VALID_LEVEL_FULL
432: -- p_check_login_user VARCHAR2 Optional
433: -- Default = FND_API.G_TRUE
434: -- Flag for checking user privilege and if user is login.
435: -- p_resource_id NUMBER Required

Line 433: -- Default = FND_API.G_TRUE

429: -- Default = FND_API.G_FALSE
430: -- p_validation_level NUMBER Optional
431: -- Default = FND_API.G_VALID_LEVEL_FULL
432: -- p_check_login_user VARCHAR2 Optional
433: -- Default = FND_API.G_TRUE
434: -- Flag for checking user privilege and if user is login.
435: -- p_resource_id NUMBER Required
436: -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
437: -- array of role ids. Required

Line 450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

446: --
447: PROCEDURE Add_ResourceRole
448: (
449: p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,

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

447: PROCEDURE Add_ResourceRole
448: (
449: p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,

Line 452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

448: (
449: p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 456: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
457: p_resource_id IN NUMBER,
458: p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
459: );
460: --------------------------------------------------------------------------------

Line 469: -- Default = FND_API.G_FALSE

465: -- Function : Remove a role from a resource.
466: -- Parameters :
467: -- IN p_api_version NUMBER Required
468: -- p_init_msg_list VARCHAR2 Optional
469: -- Default = FND_API.G_FALSE
470: -- p_commit VARCHAR2 Optional
471: -- Default = FND_API.G_FALSE
472: -- p_validation_level NUMBER Optional
473: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 471: -- Default = FND_API.G_FALSE

467: -- IN p_api_version NUMBER Required
468: -- p_init_msg_list VARCHAR2 Optional
469: -- Default = FND_API.G_FALSE
470: -- p_commit VARCHAR2 Optional
471: -- Default = FND_API.G_FALSE
472: -- p_validation_level NUMBER Optional
473: -- Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_check_login_user VARCHAR2 Optional
475: -- Default = FND_API.G_TRUE

Line 473: -- Default = FND_API.G_VALID_LEVEL_FULL

469: -- Default = FND_API.G_FALSE
470: -- p_commit VARCHAR2 Optional
471: -- Default = FND_API.G_FALSE
472: -- p_validation_level NUMBER Optional
473: -- Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_check_login_user VARCHAR2 Optional
475: -- Default = FND_API.G_TRUE
476: -- Flag for checking user privilege and if user is login.
477: -- p_resource_id NUMBER Required

Line 475: -- Default = FND_API.G_TRUE

471: -- Default = FND_API.G_FALSE
472: -- p_validation_level NUMBER Optional
473: -- Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_check_login_user VARCHAR2 Optional
475: -- Default = FND_API.G_TRUE
476: -- Flag for checking user privilege and if user is login.
477: -- p_resource_id NUMBER Required
478: -- p_role_id NUMBER Optional
479: -- Default FND_API.G_MISS_NUM

Line 479: -- Default FND_API.G_MISS_NUM

475: -- Default = FND_API.G_TRUE
476: -- Flag for checking user privilege and if user is login.
477: -- p_resource_id NUMBER Required
478: -- p_role_id NUMBER Optional
479: -- Default FND_API.G_MISS_NUM
480: -- p_role_code VARCHAR2 Optional
481: -- Default FND_API.G_MISS_CHAR
482: -- OUT : x_return_status VARCHAR2
483: -- x_msg_count NUMBER

Line 481: -- Default FND_API.G_MISS_CHAR

477: -- p_resource_id NUMBER Required
478: -- p_role_id NUMBER Optional
479: -- Default FND_API.G_MISS_NUM
480: -- p_role_code VARCHAR2 Optional
481: -- Default FND_API.G_MISS_CHAR
482: -- OUT : x_return_status VARCHAR2
483: -- x_msg_count NUMBER
484: -- x_msg_data VARCHAR2
485: -- Version : Current version 1.0

Line 494: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

490: --
491: PROCEDURE Remove_ResourceRole
492: (
493: p_api_version IN NUMBER,
494: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
495: p_commit IN VARCHAR2 := FND_API.G_FALSE,
496: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
497: x_return_status OUT NOCOPY VARCHAR2,
498: x_msg_count OUT NOCOPY NUMBER,

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

491: PROCEDURE Remove_ResourceRole
492: (
493: p_api_version IN NUMBER,
494: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
495: p_commit IN VARCHAR2 := FND_API.G_FALSE,
496: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
497: x_return_status OUT NOCOPY VARCHAR2,
498: x_msg_count OUT NOCOPY NUMBER,
499: x_msg_data OUT NOCOPY VARCHAR2,

Line 496: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

492: (
493: p_api_version IN NUMBER,
494: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
495: p_commit IN VARCHAR2 := FND_API.G_FALSE,
496: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
497: x_return_status OUT NOCOPY VARCHAR2,
498: x_msg_count OUT NOCOPY NUMBER,
499: x_msg_data OUT NOCOPY VARCHAR2,
500: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 500: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

496: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
497: x_return_status OUT NOCOPY VARCHAR2,
498: x_msg_count OUT NOCOPY NUMBER,
499: x_msg_data OUT NOCOPY VARCHAR2,
500: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
501: p_resource_id IN NUMBER,
502: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
503: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
504: );

Line 502: p_role_id IN NUMBER := FND_API.G_MISS_NUM,

498: x_msg_count OUT NOCOPY NUMBER,
499: x_msg_data OUT NOCOPY VARCHAR2,
500: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
501: p_resource_id IN NUMBER,
502: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
503: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
504: );
505: --
506: --------------------------------------------------------------------------------

Line 503: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR

499: x_msg_data OUT NOCOPY VARCHAR2,
500: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
501: p_resource_id IN NUMBER,
502: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
503: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
504: );
505: --
506: --------------------------------------------------------------------------------
507: -- Start of comments

Line 515: -- Default = FND_API.G_FALSE

511: -- Function : Remove several roles from a resource.
512: -- Parameters :
513: -- IN p_api_version NUMBER Required
514: -- p_init_msg_list VARCHAR2 Optional
515: -- Default = FND_API.G_FALSE
516: -- p_commit VARCHAR2 Optional
517: -- Default = FND_API.G_FALSE
518: -- p_validation_level NUMBER Optional
519: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 517: -- Default = FND_API.G_FALSE

513: -- IN p_api_version NUMBER Required
514: -- p_init_msg_list VARCHAR2 Optional
515: -- Default = FND_API.G_FALSE
516: -- p_commit VARCHAR2 Optional
517: -- Default = FND_API.G_FALSE
518: -- p_validation_level NUMBER Optional
519: -- Default = FND_API.G_VALID_LEVEL_FULL
520: -- p_check_login_user VARCHAR2 Optional
521: -- Default = FND_API.G_TRUE

Line 519: -- Default = FND_API.G_VALID_LEVEL_FULL

515: -- Default = FND_API.G_FALSE
516: -- p_commit VARCHAR2 Optional
517: -- Default = FND_API.G_FALSE
518: -- p_validation_level NUMBER Optional
519: -- Default = FND_API.G_VALID_LEVEL_FULL
520: -- p_check_login_user VARCHAR2 Optional
521: -- Default = FND_API.G_TRUE
522: -- Flag for checking user privilege and if user is login.
523: -- Default = null

Line 521: -- Default = FND_API.G_TRUE

517: -- Default = FND_API.G_FALSE
518: -- p_validation_level NUMBER Optional
519: -- Default = FND_API.G_VALID_LEVEL_FULL
520: -- p_check_login_user VARCHAR2 Optional
521: -- Default = FND_API.G_TRUE
522: -- Flag for checking user privilege and if user is login.
523: -- Default = null
524: -- p_resource_id NUMBER Required
525: -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE

Line 538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

534: --
535: PROCEDURE Remove_ResourceRole
536: (
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
539: p_commit IN VARCHAR2 := FND_API.G_FALSE,
540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,

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

535: PROCEDURE Remove_ResourceRole
536: (
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
539: p_commit IN VARCHAR2 := FND_API.G_FALSE,
540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2,

Line 540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

536: (
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
539: p_commit IN VARCHAR2 := FND_API.G_FALSE,
540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2,
544: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 544: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2,
544: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
545: p_resource_id IN NUMBER,
546: p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE := NULL
547: );
548: --------------------------------------------------------------------------------

Line 557: -- Default = FND_API.G_FALSE

553: -- Function : Replace all the roles of a resource.
554: -- Parameters :
555: -- IN p_api_version NUMBER Required
556: -- p_init_msg_list VARCHAR2 Optional
557: -- Default = FND_API.G_FALSE
558: -- p_commit VARCHAR2 Optional
559: -- Default = FND_API.G_FALSE
560: -- p_validation_level NUMBER Optional
561: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 559: -- Default = FND_API.G_FALSE

555: -- IN p_api_version NUMBER Required
556: -- p_init_msg_list VARCHAR2 Optional
557: -- Default = FND_API.G_FALSE
558: -- p_commit VARCHAR2 Optional
559: -- Default = FND_API.G_FALSE
560: -- p_validation_level NUMBER Optional
561: -- Default = FND_API.G_VALID_LEVEL_FULL
562: -- p_check_login_user VARCHAR2 Optional
563: -- Default = FND_API.G_TRUE

Line 561: -- Default = FND_API.G_VALID_LEVEL_FULL

557: -- Default = FND_API.G_FALSE
558: -- p_commit VARCHAR2 Optional
559: -- Default = FND_API.G_FALSE
560: -- p_validation_level NUMBER Optional
561: -- Default = FND_API.G_VALID_LEVEL_FULL
562: -- p_check_login_user VARCHAR2 Optional
563: -- Default = FND_API.G_TRUE
564: -- Flag for checking user privilege and if user is login.
565: -- p_resource_id NUMBER Required

Line 563: -- Default = FND_API.G_TRUE

559: -- Default = FND_API.G_FALSE
560: -- p_validation_level NUMBER Optional
561: -- Default = FND_API.G_VALID_LEVEL_FULL
562: -- p_check_login_user VARCHAR2 Optional
563: -- Default = FND_API.G_TRUE
564: -- Flag for checking user privilege and if user is login.
565: -- p_resource_id NUMBER Required
566: -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
567: -- array of new role ids Required

Line 580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

576: --
577: PROCEDURE Replace_ResourceRole
578: (
579: p_api_version IN NUMBER,
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581: p_commit IN VARCHAR2 := FND_API.G_FALSE,
582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,

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

577: PROCEDURE Replace_ResourceRole
578: (
579: p_api_version IN NUMBER,
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581: p_commit IN VARCHAR2 := FND_API.G_FALSE,
582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,
585: x_msg_data OUT NOCOPY VARCHAR2,

Line 582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

578: (
579: p_api_version IN NUMBER,
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581: p_commit IN VARCHAR2 := FND_API.G_FALSE,
582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,
585: x_msg_data OUT NOCOPY VARCHAR2,
586: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 586: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,
585: x_msg_data OUT NOCOPY VARCHAR2,
586: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
587: p_resource_id IN NUMBER,
588: p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
589: );
590: PROCEDURE Replace_ResourceRole

Line 593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

589: );
590: PROCEDURE Replace_ResourceRole
591: (
592: p_api_version IN NUMBER,
593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594: p_commit IN VARCHAR2 := FND_API.G_FALSE,
595: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
596: x_return_status OUT NOCOPY VARCHAR2,
597: x_msg_count OUT NOCOPY NUMBER,

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

590: PROCEDURE Replace_ResourceRole
591: (
592: p_api_version IN NUMBER,
593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594: p_commit IN VARCHAR2 := FND_API.G_FALSE,
595: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
596: x_return_status OUT NOCOPY VARCHAR2,
597: x_msg_count OUT NOCOPY NUMBER,
598: x_msg_data OUT NOCOPY VARCHAR2,

Line 595: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

591: (
592: p_api_version IN NUMBER,
593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594: p_commit IN VARCHAR2 := FND_API.G_FALSE,
595: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
596: x_return_status OUT NOCOPY VARCHAR2,
597: x_msg_count OUT NOCOPY NUMBER,
598: x_msg_data OUT NOCOPY VARCHAR2,
599: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 599: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

595: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
596: x_return_status OUT NOCOPY VARCHAR2,
597: x_msg_count OUT NOCOPY NUMBER,
598: x_msg_data OUT NOCOPY VARCHAR2,
599: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
600: p_resource_id IN NUMBER,
601: p_role_code IN VARCHAR2
602: );
603: --------------------------------------------------------------------------------

Line 612: -- Default = FND_API.G_FALSE

608: -- Function : Retrieve all the roles of a resource.
609: -- Parameters :
610: -- IN p_api_version NUMBER Required
611: -- p_init_msg_list VARCHAR2 Optional
612: -- Default = FND_API.G_FALSE
613: -- p_validation_level NUMBER Optional
614: -- Default = FND_API.G_VALID_LEVEL_FULL
615: -- p_check_login_user VARCHAR2 Optional
616: -- Default = FND_API.G_TRUE

Line 614: -- Default = FND_API.G_VALID_LEVEL_FULL

610: -- IN p_api_version NUMBER Required
611: -- p_init_msg_list VARCHAR2 Optional
612: -- Default = FND_API.G_FALSE
613: -- p_validation_level NUMBER Optional
614: -- Default = FND_API.G_VALID_LEVEL_FULL
615: -- p_check_login_user VARCHAR2 Optional
616: -- Default = FND_API.G_TRUE
617: -- Flag for checking user privilege and if user is login.
618: -- p_resource_id NUMBER Optional

Line 616: -- Default = FND_API.G_TRUE

612: -- Default = FND_API.G_FALSE
613: -- p_validation_level NUMBER Optional
614: -- Default = FND_API.G_VALID_LEVEL_FULL
615: -- p_check_login_user VARCHAR2 Optional
616: -- Default = FND_API.G_TRUE
617: -- Flag for checking user privilege and if user is login.
618: -- p_resource_id NUMBER Optional
619: -- Default = FND_API.G_MISS_NUM
620: -- p_check_effective_date VARCHAR2 Optional

Line 619: -- Default = FND_API.G_MISS_NUM

615: -- p_check_login_user VARCHAR2 Optional
616: -- Default = FND_API.G_TRUE
617: -- Flag for checking user privilege and if user is login.
618: -- p_resource_id NUMBER Optional
619: -- Default = FND_API.G_MISS_NUM
620: -- p_check_effective_date VARCHAR2 Optional
621: -- default FND_API.G_TRUE
622: -- OUT : x_return_status VARCHAR2
623: -- x_msg_count NUMBER

Line 621: -- default FND_API.G_TRUE

617: -- Flag for checking user privilege and if user is login.
618: -- p_resource_id NUMBER Optional
619: -- Default = FND_API.G_MISS_NUM
620: -- p_check_effective_date VARCHAR2 Optional
621: -- default FND_API.G_TRUE
622: -- OUT : x_return_status VARCHAR2
623: -- x_msg_count NUMBER
624: -- x_msg_data VARCHAR2
625: -- x_role_id_varray AMV_NUMBER_VARRAY_TYPE

Line 636: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

632: --
633: PROCEDURE Get_ResourceRoles
634: (
635: p_api_version IN NUMBER,
636: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: x_return_status OUT NOCOPY VARCHAR2,
639: x_msg_count OUT NOCOPY NUMBER,
640: x_msg_data OUT NOCOPY VARCHAR2,

Line 637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

633: PROCEDURE Get_ResourceRoles
634: (
635: p_api_version IN NUMBER,
636: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: x_return_status OUT NOCOPY VARCHAR2,
639: x_msg_count OUT NOCOPY NUMBER,
640: x_msg_data OUT NOCOPY VARCHAR2,
641: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 641: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: x_return_status OUT NOCOPY VARCHAR2,
639: x_msg_count OUT NOCOPY NUMBER,
640: x_msg_data OUT NOCOPY VARCHAR2,
641: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
642: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
643: x_role_id_varray OUT NOCOPY AMV_NUMBER_VARRAY_TYPE,
644: x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
645: );

Line 642: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

638: x_return_status OUT NOCOPY VARCHAR2,
639: x_msg_count OUT NOCOPY NUMBER,
640: x_msg_data OUT NOCOPY VARCHAR2,
641: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
642: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
643: x_role_id_varray OUT NOCOPY AMV_NUMBER_VARRAY_TYPE,
644: x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
645: );
646: --------------------------------------------------------------------------------

Line 655: -- Default = FND_API.G_FALSE

651: -- Function : Check if the passed resource has the passed role.
652: -- Parameters :
653: -- IN p_api_version NUMBER Required
654: -- p_init_msg_list VARCHAR2 Optional
655: -- Default = FND_API.G_FALSE
656: -- p_validation_level NUMBER Optional
657: -- Default = FND_API.G_VALID_LEVEL_FULL
658: -- p_check_login_user VARCHAR2 Optional
659: -- Default = FND_API.G_TRUE

Line 657: -- Default = FND_API.G_VALID_LEVEL_FULL

653: -- IN p_api_version NUMBER Required
654: -- p_init_msg_list VARCHAR2 Optional
655: -- Default = FND_API.G_FALSE
656: -- p_validation_level NUMBER Optional
657: -- Default = FND_API.G_VALID_LEVEL_FULL
658: -- p_check_login_user VARCHAR2 Optional
659: -- Default = FND_API.G_TRUE
660: -- Flag for checking user privilege and if user is login.
661: -- p_resource_id NUMBER Optional

Line 659: -- Default = FND_API.G_TRUE

655: -- Default = FND_API.G_FALSE
656: -- p_validation_level NUMBER Optional
657: -- Default = FND_API.G_VALID_LEVEL_FULL
658: -- p_check_login_user VARCHAR2 Optional
659: -- Default = FND_API.G_TRUE
660: -- Flag for checking user privilege and if user is login.
661: -- p_resource_id NUMBER Optional
662: -- Default = FND_API.G_MISS_NUM
663: -- If MISS, check the current (login) resource).

Line 662: -- Default = FND_API.G_MISS_NUM

658: -- p_check_login_user VARCHAR2 Optional
659: -- Default = FND_API.G_TRUE
660: -- Flag for checking user privilege and if user is login.
661: -- p_resource_id NUMBER Optional
662: -- Default = FND_API.G_MISS_NUM
663: -- If MISS, check the current (login) resource).
664: -- p_role_id NUMBER Required
665: -- p_include_group_flag VARCHAR2 Optional
666: -- Default = FND_API.G_TRUE

Line 666: -- Default = FND_API.G_TRUE

662: -- Default = FND_API.G_MISS_NUM
663: -- If MISS, check the current (login) resource).
664: -- p_role_id NUMBER Required
665: -- p_include_group_flag VARCHAR2 Optional
666: -- Default = FND_API.G_TRUE
667: -- p_check_effective_date VARCHAR2 Optional
668: -- default FND_API.G_TRUE
669: -- OUT : x_return_status VARCHAR2
670: -- x_msg_count NUMBER

Line 668: -- default FND_API.G_TRUE

664: -- p_role_id NUMBER Required
665: -- p_include_group_flag VARCHAR2 Optional
666: -- Default = FND_API.G_TRUE
667: -- p_check_effective_date VARCHAR2 Optional
668: -- default FND_API.G_TRUE
669: -- OUT : x_return_status VARCHAR2
670: -- x_msg_count NUMBER
671: -- x_msg_data VARCHAR2
672: -- x_result_flag VARCHAR2

Line 682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

678: --
679: PROCEDURE Check_ResourceRole
680: (
681: p_api_version IN NUMBER,
682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
683: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,

Line 683: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

679: PROCEDURE Check_ResourceRole
680: (
681: p_api_version IN NUMBER,
682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
683: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,
687: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 687: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

683: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,
687: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
688: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_role_id IN NUMBER,
690: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
691: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

Line 688: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,
687: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
688: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_role_id IN NUMBER,
690: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
691: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
692: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,

Line 691: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

687: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
688: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_role_id IN NUMBER,
690: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
691: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
692: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
693: x_result_flag OUT NOCOPY VARCHAR2
694: );
695: --------------------------------------------------------------------------------

Line 692: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,

688: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
689: p_role_id IN NUMBER,
690: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
691: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
692: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
693: x_result_flag OUT NOCOPY VARCHAR2
694: );
695: --------------------------------------------------------------------------------
696: -- Start of comments

Line 704: -- Default = FND_API.G_FALSE

700: -- Function : Check if the resource is a administrator
701: -- Parameters :
702: -- IN p_api_version NUMBER Required
703: -- p_init_msg_list VARCHAR2 Optional
704: -- Default = FND_API.G_FALSE
705: -- p_validation_level NUMBER Optional
706: -- Default = FND_API.G_VALID_LEVEL_FULL
707: -- p_check_login_user VARCHAR2 Optional
708: -- Default = FND_API.G_TRUE

Line 706: -- Default = FND_API.G_VALID_LEVEL_FULL

702: -- IN p_api_version NUMBER Required
703: -- p_init_msg_list VARCHAR2 Optional
704: -- Default = FND_API.G_FALSE
705: -- p_validation_level NUMBER Optional
706: -- Default = FND_API.G_VALID_LEVEL_FULL
707: -- p_check_login_user VARCHAR2 Optional
708: -- Default = FND_API.G_TRUE
709: -- Flag for checking user privilege and if user is login.
710: -- p_resource_id NUMBER Optional

Line 708: -- Default = FND_API.G_TRUE

704: -- Default = FND_API.G_FALSE
705: -- p_validation_level NUMBER Optional
706: -- Default = FND_API.G_VALID_LEVEL_FULL
707: -- p_check_login_user VARCHAR2 Optional
708: -- Default = FND_API.G_TRUE
709: -- Flag for checking user privilege and if user is login.
710: -- p_resource_id NUMBER Optional
711: -- Default = FND_API.G_MISS_NUM
712: -- p_include_group_flag VARCHAR2 Optional

Line 711: -- Default = FND_API.G_MISS_NUM

707: -- p_check_login_user VARCHAR2 Optional
708: -- Default = FND_API.G_TRUE
709: -- Flag for checking user privilege and if user is login.
710: -- p_resource_id NUMBER Optional
711: -- Default = FND_API.G_MISS_NUM
712: -- p_include_group_flag VARCHAR2 Optional
713: -- Default = FND_API.G_TRUE
714: -- OUT : x_return_status VARCHAR2
715: -- x_msg_count NUMBER

Line 713: -- Default = FND_API.G_TRUE

709: -- Flag for checking user privilege and if user is login.
710: -- p_resource_id NUMBER Optional
711: -- Default = FND_API.G_MISS_NUM
712: -- p_include_group_flag VARCHAR2 Optional
713: -- Default = FND_API.G_TRUE
714: -- OUT : x_return_status VARCHAR2
715: -- x_msg_count NUMBER
716: -- x_msg_data VARCHAR2
717: -- x_result_flag VARCHAR2

Line 727: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

723: --
724: PROCEDURE Is_Administrator
725: (
726: p_api_version IN NUMBER,
727: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729: x_return_status OUT NOCOPY VARCHAR2,
730: x_msg_count OUT NOCOPY NUMBER,
731: x_msg_data OUT NOCOPY VARCHAR2,

Line 728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

724: PROCEDURE Is_Administrator
725: (
726: p_api_version IN NUMBER,
727: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729: x_return_status OUT NOCOPY VARCHAR2,
730: x_msg_count OUT NOCOPY NUMBER,
731: x_msg_data OUT NOCOPY VARCHAR2,
732: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 732: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729: x_return_status OUT NOCOPY VARCHAR2,
730: x_msg_count OUT NOCOPY NUMBER,
731: x_msg_data OUT NOCOPY VARCHAR2,
732: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
733: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
734: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
735: x_result_flag OUT NOCOPY VARCHAR2
736: );

Line 733: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

729: x_return_status OUT NOCOPY VARCHAR2,
730: x_msg_count OUT NOCOPY NUMBER,
731: x_msg_data OUT NOCOPY VARCHAR2,
732: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
733: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
734: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
735: x_result_flag OUT NOCOPY VARCHAR2
736: );
737: --------------------------------------------------------------------------------

Line 734: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

730: x_msg_count OUT NOCOPY NUMBER,
731: x_msg_data OUT NOCOPY VARCHAR2,
732: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
733: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
734: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
735: x_result_flag OUT NOCOPY VARCHAR2
736: );
737: --------------------------------------------------------------------------------
738: -- Start of comments

Line 746: -- Default = FND_API.G_FALSE

742: -- Function : Check if the resource has publish content privelege.
743: -- Parameters :
744: -- IN p_api_version NUMBER Required
745: -- p_init_msg_list VARCHAR2 Optional
746: -- Default = FND_API.G_FALSE
747: -- p_validation_level NUMBER Optional
748: -- Default = FND_API.G_VALID_LEVEL_FULL
749: -- p_check_login_user VARCHAR2 Optional
750: -- Default = FND_API.G_TRUE

Line 748: -- Default = FND_API.G_VALID_LEVEL_FULL

744: -- IN p_api_version NUMBER Required
745: -- p_init_msg_list VARCHAR2 Optional
746: -- Default = FND_API.G_FALSE
747: -- p_validation_level NUMBER Optional
748: -- Default = FND_API.G_VALID_LEVEL_FULL
749: -- p_check_login_user VARCHAR2 Optional
750: -- Default = FND_API.G_TRUE
751: -- Flag for checking user privilege and if user is login.
752: -- p_resource_id NUMBER Optional

Line 750: -- Default = FND_API.G_TRUE

746: -- Default = FND_API.G_FALSE
747: -- p_validation_level NUMBER Optional
748: -- Default = FND_API.G_VALID_LEVEL_FULL
749: -- p_check_login_user VARCHAR2 Optional
750: -- Default = FND_API.G_TRUE
751: -- Flag for checking user privilege and if user is login.
752: -- p_resource_id NUMBER Optional
753: -- Default = FND_API.G_MISS_NUM
754: -- p_include_group_flag VARCHAR2 Optional

Line 753: -- Default = FND_API.G_MISS_NUM

749: -- p_check_login_user VARCHAR2 Optional
750: -- Default = FND_API.G_TRUE
751: -- Flag for checking user privilege and if user is login.
752: -- p_resource_id NUMBER Optional
753: -- Default = FND_API.G_MISS_NUM
754: -- p_include_group_flag VARCHAR2 Optional
755: -- Default = FND_API.G_TRUE
756: -- OUT : x_return_status VARCHAR2
757: -- x_msg_count NUMBER

Line 755: -- Default = FND_API.G_TRUE

751: -- Flag for checking user privilege and if user is login.
752: -- p_resource_id NUMBER Optional
753: -- Default = FND_API.G_MISS_NUM
754: -- p_include_group_flag VARCHAR2 Optional
755: -- Default = FND_API.G_TRUE
756: -- OUT : x_return_status VARCHAR2
757: -- x_msg_count NUMBER
758: -- x_msg_data VARCHAR2
759: -- x_result_flag VARCHAR2

Line 769: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

765: --
766: PROCEDURE Can_PublishContent
767: (
768: p_api_version IN NUMBER,
769: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
770: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
771: x_return_status OUT NOCOPY VARCHAR2,
772: x_msg_count OUT NOCOPY NUMBER,
773: x_msg_data OUT NOCOPY VARCHAR2,

Line 770: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

766: PROCEDURE Can_PublishContent
767: (
768: p_api_version IN NUMBER,
769: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
770: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
771: x_return_status OUT NOCOPY VARCHAR2,
772: x_msg_count OUT NOCOPY NUMBER,
773: x_msg_data OUT NOCOPY VARCHAR2,
774: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 774: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

770: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
771: x_return_status OUT NOCOPY VARCHAR2,
772: x_msg_count OUT NOCOPY NUMBER,
773: x_msg_data OUT NOCOPY VARCHAR2,
774: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
775: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
777: x_result_flag OUT NOCOPY VARCHAR2
778: );

Line 775: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

771: x_return_status OUT NOCOPY VARCHAR2,
772: x_msg_count OUT NOCOPY NUMBER,
773: x_msg_data OUT NOCOPY VARCHAR2,
774: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
775: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
777: x_result_flag OUT NOCOPY VARCHAR2
778: );
779: --------------------------------------------------------------------------------

Line 776: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

772: x_msg_count OUT NOCOPY NUMBER,
773: x_msg_data OUT NOCOPY VARCHAR2,
774: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
775: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
777: x_result_flag OUT NOCOPY VARCHAR2
778: );
779: --------------------------------------------------------------------------------
780: -- Start of comments

Line 788: -- Default = FND_API.G_FALSE

784: -- Function : Check if the resource has approve content privelege.
785: -- Parameters :
786: -- IN p_api_version NUMBER Required
787: -- p_init_msg_list VARCHAR2 Optional
788: -- Default = FND_API.G_FALSE
789: -- p_validation_level NUMBER Optional
790: -- Default = FND_API.G_VALID_LEVEL_FULL
791: -- p_check_login_user VARCHAR2 Optional
792: -- Default = FND_API.G_TRUE

Line 790: -- Default = FND_API.G_VALID_LEVEL_FULL

786: -- IN p_api_version NUMBER Required
787: -- p_init_msg_list VARCHAR2 Optional
788: -- Default = FND_API.G_FALSE
789: -- p_validation_level NUMBER Optional
790: -- Default = FND_API.G_VALID_LEVEL_FULL
791: -- p_check_login_user VARCHAR2 Optional
792: -- Default = FND_API.G_TRUE
793: -- Flag for checking user privilege and if user is login.
794: -- p_resource_id NUMBER Optional

Line 792: -- Default = FND_API.G_TRUE

788: -- Default = FND_API.G_FALSE
789: -- p_validation_level NUMBER Optional
790: -- Default = FND_API.G_VALID_LEVEL_FULL
791: -- p_check_login_user VARCHAR2 Optional
792: -- Default = FND_API.G_TRUE
793: -- Flag for checking user privilege and if user is login.
794: -- p_resource_id NUMBER Optional
795: -- Default = FND_API.G_MISS_NUM
796: -- p_include_group_flag VARCHAR2 Optional

Line 795: -- Default = FND_API.G_MISS_NUM

791: -- p_check_login_user VARCHAR2 Optional
792: -- Default = FND_API.G_TRUE
793: -- Flag for checking user privilege and if user is login.
794: -- p_resource_id NUMBER Optional
795: -- Default = FND_API.G_MISS_NUM
796: -- p_include_group_flag VARCHAR2 Optional
797: -- Default = FND_API.G_TRUE
798: -- OUT : x_return_status VARCHAR2
799: -- x_msg_count NUMBER

Line 797: -- Default = FND_API.G_TRUE

793: -- Flag for checking user privilege and if user is login.
794: -- p_resource_id NUMBER Optional
795: -- Default = FND_API.G_MISS_NUM
796: -- p_include_group_flag VARCHAR2 Optional
797: -- Default = FND_API.G_TRUE
798: -- OUT : x_return_status VARCHAR2
799: -- x_msg_count NUMBER
800: -- x_msg_data VARCHAR2
801: -- x_result_flag VARCHAR2

Line 811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

807: --
808: PROCEDURE Can_ApproveContent
809: (
810: p_api_version IN NUMBER,
811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,

Line 812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

808: PROCEDURE Can_ApproveContent
809: (
810: p_api_version IN NUMBER,
811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 816: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
817: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
819: x_result_flag OUT NOCOPY VARCHAR2
820: );

Line 817: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
817: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
819: x_result_flag OUT NOCOPY VARCHAR2
820: );
821: --------------------------------------------------------------------------------

Line 818: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
817: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
818: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
819: x_result_flag OUT NOCOPY VARCHAR2
820: );
821: --------------------------------------------------------------------------------
822: -- Start of comments

Line 830: -- Default = FND_API.G_FALSE

826: -- Function : Check if the resource has setup channel privelege.
827: -- Parameters :
828: -- IN p_api_version NUMBER Required
829: -- p_init_msg_list VARCHAR2 Optional
830: -- Default = FND_API.G_FALSE
831: -- p_validation_level NUMBER Optional
832: -- Default = FND_API.G_VALID_LEVEL_FULL
833: -- p_check_login_user VARCHAR2 Optional
834: -- Default = FND_API.G_TRUE

Line 832: -- Default = FND_API.G_VALID_LEVEL_FULL

828: -- IN p_api_version NUMBER Required
829: -- p_init_msg_list VARCHAR2 Optional
830: -- Default = FND_API.G_FALSE
831: -- p_validation_level NUMBER Optional
832: -- Default = FND_API.G_VALID_LEVEL_FULL
833: -- p_check_login_user VARCHAR2 Optional
834: -- Default = FND_API.G_TRUE
835: -- Flag for checking user privilege and if user is login.
836: -- p_resource_id NUMBER Optional

Line 834: -- Default = FND_API.G_TRUE

830: -- Default = FND_API.G_FALSE
831: -- p_validation_level NUMBER Optional
832: -- Default = FND_API.G_VALID_LEVEL_FULL
833: -- p_check_login_user VARCHAR2 Optional
834: -- Default = FND_API.G_TRUE
835: -- Flag for checking user privilege and if user is login.
836: -- p_resource_id NUMBER Optional
837: -- Default = FND_API.G_MISS_NUM
838: -- p_include_group_flag VARCHAR2 Optional

Line 837: -- Default = FND_API.G_MISS_NUM

833: -- p_check_login_user VARCHAR2 Optional
834: -- Default = FND_API.G_TRUE
835: -- Flag for checking user privilege and if user is login.
836: -- p_resource_id NUMBER Optional
837: -- Default = FND_API.G_MISS_NUM
838: -- p_include_group_flag VARCHAR2 Optional
839: -- Default = FND_API.G_TRUE
840: -- OUT : x_return_status VARCHAR2
841: -- x_msg_count NUMBER

Line 839: -- Default = FND_API.G_TRUE

835: -- Flag for checking user privilege and if user is login.
836: -- p_resource_id NUMBER Optional
837: -- Default = FND_API.G_MISS_NUM
838: -- p_include_group_flag VARCHAR2 Optional
839: -- Default = FND_API.G_TRUE
840: -- OUT : x_return_status VARCHAR2
841: -- x_msg_count NUMBER
842: -- x_msg_data VARCHAR2
843: -- x_result_flag VARCHAR2

Line 853: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

849: --
850: PROCEDURE Can_SetupChannel
851: (
852: p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
854: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
855: x_return_status OUT NOCOPY VARCHAR2,
856: x_msg_count OUT NOCOPY NUMBER,
857: x_msg_data OUT NOCOPY VARCHAR2,

Line 854: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

850: PROCEDURE Can_SetupChannel
851: (
852: p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
854: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
855: x_return_status OUT NOCOPY VARCHAR2,
856: x_msg_count OUT NOCOPY NUMBER,
857: x_msg_data OUT NOCOPY VARCHAR2,
858: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 858: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

854: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
855: x_return_status OUT NOCOPY VARCHAR2,
856: x_msg_count OUT NOCOPY NUMBER,
857: x_msg_data OUT NOCOPY VARCHAR2,
858: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
859: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
860: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
861: x_result_flag OUT NOCOPY VARCHAR2
862: );

Line 859: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

855: x_return_status OUT NOCOPY VARCHAR2,
856: x_msg_count OUT NOCOPY NUMBER,
857: x_msg_data OUT NOCOPY VARCHAR2,
858: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
859: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
860: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
861: x_result_flag OUT NOCOPY VARCHAR2
862: );
863: --------------------------------------------------------------------------------

Line 860: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

856: x_msg_count OUT NOCOPY NUMBER,
857: x_msg_data OUT NOCOPY VARCHAR2,
858: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
859: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
860: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
861: x_result_flag OUT NOCOPY VARCHAR2
862: );
863: --------------------------------------------------------------------------------
864: -- Start of comments

Line 872: -- Default = FND_API.G_FALSE

868: -- Function : Check if the resource has setup category privelege.
869: -- Parameters :
870: -- IN p_api_version NUMBER Required
871: -- p_init_msg_list VARCHAR2 Optional
872: -- Default = FND_API.G_FALSE
873: -- p_validation_level NUMBER Optional
874: -- Default = FND_API.G_VALID_LEVEL_FULL
875: -- p_check_login_user VARCHAR2 Optional
876: -- Default = FND_API.G_TRUE

Line 874: -- Default = FND_API.G_VALID_LEVEL_FULL

870: -- IN p_api_version NUMBER Required
871: -- p_init_msg_list VARCHAR2 Optional
872: -- Default = FND_API.G_FALSE
873: -- p_validation_level NUMBER Optional
874: -- Default = FND_API.G_VALID_LEVEL_FULL
875: -- p_check_login_user VARCHAR2 Optional
876: -- Default = FND_API.G_TRUE
877: -- Flag for checking user privilege and if user is login.
878: -- p_resource_id NUMBER Optional

Line 876: -- Default = FND_API.G_TRUE

872: -- Default = FND_API.G_FALSE
873: -- p_validation_level NUMBER Optional
874: -- Default = FND_API.G_VALID_LEVEL_FULL
875: -- p_check_login_user VARCHAR2 Optional
876: -- Default = FND_API.G_TRUE
877: -- Flag for checking user privilege and if user is login.
878: -- p_resource_id NUMBER Optional
879: -- Default = FND_API.G_MISS_NUM
880: -- p_include_group_flag VARCHAR2 Optional

Line 879: -- Default = FND_API.G_MISS_NUM

875: -- p_check_login_user VARCHAR2 Optional
876: -- Default = FND_API.G_TRUE
877: -- Flag for checking user privilege and if user is login.
878: -- p_resource_id NUMBER Optional
879: -- Default = FND_API.G_MISS_NUM
880: -- p_include_group_flag VARCHAR2 Optional
881: -- Default = FND_API.G_TRUE
882: -- OUT : x_return_status VARCHAR2
883: -- x_msg_count NUMBER

Line 881: -- Default = FND_API.G_TRUE

877: -- Flag for checking user privilege and if user is login.
878: -- p_resource_id NUMBER Optional
879: -- Default = FND_API.G_MISS_NUM
880: -- p_include_group_flag VARCHAR2 Optional
881: -- Default = FND_API.G_TRUE
882: -- OUT : x_return_status VARCHAR2
883: -- x_msg_count NUMBER
884: -- x_msg_data VARCHAR2
885: -- x_result_flag VARCHAR2

Line 895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

891: --
892: PROCEDURE Can_SetupCategory
893: (
894: p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
896: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2,

Line 896: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

892: PROCEDURE Can_SetupCategory
893: (
894: p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
896: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2,
900: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 900: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

896: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2,
900: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
901: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
903: x_result_flag OUT NOCOPY VARCHAR2
904: );

Line 901: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2,
900: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
901: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
903: x_result_flag OUT NOCOPY VARCHAR2
904: );
905: --------------------------------------------------------------------------------

Line 902: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2,
900: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
901: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
903: x_result_flag OUT NOCOPY VARCHAR2
904: );
905: --------------------------------------------------------------------------------
906: -- Start of comments

Line 914: -- Default = FND_API.G_FALSE

910: -- Function : Check if the resource has setup distribution privelege.
911: -- Parameters :
912: -- IN p_api_version NUMBER Required
913: -- p_init_msg_list VARCHAR2 Optional
914: -- Default = FND_API.G_FALSE
915: -- p_validation_level NUMBER Optional
916: -- Default = FND_API.G_VALID_LEVEL_FULL
917: -- p_check_login_user VARCHAR2 Optional
918: -- Default = FND_API.G_TRUE

Line 916: -- Default = FND_API.G_VALID_LEVEL_FULL

912: -- IN p_api_version NUMBER Required
913: -- p_init_msg_list VARCHAR2 Optional
914: -- Default = FND_API.G_FALSE
915: -- p_validation_level NUMBER Optional
916: -- Default = FND_API.G_VALID_LEVEL_FULL
917: -- p_check_login_user VARCHAR2 Optional
918: -- Default = FND_API.G_TRUE
919: -- Flag for checking user privilege and if user is login.
920: -- p_resource_id NUMBER Optional

Line 918: -- Default = FND_API.G_TRUE

914: -- Default = FND_API.G_FALSE
915: -- p_validation_level NUMBER Optional
916: -- Default = FND_API.G_VALID_LEVEL_FULL
917: -- p_check_login_user VARCHAR2 Optional
918: -- Default = FND_API.G_TRUE
919: -- Flag for checking user privilege and if user is login.
920: -- p_resource_id NUMBER Optional
921: -- Default = FND_API.G_MISS_NUM
922: -- p_include_group_flag VARCHAR2 Optional

Line 921: -- Default = FND_API.G_MISS_NUM

917: -- p_check_login_user VARCHAR2 Optional
918: -- Default = FND_API.G_TRUE
919: -- Flag for checking user privilege and if user is login.
920: -- p_resource_id NUMBER Optional
921: -- Default = FND_API.G_MISS_NUM
922: -- p_include_group_flag VARCHAR2 Optional
923: -- Default = FND_API.G_TRUE
924: -- OUT : x_return_status VARCHAR2
925: -- x_msg_count NUMBER

Line 923: -- Default = FND_API.G_TRUE

919: -- Flag for checking user privilege and if user is login.
920: -- p_resource_id NUMBER Optional
921: -- Default = FND_API.G_MISS_NUM
922: -- p_include_group_flag VARCHAR2 Optional
923: -- Default = FND_API.G_TRUE
924: -- OUT : x_return_status VARCHAR2
925: -- x_msg_count NUMBER
926: -- x_msg_data VARCHAR2
927: -- x_result_flag VARCHAR2

Line 937: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

933: --
934: PROCEDURE Can_SetupDistRule
935: (
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: x_return_status OUT NOCOPY VARCHAR2,
940: x_msg_count OUT NOCOPY NUMBER,
941: x_msg_data OUT NOCOPY VARCHAR2,

Line 938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

934: PROCEDURE Can_SetupDistRule
935: (
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: x_return_status OUT NOCOPY VARCHAR2,
940: x_msg_count OUT NOCOPY NUMBER,
941: x_msg_data OUT NOCOPY VARCHAR2,
942: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 942: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: x_return_status OUT NOCOPY VARCHAR2,
940: x_msg_count OUT NOCOPY NUMBER,
941: x_msg_data OUT NOCOPY VARCHAR2,
942: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
943: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
944: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
945: x_result_flag OUT NOCOPY VARCHAR2
946: );

Line 943: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

939: x_return_status OUT NOCOPY VARCHAR2,
940: x_msg_count OUT NOCOPY NUMBER,
941: x_msg_data OUT NOCOPY VARCHAR2,
942: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
943: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
944: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
945: x_result_flag OUT NOCOPY VARCHAR2
946: );
947: --------------------------------------------------------------------------------

Line 944: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

940: x_msg_count OUT NOCOPY NUMBER,
941: x_msg_data OUT NOCOPY VARCHAR2,
942: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
943: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
944: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
945: x_result_flag OUT NOCOPY VARCHAR2
946: );
947: --------------------------------------------------------------------------------
948: ----------------------------- GROUP PRIVELEGES ---------------------------------

Line 958: -- Default = FND_API.G_FALSE

954: -- Function : Add a role to a group.
955: -- Parameters :
956: -- IN p_api_version NUMBER Required
957: -- p_init_msg_list VARCHAR2 Optional
958: -- Default = FND_API.G_FALSE
959: -- p_commit VARCHAR2 Optional
960: -- Default = FND_API.G_FALSE
961: -- p_validation_level NUMBER Optional
962: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 960: -- Default = FND_API.G_FALSE

956: -- IN p_api_version NUMBER Required
957: -- p_init_msg_list VARCHAR2 Optional
958: -- Default = FND_API.G_FALSE
959: -- p_commit VARCHAR2 Optional
960: -- Default = FND_API.G_FALSE
961: -- p_validation_level NUMBER Optional
962: -- Default = FND_API.G_VALID_LEVEL_FULL
963: -- p_check_login_user VARCHAR2 Optional
964: -- Default = FND_API.G_TRUE

Line 962: -- Default = FND_API.G_VALID_LEVEL_FULL

958: -- Default = FND_API.G_FALSE
959: -- p_commit VARCHAR2 Optional
960: -- Default = FND_API.G_FALSE
961: -- p_validation_level NUMBER Optional
962: -- Default = FND_API.G_VALID_LEVEL_FULL
963: -- p_check_login_user VARCHAR2 Optional
964: -- Default = FND_API.G_TRUE
965: -- Flag for checking user privilege and if user is login.
966: -- p_group_id NUMBER Required

Line 964: -- Default = FND_API.G_TRUE

960: -- Default = FND_API.G_FALSE
961: -- p_validation_level NUMBER Optional
962: -- Default = FND_API.G_VALID_LEVEL_FULL
963: -- p_check_login_user VARCHAR2 Optional
964: -- Default = FND_API.G_TRUE
965: -- Flag for checking user privilege and if user is login.
966: -- p_group_id NUMBER Required
967: -- the id of the group
968: -- p_role_id NUMBER Optional

Line 969: -- Default FND_API.G_MISS_NUM

965: -- Flag for checking user privilege and if user is login.
966: -- p_group_id NUMBER Required
967: -- the id of the group
968: -- p_role_id NUMBER Optional
969: -- Default FND_API.G_MISS_NUM
970: -- p_role_code VARCHAR2 Optional
971: -- Default FND_API.G_MISS_CHAR
972: -- OUT : x_return_status VARCHAR2
973: -- x_msg_count NUMBER

Line 971: -- Default FND_API.G_MISS_CHAR

967: -- the id of the group
968: -- p_role_id NUMBER Optional
969: -- Default FND_API.G_MISS_NUM
970: -- p_role_code VARCHAR2 Optional
971: -- Default FND_API.G_MISS_CHAR
972: -- OUT : x_return_status VARCHAR2
973: -- x_msg_count NUMBER
974: -- x_msg_data VARCHAR2
975: -- Version : Current version 1.0

Line 984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

980: --
981: PROCEDURE Add_GroupRole
982: (
983: p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
985: p_commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: x_return_status OUT NOCOPY VARCHAR2,
988: x_msg_count OUT NOCOPY NUMBER,

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

981: PROCEDURE Add_GroupRole
982: (
983: p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
985: p_commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: x_return_status OUT NOCOPY VARCHAR2,
988: x_msg_count OUT NOCOPY NUMBER,
989: x_msg_data OUT NOCOPY VARCHAR2,

Line 986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

982: (
983: p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
985: p_commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: x_return_status OUT NOCOPY VARCHAR2,
988: x_msg_count OUT NOCOPY NUMBER,
989: x_msg_data OUT NOCOPY VARCHAR2,
990: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 990: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987: x_return_status OUT NOCOPY VARCHAR2,
988: x_msg_count OUT NOCOPY NUMBER,
989: x_msg_data OUT NOCOPY VARCHAR2,
990: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
991: p_group_id IN NUMBER,
992: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
993: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
994: );

Line 992: p_role_id IN NUMBER := FND_API.G_MISS_NUM,

988: x_msg_count OUT NOCOPY NUMBER,
989: x_msg_data OUT NOCOPY VARCHAR2,
990: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
991: p_group_id IN NUMBER,
992: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
993: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
994: );
995: --
996: --------------------------------------------------------------------------------

Line 993: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR

989: x_msg_data OUT NOCOPY VARCHAR2,
990: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
991: p_group_id IN NUMBER,
992: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
993: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
994: );
995: --
996: --------------------------------------------------------------------------------
997: -- Start of comments

Line 1005: -- Default = FND_API.G_FALSE

1001: -- Function : Add several roles to a group.
1002: -- Parameters :
1003: -- IN p_api_version NUMBER Required
1004: -- p_init_msg_list VARCHAR2 Optional
1005: -- Default = FND_API.G_FALSE
1006: -- p_commit VARCHAR2 Optional
1007: -- Default = FND_API.G_FALSE
1008: -- p_validation_level NUMBER Optional
1009: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1007: -- Default = FND_API.G_FALSE

1003: -- IN p_api_version NUMBER Required
1004: -- p_init_msg_list VARCHAR2 Optional
1005: -- Default = FND_API.G_FALSE
1006: -- p_commit VARCHAR2 Optional
1007: -- Default = FND_API.G_FALSE
1008: -- p_validation_level NUMBER Optional
1009: -- Default = FND_API.G_VALID_LEVEL_FULL
1010: -- p_check_login_user VARCHAR2 Optional
1011: -- Default = FND_API.G_TRUE

Line 1009: -- Default = FND_API.G_VALID_LEVEL_FULL

1005: -- Default = FND_API.G_FALSE
1006: -- p_commit VARCHAR2 Optional
1007: -- Default = FND_API.G_FALSE
1008: -- p_validation_level NUMBER Optional
1009: -- Default = FND_API.G_VALID_LEVEL_FULL
1010: -- p_check_login_user VARCHAR2 Optional
1011: -- Default = FND_API.G_TRUE
1012: -- Flag for checking user privilege and if user is login.
1013: -- p_group_id NUMBER Required

Line 1011: -- Default = FND_API.G_TRUE

1007: -- Default = FND_API.G_FALSE
1008: -- p_validation_level NUMBER Optional
1009: -- Default = FND_API.G_VALID_LEVEL_FULL
1010: -- p_check_login_user VARCHAR2 Optional
1011: -- Default = FND_API.G_TRUE
1012: -- Flag for checking user privilege and if user is login.
1013: -- p_group_id NUMBER Required
1014: -- the id of the group
1015: -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE

Line 1029: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1025: --
1026: PROCEDURE Add_GroupRole
1027: (
1028: p_api_version IN NUMBER,
1029: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1030: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1031: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1032: x_return_status OUT NOCOPY VARCHAR2,
1033: x_msg_count OUT NOCOPY NUMBER,

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

1026: PROCEDURE Add_GroupRole
1027: (
1028: p_api_version IN NUMBER,
1029: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1030: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1031: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1032: x_return_status OUT NOCOPY VARCHAR2,
1033: x_msg_count OUT NOCOPY NUMBER,
1034: x_msg_data OUT NOCOPY VARCHAR2,

Line 1031: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1027: (
1028: p_api_version IN NUMBER,
1029: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1030: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1031: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1032: x_return_status OUT NOCOPY VARCHAR2,
1033: x_msg_count OUT NOCOPY NUMBER,
1034: x_msg_data OUT NOCOPY VARCHAR2,
1035: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1035: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1031: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1032: x_return_status OUT NOCOPY VARCHAR2,
1033: x_msg_count OUT NOCOPY NUMBER,
1034: x_msg_data OUT NOCOPY VARCHAR2,
1035: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1036: p_group_id IN NUMBER,
1037: p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
1038: );
1039: --------------------------------------------------------------------------------

Line 1048: -- Default = FND_API.G_FALSE

1044: -- Function : Remove a role from a group.
1045: -- Parameters :
1046: -- IN p_api_version NUMBER Required
1047: -- p_init_msg_list VARCHAR2 Optional
1048: -- Default = FND_API.G_FALSE
1049: -- p_commit VARCHAR2 Optional
1050: -- Default = FND_API.G_FALSE
1051: -- p_validation_level NUMBER Optional
1052: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1050: -- Default = FND_API.G_FALSE

1046: -- IN p_api_version NUMBER Required
1047: -- p_init_msg_list VARCHAR2 Optional
1048: -- Default = FND_API.G_FALSE
1049: -- p_commit VARCHAR2 Optional
1050: -- Default = FND_API.G_FALSE
1051: -- p_validation_level NUMBER Optional
1052: -- Default = FND_API.G_VALID_LEVEL_FULL
1053: -- p_check_login_user VARCHAR2 Optional
1054: -- Default = FND_API.G_TRUE

Line 1052: -- Default = FND_API.G_VALID_LEVEL_FULL

1048: -- Default = FND_API.G_FALSE
1049: -- p_commit VARCHAR2 Optional
1050: -- Default = FND_API.G_FALSE
1051: -- p_validation_level NUMBER Optional
1052: -- Default = FND_API.G_VALID_LEVEL_FULL
1053: -- p_check_login_user VARCHAR2 Optional
1054: -- Default = FND_API.G_TRUE
1055: -- Flag for checking user privilege and if user is login.
1056: -- p_group_id NUMBER Required

Line 1054: -- Default = FND_API.G_TRUE

1050: -- Default = FND_API.G_FALSE
1051: -- p_validation_level NUMBER Optional
1052: -- Default = FND_API.G_VALID_LEVEL_FULL
1053: -- p_check_login_user VARCHAR2 Optional
1054: -- Default = FND_API.G_TRUE
1055: -- Flag for checking user privilege and if user is login.
1056: -- p_group_id NUMBER Required
1057: -- p_role_id NUMBER Optional
1058: -- Default FND_API.G_MISS_NUM

Line 1058: -- Default FND_API.G_MISS_NUM

1054: -- Default = FND_API.G_TRUE
1055: -- Flag for checking user privilege and if user is login.
1056: -- p_group_id NUMBER Required
1057: -- p_role_id NUMBER Optional
1058: -- Default FND_API.G_MISS_NUM
1059: -- p_role_code VARCHAR2 Optional
1060: -- Default FND_API.G_MISS_CHAR
1061: -- OUT : x_return_status VARCHAR2
1062: -- x_msg_count NUMBER

Line 1060: -- Default FND_API.G_MISS_CHAR

1056: -- p_group_id NUMBER Required
1057: -- p_role_id NUMBER Optional
1058: -- Default FND_API.G_MISS_NUM
1059: -- p_role_code VARCHAR2 Optional
1060: -- Default FND_API.G_MISS_CHAR
1061: -- OUT : x_return_status VARCHAR2
1062: -- x_msg_count NUMBER
1063: -- x_msg_data VARCHAR2
1064: -- Version : Current version 1.0

Line 1073: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1069: --
1070: PROCEDURE Remove_GroupRole
1071: (
1072: p_api_version IN NUMBER,
1073: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1074: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1076: x_return_status OUT NOCOPY VARCHAR2,
1077: x_msg_count OUT NOCOPY NUMBER,

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

1070: PROCEDURE Remove_GroupRole
1071: (
1072: p_api_version IN NUMBER,
1073: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1074: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1076: x_return_status OUT NOCOPY VARCHAR2,
1077: x_msg_count OUT NOCOPY NUMBER,
1078: x_msg_data OUT NOCOPY VARCHAR2,

Line 1075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1071: (
1072: p_api_version IN NUMBER,
1073: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1074: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1076: x_return_status OUT NOCOPY VARCHAR2,
1077: x_msg_count OUT NOCOPY NUMBER,
1078: x_msg_data OUT NOCOPY VARCHAR2,
1079: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1079: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1076: x_return_status OUT NOCOPY VARCHAR2,
1077: x_msg_count OUT NOCOPY NUMBER,
1078: x_msg_data OUT NOCOPY VARCHAR2,
1079: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1080: p_group_id IN NUMBER,
1081: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
1082: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
1083: );

Line 1081: p_role_id IN NUMBER := FND_API.G_MISS_NUM,

1077: x_msg_count OUT NOCOPY NUMBER,
1078: x_msg_data OUT NOCOPY VARCHAR2,
1079: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1080: p_group_id IN NUMBER,
1081: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
1082: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
1083: );
1084: --
1085: --------------------------------------------------------------------------------

Line 1082: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR

1078: x_msg_data OUT NOCOPY VARCHAR2,
1079: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1080: p_group_id IN NUMBER,
1081: p_role_id IN NUMBER := FND_API.G_MISS_NUM,
1082: p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
1083: );
1084: --
1085: --------------------------------------------------------------------------------
1086: -- Start of comments

Line 1094: -- Default = FND_API.G_FALSE

1090: -- Function : Remove several roles from a group.
1091: -- Parameters :
1092: -- IN p_api_version NUMBER Required
1093: -- p_init_msg_list VARCHAR2 Optional
1094: -- Default = FND_API.G_FALSE
1095: -- p_commit VARCHAR2 Optional
1096: -- Default = FND_API.G_FALSE
1097: -- p_validation_level NUMBER Optional
1098: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1096: -- Default = FND_API.G_FALSE

1092: -- IN p_api_version NUMBER Required
1093: -- p_init_msg_list VARCHAR2 Optional
1094: -- Default = FND_API.G_FALSE
1095: -- p_commit VARCHAR2 Optional
1096: -- Default = FND_API.G_FALSE
1097: -- p_validation_level NUMBER Optional
1098: -- Default = FND_API.G_VALID_LEVEL_FULL
1099: -- p_check_login_user VARCHAR2 Optional
1100: -- Default = FND_API.G_TRUE

Line 1098: -- Default = FND_API.G_VALID_LEVEL_FULL

1094: -- Default = FND_API.G_FALSE
1095: -- p_commit VARCHAR2 Optional
1096: -- Default = FND_API.G_FALSE
1097: -- p_validation_level NUMBER Optional
1098: -- Default = FND_API.G_VALID_LEVEL_FULL
1099: -- p_check_login_user VARCHAR2 Optional
1100: -- Default = FND_API.G_TRUE
1101: -- Flag for checking user privilege and if user is login.
1102: -- p_group_id NUMBER Required

Line 1100: -- Default = FND_API.G_TRUE

1096: -- Default = FND_API.G_FALSE
1097: -- p_validation_level NUMBER Optional
1098: -- Default = FND_API.G_VALID_LEVEL_FULL
1099: -- p_check_login_user VARCHAR2 Optional
1100: -- Default = FND_API.G_TRUE
1101: -- Flag for checking user privilege and if user is login.
1102: -- p_group_id NUMBER Required
1103: -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
1104: -- array of role ids. Required

Line 1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1113: --
1114: PROCEDURE Remove_GroupRole
1115: (
1116: p_api_version IN NUMBER,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: x_return_status OUT NOCOPY VARCHAR2,
1121: x_msg_count OUT NOCOPY NUMBER,

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

1114: PROCEDURE Remove_GroupRole
1115: (
1116: p_api_version IN NUMBER,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: x_return_status OUT NOCOPY VARCHAR2,
1121: x_msg_count OUT NOCOPY NUMBER,
1122: x_msg_data OUT NOCOPY VARCHAR2,

Line 1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1115: (
1116: p_api_version IN NUMBER,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: x_return_status OUT NOCOPY VARCHAR2,
1121: x_msg_count OUT NOCOPY NUMBER,
1122: x_msg_data OUT NOCOPY VARCHAR2,
1123: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1123: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: x_return_status OUT NOCOPY VARCHAR2,
1121: x_msg_count OUT NOCOPY NUMBER,
1122: x_msg_data OUT NOCOPY VARCHAR2,
1123: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1124: p_group_id IN NUMBER,
1125: p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
1126: );
1127: --------------------------------------------------------------------------------

Line 1136: -- Default = FND_API.G_FALSE

1132: -- Function : Replace all the roles of a group.
1133: -- Parameters :
1134: -- IN p_api_version NUMBER Required
1135: -- p_init_msg_list VARCHAR2 Optional
1136: -- Default = FND_API.G_FALSE
1137: -- p_commit VARCHAR2 Optional
1138: -- Default = FND_API.G_FALSE
1139: -- p_validation_level NUMBER Optional
1140: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1138: -- Default = FND_API.G_FALSE

1134: -- IN p_api_version NUMBER Required
1135: -- p_init_msg_list VARCHAR2 Optional
1136: -- Default = FND_API.G_FALSE
1137: -- p_commit VARCHAR2 Optional
1138: -- Default = FND_API.G_FALSE
1139: -- p_validation_level NUMBER Optional
1140: -- Default = FND_API.G_VALID_LEVEL_FULL
1141: -- p_check_login_user VARCHAR2 Optional
1142: -- Default = FND_API.G_TRUE

Line 1140: -- Default = FND_API.G_VALID_LEVEL_FULL

1136: -- Default = FND_API.G_FALSE
1137: -- p_commit VARCHAR2 Optional
1138: -- Default = FND_API.G_FALSE
1139: -- p_validation_level NUMBER Optional
1140: -- Default = FND_API.G_VALID_LEVEL_FULL
1141: -- p_check_login_user VARCHAR2 Optional
1142: -- Default = FND_API.G_TRUE
1143: -- Flag for checking user privilege and if user is login.
1144: -- p_group_id NUMBER Required

Line 1142: -- Default = FND_API.G_TRUE

1138: -- Default = FND_API.G_FALSE
1139: -- p_validation_level NUMBER Optional
1140: -- Default = FND_API.G_VALID_LEVEL_FULL
1141: -- p_check_login_user VARCHAR2 Optional
1142: -- Default = FND_API.G_TRUE
1143: -- Flag for checking user privilege and if user is login.
1144: -- p_group_id NUMBER Required
1145: -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
1146: -- array of role ids. Required

Line 1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1155: --
1156: PROCEDURE Replace_GroupRole
1157: (
1158: p_api_version IN NUMBER,
1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: x_msg_count OUT NOCOPY NUMBER,

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

1156: PROCEDURE Replace_GroupRole
1157: (
1158: p_api_version IN NUMBER,
1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: x_msg_count OUT NOCOPY NUMBER,
1164: x_msg_data OUT NOCOPY VARCHAR2,

Line 1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1157: (
1158: p_api_version IN NUMBER,
1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: x_msg_count OUT NOCOPY NUMBER,
1164: x_msg_data OUT NOCOPY VARCHAR2,
1165: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1165: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: x_msg_count OUT NOCOPY NUMBER,
1164: x_msg_data OUT NOCOPY VARCHAR2,
1165: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1166: p_group_id IN NUMBER,
1167: p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
1168: );
1169: PROCEDURE Replace_GroupRole

Line 1172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1168: );
1169: PROCEDURE Replace_GroupRole
1170: (
1171: p_api_version IN NUMBER,
1172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1175: x_return_status OUT NOCOPY VARCHAR2,
1176: x_msg_count OUT NOCOPY NUMBER,

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

1169: PROCEDURE Replace_GroupRole
1170: (
1171: p_api_version IN NUMBER,
1172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1175: x_return_status OUT NOCOPY VARCHAR2,
1176: x_msg_count OUT NOCOPY NUMBER,
1177: x_msg_data OUT NOCOPY VARCHAR2,

Line 1174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1170: (
1171: p_api_version IN NUMBER,
1172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1175: x_return_status OUT NOCOPY VARCHAR2,
1176: x_msg_count OUT NOCOPY NUMBER,
1177: x_msg_data OUT NOCOPY VARCHAR2,
1178: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1178: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1175: x_return_status OUT NOCOPY VARCHAR2,
1176: x_msg_count OUT NOCOPY NUMBER,
1177: x_msg_data OUT NOCOPY VARCHAR2,
1178: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1179: p_group_id IN NUMBER,
1180: p_role_code IN VARCHAR2
1181: );
1182: --------------------------------------------------------------------------------

Line 1191: -- Default = FND_API.G_FALSE

1187: -- Function : Retrieve all the roles of a group.
1188: -- Parameters :
1189: -- IN p_api_version NUMBER Required
1190: -- p_init_msg_list VARCHAR2 Optional
1191: -- Default = FND_API.G_FALSE
1192: -- p_validation_level NUMBER Optional
1193: -- Default = FND_API.G_VALID_LEVEL_FULL
1194: -- p_check_login_user VARCHAR2 Optional
1195: -- Default = FND_API.G_TRUE

Line 1193: -- Default = FND_API.G_VALID_LEVEL_FULL

1189: -- IN p_api_version NUMBER Required
1190: -- p_init_msg_list VARCHAR2 Optional
1191: -- Default = FND_API.G_FALSE
1192: -- p_validation_level NUMBER Optional
1193: -- Default = FND_API.G_VALID_LEVEL_FULL
1194: -- p_check_login_user VARCHAR2 Optional
1195: -- Default = FND_API.G_TRUE
1196: -- Flag for checking user privilege and if user is login.
1197: -- p_group_id NUMBER Required

Line 1195: -- Default = FND_API.G_TRUE

1191: -- Default = FND_API.G_FALSE
1192: -- p_validation_level NUMBER Optional
1193: -- Default = FND_API.G_VALID_LEVEL_FULL
1194: -- p_check_login_user VARCHAR2 Optional
1195: -- Default = FND_API.G_TRUE
1196: -- Flag for checking user privilege and if user is login.
1197: -- p_group_id NUMBER Required
1198: -- p_check_effective_date VARCHAR2 Optional
1199: -- default FND_API.G_TRUE

Line 1199: -- default FND_API.G_TRUE

1195: -- Default = FND_API.G_TRUE
1196: -- Flag for checking user privilege and if user is login.
1197: -- p_group_id NUMBER Required
1198: -- p_check_effective_date VARCHAR2 Optional
1199: -- default FND_API.G_TRUE
1200: -- OUT : x_return_status VARCHAR2
1201: -- x_msg_count NUMBER
1202: -- x_msg_data VARCHAR2
1203: -- x_role_id_varray AMV_NUMBER_VARRAY_TYPE

Line 1214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1210: --
1211: PROCEDURE Get_GroupRoles
1212: (
1213: p_api_version IN NUMBER,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_msg_count OUT NOCOPY NUMBER,
1218: x_msg_data OUT NOCOPY VARCHAR2,

Line 1215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1211: PROCEDURE Get_GroupRoles
1212: (
1213: p_api_version IN NUMBER,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_msg_count OUT NOCOPY NUMBER,
1218: x_msg_data OUT NOCOPY VARCHAR2,
1219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_msg_count OUT NOCOPY NUMBER,
1218: x_msg_data OUT NOCOPY VARCHAR2,
1219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1220: p_group_id IN NUMBER,
1221: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
1222: x_role_id_varray OUT NOCOPY AMV_NUMBER_VARRAY_TYPE,
1223: x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE

Line 1221: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,

1217: x_msg_count OUT NOCOPY NUMBER,
1218: x_msg_data OUT NOCOPY VARCHAR2,
1219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1220: p_group_id IN NUMBER,
1221: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
1222: x_role_id_varray OUT NOCOPY AMV_NUMBER_VARRAY_TYPE,
1223: x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
1224: );
1225: --------------------------------------------------------------------------------

Line 1234: -- Default = FND_API.G_FALSE

1230: -- Function : Check if the passed group has the passed role.
1231: -- Parameters :
1232: -- IN p_api_version NUMBER Required
1233: -- p_init_msg_list VARCHAR2 Optional
1234: -- Default = FND_API.G_FALSE
1235: -- p_validation_level NUMBER Optional
1236: -- Default = FND_API.G_VALID_LEVEL_FULL
1237: -- p_check_login_user VARCHAR2 Optional
1238: -- Default = FND_API.G_TRUE

Line 1236: -- Default = FND_API.G_VALID_LEVEL_FULL

1232: -- IN p_api_version NUMBER Required
1233: -- p_init_msg_list VARCHAR2 Optional
1234: -- Default = FND_API.G_FALSE
1235: -- p_validation_level NUMBER Optional
1236: -- Default = FND_API.G_VALID_LEVEL_FULL
1237: -- p_check_login_user VARCHAR2 Optional
1238: -- Default = FND_API.G_TRUE
1239: -- Flag for checking user privilege and if user is login.
1240: -- p_group_id NUMBER Required

Line 1238: -- Default = FND_API.G_TRUE

1234: -- Default = FND_API.G_FALSE
1235: -- p_validation_level NUMBER Optional
1236: -- Default = FND_API.G_VALID_LEVEL_FULL
1237: -- p_check_login_user VARCHAR2 Optional
1238: -- Default = FND_API.G_TRUE
1239: -- Flag for checking user privilege and if user is login.
1240: -- p_group_id NUMBER Required
1241: -- p_role_id NUMBER Required
1242: -- p_check_effective_date VARCHAR2 Optional

Line 1243: -- default FND_API.G_TRUE

1239: -- Flag for checking user privilege and if user is login.
1240: -- p_group_id NUMBER Required
1241: -- p_role_id NUMBER Required
1242: -- p_check_effective_date VARCHAR2 Optional
1243: -- default FND_API.G_TRUE
1244: -- OUT : x_return_status VARCHAR2
1245: -- x_msg_count NUMBER
1246: -- x_msg_data VARCHAR2
1247: -- x_result_flag VARCHAR2

Line 1257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1253: --
1254: PROCEDURE Check_GroupRole
1255: (
1256: p_api_version IN NUMBER,
1257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1259: x_return_status OUT NOCOPY VARCHAR2,
1260: x_msg_count OUT NOCOPY NUMBER,
1261: x_msg_data OUT NOCOPY VARCHAR2,

Line 1258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1254: PROCEDURE Check_GroupRole
1255: (
1256: p_api_version IN NUMBER,
1257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1259: x_return_status OUT NOCOPY VARCHAR2,
1260: x_msg_count OUT NOCOPY NUMBER,
1261: x_msg_data OUT NOCOPY VARCHAR2,
1262: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1262: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1259: x_return_status OUT NOCOPY VARCHAR2,
1260: x_msg_count OUT NOCOPY NUMBER,
1261: x_msg_data OUT NOCOPY VARCHAR2,
1262: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1263: p_group_id IN NUMBER,
1264: p_role_id IN NUMBER,
1265: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
1266: x_result_flag OUT NOCOPY VARCHAR2

Line 1265: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,

1261: x_msg_data OUT NOCOPY VARCHAR2,
1262: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1263: p_group_id IN NUMBER,
1264: p_role_id IN NUMBER,
1265: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
1266: x_result_flag OUT NOCOPY VARCHAR2
1267: );
1268: --------------------------------------------------------------------------------
1269: ---------------------------------- GROUP ---------------------------------------

Line 1279: -- Default = FND_API.G_FALSE

1275: -- Function : Create a resource group
1276: -- Parameters :
1277: -- IN p_api_version NUMBER Required
1278: -- p_init_msg_list VARCHAR2 Optional
1279: -- Default = FND_API.G_FALSE
1280: -- p_commit VARCHAR2 Optional
1281: -- Default = FND_API.G_FALSE
1282: -- p_validation_level NUMBER Optional
1283: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1281: -- Default = FND_API.G_FALSE

1277: -- IN p_api_version NUMBER Required
1278: -- p_init_msg_list VARCHAR2 Optional
1279: -- Default = FND_API.G_FALSE
1280: -- p_commit VARCHAR2 Optional
1281: -- Default = FND_API.G_FALSE
1282: -- p_validation_level NUMBER Optional
1283: -- Default = FND_API.G_VALID_LEVEL_FULL
1284: -- p_check_login_user VARCHAR2 Optional
1285: -- Default = FND_API.G_TRUE

Line 1283: -- Default = FND_API.G_VALID_LEVEL_FULL

1279: -- Default = FND_API.G_FALSE
1280: -- p_commit VARCHAR2 Optional
1281: -- Default = FND_API.G_FALSE
1282: -- p_validation_level NUMBER Optional
1283: -- Default = FND_API.G_VALID_LEVEL_FULL
1284: -- p_check_login_user VARCHAR2 Optional
1285: -- Default = FND_API.G_TRUE
1286: -- Flag for checking user privilege and if user is login.
1287: -- p_group_name VARCHAR2 Required

Line 1285: -- Default = FND_API.G_TRUE

1281: -- Default = FND_API.G_FALSE
1282: -- p_validation_level NUMBER Optional
1283: -- Default = FND_API.G_VALID_LEVEL_FULL
1284: -- p_check_login_user VARCHAR2 Optional
1285: -- Default = FND_API.G_TRUE
1286: -- Flag for checking user privilege and if user is login.
1287: -- p_group_name VARCHAR2 Required
1288: -- group name are unique
1289: -- p_group_desc VARCHAR2 Optional

Line 1310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1306: --
1307: PROCEDURE Add_Group
1308: (
1309: p_api_version IN NUMBER,
1310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1313: x_return_status OUT NOCOPY VARCHAR2,
1314: x_msg_count OUT NOCOPY NUMBER,

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

1307: PROCEDURE Add_Group
1308: (
1309: p_api_version IN NUMBER,
1310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1313: x_return_status OUT NOCOPY VARCHAR2,
1314: x_msg_count OUT NOCOPY NUMBER,
1315: x_msg_data OUT NOCOPY VARCHAR2,

Line 1312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1308: (
1309: p_api_version IN NUMBER,
1310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1313: x_return_status OUT NOCOPY VARCHAR2,
1314: x_msg_count OUT NOCOPY NUMBER,
1315: x_msg_data OUT NOCOPY VARCHAR2,
1316: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1316: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1313: x_return_status OUT NOCOPY VARCHAR2,
1314: x_msg_count OUT NOCOPY NUMBER,
1315: x_msg_data OUT NOCOPY VARCHAR2,
1316: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1317: p_group_name IN VARCHAR2,
1318: p_group_desc IN VARCHAR2 := NULL,
1319: p_group_usage IN VARCHAR2,
1320: p_email_address IN VARCHAR2 := NULL,

Line 1334: -- Default = FND_API.G_FALSE

1330: -- Function : Update a resource group
1331: -- Parameters :
1332: -- IN p_api_version NUMBER Required
1333: -- p_init_msg_list VARCHAR2 Optional
1334: -- Default = FND_API.G_FALSE
1335: -- p_commit VARCHAR2 Optional
1336: -- Default = FND_API.G_FALSE
1337: -- p_validation_level NUMBER Optional
1338: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1336: -- Default = FND_API.G_FALSE

1332: -- IN p_api_version NUMBER Required
1333: -- p_init_msg_list VARCHAR2 Optional
1334: -- Default = FND_API.G_FALSE
1335: -- p_commit VARCHAR2 Optional
1336: -- Default = FND_API.G_FALSE
1337: -- p_validation_level NUMBER Optional
1338: -- Default = FND_API.G_VALID_LEVEL_FULL
1339: -- p_check_login_user VARCHAR2 Optional
1340: -- Default = FND_API.G_TRUE

Line 1338: -- Default = FND_API.G_VALID_LEVEL_FULL

1334: -- Default = FND_API.G_FALSE
1335: -- p_commit VARCHAR2 Optional
1336: -- Default = FND_API.G_FALSE
1337: -- p_validation_level NUMBER Optional
1338: -- Default = FND_API.G_VALID_LEVEL_FULL
1339: -- p_check_login_user VARCHAR2 Optional
1340: -- Default = FND_API.G_TRUE
1341: -- Flag for checking user privilege and if user is login.
1342: -- p_group_id NUMBER Required

Line 1340: -- Default = FND_API.G_TRUE

1336: -- Default = FND_API.G_FALSE
1337: -- p_validation_level NUMBER Optional
1338: -- Default = FND_API.G_VALID_LEVEL_FULL
1339: -- p_check_login_user VARCHAR2 Optional
1340: -- Default = FND_API.G_TRUE
1341: -- Flag for checking user privilege and if user is login.
1342: -- p_group_id NUMBER Required
1343: -- p_new_group_name VARCHAR2 Optional
1344: -- default FND_API.G_MISS_CHAR

Line 1344: -- default FND_API.G_MISS_CHAR

1340: -- Default = FND_API.G_TRUE
1341: -- Flag for checking user privilege and if user is login.
1342: -- p_group_id NUMBER Required
1343: -- p_new_group_name VARCHAR2 Optional
1344: -- default FND_API.G_MISS_CHAR
1345: -- p_new_group_desc VARCHAR2 Optional
1346: -- default FND_API.G_MISS_CHAR
1347: -- p_new_start_date DATE Optional
1348: -- default FND_API.G_MISS_DATE

Line 1346: -- default FND_API.G_MISS_CHAR

1342: -- p_group_id NUMBER Required
1343: -- p_new_group_name VARCHAR2 Optional
1344: -- default FND_API.G_MISS_CHAR
1345: -- p_new_group_desc VARCHAR2 Optional
1346: -- default FND_API.G_MISS_CHAR
1347: -- p_new_start_date DATE Optional
1348: -- default FND_API.G_MISS_DATE
1349: -- p_new_end_date DATE Optional
1350: -- default FND_API.G_MISS_DATE

Line 1348: -- default FND_API.G_MISS_DATE

1344: -- default FND_API.G_MISS_CHAR
1345: -- p_new_group_desc VARCHAR2 Optional
1346: -- default FND_API.G_MISS_CHAR
1347: -- p_new_start_date DATE Optional
1348: -- default FND_API.G_MISS_DATE
1349: -- p_new_end_date DATE Optional
1350: -- default FND_API.G_MISS_DATE
1351: -- OUT : x_return_status VARCHAR2
1352: -- x_msg_count NUMBER

Line 1350: -- default FND_API.G_MISS_DATE

1346: -- default FND_API.G_MISS_CHAR
1347: -- p_new_start_date DATE Optional
1348: -- default FND_API.G_MISS_DATE
1349: -- p_new_end_date DATE Optional
1350: -- default FND_API.G_MISS_DATE
1351: -- OUT : x_return_status VARCHAR2
1352: -- x_msg_count NUMBER
1353: -- x_msg_data VARCHAR2
1354: -- Version : Current version 1.0

Line 1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1359: --
1360: PROCEDURE Update_Group
1361: (
1362: p_api_version IN NUMBER,
1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_count OUT NOCOPY NUMBER,

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

1360: PROCEDURE Update_Group
1361: (
1362: p_api_version IN NUMBER,
1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_count OUT NOCOPY NUMBER,
1368: x_msg_data OUT NOCOPY VARCHAR2,

Line 1365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1361: (
1362: p_api_version IN NUMBER,
1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_count OUT NOCOPY NUMBER,
1368: x_msg_data OUT NOCOPY VARCHAR2,
1369: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1369: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_count OUT NOCOPY NUMBER,
1368: x_msg_data OUT NOCOPY VARCHAR2,
1369: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1370: p_group_id IN NUMBER,
1371: p_new_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_new_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1373: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,

Line 1371: p_new_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1367: x_msg_count OUT NOCOPY NUMBER,
1368: x_msg_data OUT NOCOPY VARCHAR2,
1369: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1370: p_group_id IN NUMBER,
1371: p_new_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_new_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1373: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
1374: p_email_address IN VARCHAR2 := FND_API.G_MISS_CHAR,
1375: p_new_start_date IN DATE := FND_API.G_MISS_DATE,

Line 1372: p_new_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,

1368: x_msg_data OUT NOCOPY VARCHAR2,
1369: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1370: p_group_id IN NUMBER,
1371: p_new_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_new_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1373: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
1374: p_email_address IN VARCHAR2 := FND_API.G_MISS_CHAR,
1375: p_new_start_date IN DATE := FND_API.G_MISS_DATE,
1376: p_new_end_date IN DATE := FND_API.G_MISS_DATE

Line 1374: p_email_address IN VARCHAR2 := FND_API.G_MISS_CHAR,

1370: p_group_id IN NUMBER,
1371: p_new_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_new_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1373: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
1374: p_email_address IN VARCHAR2 := FND_API.G_MISS_CHAR,
1375: p_new_start_date IN DATE := FND_API.G_MISS_DATE,
1376: p_new_end_date IN DATE := FND_API.G_MISS_DATE
1377: );
1378: --------------------------------------------------------------------------------

Line 1375: p_new_start_date IN DATE := FND_API.G_MISS_DATE,

1371: p_new_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372: p_new_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1373: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
1374: p_email_address IN VARCHAR2 := FND_API.G_MISS_CHAR,
1375: p_new_start_date IN DATE := FND_API.G_MISS_DATE,
1376: p_new_end_date IN DATE := FND_API.G_MISS_DATE
1377: );
1378: --------------------------------------------------------------------------------
1379: -- Start of comments

Line 1376: p_new_end_date IN DATE := FND_API.G_MISS_DATE

1372: p_new_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1373: p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
1374: p_email_address IN VARCHAR2 := FND_API.G_MISS_CHAR,
1375: p_new_start_date IN DATE := FND_API.G_MISS_DATE,
1376: p_new_end_date IN DATE := FND_API.G_MISS_DATE
1377: );
1378: --------------------------------------------------------------------------------
1379: -- Start of comments
1380: -- API name : Delete_Group

Line 1387: -- Default = FND_API.G_FALSE

1383: -- Function : Delete a resource group
1384: -- Parameters :
1385: -- IN p_api_version NUMBER Required
1386: -- p_init_msg_list VARCHAR2 Optional
1387: -- Default = FND_API.G_FALSE
1388: -- p_commit VARCHAR2 Optional
1389: -- Default = FND_API.G_FALSE
1390: -- p_validation_level NUMBER Optional
1391: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1389: -- Default = FND_API.G_FALSE

1385: -- IN p_api_version NUMBER Required
1386: -- p_init_msg_list VARCHAR2 Optional
1387: -- Default = FND_API.G_FALSE
1388: -- p_commit VARCHAR2 Optional
1389: -- Default = FND_API.G_FALSE
1390: -- p_validation_level NUMBER Optional
1391: -- Default = FND_API.G_VALID_LEVEL_FULL
1392: -- p_check_login_user VARCHAR2 Optional
1393: -- Default = FND_API.G_TRUE

Line 1391: -- Default = FND_API.G_VALID_LEVEL_FULL

1387: -- Default = FND_API.G_FALSE
1388: -- p_commit VARCHAR2 Optional
1389: -- Default = FND_API.G_FALSE
1390: -- p_validation_level NUMBER Optional
1391: -- Default = FND_API.G_VALID_LEVEL_FULL
1392: -- p_check_login_user VARCHAR2 Optional
1393: -- Default = FND_API.G_TRUE
1394: -- Flag for checking user privilege and if user is login.
1395: -- p_group_name VARCHAR2 Optional

Line 1393: -- Default = FND_API.G_TRUE

1389: -- Default = FND_API.G_FALSE
1390: -- p_validation_level NUMBER Optional
1391: -- Default = FND_API.G_VALID_LEVEL_FULL
1392: -- p_check_login_user VARCHAR2 Optional
1393: -- Default = FND_API.G_TRUE
1394: -- Flag for checking user privilege and if user is login.
1395: -- p_group_name VARCHAR2 Optional
1396: -- default FND_API.G_MISS_CHAR
1397: -- p_group_id NUMBER Optional

Line 1396: -- default FND_API.G_MISS_CHAR

1392: -- p_check_login_user VARCHAR2 Optional
1393: -- Default = FND_API.G_TRUE
1394: -- Flag for checking user privilege and if user is login.
1395: -- p_group_name VARCHAR2 Optional
1396: -- default FND_API.G_MISS_CHAR
1397: -- p_group_id NUMBER Optional
1398: -- default FND_API.G_MISS_NUM
1399: -- OUT : x_return_status VARCHAR2
1400: -- x_msg_count NUMBER

Line 1398: -- default FND_API.G_MISS_NUM

1394: -- Flag for checking user privilege and if user is login.
1395: -- p_group_name VARCHAR2 Optional
1396: -- default FND_API.G_MISS_CHAR
1397: -- p_group_id NUMBER Optional
1398: -- default FND_API.G_MISS_NUM
1399: -- OUT : x_return_status VARCHAR2
1400: -- x_msg_count NUMBER
1401: -- x_msg_data VARCHAR2
1402: -- Version : Current version 1.0

Line 1411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1407: --
1408: PROCEDURE Delete_Group
1409: (
1410: p_api_version IN NUMBER,
1411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1412: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1414: x_return_status OUT NOCOPY VARCHAR2,
1415: x_msg_count OUT NOCOPY NUMBER,

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

1408: PROCEDURE Delete_Group
1409: (
1410: p_api_version IN NUMBER,
1411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1412: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1414: x_return_status OUT NOCOPY VARCHAR2,
1415: x_msg_count OUT NOCOPY NUMBER,
1416: x_msg_data OUT NOCOPY VARCHAR2,

Line 1413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1409: (
1410: p_api_version IN NUMBER,
1411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1412: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1414: x_return_status OUT NOCOPY VARCHAR2,
1415: x_msg_count OUT NOCOPY NUMBER,
1416: x_msg_data OUT NOCOPY VARCHAR2,
1417: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1417: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1414: x_return_status OUT NOCOPY VARCHAR2,
1415: x_msg_count OUT NOCOPY NUMBER,
1416: x_msg_data OUT NOCOPY VARCHAR2,
1417: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1418: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1419: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR
1420: );
1421: --------------------------------------------------------------------------------

Line 1418: p_group_id IN NUMBER := FND_API.G_MISS_NUM,

1414: x_return_status OUT NOCOPY VARCHAR2,
1415: x_msg_count OUT NOCOPY NUMBER,
1416: x_msg_data OUT NOCOPY VARCHAR2,
1417: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1418: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1419: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR
1420: );
1421: --------------------------------------------------------------------------------
1422: -- Start of comments

Line 1419: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR

1415: x_msg_count OUT NOCOPY NUMBER,
1416: x_msg_data OUT NOCOPY VARCHAR2,
1417: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1418: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1419: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR
1420: );
1421: --------------------------------------------------------------------------------
1422: -- Start of comments
1423: -- API name : Get_Group

Line 1430: -- Default = FND_API.G_FALSE

1426: -- Function : Get a resource group information based on the passed id.
1427: -- Parameters :
1428: -- IN p_api_version NUMBER Required
1429: -- p_init_msg_list VARCHAR2 Optional
1430: -- Default = FND_API.G_FALSE
1431: -- p_validation_level NUMBER Optional
1432: -- Default = FND_API.G_VALID_LEVEL_FULL
1433: -- p_check_login_user VARCHAR2 Optional
1434: -- Default = FND_API.G_TRUE

Line 1432: -- Default = FND_API.G_VALID_LEVEL_FULL

1428: -- IN p_api_version NUMBER Required
1429: -- p_init_msg_list VARCHAR2 Optional
1430: -- Default = FND_API.G_FALSE
1431: -- p_validation_level NUMBER Optional
1432: -- Default = FND_API.G_VALID_LEVEL_FULL
1433: -- p_check_login_user VARCHAR2 Optional
1434: -- Default = FND_API.G_TRUE
1435: -- Flag for checking user privilege and if user is login.
1436: -- p_group_id NUMBER Required

Line 1434: -- Default = FND_API.G_TRUE

1430: -- Default = FND_API.G_FALSE
1431: -- p_validation_level NUMBER Optional
1432: -- Default = FND_API.G_VALID_LEVEL_FULL
1433: -- p_check_login_user VARCHAR2 Optional
1434: -- Default = FND_API.G_TRUE
1435: -- Flag for checking user privilege and if user is login.
1436: -- p_group_id NUMBER Required
1437: -- OUT : x_return_status VARCHAR2
1438: -- x_msg_count NUMBER

Line 1450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1446: --
1447: PROCEDURE Get_Group
1448: (
1449: p_api_version IN NUMBER,
1450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1451: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,
1454: x_msg_data OUT NOCOPY VARCHAR2,

Line 1451: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1447: PROCEDURE Get_Group
1448: (
1449: p_api_version IN NUMBER,
1450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1451: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,
1454: x_msg_data OUT NOCOPY VARCHAR2,
1455: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1455: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1451: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,
1454: x_msg_data OUT NOCOPY VARCHAR2,
1455: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1456: p_group_id IN NUMBER,
1457: x_group_obj OUT NOCOPY AMV_GROUP_OBJ_TYPE
1458: );
1459: --------------------------------------------------------------------------------

Line 1468: -- Default = FND_API.G_FALSE

1464: -- Function : Query for resource groups
1465: -- Parameters :
1466: -- IN p_api_version NUMBER Required
1467: -- p_init_msg_list VARCHAR2 Optional
1468: -- Default = FND_API.G_FALSE
1469: -- p_validation_level NUMBER Optional
1470: -- Default = FND_API.G_VALID_LEVEL_FULL
1471: -- p_check_login_user VARCHAR2 Optional
1472: -- Default = FND_API.G_TRUE

Line 1470: -- Default = FND_API.G_VALID_LEVEL_FULL

1466: -- IN p_api_version NUMBER Required
1467: -- p_init_msg_list VARCHAR2 Optional
1468: -- Default = FND_API.G_FALSE
1469: -- p_validation_level NUMBER Optional
1470: -- Default = FND_API.G_VALID_LEVEL_FULL
1471: -- p_check_login_user VARCHAR2 Optional
1472: -- Default = FND_API.G_TRUE
1473: -- Flag for checking user privilege and if user is login.
1474: -- p_resource_id NUMBER Optional

Line 1472: -- Default = FND_API.G_TRUE

1468: -- Default = FND_API.G_FALSE
1469: -- p_validation_level NUMBER Optional
1470: -- Default = FND_API.G_VALID_LEVEL_FULL
1471: -- p_check_login_user VARCHAR2 Optional
1472: -- Default = FND_API.G_TRUE
1473: -- Flag for checking user privilege and if user is login.
1474: -- p_resource_id NUMBER Optional
1475: -- default FND_API.G_MISS_NUM,
1476: -- p_group_name VARCHAR2 Optional

Line 1475: -- default FND_API.G_MISS_NUM,

1471: -- p_check_login_user VARCHAR2 Optional
1472: -- Default = FND_API.G_TRUE
1473: -- Flag for checking user privilege and if user is login.
1474: -- p_resource_id NUMBER Optional
1475: -- default FND_API.G_MISS_NUM,
1476: -- p_group_name VARCHAR2 Optional
1477: -- default FND_API.G_MISS_CHAR
1478: -- p_group_desc VARCHAR2 Optional
1479: -- default FND_API.G_MISS_CHAR

Line 1477: -- default FND_API.G_MISS_CHAR

1473: -- Flag for checking user privilege and if user is login.
1474: -- p_resource_id NUMBER Optional
1475: -- default FND_API.G_MISS_NUM,
1476: -- p_group_name VARCHAR2 Optional
1477: -- default FND_API.G_MISS_CHAR
1478: -- p_group_desc VARCHAR2 Optional
1479: -- default FND_API.G_MISS_CHAR
1480: -- p_owner_id NUMBER Optional
1481: -- default FND_API.G_MISS_NUM

Line 1479: -- default FND_API.G_MISS_CHAR

1475: -- default FND_API.G_MISS_NUM,
1476: -- p_group_name VARCHAR2 Optional
1477: -- default FND_API.G_MISS_CHAR
1478: -- p_group_desc VARCHAR2 Optional
1479: -- default FND_API.G_MISS_CHAR
1480: -- p_owner_id NUMBER Optional
1481: -- default FND_API.G_MISS_NUM
1482: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
1483: -- Required.

Line 1481: -- default FND_API.G_MISS_NUM

1477: -- default FND_API.G_MISS_CHAR
1478: -- p_group_desc VARCHAR2 Optional
1479: -- default FND_API.G_MISS_CHAR
1480: -- p_owner_id NUMBER Optional
1481: -- default FND_API.G_MISS_NUM
1482: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
1483: -- Required.
1484: -- OUT : x_return_status VARCHAR2
1485: -- x_msg_count NUMBER

Line 1498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1494: --
1495: PROCEDURE Find_Group
1496: (
1497: p_api_version IN NUMBER,
1498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,

Line 1499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1495: PROCEDURE Find_Group
1496: (
1497: p_api_version IN NUMBER,
1498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,
1503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,
1503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1504: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1505: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1506: p_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1507: p_group_email IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1504: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,
1503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1504: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1505: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1506: p_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1507: p_group_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
1508: p_group_usage IN VARCHAR2,

Line 1505: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,
1503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1504: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1505: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1506: p_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1507: p_group_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
1508: p_group_usage IN VARCHAR2,
1509: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,

Line 1506: p_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,

1502: x_msg_data OUT NOCOPY VARCHAR2,
1503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1504: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1505: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1506: p_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1507: p_group_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
1508: p_group_usage IN VARCHAR2,
1509: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1510: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 1507: p_group_email IN VARCHAR2 := FND_API.G_MISS_CHAR,

1503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1504: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1505: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1506: p_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1507: p_group_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
1508: p_group_usage IN VARCHAR2,
1509: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1510: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
1511: x_group_obj_array OUT NOCOPY AMV_GROUP_OBJ_VARRAY

Line 1522: -- Default = FND_API.G_FALSE

1518: -- Function : Query for resource groups
1519: -- Parameters :
1520: -- IN p_api_version NUMBER Required
1521: -- p_init_msg_list VARCHAR2 Optional
1522: -- Default = FND_API.G_FALSE
1523: -- p_validation_level NUMBER Optional
1524: -- Default = FND_API.G_VALID_LEVEL_FULL
1525: -- p_check_login_user VARCHAR2 Optional
1526: -- Default = FND_API.G_TRUE

Line 1524: -- Default = FND_API.G_VALID_LEVEL_FULL

1520: -- IN p_api_version NUMBER Required
1521: -- p_init_msg_list VARCHAR2 Optional
1522: -- Default = FND_API.G_FALSE
1523: -- p_validation_level NUMBER Optional
1524: -- Default = FND_API.G_VALID_LEVEL_FULL
1525: -- p_check_login_user VARCHAR2 Optional
1526: -- Default = FND_API.G_TRUE
1527: -- Flag for checking user privilege and if user is login.
1528: -- p_resource_id NUMBER Optional

Line 1526: -- Default = FND_API.G_TRUE

1522: -- Default = FND_API.G_FALSE
1523: -- p_validation_level NUMBER Optional
1524: -- Default = FND_API.G_VALID_LEVEL_FULL
1525: -- p_check_login_user VARCHAR2 Optional
1526: -- Default = FND_API.G_TRUE
1527: -- Flag for checking user privilege and if user is login.
1528: -- p_resource_id NUMBER Optional
1529: -- default FND_API.G_MISS_NUM,
1530: -- p_group_name VARCHAR2 Optional

Line 1529: -- default FND_API.G_MISS_NUM,

1525: -- p_check_login_user VARCHAR2 Optional
1526: -- Default = FND_API.G_TRUE
1527: -- Flag for checking user privilege and if user is login.
1528: -- p_resource_id NUMBER Optional
1529: -- default FND_API.G_MISS_NUM,
1530: -- p_group_name VARCHAR2 Optional
1531: -- default FND_API.G_MISS_CHAR
1532: -- p_group_desc VARCHAR2 Optional
1533: -- default FND_API.G_MISS_CHAR

Line 1531: -- default FND_API.G_MISS_CHAR

1527: -- Flag for checking user privilege and if user is login.
1528: -- p_resource_id NUMBER Optional
1529: -- default FND_API.G_MISS_NUM,
1530: -- p_group_name VARCHAR2 Optional
1531: -- default FND_API.G_MISS_CHAR
1532: -- p_group_desc VARCHAR2 Optional
1533: -- default FND_API.G_MISS_CHAR
1534: -- p_owner_id NUMBER Optional
1535: -- default FND_API.G_MISS_NUM

Line 1533: -- default FND_API.G_MISS_CHAR

1529: -- default FND_API.G_MISS_NUM,
1530: -- p_group_name VARCHAR2 Optional
1531: -- default FND_API.G_MISS_CHAR
1532: -- p_group_desc VARCHAR2 Optional
1533: -- default FND_API.G_MISS_CHAR
1534: -- p_owner_id NUMBER Optional
1535: -- default FND_API.G_MISS_NUM
1536: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
1537: -- Required.

Line 1535: -- default FND_API.G_MISS_NUM

1531: -- default FND_API.G_MISS_CHAR
1532: -- p_group_desc VARCHAR2 Optional
1533: -- default FND_API.G_MISS_CHAR
1534: -- p_owner_id NUMBER Optional
1535: -- default FND_API.G_MISS_NUM
1536: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
1537: -- Required.
1538: -- OUT : x_return_status VARCHAR2
1539: -- x_msg_count NUMBER

Line 1552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1548: --
1549: PROCEDURE Find_Group
1550: (
1551: p_api_version IN NUMBER,
1552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,

Line 1553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1549: PROCEDURE Find_Group
1550: (
1551: p_api_version IN NUMBER,
1552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1557: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1558: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1559: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1560: p_group_usage IN VARCHAR2,
1561: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,

Line 1558: p_group_id IN NUMBER := FND_API.G_MISS_NUM,

1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1558: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1559: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1560: p_group_usage IN VARCHAR2,
1561: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1562: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 1559: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1558: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1559: p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1560: p_group_usage IN VARCHAR2,
1561: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1562: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
1563: x_group_obj_array OUT NOCOPY AMV_GROUP_OBJ_VARRAY,

Line 1577: -- Default = FND_API.G_FALSE

1573: -- Function : Add a resource to a group.
1574: -- Parameters :
1575: -- IN p_api_version NUMBER Required
1576: -- p_init_msg_list VARCHAR2 Optional
1577: -- Default = FND_API.G_FALSE
1578: -- p_commit VARCHAR2 Optional
1579: -- Default = FND_API.G_FALSE
1580: -- p_validation_level NUMBER Optional
1581: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1579: -- Default = FND_API.G_FALSE

1575: -- IN p_api_version NUMBER Required
1576: -- p_init_msg_list VARCHAR2 Optional
1577: -- Default = FND_API.G_FALSE
1578: -- p_commit VARCHAR2 Optional
1579: -- Default = FND_API.G_FALSE
1580: -- p_validation_level NUMBER Optional
1581: -- Default = FND_API.G_VALID_LEVEL_FULL
1582: -- p_check_login_user VARCHAR2 Optional
1583: -- Default = FND_API.G_TRUE

Line 1581: -- Default = FND_API.G_VALID_LEVEL_FULL

1577: -- Default = FND_API.G_FALSE
1578: -- p_commit VARCHAR2 Optional
1579: -- Default = FND_API.G_FALSE
1580: -- p_validation_level NUMBER Optional
1581: -- Default = FND_API.G_VALID_LEVEL_FULL
1582: -- p_check_login_user VARCHAR2 Optional
1583: -- Default = FND_API.G_TRUE
1584: -- Flag for checking user privilege and if user is login.
1585: -- p_group_id NUMBER Required

Line 1583: -- Default = FND_API.G_TRUE

1579: -- Default = FND_API.G_FALSE
1580: -- p_validation_level NUMBER Optional
1581: -- Default = FND_API.G_VALID_LEVEL_FULL
1582: -- p_check_login_user VARCHAR2 Optional
1583: -- Default = FND_API.G_TRUE
1584: -- Flag for checking user privilege and if user is login.
1585: -- p_group_id NUMBER Required
1586: -- the id of the group
1587: -- p_resource_id NUMBER Required

Line 1604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1600: --
1601: PROCEDURE Add_GroupMember
1602: (
1603: p_api_version IN NUMBER,
1604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status OUT NOCOPY VARCHAR2,
1608: x_msg_count OUT NOCOPY NUMBER,

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

1601: PROCEDURE Add_GroupMember
1602: (
1603: p_api_version IN NUMBER,
1604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status OUT NOCOPY VARCHAR2,
1608: x_msg_count OUT NOCOPY NUMBER,
1609: x_msg_data OUT NOCOPY VARCHAR2,

Line 1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1602: (
1603: p_api_version IN NUMBER,
1604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status OUT NOCOPY VARCHAR2,
1608: x_msg_count OUT NOCOPY NUMBER,
1609: x_msg_data OUT NOCOPY VARCHAR2,
1610: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1610: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status OUT NOCOPY VARCHAR2,
1608: x_msg_count OUT NOCOPY NUMBER,
1609: x_msg_data OUT NOCOPY VARCHAR2,
1610: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1611: p_group_id IN NUMBER,
1612: p_resource_id IN NUMBER
1613: );
1614: --------------------------------------------------------------------------------

Line 1623: -- Default = FND_API.G_FALSE

1619: -- Function : Add a few resources to a group.
1620: -- Parameters :
1621: -- IN p_api_version NUMBER Required
1622: -- p_init_msg_list VARCHAR2 Optional
1623: -- Default = FND_API.G_FALSE
1624: -- p_commit VARCHAR2 Optional
1625: -- Default = FND_API.G_FALSE
1626: -- p_validation_level NUMBER Optional
1627: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1625: -- Default = FND_API.G_FALSE

1621: -- IN p_api_version NUMBER Required
1622: -- p_init_msg_list VARCHAR2 Optional
1623: -- Default = FND_API.G_FALSE
1624: -- p_commit VARCHAR2 Optional
1625: -- Default = FND_API.G_FALSE
1626: -- p_validation_level NUMBER Optional
1627: -- Default = FND_API.G_VALID_LEVEL_FULL
1628: -- p_check_login_user VARCHAR2 Optional
1629: -- Default = FND_API.G_TRUE

Line 1627: -- Default = FND_API.G_VALID_LEVEL_FULL

1623: -- Default = FND_API.G_FALSE
1624: -- p_commit VARCHAR2 Optional
1625: -- Default = FND_API.G_FALSE
1626: -- p_validation_level NUMBER Optional
1627: -- Default = FND_API.G_VALID_LEVEL_FULL
1628: -- p_check_login_user VARCHAR2 Optional
1629: -- Default = FND_API.G_TRUE
1630: -- Flag for checking user privilege and if user is login.
1631: -- p_group_id NUMBER Required

Line 1629: -- Default = FND_API.G_TRUE

1625: -- Default = FND_API.G_FALSE
1626: -- p_validation_level NUMBER Optional
1627: -- Default = FND_API.G_VALID_LEVEL_FULL
1628: -- p_check_login_user VARCHAR2 Optional
1629: -- Default = FND_API.G_TRUE
1630: -- Flag for checking user privilege and if user is login.
1631: -- p_group_id NUMBER Required
1632: -- p_resource_id_varray AMV_NUMBER_VARRAY_TYPE
1633: -- OUT : x_return_status VARCHAR2

Line 1645: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1641: --
1642: PROCEDURE Add_GroupMember
1643: (
1644: p_api_version IN NUMBER,
1645: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1646: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1647: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1648: x_return_status OUT NOCOPY VARCHAR2,
1649: x_msg_count OUT NOCOPY NUMBER,

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

1642: PROCEDURE Add_GroupMember
1643: (
1644: p_api_version IN NUMBER,
1645: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1646: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1647: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1648: x_return_status OUT NOCOPY VARCHAR2,
1649: x_msg_count OUT NOCOPY NUMBER,
1650: x_msg_data OUT NOCOPY VARCHAR2,

Line 1647: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1643: (
1644: p_api_version IN NUMBER,
1645: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1646: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1647: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1648: x_return_status OUT NOCOPY VARCHAR2,
1649: x_msg_count OUT NOCOPY NUMBER,
1650: x_msg_data OUT NOCOPY VARCHAR2,
1651: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1651: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1647: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1648: x_return_status OUT NOCOPY VARCHAR2,
1649: x_msg_count OUT NOCOPY NUMBER,
1650: x_msg_data OUT NOCOPY VARCHAR2,
1651: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1652: p_group_id IN NUMBER,
1653: p_resource_id_varray IN AMV_NUMBER_VARRAY_TYPE
1654: );
1655: --------------------------------------------------------------------------------

Line 1664: -- Default = FND_API.G_FALSE

1660: -- Function : Remove a resource from a group.
1661: -- Parameters :
1662: -- IN p_api_version NUMBER Required
1663: -- p_init_msg_list VARCHAR2 Optional
1664: -- Default = FND_API.G_FALSE
1665: -- p_commit VARCHAR2 Optional
1666: -- Default = FND_API.G_FALSE
1667: -- p_validation_level NUMBER Optional
1668: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1666: -- Default = FND_API.G_FALSE

1662: -- IN p_api_version NUMBER Required
1663: -- p_init_msg_list VARCHAR2 Optional
1664: -- Default = FND_API.G_FALSE
1665: -- p_commit VARCHAR2 Optional
1666: -- Default = FND_API.G_FALSE
1667: -- p_validation_level NUMBER Optional
1668: -- Default = FND_API.G_VALID_LEVEL_FULL
1669: -- p_check_login_user VARCHAR2 Optional
1670: -- Default = FND_API.G_TRUE

Line 1668: -- Default = FND_API.G_VALID_LEVEL_FULL

1664: -- Default = FND_API.G_FALSE
1665: -- p_commit VARCHAR2 Optional
1666: -- Default = FND_API.G_FALSE
1667: -- p_validation_level NUMBER Optional
1668: -- Default = FND_API.G_VALID_LEVEL_FULL
1669: -- p_check_login_user VARCHAR2 Optional
1670: -- Default = FND_API.G_TRUE
1671: -- Flag for checking user privilege and if user is login.
1672: -- p_group_id NUMBER Required

Line 1670: -- Default = FND_API.G_TRUE

1666: -- Default = FND_API.G_FALSE
1667: -- p_validation_level NUMBER Optional
1668: -- Default = FND_API.G_VALID_LEVEL_FULL
1669: -- p_check_login_user VARCHAR2 Optional
1670: -- Default = FND_API.G_TRUE
1671: -- Flag for checking user privilege and if user is login.
1672: -- p_group_id NUMBER Required
1673: -- the id of the group
1674: -- p_resource_id NUMBER Required

Line 1687: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1683: --
1684: PROCEDURE Remove_GroupMember
1685: (
1686: p_api_version IN NUMBER,
1687: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1688: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1689: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1690: x_return_status OUT NOCOPY VARCHAR2,
1691: x_msg_count OUT NOCOPY NUMBER,

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

1684: PROCEDURE Remove_GroupMember
1685: (
1686: p_api_version IN NUMBER,
1687: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1688: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1689: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1690: x_return_status OUT NOCOPY VARCHAR2,
1691: x_msg_count OUT NOCOPY NUMBER,
1692: x_msg_data OUT NOCOPY VARCHAR2,

Line 1689: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1685: (
1686: p_api_version IN NUMBER,
1687: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1688: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1689: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1690: x_return_status OUT NOCOPY VARCHAR2,
1691: x_msg_count OUT NOCOPY NUMBER,
1692: x_msg_data OUT NOCOPY VARCHAR2,
1693: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1693: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1689: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1690: x_return_status OUT NOCOPY VARCHAR2,
1691: x_msg_count OUT NOCOPY NUMBER,
1692: x_msg_data OUT NOCOPY VARCHAR2,
1693: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1694: p_group_id IN NUMBER,
1695: p_resource_id IN NUMBER
1696: );
1697: --------------------------------------------------------------------------------

Line 1706: -- Default = FND_API.G_FALSE

1702: -- Function : Remove a few resources from a group.
1703: -- Parameters :
1704: -- IN p_api_version NUMBER Required
1705: -- p_init_msg_list VARCHAR2 Optional
1706: -- Default = FND_API.G_FALSE
1707: -- p_commit VARCHAR2 Optional
1708: -- Default = FND_API.G_FALSE
1709: -- p_validation_level NUMBER Optional
1710: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1708: -- Default = FND_API.G_FALSE

1704: -- IN p_api_version NUMBER Required
1705: -- p_init_msg_list VARCHAR2 Optional
1706: -- Default = FND_API.G_FALSE
1707: -- p_commit VARCHAR2 Optional
1708: -- Default = FND_API.G_FALSE
1709: -- p_validation_level NUMBER Optional
1710: -- Default = FND_API.G_VALID_LEVEL_FULL
1711: -- p_check_login_user VARCHAR2 Optional
1712: -- Default = FND_API.G_TRUE

Line 1710: -- Default = FND_API.G_VALID_LEVEL_FULL

1706: -- Default = FND_API.G_FALSE
1707: -- p_commit VARCHAR2 Optional
1708: -- Default = FND_API.G_FALSE
1709: -- p_validation_level NUMBER Optional
1710: -- Default = FND_API.G_VALID_LEVEL_FULL
1711: -- p_check_login_user VARCHAR2 Optional
1712: -- Default = FND_API.G_TRUE
1713: -- Flag for checking user privilege and if user is login.
1714: -- p_group_id NUMBER Required

Line 1712: -- Default = FND_API.G_TRUE

1708: -- Default = FND_API.G_FALSE
1709: -- p_validation_level NUMBER Optional
1710: -- Default = FND_API.G_VALID_LEVEL_FULL
1711: -- p_check_login_user VARCHAR2 Optional
1712: -- Default = FND_API.G_TRUE
1713: -- Flag for checking user privilege and if user is login.
1714: -- p_group_id NUMBER Required
1715: -- p_resource_id_varray AMV_NUMBER_VARRAY_TYPE
1716: -- OUT : x_return_status VARCHAR2

Line 1728: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1724: --
1725: PROCEDURE Remove_GroupMember
1726: (
1727: p_api_version IN NUMBER,
1728: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1731: x_return_status OUT NOCOPY VARCHAR2,
1732: x_msg_count OUT NOCOPY NUMBER,

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

1725: PROCEDURE Remove_GroupMember
1726: (
1727: p_api_version IN NUMBER,
1728: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1731: x_return_status OUT NOCOPY VARCHAR2,
1732: x_msg_count OUT NOCOPY NUMBER,
1733: x_msg_data OUT NOCOPY VARCHAR2,

Line 1730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1726: (
1727: p_api_version IN NUMBER,
1728: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1731: x_return_status OUT NOCOPY VARCHAR2,
1732: x_msg_count OUT NOCOPY NUMBER,
1733: x_msg_data OUT NOCOPY VARCHAR2,
1734: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1734: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1731: x_return_status OUT NOCOPY VARCHAR2,
1732: x_msg_count OUT NOCOPY NUMBER,
1733: x_msg_data OUT NOCOPY VARCHAR2,
1734: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1735: p_group_id IN NUMBER,
1736: p_resource_id_varray IN AMV_NUMBER_VARRAY_TYPE
1737: );
1738: --------------------------------------------------------------------------------

Line 1747: -- Default = FND_API.G_FALSE

1743: -- Function : Check if a resource belong to a group.
1744: -- Parameters :
1745: -- IN p_api_version NUMBER Required
1746: -- p_init_msg_list VARCHAR2 Optional
1747: -- Default = FND_API.G_FALSE
1748: -- p_commit VARCHAR2 Optional
1749: -- Default = FND_API.G_FALSE
1750: -- p_validation_level NUMBER Optional
1751: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1749: -- Default = FND_API.G_FALSE

1745: -- IN p_api_version NUMBER Required
1746: -- p_init_msg_list VARCHAR2 Optional
1747: -- Default = FND_API.G_FALSE
1748: -- p_commit VARCHAR2 Optional
1749: -- Default = FND_API.G_FALSE
1750: -- p_validation_level NUMBER Optional
1751: -- Default = FND_API.G_VALID_LEVEL_FULL
1752: -- p_check_login_user VARCHAR2 Optional
1753: -- Default = FND_API.G_TRUE

Line 1751: -- Default = FND_API.G_VALID_LEVEL_FULL

1747: -- Default = FND_API.G_FALSE
1748: -- p_commit VARCHAR2 Optional
1749: -- Default = FND_API.G_FALSE
1750: -- p_validation_level NUMBER Optional
1751: -- Default = FND_API.G_VALID_LEVEL_FULL
1752: -- p_check_login_user VARCHAR2 Optional
1753: -- Default = FND_API.G_TRUE
1754: -- Flag for checking user privilege and if user is login.
1755: -- p_group_id NUMBER Required

Line 1753: -- Default = FND_API.G_TRUE

1749: -- Default = FND_API.G_FALSE
1750: -- p_validation_level NUMBER Optional
1751: -- Default = FND_API.G_VALID_LEVEL_FULL
1752: -- p_check_login_user VARCHAR2 Optional
1753: -- Default = FND_API.G_TRUE
1754: -- Flag for checking user privilege and if user is login.
1755: -- p_group_id NUMBER Required
1756: -- p_resource_id NUMBER Required
1757: -- p_check_effective_date VARCHAR2 Optional

Line 1758: -- default FND_API.G_TRUE

1754: -- Flag for checking user privilege and if user is login.
1755: -- p_group_id NUMBER Required
1756: -- p_resource_id NUMBER Required
1757: -- p_check_effective_date VARCHAR2 Optional
1758: -- default FND_API.G_TRUE
1759: -- OUT : x_return_status VARCHAR2
1760: -- x_msg_count NUMBER
1761: -- x_msg_data VARCHAR2
1762: -- x_result_flag VARCHAR2

Line 1772: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1768: --
1769: PROCEDURE Check_GroupMember
1770: (
1771: p_api_version IN NUMBER,
1772: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1774: x_return_status OUT NOCOPY VARCHAR2,
1775: x_msg_count OUT NOCOPY NUMBER,
1776: x_msg_data OUT NOCOPY VARCHAR2,

Line 1773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1769: PROCEDURE Check_GroupMember
1770: (
1771: p_api_version IN NUMBER,
1772: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1774: x_return_status OUT NOCOPY VARCHAR2,
1775: x_msg_count OUT NOCOPY NUMBER,
1776: x_msg_data OUT NOCOPY VARCHAR2,
1777: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1777: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1774: x_return_status OUT NOCOPY VARCHAR2,
1775: x_msg_count OUT NOCOPY NUMBER,
1776: x_msg_data OUT NOCOPY VARCHAR2,
1777: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1778: p_group_id IN NUMBER,
1779: p_resource_id IN NUMBER,
1780: x_result_flag OUT NOCOPY VARCHAR2
1781: );

Line 1792: -- Default = FND_API.G_FALSE

1788: -- Function : Get all the group resources given the group.
1789: -- Parameters :
1790: -- IN p_api_version NUMBER Required
1791: -- p_init_msg_list VARCHAR2 Optional
1792: -- Default = FND_API.G_FALSE
1793: -- p_validation_level NUMBER Optional
1794: -- Default = FND_API.G_VALID_LEVEL_FULL
1795: -- p_check_login_user VARCHAR2 Optional
1796: -- Default = FND_API.G_TRUE

Line 1794: -- Default = FND_API.G_VALID_LEVEL_FULL

1790: -- IN p_api_version NUMBER Required
1791: -- p_init_msg_list VARCHAR2 Optional
1792: -- Default = FND_API.G_FALSE
1793: -- p_validation_level NUMBER Optional
1794: -- Default = FND_API.G_VALID_LEVEL_FULL
1795: -- p_check_login_user VARCHAR2 Optional
1796: -- Default = FND_API.G_TRUE
1797: -- Flag for checking user privilege and if user is login.
1798: -- p_group_id NUMBER Optional

Line 1796: -- Default = FND_API.G_TRUE

1792: -- Default = FND_API.G_FALSE
1793: -- p_validation_level NUMBER Optional
1794: -- Default = FND_API.G_VALID_LEVEL_FULL
1795: -- p_check_login_user VARCHAR2 Optional
1796: -- Default = FND_API.G_TRUE
1797: -- Flag for checking user privilege and if user is login.
1798: -- p_group_id NUMBER Optional
1799: -- default FND_API.G_MISS_NUM,
1800: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE

Line 1799: -- default FND_API.G_MISS_NUM,

1795: -- p_check_login_user VARCHAR2 Optional
1796: -- Default = FND_API.G_TRUE
1797: -- Flag for checking user privilege and if user is login.
1798: -- p_group_id NUMBER Optional
1799: -- default FND_API.G_MISS_NUM,
1800: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
1801: -- Required.
1802: -- OUT : x_return_status VARCHAR2
1803: -- x_msg_count NUMBER

Line 1816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1812: --
1813: PROCEDURE Get_AllGroupMember
1814: (
1815: p_api_version IN NUMBER,
1816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1817: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1818: x_return_status OUT NOCOPY VARCHAR2,
1819: x_msg_count OUT NOCOPY NUMBER,
1820: x_msg_data OUT NOCOPY VARCHAR2,

Line 1817: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1813: PROCEDURE Get_AllGroupMember
1814: (
1815: p_api_version IN NUMBER,
1816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1817: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1818: x_return_status OUT NOCOPY VARCHAR2,
1819: x_msg_count OUT NOCOPY NUMBER,
1820: x_msg_data OUT NOCOPY VARCHAR2,
1821: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1821: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1817: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1818: x_return_status OUT NOCOPY VARCHAR2,
1819: x_msg_count OUT NOCOPY NUMBER,
1820: x_msg_data OUT NOCOPY VARCHAR2,
1821: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1822: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1823: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1824: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
1825: x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY

Line 1822: p_group_id IN NUMBER := FND_API.G_MISS_NUM,

1818: x_return_status OUT NOCOPY VARCHAR2,
1819: x_msg_count OUT NOCOPY NUMBER,
1820: x_msg_data OUT NOCOPY VARCHAR2,
1821: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1822: p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1823: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1824: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
1825: x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY
1826: );

Line 1840: -- Default = FND_API.G_FALSE

1836: -- Object can be application, channel, category, or item
1837: -- Parameters :
1838: -- IN p_api_version NUMBER Required
1839: -- p_init_msg_list VARCHAR2 Optional
1840: -- Default = FND_API.G_FALSE
1841: -- p_commit VARCHAR2 Optional
1842: -- Default = FND_API.G_FALSE
1843: -- p_validation_level NUMBER Optional
1844: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1842: -- Default = FND_API.G_FALSE

1838: -- IN p_api_version NUMBER Required
1839: -- p_init_msg_list VARCHAR2 Optional
1840: -- Default = FND_API.G_FALSE
1841: -- p_commit VARCHAR2 Optional
1842: -- Default = FND_API.G_FALSE
1843: -- p_validation_level NUMBER Optional
1844: -- Default = FND_API.G_VALID_LEVEL_FULL
1845: -- p_check_login_user VARCHAR2 Optional
1846: -- Default = FND_API.G_TRUE

Line 1844: -- Default = FND_API.G_VALID_LEVEL_FULL

1840: -- Default = FND_API.G_FALSE
1841: -- p_commit VARCHAR2 Optional
1842: -- Default = FND_API.G_FALSE
1843: -- p_validation_level NUMBER Optional
1844: -- Default = FND_API.G_VALID_LEVEL_FULL
1845: -- p_check_login_user VARCHAR2 Optional
1846: -- Default = FND_API.G_TRUE
1847: -- Flag for checking user privilege and if user is login.
1848: -- p_access_obj AMV_ACCESS_OBJ_TYPE

Line 1846: -- Default = FND_API.G_TRUE

1842: -- Default = FND_API.G_FALSE
1843: -- p_validation_level NUMBER Optional
1844: -- Default = FND_API.G_VALID_LEVEL_FULL
1845: -- p_check_login_user VARCHAR2 Optional
1846: -- Default = FND_API.G_TRUE
1847: -- Flag for checking user privilege and if user is login.
1848: -- p_access_obj AMV_ACCESS_OBJ_TYPE
1849: -- OUT : x_return_status VARCHAR2
1850: -- x_msg_count NUMBER

Line 1861: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1857: --
1858: PROCEDURE Update_Access
1859: (
1860: p_api_version IN NUMBER,
1861: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1862: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1863: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1864: x_return_status OUT NOCOPY VARCHAR2,
1865: x_msg_count OUT NOCOPY NUMBER,

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

1858: PROCEDURE Update_Access
1859: (
1860: p_api_version IN NUMBER,
1861: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1862: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1863: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1864: x_return_status OUT NOCOPY VARCHAR2,
1865: x_msg_count OUT NOCOPY NUMBER,
1866: x_msg_data OUT NOCOPY VARCHAR2,

Line 1863: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1859: (
1860: p_api_version IN NUMBER,
1861: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1862: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1863: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1864: x_return_status OUT NOCOPY VARCHAR2,
1865: x_msg_count OUT NOCOPY NUMBER,
1866: x_msg_data OUT NOCOPY VARCHAR2,
1867: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1867: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1863: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1864: x_return_status OUT NOCOPY VARCHAR2,
1865: x_msg_count OUT NOCOPY NUMBER,
1866: x_msg_data OUT NOCOPY VARCHAR2,
1867: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1868: p_access_obj IN AMV_ACCESS_OBJ_TYPE
1869: );
1870: --------------------------------------------------------------------------------
1871: -- Start of comments

Line 1880: -- Default = FND_API.G_FALSE

1876: -- Object can be application, channel, category, or item
1877: -- Parameters :
1878: -- IN p_api_version NUMBER Required
1879: -- p_init_msg_list VARCHAR2 Optional
1880: -- Default = FND_API.G_FALSE
1881: -- p_commit VARCHAR2 Optional
1882: -- Default = FND_API.G_FALSE
1883: -- p_validation_level NUMBER Optional
1884: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1882: -- Default = FND_API.G_FALSE

1878: -- IN p_api_version NUMBER Required
1879: -- p_init_msg_list VARCHAR2 Optional
1880: -- Default = FND_API.G_FALSE
1881: -- p_commit VARCHAR2 Optional
1882: -- Default = FND_API.G_FALSE
1883: -- p_validation_level NUMBER Optional
1884: -- Default = FND_API.G_VALID_LEVEL_FULL
1885: -- p_check_login_user VARCHAR2 Optional
1886: -- Default = FND_API.G_TRUE

Line 1884: -- Default = FND_API.G_VALID_LEVEL_FULL

1880: -- Default = FND_API.G_FALSE
1881: -- p_commit VARCHAR2 Optional
1882: -- Default = FND_API.G_FALSE
1883: -- p_validation_level NUMBER Optional
1884: -- Default = FND_API.G_VALID_LEVEL_FULL
1885: -- p_check_login_user VARCHAR2 Optional
1886: -- Default = FND_API.G_TRUE
1887: -- Flag for checking user privilege and if user is login.
1888: -- p_access_obj AMV_ACCESS_OBJ_TYPE

Line 1886: -- Default = FND_API.G_TRUE

1882: -- Default = FND_API.G_FALSE
1883: -- p_validation_level NUMBER Optional
1884: -- Default = FND_API.G_VALID_LEVEL_FULL
1885: -- p_check_login_user VARCHAR2 Optional
1886: -- Default = FND_API.G_TRUE
1887: -- Flag for checking user privilege and if user is login.
1888: -- p_access_obj AMV_ACCESS_OBJ_TYPE
1889: -- OUT : x_return_status VARCHAR2
1890: -- x_msg_count NUMBER

Line 1901: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1897: --
1898: PROCEDURE Update_Access
1899: (
1900: p_api_version IN NUMBER,
1901: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1902: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1904: x_return_status OUT NOCOPY VARCHAR2,
1905: x_msg_count OUT NOCOPY NUMBER,

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

1898: PROCEDURE Update_Access
1899: (
1900: p_api_version IN NUMBER,
1901: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1902: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1904: x_return_status OUT NOCOPY VARCHAR2,
1905: x_msg_count OUT NOCOPY NUMBER,
1906: x_msg_data OUT NOCOPY VARCHAR2,

Line 1903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1899: (
1900: p_api_version IN NUMBER,
1901: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1902: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1904: x_return_status OUT NOCOPY VARCHAR2,
1905: x_msg_count OUT NOCOPY NUMBER,
1906: x_msg_data OUT NOCOPY VARCHAR2,
1907: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1907: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1904: x_return_status OUT NOCOPY VARCHAR2,
1905: x_msg_count OUT NOCOPY NUMBER,
1906: x_msg_data OUT NOCOPY VARCHAR2,
1907: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1908: p_access_obj_array IN AMV_ACCESS_OBJ_VARRAY
1909: );
1910: --------------------------------------------------------------------------------
1911: -- Start of comments

Line 1919: -- Default = FND_API.G_FALSE

1915: -- Function : Update all the accesses of a resource with an application
1916: -- Parameters :
1917: -- IN p_api_version NUMBER Required
1918: -- p_init_msg_list VARCHAR2 Optional
1919: -- Default = FND_API.G_FALSE
1920: -- p_commit VARCHAR2 Optional
1921: -- Default = FND_API.G_FALSE
1922: -- p_validation_level NUMBER Optional
1923: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1921: -- Default = FND_API.G_FALSE

1917: -- IN p_api_version NUMBER Required
1918: -- p_init_msg_list VARCHAR2 Optional
1919: -- Default = FND_API.G_FALSE
1920: -- p_commit VARCHAR2 Optional
1921: -- Default = FND_API.G_FALSE
1922: -- p_validation_level NUMBER Optional
1923: -- Default = FND_API.G_VALID_LEVEL_FULL
1924: -- p_check_login_user VARCHAR2 Optional
1925: -- Default = FND_API.G_TRUE

Line 1923: -- Default = FND_API.G_VALID_LEVEL_FULL

1919: -- Default = FND_API.G_FALSE
1920: -- p_commit VARCHAR2 Optional
1921: -- Default = FND_API.G_FALSE
1922: -- p_validation_level NUMBER Optional
1923: -- Default = FND_API.G_VALID_LEVEL_FULL
1924: -- p_check_login_user VARCHAR2 Optional
1925: -- Default = FND_API.G_TRUE
1926: -- Flag for checking user privilege and if user is login.
1927: -- p_resource_id NUMBER Required

Line 1925: -- Default = FND_API.G_TRUE

1921: -- Default = FND_API.G_FALSE
1922: -- p_validation_level NUMBER Optional
1923: -- Default = FND_API.G_VALID_LEVEL_FULL
1924: -- p_check_login_user VARCHAR2 Optional
1925: -- Default = FND_API.G_TRUE
1926: -- Flag for checking user privilege and if user is login.
1927: -- p_resource_id NUMBER Required
1928: -- p_application_id NUMBER Required
1929: -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE

Line 1942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1938: --
1939: PROCEDURE Update_ResourceApplAccess
1940: (
1941: p_api_version IN NUMBER,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1943: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945: x_return_status OUT NOCOPY VARCHAR2,
1946: x_msg_count OUT NOCOPY NUMBER,

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

1939: PROCEDURE Update_ResourceApplAccess
1940: (
1941: p_api_version IN NUMBER,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1943: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945: x_return_status OUT NOCOPY VARCHAR2,
1946: x_msg_count OUT NOCOPY NUMBER,
1947: x_msg_data OUT NOCOPY VARCHAR2,

Line 1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1940: (
1941: p_api_version IN NUMBER,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1943: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945: x_return_status OUT NOCOPY VARCHAR2,
1946: x_msg_count OUT NOCOPY NUMBER,
1947: x_msg_data OUT NOCOPY VARCHAR2,
1948: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1948: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945: x_return_status OUT NOCOPY VARCHAR2,
1946: x_msg_count OUT NOCOPY NUMBER,
1947: x_msg_data OUT NOCOPY VARCHAR2,
1948: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1949: p_resource_id IN NUMBER,
1950: p_application_id IN NUMBER,
1951: p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
1952: );

Line 1962: -- Default = FND_API.G_FALSE

1958: -- Function : Update all the accesses of a resource with a channel
1959: -- Parameters :
1960: -- IN p_api_version NUMBER Required
1961: -- p_init_msg_list VARCHAR2 Optional
1962: -- Default = FND_API.G_FALSE
1963: -- p_commit VARCHAR2 Optional
1964: -- Default = FND_API.G_FALSE
1965: -- p_validation_level NUMBER Optional
1966: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1964: -- Default = FND_API.G_FALSE

1960: -- IN p_api_version NUMBER Required
1961: -- p_init_msg_list VARCHAR2 Optional
1962: -- Default = FND_API.G_FALSE
1963: -- p_commit VARCHAR2 Optional
1964: -- Default = FND_API.G_FALSE
1965: -- p_validation_level NUMBER Optional
1966: -- Default = FND_API.G_VALID_LEVEL_FULL
1967: -- p_check_login_user VARCHAR2 Optional
1968: -- Default = FND_API.G_TRUE

Line 1966: -- Default = FND_API.G_VALID_LEVEL_FULL

1962: -- Default = FND_API.G_FALSE
1963: -- p_commit VARCHAR2 Optional
1964: -- Default = FND_API.G_FALSE
1965: -- p_validation_level NUMBER Optional
1966: -- Default = FND_API.G_VALID_LEVEL_FULL
1967: -- p_check_login_user VARCHAR2 Optional
1968: -- Default = FND_API.G_TRUE
1969: -- Flag for checking user privilege and if user is login.
1970: -- p_resource_id NUMBER Required

Line 1968: -- Default = FND_API.G_TRUE

1964: -- Default = FND_API.G_FALSE
1965: -- p_validation_level NUMBER Optional
1966: -- Default = FND_API.G_VALID_LEVEL_FULL
1967: -- p_check_login_user VARCHAR2 Optional
1968: -- Default = FND_API.G_TRUE
1969: -- Flag for checking user privilege and if user is login.
1970: -- p_resource_id NUMBER Required
1971: -- p_channel_id NUMBER Required
1972: -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE

Line 1985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1981: --
1982: PROCEDURE Update_ResourceChanAccess
1983: (
1984: p_api_version IN NUMBER,
1985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1986: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1988: x_return_status OUT NOCOPY VARCHAR2,
1989: x_msg_count OUT NOCOPY NUMBER,

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

1982: PROCEDURE Update_ResourceChanAccess
1983: (
1984: p_api_version IN NUMBER,
1985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1986: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1988: x_return_status OUT NOCOPY VARCHAR2,
1989: x_msg_count OUT NOCOPY NUMBER,
1990: x_msg_data OUT NOCOPY VARCHAR2,

Line 1987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1983: (
1984: p_api_version IN NUMBER,
1985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1986: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1988: x_return_status OUT NOCOPY VARCHAR2,
1989: x_msg_count OUT NOCOPY NUMBER,
1990: x_msg_data OUT NOCOPY VARCHAR2,
1991: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1991: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1988: x_return_status OUT NOCOPY VARCHAR2,
1989: x_msg_count OUT NOCOPY NUMBER,
1990: x_msg_data OUT NOCOPY VARCHAR2,
1991: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1992: p_resource_id IN NUMBER,
1993: p_channel_id IN NUMBER,
1994: p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
1995: );

Line 2005: -- Default = FND_API.G_FALSE

2001: -- Function : Update all the accesses of a resource with a category
2002: -- Parameters :
2003: -- IN p_api_version NUMBER Required
2004: -- p_init_msg_list VARCHAR2 Optional
2005: -- Default = FND_API.G_FALSE
2006: -- p_commit VARCHAR2 Optional
2007: -- Default = FND_API.G_FALSE
2008: -- p_validation_level NUMBER Optional
2009: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2007: -- Default = FND_API.G_FALSE

2003: -- IN p_api_version NUMBER Required
2004: -- p_init_msg_list VARCHAR2 Optional
2005: -- Default = FND_API.G_FALSE
2006: -- p_commit VARCHAR2 Optional
2007: -- Default = FND_API.G_FALSE
2008: -- p_validation_level NUMBER Optional
2009: -- Default = FND_API.G_VALID_LEVEL_FULL
2010: -- p_check_login_user VARCHAR2 Optional
2011: -- Default = FND_API.G_TRUE

Line 2009: -- Default = FND_API.G_VALID_LEVEL_FULL

2005: -- Default = FND_API.G_FALSE
2006: -- p_commit VARCHAR2 Optional
2007: -- Default = FND_API.G_FALSE
2008: -- p_validation_level NUMBER Optional
2009: -- Default = FND_API.G_VALID_LEVEL_FULL
2010: -- p_check_login_user VARCHAR2 Optional
2011: -- Default = FND_API.G_TRUE
2012: -- Flag for checking user privilege and if user is login.
2013: -- p_resource_id NUMBER Required

Line 2011: -- Default = FND_API.G_TRUE

2007: -- Default = FND_API.G_FALSE
2008: -- p_validation_level NUMBER Optional
2009: -- Default = FND_API.G_VALID_LEVEL_FULL
2010: -- p_check_login_user VARCHAR2 Optional
2011: -- Default = FND_API.G_TRUE
2012: -- Flag for checking user privilege and if user is login.
2013: -- p_resource_id NUMBER Required
2014: -- p_category_id NUMBER Required
2015: -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE

Line 2028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2024: --
2025: PROCEDURE Update_ResourceCateAccess
2026: (
2027: p_api_version IN NUMBER,
2028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2029: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2030: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2031: x_return_status OUT NOCOPY VARCHAR2,
2032: x_msg_count OUT NOCOPY NUMBER,

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

2025: PROCEDURE Update_ResourceCateAccess
2026: (
2027: p_api_version IN NUMBER,
2028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2029: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2030: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2031: x_return_status OUT NOCOPY VARCHAR2,
2032: x_msg_count OUT NOCOPY NUMBER,
2033: x_msg_data OUT NOCOPY VARCHAR2,

Line 2030: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2026: (
2027: p_api_version IN NUMBER,
2028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2029: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2030: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2031: x_return_status OUT NOCOPY VARCHAR2,
2032: x_msg_count OUT NOCOPY NUMBER,
2033: x_msg_data OUT NOCOPY VARCHAR2,
2034: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2034: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2030: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2031: x_return_status OUT NOCOPY VARCHAR2,
2032: x_msg_count OUT NOCOPY NUMBER,
2033: x_msg_data OUT NOCOPY VARCHAR2,
2034: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2035: p_resource_id IN NUMBER,
2036: p_category_id IN NUMBER,
2037: p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2038: );

Line 2048: -- Default = FND_API.G_FALSE

2044: -- Function : Update all the accesses of a resource with a item
2045: -- Parameters :
2046: -- IN p_api_version NUMBER Required
2047: -- p_init_msg_list VARCHAR2 Optional
2048: -- Default = FND_API.G_FALSE
2049: -- p_commit VARCHAR2 Optional
2050: -- Default = FND_API.G_FALSE
2051: -- p_validation_level NUMBER Optional
2052: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2050: -- Default = FND_API.G_FALSE

2046: -- IN p_api_version NUMBER Required
2047: -- p_init_msg_list VARCHAR2 Optional
2048: -- Default = FND_API.G_FALSE
2049: -- p_commit VARCHAR2 Optional
2050: -- Default = FND_API.G_FALSE
2051: -- p_validation_level NUMBER Optional
2052: -- Default = FND_API.G_VALID_LEVEL_FULL
2053: -- p_check_login_user VARCHAR2 Optional
2054: -- Default = FND_API.G_TRUE

Line 2052: -- Default = FND_API.G_VALID_LEVEL_FULL

2048: -- Default = FND_API.G_FALSE
2049: -- p_commit VARCHAR2 Optional
2050: -- Default = FND_API.G_FALSE
2051: -- p_validation_level NUMBER Optional
2052: -- Default = FND_API.G_VALID_LEVEL_FULL
2053: -- p_check_login_user VARCHAR2 Optional
2054: -- Default = FND_API.G_TRUE
2055: -- Flag for checking user privilege and if user is login.
2056: -- p_resource_id NUMBER Required

Line 2054: -- Default = FND_API.G_TRUE

2050: -- Default = FND_API.G_FALSE
2051: -- p_validation_level NUMBER Optional
2052: -- Default = FND_API.G_VALID_LEVEL_FULL
2053: -- p_check_login_user VARCHAR2 Optional
2054: -- Default = FND_API.G_TRUE
2055: -- Flag for checking user privilege and if user is login.
2056: -- p_resource_id NUMBER Required
2057: -- p_item_id NUMBER Required
2058: -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE

Line 2071: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2067: --
2068: PROCEDURE Update_ResourceItemAccess
2069: (
2070: p_api_version IN NUMBER,
2071: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2072: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2073: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2074: x_return_status OUT NOCOPY VARCHAR2,
2075: x_msg_count OUT NOCOPY NUMBER,

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

2068: PROCEDURE Update_ResourceItemAccess
2069: (
2070: p_api_version IN NUMBER,
2071: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2072: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2073: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2074: x_return_status OUT NOCOPY VARCHAR2,
2075: x_msg_count OUT NOCOPY NUMBER,
2076: x_msg_data OUT NOCOPY VARCHAR2,

Line 2073: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2069: (
2070: p_api_version IN NUMBER,
2071: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2072: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2073: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2074: x_return_status OUT NOCOPY VARCHAR2,
2075: x_msg_count OUT NOCOPY NUMBER,
2076: x_msg_data OUT NOCOPY VARCHAR2,
2077: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2077: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2073: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2074: x_return_status OUT NOCOPY VARCHAR2,
2075: x_msg_count OUT NOCOPY NUMBER,
2076: x_msg_data OUT NOCOPY VARCHAR2,
2077: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2078: p_resource_id IN NUMBER,
2079: p_item_id IN NUMBER,
2080: p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2081: );

Line 2091: -- Default = FND_API.G_FALSE

2087: -- Function : Update all the accesses of a group with an application
2088: -- Parameters :
2089: -- IN p_api_version NUMBER Required
2090: -- p_init_msg_list VARCHAR2 Optional
2091: -- Default = FND_API.G_FALSE
2092: -- p_commit VARCHAR2 Optional
2093: -- Default = FND_API.G_FALSE
2094: -- p_validation_level NUMBER Optional
2095: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2093: -- Default = FND_API.G_FALSE

2089: -- IN p_api_version NUMBER Required
2090: -- p_init_msg_list VARCHAR2 Optional
2091: -- Default = FND_API.G_FALSE
2092: -- p_commit VARCHAR2 Optional
2093: -- Default = FND_API.G_FALSE
2094: -- p_validation_level NUMBER Optional
2095: -- Default = FND_API.G_VALID_LEVEL_FULL
2096: -- p_check_login_user VARCHAR2 Optional
2097: -- Default = FND_API.G_TRUE

Line 2095: -- Default = FND_API.G_VALID_LEVEL_FULL

2091: -- Default = FND_API.G_FALSE
2092: -- p_commit VARCHAR2 Optional
2093: -- Default = FND_API.G_FALSE
2094: -- p_validation_level NUMBER Optional
2095: -- Default = FND_API.G_VALID_LEVEL_FULL
2096: -- p_check_login_user VARCHAR2 Optional
2097: -- Default = FND_API.G_TRUE
2098: -- Flag for checking user privilege and if user is login.
2099: -- p_group_id NUMBER Required

Line 2097: -- Default = FND_API.G_TRUE

2093: -- Default = FND_API.G_FALSE
2094: -- p_validation_level NUMBER Optional
2095: -- Default = FND_API.G_VALID_LEVEL_FULL
2096: -- p_check_login_user VARCHAR2 Optional
2097: -- Default = FND_API.G_TRUE
2098: -- Flag for checking user privilege and if user is login.
2099: -- p_group_id NUMBER Required
2100: -- p_application_id NUMBER Required
2101: -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE

Line 2114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2110: --
2111: PROCEDURE Update_GroupApplAccess
2112: (
2113: p_api_version IN NUMBER,
2114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2117: x_return_status OUT NOCOPY VARCHAR2,
2118: x_msg_count OUT NOCOPY NUMBER,

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

2111: PROCEDURE Update_GroupApplAccess
2112: (
2113: p_api_version IN NUMBER,
2114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2117: x_return_status OUT NOCOPY VARCHAR2,
2118: x_msg_count OUT NOCOPY NUMBER,
2119: x_msg_data OUT NOCOPY VARCHAR2,

Line 2116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2112: (
2113: p_api_version IN NUMBER,
2114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2117: x_return_status OUT NOCOPY VARCHAR2,
2118: x_msg_count OUT NOCOPY NUMBER,
2119: x_msg_data OUT NOCOPY VARCHAR2,
2120: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2120: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2117: x_return_status OUT NOCOPY VARCHAR2,
2118: x_msg_count OUT NOCOPY NUMBER,
2119: x_msg_data OUT NOCOPY VARCHAR2,
2120: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2121: p_resource_id IN NUMBER,
2122: p_group_id IN NUMBER,
2123: p_application_id IN NUMBER,
2124: p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE

Line 2135: -- Default = FND_API.G_FALSE

2131: -- Function : Update all the accesses of a group with a channel
2132: -- Parameters :
2133: -- IN p_api_version NUMBER Required
2134: -- p_init_msg_list VARCHAR2 Optional
2135: -- Default = FND_API.G_FALSE
2136: -- p_commit VARCHAR2 Optional
2137: -- Default = FND_API.G_FALSE
2138: -- p_validation_level NUMBER Optional
2139: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2137: -- Default = FND_API.G_FALSE

2133: -- IN p_api_version NUMBER Required
2134: -- p_init_msg_list VARCHAR2 Optional
2135: -- Default = FND_API.G_FALSE
2136: -- p_commit VARCHAR2 Optional
2137: -- Default = FND_API.G_FALSE
2138: -- p_validation_level NUMBER Optional
2139: -- Default = FND_API.G_VALID_LEVEL_FULL
2140: -- p_check_login_user VARCHAR2 Optional
2141: -- Default = FND_API.G_TRUE

Line 2139: -- Default = FND_API.G_VALID_LEVEL_FULL

2135: -- Default = FND_API.G_FALSE
2136: -- p_commit VARCHAR2 Optional
2137: -- Default = FND_API.G_FALSE
2138: -- p_validation_level NUMBER Optional
2139: -- Default = FND_API.G_VALID_LEVEL_FULL
2140: -- p_check_login_user VARCHAR2 Optional
2141: -- Default = FND_API.G_TRUE
2142: -- Flag for checking user privilege and if user is login.
2143: -- p_group_id NUMBER Required

Line 2141: -- Default = FND_API.G_TRUE

2137: -- Default = FND_API.G_FALSE
2138: -- p_validation_level NUMBER Optional
2139: -- Default = FND_API.G_VALID_LEVEL_FULL
2140: -- p_check_login_user VARCHAR2 Optional
2141: -- Default = FND_API.G_TRUE
2142: -- Flag for checking user privilege and if user is login.
2143: -- p_group_id NUMBER Required
2144: -- p_channel_id NUMBER Required
2145: -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE

Line 2158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2154: --
2155: PROCEDURE Update_GroupChanAccess
2156: (
2157: p_api_version IN NUMBER,
2158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2161: x_return_status OUT NOCOPY VARCHAR2,
2162: x_msg_count OUT NOCOPY NUMBER,

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

2155: PROCEDURE Update_GroupChanAccess
2156: (
2157: p_api_version IN NUMBER,
2158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2161: x_return_status OUT NOCOPY VARCHAR2,
2162: x_msg_count OUT NOCOPY NUMBER,
2163: x_msg_data OUT NOCOPY VARCHAR2,

Line 2160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2156: (
2157: p_api_version IN NUMBER,
2158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2161: x_return_status OUT NOCOPY VARCHAR2,
2162: x_msg_count OUT NOCOPY NUMBER,
2163: x_msg_data OUT NOCOPY VARCHAR2,
2164: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2164: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2161: x_return_status OUT NOCOPY VARCHAR2,
2162: x_msg_count OUT NOCOPY NUMBER,
2163: x_msg_data OUT NOCOPY VARCHAR2,
2164: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2165: p_group_id IN NUMBER,
2166: p_channel_id IN NUMBER,
2167: p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2168: );

Line 2178: -- Default = FND_API.G_FALSE

2174: -- Function : Update all the accesses of a group with a category
2175: -- Parameters :
2176: -- IN p_api_version NUMBER Required
2177: -- p_init_msg_list VARCHAR2 Optional
2178: -- Default = FND_API.G_FALSE
2179: -- p_commit VARCHAR2 Optional
2180: -- Default = FND_API.G_FALSE
2181: -- p_validation_level NUMBER Optional
2182: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2180: -- Default = FND_API.G_FALSE

2176: -- IN p_api_version NUMBER Required
2177: -- p_init_msg_list VARCHAR2 Optional
2178: -- Default = FND_API.G_FALSE
2179: -- p_commit VARCHAR2 Optional
2180: -- Default = FND_API.G_FALSE
2181: -- p_validation_level NUMBER Optional
2182: -- Default = FND_API.G_VALID_LEVEL_FULL
2183: -- p_check_login_user VARCHAR2 Optional
2184: -- Default = FND_API.G_TRUE

Line 2182: -- Default = FND_API.G_VALID_LEVEL_FULL

2178: -- Default = FND_API.G_FALSE
2179: -- p_commit VARCHAR2 Optional
2180: -- Default = FND_API.G_FALSE
2181: -- p_validation_level NUMBER Optional
2182: -- Default = FND_API.G_VALID_LEVEL_FULL
2183: -- p_check_login_user VARCHAR2 Optional
2184: -- Default = FND_API.G_TRUE
2185: -- Flag for checking user privilege and if user is login.
2186: -- p_group_id NUMBER Required

Line 2184: -- Default = FND_API.G_TRUE

2180: -- Default = FND_API.G_FALSE
2181: -- p_validation_level NUMBER Optional
2182: -- Default = FND_API.G_VALID_LEVEL_FULL
2183: -- p_check_login_user VARCHAR2 Optional
2184: -- Default = FND_API.G_TRUE
2185: -- Flag for checking user privilege and if user is login.
2186: -- p_group_id NUMBER Required
2187: -- p_category_id NUMBER Required
2188: -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE

Line 2201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2197: --
2198: PROCEDURE Update_GroupCateAccess
2199: (
2200: p_api_version IN NUMBER,
2201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2204: x_return_status OUT NOCOPY VARCHAR2,
2205: x_msg_count OUT NOCOPY NUMBER,

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

2198: PROCEDURE Update_GroupCateAccess
2199: (
2200: p_api_version IN NUMBER,
2201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2204: x_return_status OUT NOCOPY VARCHAR2,
2205: x_msg_count OUT NOCOPY NUMBER,
2206: x_msg_data OUT NOCOPY VARCHAR2,

Line 2203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2199: (
2200: p_api_version IN NUMBER,
2201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2204: x_return_status OUT NOCOPY VARCHAR2,
2205: x_msg_count OUT NOCOPY NUMBER,
2206: x_msg_data OUT NOCOPY VARCHAR2,
2207: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2207: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2204: x_return_status OUT NOCOPY VARCHAR2,
2205: x_msg_count OUT NOCOPY NUMBER,
2206: x_msg_data OUT NOCOPY VARCHAR2,
2207: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2208: p_group_id IN NUMBER,
2209: p_category_id IN NUMBER,
2210: p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2211: );

Line 2221: -- Default = FND_API.G_FALSE

2217: -- Function : Update all the accesses of a group with a item
2218: -- Parameters :
2219: -- IN p_api_version NUMBER Required
2220: -- p_init_msg_list VARCHAR2 Optional
2221: -- Default = FND_API.G_FALSE
2222: -- p_commit VARCHAR2 Optional
2223: -- Default = FND_API.G_FALSE
2224: -- p_validation_level NUMBER Optional
2225: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2223: -- Default = FND_API.G_FALSE

2219: -- IN p_api_version NUMBER Required
2220: -- p_init_msg_list VARCHAR2 Optional
2221: -- Default = FND_API.G_FALSE
2222: -- p_commit VARCHAR2 Optional
2223: -- Default = FND_API.G_FALSE
2224: -- p_validation_level NUMBER Optional
2225: -- Default = FND_API.G_VALID_LEVEL_FULL
2226: -- p_check_login_user VARCHAR2 Optional
2227: -- Default = FND_API.G_TRUE

Line 2225: -- Default = FND_API.G_VALID_LEVEL_FULL

2221: -- Default = FND_API.G_FALSE
2222: -- p_commit VARCHAR2 Optional
2223: -- Default = FND_API.G_FALSE
2224: -- p_validation_level NUMBER Optional
2225: -- Default = FND_API.G_VALID_LEVEL_FULL
2226: -- p_check_login_user VARCHAR2 Optional
2227: -- Default = FND_API.G_TRUE
2228: -- Flag for checking user privilege and if user is login.
2229: -- p_group_id NUMBER Required

Line 2227: -- Default = FND_API.G_TRUE

2223: -- Default = FND_API.G_FALSE
2224: -- p_validation_level NUMBER Optional
2225: -- Default = FND_API.G_VALID_LEVEL_FULL
2226: -- p_check_login_user VARCHAR2 Optional
2227: -- Default = FND_API.G_TRUE
2228: -- Flag for checking user privilege and if user is login.
2229: -- p_group_id NUMBER Required
2230: -- p_item_id NUMBER Required
2231: -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE

Line 2245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2241: --
2242: PROCEDURE Update_GroupItemAccess
2243: (
2244: p_api_version IN NUMBER,
2245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2246: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2248: x_return_status OUT NOCOPY VARCHAR2,
2249: x_msg_count OUT NOCOPY NUMBER,

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

2242: PROCEDURE Update_GroupItemAccess
2243: (
2244: p_api_version IN NUMBER,
2245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2246: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2248: x_return_status OUT NOCOPY VARCHAR2,
2249: x_msg_count OUT NOCOPY NUMBER,
2250: x_msg_data OUT NOCOPY VARCHAR2,

Line 2247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2243: (
2244: p_api_version IN NUMBER,
2245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2246: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2248: x_return_status OUT NOCOPY VARCHAR2,
2249: x_msg_count OUT NOCOPY NUMBER,
2250: x_msg_data OUT NOCOPY VARCHAR2,
2251: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2251: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2248: x_return_status OUT NOCOPY VARCHAR2,
2249: x_msg_count OUT NOCOPY NUMBER,
2250: x_msg_data OUT NOCOPY VARCHAR2,
2251: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2252: p_group_id IN NUMBER,
2253: p_item_id IN NUMBER,
2254: p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2255: );

Line 2266: -- Default = FND_API.G_FALSE

2262: -- with a business object
2263: -- Parameters :
2264: -- IN p_api_version NUMBER Required
2265: -- p_init_msg_list VARCHAR2 Optional
2266: -- Default = FND_API.G_FALSE
2267: -- p_validation_level NUMBER Optional
2268: -- Default = FND_API.G_VALID_LEVEL_FULL
2269: -- p_check_login_user VARCHAR2 Optional
2270: -- Default = FND_API.G_TRUE

Line 2268: -- Default = FND_API.G_VALID_LEVEL_FULL

2264: -- IN p_api_version NUMBER Required
2265: -- p_init_msg_list VARCHAR2 Optional
2266: -- Default = FND_API.G_FALSE
2267: -- p_validation_level NUMBER Optional
2268: -- Default = FND_API.G_VALID_LEVEL_FULL
2269: -- p_check_login_user VARCHAR2 Optional
2270: -- Default = FND_API.G_TRUE
2271: -- Flag for checking user privilege and if user is login.
2272: -- p_user_or_group_id NUMBER Required

Line 2270: -- Default = FND_API.G_TRUE

2266: -- Default = FND_API.G_FALSE
2267: -- p_validation_level NUMBER Optional
2268: -- Default = FND_API.G_VALID_LEVEL_FULL
2269: -- p_check_login_user VARCHAR2 Optional
2270: -- Default = FND_API.G_TRUE
2271: -- Flag for checking user privilege and if user is login.
2272: -- p_user_or_group_id NUMBER Required
2273: -- p_user_or_group_type VARCHAR2 Required
2274: -- p_business_object_id NUMBER Required

Line 2291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2287: --
2288: PROCEDURE Get_BusinessObjectAccess
2289: (
2290: p_api_version IN NUMBER,
2291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2293: x_return_status OUT NOCOPY VARCHAR2,
2294: x_msg_count OUT NOCOPY NUMBER,
2295: x_msg_data OUT NOCOPY VARCHAR2,

Line 2292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2288: PROCEDURE Get_BusinessObjectAccess
2289: (
2290: p_api_version IN NUMBER,
2291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2293: x_return_status OUT NOCOPY VARCHAR2,
2294: x_msg_count OUT NOCOPY NUMBER,
2295: x_msg_data OUT NOCOPY VARCHAR2,
2296: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2296: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2293: x_return_status OUT NOCOPY VARCHAR2,
2294: x_msg_count OUT NOCOPY NUMBER,
2295: x_msg_data OUT NOCOPY VARCHAR2,
2296: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2297: p_user_or_group_id IN NUMBER,
2298: p_user_or_group_type IN VARCHAR2,
2299: p_business_object_id IN NUMBER,
2300: p_business_object_type IN VARCHAR2,

Line 2312: -- Default = FND_API.G_FALSE

2308: -- Function : Retrieve all the channel access of a resource/group
2309: -- Parameters :
2310: -- IN p_api_version NUMBER Required
2311: -- p_init_msg_list VARCHAR2 Optional
2312: -- Default = FND_API.G_FALSE
2313: -- p_validation_level NUMBER Optional
2314: -- Default = FND_API.G_VALID_LEVEL_FULL
2315: -- p_check_login_user VARCHAR2 Optional
2316: -- Default = FND_API.G_TRUE

Line 2314: -- Default = FND_API.G_VALID_LEVEL_FULL

2310: -- IN p_api_version NUMBER Required
2311: -- p_init_msg_list VARCHAR2 Optional
2312: -- Default = FND_API.G_FALSE
2313: -- p_validation_level NUMBER Optional
2314: -- Default = FND_API.G_VALID_LEVEL_FULL
2315: -- p_check_login_user VARCHAR2 Optional
2316: -- Default = FND_API.G_TRUE
2317: -- Flag for checking user privilege and if user is login.
2318: -- p_user_or_group_id NUMBER Required

Line 2316: -- Default = FND_API.G_TRUE

2312: -- Default = FND_API.G_FALSE
2313: -- p_validation_level NUMBER Optional
2314: -- Default = FND_API.G_VALID_LEVEL_FULL
2315: -- p_check_login_user VARCHAR2 Optional
2316: -- Default = FND_API.G_TRUE
2317: -- Flag for checking user privilege and if user is login.
2318: -- p_user_or_group_id NUMBER Required
2319: -- p_user_or_group_type VARCHAR2 Required
2320: -- OUT : x_return_status VARCHAR2

Line 2334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2330: --
2331: PROCEDURE Get_ChannelAccess
2332: (
2333: p_api_version IN NUMBER,
2334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2335: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2336: x_return_status OUT NOCOPY VARCHAR2,
2337: x_msg_count OUT NOCOPY NUMBER,
2338: x_msg_data OUT NOCOPY VARCHAR2,

Line 2335: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2331: PROCEDURE Get_ChannelAccess
2332: (
2333: p_api_version IN NUMBER,
2334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2335: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2336: x_return_status OUT NOCOPY VARCHAR2,
2337: x_msg_count OUT NOCOPY NUMBER,
2338: x_msg_data OUT NOCOPY VARCHAR2,
2339: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2339: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2335: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2336: x_return_status OUT NOCOPY VARCHAR2,
2337: x_msg_count OUT NOCOPY NUMBER,
2338: x_msg_data OUT NOCOPY VARCHAR2,
2339: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2340: p_user_or_group_id IN NUMBER,
2341: p_user_or_group_type IN VARCHAR2,
2342: x_channel_name_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE,
2343: x_access_obj_varray OUT NOCOPY AMV_ACCESS_OBJ_VARRAY

Line 2354: -- Default = FND_API.G_FALSE

2350: -- Function : Retrieve all the channel user/group access of a fixed channel
2351: -- Parameters :
2352: -- IN p_api_version NUMBER Required
2353: -- p_init_msg_list VARCHAR2 Optional
2354: -- Default = FND_API.G_FALSE
2355: -- p_validation_level NUMBER Optional
2356: -- Default = FND_API.G_VALID_LEVEL_FULL
2357: -- p_check_login_user VARCHAR2 Optional
2358: -- Default = FND_API.G_TRUE

Line 2356: -- Default = FND_API.G_VALID_LEVEL_FULL

2352: -- IN p_api_version NUMBER Required
2353: -- p_init_msg_list VARCHAR2 Optional
2354: -- Default = FND_API.G_FALSE
2355: -- p_validation_level NUMBER Optional
2356: -- Default = FND_API.G_VALID_LEVEL_FULL
2357: -- p_check_login_user VARCHAR2 Optional
2358: -- Default = FND_API.G_TRUE
2359: -- Flag for checking user privilege and if user is login.
2360: -- p_channel_id NUMBER Required

Line 2358: -- Default = FND_API.G_TRUE

2354: -- Default = FND_API.G_FALSE
2355: -- p_validation_level NUMBER Optional
2356: -- Default = FND_API.G_VALID_LEVEL_FULL
2357: -- p_check_login_user VARCHAR2 Optional
2358: -- Default = FND_API.G_TRUE
2359: -- Flag for checking user privilege and if user is login.
2360: -- p_channel_id NUMBER Required
2361: -- p_user_or_group_type VARCHAR2 Required
2362: -- OUT : x_return_status VARCHAR2

Line 2376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2372: --
2373: PROCEDURE Get_AccessPerChannel
2374: (
2375: p_api_version IN NUMBER,
2376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2378: x_return_status OUT NOCOPY VARCHAR2,
2379: x_msg_count OUT NOCOPY NUMBER,
2380: x_msg_data OUT NOCOPY VARCHAR2,

Line 2377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2373: PROCEDURE Get_AccessPerChannel
2374: (
2375: p_api_version IN NUMBER,
2376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2378: x_return_status OUT NOCOPY VARCHAR2,
2379: x_msg_count OUT NOCOPY NUMBER,
2380: x_msg_data OUT NOCOPY VARCHAR2,
2381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2378: x_return_status OUT NOCOPY VARCHAR2,
2379: x_msg_count OUT NOCOPY NUMBER,
2380: x_msg_data OUT NOCOPY VARCHAR2,
2381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2382: p_channel_id IN NUMBER,
2383: p_user_or_group_type IN VARCHAR2,
2384: x_name_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE,
2385: x_access_obj_varray OUT NOCOPY AMV_ACCESS_OBJ_VARRAY

Line 2397: -- Default = FND_API.G_FALSE

2393: -- with a business object
2394: -- Parameters :
2395: -- IN p_api_version NUMBER Required
2396: -- p_init_msg_list VARCHAR2 Optional
2397: -- Default = FND_API.G_FALSE
2398: -- p_validation_level NUMBER Optional
2399: -- Default = FND_API.G_VALID_LEVEL_FULL
2400: -- p_check_login_user VARCHAR2 Optional
2401: -- Default = FND_API.G_TRUE

Line 2399: -- Default = FND_API.G_VALID_LEVEL_FULL

2395: -- IN p_api_version NUMBER Required
2396: -- p_init_msg_list VARCHAR2 Optional
2397: -- Default = FND_API.G_FALSE
2398: -- p_validation_level NUMBER Optional
2399: -- Default = FND_API.G_VALID_LEVEL_FULL
2400: -- p_check_login_user VARCHAR2 Optional
2401: -- Default = FND_API.G_TRUE
2402: -- Flag for checking user privilege and if user is login.
2403: -- p_include_group_flag VARCHAR2 Optional

Line 2401: -- Default = FND_API.G_TRUE

2397: -- Default = FND_API.G_FALSE
2398: -- p_validation_level NUMBER Optional
2399: -- Default = FND_API.G_VALID_LEVEL_FULL
2400: -- p_check_login_user VARCHAR2 Optional
2401: -- Default = FND_API.G_TRUE
2402: -- Flag for checking user privilege and if user is login.
2403: -- p_include_group_flag VARCHAR2 Optional
2404: -- it is ignored for the resource. Only check for group.
2405: -- Default = FND_API.G_TRUE

Line 2405: -- Default = FND_API.G_TRUE

2401: -- Default = FND_API.G_TRUE
2402: -- Flag for checking user privilege and if user is login.
2403: -- p_include_group_flag VARCHAR2 Optional
2404: -- it is ignored for the resource. Only check for group.
2405: -- Default = FND_API.G_TRUE
2406: -- p_check_effective_date VARCHAR2 Optional
2407: -- default FND_API.G_TRUE
2408: -- p_user_or_group_id NUMBER Required
2409: -- p_user_or_group_type VARCHAR2 Required

Line 2407: -- default FND_API.G_TRUE

2403: -- p_include_group_flag VARCHAR2 Optional
2404: -- it is ignored for the resource. Only check for group.
2405: -- Default = FND_API.G_TRUE
2406: -- p_check_effective_date VARCHAR2 Optional
2407: -- default FND_API.G_TRUE
2408: -- p_user_or_group_id NUMBER Required
2409: -- p_user_or_group_type VARCHAR2 Required
2410: -- p_business_object_id NUMBER Required
2411: -- p_business_object_type VARCHAR2 Required

Line 2427: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2423: --
2424: PROCEDURE Get_BusinessObjectAccess
2425: (
2426: p_api_version IN NUMBER,
2427: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2429: x_return_status OUT NOCOPY VARCHAR2,
2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,

Line 2428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2424: PROCEDURE Get_BusinessObjectAccess
2425: (
2426: p_api_version IN NUMBER,
2427: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2429: x_return_status OUT NOCOPY VARCHAR2,
2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2432: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2429: x_return_status OUT NOCOPY VARCHAR2,
2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2433: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2434: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
2435: p_user_or_group_id IN NUMBER,
2436: p_user_or_group_type IN VARCHAR2,

Line 2433: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

2429: x_return_status OUT NOCOPY VARCHAR2,
2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2433: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2434: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
2435: p_user_or_group_id IN NUMBER,
2436: p_user_or_group_type IN VARCHAR2,
2437: p_business_object_id IN NUMBER,

Line 2434: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,

2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2433: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2434: p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
2435: p_user_or_group_id IN NUMBER,
2436: p_user_or_group_type IN VARCHAR2,
2437: p_business_object_id IN NUMBER,
2438: p_business_object_type IN VARCHAR2,

Line 2450: -- Default = FND_API.G_FALSE

2446: -- Function : Retrieve all the access of a resource with an application
2447: -- Parameters :
2448: -- IN p_api_version NUMBER Required
2449: -- p_init_msg_list VARCHAR2 Optional
2450: -- Default = FND_API.G_FALSE
2451: -- p_validation_level NUMBER Optional
2452: -- Default = FND_API.G_VALID_LEVEL_FULL
2453: -- p_check_login_user VARCHAR2 Optional
2454: -- Default = FND_API.G_TRUE

Line 2452: -- Default = FND_API.G_VALID_LEVEL_FULL

2448: -- IN p_api_version NUMBER Required
2449: -- p_init_msg_list VARCHAR2 Optional
2450: -- Default = FND_API.G_FALSE
2451: -- p_validation_level NUMBER Optional
2452: -- Default = FND_API.G_VALID_LEVEL_FULL
2453: -- p_check_login_user VARCHAR2 Optional
2454: -- Default = FND_API.G_TRUE
2455: -- Flag for checking user privilege and if user is login.
2456: -- p_include_group_flag VARCHAR2 Optional

Line 2454: -- Default = FND_API.G_TRUE

2450: -- Default = FND_API.G_FALSE
2451: -- p_validation_level NUMBER Optional
2452: -- Default = FND_API.G_VALID_LEVEL_FULL
2453: -- p_check_login_user VARCHAR2 Optional
2454: -- Default = FND_API.G_TRUE
2455: -- Flag for checking user privilege and if user is login.
2456: -- p_include_group_flag VARCHAR2 Optional
2457: -- Default = FND_API.G_TRUE
2458: -- p_resource_id NUMBER Required

Line 2457: -- Default = FND_API.G_TRUE

2453: -- p_check_login_user VARCHAR2 Optional
2454: -- Default = FND_API.G_TRUE
2455: -- Flag for checking user privilege and if user is login.
2456: -- p_include_group_flag VARCHAR2 Optional
2457: -- Default = FND_API.G_TRUE
2458: -- p_resource_id NUMBER Required
2459: -- p_application_id NUMBER Required
2460: -- OUT : x_return_status VARCHAR2
2461: -- x_msg_count NUMBER

Line 2473: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2469: --
2470: PROCEDURE Get_ResourceApplAccess
2471: (
2472: p_api_version IN NUMBER,
2473: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2475: x_return_status OUT NOCOPY VARCHAR2,
2476: x_msg_count OUT NOCOPY NUMBER,
2477: x_msg_data OUT NOCOPY VARCHAR2,

Line 2474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2470: PROCEDURE Get_ResourceApplAccess
2471: (
2472: p_api_version IN NUMBER,
2473: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2475: x_return_status OUT NOCOPY VARCHAR2,
2476: x_msg_count OUT NOCOPY NUMBER,
2477: x_msg_data OUT NOCOPY VARCHAR2,
2478: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2478: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2475: x_return_status OUT NOCOPY VARCHAR2,
2476: x_msg_count OUT NOCOPY NUMBER,
2477: x_msg_data OUT NOCOPY VARCHAR2,
2478: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2479: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2480: p_resource_id IN NUMBER,
2481: p_application_id IN NUMBER,
2482: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE

Line 2479: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

2475: x_return_status OUT NOCOPY VARCHAR2,
2476: x_msg_count OUT NOCOPY NUMBER,
2477: x_msg_data OUT NOCOPY VARCHAR2,
2478: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2479: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2480: p_resource_id IN NUMBER,
2481: p_application_id IN NUMBER,
2482: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2483: );

Line 2493: -- Default = FND_API.G_FALSE

2489: -- Function : Retrieve all the access of a resource with an channel
2490: -- Parameters :
2491: -- IN p_api_version NUMBER Required
2492: -- p_init_msg_list VARCHAR2 Optional
2493: -- Default = FND_API.G_FALSE
2494: -- p_validation_level NUMBER Optional
2495: -- Default = FND_API.G_VALID_LEVEL_FULL
2496: -- p_check_login_user VARCHAR2 Optional
2497: -- Default = FND_API.G_TRUE

Line 2495: -- Default = FND_API.G_VALID_LEVEL_FULL

2491: -- IN p_api_version NUMBER Required
2492: -- p_init_msg_list VARCHAR2 Optional
2493: -- Default = FND_API.G_FALSE
2494: -- p_validation_level NUMBER Optional
2495: -- Default = FND_API.G_VALID_LEVEL_FULL
2496: -- p_check_login_user VARCHAR2 Optional
2497: -- Default = FND_API.G_TRUE
2498: -- Flag for checking user privilege and if user is login.
2499: -- p_include_group_flag VARCHAR2 Optional

Line 2497: -- Default = FND_API.G_TRUE

2493: -- Default = FND_API.G_FALSE
2494: -- p_validation_level NUMBER Optional
2495: -- Default = FND_API.G_VALID_LEVEL_FULL
2496: -- p_check_login_user VARCHAR2 Optional
2497: -- Default = FND_API.G_TRUE
2498: -- Flag for checking user privilege and if user is login.
2499: -- p_include_group_flag VARCHAR2 Optional
2500: -- Default = FND_API.G_TRUE
2501: -- p_resource_id NUMBER Required

Line 2500: -- Default = FND_API.G_TRUE

2496: -- p_check_login_user VARCHAR2 Optional
2497: -- Default = FND_API.G_TRUE
2498: -- Flag for checking user privilege and if user is login.
2499: -- p_include_group_flag VARCHAR2 Optional
2500: -- Default = FND_API.G_TRUE
2501: -- p_resource_id NUMBER Required
2502: -- p_channel_id NUMBER Required
2503: -- OUT : x_return_status VARCHAR2
2504: -- x_msg_count NUMBER

Line 2516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2512: --
2513: PROCEDURE Get_ResourceChanAccess
2514: (
2515: p_api_version IN NUMBER,
2516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2518: x_return_status OUT NOCOPY VARCHAR2,
2519: x_msg_count OUT NOCOPY NUMBER,
2520: x_msg_data OUT NOCOPY VARCHAR2,

Line 2517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2513: PROCEDURE Get_ResourceChanAccess
2514: (
2515: p_api_version IN NUMBER,
2516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2518: x_return_status OUT NOCOPY VARCHAR2,
2519: x_msg_count OUT NOCOPY NUMBER,
2520: x_msg_data OUT NOCOPY VARCHAR2,
2521: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2521: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2518: x_return_status OUT NOCOPY VARCHAR2,
2519: x_msg_count OUT NOCOPY NUMBER,
2520: x_msg_data OUT NOCOPY VARCHAR2,
2521: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2522: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2523: p_resource_id IN NUMBER,
2524: p_channel_id IN NUMBER,
2525: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE

Line 2522: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

2518: x_return_status OUT NOCOPY VARCHAR2,
2519: x_msg_count OUT NOCOPY NUMBER,
2520: x_msg_data OUT NOCOPY VARCHAR2,
2521: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2522: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2523: p_resource_id IN NUMBER,
2524: p_channel_id IN NUMBER,
2525: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2526: );

Line 2536: -- Default = FND_API.G_FALSE

2532: -- Function : Retrieve all the access of a resource with an category
2533: -- Parameters :
2534: -- IN p_api_version NUMBER Required
2535: -- p_init_msg_list VARCHAR2 Optional
2536: -- Default = FND_API.G_FALSE
2537: -- p_validation_level NUMBER Optional
2538: -- Default = FND_API.G_VALID_LEVEL_FULL
2539: -- p_check_login_user VARCHAR2 Optional
2540: -- Default = FND_API.G_TRUE

Line 2538: -- Default = FND_API.G_VALID_LEVEL_FULL

2534: -- IN p_api_version NUMBER Required
2535: -- p_init_msg_list VARCHAR2 Optional
2536: -- Default = FND_API.G_FALSE
2537: -- p_validation_level NUMBER Optional
2538: -- Default = FND_API.G_VALID_LEVEL_FULL
2539: -- p_check_login_user VARCHAR2 Optional
2540: -- Default = FND_API.G_TRUE
2541: -- Flag for checking user privilege and if user is login.
2542: -- p_include_group_flag VARCHAR2 Optional

Line 2540: -- Default = FND_API.G_TRUE

2536: -- Default = FND_API.G_FALSE
2537: -- p_validation_level NUMBER Optional
2538: -- Default = FND_API.G_VALID_LEVEL_FULL
2539: -- p_check_login_user VARCHAR2 Optional
2540: -- Default = FND_API.G_TRUE
2541: -- Flag for checking user privilege and if user is login.
2542: -- p_include_group_flag VARCHAR2 Optional
2543: -- Default = FND_API.G_TRUE
2544: -- p_resource_id NUMBER Required

Line 2543: -- Default = FND_API.G_TRUE

2539: -- p_check_login_user VARCHAR2 Optional
2540: -- Default = FND_API.G_TRUE
2541: -- Flag for checking user privilege and if user is login.
2542: -- p_include_group_flag VARCHAR2 Optional
2543: -- Default = FND_API.G_TRUE
2544: -- p_resource_id NUMBER Required
2545: -- p_category_id NUMBER Required
2546: -- OUT : x_return_status VARCHAR2
2547: -- x_msg_count NUMBER

Line 2559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2555: --
2556: PROCEDURE Get_ResourceCateAccess
2557: (
2558: p_api_version IN NUMBER,
2559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2561: x_return_status OUT NOCOPY VARCHAR2,
2562: x_msg_count OUT NOCOPY NUMBER,
2563: x_msg_data OUT NOCOPY VARCHAR2,

Line 2560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2556: PROCEDURE Get_ResourceCateAccess
2557: (
2558: p_api_version IN NUMBER,
2559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2561: x_return_status OUT NOCOPY VARCHAR2,
2562: x_msg_count OUT NOCOPY NUMBER,
2563: x_msg_data OUT NOCOPY VARCHAR2,
2564: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2564: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2561: x_return_status OUT NOCOPY VARCHAR2,
2562: x_msg_count OUT NOCOPY NUMBER,
2563: x_msg_data OUT NOCOPY VARCHAR2,
2564: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2565: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2566: p_resource_id IN NUMBER,
2567: p_category_id IN NUMBER,
2568: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE

Line 2565: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

2561: x_return_status OUT NOCOPY VARCHAR2,
2562: x_msg_count OUT NOCOPY NUMBER,
2563: x_msg_data OUT NOCOPY VARCHAR2,
2564: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2565: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2566: p_resource_id IN NUMBER,
2567: p_category_id IN NUMBER,
2568: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2569: );

Line 2579: -- Default = FND_API.G_FALSE

2575: -- Function : Retrieve all the access of a resource with an item
2576: -- Parameters :
2577: -- IN p_api_version NUMBER Required
2578: -- p_init_msg_list VARCHAR2 Optional
2579: -- Default = FND_API.G_FALSE
2580: -- p_validation_level NUMBER Optional
2581: -- Default = FND_API.G_VALID_LEVEL_FULL
2582: -- p_check_login_user VARCHAR2 Optional
2583: -- Default = FND_API.G_TRUE

Line 2581: -- Default = FND_API.G_VALID_LEVEL_FULL

2577: -- IN p_api_version NUMBER Required
2578: -- p_init_msg_list VARCHAR2 Optional
2579: -- Default = FND_API.G_FALSE
2580: -- p_validation_level NUMBER Optional
2581: -- Default = FND_API.G_VALID_LEVEL_FULL
2582: -- p_check_login_user VARCHAR2 Optional
2583: -- Default = FND_API.G_TRUE
2584: -- Flag for checking user privilege and if user is login.
2585: -- p_include_group_flag VARCHAR2 Optional

Line 2583: -- Default = FND_API.G_TRUE

2579: -- Default = FND_API.G_FALSE
2580: -- p_validation_level NUMBER Optional
2581: -- Default = FND_API.G_VALID_LEVEL_FULL
2582: -- p_check_login_user VARCHAR2 Optional
2583: -- Default = FND_API.G_TRUE
2584: -- Flag for checking user privilege and if user is login.
2585: -- p_include_group_flag VARCHAR2 Optional
2586: -- Default = FND_API.G_TRUE
2587: -- p_resource_id NUMBER Required

Line 2586: -- Default = FND_API.G_TRUE

2582: -- p_check_login_user VARCHAR2 Optional
2583: -- Default = FND_API.G_TRUE
2584: -- Flag for checking user privilege and if user is login.
2585: -- p_include_group_flag VARCHAR2 Optional
2586: -- Default = FND_API.G_TRUE
2587: -- p_resource_id NUMBER Required
2588: -- p_item_id NUMBER Required
2589: -- OUT : x_return_status VARCHAR2
2590: -- x_msg_count NUMBER

Line 2602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2598: --
2599: PROCEDURE Get_ResourceItemAccess
2600: (
2601: p_api_version IN NUMBER,
2602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2603: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2604: x_return_status OUT NOCOPY VARCHAR2,
2605: x_msg_count OUT NOCOPY NUMBER,
2606: x_msg_data OUT NOCOPY VARCHAR2,

Line 2603: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2599: PROCEDURE Get_ResourceItemAccess
2600: (
2601: p_api_version IN NUMBER,
2602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2603: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2604: x_return_status OUT NOCOPY VARCHAR2,
2605: x_msg_count OUT NOCOPY NUMBER,
2606: x_msg_data OUT NOCOPY VARCHAR2,
2607: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2607: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2603: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2604: x_return_status OUT NOCOPY VARCHAR2,
2605: x_msg_count OUT NOCOPY NUMBER,
2606: x_msg_data OUT NOCOPY VARCHAR2,
2607: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2608: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2609: p_resource_id IN NUMBER,
2610: p_item_id IN NUMBER,
2611: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE

Line 2608: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,

2604: x_return_status OUT NOCOPY VARCHAR2,
2605: x_msg_count OUT NOCOPY NUMBER,
2606: x_msg_data OUT NOCOPY VARCHAR2,
2607: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2608: p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2609: p_resource_id IN NUMBER,
2610: p_item_id IN NUMBER,
2611: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2612: );

Line 2622: -- Default = FND_API.G_FALSE

2618: -- Function : Retrieve all the access of a group with an application
2619: -- Parameters :
2620: -- IN p_api_version NUMBER Required
2621: -- p_init_msg_list VARCHAR2 Optional
2622: -- Default = FND_API.G_FALSE
2623: -- p_validation_level NUMBER Optional
2624: -- Default = FND_API.G_VALID_LEVEL_FULL
2625: -- p_check_login_user VARCHAR2 Optional
2626: -- Default = FND_API.G_TRUE

Line 2624: -- Default = FND_API.G_VALID_LEVEL_FULL

2620: -- IN p_api_version NUMBER Required
2621: -- p_init_msg_list VARCHAR2 Optional
2622: -- Default = FND_API.G_FALSE
2623: -- p_validation_level NUMBER Optional
2624: -- Default = FND_API.G_VALID_LEVEL_FULL
2625: -- p_check_login_user VARCHAR2 Optional
2626: -- Default = FND_API.G_TRUE
2627: -- Flag for checking user privilege and if user is login.
2628: -- p_group_id NUMBER Required

Line 2626: -- Default = FND_API.G_TRUE

2622: -- Default = FND_API.G_FALSE
2623: -- p_validation_level NUMBER Optional
2624: -- Default = FND_API.G_VALID_LEVEL_FULL
2625: -- p_check_login_user VARCHAR2 Optional
2626: -- Default = FND_API.G_TRUE
2627: -- Flag for checking user privilege and if user is login.
2628: -- p_group_id NUMBER Required
2629: -- p_application_id NUMBER Required
2630: -- OUT : x_return_status VARCHAR2

Line 2643: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2639: --
2640: PROCEDURE Get_GroupApplAccess
2641: (
2642: p_api_version IN NUMBER,
2643: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2644: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2645: x_return_status OUT NOCOPY VARCHAR2,
2646: x_msg_count OUT NOCOPY NUMBER,
2647: x_msg_data OUT NOCOPY VARCHAR2,

Line 2644: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2640: PROCEDURE Get_GroupApplAccess
2641: (
2642: p_api_version IN NUMBER,
2643: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2644: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2645: x_return_status OUT NOCOPY VARCHAR2,
2646: x_msg_count OUT NOCOPY NUMBER,
2647: x_msg_data OUT NOCOPY VARCHAR2,
2648: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2648: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2644: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2645: x_return_status OUT NOCOPY VARCHAR2,
2646: x_msg_count OUT NOCOPY NUMBER,
2647: x_msg_data OUT NOCOPY VARCHAR2,
2648: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2649: p_group_id IN NUMBER,
2650: p_application_id IN NUMBER,
2651: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2652: );

Line 2662: -- Default = FND_API.G_FALSE

2658: -- Function : Retrieve all the access of a group with an channel
2659: -- Parameters :
2660: -- IN p_api_version NUMBER Required
2661: -- p_init_msg_list VARCHAR2 Optional
2662: -- Default = FND_API.G_FALSE
2663: -- p_validation_level NUMBER Optional
2664: -- Default = FND_API.G_VALID_LEVEL_FULL
2665: -- p_check_login_user VARCHAR2 Optional
2666: -- Default = FND_API.G_TRUE

Line 2664: -- Default = FND_API.G_VALID_LEVEL_FULL

2660: -- IN p_api_version NUMBER Required
2661: -- p_init_msg_list VARCHAR2 Optional
2662: -- Default = FND_API.G_FALSE
2663: -- p_validation_level NUMBER Optional
2664: -- Default = FND_API.G_VALID_LEVEL_FULL
2665: -- p_check_login_user VARCHAR2 Optional
2666: -- Default = FND_API.G_TRUE
2667: -- Flag for checking user privilege and if user is login.
2668: -- p_group_id NUMBER Required

Line 2666: -- Default = FND_API.G_TRUE

2662: -- Default = FND_API.G_FALSE
2663: -- p_validation_level NUMBER Optional
2664: -- Default = FND_API.G_VALID_LEVEL_FULL
2665: -- p_check_login_user VARCHAR2 Optional
2666: -- Default = FND_API.G_TRUE
2667: -- Flag for checking user privilege and if user is login.
2668: -- p_group_id NUMBER Required
2669: -- p_channel_id NUMBER Required
2670: -- OUT : x_return_status VARCHAR2

Line 2683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2679: --
2680: PROCEDURE Get_GroupChanAccess
2681: (
2682: p_api_version IN NUMBER,
2683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2685: x_return_status OUT NOCOPY VARCHAR2,
2686: x_msg_count OUT NOCOPY NUMBER,
2687: x_msg_data OUT NOCOPY VARCHAR2,

Line 2684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2680: PROCEDURE Get_GroupChanAccess
2681: (
2682: p_api_version IN NUMBER,
2683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2685: x_return_status OUT NOCOPY VARCHAR2,
2686: x_msg_count OUT NOCOPY NUMBER,
2687: x_msg_data OUT NOCOPY VARCHAR2,
2688: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2688: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2685: x_return_status OUT NOCOPY VARCHAR2,
2686: x_msg_count OUT NOCOPY NUMBER,
2687: x_msg_data OUT NOCOPY VARCHAR2,
2688: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2689: p_group_id IN NUMBER,
2690: p_channel_id IN NUMBER,
2691: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2692: );

Line 2702: -- Default = FND_API.G_FALSE

2698: -- Function : Retrieve all the access of a group with an category
2699: -- Parameters :
2700: -- IN p_api_version NUMBER Required
2701: -- p_init_msg_list VARCHAR2 Optional
2702: -- Default = FND_API.G_FALSE
2703: -- p_validation_level NUMBER Optional
2704: -- Default = FND_API.G_VALID_LEVEL_FULL
2705: -- p_check_login_user VARCHAR2 Optional
2706: -- Default = FND_API.G_TRUE

Line 2704: -- Default = FND_API.G_VALID_LEVEL_FULL

2700: -- IN p_api_version NUMBER Required
2701: -- p_init_msg_list VARCHAR2 Optional
2702: -- Default = FND_API.G_FALSE
2703: -- p_validation_level NUMBER Optional
2704: -- Default = FND_API.G_VALID_LEVEL_FULL
2705: -- p_check_login_user VARCHAR2 Optional
2706: -- Default = FND_API.G_TRUE
2707: -- Flag for checking user privilege and if user is login.
2708: -- p_group_id NUMBER Required

Line 2706: -- Default = FND_API.G_TRUE

2702: -- Default = FND_API.G_FALSE
2703: -- p_validation_level NUMBER Optional
2704: -- Default = FND_API.G_VALID_LEVEL_FULL
2705: -- p_check_login_user VARCHAR2 Optional
2706: -- Default = FND_API.G_TRUE
2707: -- Flag for checking user privilege and if user is login.
2708: -- p_group_id NUMBER Required
2709: -- p_category_id NUMBER Required
2710: -- OUT : x_return_status VARCHAR2

Line 2723: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2719: --
2720: PROCEDURE Get_GroupCateAccess
2721: (
2722: p_api_version IN NUMBER,
2723: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2724: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2725: x_return_status OUT NOCOPY VARCHAR2,
2726: x_msg_count OUT NOCOPY NUMBER,
2727: x_msg_data OUT NOCOPY VARCHAR2,

Line 2724: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2720: PROCEDURE Get_GroupCateAccess
2721: (
2722: p_api_version IN NUMBER,
2723: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2724: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2725: x_return_status OUT NOCOPY VARCHAR2,
2726: x_msg_count OUT NOCOPY NUMBER,
2727: x_msg_data OUT NOCOPY VARCHAR2,
2728: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2728: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2724: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2725: x_return_status OUT NOCOPY VARCHAR2,
2726: x_msg_count OUT NOCOPY NUMBER,
2727: x_msg_data OUT NOCOPY VARCHAR2,
2728: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2729: p_group_id IN NUMBER,
2730: p_category_id IN NUMBER,
2731: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2732: );

Line 2742: -- Default = FND_API.G_FALSE

2738: -- Function : Retrieve all the access of a group with an item
2739: -- Parameters :
2740: -- IN p_api_version NUMBER Required
2741: -- p_init_msg_list VARCHAR2 Optional
2742: -- Default = FND_API.G_FALSE
2743: -- p_validation_level NUMBER Optional
2744: -- Default = FND_API.G_VALID_LEVEL_FULL
2745: -- p_check_login_user VARCHAR2 Optional
2746: -- Default = FND_API.G_TRUE

Line 2744: -- Default = FND_API.G_VALID_LEVEL_FULL

2740: -- IN p_api_version NUMBER Required
2741: -- p_init_msg_list VARCHAR2 Optional
2742: -- Default = FND_API.G_FALSE
2743: -- p_validation_level NUMBER Optional
2744: -- Default = FND_API.G_VALID_LEVEL_FULL
2745: -- p_check_login_user VARCHAR2 Optional
2746: -- Default = FND_API.G_TRUE
2747: -- Flag for checking user privilege and if user is login.
2748: -- p_group_id NUMBER Required

Line 2746: -- Default = FND_API.G_TRUE

2742: -- Default = FND_API.G_FALSE
2743: -- p_validation_level NUMBER Optional
2744: -- Default = FND_API.G_VALID_LEVEL_FULL
2745: -- p_check_login_user VARCHAR2 Optional
2746: -- Default = FND_API.G_TRUE
2747: -- Flag for checking user privilege and if user is login.
2748: -- p_group_id NUMBER Required
2749: -- p_item_id NUMBER Required
2750: -- OUT : x_return_status VARCHAR2

Line 2763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2759: --
2760: PROCEDURE Get_ResourceItemAccess
2761: (
2762: p_api_version IN NUMBER,
2763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2765: x_return_status OUT NOCOPY VARCHAR2,
2766: x_msg_count OUT NOCOPY NUMBER,
2767: x_msg_data OUT NOCOPY VARCHAR2,

Line 2764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2760: PROCEDURE Get_ResourceItemAccess
2761: (
2762: p_api_version IN NUMBER,
2763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2765: x_return_status OUT NOCOPY VARCHAR2,
2766: x_msg_count OUT NOCOPY NUMBER,
2767: x_msg_data OUT NOCOPY VARCHAR2,
2768: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2768: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2765: x_return_status OUT NOCOPY VARCHAR2,
2766: x_msg_count OUT NOCOPY NUMBER,
2767: x_msg_data OUT NOCOPY VARCHAR2,
2768: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2769: p_group_id IN NUMBER,
2770: p_item_id IN NUMBER,
2771: x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2772: );