APPS.IBE_DSP_SECTION_ITEM_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 1119: IS SELECT mini_site_section_item_id FROM ibe_dsp_msite_sct_items

1115: l_inventory_item_id NUMBER;
1116: l_organization_id NUMBER;
1117:
1118: CURSOR c1(l_c_section_item_id IN NUMBER)
1119: IS SELECT mini_site_section_item_id FROM ibe_dsp_msite_sct_items
1120: WHERE section_item_id = l_c_section_item_id;
1121:
1122: CURSOR c2(l_c_section_item_id IN NUMBER)
1123: IS SELECT section_id, inventory_item_id, organization_id

Line 1227: -- delete from ibe_dsp_msite_sct_items table

1223: FND_MSG_PUB.Add;
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:
1227: -- delete from ibe_dsp_msite_sct_items table
1228: FOR r1 IN c1(l_section_item_id) LOOP
1229: IBE_DSP_MSITE_SCT_ITEM_PVT.Delete_MSite_Section_Item
1230: (
1231: p_api_version => p_api_version,