APPS.RRS_SITE_INFO dependencies on RRS_RELATIONSHIP_TAB

Line 17: ,x_relationship_tab OUT NOCOPY rrs_relationship_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
18: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_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

Line 1274: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab

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
1275: ) is
1276:
1277: TYPE local_rrs_site_cluster_rec is RECORD (
1278: cluster_name rrs_site_groups_tl.name%TYPE

Line 1315: TYPE local_rrs_relationship_tab IS TABLE OF local_rrs_relationship_rec;

1311: object_party_name hz_parties.party_name%Type,
1312: relationship_role hz_relationship_types.role%Type,
1313: relationship_role_meaning fnd_lookup_values.description%Type
1314: );
1315: TYPE local_rrs_relationship_tab IS TABLE OF local_rrs_relationship_rec;
1316: l_relationship_details local_rrs_relationship_tab;
1317:
1318:
1319: TYPE local_rrs_property_rec is RECORD (

Line 1316: l_relationship_details local_rrs_relationship_tab;

1312: relationship_role hz_relationship_types.role%Type,
1313: relationship_role_meaning fnd_lookup_values.description%Type
1314: );
1315: TYPE local_rrs_relationship_tab IS TABLE OF local_rrs_relationship_rec;
1316: l_relationship_details local_rrs_relationship_tab;
1317:
1318:
1319: TYPE local_rrs_property_rec is RECORD (
1320: location_name pn_locations_all.location_code%TYPE,

Line 1554: x_relationship_tab := rrs_relationship_tab();

1550: and (HzPuiRelationshipsEO.status = 'A'
1551: and (HzPuiRelationshipsEO.end_date is null or HzPuiRelationshipsEO.end_date >= trunc(sysdate)) );
1552:
1553:
1554: x_relationship_tab := rrs_relationship_tab();
1555: if l_relationship_details.count > 0 then
1556: FOR i in l_relationship_details.First..l_relationship_details.Last LOOP
1557: x_relationship_tab.Extend();
1558: x_relationship_tab(i) := rrs_relationship_rec( l_relationship_details(i).start_date