APPS.AMW_ORG_HIERARCHY_PKG dependencies on FND_GRANTS

Line 929: FROM fnd_grants grants,

925: granted_menu.menu_name role_name,
926: obj.obj_name object_name,
927: granted_menu.menu_id menu_id,
928: grants.end_date end_date
929: FROM fnd_grants grants,
930: fnd_menus granted_menu,
931: fnd_objects obj
932: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
933: AND grants.object_id = obj.object_id

Line 7048: FROM fnd_grants grants,

7044: granted_menu.menu_name role_name,
7045: obj.obj_name object_name,
7046: granted_menu.menu_id menu_id,
7047: grants.end_date end_date
7048: FROM fnd_grants grants,
7049: fnd_menus granted_menu,
7050: fnd_objects obj
7051: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7052: AND grants.object_id = obj.object_id

Line 7069: FROM fnd_grants grants,

7065: and granted_menu.menu_name in ('AMW_RL_PROC_OWNER_ROLE', 'AMW_RL_PROC_FINANCE_OWNER_ROLE', 'AMW_RL_PROC_APPL_OWNER_ROLE');
7066:
7067: cursor org_only_party_list(org_id number, process_id number, org_menu_name varchar2, rl_menu_name varchar2) is
7068: SELECT grants.grant_guid grant_guid
7069: FROM fnd_grants grants,
7070: fnd_menus granted_menu,
7071: fnd_objects obj
7072: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7073: AND grants.object_id = obj.object_id

Line 7090: FROM fnd_grants grants,

7086: AND grants.instance_pk4_value = '*NULL*'
7087: AND grants.instance_pk5_value = '*NULL*'
7088: and granted_menu.menu_name = org_menu_name
7089: and (grants.grantee_key, obj.object_id ,grants.menu_id ) not in (select grants.grantee_key,obj.object_id, grants.menu_id
7090: FROM fnd_grants grants,
7091: fnd_menus granted_menu,
7092: fnd_objects obj
7093: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7094: AND grants.object_id = obj.object_id

Line 7258: TYPE t_grant_guid IS TABLE OF fnd_grants.grant_guid%type;

7254: p_process_id in number,
7255: p_org_menu_name in varchar2,
7256: p_rl_menu_name in varchar2 ) is
7257:
7258: TYPE t_grant_guid IS TABLE OF fnd_grants.grant_guid%type;
7259: l_grant_guid t_grant_guid;
7260: l_return_status varchar2(10);
7261: l_err_code number;
7262: l_msg_data varchar2(4000);

Line 7272: FROM fnd_grants grants,

7268: l_grant_guid.delete;
7269:
7270: SELECT grants.grant_guid grant_guid
7271: BULK COLLECT INTO l_grant_guid
7272: FROM fnd_grants grants,
7273: fnd_menus granted_menu,
7274: fnd_objects obj
7275: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7276: AND grants.object_id = obj.object_id

Line 7289: FROM fnd_grants grants,

7285: AND grants.instance_pk4_value = '*NULL*'
7286: AND grants.instance_pk5_value = '*NULL*'
7287: and granted_menu.menu_name = p_org_menu_name
7288: and (grants.grantee_key) not in ( select grants.grantee_key
7289: FROM fnd_grants grants,
7290: fnd_menus granted_menu,
7291: fnd_objects obj
7292: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7293: AND grants.object_id = obj.object_id

Line 7340: TYPE t_end_date IS TABLE OF fnd_grants.end_date%TYPE;

7336: p_org_menu_name in varchar2,
7337: p_rl_menu_name in varchar2 ) is
7338:
7339: TYPE t_party_id IS TABLE OF number;
7340: TYPE t_end_date IS TABLE OF fnd_grants.end_date%TYPE;
7341:
7342: l_party_id t_party_id;
7343: l_end_date t_end_date;
7344:

Line 7362: FROM fnd_grants grants,

7358: SELECT TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:','')) party_id,
7359: grants.end_date end_date
7360: BULK COLLECT INTO l_party_id,
7361: l_end_date
7362: FROM fnd_grants grants,
7363: fnd_menus granted_menu,
7364: fnd_objects obj
7365: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7366: AND grants.object_id = obj.object_id

Line 7379: FROM fnd_grants grants,

7375: AND grants.instance_pk4_value = '*NULL*'
7376: AND grants.instance_pk5_value = '*NULL*'
7377: and granted_menu.menu_name = p_rl_menu_name
7378: and (grants.grantee_key) not in ( select grants.grantee_key
7379: FROM fnd_grants grants,
7380: fnd_menus granted_menu,
7381: fnd_objects obj
7382: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7383: AND grants.object_id = obj.object_id