DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on FND_GRANTS

Line 3435: l_grant_guid fnd_grants.grant_guid%TYPE;

3431: l_SERVICE_ITEM_FLAG VARCHAR2(1);
3432: l_VENDOR_WARRANTY_FLAG VARCHAR2(1);
3433: l_USAGE_ITEM_FLAG VARCHAR2(1);
3434: l_party_id FND_USER.CUSTOMER_ID%TYPE;
3435: l_grant_guid fnd_grants.grant_guid%TYPE;
3436: l_ego_exists VARCHAR2(1) := 'N';
3437: l_master_org VARCHAR2(1); --R12: Business Events
3438: l_mast_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE;
3439:

Line 4355: --3797291: Using fnd_grants API instead of EGO API.

4351: -- For Internal Users , Customer_Id may not getting populated in FND_USER
4352: -- Hence checking USER_ID from ego_people_v which always return all registered
4353: -- Users (Customer, Internal and Vendor)
4354: -- Bug Fix : 3048453
4355: --3797291: Using fnd_grants API instead of EGO API.
4356: IF (l_ego_exists = 'Y' AND INV_Item_Util.g_Appl_Inst.EGO <> 0 ) THEN
4357: l_party_id := NULL;
4358: BEGIN
4359:

Line 4366: FND_GRANTS_PKG.GRANT_FUNCTION(

4362: FROM EGO_USER_V
4363: WHERE USER_ID = FND_GLOBAL.User_ID;
4364:
4365: IF l_party_id IS NOT NULL THEN
4366: FND_GRANTS_PKG.GRANT_FUNCTION(
4367: P_API_VERSION => 1.0
4368: ,P_MENU_NAME => 'EGO_ITEM_OWNER'
4369: ,P_OBJECT_NAME => 'EGO_ITEM'
4370: ,P_INSTANCE_TYPE => 'INSTANCE'