APPS.OE_UPDATE_HEADER_ACK_UTIL SQL Statements

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

Line: 92

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

Line: 96

    SELECT order_source_id
    	 , orig_sys_document_ref
	 , change_sequence
	 , nvl(org_id,				FND_API.G_MISS_NUM)
	 , nvl(header_id,			FND_API.G_MISS_NUM)
	 , nvl(order_number,			FND_API.G_MISS_NUM)
	 , nvl(ordered_date,			FND_API.G_MISS_DATE)
	 , nvl(order_type_id,			FND_API.G_MISS_NUM)
	 , nvl(first_ack_code,			FND_API.G_MISS_CHAR)
	 , nvl(first_ack_date,			FND_API.G_MISS_DATE)
	 , nvl(last_ack_code,			FND_API.G_MISS_CHAR)
	 , nvl(last_ack_date,			FND_API.G_MISS_DATE)
      FROM oe_order_headers
     WHERE order_source_id 			= l_order_source_id
       AND orig_sys_document_ref 		= l_orig_sys_document_ref
;

Line: 174

  l_header_rec.operation 	:= OE_GLOBALS.G_OPR_UPDATE;

Line: 175

  l_line_rec.operation 		:= OE_GLOBALS.G_OPR_UPDATE;

Line: 284

			    oe_debug_pub.add(  'ACKNOWLEDGMENT CODE AND DATE UPDATED FOR REF: '|| L_HEADER_REC_NEW.ORIG_SYS_DOCUMENT_REF ) ;

Line: 308

   End of Update Header Ack
   -----------------------------------------------------------
*/
      IF l_debug_level  > 0 THEN
          oe_debug_pub.add(  'END OF UPDATE HEADER ACK' ) ;

Line: 338

END Update_Header_Ack;