DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_STYLE_VARIANT_ATTR_VS

Line 1903: MERGE INTO EGO_STYLE_VARIANT_ATTR_VS ESVAV

1899: -- Processing Style variant value sets. Using a merge statement so that bulk --
1900: -- feature can be used --
1901: --------------------------------------------------------------------------------
1902: IF p_validate_only = FND_API.G_FALSE THEN
1903: MERGE INTO EGO_STYLE_VARIANT_ATTR_VS ESVAV
1904: USING (SELECT
1905: INTF.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID,
1906: INTF.ATTR_VALUE_NUM AS VALUE_SET_ID,
1907: ATTR.ATTR_ID AS ATTRIBUTE_ID

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

1949: SYSDATE,
1950: l_user_id
1951: );
1952:
1953: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Inserted value sets to EGO_STYLE_VARIANT_ATTR_VS, for styles, count='||SQL%ROWCOUNT, 1);
1954:
1955: ---------------------------------------------------------------------------------
1956: -- Marking all these records as processed --
1957: -- All the records that are in status G_PS_STYLE_VARIANT_IN_PROCESS to success --

Line 2433: EGO_STYLE_VARIANT_ATTR_VS SVA,

2429: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
2430: FROM
2431: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,
2432: EGO_ITM_USR_ATTR_INTRFC INTF,
2433: EGO_STYLE_VARIANT_ATTR_VS SVA,
2434: EGO_FND_DF_COL_USGS_EXT ATTR,
2435: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
2436: MTL_SYSTEM_ITEMS_INTERFACE MSII
2437: WHERE INTF.DATA_SET_ID = p_data_set_id