459: p_time_category_exists := l_exists;
460:
461: select mapping_component_id
462: into p_component_type_id
463: from hxc_mapping_components
464: where field_name = 'Dummy Element Context';
465:
466:
467: IF g_debug THEN
479: p_time_category_comp_exists OUT nocopy VARCHAR2) IS
480:
481: l_time_category_comp_id hxc_time_category_comps.TIME_CATEGORY_COMP_ID%type;
482: l_time_category_comp_ovn hxc_time_category_comps.OBJECT_VERSION_NUMBER%type;
483: l_component_type_id hxc_mapping_components.MAPPING_COMPONENT_ID%TYPE;
484:
485: l_proc VARCHAR2(100);
486:
487: BEGIN
506: IF l_component_type_id = -1 OR l_component_type_id is null
507: THEN
508: select mapping_component_id
509: into l_component_type_id
510: from hxc_mapping_components
511: where field_name = 'Dummy Element Context';
512: END IF;
513:
514: SELECT 'Y'