DBA Data[Home] [Help]

APPS.AMS_MTL_CATG_LOADER_PVT dependencies on AMS_COMPETITOR_PRODUCTS_B

Line 278: UPDATE ams_competitor_products_b

274: IF c_get_category%FOUND
275: AND l_cat_rec.product_category_id is not null
276: AND l_cat_rec.product_cat_set_id is not null
277: THEN
278: UPDATE ams_competitor_products_b
279: SET category_id = l_cat_rec.product_category_id
280: ,category_set_id = l_cat_rec.product_cat_set_id
281: WHERE competitor_product_id = l_competitor_prod_id;
282: ELSE