APPS.PO_ACKNOWLEDGE_PO_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 184

 * Effects: Insert shipment level acknowledgement result into PO_ACCEPTANCES
 *          table.  It also checks if all shipments are acknowledged after
 *          inserting the record, if yes then post the header level acknowledge
 *          result.
 * Returns:
 *   x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
 *                     FND_API.G_RET_STS_ERROR if an error occurs
 *                     FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
 */

PROCEDURE Acknowledge_Shipment (
    	p_api_version          	IN  	NUMBER,
    	p_Init_Msg_List		IN  	VARCHAR2,
    	x_return_status		OUT 	NOCOPY VARCHAR2,
	p_line_location_id	IN	NUMBER,
	p_po_header_id		IN	NUMBER,
	p_po_release_id		IN	NUMBER,
	p_revision_num		IN	NUMBER,
	p_accepted_flag		IN	VARCHAR2,
	p_comment		IN	VARCHAR2 default null,
	p_buyer_id		IN	NUMBER,
	p_user_id		IN	NUMBER )
IS

  l_api_name		CONSTANT VARCHAR2(30) := 'ACKNOWLEDGE_SHIPMENT';