APPS.RRS_SITE_INFO dependencies on RRS_SITE_PERSON_TAB

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

Line 1561: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab

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

Line 1687: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;

1683: subject_type_meaning fnd_lookup_values.meaning%Type,
1684: object_type_meaning fnd_lookup_values.meaning%Type,
1685: relationship_role_meaning fnd_lookup_values.description%Type
1686: );
1687: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;
1688: l_person_details local_rrs_site_person_tab;
1689:
1690:
1691: begin

Line 1688: l_person_details local_rrs_site_person_tab;

1684: object_type_meaning fnd_lookup_values.meaning%Type,
1685: relationship_role_meaning fnd_lookup_values.description%Type
1686: );
1687: TYPE local_rrs_site_person_tab IS TABLE OF local_rrs_site_person_rec;
1688: l_person_details local_rrs_site_person_tab;
1689:
1690:
1691: begin
1692:

Line 2037: x_site_person_tab := rrs_site_person_tab();

2033: and (HzPuiRelationshipsEO.status = 'A'
2034: and (end_date is null or end_date >= trunc(sysdate)) ));
2035:
2036:
2037: x_site_person_tab := rrs_site_person_tab();
2038: if l_person_details.count > 0 then
2039: FOR i in l_person_details.First..l_person_details.Last LOOP
2040: x_site_person_tab.Extend();
2041: