APPS.RCV_SHIPMENT_LINES_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 192: from rcv_shipment_headers

188: BEGIN
189:
190: select wf_item_key
191: into l_itemkey
192: from rcv_shipment_headers
193: where shipment_header_id =( select shipment_header_id
194: from rcv_shipment_lines
195: where shipment_line_id= p_shipment_line_id);
196:

Line 289: from rcv_shipment_headers

285: BEGIN
286:
287: select wf_item_key
288: into l_itemkey
289: from rcv_shipment_headers
290: where shipment_header_id =( select shipment_header_id
291: from rcv_shipment_lines
292: where shipment_line_id= p_shipment_line_id);
293:

Line 522: from rcv_shipment_headers

518: BEGIN
519:
520: select wf_item_key
521: into l_itemkey
522: from rcv_shipment_headers
523: where shipment_header_id =( select shipment_header_id
524: from rcv_shipment_lines
525: where shipment_line_id= p_shipment_line_id);
526:

Line 573: from rcv_shipment_headers

569:
570: if (p_level = 'HEADER') then
571: select wf_item_key
572: into l_itemkey
573: from rcv_shipment_headers
574: where shipment_header_id = p_document_id;
575:
576: l_api_name := l_itemkey || ' update_approval_status';
577:

Line 584: update rcv_shipment_headers

580: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
581: 'Enter HEADER update_approval_status');
582: END IF;
583:
584: update rcv_shipment_headers
585: set comments = p_comments,
586: last_update_date = sysdate,
587: last_updated_by = fnd_global.user_id,
588: last_update_login = fnd_global.login_id

Line 597: from rcv_shipment_headers

593: if (p_level = 'LINE') then
594:
595: select wf_item_key
596: into l_itemkey
597: from rcv_shipment_headers
598: where shipment_header_id =( select shipment_header_id
599: from rcv_shipment_lines
600: where shipment_line_id= p_document_id);
601: