APPS.ICX_CONTENTS_POSTUPG_PVT dependencies on ICX_CAT_STORE_CONTENTS

Line 383: INSERT INTO icx_cat_store_contents

379:
380: l_err_loc := 0;
381:
382: FORALL i IN 1..p_new_zone_ids.COUNT
383: INSERT INTO icx_cat_store_contents
384: (store_id, content_id, content_type, sequence, display_always_flag,
385: created_by, creation_date, last_updated_by, last_update_date,
386: last_update_login)
387: SELECT sc.store_id, p_new_zone_ids(i), sc.content_type, sc.sequence,

Line 390: FROM icx_cat_store_contents sc

386: last_update_login)
387: SELECT sc.store_id, p_new_zone_ids(i), sc.content_type, sc.sequence,
388: sc.display_always_flag, sc.created_by, sc.creation_date,
389: sc.last_updated_by, sc.last_update_date, sc.last_update_login
390: FROM icx_cat_store_contents sc
391: WHERE sc.content_id = p_old_zone_id;
392:
393: l_err_loc := 100;
394:

Line 422: -- delete from icx_cat_store_contents

418: END IF;
419:
420: l_err_loc := 0;
421:
422: -- delete from icx_cat_store_contents
423: DELETE icx_cat_store_contents
424: WHERE content_id = p_old_zone_id;
425:
426: l_err_loc := 100;

Line 423: DELETE icx_cat_store_contents

419:
420: l_err_loc := 0;
421:
422: -- delete from icx_cat_store_contents
423: DELETE icx_cat_store_contents
424: WHERE content_id = p_old_zone_id;
425:
426: l_err_loc := 100;
427: