APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_POR_ITEM_SOURCES_TL

Line 618: FROM icx_por_item_sources_tl

614:
615: DELETE FROM icx_cat_content_zones_tl
616: WHERE zone_id = 2
617: AND EXISTS (SELECT 1
618: FROM icx_por_item_sources_tl
619: WHERE item_source_id = 10000001);
620: l_err_loc := 100;
621:
622: INSERT INTO icx_cat_content_zones_tl

Line 629: FROM icx_por_item_sources_tl

625: last_update_login)
626: SELECT 2, language, source_lang, item_source_name, description,
627: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
628: fnd_global.login_id
629: FROM icx_por_item_sources_tl
630: WHERE item_source_id = 10000001;
631: l_err_loc := 200;
632:
633: -- check for the existence of local catalogs (meaning 11.5.9 and later)

Line 3253: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl

3249: SELECT p_new_zone_ids(i), sources_tl.language, sources_tl.source_lang,
3250: sources_tl.item_source_name, sources_tl.description,
3251: sources_tl.ctx_keywords, sources.image_url, fnd_global.user_id,
3252: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3253: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl
3254: WHERE sources.item_source_id = p_catalog_ids(i)
3255: AND sources_tl.item_source_id = sources.item_source_id;
3256:
3257: l_err_loc := 200;

Line 3632: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl

3628: sources_tl.item_source_name, sources_tl.description,
3629: sources_tl.ctx_keywords, sources.image_url,
3630: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3631: fnd_global.login_id
3632: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl
3633: WHERE sources.item_source_id = p_item_source_ids(i)
3634: AND sources_tl.item_source_id = sources.item_source_id;
3635:
3636: l_err_loc := 200;