APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on FND_GRANTS

Line 853: FROM FND_GRANTS fgrant, FND_OBJECTS fobj, FND_MENUS fmenu

849: fgrant.instance_set_id instance_set_id,
850: fmenu.menu_name menu_name,
851: fgrant.program_name program_name,
852: fgrant.program_tag program_tag
853: FROM FND_GRANTS fgrant, FND_OBJECTS fobj, FND_MENUS fmenu
854: WHERE fgrant.menu_id = fmenu.menu_id
855: AND fgrant.object_id = fobj.object_id
856: AND fobj.obj_name = 'OKC_REP_CONTRACT'
857: AND fgrant.instance_pk1_value = to_char(p_contract_id);

Line 901: FND_GRANTS_PKG.delete_grant(

897: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
898: 'program_tag is: ' || acl_rec.program_tag);
899: END IF;
900: -- call FND_GRANT's delete api
901: FND_GRANTS_PKG.delete_grant(
902: p_grantee_type => acl_rec.grantee_type, -- USER or GROUP
903: p_grantee_key => acl_rec.grantee_key, -- user_id or group_id
904: p_object_name => G_REP_CONTRACT,
905: p_instance_type => acl_rec.instance_type, -- INSTANCE or SET

Line 2942: FROM FND_GRANTS fgrant, FND_OBJECTS fobj, FND_MENUS fmenu

2938: fgrant.program_tag program_tag,
2939: fgrant.parameter1 parameter1,
2940: fgrant.parameter2 parameter2,
2941: fgrant.parameter3 parameter3
2942: FROM FND_GRANTS fgrant, FND_OBJECTS fobj, FND_MENUS fmenu
2943: WHERE fgrant.menu_id = fmenu.menu_id
2944: AND fgrant.object_id = fobj.object_id
2945: AND fobj.obj_name = 'OKC_REP_CONTRACT'
2946: AND fgrant.instance_pk1_value = to_char(p_source_contract_id);

Line 2992: FND_GRANTS_PKG.grant_function(

2988: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2989: 'program_tag is: ' || acl_rec.program_tag);
2990: END IF;
2991: -- call FND_GRANT's delete api
2992: FND_GRANTS_PKG.grant_function(
2993: p_api_version => 1.0,
2994: p_menu_name => acl_rec.menu_name, -- Menu to be deleted.
2995: p_object_name => G_REP_CONTRACT,
2996: p_instance_type => acl_rec.instance_type, -- INSTANCE or SET