APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_SHOP_STORES_B

Line 235: FROM icx_cat_content_zones_b z, icx_cat_shop_stores_b s

231: BEGIN
232:
233: SELECT 1
234: INTO exists_non_seeded_data
235: FROM icx_cat_content_zones_b z, icx_cat_shop_stores_b s
236: WHERE (z.zone_id NOT IN (1,2) OR s.store_id NOT IN (1,2))
237: AND rownum = 1;
238: l_err_loc := 100;
239:

Line 657: DELETE FROM icx_cat_shop_stores_b

653: -- the main store has been deleted in 11i, so delete the new seeded r12
654: -- main store in this case (as it doesn't really make sense to add
655: -- something the user didn't want before); the user can easily recreate
656: -- a main store if desired.
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

Line 787: UPDATE icx_cat_shop_stores_b

783: END IF;
784:
785: l_err_loc := 0;
786:
787: UPDATE icx_cat_shop_stores_b
788: SET sequence =
789: (SELECT sequence_number FROM icx_cat_stores_b
790: WHERE store_id = p_old_id)
791: WHERE store_id = p_new_id;

Line 2738: INSERT INTO icx_cat_shop_stores_b

2734: l_err_loc := 200;
2735:
2736: -- migrate the base and TL table data
2737: FORALL i IN 1..l_old_store_ids.COUNT
2738: INSERT INTO icx_cat_shop_stores_b
2739: (store_id, sequence, local_content_first_flag, created_by, creation_date,
2740: last_updated_by, last_update_date, last_update_login)
2741: SELECT l_r12_store_ids(i), stores.sequence_number, 'Y', fnd_global.user_id,
2742: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id