APPS.RCV_SHIPMENT_LINES_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 208: from rcv_shipment_headers

204: BEGIN
205:
206: select wf_item_key
207: into l_itemkey
208: from rcv_shipment_headers
209: where shipment_header_id =( select shipment_header_id
210: from rcv_shipment_lines
211: where shipment_line_id= p_shipment_line_id);
212:

Line 332: from rcv_shipment_headers

328: BEGIN
329:
330: select wf_item_key
331: into l_itemkey
332: from rcv_shipment_headers
333: where shipment_header_id =( select shipment_header_id
334: from rcv_shipment_lines
335: where shipment_line_id= p_shipment_line_id);
336:

Line 692: from rcv_shipment_headers

688: BEGIN
689:
690: select wf_item_key
691: into l_itemkey
692: from rcv_shipment_headers
693: where shipment_header_id =( select shipment_header_id
694: from rcv_shipment_lines
695: where shipment_line_id= p_shipment_line_id);
696:

Line 743: from rcv_shipment_headers

739:
740: if (p_level = 'HEADER') then
741: select wf_item_key
742: into l_itemkey
743: from rcv_shipment_headers
744: where shipment_header_id = p_document_id;
745:
746: l_api_name := l_itemkey || ' update_approval_status';
747:

Line 754: update rcv_shipment_headers

750: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
751: 'Enter HEADER update_approval_status');
752: END IF;
753:
754: update rcv_shipment_headers
755: set comments = p_comments,
756: last_update_date = sysdate,
757: last_updated_by = fnd_global.user_id,
758: last_update_login = fnd_global.login_id

Line 767: from rcv_shipment_headers

763: if (p_level = 'LINE') then
764:
765: select wf_item_key
766: into l_itemkey
767: from rcv_shipment_headers
768: where shipment_header_id =( select shipment_header_id
769: from rcv_shipment_lines
770: where shipment_line_id= p_document_id);
771: