[Home] [Help]
603: l_source_layout_type VARCHAR2(1);
604:
605: CURSOR c_get_component_mapping_all(c_section_id NUMBER) IS
606: SELECT obj.item_id, obj.context_id, obj.object_type
607: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context
608: WHERE obj.object_id = c_section_id
609: AND obj.object_type = 'S'
610: AND obj.context_id = context.context_id
611: AND context.context_type_code = 'LAYOUT_COMPONENT';
615: -- for example, subsection, featured section, product section
616: -- old process template
617: CURSOR c_get_component_mapping(c_section_id NUMBER) IS
618: SELECT obj.item_id, obj.context_id, obj.object_type
619: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context
620: WHERE obj.object_id = c_section_id
621: AND obj.object_type = 'S'
622: AND obj.context_id = context.context_id
623: AND context.context_type_code = 'LAYOUT_COMPONENT'
642:
643: IF (l_source_layout_type = 'C') THEN
644: -- Bulk collection will be used for inserting the data into mapping table
645: IF (p_include_all = FND_API.G_FALSE) THEN
646: DELETE FROM ibe_dsp_obj_lgl_ctnt obj
647: WHERE obj.object_id = p_target_section_id
648: AND obj.object_type = 'S'
649: AND EXISTS (
650: SELECT 1
652: WHERE obj.context_id = context.context_id
653: AND context.context_type_code = 'LAYOUT_COMPONENT')
654: AND NOT EXISTS(
655: SELECT 1
656: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1
657: WHERE obj1.context_id = obj.context_id
658: AND obj1.context_id = context.context_id
659: AND obj1.object_id = p_source_section_id
660: AND obj1.object_type = 'S'
662: AND context.component_type_code <> 'CENTER');
663: -- AND context.component_type_code <> 'OLD_PROCESS'
664: -- Component mapping except old processing and center display template
665: FOR mapping IN c_get_component_mapping(p_source_section_id) LOOP
666: UPDATE ibe_dsp_obj_lgl_ctnt
667: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
668: ITEM_ID = mapping.item_id,
669: CREATED_BY = FND_GLOBAL.user_id,
670: CREATION_DATE = SYSDATE,
674: WHERE object_id = p_target_section_id
675: AND object_type = 'S'
676: AND context_id = mapping.context_id;
677: IF sql%NOTFOUND THEN
678: INSERT INTO ibe_dsp_obj_lgl_ctnt(OBJ_LGL_CTNT_ID,
679: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
680: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
681: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
682: ITEM_ID)
679: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
680: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
681: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
682: ITEM_ID)
683: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
684: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
685: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
686: END IF;
687: END LOOP;
686: END IF;
687: END LOOP;
688: ELSE
689: -- Component exclude old processing
690: DELETE FROM ibe_dsp_obj_lgl_ctnt obj
691: WHERE obj.object_id = p_target_section_id
692: AND obj.object_type = 'S'
693: AND EXISTS (
694: SELECT 1
696: WHERE obj.context_id = context.context_id
697: AND context.context_type_code = 'LAYOUT_COMPONENT')
698: AND NOT EXISTS(
699: SELECT 1
700: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1
701: WHERE obj1.context_id = obj.context_id
702: AND obj1.context_id = context.context_id
703: AND obj1.object_id = p_source_section_id
704: AND obj1.object_type = 'S'
704: AND obj1.object_type = 'S'
705: AND context.context_type_code = 'LAYOUT_COMPONENT');
706: -- AND context.component_type_code <> 'OLD_PROCESS');
707: FOR mapping IN c_get_component_mapping_all(p_source_section_id) LOOP
708: UPDATE ibe_dsp_obj_lgl_ctnt
709: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
710: ITEM_ID = mapping.item_id,
711: CREATED_BY = FND_GLOBAL.user_id,
712: CREATION_DATE = SYSDATE,
716: WHERE object_id = p_target_section_id
717: AND object_type = 'S'
718: AND context_id = mapping.context_id;
719: IF sql%NOTFOUND THEN
720: INSERT INTO ibe_dsp_obj_lgl_ctnt(OBJ_LGL_CTNT_ID,
721: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
722: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
723: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
724: ITEM_ID)
721: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
722: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
723: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
724: ITEM_ID)
725: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
726: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
727: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
728: END IF;
729: END LOOP;
5452:
5453: --get all the logical multimedia associated with the original Section
5454:
5455: CURSOR c1(l_old_section_id IN NUMBER)
5456: IS SELECT item_id,context_id from ibe_dsp_obj_lgl_ctnt where
5457: object_type='S' and object_id= l_old_section_id;
5458:
5459:
5460:
5496: -- Reference the contents of the old section to the new section.
5497: --
5498: ---step1:Retrieve all the Logical Media associated with the Old_Section
5499: -- step2:Create copy of all these Logical Media (jtf_amv_items_b/tl table)
5500: -- step3:Associate the new section with these new Logical Media ( ibe_dsp_obj_lgl_ctnt table)
5501: -- step4:For all the new Logical media, create equivalent store mappings as existed for the Old Logical Media
5502: -- (ibe_dsp_lgl_phys_map)
5503:
5504: ---------------------------------------------------------------------------------------------------
5521:
5522: --get all the logical multimedia associated with the original Section
5523:
5524: --** CURSOR c1(l_old_section_id IN NUMBER)
5525: --** IS SELECT item_id,context_id from ibe_dsp_obj_lgl_ctnt where
5526: --** object_type='S' and object_id= l_old_section_id;
5527:
5528:
5529: -- get all the mappings associated with the Media logical item
5899: -- for example, subsection, featured section, product section
5900: -- old process template
5901: CURSOR c_get_component_mapping(c_section_id NUMBER) IS
5902: SELECT obj.item_id, obj.context_id, obj.object_type
5903: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context
5904: WHERE obj.object_id = c_section_id
5905: AND obj.object_type = 'S'
5906: AND obj.context_id = context.context_id
5907: AND context.context_type_code = 'LAYOUT_COMPONENT'
5951: END IF;
5952: IF (G_ENABLE_TRACE= 'Y') THEN
5953: fnd_file.put_line(fnd_file.log,'Delete from ibe_dsp_obj_lgl_cnt_obj for section '||p_target_section_id);
5954: END IF;
5955: DELETE FROM ibe_dsp_obj_lgl_ctnt obj
5956: WHERE obj.object_id = p_target_section_id
5957: AND obj.object_type = 'S'
5958: AND EXISTS (
5959: SELECT 1
5961: WHERE obj.context_id = context.context_id
5962: AND context.context_type_code = 'LAYOUT_COMPONENT')
5963: AND NOT EXISTS(
5964: SELECT 1
5965: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1
5966: WHERE obj1.context_id = obj.context_id
5967: AND obj1.context_id = context.context_id
5968: AND obj1.object_id = p_source_section_id
5969: AND obj1.object_type = 'S'
5987: END IF;
5988: IF (G_ENABLE_TRACE= 'Y') THEN
5989: fnd_file.put_line(fnd_file.log,'Layout component mapping for section '||p_target_section_id);
5990: END IF;
5991: UPDATE ibe_dsp_obj_lgl_ctnt
5992: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
5993: ITEM_ID = mapping.item_id,
5994: CREATED_BY = FND_GLOBAL.user_id,
5995: CREATION_DATE = SYSDATE,
5999: WHERE object_id = p_target_section_id
6000: AND object_type = 'S'
6001: AND context_id = mapping.context_id;
6002: IF sql%NOTFOUND THEN
6003: INSERT INTO ibe_dsp_obj_lgl_ctnt(OBJ_LGL_CTNT_ID,
6004: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
6005: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
6006: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
6007: ITEM_ID)
6004: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
6005: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
6006: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
6007: ITEM_ID)
6008: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL,1,FND_GLOBAL.user_id,SYSDATE,
6009: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id, NULL,
6010: mapping.context_id, 'S', p_target_section_id, mapping.item_id);
6011: END IF;
6012: x_section_ids.extend(1);
6197: x_layout_comp_ids.extend(1);
6198: l_idx := l_idx + 1;
6199: x_section_ids(l_idx) := p_section_id;
6200: x_layout_comp_ids(l_idx) := p_layout_comp_id(l_i);
6201: DELETE FROM ibe_dsp_obj_lgl_ctnt obj
6202: WHERE obj.object_id = p_section_id
6203: AND obj.object_type = 'S'
6204: AND obj.context_id = p_layout_comp_id(l_i);
6205: ELSIF (p_actionflags(l_i) = 'I') AND
6208: x_layout_comp_ids.extend(1);
6209: l_idx := l_idx + 1;
6210: x_section_ids(l_idx) := p_section_id;
6211: x_layout_comp_ids(l_idx) := p_layout_comp_id(l_i);
6212: INSERT INTO ibe_dsp_obj_lgl_ctnt(OBJ_LGL_CTNT_ID,
6213: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
6214: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
6215: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
6216: ITEM_ID)
6213: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
6214: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
6215: SECURITY_GROUP_ID, CONTEXT_ID, OBJECT_TYPE, OBJECT_ID,
6216: ITEM_ID)
6217: VALUES(ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL, 1, FND_GLOBAL.user_id,
6218: SYSDATE, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.login_id,
6219: NULL, p_layout_comp_id(l_i), 'S', p_section_id,
6220: p_layout_temp_id(l_i));
6221: ELSIF (p_actionflags(l_i) = 'U') AND
6224: x_layout_comp_ids.extend(1);
6225: l_idx := l_idx + 1;
6226: x_section_ids(l_idx) := p_section_id;
6227: x_layout_comp_ids(l_idx) := p_layout_comp_id(l_i);
6228: UPDATE ibe_dsp_obj_lgl_ctnt
6229: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
6230: ITEM_ID = p_layout_temp_id(l_i),
6231: CREATED_BY = FND_GLOBAL.user_id,
6232: CREATION_DATE = SYSDATE,
6367: AND ctx.component_type_code = 'SECTION';
6368:
6369: CURSOR c_get_center_map_csr(c_section_id NUMBER, c_context_id NUMBER) IS
6370: SELECT map.obj_lgl_ctnt_id, map.object_version_number
6371: FROM ibe_dsp_obj_lgl_ctnt map
6372: WHERE map.object_id = c_section_id
6373: AND map.object_type = 'S'
6374: AND map.context_id = c_context_id;
6375: