DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on FND_GRANTS

Line 3174: l_grant_guid fnd_grants.grant_guid%TYPE;

3170: l_SERVICE_ITEM_FLAG VARCHAR2(1);
3171: l_VENDOR_WARRANTY_FLAG VARCHAR2(1);
3172: l_USAGE_ITEM_FLAG VARCHAR2(1);
3173: l_party_id FND_USER.CUSTOMER_ID%TYPE;
3174: l_grant_guid fnd_grants.grant_guid%TYPE;
3175: l_ego_exists VARCHAR2(1) := 'N';
3176: l_master_org VARCHAR2(1); --R12: Business Events
3177: l_mast_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE;
3178:

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

4086: -- For Internal Users , Customer_Id may not getting populated in FND_USER
4087: -- Hence checking USER_ID from ego_people_v which always return all registered
4088: -- Users (Customer, Internal and Vendor)
4089: -- Bug Fix : 3048453
4090: --3797291: Using fnd_grants API instead of EGO API.
4091: IF (l_ego_exists = 'Y' AND INV_Item_Util.g_Appl_Inst.EGO <> 0 ) THEN
4092: l_party_id := NULL;
4093: BEGIN
4094:

Line 4101: FND_GRANTS_PKG.GRANT_FUNCTION(

4097: FROM EGO_USER_V
4098: WHERE USER_ID = FND_GLOBAL.User_ID;
4099:
4100: IF l_party_id IS NOT NULL THEN
4101: FND_GRANTS_PKG.GRANT_FUNCTION(
4102: P_API_VERSION => 1.0
4103: ,P_MENU_NAME => 'EGO_ITEM_OWNER'
4104: ,P_OBJECT_NAME => 'EGO_ITEM'
4105: ,P_INSTANCE_TYPE => 'INSTANCE'