[Home] [Help]
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: ---------------------------------------------------------------------------------------------------
5505: --** PROCEDURE Reference_Section_Content
5506: --** (
5529: -- get all the mappings associated with the Media logical item
5530:
5531: --** CURSOR c2(l_item_id IN NUMBER)
5532: --** IS SELECT msite_id,language_code,attachment_id,default_language,default_site
5533: --** from ibe_dsp_lgl_phys_map where item_id=l_item_id;
5534:
5535: --** BEGIN
5536: --** IF ((p_old_section_id is null) or (p_new_section_id is null)) then
5537: --** RAISE FND_API.g_exc_error;
5566:
5567: -- get all the mapping for the old Logical Media
5568: --** For r2 in c2(r1.item_id) LOOP
5569:
5570: -- Add all the mappings in the ibe_dsp_lgl_phys_map table for the copied new Logical Item Id
5571:
5572: --** Save_Physical_Map(p_item_id => l_new_item_id,
5573: --** p_msite_id => r2.msite_id,
5574: --** p_language_code =>r2.language_code,
5578: --** x_return_status =>x_return_status,
5579: --** x_msg_count =>x_msg_count,
5580: --** x_msg_data =>x_msg_data);
5581:
5582: -- dbms_output.put_line('inserting into ibe_dsp_lgl_phys_map');
5583:
5584: --** END LOOP; -- end for r2 in c2
5585:
5586:
5657:
5658: END Copy_Logical_Media;
5659:
5660: ---------------------------------------------------------------------------
5661: -- save the rows in the ibe_dsp_lgl_phys_map table for the logical item id.
5662: --
5663: --
5664: PROCEDURE Save_Physical_Map(p_item_id IN NUMBER,
5665: p_msite_id IN NUMBER,
5677: l_lgl_phys_map_id NUMBER;
5678: l_language_code_tbl ibe_physicalMap_grp.LANGUAGE_CODE_TBL_TYPE;
5679:
5680: CURSOR lgl_phys_map_id_seq IS
5681: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;
5682: BEGIN
5683:
5684: IF (p_item_id IS NULL)or (p_msite_id IS NULL) OR (p_attachment_id IS NULL)
5685: OR (p_language_code IS NULL ) or (p_default_site is null ) or (p_default_language is null) THEN
5689: OPEN lgl_phys_map_id_seq;
5690: FETCH lgl_phys_map_id_seq INTO l_lgl_phys_map_id;
5691: CLOSE lgl_phys_map_id_seq;
5692:
5693: INSERT INTO IBE_DSP_LGL_PHYS_MAP (
5694: lgl_phys_map_id,
5695: object_version_number,
5696: last_update_date,
5697: last_updated_by,