APPS.RRS_SITE_INFO dependencies on RRS_SITE_ATTACHMENT_TAB

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

Line 2297: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab

2293:
2294: Procedure Get_site_attachments(
2295: p_site_id_num IN varchar2
2296: ,p_site_name IN varchar2 Default null
2297: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
2298: ) is
2299:
2300: l_site_id number;
2301: i number;

Line 2330: TYPE local_rrs_site_attachment_tab IS TABLE OF local_rrs_site_attachment_rec;

2326: seq_num fnd_attached_documents.seq_num%TYPE,
2327: url fnd_documents.URL%TYPE,
2328: title fnd_documents_tl.title%TYPE
2329: );
2330: TYPE local_rrs_site_attachment_tab IS TABLE OF local_rrs_site_attachment_rec;
2331: l_attachment_details local_rrs_site_attachment_tab;
2332:
2333: begin
2334:

Line 2331: l_attachment_details local_rrs_site_attachment_tab;

2327: url fnd_documents.URL%TYPE,
2328: title fnd_documents_tl.title%TYPE
2329: );
2330: TYPE local_rrs_site_attachment_tab IS TABLE OF local_rrs_site_attachment_rec;
2331: l_attachment_details local_rrs_site_attachment_tab;
2332:
2333: begin
2334:
2335: begin

Line 2403: x_site_attachment_tab := rrs_site_attachment_tab();

2399: AND (d.SECURITY_TYPE=4 OR d.PUBLISH_FLAG='Y')
2400: ORDER BY seq_num;
2401:
2402:
2403: x_site_attachment_tab := rrs_site_attachment_tab();
2404: if l_attachment_details.count > 0 then
2405: FOR i in l_attachment_details.First..l_attachment_details.Last LOOP
2406: x_site_attachment_tab.Extend();
2407: x_site_attachment_tab(i) := rrs_site_attachment_rec(