[Home] [Help]
568: --
569: -- In this case, the upgrade is a bit complicated:
570: -- There is no Main Store, but the previous 11.5.9/11.5.10 upgrade script
571: -- will forcibly migrate any old 11.5.8 item sources and add the
572: -- relationship in icx_cat_store_catalogs to a "phantom" main store that
573: -- will not exist. To properly complete this process, this script will
574: -- assume the new seeded R12 is the properly "migrated" store to which
575: -- the item sources will be moved over to content zones (as-is in the
576: -- rest of the script).
1253: l_err_loc := 0;
1254:
1255: SELECT sources.item_source_id, sc.store_id, ICX_CAT_CONTENT_ZONES_S.NEXTVAL
1256: BULK COLLECT INTO l_catalog_ids, l_store_ids, l_new_zone_ids
1257: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
1258: WHERE sources.type = 'LOCAL'
1259: AND sources.item_source_id = sc.item_source_id(+);
1260: l_err_loc := 100;
1261:
1300: l_err_loc := 0;
1301:
1302: SELECT sources.item_source_id, sc.store_id, ICX_CAT_CONTENT_ZONES_S.NEXTVAL
1303: BULK COLLECT INTO l_item_source_ids, l_store_ids, l_new_zone_ids
1304: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
1305: WHERE sources.type IN ('EXTERNAL', 'DISTSRCH', 'INFO')
1306: AND sources.item_source_id = sc.item_source_id(+);
1307: l_err_loc := 100;
1308:
2231: BEGIN
2232:
2233: SELECT templates.template_id, sc.store_id
2234: BULK COLLECT INTO l_template_ids, l_old_store_ids
2235: FROM icx_cat_store_catalogs sc, por_noncat_templates_all_b templates,
2236: icx_cat_store_org_assignments orgs
2237: WHERE templates.template_id = sc.item_source_id
2238: AND sc.store_id = orgs.store_id
2239: AND orgs.org_id IN (templates.org_id, -2)
2614: l_err_loc := 100;
2615:
2616: SELECT sources.item_source_id, sources.type, sc.store_id
2617: BULK COLLECT INTO x_old_content_ids, x_content_types, x_old_store_ids
2618: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
2619: WHERE sources.item_source_id = sc.item_source_id(+)
2620: AND sources.type <> 'CNTRCTR'
2621: ORDER BY sc.store_id;
2622:
2632: l_err_loc := 200;
2633:
2634: SELECT sources.item_source_id, sources.type, sc.store_id
2635: BULK COLLECT INTO x_old_content_ids, x_content_types, x_old_store_ids
2636: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
2637: WHERE sources.item_source_id = sc.item_source_id(+)
2638: AND sources.type IN ('EXTERNAL', 'DISTSRCH', 'INFO')
2639: ORDER BY sc.store_id;
2640:
2650: l_err_loc := 300;
2651:
2652: SELECT sources.item_source_id, sources.type, sc.store_id
2653: BULK COLLECT INTO x_old_content_ids, x_content_types, x_old_store_ids
2654: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
2655: WHERE sources.item_source_id = sc.item_source_id(+)
2656: AND sources.type = 'LOCAL'
2657: ORDER BY sc.store_id;
2658:
2828: SELECT p_r12_store_id, p_zone_ids(i), 'CONTENT_ZONE',
2829: sc.sequence_number, sc.display_always_flag,
2830: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
2831: fnd_global.login_id
2832: FROM icx_cat_store_catalogs sc
2833: WHERE p_old_store_id IS NOT NULL
2834: AND sc.store_id = p_old_store_id
2835: AND sc.item_source_id = p_old_source_id;
2836:
2903: SELECT p_r12_store_ids(i), p_zone_ids(i), 'CONTENT_ZONE',
2904: sc.sequence_number, sc.display_always_flag,
2905: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
2906: fnd_global.login_id
2907: FROM icx_cat_store_catalogs sc
2908: WHERE p_old_store_ids(i) IS NOT NULL
2909: AND sc.store_id = p_old_store_ids(i)
2910: AND sc.item_source_id = p_old_source_ids(i);
2911:
2982: SELECT p_r12_store_ids(i), p_smart_form_ids(i), 'SMART_FORM',
2983: DECODE(default_template_flag, 'Y', 1, NULL),
2984: sc.display_always_flag, fnd_global.user_id, sysdate,
2985: fnd_global.user_id, sysdate, fnd_global.login_id
2986: FROM icx_cat_store_catalogs sc
2987: WHERE sc.store_id = p_old_store_ids(i)
2988: AND sc.item_source_id = p_smart_form_ids(i);
2989:
2990: l_err_loc := 100;