APPS.ICX_CONTENTS_POSTUPG_PVT dependencies on ICX_CAT_SECURE_CONTENTS

Line 30: -- 6. Duplicate the icx_cat_secure_contents to the new zones.

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.
30: -- 6. Duplicate the icx_cat_secure_contents to the new zones.
31: -- 7. Add these zone to all stores with which the original zone was attached.
32: -- 8. After all the new zones are created, delete the original zones from
33: -- all the relevant tables.
34: -- 9. Populate SQEs required for Catalog Search.

Line 343: INSERT INTO icx_cat_secure_contents

339:
340: l_err_loc := 0;
341:
342: FORALL i IN 1..p_new_zone_ids.COUNT
343: INSERT INTO icx_cat_secure_contents
344: (content_id, org_id, responsibility_id, secure_by, created_by, creation_date,
345: last_updated_by, last_update_date, last_update_login)
346: SELECT p_new_zone_ids(i), contents.org_id, contents.responsibility_id,
347: contents.secure_by, contents.created_by, contents.creation_date,

Line 349: FROM icx_cat_secure_contents contents

345: last_updated_by, last_update_date, last_update_login)
346: SELECT p_new_zone_ids(i), contents.org_id, contents.responsibility_id,
347: contents.secure_by, contents.created_by, contents.creation_date,
348: contents.last_updated_by, contents.last_update_date, contents.last_update_login
349: FROM icx_cat_secure_contents contents
350: WHERE contents.content_id = p_old_zone_id;
351:
352: l_err_loc := 100;
353:

Line 428: -- delete from icx_cat_secure_contents

424: WHERE content_id = p_old_zone_id;
425:
426: l_err_loc := 100;
427:
428: -- delete from icx_cat_secure_contents
429: DELETE icx_cat_secure_contents
430: WHERE content_id = p_old_zone_id;
431:
432: l_err_loc := 200;

Line 429: DELETE icx_cat_secure_contents

425:
426: l_err_loc := 100;
427:
428: -- delete from icx_cat_secure_contents
429: DELETE icx_cat_secure_contents
430: WHERE content_id = p_old_zone_id;
431:
432: l_err_loc := 200;
433: