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.CZ_SECURITY_PVT dependencies on FND_GRANTS

Line 196: FROM fnd_grants

192: l_check_grant VARCHAR2(1) := 'F';
193: BEGIN
194: SELECT 'T'
195: INTO l_check_grant
196: FROM fnd_grants
197: WHERE grantee_key = UPPER(p_user_name)
198: AND instance_set_id = p_instance_set_id
199: AND menu_id = p_menu_id;
200: RETURN l_check_grant;

Line 322: l_user_name fnd_grants.grantee_key%TYPE;

318: IS
319:
320: l_api_name CONSTANT VARCHAR2(30) := 'grant_privilege';
321: l_api_version CONSTANT NUMBER := 1.0;
322: l_user_name fnd_grants.grantee_key%TYPE;
323: l_ctx_resp_id fnd_grants.CTX_RESP_ID%TYPE;
324: l_privilege VARCHAR2(100);
325: l_menu_name VARCHAR2(100);
326: l_menu_id NUMBER;

Line 323: l_ctx_resp_id fnd_grants.CTX_RESP_ID%TYPE;

319:
320: l_api_name CONSTANT VARCHAR2(30) := 'grant_privilege';
321: l_api_version CONSTANT NUMBER := 1.0;
322: l_user_name fnd_grants.grantee_key%TYPE;
323: l_ctx_resp_id fnd_grants.CTX_RESP_ID%TYPE;
324: l_privilege VARCHAR2(100);
325: l_menu_name VARCHAR2(100);
326: l_menu_id NUMBER;
327: l_object_id NUMBER;

Line 401: FROM fnd_grants

397: ---check if grant exists
398: BEGIN
399: SELECT 1
400: INTO l_check_grant
401: FROM fnd_grants
402: WHERE grantee_key = UPPER(l_user_name)
403: AND instance_set_id = l_instance_set_id
404: AND menu_id = l_menu_id
405: AND object_id = l_object_id;

Line 414: ----insert into fnd_grants table

410:
411: IF (l_check_grant = 1) THEN
412: RAISE PRIV_ALREADY_EXISTS;
413: ELSE
414: ----insert into fnd_grants table
415: INSERT INTO FND_GRANTS ( GRANT_GUID,GRANTEE_TYPE,GRANTEE_KEY,MENU_ID,START_DATE,OBJECT_ID
416: ,INSTANCE_TYPE,INSTANCE_SET_ID,INSTANCE_PK1_VALUE,INSTANCE_PK2_VALUE
417: ,INSTANCE_PK3_VALUE,INSTANCE_PK4_VALUE,INSTANCE_PK5_VALUE,CREATED_BY
418: ,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN

Line 415: INSERT INTO FND_GRANTS ( GRANT_GUID,GRANTEE_TYPE,GRANTEE_KEY,MENU_ID,START_DATE,OBJECT_ID

411: IF (l_check_grant = 1) THEN
412: RAISE PRIV_ALREADY_EXISTS;
413: ELSE
414: ----insert into fnd_grants table
415: INSERT INTO FND_GRANTS ( GRANT_GUID,GRANTEE_TYPE,GRANTEE_KEY,MENU_ID,START_DATE,OBJECT_ID
416: ,INSTANCE_TYPE,INSTANCE_SET_ID,INSTANCE_PK1_VALUE,INSTANCE_PK2_VALUE
417: ,INSTANCE_PK3_VALUE,INSTANCE_PK4_VALUE,INSTANCE_PK5_VALUE,CREATED_BY
418: ,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN
419: ,CTX_SECGRP_ID,CTX_RESP_ID,CTX_RESP_APPL_ID,CTX_ORG_ID)

Line 534: FROM fnd_grants

530:
531: ----check if privilege actually exists
532: SELECT 1
533: INTO l_check_grant
534: FROM fnd_grants
535: WHERE grantee_key = UPPER(p_user_name)
536: AND instance_set_id = l_instance_set_id
537: AND menu_id = l_menu_id
538: AND object_id = l_object_id;

Line 543: DELETE FROM fnd_grants

539:
540: IF (l_check_grant <> 1) THEN
541: RAISE NO_PRIV_EXISTS; ---do we need to do a check and return an error message
542: ELSE
543: DELETE FROM fnd_grants
544: WHERE grantee_key = UPPER(p_user_name)
545: AND menu_id = l_menu_id
546: AND object_id = l_object_id
547: AND instance_set_id = l_instance_set_id

Line 600: DELETE FROM fnd_grants WHERE menu_id = l_menu_id AND object_id = l_object_id

596: l_instance_set_name := get_instance_set_name(l_entity_type,p_instance_pk1_value);
597: l_instance_set_id := get_instance_set_id(l_object_id,l_instance_set_name);
598: l_menu_id := get_menu_id_for_menuname(cz_security_pvt.MANAGE_MODEL_ROLE);
599:
600: DELETE FROM fnd_grants WHERE menu_id = l_menu_id AND object_id = l_object_id
601: AND instance_set_id = l_instance_set_id AND instance_pk1_value = to_char(p_instance_pk1_value);
602:
603: l_object_id := get_object_id (l_entity_type);
604: l_instance_set_name := get_instance_set_name(l_entity_type,p_instance_pk1_value);

Line 608: DELETE FROM fnd_grants WHERE menu_id = l_menu_id AND object_id = l_object_id

604: l_instance_set_name := get_instance_set_name(l_entity_type,p_instance_pk1_value);
605: l_instance_set_id := get_instance_set_id(l_object_id,l_instance_set_name);
606: l_menu_id := get_menu_id_for_menuname(cz_security_pvt.EDIT_MODEL_ROLE);
607:
608: DELETE FROM fnd_grants WHERE menu_id = l_menu_id AND object_id = l_object_id
609: AND instance_set_id = l_instance_set_id AND instance_pk1_value = to_char(p_instance_pk1_value);
610:
611: l_entity_type := cz_security_pvt.RULEFOLDER;
612: l_object_id := get_object_id (l_entity_type);

Line 617: DELETE FROM fnd_grants WHERE menu_id = l_menu_id AND object_id = l_object_id

613: l_instance_set_name := get_instance_set_name(l_entity_type,p_instance_pk1_value);
614: l_instance_set_id := get_instance_set_id(l_object_id,l_instance_set_name);
615: l_menu_id := get_menu_id_for_menuname(cz_security_pvt.EDIT_RULE_ROLE);
616:
617: DELETE FROM fnd_grants WHERE menu_id = l_menu_id AND object_id = l_object_id
618: AND instance_set_id = l_instance_set_id AND instance_pk1_value = to_char(p_instance_pk1_value);
619:
620: l_entity_type := cz_security_pvt.UI;
621: l_object_id := get_object_id (l_entity_type);

Line 626: DELETE FROM fnd_grants WHERE menu_id = l_menu_id AND object_id = l_object_id

622: l_instance_set_name := get_instance_set_name(l_entity_type,p_instance_pk1_value);
623: l_instance_set_id := get_instance_set_id(l_object_id,l_instance_set_name);
624: l_menu_id := get_menu_id_for_menuname(cz_security_pvt.EDIT_UI_ROLE);
625:
626: DELETE FROM fnd_grants WHERE menu_id = l_menu_id AND object_id = l_object_id
627: AND instance_set_id = l_instance_set_id AND instance_pk1_value = to_char(p_instance_pk1_value);
628: END;
629:
630: --------------------------------------------------------------------