APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_STORES_B

Line 731: FROM icx_cat_stores_b

727: BEGIN
728:
729: SELECT 1
730: INTO l_has_main_store
731: FROM icx_cat_stores_b
732: WHERE store_id = 0;
733:
734: l_err_loc := 100;
735:

Line 789: (SELECT sequence_number FROM icx_cat_stores_b

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;
792: l_err_loc := 100;
793:

Line 2414: FROM icx_cat_stores_b stores, icx_cat_store_org_assignments orgs

2410:
2411: SELECT distinct(stores.store_id),
2412: decode(orgs.org_id, -2, 'ALL_USERS', 'OU_SECURED')
2413: BULK COLLECT INTO l_store_ids, l_security_flags
2414: FROM icx_cat_stores_b stores, icx_cat_store_org_assignments orgs
2415: WHERE stores.store_id = orgs.store_id;
2416:
2417: l_err_loc := 100;
2418:

Line 2723: FROM icx_cat_stores_b

2719:
2720: -- select all the old stores (minus the seeded ones) and new store IDs
2721: SELECT store_id, ICX_CAT_SHOP_STORES_S.NEXTVAL
2722: BULK COLLECT INTO l_old_store_ids, l_r12_store_ids
2723: FROM icx_cat_stores_b
2724: WHERE store_id NOT IN (0, 10000000);
2725:
2726: l_err_loc := 100;
2727:

Line 2743: FROM icx_cat_stores_b stores

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
2743: FROM icx_cat_stores_b stores
2744: WHERE stores.store_id = l_old_store_ids(i);
2745:
2746: l_err_loc := 300;
2747: