APPS.RRS_SITE_INFO dependencies on RRS_SITE_URL_TAB

Line 19: ,x_site_url_tab OUT NOCOPY rrs_site_url_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
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

Line 1560: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab

1556: ,p_site_name IN varchar2 Default null
1557: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
1558: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
1559: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
1560: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
1561: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
1562: ) is
1563:
1564: l_site_id number;

Line 1657: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;

1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1655: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1656: );
1657: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;
1658: l_url_details local_rrs_site_url_tab;
1659:
1660:
1661: TYPE local_rrs_site_person_rec is RECORD (

Line 1658: l_url_details local_rrs_site_url_tab;

1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1655: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1656: );
1657: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;
1658: l_url_details local_rrs_site_url_tab;
1659:
1660:
1661: TYPE local_rrs_site_person_rec is RECORD (
1662: relationship_id hz_relationships.relationship_id%Type,

Line 1947: x_site_url_tab := rrs_site_url_tab();

1943: AND HzPuiContactPointUrlEO.OWNER_TABLE_ID = l_site_party_id)
1944: ORDER BY HzPuiContactPointUrlEO.PRIMARY_FLAG DESC, USAGE NULLS LAST, HzPuiContactPointUrlEO.PRIMARY_BY_PURPOSE DESC;
1945:
1946:
1947: x_site_url_tab := rrs_site_url_tab();
1948: if l_url_details.count > 0 then
1949: FOR i in l_url_details.First..l_url_details.Last LOOP
1950: x_site_url_tab.Extend();
1951: x_site_url_tab(i) := rrs_site_url_rec(