eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_UTILS dependencies on ECX_OBJECT_ATTRIBUTES

Line 540: attribute_id ecx_object_attributes.attribute_id%TYPE,

536: i_method_name varchar2(2000) := 'ecx_utils.load_attributes';
537:
538: /* TYPE object_record is RECORD
539: (
540: attribute_id ecx_object_attributes.attribute_id%TYPE,
541: attribute_name ecx_object_attributes.attribute_name%TYPE,
542: parent_attribute_id ecx_object_attributes.parent_attribute_id%TYPE,
543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,
544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,

Line 541: attribute_name ecx_object_attributes.attribute_name%TYPE,

537:
538: /* TYPE object_record is RECORD
539: (
540: attribute_id ecx_object_attributes.attribute_id%TYPE,
541: attribute_name ecx_object_attributes.attribute_name%TYPE,
542: parent_attribute_id ecx_object_attributes.parent_attribute_id%TYPE,
543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,
544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,
545: attribute_type ecx_object_attributes.attribute_type%TYPE,

Line 542: parent_attribute_id ecx_object_attributes.parent_attribute_id%TYPE,

538: /* TYPE object_record is RECORD
539: (
540: attribute_id ecx_object_attributes.attribute_id%TYPE,
541: attribute_name ecx_object_attributes.attribute_name%TYPE,
542: parent_attribute_id ecx_object_attributes.parent_attribute_id%TYPE,
543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,
544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,
545: attribute_type ecx_object_attributes.attribute_type%TYPE,
546: default_value ecx_object_attributes.default_value%TYPE,

Line 543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,

539: (
540: attribute_id ecx_object_attributes.attribute_id%TYPE,
541: attribute_name ecx_object_attributes.attribute_name%TYPE,
542: parent_attribute_id ecx_object_attributes.parent_attribute_id%TYPE,
543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,
544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,
545: attribute_type ecx_object_attributes.attribute_type%TYPE,
546: default_value ecx_object_attributes.default_value%TYPE,
547: data_type ecx_object_attributes.data_type%TYPE,

Line 544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,

540: attribute_id ecx_object_attributes.attribute_id%TYPE,
541: attribute_name ecx_object_attributes.attribute_name%TYPE,
542: parent_attribute_id ecx_object_attributes.parent_attribute_id%TYPE,
543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,
544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,
545: attribute_type ecx_object_attributes.attribute_type%TYPE,
546: default_value ecx_object_attributes.default_value%TYPE,
547: data_type ecx_object_attributes.data_type%TYPE,
548: has_attributes ecx_object_attributes.has_attributes%TYPE,

Line 545: attribute_type ecx_object_attributes.attribute_type%TYPE,

541: attribute_name ecx_object_attributes.attribute_name%TYPE,
542: parent_attribute_id ecx_object_attributes.parent_attribute_id%TYPE,
543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,
544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,
545: attribute_type ecx_object_attributes.attribute_type%TYPE,
546: default_value ecx_object_attributes.default_value%TYPE,
547: data_type ecx_object_attributes.data_type%TYPE,
548: has_attributes ecx_object_attributes.has_attributes%TYPE,
549: leaf_node ecx_object_attributes.leaf_node%TYPE,

Line 546: default_value ecx_object_attributes.default_value%TYPE,

542: parent_attribute_id ecx_object_attributes.parent_attribute_id%TYPE,
543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,
544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,
545: attribute_type ecx_object_attributes.attribute_type%TYPE,
546: default_value ecx_object_attributes.default_value%TYPE,
547: data_type ecx_object_attributes.data_type%TYPE,
548: has_attributes ecx_object_attributes.has_attributes%TYPE,
549: leaf_node ecx_object_attributes.leaf_node%TYPE,
550: occurrence ecx_object_attributes.occurrence%TYPE,

Line 547: data_type ecx_object_attributes.data_type%TYPE,

543: base_column_name varchar2(500),--ecx_object_attributes.object_column_flag%TYPE,
544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,
545: attribute_type ecx_object_attributes.attribute_type%TYPE,
546: default_value ecx_object_attributes.default_value%TYPE,
547: data_type ecx_object_attributes.data_type%TYPE,
548: has_attributes ecx_object_attributes.has_attributes%TYPE,
549: leaf_node ecx_object_attributes.leaf_node%TYPE,
550: occurrence ecx_object_attributes.occurrence%TYPE,
551: cond_value ecx_object_attributes.cond_value%TYPE,

Line 548: has_attributes ecx_object_attributes.has_attributes%TYPE,

544: xref_category_id ecx_object_attributes.xref_category_id%TYPE,
545: attribute_type ecx_object_attributes.attribute_type%TYPE,
546: default_value ecx_object_attributes.default_value%TYPE,
547: data_type ecx_object_attributes.data_type%TYPE,
548: has_attributes ecx_object_attributes.has_attributes%TYPE,
549: leaf_node ecx_object_attributes.leaf_node%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,

Line 549: leaf_node ecx_object_attributes.leaf_node%TYPE,

545: attribute_type ecx_object_attributes.attribute_type%TYPE,
546: default_value ecx_object_attributes.default_value%TYPE,
547: data_type ecx_object_attributes.data_type%TYPE,
548: has_attributes ecx_object_attributes.has_attributes%TYPE,
549: leaf_node ecx_object_attributes.leaf_node%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,

Line 550: occurrence ecx_object_attributes.occurrence%TYPE,

546: default_value ecx_object_attributes.default_value%TYPE,
547: data_type ecx_object_attributes.data_type%TYPE,
548: has_attributes ecx_object_attributes.has_attributes%TYPE,
549: leaf_node ecx_object_attributes.leaf_node%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

Line 551: cond_value ecx_object_attributes.cond_value%TYPE,

547: data_type ecx_object_attributes.data_type%TYPE,
548: has_attributes ecx_object_attributes.has_attributes%TYPE,
549: leaf_node ecx_object_attributes.leaf_node%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: );

Line 552: cond_node ecx_object_attributes.cond_node%TYPE,

548: has_attributes ecx_object_attributes.has_attributes%TYPE,
549: leaf_node ecx_object_attributes.leaf_node%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:

Line 553: cond_node_type ecx_object_attributes.cond_node_type%TYPE,

549: leaf_node ecx_object_attributes.leaf_node%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:

Line 562: TYPE t_attribute_id is TABLE of ecx_object_attributes.attribute_id%TYPE;

558: TYPE object_rec_table is TABLE of object_record index by BINARY_INTEGER;
559: obj_rec_table object_rec_table;
560: */
561:
562: TYPE t_attribute_id is TABLE of ecx_object_attributes.attribute_id%TYPE;
563: TYPE t_attribute_name is TABLE of ecx_object_attributes.attribute_name%TYPE;
564: TYPE t_parent_attribute_id is TABLE of ecx_object_attributes.parent_attribute_id%TYPE;
565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,
566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;

Line 563: TYPE t_attribute_name is TABLE of ecx_object_attributes.attribute_name%TYPE;

559: obj_rec_table object_rec_table;
560: */
561:
562: TYPE t_attribute_id is TABLE of ecx_object_attributes.attribute_id%TYPE;
563: TYPE t_attribute_name is TABLE of ecx_object_attributes.attribute_name%TYPE;
564: TYPE t_parent_attribute_id is TABLE of ecx_object_attributes.parent_attribute_id%TYPE;
565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,
566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;
567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;

Line 564: TYPE t_parent_attribute_id is TABLE of ecx_object_attributes.parent_attribute_id%TYPE;

560: */
561:
562: TYPE t_attribute_id is TABLE of ecx_object_attributes.attribute_id%TYPE;
563: TYPE t_attribute_name is TABLE of ecx_object_attributes.attribute_name%TYPE;
564: TYPE t_parent_attribute_id is TABLE of ecx_object_attributes.parent_attribute_id%TYPE;
565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,
566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;
567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;
568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;

Line 565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,

561:
562: TYPE t_attribute_id is TABLE of ecx_object_attributes.attribute_id%TYPE;
563: TYPE t_attribute_name is TABLE of ecx_object_attributes.attribute_name%TYPE;
564: TYPE t_parent_attribute_id is TABLE of ecx_object_attributes.parent_attribute_id%TYPE;
565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,
566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;
567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;
568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;
569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;

Line 566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;

562: TYPE t_attribute_id is TABLE of ecx_object_attributes.attribute_id%TYPE;
563: TYPE t_attribute_name is TABLE of ecx_object_attributes.attribute_name%TYPE;
564: TYPE t_parent_attribute_id is TABLE of ecx_object_attributes.parent_attribute_id%TYPE;
565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,
566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;
567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;
568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;
569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;
570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;

Line 567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;

563: TYPE t_attribute_name is TABLE of ecx_object_attributes.attribute_name%TYPE;
564: TYPE t_parent_attribute_id is TABLE of ecx_object_attributes.parent_attribute_id%TYPE;
565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,
566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;
567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;
568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;
569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;
570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;
571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%TYPE;

Line 568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;

564: TYPE t_parent_attribute_id is TABLE of ecx_object_attributes.parent_attribute_id%TYPE;
565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,
566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;
567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;
568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;
569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;
570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;
571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%TYPE;
572: TYPE t_occurrence is TABLE of ecx_object_attributes.occurrence%TYPE;

Line 569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;

565: TYPE t_base_column_name is TABLE of varchar2(500);--ecx_object_attributes.object_column_flag%TYPE,
566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;
567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;
568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;
569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;
570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;
571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%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;

Line 570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;

566: TYPE t_xref_category_id is TABLE of ecx_object_attributes.xref_category_id%TYPE;
567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;
568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;
569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;
570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;
571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%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;

Line 571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%TYPE;

567: TYPE t_attribute_type is TABLE of ecx_object_attributes.attribute_type%TYPE;
568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;
569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;
570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;
571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%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;

Line 572: TYPE t_occurrence is TABLE of ecx_object_attributes.occurrence%TYPE;

568: TYPE t_default_value is TABLE of ecx_object_attributes.default_value%TYPE;
569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;
570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;
571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%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;

Line 573: TYPE t_cond_value is TABLE of ecx_object_attributes.cond_value%TYPE;

569: TYPE t_data_type is TABLE of ecx_object_attributes.data_type%TYPE;
570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;
571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%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;

Line 574: TYPE t_cond_node is TABLE of ecx_object_attributes.cond_node%TYPE;

570: TYPE t_has_attributes is TABLE of ecx_object_attributes.has_attributes%TYPE;
571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%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:

Line 575: TYPE t_cond_node_type is TABLE of ecx_object_attributes.cond_node_type%TYPE;

571: TYPE t_leaf_node is TABLE of ecx_object_attributes.leaf_node%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;

Line 577: TYPE t_required_flag is TABLE of ecx_object_attributes.required_flag%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;
581: v_parent_attribute_id t_parent_attribute_id;

Line 628: from ecx_object_attributes eoa

624: occurrence,
625: cond_value,
626: cond_node,
627: cond_node_type
628: from ecx_object_attributes eoa
629: where eoa.map_id = p_map_id
630: and eoa.objectlevel_id = p_level_id
631: order by attribute_id;
632:

Line 695: from ecx_object_attributes a,

691: v_cond_node,
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

Line 3063: l_attribute_name ecx_object_attributes.attribute_name%type;

3059: (v_map_id IN NUMBER,
3060: v_attribute_id IN NUMBER) return varchar2
3061: IS
3062: i_method_name varchar2(2000) := 'ecx_utils.getNodePath';
3063: l_attribute_name ecx_object_attributes.attribute_name%type;
3064: l_attribute_id ecx_object_attributes.attribute_id%type;
3065: l_node_path varchar2(32767);
3066: l_parent_name ecx_object_attributes.attribute_name%type;
3067: l_parent_id ecx_object_attributes.attribute_id%type;

Line 3064: l_attribute_id ecx_object_attributes.attribute_id%type;

3060: v_attribute_id IN NUMBER) return varchar2
3061: IS
3062: i_method_name varchar2(2000) := 'ecx_utils.getNodePath';
3063: l_attribute_name ecx_object_attributes.attribute_name%type;
3064: l_attribute_id ecx_object_attributes.attribute_id%type;
3065: l_node_path varchar2(32767);
3066: l_parent_name ecx_object_attributes.attribute_name%type;
3067: l_parent_id ecx_object_attributes.attribute_id%type;
3068: l_root_node ecx_object_attributes.attribute_name%type;

Line 3066: l_parent_name ecx_object_attributes.attribute_name%type;

3062: i_method_name varchar2(2000) := 'ecx_utils.getNodePath';
3063: l_attribute_name ecx_object_attributes.attribute_name%type;
3064: l_attribute_id ecx_object_attributes.attribute_id%type;
3065: l_node_path varchar2(32767);
3066: l_parent_name ecx_object_attributes.attribute_name%type;
3067: l_parent_id ecx_object_attributes.attribute_id%type;
3068: l_root_node ecx_object_attributes.attribute_name%type;
3069:
3070: begin

Line 3067: l_parent_id ecx_object_attributes.attribute_id%type;

3063: l_attribute_name ecx_object_attributes.attribute_name%type;
3064: l_attribute_id ecx_object_attributes.attribute_id%type;
3065: l_node_path varchar2(32767);
3066: l_parent_name ecx_object_attributes.attribute_name%type;
3067: l_parent_id ecx_object_attributes.attribute_id%type;
3068: l_root_node ecx_object_attributes.attribute_name%type;
3069:
3070: begin
3071: if (l_procedureEnabled) then

Line 3068: l_root_node ecx_object_attributes.attribute_name%type;

3064: l_attribute_id ecx_object_attributes.attribute_id%type;
3065: l_node_path varchar2(32767);
3066: l_parent_name ecx_object_attributes.attribute_name%type;
3067: l_parent_id ecx_object_attributes.attribute_id%type;
3068: l_root_node ecx_object_attributes.attribute_name%type;
3069:
3070: begin
3071: if (l_procedureEnabled) then
3072: ecx_debug.push(i_method_name);

Line 3084: FROM ecx_object_attributes

3080: END IF;
3081:
3082: SELECT attribute_name,attribute_id,parent_attribute_id
3083: INTO l_attribute_name,l_attribute_id,l_parent_id
3084: FROM ecx_object_attributes
3085: WHERE map_id = v_map_id and objectlevel_id in(
3086: select objectlevel_id from ecx_object_levels
3087: WHERE map_id=v_map_id and object_id = 1) AND attribute_id=v_attribute_id;
3088:

Line 3095: FROM ecx_object_attributes

3091: Loop
3092: EXIT WHEN l_parent_id=0;
3093: SELECT attribute_name,attribute_id,parent_attribute_id
3094: INTO l_attribute_name,l_attribute_id,l_parent_id
3095: FROM ecx_object_attributes
3096: WHERE map_id = v_map_id and objectlevel_id in(
3097: select objectlevel_id from ecx_object_levels
3098: WHERE map_id=v_map_id and object_id = 1) AND attribute_id=l_parent_id;
3099: