APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_SHOP_STORES_TL

Line 661: DELETE FROM icx_cat_shop_stores_tl

657: DELETE FROM icx_cat_shop_stores_b
658: WHERE store_id = 1;
659: l_err_loc := 600;
660:
661: DELETE FROM icx_cat_shop_stores_tl
662: WHERE store_id = 1;
663: l_err_loc := 700;
664:
665: END IF;

Line 794: DELETE FROM icx_cat_shop_stores_tl

790: WHERE store_id = p_old_id)
791: WHERE store_id = p_new_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:

Line 799: INSERT INTO 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,
801: image, created_by, creation_date, last_updated_by, last_update_date,
802: last_update_login)
803: SELECT p_new_id, language, source_lang, store_name,

Line 2749: INSERT INTO icx_cat_shop_stores_tl

2745:
2746: l_err_loc := 300;
2747:
2748: FORALL i IN 1..l_old_store_ids.COUNT
2749: INSERT INTO icx_cat_shop_stores_tl
2750: (store_id, language, source_lang, name, description, long_description,
2751: image, created_by, creation_date, last_updated_by, last_update_date,
2752: last_update_login)
2753: SELECT l_r12_store_ids(i), stores_tl.language, stores_tl.source_lang,