APPS.EGO_IMPORT_UTIL_PVT dependencies on FND_GRANTS

Line 4720: l_grant_guid FND_GRANTS.GRANT_GUID%type;

4716: IS
4717: TYPE ref_cursor IS REF CURSOR;
4718: c_get_item_roles ref_cursor;
4719:
4720: l_grant_guid FND_GRANTS.GRANT_GUID%type;
4721: l_return_status VARCHAR2(10);
4722: l_errorcode VARCHAR2(10);
4723: l_menu_id NUMBER;
4724: l_party_key VARCHAR2(99);

Line 4736: l_grantee_type FND_GRANTS.GRANTEE_TYPE%TYPE;

4732:
4733: l_inventory_item_id NUMBER;
4734: l_organization_id NUMBER;
4735: l_menu_name FND_MENUS.MENU_NAME%TYPE;
4736: l_grantee_type FND_GRANTS.GRANTEE_TYPE%TYPE;
4737: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
4738: l_end_date DATE;
4739: BEGIN
4740: Debug_Conc_Log('Default_Item_People: Starting');

Line 4737: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;

4733: l_inventory_item_id NUMBER;
4734: l_organization_id NUMBER;
4735: l_menu_name FND_MENUS.MENU_NAME%TYPE;
4736: l_grantee_type FND_GRANTS.GRANTEE_TYPE%TYPE;
4737: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
4738: l_end_date DATE;
4739: BEGIN
4740: Debug_Conc_Log('Default_Item_People: Starting');
4741: RETCODE := '0';

Line 4800: FND_GRANTS grants,

4796: grants.GRANTEE_KEY,
4797: grants.END_DATE
4798: FROM
4799: MTL_SYSTEM_ITEMS_INTERFACE msii,
4800: FND_GRANTS grants,
4801: FND_MENUS menus
4802: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
4803: AND msii.PROCESS_FLAG = 7
4804: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 4826: FND_GRANTS_PKG.GRANT_FUNCTION(

4822: Debug_Conc_Log('Default_Item_People: Creating grant for l_inventory_item_id, l_organization_id, l_menu_name, l_grantee_type, l_grantee_key, l_end_date='||
4823: l_inventory_item_id||','|| l_organization_id||','|| l_menu_name||','|| l_grantee_type||','|| l_grantee_key||','|| l_end_date);
4824:
4825:
4826: FND_GRANTS_PKG.GRANT_FUNCTION(
4827: p_api_version => 1.0,
4828: p_menu_name => l_menu_name,
4829: p_object_name => 'EGO_ITEM',
4830: p_instance_type => 'INSTANCE',

Line 4905: AND NOT EXISTS (SELECT 1 FROM FND_GRANTS fg

4901: AND msik.STYLE_ITEM_ID = intf.INVENTORY_ITEM_ID
4902: AND msik.ORGANIZATION_ID = mp.ORGANIZATION_ID
4903: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
4904: AND intf.INTERNAL_ROLE_ID = menus.MENU_ID
4905: AND NOT EXISTS (SELECT 1 FROM FND_GRANTS fg
4906: WHERE fg.INSTANCE_TYPE = 'INSTANCE'
4907: AND fg.INSTANCE_PK1_VALUE = To_Char(msik.INVENTORY_ITEM_ID)
4908: AND fg.INSTANCE_PK2_VALUE = TO_CHAR(intf.ORGANIZATION_ID)
4909: AND fg.OBJECT_ID = cp_object_id

Line 4916: l_grant_guid FND_GRANTS.GRANT_GUID%type;

4912: AND fg.GRANTEE_TYPE = intf.GRANTEE_TYPE
4913: AND fg.GRANTEE_KEY = 'HZ_PARTY:'||intf.GRANTEE_PARTY_ID
4914: );
4915:
4916: l_grant_guid FND_GRANTS.GRANT_GUID%type;
4917: l_return_status VARCHAR2(10);
4918: l_errorcode VARCHAR2(10);
4919: l_object_id NUMBER;
4920: l_ret_status VARCHAR2(10);

Line 4946: FND_GRANTS_PKG.GRANT_FUNCTION(

4942: FOR i IN c_skus_to_process(l_request_id, l_object_id) LOOP
4943: Debug_Conc_Log('Copy_Item_People_From_Style: Creating grant for l_inventory_item_id, l_organization_id, l_menu_name, l_grantee_type, l_grantee_key, l_end_date='||
4944: i.INVENTORY_ITEM_ID||','|| i.ORGANIZATION_ID||','|| i.MENU_NAME||','|| i.GRANTEE_TYPE||','|| i.GRANTEE_KEY||','|| i.END_DATE);
4945:
4946: FND_GRANTS_PKG.GRANT_FUNCTION(
4947: p_api_version => 1.0,
4948: p_menu_name => i.MENU_NAME,
4949: p_object_name => 'EGO_ITEM',
4950: p_instance_type => 'INSTANCE',