APPS.JTF_DSP_MSITE_SCT_SECT_PVT dependencies on JTF_DSP_SECTIONS_B

Line 528: SELECT section_id INTO l_parent_section_id FROM jtf_dsp_sections_b

524: IF ((p_parent_section_id IS NOT NULL) AND
525: (p_parent_section_id <> FND_API.G_MISS_NUM))
526: THEN
527: BEGIN
528: SELECT section_id INTO l_parent_section_id FROM jtf_dsp_sections_b
529: WHERE section_id = p_parent_section_id;
530: EXCEPTION
531: WHEN NO_DATA_FOUND THEN
532: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');

Line 547: SELECT section_id INTO l_child_section_id FROM jtf_dsp_sections_b

543:
544: -- child section id
545: -- note that child section id cannot be null due to previous checks
546: BEGIN
547: SELECT section_id INTO l_child_section_id FROM jtf_dsp_sections_b
548: WHERE section_id = p_child_section_id;
549: EXCEPTION
550: WHEN NO_DATA_FOUND THEN
551: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');