2487:
2488:
2489: l_site_id number;
2490:
2491: TYPE local_rrs_site_asset_rec is RECORD (
2492: item_description mtl_system_items_tl.description%TYPE,
2493: Item mtl_system_items_b.segment1%TYPE,
2494: ItemInstance csi_item_instances.instance_number%TYPE,
2495: SerialNumber csi_item_instances.serial_number%TYPE,
2496: Status csi_instance_statuses.name%TYPE,
2497: Quantity csi_item_instances.quantity%TYPE,
2498: StartDate csi_item_instances.active_start_date%TYPE
2499: );
2500: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;
2501: l_asset_details local_rrs_site_asset_tab;
2502:
2503:
2504:
2540: x_site_asset_tab := rrs_site_asset_tab();
2541: if l_asset_details.count > 0 then
2542: FOR i in l_asset_details.First..l_asset_details.Last LOOP
2543: x_site_asset_tab.Extend();
2544: x_site_asset_tab(i) := rrs_site_asset_rec(
2545: l_asset_details(i).ITEM_DESCRIPTION
2546: ,l_asset_details(i).ITEM
2547: ,l_asset_details(i).ITEMINSTANCE
2548: ,l_asset_details(i).SERIALNUMBER