APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_CONTENT_ZONES_TL

Line 615: DELETE FROM icx_cat_content_zones_tl

611: -- the base table), the easiest way to do migrate is remove the seeded tl
612: -- rows and replace them with the existing translated contractor rows.
613: -- per .ldt file, contractor catalog was 10,000,001 in 11.5.10 and 2 in R12
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);

Line 622: INSERT INTO icx_cat_content_zones_tl

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
623: (zone_id, language, source_lang, name, description,
624: created_by, creation_date, last_updated_by, last_update_date,
625: last_update_login)
626: SELECT 2, language, source_lang, item_source_name, description,

Line 849: DELETE FROM icx_cat_content_zones_tl

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
850: WHERE zone_id = 1;
851: l_err_loc := 200;
852:
853: -- there are nothing seeded into icx_cat_secure_contents for the seeded

Line 1021: UPDATE icx_cat_content_zones_tl

1017: SET zone_id = 1
1018: WHERE zone_id = l_promoted_zone_id;
1019: l_err_loc := 200;
1020:
1021: UPDATE icx_cat_content_zones_tl
1022: SET zone_id = 1
1023: WHERE zone_id = l_promoted_zone_id;
1024: l_err_loc := 300;
1025:

Line 3245: INSERT INTO icx_cat_content_zones_tl

3241:
3242: l_err_loc := 100;
3243:
3244: FORALL i IN 1..p_catalog_ids.COUNT
3245: INSERT INTO icx_cat_content_zones_tl
3246: (zone_id, language, source_lang, name, description, keywords, image,
3247: created_by, creation_date, last_updated_by, last_update_date,
3248: last_update_login)
3249: SELECT p_new_zone_ids(i), sources_tl.language, sources_tl.source_lang,

Line 3355: INSERT INTO icx_cat_content_zones_tl

3351:
3352: l_err_loc := 100;
3353:
3354: FORALL i IN 1..p_new_zone_ids.COUNT
3355: INSERT INTO icx_cat_content_zones_tl
3356: (zone_id, language, source_lang, name, description, keywords, image,
3357: created_by, creation_date, last_updated_by, last_update_date,
3358: last_update_login)
3359: SELECT p_new_zone_ids(i), zones_tl.language, zones_tl.source_lang,

Line 3363: FROM icx_cat_content_zones_tl zones_tl

3359: SELECT p_new_zone_ids(i), zones_tl.language, zones_tl.source_lang,
3360: zones_tl.name, zones_tl.description,
3361: zones_tl.keywords, zones_tl.image, fnd_global.user_id,
3362: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3363: FROM icx_cat_content_zones_tl zones_tl
3364: WHERE zones_tl.zone_id = 1;
3365:
3366: l_err_loc := 200;
3367:

Line 3623: INSERT INTO icx_cat_content_zones_tl

3619:
3620: l_err_loc := 100;
3621:
3622: FORALL i IN 1..p_new_zone_ids.COUNT
3623: INSERT INTO icx_cat_content_zones_tl
3624: (zone_id, language, source_lang, name, description, keywords, image,
3625: created_by, creation_date, last_updated_by, last_update_date,
3626: last_update_login)
3627: SELECT p_new_zone_ids(i), sources_tl.language, sources_tl.source_lang,