101:
102: Cursor c_2 is
103: select asset_hierarchy_purpose_id
104: ,name
105: from fa_asset_hierarchy_purpose
106: where book_type_code = v_corp_book
107: and purpose_type = 'INHERITANCE';
108:
109: Cursor c_3 is
107: and purpose_type = 'INHERITANCE';
108:
109: Cursor c_3 is
110: select parent_hierarchy_id
111: from fa_asset_hierarchy
112: where asset_id = x_asset_id
113: and asset_hierarchy_purpose_id = x_asset_purpose_id;
114:
115: Cursor c_4 is
113: and asset_hierarchy_purpose_id = x_asset_purpose_id;
114:
115: Cursor c_4 is
116: select name
117: from fa_asset_hierarchy
118: where asset_hierarchy_id = x_parent_hierarchy_id;
119:
120:
121: Begin
369: end check_distribution_match;
370:
371: Function get_node_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2
372: is
373: v_node_name fa_asset_hierarchy.name%type;
374: cursor c is
375: select name
376: from fa_asset_hierarchy
377: where asset_hierarchy_id = x_id;
372: is
373: v_node_name fa_asset_hierarchy.name%type;
374: cursor c is
375: select name
376: from fa_asset_hierarchy
377: where asset_hierarchy_id = x_id;
378: Begin
379: open c;
380: fetch c into v_node_name;
384: End get_node_name;
385:
386: Function get_node_level (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2
387: is
388: v_node_level fa_asset_hierarchy.level_number%type;
389: cursor c is
390: select level_number
391: from fa_asset_hierarchy
392: where asset_hierarchy_id = x_id;
387: is
388: v_node_level fa_asset_hierarchy.level_number%type;
389: cursor c is
390: select level_number
391: from fa_asset_hierarchy
392: where asset_hierarchy_id = x_id;
393: Begin
394: open c;
395: fetch c into v_node_level;
565:
566: if upper(x_derived_from_entity) like '%NODE%' then
567: select level_number
568: into x_level_number
569: from fa_asset_hierarchy
570: where asset_hierarchy_id = x_derived_from_entity_id;
571: end if;
572:
573: End get_life_derivation_info;