APPS.IBE_DSP_MSITE_SCT_SECT_PVT dependencies on IBE_DSP_SECTIONS_B

Line 556: SELECT section_id INTO l_parent_section_id FROM ibe_dsp_sections_b

552: IF ((p_parent_section_id IS NOT NULL) AND
553: (p_parent_section_id <> FND_API.G_MISS_NUM))
554: THEN
555: BEGIN
556: SELECT section_id INTO l_parent_section_id FROM ibe_dsp_sections_b
557: WHERE section_id = p_parent_section_id;
558: EXCEPTION
559: WHEN NO_DATA_FOUND THEN
560: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');

Line 581: SELECT section_id INTO l_child_section_id FROM ibe_dsp_sections_b

577:
578: -- child section id
579: -- note that child section id cannot be null due to previous checks
580: BEGIN
581: SELECT section_id INTO l_child_section_id FROM ibe_dsp_sections_b
582: WHERE section_id = p_child_section_id;
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');