APPS.RRS_SITE_INFO dependencies on RRS_SITE_ATTACHMENT_TAB

Line 21: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_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
25: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 2224: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab

2220:
2221: Procedure Get_site_attachments(
2222: p_site_id_num IN varchar2
2223: ,p_site_name IN varchar2 Default null
2224: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
2225: ) is
2226:
2227: l_site_id number;
2228: i number;

Line 2257: TYPE local_rrs_site_attachment_tab IS TABLE OF local_rrs_site_attachment_rec;

2253: seq_num fnd_attached_documents.seq_num%TYPE,
2254: url fnd_documents.URL%TYPE,
2255: title fnd_documents_tl.title%TYPE
2256: );
2257: TYPE local_rrs_site_attachment_tab IS TABLE OF local_rrs_site_attachment_rec;
2258: l_attachment_details local_rrs_site_attachment_tab;
2259:
2260: begin
2261:

Line 2258: l_attachment_details local_rrs_site_attachment_tab;

2254: url fnd_documents.URL%TYPE,
2255: title fnd_documents_tl.title%TYPE
2256: );
2257: TYPE local_rrs_site_attachment_tab IS TABLE OF local_rrs_site_attachment_rec;
2258: l_attachment_details local_rrs_site_attachment_tab;
2259:
2260: begin
2261:
2262: begin

Line 2330: x_site_attachment_tab := rrs_site_attachment_tab();

2326: AND (d.SECURITY_TYPE=4 OR d.PUBLISH_FLAG='Y')
2327: ORDER BY seq_num;
2328:
2329:
2330: x_site_attachment_tab := rrs_site_attachment_tab();
2331: if l_attachment_details.count > 0 then
2332: FOR i in l_attachment_details.First..l_attachment_details.Last LOOP
2333: x_site_attachment_tab.Extend();
2334: x_site_attachment_tab(i) := rrs_site_attachment_rec(