APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;

516: )
517: ORDER BY ATTR_EXT.ATTR_ID;
518:
519: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;

Line 524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;

520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
525: l_concat_value VARCHAR2(32000);
526: l_user_id NUMBER := FND_GLOBAL.USER_ID;
527: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
528: l_delimeter EGO_DEFAULT_OPTIONS.OPTION_VALUE%TYPE;

Line 852: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,

848: p_organization_id,
849: p_item_number,
850: p_style_item_flag,
851: p_style_item_id,
852: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
853: EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID,
854: 'FK'
855: );
856: