APPS.IBE_M_AUTOPLACEMENT_PVT dependencies on IBE_DSP_SECTION_ITEMS

Line 288: FROM ibe_dsp_section_items

284: -- start_date, end_date
285: CURSOR c_check_section_item(c_section_id NUMBER,
286: c_item_id NUMBER, c_organization_id NUMBER) IS
287: SELECT section_item_id
288: FROM ibe_dsp_section_items
289: WHERE section_id = c_section_id
290: AND inventory_item_id = c_item_id
291: AND organization_id = c_organization_id;
292:

Line 641: FROM ibe_dsp_section_items si, mtl_system_items_kfv msi,

637: c_organization_id NUMBER, c_start_date DATE,
638: c_end_date DATE) IS
639: SELECT si.section_item_id, si.inventory_item_id,
640: msi.concatenated_segments, ms.description
641: FROM ibe_dsp_section_items si, mtl_system_items_kfv msi,
642: mtl_system_items_vl ms
643: WHERE si.inventory_item_id = ms.inventory_item_id
644: AND si.organization_id = ms.organization_id
645: AND si.organization_id = msi.organization_id

Line 671: -- Should set the end_date_active in IBE_DSP_SECTION_ITEMS

667: g_product_tbl(g_index).section_code := g_section_code;
668: g_product_tbl(g_index).section_name := g_sectioN_name;
669: g_index := g_index + 1;
670: IF (p_mode = 'EXECUTION') THEN
671: -- Should set the end_date_active in IBE_DSP_SECTION_ITEMS
672: -- table and IBE_DSP_MSITE_SCT_ITEMS
673: -- For fixing bug 2771549
674: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
675: (p_api_version => 1.0,