APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on FND_GRANTS

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

978: fgrant.instance_set_id instance_set_id,
979: fmenu.menu_name menu_name,
980: fgrant.program_name program_name,
981: fgrant.program_tag program_tag
982: FROM FND_GRANTS fgrant, FND_OBJECTS fobj, FND_MENUS fmenu
983: WHERE fgrant.menu_id = fmenu.menu_id
984: AND fgrant.object_id = fobj.object_id
985: AND fobj.obj_name = 'OKC_REP_CONTRACT'
986: AND fgrant.instance_pk1_value = to_char(p_contract_id);

Line 1030: FND_GRANTS_PKG.delete_grant(

1026: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1027: 'program_tag is: ' || acl_rec.program_tag);
1028: END IF;
1029: -- call FND_GRANT's delete api
1030: FND_GRANTS_PKG.delete_grant(
1031: p_grantee_type => acl_rec.grantee_type, -- USER or GROUP
1032: p_grantee_key => acl_rec.grantee_key, -- user_id or group_id
1033: p_object_name => G_REP_CONTRACT,
1034: p_instance_type => acl_rec.instance_type, -- INSTANCE or SET

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

3108: fgrant.program_tag program_tag,
3109: fgrant.parameter1 parameter1,
3110: fgrant.parameter2 parameter2,
3111: fgrant.parameter3 parameter3
3112: FROM FND_GRANTS fgrant, FND_OBJECTS fobj, FND_MENUS fmenu
3113: WHERE fgrant.menu_id = fmenu.menu_id
3114: AND fgrant.object_id = fobj.object_id
3115: AND fobj.obj_name = 'OKC_REP_CONTRACT'
3116: AND fgrant.instance_pk1_value = to_char(p_source_contract_id);

Line 3162: FND_GRANTS_PKG.grant_function(

3158: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3159: 'program_tag is: ' || acl_rec.program_tag);
3160: END IF;
3161: -- call FND_GRANT's delete api
3162: FND_GRANTS_PKG.grant_function(
3163: p_api_version => 1.0,
3164: p_menu_name => acl_rec.menu_name, -- Menu to be deleted.
3165: p_object_name => G_REP_CONTRACT,
3166: p_instance_type => acl_rec.instance_type, -- INSTANCE or SET