APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on IBE_DSP_CONTEXT_B

Line 607: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context

603: l_source_layout_type VARCHAR2(1);
604:
605: CURSOR c_get_component_mapping_all(c_section_id NUMBER) IS
606: SELECT obj.item_id, obj.context_id, obj.object_type
607: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context
608: WHERE obj.object_id = c_section_id
609: AND obj.object_type = 'S'
610: AND obj.context_id = context.context_id
611: AND context.context_type_code = 'LAYOUT_COMPONENT';

Line 619: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context

615: -- for example, subsection, featured section, product section
616: -- old process template
617: CURSOR c_get_component_mapping(c_section_id NUMBER) IS
618: SELECT obj.item_id, obj.context_id, obj.object_type
619: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context
620: WHERE obj.object_id = c_section_id
621: AND obj.object_type = 'S'
622: AND obj.context_id = context.context_id
623: AND context.context_type_code = 'LAYOUT_COMPONENT'

Line 651: FROM ibe_dsp_context_b context

647: WHERE obj.object_id = p_target_section_id
648: AND obj.object_type = 'S'
649: AND EXISTS (
650: SELECT 1
651: FROM ibe_dsp_context_b context
652: WHERE obj.context_id = context.context_id
653: AND context.context_type_code = 'LAYOUT_COMPONENT')
654: AND NOT EXISTS(
655: SELECT 1

Line 656: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1

652: WHERE obj.context_id = context.context_id
653: AND context.context_type_code = 'LAYOUT_COMPONENT')
654: AND NOT EXISTS(
655: SELECT 1
656: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1
657: WHERE obj1.context_id = obj.context_id
658: AND obj1.context_id = context.context_id
659: AND obj1.object_id = p_source_section_id
660: AND obj1.object_type = 'S'

Line 695: FROM ibe_dsp_context_b context

691: WHERE obj.object_id = p_target_section_id
692: AND obj.object_type = 'S'
693: AND EXISTS (
694: SELECT 1
695: FROM ibe_dsp_context_b context
696: WHERE obj.context_id = context.context_id
697: AND context.context_type_code = 'LAYOUT_COMPONENT')
698: AND NOT EXISTS(
699: SELECT 1

Line 700: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1

696: WHERE obj.context_id = context.context_id
697: AND context.context_type_code = 'LAYOUT_COMPONENT')
698: AND NOT EXISTS(
699: SELECT 1
700: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1
701: WHERE obj1.context_id = obj.context_id
702: AND obj1.context_id = context.context_id
703: AND obj1.object_id = p_source_section_id
704: AND obj1.object_type = 'S'

Line 5903: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context

5899: -- for example, subsection, featured section, product section
5900: -- old process template
5901: CURSOR c_get_component_mapping(c_section_id NUMBER) IS
5902: SELECT obj.item_id, obj.context_id, obj.object_type
5903: FROM ibe_dsp_obj_lgl_ctnt obj, ibe_dsp_context_b context
5904: WHERE obj.object_id = c_section_id
5905: AND obj.object_type = 'S'
5906: AND obj.context_id = context.context_id
5907: AND context.context_type_code = 'LAYOUT_COMPONENT'

Line 5960: FROM ibe_dsp_context_b context

5956: WHERE obj.object_id = p_target_section_id
5957: AND obj.object_type = 'S'
5958: AND EXISTS (
5959: SELECT 1
5960: FROM ibe_dsp_context_b context
5961: WHERE obj.context_id = context.context_id
5962: AND context.context_type_code = 'LAYOUT_COMPONENT')
5963: AND NOT EXISTS(
5964: SELECT 1

Line 5965: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1

5961: WHERE obj.context_id = context.context_id
5962: AND context.context_type_code = 'LAYOUT_COMPONENT')
5963: AND NOT EXISTS(
5964: SELECT 1
5965: FROM ibe_dsp_context_b context, ibe_dsp_obj_lgl_ctnt obj1
5966: WHERE obj1.context_id = obj.context_id
5967: AND obj1.context_id = context.context_id
5968: AND obj1.object_id = p_source_section_id
5969: AND obj1.object_type = 'S'

Line 6364: FROM ibe_dsp_context_b ctx

6360: l_deliverable_id NUMBER;
6361:
6362: CURSOR c_get_center_main_csr IS
6363: SELECT ctx.context_id
6364: FROM ibe_dsp_context_b ctx
6365: WHERE ctx.access_name = 'CENTER'
6366: AND ctx.context_type_code = 'LAYOUT_COMPONENT'
6367: AND ctx.component_type_code = 'SECTION';
6368: