APPS.RRS_SITE_INFO dependencies on RRS_SITE_ASSET_TAB

Line 23: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab

19: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
20: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
21: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
22: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
23: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
24: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
25: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
26: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
27: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 2485: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab

2481:
2482: Procedure Get_site_assets(
2483: p_site_id_num IN varchar2
2484: ,p_site_name IN varchar2 Default null
2485: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
2486: ) is
2487:
2488:
2489: l_site_id number;

Line 2500: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;

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:

Line 2501: l_asset_details local_rrs_site_asset_tab;

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:
2505: begin

Line 2540: x_site_asset_tab := rrs_site_asset_tab();

2536: ORDER BY ItemDescription;
2537:
2538:
2539:
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(