eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_SITE_INFO dependencies on RRS_RELATIONSHIP_TAB

Line 16: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab

12: ,x_property_tab OUT NOCOPY rrs_property_tab
13: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
14: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
15: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
16: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
17: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_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

Line 1256: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab

1252: ,x_property_tab OUT NOCOPY rrs_property_tab
1253: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
1254: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
1255: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
1256: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
1257: ) is
1258:
1259: TYPE local_rrs_site_cluster_rec is RECORD (
1260: cluster_name rrs_site_groups_tl.name%TYPE

Line 1296: TYPE local_rrs_relationship_tab IS TABLE OF local_rrs_relationship_rec;

1292: object_party_name hz_parties.party_name%Type,
1293: relationship_role hz_relationship_types.role%Type,
1294: relationship_role_meaning fnd_lookup_values.description%Type
1295: );
1296: TYPE local_rrs_relationship_tab IS TABLE OF local_rrs_relationship_rec;
1297: l_relationship_details local_rrs_relationship_tab;
1298:
1299:
1300: TYPE local_rrs_property_rec is RECORD (

Line 1297: l_relationship_details local_rrs_relationship_tab;

1293: relationship_role hz_relationship_types.role%Type,
1294: relationship_role_meaning fnd_lookup_values.description%Type
1295: );
1296: TYPE local_rrs_relationship_tab IS TABLE OF local_rrs_relationship_rec;
1297: l_relationship_details local_rrs_relationship_tab;
1298:
1299:
1300: TYPE local_rrs_property_rec is RECORD (
1301: location_name pn_locations_all.location_code%TYPE,

Line 1487: x_relationship_tab := rrs_relationship_tab();

1483: and (HzPuiRelationshipsEO.status = 'A'
1484: and (HzPuiRelationshipsEO.end_date is null or HzPuiRelationshipsEO.end_date >= trunc(sysdate)) );
1485:
1486:
1487: x_relationship_tab := rrs_relationship_tab();
1488: if l_relationship_details.count > 0 then
1489: FOR i in l_relationship_details.First..l_relationship_details.Last LOOP
1490: x_relationship_tab.Extend();
1491: x_relationship_tab(i) := rrs_relationship_rec( l_relationship_details(i).start_date