APPS.ECX_UTILS dependencies on ECX_ATTRIBUTE_MAPPINGS

Line 554: source_attribute_id ecx_attribute_mappings.SOURCE_ATTRIBUTE_ID%TYPE

550: occurrence ecx_object_attributes.occurrence%TYPE,
551: cond_value ecx_object_attributes.cond_value%TYPE,
552: cond_node ecx_object_attributes.cond_node%TYPE,
553: cond_node_type ecx_object_attributes.cond_node_type%TYPE,
554: source_attribute_id ecx_attribute_mappings.SOURCE_ATTRIBUTE_ID%TYPE
555: );
556:
557:
558: TYPE object_rec_table is TABLE of object_record index by BINARY_INTEGER;

Line 576: TYPE t_source_attribute_id is TABLE of ecx_attribute_mappings.SOURCE_ATTRIBUTE_ID%TYPE;

572: TYPE t_occurrence is TABLE of ecx_object_attributes.occurrence%TYPE;
573: TYPE t_cond_value is TABLE of ecx_object_attributes.cond_value%TYPE;
574: TYPE t_cond_node is TABLE of ecx_object_attributes.cond_node%TYPE;
575: TYPE t_cond_node_type is TABLE of ecx_object_attributes.cond_node_type%TYPE;
576: TYPE t_source_attribute_id is TABLE of ecx_attribute_mappings.SOURCE_ATTRIBUTE_ID%TYPE;
577: TYPE t_required_flag is TABLE of ecx_object_attributes.required_flag%TYPE;
578:
579: v_attribute_id t_attribute_id;
580: v_attribute_name t_attribute_name;

Line 598: source_attribute_id ecx_attribute_mappings.source_attribute_id%TYPE

594: v_required_flag t_required_flag;
595:
596: TYPE dtd_map is RECORD
597: (
598: source_attribute_id ecx_attribute_mappings.source_attribute_id%TYPE
599: );
600:
601:
602: TYPE dtd_map_table is TABLE of dtd_map index by BINARY_INTEGER;

Line 637: from ecx_attribute_mappings eam

633: cursor dtd_map (
634: p_map_id IN pls_integer,
635: p_attribute_id IN pls_integer ) IS
636: select source_attribute_id
637: from ecx_attribute_mappings eam
638: where eam.target_attribute_id = p_attribute_id
639: and eam.map_id = p_map_id;
640: */
641: l_dtd_id pls_integer;

Line 696: ecx_attribute_mappings m

692: v_cond_node_type,
693: v_source_attribute_id
694:
695: from ecx_object_attributes a,
696: ecx_attribute_mappings m
697: where a.map_id = i_map_id
698: and a.objectlevel_id = i_level_id
699: and m.map_id (+) = i_map_id
700: and m.TARGET_ATTRIBUTE_ID (+) = a.ATTRIBUTE_ID

Line 739: -- from ecx_attribute_mappings eam

735: --end if;
736:
737: -- select source_attribute_id
738: -- bulk collect into dtd_map_tbl
739: -- from ecx_attribute_mappings eam
740: -- where eam.target_attribute_id = obj_rec_table(c1).attribute_id
741: -- and eam.map_id = i_map_id;
742: -- if dtd_map_tbl.COUNT > 1 then
743: -- dbms_output.put_line('dtd_map_tbl.COUNT=' || dtd_map_tbl.COUNT);