APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_STORES_TL

Line 796: AND EXISTS (SELECT 1 FROM icx_cat_stores_tl WHERE store_id = p_old_id);

792: l_err_loc := 100;
793:
794: DELETE FROM icx_cat_shop_stores_tl
795: WHERE store_id = p_new_id
796: AND EXISTS (SELECT 1 FROM icx_cat_stores_tl WHERE store_id = p_old_id);
797: l_err_loc := 200;
798:
799: INSERT INTO icx_cat_shop_stores_tl
800: (store_id, language, source_lang, name, description, long_description,

Line 807: FROM icx_cat_stores_tl

803: SELECT p_new_id, language, source_lang, store_name,
804: short_description, long_description, image_location,
805: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
806: fnd_global.login_id
807: FROM icx_cat_stores_tl
808: WHERE store_id = p_old_id;
809: l_err_loc := 300;
810:
811: -- add the relationship to the stores map

Line 2757: FROM icx_cat_stores_tl stores_tl

2753: SELECT l_r12_store_ids(i), stores_tl.language, stores_tl.source_lang,
2754: stores_tl.store_name, stores_tl.short_description,
2755: stores_tl.long_description, stores_tl.image_location, fnd_global.user_id,
2756: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
2757: FROM icx_cat_stores_tl stores_tl
2758: WHERE stores_tl.store_id = l_old_store_ids(i);
2759:
2760: l_err_loc := 400;
2761: