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,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_DATE = SYSDATE,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
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,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_DATE = SYSDATE,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
674: WHERE object_id = p_target_section_id
675: AND object_type = 'S'
669: CREATED_BY = FND_GLOBAL.user_id,
670: CREATION_DATE = SYSDATE,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_DATE = SYSDATE,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
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
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;
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;
688: ELSE
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,
713: LAST_UPDATED_BY = FND_GLOBAL.user_id,
714: LAST_UPDATE_DATE = SYSDATE,
715: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
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,
713: LAST_UPDATED_BY = FND_GLOBAL.user_id,
714: LAST_UPDATE_DATE = SYSDATE,
715: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
716: WHERE object_id = p_target_section_id
717: AND object_type = 'S'
711: CREATED_BY = FND_GLOBAL.user_id,
712: CREATION_DATE = SYSDATE,
713: LAST_UPDATED_BY = FND_GLOBAL.user_id,
714: LAST_UPDATE_DATE = SYSDATE,
715: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
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
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;
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;
730: END IF;
3175: start_date_active = l_start_date_active,
3176: end_date_active = l_end_date_active,
3177: sort_order = l_sort_order,
3178: last_update_date = SYSDATE,
3179: last_updated_by = FND_GLOBAL.user_id
3180: WHERE mini_site_id = l_old_mini_site_ids(j)
3181: AND child_section_id = p_section_id
3182: AND parent_section_id <> l_parent_section_id;
3183: END IF;
5707: ) VALUES (
5708: l_lgl_phys_map_id,
5709: 1,
5710: SYSDATE,
5711: FND_GLOBAL.user_id,
5712: SYSDATE,
5713: FND_GLOBAL.user_id,
5714: FND_GLOBAL.login_id,
5715: p_msite_id,
5709: 1,
5710: SYSDATE,
5711: FND_GLOBAL.user_id,
5712: SYSDATE,
5713: FND_GLOBAL.user_id,
5714: FND_GLOBAL.login_id,
5715: p_msite_id,
5716: p_language_code,
5717: p_attachment_id,
5710: SYSDATE,
5711: FND_GLOBAL.user_id,
5712: SYSDATE,
5713: FND_GLOBAL.user_id,
5714: FND_GLOBAL.login_id,
5715: p_msite_id,
5716: p_language_code,
5717: p_attachment_id,
5718: p_item_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,
5996: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5997: LAST_UPDATE_DATE = SYSDATE,
5998: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
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,
5996: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5997: LAST_UPDATE_DATE = SYSDATE,
5998: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
5999: WHERE object_id = p_target_section_id
6000: AND object_type = 'S'
5994: CREATED_BY = FND_GLOBAL.user_id,
5995: CREATION_DATE = SYSDATE,
5996: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5997: LAST_UPDATE_DATE = SYSDATE,
5998: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
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
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);
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);
6013: x_layout_comp_ids.extend(1);
6179: -- dbms_output.put_line('Before updating ibe_dsp_sections_b');
6180: UPDATE ibe_dsp_sections_b
6181: SET deliverable_id = l_new_deliverable_id,
6182: last_update_date = SYSDATE,
6183: last_updated_by = FND_GLOBAL.user_id,
6184: object_version_number = object_version_number + 1
6185: WHERE section_id = p_section_id;
6186: -- dbms_output.put_line('After updating ibe_dsp_sections_b');
6187: -------------------------------------
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
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
6222: (p_layout_temp_id(l_i) IS NOT NULL) THEN
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,
6233: LAST_UPDATED_BY = FND_GLOBAL.user_id,
6234: LAST_UPDATE_DATE = SYSDATE,
6235: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
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,
6233: LAST_UPDATED_BY = FND_GLOBAL.user_id,
6234: LAST_UPDATE_DATE = SYSDATE,
6235: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
6236: WHERE object_id = p_section_id
6237: AND object_type = 'S'
6231: CREATED_BY = FND_GLOBAL.user_id,
6232: CREATION_DATE = SYSDATE,
6233: LAST_UPDATED_BY = FND_GLOBAL.user_id,
6234: LAST_UPDATE_DATE = SYSDATE,
6235: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
6236: WHERE object_id = p_section_id
6237: AND object_type = 'S'
6238: AND context_id = p_layout_comp_id(l_i)
6239: AND object_version_number = p_object_versions(l_i);
6254: l_master_minisite_id) LOOP
6255: UPDATE ibe_dsp_sections_b
6256: SET deliverable_id = l_new_deliverable_id,
6257: last_update_date = SYSDATE,
6258: last_updated_by = FND_GLOBAL.user_id,
6259: object_version_number = object_version_number + 1
6260: WHERE section_id = child_section.child_section_id;
6261: -- Get the original layout of the section
6262: Cascade_Layout_Comp_Mapping