APPS.RRS_SITE_INFO dependencies on RRS_SITE_PERSON_TAB

Line 21: ,x_site_person_tab OUT NOCOPY rrs_site_person_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
25: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 1628: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab

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;
1632: l_site_party_id number;

Line 1755: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;

1751: subject_type_meaning fnd_lookup_values.meaning%Type,
1752: object_type_meaning fnd_lookup_values.meaning%Type,
1753: relationship_role_meaning fnd_lookup_values.description%Type
1754: );
1755: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;
1756: l_person_details local_rrs_site_person_tab;
1757:
1758:
1759: begin

Line 1756: l_person_details local_rrs_site_person_tab;

1752: object_type_meaning fnd_lookup_values.meaning%Type,
1753: relationship_role_meaning fnd_lookup_values.description%Type
1754: );
1755: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;
1756: l_person_details local_rrs_site_person_tab;
1757:
1758:
1759: begin
1760:

Line 2111: x_site_person_tab := rrs_site_person_tab();

2107: and HzPuiRelationshipsEO.subject_type = 'PERSON'
2108: and (HzPuiRelationshipsEO.status = 'A'
2109: and (end_date is null or end_date >= trunc(sysdate)) ));
2110:
2111: x_site_person_tab := rrs_site_person_tab();
2112: if l_person_details.count > 0 then
2113: FOR i in l_person_details.First..l_person_details.Last LOOP
2114: x_site_person_tab.Extend();
2115: