APPS.OE_UPDATE_LINE_ACK_UTIL SQL Statements

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

Line: 95

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

Line: 103

    SELECT order_source_id
    	 , orig_sys_document_ref
    	 , change_sequence
    	 , orig_sys_line_ref
	 , orig_sys_shipment_ref
	 , nvl(org_id,				FND_API.G_MISS_NUM)
	 , nvl(line_number,			FND_API.G_MISS_NUM)
	 , nvl(shipment_number,			FND_API.G_MISS_NUM)
	 , nvl(line_id,				FND_API.G_MISS_NUM)
	 , nvl(line_type_id,			FND_API.G_MISS_NUM)
	 , nvl(item_type_code,			FND_API.G_MISS_CHAR)
	 , nvl(inventory_item_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_lines
     WHERE order_source_id			= l_order_source_id
       AND orig_sys_document_ref 		= l_orig_sys_document_ref
       AND change_sequence 			= l_change_sequence
       AND orig_sys_line_ref 			= l_orig_sys_line_ref
       AND orig_sys_shipment_ref 		= l_orig_sys_shipment_ref
  ORDER BY orig_sys_line_ref, orig_sys_shipment_ref
;

Line: 189

  l_header_rec.operation 	:= OE_GLOBALS.G_OPR_UPDATE;

Line: 190

  l_line_rec.operation 		:= OE_GLOBALS.G_OPR_UPDATE;

Line: 310

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

Line: 335

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

Line: 365

END Update_Line_Ack;