APPS.RRS_SITE_INFO dependencies on RRS_SITE_URL_TAB

Line 20: ,x_site_url_tab OUT NOCOPY rrs_site_url_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
22: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
23: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
24: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 1627: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab

1623: ,p_site_name IN varchar2 Default null
1624: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab
1625: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
1626: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
1627: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
1628: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
1629: ) is
1630:
1631: l_site_id number;

Line 1725: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;

1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1723: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1724: );
1725: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;
1726: l_url_details local_rrs_site_url_tab;
1727:
1728:
1729: TYPE local_rrs_site_person_rec is RECORD (

Line 1726: l_url_details local_rrs_site_url_tab;

1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1723: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1724: );
1725: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;
1726: l_url_details local_rrs_site_url_tab;
1727:
1728:
1729: TYPE local_rrs_site_person_rec is RECORD (
1730: relationship_id hz_relationships.relationship_id%Type,

Line 2023: x_site_url_tab := rrs_site_url_tab();

2019: and (HzPuiContactPointUrlEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
2020: AND HzPuiContactPointUrlEO.OWNER_TABLE_ID = l_site_party_id)
2021: ORDER BY HzPuiContactPointUrlEO.PRIMARY_FLAG DESC, USAGE NULLS LAST, HzPuiContactPointUrlEO.PRIMARY_BY_PURPOSE DESC;
2022:
2023: x_site_url_tab := rrs_site_url_tab();
2024: if l_url_details.count > 0 then
2025: FOR i in l_url_details.First..l_url_details.Last LOOP
2026: x_site_url_tab.Extend();
2027: x_site_url_tab(i) := rrs_site_url_rec(