APPS.IBE_M_AUTOPLACEMENT_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 308: FROM ibe_dsp_msite_sct_items

304: l_sect_item_id NUMBER;
305: CURSOR c_check_msite_sct_items(c_section_item_id NUMBER,
306: c_minisite_id NUMBER) IS
307: SELECT mini_site_section_item_id
308: FROM ibe_dsp_msite_sct_items
309: WHERE mini_site_id = c_minisite_id
310: AND section_item_id = c_section_item_id;
311: BEGIN
312: printDebuglog('Get Master Minisite');

Line 550: DELETE FROM IBE_DSP_MSITE_SCT_ITEMS

546: IF (c_check_msite_sct_items%FOUND) THEN
547: CLOSE c_check_msite_sct_items;
548: printDebuglog('Clean master minisite from section-item:' ||
549: to_char(l_temp));
550: DELETE FROM IBE_DSP_MSITE_SCT_ITEMS
551: WHERE mini_site_section_item_id = l_temp;
552: ELSE
553: printDebuglog('No data clean action');
554: CLOSE c_check_msite_sct_items;

Line 672: -- table and IBE_DSP_MSITE_SCT_ITEMS

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,
676: p_init_msg_list => FND_API.G_FALSE,