DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_STYLE_VARIANT_ATTR_VS

Line 2337: MERGE INTO EGO_STYLE_VARIANT_ATTR_VS ESVAV

2333: -- Processing Style variant value sets. Using a merge statement so that bulk --
2334: -- feature can be used --
2335: --------------------------------------------------------------------------------
2336: IF p_validate_only = FND_API.G_FALSE THEN
2337: MERGE INTO EGO_STYLE_VARIANT_ATTR_VS ESVAV
2338: USING (SELECT
2339: INTF.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID,
2340: INTF.ATTR_VALUE_NUM AS VALUE_SET_ID,
2341: ATTR.ATTR_ID AS ATTRIBUTE_ID

Line 2387: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Inserted value sets to EGO_STYLE_VARIANT_ATTR_VS, for styles, count='||SQL%ROWCOUNT, 1);

2383: SYSDATE,
2384: l_user_id
2385: );
2386:
2387: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Inserted value sets to EGO_STYLE_VARIANT_ATTR_VS, for styles, count='||SQL%ROWCOUNT, 1);
2388:
2389: ---------------------------------------------------------------------------------
2390: -- Marking all these records as processed --
2391: -- All the records that are in status G_PS_STYLE_VARIANT_IN_PROCESS to success --

Line 3085: EGO_STYLE_VARIANT_ATTR_VS SVA,

3081: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
3082: FROM
3083: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,
3084: EGO_ITM_USR_ATTR_INTRFC INTF,
3085: EGO_STYLE_VARIANT_ATTR_VS SVA,
3086: EGO_FND_DF_COL_USGS_EXT ATTR,
3087: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
3088: MTL_SYSTEM_ITEMS_INTERFACE MSII
3089: WHERE INTF.DATA_SET_ID = p_data_set_id