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.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_GRANTS

Line 35: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,

31: -- -----------------------------------------------------------------
32: PROCEDURE Insert_Grant (p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
36: p_function_id IN igs_sc_grants.function_id%TYPE,
37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39: p_grant_name IN igs_sc_grants.grant_name%TYPE,

Line 36: p_function_id IN igs_sc_grants.function_id%TYPE,

32: PROCEDURE Insert_Grant (p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
36: p_function_id IN igs_sc_grants.function_id%TYPE,
37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39: p_grant_name IN igs_sc_grants.grant_name%TYPE,
40: p_grant_text IN igs_sc_grants.grant_text%TYPE,

Line 37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,

33: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
36: p_function_id IN igs_sc_grants.function_id%TYPE,
37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39: p_grant_name IN igs_sc_grants.grant_name%TYPE,
40: p_grant_text IN igs_sc_grants.grant_text%TYPE,
41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',

Line 38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,

34: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
36: p_function_id IN igs_sc_grants.function_id%TYPE,
37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39: p_grant_name IN igs_sc_grants.grant_name%TYPE,
40: p_grant_text IN igs_sc_grants.grant_text%TYPE,
41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
42: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',

Line 39: p_grant_name IN igs_sc_grants.grant_name%TYPE,

35: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
36: p_function_id IN igs_sc_grants.function_id%TYPE,
37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39: p_grant_name IN igs_sc_grants.grant_name%TYPE,
40: p_grant_text IN igs_sc_grants.grant_text%TYPE,
41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
42: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
43: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',

Line 40: p_grant_text IN igs_sc_grants.grant_text%TYPE,

36: p_function_id IN igs_sc_grants.function_id%TYPE,
37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39: p_grant_name IN igs_sc_grants.grant_name%TYPE,
40: p_grant_text IN igs_sc_grants.grant_text%TYPE,
41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
42: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
43: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
44: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',

Line 41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',

37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39: p_grant_name IN igs_sc_grants.grant_name%TYPE,
40: p_grant_text IN igs_sc_grants.grant_text%TYPE,
41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
42: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
43: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
44: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
45: x_return_status OUT NOCOPY VARCHAR2,

Line 42: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',

38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
39: p_grant_name IN igs_sc_grants.grant_name%TYPE,
40: p_grant_text IN igs_sc_grants.grant_text%TYPE,
41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
42: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
43: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
44: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_return_message OUT NOCOPY VARCHAR2

Line 43: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',

39: p_grant_name IN igs_sc_grants.grant_name%TYPE,
40: p_grant_text IN igs_sc_grants.grant_text%TYPE,
41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
42: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
43: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
44: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_return_message OUT NOCOPY VARCHAR2
47: );

Line 44: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',

40: p_grant_text IN igs_sc_grants.grant_text%TYPE,
41: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
42: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
43: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
44: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_return_message OUT NOCOPY VARCHAR2
47: );
48:

Line 226: p_grant_id IN igs_sc_grants.grant_id%TYPE,

222:
223: PROCEDURE Update_Grant (p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_grant_id IN igs_sc_grants.grant_id%TYPE,
227: p_function_id IN igs_sc_grants.function_id%TYPE,
228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229: p_grant_name IN igs_sc_grants.grant_name%TYPE,
230: p_grant_text IN igs_sc_grants.grant_text%TYPE,

Line 227: p_function_id IN igs_sc_grants.function_id%TYPE,

223: PROCEDURE Update_Grant (p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_grant_id IN igs_sc_grants.grant_id%TYPE,
227: p_function_id IN igs_sc_grants.function_id%TYPE,
228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229: p_grant_name IN igs_sc_grants.grant_name%TYPE,
230: p_grant_text IN igs_sc_grants.grant_text%TYPE,
231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',

Line 228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,

224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_grant_id IN igs_sc_grants.grant_id%TYPE,
227: p_function_id IN igs_sc_grants.function_id%TYPE,
228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229: p_grant_name IN igs_sc_grants.grant_name%TYPE,
230: p_grant_text IN igs_sc_grants.grant_text%TYPE,
231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
232: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',

Line 229: p_grant_name IN igs_sc_grants.grant_name%TYPE,

225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_grant_id IN igs_sc_grants.grant_id%TYPE,
227: p_function_id IN igs_sc_grants.function_id%TYPE,
228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229: p_grant_name IN igs_sc_grants.grant_name%TYPE,
230: p_grant_text IN igs_sc_grants.grant_text%TYPE,
231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
232: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
233: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',

Line 230: p_grant_text IN igs_sc_grants.grant_text%TYPE,

226: p_grant_id IN igs_sc_grants.grant_id%TYPE,
227: p_function_id IN igs_sc_grants.function_id%TYPE,
228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229: p_grant_name IN igs_sc_grants.grant_name%TYPE,
230: p_grant_text IN igs_sc_grants.grant_text%TYPE,
231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
232: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
233: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
234: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',

Line 231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',

227: p_function_id IN igs_sc_grants.function_id%TYPE,
228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229: p_grant_name IN igs_sc_grants.grant_name%TYPE,
230: p_grant_text IN igs_sc_grants.grant_text%TYPE,
231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
232: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
233: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
234: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
235: x_return_status OUT NOCOPY VARCHAR2,

Line 232: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',

228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229: p_grant_name IN igs_sc_grants.grant_name%TYPE,
230: p_grant_text IN igs_sc_grants.grant_text%TYPE,
231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
232: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
233: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
234: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_return_message OUT NOCOPY VARCHAR2

Line 233: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',

229: p_grant_name IN igs_sc_grants.grant_name%TYPE,
230: p_grant_text IN igs_sc_grants.grant_text%TYPE,
231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
232: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
233: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
234: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_return_message OUT NOCOPY VARCHAR2
237: );

Line 234: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',

230: p_grant_text IN igs_sc_grants.grant_text%TYPE,
231: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
232: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
233: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
234: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_return_message OUT NOCOPY VARCHAR2
237: );
238:

Line 411: p_grant_id IN igs_sc_grants.grant_id%TYPE,

407:
408: PROCEDURE Delete_Grant (p_api_version IN NUMBER,
409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
411: p_grant_id IN igs_sc_grants.grant_id%TYPE,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_return_message OUT NOCOPY VARCHAR2
414: );
415:

Line 444: p_grant_id IN igs_sc_grants.grant_id%TYPE,

440: -- -----------------------------------------------------------------
441: PROCEDURE Lock_Grant (p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
443: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
444: p_grant_id IN igs_sc_grants.grant_id%TYPE,
445: x_return_status OUT NOCOPY VARCHAR2,
446: x_return_message OUT NOCOPY VARCHAR2
447: );
448:

Line 452: p_grant_id IN igs_sc_grants.grant_id%TYPE,

448:
449: PROCEDURE Unlock_Grant (p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
451: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
452: p_grant_id IN igs_sc_grants.grant_id%TYPE,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_return_message OUT NOCOPY VARCHAR2
455: );
456:

Line 457: FUNCTION Is_Grant_Locked (p_grant_id IN igs_sc_grants.grant_id%TYPE) RETURN VARCHAR2;

453: x_return_status OUT NOCOPY VARCHAR2,
454: x_return_message OUT NOCOPY VARCHAR2
455: );
456:
457: FUNCTION Is_Grant_Locked (p_grant_id IN igs_sc_grants.grant_id%TYPE) RETURN VARCHAR2;
458:
459: PROCEDURE Lock_All_Grants(
460: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
461: retcode OUT NOCOPY NUMBER , -- Request standard return status