APPS.DOM_SECURITY_PUB dependencies on FND_GRANTS

Line 56: l_grant_guid FND_GRANTS.GRANT_GUID%TYPE ;

52: )
53: IS
54:
55: l_api_name CONSTANT VARCHAR2(50) := 'Grant_Document_Role';
56: l_grant_guid FND_GRANTS.GRANT_GUID%TYPE ;
57: l_grant_exist VARCHAR2(10);
58: l_return_status VARCHAR2(3) ;
59: l_role_name FND_MENUS.MENU_NAME%TYPE;
60: l_pk4_value VARCHAR2(50);

Line 101: update FND_GRANTS

97: else
98: l_pk4_value := p_pk4_value;
99: end if;
100:
101: update FND_GRANTS
102: set parameter1 = p_pk3_value,
103: parameter2 = p_pk4_value
104: where grant_guid = l_grant_guid;
105: end if;

Line 194: l_grantee_key fnd_grants.grantee_key%TYPE;

190: l_role_ids FND_ARRAY_OF_NUMBER_25;
191: l_object_id NUMBER ;
192: lcount1 NUMBER;
193: l_ocs_role_to_revoke VARCHAR2(30);
194: l_grantee_key fnd_grants.grantee_key%TYPE;
195: l_grantee_type fnd_grants.grantee_type%TYPE;
196:
197: CURSOR get_party_type (cp_party_id NUMBER)
198: IS

Line 195: l_grantee_type fnd_grants.grantee_type%TYPE;

191: l_object_id NUMBER ;
192: lcount1 NUMBER;
193: l_ocs_role_to_revoke VARCHAR2(30);
194: l_grantee_key fnd_grants.grantee_key%TYPE;
195: l_grantee_type fnd_grants.grantee_type%TYPE;
196:
197: CURSOR get_party_type (cp_party_id NUMBER)
198: IS
199: SELECT party_type

Line 235: FND_GRANTS_PKG.delete_grant(

231: INTO l_role_name
232: FROM fnd_menus
233: WHERE menu_id = p_role_id;
234:
235: FND_GRANTS_PKG.delete_grant(
236: p_grantee_type => l_grantee_type,
237: p_grantee_key => l_grantee_key,
238: p_object_name => p_object_name,
239: p_instance_type => 'INSTANCE',

Line 277: FND_GRANTS_PKG.delete_grant(

273: INTO l_role_name
274: FROM fnd_menus
275: WHERE menu_id = l_role_ids(lcount1);
276:
277: FND_GRANTS_PKG.delete_grant(
278: p_grantee_type => l_grantee_type,
279: p_grantee_key => l_grantee_key,
280: p_object_name => p_object_name,
281: p_instance_type => 'INSTANCE',

Line 903: FROM fnd_grants grants

899: cp_revision_id VARCHAR2,
900: cp_change_id VARCHAR2,
901: cp_change_line_id VARCHAR2) IS
902: SELECT grants.menu_id menu_id
903: FROM fnd_grants grants
904: WHERE grants.object_id = cp_object_id
905: AND ((grants.instance_pk1_value=cp_document_id )
906: OR((grants.instance_pk1_value = '*NULL*') AND (cp_document_id IS NULL)))
907: AND ((grants.instance_pk2_value=cp_revision_id )

Line 916: l_grantee_key fnd_grants.grantee_key%TYPE;

912: OR((grants.parameter2 IS NULL) AND (cp_change_line_id IS NULL))
913: );
914:
915: l_grantee_type hz_parties.party_type%TYPE;
916: l_grantee_key fnd_grants.grantee_key%TYPE;
917: l_instance_set_id fnd_grants.instance_set_id%TYPE;
918: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
919: l_dummy VARCHAR2(1);
920: l_index INTEGER;

Line 917: l_instance_set_id fnd_grants.instance_set_id%TYPE;

913: );
914:
915: l_grantee_type hz_parties.party_type%TYPE;
916: l_grantee_key fnd_grants.grantee_key%TYPE;
917: l_instance_set_id fnd_grants.instance_set_id%TYPE;
918: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
919: l_dummy VARCHAR2(1);
920: l_index INTEGER;
921:

Line 918: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

914:
915: l_grantee_type hz_parties.party_type%TYPE;
916: l_grantee_key fnd_grants.grantee_key%TYPE;
917: l_instance_set_id fnd_grants.instance_set_id%TYPE;
918: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
919: l_dummy VARCHAR2(1);
920: l_index INTEGER;
921:
922: CURSOR get_party_type (cp_party_id NUMBER)

Line 1044: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;

1040: --
1041: -- END OF comments
1042:
1043:
1044: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
1045: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
1046:
1047: BEGIN
1048: l_grantee_key := 'HZ_PARTY:'||p_party_id;

Line 1045: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;

1041: -- END OF comments
1042:
1043:
1044: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
1045: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
1046:
1047: BEGIN
1048: l_grantee_key := 'HZ_PARTY:'||p_party_id;
1049: