[Home] [Help]
492: l_err_loc := 0;
493:
494: -- secure the seeded "All Local" content zone with the Main Store;
495: -- this is not handled by the .ldt, so it's done here
496: INSERT INTO icx_cat_store_contents
497: (store_id, content_id, content_type, sequence, display_always_flag,
498: created_by, creation_date, last_updated_by, last_update_date,
499: last_update_login)
500: SELECT 1, 1, 'CONTENT_ZONE', 1, NULL, fnd_global.user_id, sysdate,
531: END IF;
532:
533: l_err_loc := 0;
534:
535: INSERT INTO icx_cat_store_contents
536: (store_id, content_id, content_type, sequence, display_always_flag,
537: created_by, creation_date, last_updated_by, last_update_date,
538: last_update_login)
539: SELECT 2, 10000000, 'SMART_FORM', 1, 'N', fnd_global.user_id, sysdate,
853: -- there are nothing seeded into icx_cat_secure_contents for the seeded
854: -- content zone, so nothing to handle in that table
855:
856: -- remove all links to stores, if any
857: DELETE FROM icx_cat_store_contents
858: WHERE content_id = 1;
859: l_err_loc := 300;
860:
861: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1004: BEGIN
1005:
1006: SELECT zone_id
1007: INTO l_promoted_zone_id
1008: FROM icx_cat_content_zones_b z, icx_cat_store_contents c
1009: WHERE z.supplier_attribute_action_flag = 'INCLUDE_ALL'
1010: AND z.category_attribute_action_flag = 'INCLUDE_ALL'
1011: AND z.zone_id = c.content_id
1012: AND c.store_id = 1;
1031: -- update the store-contents association by deleting the old one, and
1032: -- replacing the new one with the new seeded ID of 1 (as there may
1033: -- be other valuable information saved in this relationship row that
1034: -- should be saved, for instance, sequence).
1035: UPDATE icx_cat_store_contents
1036: SET content_id = 1
1037: WHERE content_id = l_promoted_zone_id;
1038: l_err_loc := 500;
1039:
2820:
2821: l_err_loc := 0;
2822:
2823: FORALL i IN 1..p_zone_ids.COUNT
2824: INSERT INTO icx_cat_store_contents
2825: (store_id, content_id, content_type, sequence, display_always_flag,
2826: created_by, creation_date, last_updated_by, last_update_date,
2827: last_update_login)
2828: SELECT p_r12_store_id, p_zone_ids(i), 'CONTENT_ZONE',
2895:
2896: l_err_loc := 0;
2897:
2898: FORALL i IN 1..p_zone_ids.COUNT
2899: INSERT INTO icx_cat_store_contents
2900: (store_id, content_id, content_type, sequence, display_always_flag,
2901: created_by, creation_date, last_updated_by, last_update_date,
2902: last_update_login)
2903: SELECT p_r12_store_ids(i), p_zone_ids(i), 'CONTENT_ZONE',
2974:
2975: l_err_loc := 0;
2976:
2977: FORALL i IN 1..p_smart_form_ids.COUNT
2978: INSERT INTO icx_cat_store_contents
2979: (store_id, content_id, content_type, sequence, display_always_flag,
2980: created_by, creation_date, last_updated_by, last_update_date,
2981: last_update_login)
2982: SELECT p_r12_store_ids(i), p_smart_form_ids(i), 'SMART_FORM',