APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_CONTENT_ZONES_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 845: DELETE FROM icx_cat_content_zones_b

841:
842: l_err_loc := 0;
843:
844: -- remove the R12 seeded zone data
845: DELETE FROM icx_cat_content_zones_b
846: WHERE zone_id = 1;
847: l_err_loc := 100;
848:
849: DELETE FROM icx_cat_content_zones_tl

Line 1008: FROM icx_cat_content_zones_b z, icx_cat_store_contents c

1004: BEGIN
1005:
1006: SELECT zone_id
1007: INTO l_promoted_zone_id
1008: FROM icx_cat_content_zones_b z, icx_cat_store_contents c
1009: WHERE z.supplier_attribute_action_flag = 'INCLUDE_ALL'
1010: AND z.category_attribute_action_flag = 'INCLUDE_ALL'
1011: AND z.zone_id = c.content_id
1012: AND c.store_id = 1;

Line 1016: UPDATE icx_cat_content_zones_b

1012: AND c.store_id = 1;
1013: l_err_loc := 100;
1014:
1015: -- update the promoted zone to zone ID = 1 (seeded ID)
1016: UPDATE icx_cat_content_zones_b
1017: SET zone_id = 1
1018: WHERE zone_id = l_promoted_zone_id;
1019: l_err_loc := 200;
1020:

Line 3227: INSERT INTO icx_cat_content_zones_b

3223: l_err_loc := 0;
3224:
3225: -- do a forall, migrating values into the base and tl tables
3226: FORALL i IN 1..p_catalog_ids.COUNT
3227: INSERT INTO icx_cat_content_zones_b
3228: (zone_id, type, url, security_assignment_flag,
3229: category_attribute_action_flag, supplier_attribute_action_flag,
3230: items_without_supplier_flag, items_without_shop_catg_flag,
3231: created_by, creation_date, last_updated_by,

Line 3337: INSERT INTO icx_cat_content_zones_b

3333: l_err_loc := 0;
3334:
3335: -- do a forall, migrating values into the base and tl tables
3336: FORALL i IN 1..p_new_zone_ids.COUNT
3337: INSERT INTO icx_cat_content_zones_b
3338: (zone_id, type, url, security_assignment_flag,
3339: category_attribute_action_flag, supplier_attribute_action_flag,
3340: items_without_supplier_flag, items_without_shop_catg_flag,
3341: created_by, creation_date, last_updated_by,

Line 3349: FROM icx_cat_content_zones_b zones

3345: DECODE(g_site_approved_pricing, 'Y', 'N',
3346: zones.items_without_supplier_flag),
3347: zones.items_without_shop_catg_flag, fnd_global.user_id,
3348: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3349: FROM icx_cat_content_zones_b zones
3350: WHERE zones.zone_id = 1;
3351:
3352: l_err_loc := 100;
3353:

Line 3607: INSERT INTO icx_cat_content_zones_b

3603: l_err_loc := 0;
3604:
3605: -- using FORALL, migrate values into the base and tl tables
3606: FORALL i IN 1..p_new_zone_ids.COUNT
3607: INSERT INTO icx_cat_content_zones_b
3608: (zone_id, type, url, security_assignment_flag, created_by, creation_date,
3609: last_updated_by, last_update_date, last_update_login)
3610: SELECT p_new_zone_ids(i),
3611: DECODE(type, 'EXTERNAL', 'PUNCHOUT',