APPS.ICX_CONTENTS_POSTUPG_PVT dependencies on ICX_CAT_CONTENT_ZONES_TL

Line 25: -- 3. Create icx_cat_content_zones_b, icx_cat_content_zones_tl for each of

21: -- 1. Get local content zones with sqe_sequence not populated due to size
22: -- restriction
23: -- 2. For each of the zones, find the category count. Group them into
24: -- multiple zones with 150 categories each.
25: -- 3. Create icx_cat_content_zones_b, icx_cat_content_zones_tl for each of
26: -- these new zones.
27: -- 4. Duplicate the supplier restrictions from the original zones to the new
28: -- zones.
29: -- 5. Create Category restrictions to these new zones.

Line 240: INSERT INTO icx_cat_content_zones_tl

236:
237: l_err_loc := 200;
238:
239: FORALL i IN 1..p_new_zone_ids.COUNT
240: INSERT INTO icx_cat_content_zones_tl
241: (zone_id, language, source_lang, name, description, keywords, image,
242: created_by, creation_date, last_updated_by, last_update_date,
243: last_update_login)
244: SELECT p_new_zone_ids(i), zones_tl.language, zones_tl.source_lang, zones_tl.name || ' : ' || l_index_tab(i),

Line 248: FROM icx_cat_content_zones_tl zones_tl

244: SELECT p_new_zone_ids(i), zones_tl.language, zones_tl.source_lang, zones_tl.name || ' : ' || l_index_tab(i),
245: zones_tl.description, zones_tl.keywords, zones_tl.image,
246: zones_tl.created_by, zones_tl.creation_date, zones_tl.last_updated_by, zones_tl.last_update_date,
247: zones_tl.last_update_login
248: FROM icx_cat_content_zones_tl zones_tl
249: WHERE zones_tl.zone_id = p_old_zone_id;
250:
251:
252: l_err_loc := 300;

Line 440: -- delete from icx_cat_content_zones_tl

436: WHERE zone_id=p_old_zone_id;
437:
438: l_err_loc := 300;
439:
440: -- delete from icx_cat_content_zones_tl
441: DELETE icx_cat_content_zones_tl
442: WHERE zone_id=p_old_zone_id;
443:
444: l_err_loc := 400;

Line 441: DELETE icx_cat_content_zones_tl

437:
438: l_err_loc := 300;
439:
440: -- delete from icx_cat_content_zones_tl
441: DELETE icx_cat_content_zones_tl
442: WHERE zone_id=p_old_zone_id;
443:
444: l_err_loc := 400;
445: