668: x_resultout out NOCOPY varchar2)is
669:
670: cursor get_attachments(l_shipment_header_id number) is
671: select pk1_value
672: from fnd_attached_documents
673: where entity_name='RCV_LINES'
674: and pk1_value in (select shipment_line_id
675: from rcv_shipment_lines
676: where shipment_header_id=l_shipment_header_id);
711: /*
712: l_progress := 'POS_WCAPPROVE_PVT.get_wc_attributes: 02.';
713: select count(*)
714: into l_attach_count
715: from fnd_attached_documents
716: where entity_name =' RCV_LINES'
717: and pk1_value in (select shipment_line_id
718: from rcv_shipment_lines
719: where shipment_header_id=l_shipment_header_id);