29:
30: h_concat_cat varchar2(500);
31: h_concat_loc varchar2(500);
32: h_concat_key varchar2(500);
33: h_cat_segs fa_rx_shared_pkg.Seg_Array;
34: h_loc_segs fa_rx_shared_pkg.Seg_Array;
35: h_key_segs fa_rx_shared_pkg.Seg_Array;
36:
37:
30: h_concat_cat varchar2(500);
31: h_concat_loc varchar2(500);
32: h_concat_key varchar2(500);
33: h_cat_segs fa_rx_shared_pkg.Seg_Array;
34: h_loc_segs fa_rx_shared_pkg.Seg_Array;
35: h_key_segs fa_rx_shared_pkg.Seg_Array;
36:
37:
38: cursor c_assets is
31: h_concat_loc varchar2(500);
32: h_concat_key varchar2(500);
33: h_cat_segs fa_rx_shared_pkg.Seg_Array;
34: h_loc_segs fa_rx_shared_pkg.Seg_Array;
35: h_key_segs fa_rx_shared_pkg.Seg_Array;
36:
37:
38: cursor c_assets is
39: select distinct me.asset_event_id,ad.asset_id,ad.asset_number,ad.description,ad.serial_number,
212:
213: -- h_concat_cat := p_category;
214: if (c_mainrec.asset_category_id is not null) then
215:
216: fa_rx_shared_pkg.concat_category (
217: struct_id => h_cat_structure,
218: ccid => c_mainrec.asset_category_id,
219: concat_string => h_concat_cat,
220: segarray => h_cat_segs);
222:
223: -- h_concat_loc := p_location;
224: if (c_mainrec.location_id is not null) then
225:
226: fa_rx_shared_pkg.concat_location (
227: struct_id => h_loc_structure,
228: ccid => c_mainrec.location_id,
229: concat_string => h_concat_loc,
230: segarray => h_loc_segs);
232:
233: -- h_concat_key := p_asset_key;
234: if (c_mainrec.asset_key_ccid is not null) then
235:
236: fa_rx_shared_pkg.concat_asset_key (
237: struct_id => h_key_structure,
238: ccid => c_mainrec.asset_key_ccid,
239: concat_string => h_concat_key,
240: segarray => h_key_segs);