APPS.RRS_SITE_INFO dependencies on RRS_SITE_ASSET_TAB

Line 22: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab

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

Line 2412: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab

2408:
2409: Procedure Get_site_assets(
2410: p_site_id_num IN varchar2
2411: ,p_site_name IN varchar2 Default null
2412: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
2413: ) is
2414:
2415:
2416: l_site_id number;

Line 2427: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;

2423: Status csi_instance_statuses.name%TYPE,
2424: Quantity csi_item_instances.quantity%TYPE,
2425: StartDate csi_item_instances.active_start_date%TYPE
2426: );
2427: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;
2428: l_asset_details local_rrs_site_asset_tab;
2429:
2430:
2431:

Line 2428: l_asset_details local_rrs_site_asset_tab;

2424: Quantity csi_item_instances.quantity%TYPE,
2425: StartDate csi_item_instances.active_start_date%TYPE
2426: );
2427: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;
2428: l_asset_details local_rrs_site_asset_tab;
2429:
2430:
2431:
2432: begin

Line 2467: x_site_asset_tab := rrs_site_asset_tab();

2463: ORDER BY ItemDescription;
2464:
2465:
2466:
2467: x_site_asset_tab := rrs_site_asset_tab();
2468: if l_asset_details.count > 0 then
2469: FOR i in l_asset_details.First..l_asset_details.Last LOOP
2470: x_site_asset_tab.Extend();
2471: x_site_asset_tab(i) := rrs_site_asset_rec(