APPS.RRS_SITE_INFO dependencies on RRS_PROPERTY_TAB

Line 13: ,x_property_tab OUT NOCOPY rrs_property_tab

9: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
10: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
11: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
12: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab
13: ,x_property_tab OUT NOCOPY rrs_property_tab
14: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
15: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
16: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
17: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab

Line 1270: ,x_property_tab OUT NOCOPY rrs_property_tab

1266:
1267: Procedure Get_site_associations(
1268: p_site_id_num IN varchar2
1269: ,p_site_name IN varchar2 Default null
1270: ,x_property_tab OUT NOCOPY rrs_property_tab
1271: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
1272: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
1273: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
1274: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab

Line 1325: TYPE local_rrs_property_tab IS TABLE OF local_rrs_property_rec;

1321: property_name pn_properties_all.property_name%TYPE,
1322: org_code mtl_parameters.organization_code%TYPE,
1323: org_description hr_all_organization_units.name%TYPE
1324: );
1325: TYPE local_rrs_property_tab IS TABLE OF local_rrs_property_rec;
1326: l_property_details local_rrs_property_tab;
1327:
1328:
1329:

Line 1326: l_property_details local_rrs_property_tab;

1322: org_code mtl_parameters.organization_code%TYPE,
1323: org_description hr_all_organization_units.name%TYPE
1324: );
1325: TYPE local_rrs_property_tab IS TABLE OF local_rrs_property_rec;
1326: l_property_details local_rrs_property_tab;
1327:
1328:
1329:
1330: begin

Line 1364: x_property_tab := rrs_property_tab();

1360: where MP.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
1361: and site.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
1362: and site.site_id = l_site_id;
1363:
1364: x_property_tab := rrs_property_tab();
1365: if l_property_details.count > 0 then
1366: For i in l_property_details.First..l_property_details.Last Loop
1367: x_property_tab.Extend();
1368: x_property_tab(i) := rrs_property_rec(l_property_details(i).location_name