APPS.EGO_IMPORT_UTIL_PVT dependencies on FND_GRANTS

Line 5470: l_grant_guid FND_GRANTS.GRANT_GUID%type;

5466: IS
5467: TYPE ref_cursor IS REF CURSOR;
5468: c_get_item_roles ref_cursor;
5469:
5470: l_grant_guid FND_GRANTS.GRANT_GUID%type;
5471: l_return_status VARCHAR2(10);
5472: l_errorcode VARCHAR2(10);
5473: l_menu_id NUMBER;
5474: l_party_key VARCHAR2(99);

Line 5486: l_grantee_type FND_GRANTS.GRANTEE_TYPE%TYPE;

5482:
5483: l_inventory_item_id NUMBER;
5484: l_organization_id NUMBER;
5485: l_menu_name FND_MENUS.MENU_NAME%TYPE;
5486: l_grantee_type FND_GRANTS.GRANTEE_TYPE%TYPE;
5487: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
5488: l_end_date DATE;
5489: BEGIN
5490: Debug_Conc_Log('Default_Item_People: Starting');

Line 5487: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;

5483: l_inventory_item_id NUMBER;
5484: l_organization_id NUMBER;
5485: l_menu_name FND_MENUS.MENU_NAME%TYPE;
5486: l_grantee_type FND_GRANTS.GRANTEE_TYPE%TYPE;
5487: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
5488: l_end_date DATE;
5489: BEGIN
5490: Debug_Conc_Log('Default_Item_People: Starting');
5491: RETCODE := '0';

Line 5550: FND_GRANTS grants,

5546: grants.GRANTEE_KEY,
5547: grants.END_DATE
5548: FROM
5549: MTL_SYSTEM_ITEMS_INTERFACE msii,
5550: FND_GRANTS grants,
5551: FND_MENUS menus
5552: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
5553: AND msii.PROCESS_FLAG = 7
5554: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 5576: FND_GRANTS_PKG.GRANT_FUNCTION(

5572: 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='||
5573: l_inventory_item_id||','|| l_organization_id||','|| l_menu_name||','|| l_grantee_type||','|| l_grantee_key||','|| l_end_date);
5574:
5575:
5576: FND_GRANTS_PKG.GRANT_FUNCTION(
5577: p_api_version => 1.0,
5578: p_menu_name => l_menu_name,
5579: p_object_name => 'EGO_ITEM',
5580: p_instance_type => 'INSTANCE',

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

5651: AND msik.STYLE_ITEM_ID = intf.INVENTORY_ITEM_ID
5652: AND msik.ORGANIZATION_ID = mp.ORGANIZATION_ID
5653: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
5654: AND intf.INTERNAL_ROLE_ID = menus.MENU_ID
5655: AND NOT EXISTS (SELECT 1 FROM FND_GRANTS fg
5656: WHERE fg.INSTANCE_TYPE = 'INSTANCE'
5657: AND fg.INSTANCE_PK1_VALUE = To_Char(msik.INVENTORY_ITEM_ID)
5658: AND fg.INSTANCE_PK2_VALUE = TO_CHAR(intf.ORGANIZATION_ID)
5659: AND fg.OBJECT_ID = cp_object_id

Line 5666: l_grant_guid FND_GRANTS.GRANT_GUID%type;

5662: AND fg.GRANTEE_TYPE = intf.GRANTEE_TYPE
5663: AND fg.GRANTEE_KEY = 'HZ_PARTY:'||intf.GRANTEE_PARTY_ID
5664: );
5665:
5666: l_grant_guid FND_GRANTS.GRANT_GUID%type;
5667: l_return_status VARCHAR2(10);
5668: l_errorcode VARCHAR2(10);
5669: l_object_id NUMBER;
5670: l_ret_status VARCHAR2(10);

Line 5696: FND_GRANTS_PKG.GRANT_FUNCTION(

5692: FOR i IN c_skus_to_process(l_request_id, l_object_id) LOOP
5693: 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='||
5694: i.INVENTORY_ITEM_ID||','|| i.ORGANIZATION_ID||','|| i.MENU_NAME||','|| i.GRANTEE_TYPE||','|| i.GRANTEE_KEY||','|| i.END_DATE);
5695:
5696: FND_GRANTS_PKG.GRANT_FUNCTION(
5697: p_api_version => 1.0,
5698: p_menu_name => i.MENU_NAME,
5699: p_object_name => 'EGO_ITEM',
5700: p_instance_type => 'INSTANCE',